In recent years, the demand for interoperability between proprietary databases and open-source Geographic Information System (GIS) tools has surged. This session aims to explore the seamless integration of Oracle Spatial, a leading spatial database management system, with popular open-source GIS tools like QGIS, GeoServer, and GDAL.
The session will delve into the technical intricacies of connecting Oracle Spatial with these open-source tools, highlighting deployment options in the Oracle Cloud, challenges, and best practices. Participants will gain insights into leveraging the robust capabilities of Oracle Spatial while harnessing the flexibility and community-driven development of open-source GIS tools.
Highlights:
02:17 Intro
05:17 Vector and Raster data using GDAL and Oracle Spatial (demo included)
32:39 QGIS and Oracle Spatial (demo included)
39:13 Geo Web Services using GeoServer and Oracle Spatial (demo included)
45:00 LiDAR data using LAStools and Oracle Spatial (demo included)
56:40 More information
58:30 Q&A
Links:
* GitHub repo for the AskTOM Spatial Series sessions: https://github.com/karinpatenge/asktom-spatial/
* Reference Architecture "Build a geospatial platform on Oracle Autonomous Database": https://docs.oracle.com/en/solutions/geospatial-platform-adw
* GDAL drivers for Oracle
* Vector: https://gdal.org/drivers/vector/oci.html
* Raster: https://gdal.org/drivers/raster/georaster.html
* Connect QGIS to an Autonomous Database: https://medium.com/oracledevs/connect-qgis-to-an-autonomous-database-686b6e947fe4
