This blog discusses more options for visualizing your Oracle spatial data. Whether you’re a business analyst working with BI dashboards or Excel files who wants to add map views quickly without coding, or an analyst or developer who wants easy access to spatial operations, there’s an option for you. These include Oracle Analytics Cloud and Oracle Spatial Studio.
Oracle Analytics Cloud
For users of business intelligence dashboards, Oracle Analytics Cloud has built-in mapping features. Spatial visualization in Oracle Analytics Cloud can be accessed via the Answers Dashboard. The Spatial Map Visualization Component is integrated with OAC and allows you to link your geospatial data with OAC data. This requires some expertise in OAC in order to create and configure your map layers.
There are many great map features available in OAC such as:
More information on creating maps and visualizing spatial data in OAC can be found here: Visualizing and Building Reports in OAC
In addition, there is a great OAC Blog
Oracle Spatial Studio
Spatial Studio is a self-service web application for spatial analytics and mapping. It can be used to visualize your raw tables from spatial in the database, but it is even more useful for visualizing your spatial analyses results. It’s designed for users with no spatial or GIS knowledge and provides access to a wide range of spatial operations which are typically hidden behind complex SQL syntax. Everything is done through mouse clicks and menu options.
Many tasks and daily operations faced by users are simplified with Spatial Studio. It provides an advanced web interface for loading your geospatial data into Oracle Database. Your source can be shapefiles, Excel spreadsheets, or GeoJSON files. Spatial Studio prepares the data for spatial analysis. You can then easily share the results of your spatial analyses and visualizations with others.
Spatial Studio has a developer API. When you build a spatial analytics application using the menu options, you can also see the underlying SQL to understand what is happening behind the scenes. This allows you to take the underlying SQL and write more complex SQL if you want to build more complex applications.
More information can be found here: Spatial Studio
Customer example: oracle.com AnD'20 site
Derek Hayden, OUTFRONT Media and Tim Vlamis, Vlamis Software Solutions