Feature Class Tables in Postgresql Using Postgis Geometry Storage

Download as pdf or txt
Download as pdf or txt
You are on page 1of 1

Feature class tables in PostgreSQL using PostGIS geometry storage

<owner>.parcels gdb_items sde.sde_table_registry sde.sde_layers


U3 uuid PK registration_id PK database_name
PK table_name
objectid U2 objectid U1 database_name PK owner
I2 pid I4 type U1 owner PK spatial_column
owner I1 name U1 table_name
datesold I3 physicalname rowid_column U1 layer_id
taxrate I2 path description description
I1 shape url object_flags eflags
properties registration_date layer_mask
defaults config_keyword minx
datasetsubtype1 minimum_id miny
datasetsubtype2 imv_view_name maxx
datasetinfo1 maxy
datasetinfo2 minz
definition maxz
documentation minm
iteminfo sde.sde_column_registry maxm
shape cdate
PK table_name layer_config
PK database_name optimal_array_size
public.geometry_columns PK owner stats_date
PK column_name minimum_id
PK oid
srid
sde_type base_layer_id
f_table_catalog column_size secondary_srid
f_table_schema decimal_digits
f_table_name description
f_geometry_column object_flags
coord_dimension object_id
srid
type sde.sde_spatial_references
PK srid

sde.sde_geometry_columns description
auth_name
PK f_table_catalog auth_srid
PK f_table_schema falsex
PK f_table_name falsey
PK f_geometry_column xyunits
falsez
storage_type zunits
geometry_type falsem
coord_dimension munits
srid xycluster_tol
zcluster_tol
mcluster_tol
object_flags
srtext

You might also like