Oracle® Spatial
GeoRaster
10g Release 1 (10.1)
Part No. B10827-01
December 2003
Provides usage and reference information for the
GeoRaster feature of Oracle Spatial, which lets you store,
index, query, analyze, and deliver GeoRaster data, that
is, raster image and gridded data and its associated
metadata.
Oracle Spatial GeoRaster, 10g Release 1 (10.1)
Part No. B10827-01
Copyright © 2003 Oracle Corporation. All rights reserved.
Primary Author: Chuck Murray
Contributors: Janet Blowney, Jeffrey Xie, Terry Xu, Sophia Yuditskaya
The Programs (which include both the software and documentation) contain proprietary information of
Oracle Corporation; they are provided under a license agreement containing restrictions on use and
disclosure and are also protected by copyright, patent and other intellectual and industrial property
laws. Reverse engineering, disassembly or decompilation of the Programs, except to the extent required
to obtain interoperability with other independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems
in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this
document is error-free. Except as may be expressly permitted in your license agreement for these
Programs, no part of these Programs may be reproduced or transmitted in any form or by any means,
electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.
If the Programs are delivered to the U.S. Government or anyone licensing or using the programs on
behalf of the U.S. Government, the following notice is applicable:
Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial
computer software" and use, duplication, and disclosure of the Programs, including documentation,
shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement.
Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer
software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR
52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500
Oracle Parkway, Redwood City, CA 94065.
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently
dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,
redundancy, and other measures to ensure the safe use of such applications if the Programs are used for
such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the
Programs.
Oracle is a registered trademark, and Oracle Store and PL/SQL are trademarks or registered trademarks
of Oracle Corporation. Other names may be trademarks of their respective owners.
iii
Contents
List of Examples
List of Figures
List of Table s
Send Us Your Comments ................................................................................................................. xiii
Preface........................................................................................................................................................... xv
Audience ............................................................................................................................................... xvi
Documentation Accessibility ............................................................................................................. xvi
Organization........................................................................................................................................ xvii
Related Documentation ..................................................................................................................... xvii
Conventions......................................................................................................................................... xviii
1 GeoRaster Overview and Concepts
1.1 Vector and Raster Data......................................................................................................... 1-2
1.2 GeoRaster Targeted Data Sources and Uses ..................................................................... 1-2
1.2.1 Remote Sensing .............................................................................................................. 1-3
1.2.2 Photogrammetry ............................................................................................................ 1-3
1.2.3 Geographic Information Systems ................................................................................ 1-4
1.2.4 Cartography .................................................................................................................... 1-4
1.2.5 Digital Image Processing............................................................................................... 1-5
1.2.6 Geology, Geophysics, and Geochemistry................................................................... 1-5
1.3 GeoRaster Data Model.......................................................................................................... 1-5
1.4 GeoRaster Physical Storage ............................................................................................... 1-10
1.4.1 Storage Parameters ...................................................................................................... 1-14
1.4.2 Raster Data Table ......................................................................................................... 1-16
1.4.3 Blank and Empty GeoRaster Objects......................................................................... 1-17
iv
1.5 Bands, Layers, and Interleaving........................................................................................ 1-18
1.6 Georeferencing..................................................................................................................... 1-20
1.6.1 GeoRaster Georeferencing Method ........................................................................... 1-21
1.7 Pyramids ............................................................................................................................... 1-22
1.8 GeoRaster PL/SQL Subprogram Categories................................................................... 1-25
1.8.1 Subprograms to Create, Load, and Export GeoRaster Data .................................. 1-25
1.8.2 Subprograms to Validate and Process GeoRaster Objects ..................................... 1-26
1.8.3 Subprogram for GeoRaster DML Triggers ............................................................... 1-26
1.8.4 Subprograms to Get and Set GeoRaster Metadata and Data................................. 1-27
1.9 GeoRaster Tools: Loader, Viewer, Exporter .................................................................... 1-35
1.10 GeoRaster PL/SQL Demo Files......................................................................................... 1-36
2 GeoRaster Data Types and Related Structures
2.1 SDO_GEORASTER Object Type ......................................................................................... 2-1
2.1.1 rasterType Attribute ...................................................................................................... 2-2
2.1.2 spatialExtent Attribute .................................................................................................. 2-2
2.1.3 rasterDataTable Attribute ............................................................................................. 2-3
2.1.4 rasterID Attribute........................................................................................................... 2-3
2.1.5 metadata Attribute ......................................................................................................... 2-3
2.2 SDO_RASTER Object Type and the Raster Data Table ................................................... 2-4
2.2.1 rasterID Attribute........................................................................................................... 2-4
2.2.2 pyramidLevel Attribute................................................................................................. 2-4
2.2.3 bandBlockNumber Attribute........................................................................................ 2-5
2.2.4 rowBlockNumber Attribute.......................................................................................... 2-5
2.2.5 columnBlockNumber Attribute ................................................................................... 2-5
2.2.6 blockMBR Attribute ....................................................................................................... 2-5
2.2.7 rasterBlock Attribute...................................................................................................... 2-5
2.3 Other GeoRaster Types......................................................................................................... 2-5
2.3.1 SDO_GEOR_HISTOGRAM Object Type.................................................................... 2-5
2.3.2 SDO_GEOR_COLORMAP Object Type ..................................................................... 2-6
2.3.3 SDO_GEOR_GRAYSCALE Object Type .................................................................... 2-7
2.3.4 SDO_RASTERSET Collection Type ............................................................................. 2-8
2.3.5 SDO_GEOR_SRS Object Type ...................................................................................... 2-8
2.4 GeoRaster System Data Views (xxx_SDO_GEOR_SYSDATA) .................................... 2-10
2.4.1 TABLE_NAME Column.............................................................................................. 2-11
v
2.4.2 COLUMN_NAME Column........................................................................................ 2-11
2.4.3 METADATA_COLUMN_NAME Column .............................................................. 2-11
2.4.4 RDT_TABLE_NAME Column ................................................................................... 2-12
2.4.5 RASTER_ID Column ................................................................................................... 2-12
2.4.6 OTHER_TABLE_NAMES Column............................................................................ 2-12
2.5 GeoRaster XML Schema Table .......................................................................................... 2-12
3 GeoRaster Operations
3.1 Creating the Standard GeoRaster DML Trigger............................................................... 3-2
3.2 Creating New GeoRaster Objects........................................................................................ 3-3
3.3 Loading GeoRaster Data ...................................................................................................... 3-3
3.4 Validating GeoRaster Objects.............................................................................................. 3-4
3.5 Georeferencing GeoRaster Objects ..................................................................................... 3-4
3.6 Indexing GeoRaster Data ..................................................................................................... 3-5
3.7 Changing Raster Storage...................................................................................................... 3-6
3.8 Querying and Updating GeoRaster Metadata.................................................................. 3-6
3.9 Querying and Updating Cell Data...................................................................................... 3-7
3.10 Processing GeoRaster Objects.............................................................................................. 3-7
3.11 Viewing GeoRaster Objects.................................................................................................. 3-7
3.12 Exporting GeoRaster Objects............................................................................................... 3-8
3.13 Transferring GeoRaster Data Between Databases............................................................ 3-8
3.14 Dealing with Possible GeoRaster Data Problems........................................................... 3-10
4 SDO_GEOR Package Reference
SDO_GEOR.changeCellValue ............................................................................................. 4-2
SDO_GEOR.changeFormat.................................................................................................. 4-5
SDO_GEOR.changeFormatCopy ........................................................................................ 4-7
SDO_GEOR.copy................................................................................................................... 4-9
SDO_GEOR.createBlank..................................................................................................... 4-11
SDO_GEOR.deletePyramid ............................................................................................... 4-13
SDO_GEOR.exportTo ......................................................................................................... 4-14
SDO_GEOR.generatePyramid........................................................................................... 4-19
SDO_GEOR.generateSpatialExtent................................................................................... 4-21