Failure to reproject bounding box in KML
----------------------------------------
Key: GEOS-2073
URL: http://jira.codehaus.org/browse/GEOS-2073
Project: GeoServer
Issue Type: Bug
Affects Versions: 1.7.0-beta2, 1.7.0-RC1
Reporter: Arne Kepp
Assignee: Andrea Aime
Fix For: 1.7.0
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
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 message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira