Latest Contributions by AndrewQuee

+1 for this.  It would be incredibly useful for data management to know what size database objects were and when they were last edited.  Imagine using File Explorer with no modified date or size information! ... View more

@AndrewKniowski1 this was a great tool at release and worked great for a long time.  However things have changed and under 2.9.x  the installation is quite different.  When I finally got R, the bridge and the custom toolboxes installed, I now get this error while running the 'Create state tree diagram' tool: Create state tree diagram ===================== Parameters Database connection file: redacted.sde Create pdf true Create features true View in window true tree_vertices tree_edges ===================== Messages Start Time: Tuesday, 20 September 2022 3:50:49 PM Executing (GetStateData): GetStateData redacted.sde Start Time: Tuesday, 20 September 2022 3:50:49 PM Saving temporary files to C:\Users\aquee\AppData\Local\Temp\ArcGISProTemp16744\StateDiagram_g9fdkh90 Succeeded at Tuesday, 20 September 2022 3:50:53 PM (Elapsed Time: 3.98 seconds) Executing (CreateStateDiagram): CreateStateDiagram C:\Users\aquee\AppData\Local\Temp\ArcGISProTemp16744\StateDiagram_g9fdkh90 true true true Start Time: Tuesday, 20 September 2022 3:50:53 PM URL 'http://cran.cnr.Berkeley.edu/src/contrib/PACKAGES.rds': status was 'Couldn't connect to server'URL 'http://cran.cnr.Berkeley.edu/src/contrib/PACKAGES.gz': status was 'Couldn't connect to server'URL 'http://cran.cnr.Berkeley.edu/src/contrib/PACKAGES': status was 'Couldn't connect to server'unable to access index for repository http://cran.cnr.Berkeley.edu/src/contrib: cannot open URL 'http://cran.cnr.Berkeley.edu/src/contrib/PACKAGES'package 'igraph' is not available for this version of R A version of this package for your version of R might be available elsewhere, see the ideas at https://cran.r-project.org/doc/manuals/r-patched/R-admin.html#Installing-packagesURL 'http://cran.cnr.Berkeley.edu/bin/windows/contrib/4.2/PACKAGES.rds': status was 'Couldn't connect to server'URL 'http://cran.cnr.Berkeley.edu/bin/windows/contrib/4.2/PACKAGES.gz': status was 'Couldn't connect to server'URL 'http://cran.cnr.Berkeley.edu/bin/windows/contrib/4.2/PACKAGES': status was 'Couldn't connect to server'unable to access index for repository http://cran.cnr.Berkeley.edu/bin/windows/contrib/4.2: cannot open URL 'http://cran.cnr.Berkeley.edu/bin/windows/contrib/4.2/PACKAGES'URL 'http://cran.cnr.Berkeley.edu/src/contrib/PACKAGES.rds': status was 'Couldn't connect to server'URL 'http://cran.cnr.Berkeley.edu/src/contrib/PACKAGES.gz': status was 'Couldn't connect to server'URL 'http://cran.cnr.Berkeley.edu/src/contrib/PACKAGES': status was 'Couldn't connect to server'unable to access index for repository http://cran.cnr.Berkeley.edu/src/contrib: cannot open URL 'http://cran.cnr.Berkeley.edu/src/contrib/PACKAGES'package 'sp' is not available for this version of R A version of this package for your version of R might be available elsewhere, see the ideas at https://cran.r-project.org/doc/manuals/r-patched/R-admin.html#Installing-packagesURL 'http://cran.cnr.Berkeley.edu/bin/windows/contrib/4.2/PACKAGES.rds': status was 'Couldn't connect to server'URL 'http://cran.cnr.Berkeley.edu/bin/windows/contrib/4.2/PACKAGES.gz': status was 'Couldn't connect to server'URL 'http://cran.cnr.Berkeley.edu/bin/windows/contrib/4.2/PACKAGES': status was 'Couldn't connect to server'unable to access index for repository http://cran.cnr.Berkeley.edu/bin/windows/contrib/4.2: cannot open URL 'http://cran.cnr.Berkeley.edu/bin/windows/contrib/4.2/PACKAGES' Number of states 652 Number of versions 16 Error in do.call : could not find function "graph_from_data_frame" Failed to execute (CreateStateDiagram). Failed at Tuesday, 20 September 2022 3:51:27 PM (Elapsed Time: 34.09 seconds) Failed to execute (Model). Failed at Tuesday, 20 September 2022 3:51:27 PM (Elapsed Time: 38.09 seconds) The tools for R and the R-Bridge work correctly and report their status/version okay.  Pro notes R configured ok in options. At first I thought this was some kind of proxy error, it looks like it is either trying to use/sync a graphing function from Berkeley.edu Looking further, visiting http://cran.cnr.berkeley.edu/bin gives: CRAN mirror restricted to UC Berkeley The CRAN mirror at UC Berkeley's College of Natural Resources is no longer available to off campus users and has been removed from the CRAN mirror list. The load on our server was too much. Berkeley folks can continue to access the mirror from on-campus networks or from within the VPN. The rest of the R community: Sorry, but you'll have to please choose a different CRAN mirror. Looks like we slashdotted it. 😞   How do we either change the tool to point at another CRAN mirror, or even better download the resources into the tool source so it is not reliant on an external site when run? Congratulations on making a fantastic tool, and helping keep this alive. 🙂   ... View more

I might be misinterpreting what you're saying but my understanding is that attribute rules are indeed baked into the geodatabase: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/an-overview-of-attribute-rules.htm#ESRI_SECTION1_A33473E5BD1C4CC696B161940BCAEE64 "Attribute rules are created on an input feature class or table." "...attribute rules are established on datasets in the geodatabase..." "Once attribute rules are added to a dataset, it is incompatible with ArcMap or ArcGIS Pro 2.0 and earlier." So, only compliant clients can even edit the rules-based geodatabase objects, and if they do they are required to follow those rules regardless of how they did it (GP tool, python, arcade, scripting/model, version edit, etc).  This is pretty much exactly what the community asked for, and is a relatively simple and elegant solution.  (Needs improvements of course, but that is happening) Can you edit the underlying database by using native tools bypassing the Esri stack or build your own triggers/database scripting for custom functionality?  Sure... but do you really want to go back to the good-bad old days of ArcView 8/ArcInfo? I believe when this has been mooted in the past Esri didn't want to get in to modifying/supporting changes to propriety RDBMS' and they have no no way of knowing which one you use; a massive cost on their business to essentially change multiple companies products.  The answer was...  Attribute Rules on the Geodatabase extensible through web services. As long as you're in the Esri ecosphere I don't understand the problem, unless you're dealing with non-Esri clients who are directly editing the database, or you're importing data directly without going through an edit/rules/reviewer QA process. ... View more

At 2.9.1 Confirm both Copy Features GPT and  Export data - out will create a FC in the same GDB  from selection only as JayantaPoddar demonstrated. If you only want selected features, make sure you select them first before starting either tool.  Both of the below resulted in 1 feature in the output. Using Export Features or Copy Features     Docs say this is the same up to 3.0 "If the input is a layer and has a selection, only the selected features are copied to the output feature class." ... View more

First thing to look at is does the evaluating user have access to the sequence and has it been tested running by the schema owner? Second, you mention you are using a calculation rule.  Check: When using sequences in the script expression, ensure that the Exclude from application evaluation option is set to true.   This mandatory, if set to false the rule will fail; may only relate to 'insert edit operation'.  We've asked Esri to amend the dialog as there is no reason to allow an choice that will cause an error. "Calculation attribute rule examples - Generate an ID by incrementing a sequence" ... View more

I actually prefer the original design - it is always "Allow Application Evaluation" by default and in special cases (one?) you need to "Exclude from Application Evaluation" so for me that makes sense.  You need to firmly decide that is what you want as it has a dramatic effect on when the rule runs. I think if that change was to go ahead then the checkbox should be ticked by default to represent what the standard behaviour is, with tooltip warnings of the implications of changing it. ... View more

This also applies to the 'editable' feature for calculation rules.  If you did not want to let users edit this field (say you are populating a DB sequence by calculation) and forgot to untick it, or if you change your mind later about editability, you cannot toggle this option.  (Greyed out as shown) Your only recourse then is to delete the entire rule and recreate it. ... View more

Sorry for very long delay.  I confirm the two above post results in 2.8.1, and that although there is no control in the GPT for it, it does honour (and copy) only the active selection from the source featureclass in the map. ... View more

@PhallyGNP  to expand on Xander's good answer and the linked documentation, if you want to go down the "sequence as unique ID" route you need to create a database sequence (and will need rights to do so)  in the schema the dataset is in. e.g.  CreateDatabaseSequence(Connection.sde, MyNewSeq_name, {seq_start_id}, {seq_inc_value}) where optionally start_id is the start number and inc_value is the increment.  If you have no existing values you want to use, these can be omitted.  In my work we are often importing/migrating existing incrementing IDs/sequences, so we absolutely do not want to overrun sequences and reuse IDs. Pair this with a calculation rule as Xander mentioned.  Here's a simple example to get you started: Note!  In this case Exclude from Application evaluation must be enabled  for reasons which I hope are obvious.  This case is for a persistent ID that does not change through the life of the feature.  If you wanted a unique ID for every change, tick trigger on Update as well.   Finally it's also worth mentioning (reviewing your original question) that Pro supports Add GlobalID which is a unique ID generator completely managed by the system.  You don't have to do anything with it and it requires no rules or Arcade. It Just Works if uniquely identifying features is what you're looking for, don't need to match/customise existing sequences and don't care what the ID is or looks like.  (It'll be a UUID which is like  a Windows GUID and look a lot like "0fa8df96-4742-11ec-81d3-0242ac130003") ... View more

@PhallyGnean if you're using it, Data Reviewer offers this as a Unique Field Value check without needing customising. As @XanderBakker said, you can also write your own validation or use a sequence.  Their advice is pretty much what we're implementing for data integrity/validation. ... View more

Good suggestion, I was going to recommend you take it to http://ideas.arcgis.com/  Over here though they say that GP FC to FC actually strips attribute rules, which seems to be want you want.  I just used it to copy a FC from one enterprise GDB to another, and confirm attribute rules were not copied.  I don't see any switch in there I might have toggled but it seems to do the job you're asking.  ... View more

Thanks for that link to the manual - as far as I know this is the only reference to it.  It would be good if it was available from the tool ribbon. PerfTools for Desktop had a neat function for randomly generating extents for sampling and testing from a feature class.  Does this add-in support that feature? ... View more

I have to admit that I had second, third and even fourth thoughts about making suggestions to the legendary @DanPatterson but I thought "well, there might be just the tiniest chance they may not know one of those things (I'm still find ing new features in Pro all the time) and this content may help someone who doesn't know."  The phrase "teaching your grandmother how to suck eggs" comes to mind. 🙂 I agree the way the favourite tools work isn't great - you will get more and more tools on there until you end up with almost a copy of the toolboxes.  I'm not sure why Esri got rid of the ability to build your own custom toolboxes of standard tools, that was actually pretty neat.  Something something feature equivalency, Esri? 😛 As another option, you can create your own toolbars with groups of favourite tools, but this doesn't seem much better than saving them into the GP pane.  I also can't find a way of turning the groups on and off.  I guess you could have one tab per GP toolset but that would lead to tabspam and I don't think that's really what you're looking for. "You do not have permission to upload images" - really, Esri?  Uploaded as video instead. ... View more

In Desktop you have always been able to make your own toolboxes and customise them to suit your needs, so you might have one toolbox for spatial geoprocessing, another for statistical analysis, etc. https://desktop.arcgis.com/en/arcmap/latest/analyze/managing-tools-and-toolboxes/adding-tools.htm#GUID-CA99C4ED-DB43-4038-8C2E-2099F173F3F0 In Pro, although you can still make new toolboxes, it looks like Esri has deprecated that functionality and they now cannot contain copies of built-in tools, only ones you make yourself (unless you copied the python source and duped them).  The new system appears to be either favouriting a GP tool, or adding it to the analysis banner pane.  You can also add tools directly to the access bar, but none of these appear to be project-based so eventually you will end up with dozens of tools pinned, which may not be what you're looking for. There's a third option I've seen done quite a bit in Esri demos and I use myself: Search tools history or toolbox.  Just like Windows Start search, throw the first couple of letters in there, then pick the result you want which will be in the top few returned.  In practise I actually find this far faster than bobbling through toolbox names as it learns what I use most frequently. ... View more

I don't want to be negative but Esri has form with wiping out all community content/resources every few years, leading to massive frustration as years of work/solutions/highlighted problems are irrevocably lost and we have to start again fro scratch.  Also sometimes legacy resrouces need to be revisited.  I know of projects still using VB6/VBA under ArcGIS 9... I look forwards to being pleasantly surpised this time, but we shall see. ... View more