Scribd
Upload
48 views1 page

O LR Raster Tables PDF

This document describes the tables used to store raster datasets in binary format in an Oracle database, including tables for raster bands, blocks, auxiliary information, ownership and layer details, raster columns, spatial references, geometry columns, and a table registry. Primary and foreign keys are specified to link the tables together and store information about each raster dataset like footprint, bands, blocks, and spatial references. The tables provide a relational database schema for efficiently storing and querying raster geospatial data in Oracle.

Uploaded by

mapache
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
48 views1 page

O LR Raster Tables PDF

This document describes the tables used to store raster datasets in binary format in an Oracle database, including tables for raster bands, blocks, auxiliary information, ownership and layer details, raster columns, spatial references, geometry columns, and a table registry. Primary and foreign keys are specified to link the tables together and store information about each raster dataset like footprint, bands, blocks, and spatial references. The tables provide a relational database schema for efficiently storing and querying raster geospatial data in Oracle.

Uploaded by

mapache
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Raster dataset tables in Oracle in binary storage

WORLD_TIF SDE_BLK_2 SDE_AUX_2 SDE_RAS_2 LAYERS


OID PK RASTERBAND_ID PK RASTERBAND_ID PK RASTER_ID PK OWNER
PK RRD_FACTOR PK TYPE PK TABLE_NAME
I1 FOOTPRINT PK ROW_NBR RASTERFLAGS PK SPATIAL_COLUMN
I2 RASTER PK COL_NBR OBJECT DESRIPTION
LAYER_ID
BLOCK_DATA DESCRIPTION
DATABASE_NAME
SDE_BND_2 EFLAGS
F117 GDB_ITEMTYPES LAYER_MASK
PK RATERBAND_ID
OBJECTID GSIZE1
PK FID GSIZE2
U1 SEQUENCE_NBR
I3 UUID GSIZE3
NUMOFPTS U1 RASTER_ID
I2 PARENTTYPEID MINX
ENTITY NAME
I1 NAME MINY
EMINX BAND_FLAGS
MAXX
EMINY BAND_WIDTH
MAXY
EMAXX AND_HEIGHT
GDB_ITEMS CDATE
EMAXY BAND_TYPES
LAYER_CONFIG
EMINZ BLOCK_WIDTH
U3 UUID OPTIMAL_ARRAY_SIZE
EMAXZ BLOCK_HEIGHT
STATS_DATE
MIN_MEASURE BLOCK_ORIGIN_X
U2 OBJECTID MINIMUM_ID
MAX_MEASURE BLOCK_ORIGIN_Y
I4 TYPE SRID
I1 AREA EMINX
I1 NAME BASE_LAYER_ID
I2 LEN EMINY
I3 PHYSICALNAME MINZ
POINTS EMAXX
I2 PATH MINM
EMAXY
URL MAXZ
CDATE
PROPERTIES MAXM
MDATE
DEFAULTS SECONDARY_SRID
S117
DATASETSUBTYPE1
PK,I1 SP_FID DATASETSUBTYPE2
PK GX DATASETINFO1 SPATIAL_REFERENCES
PK GY DATASETINFO2
PK EMINX DEFINITION PK SRID
PK EMINY DOCUMENTATION
PK EMAXX ITEMINFO DESCRIPTION
PK EMAXY SHAPE AUTH_NAME
AUTH_SRID
FALSEX
RASTER_COLUMNS FALSEY
XYUNITS
PK OWNER FALSEZ
PK TABLE_NAME ZUNITS
PK RASTER_COLUMN FALSEM
COLUMN_REGISTRY
MUNITS
U1 RASTERCOLUMN_ID XYCLUSTER_TOL
PK COLUMN_NAME
DESCRIPTION ZCLUSTER_TOL
PK OWNER
DATABASE_NAME MCLUSTER_TOL
PK TABLE_NAME
CDATE OBJECT_FLAGS
CONFIG_KEYWORD SRTEXT
DATABASE_NAME
MINIMUM_ID
SDE_TYPE
BASE_RASTERCOLUMN_ID
COLUMN_SIZE
RASTERCOLUMN_MASK
DECIMAL_DIGITS
SRID GEOMETRY_COLUMNS
DESCRIPTION
OBJECT_FLAGS PK F_TABLE_SCHEMA
OBJECT_ID PK F_TABLE_NAME
PK F_GEOMETRY_COLUMN
TABLE_REGISTRY
PK REGISTRATION_ID F_TABLE_CATALOG
G_TABLE_CATALOG
OWNER G_TABLE_SCHEMA
TABLE_NAME G_TABLE_NAME
ROWID_COLUMN STORAGE_TYPE
DESCRIPTION GEOMETRY_TYPE
OBJECT_FLAGS COORD_DIMENSION
REGISTRATION_DATE MAX_PPR
CONFIG_KEYWORD SRID
MINIMUM_ID
IMV_VIEW_NAME

You might also like