Changes in This Release for Oracle Spatial GeoRaster Developer's Guide
This preface contains the following.
Changes in Oracle Database Release 23ai
The following are the changes in Oracle Spatial GeoRaster Developer's Guide for Oracle Database Release 23ai.
REST API
Effective with Oracle Database Release 23ai, 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 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.
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 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 Database Release 23ai.
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 Database Release 23ai.
JPEG Compression on 4-band Raster Blocks
Starting with Oracle Release 23ai, 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.