1,896 reputation
11438
bio website arabellasmusings.wordpress.co…
location South Africa
age 25
visits member for 2 years, 5 months
seen 2 days ago

I have a Bachelor of Science in Applied Geoinformatics, with my main areas of study being Geography and Environmental Studies, GIS, Computer Science and Information Systems. I have always had a passion for computers and geography, so studying and working in the GIS field has given me the best of both worlds.

My questions/answers will be written in South African (UK) English - please do not "correct" my spelling.


Jul
9
revised Set Data Driven Scale from Arcpy
fixed typo in code
Jul
6
comment How to define coordinate system and geographic transformation for a CAD drawing?
possible duplicate of http://gis.stackexchange.com/questions/29386/trouble-when-georeferencing-cad-fi‌​les-in-arcmap/29396#29396
Jul
3
comment How to read an Excel sheet in ArcPy script
I have found openpyxl to be very useful as well for reading in and manipulating Excel sheets in conjunction with arcpy.
Jul
3
comment How to read an Excel sheet in ArcPy script
I've found using the format xls=r"E:\123.xls\Sheet1$" to be fairly dodgy - sometimes it works, sometimes it doesn't (I've tried it on two copies of the same workbook - it worked for the other one, the script crashed with "does not exist" on the other).
Jun
28
comment Using Value from Iterate Feature Selection to Calculate Field in ArcMap 10.1 ModelBuilder
Value should be set as a precondition to Calculate Value. This ensures that the expression is constructed after the current value is updated, so the connector between Value and Calculate Value should be a dotted line. You can then fill in the Python code.
Jun
27
answered Using Value from Iterate Feature Selection to Calculate Field in ArcMap 10.1 ModelBuilder
Jun
25
awarded  Notable Question
Jun
20
comment how to remove underscore from filename in directory using modelbuilder
@galindo If you used PolyGeo's string replacement in the Calculate Value tool, then your parsed_filename contains the new shp name without underscores.
Jun
20
comment how to remove underscore from filename in directory using modelbuilder
@PolyGeo I meant that if the recursive checkbox is ticked, the Collect Values is not necessary because it will iterate over each shapefile anyway, therefore Copy Features will run for each iteration and copy each shp.
Jun
19
answered how to remove underscore from filename in directory using modelbuilder
Jun
19
comment how to remove underscore from filename in directory using modelbuilder
I would suggest using Copy Features instead, as the OP would like to copy the shapefiles over to a new folder.
Jun
12
comment Export selected converted geotagged photo points to a new feature class
I was manually selecting the points because visually I had to spread them also evenly across my study area, and I also had to check the photo quality before selecting the point, so I just did a normal export. Afterwards I tried a combo of joining to the attachment table/copying the table over, both of which did not work (wasn't really expecting it to). I will try the Select with a few test points now.
Jun
11
comment Export selected converted geotagged photo points to a new feature class
I've added my workaround below, though I would still like to know if there is a better way to do this.
Jun
11
answered Export selected converted geotagged photo points to a new feature class
Jun
11
asked Export selected converted geotagged photo points to a new feature class
Jun
11
awarded  Notable Question
Jun
5
awarded  Popular Question
Jun
3
comment Trigger a python script to run after a row is added to the feature class
@blah238 agreed.
Jun
3
accepted Trigger a python script to run after a row is added to the feature class
Jun
3
comment Trigger a python script to run after a row is added to the feature class
I like the idea of a script checking the flag status before running the other tools. I think I will go with the idea of running the script more frequently (say, once every 2 hours instead of only once a day), and the check will prevent it from running the entire script unnecessarily.