topic Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches in Data Management Questions

10.2.2 Alternate Names Geocoding Does Not Return Matches

JoeBorgione — Mon, 09 Feb 2015 17:39:45 GMT

After a quick search of the forums, I didn't see this particular problem listed, which is surprising to me as it was brought to my attention from a colleague using 10.2.1.

I created dual range address locator based on centerlines data. We have named and numbered streets in Utah, and every named street has a numeric alias: I created an alias table and it is part of the locator. Both the centerlines data and the alias table have a join item called of all things 'joinitem'. Initially I built the locator with out indexing the joinitem, and when it failed for the first time, I then retreated and added the index.

The alt-names table is ignored. My colleague created separate dual range locator using the numeric values as the street names and then put it together with the original as a composite and that works for him. I want it (as he does) to work the way it's supposed to.

The only changes I made to the default settings is I Added YES to Match with no zones (I heard that was a bug at 10.1) and changed the Presort input table by (fields) to City, Zip State, but I have even used an input table, I've just tested the locator interactively.

Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches

JoeBorgione — Mon, 09 Feb 2015 21:43:03 GMT

Here's the answer:

In the AltNames table 10.2 REQUIRES that you have a PRE_TYPE and ST_TYPE field to map to. Even if you don't have those fields in your data, you 'll need to add them.

What I did for my situation is add them as text type of one character, then calculated them to equal "" (doublequote doublequote so they are empty but not <null>) If you use these two fields as shown above, when you create your locator it will map to them by default.

Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches

VickyYoung1 — Wed, 06 Jan 2016 23:49:44 GMT

Hi Joe

I came upon this post researching the same issue ( in 10.2.2). I set up my Alternate Name table based on the directions above and have all the field mapping in the Locator properties set correctly (as far as I can tell) but still can't get the Alternate addresses to work (my alias table works).

I've gone over the help and tutorial information, tested the join and seem to have all the settings right in my Locator.

I thought I would post here to see if there was anything I may have missed. I can share my Locator if that helps.

Thanks

Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches

JoeBorgione — Thu, 07 Jan 2016 15:19:46 GMT

Sorry Vicky, 11 months ago I set up a 10.2.2 box, but because of a third party software I'm dependent upon, I'm stuck using 9.3 locators. I can't remember anything else than what I posted back then. Perhaps one of the ESRI geocoding folks can chime in.

Bruce HaroldBrad Niemand

Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches

ShanaBritt — Fri, 08 Jan 2016 00:15:39 GMT

Vicky

Are you able to provide a screen shot of the entire field mapping showing all of the primary and alternate table parameters, as well as the Geocoding Options? When I'm testing the alternate name to see why I may not be getting the expected results I add the reference data and the alternate name table to a Map and create a relate using the fields that you would map as the JoinIDs when building the locator. Then use the Identify button on a feature that has an alternate name and check the related info in the Identify Results Window to see if the information is correct. If you would like me to look at your locator and data you can send it to me at sbritt@esri.com.

-Shana

Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches

VickyYoung1 — Fri, 08 Jan 2016 21:32:12 GMT

Hi Shana,

I had tested the join/relate between the reference data and alternate table and it works fine. I will send you the locator data at the address listed above.

Thank you

Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches

VickyYoung1 — Wed, 13 Jan 2016 21:23:29 GMT

In the field mapping settings I was using the same field for my Primary Table FeatureID and primary table joinID. This was affecting the Alternate name search success. By using ObjectID (or another unique field in the data) I solved this problem.

Thank you Shana for you help!

Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches

JoeBorgione — Wed, 13 Jan 2016 21:51:18 GMT

I was using the same field for my Primary Table FeatureID and primary table joinID.

So the bottom line is your were using incorrect field mapping?

Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches

VickyYoung1 — Wed, 13 Jan 2016 23:07:29 GMT

Actually my initial field mapping worked fine with test data in a file gdb but when I tried to use SDE data as the data source I needed to make the above noted changes to the field mapping for the Alternate Name search to work. Thanks for helping to clarify.

Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches

ChelseaRozek — Tue, 22 Nov 2016 17:09:07 GMT

Was also just dealing with the locator not returning proper results when using the alias table.

The piece of Joe's answer that I was missing, in case it helps anyone else, is that you need those two extra fields so that your field mappings on the alias table match the field mappings on your primary table (road centerlines in my case). These fields themselves don't matter, just that the two sets of field mappings match. So in my case, I removed all those extra fields and just made a FULLNAME field on the alias table because that was all I was mapping to on the road centerlines.

Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches

ShanaBritt — Mon, 28 Nov 2016 21:54:19 GMT

Chelsea:

If you had a FULLNAME field in the primary table and in the alternate name table and only mapped those two fields when building the address locator, you should get matches for the alternate names. The field mapping between the primary table and alternate name table need to match in order for the query between the two tables to work.

Shana

Re: 10.2.2 Alternate Names Geocoding Does Not Return Matches

ChelseaRozek — Tue, 29 Nov 2016 16:01:54 GMT

Yeah, that was the answer I came to. Just posting it in case it could help anyone else.