Feature datasets in a geodatabase in SQL Server

Feature datasets are objects that allow you to group together related feature classes so they can participate in specific functionality. You would use a feature dataset to group feature classes that have the following characteristics:

Use the following links to read about different components of feature datasets in SQL Server:

TopologiesRelationship classesGeometric networksNetwork datasetsSchematic datasetsTerrain datasetsParcel fabrics

The following sections describe how a feature dataset would appear in the Catalog tree in ArcGIS for Desktop, in the database management system (DBMS), and in an XML document.

Feature datasets in ArcGIS for Desktop

In the Catalog tree, feature datasets are represented with the following icon:

Feature dataset icon

When the feature dataset is expanded in the Catalog tree, you can see all the feature classes and other data objects that are in it.

Expanded feature dataset in the Catalog tree

The name of a feature dataset in a geodatabase in Microsoft SQL Server contains the database name, the dataset owner's name, and the name of the feature dataset itself. This can be seen in the preceding graphic.

Feature datasets in a Microsoft SQL Server database

In the database, feature datasets are virtual collections of feature classes. They are grouped together by a common ID, which is maintained in the GDB_ITEMS system table.

For the Water feature dataset example, the feature class, Tanks, is identified as part of the Water feature dataset through the GDB_ITEMRELATIONSHIPS table. The UUID of the feature dataset is the ORIGINID, and the UUID of the feature class is the DESTID.

The following shows the Tanks feature class business table and the system tables that track the Water feature dataset in SQL Server:

Example feature dataset tables in SQL Server

Because feature datasets are virtual collections of objects, feature classes in feature datasets are just like stand-alone feature classes in that they have their own records in the tables associated with feature classes such as SDE_layers, SDE_table_registry, sde_geometry_columns, and SDE_column_registry. Since feature classes associated with feature datasets are database objects in their own right, they cannot have the same name as other tables or stand-alone feature classes in the same schema in the database.

TipTip:

See Feature classes in a geodatabase in SQL Server for a diagram of feature class relationships in the geodatabase.

Topologies, geometric networks, network datasets, parcel fabrics, schematic datasets, and terrain datasets are additional database objects that can be part of a feature dataset. These objects use additional system tables, which are described in separate topics.

Feature datasets in an XML document

Feature datasets are grouped under the DatasetDefinitions tag in an XML document and defined by a DataElement tag of type esri:DEFeatureDataset. The feature classes that are part of the feature dataset are listed as children data elements of the feature dataset. These element definitions are followed by a definition of the feature dataset itself. The XML document entry for the Water dataset would look like the following:

<DatasetDefinitions xsi: type="esri:ArrayOfDataElement">
 <DataElement xsi:type="esri:DEFeatureDataset">
 <CatalogPath>/V=dbo.DEFAULT/FD=mydgdb.MAP.Water</CatalogPath> 
 <Name>mydgdb.MAP.Water</Name>  
 <Children xsi:type="esri:ArrayOfDataElement">
    <DataElement xsi:type="esri:DEFeatureClass">
      <CatalogPath>/V=mydgdb.MAP.Water/RC=mydgdb.MAP.Anno_19_72</CatalogPath> 
      <Name>mydgdb.MAP.Anno_19_72</Name> 
      <DatasetType>esriDTFeatureClass</DatasetType> 
      <DSID>1</DSID> 
      <Versioned>false</Versioned> 
      <CanVersion>true</CanVersion> 
      <HasOID>false</HasOID> 
      <OIDFieldName/> 
    <Fields xsi:type="esri:Fields">
      <FieldArray xsi:type="esri:ArrayOfField">
    </Fields>

...all other child data elements...

</Children>
 <DatasetType>esriDTFeatureDataset</DatasetType>
 <DSID>-1</DSID>
 <Versioned>false</Versioned>
 <CanVersion>true</CanVersion>
 <ConfigurationKeyword></Configuration Keyword>
 <Extent xsi:type="esri:EnvelopeN">
   <XMin>2210083.8332546502</XMin>
   <YMin>386326.52300001681</YMin>
   <XMax>2223761.6047394276</XMax>
   <YMax>399843.09970059991</YMax>
   <SpatialReference xsi:type"esri:ProjectedCoordinateSystem">
   <WKT>PROJCS["NAD_1927_StatePlane_Colorado_North_FIPS_0501",
        GEOGCS["GCS_North_American_1927",DATUM["D_North_American_1927",
        SPHERIOD["Clarke_1866",6378206.4,294.9786982]],PRIMEM["Greenwich",0.0],
        UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],
        PARAMETER["False_Easting",2000000.0],PARAMETER["False_Northing",0.0],
        PARAMETER["Centeral_Meridian",-105.5],PARAMETER["Stnadard_parallel_1",39.71666666666667],
        PARAMETER["Standard_Parallel_2",40.78333333333333],
        PARAMETER["Latitude_Of_Origin",39.333333333334],
        UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",26753]]</WKT>
     <XOrigin>-119259500</XOrigin>
     <YOrigin>-96173400</YOrigin>
     <XYScale>37140179.758043662</XYScale>
     <ZOrigin>-100000</ZOrigin>
     <ZScale>10000</ZScale>
     <MOrigin>-100000</MOrigin>
     <MScale>10000</MScale>
     <XYTolerance>0.0032808333333333335</XYTolerance>
     <ZTolerance>0.001</ZTolerance>
     <MTolerance>0.001</MTolerance>
     <HighPrecision>true</HighPrecision>
     <WKID>26753</WKID>
   </SpatialReference>
  </Extent>
 </DataElement>
</DatasetDefinitions>
NoteNote:

Though the <Versioned> tag is set to false for the feature dataset, this does not reflect the versioned state of the feature classes in the feature dataset. To find this information, query each individual feature class in the feature dataset.

8/21/2013