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

[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. My kanagawa table (downloaded from pgrouting sample app, was 
> registered in geometry column with SRID 4326(manually by me). I cannot 
> understand what's happening, because I simply don't understand wich is 
> the second geometry that (probably) has the SRDI=-1. Any clue?
>
> SELECT "gid", "length", "x1", "y1", "x2", "y2", "source", "target", 
> encode(AsBinary(force_2d("the_geom"), 'XDR'),'base64') FROM 
> "public"."kanagawa" WHERE "the_geom" && GeometryFromText('POLYGON 
> ((138.86892242431625 35.10309162139895, 138.86892242431625 
> 35.69988307952885, 139.90027313232477 35.69988307952885, 
> 139.90027313232477 35.10309162139895, 138.86892242431625 
> 35.10309162139895))', 4326) AND intersects("the_geom", 
> GeometryFromText('POLYGON ((138.86892242431625 35.10309162139895, 
> 138.86892242431625 35.69988307952885, 139.90027313232477 
> 35.69988307952885, 139.90027313232477 35.10309162139895, 
> 138.86892242431625 35.10309162139895))', 4326))
>
> Thanks
>
> Andrea Maschio
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>