Latest Contributions by CCWeedcontrol

I have the following code and i am getting an error on line 76 with the arcpy.da.UpdateCursor that update feature attributes to proper case . I am unsure why. I would really appreciate some help please?   Thanks.   # Import arcpy module import arcpy from arcpy import env # Allow overwrite arcpy.env.overwriteOutput = True # Script user input parameters polygonLayer = "TaxParcels1" #Taxparcels pointLayer = "CCAP8" #Point Layer arcpy.env.workspace = r"Database Servers\15_SQLEXPRESS.gds\CCAPTEST (VERSION:dbo.DEFAULT)" #arcpy.env.workspace = r"Database Servers\15_SQLEXPRESS.gds\TEST (VERSION:dbo.DEFAULT)" poly = "ACCOUNT_1" Pnt = "Account" sjpoints = "In_memory\sjpoints" parcelsCount = int(arcpy.GetCount_management(pointLayer).getOutput(0)) dsc = arcpy.Describe(pointLayer) selection_set = dsc.FIDSet if len(selection_set) == 0: print "There are no features selected" elif parcelsCount >= 1: #Run the Spatial Join tool, using the defaults for the join operation and join type arcpy.SpatialJoin_analysis(pointLayer, polygonLayer, sjpoints) # define the field list from the spatial join sourceFieldsList = ["TARGET_FID", poly,"SiteAddress",'SiteNum_1', 'SiteStreet_1','SiteNumSfx_1','Predir_1','SiteStreet_1','Postdir_1', 'SiteCity_1', 'SiteZIP_1', 'OwnerName_1', 'StreetType_1'] #,'StreetType_1' # define the field list to the original points updateFieldsList = ["OID@", Pnt,"SiteAddres", 'SiteNum', 'StreetName','SiteNumSfx','Predir','SiteStreet', 'Postdir', 'SiteCity', 'SiteZip', 'OwnerName', 'StreetType'] #, 'StreetType' # Start an edit session. Must provide the workspace. edit = arcpy.da.Editor(arcpy.env.workspace) # Edit session is started without an undo/redo stack for versioned data # (for second argument, use False for unversioned data) edit.startEditing(True) # Start an edit operation edit.startOperation() manualFields = ["FacltyType","GIS_STEW", "StructType", "Verified", "Status", "StructCat", "APA_CODE",'StreetName'] #,'StreetName' with arcpy.da.UpdateCursor(pointLayer, manualFields) as rows: for row in rows: row[0] = ("Single Family Home") row[1] = ("Canyon") row[2] = ("Primary, Private") row[3] = ("Yes, GRM, TA") row[4] = ("Active") row[5] = ("Residential") row[6] = ("1110") row[7] = (sourceFieldsList[4] + " " + sourceFieldsList[12]) rows.updateRow(row) del row del rows # populate the dictionary from the polygon valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints, sourceFieldsList)} with arcpy.da.UpdateCursor(pointLayer, updateFieldsList) as updateRows: for updateRow in updateRows: keyValue = updateRow[0] if keyValue in valueDict: for n in range (1,len(sourceFieldsList)): updateRow = valueDict[keyValue][n-1] updateRows.updateRow(updateRow) del updateRows del updateRow #Update feature attributes to proper case fields1 = ["StreetName", "SiteStreet","SiteAddres","OwnerName","StreetType"]#,'StreetType' with arcpy.da.UpdateCursor(pointLayer, fields1) as cursor: for row in cursor: row[0] = row[0].title() row[1] = row[1].title() row[2] = row[2].title() row[3] = row[3].title() row[4] = row[4].title() cursor.updateRow(row) # Stop the edit operation. #edit.stopOperation() # Stop the edit session and save the changes edit.stopEditing(True) arcpy.RefreshActiveView() #arcpy.Delete_management(sjpoints) ... View more

currently have a code that i would like to update a certain field based off of two other fields but i am getting a error. Error:TypeError: list indices must be integers, not str. on line : row[7] = (sourceFieldsList['SiteStreet_1'] + " " + sourceFieldsList['StreetType_1']) The only difference in the fields is that some have different lengths, the fields are 'String' fields so i am not sure what's going on other then the lengths. Do the fields have to be the same lengths? Any help would be great, thanks! # define the field list from the spatial join     sourceFieldsList = ["TARGET_FID", poly,"SiteAddress",'SiteNum_1', 'SiteStreet_1','SiteNumSfx_1','Predir_1','SiteStreet_1', 'Postdir_1', 'SiteCity_1', 'SiteZIP_1', 'OwnerName_1','StreetType_1']    #     # define the field list to the original points     updateFieldsList = ["OID@", Pnt,"SiteAddres", 'SiteNum', 'StreetName', 'SiteNumSfx','Predir','SiteStreet', 'Postdir', 'SiteCity', 'SiteZip', 'OwnerName' 'StreetType']         # Start an edit session. Must provide the workspace.        edit = arcpy.da.Editor(arcpy.env.workspace)          # Edit session is started without an undo/redo stack for versioned data        #  (for second argument, use False for unversioned data)        edit.startEditing(True)          # Start an edit operation        edit.startOperation()        manualFields =  ["FacltyType","GIS_STEW", "StructType", "Verified", "Status", "StructCat", "APA_CODE",'StreetName'] #]                with arcpy.da.UpdateCursor(pointLayer, manualFields) as rows:               for row in rows:                   row[0] = ("Single Family Home")             row[1] = ("Canyon")             row[2] = ("Primary, Private")                       row[3] = ("Yes, GRM, TA")                       row[4] = ("LM")             row[5] = ("Residential")                       row[6] = ("1110")             row[7] = (sourceFieldsList['SiteStreet_1'] + " " + sourceFieldsList['StreetType_1'])             rows.updateRow(row) ... View more

I have a script that works good but only if the first letter of the input has the first letter upper case. Currently every road name starts with an upper case letter. How can I format the expression to allow for either upper or lower case inputs.   Thanks. import arcpy  arcpy.AddMessage("Starting")  pu = arcpy.GetParameterAsText(0)  arcpy.AddMessage(pu)  mxd = arcpy.mapping.MapDocument("CURRENT")  df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]  lyr = arcpy.mapping.ListLayers(mxd, "Roads", df)[0] pu = arcpy.GetParameterAsText(0) arcpy.AddMessage(lyr.name)  expression = "FENAME LIKE '%{}%'".format(pu) arcpy.AddMessage(expression)  arcpy.SelectLayerByAttribute_management(lyr,"NEW_SELECTION",expression)  df.extent = lyr.getSelectedExtent()  arcpy.RefreshActiveView()  arcpy.AddMessage("Completed")  ... View more

I have two layers with building footprints I need to update one of them. After merging layers I have some features with an sequential number in the field Bld_ID field but some don't. So i need to update the Bld_ID with sequential number and they start with "Bld": example bld000001, bld00002, bld00003, etc. So some how i need to find the last highest sequential number in the field Bld_ID then add 1 to that and use that to update the buildings i have selected. I have a code i used for something similar but i am running into the an error with this any help would be appreciated: Runtime error Traceback (most recent call last):   File "<string>", line 30, in <module> IndexError: list index out of range import arcpy, sys, re, os  from arcpy import env  import string arcpy.env.qualifiedFieldNames = False      arcpy.env.overwriteOutput = True        Bld = "BuildingFootprints" #target point feature class BldCount = int(arcpy.GetCount_management(Bld).getOutput(0)) dsc = arcpy.Describe(Bld) selection_set = dsc.FIDSet         if len(selection_set) == 0:           print "There are no features selected"               elif BldCount >= 1:     #Gets the highest AddressID and calculates new point to assign new highest AddressID     Bld_list = []          with arcpy.da.SearchCursor(Bld, ["Bld_ID"]) as cursor:              for row in cursor:                  try:                      if "Bld" in row[0]:                          Bld_list.append(int(row[0].strip("Bld")))                     except TypeError:                      pass                  del cursor                    Bld_list.sort()          Bld_ID = Bld_list[-1] + 1          Bld_ID = 'Bld' + str(Bld_ID)     with arcpy.da.UpdateCursor(Bld, "Bld_ID") as rows:               for row in rows:                   row[0] = Bld_ID                         rows.updateRow(row)          del row               del rows ... View more