[postgis-users] Error in shp2pgsql

[Maria Arias de Reyna]

El Tuesday 22 June 2010, João Paulo Hespanha escribió:
> Dear Sirs:
>
> While importing a shapefile produced from an ESRI personal geodatabase,
> consisting of a total of 609 polygons, I got the error which I report in
> the below transcript (a bit long... as usual).
>
> Later, I found out that the program was crashing due to a incorrect
> polygon, having shape length and area equal to zero. Now I know that
> ArcGIS accepts such misformed polygons in the geodatabase...
>

You can try to load the shapefile with another program (like kosmo) and save 
it to postgresql directly. And if you need the sql, dump the table from 
postgresql.

Maybe that way, the external program catches the exception.

> I have also used SPIT (a QGIS plugin), which did not give me problems
> respecting the import and simply ignored the erroneous polygon, although
> it did not informed me of the fact.
>
> FYI, I am using release 1.5 of shp2pgsql and:
> "POSTGIS="1.3.5" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September
> 2009" USE_STATS"; "PostgreSQL 8.3.8 on i486-pc-linux-gnu, compiled by
> GCC gcc-4.4.real (Ubuntu 4.4.1-3ubuntu3) 4.4.1"
>
>
> Transcript from my session:
> jphespanha at JPHUbuntu:~/Documentos/Tese/ImplementationTest_2010/ArcGISshapes
>$ shp2pgsql -c -s 9102160 Predio_Polygons public.predio_polygons >
> predio_polys.sql Shapefile type: Polygon
> Postgis type: MULTIPOLYGON[2]
> *** glibc detected *** shp2pgsql: corrupted double-linked list:
> 0x084a9c78 ***
> ======= Backtrace: =========
> /lib/tls/i686/cmov/libc.so.6[0xe3f0d1]
> /lib/tls/i686/cmov/libc.so.6[0xe40b69]
> /lib/tls/i686/cmov/libc.so.6(cfree+0x6d)[0xe438ad]
> shp2pgsql[0x8053345]
> shp2pgsql[0x8053d76]
> /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe6)[0xdeab56]
> shp2pgsql[0x8049ed1]
> ======= Memory map: ========
> 0068d000-0068e000 r-xp 00000000 00:00 0          [vdso]
> 00931000-00955000 r-xp 00000000 08:01
> 1967425    /lib/tls/i686/cmov/libm-2.10.1.so
> 00955000-00956000 r--p 00023000 08:01
> 1967425    /lib/tls/i686/cmov/libm-2.10.1.so
> 00956000-00957000 rw-p 00024000 08:01
> 1967425    /lib/tls/i686/cmov/libm-2.10.1.so
> 009e3000-009e5000 r-xp 00000000 08:01
> 534769     /usr/lib/gconv/CP1252.so
> 009e5000-009e6000 r--p 00001000 08:01
> 534769     /usr/lib/gconv/CP1252.so
> 009e6000-009e7000 rw-p 00002000 08:01
> 534769     /usr/lib/gconv/CP1252.so
> 00d6b000-00d87000 r-xp 00000000 08:01 2352       /lib/libgcc_s.so.1
> 00d87000-00d88000 r--p 0001b000 08:01 2352       /lib/libgcc_s.so.1
> 00d88000-00d89000 rw-p 0001c000 08:01 2352       /lib/libgcc_s.so.1
> 00dd4000-00f12000 r-xp 00000000 08:01
> 1967417    /lib/tls/i686/cmov/libc-2.10.1.so
> 00f12000-00f13000 ---p 0013e000 08:01
> 1967417    /lib/tls/i686/cmov/libc-2.10.1.so
> 00f13000-00f15000 r--p 0013e000 08:01
> 1967417    /lib/tls/i686/cmov/libc-2.10.1.so
> 00f15000-00f16000 rw-p 00140000 08:01
> 1967417    /lib/tls/i686/cmov/libc-2.10.1.so
> 00f16000-00f19000 rw-p 00000000 00:00 0
> 00f53000-00f6e000 r-xp 00000000 08:01 146        /lib/ld-2.10.1.so
> 00f6e000-00f6f000 r--p 0001a000 08:01 146        /lib/ld-2.10.1.so
> 00f6f000-00f70000 rw-p 0001b000 08:01 146        /lib/ld-2.10.1.so
> 08048000-0807b000 r-xp 00000000 08:01 4134       /usr/bin/shp2pgsql
> 0807b000-0807c000 r--p 00032000 08:01 4134       /usr/bin/shp2pgsql
> 0807c000-0807d000 rw-p 00033000 08:01 4134       /usr/bin/shp2pgsql
> 084a6000-084c7000 rw-p 00000000 00:00 0          [heap]
> b7600000-b7621000 rw-p 00000000 00:00 0
> b7621000-b7700000 ---p 00000000 00:00 0
> b77f4000-b77f6000 rw-p 00000000 00:00 0
> b7800000-b7801000 rw-p 00000000 00:00 0
> b7801000-b7808000 r--s 00000000 08:01
> 534863     /usr/lib/gconv/gconv-modules.cache
> b7808000-b780d000 rw-p 00000000 00:00 0
> bf7f9000-bf80e000 rw-p 00000000 00:00 0          [stack]
> Abortado
>
> I really have to do an update on this old versions of postgresql
> +postgis!!! :-)
> Perhaps the question is already solved, but if not, this could be
> helpful.
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



-- 
María Arias de Reyna Domínguez
Área de Operaciones

Emergya Consultoría 
Tfno: +34 954 51 75 77 / +34 607 43 74 27
Fax: +34 954 51 64 73 
www.emergya.es