[postgis-users] Error while importing data

[strk at refractions.net]

On Mon, Mar 14, 2005 at 12:01:14PM +0000, Nigel Kukard wrote:
...
> 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

Nigel, you are "appending" to an existing table (all).

How did you create that table ?
You probably run AddGeometryColumn() once, specifying a different
dimension then '2', which is required by your shapefile.
I tried both creating and appending the shapefile and it works.

The "dimensions" constraint was not enforced in postgis 0.x, and
this seems to give problem to more then a user...

Do people think the check is better avoid ?

--strk;

> 
> 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
> >>>
> >>>
> >>>
> >>>
> 







> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users