Latest Contributions by DavidSolari

‎10-13-2022

A few people have posted suggestions, here's one that works with any number of fields and any value: def setIfFound(value, *checks): return value if value in checks else None

‎09-29-2022

Creating a spatial layer by joining features to a parent table has been a long-running deficiency in ArcGIS. The classic method to work around this is to create Query Layer or database view but this only works for EGDBs and a few other products and I assume your Survey123 data is all hosted which rules this out. The other workaround is to write a Python script that loads both tables, joins them and then outputs features to a third shadow table that you use for analysis. This prohibits real-time analysis and requires tool maintenance but it works! If there's been platform advancements to handle this use case then I haven't heard of any but that doesn't mean they aren't out there, worst case scenario you file or bump an Idea post and hope for the best.

‎09-29-2022

Please add the ability to use an arcade expression for every map series field: name, page number, spatial reference etc. This would decrease the iteration time for map series where I'd have to copy out a layer to a geodatabase just to add and calculate map series specific fields.

‎09-21-2022

I assume you're trying to clean up address data, which doesn't have a generic solution. If it's the same error over and over you can use string methods such as .index, .split, .join, slicing etc. to fix the error, here's an example that'll work for your example string: def fixAddr(x): sNum, sData = x.split() sDir = sData[0] sName = sData[1:-2] sType = sData[-2:] return f"{sNum} {sDir} {sName} {sType}" If you want a generic method, the only technique I can think of is to run your address string through a geocoder and then pull out the component parts from the returned address. This is much more complex than just basic field calculation but it's the most bulletproof method I've found. Good luck!

‎09-21-2022

Labels are locked to the feature they describe. If you want freely placeable text, you have a few options: Create a separate set of point features to hold the labels and then add them to the map with a blank symbol. These label points will work in virtually any part of an ArcGIS system but you're limited on how fancy the placement and text formatting can get Create an annotation feature class. These feature are explicitly designed to handle text and can store complex formatting rules. The catch is they don't play well with web services so unless you acquire a custom extension for annotation layers they're basically stuck in the desktop. Both maps and layouts have a layer for general graphics, such as text and images. These graphics technically aren't geospatial data and there's limits to data interoperability but if you just need a quick label for your PDF they'll do just fine.

‎09-21-2022

The Pro geoprocessing system has this neat feature buried in the docs where you can create standard Python packages that contain script tools, then install those packages to your current environment with the accompanying toolbox infrastructure. More info here. The docs use a Python toolbox in their examples but there's mentions of supporting standard toolboxes as well, most notably in the introduction to the page I linked. However, when I build a package with a standard toolbox and then install it, attempting to run the tool in Pro 3.0.1 results in this error: Traceback (most recent call last): File "<string>", line 1, in <module> File "C:\Users\JDangermont\AppData\Local\ESRI\conda\envs\testing\Lib\site-packages\foo\esri\arcpy\SampleToolbox.py", line 20, in SampleTool raise e File "C:\Users\JDangermont\AppData\Local\ESRI\conda\envs\testing\Lib\site-packages\foo\esri\arcpy\SampleToolbox.py", line 17, in SampleTool retval = convertArcObjectToPythonObject(gp.SampleTool_SampleToolbox(*gp_fixargs((), True))) File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 510, in __getattr__ val = getattr(self._gp, attr) AttributeError: Object: Tool or environment <SampleTool_SampleToolbox> not found This could be some weird misconfiguration or environment problem on my end so I've attached a little package that you can download, build, and add to your testing environment. You can build the package using the standard instructions, install it with pip, relaunch Pro and then run arcpy.SamplePythonToolbox.SampleTool() and arcpy.SampleToolbox.SampleTool() from the Python window. If the first tool succeeds but the second tool fails then it's safe to say atbx files aren't actually compatible with this packaging system. If so I hope someone from esri can dig into this as it's most likely just an issue with the autogenerated wrapper code.

‎09-21-2022

My general rule for writing script tools is to structure them like this: def main(param0, param1, param2): return doSomethingWith(param0) + doOtherThingWith(param1 + param2) if __name__ == "__main__": param0 = arcpy.GetParameterAsText(0) param1 = arcpy.GetParameterAsText(1) param2 = arcpy.GetParameterAsText(2) param3 = main(param0, param1, param2) arcpy.SetParameterAstext(3, param3) This has two big benefits. First, you ensure all the parameters are yanked out of the aether and loaded into proper variables before you run your task. Second, you now have a main function that isn't strictly dependent on parameter state, which means you can write tests for it or call the function from other scripts without going through importing a toolbox.

‎09-15-2022

If you're willing to dive into arcpy cursors and geometry objects you should be able to find a way to load in lines, generate points at set intervals along said line and then load those points into a feature class. There might be a stock geoprocessing or editing tool we're both missing but if you like solving little programming challenges this seems worth digging into.

‎09-15-2022

It looks like the only exit point that can return a null value is the final return for the address itself. You can coerce a null address to your string like so: var address = closestFeatureWithDistance['feature']['Address'] return Iif(IsEmpty(address), "Not Detected", address) I think the issue is you're checking if the entire "closestFeatureWithDistance" object is null on line 33 rather than just the Address attribute.

‎09-15-2022

Attribute Rules sound like the clear answer here, you can get started at this link. If your datasets need to remain accessible in ArcMap then this is off the table, 2 things you can try are: Using the new Field Maps arcade functionality to calculate the attributes client-side (link). This'll only work if your only point of entry to the data is through Field Maps. Create database triggers in your RDBMS if available. This is a very fragile process as anything that changes the underlying table structure (such as enabling versioning) will break your triggers and you may have to write some complex SQL to keep the tables in line, but this'll work across the board.

‎09-15-2022

Try and reduce your workflow down to something that's easy to replicate and try to make it happen again. If you can reliably delete records just by using the join commands then you need to take this to your support contact as this could be a major regression in Pro, or at least signs that something in your environment is acting up.

‎09-02-2022

Quoting the latest docs: For layers in the feature service that can store attachments, the Create or Update operation allows editors of the feature service to add an attachment to a feature. The Update operation further enables editors to update or delete an attachment that is associated with a feature. If only the Delete operation is enabled, editors can delete attachments. I can't think of a single scenario where the user would be forbidden from deleting a feature, but should be able to delete that feature's attachments. Please align the attachment permissions with the feature permissions so that users must have delete permissions to delete attachments.

‎08-25-2022

One thing you can try first is to add "?f=json" to the end of your URL, this should return the resource's JSON definition. I've encountered a lot of ArcGIS Server sites that forbid HTML viewing but are fine with JSON, you might be in the same boat.

‎08-25-2022

If you're rendering the map in Pro, you can go to the Map's properties and fiddle with the Clip Layers section. This'll create a clip mask that you can apply to layers, including the output of the Heat Map symbology. Here's an example of what this looks like from a layout I made: If you don't have Pro or you have the heat map as a raster then you'll need a tool that can clip rasters, not sure what the workflow is there.

‎08-05-2022

Has anyone found a working setup for script tool debugging with Pro 3.0 and VS2022? I'm following the steps from the usual guide which worked fine with Pro 2.9 and VS2019 but nothing seems to be working right now. I was able to get an exception caught at one point but I haven't been able to replicate it after a dozen attempts. I don't have VS2019 on hand so I can't test if it's just an issue with VS2022 but I'd hope the version of Pro built on the latest .NET release would also support the current Visual Studio.

Online Status	Offline
Date Last Visited	Monday

My Ideas

Latest Contributions by DavidSolari

Re: Search for a string in multiple fields

Re: [survey123] Mapping related table based on coordinates in parent object

Map Series: Arcade Expressions for Fields

Re: Spaces

Re: How to freely move data labels in ArcGis Online (web map)?

Issue with Geoprocessing Modules and Standard Toolboxes

Re: arcpy.GetParameterAsText getting null value if used after arcpy.ExcelToTable_conversion

Re: Inserting points at specific intervals along a polyline

Re: Return Not Detected for Address field insted of Null values for arcade expression

Re: Auto-populating field using spatial location of another feature and its attributes using ArcGIS Pro

Re: ArcGIS PRO - Records disappeared from the table when joining tables

Prevent users from deleting attachments if they can't delete the parent feature

Re: ArcGIS REST Services Directory

Re: Clipping Heat Maps

Issues Debugging Python in ArcGIS Pro 3.0 with Visual Studio 2022

Re: 3rd Party Form => Survey123

Re: SQL Registered Server via Database Connection ...

Re: SQL Registered Server via Database Connection ...

Re: arcade expression in Field Maps pop-ups

Re: Best way to publish a locally created tile cac...