1/20

Contents

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 12c Release 2 (12.2.0.1)
  • Native JPEG 2000 Compression
  • New Image Processing Capabilities
  • New Raster Algebra Capabilities
  • New Core Subprograms and Enhancements
  • Java API, Client-Side Viewer, and ETL Enhancements
  • Web Coverage Service (WCS) 2.0.1 Support
  • SDO_GEOR_IP Package
  • Other Changes for Release 12.2.0.1
• Changes in Oracle Database 12c Release 1 (12.1.0.2)
  • GeoRaster Not Enabled by Default
  • JAVA API Supports All Release 12c New Features
  • Third-Party Plug-in Installation Change
  • GDAL-Based ETL Tool Enhancements
  • SDO_GEOR_AGGR Package Enhancements
  • Other Changes for Release 12.1.0.2
• Changes in Oracle Database 12c Release 1 (12.1.0.1)
  • New Features
    • Raster Algebra and Analytics
    • Advanced Image Processing and Virtual Mosaic
    • GeoRaster Core Enhancements
    • Other New Server-Side Subprograms and Features
    • New and Enhanced Client-Side Tools and Java API
    • SDO_GEOR_AGGR Package
    • SDO_GEOR_RA Package
  • Deprecated Features
  • Other Changes

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.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.1.1 rasterType Attribute
  • 2.1.2 spatialExtent Attribute
  • 2.1.3 rasterDataTable Attribute
  • 2.1.4 rasterID Attribute
  • 2.1.5 metadata Attribute
• 2.2 SDO_RASTER Object Type and the Raster Data Table
  • 2.2.1 rasterID Attribute
  • 2.2.2 pyramidLevel Attribute
  • 2.2.3 bandBlockNumber Attribute
  • 2.2.4 rowBlockNumber Attribute
  • 2.2.5 columnBlockNumber Attribute
  • 2.2.6 blockMBR Attribute
  • 2.2.7 rasterBlock Attribute
• 2.3 Other GeoRaster Types
  • 2.3.1 SDO_GEOR_HISTOGRAM Object Type
  • 2.3.2 SDO_GEOR_COLORMAP Object Type
  • 2.3.3 SDO_GEOR_GRAYSCALE Object Type
  • 2.3.4 SDO_RASTERSET Collection Type
  • 2.3.5 SDO_GEOR_SRS Object Type
  • 2.3.6 SDO_GEOR_GCP Object Type
  • 2.3.7 SDO_GEOR_GCP_ COLLECTION Collection Type
  • 2.3.8 SDO_GEOR_GCPGEOREFTYPE Object Type
• 2.4 GeoRaster System Data Views (xxx_SDO_GEOR_SYSDATA)
  • 2.4.1 TABLE_NAME Column
  • 2.4.2 COLUMN_NAME Column
  • 2.4.3 METADATA_COLUMN_NAME Column
  • 2.4.4 RDT_TABLE_NAME Column
  • 2.4.5 RASTER_ID Column
  • 2.4.6 OTHER_TABLE_NAMES Column
• 2.5 GeoRaster XML Schema

3 GeoRaster Database Creation and Management

• 3.1 Adding Data Files and Temporary Tablespaces for GeoRaster Users
• 3.2 Creating the GeoRaster Table and Raster Data Tables
  • 3.2.1 Creating a GeoRaster Table
  • 3.2.2 Creating Raster Data Tables
  • 3.2.3 GeoRaster DML Trigger
• 3.3 Creating New GeoRaster Objects
• 3.4 Loading Raster Data
  • 3.4.1 Loading with Blocking and Optimal Padding
  • 3.4.2 Loading JPEG and JPEG 2000 Images Without Decompression
  • 3.4.3 Reformatting the Source Raster Before Loading
• 3.5 Validating GeoRaster Objects
• 3.6 Georeferencing GeoRaster Objects
• 3.7 Generating and Setting Spatial Extents
  • 3.7.1 Special Considerations if the GeoRaster Table Has a Spatial Index
• 3.8 Indexing GeoRaster Objects
• 3.9 Viewing GeoRaster Objects
• 3.10 Exporting GeoRaster Objects
• 3.11 Using GeoRaster with Workspace Manager and Label Security
  • 3.11.1 Using GeoRaster with Workspace Manager
  • 3.11.2 Using GeoRaster with Label Security
• 3.12 Maintaining Efficient Tablespace Use by GeoRaster Objects
• 3.13 Checking GeoRaster Tables and Objects in the Database
• 3.14 Maintaining GeoRaster Objects and System Data in the Database
• 3.15 Transferring GeoRaster Data Between Databases
  • 3.15.1 Checking for and Resolving Conflicts
  • 3.15.2 Performing the GeoRaster Data Transfer
• 3.16 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

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.18.1 Virtual Mosaic as One or a List of GeoRaster Tables
  • 6.18.2 Virtual Mosaic as a View with a GeoRaster Column
  • 6.18.3 Virtual Mosaic as a SQL Query Statement or a Cursor
  • 6.18.4 Using Virtual Mosaic in Applications
  • 6.18.5 Special Considerations for Large-Scale Virtual Mosaic
    • 6.18.5.1 Improving Query Performance Using MIN_X_RES$ and MAX_X_RES$
• 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.isRDTNameUnique
• 8.3 SDO_GEOR_ADMIN.isUpgradeNeeded
• 8.4 SDO_GEOR_ADMIN.listGeoRasterColumns
• 8.5 SDO_GEOR_ADMIN.listGeoRasterObjects
• 8.6 SDO_GEOR_ADMIN.listGeoRasterTables
• 8.7 SDO_GEOR_ADMIN.listDanglingRasterData
• 8.8 SDO_GEOR_ADMIN.listRDT
• 8.9 SDO_GEOR_ADMIN.listRegisteredRDT
• 8.10 SDO_GEOR_ADMIN.listUnregisteredRDT
• 8.11 SDO_GEOR_ADMIN.maintainSysdataEntries
• 8.12 SDO_GEOR_ADMIN.registerGeoRasterColumns
• 8.13 SDO_GEOR_ADMIN.registerGeoRasterObjects
• 8.14 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.getMosaicSubset
• 9.5 SDO_GEOR_AGGR.mosaicSubset
• 9.6 SDO_GEOR_AGGR.validateForMosaicSubset

10 SDO_GEOR_IP Package Reference

• 10.1 SDO_GEOR_IP.dodge
• 10.2 SDO_GEOR_IP.equalize
• 10.3 SDO_GEOR_IP.filter
• 10.4 SDO_GEOR_IP.histogramMatch
• 10.5 SDO_GEOR_IP.normalize
• 10.6 SDO_GEOR_IP.piecewiseStretch
• 10.7 SDO_GEOR_IP.stretch

11 SDO_GEOR_RA Package Reference

• 11.1 SDO_GEOR_RA.classify
• 11.2 SDO_GEOR_RA.diff
• 11.3 SDO_GEOR_RA.findCells
• 11.4 SDO_GEOR_RA.isOverlap
• 11.5 SDO_GEOR_RA.over
• 11.6 SDO_GEOR_RA.rasterMathOp
• 11.7 SDO_GEOR_RA.rasterUpdate
• 11.8 SDO_GEOR_RA.stack

12 SDO_GEOR_UTL Package Reference

• 12.1 SDO_GEOR_UTL.calcOptimizedBlockSize
• 12.2 SDO_GEOR_UTL.calcRasterNominalSize
• 12.3 SDO_GEOR_UTL.calcRasterStorageSize
• 12.4 SDO_GEOR_UTL.calcSurfaceArea
• 12.5 SDO_GEOR_UTL.clearReportTable
• 12.6 SDO_GEOR_UTL.createDMLTrigger
• 12.7 SDO_GEOR_UTL.createReportTable
• 12.8 SDO_GEOR_UTL.disableReport
• 12.9 SDO_GEOR_UTL.dropReportTable
• 12.10 SDO_GEOR_UTL.emptyBlocks
• 12.11 SDO_GEOR_UTL.enableReport
• 12.12 SDO_GEOR_UTL.fillEmptyBlocks
• 12.13 SDO_GEOR_UTL.generateColorRamp
• 12.14 SDO_GEOR_UTL.generateGrayRamp
• 12.15 SDO_GEOR_UTL.getAllStatusReport
• 12.16 SDO_GEOR_UTL.getMaxMemSize
• 12.17 SDO_GEOR_UTL.getReadBlockMemSize
• 12.18 SDO_GEOR_UTL.getProgress
• 12.19 SDO_GEOR_UTL.getStatusReport
• 12.20 SDO_GEOR_UTL.getWriteBlockMemSize
• 12.21 SDO_GEOR_UTL.isReporting
• 12.22 SDO_GEOR_UTL.makeRDTNamesUnique
• 12.23 SDO_GEOR_UTL.recreateDMLTriggers
• 12.24 SDO_GEOR_UTL.renameRDT
• 12.25 SDO_GEOR_UTL.setClientID
• 12.26 SDO_GEOR_UTL.setMaxMemSize
• 12.27 SDO_GEOR_UTL.setReadBlockMemSize
• 12.28 SDO_GEOR_UTL.setSeqID
• 12.29 SDO_GEOR_UTL.setWriteBlockMemSize

A GeoRaster Metadata XML Schema

Index