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

[James Dominy]

Obe, Regina wrote:
> 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 
Hi Regina,

Nope, that was a typo on my part

> 
> -----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 GISProvinces
> 
> 
> 
> When I run the result through psql, I get
> 
> ERROR: new row for relation "gisprovinces" 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.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users