RE: [Geoserver-devel] Oracle WMS SRS?

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

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.  :(

-----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: geo...@li...
> [mailto:geo...@li...] On Behalf Of 
> scott o
> Sent: Friday, 16 July 2004 8:48 AM
> To: geo...@li...
> 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@8845df8
> b
> 91527029 [FINE]
> org.vfny.geoserver.servlets.AbstractService - strategy
> is: org.vfny.geoserver.servlets.SpeedStrategy@1417095
> 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
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
> 