Oracle Spatial and Graph – technical tips, best practices, and news from the product team

Options for Visualizing Spatial Data in Oracle (Part 2)

Carol Palmer
Senior Principal Product Manager



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:

  • Associating a map layer to a data column directly in the data source definition so every map using that column (such as city column) will automatically use that correct layer for each map visualization included in your project – available in OAC5.5
  • Ability to add your own custom map layers
  • Creating clusters when mapping large sets of point data to more easily visualize the data on a map
  • Creating heatmap layers on a map visualization to identify the density or high concentration of point values or metric values associated with the points, such as identifying the high rent areas in a specific part of a city

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

Category 5 Analytics: How OUTFRONT Media Maps Hurricane Risk(pdf)Derek Hayden, OUTFRONT Media and Tim Vlamis, Vlamis Software Solutions


Join the discussion

Comments ( 1 )
  • Jean Wednesday, May 20, 2020
    Cool post Carol!
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.