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
These an other topics will be covered in subsequent posts so please stay tuned.
Greetings