Latest Contributions by LarryAdgate

#My goal is similar to the thread listed below: #https://community.esri.com/thread/158291 #"I need to move a set of point features based on the XY values from another table linked through table join" #This script works perfectly as long as the feature class with the outdated xy's have no duplicate "PREM_ID" numbers. # A "PREM_ID" number represents a Geocoded address point and its possible to have several of them stacked on top of each other on one parcel. #Unfortunately my outdated xy feature class has a combination of both unique and duplicate PREM_ID numbers and this script will not pass duplicate PREM_ID numbers. #IndexError: list index out of range #Thank You for your assistance, #Larry Adgate import arcpy #input path of gdb where original feature class resides gdb = "C:\\Projects\\MyProject\\Arden.gdb" #input original feature class path with outdated XY (This feature Class has both unique and duplicate "PREM_ID" numbers) basefc = "C:\\Projects\\MyProject\\Arden.gdb\\Arden\\LateralLinesPoints" #input feature class path of points with updated XY (This Feature Class contains only unque "PREM_ID numbers #and not all there numbers can be found in the outdate xy feature class) newfc = "C:\\Projects\\MyProject\\Arden.gdb\\Arden\\CCB_Points" #input field name which has a unique ID to both original and new point feature class field = "PREM_ID" list_idxy = [] with arcpy.da.SearchCursor(newfc, [field, "SHAPE@X", "SHAPE@Y"]) as cur: for row in cur: list_idxy.append(row) i = 0 with arcpy.da.Editor(gdb) as edit: with arcpy.da.UpdateCursor(basefc, [field, "SHAPE@X", "SHAPE@Y"]) as cur: for row in cur: print row if row[0] == list_idxy[0]: row[1] = list_idxy[1] row[2] = list_idxy[2] i += 1 cur.updateRow(row) print "points shifted!" ... View more

#I would really appreciate some help on this: I need to use the Set function on this script to remove all # my duplicates but the InsertCursor refuses to work here. Any Ideas, Thank You- Larry Adgate import arcpy fc1 = "Database Connections\\TaskmasterServer.sde\\sde_gsw.GSW_SDE.CCB_Updates1" fc2= "Database Connections\\TaskmasterServer.sde\\sde_gsw.GSW_SDE.CCB_Data\\sde_gsw.GSW_SDE.Master_CCB_Points" fc3 = "K:\\808 - TariffMaps\\MyResults\\MyTable.dbf" set_one = set(r[0] for r in arcpy.da.SearchCursor(fc1,"PREM_ID")) set_two = set(r[0] for r in arcpy.da.SearchCursor(fc2,"PREM_ID")) print "Items unique to the Primary Field: {}".format(", ".join(sorted(set_one-set_two))) results = set(set_one-set_two) print results cursor = arcpy.da.InsertCursor(fc3, ["result"]) #Below is my error= TypeError: value #0 - unsupported type: set cursor.insertRow([results]) del cursor ... View more

For better maintenance to our Web Map Services, is there a Python Script out there to Reboot our Enterprise Server?  Thanks, Larry Adgate`          ... View more