TIGER Geocoder
A PL/PgSql based geocoder written for the TIGER/Line census data.
http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/
Note the version currently in PostGIS 1.5 is the old one that uses pre-Tiger 2007 proprietary format.
The Tiger Geocoder was redone by Steve Frost to work with the new shapefile 2008 dataset and he has this in his GIT repository http://www.snowman.net/git/tiger_geocoder.
We are currently working on upgrading Steve's version to work with Tiger 2009 and Tiger 2010 datasets. The Tiger 2009 is functional and its use described in detail in Chapter 10 of PostGIS in Action and the packaged README.
In the Tiger 2010 the census made structural changes to the tables so they are different from the 2009 column format. We are currently working on writing loader scripts to load in this newer data and then revise scripts accordingly to work with it and work with PostGIS 2.0. Both of the 2009 and 2010 scripts will be merged into the PostGIS 2.0 codebase once cleaned up and will be packaged as part of the PostGIS 2.0 final release. The tiger 2010 version is now in trunk and is under revision. Right now it is functional -- but we still need to fill in some more of the zip* lookup tables to make it handle all cases and are also working on improving its speed. The loader script has only been tested on Windows. Work needs to be done to test the script on Linux. We think only minor changes need to be done to get it functioning on Linux if it isn't already. The other change is that we went a down a template approach to better easily generate a script for each platform. This is all detailed in the readme. The downside is that we don't have all the various options as what Steve Frost had in his script, but upside works for most usecases and doesn't leave out our large Windows userbase. Steve's loader script is in the folder http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_geocoder_2010/legacy_import/tiger_2008 for those inclined to try it out and perhaps bring it up to date to work with the 2010 census.
http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder
Open Tickets
No results
