Desktop Help 10.0 - Schematic datasets in a geodatabase in SQL Server

Schematic datasets are similar to feature datasets, but they contain a collection of schematic diagram templates and schematic feature classes. They are used to graphically visualize and manipulate network data.

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 ArcGIS Desktop

In the Catalog tree, schematic datasets have the following icon:

Schematic dataset icon

When you expand a schematic dataset, you can see the schematic diagrams it contains. These diagrams have the following icon:

Schematic diagram icon

The names of the schematic dataset and schematic diagram in a geodatabase in SQL Server contain the database name, the name of the dataset owner, and the names of the dataset and diagram themselves.

Schematic datasets in a Microsoft SQL Server database

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

SCH_DATASET

The SCH_DATASET table contains one record for each schematic dataset created in the geodatabase. The ID field in this table is used to identify the associated feature and diagram tables and appears in those table names.

Field name	Field type	Description	Null?
ID	integer	Unique identifier of the schematic dataset The value in this field is the ID in the names of all the other schematic dataset tables except SCH_RELEASE and SCH_UNIQUEID.	NOT NULL
MAJOR	integer	Release number of the dataset version	NOT NULL
MINOR	integer	Minor release number of the dataset version; not used at this time	NOT NULL
BUGFIX	integer	Patch or service pack number of the dataset version; not used at this time	NOT NULL
DBNAME	nvarchar(32)	Name of the database in which the schematic dataset is stored
OWNER	nvarchar(32)	The user who created the schematic dataset
NAME	nvarchar(128)	The name of the schematic dataset	NOT NULL
LOCKINFO	nvarchar(38)	Used by the Schematic Dataset Editor configuration tool to avoid conflicts when multiple users are making configuration changes concurrently
BLOBS	varbinary(max)	Stores the metadata for the schematic dataset

SCH_RELEASE

The SCH_RELEASE table is not currently in use.

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

SCH_UNIQUEID

The SCH_UNIQUEID table provides unique identifiers for the indexes of schematic feature classes.

Field name	Field type	Description	Null?
ID	integer	The unique identifier used when creating new diagram templates for the object class	NOT NULL
DUMMY	integer	Not currently in use

SCH<ID>_CLSENTRY

This table stores the associations between the diagram templates and the feature types in a schematic dataset. This table is created when the schematic dataset is created.

Field name	Field type	Description	Null?
ID	integer	Uniquely identifies the relationship between a diagram template and feature class	NOT NULL
DIAGRAMCLASSID	integer	Corresponds to the ID field in the SCH<ID>_DIACLASS table	NOT NULL
ELEMENTCLASSID	integer	Corresponds to the ID field in the SCH<ID>_ELTCLASS table	NOT NULL

SCH<ID>_DATASRC

This table contains a list of all the data sources accessed by the schematic dataset. This table is created when the schematic dataset is created.

Field name	Field type	Description	Null?
ID	integer	Uniquely identifies a data source	NOT NULL
NAME	nvarchar(255)	Name of the data source	NOT NULL
CLSID	nvarchar(38)	Class ID of the data source component	NOT NULL
LABEL	nvarchar(255)	Not currently in use	NOT NULL
CONNECTION	varbinary(max)	Parameters of the connection; used to persist and restore the connection	NOT NULL

SCH<ID>_DIACLASS

This table tracks all the diagram templates present in a schematic dataset. It contains a row for each diagram template created.

This table is created when the schematic dataset is created.

Field name	Field type	Description	Null?
ID	integer	Uniquely identifies a diagram template	NOT NULL
OBJECTCLASSID	integer	Corresponds to the ID field in the SCH_UNIQUEID table	NOT NULL
CREATIONNAME	nvarchar(255)	Name of the diagram class when the table is created	NOT NULL
NAME	nvarchar(255)	Current name of the diagram class (if it was changed from the original name) Corresponds to the diagram template name in the SCH<ID>D_<DIAGRAM_TEMPLATE_NAME> table name	NOT NULL
PARENTID	integer	ID of the parent diagram class entry	NOT NULL
DATASOURCEID	integer	Corresponds to the ID field of SCH<ID>_DATASRC; only used for a diagram template based on a custom query
BUILDERCLSID	nvarchar(38)	Class ID for the schema builder (XML, network dataset, or standard)
LINKERCLSID	nvarchar(38)	Component managing feature to element relationship method
ALGORITHMCLSID	nvarchar(38)	Class ID of the algorithm that is automatically applied to diagrams of this type
BLOBS	varbinary(max)	Stores the diagram class definition parameters (builder properties, custom query, default layer properties, attributes, algorithms that are available for diagrams based on this type and their parameters, default node class, spatial reference)

SCH<ID>_ELTCLASS

This table maintains a list of all the feature classes for each dataset. This table is created when the schematic dataset is created. For every row in this table, one SCH<ID>E_<FEATURE_CLASS_NAME> and one SCH<ID>A_<FEATURE_CLASS_NAME> table are created.

Field name	Field type	Description	Null?
ID	integer	Uniquely identifies a schematic feature class	NOT NULL
OBJECTCLASSID	integer	Corresponds to the ID in the GDB_ITEMS table	NOT NULL
CREATIONNAME	nvarchar(255)	Name of the schematic feature class when the table is created	NOT NULL
NAME	nvarchar(255)	Current name of the schematic feature class (if it changed) Corresponds to the feature class name in the SCH<ID>E_<FEATURE_CLASS_NAME> and SCH<ID>A_<FEATURE_CLASS_NAME> table names	NOT NULL
PARENTID	integer	ID of the parent element class entry	NOT NULL
ELEMENTTYPE	integer	Value specifying the type of element (such as node, link, node-on-link, or sublink)	NOT NULL
RELATIOINCLSID	nvarchar(38)	Relationship to a feature class
ASSOCIATEDSID	integer	Data source ID of related feature class
ASSOCIATEDOCID	integer	ID of the related feature classes from the GDB_ITEMS table
DATASOURCEID	integer	Corresponds to the ID field in the SCH<ID>_DATASRC table; only used for a schematic feature class based on a custom query
BLOBS	varbinary(max)	Stores the schematic feature class definition parameters (such as attributes and custom query)

SCH<ID>_FOLDER

This table maintains a list of all the folders created in a dataset. This table is created when the schematic dataset is created.

Field name	Field type	Description	Null?
ID	integer	Unique identifier for the folder	NOT NULL
NAME	nvarchar(255)	Name of the folder	NOT NULL
PFID	integer	ID of the parent folder if nested	NOT NULL
XML	varbinary(max)	Stores the metadata of the folder

SCH<ID>A_<FEATURE_CLASS_NAME>

This table tracks the associations between a schematic feature and GIS feature. It is only used when items are associated to a schematic record in compliance with rules defined in the SCH<ID>R_<DIAGRAM_TEMPLATE_NAME> table.

Field name	Field type	Description	Null?
ID	integer	Uniquely identifies the association between a schematic feature and a GIS feature	NOT NULL
SCHEMATICID	integer	Unique ID for a schematic feature	NOT NULL
DATASOURCEID	integer	Corresponds to the ID field in the SCH<ID>_DATASRC table
UCID	integer	Class ID of the related feature
UOID	integer	ObjectID of the related feature
USID	integer	ID of the element in the related feature; only applicable to related features that are complex edges Identifies the segment ID on the related complex edge feature; 0 for all other kinds of related features
UGUID	integer	GUID of the related feature (if one exists)

SCH<ID>D_<DIAGRAM_TEMPLATE_NAME>

This table stores a list of all diagrams created using a particular diagram template (the one indicated by the <DIAGRAM_TEMPLATE_NAME>). This table is created when its associated diagram template is created and contains one row per diagram.

Field name	Field type	Description	Null?
ID	integer	Uniquely identifies a diagram	NOT NULL
NAME	nvarchar(255)	Name of the diagram	NOT NULL
FOLDERID	integer	Corresponds to the ID field in the SCH<ID>_FOLDER table	NOT NULL
DIAGRAMCLASSID	integer	Corresponds to SCH<ID>_DIACLASS table's OBJECTCLASSID field	NOT NULL
LASTUPDATE	datetime2	Date and time of last user update
VERSION	nvarchar(255)	If generated from versioned data, lists which version
CREATIONDATE	datetime2	Date and time the diagram was created
CREATOR	nvarchar(100)	Name of the user who created the diagram
UPDATEDBY	nvarchar(100)	Name of the user who last updated the diagram
BLOBS	varbinary(max)	Stores the diagram parameters (such as a list of the end and root nodes and CLASSID of the last algorithm executed before saving)
LOCKSTATUS	integer	Indicates if the diagram is currently locked or edited by a user
LASTMODIFICATION	datetime2	Date and time of the last time the diagram was modified
MODIFIEDBY	nvarchar(100)	The user who last modified the diagram

SCH<ID>E_<FEATURE_CLASS_NAME>

This table stores a list of all the schematic features created using a schematic feature class and used in a diagram.

Field name	Field type	Description	Null?
ID	integer	Uniquely identifies an element; primary key	NOT NULL
DIAGRAMCLASSID	integer	Corresponds to the OBJECTCLASSID field in the SCH<ID>_DIACLASS table	NOT NULL
DIAGRAMOBJECTID	integer	Corresponds to the ID field in the SCH<ID>D_<Diagram_Template_Name> table	NOT NULL
SCHEMATICID	nvarchar(128)	Uniquely identifies a the schematic feature in the diagram; consists of UCID, UOID, and USID	NOT NULL
ISINITIAL	integer	Indicates whether this schematic feature was part of the initial creation list	NOT NULL
ISDISPLAYED	integer	Indicates whether this schematic feature is currently displayed	NOT NULL
RELATIONOBJECTID	integer	ObjectID of related standard feature or object in relationship
RELATIONCLASSID	integer	Class ID of related standard feature or object in relationship
DATASOURCEID	integer	Corresponds to the ID field in the SCH<ID>_DATASRC table
UCID	integer	Class ID of corresponding feature or object
UOID	integer	Object ID of corresponding feature or object
USID	integer	The ID of the element in the corresponding feature; only applicable to corresponding features that are complex edges. Identifies the segment ID on the corresponding complex edge feature. 0 for all other types of corresponding features.
UPDATESTATUS	nvarchar(38)	Specifies if a feature is new as a result of the last update
SUBTYPE	integer	Subtype of feature
PROPERTYSET	varbinary(max)	Holds attribute information
INITIALX	numeric	X position of feature when created; only applicable to node schematic feature type
INITIALY	numeric	Y position of feature when created; only applicable to node schematic feature type
INITIALPOSITION	numeric	Initial position of feature on its related reference schematic link; only applicable to node-on-link schematic feature type
REFERENCELINK	nvarchar(128)	SCHEMATICID of the reference schematic link with which the feature is associated; only applicable to node-on-link or sublink schematic feature types
ROTATION	numeric(32,20)	Symbol rotation of feature; only applicable to node or node-on-link schematic feature types
FROMTID	nvarchar(128)	SCHEMATICID of the feature's origin node; only applicable to link or sublink schematic feature types
TOTID	nvarchar(128)	SCHEMATICID of the feature's end node; only applicable to link or sublink schematic feature types
FROMPORT	integer	Port number on the feature's origin node symbol that must be used to connect the feature; only applicable to link or sublink schematic feature types
TOPORT	integer	Port number on the feature's origin node symbol that must be used to connect the feature; only applicable to link or sublink schematic feature types
FLOWDIRECTION	integer	Indicates the flow direction; only applicable to link or sublink schematic feature types
UGUID	uniqueidentifier	GUID of the related feature (if one exists)
SHAPE	geometry geography varbinary(max)	Geometry of the schematic feature

SCH<ID>R_<DIAGRAM_TEMPLATE_NAME>

This table stores a list of all the schematic rules configured on a diagram template. This table is created when its associated diagram template is created but is only populated if rules are configured.

Field name	Field type	Description	Null?
ID	integer	Uniquely identifies relationship rule; primary key	NOT NULL
ORDERNUMBER	integer	Indicates in which order rules will be run	NOT NULL
ACTIVE	integer	Indicates whether or not the rule is active	NOT NULL
CLSID	nvarchar(38)	Class ID of the rule	NOT NULL
PROPERTYSET	varbinary(max)	Rule properties	NOT NULL

View a diagram of a schematic dataset in SQL Server.

Note:

You need Adobe Acrobat Reader to open the file.

Dashed lines indicate implicit relationships between columns.

Schematic datasets in XML

Though you cannot export an entire schematic dataset to XML at once, you can export individual schematic diagrams to an XML document. The following is a partial example of such a file:

<sch:Diagrams xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:esri="http://www.esri.com/schemas/ArcGIS/10.0" xmlns:xs="http://www.w3.org/2001/XMLSchema"
 xmlns:sch="http://www.esri.com/schemas/ArcGIS/10.0/Schematics">
 <Diagram DiagramTemplateName="GeoSchematic" DiagramName="Feeder 0801-Rice Creek"
  EnforceDiagram TemplateName="false" EnforceDiagramName="false" Version="dbo.DEFAULT">
  <Features>
    <NodeFeature>
      <FeatureClassName>TransformerBank</FeatureClassName>
      <ExternalUniqueID>36-1585-0</ExternalUniqueID>

        <DatasourceName>sql gdb</DatasourceName>
      <UCID>36</UCID>
      <UOID>1585</UOID>
      <SUBTYPE>0</SUBTYPE>
      <UPDATESTATUS>1</UPDATESTATUS>
      <InitialX>376834.28999999911</InitialX>
      <InitialY>1571795.700000003</InitialY>
      <ROTATION>0</ROTATION>
    </NodeFeature>
    <LinkFeature>
       <FeatureClassName>PrimaryLine</FeatureClassName>
       <ExternalUniqueID>16-1083-0</ExternalUniqueID>
         
         <DatasourceName>sql gdb</DatasourceName>
       <UCID>16</UCID>
       <UOID>1083</UOID>
       <SUBTYPE>1</SUBTYPE>
       <UPDATESTATUS>1</UPDATESTATUS>
       <FromNode>21-8-0</FromNode>
       <ToNode>36-250-0</ToNode>
       <PropertySet xsi:type="esri:PropertySet">
         <PropertyArray xsi:type="esri:ArrayOfPropertySetProperty">
           <PropertySetProperty xsi:type="esri:PropertySetProperty">
             <Key>placement</Key>
             <Value xsi:type="xs:int">0</Value>
           </PropertySetProperty>
         <PropertyArray>
        </PropertySet>
       <Vertices />
     </LinkFeature>
    </Features>
    <Datasources>
      <Datasource>
        <NameString>sql gdb</NameString>
        <WorkSpaceInfo xsi:type="esri:WorkspaceName">
          <PathName>c:\Documents and Settings\gis\
           Application Data\ESRI\Desktop10.0\ArcCatalog\sdegdb on sqlserver</PathName>
          <BrowseName>ArcSDE Data</BrowseName>
          <WorkspaceFactoryProgID>esriDataSourcesGDB.SdeWorkspaceFactory.1</WorkspaceFactoryProgID>
          <WorkspaceType>esriRemoteDatabaseWorkspace</WorkspaceType>
          <Connection Properties xsi:type="esri:PropertySet">
            <PropertyArray xsi:type="esri:ArrayOfPropertySetProperty">
              <PropertySetProperty xsi:type="esri:PropertySetProperty">
                <Key>SERVER</Key>
                <Value xsi:type="xs:string">blackrock</Value>
              </PropertySetProperty>
              <PropertySetProperty xsi:type="esri:PropertySetProperty">
                <Key>INSTANCE</Key>
                <Value xsi:type="xs:string">sde:sqlserver:blackrock\ssspatial</Value>
              </PropertySetProperty>
              <PropertySetProperty xsi:type="esri:PropertySetProperty">
                <Key>DATABASE</Key>
                <Value xsi:type="xs:string">spatialdb</Value>
              </PropertySetProperty>
              <PropertySetProperty xsi:type="esri:PropertySetProperty">
                <Key>AUTHENTICATION_MODE</Key>
                <Value xsi:type="xs:string">OS</Value>
              </PropertySetProperty>
              <PropertySetProperty xsi:type="esri:PropertySetProperty">
                <Key>VERSION</Key>
                <Value xsi:type="xs:string">dbo.DEFAULT</Value>
              </PropertySetProperty>
            </PropertyArray>
          </ConnectionProperties>
        </WorkSpaceInfo>
      </Datasource>
    </Datasources>
  </Diagram>
</sch:Diagrams>

Schematic datasets in a geodatabase in SQL Server

Schematic datasets in ArcGIS Desktop

Schematic datasets in a Microsoft SQL Server database

Schematic datasets in XML

Related Topics