Oracle Spatial Studio

Oracle Spatial Studio, also referred to as Spatial Studio, is a free tool that lets you connect with, visualize, explore, and analyze geospatial data stored in and managed by Oracle Spatial and Graph.  Spatial Studio is a multiuser Java EE application that can be used as a standalone tool (Quick Start) or deployed to WebLogic Server.

Before you can use Spatial Studio, you must download the kit from Oracle Technical Resources (formerly called Oracle Technology Network), install the software, and perform certain administrative actions like creating database users that are authorized to use the tool, and managing those users.

Note:  Spatial Studio is not the Spatial and Graph map visualization component (formerly called "MapViewer"), which is not an end-user "tool" but rather a separate and distinct component.

The map visualization component is documented in Oracle Spatial and Graph Map Visualization Guide.

GDAL documentation » Vector drivers » Oracle Spatial

This driver supports reading and writing data in Oracle Spatial (8.1.7 or later) Object-Relational format. The Oracle Spatial driver is not normally built into OGR, but may be built in on platforms where the Oracle client libraries are available.

Oracle Spatial Online Reference Guide

The spatial features in Oracle Spatial and Graph consist of a set of object data types, type methods, and operators, functions, and procedures that use these types. A geometry is stored as an object, in a single row, in a column of type SDO_GEOMETRY. Spatial index creation and maintenance is done using basic DDL (CREATE, ALTER, DROP) and DML (INSERT, UPDATE, DELETE) statements.

IT UPDATE (Code - Innovate)

RECENT DIFM IT NEWS (2023.01.17)

Today was the first meeting of the Oracle - DIFM Code-Innovate discussion.  Topics were to manage expectations and establish a timeline and number of attendees.   The scope of the project is to use Apex and an Oracle Autonomous Transaction database to build and create a version of trial design using the power of Oracle SQL, and Oracles Geospatial Studio Suite. 

Louisiana State University Logo

March 07, 2023

Integration with Oracle IDCS Complete!

The DIFM Ag Research Portal and Farmers Portal is now integrated with Oracle IDCS and there is self-registration for farmers and research scientists.   Both applications remain under development but the underlying scaffolding is built and being tested.

Ag Research Portal:  Is an end-user application under development designed for PI's and Stakeholders to access, review, edit migrated data residing in DIFM's Autonomous Data Warehouse in the Oracle Cloud.  

Farm Portal: Is an end-user application allowing farmers to register for OFPE Trials, upload necessary data for implementing those trials.  

Integrating user registration with IDCS and managing application & data access with IDCS satisfies essential requirements of Phase I of the software development plan.