Oracle Spatial and Graph – technical tips, best practices, and news from the product team
-
Spatial and Graph,
Spatial Features
July 8, 2019
Spatial Studio - Hello World!
The newly released Oracle Spatial Studio ("Spatial Studio") simplifies spatial analysis and visualization capabilities in Oracle Database. This is the first installment of blog posts providing how-to, tips, best practices, and overall guidance in the use of Spatial Studio. We look forward to your feedback and creative uses of Spatial Studio!
For an overview of Oracle Spatial Studio, please visit the product page at https://www.oracle.com/database/technologies/spatial-studio.html. Spatial Studio is provided as both a deployable Java EE application and a pre-deployed, self-contained Quick Start. The Quick Start is an easy way to get up and running in just a few minutes. You just need an Oracle Database with Spatial and Graph, version 12.2 or newer. For instructions on setting up Spatial Studio, please refer to https://www.oracle.com/database/technologies/spatial-studio/get-started.html. Once you have Spatial Studio running, follow along with the basic workflow steps below:
In this workflow we will load country and urban area polygons and then determine which urban areas are in a country of interest.
Download Shapefiles:
-
Go to https://www.naturalearthdata.com/downloads/10m-cultural-vectors/
-
Download "Admin 0 - Countries" and 'Urban Areas" and unzip the files
-
You should now have the following 2 folders containing the Shapefiles:
Create datasets:
-
Log into Spatial Studio
-
If using the Quick Start, log in as Admin user
-
If using a WebLogic deployment, log in as the WebLogic admin user
-
-
Click Create > Dataset
-
Create Datasets from Shapefiles:
Create Project:
-
Click Create > Project
-
Add datasets
-
Create map and style layers:
Perform Spatial Analysis:
-
We will apply a spatial filter to identify Urban Areas in the British Isles
-
Select the United Kingdom and Ireland. This will be our spatial filter
-
Open Spatial Analysis for Urban Areas
-
Configure and run spatial filter
-
Drag analysis result into map and set style:
There's lots more to cover, such as
- Spatial Analysis best practices
- Feeding the results of a spatial analysis into another analysis
- Saving our project so that we can revisit our work later
- Publishing our project for others to consume
- Exporting our results for upload to others applications such as Oracle Data Visualization
- Exposing our results as a GeoJSON REST endpoint for application integration
These an other topics will be covered in subsequent posts so please stay tuned.
Greetings