Postgres Pro
Downloads
Home   >   mailing lists

OT - load a shp file - Mailing list pgsql-sql

From John Fabiani
Subject OT - load a shp file
Date
Msg-id 201011302206.58515.johnf@jfcomputer.com
Whole thread Raw
Responses Re: OT - load a shp file
List pgsql-sql
Tree view 
Hi,
How do I load a Census shp file into an exist database?  I believe I have 
postGIS install and now I want to load the US counties shp file.  

the following does not appear to work
shp2pgsql -s 4269 -I -W latin1 tl_2008_us_county.shp 2008_us_county | psql

Plus I don't know what it does!

Johnf

pgsql-sql by date:

Previous
From: Samuel Gendler
Date:
Subject: aggregation question
Next
From: Jeff Bland
Date:
Subject: DELETE WHERE EXISTS unexpected results