Oracle Spatial Studio 20.1 is now available. Spatial Studio is a web application that provides self-service access to the spatial features of Oracle Database 19c on-prem and in the Cloud – including Oracle Autonomous Database and the Oracle Cloud Free Tier. This release also works with Oracle Database 12c Release 2 on-prem and in the Cloud and includes new features and improvements in the areas of data loading, spatial analysis, visualization and performance.
Here are some of the new features and enhancements in Oracle Spatial Studio 20.1:
Simpler Data Uploading
Uploading data into Spatial Studio is now simpler. You can upload multiple dataset files with different formats – such as spreadsheets, GeoJSON and shapefiles – all at the same time. You just select all the mixed type files from a file browser and Studio will guide you through the individual identified datasets contained in the uploaded files.
Public Datasets and Public Published Projects
Datasets that are based on public domain (such as county boundaries) or are related to public works can be set as “public” or world readable. These datasets can then be consumed by other applications in the form of GeoJSON or Vector Tiles, which are exposed as REST endpoints. This means that public datasets can be accessed through REST endpoints by anyone, without having to log into Spatial Studio.
A public published project is a published project where all the datasets are public datasets. You can embed the visualizations of a public published project in other web applications, or view them standalone in a web browser, all without having to log into Spatial Studio.
New Spatial Analytics Category
There is a new Analytics category in the Spatial Analysis Operations. Each analysis provides an easy to understand interface with minimal user input to perform the analysis. You just pick the spatial analysis you want, and Studio’s dialog guides you through the operation.
Examples of analyses include Summarize Distance, Summarize Region, and Nearest Neighbor. Behind the scenes Studio will utilize the most optimized SQL query based on years of spatial database tuning expertise.
Administrators can now register custom basemaps and use them in map visualizations. The basemaps may be raster or vector tiles and are typically hosted on third party servers.
Visualize Change over Time
Time, in addition to space, is an important aspect when visualizing spatial data. Spatial Studio now has a time slider to visualize change over time. When you add a dataset with a date/time column to a map visualization, there is a time slider displayed on the map.
For example, you can view a historical view of COVID-19 cases in a city over a specific period of time.
Project Import and Export
You can export an entire Project as a zip file, which you can later import into a different Spatial Studio instance. The Project definition, datasets, analysis visualizations, as well as the underlying tables and views are included in the zip file. This is a good way of backing up your work or migrating your work to a different Spatial Studio instance, where you can perform spatial analysis operations.
Another user can also import an entire Project as a zip file. The other user can add datasets to the Project and perform new spatial analysis operations.
Enhanced WebLogic Server Cluster support
For large Spatial Studio deployments running on a WebLogic Server cluster with multiple server instances, it is important than the in-memory cached Studio metadata are kept in sync across the cluster. The enhancements made in this release ensure that each Studio instance’s in-memory cache of its metadata is always in sync.
For example, when a user deletes a dataset, the deletion is carried out by Studio instance A and persisted to the backend database schema. Within a reasonable amount of time, all other Studio instances sync their own metadata cache and ensure the same dataset is deleted from their in-memory cache.
GeoRaster Data Visualization
In Spatial Studio, you can now create and visualize imagery data stored in the spatial GeoRaster type in Oracle Database. When you create a new dataset, you will see a new type of base table in a database schema labeled as “GeoRaster”.
During dataset creation, you can specify the exact raster set that goes into the GeoRaster dataset. When you drag and drop a GeoRaster dataset on a map, various raster specific rendering options are provided so you can enhance your visualization with raster bands and ranges.
New 3D Data Visualization
Access Token Support
Access tokens can now be generated and used to invoke Spatial Studio’s REST endpoints so that third party applications can access and process a user’s protected resources (datasets, projects, or visualizations). This means that most Spatial Studio functions can be invoked programmatically, without the need for user or administrator involvement through the user interface.
Improved Large Dataset Visualization Performance
You can visualize and explore very large datasets, such as tables containing billions of rows of geospatial data points, with much improved performance from the previous version.
Spatial Studio administration is now more streamlined and better organized, with sections of administrative functions grouped into their own page. The main Administration page has sub-areas of administrative functions, such as Safe Domains that Spatial Studio has access to, and Background Maps Management.
For more information about other new features in Oracle Spatial Studio 20.1, please visit Oracle Spatial Studio.