Go to main content
1/18
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 12
c
Release 1 (12.1.0.2)
GeoRaster Not Enabled by Default
JAVA API Supports All Release 12
c
New Features
Third-Party Plug-in Installation Change
GDAL-Based ETL Tool Enhancements
SDO_GEOR_AGGR Package Enhancements
Other Changes
Changes in Oracle Database 12
c
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 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 Interface
1.17
GeoRaster Java API
1.18
GeoRaster Tools: Viewer, Loader, Exporter
1.18.1
JAI-Based Viewer, Loader, and Exporter
1.18.2
GDAL-Based ETL Wizard for Concurrent Batch Loading and Exporting
1.19
GeoRaster PL/SQL and Java Demo Files
1.20
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
6.1
SDO_GEOR.addNODATA
6.2
SDO_GEOR.addSourceInfo
6.3
SDO_GEOR.calcCompressionRatio
6.4
SDO_GEOR.changeCellValue
6.5
SDO_GEOR.changeFormatCopy
6.6
SDO_GEOR.copy
6.7
SDO_GEOR.createBlank
6.8
SDO_GEOR.createTemplate
6.9
SDO_GEOR.deleteControlPoint
6.10
SDO_GEOR.deleteNODATA
6.11
SDO_GEOR.deletePyramid
6.12
SDO_GEOR.evaluateDouble
6.13
SDO_GEOR.exportTo
6.14
SDO_GEOR.generateBlockMBR
6.15
SDO_GEOR.generatePyramid
6.16
SDO_GEOR.generateSpatialExtent
6.17
SDO_GEOR.generateSpatialResolutions
6.18
SDO_GEOR.generateStatistics
6.19
SDO_GEOR.generateStatisticsMax
6.20
SDO_GEOR.generateStatisticsMean
6.21
SDO_GEOR.generateStatisticsMedian
6.22
SDO_GEOR.generateStatisticsMin
6.23
SDO_GEOR.generateStatisticsMode
6.24
SDO_GEOR.generateStatisticsSTD
6.25
SDO_GEOR.georeference
6.26
SDO_GEOR.getBandDimSize
6.27
SDO_GEOR.getBeginDateTime
6.28
SDO_GEOR.getBinFunction
6.29
SDO_GEOR.getBinTable
6.30
SDO_GEOR.getBinType
6.31
SDO_GEOR.getBitmapMask
6.32
SDO_GEOR.getBitmapMaskSubset
6.33
SDO_GEOR.getBitmapMaskValue
6.34
SDO_GEOR.getBlankCellValue
6.35
SDO_GEOR.getBlockingType
6.36
SDO_GEOR.getBlockSize
6.37
SDO_GEOR.getCellCoordinate
6.38
SDO_GEOR.getCellDepth
6.39
SDO_GEOR.getCellValue
6.40
SDO_GEOR.getColorMap
6.41
SDO_GEOR.getColorMapTable
6.42
SDO_GEOR.getCompressionType
6.43
SDO_GEOR.getControlPoint
6.44
SDO_GEOR.getDefaultAlpha
6.45
SDO_GEOR.getDefaultBlue
6.46
SDO_GEOR.getDefaultColorLayer
6.47
SDO_GEOR.getDefaultGreen
6.48
SDO_GEOR.getDefaultPyramidLevel
6.49
SDO_GEOR.getDefaultRed
6.50
SDO_GEOR.getEndDateTime
6.51
SDO_GEOR.getGCPGeorefMethod
6.52
SDO_GEOR.getGCPGeorefModel
6.53
SDO_GEOR.getGeoreferenceType
6.54
SDO_GEOR.getGrayScale
6.55
SDO_GEOR.getGrayScaleTable
6.56
SDO_GEOR.getHistogram
6.57
SDO_GEOR.getHistogramTable
6.58
SDO_GEOR.getID
6.59
SDO_GEOR.getInterleavingType
6.60
SDO_GEOR.getLayerDimension
6.61
SDO_GEOR.getLayerID
6.62
SDO_GEOR.getLayerOrdinate
6.63
SDO_GEOR.getModelCoordinate
6.64
SDO_GEOR.getModelCoordLocation
6.65
SDO_GEOR.getModelSRID
6.66
SDO_GEOR.getNODATA
6.67
SDO_GEOR.getPyramidMaxLevel
6.68
SDO_GEOR.getPyramidType
6.69
SDO_GEOR.getRasterBlockLocator
6.70
SDO_GEOR.getRasterBlocks
6.71
SDO_GEOR.getRasterData
6.72
SDO_GEOR.getRasterRange
6.73
SDO_GEOR.getRasterSubset
6.74
SDO_GEOR.getScaling
6.75
SDO_GEOR.getSourceInfo
6.76
SDO_GEOR.getSpatialDimNumber
6.77
SDO_GEOR.getSpatialDimSizes
6.78
SDO_GEOR.getSpatialResolutions
6.79
SDO_GEOR.getSpectralResolution
6.80
SDO_GEOR.getSpectralUnit
6.81
SDO_GEOR.getSRS
6.82
SDO_GEOR.getStatistics
6.83
SDO_GEOR.getTotalLayerNumber
6.84
SDO_GEOR.getULTCoordinate
6.85
SDO_GEOR.getVAT
6.86
SDO_GEOR.getVersion
6.87
SDO_GEOR.hasBitmapMask
6.88
SDO_GEOR.hasGrayScale
6.89
SDO_GEOR.hasNODATAMask
6.90
SDO_GEOR.hasPseudoColor
6.91
SDO_GEOR.importFrom
6.92
SDO_GEOR.init
6.93
SDO_GEOR.isBlank
6.94
SDO_GEOR.isOrthoRectified
6.95
SDO_GEOR.isRectified
6.96
SDO_GEOR.isSpatialReferenced
6.97
SDO_GEOR.mask
6.98
SDO_GEOR.mergeLayers
6.99
SDO_GEOR.mosaic
6.100
SDO_GEOR.rectify
6.101
SDO_GEOR.reproject
6.102
SDO_GEOR.scaleCopy
6.103
SDO_GEOR.schemaValidate
6.104
SDO_GEOR.setBeginDateTime
6.105
SDO_GEOR.setBinFunction
6.106
SDO_GEOR.setBinTable
6.107
SDO_GEOR.setBitmapMask
6.108
SDO_GEOR.setBlankCellValue
6.109
SDO_GEOR.setColorMap
6.110
SDO_GEOR.setColorMapTable
6.111
SDO_GEOR.setControlPoint
6.112
SDO_GEOR.setDefaultAlpha
6.113
SDO_GEOR.setDefaultBlue
6.114
SDO_GEOR.setDefaultColorLayer
6.115
SDO_GEOR.setDefaultGreen
6.116
SDO_GEOR.setDefaultPyramidLevel
6.117
SDO_GEOR.setDefaultRed
6.118
SDO_GEOR.setEndDateTime
6.119
SDO_GEOR.setGCPGeorefMethod
6.120
SDO_GEOR.setGCPGeorefModel
6.121
SDO_GEOR.setGrayScale
6.122
SDO_GEOR.setGrayScaleTable
6.123
SDO_GEOR.setHistogramTable
6.124
SDO_GEOR.setID
6.125
SDO_GEOR.setLayerID
6.126
SDO_GEOR.setLayerOrdinate
6.127
SDO_GEOR.setModelCoordLocation
6.128
SDO_GEOR.setModelSRID
6.129
SDO_GEOR.setNODATAMask
6.130
SDO_GEOR.setOrthoRectified
6.131
SDO_GEOR.setRasterType
6.132
SDO_GEOR.setRectified
6.133
SDO_GEOR.setScaling
6.134
SDO_GEOR.setSourceInfo
6.135
SDO_GEOR.setSpatialReferenced
6.136
SDO_GEOR.setSpatialResolutions
6.137
SDO_GEOR.setSpectralResolution
6.138
SDO_GEOR.setSpectralUnit
6.139
SDO_GEOR.setSRS
6.140
SDO_GEOR.setStatistics
6.141
SDO_GEOR.setULTCoordinate
6.142
SDO_GEOR.setVAT
6.143
SDO_GEOR.setVersion
6.144
SDO_GEOR.subset
6.145
SDO_GEOR.updateRaster
6.146
SDO_GEOR.validateBlockMBR
6.147
SDO_GEOR.validateGeoRaster
7
SDO_GEOR_ADMIN Package Reference
7.1
SDO_GEOR_ADMIN.checkSysdataEntries
7.2
SDO_GEOR_ADMIN.isRDTNameUnique
7.3
SDO_GEOR_ADMIN.isUpgradeNeeded
7.4
SDO_GEOR_ADMIN.listGeoRasterColumns
7.5
SDO_GEOR_ADMIN.listGeoRasterObjects
7.6
SDO_GEOR_ADMIN.listGeoRasterTables
7.7
SDO_GEOR_ADMIN.listDanglingRasterData
7.8
SDO_GEOR_ADMIN.listRDT
7.9
SDO_GEOR_ADMIN.listRegisteredRDT
7.10
SDO_GEOR_ADMIN.listUnregisteredRDT
7.11
SDO_GEOR_ADMIN.maintainSysdataEntries
7.12
SDO_GEOR_ADMIN.registerGeoRasterColumns
7.13
SDO_GEOR_ADMIN.registerGeoRasterObjects
7.14
SDO_GEOR_ADMIN.upgradeGeoRaster
8
SDO_GEOR_AGGR Package Reference
8.1
SDO_GEOR_AGGR.append
8.2
SDO_GEOR_AGGR.getMosaicExtent
8.3
SDO_GEOR_AGGR.getMosaicResolutions
8.4
SDO_GEOR_AGGR.getMosaicSubset
8.5
SDO_GEOR_AGGR.mosaicSubset
8.6
SDO_GEOR_AGGR.validateForMosaicSubset
9
SDO_GEOR_RA Package Reference
9.1
SDO_GEOR_RA.classify
9.2
SDO_GEOR_RA.findCells
9.3
SDO_GEOR_RA.isOverlap
9.4
SDO_GEOR_RA.rasterMathOp
9.5
SDO_GEOR_RA.rasterUpdate
10
SDO_GEOR_UTL Package Reference
10.1
SDO_GEOR_UTL.calcOptimizedBlockSize
10.2
SDO_GEOR_UTL.calcRasterNominalSize
10.3
SDO_GEOR_UTL.calcRasterStorageSize
10.4
SDO_GEOR_UTL.clearReportTable
10.5
SDO_GEOR_UTL.createDMLTrigger
10.6
SDO_GEOR_UTL.createReportTable
10.7
SDO_GEOR_UTL.disableReport
10.8
SDO_GEOR_UTL.dropReportTable
10.9
SDO_GEOR_UTL.emptyBlocks
10.10
SDO_GEOR_UTL.enableReport
10.11
SDO_GEOR_UTL.fillEmptyBlocks
10.12
SDO_GEOR_UTL.getAllStatusReport
10.13
SDO_GEOR_UTL.getProgress
10.14
SDO_GEOR_UTL.getStatusReport
10.15
SDO_GEOR_UTL.isReporting
10.16
SDO_GEOR_UTL.makeRDTNamesUnique
10.17
SDO_GEOR_UTL.recreateDMLTriggers
10.18
SDO_GEOR_UTL.renameRDT
10.19
SDO_GEOR_UTL.setClientID
10.20
SDO_GEOR_UTL.setSeqID
A
GeoRaster Metadata XML Schema
Index
Scripting on this page enhances content navigation, but does not change the content in any way.