Latest Contributions by ThomasColson

‎04-27-2023

I have Solved: Attribute Rule Expressions: calculate max value fr... - Esri Community successfully working in the fgdb environment. What I'm looking to do is replicate in a "new" web map viewer "Form" to autopopulate an unique ID field that IS NOT the objectID nor the GlobalID. Thing is, the data contains many existing records, with this ID ranging from 1-15000, with many values in between missing due to past deletions. What I want is to look at the max value in this field, and have (Arcade?) auto populate the next highest value when the user creates a new point, based on this form. But I don't see how this is possible as AGOL (still!) does not support GDB attribute rules and Create Database Sequence (Data Management)—ArcGIS Pro | Documentation

‎04-21-2023

That worked perfectly! Sadly, performance is....lacking. Eg. I have a line with 36 features that passed thru 3 states. The result (pop up) takes 2-3 minutes to execute, on a very fast computer and very fast internet. Is this just a hard limitation of Arcade that can't be worked around?

‎04-21-2023

In an AGOL webmap, I have an Attribute Expression (that I sourced from here😞 // get the states layer var portal = Portal('https://arcgis.com') var states = FeatureSetByPortalItem( portal, 'a454cf97c4264cd2b77f27175e01d3ba', 3, ['ABBRV'] ) // intersect feature with States var xs = Intersects( $feature, states ) // create array of intersected state names var c_array = [] for (var c in xs){ Push(c_array, c['ABBRV']) } // remove duplicates var unique_states = Distinct(c_array) // concatenate array, return string return Concatenate(unique_states, ', ') That works as expected: user clicks on a line, pop-up returns a list of state(s) that the selected line intersects. Here's the problem: the line is multiple parts (features? Sections?). CHunked up by numerous attributes (state, county, district, etc....). So if the user clicks on a line segment, they get the state(s) that the segment intersects. But what I want is: Every single state the ENTIRE line intersects, based on the name of the line. So if the NAME attribute of the line they click on is "BIGFOOT", some sort of magical arcade thing that FIRST selects every single line segment (which could be dozens) with NAME = "BIGFOOT", then do the intersect and return every state intersected by every line segment where NAME = "BIGFOOT".

‎04-20-2023

I'm trying to build a list from a feature class that is a lot of polylines, something like this: Trail 1, State 1, District 1 Trail 1, State 1, District 1 Trail 1, State 1, District 2 Trail 2, State 2, District 3 Trail 2, State 2, District 4 Trail 3, State 3, District 5 Trail 3, State 4, District 6 Trail 3, State 5, District 7 Trail 3, State 6, District 8 Trail 3, State 7, District 9 What I want the list to show is: Trail 1, 1 State(s), 2 District(s) Trail 2, 1 State(s), 2 District(s) Trail 3, 5 State(s), 5 District(s) What I've got so far is: var fs = FeatureSetByPortalItem(Portal('https://arcgis.com/'), 'a454cf97c4264cd2b77f27175e01d3ba', 0, ['TRLNAME','STATE','CONG_DIST'], false); return GroupBy(fs, ['TRLNAME'], [{name: 'total_states', expression: 'STATE', statistic: 'COUNT' }, {name: 'total_districts', expression: 'CONG_DIST', statistic: 'Count' }]); Which gives me Which is giving me unique trails, but very clearly not the unique state, district for each trail. How do I narrow down the expression to return unique states,districts for each trail? Not a programmer.....

‎04-20-2023

I'm trying to build a dashboard list from a feature class that is a lot of polylines, something like this: Trail 1, State 1, District 1 Trail 1, State 1, District 1 Trail 1, State 1, District 2 Trail 2, State 2, District 3 Trail 2, State 2, District 4 Trail 3, State 3, District 5 Trail 3, State 4, District 6 Trail 3, State 5, District 7 Trail 3, State 6, District 8 Trail 3, State 7, District 9 What I want the list to show is: Trail 1, 1 State(s), 2 District(s) Trail 2, 1 State(s), 2 District(s) Trail 3, 5 State(s), 5 District(s) What I've got so far is: var fs = FeatureSetByPortalItem(Portal('https://arcgis.com/'), 'a454cf97c4264cd2b77f27175e01d3ba', 0, ['TRLNAME','STATE','CONG_DIST'], false); return GroupBy(fs, ['TRLNAME'], [{name: 'total_states', expression: 'STATE', statistic: 'COUNT' }, {name: 'total_districts', expression: 'CONG_DIST', statistic: 'Count' }]); Which gives me Which is giving me unique trails, but very clearly not the unique state, district for each trail. How do I narrow down the expression to return unique states,districts for each trail? Not a programmer.....

‎03-14-2023

Looking for a python-way to check the existence of the following as part of a QA script: If the correct default is assigned to a field; If the field is nullable If the field is required

‎03-13-2023

Thanks this worked!

‎03-13-2023

With the following I am evaluating: Does the field exist and correct length. Print message Does the field exist and incorrect length. Print message Does the field not exist. Create field. Print Message #Create required TRLNAME Field try: in_Field = "TRLNAME" if len(arcpy.ListFields(in_Table,in_Field))>0 and len(in_Field) == 254: arcpy.AddWarning(in_Field+" exists and is the correct length. Yay!") elif len(arcpy.ListFields(in_Table,in_Field))>0 and len(in_Field) != 254: arcpy.AddWarning(in_Field+" exists but is not the correct string length (254).") else: arcpy.AddField_management(in_Table, in_Field, "TEXT", "", "", 254, in_Field, "NON_NULLABLE", "REQUIRED", "") arcpy.AddMessage ("Created the "+in_Field+" field.") except arcpy.ExecuteError: msgs = arcpy.GetMessages(2) arcpy.AddError(msgs) except: tb = sys.exc_info()[2] tbinfo = traceback.format_tb(tb)[0] pymsg = "PYTHON ERRORS:\nTraceback info:\n" + tbinfo + "\nError Info:\n" + str(sys.exc_info()[1]) msgs = "ArcPy ERRORS:\n" + arcpy.GetMessages(2) + "\n" arcpy.AddError(pymsg) arcpy.AddError(msgs) If the field does not exist, it correctly creates it. However, if the field exists, regardless of if it's the correct length (254 or any other string length), it always defaults to the "elif" in the block and reports that the field is not the correct length. Feel like this is a simple syntax error but I've been at it for hours and not seeing it. Help?

‎03-13-2023

With the following I am evaluating: Does the field exist and correct length. Print message Does the field exist and incorrect length. Print message Does the field not exist. Create field. Print Message #Create required TRLNAME Field try: in_Field = "TRLNAME" if len(arcpy.ListFields(in_Table,in_Field))>0 and len(in_Field) == 254: arcpy.AddWarning(in_Field+" exists and is the correct length. Yay!") elif len(arcpy.ListFields(in_Table,in_Field))>0 and len(in_Field) != 254: arcpy.AddWarning(in_Field+" exists but is not the correct string length (254).") else: arcpy.AddField_management(in_Table, in_Field, "TEXT", "", "", 254, in_Field, "NON_NULLABLE", "REQUIRED", "") arcpy.AddMessage ("Created the "+in_Field+" field.") except arcpy.ExecuteError: msgs = arcpy.GetMessages(2) arcpy.AddError(msgs) except: tb = sys.exc_info()[2] tbinfo = traceback.format_tb(tb)[0] pymsg = "PYTHON ERRORS:\nTraceback info:\n" + tbinfo + "\nError Info:\n" + str(sys.exc_info()[1]) msgs = "ArcPy ERRORS:\n" + arcpy.GetMessages(2) + "\n" arcpy.AddError(pymsg) arcpy.AddError(msgs) If the field does not exist, it correctly creates it. However, if the field exists, regardless of if it's the correct length (254 or any other string length), it always defaults to the "elif" in the block and reports that the field is not the correct length. Feel like this is a simple syntax error but I've been at it for hours and not seeing it. Help?

‎05-17-2022

For those that are wondering why ENH-000129687 [Enhancement] Provide the ability to use Group Managed Services Account while setting up Integrated Windows Authentication in Portal for ArcGIS in ArcGIS Enterprise. is classified as "Will Not Be Addressed" is: "This feature would require significant research and development" despite the significant workload customers have in maintaining and keeping secure a password-based service account for this purpose (or the significant amount of $ that GIS server license costs).

‎12-08-2021

@DougMorgenthaler seems like this could be an easy one to move to "Partially Implemented" with " Some of the GNSS metadata fields currently available would be very easy to add, like "Receiver Name" (ESRIGNSS_RECEIVER)"

‎06-28-2021

"It is currently possible to sort items in ArcCatalog and ArcGIS Pro Catalog view by clicking the column headers." and "Already Offered" is not correct. It is possible to sort SOME THINGS in Catalog View, but not everything we need to sort on, as brought up in Add Additional Details in Catalog View in ArcGIS P... - Esri Community Pro 2.8.1. Cannot sort (or view) date. Catalog 10.7.1 Can... Someone will point out that double-clicking on the date column will sort it ascending/descending anyways...you just can't see the date. No, it won't. It will change the order of the items, but it's not sorting on any date field. It would help me if someone could explain how this is already offered. Am I missing a setting in Options that needs to be turned on?

‎06-24-2021

The current ArcGIS Server Patch Utility (C:\Program Files\ArcGIS\Server\tools\patchnotification) relies on Java. Even the most permissive security model blocks java. This makes ESRI one of the few (only?) vendor where sys admins have to go to a web site, find the patch, download it, and install it. So 2000's! Give us a patch manager that works!

‎03-22-2021

So when I submitted this bug, it was specifically for that this feature was only available on lines and polygons, but not points, so we may be splitting hairs on the exact text of the bug and davids example.

‎03-18-2021

Helps if the account running the query has the right permissions to see ALL items, not just public ones!

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by ThomasColson

Is sequential numbering based on last known number possible with Arcade in a "new" web map form?

Re: Arcade: Select Similar items when item in selected

Arcade: Select Similar items when item in selected

Dashboard list how to get a distinct list from a distinct list with Arcade?

Dashboard list how to get a distinct list from a distinct list with Arcade?

Do the following python field checks exist?

Re: Python if elif always defaults to elif

Python if elif always defaults to elif

Python if elif always defaults to elif

Re: Group Managed Service Account be used for Windows Integrated Authentication?

Re: GNSS Metadata Fields for Lines and Polygons in Field Maps

Re: Add an option to sort items in ArcCatalog by date, type etc.

Enterprise Patch Utility: It's time to end Java

Re: Limited options in 'Format All Symbols'

Re: Is it possible to query all users and return number of items owned by each?

Re: Group Managed Service Account be used for Wind...

Re: Help: Legend color ramp does not match layer c...

Re: How do I transfer attributes between features ...

Re: How to bulk delete protect and mark as authori...

Re: Migrate Portal User, Group and Group Members t...

Wildfire Response GIS