[postgis-users] TIGER geocoder with Census 2009 shapefiles

[Dave Fuhry]

I'm trying to set up the TIGER geocoder from
http://www.snowman.net/git/tiger_geocoder/ which is new and aims to
work with the new TIGER shapefiles.  I'm trying with the 2009
shapefiles from www2.census.gov/geo/tiger/TIGER2009/.

I'm not sure how to create the roads_local table (derived closely from
completechain in the old version).  A join between edges and addr?

Wondering if anyone can offer any direction.  A relevant ticket is
http://trac.osgeo.org/postgis/ticket/135.  The out-of-date file which
used to create the roads_local table is tables/roads_local.sql, in the
above repository.

-Dave

                                       Table "tiger.edges"
   Column   |          Type          |                         Modifiers
------------+------------------------+------------------------------------------------------------
 gid        | integer                | not null default
nextval('public.edges_gid_seq'::regclass)
 statefp    | character varying(2)   |
 countyfp   | character varying(3)   |
 tlid       | bigint                 |
 tfidl      | bigint                 |
 tfidr      | bigint                 |
 mtfcc      | character varying(5)   |
 fullname   | character varying(100) |
 smid       | character varying(22)  |
 lfromadd   | character varying(12)  |
 ltoadd     | character varying(12)  |
 rfromadd   | character varying(12)  |
 rtoadd     | character varying(12)  |
 zipl       | character varying(5)   |
 zipr       | character varying(5)   |
 featcat    | character varying(1)   |
 hydroflg   | character varying(1)   |
 railflg    | character varying(1)   |
 roadflg    | character varying(1)   |
 olfflg     | character varying(1)   |
 passflg    | character varying(1)   |
 divroad    | character varying(1)   |
 exttyp     | character varying(1)   |
 ttyp       | character varying(1)   |
 deckedroad | character varying(1)   |
 artpath    | character varying(1)   |
 persist    | character varying(1)   |
 gcseflg    | character varying(1)   |
 offsetl    | character varying(1)   |
 offsetr    | character varying(1)   |
 tnidf      | bigint                 |
 tnidt      | bigint                 |
 the_geom   | public.geometry        |


                                      Table "tiger.addr"
  Column   |         Type          |                         Modifiers
-----------+-----------------------+-----------------------------------------------------------
 gid       | integer               | not null default
nextval('public.addr_gid_seq'::regclass)
 tlid      | bigint                |
 fromhn    | character varying(12) |
 tohn      | character varying(12) |
 side      | character varying(1)  |
 zip       | character varying(5)  |
 plus4     | character varying(4)  |
 fromtyp   | character varying(1)  |
 totyp     | character varying(1)  |
 fromarmid | integer               |
 toarmid   | integer               |
 arid      | character varying(22) |
 mtfcc     | character varying(5)  |
 statefp   | character varying(2)  | not null