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: [email protected] [mailto:[email protected]] On Behalf Of Clay, Bruce Sent: Thursday, September 26, 2013 3:42 PM To: [email protected] 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.
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
