Latest Contributions by DougMerrick

Sorry, I am using ArcMap 10.3.1. I have used a double concatenation string in python to catch 99.9% of my lookups, first using two fields against the lookup (for a general lookup), and then a 3 field lookup for specific lookups in the table. In the lookup table I have a full look up reference (Utility-Type-Material-Diameter --> Water-Pressure Main-PVC-100) but I also have partial references (Water-Pressure Main-PVC-), so using a python dictionary to input a unit rate I only use the Type and Material, then I use Type, Material, and Diameter. After the rates are in I multiply against the length. Its not a perfect system but it allows for any diameters not found in the lookup table per type and material to be given a rate. The attached text file using python  ... View more

Thanks for catching that Richard, I am amazed at how fast the python code works. ... View more

I am having trouble  using the example for "Creating a Multi-Field Python Dictionary Key to Replace a Concatenated Join Field:" I have replaced with source/update feature classes and field but when I try to run the script I get the error message: Parsing error SyntaxError: invalid syntax (line 23) This is line          if keyValue in valueDict:   I am unable to discern what the problem is with the line of code. from time import strftime print "Start script: " + strftime("%Y-%m-%d %H:%M:%S") import arcpy sourceFC = r"C:\Users\user\Desktop\test.gdb\Repl_Cost" sourceFieldsList = ["WPP_TYPE", "MATERIAL", "DIAMETER", "Unit_Rate"] # Use list comprehension to build a dictionary from a da SearchCursor where the key values are based on 3 separate feilds valueDict = {str(r[0]) + "," + str(r[1]) + "," + str(r[2]):(r[3:]) for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)} updateFC = r"C:\Users\user\Desktop\test.gdb\WPP" updateFieldsList = ["Asset_Type", "EXTG_Material", "Diameter", "Repl_Cost"] with arcpy.da.UpdateCursor(updateFC, updateFieldsList) as updateRows: for updateRow in updateRows: # store the Join value by combining 3 field values of the row being updated in a keyValue variable keyValue = updateRow[0]+ "," + str(updateRow[1]) + "," + str(updateRow[2] # verify that the keyValue is in the Dictionary if keyValue in valueDict: # transfer the value stored under the keyValue from the dictionary to the updated field. updateRow[3] = valueDict[keyValue][0] updateRows.updateRow(updateRow) del valueDict print "Finished script: " +strftime("%Y-%m-%d %H:%M:%S") ... View more

I was able to get this to work on local data, but pointing the fc to the specific feature class in the versioned ArcSDE environment was proving troublesome. So I went with the solution I detailed above. Thanks though ... View more

I looked at that before realizing that by using a python script to run the model itself would reduce the coding headache significantly. The python script to run the model can be found here http://joelmccune.com/run-models-as-scheduled-tasks/ When making the model, add the data directly from the source (ie. NCGIS.GIS.UtilityMain instead of from the table of Contents-Utility Main). ... View more