Latest Contributions by DavidSolari

My team's current maintenance process uses the arcpy "List" functions to only grab tables and feature classes to avoid this issue, it would be nice if you could throw an entire EGDB workspace at the maintenance tools and have it only process what it's capable of. ... View more

My org's in the same boat so I can't tell you what the proper process is. Based on the docs I think the first parameter is the line geometry to test against and the second parameter is a point. You might have to intersect the buffered line against the points to get a sensible set, run NearestCoordinate against every point, find the closest one, then use that for your results. ... View more

Does NearestCoordinate work for your use case? This requires Pro 3.3 and/or Enterprise 11.3 but it looks like it returns the side info. ... View more

Here's a simple implementation that spits out a point feature class in Web Mercator and nullable long integer fields, should be easy to alter this to suit your needs   from os import path def workbook_to_fc(file_path: str, fc_path: str): excel = arcpy.conversion.ExcelToTable(file_path, "memory\\fields")[0] arcpy.management.CreateFeatureclass(*path.split(fc_path), "POINT", spatial_reference=arcpy.SpatialReference(3857)) fields = [[name, "LONG", alias, None, None, None] for _, name, alias in arcpy.da.SearchCursor(excel, "*")] arcpy.management.AddFields(fc_path, fields)   ... View more

The "Shape" field in spatial data is a wrapper around however the format stores the geometry data. This could be some sort of text or binary data field in the table, or a separate table that's joined to the attribute data in real time. Either way, ArcGIS has to recognize the data format as something that stores features, if it thinks it's just a standard table then it'll just show the raw field data at best. In short, if you have your data in a CSV file or something like that you'll need to convert it to a spatial dataset of some sort -- usually a feature class in a file geodatabase. For point data the XY Table to Point tool should be good enough. For more complex geometries you'll have to figure out how each record stores the data and either dig up an appropriate conversion tool or write your own using arcpy. Once the data is copied to a feature class it can take advantage of all the ArcGIS tools and workflows ... View more

This is a known issue with the latest builds of Chrome, a deprecated feature used to display that bar was removed. There should be a hotfix patch available for your deployment. ... View more

I've had at least one project that would ideally use the standard editing tools (and Field Maps) get converted to a Survey123 hackjob workflow due solely to a lack of a multiple-choice domain. Making this a standard geodatabase feature would lead to greater adoption in other parts of ArcGIS. While I'm here, here's a user story to help development: Bob needs to collect which birds and which fish are in all the lakes in the city park. The lake assets are digitized ahead of time and he only needs the latest state, so a multi-choice domain for the "birds" and "fish" fields on those lake polygons are all he needs. The "birds" field is already there as a text field and can't be altered, so Bob creates a "BirdSpecies" multi-choice domain in the Enterprise Geodatabase for "Text" fields. He enters a 2-character code for each species and a full text description. The "fish" field will be a new field and Bob wants to keep his data fast and compact, so he creates a "FishSpecies" multi-choice domain for "Short" fields. Bob enters the description of each species and Pro auto-populates a numerical code, ensuring that for each description "n" the code is "2^(n-1)". Bob can alter the codes by hand but Pro will ensure that no codes have non-power-of-2 values. It will also ensure that no more than 16 codes are assigned for this "Short" domain; Bob can step up to a "Long" type if he needs up to 32 choices. Bob stops the web services, adds the new field, applies both domains and starts the services back up. The REST endpoints for these services now show the multi-choice domain options for the appropriate fields. Alice is configuring the Field Map for this collection project. When she adds the lake layer to the map and configures the smart forms the "birds" and "fish" fields now have a "checkbox" form element by default. Alice can change this from a dropdown list to a radio list if needed. She can also write Arcade expressions using the new "HasCodeInField" function to hide field groups or calculate other fields if a certain bird or fish is selected in the form. Steven has to create a Survey123 form for the lakes to meet a client mandate. He tells Survey123 Connect to prep the form based on the "Lakes" layer and the form automatically has a "select_multiple" question and matching list for the "birds" and "fish" fields. Ricardo collects a new lake in Survey123 and updates an existing lake in Field Maps. In both cases, the raw value of the "birds" field is all the codes in a comma-separated list, just as Survey123 does with a "select_multiple" question on a domain-free text field, and the "fish" field holds the bitwise OR of all choices as a single number. Veronica has a custom export script tool that needs to handle these new domains. During the export, her script grabs the "Domain" object for each field and calls the "codeToDesc" function with the raw value as a parameter to get a list of descriptions that she can process further. She could also use the "arcpy.da.ConvertDomainCodeToDesc" function with the raw value, the workspace path and the name of the matching domain to acheive the same goals. ... View more

Please make use of code sample formatting for Python code to avoid indent ambiguity, like so: with arcpy.da.SearchCursor(feature_class, ["*"], where_clause) as cursor: for row in cursor: row_value = row[cursor.fields.index("LAST_UPDAT")] rowdate_only = row_value.date() # This fails What's the data type of "LAST_UPDAT"? If it's a string you'll need to use the this method, if it's an integer that represents a UNIX timestamp try something in this StackOverflow thread, and if it's a custom integer representation then parsing is non-trivial. ... View more

Supporting multiple trips to the same survey record is a common workflow in my org. We point our survey forms to feature services that use registered EGDB data so we can use attribute rules with a state field to advance the form along as certain key fields are edited. If you don't have access to that, some things you can try are: Using the "deviceid" field type, this should have a valid value on mobile and not on the web. Make sure you bind the field type to "null" so it doesn't get into the actual data. You can also try adding your objectid or globalid field directly -- again, bind this to "null". Brand new forms should not have the values populated while editing existing forms will. ... View more

Try altering your script to output the new field alias names only, then run the alter field tool by hand for a few of them using that output. Does it fail silently again, or do you get an error? ... View more

Odd, this expression works in the Map Viewer for Enterprise 11.1 just fine. Does adding an explicit "return" keyword at the start of line 2 fix things? ... View more

Here's what I'm using on my current projects, this requires using Arcade to make a special field for the URL:   "https://survey123.arcgis.app?itemID=blahblahbalh&action=edit&update=true&q:globalId=" + Lower(Mid($feature.GlobalID, 1, 36))   I think you should be able to swap out the first part of the URL with the other link type, depending on what works better for your set of devices. As for that GlobalID part, this removes the curly braces and lowercases the letters, this should avoid any issues with a GlobalID in a URL. ... View more

If you have a bunch of features and you want to see their spatial relation to another set of features just use the Spatial Join tool. You can run through the results with a cursor but it'll run much faster, especially as the size of your datasets expand. ... View more

If you make "params" a proper function parameter and pass it in every time does that help? ... View more