David, As a matter of fact we've been working on that for chapter 10 of our upcoming book and think we have it all working. As a part of the example generation process for our chapter 10, we had to come up with a way to load the tables that works on both windows and Linux. Unfortunately we haven't had a chance to test the Linux loading approach, but is pretty much a parallel of the windows approach.
To do so we started out with Steve's code, added some additional skeleton tables and a database function that generates a command line script for the respective OS. Hopefully it all makes sense from the readme file we have packaged. We also changed one of the functions because there was an error in it and revised slightly to work with Tiger 2009 data. You can dowload our slightly hacked version of Steve's code from our chapter 10 page. Steve -- if you are listening we are hoping to remerge your version with our loader part and bring back into the PostGIS distribution as part of PostGIS 1.5.1 or 2.0 release. http://www.postgis.us/chapter_10 Leo and Regina http://www.postgis.us/ -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Dave Fuhry Sent: Friday, February 26, 2010 3:04 PM To: PostGIS Users Discussion Subject: [postgis-users] TIGER geocoder with Census 2009 shapefiles 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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
