[postgis-users] error loading shapefiles into postgis

[Paragon Corporation]

Bruce,
Hard to say without more specifics about EXACTLY what errors you are
getting.
 
Common errors
 
1)  encoding,  By default UTF8 is assumed unless overwritten 
 
2)  If you use -S switch it will fail if it sees MULTIPOLYGONs for example.
 
3) ESRI files often have geometries which PostGIS considers so invalid it
won't load them and that will kill the whole transaction and prevent any
loading
 
To skip over these royally bad geometries, you can use the -e option.
 
http://postgis.net/docs/manual-2.1/using_postgis_dbmanagement.html#shp2pgsql
_usage
 
This will be slower since it commits each record as a separate transaction.
 
If you do come across a royally bad geometry that you don't think is royally
bad, we'd like to know about it to confirm.  There have been instances
(which I can't recall off hand),
where a geometry was not interpreted right by shp2pgsql. 
 
Hope that helps,
Regina
http://www.postgis.us
http://postgis.net
 

  _____  

From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Clay, Bruce
Sent: Thursday, September 26, 2013 3:42 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] error loading shapefiles into postgis


I have a number of shapefiles from various sources that have a mixture of
polygons and multi-polygons or points nad multi-point that I have been
trying to load into PostGis.  I have tried using QGis / Spit, org2ogr and
shp2pgsql.  
 
Some of the files will load but thow a bunch or errors/warnings and others
won't load at all.  The files are part of the ArcGis data distribution as
sdc files converted to shapefiles using the ESRI DDA application.
 
Is there a "proper method" or any method that will work to get the data
registered in PostGis?
 
Bruce
 
 


This message and any enclosures are intended only for the addressee. Please 
notify the sender by email if you are not the intended recipient. If you are

not the intended recipient, you may not use, copy, disclose, or distribute
this 
message or its contents or enclosures to any other person and any such
actions 
may be unlawful. Ball reserves the right to monitor and review all messages 
and enclosures sent to or from this email address.

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