Thanks for the quick reply. I'm looking at the files (http://www.census.gov/geo/www/cob/bdy_files.html). Do I download them all? I'm just trying to get the Tiger geocoder to work... That is, I only see references to the places and counties lookup tables in the lookup_tables.sql -- no mention of any of these other datasets, per se.. Which boundry files correspond to those requirements? What's the installation procedure, I guess, is what I'm looking for.
How do I ensure those tables get created? I'm looking at the cartographic boundry files (http://www.census.gov/geo/www/cob/bdy_files.html).. Do I need te congressional districts and so on? If I do manage to figure this all out (your help being very appreciated) I'll share a detailed tutorial walking from a fresh Postgres to the finish line.. Thanks, Josh On Sat, Jul 12, 2008 at 3:43 PM, Stephen Woodbridge <[EMAIL PROTECTED]> wrote: > starbuxman wrote: >> >> Hello everyone, >> >> I'm trying to setup the TIGER geocoder but am new at this sort of thing: >> >> I've already finished the bit where i run import/load_tiger.sh >> successfully. >> >> I'm using the 2006se TIGER line data. I now have all the PostGIS (on >> Postgres 8.3) and two tables Landmarks and CompleteChain (with a >> whopping 66 million records!/ 25gb footprint!) that took 28 hours to >> install. >> >> Now it says to import the .shp files... Only question is, what shp files? >> >> Here is the listing of the typical archive: >> Archive: TGR02164.ZIP >> inflating: TGR02164.RT1 >> inflating: TGR02164.RT2 >> inflating: TGR02164.RT4 >> inflating: TGR02164.RT5 >> inflating: TGR02164.RT6 >> inflating: TGR02164.RT7 >> inflating: TGR02164.RT8 >> inflating: TGR02164.RTA >> inflating: TGR02164.RTC >> inflating: TGR02164.RTE >> inflating: TGR02164.RTH >> inflating: TGR02164.RTI >> inflating: TGR02164.RTM >> inflating: TGR02164.RTP >> inflating: TGR02164.RTR >> inflating: TGR02164.RTS >> inflating: TGR02164.RTT >> inflating: TGR02164.RTZ >> inflating: TGR02164.MET >> >> Then, finally, looking ahead: I opened up the enxt step which is >> lookup_tables.sql and it in turn tries to create tables while drawing >> from tables called >> co99_d00 and pl99_d00 -- where do these tables get created? How? > > These the the shapefiles that you need to load. You can download them from > Census site look for the cartographic boundary files. > >> I know that the 2007 data is now using .shp files (or at least that's >> my understanding) -- do I need to download those, as well? Does that >> introduce the risk of data that's not out of sync? For that matter, >> what do I do with that data in the first place? > > No!, these are a totaly different format and will take a new process to > install them into the geocoder if it is even possible. > > -Steve W > >> Any help is greatly appreciated, thank you, >> >> Joshua Long >> http://www.joshlong.com/ > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Joshua Long Sun Certified Java Programmer http://www.joshlong.com/ _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
