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