In the previous article, we’ve learned how to install Oracle Spatial Studio (OSS). If you are a truly beginner, you might be wondering where we should start. In this article I will show you some basic operation on how to use Oracle Spatial Studio. I hope this guide will be useful for the beginners.
Oracle Spatial Studio is a web-based application provided by Oracle to help users visualize, analyze, and manage spatial data without the need for complex programming or SQL knowledge. It simplifies working with geospatial data stored in Oracle databases, allowing users to create interactive maps, run spatial analyses, and generate insights from spatial datasets. For more information please visit the official website.
In this article, we will learn the following:
- Create a new connection to the Oracle database and WMS
- Create a new dataset
- Create a new Project
In order to follow this guide, I assume you already have Oracle Spatial Studio installed on your system. You can read my article to install Spatial Studio on Oracle Linux if you wish. If you do so, no you should have a local Oracle Database installed on your system. To access the web administration for OSS you can use the address:
https://your-server-ip-address:4040/spatialstudio
Step 1. Create a New Connection in Oracle Spatial Studio
Oracle Spatial Studio supports Oracle Database (On premise or Cloud), Oracle Autonomous Database, and OGC Web Map Service (WMS) connections. To add new connection, go to the Connections tab in Oracle Spatial Studio web. Select the connection type. In this example, we will connect to the Oracle Database.
Click Next and then enter your oracle database connection details.
Click OK and if all goes well, you will see the new connection in the Connection list.
So at this point, we have successfully created a new connection to our Oracle Database.
Step 2. Create a New Dataset
To create a new dataset, go to Datasets tab and then click Create Dataset button. The new dataset window will open. Here we can choose from different sources. We can use the Database table/view, GeoJSON URL, OGC WMS, Local file (shapefiles, GeoJSON, CSV), File URL, Cesium Formats and upload raster to the Database. In this example, we will upload a Shapefiles.
Steps to create a dataset from Shapefiles:
- Click Create Dataset
- Click Local file.
- Select all the files associated with your Shapefiles (.shp, .shx, .dbf)
- Click Create button
Now we can set the settings for this new Shapefiles. We need to specify the upload location, coordinate system etc.
Click Submit and wait until the process complete. Now you should see the new dataset in your Datasets list.
Step 3. Create a New Project
To start creating a new Project, go to the Project tab and click Create Project. It will open an empty Canvas/view with World Map.
Click Add Dataset and choose the dataset we added previously. And then drag the dataset to the Map.
Now your dataset should be displayed on the Map canvas. We can change the layer/dataset settings from the Layers Settings.
Ok, so that’s the basic steps of Oracle Spatial Studio. Stay tuned to this blog if you are interested in the Spatial Studio because we will have more tutorials.