Multiple Addresses geocoded to a single point

Question

I am trying to create a custom Locator I can use to geocode addresses from a spreadsheet.

I can create a basic Locator which uses our address feature class and streets feature class which runs successfully but it maps multiple address along a street to a single point on the street.

Can anyone tell me why?

ShanaBritt · Answer

@SLouq For those addresses that are placed along the street centerline it sounds like they were matched to the street data and not the point address data. For the addresses in question, check the values in the Addr_type field. This will tell you if the address is a PointAddress or StreetAddress (StreetName, StreetAddressExt) match. If a point for the address does not exist in the point address data to build the locator, then the address will be matched to the street data and interpolated long the line based on the house number range of the street in the data.

As far as the format of your spreadsheet is concerned it should look similar to one of the following:

If you'd like for me to take a look at your data, you can send it to me in a private message if you like. I think at a minimum it would be helpful to see the reference tables from the locator properties dialog for both the PointAddress role and StreetAddress role.

SLouq · Answer

I think the problem I'm having is with the way data is formatted in the spreadsheet I'm trying to geocode. I've been experimenting with different ways of doing this and have gotten all the attributes from my spreadsheet to show up on the map, just they are all placed along the street centerline and not the location of the address.

I've been using the address, streets and parcel table as roles in my Locator.

ThomasHoman · Answer

Can you post the relevant data - locator, street centerlines and address points? The redacted screen shot does not provide any information for deeper discussion.

Have you completely ruled out a data problem with the centerline ranging on that particular street segment?