1/19

Contents

List of Examples

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 1 (12.1.0.2)
• Changes in Oracle Database 12c Release 1 (12.1.0.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 Compression of GeoRaster Objects
    • 1.11.1.1 JPEG-B Support Deprecated
  • 1.11.2 DEFLATE Compression of GeoRaster Objects
  • 1.11.3 Decompression of GeoRaster Objects
  • 1.11.4 Third-Party Plug-ins for Compression
  • 1.11.5 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 Tools: Viewer, Loader, Exporter
  • 1.17.1 JAI-Based Viewer, Loader, and Exporter
  • 1.17.2 GDAL-Based ETL Wizard for Concurrent Batch Loading and Exporting
• 1.18 GeoRaster PL/SQL and Java Demo Files
• 1.19 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 Basic GeoRaster Operations

• 3.1 Creating the GeoRaster Table and Raster Data Tables
  • 3.1.1 Creating a GeoRaster Table
  • 3.1.2 Creating Raster Data Tables
  • 3.1.3 GeoRaster DML Trigger
• 3.2 Creating New GeoRaster Objects
• 3.3 Adding Temporary Tablespaces for GeoRaster Users
• 3.4 Loading Raster Data
  • 3.4.1 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 Querying and Searching GeoRaster Objects
• 3.10 Changing and Optimizing Raster Storage
• 3.11 Copying GeoRaster Objects
• 3.12 Querying and Updating GeoRaster Metadata
• 3.13 Querying and Updating GeoRaster Cell Data
• 3.14 Interpolating Cell Values
• 3.15 Processing and Analyzing GeoRaster Objects
• 3.16 Monitoring and Reporting GeoRaster Operation Progress
• 3.17 Compressing and Decompressing GeoRaster Objects
• 3.18 Deleting GeoRaster Objects, and Dropping GeoRaster Tables and RDTs
• 3.19 Viewing GeoRaster Objects
• 3.20 Exporting GeoRaster Objects
• 3.21 Updating GeoRaster Objects Before Committing
• 3.22 Using Template-Related Subprograms to Develop GeoRaster Applications
• 3.23 Using GeoRaster with Workspace Manager and Label Security
  • 3.23.1 Using GeoRaster with Workspace Manager
  • 3.23.2 Using GeoRaster with Label Security
• 3.24 Maintaining Efficient Tablespace Use by GeoRaster Objects
• 3.25 Maintaining GeoRaster Objects and System Data in the Database
• 3.26 Transferring GeoRaster Data Between Databases
  • 3.26.1 Checking for and Resolving Conflicts
  • 3.26.2 Performing the GeoRaster Data Transfer
• 3.27 Using Transportable Tablespaces with GeoRaster Data

4 Raster Algebra and Analytics

• 4.1 Raster Algebra Language
  • 4.1.1 Examples of Raster Algebra Expressions
• 4.2 Cell Value-Based Conditional Queries
• 4.3 Cell Value-Based Conditional Updates (Edits)
• 4.4 Mathematical Operations
• 4.5 Classification Operations
• 4.6 On-the-Fly Statistical Analysis
• 4.7 Raster Data Scaling and Offsetting
• 4.8 Raster Data Casting
• 4.9 Cartographic Modeling

5 Image Processing and Virtual Mosaic

• 5.1 Advanced Georeferencing
• 5.2 Image Reprojection
• 5.3 Image Rectification
• 5.4 Image Orthorectification
  • 5.4.1 Orthorectification with Average Height
  • 5.4.2 Orthorectification with DEM
• 5.5 Image Scaling
• 5.6 Image Stretching
• 5.7 Image Segmentation
• 5.8 Image Pyramiding: Parallel Generation and Partial Update
• 5.9 Bitmap Pyramiding
• 5.10 Vegetation Index Computation
• 5.11 Tasseled Cap Transformation
• 5.12 Image Masking
• 5.13 Band Merging
• 5.14 Image Appending
• 5.15 Large-Scale Image Mosaicking
  • 5.15.1 Parallel Compression, Copying, Subsetting, Reprojection, and Rectification
• 5.16 Virtual Mosaic
  • 5.16.1 Virtual Mosaic as One or a List of GeoRaster Tables
  • 5.16.2 Virtual Mosaic as a View with a GeoRaster Column
  • 5.16.3 Virtual Mosaic as a SQL Query Statement or a Cursor
  • 5.16.4 Using Virtual Mosaic in Applications
  • 5.16.5 Special Considerations for Large-Scale Virtual Mosaic
    • 5.16.5.1 Improving Query Performance Using MIN_X_RES$ and MAX_X_RES$
• 5.17 Image Serving

6 SDO_GEOR Package Reference

• SDO_GEOR.addNODATA
• SDO_GEOR.addSourceInfo
• SDO_GEOR.calcCompressionRatio
• SDO_GEOR.changeCellValue
• SDO_GEOR.changeFormatCopy
• SDO_GEOR.copy
• SDO_GEOR.createBlank
• SDO_GEOR.createTemplate
• SDO_GEOR.deleteControlPoint
• SDO_GEOR.deleteNODATA
• SDO_GEOR.deletePyramid
• SDO_GEOR.evaluateDouble
• SDO_GEOR.exportTo
• 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.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.getBlankCellValue
• SDO_GEOR.getBlockingType
• SDO_GEOR.getBlockSize
• SDO_GEOR.getCellCoordinate
• SDO_GEOR.getCellDepth
• SDO_GEOR.getCellValue
• 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.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

7 SDO_GEOR_ADMIN Package Reference

• SDO_GEOR_ADMIN.checkSysdataEntries
• 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

8 SDO_GEOR_AGGR Package Reference

• SDO_GEOR_AGGR.append
• SDO_GEOR_AGGR.getMosaicExtent
• SDO_GEOR_AGGR.getMosaicResolutions
• SDO_GEOR_AGGR.getMosaicSubset
• SDO_GEOR_AGGR.mosaicSubset
• SDO_GEOR_AGGR.validateForMosaicSubset

9 SDO_GEOR_RA Package Reference

• SDO_GEOR_RA.classify
• SDO_GEOR_RA.findCells
• SDO_GEOR_RA.isOverlap
• SDO_GEOR_RA.rasterMathOp
• SDO_GEOR_RA.rasterUpdate

10 SDO_GEOR_UTL Package Reference

• SDO_GEOR_UTL.calcOptimizedBlockSize
• SDO_GEOR_UTL.calcRasterNominalSize
• SDO_GEOR_UTL.calcRasterStorageSize
• SDO_GEOR_UTL.clearReportTable
• SDO_GEOR_UTL.createDMLTrigger
• 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.getAllStatusReport
• SDO_GEOR_UTL.getProgress
• SDO_GEOR_UTL.getStatusReport
• SDO_GEOR_UTL.isReporting
• SDO_GEOR_UTL.makeRDTNamesUnique
• SDO_GEOR_UTL.recreateDMLTriggers
• SDO_GEOR_UTL.renameRDT
• SDO_GEOR_UTL.setClientID
• SDO_GEOR_UTL.setSeqID

A GeoRaster Metadata XML Schema

Index