Scribd Logo
Upload

Welcome to Scribd!

  • 26 views

    O LR Raster Tables PDF

    Uploaded by

    mapache
    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    O LR Raster Tables PDF

    Uploaded by

    mapache
    26 views1 page
    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.

    Original Title

    O_LR_raster_tables.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    26 views1 page

    O LR Raster Tables PDF

    Uploaded by

    mapache
    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.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 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