topic Re: Find matching attributes in Python Questions

Find matching attributes

2Quiker — Sat, 11 Dec 2021 21:22:38 GMT

I am trying to update the points selected features field "Verifi2" with "Match" or "No" based on if the 'SiteAddres' field of the selected feature matches the parcels layer 'SiteAddress' field. I currently have the following code but all of the selected features have "No" in the Verifi2 field. Which is not the case because some of the selected point features SiteAddres does match parcels SiteAddress. I would appreciate some help please.

import arcpy 
from datetime import datetime as d
startTime = d.now()

fc1 = "AddresPointsTest" 
fc2 = "TaxParcels1"

#set up cursors
cursor1 = arcpy.da.SearchCursor(fc1, ["SiteAddres", "Verifi2"])  
cursor2 = arcpy.da.SearchCursor(fc2, ["SiteAddress"])


with arcpy.da.UpdateCursor(fc1, ["SiteAddres", "Verifi2"]) as cursor1:  
     for row1 in cursor1:  
          with arcpy.da.SearchCursor(fc2, ["SiteAddress"]) as cursor2:  
               row2 = cursor2.next()  
               #print row2  
               row1[1] = "Match" if row1[0].lower() == row2[0].lower() else "No"  
               #print row1[2]  
               cursor1.updateRow(row1)  

try:
    print '(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')'

except Exception, e:
    # If an error occurred, print line number and error message
    import traceback, sys
    tb = sys.exc_info()[2]
    print "Line %i" % tb.tb_lineno
    print e.message
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Find matching attributes

MitchHolley1 — Tue, 03 Oct 2017 18:44:50 GMT

Do these two datasets have a unique ID that links them together? If so, you could create a dictionary with ID: Address pairs and use that to search the attribute table. Nested cursors get tricky...

Just to clarify, are you looking for any Addresses in FC1 that are not in FC2?

Re: Find matching attributes

BruceHarold — Tue, 03 Oct 2017 19:40:51 GMT

Hi, see if this tool does what you need:

http://pm.maps.arcgis.com/home/item.html?id=e638afe0695a4ad38388cb8d9b350446

Re: Find matching attributes

2Quiker — Tue, 03 Oct 2017 20:49:08 GMT

Yes they do have a unique ID that links them together. I guess i didn't think this through all the way...hummm

So some parcels have an address point (separate layer) but some address points don't match the parcels(separate layer) site addresses i need to find the ones that match and don't match, but only of the selected features in ArcMap.

Re: Find matching attributes

MitchHolley1 — Sat, 11 Dec 2021 21:22:41 GMT

If you make your Python script able to be consumed with ArcMap (via Script Tool), then it will automatically accept a selection.

What you need to do is:
1.) Build a dictionary of ID: Address pairs
2.) Search feature attribute table for presence of Addresses
3.) Update field based on result from 2

This should get you started.

fc1 = r'complete_path_to_featureClass1'
fc2 = r'complete_path_to_featureClass2'

#build a dictionary of OBJECTID : Address pairs, change OID@ to your uniqueID
addDict = {row[0]:row[1] for row in arcpy.da.SearchCursor(fc1, ['OID@','SiteAddress'])}

#search through fc2 to see if addresses match based on OBJECTID value
#again, change OID@ to your uniqueID
with arcpy.da.UpdateCursor(fc2, ['OID@','SiteAddress','Verifi2']) as cursor:
    for row in cursor:
        if row[0] in addDict:
            if row[1] != addDict[row[0]]: #if the value associated with those ids do not match
                row[2] = 'No'
            else:
                row[2] = 'Match'
            cursor.updateRow(row)
del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Find matching attributes

2Quiker — Sat, 11 Dec 2021 21:22:43 GMT

Hi Mitch.

thank you for the reply and help. I tried the code but i am getting the same results as before.

I select the points in Arcmap and run the code in ArcMap python window. All of the point features have 'No' in the Verifi2 filed.

on line 12 of your code should it be if row[1] != addDict[row[1]] since your comparing the SiteAddress and SiteAddres fields?

Here is the code i am working with.

import arcpy 
from datetime import datetime as d
startTime = d.now()

fc1 = "AddresPointsTest" 
fc2 = "TaxParcels1"

#set up cursors
cursor1 = arcpy.da.SearchCursor(fc1, ["SiteAddres", "Verifi2"])  
cursor2 = arcpy.da.SearchCursor(fc2, ["SiteAddress"])

#build a dictionary of OBJECTID : Address pairs, change OID@ to your uniqueID
#addDict is for the taxparcels
addDict = {row[0]:row[1] for row in arcpy.da.SearchCursor(fc2, ['OID@','SiteAddress'])}

#search through fc2 to see if addresses match based on OBJECTID value
#again, change OID@ to your uniqueID
#UpdateCursor is for the address points
with arcpy.da.UpdateCursor(fc1, ['OID@','SiteAddres','Verifi2']) as cursor:
    for row in cursor:
        if row[0] in addDict:
            if row[1] != addDict[row[0]]: #if the value associated with those ids do not match
                row[2] = 'No'
            else:
                row[2] = 'Match'
            cursor.updateRow(row)
del cursor

try:
    print '(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')'

except Exception, e:
    # If an error occurred, print line number and error message
    import traceback, sys
    tb = sys.exc_info()[2]
    print "Line %i" % tb.tb_lineno
    print e.message‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Find matching attributes

MitchHolley1 — Wed, 04 Oct 2017 15:26:31 GMT

A couple things... do not run this code in the Python executable window inside of ArcMap. Please make this tool a Script Tool. It will be much easier to manage and deploy. Secondly, no... the addDict[row[0]] is correct because you're asking Python to compare the value of the dictionary associated with that ID. Please research dictionaries and script tools. You may want to print the keys and values of the dictionary to make sure it's built properly.

Re: Find matching attributes

2Quiker — Wed, 04 Oct 2017 20:56:50 GMT

I tried your suggestion to put it into a script but i still just get "No" for all the features.

Would it have to do with the fact that the taxparcels address filed are all upper case letters and the points address field are all lower case?

Re: Find matching attributes

MitchHolley1 — Thu, 05 Oct 2017 13:02:12 GMT

Yes... the != operation is a strict comparison. I would include .strip() and .lower() for comparison.

Re: Find matching attributes

2Quiker — Thu, 05 Oct 2017 14:56:57 GMT

tired the following but i get following error:

if row[1].strip().lower() != addDict[row[0].strip().lower()]: #if the value associated with those ids do not match
AttributeError: 'int' object has no attribute 'strip'

if row[1].lower() != addDict[row[0].lower()]:

if row[1].strip().lower() != addDict[row[0].strip().lower()]:

Re: Find matching attributes

MitchHolley1 — Thu, 05 Oct 2017 16:10:44 GMT

if row[1].strip().lower() != addDict[row[0]].strip().lower()

Re: Find matching attributes

2Quiker — Thu, 05 Oct 2017 17:16:01 GMT

I am still getting all 'No'.

Re: Find matching attributes

2Quiker — Sat, 11 Dec 2021 21:22:46 GMT

Looking at my data i noticed that the OID@ on both layers where not matching so i had to change the OID@, my apologies. Once i changed the uniqueID and ran the script i get error.

line 18, in <module>
if [row[1]].strip().lower() != addDict[row[0]].strip().lower(): #if the value associated with those ids do not match
AttributeError: 'list' object has no attribute 'strip'

code

import arcpy 
from datetime import datetime as d
startTime = d.now()



fc1 = r'C:\Temp\TaxParcels1.shp'
fc2 = r'C:\Temp\AddresPointsTest.shp'

#build a dictionary of OBJECTID : Address pairs, change OID@ to your uniqueID
addDict = {row[0]:row[1] for row in arcpy.da.SearchCursor(fc1, ['ACCOUNT','SiteAddress'])}

#search through fc2 to see if addresses match based on OBJECTID value
#again, change OID@ to your uniqueID
with arcpy.da.UpdateCursor(fc2, ['Account','SiteAddres','Verifi2']) as cursor:
    for row in cursor:
        if row[0] in addDict:
            if row[1].strip().lower() != addDict[row[0]].strip().lower(): #if the value associated with those ids do not match
                row[2] = 'No'
            else:
                row[2] = 'Match'
            cursor.updateRow(row)
del cursor

try:
    print '(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')'

except Exception, e:
    # If an error occurred, print line number and error message
    import traceback, sys
    tb = sys.exc_info()[2]
    print "Line %i" % tb.tb_lineno
    print e.message
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Find matching attributes

MitchHolley1 — Thu, 05 Oct 2017 21:08:36 GMT

You need to look up how those functions work...

Re: Find matching attributes

CCWeedcontrol — Thu, 05 Oct 2017 22:56:14 GMT

Sorry, i am not understanding that line. .strip() removes all whitespace and .lower() and lower() method converts all of the characters to lowercase. Not sure why it's given me that error but thank you very much for the assistance.