Geometric networks in a geodatabase in SQL Server
Geometric networks are collections of line (edge) and point (junction) feature classes in a feature dataset that possess a connectivity relationship. Geometric networks are used to model infrastructure, such as electric utility lines and sewer systems.
The tables that are created with a network depend on whether there are turns present in the network.
Geometric networks in ArcGIS Desktop
In the Catalog tree, feature datasets that contain geometric networks look the same until you expand the dataset. Once the dataset is expanded, you see a geometric network represented with the following icon:
The name of a geometric network in a geodatabase in SQL Server contains the database name, the name of the owner of the geometric network, and the name of the geometric network itself.
For example, a geometric network, hydro2_gnet, owned by user RJP, in a geodatabase named gdb2 would be listed as gdb2.rjp.Hydro2_gnet in the Catalog tree.
When a geometric network is built, an orphan junction feature class is created inside the feature dataset. The name of this feature class is the name of the network followed by _Junctions.
Any errors that are encountered when the geometric network is created are placed in the build errors table, which you can also see in the Catalog. This table has is named <network_name>_BUILDERR. If there were errors when the water_net geometric network was built, a table named gdb2.rjp.WATER_NET_BUILDERR would be created in the geodatabase.
Geometric networks in a Microsoft SQL Server database
Geometric networks are tracked in the GDB_ITEMS table. The GDB_ITEMTYPES table stores a value indicating that the object is a geometric network. The GDB_ITEMRELATIONSHIPS table stores information on how the network and the feature dataset it is in are related.
In addition to these tables, networks are made up of a set of variably sized tables that is stored in the schema of the user who created the geometric network. The size of these tables depends on the size of the network—for example, the number of junctions and number of edges can affect the network size.
There are 9 fixed tables per network, and they are identified by the following naming convention: N_<ID>_<table_descriptor>, where ID represents a logical network ID, which is stored in the networks definition in the GDB_ITEMS table; for example, N_1_<table descriptor>, N_2_<table descriptor>.
The actual number of tables varies depending on what elements the network contains. A maximum of 21 tables could be created for a network with turns and weights.
All these tables are versioned when the network itself is versioned.
The following tables are always created: N_<ID>_Desc, N_<ID>_E<#>, n_estatus, N_<ID>_ETOPO, N_<ID>_FLODIR, N_<ID>_JDESC, N_<ID>_JSTATUS, N_<ID>_JTOPO, and N_<ID>_PROPS.
The N_<ID>_* tables can be viewed in the DBMS but should not be altered using SQL/third-party applications; doing so can corrupt the network.
N_<ID>_<>
Tables in the geodatabase that begin with N_ store information about networks.
N_<ID>_DESC
The N_<ID>_Desc table describes the elements of a network. This is a normalized table whose row count is equal to the number of junctions and the number of edges in a geometric network.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
OID |
integer |
The unique identifier of an element in a geometric network |
NOT NULL |
userclassid |
smallint |
The identifier of the feature class to which the element belongs |
NOT NULL |
userid |
integer |
The ObjectID of the feature |
NOT NULL |
usersubid |
integer |
The identifier of an element in a feature; only applicable to complex edge features |
NOT NULL |
elementtype |
smallint |
A code indicating the type of network element; either 1 = junction or 2 = edge |
NOT NULL |
EID |
integer |
The unique element identifier of the network element; only unique for the type of network element |
NOT NULL |
N_<ID>_PROPS
The N_<ID>_PROPS table contains a summary description of a network's properties, such as element counts and maximum EID values.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
propertyid |
integer |
The unique identifier of the network property |
NOT NULL |
propertyname |
nvarchar(32) |
The name of the property |
NOT NULL |
propertyvalue |
integer |
The value of the property |
NOT NULL |
All the remaining network tables contain the same field names and types. The table names and what they track are described below the table definition.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
OID |
integer |
The unique ID of the varbinarymax page in the table |
NOT NULL |
pagenumber |
integer |
The number of the varbinarymax page in the table |
NOT NULL |
pageblob |
varbinary(max) |
The description for the element the table is describing, such as edge and edge status |
- N_<ID>_E<#>—Describes network edge weights; # = 2, 3, 4, or 5
- N_<ID>_EDESC—Describes the edges in a network
- n_estatus—Describes the status of each edge including its deleted and disabled states
- N_<ID>_ETOPO—Describes the network edge topology or connectivity
- N_<ID>_FLODIR—Describes the network flow direction
- N_<ID>_J<#>—Describes network junction weights; # = 0 or 1
- N_<ID>_JDESC—Describes the network junctions
- N_<ID>_JSTATUS—Describes the status of each network junction including its deleted and disabled states
- N_<ID>_JTOPO—Describes the connectivity of junction elements with edge elements
- N_<ID>_JTOPO2—Describes the connectivity of junction elements with edge elements when there are multiple edges connected to a single junction
- N_<ID>_T<#>*—Describes the weight values of each turn element
- N_<ID>_TDEFN*—Defines each turn element by listing the edges and junctions that make up the turn
- N_<ID>_TDEFN2*—Overflow table for the turn element definition; for example, if multiple edges make up a turn
- N_<ID>_TDESC*—Describes the turns in a network
- N_<ID>_TSTATUS*—Describes the status of each network turn, including its deleted and disabled states
View a diagram of a geometric network in SQL Server.
Dashed lines indicate implicit relationships between columns.
You need Adobe Acrobat Reader to open the file.
For a description of the build errors table, see Network build errors table schema.
Geometric networks in an XML document
For a geometric network, the data element in an XML document is listed as type GeometricNetwork. The following is a portion of an XML document exported from a feature dataset containing a geometric network:
<DataElement xsi:type="esri:DEGeometricNetwork"> <CatalogPath>/V=sde.DEFAULT/FD=gdb2.RJP.hydro2/GN=gdb2.RJP.hydro2_gNet</CatalogPath> <Name>gdb2.RJP.hydro2_gNet</Name> <MetadataRetrieved>true</MetadataRetrieved> <Metadata xsi:type="esri:XmlPropertySet"> <XmlDoc><?xml version="1.0"?> <metadata xml:lang="en"><Esri><MetaID>{A4750260-72E0-4B84-9E59-A28ED020FBCF}</MetaID><CreaDate>20060530</CreaDate><CreaTime>14011400</CreaTime><SyncOnce>TRUE</SyncOnce></Esri></metadata></XmlDoc> </Metadata> <DatasetType>esriDTGeometricNetwork</DatasetType> <DSID>-1</DSID> <Versioned>false</Versioned> <CanVersion>true</CanVersion> <Extent xsi:type="esri:EnvelopeN" /> <SpatialReference xsi:type="esri:ProjectedCoordinateSystem"> <WKT>PROJCS["World_Mercator", GEOGCS["GCS_WGS_1984", DATUM["D_WGS_1984", SPHEROID["WGS_1984",6378137.0,298.257223563]], PRIMEM["Greenwich",0.0], UNIT["Degree",0.0174532925199433]], PROJECTION["Mercator"], PARAMETER["False_Easting",0.0], PARAMETER["False_Northing",0.0], PARAMETER["Central_Meridian",0.0], PARAMETER["Standard_Parallel_1",0.0], UNIT["Meter",1.0]]</WKT> <XOrigin>-147.84354555</XOrigin> <YOrigin>-0.843545550000002</YOrigin> <XYScale>160000000</XYScale> <ZOrigin>0</ZOrigin> <ZScale>1</ZScale> <MOrigin>0</MOrigin> <MScale>1</MScale> <XYTolerance>0.0002</XYTolerance> <ZTolerance>4.7683715798108E-03</ZTolerance> <MTolerance>2</MTolerance> <HighPrecision>true</HighPrecision> </SpatialReference> <NetworkType>esriNTUtilityNetwork</NetworkType> <OrphanJunctionFeatureClassName /> <FeatureClassNames xsi:type="esri:Names" /> <ConnectivityRules xsi:type="esri:ArrayOfConnectivityRule" /> <NetworkWeights xsi:type="esri:ArrayOfNetWeight" /> <WeightAssociations xsi:type="esri:ArrayOfNetWeightAssociation" /> </DataElement>