Latest Contributions by MitchHolley1

You could build a dictionary of both geometries and compare them with arcpy.  However, I don't know if this will be any faster... especially connecting to a non-local database. I would test this on scratch data first. import arcpy #datasources polygon = r'path\to\polygon' point = r'path\to\point' #cursor objects polyCur = arcpy.da.SearchCursor(polygon, ['SHAPE@','PlanRefID']) pointCur = arcpy.da.SearchCursor(point, ['SHAPE@','OBJECTID'],"PlanRefID IS NULL") #dictionary to store geometry:value pairs for comparison poly_dict = {row[0]:row[1] for row in polyCur} point_dict = {row[0]:row[1] for row in pointCur} #populated match dictionary of polygon.PlanRefID, if point geom is within poly geom #see here: http://desktop.arcgis.com/en/arcmap/10.3/analyze/arcpy-classes/point.htm match = {} for pnt in point_dict: for poly in poly_dict: if pnt.within(poly): ID = point_dict[pnt] value = poly_dict[poly] match[ID] = value #could add qry to make it run faster.. may not work with different data formats (.shp) qry = "OBJECTID IN {}".format(tuple(k for k in match)) #iterate over points w/ qry and update PlanRefID if OBJECTID is found in dictionary with arcpy.da.UpdateCursor(point, ['OBJECTID','PlanRefID'],qry) as cursor: for row in cursor: if row[0] in match: row[1] = match[row[0]] cursor.updateRow(row) del cursor ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Lastly, I created a similar ESRI Script Tool that has worked successfully with ArcMap 10.4.  I call is Spatially Append Attributes. ... View more