Changes in This Release for Oracle Spatial GeoRaster Developer's Guide

This preface contains the following.

Changes in Oracle AI Database 26ai

The following describes the new features in Oracle Spatial GeoRaster Developer's Guide for Oracle AI Database 26ai.

REST API

Effective with Oracle AI Database 26ai, GeoRaster includes a REST API, which consists of a full set of endpoints that enable users to access GeoRaster data and GeoRaster features through web clients. It provides APIs to access and render GeoRaster objects and virtual mosaics, support all PL/SQL packages and programs, as well as import and export data. The GeoRaster REST API is included in Oracle Spatial Web Services, which includes a web demo as well.

See GeoRaster REST API for more information.

Python Examples

Sample Python notebooks are provided with GeoRaster. The examples in these notebooks demonstrate how to read, write, manipulate, and process raster data stored in the GeoRaster database using the standard Python API for Oracle AI Database and the GDAL Python API. The GDAL distribution with Oracle Spatial now includes the GDAL Python API.

See GeoRaster and Python for more information.

Enhancements to PL/SQL API

The parallelParam parameter is added to parallelize the SDO_GEOR_UTL.emptyBlocks procedure. See SDO_GEOR_UTL.emptyBlocks for more information.

The parallelParam parameter is added to parallelize the SDO_GEOR_UTL.fillEmptyBlocks procedure. See SDO_GEOR_UTL.fillEmptyBlocks for more information.

The list_option and table_name parameters are added to the SDO_GEOR_ADMIN.listGeoRasterColumns and SDO_GEOR_ADMIN.listGeoRasterObjects functions to allow selective queries over large databases.

The table_name parameter is added to the SDO_GEOR_ADMIN.registerGeoRasterColumns and SDO_GEOR_ADMIN.registerGeoRasterObjects functions to allow faster step-by-step registration over large databases.

Two new formats of SDO_GEOR_GDAL.translate procedure are added to allow the data transfer between a GeoRaster object and a raster in file format but stored as a BLOB in a database table.

Raster Tiles Generation

Raster tiles support efficient streaming of spatial raster data to map visualization web clients with a simple SQL call. The tiles are compatible with Open Geospatial Consortium (OGC) Web Map Tile Service (WMTS) tiling scheme and MapBox Terrain-RGB encoding specification for both 2D and 3D visualizations. This tiling approach allows web-based delivery of imagery and raster data at various levels of detail, which also reduces the complexity of web application development. With the GeoRaster database, you can serve any imagery and other raster data to the web using this tiling approach.

Using the SDO_UTIL.GET_RASTERTILE function, you can generate raster tiles from spatial GeoRaster objects in database tables. See Raster Tile and Creating and Using Raster Tile Service for Web Application for more information.

Wallet Support in the GeoRaster Tools

The GeoRaster Viewer and ETL tools are enhanced to use an Oracle Wallet with or without credentials to create a connection to an Oracle AI Database.

Deprecated Subprograms in SDO_GEOR_ADMIN Package

The GeoRaster subprograms SDO_GEOR_ADMIN.isUpgradeNeeded and SDO_GEOR_ADMIN.upgradeGeoRaster in SDO_GEOR_ADMIN package, which are used to maintain the GeoRaster objects in the database, are deprecated in Oracle AI Database 26ai.

Deprecated Subprograms in SDO_GEOR Package

The GeoRaster subprograms SDO_GEOR.importFrom and SDO_GEOR.exportTo in the SDO_GEOR package are deprecated in Oracle AI Database 26ai.

JPEG Compression on 4-band Raster Blocks

Starting with Oracle AI Database 26ai, JPEG compression and decompression on Oracle Spatial GeoRaster object can only be applied on 1-band and 3-band raster blocks. Any GeoRaster object that has 4-band raster blocks needs to be reblocked to 1-band or 3-band raster blocks before applying the JPEG compression.