topic Re: Setting up alternate tables to create locator in Geoprocessing Questions

Setting up alternate tables to create locator

RenatevanDorp — Fri, 28 Jun 2024 20:03:59 GMT

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!

Re: Setting up alternate tables to create locator

ShanaBritt — Tue, 09 Jul 2024 16:38:22 GMT

@RenatevanDorp Can you provide an example of the full input for what will be geocoded and what you expect to be returned? Is it only the street name and place (city, town, neighborhood, subregion)? There are alternate name table roles , which role would you be using? Alternate Street Name? Alternate City Name?

https://pro.arcgis.com/en/pro-app/latest/help/data/geocoding/fundamentals-of-alternate-name-tables.htm

Re: Setting up alternate tables to create locator

RenatevanDorp — Mon, 29 Jul 2024 19:05:46 GMT

I have some addresses that I am trying to figure out what category they belong in. Addresses, such as:

Main Street South: Streetname = Main; Street Type= Street; Dir= South are easy.

Line 89: Prefix type=Line ; Streetname =89

Perth Line 86: Prefix type= Line: Streetname= Perth 86? Is the way to include it to create a locator? Any suggestions are appreciated.

Re: Setting up alternate tables to create locator

ShanaBritt — Tue, 30 Jul 2024 00:50:27 GMT

What country are you creating the locator for? Is "Perth Line 86" like a highway?

Re: Setting up alternate tables to create locator

RenatevanDorp — Tue, 30 Jul 2024 12:45:52 GMT

I am creating a local locator. The road is located in Canada. It is a local County road. Perth County naming convention of rural roads is to first name the road/line followed by the road/line number (see https://en.wikipedia.org/wiki/List_of_numbered_roads_in_Perth_County)

Re: Setting up alternate tables to create locator

ShanaBritt — Fri, 02 Aug 2024 13:49:28 GMT

@RenatevanDorp You may want to try using "Perth Line 86" as the street name in the data. Do you have multiple Perth Line county roads in your data? Were you not getting good results previously?