Hacker News new | ask | show | jobs
by dracodoc 2785 days ago
In case it's not known by everybody, you can geocode(maybe also reverse geocode, I didn't check) US addresses in batch with TIGER census data and PostGIS.

It's not directly relate to topic (dynamic maps, online geocoding), but somewhat relevant.

With about $300 in Amazon EC2 I geocoded 18 million addresses in 3 months. You probably can do it with your own PC with similar time (the only hardware requirement is RAM and SSD).

http://dracodoc.github.io/tags/Geocoding/

1 comments

Did you do any verification to show the effective accuracy/spatial resolution?
There is an accuracy score in postgis tiger geocoder plugin. Usually a low value mean a pretty good match. Depend on address format and quality, 70-80% of addresses got a good match.

For resolution you cannot expect too much because street numbers are usually interpolated, and TIGER database definitely will not be as good as best commercial database. However you don't have many other solution if you have millions address to geocode.