We would like to provide Google Maps like features in Oracle Apex using Oracle Spatial. Oracle Spatial is of particular interest to us due to the fact that we are a part of Government and as such not accessing outside servers but instead hosting everything on our own server is very appealing to us. This is however quite a challenge since most of the Oracle Spatial demos and examples and tools seem to all use the Oracle site as the source of the maps and I have not found any information (except for the volumes and volumes of 500 page documents that Oracle provide that does not say much) on how to install the maps and the geocoder and driver directions so that they run from your local server instead. Finding out how to setup these and what you need is also a challenge.
We would also like to use Apex to do static and live/realtime geolocation, geofencing, geocoding, routing, turn by turn driver directions, heatmaps, etc. Jeff Kemp has made this nice plugin for Apex that does most of these, but there does not seem to be anything similar for Oracle Spatial:
https://github.com/jeffreykemp/jk64-plugin-reportmap
https://apex.oracle.com/pls/apex/f?p=15181:9:491097688861:::::
What is the best technology to accomplish something similar in Oracle Apex with Oracle Spatial while hosting it all on your local database server? Where can one find accessible and easy to understand technical information about it that includes example code?
To complicate things our Spatial is currently installed on the OBIEE server and Apex on a different database. It is also very difficult to find out which urls one has to use to access the mapviewer and how and which ports to open.
Any help would be much appreciated.