Latest Contributions by DonMorrison1

‎01-12-2022

You can use the python '_file_' variable to get the path to your .py file. From there you can back it up to the root of your toolbox. Here is an example of how I do it: path_code_base = os.path.normpath(__file__ + '/../../../../')

‎01-11-2022

I took at look at one of the REST endpoints behind one of the layers ('Registered Two Unit Dwellings') and it did not have the EXTRACT capability enabled. I suspect this is why it is not working for your.

‎01-09-2022

I can't easily recreate the ExecutionError exception but one thing I would try is to see what you get with the exception's 'args' property, which will give you the arguments passed in by the ESRI code when the exception was created. try: my code here... except arcpy.ExecuteError as ex: print (str(ex.args)) # Maybe the specific error code is one of the args ?????? e = sys.exc_info()[1] print(e) except: handle of other errors

‎12-16-2021

This may not be what you are looking for, but one way to get information on a hosted map service's tiles is using the REST apis - specifically this one. If you look at the response JSON's "lodInfos" section you can see which sets of tiles have been built. I've never worked with .rrd or .ovr files. Maybe there is a way to do this via a python API, but I'm not sure.

‎12-09-2021

I recently stumbled over this also with SelectLayerByAttribute. I found if I created a layer using MakeFeatureLayer and passing that into SelectLayerByAttribute instead of passing in the feature class, it ran many times faster.

‎12-08-2021

I would simply dump out the variables and see what they look like - something like this (this is in a python toolbox?) arcpy.AddMessage("search_string: " + search_string) arcpy.AddMessage("whereClause: " + whereClause)

‎12-08-2021

Have you tried to explicitly convert the string to a double before writing it? For instance in your 2nd example: row[1] = float(row[0])

‎11-18-2021

You can get that from the "Derived Output" which is described in the documentation. Here is a snippet of my code that gets the item of the published image service rsp = arcpy.UploadServiceDefinition_server(<sd_output_filename>, "HOSTING_SERVER") gis_item = gis.content.get(rsp[2])

‎11-17-2021

Right, I see the same behavior when I upload to ArcGIS Online as a feature layer, and work around it by moving it to the right folder after the publish (See the code below). You may have a make some tweaks if publishing to a portal or publishing a map image layer. rsp = arcpy.UploadServiceDefinition_server(<sd_filename>, "HOTING_SERVER") gis_item = gis.content.get(rsp[3]) gis_item.move(<destination_folder>)

‎11-14-2021

I found an acceptable workaround for this by writing out the rows to insert into a temporary in-memory table then appending the in-memory table to the "intermediate table". At least that way I don't have to create an InsertCursor for every record that I want to add.

‎11-11-2021

I wasn't able to access the layer from arcpy - I'm not sure why. But an alternative is to use the ArcGIS API for python. The code to access your object would look like this ('255af1ceee844d6da8ef8440c8f90d00' is the ArcGIS item ID for the sentinal image layer): from arcgis.gis import GIS gis = GIS(url=None, username=<my_id>, password=<my_pw>) item = gis.content.get('255af1ceee844d6da8ef8440c8f90d00') record = item.layers[0].query(where="objectid=23156221").to_dict()['features'][0] print (record)

‎11-11-2021

I'm a big believer in using python dicts to optimizing the use of cursors, especially when the access patterns are more random than sequential. However in Chase's case it seems that using the python dict makes it more complicated than it needs to be. Unless there is a big performance advantage using the dicts (and there might very well be), this is how I would do it. import arcpy relTable = r"C:\Path\RelateTable" updateFC = r"C:\Path\UpdateFeatureClass" with arcpy.da.UpdateCursor(updateFC, ["FacilityID", "LatestStatus"]) as updateRows: for f_id, old_status in updateRows: with arcpy.da.SearchCursor(relTable, ["Status"], where_clause="FacilityIDRel=%s" % f_id, sql_clause=(None, "ORDER BY last_edited_date DESC") ) as searchRows: for (new_status,) in searchRows: updateRows.updateRow(f_id, new_status) break

‎11-10-2021

You should be able to get rid of your loops and let the python Multiprocessing Pool manage running the body of the loop. You have to prepare a list of "parameter sets" that the Pool will use to invoke the body whenever a processor becomes available. In your case the list would look something like this (no guarantee on the exact syntax) parm_list = [('x','a'), ('x','b'),('x','c'),('y','a'),('y','b'),('y','c'),('z','a'),('z','b'),('z','c')] then your body would be encapsulated in a function something list this def my_body (parm): outNALayerName = parm[0] chunk = parm[1] ..... and you would call it like this p = multiprocessing.Pool(<number of processors>) p.map(my_body, parm_list) p.close() You have to be careful about lock conflicts, for instance if you use duplicate names for your temporary files or try have multiple processes updating the same file.

‎11-10-2021

Very good. If I recall correctly, I opted for the JSON route only because the python code seemed simpler doing the updates that way versus navigating through the dom.

‎11-10-2021

Hi Heiko. From python you can access the record data using cursors. The "input table" will be URL of the ArcGIS online item (in your case the hosted feature layer created from the uploaded file geodatabase).

Online Status	Offline
Date Last Visited	‎11-28-2025 04:52 AM

My Ideas

Latest Contributions by DonMorrison1

Re: Get path to script tool inside of a toolset?

Re: Extracting Shapefile or geojson from ArcGIS web map

Re: Handle specify error in arcpy

Re: how to know if a raster dataset has or not has pyramid?

Re: Calls to arcpy.management tools get progressively slower as they are called multiple times within a script

Re: Pass multiple parameters into script

Re: copying values from string type column to double column

Re: How to access the ID of a published service on ArcGIS Portal?

Re: How to set PortalFolder when publishing via arcpy.sharing?

Re: Inserting record in M:N relationship table "Cannot reset foreign key values for an existing relationship row"

Re: Use Sentinel-2A images with Python (ArcPy)

Re: Turbo Charging Data Manipulation with Python Cursors and Dictionaries

Re: Multiprocessing a nested loop

Re: How to set Instance Type to Dedicated with 1 and 2 Min/Max instances in Service Definition draft?

Re: Add rows to ArcGIS Online File Geodatabase from python

MakeFeatureLayer fails with python multiprocessing

Re: MakeFeatureLayer fails with python multiproces...

Re: Looking for a code example of using Python RES...

Re: Looking for a code example of using Python RES...

How to get list of keys from Arcade Dictionary