Close Search
No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions
 

All licensed users of Oracle Database EE under Premier or Extended Support, Oracle Database SE2, and Oracle Database Cloud Service (all editions) are licensed to use the features of Oracle Spatial and Graph (OSG).

Using the Quick Start

Spatial Studio is available as a Java application for trial, development, and testing purposes at no cost under an Oracle Technology Network License Agreement.

Deployment

Download Spatial Studio Quick Start from Oracle Technical Resources (formerly OTN)

Technical Requirements

  • Oracle Database 12.2+ [NOTE: Spatial Studio requires a database connection]
  • Studio repository must include Oracle Database with Spatial and Graph or Locator installed.
  • 64-bit JDK8 (update 181 or later)and JDK 11 only
  • Required DB privileges: CONNECT, CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE PROCEDURE, CREATE SYNONYM, CREATE TYPE, CREATE TRIGGER
  • Public internet connection to access hosted background maps and geocoding service
  • Minimum of 1.5GB of free memory, 8GB of total memory

Installing and Configuring

  1. Download the Quick Start zip archive OracleSpatialStudio_qs_21.1.0.zip.

  2. Unzip (extract) it, which results in a directory named Oracle_Spatial_Studio.

  3. Ensure that the JAVA_HOME environment variable exists on your system, and points to a full JDK installation of Java SE Development Kit 8u181 or later.

  4. Ensure that the port 4040 is not being used by any other (web) applications. (You can direct Spatial Studio to use different ports, but 4040 is the default HTTPS port for Studio.)

  5. From a command window (Windows) or terminal (Linux or Mac), go to (cd) the Oracle_Spatial_Studio directory. This directory contains several .bat or .sh files.

  6. Use start.sh or start.bat to start the application. (On Linux or Mac you may need to ensure that the .sh files are executable by first running the command: chmod u+x *.sh)

    Leave the terminal or command window open.

  7. In your browser, go to the URL: https://localhost:4040/spatialstudio

    This page will require login. And you will need to add a security exception to your browser as the Quick Start uses a self-signed SSL certificate. Check the README.txt file found in the Quick Start folder for login instructions and how to change the login id et al. The following considerations apply to using Spatial Studio Quick Start:

  • The default port is 4040, but you can change it by editing the file conf/server.json in Oracle_Spatial_Studio. You will need to restart the application after you make the change.
  • Spatial Studio Quick Start provides several predefined web user login accounts in the configuration file conf/jetty-realm.properties. You should change the passwords immediately after you unzip the downloaded Quick Start. Because Spatial Studio Quick Start is intended for personal use, the passwords for the end user accounts are not encrypted. However, all other passwords, such as those used to log into the Spatial Studio metadata schema or for any user-created connections to database schemas, are strongly encrypted everywhere.
  • To stop the application, the preferred approach is to start a second terminal or command window, then go to the same Oracle_Spatial_Studio folder and run the stop.bat or stop.sh script.

See documentation for more information.

Using a Java EE Deployment

Technical Requirements

  • Oracle Database 12.2+ [NOTE: Spatial Studio requires a database connection]
  • Studio repository must include Oracle Database with Spatial and Graph or Locator installed.
  • 64-bit JDK8 (update 181 or later) and JDK 11 only
  • WebLogic 12.2.1.3+
  • Required DB privileges: CONNECT, CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE PROCEDURE, CREATE SYNONYM, CREATE TYPE, CREATE TRIGGER
  • Public internet connection to access hosted background maps and geocoding services

Deployment

  • Download the Spatial Studio Java EE application archive EAR file from Oracle Service Delivery Cloud (OSDC) or Oracle Technical Resources (formerly Oracle Technology Network)
  • Perform standard WebLogic Server (WLS) app deployment in Java Cloud Service or on-premises
  • Any users known to WLS can access Spatial Studio (Java EE users, SSO users, etc.)
  • WLS users in its Administrators group will assume admin role when logged into Spatial Studio

See documentation for more information.

Using the Spatial Studio App in the Oracle Cloud Marketplace

The Spatial Studio application is free with all editions of Oracle Database Cloud Service.

Go to Oracle Cloud Marketplace to get the app.

    Spatial Studio FAQ

    Open all Close all
  • How can I try Spatial Studio?

    Spatial Studio is available as a Java application for trial, development and testing purposes at no cost under an Oracle Technology Network License Agreement. It may be used in conjunction with any Oracle Database XE version 18c or higher. Spatial Studio Quick Start comes pre-deployed. You simply download, unzip, and run. See Get Started.

  • Do I need a separate license for Spatial Studio?

    No, All licensed users of Oracle Database EE under Premier or Extended Support, Oracle Database SE2, and Oracle Database Cloud Service (all editions) are licensed to use the features of Oracle Spatial and Graph (OSG).

  • What are the technical requirements to run Spatial Studio?
    • Oracle Database 12.2+ [NOTE: Spatial Studio requires a database connection]
    • Spatial Studio repository must include spatial features in Oracle Database
    • WebLogic 12.2.1.3+

    Specific to 20.1

    • 64-bit JDK 8 (update 181 or later) and JDK 11 only

    Specific to 19.2.1

    • JDK 8 only 64-bit (update 181 or later)

    See Get Started.

  • Where do I get Spatial Studio?
  • How is Spatial Studio deployed?
  • How often will there be new releases of Spatial Studio?

    Spatial Studio updates are planned to be released quarterly.

  • Do I need Spatial or GIS knowledge to use Spatial Studio?

    No. Spatial Studio is a self-service application that has been designed for the business user who does not have any GIS or Spatial knowledge. Spatial Studio is designed to enable business analysts and non-GIS developers to use the spatial features in Oracle Database and incorporate spatial analysis in applications and workflows. There is no coding required.

  • If I am a developer with Spatial or GIS knowledge, can I benefit from using Spatial Studio?

    Yes. Spatial Studio provides a simple user interface to access the spatial features in Oracle Database for spatial filtering, aggregation, transformation, and calculation. Upon creating spatial analyses, you have visibility into the SQL that is generated for use as blueprints for further SQL development. In addition, datasets and analysis results are exposed as REST endpoints for programmatic integration. Finally, interactive map visualizations with analysis results can be integrated into other applications as embeddable web content.

  • What data sources can I use with Spatial Studio?

    Spatial Studio reads data from Oracle Databases. Spatial Studio also allows you to upload data from Excel spreadsheets, GeoJSON files, and Shapefiles to Oracle Database. Support for additional data sources and upload formats are planned for future releases.

  • What types of visualizations does Spatial Studio support?

    With Spatial Studio you can visualize data as maps and tables. There are more visualizations planned for future releases.

  • Can you have multiple visualizations in the same project?

    Yes. You can have multiple maps and/or tables in a single project.

  • What background map styles are provided with Spatial Studio?

    Spatial Studio provides a World Map based on HERE data and three styles of OpenStreetMap: OSM Bright, Positron, and Dark Matter. These maps require public internet access.

  • Can I use a different background map such as an internal map service?

    Administrators can create or register custom basemaps in the Console and then all Spatial Studio users can use them in map visualizations. When such basemaps are hosted inhouse, no public internet access is needed. This feature is not available in Spatial Studio 19.2.1.

  • Does my data have to include an Oracle spatial datatype?

    No, Spatial Studio can work with any data that includes addresses or latitude/longitude coordinates.

  • Does Spatial Studio support GeoRaster data stored in the database?

    Yes, Spatial Studio 20.1 can visualize GeoRaster images, although Raster Algebra and related raster data analyses are not supported. This feature is not available in Spatial Studio 19.2.1.

  • What is the geocoder used by Spatial Studio?

    By default, Spatial Studio uses Oracle Maps Cloud Service. You can also use your own instance of the Oracle Spatial Java EE Geocoder.

  • Does Spatial Studio give you the ability to make corrections to geocoded results?

    Yes, Spatial Studio highlights geocoding issues due to data inconsistency and allows the user to make corrections.

  • What countries are supported for geocoding?

    All countries except China, Japan, and Korea. Some countries and regions may lack 100% coverage for geocoding.

  • Does Spatial Studio support other forms of geographic enrichment?

    We plan to add additional enrichment capabilities (hierarchies, place names, etc.) in future releases.

  • Can I publish the results of Spatial Studio analysis using REST?

    Yes, REST endpoints are auto-generated for datasets and spatial analysis results.

  • Does Spatial Studio take the place of the Spatial Map Visualization Component (previously called MapViewer)?

    No, the Spatial Map Visualization Component is intended for developers who are experienced with JavaScript. Spatial Studio is a self-service application.

  • Is Spatial Studio included in Oracle Analytics Cloud?

    No. Spatial Studio is part of the Oracle Database product family.

  • Can you integrate results from Spatial Studio with OAC?

    Yes. Spatial Studio analyses are persisted as database views which can be accessed by OAC. In addition, spatial data can be exported as GeoJSON for use in OAC as a custom map layer.

Follow Oracle Spatial Studio
 
Forum
 
Facebook
 
LinkedIn
 
Blog
 
Twitter
Resources for
Why Oracle
Learn
What’s New
Contact Us