[postgis-users] Error while importing data

[Nigel Kukard]

Hi, below error message, attached shapefiles


strk at refractions.net wrote:

>On Sun, Mar 13, 2005 at 03:10:23PM +0000, Nigel Kukard wrote:
>
>
>>Hi,
>>
>>I see quite a number more errors (the_geom constraint violations) with
>>1.0.0rcX, if I paste one of these for you, could you tell me why its
>>happening?
>>
>>
>
>
>

commands i used are..  (cvs snapshot of postgis-1.0.0, RCSID: $Id:
shp2pgsql.c,v 1.81 2005/03/08 11:06:33 strk Exp $)

shp2pgsql -a -D 2327BD_AIR_TRANSPORT_AREA_ALLFEATTYPES.shp all >
/tmp/air_transport.sql
psql -U postgres all < /tmp/air_transport.sql

here is the error....

BEGIN
ERROR:  new row for relation "air_transport_area" violates check
constraint "enforce_dims_the_geom"
CONTEXT:  COPY air_transport_area, line 1: "12006587    12006587
LANDING STRIP   AREA    2327BD  A     0        \N
000000000000000000000001        0       \N      MDP_2   0       0
20020522        ..."
ROLLBACK


attached is the shapefiles i am trying to import.

Thanks for your help!!!

Regards
Nigel

>The message says you're trying to load a differently-dimensioned geometry
>in a table you created with a dimension constraint.
>The dimension constraint is added by AddGeometryColumn().
>
>If shp2pgsql did the whole thing (call AddGeometryColumn() and feed
>the geoms) we have a big bad bug, and having your case's shapefile
>would help fixing it.
>
>--strk;
>
>
>
>>Regards
>>Nigel
>>
>>strk at refractions.net wrote:
>>
>>
>>
>>>On Thu, Mar 10, 2005 at 06:00:20AM +0000, Nigel Kukard wrote:
>>>
>>>
>>>
>>>
>>>>Hi Guys,
>>>>
>>>>I'm new to postgis. I got shape files from our local government,
>>>>containing all data for South Afica.
>>>>
>>>>I installed postgresql 8.0.0, postgis 1.0.0-rc3, proj 4.4.9, gdal 1.2.5,
>>>>php-5.0.3 & mapserver 4.4.1
>>>>
>>>>The first thing i did is pipe lwpostgis.sql & spatial_ref_sys.sql into
>>>>pgsql.
>>>>
>>>>I continued to run shp2pgsql on one of the shape files to insert it into
>>>>my database with
>>>>shp2pgsql -d drainagexxxxx.shp drainage > /tmp/postgis.sql
>>>>
>>>>I then tried to pipe the /tmp/postgis.sql into postgresql,  but got the
>>>>following error...
>>>>
>>>>BEGIN
>>>>NOTICE:  CREATE TABLE will create implicit sequence "drainage_gid_seq"
>>>>for serial column "drainage.gid"
>>>>CREATE TABLE
>>>>                                addgeometrycolumn
>>>>---------------------------------------------------------------------------------------
>>>>public.drainage.the_geom SRID:-1 TYPE:MULTILINESTRING DIMS:4
>>>>geometry_column fixed:0
>>>>(1 row)
>>>>
>>>>ERROR:  Invalid type in wbk
>>>>
>>>>
>>>>
>>>>
>>>Nigel, we have fixed a (Multi)LineString-related bug in shp2pgsql.
>>>If you can test a CVS snapshot that would help us release RC4.
>>>
>>>--strk;
>>>
>>>
>>>
>>>
>>>
>>>
>>>>ERROR:  current transaction is aborted, commands ignored until end of
>>>>transaction block
>>>>ERROR:  current transaction is aborted, commands ignored until end of
>>>>transaction block
>>>>ERROR:  current transaction is aborted, commands ignored until end of
>>>>transaction block
>>>>ROLLBACK
>>>>
>>>>
>>>>most of the shape files import fine, there are a couple of types which
>>>>give me the above error.
>>>>
>>>>any help would greatly be appreciated, if need be I can attach the
>>>>actual sql file or any other info needed.
>>>>
>>>>Regards
>>>>Nigel Kukard
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>>_______________________________________________
>>>>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/20050314/3fce25bb/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2327BD_AIR_TRANSPORT_AREA_ALLFEATTYPES.dbf
Type: application/octet-stream
Size: 2624 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050314/3fce25bb/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2327BD_AIR_TRANSPORT_AREA_ALLFEATTYPES.shp
Type: application/octet-stream
Size: 524 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050314/3fce25bb/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2327BD_AIR_TRANSPORT_AREA_ALLFEATTYPES.shx
Type: application/octet-stream
Size: 124 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050314/3fce25bb/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050314/3fce25bb/attachment.pgp>