Latest Contributions by shildebrand

Has anyone had any problems getting the trace tool to actually trace features?  I have a layer of parcels that I want to trace and a layer of subdivisions that I want to create by tracing parcels.  Usually you just click the layer you want to trace and it starts tracing.  Anyone else having similar problems  The two layers are selectable and both have snapping enabled, but nothing traces once you start tracing.  Any ideas or troubleshooting steps out there?   ... View more

Does anyone know if there is a way to create annotation from the labels of a specific layer and "store them in the map" like we could do in arcmap?  It looks like you can only convert the labels for everything in the map but not a specific layer.  I would like to just create annotation for a small area and be able to move it around like text in a layout. ... View more

Does anyone have any recommendations for best python IDE's that are compatible with ArcGIS?  I'm looking for something that has line numbers and good debugging tools.  Something better than the default IDLE program that is installed already with ArcGIS.  We thought that PyScripter would be a good option, but it appears that it is a malicious program.  I appreciate any direction you can provide. ... View more

I am trying to automate a process to populate a field in a point feature class with the name of district (a polygon layer) that it falls inside using python.  Ideally this script would only populate the points that have NULL district names.  I'm thinking this may be done programmatically using the select by attribute, select by location, and calculate field functions? If someone could point me in the right direction, that would be much appreciated! ... View more

Hi everyone, I am trying to append multiple personal geodatabase tables to a 2nd stand-alone personal geodatabase table using a python script.  The idea here is that the user would select a workspace folder that has multiple personal geodatabases (.mdb's) that each have tables named "Valve", "Hydrant", and "Cannot_Locate_Valve".  The script would then create a new file geodatabase ("CombinedData.gdb") and import an .xml file that has the following two tables: "Daily_Valve" and "Daily_Hydrant".  The script will then append all tables named "Valve" or "Cannot_Locate_Valve" into the just created "Daily_Valve" and append all tables named "Hydrant" into the "Daily_Hydrant" table.  The screenshot below shows the directory structure that I am referring to.  Can anyone lead me in the right direction on this? import arcpy from arcpy import env import arcpy.da as da import os #Set Workspace workspace = arcpy.GetParameterAsText(0) #Create .mdb to Hold Combined Valve & Hydrant Data target_geodatabase = arcpy.CreateFileGDB_management(workspace, "CombinedData.gdb") #Load Schema arcpy.ImportXMLWorkspaceDocument_management (target_geodatabase, r"W:\Projects\KansasCityMO\Valve And Hydrant\Data\Databases\KCMO_DAILY_FILE.xml", "SCHEMA_ONLY") #Search for Valve & Hydrant Tables and Append to Combined Daily Tables for dirpath, dirnames, filenames in da.Walk(workspace, datatype="Table"):    for filename in filenames:       if filename == "Valve" or "Cannot_Locate_Valve":          arcpy.Append_management(os.path.join(dirpath, filename), target_geodatabase, "TEST", "", "")       elif filename == "Hydrant":          arcpy.Append_management(os.path.join(dirpath, filename), target_geodatabase, "TEST", "", "") ... View more

Does anyone have a script that will download attachments from an sde related table? Ideally the script allow the user to download only the attachments related to a subset of features selected from the original feature class.  For example, only download the attachments related to records in the related feature class where "PROJECT" = \'PROJECT NAME\'.  I would also like the script to rename to exported files to the ID of the features class + A.  For example, feature ID 1234 would export attachments 1234A.jpg and 1234B.jpg.  Here's what I have written so far: import arcpy, os from collections import defaultdict inFC = r'Database Connections\LDI_COMPREHENSIVE_WEB_DB.sde\LDI_COMPREHENSIVE_WEB.SDE.WebCollection\LDI_COMPREHENSIVE_WEB.SDE.SurveyPoints' # Feature Class inTable = r'Database Connections\LDI_COMPREHENSIVE_WEB_DB.sde\LDI_COMPREHENSIVE_WEB.SDE.SurveyPoints__ATTACH' # Attachment table fileLocation = r'W:\Projects\Path' # Output location # Get dictionary of ObjectID and associated field value myFeatures = dict() with arcpy.da.SearchCursor(inFC, ['GlobalID', 'Transferred_FacilityID'], '"PROJECT" = \'PROJECT NAME\'') as cursor: for row in cursor: myFeatures[row[0]] = row[1] # Create dictionary to count usage of the field value (to increment files) valueUsage = defaultdict(int) # Loop through attachments, incrementing field value usage, and using that # increment value in the filename with arcpy.da.SearchCursor(inTable, ['DATA', 'ATT_NAME', 'ATTACHMENTID', 'REL_GLOBALID']) as cursor: for row in cursor: if row[3] in myFeatures: attachment = row[0] fieldValue = myFeatures[row[3]] # Value of specified field in feature class valueUsage[fieldValue] += 1 # Increment value filename = "{0}_{1}".format(fieldValue, valueUsage[fieldValue]) # filename = FieldValue_1 output = os.path.join(fileLocation, filename) # Create output filepath open(output, 'wb').write(attachment.tobytes()) # Output attachment to file del row del filename del attachment Any help with this would be greatly appreciated! ... View more