import arcpy from arcpy import env def sumOwners(): mxd=arcpy.mapping.MapDocument("CURRENT") wrkPath=mxd.filePath[0: mxd.filePath.rfind('\\')] env.workspace=wrkPath+"\\data.mdb" Pclass=wrkPath+"\\data.mdb\\contamination\\parcel" Rtable=wrkPath+"\\data.mdb\\owners2" Prows=arcpy.UpdateCursor(Pclass) Rrows=arcpy.SearchCursor(Rtable) nameLst=[] for i in Rrows: nameLst.append([i.getValue("P_No"),i.getValue("Owner_Name")]) lst=[] s="" for i in Prows: code=i.getValue("Code") for j in nameLst: if code==j[0]: s+=j[1]+"\r" s=s[:-1] i.setValue("Owners", s) Prows.updateRow(i) s=""
Well i spent almost a day but finally i solved the problem with a python script.
Thank you very much. I will give a try.
Hello friends, I used the tool "ArcToolbox>Data Management Tools>Relationship Classes>Table to Relationship Class" to establish a relation (many to many) between land parcels and owners. I already had the intermediate table. The question is how can i make a thematic map that shows the number of owners a parcel has? For example: light blue color=1 owner darker blue=2 owners dark blue=3+ owners Thank you
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.