I have a road network (in shapefile) which is in a projected system (e.g. EPSG:2100). I also have a number of GPS files in WGS84.
I have already stored the data into Oracle 12c (Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production) using just the Locator (and not Spatial and Graph).
I want to perform the following actions:
Create buffered geometries from the existing road links (i.e. linestring to polygon).
Transform the GPS points from WGS84 to EPSG:2100.
Match the (transformed) GPS points with the buffered road links.
When the data are displayed on a web page (with leaflet.js), I want to be able to define an area and select only the links and GPS signals contained in that area.
Will the Locator suffice for that? Obtaining license for Oracle Enterprise and Spatial and Graph is out of the question.
Trying to clarify things a bit further and make the question simpler, all I am asking is if the Oracle's equivalents of PostGIS' ST_Transform, ST_Buffer and ST_Contains are freely available with the Locator or the (paid) Spatial and Graph is required.