[postgis-devel] [PostGIS] #893: Error loading (shp2pgsql or bad geometry)

PostGIS trac at osgeo.org
Wed Mar 30 11:50:53 PDT 2011


#893: Error loading (shp2pgsql or bad geometry)
-----------------------+----------------------------------------------------
 Reporter:  j03lar50n  |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 1.4.3
Component:  postgis    |     Version:  1.4          
 Keywords:             |  
-----------------------+----------------------------------------------------
 I'm struggling to import this .shp to PostGIS. Have tried changing the
 encoding, i deleted 'Shape_Length' and 'Shape_Area' columns. Tried
 shp2pgsql command-line, SPIT, pgAdminIII (shapeloader OpenGeo).

 example error msg:

 Failed SQL begins: "INSERT INTO "gis"."County_VegPolys_SLU"
 ("OBJECTID","Formation","Oaks",the_geom) VALUES
 ('31320','2','9','0106000020B5080000010000000103000020B50800000500000012180000103CB7B15364564120F8AA1B94104141B0123FD8526456418065C56892104141C0B6E64B5064564100D5CC11"
 Failed in pgui_exec(): server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.

 Failed record number #32245
 Failed SQL begins: "INSERT INTO "gis"."County_VegPolys_SLU"
 ("OBJECTID","Formation","Oaks",the_geom) VALUES
 ('31321','2','9','0106000020B5080000010000000103000020B50800000100000006010000002E940B1D775641405DC9536F11414130859ACE1A77564140FE934867114141A078022D17775641402A14E7"
 Failed in pgui_exec(): no connection to the server


 postgis_full_version
 ----------------------------------------------------------------------------------------
  POSTGIS="1.4.0" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.7.1, 23 September
 2009" USE_STATS
 (1 row)

 version
 -----------------------------------------------------------------------------------------------------------
  PostgreSQL 8.4.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real
 (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 32-bit
 (1 row)

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/893>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list