Sanity ?
;-)
Empty fields or misformed SQL, missing data or misformed data. Depending on how
you are setting the output, you can try running sample statements in the "psql"
tool (or pgAdmin):
BEGIN;
<your sql here>;
ROLLBACK; -- assuming you don't want partial changes
Post back the first few lines and maybe the last few, but do eyeball it first
and see if anything jumps out at you.
Sorry for top-posting with such a slug o'text below but, as they say, "ours is
not to reason why, but to invert and multiply."
Greg Williamson
Senior DBA
DigitalGlobe
Confidentiality Notice: This e-mail message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information and must be protected in accordance with those
provisions. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
(My corporate masters made me say this.)
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of George Silva
Sent: Wed 5/14/2008 8:03 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Having problemas to convert SHP to PGSQL
Thanks Robert. Will try that.
What should i look for?
George
On Wed, May 14, 2008 at 3:45 PM, Burgholzer,Robert <[EMAIL PROTECTED]> wrote:
BTW - I always dump the output of shp2pgsql to a text file, so that I
can look at the SQL insert statements if there is a problem.
Robert W. Burgholzer
Surface Water Modeler
Office of Water Supply and Planning
Virginia Department of Environmental Quality
[EMAIL PROTECTED]
804-698-4405
Open Source Modeling Tools:
http://sourceforge.net/projects/npsource/
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Burgholzer,Robert
Sent: Wednesday, May 14, 2008 2:36 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Having problemas to convert SHP to PGSQL
Syntax for command please ...
Robert W. Burgholzer
Surface Water Modeler
Office of Water Supply and Planning
Virginia Department of Environmental Quality
[EMAIL PROTECTED]
804-698-4405
Open Source Modeling Tools:
http://sourceforge.net/projects/npsource/
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George
R. C. Silva
Sent: Wednesday, May 14, 2008 2:27 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Having problemas to convert SHP to PGSQL
hello all!
Once again i come with a issue for you the experts :P
I´m having trouble converting a shapefile to postgis schema, and nothing
will make it work.
the shp2pgsql actually runs, but at the end, no table is added or
populated. I even tried converting using QGIS 10
I will attach a zip of the shpfile. SRID is 29182.
Ive checked within ArcGIS is the shp is valid, or has problems, and
nothing.
My postgresql is 8.3 and latest pgis.
_______________________________________________
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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
