Integrating Oracle Spatial and Google Maps
This Webinar will describe how by using PL/SQL you can load in images into an Oracle 11G database, extract the Geocoding information using Oracle Multimedia, store it in Oracle Spatial and then display this information along with additional EXIF information on a Google map.
Example photo's taken using an iPhone will be used. The presentation will also discuss how to generate dynamic Javascript to seamlessly integrate in with Google. The presentation assumes the listener has minimal to no experience with dealing with Oracle Spatial and Google Maps and will cover basics of spatial table creation, setup and indexing.
Example queries will be shown using Oracle Spatial, showing how simple it is to do queries like "find me all images within 3km of this point".
In addition, example code will be shown how to reverse engineer addresses into Geospatial Co-ordinates using the Google API. All PL/SQL code and table descriptions with storage parameters, will be made available.