|
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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
