<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [postgis-users] Having problemas to convert SHP to PGSQL</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<BR>
<P><FONT SIZE=2>Sanity ?<BR>
<BR>
;-)<BR>
<BR>
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):<BR>
BEGIN;<BR>
<your sql here>;<BR>
ROLLBACK; -- assuming you don't want partial changes<BR>
<BR>
Post back the first few lines and maybe the last few, but do eyeball it first and see if anything jumps out at you.<BR>
<BR>
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."<BR>
<BR>
Greg Williamson<BR>
Senior DBA<BR>
DigitalGlobe<BR>
<BR>
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.<BR>
<BR>
(My corporate masters made me say this.)<BR>
<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of George Silva<BR>
Sent: Wed 5/14/2008 8:03 PM<BR>
To: PostGIS Users Discussion<BR>
Subject: Re: [postgis-users] Having problemas to convert SHP to PGSQL<BR>
<BR>
Thanks Robert. Will try that.<BR>
<BR>
What should i look for?<BR>
<BR>
George<BR>
<BR>
<BR>
On Wed, May 14, 2008 at 3:45 PM, Burgholzer,Robert <rwburgholzer@deq.virginia.gov> wrote:<BR>
<BR>
<BR>
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.<BR>
<BR>
<BR>
Robert W. Burgholzer<BR>
Surface Water Modeler<BR>
Office of Water Supply and Planning<BR>
Virginia Department of Environmental Quality<BR>
rwburgholzer@deq.virginia.gov<BR>
804-698-4405<BR>
Open Source Modeling Tools:<BR>
<A HREF="http://sourceforge.net/projects/npsource/">http://sourceforge.net/projects/npsource/</A><BR>
<BR>
-----Original Message-----<BR>
<BR>
From: postgis-users-bounces@postgis.refractions.net [<A HREF="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</A>] On Behalf Of Burgholzer,Robert<BR>
Sent: Wednesday, May 14, 2008 2:36 PM<BR>
To: PostGIS Users Discussion<BR>
<BR>
Subject: RE: [postgis-users] Having problemas to convert SHP to PGSQL<BR>
<BR>
Syntax for command please ...<BR>
<BR>
Robert W. Burgholzer<BR>
Surface Water Modeler<BR>
Office of Water Supply and Planning<BR>
Virginia Department of Environmental Quality<BR>
rwburgholzer@deq.virginia.gov<BR>
804-698-4405<BR>
Open Source Modeling Tools:<BR>
<A HREF="http://sourceforge.net/projects/npsource/">http://sourceforge.net/projects/npsource/</A><BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net [<A HREF="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</A>] On Behalf Of George R. C. Silva<BR>
Sent: Wednesday, May 14, 2008 2:27 PM<BR>
To: PostGIS Users Discussion<BR>
Subject: [postgis-users] Having problemas to convert SHP to PGSQL<BR>
<BR>
hello all!<BR>
<BR>
Once again i come with a issue for you the experts :P<BR>
<BR>
I´m having trouble converting a shapefile to postgis schema, and nothing<BR>
will make it work.<BR>
<BR>
the shp2pgsql actually runs, but at the end, no table is added or<BR>
populated. I even tried converting using QGIS 10<BR>
<BR>
I will attach a zip of the shpfile. SRID is 29182.<BR>
<BR>
Ive checked within ArcGIS is the shp is valid, or has problems, and nothing.<BR>
<BR>
My postgresql is 8.3 and latest pgis.<BR>
<BR>
_______________________________________________<BR>
postgis-users mailing list<BR>
postgis-users@postgis.refractions.net<BR>
<A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>
_______________________________________________<BR>
postgis-users mailing list<BR>
postgis-users@postgis.refractions.net<BR>
<A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>
<BR>
<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>