ArcGIS Server Banner

Schematic datasets in a geodatabase in SQL Server

Schematic datasets in a geodatabase in SQL Server
Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

NOTE: Requires Schematics extension

Schematic datasets are similar to feature datasets but they contain a collection of schematic diagram classes and schematic element classes (which are the schematic equivalent of feature classes). They are used to graphically visualize and manipulate network data.

A schematic dataset is always associated with a schematic project. When you create a schematic dataset in ArcCatalog, an associated schematic project is automatically created. A schematic project contains the graphic parameters and display rules for the schematic diagrams generated and stored in the schematic dataset.

NOTE: If you are using the multiple spatial database model for SQL Server, be sure you are connected to the sde database when you create your schematic dataset.

Schematic datasets in ArcCatalog

The following is an example of a schematic dataset, schematic folders, and schematic diagrams in a SQL Server database management system in ArcCatalog:

Schematics dataset in ArcCatalog (SQL Server)

Top of page

Schematic datasets in a SQL Server DBMS

The following tables are used to store information on schematic datasets.

SCH_DATASET

Contains one record for each schematic dataset. The ID field in this table is used to identify the assosiated element and diagram tables.


Field name Field type Description
ID int Unique identifier of the schematic dataset

Primary key
MAJOR int Release number of the dataset version; not used at this time
MINOR int Minor release number of the dataset version; not used at this time
BUGFIX int Patch or service pack number of the dataset version; not used at this time
DBNAME nvarchar(32) Name of the database in which the schematic dataset is stored

nulls allowed
OWNER nvarchar(32) The user who created the schematic dataset

nulls allowed
NAME nvarchar(128) The name of the schematic dataset
EXTCLSID nvarchar(38) Not currently in use

nulls allowed
SPATIALREF nvarchar(1024) Default spatial reference used when creating new diagrams

nulls allowed
BLOBS image Stores the default parameters for the dataset, such as the default node symbol, text separator, and character

nulls allowed

SCH_RELEASE

The SCH_RELEASE table is not currently in use.


Field name Field type Description
MAJOR int Release number of the system tables; not used at this time
MINOR int Minor release number of the system tables; not used at this time
BUGFIX int Patch or service pack number of the system tables; not used at this time

SCH_UNIQUEID

The SCH_UNIQUEID table stores the unique identifier of a diagram type.


Field name Field type Description
ID int The unique identifier used when creating new diagram types for the object class
DUMMY int Not in use at this time

nulls allowed

SCH<ID>_CLSENTRY

Stores the associations between the diagram types and the element types in a schematic dataset


Field name Field type Description
ID int Uniquely identifies the relationship between a diagram type and element type

Primary key
DIAGRAMCLASSID int Foreign key to the ID field in the SCH<ID>_DIACLASS table
ELEMENTCLASSID int Foreign key to the ID field in the SCH<ID>_ELTCLASS table

SCH<ID>_DATASRC

Contains a list of all the data sources accessed by the schematic dataset


Field name Field type Description
ID int Uniquely identifies a data source

Primary key
NAME nvarchar(255) Name of the data source
CLSID nvarchar(38) Class ID of the data source component
LABEL nvarchar(255) Not currently in use
CONNECTION image Parameters of the connection; used to persist and restore the connection

SCH<ID>_DIACLASS

Tracks all the diagram types present in a schematic dataset


Field name Field type Description
ID int Uniquely identifies a diagram type

Primary key
OBJECTCLASSID int Foreign key to the ID field in the SCH_UNIQUEID table
CREATIONNAME nvarchar(255) Name of the diagram class when the table is created
NAME nvarchar(255) Current name of the diagram class (if it was changed from the original name)
PARENTID int ID of the parent diagram class entry
DATASOURCEID int Foreign key to the ID field of SCH<ID>_DATASRC

nulls allowed
BUILDERCLSID nvarchar(38) Class ID for the schema builder (custom query, network dataset, or standard)

nulls allowed
LINKERCLSID nvarchar(38) Component managing feature to element relationship method

nulls allowed
ALGORITHMCLSID nvarchar(38) Class ID of the algorithm that is automatically applied to diagrams of this type

nulls allowed
BLOBS image Stores all the attribute and symbology information

nulls allowed

SCH<ID>_ELTCLASS

Maintains a list of all the element types for each dataset


Field name Field type Description
ID int Uniquely identifies an element type
OBJECTCLASSID int Foreign key to ID in GDB_ObjectClasses table
CREATIONNAME nvarchar(255) Name of the element class when the table is created
NAME nvarchar(255) Current name of the element class (if it changed)
PARENTID int ID of the parent element class entry
ELEMENTTYPE int Value specifying the type of element (node, link, etc.)
RELATIOINCLSID nvarchar(38) Relationship to a feature class

nulls allowed
ASSOCIATEDDSID int Data source ID of related feature class

nulls allowed
ASSOCIATEDOCID int ID of the related feature classes from the GDB_ObjectClasses table

nulls allowed
DATASOURCEID int Foreign key to the ID field in the SCH<ID>_DATASRC table

nulls allowed
BLOBS image Stores attribute and symbology

nulls allowed

SCH<ID>_FOLDER

Maintains a list of all the folders created in a dataset


Field name Field type Description
ID int Unique identifier for the folder
NAME nvarchar(255) Name of the folder
PFID int ID of the parent folder if nested
XML image Stores the metadata of the folder

nulls allowed

SCH<ID>A_<ELEMENT_TYPE_NAME>

Tracks the associations between an element and a feature


Field name Field type Description
ID int Uniquely identifies the association between an element and a feature

Primary key
SCHEMATICID int Unique ID for an element
DATASOURCEID int Foreign key to the ID field in the SCH<ID>_DATASRC table

nulls allowed
UCID int Class ID of the related feature

nulls allowed
UOID int Object ID of the related feature

nulls allowed
USID int Subtype ID of the related feature

nulls allowed
UEID int Enabled ID of the related feature

nulls allowed

SCH<ID>D_<DIAGRAM_TYPE_NAME>

Stores a list of all diagrams created using a particular diagram type (the one indicated by the <DIAGRAM_TYPE_NAME>)


Field name Field type Description
ID int Uniquely identifies a diagram

Primary key
NAME nvarchar(255) Name of the diagram
FOLDERID int Foreign key to the SCH<ID>_FOLDER table
DIAGRAMCLASSID int Foreign key to SCH<ID>_DIACLASS table's OBJECTCLASSID field
LASTUPDATE datetime Date and time of last user update

nulls allowed
VERSION nvarchar(255) If generated from versioned data, lists which version

nulls allowed
CREATIONDATE datetime Date and time diagram was created

nulls allowed
CREATOR nvarchar(100) Name of the user that created the diagram

nulls allowed
UPDATEDBY nvarchar(100) Name of the user that last updated the diagram

nulls allowed
SPATIALREF nvarchar(1024) Spatial coordinates

nulls allowed
BLOBS image Stores the current positioning of all elements in the diagram

nulls allowed

SCH<ID>E_<ELEMENT_TYPE_NAME>

Stores a list of all the elements created using an element type

Element types define the attributes and symbology of an element.


Field name Field type Description
ID int Uniquely identifies an element

Primary key
DIAGRAMCLASSID int Foregn key to the SCH<ID>_DIACLASS table's OBJECTCLASSID field
DIAGRAMOBBJECTID int Foreign key to the SCH<ID>D_<Diagram_Type_Name> table
SCHEMATICID nvarchar(128) Uniquely identifies an element; consists of DIAGRAMOBJECTID, DIAGRAMCLASSID, DATASOURCEID, UCID, UOID, and USID
ISINITIAL int Indicates whether this element was part of the initial creation list
ISDISPLAYED int Indicates whether this element is currently displayed
RELATIONOBJECTID int Object ID of related feature in relationship

nulls allowed
RELATIONCLASSID int Class ID of related feature in relationship

nulls allowed
DATASOURCEID int Foreign key to SCH<ID>_DATASRC table

nulls allowed
UCID int Class ID of corresponding feature

nulls allowed
UOID int Object ID of corresponding feature

nulls allowed
USID int Subtype ID of corresponding feature

nulls allowed
UEID int Enabled value of corresponding feature

nulls allowed
SUBTYPE int Subtype of feature

nulls allowed
PROPERTYSET image Holds attribute information

nulls allowed
INITIALX numeric X positon of element when created

nulls allowed
INITIALY numeric Y position of element when created

nulls allowed

SCH<ID>R_<DIAGRAM_TYPE_NAME>

Stores a list of all the relationship rules for a diagram type


Field name Field type Description
ID int Uniquely identifies relationship rule

Primary key
ORDERNUMBER int Indicates in which order rules will be run
ACTIVE int Indicates whether or not the rule is active
CLSID nvarchar(38) Class ID of the rule
PROPERTYSET image Property page values

nulls allowed

Click the following link to see an example schematic dataset system tables showing implicit links.

SQL Server schematic dataset diagram

Schematic datasets in XML

Exporting schematic datasets to XML is not presently supported.

Top of page

See Also

  • Feature datasets in a geodatabase in SQL Server