NOTE: The system tables should not be altered using anything other than ArcGIS software.
Field Name |
Field type |
Description |
id |
integer |
Unique identifier of the domain.
Primary key.
NOT NULL. |
owner |
varchar(32) |
User who created the attribute domain.
NOT NULL. |
domainname |
varchar(160) |
Name assigned to the attribute domain in the geodatabase.
Unique.
NOT NULL. |
description |
varchar(255) |
Optional text describing the attribute domain. |
domaintype |
integer |
Code indicating whether this is a range (1) or coded-value (2) domain.
NOT NULL. |
fieldtype |
integer |
Code indicating what type of field the domain applies to:
0 = Short integer
1 = Long integer
2 = Float
3 = Double
4 = Text
5 = Date
NOT NULL. |
mergepolicy |
integer |
Code indicating the policy to use to assign to the resultant feature when two features are merged:
1 = sum values—The attribute of the feature that results from a merge will be the sum of the values of the two original (premerge) features.
2 = geometry weighted—The attribute of the feature that results from a merge is the weighted average of the values of the attributes of the original (premerge) features. The average is based on the original features' geometry.
3 = default value—The attribute of the feature created as a result of the merge will be the same as the default value of the feature class or subtype. (Note: This is the only merge policy value available for nonnumeric fields and coded value domains.)
NOT NULL. |
splitpolicy |
integer |
Code indicating the policy to be used for assigning attributes to the features that result from splitting one feature:
1 = geometry ratio—The attributes of the features resulting from the split are a ratio of the original feature's (presplit) value. The ratio is based on the ratio in which the geometry is divided by the split.
2 = duplicate—The attributes of the features resulting from the split are the same as the original object's (presplit) attribute value.
3 = default value—The attributes of features resulting from the split take on the default value for the attribute as defined in the feature class or subtype.
NOT NULL. |
Field Name |
Field type |
Description |
objectclassid |
integer |
Foreign key to the id field in the gdb_objectclasses table
Unique
NOT NULL |
featuretype |
integer |
Code representing the type of feature
1 = point, multipoint, line, polygon, or multipatch
7 = junctions
8 = simple edges
10 = complex edges
11 = annotation
13 = dimension
14 = raster
NOT NULL |
geometrytype |
integer |
Code representing the type of geometry of the feature class
1 = point
2 = multipoint
3 = line
4 = polygon (including annotation and dimension)
9 = multipatch
NOT NULL |
shapefield |
varchar(32) |
Name of the shape field in the feature class
NOT NULL |
geomnetworkid |
integer |
Foreign key to id field in the gdb_geomnetworks table |
graphid |
integer |
Foreign key to id field in gdb_networks table |
Field Name |
Field type |
Description |
classid |
integer |
Foreign key to the id field in the gdb_objectclasses table
NOT NULL |
fieldname |
varchar(160) |
Name of the field in the table
NOT NULL |
aliasname |
varchar(160) |
Alternative name assigned to the field (Aliases can be altered after field creation; the field name cannot.) |
modelname |
varchar(160) |
Alternative name assigned to the fields used to identify a type of field without requiring a hard-coded name |
defaultdomainname |
varchar(160) |
Name of the domain associated with the field |
defaultvaluestring |
varchar(160) |
If the field is type text, the default value assigned to it |
defaultvaluenumber |
numeric |
If the field is a numeric type, the default value assigned to it |
isrequired |
integer |
0 (not a required field) or 1 (a required field)
NOT NULL |
issubtypefixed |
integer |
Denotes whether subtype is set for the field
0 = yes
1 = no
NOT NULL |
iseditable |
integer |
0 (not editable) or 1 (editable)
NOT NULL |
Field Name |
Field type |
Description |
ruleid |
integer |
The unique identifier for a rule in a geodatabase and the foreign key to the id field in the gdb_validrules table
Primary key
NOT NULL |
edgeclassid |
integer |
The object class ID of the edge feature class and the foreign key to the id field in the gdb_geomnetworks table
NOT NULL |
edgesubtype |
integer |
The subtype of the edge feature class
NOT NULL |
edgemincard |
integer |
The minimum edge cardinality (the minimum number of edges to which a junction can connect)
NOT NULL |
edgemaxcard |
integer |
The maximum edge cardinality (the maximum number of edges to which a junction can connect)
NOT NULL |
junctionclassid |
integer |
The object class ID of the junction feature class and the foreign key to the id field in the gdb_geomnetworks table
NOT NULL |
junctionsubtype |
integer |
The subtype of the junction feature class
NOT NULL |
junctionmincard |
integer |
The minimum junction cardinality (the minimum number of junctions to which an edge can connect)
NOT NULL |
junctionmaxcard |
integer |
The maximum junction cardinality (the maximum number of junctions to which an edge can connect)
NOT NULL |
isdefault |
integer |
Contains a value of 0 or 1 indicating if a junction is a default junction and has been created automatically |
Field Name |
Field type |
Description |
oid |
integer |
The unique identifier of a weight in a geodatabase
Primary key
NOT NULL |
networkid |
integer |
The unique identifier for the geometric network in a geodatabase and the foreign key to the ID fields in the gdb_geomnetworks, gdb_networks, and gdb_extensiondatasets tables
Unique
NOT NULL |
name |
varchar(160) |
The name of the weight, which must be unique in each network
NOT NULL |
weightid |
integer |
The unique identifier of the weight in the geometric network
Unique
NOT NULL |
weighttype |
integer |
A value indicating the type of network weight
NOT NULL |
bitgatesize |
integer |
A value from 0 to 31 indicating the size of the bitgate weight
(Nonbitgate weights have a value of 0.) |
elementtypes |
integer |
Denotes the type of network weight |
Field Name |
Field type |
Description |
id |
integer |
The unique identifier of the logical network in a geodatabase.
Primary key.
NOT NULL. |
databasename |
varchar(32) |
Database in which the network is stored.
NOT NULL. |
owner |
varchar(32) |
The name of the user who created the network.
NOT NULL. |
name |
varchar(160) |
The name of the network.
NOT NULL. |
networktype |
integer |
A value indicating the type of network.
All networks created using ArcGIS Desktop will have a value of 1=esriNTUtilityNetwork.
NOT NULL. |
indextype |
integer |
Not currently implemented.
NOT NULL. |
normalized |
integer |
A value of either 0 or 2, which indicates whether the network is narrow or wide.
Narrow networks contain feature classes with object IDs less than 10,000; wide networks can contain feature classes with object IDs greater than 10,000.
NOT NULL. |
Field name |
Field type |
Description |
id |
integer |
Unique identifier for the object class
Primary key
NOT NULL |
databasename |
varchar(32) |
Name of the database in which the object is stored
NOT NULL |
owner |
varchar(32) |
User who owns the object class
NOT NULL |
name |
varchar(160) |
Name of the object class
NOT NULL |
aliasname |
varchar(160) |
Alternative name of the object class |
modelname |
varchar(160) |
Alternative name of the object class; used to identify the type of entity without requiring a hard-coded name |
clsid |
varchar(38) |
GUID that uniquely identifies the type of object class
NOT NULL |
extclsid |
varchar(38) |
GUID that uniquely identifies the extension of an object class |
extpropes |
bytea |
Stores the properties of the associated class extension |
subtypefield |
varchar(32) |
Name of the field in the object class for defining subtypes |
datasetid |
integer |
Foreign key to the id field in the gdb_featuredataset table |
Field name |
Field type |
Description |
id |
integer |
Unique identifier of the relationship class.
Primary key.
NOT NULL. |
databasename |
varchar(32) |
Name of the database in which the relationship class resides.
NOT NULL. |
owner |
varchar(32) |
User who owns the relationship class.
NOT NULL. |
name |
varchar(160) |
Name of the relationship class.
NOT NULL. |
originclassid |
integer |
Identifier of the origin object class.
NOT NULL. |
destclassid |
integer |
Identifier of the destination object class.
NOT NULL. |
forwardlabel |
varchar(255) |
Label that describes the relationship when navigating from origin class to destination class. |
backwardlabel |
varchar(255) |
Label that describes the relationship when navigating from destination class to origin class. |
cardinality |
integer |
Code representing the type of cardinality of the relationship class:
1 = one to one.
2 = one to many.
3 = many to many.
NOT NULL. |
notification |
integer |
Code indicating the notification direction:
1 = none (no messages propagated).
2 = forward (origin to destination).
3 = backward.
4 = both (forward and backward. notification).
NOT NULL. |
iscomposite |
integer |
If a relationship class is composite, destination objects cannot exist independently of their related origin objects.
Possible values are
0 (is simple, not composite) or 1 (is composite).
NOT NULL. |
isattributed |
integer |
Indicates whether or not this is an attributed relationship.
NOT NULL. |
originprimarykey |
varchar(32) |
The name of the primary key field of the origin object class.
NOT NULL. |
destprimarykey |
varchar(32) |
The name of the primary key field in the destination object class.
NOT NULL. |
originforeignkey |
varchar(32) |
The name of the foreign key field of the origin object class.
NOT NULL. |
destforeignkey |
varchar(32) |
The name of the foreign key field in the destination object class.
NOT NULL. |
datasetid |
integer |
Foreign key to the gdb_featuredataset table. |
Field name |
Field type |
Description |
id |
integer |
Unique identifier for row.
NOT NULL. |
replicaid |
integer |
Foreign key to the id field in the gdb_replicas table.
NOT NULL. |
event |
integer |
Indicates if an import (1) or an export (2) has been logged.
NOT NULL. |
errorcode |
integer |
The error code associated with the event; you can search the developer help to get the description associated with the error. If the event was successful, a success error code is returned.
NOT NULL. |
logdate |
time stamp without time zone |
The date on which the event occurred.
NOT NULL. |
sourcebegingen |
integer |
Several generations of data changes may be imported or exported in one event. This value indicates the generation number of the first generation of changes involved. For example, if generations 1 to 3 were imported, this field would have the value 1.
NOT NULL. |
sourceendgen |
integer |
Several generations of data changes may be imported or exported in one event. This value indicates the generation number of the last generation of changes involved. For example, if generations 1 to 3 were imported, this field would have the value 3.
NOT NULL. |
targetgen |
integer |
The generation to which changes are to be applied; this value is used to apply changes to the appropriate version in the target replica.
NOT NULL. |
Field name |
Field type |
Description |
id |
integer |
Unique identifier for the replica (child) version
Primary key
NOT NULL |
name |
varchar(32) |
Name of the replica (child) version of the geodatabase
NOT NULL |
owner |
varchar(32) |
User who owns the replica (child) version of the geodatabase
NOT NULL |
version |
varchar(64) |
Name of the replica version in the parent geodatabase
NOT NULL |
parentid |
integer |
ID of the replica in the parent geodatabase
NOT NULL |
repdate |
time stamp without time zone |
Date and time the replica was created
NOT NULL |
defquery |
bytea |
Contains the replica description, which describes datasets and filters that define the replica
NOT NULL |
repguid |
varchar(36) |
The GUID value that uniquely identifies the replica across geodatabases
NOT NULL |
repcinfo |
varchar(1800) |
The connection information for the relative replicas geodatabase |
role |
integer |
Indicates if a replica has the role of parent or child
NOT NULL |
Field name |
Field type |
Description |
ruleid |
integer |
Unique identifier of the topology rule; foreign key to the id field in the gdb_validrules table
Primary key
NOT NULL |
originclassid |
integer |
Foreign key to classid field in gdb_topoclasses table
NOT NULL |
originsubtype |
integer |
Foreign key to subtypecode field in gdb_subtypes table
NOT NULL |
alloriginsubtypes |
integer |
Indicates if rule applies to all subtypes in the origin feature class
NOT NULL |
destclassid |
integer |
Foreign key to classid field in gdb_topoclasses table
NOT NULL |
destsubtype |
integer |
Foreign key to subtypecode field in gdb_subtypes table
NOT NULL |
alldestsubtypes |
integer |
Indicates if rule applies to all subtypes in the destination feature class
NOT NULL |
topologyruletype |
integer |
The type of topology rule
NOT NULL |
name |
varchar(160) |
User-defined name associated with the topology rule |
ruleguid |
varchar(38) |
GUID that uniquely identifies the topology rule
Unique
NOT NULL |
NOTE: If you alter column definitions using a SQL interface, the records in the sde_column_registry table are not updated. This may cause any subsequent exports of the data to fail.
Field name |
Field type |
Description |
database_name |
varchar(32) |
Name of the database in which the table containing the column resides
NOT NULL |
table_name |
varchar(128) |
Name of the table that contains the registered column
NOT NULL |
owner |
varchar(32) |
Owner of the table in which the column resides (the user who created the table)
NOT NULL |
column_name |
varchar(32) |
Name of the registered column
NOT NULL |
sde_type |
integer |
Code for the column's data type; possible values and their definitions include the following:
1 = SE_INT16_TYPE—2-byte integer
2 = SE_INT32_TYPE —4-byte integer
3 = SE_FLOAT32_TYPE—4-byte float
4 = SE_FLOAT64_TYPE—8-byte float
5 = SE_STRING_TYPE—Null term character array
6 = SE_BLOB_TYPE—Variable length data
7 = SE_DATE_TYPE—Time stamp date
8 = SE_SHAPE_TYPE—Shape geometry (SE_SHAPE)
9 = SE_RASTER_TYPE—Raster
10 = SE_XML_TYPE—XML document
11 = SE_INT64_TYPE—8-byte integer
12 = SE_UUID_TYPE—A universal unique ID
13 = SE_CLOB_TYPE—Character variable length data
14 = SE_NSTRING_TYPE—Unicode null term character array
15 = SE_NCLOB_TYPE—Unicode character large object
20 = SE_POINT_TYPE—Point UDT
21 = SE_CURVE_TYPE—LineString UDT
22 = SE_LINESTRING_TYPE—LineString UDT
23 = SE_SURFACE_TYPE—Polygon UDT
24 = SE_POLYGON_TYPE—Polygon UDT
25 = SE_GEOMETRYCOLLECTION_TYPE 25—MultiPoint UDT
26 = SE_MULTISURFACE_TYPE—LineString UDT
27 = SE_MULTICURVE_TYPE—LineString UDT
28 = SE_MULTIPOINT_TYPE—MultiPoint UDT
29 = SE_MULTILINESTRING_TYPE—MultiLineString UDT
30 = SE_MULTIPOLYGON_TYPE—MultiPolygon UDT
31 = SE_GEOMETRY_TYPE—Geometry UDT
NOT NULL |
column_size |
integer |
The registered column value's length |
decimal_digits |
integer |
Number of integers to the right of the decimal in the column value |
description |
varchar(65) |
A description of the type of column
|
object_flags |
integer |
Stores the column properties; properties include the following:
- Column has a row ID.
- SDE controls the row ID column.
- Column allows NULLS.
- Column stores ST_GEOMETRY geometry data.
- Column stores binary geometry data.
- Column stores UDT geometry data.
- Column stores binary raster data.
- Column stores UDT raster data.
- Column stores XML data.
- Column stores dates.
- Column stores time.
- Column stores a time stamp.
- Column stores a Unicode string.
NOT NULL |
object_id |
integer |
This value is set to the RASTERCOLUMN_ID of the RASTER_COLUMNS table if the column is a raster column or the LAYER_ID of the LAYERS table if this column is a geometry column.
|
NOTE: This table is not present if the geodatabase has never been compressed.
Field name |
Field type |
Description |
compress_id |
integer |
Unique identifier of a compress operation
NOT NULL |
sde_id |
integer |
Process identification number of the compress operation; references sde_id column in sde_process_information table
NOT NULL |
server_id |
integer |
System process_id of the ArcSDE server process that performed or is performing the compress operation
NOT NULL |
direct_connect |
varchar(1) |
Y (yes) or N (no) if the client is making a direct connection to the geodatabase
NOT NULL |
compress_start |
TIME STAMP |
The date and time the compress operation was begun
NOT NULL |
start_state_count |
integer |
The number of states present when compress began
NOT NULL |
compress_end |
TIME STAMP |
The date and time the compress operation completed
NOT NULL |
end_state_count |
integer |
The number of remaining states after the compress operation
NOT NULL |
compress_status |
varchar(20) |
Indicates whether or not the compress operation was successfully completed
NOT NULL |
Field name |
Field type |
Description |
f_table_catalog |
varchar(32) |
The database in which the feature table is stored
NOT NULL |
f_table_schema |
varchar(32) |
Schema in which the business table is stored
NOT NULL |
f_table_name |
varchar(160) |
Name of the business table of the dataset
NOT NULL |
f_geometry_column |
varchar(32) |
Name of the geometry column in the business table
NOT NULL |
storage_type |
integer |
Code for the storage type of the geometry; could represent either WKB, WKT, or BINARY |
geometry_type |
integer |
Code for the geometry type that the column stores; could represent either point, multipoint, linestring, multilinestring, polygon, or multipolygon |
coord_dimension |
integer |
Code for the coordinate dimension includes the following:
0 = point
1 = linear
2 = area |
max_ppr |
integer |
Maximum points per row (no longer used by ArcSDE)
|
srid |
integer |
Spatial reference ID
Foreign key to SRID in sde_spatial_references table
NOT NULL |
Field name |
Field type |
Description |
sde_id |
integer |
Process identification number of the process that has locked the layer; foreign key to the sde_id column in sde_process_information table
NOT NULL |
layer_id |
integer |
Foreign key to layer_id field in sde_layers table
NOT NULL |
autolock |
character(1) |
Set to 1 if the layer lock was set internally; otherwise, it is set to 0 if the layer lock was set by the application.
NOT NULL |
lock_type |
character(1) |
The type of layer lock can be one of the following:
0 = A read lock on the entire layer
1 = A write lock on the entire layer
2 = A read lock on an area within the layer
3 = A write lock on an area within the layer
4 = A layer autolock
NOT NULL |
minx |
bigint |
The minimum x-coordinate of the bounding box used to define the features within an area locked during an area lock |
miny |
bigint |
The minimum y-coordinate of the bounding box used to define the features within an area locked during an area lock |
maxx |
bigint |
The maximum x-coordinate of the bounding box used to define the features within an area locked during an area lock |
maxy |
bigint |
The maximum y-coordinate of the bounding box used to define the features within an area locked during an area lock |
Field name |
Field type |
Description |
layer_id |
integer |
Unique identifier for the layer
Unique
NOT NULL |
description |
varchar(65) |
The optional layer description
|
database_name |
varchar(32) |
Name of the database in which the layer is stored
NOT NULL |
owner |
varchar(30) |
The user who created the layer
NOT NULL |
table_name |
varchar(128) |
Name of the business table of the layer
NOT NULL |
spatial_column |
varchar(128) |
Name of the spatial column in the layer
NOT NULL |
eflags |
integer |
Stores the following layer properties:
- Layer stores single-precision or double-precision coordinates.
- Layer stores 3D coordinates.
- Layer stores measures.
- Layer has autolocking enabled or disabled.
- Layer is in load only I/O mode or normal I/O mode.
- Layer stores annotation.
- Layer stores CAD data.
- Layer is a view of another layer.
- Layer does not have a spatial index.
- The DBMS data type in which the layer data is stored.
- The SDE types that the layer can accept, which can be such types as points, linestrings, and polygons.
NOT NULL |
layer_mask |
integer |
Stores additional internal properties about the layer
NOT NULL |
minx |
double precision |
Minimum x-coordinate value of the layer
NOT NULL |
miny |
double precision |
Minimum y-coordinate value of the layer
NOT NULL |
maxx |
double precision |
Maximum x-coordinate value of the layer
NOT NULL |
maxy |
double precision |
Maximum y-coordinate value of the layer
NOT NULL |
minz |
double precision |
Minimum z-coordinate value of the layer |
maxz |
double precision |
Maximum z-coordinate value of the layer |
minm |
double precision |
Minimum measure value of the layer |
maxm |
double precision |
Maximum measure value of the layer |
cdate |
integer |
The layer creation date
NOT NULL |
layer_config |
varchar(32) |
Configuration keyword with which the layer was created |
optimal_array_size |
integer |
Geometry array buffer size |
stats_date |
integer |
When statistics were last calculated for a layer |
minimum_id |
integer |
The minimum feature ID value of a binary layer |
srid |
integer |
Spatial reference identification number; foreign key to srid value in the sde_spatial_references table
NOT NULL |
secondary_srid |
integer |
Foreign key to srid field in sde_spatial_references table |
base_layer_id |
integer |
Stores the base layer's layer_id value for a layer that is actually a view
NOT NULL |
gsize1 |
double precision |
Size of first spatial grid
NOT NULL |
gsize2 |
double precision |
Size of second spatial grid
NOT NULL |
gsize3 |
double precision |
Size of third spatial grid
NOT NULL |
Field name |
Field type |
Description |
record_id |
integer |
Unique identifier for the record
Primary key
NOT NULL |
object_database |
varchar(32) |
The name of the database in which the locator is stored |
object_name |
varchar(160) |
The name of the locator to which the property belongs and foreign key to the name column in the sde_locators table
NOT NULL |
object_owner |
varchar(32) |
The name of the user who owns the record
NOT NULL |
object_type |
integer |
Always a value of 2 for locator properties
NOT NULL |
class_name |
varchar(32) |
Always a value of sde_internal for locator properties |
property |
varchar(32) |
The name of the locator property |
prop_value |
varchar(255) |
The value of the locator property |
description |
varchar(65) |
Not used for locator properties |
creation_date |
time stamp without time zone |
Date and time the locator property was created
NOT NULL |
Field name |
Field type |
Description |
sde_id |
integer |
Process identification number of the process that locked the geodatabase object; references sde_id column in sde_process_information table
NOT NULL |
object_id |
integer |
ID from the object_classes table of the affected dataset
NOT NULL |
object_type |
integer |
Object lock type; for example, version, state_tree lock used by internal applications
NOT NULL |
application_id |
integer |
Application unique identifier
NOT NULL |
autolock |
CHARACTER(1) |
Set to 1 if the layer lock was set internally; otherwise, set to 0 if the layer lock was set by the application
NOT NULL |
lock_type |
CHARACTER(1) |
The type of object lock, which includes
"S" for shared
"E" for exclusive
With the sde_id, object_id, object_type, application_id, and autolock fields, makes up the primary key
NOT NULL |
Field name |
Field type |
Description |
sde_id |
integer |
Process identification number
Primary key
NOT NULL |
spid |
integer |
The gsrvr process ID
Unique
NOT NULL |
server_id |
integer |
The operating system process ID of the server process
NOT NULL |
start_time |
timestamp without time zone |
Date and time process was started
NOT NULL |
rcount |
integer |
The number of reads that have been processed
NOT NULL |
wcount |
integer |
The number of writes that have been processed
NOT NULL |
opcount |
integer |
Total number of operations a process has executed
NOT NULL |
numlocks |
integer |
The number of locks that the process currently has open
NOT NULL |
fb_partial |
integer |
Total number of partial features shipped by the process
NOT NULL |
fb_count |
integer |
Total number of buffers loaded by the process
NOT NULL |
fb_fcount |
integer |
Total number of features buffered by the process
NOT NULL |
fb_kbytes |
integer |
Total number of kilobytes buffered by the process
NOT NULL |
owner |
varchar(30) |
The name of the connected user
NOT NULL |
direct_connect |
varchar(1) |
Indicates whether process was made with a direct connection: t (true) or f (false)
NOT NULL |
sysname |
varchar(32) |
The operating system that the client machine is running
NOT NULL |
nodename |
varchar(255) |
The connected client machine name
NOT NULL |
xdr_needed |
varchar(1) |
Records whether or not client is using XDR to communicate with the gsrvr: t (true) or f (false)
NOT NULL |
Field name |
Field type |
Description |
rastercolumn_id |
integer |
Unique identifier of a raster column
Unique
NOT NULL |
description |
varchar(65) |
The description of the raster table |
database_name |
varchar(32) |
Name of the database in which the raster is stored
NOT NULL |
owner |
varchar(32) |
The owner of the raster column's business table
NOT NULL |
table_name |
varchar(128) |
The business table name
NOT NULL |
raster_column |
varchar(128) |
The raster column name
NOT NULL |
cdate |
integer |
The date the raster column was added to the business table
NOT NULL |
config_keyword |
varchar(32) |
The DBTUNE configuration keyword whose storage parameters determine how the tables and indexes of the raster are stored in the database |
minimum_id |
integer |
Defined during the creation of the raster; establishes value of the raster table's raster_id column |
base_rastercolumn_id |
integer |
When the raster column is part of a view and not a table, this value is the rastercolumn_id of the base table of the view.
NOT NULL |
rastercolumn_mask |
integer |
Set to 256 for a geodatabase raster
NOT NULL |
srid |
integer |
Spatial reference identifier number; foreign key to the srid field in the sde_spatial_references table |
Field name |
Field type |
Description |
srid |
integer |
Spatial reference ID
Primary key
NOT NULL |
description |
varchar(64) |
The text description of the spatial reference system |
auth_name |
varchar(255) |
The name of the standard or standards body that is being cited for this reference system |
falsex |
double precision |
Offset applied to x-coordinate value
NOT NULL |
falsey |
double precision |
Offset applied to y-coordinate values
NOT NULL |
xyunits |
double precision |
Scale factor applied to x- and y-coordinates after applying offset
NOT NULL |
falsez |
double precision |
Offset applied to z-coordinate values
NOT NULL |
zunits |
double precision |
Scale factor applied to z-coordinate value after applying offset
NOT NULL |
falsem |
double precision |
Offset applied to measures
NOT NULL |
munits |
double precision |
Scale factor applied to measures after applying offset
NOT NULL |
xycluster_tol |
double precision |
X,y coordinate cluster tolerance for topological processing |
zcluster_tol |
double precision |
Z-coordinate cluster tolerance for topological processing |
mcluster_tol |
double precision |
Measure cluster tolerance for topological processing |
object_flags |
integer |
Stores object attributes, including precision
NOT NULL |
srtext |
varchar(1024) |
Descriptor for the spatial reference as seen in the ArcGIS interface
NOT NULL |
srname |
varchar(128) |
Name of the spatial reference system, for example, GCS_WGS_84 or GCS_ASSUMED_GEOGRAPHIC_1 |
min_x |
double precision |
Minimum possible x-value for coordinates
NOT NULL |
min_y |
double precision |
Minimum possible y-value for coordinates |
min_z |
double precision |
Minimum possible z-value for coordinates |
min_m |
double precision |
Minimum possible m-value for measures |
max_x |
double precision |
Maximum possible x-value for coordinates
NOT NULL |
max_y |
double precision |
Maximum possible y-value for coordinates
NOT NULL |
max_z |
double precision |
Maximum possible z-value for coordinates
NOT NULL |
max_m |
double precision |
Maximum possible m-value for measures
NOT NULL |
cs_id |
integer |
Coordinate system ID |
cs_name |
varchar(128) |
Name of the coordinate system for this spatial reference system
NOT NULL |
cs_type |
varchar(128) |
Type of coordinate system—PROJECTED, GEOGRAPHIC, or UNSPECIFIED
NOT NULL |
organization |
varchar(128) |
Name of the organization that defined the coordinate system |
org_coordsys_id |
integer |
Coordinate system ID defined by the organization |
Field name |
Field type |
Description |
registration_id |
integer |
Unique identifier for the registration of the table
Primary key
NOT NULL |
database_name |
varchar(32) |
Name of the database in which the table is stored
NOT NULL |
schema_name |
varchar(32) |
Name of the schema in which the table is stored |
owner |
varchar(32) |
User who created the table
NOT NULL |
table_name |
varchar(128) |
Name of the table
NOT NULL |
rowid_column |
varchar(32) |
Name of the ObjectID column in the table |
description |
varchar(65) |
The text description of the table
|
object_flags |
integer |
Stores the registration properties of the table, which include the following:
- The table has a registered row ID.
- SDE controls the row ID.
- The table has a geometry column.
- The table is a multiversioned view.
- The table can be row locked.
- The table has a raster column.
- The table is a view of another table.
- The table has a geocoding locator column.
- Data definition language operations are restricted.
- Data manipulation language operations are restricted.
- The table is hidden.
- The table has single row IDs.
- The table has an XML column.
- The table has a layer that stores double coordinates.
- The interior states of this versioned table can be edited.
- This is a base save table.
- This table has trusted shapes.
- This is an archiving table.
- This table is in load-only I/O mode.
- This is a history table.
NOT NULL |
registration_date |
integer |
The date the table was registered
NOT NULL |
config_keyword |
varchar(32) |
Configuration keyword with which the table was created |
minimum_id |
integer |
The minimum row_id value of the table |
imv_view_name |
varchar(32) |
The name of a multiversioned view of the given table |
Field name |
Field type |
Description |
major |
integer |
Number of the major release; for example, for ArcSDE 9.3, the major release number would be 9.
Primary key.
NOT NULL. |
minor |
integer |
Number indicating the version of the minor release; for example, for ArcSDE 9.3, the minor release number would be 3.
NOT NULL. |
bugfix |
integer |
Number of the patch or service pack installed.
NOT NULL. |
description |
varchar(96) |
Description of the ArcSDE installation.
NOT NULL. |
release |
integer |
Complete release number; for example, 92009.
NOT NULL. |
sdesvr_rel_low |
integer |
Indicates the lowest release number of server allowed to run on this instance.
NOT NULL. |
Field name |
Field type |
Description |
name |
varchar(64) |
The unique name of the version
NOT NULL |
owner |
varchar(32) |
The version owner
NOT NULL |
version_id |
integer |
The unique identifier of the version
Primary key
NOT NULL |
status |
integer |
Specifies whether the version is available to the public or if it is privately accessed by the owner
NOT NULL |
state_id |
bigint |
The ID of the database state to which this version points
NOT NULL |
description |
varchar(65) |
An optional text description of the version |
parent_name |
varchar(64) |
The name of this version's parent version |
parent_owner |
varchar(32) |
The name of the owner of the parent version |
parent_version_id |
integer |
The ID of the version which is the parent of this version |
creation_time |
time stamp without time zone |
The date/time that this version was created
NOT NULL |
Field name |
Field type |
Description |
column_id |
integer |
The XML column's identifier; this value is assigned by ArcSDE at the time the XML column is created.
Primary key.
NOT NULL. |
registration_id |
integer |
The identifier of the business table containing the XML column; a foreign key to the id column in the sde_table_registry table.
NOT NULL. |
column_name |
varchar(32) |
Name of the XML column in the business table.
NOT NULL. |
index_id |
integer |
The identifier of the XPath index associated with the XML column, if one exists; a foreign key to the XML indexes table. |
minimum_id |
integer |
The value of the initial number used in the business table's XML column to identify individual XML documents. |
config_keyword |
varchar(32) |
The DBTUNE configuration keyword containing parameters that determine how the XML document and the XML XPath index tables and the text indexes created on those tables are defined in the database. |
xflags |
integer |
A value indicating whether the original documents in the XML document table are stored compressed or uncompressed; by default, documents are compressed. (Compressed documents provide better performance.) |
Field name |
Field type |
Description |
index_id |
integer |
The identifier of the XPath index associated with an XML column, if one exists; foreign key to the index_id column in the sde_xml_indexes table.
NOT NULL. |
tag_id |
integer |
The identifier of an XPath, or tag.
NOT NULL. |
tag_name |
varchar(1024) |
An absolute XPath identifying an XML element or attribute that may occur in an XML document.
For example,
/metadata/mdDateSt identifies an XML element, and /metadata/dataIdInfo/tpCat/TopicCatCd/@value identifies an XML attribute. These XPaths must not contain asterisks (*) to refer to a group of XML elements or attributes—each element or attribute is matched exactly using the XPaths specified in this table.
NOT NULL. |
data_type |
integer |
A value indicating whether the XML element or attribute will be indexed as a string or a number.
1 = The content of the tag will be indexed as text.
2 = The content will be indexed as a number.
NOT NULL. |
tag_alias |
integer |
A number that may be used to identify an XPath.
For example, the Z39.50 communication protocol uses numeric codes to refer to content that may be searched. This column is not used by the ArcIMS Z39.50 Connector. |
description |
varchar(64) |
Text identifying the content that should be contained in the XML element or attribute. |
is_excluded |
integer |
A value indicating whether the XML element is included in or excluded from the XPath index.
0 = included.
1 = excluded.
NOT NULL. |
Field name |
Field type |
Description |
index_id |
integer |
The identifier of the XPath index.
Primary key.
NOT NULL. |
index_name |
varchar(32) |
The name of the XPath index.
For XPath indexes associated with an ArcIMS metadata service, the name will be "ims_xml#", where # is the identifier of the XML column in the metadata service's business table.
NOT NULL. |
owner |
varchar(32) |
The database user who owns the XML column.
For ArcIMS metadata services, this is the user specified in the service's ArcXML configuration file.
NOT NULL. |
index_type |
integer |
A value indicating the type of XPath index.
1 = index type SE_XML_INDEX_TEMPLATE
2 = index type SE_XML_INDEX_DEFINITION
For XPath indexes associated with an ArcIMS metadata service, only the index type SE_XML_INDEX_DEFINITION is supported.
NOT NULL. |
description |
varchar(64) |
Text identifying the XPath index.
If an index definition file was used to create the index, the index's description may be specified at the top of the file. |