Vjylku

I have address data that returns many ties when geocoding using a Locator I created. The Locator uses a table that has grouped addresses based on street number ranges, e.g.

|Start_Street_Num | End_Street_Num | St_Name | Grouped_Street_Address | x | y

-----------------------------------------------------------------------------

|100              | 150            | Foo     | 100 Foo                | 1 | 2

|151              | 199            | Foo     | 100 Foo                | 3 | 4

Because of this, there are duplicates in the grouped address column, but I need to keep them because they refer to different (x,y) locations. Just for reference, the (x,y) values here refer to the midpoint of the street. I'm not allowed to consolidate the rows because there could be an intersection separating them.

The input table being geocoded has the actual address and the grouped address, e.g.

|Actual_Address_Num | Actual_Address_Name | Grouped_Address_to_Geocode

----------------------------------------------------------------------

| 123               | Foo                 | 100 Foo

The geocoded spits back this entry as TIED since there are two 100 Foo grouped addresses in the Locator.

Is there a way to do a rematch and have it look at the address number column to match the right range? i.e.

# psudo code logic

for row in table:

    if(Actual_Address_Num >= Start_Street_Num and Actual_Address_Num <= End_Street_Num):

        # match this row with the grouped address

If this is NOT possible, what is a suggested workaround / workflow change I should consider looking into?

What I've tried:

• I found this article about attaching a new locator to the feature class resulting from a geocoding process: https://support.esri.com/en/technical-article/000003504. This seems like I would need to make a whole new Locator and run the geocoding against that Locator, but does not solve my issue with choosing the correct row for ties.


• I see that ESRI has this Rematch function: https://pro.arcgis.com/en/pro-app/tool-reference/geocoding/rematch-addresses.htm. But there does not seem to be a way for me to specify what to rematch against as the only variables are the input FC and an SQL where clause to select the rows you want to be geocoded.


• I saw this post: Programmatically rematch unmatched addresses using a different composite locator. But it doesn't have an answer and I am not using any of ESRI World Geocoding Services.

For Reference:

• Python 2.7.13 win32


• Working out of a File Geodatabase