List of Figures
List of Tables
Title and Copyright Information
Preface
- Audience
- Documentation Accessibility
- Related Documents
- Conventions
Changes in This Release for Oracle Spatial and Graph GeoRaster Developer's Guide
- Changes in Oracle Database 19.1
  - GeoRaster Must Be Enabled at Schema Level
  - SDO_GEOR_RA Support for Result Data in a BLOB
- Changes in Oracle Database 18.1
1 GeoRaster Overview and Concepts
- 1.1 Vector and Raster Data
- 1.2 Raster Data Sources
  - 1.2.1 Remote Sensing
  - 1.2.2 Photogrammetry
  - 1.2.3 Geographic Information Systems
  - 1.2.4 Cartography
  - 1.2.5 Digital Image Processing
  - 1.2.6 Geology, Geophysics, and Geochemistry
- 1.3 GeoRaster Data Model
- 1.4 GeoRaster Physical Storage
  - 1.4.1 Storage Parameters
  - 1.4.2 Raster Data Table
  - 1.4.3 Blank and Empty GeoRaster Objects
  - 1.4.4 Empty Raster Blocks
  - 1.4.5 Cross-Schema Support with GeoRaster
- 1.5 Bands, Layers, and Metadata
- 1.6 Georeferencing
  - 1.6.1 Functional Fitting Georeferencing Model
  - 1.6.2 Ground Control Point (GCP) Georeferencing Model
  - 1.6.3 Cell Coordinate and Model Coordinate Transformation
- 1.7 Resampling and Interpolation
- 1.8 Pyramids
- 1.9 Bitmap Masks
- 1.10 NODATA Values and Value Ranges
- 1.11 Compression and Decompression
  - 1.11.1 JPEG (JPEG-F) Compression of GeoRaster Objects
    - 1.11.1.1 JPEG-B Support Deprecated
  - 1.11.2 JPEG 2000 Compression of GeoRaster Objects
  - 1.11.3 DEFLATE Compression of GeoRaster Objects
  - 1.11.4 Decompression of GeoRaster Objects
  - 1.11.5 Third-Party Plug-ins for Compression
  - 1.11.6 Advanced LOB Compression
- 1.12 GeoRaster and Database Management
- 1.13 Parallel Processing in GeoRaster
- 1.14 Reporting Operation Progress in GeoRaster
- 1.15 GeoRaster PL/SQL API
- 1.16 GeoRaster Java API
- 1.17 GeoRaster Spatial Web Services
- 1.18 MapViewer and GeoRaster
- 1.19 GeoRaster Tools: Viewer, Loader, Exporter
  - 1.19.1 JAI-Based Viewer, Loader, and Exporter
  - 1.19.2 GDAL-Based ETL Wizard for Concurrent Batch Loading and Exporting
  - 1.19.3 Using GDAL from the Spatial and Graph Installation
  - 1.19.4 Using the SDO_GEOR_GDAL Package
- 1.20 GeoRaster PL/SQL and Java Sample Files
- 1.21 README File for Spatial and Graph and Related Features
2 GeoRaster Data Types and Related Structures
- 2.1 SDO_GEORASTER Object Type
- 2.2 SDO_RASTER Object Type and the Raster Data Table
- 2.3 Other GeoRaster Types
- 2.4 GeoRaster System Data Views (xxx_SDO_GEOR_SYSDATA)
- 2.5 GeoRaster XML Schema
3 GeoRaster Database Creation and Management
- 3.1 Enabling GeoRaster at the Schema Level
- 3.2 Adding Data Files and Temporary Tablespaces for GeoRaster Users
- 3.3 Creating the GeoRaster Table and Raster Data Tables
- 3.4 Creating New GeoRaster Objects
- 3.5 Loading Raster Data
- 3.6 Validating GeoRaster Objects
- 3.7 Georeferencing GeoRaster Objects
- 3.8 Generating and Setting Spatial Extents
  - 3.8.1 Special Considerations if the GeoRaster Table Has a Spatial Index
- 3.9 Indexing GeoRaster Objects
- 3.10 Viewing GeoRaster Objects
- 3.11 Exporting GeoRaster Objects
- 3.12 Using GeoRaster with Workspace Manager and Label Security
  - 3.12.1 Using GeoRaster with Workspace Manager
  - 3.12.2 Using GeoRaster with Label Security
- 3.13 Maintaining Efficient Tablespace Use by GeoRaster Objects
- 3.14 Checking GeoRaster Tables and Objects in the Database
- 3.15 Maintaining GeoRaster Objects and System Data in the Database
- 3.16 Transferring GeoRaster Data Between Databases
  - 3.16.1 Checking for and Resolving Conflicts
  - 3.16.2 Performing the GeoRaster Data Transfer
- 3.17 Using Transportable Tablespaces with GeoRaster Data
4 GeoRaster Data Query and Manipulation
- 4.1 Querying and Searching GeoRaster Objects
- 4.2 Changing and Optimizing Raster Storage
- 4.3 Copying GeoRaster Objects
- 4.4 Subsetting GeoRaster Objects with Polygon Clipping
- 4.5 Querying and Updating GeoRaster Metadata
- 4.6 Querying and Updating GeoRaster Cell Data
- 4.7 Interpolating Cell Values
- 4.8 Processing and Analyzing GeoRaster Objects
- 4.9 Monitoring and Reporting GeoRaster Operation Progress
- 4.10 Compressing and Decompressing GeoRaster Objects
- 4.11 Deleting GeoRaster Objects, and Performing Actions on GeoRaster Tables and RDTs
- 4.12 Performing Cross-Schema Operations
- 4.13 Managing Memory to Improve Performance
- 4.14 Updating GeoRaster Objects Before Committing
- 4.15 Updating GeoRaster Objects in a Loop
- 4.16 Using Template-Related Subprograms to Develop GeoRaster Applications
5 Raster Algebra and Analytics
- 5.1 Raster Algebra Language
  - 5.1.1 Examples of Raster Algebra Expressions
- 5.2 Cell Value-Based Conditional Queries
- 5.3 Cell Value-Based Conditional Updates (Edits)
- 5.4 Mathematical Operations
- 5.5 Classification Operations
- 5.6 Statistical Operations
  - 5.6.1 On-the-Fly Statistical Analysis
  - 5.6.2 Stack Statistical Analysis
- 5.7 Logical Operations
  - 5.7.1 Using Raster Algebra Procedures with Logical Expressions
  - 5.7.2 Using Raster Algebra Functions Only
- 5.8 Raster Data Scaling and Offsetting
- 5.9 Raster Data Casting
- 5.10 Cartographic Modeling
- 5.11 Terrain Modeling and Analysis
6 Image Processing and Virtual Mosaic
- 6.1 Advanced Georeferencing
- 6.2 Image Reprojection
- 6.3 Image Rectification
- 6.4 Image Orthorectification
  - 6.4.1 Orthorectification with Average Height
  - 6.4.2 Orthorectification with DEM
- 6.5 Image Warping
- 6.6 Image Affine Transformation and Scaling
- 6.7 Image Stretching, Normalization, Equalization, Histogram Matching, and Dodging
- 6.8 Image Filtering
- 6.9 Image Segmentation
- 6.10 Image Pyramiding: Parallel Generation and Partial Update
- 6.11 Bitmap Pyramiding
- 6.12 Vegetation Index Computation
- 6.13 Tasseled Cap Transformation
- 6.14 Image Masking
- 6.15 Band Merging
- 6.16 Image Appending
- 6.17 Large-Scale Image Mosaicking
  - 6.17.1 Color Balancing During Mosaicking
  - 6.17.2 Parallel Compression, Copying, and Subsetting
- 6.18 Virtual Mosaic
- 6.19 Image Serving
7 SDO_GEOR Package Reference
- 7.1 SDO_GEOR.addNODATA
- 7.2 SDO_GEOR.addSourceInfo
- 7.3 SDO_GEOR.affineTransform
- 7.4 SDO_GEOR.calcCompressionRatio
- 7.5 SDO_GEOR.changeCellValue
- 7.6 SDO_GEOR.changeCellValues
- 7.7 SDO_GEOR.changeFormatCopy
- 7.8 SDO_GEOR.compressJP2
- 7.9 SDO_GEOR.copy
- 7.10 SDO_GEOR.createBlank
- 7.11 SDO_GEOR.createTemplate
- 7.12 SDO_GEOR.decompressJP2
- 7.13 SDO_GEOR.deleteControlPoint
- 7.14 SDO_GEOR.deleteNODATA
- 7.15 SDO_GEOR.deletePyramid
- 7.16 SDO_GEOR.evaluateDouble
- 7.17 SDO_GEOR.evaluateDoubles
- 7.18 SDO_GEOR.exportTo
- 7.19 SDO_GEOR.generateAreaWeightedMean
- 7.20 SDO_GEOR.generateBitmapPyramid
- 7.21 SDO_GEOR.generateBlockMBR
- 7.22 SDO_GEOR.generatePyramid
- 7.23 SDO_GEOR.generateSpatialExtent
- 7.24 SDO_GEOR.generateSpatialResolutions
- 7.25 SDO_GEOR.generateStatistics
- 7.26 SDO_GEOR.generateStatisticsMax
- 7.27 SDO_GEOR.generateStatisticsMean
- 7.28 SDO_GEOR.generateStatisticsMedian
- 7.29 SDO_GEOR.generateStatisticsMin
- 7.30 SDO_GEOR.generateStatisticsMode
- 7.31 SDO_GEOR.generateStatisticsSTD
- 7.32 SDO_GEOR.georeference
- 7.33 SDO_GEOR.getBandDimSize
- 7.34 SDO_GEOR.getBeginDateTime
- 7.35 SDO_GEOR.getBinFunction
- 7.36 SDO_GEOR.getBinTable
- 7.37 SDO_GEOR.getBinType
- 7.38 SDO_GEOR.getBitmapMask
- 7.39 SDO_GEOR.getBitmapMaskSubset
- 7.40 SDO_GEOR.getBitmapMaskValue
- 7.41 SDO_GEOR.getBitmapMaskValues
- 7.42 SDO_GEOR.getBlankCellValue
- 7.43 SDO_GEOR.getBlockingType
- 7.44 SDO_GEOR.getBlockSize
- 7.45 SDO_GEOR.getCellCoordinate
- 7.46 SDO_GEOR.getCellDepth
- 7.47 SDO_GEOR.getCellValue
- 7.48 SDO_GEOR.getCellValues
- 7.49 SDO_GEOR.getColorMap
- 7.50 SDO_GEOR.getColorMapTable
- 7.51 SDO_GEOR.getCompressionType
- 7.52 SDO_GEOR.getControlPoint
- 7.53 SDO_GEOR.getDefaultAlpha
- 7.54 SDO_GEOR.getDefaultBlue
- 7.55 SDO_GEOR.getDefaultColorLayer
- 7.56 SDO_GEOR.getDefaultGreen
- 7.57 SDO_GEOR.getDefaultPyramidLevel
- 7.58 SDO_GEOR.getDefaultRed
- 7.59 SDO_GEOR.getEndDateTime
- 7.60 SDO_GEOR.getGCPGeorefMethod
- 7.61 SDO_GEOR.getGCPGeorefModel
- 7.62 SDO_GEOR.getGeoreferenceType
- 7.63 SDO_GEOR.getGrayScale
- 7.64 SDO_GEOR.getGrayScaleTable
- 7.65 SDO_GEOR.getHistogram
- 7.66 SDO_GEOR.getHistogramTable
- 7.67 SDO_GEOR.getID
- 7.68 SDO_GEOR.getInterleavingType
- 7.69 SDO_GEOR.getJP2TileSize
- 7.70 SDO_GEOR.getLayerDimension
- 7.71 SDO_GEOR.getLayerID
- 7.72 SDO_GEOR.getLayerOrdinate
- 7.73 SDO_GEOR.getModelCoordinate
- 7.74 SDO_GEOR.getModelCoordLocation
- 7.75 SDO_GEOR.getModelSRID
- 7.76 SDO_GEOR.getNODATA
- 7.77 SDO_GEOR.getPyramidMaxLevel
- 7.78 SDO_GEOR.getPyramidType
- 7.79 SDO_GEOR.getRasterBlockLocator
- 7.80 SDO_GEOR.getRasterBlocks
- 7.81 SDO_GEOR.getRasterData
- 7.82 SDO_GEOR.getRasterRange
- 7.83 SDO_GEOR.getRasterSubset
- 7.84 SDO_GEOR.getScaling
- 7.85 SDO_GEOR.getSourceInfo
- 7.86 SDO_GEOR.getSpatialDimNumber
- 7.87 SDO_GEOR.getSpatialDimSizes
- 7.88 SDO_GEOR.getSpatialResolutions
- 7.89 SDO_GEOR.getSpectralResolution
- 7.90 SDO_GEOR.getSpectralUnit
- 7.91 SDO_GEOR.getSRS
- 7.92 SDO_GEOR.getStatistics
- 7.93 SDO_GEOR.getTotalLayerNumber
- 7.94 SDO_GEOR.getULTCoordinate
- 7.95 SDO_GEOR.getVAT
- 7.96 SDO_GEOR.getVersion
- 7.97 SDO_GEOR.hasBitmapMask
- 7.98 SDO_GEOR.hasGrayScale
- 7.99 SDO_GEOR.hasNODATAMask
- 7.100 SDO_GEOR.hasPseudoColor
- 7.101 SDO_GEOR.importFrom
- 7.102 SDO_GEOR.init
- 7.103 SDO_GEOR.isBlank
- 7.104 SDO_GEOR.isOrthoRectified
- 7.105 SDO_GEOR.isRectified
- 7.106 SDO_GEOR.isSpatialReferenced
- 7.107 SDO_GEOR.mask
- 7.108 SDO_GEOR.mergeLayers
- 7.109 SDO_GEOR.mosaic
- 7.110 SDO_GEOR.rectify
- 7.111 SDO_GEOR.reproject
- 7.112 SDO_GEOR.scaleCopy
- 7.113 SDO_GEOR.schemaValidate
- 7.114 SDO_GEOR.setBeginDateTime
- 7.115 SDO_GEOR.setBinFunction
- 7.116 SDO_GEOR.setBinTable
- 7.117 SDO_GEOR.setBitmapMask
- 7.118 SDO_GEOR.setBlankCellValue
- 7.119 SDO_GEOR.setColorMap
- 7.120 SDO_GEOR.setColorMapTable
- 7.121 SDO_GEOR.setControlPoint
- 7.122 SDO_GEOR.setDefaultAlpha
- 7.123 SDO_GEOR.setDefaultBlue
- 7.124 SDO_GEOR.setDefaultColorLayer
- 7.125 SDO_GEOR.setDefaultGreen
- 7.126 SDO_GEOR.setDefaultPyramidLevel
- 7.127 SDO_GEOR.setDefaultRed
- 7.128 SDO_GEOR.setEndDateTime
- 7.129 SDO_GEOR.setGCPGeorefMethod
- 7.130 SDO_GEOR.setGCPGeorefModel
- 7.131 SDO_GEOR.setGrayScale
- 7.132 SDO_GEOR.setGrayScaleTable
- 7.133 SDO_GEOR.setHistogramTable
- 7.134 SDO_GEOR.setID
- 7.135 SDO_GEOR.setLayerID
- 7.136 SDO_GEOR.setLayerOrdinate
- 7.137 SDO_GEOR.setModelCoordLocation
- 7.138 SDO_GEOR.setModelSRID
- 7.139 SDO_GEOR.setNODATAMask
- 7.140 SDO_GEOR.setOrthoRectified
- 7.141 SDO_GEOR.setRasterType
- 7.142 SDO_GEOR.setRectified
- 7.143 SDO_GEOR.setScaling
- 7.144 SDO_GEOR.setSourceInfo
- 7.145 SDO_GEOR.setSpatialReferenced
- 7.146 SDO_GEOR.setSpatialResolutions
- 7.147 SDO_GEOR.setSpectralResolution
- 7.148 SDO_GEOR.setSpectralUnit
- 7.149 SDO_GEOR.setSRS
- 7.150 SDO_GEOR.setStatistics
- 7.151 SDO_GEOR.setULTCoordinate
- 7.152 SDO_GEOR.setVAT
- 7.153 SDO_GEOR.setVersion
- 7.154 SDO_GEOR.subset
- 7.155 SDO_GEOR.updateRaster
- 7.156 SDO_GEOR.validateBlockMBR
- 7.157 SDO_GEOR.validateGeoRaster
- 7.158 SDO_GEOR.warp
8 SDO_GEOR_ADMIN Package Reference
- 8.1 SDO_GEOR_ADMIN.checkSysdataEntries
- 8.2 SDO_GEOR_ADMIN.enableGeoRaster
- 8.3 SDO_GEOR_ADMIN.isGeoRasterEnabled
- 8.4 SDO_GEOR_ADMIN.isRDTNameUnique
- 8.5 SDO_GEOR_ADMIN.isUpgradeNeeded
- 8.6 SDO_GEOR_ADMIN.listGeoRasterColumns
- 8.7 SDO_GEOR_ADMIN.listGeoRasterObjects
- 8.8 SDO_GEOR_ADMIN.listGeoRasterTables
- 8.9 SDO_GEOR_ADMIN.listDanglingRasterData
- 8.10 SDO_GEOR_ADMIN.listRDT
- 8.11 SDO_GEOR_ADMIN.listRegisteredRDT
- 8.12 SDO_GEOR_ADMIN.listUnregisteredRDT
- 8.13 SDO_GEOR_ADMIN.maintainSysdataEntries
- 8.14 SDO_GEOR_ADMIN.registerGeoRasterColumns
- 8.15 SDO_GEOR_ADMIN.registerGeoRasterObjects
- 8.16 SDO_GEOR_ADMIN.upgradeGeoRaster
9 SDO_GEOR_AGGR Package Reference
- 9.1 SDO_GEOR_AGGR.append
- 9.2 SDO_GEOR_AGGR.getMosaicExtent
- 9.3 SDO_GEOR_AGGR.getMosaicResolutions
- 9.4 SDO_GEOR_AGGR.getMosaicStatistics
- 9.5 SDO_GEOR_AGGR.getMosaicSubset
- 9.6 SDO_GEOR_AGGR.mosaicSubset
- 9.7 SDO_GEOR_AGGR.validateForMosaicSubset
10 SDO_GEOR_GDAL Package Reference
- 10.1 SDO_GEOR_GDAL.dem
- 10.2 SDO_GEOR_GDAL.translate
11 SDO_GEOR_IP Package Reference
- 11.1 SDO_GEOR_IP.dodge
- 11.2 SDO_GEOR_IP.equalize
- 11.3 SDO_GEOR_IP.filter
- 11.4 SDO_GEOR_IP.histogramMatch
- 11.5 SDO_GEOR_IP.normalize
- 11.6 SDO_GEOR_IP.piecewiseStretch
- 11.7 SDO_GEOR_IP.stretch
12 SDO_GEOR_RA Package Reference
- 12.1 SDO_GEOR_RA.classify
- 12.2 SDO_GEOR_RA.diff
- 12.3 SDO_GEOR_RA.findCells
- 12.4 SDO_GEOR_RA.isOverlap
- 12.5 SDO_GEOR_RA.over
- 12.6 SDO_GEOR_RA.rasterMathOp
- 12.7 SDO_GEOR_RA.rasterUpdate
- 12.8 SDO_GEOR_RA.stack
13 SDO_GEOR_UTL Package Reference
- 13.1 SDO_GEOR_UTL.calcOptimizedBlockSize
- 13.2 SDO_GEOR_UTL.calcRasterNominalSize
- 13.3 SDO_GEOR_UTL.calcRasterStorageSize
- 13.4 SDO_GEOR_UTL.calcSurfaceArea
- 13.5 SDO_GEOR_UTL.clearReportTable
- 13.6 SDO_GEOR_UTL.createDMLTrigger
- 13.7 SDO_GEOR_UTL.createReportTable
- 13.8 SDO_GEOR_UTL.disableReport
- 13.9 SDO_GEOR_UTL.dropReportTable
- 13.10 SDO_GEOR_UTL.emptyBlocks
- 13.11 SDO_GEOR_UTL.enableReport
- 13.12 SDO_GEOR_UTL.fillEmptyBlocks
- 13.13 SDO_GEOR_UTL.generateColorRamp
- 13.14 SDO_GEOR_UTL.generateGrayRamp
- 13.15 SDO_GEOR_UTL.getAllStatusReport
- 13.16 SDO_GEOR_UTL.getMaxMemSize
- 13.17 SDO_GEOR_UTL.getReadBlockMemSize
- 13.18 SDO_GEOR_UTL.getProgress
- 13.19 SDO_GEOR_UTL.getStatusReport
- 13.20 SDO_GEOR_UTL.getWriteBlockMemSize
- 13.21 SDO_GEOR_UTL.isReporting
- 13.22 SDO_GEOR_UTL.makeRDTNamesUnique
- 13.23 SDO_GEOR_UTL.recreateDMLTriggers
- 13.24 SDO_GEOR_UTL.renameRDT
- 13.25 SDO_GEOR_UTL.setClientID
- 13.26 SDO_GEOR_UTL.setMaxMemSize
- 13.27 SDO_GEOR_UTL.setReadBlockMemSize
- 13.28 SDO_GEOR_UTL.setSeqID
- 13.29 SDO_GEOR_UTL.setWriteBlockMemSize
A GeoRaster Metadata XML Schema
Index