ArcGIS Server Banner

Schematic datasets in a geodatabase in PostgreSQL

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

NOTE: Requires ArcGIS Schematics extension

Schematic datasets are similar to feature datasets but 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.

Schematic datasets in ArcCatalog

The following is an example of a schematic dataset, schematic folders, and schematic diagrams in a PostgreSQL database as they appear in ArcCatalog:

Schematic dataset in ArcCatalog (PostgreSQL)

Top of page

Schematic datasets in a PostgreSQL DBMS

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

sch_dataset

The sch_dataset table contains one record for each schematic dataset. The id field in this table is used to identify the associated element and diagram tables.


Field name Field type Description
id integer Unique identifier of the schematic dataset

NOT NULL
major integer Release number of the dataset version; not used at this time

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 varchar(32) Name of the database in which the schematic dataset is stored
owner varchar(32) The user who created the schematic dataset
name varchar(128) The name of the schematic dataset

NOT NULL
extclsid varchar(38) Not currently in use
spatialref varchar(1024) Default spatial reference used when creating new diagrams
blobs bytea Stores the default parameters for the dataset, such as the default node symbol, text separator, and character

sch_release

The sch_release table is not currently in use.


Field name Field type Description
major integer Release number of the system tables; not used at this time

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 stores the unique identifier of a diagram type.


Field name Field type Description
id integer The unique identifier used when creating new diagram types for the object class

NOT NULL
dummy integer Not in use at this time

sch<id>_clsentry

The sch<id>_clsentry table stores the associations between the diagram types and the element types in a schematic dataset.


Field name Field type Description
id integer Uniquely identifies the relationship between a diagram type and element type

NOT NULL
diagramclassid integer Foreign key to the id field in the sch<id>_diaclass table

NOT NULL
elementclassid integer Foreign key to the id field in the sch<id>_eltclass table

NOT NULL

sch<id>_datasrc

The sch<id>_datasrc table contains a list of all the data sources accessed by the schematic dataset.


Field name Field type Description
id integer Uniquely identifies a data source

NOT NULL
name varchar(255) Name of the data source

NOT NULL
clsid varchar(38) Class iIDof the data source component

NOT NULL
label varchar(255) Not currently in use
connection bytea Parameters of the connection; used to persist and restore the connection

NOT NULL

sch<id>_diaclass

This table tracks all the diagram types present in a schematic dataset.


Field name Field type Description
id integer Uniquely identifies a diagram type

NOT NULL
objectclassid integer Foreign key to the id field in the sch_uniqueid table

NOT NULL
creationname varchar(255) Name of the diagram class when the table is created

NOT NULL
name varchar(255) Current name of the diagram class (if it was changed from the original name)

NOT NULL
parentid integer ID of the parent diagram class entry

NOT NULL
datasourceid integer Foreign key to the id field of sch<id>_datasrc
builderclsid varchar(38) Class ID for the schema builder (custom query, network dataset, or standard)

linkerclsid varchar(38) Component managing feature to element relationship method

algorithmclsid varchar(38) Class ID of the algorithm that is automatically applied to diagrams of this type

blobs bytea Stores all the attribute and symbology information

sch<id>_eltclass

This table maintains a list of all the element types for each dataset.


Field name Field type Description
id integer Uniquely identifies an element type

NOT NULL
objectclassid integer Foreign key to id in gdb_objectclasses table

NOT NULL
creationname varchar(255) Name of the element class when the table is created

NOT NULL
name varchar(255) Current name of the element class (if it changed)

NOT NULL
parentid integer Identifier of the parent element class entry

NOT NULL
elementtype integer Value specifying the type of element (node, link, et cetera)

NOT NULL
relationclsid varchar(38) Relationship to a feature class
associateddsid integer Data source ID of related feature class
associatedocid integer ID of the related feature classes from the gdb_objectclasses table
datasourceid integer Foreign key to the id field in the sch<id>_datasrc table
blobs bytea Stores attribute and symbology

sch<id>_folder

The sch<id>_folder table maintains a list of all the folders created in a dataset.


Field name Field type Description
id integer Unique identifier for the folder

NOT NULL
name character variety(255) Name of the folder

NOT NULL
pfid integer Identifier of the parent folder if nested

NOT NULL
xml bytea Stores the metadata of the folder

sch<id>a_<element_type_name>

This table tracks the associations between an element and a feature.


Field name Field type Description
id integer Uniquely identifies the association between an element and a feature

NOT NULL
schematicid integer Unique identifier for an element

NOT NULL
datasourceid integer Foreign key 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 Subtype ID of the related feature
ueid integer Enabled ID of the related feature

sch<id>d_<diagram_type_name>

This table 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 integer Uniquely identifies a diagram

NOT NULL
name varchar(255) Name of the diagram

NOT NULL
folderid integer Foreign key to the sch<id>_folder table

NOT NULL
diagramclassid integer Foreign key to sch<id>_diaclass table's objectclassid field

NOT NULL
lastupdate timestamp without time zone Date and time of last user update
version varchar(255) If generated from versioned data, lists which version

creationdate timestamp without time zone Date and time diagram was created
creator varchar(100) Name of the user that created the diagram
updatedby varchar(100) Name of the user that last updated the diagram
spatialref varchar(1024) Spatial coordinates
blobs bytea Stores the current positioning of all elements in the diagram

sch<id>e_<element_type_name>

This table 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 integer Uniquely identifies an element

NOT NULL
diagramclassid integer Foreign key to the sch<id>_diaclass table's objectclassid field

NOT NULL
diagramobjectid integer Foreign key to the sch<id>d_<diagram_type_name> table

NOT NULL
schematicid varchar(128) Uniquely identifies an element; consists of diagramobjectid, diagramclassid, datasourceid, ucid, uoid, and usid

NOT NULL
isinitial integer Indicates whether this element was part of the initial creation list

NOT NULL
isdisplayed integer Indicates whether this element is currently displayed

NOT NULL
relationobjectid integer ObjectID of related feature in relationship
relationclassid integer Class ID of related feature in relationship
datasourceid integer Foreign key to sch<id>_datasrc table
ucid integer Class ID of corresponding feature
uoid integer ObjectID of corresponding feature
usid integer Subtype ID of corresponding feature
ueid integer Enabled value of corresponding feature
subtype integer Subtype of feature
propertyset bytea Holds attribute information
initialx numeric(32,20) X positon of element when created
initialy numeric(32,20) Y position of element when created

sch<id>r_<diagram_type_name>

This table stores a list of all the relationship rules for a diagram type.


Field Name Field Type Description
id integer Uniquely identifies relationship rule

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 varchar(38) Class ID of the rule

NOT NULL
propertyset bytea Property page values

The following link takes you to a diagram of the tables involved in a schematic dataset.

PostgreSQL schematic dataset diagram

Schematic datasets in an XML workspace document

Exporting schematic datasets to XML is not presently supported.

Top of page

See Also

  • Feature datasets in a geodatabase in PostgreSQL