Hi,
I was trying to throw more data at our KML regionating stuff and ran
into the query below, which occurs when someone asks for a tile and the
H2 database has already been built.
null
Translator error
Could not aquire feature:org.geotools.data.DataSourceException: Error
Performing SQL query:
... query ...
ERROR: Operation on two geometries with different SRIDs
This database doesn't have anything but 4283 in it, so I am somewhat
curious what makes this error happen, but more importantly can we just
remove the bounding box filter? The result appears to be the same, and
no complaints from Postgis.
It's probably not cheap, and we shouldn't need it anyway I think. I'm
guessing at line 417 in KMLTransformer.java
-Arne
SELECT "ogc_fid", encode(asBinary(force_2d("geometry"),'XDR'),'base64'),
"gid", "pin", "class", "identifier", "purpose", "vesting", "name",
"name_stat", "legal_area", "clw_code", "category", "iucn" FROM
"public"."DEC-007" WHERE (((TRUE AND TRUE) AND "geometry" &&
GeometryFromText('POLYGON ((90 -45.000000042821874, 90 0, 135 0, 135
-45.000000042821874, 90 -45.000000042821874))', 4283)) AND ("ogc_fid" =
'1') OR ("ogc_fid" = '101') OR ("ogc_fid" = '102') OR ("ogc_fid" =
'103') OR ("ogc_fid" = '104') OR ("ogc_fid" = '105') OR ("ogc_fid" =
'1078') OR ("ogc_fid" = '1079') OR ("ogc_fid" = '129') OR ("ogc_fid" =
'1343') OR ("ogc_fid" = '1344') OR ("ogc_fid" = '1719') OR ("ogc_fid" =
'1720') OR ("ogc_fid" = '1827') OR ("ogc_fid" = '1839') OR ("ogc_fid" =
'1886') OR ("ogc_fid" = '1887') OR ("ogc_fid" = '1888') OR ("ogc_fid" =
'225') OR ("ogc_fid" = '691') OR ("ogc_fid" = '720') OR ("ogc_fid" =
'721') OR ("ogc_fid" = '722') OR ("ogc_fid" = '815') OR ("ogc_fid" =
'816') OR ("ogc_fid" = '817') OR ("ogc_fid" = '833') OR ("ogc_fid" =
'834') OR ("ogc_fid" = '835') OR ("ogc_fid" = '836'));
(The data is available if you ssh to atlas, then connect to -h
db.opengeo.org -d landgate , username and pass can be found on the wiki
page for demo.opengeo.org )
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
