Latest Contributions by Brian_McLeer

We are changing our production server to have a prefix of 'HV'. I have a folder of MXDs I would like to update to the new server, but I am missing something from my code below. I got my start from https://gist.github.com/davehorsey/d8892b150e61d2e03617.  import arcpy, os path = r"C:\layouts" for fileName in os.listdir (path): basename, extension = os.path.splitext(fileName) # select MXD files that do NOT begin with "Copy_of_" - this # prevents the script from updating files that have already been updated if (extension == ".mxd") and (fileName[:8] != "Copy_of_"): fullPath = os.path.join(path, fileName) mxd = arcpy.mapping.MapDocument(fullPath) print fullPath # update data sources mxd.findAndReplaceWorkspacePaths("Database Connections\\Server Database NT Auth.sde", "Database Connections\\HV_Server Database NT Auth.sde") print "\tUpdated: SDE data sources" # check for broken links brknList = arcpy.mapping.ListBrokenDataSources(mxd) for brknItem in brknList: print "\tCheck: " + brknItem.name + " data source broken" if not brknList: print "\tCheck: no broken data sources" # save a copy of the MXD saveACopy_filename = "Copy_of_" + fileName saveACopy_fullpath = os.path.join(path, saveACopy_filename) mxd.saveACopy(saveACopy_fullpath) print "\tSaved: " + saveACopy_filename del mxd # delete the original MXD arcpy.Delete_management(fullPath) print "\tDeleted: " + fullPath‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I am working on a python script that updates a field titled 'PlanRefID' field in several point feature classes. These are populated based on a 'PlanRefID' field in a polygon feature class. The cursor will loop through and populate the 'PlanRefID' field in the point feature classes (approximately 10) correctly. The issue I am having is that I only want it to update where the PlanRefID IS NULL in my point feature classes. However, it will loop through all records in the polygon feature class, which is taking about 1.5 - 2 hours to run. As the feature classes add more records, the processing time will only increase. I only interested in updating the point features where the PlanRefID IS NULL and referencing the polygons they intersect.  arcpy.MakeFeatureLayer_management("Database Connections\\Server Database OWNER.sde\\Database.OWNER.FeatureDataset\\Database.OWNER.Polygon", "Database_OWNER_Polygon") arcpy.MakeFeatureLayer_management("Database Connections\\Server Database OWNER.sde\\Database.OWNER.FeatureDataset\\Database.OWNER.Point", "Database_Owner_Point", "PlanRefID IS NULL") arcpy.SelectLayerByAttribute_management("Database_Owner_Point", "NEW_SELECTION", "PlanRefID IS NULL") rows = arcpy.SearchCursor("Database_OWNER_Polygon") for row in rows: arcpy.SelectLayerByAttribute_management("Database_OWNER_Polygon", "NEW_SELECTION", "\"OBJECTID\" = " + str(row.getValue("OBJECTID"))) arcpy.SelectLayerByLocation_management("Database_Owner_Point", "INTERSECT", "Database_OWNER_Polygon", "", "NEW_SELECTION") arcpy.CalculateField_management("Database_Owner_Point", "PlanRefID", "'{0}'".format(str(row.getValue("PlanRefID"))), "PYTHON_9.3", "") print "Finished processing " + str(row.getValue("PlanRefID"))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more