Is there a way to pre-scrub location information for correctness?
We're trying out GeoAnalytics 5.8.1 with some success at getting area and bubble maps.
As is usually the case, our address book data is messy, often containing missing information or subtly misspelled information, e.g. Carrolton, Texas instead of the correct Carrollton, Texas. GeoAnalytics displays the second correct form, but not the first incorrect form.
Is there a way to scrub my entire address book against the Lookup service and obtain a list of addresses that result in a lookup failure? The error message in the map is not useful - it only says "Unsuccessful location lookup" without mentioning the name of the location. In any case, it would be painful and hit and miss to try to find incorrect addresses this way.
The fields I am most interested in are City, State, Postal Code and Country. If I can scrub these four fields, we can start to fix them in the source data. We have about 8,000 addresses to scrub. Most appear to be correct, but many are incorrect.
Ideally, I can write code in the script and pass in a long list of rows of these four fields and receive back notification about which rows failed to lookup.
Any and all ideas are appreciated. We have the local map server installed, if that helps.
Re: Is there a way to pre-scrub location information for correctness?
There are two Geo Analytics operations you can use, one for checking areas and one for checking points:
NamedAreaLookup – Get the polygons for named areas such as countries, administrative areas and postal areas.
NamedPointLookup – Get the (center)points for named areas such as countries, administrative areas and postal areas.
You will get a resulting a table with the matching records so you can find and correct the bad ones.
When supplying info to the lookup, you can improve the results by providing additional location and type information. See the documentation for more info about the location service. here's two example how to refer to cities and postal codes (XPC indicates xip info and P* is place info).
=city:name & ',' state_abbr & ',US*'
=zip_code & ',US:XPC'
Another good op is the "Load" operation, you can for instance load all the counties in the us to check the spelling of the county name.