In this session, we showed a new tool, Spatial Studio, that lets you quickly and easily do spatial analytics and create maps, even if you don't have GIS or Spatial knowledge. Now business users and non-GIS developers have a simple user interface to access the spatial features in Oracle Database.
Through step by step demos, we showed how to prepare your data for spatial analysis, perform spatial analysis operations, publish, and share the results – as well as how to access spatial analyses results via REST and incorporate in applications and workflows. Carol Palmer and David Lapp, product managers for Oracle Spatial and Graph, presented.
02:45 – Agenda, brief overview of Oracle Spatial and Graph
06:47 – What is Spatial Studio?
09:35 – Demo
09:35 – Intro, overview of pages in Studio
12:50 – Creating data sets
14:18 - Load data from a spreadsheet
17:00 – Prepare data: geocode addresses
21:40 – Add a shapefile and a Database table
23:10 – Exporting data sets
24:00 – Analyzing data sets – what spatial analysis do we want to do here?
25:55 – Create a project
26:20 – View addresses and regions on a map, and run spatial analysis (find all addresses in a specific region)
30:20 – View the underlying SQL and RESTful endpoint (GeoJSON) to access analysis result programmatically
31:28 – More spatial analysis
32:40 – Create an info window pop up (showing region for each address)
35:00 – Add coastal zone and calculate distance from each location to coastal zone
38:05 – Add an info window
39:30 – Map styling options, map filtering on the client
41:38 – Share map project with others, and publish project
42:48 – Exporting a project, eg to Oracle Data Visualization
44:20 – Functionality – recap of key features of Spatial Studio
46:24 – License – what products/services is Spatial Studio included with?
47:03 – Technical Requirements – what’s needed to run Spatial Studio
47:20 – Get Started – quickstart and download info
47:55 – V1 Limitations – some limitations to be aware of
49:10 – Resources – useful links for technical tips and info, and SIG interest group
Slides are available here: https://www.slideshare.net/JeanIhm/oracle-spatial-studio-fast-and-easy-spatial-a
Learn more about and download Spatial Studio: https://www.oracle.com/database/technologies/spatial-studio.html