Re: [postgis-users] ERROR: Operation on two geometries with different SRIDs

2011-11-07 Thread Stefan Schwarzer
>> Now, trying to import it with: >> >>shp2pgsql -s EPSG:26191 -I -D morocco.shp morocco> morocco.sql >>psql -U my_database< morocco.sql > > Hi Stefan, > > The SRID argument to shp2pgsql should just be a plain numeric field, and not > have the EPSG prefix in front of it,

Re: [postgis-users] ERROR: Operation on two geometries with different SRIDs

2011-11-07 Thread Mark Cave-Ayland
On 07/11/11 14:07, Stefan Schwarzer wrote: Now, trying to import it with: shp2pgsql -s EPSG:26191 -I -D morocco.shp morocco> morocco.sql psql -U my_database< morocco.sql Hi Stefan, The SRID argument to shp2pgsql should just be a plain numeric field, and not have the E

Re: [postgis-users] ERROR: Operation on two geometries with different SRIDs

2011-11-07 Thread Nicolas Ribot
On 7 November 2011 15:07, Stefan Schwarzer wrote: > Hi there, > > I am somewhat fighting with the projection of my file. > > I have a file for Morocco, which, after ArcMap, has the following projection: > >       Projected Coordinate System:     zone1 >       Projection:      Lambert_Conformal_Con

[postgis-users] ERROR: Operation on two geometries with different SRIDs

2011-11-07 Thread Stefan Schwarzer
Hi there, I am somewhat fighting with the projection of my file. I have a file for Morocco, which, after ArcMap, has the following projection: Projected Coordinate System: zone1 Projection: Lambert_Conformal_Conic False_Easting: 50. False_Northi

Re: [postgis-users] ERROR: Operation on two GEOMETRIES with different SRIDs (again)

2011-02-14 Thread Nicklas Avén
Hallo You have two problems here first You don't transform the geometr to another srid with set_srid, you just tell what srid the geometry has. use ST_Transform instead second. Do your transformation into a new table or at least into a new column to don't get in trouble with srid-constraints.

[postgis-users] ERROR: Operation on two GEOMETRIES with different SRIDs (again)

2011-02-14 Thread Farrukh Najmi
I have a table GeometryValueType with column of type geometry and name geometry. From advice received on a previous thread on this list I have made sure that all data in geometry column has the same SRID. Currently them SRID is 4326 (EPSG:4326). I would now like to transform all values ion the

Re: [postgis-users] ERROR: Operation on two geometries with different SRIDs

2008-01-15 Thread Kevin Neufeld
What do you get when you issue this query? SELECT ST_SRID(the_geom), count(*) FROM "public"."kanagawa" GROUP BY ST_SRID; -- Kevin Andrea Maschio wrote: Hello, while trying to dome this query in geoserver, I've got the following error: ERROR: Operation on two geometries with different SRIDs. M

[postgis-users] ERROR: Operation on two geometries with different SRIDs

2008-01-15 Thread Andrea Maschio
Hello, while trying to dome this query in geoserver, I've got the following error: ERROR: Operation on two geometries with different SRIDs. My kanagawa table (downloaded from pgrouting sample app, was registered in geometry column with SRID 4326(manually by me). I cannot understand what's happe