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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
