From: John Fabiani <johnf@jfcomputer.com>
Organization: J.F. Computer Solutions
To: pgsql-sql@postgresql.org
Subject: Re: OT - load a shp file
Date: Wed, 1 Dec 2010 06:29:10 -0800
User-Agent: KMail/1.13.5 (Linux/2.6.34.7-0.5-desktop; KDE/4.4.4; i686; ; )
References: <201011302206.58515.johnf@jfcomputer.com>
	<4CF611D0.9030505@gmail.com>
In-Reply-To: <4CF611D0.9030505@gmail.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="windows-1252"
Content-Transfer-Encoding: quoted-printable
Message-Id: <201012010629.10542.johnf@jfcomputer.com>

On Wednesday, December 01, 2010 01:13:52 am Lee Hachadoorian wrote:
> John,
>=20
> Would probably be useful to see the results of the command, but a couple
> of things are immediately obvious.
>=20
> 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 want this in the
> public schema, make sure to use the schema-qualified table name.
>=20
> Second, the docs specify that the shapefile be passed in without the
> .shp extension.
>=20
> Third, since you're not specifying the database explicitly, make sure
> that the default makes sense (psql assumes a default of your user name
> or reads it from the PGDATABASE environment variable). The examples in
> the shp2pgsql docs all explicitly specify a target database with, e.g.
> =85 | psql -d my_db
>=20
> If you fix all of this and it still isn't working, I would direct the
> output to a file, look at it to make sure it makes sense, then try to
> pass the file to psql.
>=20
> If you would prefer, there are also a couple of GUIs that can control
> shp2pgsql. I've had success with the SPIT (Shapefile to PostGIS Import
> Tool) plugin for Quantum GIS (http://qgis.org/). For Windows only you
> can use the Shp2PgSQL Graphical Loader (a plugin for pgAdmin III)
> available at http://postgis.refractions.net/download/windows/.
>=20
> Finally, a better list for PostGIS support is
> postgis-users@postgis.refractions.net.
>=20
> --Lee
>=20
> On 12/01/2010 01:06 AM, John Fabiani wrote:
> > Hi,
> > How do I load a Census shp file into an exist database?  I believe I ha=
ve
> > postGIS install and now I want to load the US counties shp file.
> >=20
> > the following does not appear to work
> > shp2pgsql -s 4269 -I -W latin1 tl_2008_us_county.shp 2008_us_county |
> > psql
> >=20
> > Plus I don't know what it does!
> >=20
> > Johnf

thanks for the help.  Your response already has taught me a few things and =
I=20
haven't even tried to fix the issues.

Johnf