Scribd
Upload
15 views1 page

SQL Server Raster Dataset Overview

This document describes tables used for storing raster datasets in SQL Server using the ST_Raster storage type. It includes tables for raster bands, blocks, layers, columns, spatial references, table registry, and geometry columns. These tables provide information on the structure and metadata of raster datasets.

Uploaded by

arief_7
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
15 views1 page

SQL Server Raster Dataset Overview

This document describes tables used for storing raster datasets in SQL Server using the ST_Raster storage type. It includes tables for raster bands, blocks, layers, columns, spatial references, table registry, and geometry columns. These tables provide information on the structure and metadata of raster datasets.

Uploaded by

arief_7
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

world_TIF

OID
I1 FOOTPRINT
I2 RASTER
SDE_aux_2
PK rasterband_id
PK type
object
SDE_blk_2
PK rasterband_id
PK rrd_factor
PK row_nbr
PK col_nbr
block_data
SDE_layers
PK database_name
PK table_name
PK owner
PK spatial_column
U1 layer_id
description
eflags
layer_mask
gsize1
gsize2
gsize3
minx
miny
maxx
maxy
minz
maxz
minm
maxm
cdate
layer_config
optimal_array_size
stats_date
minimum_id
srid
base_layer_id
secondary_srid
SDE_raster_columns
PK database_name
PK owner
PK table_name
PK raster_column
U1 rastercolumn_id
description
cdate
config_keyword
minimum_id
base_rastercolumn_id
rastercolumn_mask
srid
SDE_column_registry
PK database_name
PK table_name
PK owner
PK column_name
sde_type
column_size
decimal_digits
description
object_flags
object_id
Raster dataset tables in SQL Server using ST_Raster storage
SDE_spatial_references
PK srid
description
auth_name
auth_srid
falsex
falsey
xyunits
falsez
zunits
falsem
munits
xycluster_tol
zcluster_tol
mcluster_tol
object_flags
srtext
SDE_table_registry
PK registration_id
U1 table_name
U1 database_name
U1 owner
rowid_column
description
object_flags
registration_date
config_keyword
minimum_id
imv_view_name
SDE_geometry_columns
PK f_table_catalog
PK f_table_schema
PK f_table_name
PK f_geometry_column
g_table_catalog
g_table_schema
g_table_name
storage_type
geometry_type
coord_dimension
max_ppr
srid
GDB_ITEMTYPES
U3 UUID
U2 ObjectID
I2 ParentTypeID
I1 Name
GDB_ITEMS
U3 UUID
U2 Objectid
I4 Type
I1 Name
I3 PhysicalName
I2 Path
Url
Properties
Defaults
DatasetSubtype1
DatasetSubtype2
DatasetInfo1
DatasetInfo2
Definition
Documentation
ItemInfo
Shape

You might also like