[postgis-users] Which *.shp files is the TIGER GeoCoder referring to, and where do co99_d00 and pl99_d00 come from?

Josh Long starbuxman at gmail.com
Sat Jul 12 15:52:16 PDT 2008

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..


On Sat, Jul 12, 2008 at 3:43 PM, Stephen Woodbridge
<woodbri at swoodbridge.com> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Joshua Long
Sun Certified Java Programmer

More information about the postgis-users mailing list