Latest Contributions by DavidSolari

‎10-30-2023

The traditional archiving method? Nope, you're out of luck with the data table alone, you might be able to correlate the GDB_TO_DATE with other database or server logs but no guarantees. Branch Versioned tables have their own schema that includes the GDB_DELETED BY field which should list the culprit, if you can work out a migration plan I'd recommend switching.

‎10-30-2023

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

‎10-30-2023

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.

‎10-27-2023

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.

‎10-27-2023

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.

‎10-27-2023

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

‎10-26-2023

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.

‎10-26-2023

Is there a list of which Python version (e.g. 3.7, 3.9 etc.) is included with each version of Pro? My team has had to keep an old version of Pro around to maintain version compatibility with our Enterprise Python environment and a table like this would've saved a few hours of trial and error installing different versions. This table already exists for Enterprise so I'm not sure why I can't find the same resource for Pro.

‎10-26-2023

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.

‎10-26-2023

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.

‎10-24-2023

When Power Automate is connected to Survey 123 using this method for Enterprise the only surveys available are those owned by the account embedded in the workflow. I propose expanding this to any survey shared with the embedded account so they can run workflows for surveys other organization members own. Our team needs to grant access to an external user solely for working with existing surveys, which is impossible to control if the embedded user also owns the survey. Expanding what the workflow can access without changing the user's scope would fix this issue.

‎10-24-2023

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.

‎10-23-2023

For context: we're hosting all of our data in our Enterprise (10.9.1) and using Survey123 thorough the usual website with our portal URL glued on. We've tried to use webhook with Power Automate using the documented method and everything seems to work well, but only if the registered user owns every single survey. This is untenable for us as the team feeding off the webhooks is separate from the team managing the surveys, which means they need a separate account. My question is: is there a way for Power Automate to pull every survey that's shared to the registered user, not just the ones it owns? We might be able to hack around things by hosting a custom swagger file but I'm not even sure if processing surveys that are just shared to a user is allowed. More info on what we can do here is greatly appreciated!

‎10-20-2023

Untested, but this should get you in the ballpark: # Get this polyline object somehow, cursors with the "SHAPE@" token work well line = get_line() sr = line.spatialReference start = arcpy.PointGeometry(line.firstPoint, spatial_reference=sr) end = arcpy.PointGeometry(line.lastPoint, spatial_reference=sr) angle, distance = start.angleAndDistanceTo(end, "GEODESIC") Peep the "angleAndDistanceTo" part of the PointGeometry docs for more info.

‎10-19-2023

I noticed this in the new parameter controls document: To support a parameter that accepts a multiline block of text, use a controlCLSID value of {E5456E51-0C41-4797-9EE4-5269820C6F0E}. Does this mean text boxes that pass multiline string data are implemented in 3.1? I don't have 3.1 to test but at a glance it seems like this was silently implemented. If so this is an easy "Already Implemented" idea for whichever community manager stumbles across this, wink wink.

Online Status	Offline
Date Last Visited	Tuesday

My Ideas

Latest Contributions by DavidSolari

Re: Enterprise GeoDatabase - Find out who deleted Features

Re: Downloading Selected Attachments

Re: Web layer draws slow in Pro - and dashboard

Re: Understanding snap to grid

Re: Edit Default Visibility for Feature/Map Service

Re: Table of Python Versions for Each Pro Release?

Re: Is there an easy way to populate a new related table with data that is currently stored as an attribute of another feature class?

Table of Python Versions for Each Pro Release?

Re: String to Datetime with Python in ArcGIS Pro

Re: Merging 10 vector polygon classes into 5 classes

Webhooks & Power Automate: Allow Enterprise Workflow to See All Shared Surveys

Re: Webhooks & Enterprise: Accessing Surveys Shared With User

Webhooks & Enterprise: Accessing Surveys Shared With User

Re: Obtain bearing of a geodesic line using arcpy

Re: Text box parameter for script tools

Re: How to show required field values in ArcGIS Fi...

Re: How to Make Python Toolbox Use It's Folder Loc...

Re: ArcGIS Pro field calculator if statements base...

Re: Calculate right after hitting the submit butto...

Re: Python code to subtract a value but don't go b...