Re: [SQL] OT - load a shp file

2010-12-01 Thread John Fabiani
On Wednesday, December 01, 2010 01:13:52 am Lee Hachadoorian wrote: > John, > > Would probably be useful to see the results of the command, but a couple > of things are immediately obvious. > > First, Postgres requires identifiers to start with a letter or > underscore. You are attempting to crea

Re: [SQL] OT - load a shp file

2010-12-01 Thread Lee Hachadoorian
John, Would probably be useful to see the results of the command, but a couple of things are immediately obvious. First, Postgres requires identifiers to start with a letter or underscore. You are attempting to create a table named 2008_us_county, which is not a legal identifier. Also, unless you

[SQL] OT - load a shp file

2010-11-30 Thread John Fabiani
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