NOTE: The system tables should not be altered using anything other than the ArcGIS software.
NOTE: If you alter column definitions using a SQL interface, the records in the 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 that contains the column is stored
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 |
Int |
Code for the column's data type; possible values and their definitions include
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—Struct tm 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 |
Int |
The registered column value's length |
decimal_digits |
Int |
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 |
Int |
Stores the column properties; properties include
- Column has a row ID
- SDE controls the row ID column
- Column allows NULLS
- Column stores Oracle LONG RAW data
- Column stores BLOB data
- Column stores CLOB data
- Column stores ST_GEOMETRY geometry data
- Column stores binary geometry data
- Column stores UDT geometry data
- Column stores Oracle LOB 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 |
Int |
Value set to the rastercolumn_id of the sde.raster_columns table if the column is a raster column or the layer_id of the sde.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 |
Serial |
Unique identifier of a compress operation
NOT NULL |
sde_id |
Int |
Process identification number of the compress operation; references sde_id column in the process_information table
NOT NULL |
server_id |
Int |
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 |
Datetime |
The date and time the compress operation was begun
NOT NULL |
start_state_count |
Int |
The number of states present when compress began
NOT NULL |
compress_end |
Datetime |
The date and time the compress operation completed
NOT NULL |
end_state_count |
Int |
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 |
id |
Int |
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.
NOT NULL. |
description |
Varchar(255) |
Optional text describing the attribute domain. |
domaintype |
Int |
Code indicating whether this is a range (1) or coded value (2) domain.
NOT NULL. |
fieldtype |
Int |
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 |
Int |
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 |
Int |
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 attribute 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 |
Int |
Foreign key to the id field in the gdb_objectclasses table
NOT NULL |
featuretype |
Int |
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 |
Int |
Code representing the type of geometry of the feature class
1 = point
2 = multipoint
3 = line
4 = polygon (including anno and dimension)
9 = multipatch
NOT NULL |
shapefield |
Varchar(32) |
Name of the shape field in the feature class
NOT NULL |
geomnetworkid |
Int |
Foreign key to the id field in the gdb_geomnetworks table |
graphid |
Int |
Foreign key to id in the gdb_networks table |
Field name |
Field type |
Description |
classid |
Int |
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) |
Alternate name assigned to the field (Aliases can be altered after field creation, the field name cannot.) |
modelname |
Varchar(160) |
Alternate name assigned to the field 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 |
Decimal(38,8) |
If the field is a numeric type, the default value assigned to it |
isrequired |
Int |
0 (not a required field) or 1 (a required field) |
issubtypefixed |
Int |
Denotes whether subtype is set for the field
0 = yes
1 = no |
iseditable |
Int |
0 (not editable) or 1 (editable) |
Field name |
Field type |
Description |
ruleid |
Int |
Primary key, the unique ID for a rule in a geodatabase and the foreign key to the id field in the gdb_validrules table
NOT NULL |
edgeclassid |
Int |
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 |
Int |
The subtype of the edge feature class
NOT NULL |
junctionclassid |
Int |
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 |
Int |
The subtype of the junction feature class
NOT NULL |
edgemincard |
Int |
The minimum edge cardinality (the minimum number of edges to which a junction can connect)
NOT NULL |
edgemaxcard |
Int |
The maximum edge cardinality (the maximum number of edges to which a junction can connect)
NOT NULL |
junctionmincard |
Int |
The minimum junction cardinality (the minimum number of junctions to which an edge can connect)
NOT NULL |
junctionmaxcard |
Int |
The maximum junction cardinality (the maximum number of junctions to which an edge can connect)
NOT NULL |
isdefault |
Int |
Will contain 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 |
Int |
The unique identifier of a weight in a geodatabase
NOT NULL |
networkid |
Int |
The unique ID 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
NOT NULL |
name |
Varchar(160) |
The name of the weight, which must be unique in each network
NOT NULL |
weightid |
Int |
The unique ID of the weight in the geometric network
NOT NULL |
weighttype |
Int |
A value indicating the type of network weight
NOT NULL |
bitgatesize |
Int |
A value from 0 to 31 indicating the size of the BitGate weight
(NonBitGate weights have a value of 0.) |
elementtypes |
Int |
Denotes the type of network weight |
Field name |
Field type |
Description |
id |
Int |
The unique identifier and primary key of the logical network in a geodatabase.
NOT NULL. |
databasename |
Varchar(32) |
The name of the database in which the network is stored.
NOT NULL. |
owner |
Varchar(32) |
The name of the user who created the logical network.
NOT NULL. |
name |
Varchar(160) |
The name of the logical network.
NOT NULL. |
networktype |
Int |
A value indicating the type of network.
All networks created using ArcGIS Desktop will have a value of 1=esriNTUtilityNetwork.
NOT NULL. |
indextype |
Int |
Not currently implemented. |
normalized |
Int |
A value of either 0 or 2, which indicates whether the network is narrow or wide.
Narrow networks contain feature classes with ObjectIDs less than 10,000; wide networks can contain feature classes with ObjectIDs greater than 10,000.
NOT NULL. |
Field name |
Field type |
Description |
id |
Int |
Unique identifier for the object class
Primary key
NOT NULL |
databasename |
Varchar(32) |
Database in which the object class 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) |
Alternate 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 |
extprops |
BLOB |
Stores the properties of the associated class extension |
subtypefield |
Varchar(32) |
Name of the field in the object class for defining subtypes
|
datasetid |
Int |
Foreign key to the ID field in the gdb_featuredatasets table
|
Field name |
Field type |
Description |
id |
Int |
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 |
Int |
Object class ID of the origin object class.
NOT NULL. |
destclassid |
Int |
Object class ID 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 |
Int |
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 |
Int |
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 |
Int |
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 |
Int |
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 |
Int |
Foreign key to the gdb_featuredataset table. |
Field name |
Field type |
Description |
id |
Int |
Unique identifier for row.
NOT NULL. |
replicaid |
Int |
Foreign key to the ID field in the gdb_replicas table.
NOT NULL. |
event |
Int |
Indicates if an import (1) or an export (2) has been logged.
NOT NULL. |
errorcode |
Int |
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 |
Datetime |
The date on which the event occurred.
NOT NULL. |
sourcebegingen |
Int |
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 |
Int |
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 |
Int |
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 |
Int |
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 |
Int |
Identifier of the replica in the parent geodatabase
NOT NULL |
repdate |
Datetime |
Date and time the replica was created
NOT NULL |
defquery |
BLOB |
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 |
Char(1800) |
The connection information for the relative replicas geodatabase |
role |
Int |
Indicates if a replica has the role of parent or child
NOT NULL |
Field name |
Field type |
Description |
ruleid |
Int |
Unique identifier of the topology rule; foreign key to the id field in the gdb_validrules table
NOT NULL |
originclassid |
Int |
Foreign key to classid field in gdb_topoclasses table
NOT NULL |
originsubtype |
Int |
Foreign key to subtypecode field in gdb_subtypes table
NOT NULL |
alloriginsubtypes |
Int |
Indicates if rule applies to all subtypes in the origin feature class
NOT NULL |
destclassid |
Int |
Foreign key to classid field in gdb_topoclasses table
NOT NULL |
destsubtype |
Int |
Foreign key to subtypecode field in gdb_subtypes table
NOT NULL |
alldestsubtypes |
Int |
Indicates if rule applies to all subtypes in the destination feature class
NOT NULL |
topologyruletype |
Int |
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
NOT NULL |
Field name |
Field type |
Description |
f_table_catalog |
Varchar(32) |
The database in which the geometry column's table is stored
NOT NULL |
f_table_schema |
Varchar(32) |
The owner of the geometry column's table
NOT NULL |
f_table_name |
Varchar(128) |
The geometry column's table name
NOT NULL |
f_geometry_column |
Varchar(128) |
The name of the geometry column
NOT NULL |
storage_type |
Int |
An OGC required field not used by ArcSDE |
geometry_type |
Int |
The geometry type code; ArcSDE inserts the following values into this field:
0 = ST_Geometry
1 = ST_Point
3 = ST_LineString
5 = ST_Polygon
7 = ST_MultiPoint
9 = ST_MultiLineString
11 = ST_MultiPolygon |
coord_dimension |
Int |
Code for the coordinate dimension
0 = point
1 = linear
2 = area |
srid |
Int |
The geometry column's spatial reference system; a foreign key to the SRID column of the spatial_references table
NOT NULL |
Field name |
Field type |
Description |
sde_id |
Int |
Process identification number of the process that has locked the layer; foreign key to the sde_id column in PROCESS_INFORMATION table
NOT NULL |
layer_id |
Int |
Foreign key to layer_id field in LAYERS table
NOT NULL |
autolock |
Char(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 |
Char(1) |
The type of layer lock can either be
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 |
Int |
The minimum x-coordinate of the bounding box used to define the features within an area locked during an area lock |
miny |
Int |
The minimum y-coordinate of the bounding box used to define the features within an area locked during an area lock |
maxx |
Int |
The maximum x-coordinate of the bounding box used to define the features within an area locked during an area lock |
maxy |
Int |
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 |
Int |
Unique identifier for the layer
Primary key
NOT NULL |
description |
Varchar(65) |
The optional layer description
|
databasename |
Varchar(32) |
Name of the database in which the layer is stored |
owner |
Varchar(32) |
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 |
Int |
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, polygons
NOT NULL |
layer_maks |
Int |
Stores additional internal properties about the layer
NOT NULL |
minx |
Float |
Minimum x-coordinate value of the layer
NOT NULL |
miny |
Float |
Minimum y-coordinate value of the layer
NOT NULL |
maxx |
Float |
Maximum x-coordinate value of the layer
NOT NULL |
maxy |
Float |
Maximum y-coordinate vlue of the layer
NOT NULL |
minz |
Float |
Minimum z-coordinate value of the layer |
maxz |
Float |
Maximum z-coordinate value of the layer |
minm |
Float |
Minimum measure value of the layer |
maxm |
Float |
Maximum measure value of the layer |
cdate |
Int |
The layer creation date
NOT NULL |
layer_config |
Varchar(32) |
Configuration keyword with which the layer was created |
optimal_array_size |
Int |
Geometry array buffer size |
stats_date |
Int |
When statistics were last calculated for a layer |
minimum_id |
Int |
The minimum feature ID value of a binary layer |
srid |
Int |
Spatial reference identification number; corresponds to srid value in the spatial_references table
NOT NULL |
base_layer_id |
Int |
Stores the base layer's layer_id value for a layer that is actually a view
NOT NULL |
Field name |
Field type |
Description |
record_id |
Int |
Unique identifier for the record
Primary key
NOT NULL |
object_name |
Varchar(160) |
The name of the locator to which the property belongs and foreign key to the name column in the locators table
NOT NULL |
object_database |
Varchar(32) |
Name of the database in which the locator is stored |
object_owner |
Varchar(32) |
The name of the user who owns the record
NOT NULL |
object_type |
Int |
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 |
datetime |
Date and time the locator property was created
NOT NULL |
Field name |
Field type |
Description |
sde_id |
Int |
Process identification number of the process that locked the geodatabase object; references sde_id column in process_information table
NOT NULL |
object_id |
Int |
The ID from the object_classes table of the affected dataset
NOT NULL |
object_type |
Int |
Object lock type; for example, version,state_tree lock used by internal applications
NOT NULL |
application_id |
Int |
Application unique identifier
NOT NULL |
autolock |
Char(1) |
Set to Y if the layer lock was set internally; otherwise, set to N if the layer lock was set by the application
NOT NULL |
lock_type |
Char(1) |
The type of object lock, which includes
"S" for shared
"E" for exclusive
NOT NULL |
Field Name |
Field Type |
Description |
sde_id |
Int |
Process identification number
NOT NULL |
server_id |
Int |
The operating system process ID of the server process
NOT NULL |
start_time |
datetime |
Date and time process was started
NOT NULL |
rcount |
Int |
The number of reads that have been processed
NOT NULL |
wcount |
Int |
The number of writes that have been processed
NOT NULL |
opcount |
Int |
Total number of operations a process has executed
NOT NULL |
numlocks |
Int |
The number of locks that the process currently has open
NOT NULL |
fb_partial |
Int |
Total number of partial features shipped by the process
NOT NULL |
fb_count |
Int |
Total number of buffers loaded by the process
NOT NULL |
fb_fcount |
Int |
Total number of features buffered by the process
NOT NULL |
fb_kbytes |
Int |
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 |
Int |
The primary key of the raster column table.
NOT NULL. |
description |
Varchar(65) |
The description of the raster table. |
databasename |
Varchar(32) |
Name of the database in which the table that contains the raster column 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 |
Int |
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 |
Int |
Defined during the creation of the raster, establishes value of the raster table's raster_id column. |
base_rastercolumn_id |
Int |
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 |
Int |
Set to 256 for a geodatabase raster.
NOT NULL. |
srid |
Int |
Spatial reference identifier number; references srid in the spatial_references table. |
Field name |
Field type |
Description |
srid |
Int |
Spatial reference identifier number
NOT NULL |
description |
Varchar(64) |
The text description of the spatial reference system |
auth_name |
Varchar(256) |
The name of the standard or standards body that is being cited for this reference system; for example, POSC would be a valid AUTH_NAME |
auth_srid |
Int |
The ID of the Spatial Reference System as defined by the Authority cited in AUTH_NAME |
falsex |
Float |
The x offset used when transforming ground coordinates to internal system coordinates
NOT NULL |
falsey |
Float |
The y offset used when transforming ground coordinates to internal system coordinates
NOT NULL |
xyunits |
Float |
The scale factor to apply when transforming ground coordinates to internal system coordinates
NOT NULL |
falsez |
Float |
The z offset to use when transforming z values to internal system coordinates
NOT NULL |
zunits |
Float |
The scale factor to use when transforming z values to internal system coordinates
NOT NULL |
falsem |
Float |
The measure offset to use when transforming measure values to internal system coordinates
NOT NULL |
munits |
Float |
The scale factor to use when transforming measure values to internal system coordinates
NOT NULL |
srtext |
Char(2048) |
Name and descriptor for the spaital reference as seen in the ArcGIS interface
NOT NULL |
object_flags |
Int |
Stores object attributes, including precision
NOT NULL |
xycluster_tol |
Float |
X,y coordinate cluster tolerance for topological processing
|
zcluster_tol |
Float |
Z-coordinate cluster tolerance for topological processing |
mcluster_tol |
Float |
Measure cluster tolerance for topological processing |
Field name |
Field type |
Description |
registration_id |
Int |
Unique identifier for the registration of the table
Primary key
NOT NULL |
databasename |
Varchar(32) |
Name of the database in which the table is stored
NOT NULL |
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 |
Int |
Stores the registration properties of the table, which include
- 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 |
Int |
The date the table was registered
NOT NULL |
config_keyword |
Varchar(32) |
Configuration keyword with which the table was created
|
minimum_id |
Int |
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 |
Int |
Number of the major release; for example, for ArcSDE 9.1, the major release number would be 9.
NOT NULL. |
minor |
Int |
Number indicating the version of the major release; for example, for ArcSDE 9.1, the minor release number would be 1.
NOT NULL. |
bugfix |
Int |
Number of the patch or service pack installed.
NOT NULL. |
description |
Varchar(96) |
Description of the ArcSDE installation.
NOT NULL. |
release |
Int |
Complete release number; for example, 92009,
NOT NULL |
sdesvr_rel_low |
Int |
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 |
Int |
The unique identifier of the version
NOT NULL |
status |
Int |
Specifies whether the version is available to the public or if it is privately accessed by the owner
NOT NULL |
state_id |
Int8 |
The identifier 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 |
Int |
The identifier of the version which is the parent of this version |
creation_time |
Datetime |
The date/time that this version was created
NOT NULL |