RE: [Geoserver-devel] Oracle WMS SRS?

GeoServer GeoServer Developer
1

I forgot to CC this to the list last time.

Basically, Im not sure how SRIDs are supposed to work in Oracle so Ive sort of ignored them. :frowning:

-----Original Message-----
From: Geoghegan, Sean
Sent: Friday, 16 July 2004 1:21 PM
To: 'scott o'
Subject: SEC:U RE: [Geoserver-devel] Oracle WMS SRS?

There are a couple of issues here.

Firstly, the Oracle data store doesn't really handle SRIDs very well. I am not really proficient in spatial reference systems in general or within Oracle. So when I coded the Oracle Datastore I just did it to the case of having no SRID defined. If you want to make changes to support this, it would be well accepted.

As I understand it, Oracle SRIDs are not compatible with EPSG codes so some translation would need to be done.

Secondly, Im not sure if/how the SRS code is actually passed to the data stores, perhaps one of the other developers can confirm this.

Sean

-----Original Message-----
From: geoserver-devel-admin@lists.sourceforge.net
[mailto:geoserver-devel-admin@lists.sourceforge.net] On Behalf Of
scott o
Sent: Friday, 16 July 2004 8:48 AM
To: geoserver-devel@lists.sourceforge.net
Subject: [Geoserver-devel] Oracle WMS SRS?

Hi -

I'm trying to test a WMS request with an Oracle Spatial backend. The
Oracle Spatial query appears to require that the SDO_SRID parameter be
defined within the SDO_GEOMETRY parameters of the query if the target
layer has an SDO_SRID defined. The SRS parameter is not being assigned
to the SDO_SRID and NULL is passed into the SQL query for the SDO_SRID
parameter (look in snippet below for: "About to execure query: SELECT
SOURCE, GID, ..."). The query works fine when issued within the
database if the NULL is replaced with 41177.

The problem is that the SRS parameter is not being passed to the
SDO_SRID field. I've tried valid EPSG codes, which I expected to pass
through, but all attempts pass a NULL.
Perhaps the problem is with the SQLEncoderOracle filter
(91527057 [FINE] org.geotools.filter.SQLEncoderOracle - Using NULL
SRID:)?

I'm using the 1.2.0-rc2 release rebuilt with the
gt2-oracle-spatial.jar posted on the geo181 task tracker (to overcome
connection problems), Tomcat 4.1.24, and Oracle
8.1.7 (and 10g) on Solaris 8.

Here's a snippet of the catalina.out:

91485375 [FINE] org.vfny.geoserver.global.Data - loading datastore
NV_GEOMETRY
91527015 [FINE]
org.vfny.geoserver.requests.readers.KvpRequestReader - clean request
is request=GetMap&layers=sclgis:NV_GEOMETRY&bbox
=489153,5433000,529000,5460816&width=800&height=400&srs=EPSG:4
1177&styles=normal&Format=image/svg
91527017 [FINE]
org.vfny.geoserver.requests.readers.KvpRequestReader - returning
parsed {SRS=EPSG:41177,
BBOX=489153,5433000,529000,5
460816, LAYERS=sclgis:NV_GEOMETRY, HEIGHT=400, REQUEST=GetMap,
STYLES=normal, WIDTH=800, FORMAT=image/svg}
91527019 [INFO]
org.vfny.geoserver.servlets.AbstractService - Looking for configured
service responses' strategy 91527020 [INFO]
org.vfny.geoserver.servlets.AbstractService - Looking for configured
service strategy SPEED
91527022 [FINE]
org.vfny.geoserver.servlets.AbstractService - verifying configured
strategy
91527023 [INFO]
org.vfny.geoserver.servlets.AbstractService - Using service strategy
class org.vfny.geoserver.servlets.SpeedStrategy
91527026 [FINE] org.vfny.geoserver.global.Data - getting type
sclgis:NV_GEOMETRY
91527028 [INFO]
org.vfny.geoserver.servlets.AbstractService - handling
request:
org.vfny.geoserver.requests.wms.GetMapRequest@anonymised.com
b
91527029 [FINE]
org.vfny.geoserver.servlets.AbstractService - strategy
is: org.vfny.geoserver.servlets.SpeedStrategy@anonymised.com
91527031 [FINE]
org.vfny.geoserver.responses.wms.map.SVGMapResponse - checking if can
producer image/svg, returningtrue
91527042 [FINE]
org.vfny.geoserver.servlets.AbstractService - mime type is:
image/svg+xml
91527045 [FINE]
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG - obtaining
FeatureReader for NV_GEOMETRY
91527055 [FINE] org.geotools.data.jdbc.JDBCDataStore - calling sql
builder with filter [ GEOMETRY bbox POLYGON
((489153 5433000, 4891
53 5460816, 529000 5460816, 529000 5433000, 489153
5433000)) ]
91527057 [FINE] org.geotools.filter.SQLEncoderOracle - Using NULL
SRID:
91527059 [FINE] org.geotools.data.jdbc.JDBCDataStore - sql is SELECT
SOURCE, GID, GEOMETRY FROM NV_GEOMETRY WHERE SDO_GEOM.RELATE("GE
OMETRY",'disjoint',MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO
_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(489153.0,5
433000.0,
489153.0,5460816.0,529000.0,5460816.0,529000.0,5433000.0,48915
3.0,5433000.0)),0.001)
= 'FALSE'
91527061 [FINE] org.geotools.data.jdbc.JDBCDataStore - About to
execure query: SELECT SOURCE, GID, GEOMETRY FROM NV_GEOMETRY WHERE SD
O_GEOM.RELATE("GEOMETRY",'disjoint',MDSYS.SDO_GEOMETRY(2003,NU
LL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE
_ARRAY(48
9153.0,5433000.0,489153.0,5460816.0,529000.0,5460816.0,529000.
0,5433000.0,489153.0,5433000.0)),0.001)
= 'FALSE'
91527063 [FINE] org.geotools.data.jdbc.ConnectionPool
- Getting available connection.
91529255 [SEVERE] org.geotools.data.jdbc.JDBCDataStore
- Error Performing SQL query
91529258 [WARNING] org.geotools.data.jdbc.JDBCUtils - Error closing
JDBC Statement
91529259 [FINE]
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager
- Connection closed - adding to available connections.
91529262 [FINE]
org.vfny.geoserver.responses.wms.GetMapResponse - asking delegate for
aborting the process
91529263 [INFO]
org.vfny.geoserver.servlets.AbstractService - Had an undefined error:
Error Performing SQL query
org.geotools.data.DataSourceException: Error Performing SQL query
        at
org.geotools.data.jdbc.JDBCDataStore.executeQuery(JDBCDataStor
e.java:850)
        at
org.geotools.data.jdbc.JDBCDataStore.getFeatureReader(JDBCData
Store.java:614)
        at
org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureS
ource.java:202)
        at
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG.writeLayers
(EncodeSVG.java:140)
        at
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG.encode(Enco
deSVG.java:57)
        at
org.vfny.geoserver.responses.wms.map.SVGMapResponse.writeTo(SV
GMapResponse.java:136)
        at
org.vfny.geoserver.responses.wms.GetMapResponse.writeTo(GetMap
Response.java:134)
        at
org.vfny.geoserver.servlets.AbstractService.doService(Abstract
Service.java:418)
        at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractServ
ice.java:232)
        at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doResponse(WmsDi
spatcher.java:135)
        at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doGet(WmsDispatc
her.java:106)
        at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java
Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

2

With respect to Oracle 9iR2, there is a table MDSYS.CS_SRS which gives the OGC Well Known Text (WKT) name and Oracle SRID for the coordinate systems it knows about (CS_SRS should be present in all object relational Oracle spatial dbs supporting coordinate reference systems - although I haven't checked 10g).

It must be possible to derive the WKT for EPSG coordinate systems, as per the OGC Coordinate Transformation Services spec, but I don't know of any software for doing that (using the EPSG MS Access database). According to http://postgis.refractions.net/docs/x321.html there should be a cross reference at http://www.opengis.org/techno/interop/EPSG2WKT.TXT, but it is no longer there. Maybe the Refractions team know all about EPSG/WKT mappings?

As well as suppliying an SRID in the SQL Encoder, the output should ideally require transformation to the SRS given in <feature type>/info.xml, as geometries within an Oracle Spatial table can be with respect to different coordinate systems (eg sampling points collected in different datums) - Oracle can do this.

Currently, Oracle GetFeature GML output quotes the feature type SRS and assumes it is right - as with shape files.

Unfortunately I can't do much on this till I have some results for http://docs.codehaus.org/display/GEOTOOLS/Community+Schema+Support+and+Complex+Types?showAttachments=true#attachments, but would like to help out.

Cheers
Peter Barrs
Social Change Online

Geoghegan, Sean wrote:

I forgot to CC this to the list last time.

Basically, Im not sure how SRIDs are supposed to work in Oracle so Ive sort of ignored them. :frowning:

-----Original Message-----
From: Geoghegan, Sean Sent: Friday, 16 July 2004 1:21 PM
To: 'scott o'
Subject: SEC:U RE: [Geoserver-devel] Oracle WMS SRS?

There are a couple of issues here.

Firstly, the Oracle data store doesn't really handle SRIDs very well. I am not really proficient in spatial reference systems in general or within Oracle. So when I coded the Oracle Datastore I just did it to the case of having no SRID defined. If you want to make changes to support this, it would be well accepted.

As I understand it, Oracle SRIDs are not compatible with EPSG codes so some translation would need to be done.

Secondly, Im not sure if/how the SRS code is actually passed to the data stores, perhaps one of the other developers can confirm this.

Sean

-----Original Message-----
From: geoserver-devel-admin@lists.sourceforge.net
[mailto:geoserver-devel-admin@lists.sourceforge.net] On Behalf Of scott o
Sent: Friday, 16 July 2004 8:48 AM
To: geoserver-devel@lists.sourceforge.net
Subject: [Geoserver-devel] Oracle WMS SRS?

Hi -

I'm trying to test a WMS request with an Oracle Spatial backend. The Oracle Spatial query appears to require that the SDO_SRID parameter be defined within the SDO_GEOMETRY parameters of the query if the target layer has an SDO_SRID defined. The SRS parameter is not being assigned to the SDO_SRID and NULL is passed into the SQL query for the SDO_SRID parameter (look in snippet below for: "About to execure query: SELECT SOURCE, GID, ..."). The query works fine when issued within the database if the NULL is replaced with 41177.

The problem is that the SRS parameter is not being passed to the SDO_SRID field. I've tried valid EPSG codes, which I expected to pass through, but all attempts pass a NULL.
Perhaps the problem is with the SQLEncoderOracle filter
(91527057 [FINE] org.geotools.filter.SQLEncoderOracle - Using NULL SRID:)?

I'm using the 1.2.0-rc2 release rebuilt with the gt2-oracle-spatial.jar posted on the geo181 task tracker (to overcome connection problems), Tomcat 4.1.24, and Oracle
8.1.7 (and 10g) on Solaris 8.

Here's a snippet of the catalina.out:

91485375 [FINE] org.vfny.geoserver.global.Data - loading datastore NV_GEOMETRY
91527015 [FINE]
org.vfny.geoserver.requests.readers.KvpRequestReader - clean request is request=GetMap&layers=sclgis:NV_GEOMETRY&bbox
=489153,5433000,529000,5460816&width=800&height=400&srs=EPSG:4
1177&styles=normal&Format=image/svg
91527017 [FINE]
org.vfny.geoserver.requests.readers.KvpRequestReader - returning parsed {SRS=EPSG:41177,
BBOX=489153,5433000,529000,5
460816, LAYERS=sclgis:NV_GEOMETRY, HEIGHT=400, REQUEST=GetMap, STYLES=normal, WIDTH=800, FORMAT=image/svg}
91527019 [INFO]
org.vfny.geoserver.servlets.AbstractService - Looking for configured service responses' strategy 91527020 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service strategy SPEED
91527022 [FINE]
org.vfny.geoserver.servlets.AbstractService - verifying configured strategy
91527023 [INFO]
org.vfny.geoserver.servlets.AbstractService - Using service strategy class org.vfny.geoserver.servlets.SpeedStrategy
91527026 [FINE] org.vfny.geoserver.global.Data - getting type sclgis:NV_GEOMETRY
91527028 [INFO]
org.vfny.geoserver.servlets.AbstractService - handling
request:
org.vfny.geoserver.requests.wms.GetMapRequest@anonymised.com
b
91527029 [FINE]
org.vfny.geoserver.servlets.AbstractService - strategy
is: org.vfny.geoserver.servlets.SpeedStrategy@anonymised.com
91527031 [FINE]
org.vfny.geoserver.responses.wms.map.SVGMapResponse - checking if can producer image/svg, returningtrue
91527042 [FINE]
org.vfny.geoserver.servlets.AbstractService - mime type is: image/svg+xml
91527045 [FINE]
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG - obtaining FeatureReader for NV_GEOMETRY
91527055 [FINE] org.geotools.data.jdbc.JDBCDataStore - calling sql builder with filter [ GEOMETRY bbox POLYGON
((489153 5433000, 4891
53 5460816, 529000 5460816, 529000 5433000, 489153
5433000)) ]
91527057 [FINE] org.geotools.filter.SQLEncoderOracle - Using NULL SRID:
91527059 [FINE] org.geotools.data.jdbc.JDBCDataStore - sql is SELECT SOURCE, GID, GEOMETRY FROM NV_GEOMETRY WHERE SDO_GEOM.RELATE("GE OMETRY",'disjoint',MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO
_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(489153.0,5
433000.0,
489153.0,5460816.0,529000.0,5460816.0,529000.0,5433000.0,48915
3.0,5433000.0)),0.001)
= 'FALSE'
91527061 [FINE] org.geotools.data.jdbc.JDBCDataStore - About to execure query: SELECT SOURCE, GID, GEOMETRY FROM NV_GEOMETRY WHERE SD O_GEOM.RELATE("GEOMETRY",'disjoint',MDSYS.SDO_GEOMETRY(2003,NU
LL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE
_ARRAY(48
9153.0,5433000.0,489153.0,5460816.0,529000.0,5460816.0,529000.
0,5433000.0,489153.0,5433000.0)),0.001)
= 'FALSE'
91527063 [FINE] org.geotools.data.jdbc.ConnectionPool
- Getting available connection.
91529255 [SEVERE] org.geotools.data.jdbc.JDBCDataStore
- Error Performing SQL query
91529258 [WARNING] org.geotools.data.jdbc.JDBCUtils - Error closing JDBC Statement
91529259 [FINE]
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager
- Connection closed - adding to available connections.
91529262 [FINE]
org.vfny.geoserver.responses.wms.GetMapResponse - asking delegate for aborting the process
91529263 [INFO]
org.vfny.geoserver.servlets.AbstractService - Had an undefined error: Error Performing SQL query
org.geotools.data.DataSourceException: Error Performing SQL query
       at
org.geotools.data.jdbc.JDBCDataStore.executeQuery(JDBCDataStor
e.java:850)
       at
org.geotools.data.jdbc.JDBCDataStore.getFeatureReader(JDBCData
Store.java:614)
       at
org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureS
ource.java:202)
       at
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG.writeLayers
(EncodeSVG.java:140)
       at
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG.encode(Enco
deSVG.java:57)
       at
org.vfny.geoserver.responses.wms.map.SVGMapResponse.writeTo(SV
GMapResponse.java:136)
       at
org.vfny.geoserver.responses.wms.GetMapResponse.writeTo(GetMap
Response.java:134)
       at
org.vfny.geoserver.servlets.AbstractService.doService(Abstract
Service.java:418)
       at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractServ
ice.java:232)
       at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
       at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doResponse(WmsDi
spatcher.java:135)
       at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doGet(WmsDispatc
her.java:106)
       at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
       at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

3

Further to this -Oracle 8i may need separate support to Oracle 9i and later - 8i doesn't support coordinate systems from memory.

Peter Barrs wrote:

With respect to Oracle 9iR2, there is a table MDSYS.CS_SRS which gives the OGC Well Known Text (WKT) name and Oracle SRID for the coordinate systems it knows about (CS_SRS should be present in all object relational Oracle spatial dbs supporting coordinate reference systems - although I haven't checked 10g).

It must be possible to derive the WKT for EPSG coordinate systems, as per the OGC Coordinate Transformation Services spec, but I don't know of any software for doing that (using the EPSG MS Access database). According to http://postgis.refractions.net/docs/x321.html there should be a cross reference at http://www.opengis.org/techno/interop/EPSG2WKT.TXT, but it is no longer there. Maybe the Refractions team know all about EPSG/WKT mappings?

As well as suppliying an SRID in the SQL Encoder, the output should ideally require transformation to the SRS given in <feature type>/info.xml, as geometries within an Oracle Spatial table can be with respect to different coordinate systems (eg sampling points collected in different datums) - Oracle can do this.

Currently, Oracle GetFeature GML output quotes the feature type SRS and assumes it is right - as with shape files.

Unfortunately I can't do much on this till I have some results for http://docs.codehaus.org/display/GEOTOOLS/Community+Schema+Support+and+Complex+Types?showAttachments=true#attachments, but would like to help out.

Cheers
Peter Barrs
Social Change Online

Geoghegan, Sean wrote:

I forgot to CC this to the list last time.

Basically, Im not sure how SRIDs are supposed to work in Oracle so Ive sort of ignored them. :frowning:

-----Original Message-----
From: Geoghegan, Sean Sent: Friday, 16 July 2004 1:21 PM
To: 'scott o'
Subject: SEC:U RE: [Geoserver-devel] Oracle WMS SRS?

There are a couple of issues here.

Firstly, the Oracle data store doesn't really handle SRIDs very well. I am not really proficient in spatial reference systems in general or within Oracle. So when I coded the Oracle Datastore I just did it to the case of having no SRID defined. If you want to make changes to support this, it would be well accepted.

As I understand it, Oracle SRIDs are not compatible with EPSG codes so some translation would need to be done.

Secondly, Im not sure if/how the SRS code is actually passed to the data stores, perhaps one of the other developers can confirm this.

Sean

-----Original Message-----
From: geoserver-devel-admin@lists.sourceforge.net
[mailto:geoserver-devel-admin@lists.sourceforge.net] On Behalf Of scott o
Sent: Friday, 16 July 2004 8:48 AM
To: geoserver-devel@lists.sourceforge.net
Subject: [Geoserver-devel] Oracle WMS SRS?

Hi -

I'm trying to test a WMS request with an Oracle Spatial backend. The Oracle Spatial query appears to require that the SDO_SRID parameter be defined within the SDO_GEOMETRY parameters of the query if the target layer has an SDO_SRID defined. The SRS parameter is not being assigned to the SDO_SRID and NULL is passed into the SQL query for the SDO_SRID parameter (look in snippet below for: "About to execure query: SELECT SOURCE, GID, ..."). The query works fine when issued within the database if the NULL is replaced with 41177.

The problem is that the SRS parameter is not being passed to the SDO_SRID field. I've tried valid EPSG codes, which I expected to pass through, but all attempts pass a NULL.
Perhaps the problem is with the SQLEncoderOracle filter
(91527057 [FINE] org.geotools.filter.SQLEncoderOracle - Using NULL SRID:)?

I'm using the 1.2.0-rc2 release rebuilt with the gt2-oracle-spatial.jar posted on the geo181 task tracker (to overcome connection problems), Tomcat 4.1.24, and Oracle
8.1.7 (and 10g) on Solaris 8.

Here's a snippet of the catalina.out:

91485375 [FINE] org.vfny.geoserver.global.Data - loading datastore NV_GEOMETRY
91527015 [FINE]
org.vfny.geoserver.requests.readers.KvpRequestReader - clean request is request=GetMap&layers=sclgis:NV_GEOMETRY&bbox
=489153,5433000,529000,5460816&width=800&height=400&srs=EPSG:4
1177&styles=normal&Format=image/svg
91527017 [FINE]
org.vfny.geoserver.requests.readers.KvpRequestReader - returning parsed {SRS=EPSG:41177,
BBOX=489153,5433000,529000,5
460816, LAYERS=sclgis:NV_GEOMETRY, HEIGHT=400, REQUEST=GetMap, STYLES=normal, WIDTH=800, FORMAT=image/svg}
91527019 [INFO]
org.vfny.geoserver.servlets.AbstractService - Looking for configured service responses' strategy 91527020 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service strategy SPEED
91527022 [FINE]
org.vfny.geoserver.servlets.AbstractService - verifying configured strategy
91527023 [INFO]
org.vfny.geoserver.servlets.AbstractService - Using service strategy class org.vfny.geoserver.servlets.SpeedStrategy
91527026 [FINE] org.vfny.geoserver.global.Data - getting type sclgis:NV_GEOMETRY
91527028 [INFO]
org.vfny.geoserver.servlets.AbstractService - handling
request:
org.vfny.geoserver.requests.wms.GetMapRequest@anonymised.com
b
91527029 [FINE]
org.vfny.geoserver.servlets.AbstractService - strategy
is: org.vfny.geoserver.servlets.SpeedStrategy@anonymised.com
91527031 [FINE]
org.vfny.geoserver.responses.wms.map.SVGMapResponse - checking if can producer image/svg, returningtrue
91527042 [FINE]
org.vfny.geoserver.servlets.AbstractService - mime type is: image/svg+xml
91527045 [FINE]
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG - obtaining FeatureReader for NV_GEOMETRY
91527055 [FINE] org.geotools.data.jdbc.JDBCDataStore - calling sql builder with filter [ GEOMETRY bbox POLYGON
((489153 5433000, 4891
53 5460816, 529000 5460816, 529000 5433000, 489153
5433000)) ]
91527057 [FINE] org.geotools.filter.SQLEncoderOracle - Using NULL SRID:
91527059 [FINE] org.geotools.data.jdbc.JDBCDataStore - sql is SELECT SOURCE, GID, GEOMETRY FROM NV_GEOMETRY WHERE SDO_GEOM.RELATE("GE OMETRY",'disjoint',MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO
_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(489153.0,5
433000.0,
489153.0,5460816.0,529000.0,5460816.0,529000.0,5433000.0,48915
3.0,5433000.0)),0.001)
= 'FALSE'
91527061 [FINE] org.geotools.data.jdbc.JDBCDataStore - About to execure query: SELECT SOURCE, GID, GEOMETRY FROM NV_GEOMETRY WHERE SD O_GEOM.RELATE("GEOMETRY",'disjoint',MDSYS.SDO_GEOMETRY(2003,NU
LL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE
_ARRAY(48
9153.0,5433000.0,489153.0,5460816.0,529000.0,5460816.0,529000.
0,5433000.0,489153.0,5433000.0)),0.001)
= 'FALSE'
91527063 [FINE] org.geotools.data.jdbc.ConnectionPool
- Getting available connection.
91529255 [SEVERE] org.geotools.data.jdbc.JDBCDataStore
- Error Performing SQL query
91529258 [WARNING] org.geotools.data.jdbc.JDBCUtils - Error closing JDBC Statement
91529259 [FINE]
org.geotools.data.jdbc.ConnectionPool$ConnectionListManager
- Connection closed - adding to available connections.
91529262 [FINE]
org.vfny.geoserver.responses.wms.GetMapResponse - asking delegate for aborting the process
91529263 [INFO]
org.vfny.geoserver.servlets.AbstractService - Had an undefined error: Error Performing SQL query
org.geotools.data.DataSourceException: Error Performing SQL query
       at
org.geotools.data.jdbc.JDBCDataStore.executeQuery(JDBCDataStor
e.java:850)
       at
org.geotools.data.jdbc.JDBCDataStore.getFeatureReader(JDBCData
Store.java:614)
       at
org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureS
ource.java:202)
       at
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG.writeLayers
(EncodeSVG.java:140)
       at
org.vfny.geoserver.responses.wms.map.svg.EncodeSVG.encode(Enco
deSVG.java:57)
       at
org.vfny.geoserver.responses.wms.map.SVGMapResponse.writeTo(SV
GMapResponse.java:136)
       at
org.vfny.geoserver.responses.wms.GetMapResponse.writeTo(GetMap
Response.java:134)
       at
org.vfny.geoserver.servlets.AbstractService.doService(Abstract
Service.java:418)
       at
org.vfny.geoserver.servlets.AbstractService.doGet(AbstractServ
ice.java:232)
       at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
       at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doResponse(WmsDi
spatcher.java:135)
       at
org.vfny.geoserver.servlets.wms.WmsDispatcher.doGet(WmsDispatc
her.java:106)
       at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
       at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

       __________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--
Peter Barrs
Web Map Team
Social Change Online

Brisbane:

Ph +61 (0)7 3354 1623
19 Ryland St
Grovely Qld 4054
Australia

Sydney Head Office:

Ph +61 (0)2 9692 5100

http://webmap.socialchange.net.au/
http://socialchange.net.au/

4

Ok, I believe I've got this fixed - at least I made a spatial table that
used srids, and defined the srid in the USER_SDO_GEOM_METADATA table
and was able to return without choking. Basically I took the exact
same tactic as postgis - lookup the srid in the meta column (in this
case USER_SDO_GEOM_METADATA, so this is needed - I think Sean actually
did this before, but was using sdoapi.jar objects - I just do a lookup
in the table directly with sql statements. So any request coming in
just uses the defined srid. Eventually the WFS 1.1 spec will have us
do reprojection and we can revisit this, but this should fix things for
now.

This is not a deep fix, I don't truly understand oracle and srids, but
it works on my machine.

The fix is on the 2.0.x branch of geotools - I'll put it on geoserver
cvs soon and it will be in the next release. Let me know if you want
it sooner.

Chris

>
> Geoghegan, Sean wrote:
>
>> I forgot to CC this to the list last time.
>>
>> Basically, Im not sure how SRIDs are supposed to work in Oracle so
>> Ive sort of ignored them. :frowning:
>>
>>
>>
>> -----Original Message-----
>> From: Geoghegan, Sean Sent: Friday, 16 July 2004 1:21 PM
>> To: 'scott o'
>> Subject: SEC:U RE: [Geoserver-devel] Oracle WMS SRS?
>>
>> There are a couple of issues here.
>>
>> Firstly, the Oracle data store doesn't really handle SRIDs very
>> well. I am not really proficient in spatial reference systems in
>> general or within Oracle. So when I coded the Oracle Datastore I
>> just did it to the case of having no SRID defined. If you want to
>> make changes to support this, it would be well accepted.
>>
>> As I understand it, Oracle SRIDs are not compatible with EPSG
codes
>> so some translation would need to be done.
>>
>> Secondly, Im not sure if/how the SRS code is actually passed to
the
>> data stores, perhaps one of the other developers can confirm this.
>>
>> Sean
>>
>>
>>> -----Original Message-----
>>> From: geoserver-devel-admin@lists.sourceforge.net
>>> [mailto:geoserver-devel-admin@lists.sourceforge.net] On Behalf Of
>>> scott o
>>> Sent: Friday, 16 July 2004 8:48 AM
>>> To: geoserver-devel@lists.sourceforge.net
>>> Subject: [Geoserver-devel] Oracle WMS SRS?
>>>
>>> Hi -
>>>
>>> I'm trying to test a WMS request with an Oracle Spatial backend.
The
>>> Oracle Spatial query appears to require that the SDO_SRID
parameter
>>> be defined within the SDO_GEOMETRY parameters of the query if the
>>> target layer has an SDO_SRID defined. The SRS parameter is not
being
>>> assigned to the SDO_SRID and NULL is passed into the SQL query
for
>>> the SDO_SRID parameter (look in snippet below for: "About to
execure
>>> query: SELECT SOURCE, GID, ..."). The query works fine when
issued
>>> within the database if the NULL is replaced with 41177.
>>>
>>> The problem is that the SRS parameter is not being passed to the
>>> SDO_SRID field. I've tried valid EPSG codes, which I expected to
>>> pass through, but all attempts pass a NULL.
>>> Perhaps the problem is with the SQLEncoderOracle filter
>>> (91527057 [FINE] org.geotools.filter.SQLEncoderOracle - Using
NULL
>>> SRID:)?
>>>
>>> I'm using the 1.2.0-rc2 release rebuilt with the
>>> gt2-oracle-spatial.jar posted on the geo181 task tracker (to
>>> overcome connection problems), Tomcat 4.1.24, and Oracle
>>> 8.1.7 (and 10g) on Solaris 8.
>>>
>>> Here's a snippet of the catalina.out:
>>>
>>> 91485375 [FINE] org.vfny.geoserver.global.Data - loading
datastore
>>> NV_GEOMETRY
>>> 91527015 [FINE]
>>> org.vfny.geoserver.requests.readers.KvpRequestReader - clean
request
>>> is request=GetMap&layers=sclgis:NV_GEOMETRY&bbox
>>> =489153,5433000,529000,5460816&width=800&height=400&srs=EPSG:4
>>> 1177&styles=normal&Format=image/svg
>>> 91527017 [FINE]
>>> org.vfny.geoserver.requests.readers.KvpRequestReader - returning
>>> parsed {SRS=EPSG:41177,
>>> BBOX=489153,5433000,529000,5
>>> 460816, LAYERS=sclgis:NV_GEOMETRY, HEIGHT=400, REQUEST=GetMap,
>>> STYLES=normal, WIDTH=800, FORMAT=image/svg}
>>> 91527019 [INFO]
>>> org.vfny.geoserver.servlets.AbstractService - Looking for
configured
>>> service responses' strategy 91527020 [INFO]
>>> org.vfny.geoserver.servlets.AbstractService - Looking for
configured
>>> service strategy SPEED
>>> 91527022 [FINE]
>>> org.vfny.geoserver.servlets.AbstractService - verifying
configured
>>> strategy
>>> 91527023 [INFO]
>>> org.vfny.geoserver.servlets.AbstractService - Using service
strategy
>>> class org.vfny.geoserver.servlets.SpeedStrategy
>>> 91527026 [FINE] org.vfny.geoserver.global.Data - getting type
>>> sclgis:NV_GEOMETRY
>>> 91527028 [INFO]
>>> org.vfny.geoserver.servlets.AbstractService - handling
>>> request:
>>> org.vfny.geoserver.requests.wms.GetMapRequest@anonymised.com
>>> b
>>> 91527029 [FINE]
>>> org.vfny.geoserver.servlets.AbstractService - strategy
>>> is: org.vfny.geoserver.servlets.SpeedStrategy@anonymised.com
>>> 91527031 [FINE]
>>> org.vfny.geoserver.responses.wms.map.SVGMapResponse - checking if
>>> can producer image/svg, returningtrue
>>> 91527042 [FINE]
>>> org.vfny.geoserver.servlets.AbstractService - mime type is:
>>> image/svg+xml
>>> 91527045 [FINE]
>>> org.vfny.geoserver.responses.wms.map.svg.EncodeSVG - obtaining
>>> FeatureReader for NV_GEOMETRY
>>> 91527055 [FINE] org.geotools.data.jdbc.JDBCDataStore - calling
sql
>>> builder with filter [ GEOMETRY bbox POLYGON
>>> ((489153 5433000, 4891
>>> 53 5460816, 529000 5460816, 529000 5433000, 489153
>>> 5433000)) ]
>>> 91527057 [FINE] org.geotools.filter.SQLEncoderOracle - Using NULL
SRID:
>>> 91527059 [FINE] org.geotools.data.jdbc.JDBCDataStore - sql is
SELECT
>>> SOURCE, GID, GEOMETRY FROM NV_GEOMETRY WHERE SDO_GEOM.RELATE("GE
>>> OMETRY",'disjoint',MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO
>>> _ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(489153.0,5
>>> 433000.0,
>>> 489153.0,5460816.0,529000.0,5460816.0,529000.0,5433000.0,48915
>>> 3.0,5433000.0)),0.001)
>>> = 'FALSE'
>>> 91527061 [FINE] org.geotools.data.jdbc.JDBCDataStore - About to
>>> execure query: SELECT SOURCE, GID, GEOMETRY FROM NV_GEOMETRY
WHERE
>>> SD O_GEOM.RELATE("GEOMETRY",'disjoint',MDSYS.SDO_GEOMETRY(2003,NU
>>> LL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE
>>> _ARRAY(48
>>> 9153.0,5433000.0,489153.0,5460816.0,529000.0,5460816.0,529000.
>>> 0,5433000.0,489153.0,5433000.0)),0.001)
>>> = 'FALSE'
>>> 91527063 [FINE] org.geotools.data.jdbc.ConnectionPool
>>> - Getting available connection.
>>> 91529255 [SEVERE] org.geotools.data.jdbc.JDBCDataStore
>>> - Error Performing SQL query
>>> 91529258 [WARNING] org.geotools.data.jdbc.JDBCUtils - Error
closing
>>> JDBC Statement
>>> 91529259 [FINE]
>>> org.geotools.data.jdbc.ConnectionPool$ConnectionListManager
>>> - Connection closed - adding to available connections.
>>> 91529262 [FINE]
>>> org.vfny.geoserver.responses.wms.GetMapResponse - asking delegate
>>> for aborting the process
>>> 91529263 [INFO]
>>> org.vfny.geoserver.servlets.AbstractService - Had an undefined
>>> error: Error Performing SQL query
>>> org.geotools.data.DataSourceException: Error Performing SQL query
>>> at
>>> org.geotools.data.jdbc.JDBCDataStore.executeQuery(JDBCDataStor
>>> e.java:850)
>>> at
>>> org.geotools.data.jdbc.JDBCDataStore.getFeatureReader(JDBCData
>>> Store.java:614)
>>> at
>>> org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureS
>>> ource.java:202)
>>> at
>>> org.vfny.geoserver.responses.wms.map.svg.EncodeSVG.writeLayers
>>> (EncodeSVG.java:140)
>>> at
>>> org.vfny.geoserver.responses.wms.map.svg.EncodeSVG.encode(Enco
>>> deSVG.java:57)
>>> at
>>> org.vfny.geoserver.responses.wms.map.SVGMapResponse.writeTo(SV
>>> GMapResponse.java:136)
>>> at
>>> org.vfny.geoserver.responses.wms.GetMapResponse.writeTo(GetMap
>>> Response.java:134)
>>> at
>>> org.vfny.geoserver.servlets.AbstractService.doService(Abstract
>>> Service.java:418)
>>> at
>>> org.vfny.geoserver.servlets.AbstractService.doGet(AbstractServ
>>> ice.java:232)
>>> at
>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
>>> at
>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>>> at
>>> org.vfny.geoserver.servlets.wms.WmsDispatcher.doResponse(WmsDi
>>> spatcher.java:135)
>>> at
>>> org.vfny.geoserver.servlets.wms.WmsDispatcher.doGet(WmsDispatc
>>> her.java:106)
>>> at
>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
>>> at
>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>>>
>>>
>>>
>>>
>>>
>>> __________________________________
>>> Do you Yahoo!?
>>> New and Improved Yahoo! Mail - 100MB free storage!
>>> http://promotions.yahoo.com/new_mail
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java
>>> Enterprise J2EE developer tools!
>>> Get your free copy of BEA WebLogic Workshop 8.1 today.
>>> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
>>> _______________________________________________
>>> Geoserver-devel mailing list
>>> Geoserver-devel@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>>>
>>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by BEA Weblogic Workshop
>> FREE Java Enterprise J2EE developer tools!
>> Get your free copy of BEA WebLogic Workshop 8.1 today.
>> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
>> _______________________________________________
>> Geoserver-devel mailing list
>> Geoserver-devel@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>>
>>
>>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by BEA Weblogic Workshop
> FREE Java Enterprise J2EE developer tools!
> Get your free copy of BEA WebLogic Workshop 8.1 today.
> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
> _______________________________________________
> Geoserver-devel mailing list
> Geoserver-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>

--
Peter Barrs
Web Map Team
Social Change Online

Brisbane:

Ph +61 (0)7 3354 1623
19 Ryland St
Grovely Qld 4054
Australia

Sydney Head Office:

Ph +61 (0)2 9692 5100

http://webmap.socialchange.net.au/
http://socialchange.net.au/

-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/

From MAILER-DAEMON Thu Jul 22 13:43:20 2004
From: Mail Delivery Service <postmaster@anonymised.com>
To: geoserver-devel@anonymised.com
Message-ID: <40FFBC380005F1DB@anonymised.com>
MIME-Version: 1.0
Content-Type: Multipart/Report; report-type=delivery-status; boundary="========/40FFBC380005F1D8/henderson.inet.fi"
X-Spam-Score: 0.0 (/)
X-Spam-Report: Spam Filtering performed by sourceforge.net.
  See http://spamassassin.org/tag/ for more details.
  Report problems to http://sf.net/tracker/?func=add&group_id=1&atid=200001
  0.0 SF_CHICKENPOX_SLASH BODY: Text interparsed with /
  0.0 SF_CHICKENPOX_MINUS BODY: Text interparsed with -
  0.0 SF_CHICKENPOX_AT BODY: Text interparsed with @
  0.0 SF_CHICKENPOX_PERIOD BODY: Text interparsed with .
Subject: [Geoserver-devel] Delivery Status Notification
Sender: geoserver-devel-admin@lists.sourceforge.net
Errors-To: geoserver-devel-admin@lists.sourceforge.net
X-BeenThere: geoserver-devel@lists.sourceforge.net
X-Mailman-Version: 2.0.9-sf.net
Precedence: bulk
List-Unsubscribe: <https://lists.sourceforge.net/lists/listinfo/geoserver-devel&gt;,
  <mailto:geoserver-devel-request@lists.sourceforge.net?subject=unsubscribe>
List-Id: Geoserver Developers' List <geoserver-devel.lists.sourceforge.net>
List-Post: <mailto:geoserver-devel@lists.sourceforge.net>
List-Help: <mailto:geoserver-devel-request@lists.sourceforge.net?subject=help>
List-Subscribe: <https://lists.sourceforge.net/lists/listinfo/geoserver-devel&gt;,
  <mailto:geoserver-devel-request@lists.sourceforge.net?subject=subscribe>
List-Archive: <http://sourceforge.net/mailarchive/forum.php?forum=geoserver-devel&gt;
Date: Thu Jul 22 13:44:03 2004
X-Original-Date: Thu, 22 Jul 2004 23:43:16 +0300

This multi-part MIME message contains a Delivery Status Notification.
If you can see this text, your mail client may not be able to understand MIME
formatted messages or DSNs (see RFC 2045 through 2049 for general MIME
information and RFC 1891 through 1894 for DSN specific information).

--========/40FFBC380005F1D8/henderson.inet.fi
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 8bit

- These recipients of your message have been processed by the mail server:
panu.koski@anonymised.com; Failed; 5.1.1 (bad destination mailbox address)

    Remote MTA fep13.inet.fi: SMTP diagnostic: 550 Invalid recipient: <panu.koski@anonymised.com>

--========/40FFBC380005F1D8/henderson.inet.fi
Content-Type: Message/Delivery-Status

Reporting-MTA: dns; henderson.inet.fi
Received-from-MTA: dns; lists.sf.net (221.232.129.66)
Arrival-Date: Thu, 22 Jul 2004 23:43:16 +0300

Final-Recipient: rfc822; panu.koski@anonymised.com
Action: Failed
Status: 5.1.1 (bad destination mailbox address)
Remote-MTA: dns; fep13.inet.fi
Diagnostic-Code: smtp; 550 Invalid recipient: <panu.koski@anonymised.com>

--========/40FFBC380005F1D8/henderson.inet.fi
Content-Type: Text/RFC822-headers

Return-Path: <geoserver-devel@anonymised.com>
Received: from lists.sf.net (221.232.129.66) by henderson.inet.fi (7.1.016.11)
        id 40FFBC380005F1D8 for panu.koski@anonymised.com; Thu, 22 Jul 2004 23:43:16 +0300
Message-ID: <40FFBC380005F1D8@anonymised.com> (added by postmaster@anonymised.com)
From: geoserver-devel@anonymised.com
To: panu.koski@anonymised.com
Subject: STATUS
Date: Fri, 23 Jul 2004 04:43:39 +0800
MIME-Version: 1.0
Content-Type: multipart/mixed;
  boundary="----=_NextPart_000_0007_E3A1E6CA.8A83A5BA"
X-Priority: 3
X-MSMail-Priority: Normal

--========/40FFBC380005F1D8/henderson.inet.fi--