[Geoserver-users] Antw: Re: generating kml from OracleDatastore

GeoServer GeoServer User
1

Hi Andrea,

Unfortunately your suggested nightly-built from yesterday effected no changes.
But i 'm still wondering, why the reprojection goes right if Output is image/png and goes wrong for KML ?
My Problem is that i don't have so much notion on Oracle Spatial Datastore.
But i try to understand and have taken a look at the Table USER_SDO_GEOM_METADATA. There's an entry for my Data Table with a Definition which Column contains the Geometry and a blank(!) Field for SRID.
Similar to Postgis ( geometry_columns) i've updated SRID to 2398, but this has no effect for GeoServer.
Therefor the UMN Mapserver(!) dies with the following Error :
<--
ORA-13208: Interner Fehler beim Auswerten von Operator [window SRID does not match layer SRID]
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", Zeile 259
ORA-06512: in Zeile 1
. Query statement: SELECT MI_PRINX, GEOLOC FROM baustelle_akt WHERE SDO_FILTER( GEOLOC, MDSYS.SDO_GEOMETRY(2003, NULL, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(4503976,5993791.95,4512424,6001887.95) ),&#39;querytype=window&#39:wink: = &#39;TRUE&#39; . Check your data statement.
-->
I have no Idea what goes wrong there . . .

Another Aspect is, that i define a SRS in the Configuration Section for FeatureType in GeoServer Admin Desk.
Shouldn't this enough information for Reprojection ?

greets

Ronald

--
Ronald Woita
http://geoportal.rostock.de
Hansestadt Rostock
Kataster-, Vermessungs- und Liegenschaftsamt
Holbeinplatz 14, 18069 Rostock
email: ronald.woita@anonymised.com
phone: +49 (0)381 - 381 6256

Andrea Aime <aaime@anonymised.com> 05.07.2007 15:46 >>>

Ronald Woita ha scritto:

Hi list,

I try to generate kml from Data in a Oracle Datastore.
the Coordinatesystem is epsg:2398, the Style is an external Graphic.

Everything works fine with the following WMS-Request (png) :
http://geoportal.rostock.de/geoserver/wms?service=WMS&request=GetMap&format=image/png&width=1024&height=1024&srs=EPSG:4326&layers=kvla:BAUSTELLE_AKT&styles=hro_baustellen&KMATTR=false&bbox=12.07,54.07,12.15,54.18

but the creation of kml with the next request fails with the message 'empty kml-File' :
http://geoportal.rostock.de/geoserver/wms?service=WMS&request=GetMap&format=application/vnd.google-earth.kml+XML&width=1024&height=1024&srs=EPSG:4326&layers=kvla:BAUSTELLE_AKT&styles=hro_baustellen&KMATTR=false&bbox=12.07,54.07,12.15,54.18

Ronald, Oracle data store in any released version has quite
some issues with SRS. We have an improved version or the
data store that works with most SRS, but it's unreleased.

Can you try downloading the latest snapshot here:
http://geo.openplans.org/nightly/1.5.x/
and coupling it with the following Oracle datastore:
http://geo.openplans.org/aaime/gt2-oracle-spatial-2.3.3-SNAPSHOT.jar

Anyways, the KML output should work even if the source SRS
is null... I've opened a Jira issue for this:
http://jira.codehaus.org/browse/GEOS-1192

Cheers
Andrea

2

Ronald Woita ha scritto:

Hi Andrea,

Unfortunately your suggested nightly-built from yesterday effected no changes.
But i 'm still wondering, why the reprojection goes right if Output is image/png and goes wrong for KML ?
My Problem is that i don't have so much notion on Oracle Spatial Datastore.
But i try to understand and have taken a look at the Table USER_SDO_GEOM_METADATA. There's an entry for my Data Table with a Definition which Column contains the Geometry and a blank(!) Field for SRID.
Similar to Postgis ( geometry_columns) i've updated SRID to 2398, but this has no effect for GeoServer.
Therefor the UMN Mapserver(!) dies with the following Error :
<--
ORA-13208: Interner Fehler beim Auswerten von Operator [window SRID does not match layer SRID]
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", Zeile 259
ORA-06512: in Zeile 1
. Query statement: SELECT MI_PRINX, GEOLOC FROM baustelle_akt WHERE SDO_FILTER( GEOLOC, MDSYS.SDO_GEOMETRY(2003, NULL, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(4503976,5993791.95,4512424,6001887.95) ),&#39;querytype=window&#39:wink: = &#39;TRUE&#39; . Check your data statement.
-->
I have no Idea what goes wrong there . . .

What's going on is that none of your data is setup with a CRS, and the index was already
created referring to a cartesian space, and now it fails because it sees there is a
inconsistency between the data and the bbox used for the request.

Another Aspect is, that i define a SRS in the Configuration Section for FeatureType in GeoServer Admin Desk.
Shouldn't this enough information for Reprojection ?

You're indeed right, and in fact the map rendering is using that one, the
KML generation has a completely different code path and apparently it's not using
that information. Can you open a Jira issue, so that we won't forget about
it, and eventually fix it soon?

Cheers
Andrea