Scribd
Upload
5 views1 page

PostgreSQL Raster Dataset Structure

This document describes the tables used to store raster dataset information in a PostgreSQL database using the ST_Raster storage. It lists the main tables including gdb_items, sde_table_registry, gdb_itemtypes, sde_raster_columns, sde_layers, sde_column_registry, sde_aux_31, sde_spatial_references, sde_geometry_columns, and sde_blk_31. These tables store metadata about raster datasets like footprint, band information, spatial references and block data.

Uploaded by

Sheikh Ubaid
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
5 views1 page

PostgreSQL Raster Dataset Structure

This document describes the tables used to store raster dataset information in a PostgreSQL database using the ST_Raster storage. It lists the main tables including gdb_items, sde_table_registry, gdb_itemtypes, sde_raster_columns, sde_layers, sde_column_registry, sde_aux_31, sde_spatial_references, sde_geometry_columns, and sde_blk_31. These tables store metadata about raster datasets like footprint, band information, spatial references and block data.

Uploaded by

Sheikh Ubaid
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

Raster dataset tables in PostgreSQL using ST_Raster storage

gdb_items
U3
U2
I4
I1
I3
I2

sde_table_registry

uuid
objectid
type
name
physicalname
path
url
properties
defaults
datasetsubtype1
datasetsubtype2
datasetinfo1
datasetinfo2
definition
documentation
iteminfo
shape

gdb_itemtypes
objectid
I3
I2
I1

sde_raster_columns

qa_ras_seattle2_xf

uuid
parenttypeid
name

U1
I1
U2

oid
footprint
raster

PK

registration_id

U1
U1
U1

database_name
owner
table_name
rowid_column
description
object_flags
registration_date
config_keyword
minimum_id
imv_view_name

sde_layers
PK
PK
PK
PK

database_name
table_name
owner
spatial_column

U1

layer_id
description
eflags
layer_mask
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_column_registry
PK
PK
PK
PK

f_table_catalog
f_table_schema
f_table_name
f_geometry_column

U1

rastercolumn_id
description
cdate
config_keyword
minimum_id
base_rastercolumn_id
rastercolumn_mask
srid

sde_aux_31
sde_spatial_references
PK

storage_type
geometry_type
coord_dimension
srid

database_name
owner
table_name
raster_column

sde_type
column_size
decimal_digits
description
object_flags
object_id

sde_geometry_columns
PK
PK
PK
PK

table_name
database_name
owner
column_name

PK
PK
PK
PK

rasterband_id
type
object

srid
description
auth_name
auth_srid
falsex
falsey
xyunits
falsez
zunits
falsem
munits
xycluster_tol
zcluster_tol
mcluster_tol
object_flags
srtext

sde_blk_31

U1
U1
U1
U1

rasterband_id
rrd_factor
row_nbr
col_nbr
block_data

You might also like