[postgis-users] Which *.shp files is the TIGER GeoCoder referring to, and where do co99_d00 and pl99_d00 come from?
starbuxman at gmail.com
Sun Jul 13 15:16:36 PDT 2008
Thanks again for your help. Just about 5 hours ago I managed to
finish the successul installation of ... well.. everything.. on
Postgres 8.3. It took 2 days and near 100gbs, but its done..
I ran my first test this morning with select geocode( 'address blah blah') ;
and then it failed...
complained about all sorts of casts (I guess this hasn't been tested
or run on 8.3, which is fairly new..) from types/against types to
I will try and take a look at the hundreds and hundreds of SQL for the
functions, but I'm not sure I'll have a prayer...
May have to revisit this at another time. Has anyone gotten this to
work on 8.3?
Thanks in advance,
On Sat, Jul 12, 2008 at 5:07 PM, Stephen Woodbridge
<woodbri at swoodbridge.com> wrote:
> I have used the tiger geocoder so I'm only guessing ...
> You only need the county and place files
> download these and unzip them.
> use shp2pgsql to load them, it has an option to specify the table name.
> If there are more than one *.shp for either of these the use -c to create
> the table on the first one and then use -a to append to the table for all
> the rest in the set.
> Josh Long wrote:
>> 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
>>>> 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
>>>> Now it says to import the .shp files... Only question is, what shp
>>>> 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
>>> 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
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
> postgis-users mailing list
> postgis-users at postgis.refractions.net
Sun Certified Java Programmer
More information about the postgis-users