[postgis-users] TIGER geocoder with Census 2009 shapefiles
Dave Fuhry
dfuhry at gmail.com
Fri Feb 26 12:04:13 PST 2010
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
More information about the postgis-users
mailing list