858 reputation
26
bio website
location
age
visits member for 2 years, 8 months
seen 2 days ago

2d
answered Update Cursor with Date Issue
Jun
23
comment If then statement in model builder
You don't say which version of ArcGIS, but it sounds like you could make use of the Join Field tool here (or Add Join, Calculate Field, Remove Join): desktop.arcgis.com/en/desktop/latest/tools/… Usually, I'd use cursors for this, but you said you needed a 'modelbuilder' solution.
Jun
5
revised How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
sorry, never used the hyperlink editor tool...took me a bit, but got it rigged correctly, thank you.
Jun
5
answered How to export tables to Excel from ArcGIS 10.1 using the xlsxwriter python module?
Jun
5
comment Arcpy strip '{ and ]' from list return
Not sure why you have brackets in the first place, but if you're sure you'd like to strip the first and last characters, Python can 'slice' a string, as in [1:-1].
Jun
2
comment How to Remove Multiple Labels for Stacked Points? ArcGIS 10.2.2?
My sol is a variation of FelixIP's...just in a separate table. Labeling is of course based on a join...probably slows things a little for the service, but I have something similar that seems to perform fine for a moderate number of records.
Jun
2
answered How to Remove Multiple Labels for Stacked Points? ArcGIS 10.2.2?
Jun
1
revised Ratio policy for Intersect in ArcGIS Online?
added 147 characters in body
Jun
1
answered Ratio policy for Intersect in ArcGIS Online?
May
31
awarded  Critic
May
31
comment Attribute field based off intersecting polygon
No, shouldn't be a problem...notice the sel by loc line using the bookmark extent geometry. The OP wants to list all intersecting zip code features and add it to the output. The search cursor honors the sel by loc, so that's correct. It's up to the OP to have bookmarks with reasonably limited extent to prevent a case as you mention.
May
31
comment Attribute field based off intersecting polygon
Incidentally, you should be able to shorten the lines generating points, such as "array.add(arcpy.Point(bkmk.extent.XMin, bkmk.extent.YMin))" to "array.add(bkmk.extent.lowerLeft)", etc., as these statements directly return a point obj for the array.
May
31
comment Attribute field based off intersecting polygon
What have you done to fix the problem? Is your destination field, ZipCode, the proper type and of adequate length? Have you inserted a print statement to 'see' what the zipCode var holds before the insert?
May
31
revised Attribute field based off intersecting polygon
the resultant string is actually also an iterable sequence, but is nonsense.
May
31
answered Attribute field based off intersecting polygon
May
31
comment Attribute field based off intersecting polygon
Check the zipCode variable with a print or AddMessage statement to make sure you're getting what you expect to use with your cursor...also check the size of the field.
May
31
comment Attribute field based off intersecting polygon
Looks like you've got 'zipCodes' and 'zipCode' mixed up...do you mean to insert 'zipCode'?
May
27
comment Update Data Driven Pages Index layer via Python
Curious, maybe I'm missing something, but if the schema isn't anything unexpected to confound the indexing as DDP is expecting, then why can't you simply replace the dataSource instead of all the layer obj manipulations?
May
11
answered Combo box in python add-in for Arc - keep selected value visible
Apr
20
comment Add layer to mxd files ignoring specific item- arcpy
If you don't need case sensitivity and specifically want to exclude 'land use', then instead of Alex's "if 'land use' not in mxd", you could use: if os.path.splitext(mxd.lower())[0] != 'land use'