Latest Contributions by AndrewQuee

‎11-16-2021

@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")

‎11-10-2021

@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.

‎11-08-2021

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.

‎03-28-2021

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?

‎11-16-2020

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.

‎11-12-2020

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.

‎11-08-2020

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.

‎10-29-2020

Thanks. I'll just add that I discovered that Pygments has about half a dozen sub-lexers for Javascript variants. When I tested these in Mediawiki/Syntaxhighlight to see if they were compatible with Arcade (albeit for completely the wrong language) one or two aspired to the mediocracy of the javascript lexer, the rest were dire/inapplicable. This isn't a deal breaker for me/us, so will go onto the backburner (read: locked filing cabinet in disused toilet at bottom of unlit stairwell) until I get spare time to look at it. I had a brief look at making a lexer, seems quite overkill for the benefit of making text look nice. I might look at simply altering the existing colour values for the javascript lexer as a quick fix.

‎10-29-2020

Yes, this is exactly what we are doing now in Desktop and Pro business systems. We were hoping to return to somehting more COTS-like and reduce development overheads is all. Thanks for the clarification.

‎10-28-2020

Thanks very much Xander and Dan Patterson‌, I knew it was an easy question, I just couldn't find the answer in the FAQ etc. I really think that the issue is in my markup, so while I might not be up to writing a lexer, I definitely think I can do something on the javascript configuration. If someone on the Esri side would like to expand on what they use for the nice markup shown in code snippets on Esri websites that'd be lovely, otherwise I might do some reverse-engineering through mediawiki.

‎10-27-2020

We store business information using mediawiki and share template code snippets from all our development environments using the syntaxhighlight extension which uses Pygments to do automatic syntax formatting in the page. Arcade is not in the 'hundreds of languages' Pygments supports (and I acknowledge this is not the venue to ask for Pygments or Mediawiki support) but I just wanted to ask what root language is Arcade most like? It doesn't need to be 100% accurate but anyone who's read code with <pre> tags knows it doesn't 'spark joy'. Over at Using Arcade expressions in web apps they said Arcade is similar to other scripting and expression languages, such as SQL, Python, VBScript and spreadsheet formulas. ...It has syntax similar to JavaScript... The closest and nicest-looking syntax I've seen is java but I was wondering out of those hundreds what the closest match is. Javascript is mentioned a lot over at Arcade | ArcGIS API for JavaScript 4.17 but when I apply that under syntaxhighlighter it actually looks quite 'meh', although that could just be my style markup. Edit: This is what I mean by 'meh' styling if you're interested. No fault of Arcade, Mediawiki or Pygments, it is what it is.

‎09-06-2020

The move to a flatter versioning system is welcome because it almost all cases we have no requirement to have versions on versions on a version. There's change required to production data in multi-user editing, and that's it, so just the one child version per change (which only lasts as long as the edit lifetime) is all we need. In fact unraveling accidental grandchild versions is the only thing we do with the current multiple layer versioning system. The move to a service-oriented system is also welcome and a great innovation, allowing much greater flexibility, scope and wealth of applications working with enterprise data across the internet, especially important while staff and clients can both be working from home during COVID-19. One thing that is a concern though is we currently allow users to create, edit, reconcile and post their versions to DEFAULT (we use customisations to prevent direct editing of DEFAULT) but this seems no longer possible unless we make them feature layer owners or portal administrators. We'd like to retain the efficiency of self-managed editing with a minimum administration overhead with protected DEFAULT version. But it's inadvisable leave it unprotected or to make all users of the service Owners and unsafe to make them all Portal Adminstrators just to be able to reconcile and post to DEFAULT. We'd also like to remain as close to COTS as possible to deliver development and support efficiencies. What would be ideal for our workflow is if in Enterprise permission can be given to allow classes of users the ability to create, reconcile and post their versions to a protected DEFAULT branch version, but not edit the default version directly.

‎06-18-2020

Sorry let me try English again on my post (not allowed to edit) "took many times longer in Pro than using Catalog" and "...would hate to doing this on dozens of objects in a Catalog pane on multiple enterprise geodatabases" Had a similar case yesterday. Create new map, open catalog pane, connect database, select four FC. Add to map. Simple, yes? Nothing happened. Wait. Wait. Wait. [30 seconds later] Ok this is not happening, can you even add multiple items to a map at once? Do it again. Wait. Wait. Wait. Nothing happens. Do it again. Give up and start adding them one at a time. All of a sudden multiple copies of the same FC erupt onto the map! [2 minutes later] Um.. okay?

‎06-15-2020

I had an 'entertaining' example yesterday. Exported some simple FC's into a network folder. Two groups of three same-named FCs, each with maybe 10K features, nothing special. Call them A, B, C and A, B, C. Takes about 10 seconds in Desktop. Okay rename the first three so avoid conflict on importing the second group: A1, B1, C1. Wait. Wait. Wait. Nothing happens in catalog pane. Press refresh. Names finally change. Why do I need to manually refresh an object list? I haven't had to do that since the bad old days of Bashing console and FTP! Okay, bring in new group and rename also to show different origin, A2, B2, C2. Refresh. Check names have changed. Wait a few seconds for hamsters to catch up. Refresh to ensure names have changed. Copy all six into local FGDB on my computer. The second group copy with the original names! Go back to the source location. Names are changed there, but not on destination. FGDB has A1, B1, C1, A, B, C *flip mousepad and close Pro* This is a really really basic, simple operation done on my own computer, and took about many times longer in Pro than using Catalog simply because I couldn't trust the processing tools to be doing the right thing at the right time. I would hate to doing this on dozens of objects in a Catalog pane on multiple enterprise.

‎06-09-2020

Thanks for the clarification Kory. My experience was that it was all features not just the selected one (Copy features Gp was successful and did honour selection) I'm on another task but will return to this by next week and check again. I can also do a 2.5.0 vs 2.5.1 test if required.

Online Status	Offline
Date Last Visited	‎09-11-2025 05:47 PM

My Ideas

Latest Contributions by AndrewQuee

Re: Attribute Rule - FAQ

Re: Attribute Rule - FAQ

Re: Add option to delete attribute rules when exporting feature classes

Re: How can I use the new ArcGIS Pro PerfTools Add-in?

Re: Enable ArcToolbox customization

Re: Enable ArcToolbox customization

Re: The New GeoNet Platform Launches on November 12

Re: What language is Arcade most like for syntax highlighting?

Re: Blog discussion - branch versioning

Re: What language is Arcade most like for syntax highlighting?

What language is Arcade most like for syntax highlighting?

Re: Blog discussion - branch versioning

Re: Why does ArcGIS Pro have to be so slow???

Re: Why does ArcGIS Pro have to be so slow???

Re: Is there an export selected features option within ArcGIS Pro?

Re: WebGISDR Failing on export and import with per...

Re: Are attribute rules supported in ArcGIS Enterp...

Re: Is Esri providing support for work from home?

Re: Administer SDE without Versioning Lineage Tree...

Re: How to replicate state tree from GDBTools?