Latest Contributions by AnthonyCheesman1

I would LOVE it if I was able to edit gdb (aspatial) tables using the Attribute Editor option in the Editor toolbar. It doesn't happen often, but there are certain projects where I need to maintain aspatial data, and as it stands this is an awkward thing to do, as I need to edit each record / attribute individually in the attribute table view. The ability to edit using Attribute Editor would mean that I could quickly and consistently apply the same attribute to a number of records, and the transposed view would mean that I could easily visually validate the updated records.   ... View more

Hi all A theoretical question at this point,  but one I may implement if I can work out a way. I have a custom MXD that is used by non-technical people in the field - basically their only input is to sketch lines on a tablet screen with a stylus. We have an enterprise licence agreement, and have configured our licence server to allow checking out / borrowing of licences for offline use for a period of time (10 days I think). I am wondering, is it possible to script a solution in Python, that would # check if it is running on a borrowed (offline) or network licence # if on a borrowed licence, check the expiry date # if there are less than days to run, return the licence and then re-borrow (basically to reset the clock). If I can get this rolling, I pretty much have a set and forget solution, as I have already scripted a solution to check for network connection and then to sync data with a gdb available on network share. Ideally I could have one script that would automatically execute on machine startup, user then just opens the project and hits the road. ... View more

Good afternoon all Having some issues with the Select By Location function returning an odd error message that I can't shake out. I'm pretty confident it's falling over on the first half of the if..else command. This is in there to differentiate between features which need to be checked with a buffer distance and those that don't (this bit of code will be iterated through all the features in a dataset individually). Code (or snippets of): sqlquery = OIDFieldName + "=" + str(oid) dataset_tocheck_lyr = arcpy.MakeFeatureLayer_management(dataset_tocheck, "dataset_tocheck_lyr", "\"sqlquery\"") themelocation_lyr = arcpy.MakeFeatureLayer_management(themelocation, "themelocation_lyr") #create temp layer of theme location bufferdist = str(int(overlayfeature.DIST)) + " Meters" . . .                                     if int(overlayfeature.DIST) == 0:                     arcpy.SelectLayerByLocation_management(themelocation_lyr, "INTERSECT", dataset_tocheck_lyr, "","NEW_SELECTION")                     output_text.write("Buffer is zero, not factoring into SBL\n\n")                 else:                     arcpy.SelectLayerByLocation_management(themelocation_lyr, "INTERSECT", dataset_tocheck_lyr, "\"bufferdist\"", "NEW_SELECTION")                     output_text.write("Buffer is not zero, factoring additional string into SBL\n\n") Error: Traceback (most recent call last):   File "C:\Python26\ArcGIS10.0\Lib\site-packages\Pythonwin\pywin\framework\scriptutils.py", line 326, in RunScript     exec codeObject in __main__.__dict__   File "U:\PythonValuesChecking\Python Scripts\ValuesChecker.py", line 74, in <module>     arcpy.SelectLayerByLocation_management(themelocation_lyr, "INTERSECT", dataset_tocheck_lyr, "","NEW_SELECTION")   File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\management.py", line 4381, in SelectLayerByLocation     raise e ExecuteError: ERROR 999999: Error executing function. An invalid SQL statement was used. An invalid SQL statement was used. An invalid SQL statement was used. An invalid SQL statement was used. Failed to execute (SelectLayerByLocation). This has thrown a few other problems at me, which I have so far been able to solve, but this one has got me stuffed. Any thoughts? ... View more

Hello Caution... Python rookie here. I am sure this will be a very easy answer, but for the life of me I can't figure it out. I am trying to write an iterator that will cycle through the features within a feature class, checking each of them against a values layer. I have almost worked out how to run the iteration by identifying the OID field and the number of features, and then run a while: loop, but I have struck a problem in creating the temporary layer that will house the single feature for checking. Code below: # new code using OID and while loop: num_feats = int(str((arcpy.GetCount_management(dataset_tocheck)))) #returns number of features in dataset to check. Initial result is type RETURN, covert to STRING and then to INTEGER. descFC = arcpy.Describe(dataset_tocheck) #set descFC variable for dataset to check OIDFieldName = str(descFC.OIDFieldName) #find OID fieldname of dataset to check, convert to STRING oid = 0 #create OID variable for WHILE loop arcpy.MakeFeatureLayer_management(dataset_tocheck,"dataset_tocheck_lyr") #make feature layer from feature class while oid < num_feats: #create WHILE loop for OID in [0, num_feats]     dataset_tocheck_subset = arcpy.SelectLayerByAttribute_management("dataset_tocheck_lyr", "NEW_SELECTION", OIDFieldName = oid)     oid = oid + 1 The issue I am striking is using the variables OIDFieldName and oid in the SelectLayerByAttribute function. I am trying to use variables as I want to make this code as portable as possible and once it is running, assemble into a tool for corporate deployment. Error being returned: Traceback (most recent call last):   File "C:\Python26\ArcGIS10.0\Lib\site-packages\Pythonwin\pywin\framework\scriptutils.py", line 326, in RunScript     exec codeObject in __main__.__dict__   File "U:\PythonValuesChecking\Python Scripts\ValuesChecker.py", line 70, in <module>     dataset_tocheck_subset = arcpy.SelectLayerByAttribute_management("dataset_tocheck_lyr", "NEW_SELECTION", OIDFieldName = oid) TypeError: SelectLayerByAttribute() got an unexpected keyword argument 'OIDFieldName' Am I able to use variables in this manner? What am I doing wrong? ... View more

Good morning I am currently working on generating a very large map (5 metres wide x 2.5 tall) to be displayed on a wall. Due to system limitations, I have generated the map as a number of tiles, with the intention of stitching these tiles together using Adobe Illustrator or similar prior to outsourcing the printing (a technique that has worked for me in the past). To speed up this process, I was wondering if it was possible to access / use the embedded georeferencing within the pdf tiles in Illustrator to help allign and stitch the tiles? I am not at all familiar with Illustrator (have outsourced this component of the job) but am wondering if anyone is aware of a potential solution. Cheers Anthony ... View more