[postgis-users] Having problemas to convert SHP to PGSQL

[Gregory Williamson]

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: postgis-users-bounces at postgis.refractions.net 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 <rwburgholzer at deq.virginia.gov> 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
	rwburgholzer at deq.virginia.gov
	804-698-4405
	Open Source Modeling Tools:
	http://sourceforge.net/projects/npsource/
	
	-----Original Message-----
	
	From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] 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
	rwburgholzer at deq.virginia.gov
	804-698-4405
	Open Source Modeling Tools:
	http://sourceforge.net/projects/npsource/
	
	-----Original Message-----
	From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] 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
	postgis-users at postgis.refractions.net
	http://postgis.refractions.net/mailman/listinfo/postgis-users
	_______________________________________________
	postgis-users mailing list
	postgis-users at postgis.refractions.net
	http://postgis.refractions.net/mailman/listinfo/postgis-users
	



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080514/ad39133e/attachment.html>