Table (full street address) convert to lat/long

2188
4
02-05-2018 10:02 AM
by
Occasional Contributor III

Thank you!

Tags (3)
1 Solution

Accepted Solutions
MVP Emeritus

In order get the results you are after, you 'll need to geocode your table of addresses to some sort of "matchable" spatial data.  That can include but not limited to street centerline data.

Lets say your center line data has three records of S MAIN ST,and each is ranged respectively as 1-500, 501-1000, and 1001- 1500.

And lets say one of your addresses is 1234 S Main ST . The geocoder (that you build) matches the full address of 1234 S MAIN ST to the street centerline data record that has that house number within its range.  The trick is your street centerline data needs the various address components split out into individual fields:

Prefix = S

StreetName = MAIN

StreetType = ST

Obviously, your address table needs to be fairly 'clean', that is, for the best results your addresses need to be in the form that your matching data is in.

If you have and address of 1234 MAIN and you geocoder is looking for 1234 S MAIN ST, you will probably get a hit, but not a 100 % score.

That should just about do it....
4 Replies
MVP Emeritus

Start here:

That should just about do it....
by
Occasional Contributor III

I understand. Thanks for the link. I was a bit confused between broken down fields and full street address field. I am aware that geocode builds multiple fields. Is there any way that geocode build full street address instead broken down fields? i.e. house number, dir, etc.

MVP Emeritus

In order get the results you are after, you 'll need to geocode your table of addresses to some sort of "matchable" spatial data.  That can include but not limited to street centerline data.

Lets say your center line data has three records of S MAIN ST,and each is ranged respectively as 1-500, 501-1000, and 1001- 1500.

And lets say one of your addresses is 1234 S Main ST . The geocoder (that you build) matches the full address of 1234 S MAIN ST to the street centerline data record that has that house number within its range.  The trick is your street centerline data needs the various address components split out into individual fields:

Prefix = S

StreetName = MAIN

StreetType = ST

Obviously, your address table needs to be fairly 'clean', that is, for the best results your addresses need to be in the form that your matching data is in.

If you have and address of 1234 MAIN and you geocoder is looking for 1234 S MAIN ST, you will probably get a hit, but not a 100 % score.

That should just about do it....