[postgis-users] Importing shapefiles with srid != -1

[Obe, Regina]

James, 

Well the below looks okay except I notice that you are importing into a
table called

GISProvices

and the table definition you gave is for

GISProvinces

You don't happen to have two tables similarly named do you?  Maybe your
GISProvices was created with an SRID  of -1.

Hope that helps,
Regina 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
James Dominy
Sent: Friday, May 09, 2008 8:01 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Importing shapefiles with srid != -1

Hi all,

I have a shape file with an associated prj. The prj file says the shape
file is 
in WGS84, so I'm using

shp2pgsql -a -g gisdata -s 4326 provinces.shp GISProvices



When I run the result through psql, I get

ERROR: new row for relation "gisprovices" violates check constraint 
"enforce_srid_gisdata"



The table definition is as follows...

CREATE TABLE GISProvinces (
         region_id SERIAL PRIMARY KEY,
         name VARCHAR(255) NULL,
         layer INTEGER NOT NULL REFERENCES TGISLayer
);
SELECT AddGeometryColumn('', 'gisprovinces', 'gisdata', 4326,
'MULTIPOLYGON', 2);

Everything works fine if I don't specify any srid. As soon as I specify
an SRID 
for either the column or the inserts (via -s with shp2pgsql), or both,
even if 
they are the same, I get the error. What am I doing wrong?

Thanks,
James
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.