Latest Contributions by BlakeTerhune

Do the users have ArcGIS Pro installed? ... View more

You can use Python to open a search cursor using the fields in the order you want with a sql_clause parameter to sort on the field you want. Iterate through each row of the cursor and write the data to your text file. You can even use the Python CSV module. ... View more

I think your fieldMap is incorrect. The error: "Every table requires a role" refers to the role that is also configured within the field_mapping. If you run the tool manually in ArcGIS Pro, then go to the geoprocessing history tab in the Catalog pane, you can right click on the tool result and copy as Python command. Then paste that into your code editor so you can see the formatting of everything. That's what I did here and this was what I got.   fieldMap = [ "StreetAddress.HOUSE_NUMBER_FROM_LEFT 'road_layer'.L_LADD", "StreetAddress.HOUSE_NUMBER_TO_LEFT 'road_layer'.L_HADD", "StreetAddress.HOUSE_NUMBER_FROM_RIGHT 'road_layer'.R_LADD", "StreetAddress.HOUSE_NUMBER_TO_RIGHT 'road_layer'.R_HADD", "StreetAddress.HOUSE_NUMBER_FROM_RIGHT 'road_layer'.R_LADD", "StreetAddress.PARITY_LEFT 'road_layer'.L_PARITY", "StreetAddress.PARITY_RIGHT 'road_layer'.R_PARITY", "StreetAddress.STREET_NAME 'road_layer'.NAME", "StreetAddress.STREET_SUFFIX_TYPE 'road_layer'.SFX", "StreetAddress.STREET_SUFFIX_DIR 'road_layer'.DIR", "StreetAddress.FULL_STREET_NAME 'road_layer'.FULL_NAME" ]   ... View more

I just noticed the ExportAttachments() function in 3.3. Maybe you could try that too if you're able to upgrade Pro. ... View more

Sorry, I have not worked with images much, but you could try ImageMagick or wand. ... View more

More information in the ArcGIS Pro Blog. Additionally, ArcGIS Pro 3.3 requires Microsoft Edge WebView2 Runtime version 117 or later. If it is not already installed on the machine, use the Evergreen Bootstrapper or Evergreen Standalone installer from Microsoft. Learn more in this blog. ... View more

@AlfredBaldenweck wrote: No idea how I missed that. I looked right at it and moved on. The documentation for mapType says, "Returns a string value that reports the Map object's type information. If the Map is 2D, MAP is returned. If the Map is 3D, SCENE is returned." It implies those are the only two options, which is clearly not the case. I am submitting feedback on that page to be more descriptive of the mapType property. ... View more

Apologies if I'm missing something obvious, but would it be the isBasemapLayer property on the layer object? ... View more

Using the Catalog View in ArcGIS Pro, you can drag and drop a feature class from one gdb to another and it will also copy the relationship class and related feature class/table. It only does the direct relationships though. Grandchild relates are ignored so you'll have to copy those separately or script it with Python to walk through all the relationships of the input feature class. ... View more

CreateDatabaseConnectionString() only connects to an edbms, not a file geodatabase. Therefore, CreateFileGDB() doesn't accept a database connection string; the parameters are for an output folder and name. I see you've also included a code snippet for Buffer. Is there something else you're trying to do? ... View more

Then add an input parameter (DEWorkspace) and have the user set the database connection manually to whatever they want. ... View more

If everyone is using the same database connection and it's not changing often, maybe you can create the database connection in the script when it's run? Just output to a temp directory that will get cleaned up when the script finishes. Or you can try a database connection string instead of using .sde files. ... View more

Using arcpy.GetParameter() returns the object that was input for that parameter when running the tool; whatever you have set as the parameter datatype. In the case of your tool here, if it isGPFeatureLayer or GPLayer, the return value of GetParameter() will be a Layer object so you'll have access to all that object's properties and methods. connectionProperties, dataSource, longName, or name might be the property you're looking for.   layer = arcpy.GetParameter(0) def main(layer): arcpy.AddMessage(f"connectionProperties: {layer.connectionProperties}") arcpy.AddMessage(f"dataSource: {layer.dataSource}") arcpy.AddMessage(f"longName: {layer.longName}") arcpy.AddMessage(f"name: {layer.name}") if __name__ == "__main__": main(layer)   ... View more

The Query widget in Experience Builder has a spatial filter option. ... View more

Ah, boo. I see what you're saying. Off to Python Ideas! ... View more