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
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか?無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.