Hi all,
for an upcoming project I will store point geometries in a Oracle DB. This DB
will serve as a data store for GeoServer which will be used for WMS Requests.
As I understand it Oracle handles the bounding box calculations (on behalf of
GeoServer), when there is a WMS request for certain features in a bbox. In
Oracle there seem to be two function for this: SDO_RELATE (which is in Locator
version) and SDO_GEOM.RELATE (available only in Oracle Spatial). Which one is
used by GeoServer?
I found this relevant link on the question (from 2012):
http://gis.stackexchange.com/questions/36751/querying-intersecting-areas-areas-oracle-locator-or-spatial
In the answer it says:
I once had to trace a GeoServer WMS query in Oracle and I'm pretty sure it used
the SDO_RELATE approach, but you might want to verify this using your own
trace, scanning through the GeoServer source, or posting a question on the
GeoServer users mailing list
Since I am not sure, I thought I'd just ask here ;-)
The project is just starting off and I need to know whether Locator is
sufficient or Spatial needs to be purchased (PostGIS cannot be used for other
reasons).
Best regards,
Jens
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
