Schematic datasets in a geodatabase in Oracle

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.

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 Oracle contain the name of the dataset owner and the names of the dataset and diagram themselves.

Schematic datasets in an Oracle 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

NUMBER(38)

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

NUMBER(38)

Release number of the dataset version

NOT NULL

MINOR

NUMBER(38)

Minor release number of the dataset version; not used at this time

NOT NULL

BUGFIX

NUMBER(38)

Patch or service pack number of the dataset version; not used at this time

NOT NULL

DBNAME

NVARCHAR2(32)

Name of the database in which the schematic dataset is stored

OWNER

NVARCHAR2(32)

The user who created the schematic dataset

NAME

NVARCHAR2(128)

The name of the schematic dataset

NOT NULL

LOCKINFO

NVARCHAR2(38)

Used by the Schematic Dataset Editor configuration tool to avoid conflicts when multiple users are making configuration changes concurrently

BLOBS

BLOB

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

NUMBER(38)

Release number of the system tables

NOT NULL

MINOR

NUMBER(38)

Minor release number of the system tables; not used at this time

NOT NULL

BUGFIX

NUMBER(38)

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

NUMBER(38)

The unique identifier used when creating new diagram templates for the object class

NOT NULL

DUMMY

NUMBER(38)

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

NUMBER(38)

Uniquely identifies the relationship between a diagram template and feature class

NOT NULL

DIAGRAMCLASSID

NUMBER(38)

Corresponds to the ID field in the SCH<ID>_DIACLASS table

NOT NULL

ELEMENTCLASSID

NUMBER(38)

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

NUMBER(38)

Uniquely identifies a data source

NOT NULL

NAME

NVARCHAR2(255)

Name of the data source

NOT NULL

CLSID

NVARCHAR2(38)

Class ID of the data source component

NOT NULL

LABEL

NVARCHAR2(255)

Not currently in use

CONNECTION

BLOB

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

NUMBER(38)

Uniquely identifies a diagram template

NOT NULL

OBJECTCLASSID

NUMBER(38)

Corresponds to the ID field in the SCH_UNIQUEID table

NOT NULL

CREATIONNAME

NVARCHAR2(255)

Name of the diagram class when the table is created

NOT NULL

NAME

NVARCHAR2(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

NUMBER(38)

ID of the parent diagram class entry

NOT NULL

DATASOURCEID

NUMBER(38)

Corresponds to the ID field of SCH<ID>_DATASRC; only used for a diagram template based on a custom query

BUILDERCLSID

NVARCHAR2(38)

Class ID for the schema builder (XML, network dataset, or standard)

LINKERCLSID

NVARCHAR2(38)

Component managing feature to element relationship method

ALGORITHMCLSID

NVARCHAR2(38)

Class ID of the algorithm that is automatically applied to diagrams of this type

BLOBS

BLOB

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

NUMBER(38)

Uniquely identifies a schematic feature class

NOT NULL

OBJECTCLASSID

NUMBER(38)

Corresponds to the ID in the GDB_ITEMS table

NOT NULL

CREATIONNAME

NVARCHAR2(255)

Name of the schematic feature class when the table is created

NOT NULL

NAME

NVARCHAR2(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

NUMBER(38)

ID of the parent element class entry

NOT NULL

ELEMENTTYPE

NUMBER(38)

Value specifying the type of element (such as node, link, node-on-link, or sublink)

NOT NULL

RELATIOINCLSID

NVARCHAR2(38)

Relationship to a feature class

ASSOCIATEDSID

NUMBER(38)

Data source ID of related feature class

ASSOCIATEDOCID

NUMBER(38)

ID of the related feature classes from the GDB_ITEMS table

DATASOURCEID

NUMBER(38)

Corresponds to the ID field in the SCH<ID>_DATASRC table; only used for a schematic feature class based on a custom query

BLOBS

BLOB

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

NUMBER(38)

Unique identifier for the folder

NOT NULL

NAME

NVARCHAR2(255)

Name of the folder

NOT NULL

PFID

NUMBER(38)

ID of the parent folder if nested

NOT NULL

XML

BLOB

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

NUMBER(38)

Uniquely identifies the association between a schematic feature and a GIS feature

NOT NULL

SCHEMATICID

NUMBER(38)

Unique ID for a schematic feature

NOT NULL

DATASOURCEID

NUMBER(38)

Corresponds to the ID field in the SCH<ID>_DATASRC table

UCID

NUMBER(38)

Class ID of the related feature

UOID

NUMBER(38)

ObjectID of the related feature

USID

NUMBER(38)

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

NUMBER(38)

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

NUMBER(38)

Uniquely identifies a diagram

NOT NULL

NAME

NVARCHAR2(255)

Name of the diagram

NOT NULL

FOLDERID

NUMBER(38)

Corresponds to the ID field in the SCH<ID>_FOLDER table

NOT NULL

DIAGRAMCLASSID

NUMBER(38)

Corresponds to SCH<ID>_DIACLASS table's OBJECTCLASSID field

NOT NULL

LASTUPDATE

DATE

Date and time of last user update

VERSION

NVARCHAR2(255)

If generated from versioned data, lists which version

CREATIONDATE

DATE

Date and time the diagram was created

CREATOR

NVARCHAR2(100)

Name of the user who created the diagram

UPDATEDBY

NVARCHAR2(100)

Name of the user who last updated the diagram

BLOBS

BLOB

Stores the diagram parameters (such as a list of the end and root nodes and CLASSID of the last algorithm executed before saving)

LOCKSTATUS

NUMBER(38)

Indicates if the diagram is currently locked or edited by a user

NOT NULL

LASTMODIFICATION

DATE

Date and time the last modification was made to the diagram

MODIFIEDBY

NVARCHAR2(100)

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

NUMBER(38)

Uniquely identifies a schematic feature; primary key

NOT NULL

DIAGRAMCLASSID

NUMBER(38)

Corresponds to the OBJECTCLASSID field in the SCH<ID>_DIACLASS table

NOT NULL

DIAGRAMOBJECTID

NUMBER(38)

Corresponds to the ID field in the SCH<ID>D_<Diagram_Template_Name> table

NOT NULL

SCHEMATICID

NVARCHAR2(128)

Uniquely identifies the schematic feature in the diagram; consists of UCID, UOID, and USID when the schematic feature is created by the standard builder

NOT NULL

ISINITIAL

NUMBER(38)

Indicates whether this schematic feature was part of the initial creation list

NOT NULL

ISDISPLAYED

NUMBER(38)

Indicates whether this schematic feature is currently displayed

NOT NULL

RELATIONOBJECTID

NUMBER(38)

ObjectID of related standard feature or object in relationship

RELATIONCLASSID

NUMBER(38)

Class ID of related standard feature or object in relationship

DATASOURCEID

NUMBER(38)

Corresponds to the ID field in the SCH<ID>_DATASRC table

UCID

NUMBER(38)

Class ID of corresponding feature or object

UOID

NUMBER(38)

ObjectID of corresponding feature or object

USID

NUMBER(38)

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 kinds of corresponding features.

UPDATESTATUS

NUMBER(38)

Specifies if a feature is new as a result of the last update

SUBTYPE

NUMBER(38)

Subtype of feature

PROPERTYSET

BLOB

Holds attribute information

INITIALX

NUMBER(32,20)

X position of feature when created; only applicable to node schematic feature type

INITIALY

NUMBER(32,20)

Y position of feature when created; only applicable to node schematic feature type

INITIALPOSITION

NUMBER(32,20)

Initial position of feature on its related reference schematic link; only applicable to node-on-link schematic feature type

REFERENCELINK

NVARCHAR2(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

NUMBER(32,20)

Symbol rotation of feature; only applicable to node or node-on-link schematic feature types

FROMTID

NVARCHAR2(128)

SCHEMATICID of the feature's origin node; only applicable to link or sublink schematic feature types

TOTID

NVARCHAR2(128)

SCHEMATICID of the feature's end node; only applicable to link or sublink schematic feature types

FROMPORT

NUMBER(38)

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

NUMBER(38)

Port number on the feature's end node symbol that must be used to connect the feature; only applicable to link or sublink schematic feature types

FLOWDIRECTION

NUMBER(38)

Indicates the flow direction; only applicable to link or sublink schematic feature types

UGUID

CHAR(38)

GUID of the related feature (if one exists)

SHAPE

NUMBER(38)

ST_GEOMETRY

SDO_GEOMETRY

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

NUMBER(38)

Uniquely identifies relationship rule

NOT NULL

ORDERNUMBER

NUMBER(38)

Indicates in which order rules will be run

NOT NULL

ACTIVE

NUMBER(38)

Indicates whether or not the rule is active

NOT NULL

CLSID

NVARCHAR2(38)

Class ID of the rule

PROPERTYSET

BLOB

Rule properties

View a diagram of a schematic dataset in Oracle.

NoteNote:

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="sde.DEFAULT">
  <Features>
    <NodeFeature>
      <FeatureClassName>TransformerBank</FeatureClassName>
      <ExternalUniqueID>36-1585-0</ExternalUniqueID>

        <DatasourceName>arcsde oracle 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>arcsde oracle 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>arcsde oracle gdb</NameString>
        <WorkSpaceInfo xsi:type="esri:WorkspaceName">
          <PathName>c:\Documents and Settings\gis\
           Application Data\ESRI\Desktop10.0\ArcCatalog\sdegdb on oracle</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">boldface</Value>
              </PropertySetProperty>
              <PropertySetProperty xsi:type="esri:PropertySetProperty">
                <Key>INSTANCE</Key>
                <Value xsi:type="xs:string">sde:oracle11g</Value>
              </PropertySetProperty>
              <PropertySetProperty xsi:type="esri:PropertySetProperty">
                <Key>AUTHENTICATION_MODE</Key>
                <Value xsi:type="xs:string">DBMS</Value>
              </PropertySetProperty>
              <PropertySetProperty xsi:type="esri:PropertySetProperty">
                <Key>USER</Key>
                <Value xsi:type="xs:string">tech</Value>
              </PropertySetProperty>
              <PropertySetProperty xsi:type="esri:PropertySetProperty">
                <Key>PASSWORD</Key>
                <Value xsi:type="xs:base64Binary">PuADAS7KKACvUT5djMUTw2sRnEhHAA==</Value>
              </PropertySetProperty>
              <PropertySetProperty xsi:type="esri:PropertySetProperty">
                <Key>VERSION</Key>
                <Value xsi:type="xs:string">sde.DEFAULT</Value>
              </PropertySetProperty>
            </PropertyArray>
          </ConnectionProperties>
        </WorkSpaceInfo>
      </Datasource>
    </Datasources>
  </Diagram>
</sch:Diagrams>

Related Topics


8/19/2013