Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Related Documents
  • Conventions
• Changes in This Release for Oracle Spatial GeoRaster Developer’s Guide
  • Changes in Oracle AI Database 26ai
• GeoRaster Overview and Concepts
  • Vector and Raster Data
  • Raster Data Sources
    • Remote Sensing
    • Photogrammetry
    • Geographic Information Systems
    • Cartography
    • Digital Image Processing
    • Geology, Geophysics, and Geochemistry
  • GeoRaster Data Model
  • GeoRaster Physical Storage
    • Storage Parameters
    • Raster Data Table
    • Blank and Empty GeoRaster Objects
    • Empty Raster Blocks
    • Cross-Schema Support with GeoRaster
  • Bands, Layers, and Metadata
  • Georeferencing
    • Functional Fitting Georeferencing Model
    • Ground Control Point (GCP) Georeferencing Model
    • Cell Coordinate and Model Coordinate Transformation
  • Resampling and Interpolation
  • Pyramids
  • Bitmap Masks
  • NODATA Values and Value Ranges
  • Compression and Decompression
    • JPEG (JPEG-F) Compression of GeoRaster Objects
      • JPEG-B Support Deprecated
    • JPEG 2000 Compression of GeoRaster Objects
    • DEFLATE Compression of GeoRaster Objects
    • Decompression of GeoRaster Objects
    • Advanced LOB Compression
  • GeoRaster and Database Management
  • Parallel Processing in GeoRaster
  • Reporting Operation Progress in GeoRaster
  • Raster Tiles
  • GeoRaster PL/SQL API
  • GeoRaster Java API
  • GeoRaster REST API
  • GeoRaster and Python
  • GeoRaster Spatial Web Services
  • GeoRaster Support in Spatial Studio and Map Visualization Component
  • GeoRaster Tools: Viewer, Loader, Exporter
    • JAI-Based Viewer, Loader, and Exporter
    • GDAL-Based ETL Wizard for Concurrent Batch Loading and Exporting
    • Using GDAL from the Spatial Installation or on a Client Machine
    • Using the SDO_GEOR_GDAL Package
  • GeoRaster PL/SQL, Java, and Python Sample Files
  • README File for Spatial and Related Features
• GeoRaster Data Types and Related Structures
  • SDO_GEORASTER Object Type
    • rasterType Attribute
    • spatialExtent Attribute
    • rasterDataTable Attribute
    • rasterID Attribute
    • metadata Attribute
  • SDO_RASTER Object Type and the Raster Data Table
    • rasterID Attribute
    • pyramidLevel Attribute
    • bandBlockNumber Attribute
    • rowBlockNumber Attribute
    • columnBlockNumber Attribute
    • blockMBR Attribute
    • rasterBlock Attribute
  • Other GeoRaster Types
    • SDO_GEOR_HISTOGRAM Object Type
    • SDO_GEOR_HISTOGRAM_ARRAY Collection Type
    • SDO_GEOR_COLORMAP Object Type
    • SDO_GEOR_GRAYSCALE Object Type
    • SDO_RASTERSET Collection Type
    • SDO_GEOR_SRS Object Type
    • SDO_GEOR_GCP Object Type
    • SDO_GEOR_GCP_ COLLECTION Collection Type
    • SDO_GEOR_GCPGEOREFTYPE Object Type
  • GeoRaster System Data Views (xxx_SDO_GEOR_SYSDATA)
    • TABLE_NAME Column
    • COLUMN_NAME Column
    • METADATA_COLUMN_NAME Column
    • RDT_TABLE_NAME Column
    • RASTER_ID Column
    • OTHER_TABLE_NAMES Column
  • GeoRaster XML Schema
• GeoRaster Database Creation and Management
  • Enabling GeoRaster at the Schema Level
  • Adding Data Files and Temporary Tablespaces for GeoRaster Users
  • Creating the GeoRaster Table and Raster Data Tables
    • Creating a GeoRaster Table
    • Creating Raster Data Tables
    • Creating GeoRaster DML Triggers
  • Creating New GeoRaster Objects
  • Loading Raster Data
    • Loading with Blocking and Optimal Padding
    • Loading JPEG and JPEG 2000 Images Without Decompression
    • Reformatting the Source Raster Before Loading
  • Validating GeoRaster Objects
  • Georeferencing GeoRaster Objects
  • Generating and Setting Spatial Extents
    • Special Considerations if the GeoRaster Table Has a Spatial Index
  • Indexing GeoRaster Objects
  • Viewing GeoRaster Objects
  • Exporting GeoRaster Objects
  • Using GeoRaster with Workspace Manager and Label Security
    • Using GeoRaster with Workspace Manager
    • Using GeoRaster with Label Security
  • Maintaining Efficient Tablespace Use by GeoRaster Objects
  • Checking GeoRaster Tables and Objects in the Database
  • Maintaining GeoRaster Objects and System Data in the Database
  • Transferring GeoRaster Data Between Databases
    • Using Data Pump Utility to Transfer GeoRaster Data
    • Using Transportable Tablespaces To Transfer GeoRaster Data
      • Export the Tablespaces from the Source Database
      • Import the Tablespaces into the Target Database
    • Using Database Link with GeoRaster Data
• GeoRaster Data Query and Manipulation
  • Querying and Searching GeoRaster Objects
  • Changing and Optimizing Raster Storage
  • Copying GeoRaster Objects
  • Subsetting GeoRaster Objects with Polygon Clipping
  • Querying and Updating GeoRaster Metadata
  • Querying and Updating GeoRaster Cell Data
  • Interpolating Cell Values
  • Processing and Analyzing GeoRaster Objects
  • Monitoring and Reporting GeoRaster Operation Progress
  • Compressing and Decompressing GeoRaster Objects
  • Deleting GeoRaster Objects, and Performing Actions on GeoRaster Tables and RDTs
  • Performing Cross-Schema Operations
  • Managing Memory to Improve Performance
  • Updating GeoRaster Objects Before Committing
  • Updating GeoRaster Objects in a Loop
  • Using Template-Related Subprograms to Develop GeoRaster Applications
• Raster Algebra and Analytics
  • Raster Algebra Language
    • Examples of Raster Algebra Expressions
  • Cell Value-Based Conditional Queries
  • Cell Value-Based Conditional Updates (Edits)
  • Mathematical Operations
  • Classification Operations
  • Statistical Operations
    • On-the-Fly Statistical Analysis
    • Stack Statistical Analysis
  • Logical Operations
    • Using Raster Algebra Procedures with Logical Expressions
    • Using Raster Algebra Functions Only
  • Raster Data Scaling and Offsetting
  • Raster Data Casting
  • Cartographic Modeling
  • Terrain Modeling and Analysis
• Image Processing and Virtual Mosaic
  • Advanced Georeferencing
  • Image Reprojection
  • Image Rectification
  • Image Orthorectification
    • Orthorectification with Average Height
    • Orthorectification with DEM
  • Image Warping
  • Image Affine Transformation and Scaling
  • Image Stretching, Normalization, Equalization, Histogram Matching, and Dodging
  • Image Filtering
  • Image Segmentation
  • Image Pyramiding: Parallel Generation and Partial Update
  • Bitmap Pyramiding
  • Vegetation Index Computation
  • Tasseled Cap Transformation
  • Image Masking
  • Band Merging
  • Image Appending
  • Large-Scale Image Mosaicking
    • Color Balancing During Mosaicking
    • Parallel Compression, Copying, and Subsetting
  • Virtual Mosaic
    • Virtual Mosaic as One or a List of GeoRaster Tables
    • Virtual Mosaic as a View with a GeoRaster Column
    • Virtual Mosaic as a SQL Query Statement or a Cursor
    • Using Virtual Mosaic in Applications
    • Special Considerations for Large-Scale Virtual Mosaic
      • Improving Query Performance Using MIN_X_RES$ and MAX_X_RES$
  • Image Serving
• SDO_GEOR Package Reference
  • SDO_GEOR.addNODATA
  • SDO_GEOR.addSourceInfo
  • SDO_GEOR.affineTransform
  • SDO_GEOR.calcCompressionRatio
  • SDO_GEOR.changeCellValue
  • SDO_GEOR.changeCellValues
  • SDO_GEOR.changeFormatCopy
  • SDO_GEOR.compressJP2
  • SDO_GEOR.copy
  • SDO_GEOR.createBlank
  • SDO_GEOR.createTemplate
  • SDO_GEOR.decompressJP2
  • SDO_GEOR.deleteControlPoint
  • SDO_GEOR.deleteNODATA
  • SDO_GEOR.deletePyramid
  • SDO_GEOR.evaluateDouble
  • SDO_GEOR.evaluateDoubles
  • SDO_GEOR.exportTo
  • SDO_GEOR.generateAreaWeightedMean
  • SDO_GEOR.generateBitmapPyramid
  • SDO_GEOR.generateBlockMBR
  • SDO_GEOR.generatePyramid
  • SDO_GEOR.generateSpatialExtent
  • SDO_GEOR.generateSpatialResolutions
  • SDO_GEOR.generateStatistics
  • SDO_GEOR.generateStatisticsMax
  • SDO_GEOR.generateStatisticsMean
  • SDO_GEOR.generateStatisticsMedian
  • SDO_GEOR.generateStatisticsMin
  • SDO_GEOR.generateStatisticsMode
  • SDO_GEOR.generateStatisticsSTD
  • SDO_GEOR.generateStatisticsSum
  • SDO_GEOR.georeference
  • SDO_GEOR.getBandDimSize
  • SDO_GEOR.getBeginDateTime
  • SDO_GEOR.getBinFunction
  • SDO_GEOR.getBinTable
  • SDO_GEOR.getBinType
  • SDO_GEOR.getBitmapMask
  • SDO_GEOR.getBitmapMaskSubset
  • SDO_GEOR.getBitmapMaskValue
  • SDO_GEOR.getBitmapMaskValues
  • SDO_GEOR.getBlankCellValue
  • SDO_GEOR.getBlockingType
  • SDO_GEOR.getBlockSize
  • SDO_GEOR.getCellCoordinate
  • SDO_GEOR.getCellDepth
  • SDO_GEOR.getCellValue
  • SDO_GEOR.getCellValues
  • SDO_GEOR.getColorMap
  • SDO_GEOR.getColorMapTable
  • SDO_GEOR.getCompressionType
  • SDO_GEOR.getControlPoint
  • SDO_GEOR.getDefaultAlpha
  • SDO_GEOR.getDefaultBlue
  • SDO_GEOR.getDefaultColorLayer
  • SDO_GEOR.getDefaultGreen
  • SDO_GEOR.getDefaultPyramidLevel
  • SDO_GEOR.getDefaultRed
  • SDO_GEOR.getEndDateTime
  • SDO_GEOR.getGCPGeorefMethod
  • SDO_GEOR.getGCPGeorefModel
  • SDO_GEOR.getGeoreferenceType
  • SDO_GEOR.getGrayScale
  • SDO_GEOR.getGrayScaleTable
  • SDO_GEOR.getHistogram
  • SDO_GEOR.getHistogramTable
  • SDO_GEOR.getID
  • SDO_GEOR.getInterleavingType
  • SDO_GEOR.getJP2TileSize
  • SDO_GEOR.getLayerDimension
  • SDO_GEOR.getLayerID
  • SDO_GEOR.getLayerOrdinate
  • SDO_GEOR.getModelCoordinate
  • SDO_GEOR.getModelCoordLocation
  • SDO_GEOR.getModelSRID
  • SDO_GEOR.getNODATA
  • SDO_GEOR.getPyramidMaxLevel
  • SDO_GEOR.getPyramidType
  • SDO_GEOR.getRasterBlockLocator
  • SDO_GEOR.getRasterBlocks
  • SDO_GEOR.getRasterData
  • SDO_GEOR.getRasterRange
  • SDO_GEOR.getRasterSubset
  • SDO_GEOR.getScaling
  • SDO_GEOR.getSourceInfo
  • SDO_GEOR.getSpatialDimNumber
  • SDO_GEOR.getSpatialDimSizes
  • SDO_GEOR.getSpatialResolutions
  • SDO_GEOR.getSpectralResolution
  • SDO_GEOR.getSpectralUnit
  • SDO_GEOR.getSRS
  • SDO_GEOR.getStatistics
  • SDO_GEOR.getTotalLayerNumber
  • SDO_GEOR.getULTCoordinate
  • SDO_GEOR.getVAT
  • SDO_GEOR.getVersion
  • SDO_GEOR.hasBitmapMask
  • SDO_GEOR.hasGrayScale
  • SDO_GEOR.hasNODATAMask
  • SDO_GEOR.hasPseudoColor
  • SDO_GEOR.importFrom
  • SDO_GEOR.init
  • SDO_GEOR.isBlank
  • SDO_GEOR.isOrthoRectified
  • SDO_GEOR.isRectified
  • SDO_GEOR.isSpatialReferenced
  • SDO_GEOR.mask
  • SDO_GEOR.mergeLayers
  • SDO_GEOR.mosaic
  • SDO_GEOR.rectify
  • SDO_GEOR.reproject
  • SDO_GEOR.scaleCopy
  • SDO_GEOR.schemaValidate
  • SDO_GEOR.setBeginDateTime
  • SDO_GEOR.setBinFunction
  • SDO_GEOR.setBinTable
  • SDO_GEOR.setBitmapMask
  • SDO_GEOR.setBlankCellValue
  • SDO_GEOR.setColorMap
  • SDO_GEOR.setColorMapTable
  • SDO_GEOR.setControlPoint
  • SDO_GEOR.setDefaultAlpha
  • SDO_GEOR.setDefaultBlue
  • SDO_GEOR.setDefaultColorLayer
  • SDO_GEOR.setDefaultGreen
  • SDO_GEOR.setDefaultPyramidLevel
  • SDO_GEOR.setDefaultRed
  • SDO_GEOR.setEndDateTime
  • SDO_GEOR.setGCPGeorefMethod
  • SDO_GEOR.setGCPGeorefModel
  • SDO_GEOR.setGrayScale
  • SDO_GEOR.setGrayScaleTable
  • SDO_GEOR.setHistogramTable
  • SDO_GEOR.setID
  • SDO_GEOR.setLayerID
  • SDO_GEOR.setLayerOrdinate
  • SDO_GEOR.setModelCoordLocation
  • SDO_GEOR.setModelSRID
  • SDO_GEOR.setNODATAMask
  • SDO_GEOR.setOrthoRectified
  • SDO_GEOR.setRasterType
  • SDO_GEOR.setRectified
  • SDO_GEOR.setScaling
  • SDO_GEOR.setSourceInfo
  • SDO_GEOR.setSpatialReferenced
  • SDO_GEOR.setSpatialResolutions
  • SDO_GEOR.setSpectralResolution
  • SDO_GEOR.setSpectralUnit
  • SDO_GEOR.setSRS
  • SDO_GEOR.setStatistics
  • SDO_GEOR.setULTCoordinate
  • SDO_GEOR.setVAT
  • SDO_GEOR.setVersion
  • SDO_GEOR.subset
  • SDO_GEOR.updateRaster
  • SDO_GEOR.validateBlockMBR
  • SDO_GEOR.validateGeoRaster
  • SDO_GEOR.warp
• SDO_GEOR_ADMIN Package Reference
  • SDO_GEOR_ADMIN.checkSysdataEntries
  • SDO_GEOR_ADMIN.disableGeoRaster
  • SDO_GEOR_ADMIN.enableGeoRaster
  • SDO_GEOR_ADMIN.isGeoRasterEnabled
  • SDO_GEOR_ADMIN.isRDTNameUnique
  • SDO_GEOR_ADMIN.isUpgradeNeeded
  • SDO_GEOR_ADMIN.listGeoRasterColumns
  • SDO_GEOR_ADMIN.listGeoRasterObjects
  • SDO_GEOR_ADMIN.listGeoRasterTables
  • SDO_GEOR_ADMIN.listDanglingRasterData
  • SDO_GEOR_ADMIN.listRDT
  • SDO_GEOR_ADMIN.listRegisteredRDT
  • SDO_GEOR_ADMIN.listUnregisteredRDT
  • SDO_GEOR_ADMIN.maintainSysdataEntries
  • SDO_GEOR_ADMIN.registerGeoRasterColumns
  • SDO_GEOR_ADMIN.registerGeoRasterObjects
  • SDO_GEOR_ADMIN.upgradeGeoRaster
• SDO_GEOR_AGGR Package Reference
  • SDO_GEOR_AGGR.append
  • SDO_GEOR_AGGR.getMosaicExtent
  • SDO_GEOR_AGGR.getMosaicResolutions
  • SDO_GEOR_AGGR.getMosaicStatistics
  • SDO_GEOR_AGGR.getMosaicSubset
  • SDO_GEOR_AGGR.mosaicSubset
  • SDO_GEOR_AGGR.validateForMosaicSubset
• SDO_GEOR_GDAL Package Reference
  • SDO_GEOR_GDAL.dem
  • SDO_GEOR_GDAL.translate
• SDO_GEOR_IP Package Reference
  • SDO_GEOR_IP.dodge
  • SDO_GEOR_IP.equalize
  • SDO_GEOR_IP.filter
  • SDO_GEOR_IP.histogramMatch
  • SDO_GEOR_IP.normalize
  • SDO_GEOR_IP.piecewiseStretch
  • SDO_GEOR_IP.stretch
• SDO_GEOR_RA Package Reference
  • SDO_GEOR_RA.classify
  • SDO_GEOR_RA.diff
  • SDO_GEOR_RA.findCells
  • SDO_GEOR_RA.isOverlap
  • SDO_GEOR_RA.over
  • SDO_GEOR_RA.rasterMathOp
  • SDO_GEOR_RA.rasterUpdate
  • SDO_GEOR_RA.stack
• SDO_GEOR_UTL Package Reference
  • SDO_GEOR_UTL.calcOptimizedBlockSize
  • SDO_GEOR_UTL.calcRasterNominalSize
  • SDO_GEOR_UTL.calcRasterStorageSize
  • SDO_GEOR_UTL.calcSurfaceArea
  • SDO_GEOR_UTL.clearReportTable
  • SDO_GEOR_UTL.createDMLTrigger
  • SDO_GEOR_UTL.createImage
  • SDO_GEOR_UTL.createReportTable
  • SDO_GEOR_UTL.disableReport
  • SDO_GEOR_UTL.dropReportTable
  • SDO_GEOR_UTL.emptyBlocks
  • SDO_GEOR_UTL.enableReport
  • SDO_GEOR_UTL.fillEmptyBlocks
  • SDO_GEOR_UTL.generateColorRamp
  • SDO_GEOR_UTL.generateGrayRamp
  • SDO_GEOR_UTL.get_rasterTile
  • SDO_GEOR_UTL.getAllStatusReport
  • SDO_GEOR_UTL.getMaxMemSize
  • SDO_GEOR_UTL.getReadBlockMemSize
  • SDO_GEOR_UTL.getProgress
  • SDO_GEOR_UTL.getStatusReport
  • SDO_GEOR_UTL.getWriteBlockMemSize
  • SDO_GEOR_UTL.isReporting
  • SDO_GEOR_UTL.makeRDTNamesUnique
  • SDO_GEOR_UTL.recreateDMLTriggers
  • SDO_GEOR_UTL.renameRDT
  • SDO_GEOR_UTL.setClientID
  • SDO_GEOR_UTL.setMaxMemSize
  • SDO_GEOR_UTL.setReadBlockMemSize
  • SDO_GEOR_UTL.setSeqID
  • SDO_GEOR_UTL.setWriteBlockMemSize
• GeoRaster Metadata XML Schema
• GeoRaster REST API Reference
  • GeoRaster REST API Architecture
  • Deploying and Configuring the GeoRaster REST API
  • Authentication
  • GeoRaster REST API Endpoints Examples
    • Initiating a GeoRaster Object
    • Loading a Raster Image
    • Viewing a Loaded Raster Image
    • Classifying a Raster Image
    • Rectifying a Raster Image
    • Creating, Viewing, and Managing Virtual Mosaics
  • GeoRaster REST API Demonstration Web Page
• Creating and Using Raster Tile Service for Web Application
  • Example 1: A Raster Tile Service Using ORDS With a Single Raster Layer
  • Example 2: A Raster Tile Service Using ORDS With a Terrain Layer and an Image Layer for 3D Visualization