I am setting up the data to create a locator. In many places street names, such as, Main Street are common place. In the past, the street name and place name would be used. Now, the Counties have changed this by adding the place name before the street name and not use place name (see table for an example):
| Street name | Place Name |
| Main Street | Zurich |
| Zurich Main Street | |
I work with both addresses as both scenarios are being used in practise. I am interested to hear what the best workflow is; Use in the main table Main Street and use the place name (Zurich) as the primary key, and in the alternate table have included "Zurich Main Street". In this scenario: would this primary key (place name) also be applied when going through the alternate tables? If this would be the case, then there will be no match when using the geocoder.
Thanks!
