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
-------------------------------------------------------------------------
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
