ArcGIS Help 10.2 - Geometric networks in a geodatabase in Oracle

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 for 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:

Geometric network icon

The name of a geometric network in a geodatabase in Oracle contains 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 would be listed as 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 RJP.hydro2_gnet_BUILDERR would be created in the geodatabase.

Geometric networks in an Oracle 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_<ID>_ESTATUS, N_<ID>_ETOPO, N_<ID>_FLODIR, N_<ID>_JDESC, N_<ID>_JSTATUS, N_<ID>_JTOPO, and N_<ID>_PROPS.

Note:

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	NUMBER(38)	The unique identifier of an element in a geometric network	NOT NULL
USERCLASSID	NUMBER(4)	The identifier of the feature class to which the element belongs	NOT NULL
USERID	NUMBER(38)	The ObjectID of the feature	NOT NULL
USERSUBID	NUMBER(38)	The identifier of an element in a feature; only applicable to complex edge features	NOT NULL
ELEMENTTYPE	NUMBER(4)	A code indicating the type of network element; either 1 = junction or 2 = edge	NOT NULL
EID	NUMBER(38)	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	NUMBER(38)	The unique identifier of the network property	NOT NULL
PROPERTYNAME	NVARCHAR2(32)	The name of the property	NOT NULL
PROPERTYVALUE	NUMBER(38)	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	NUMBER(38)	The unique identifier of the BLOB page in the table	NOT NULL
PAGENUMBER	NUMBER(38)	The number of the BLOB page in the table	NOT NULL
PAGEBLOB	BLOB	The actual BLOB page, which contains a 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_<ID>_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 Oracle.

Dashed lines indicate implicit relationships between columns.

Note:

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=sde.RJP.hydro2/GN=sde.RJP.hydro2_gNet</CatalogPath> 
  <Name>sde.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>

Geometric networks in a geodatabase in Oracle

Geometric networks in ArcGIS for Desktop

Geometric networks in an Oracle database

Geometric networks in an XML document

Related Topics