8,833 reputation
131101
bio website StephenLead.com
location Sydney
age
visits member for 3 years, 10 months
seen 43 mins ago

1d
comment Avoiding Python version confusion when using IDLE with ArcGIS Pro and rest of ArcGIS for Desktop?
PythonWin also has great debugging capabilities, including a handy Watch window which lets you quickly see multiple variables' values
1d
answered Avoiding Python version confusion when using IDLE with ArcGIS Pro and rest of ArcGIS for Desktop?
1d
comment How to write to a single table via Python multiprocessing
@Luke thanks, multiprocessing.Lock() works. But it seems to remove any benefits of multiprocessing as it creates a bottleneck. I guess the whole approach is flawed, as per Michael's original comment which started this whole exploration!
1d
comment How to write to a single table via Python multiprocessing
Thanks for the tips - not bad for your first multiprocessing script :) I think the problem only occurs when multiple processes try to access the insertCursor simultaneously, which doesn't happen in your simple script. If I replace your bList with the larger list generated by loading all the cities (for city in sCursor: bList.append([outTblName, city[0], city[1]]), I get the same result as my original script. That is, only around 450 of the original 593 cities are added.
1d
comment How to write to a single table via Python multiprocessing
@MichaelMiles-Stimson how can I detect when the whole process is finished, so I can append the tables? If I include print("finished") indented by one tab (same level as the with arcpy.da.SearchCursor...) this is the first (not last) thing I see.
1d
comment How to write to a single table via Python multiprocessing
I also tried calling the function recursively in the case of errors - still no dice. I guess creating multiple tables and appending them is the best workaround
1d
revised How to write to a single table via Python multiprocessing
added recursive call within the doProcess loop
1d
comment Can multiprocessing with arcpy be run in a script tool?
@MichaelMiles-Stimson I just posted a question asking how to handle multiple insert cursors ;)
1d
asked How to write to a single table via Python multiprocessing
2d
reviewed Looks OK Rename layers with script
Mar
27
comment arcgis server performance comparison
Wait, is she really downloading 1.4Gb of data in a WFS request? I'd hesitate before sending that via FTP
Mar
27
comment arcgis server performance comparison
Also, I think you've referenced the exact blog post that the question says is outdate
Mar
26
reviewed No Action Needed Publishing map services in GeoServer like ArcGIS for Server does?
Mar
26
reviewed Reviewed No legend showing at all in ArcGIS Server print task (MapExport)
Mar
25
reviewed No Action Needed Create a specific number points that are equidistant from each other and a constraining polygon
Mar
25
reviewed Reviewed File Geodatabase API .NET Wrapper: How to determine if Table/Feature Class Is Locked?
Mar
24
reviewed Approve climate tag wiki excerpt
Mar
20
accepted How to use OR in a CON statement, in the ArcGIS Raster Calculator?
Mar
19
reviewed Reviewed How to calculate distances between several points from each point of my shape file?
Mar
19
comment How to calculate distances between several points from each point of my shape file?
or do you mean to calculate the distances along the road network?