[Geoserver-users] Is Oracle Locator sufficient or do I need Oracle Spatial?

[Nachtigall, J. (init) <Jen...@in...>]

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