search

CivicTechAtlanta / show-me-the-food

Show food sources in Atlanta (and beyond!)
MIT License
5 stars 1 forks source link

standardize addresses and coordinates #3

Open switzersc opened 9 years ago

switzersc commented 9 years ago

add a column to locations for standardized_address use the USPS address information API to standardize addresses, which will be helpful in identifying duplicate data

We've currently applied to the USPS for access to the API.

switzersc commented 9 years ago

The USPS rejected our application to use their address standardization api, because we won't use it to send packages through the USPS. Thanks, Government.

bahrieinn commented 9 years ago

I'm not sure how many requests you need to make, but could try out something like http://smartystreets.com? Looks like they are free up to 250 lookups/mo but start charging after.

kentr commented 8 years ago

I don't know the full scope of this issue, so please excuse if this suggestion is off-base. I've had pretty good results in standardizing / normalizing addresses with the Tiger Geocoder address normalizer.

A pro is that you can host it on your own server and do a lot of stuff quickly with SQL (including GIS data manipulation). Of course, that comes with the con of having to maintain the installation.

There's apparently an address standardizer library for Python (maybe several), and there are some other open source libraries available.