Latest Contributions by DavidSolari

Ah, looks like I was beaten to the punch! As Josh pointed out, names with more than 1 space in them will lead to issues. My code dumps everything but the last token in the first name slot, with some tweaking you can get everything but the first token in the last name slot. ... View more

The output is an array of strings. Here's how to safely extract that data assuming arbitrary input: var tokens = Split("Your Data", " "); var count = Count(tokens); var first = null; var last = null; if (count == 1) { first = tokens[0]; } else if (count == 2) { first = tokens[0]; last = tokens[1]; } else if (count > 2) { var first_array = []; for (var i in tokens) { if (i == count - 1) { break; } Push(first_array, tokens[i]); } first = Concatenate(first_array, " "); last = tokens[-1]; } // Do what you need with first and last ... View more

SQL Expression parameters require a "Dependency" on the parameter you want to filter so it can populate the dialog, set that up and your parameter should work ... View more

If you have access to these Vector Tile options, give them a try. You'll get a reasonably performant Vector Tile layer along with a service that supports popups.   ... View more

GIS is primarily concerned with the locations of object relative to a fixed reference. Or "the earth" to be specific. As such, the grid options are all pinned to the origin of your map's coordinate system, in the units of said system. That said, an option to center the grid relative to the start of a sketch seems like a handy function, hit up the Ideas area and it might get implemented down the road. ... View more

Officially, there's no way to change a MapService without going through the usual publishing routes. Unofficially, if you can get your script to access your ArcGIS Server's directory folder, you can navigate through the "arcgissystem\arcgisinput" tree to find the definition for your service. Buried somewhere in each service folder is the mapx and/or msd files used to render each service, as well as the service-level metadata files. If you edit every relevant files' minScale and maxScale properties then you should be good! Or you'll corrupt the service. Oh, don't forget mapx and msd files have no public interface so nothing's stopping your process from breaking after an errant update. ... View more

Oh wow, I had no idea ESRI was uploading the arcpy package to Anaconda, this makes things much easier. Thank you! ... View more

  parent_key = "GlobalID" child_key = "ParentID" parent_fields = [parent_key, "fields", "to", "copy"] child_fields = [child_key, "into", "the", "child"] # Start an edit session if needed with arcpy.da.UpdateCursor("parent_table", parent_fields) as update, arcpy.da.InsertCursor("child_table", child_fields) as insert: for row in update: insert.insertRow(row) update.updateRow([row[0]] + [None] * (len(row) - 1)) # Close the edit session if needed   Untested, but this should simultaneously create related records with the relevant fields while nulling out the old data to avoid confusion. ... View more

I'm not sure where this ms level noise is coming from (especially with strptime) but this StackOverflow answer looks like a valid solution when combined with a good old Field Calculation run. ... View more

Here's a (untested) Field Calculator code block:   def reclass(value): lookup = { "Coniferous": "Tree", "Deciduous": "Tree", "Igneous": "Rock" } return lookup.get(value, value)   You write something like "reclass(!my_field!)" and it'll map the inputs to the outputs as defined in the "lookup" dictionary, but leave them unchanged if it's not in the list. Alternatively, you can load the old and new values into a table, join the tables on the common key field, then field calculate over the data. This'll let you maintain a lookup table as standard ArcGIS data instead of Python code if that works better. ... View more

To keep things simple: we can't give the Power Automate users the ability to alter the surveys in any way, their only ability should be to pull completed surveys through the webhook. Unless there's a way to get that working I'll have to take this to the Idea Zone. Thanks for the clarification. ... View more