Josh,
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.
-Steve
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..
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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
