The following tables list the attributes of the water UN feature classes.
Some of these attributes are found in all categories: they are listed in the table below. Attributes that are filled in automatically are highlighted in gray. [0=Esri Domain, 1=CodedValue Domain]
Line |
Device |
Junction |
Boundary |
SubnetLine |
Assembly |
EdgeObject |
JunctionObject |
Field name |
Field type |
Localization |
Domain |
Description |
X |
X |
X |
X |
|
|
|
|
AbnormalCoveringHeight |
FLOAT |
CH |
|
Abnormal Covering height [m] |
X |
X |
X |
X |
|
|
X |
X |
AddressID |
TEXT, 255 |
Basic |
|
Address (Reference) |
X |
X |
X |
X |
|
|
X |
X |
AssetCatalogItem |
LONG |
Basic |
|
Asset catalog item |
X |
X |
X |
X |
|
|
X |
X |
AssetID |
TEXT, 80 |
Basic |
|
Asset ID |
X |
X |
X |
X |
|
X |
X |
X |
AssetName |
TEXT, 255 |
Basic |
|
Asset name |
X |
X |
X |
X |
|
|
X |
X |
AssetOwner |
SHORT |
Basic |
VGU_Organization (1) |
Asset owner |
X |
X |
X |
X |
|
X |
X |
X |
AssetText |
TEXT, 255 |
Basic |
|
Asset text |
X |
X |
X |
X |
|
X |
X |
X |
CommentGeneral |
TEXT, 255 |
Basic |
|
Comment |
X |
X |
X |
X |
X |
X |
X |
X |
created_date |
DATE |
Basic |
|
Created date |
X |
X |
X |
X |
X |
X |
X |
X |
created_user |
TEXT, 255 |
Basic |
|
Created user |
X |
X |
X |
X |
|
X |
X |
X |
DataOwner |
SHORT |
CH |
VGU_Organization (1) |
Data owner |
X |
X |
X |
X |
|
X |
X |
X |
DataProvider |
SHORT |
CH |
VGU_Organization (1) |
Data provider |
X |
X |
X |
X |
|
|
X |
X |
DetailLifeCycleStatus |
LONG |
Basic |
VGU_DetailLifeCycleStatus (1) |
DetailLifeCycleStatus |
X |
X |
X |
X |
X |
X |
X |
X |
Document_ref |
GUID |
Basic |
|
Document_ref |
|
X |
X |
|
|
|
|
|
Elevation |
DOUBLE |
Basic |
|
Elevation (m a.s.l.) |
X |
X |
X |
X |
|
|
X |
X |
FormerAssetName |
TEXT, 255 |
Basic |
|
Former Asset name |
X |
X |
X |
X |
X |
X |
X |
X |
last_edited_date |
DATE |
Basic |
|
Last edited date |
X |
X |
X |
X |
X |
X |
X |
X |
last_edited_user |
TEXT, 255 |
Basic |
|
Last edited user |
X |
|
|
|
|
|
|
|
Length_XY_calc |
DOUBLE |
Basic |
|
Calculated 2D length [m] |
X |
|
|
|
|
|
|
|
Length_XYZ_calc |
DOUBLE |
Basic |
|
Calculated 3D length [m] |
X |
|
|
|
|
|
|
|
Length_XYZ_effective |
DOUBLE |
Basic |
|
Effective 3D length [m] |
X |
X |
X |
X |
|
|
|
|
MaintenanceResponsible |
SHORT |
Basic |
VGU_Organization (1) |
Maintenance responsible |
|
X |
|
|
|
|
|
|
NET_CurrentPosition |
SHORT |
Basic |
VGU_DevicePosition (0) |
Current position |
X |
X |
X |
|
|
|
X |
X |
NET_Custom |
LONG |
Basic |
|
Net custom |
X |
X |
X |
X |
|
|
X |
X |
NET_MainLifeCycleStatus |
SHORT |
Basic |
VGU_MainLifeCycleStatus (0) |
Main life cycle status |
|
X |
|
|
|
|
|
|
NET_NormalPosition |
SHORT |
Basic |
VGU_DevicePosition (0) |
Normal position |
X |
X |
X |
|
|
|
X |
X |
NET_Trace |
LONG |
Basic |
|
Trace |
|
X |
X |
|
|
|
|
|
PosDeterm_XY_Method |
SHORT |
Basic |
VGU_PositionDetermination_XY_Method (1) |
XY position determination method |
|
X |
X |
|
|
|
|
|
PosDeterm_XY_Range |
DOUBLE |
Basic |
|
XY position determination range [m] |
X |
X |
X |
X |
|
|
|
|
PosDeterm_XY_Reliability |
SHORT |
Basic |
VGU_PositionDetermination_Reliability (0) |
XY position determination reliability |
|
X |
X |
|
|
|
|
|
PosDeterm_Z_Method |
SHORT |
Basic |
VGU_PositionDetermination_Z_Method (1) |
Z position determination method |
|
X |
X |
|
|
|
|
|
PosDeterm_Z_Range |
DOUBLE |
Basic |
|
Z position determination range [m] |
X |
X |
X |
X |
|
|
|
|
PosDeterm_Z_Reliability |
SHORT |
Basic |
VGU_PositionDetermination_Reliability (0) |
Z position determination reliability |
X |
X |
X |
X |
|
X |
X |
X |
SIA405_ID |
TEXT, 16 |
CH |
|
SIA ID |
|
X |
X |
|
|
X |
|
|
SYM_ROTATION |
DOUBLE |
Basic |
|
Symbol rotation |
X |
X |
X |
X |
|
X |
|
|
SYM_STYLE |
TEXT, 64 |
Basic |
|
Symbol style |
|
|
|
|
X |
|
|
|
TotalLength |
DOUBLE |
Basic |
|
Total length [m] |
|
|
|
|
X |
|
|
|
TotalServiceConnectionDevice |
LONG |
Basic |
|
Total service connections |
X |
X |
X |
X |
|
|
X |
X |
VG_CalculateArcade |
TEXT, 2048 |
Basic |
|
VG calculate Arcade |
The following attributes are specific to water.
Line |
Device |
Junction |
Boundary |
SubnetLine |
Assembly |
EdgeObject |
JunctionObject |
Field name |
Field ype |
Localization |
Domain |
Description |
|
X |
X |
|
|
|
|
|
AnodeAmount |
SHORT |
Basic |
|
Amount of Anodes |
X |
X |
X |
|
|
X |
X |
X |
AssetEntity |
LONG |
Basic |
WAT_AssemblyAssetEntityProduction (1), WAT_AssemblyAssetEntityPumpStation (1), WAT_AssemblyAssetEntityStation (1), WAT_AssemblyAssetEntityTransfer (1), WAT_DeviceAssetEntityFountain (1), WAT_DeviceAssetEntityTank (1), WAT_DeviceAssetEntityValve (1), WAT_DeviceFireDeviceHydrant (1), WAT_DeviceFireDeviceSprinkler (1), WAT_JunctionAssetEntitySensorUnit (1), WAT_JunctionAssetEntitySleeve (1), WAT_LineAssetEntityDistribution (1), WAT_LineAssetEntityService (1), WAT_LineAssetEntityTransmission (1) |
Asset type detail |
X |
|
|
|
|
|
|
|
Bedding |
SHORT |
CH |
VGU_Bedding (1) |
Bedding |
|
X |
X |
|
|
|
|
|
Bending |
TEXT, 10 |
CH |
|
Bending [°] |
|
X |
X |
|
|
|
|
|
CategoryLine |
SHORT |
Basic |
|
Line category |
|
X |
X |
|
|
|
|
|
CCP_Bonded |
SHORT |
Basic |
VGU_YesNo (1) |
CCP IsBonded |
|
X |
X |
|
|
|
|
|
CCP_InsulatedConnection |
SHORT |
Basic |
VGU_YesNo (1) |
CCP Is Insulated |
X |
|
|
|
|
|
|
|
CCPProtected |
SHORT |
CH |
VGU_CCPProtected (1) |
Cathodic protection |
|
X |
|
|
|
|
|
|
ClosingDirection |
SHORT |
Basic |
VGU_ClosingDirection (0) |
Closing direction |
|
X |
|
|
|
|
|
|
Coating |
TEXT, 40 |
CH |
|
Coating |
X |
X |
X |
|
|
X |
X |
X |
Concessionaire |
SHORT |
Basic, CH |
VGU_Organization (1) |
Concessionaire |
X |
X |
X |
|
|
|
X |
X |
ConditionGeneral |
SHORT |
Basic |
VGU_Condition (0) |
General Condition |
X |
|
X |
|
|
|
|
|
ConnectionType |
SHORT |
Basic, CH |
VGU_JunctionConnectionType (1), VGU_LineConnectionType (1) |
Connection type |
|
X |
X |
|
|
|
|
|
Consumption |
DOUBLE |
Basic |
|
Consumption [m3/y] |
X |
X |
X |
|
|
|
|
|
Diameter |
DOUBLE |
Basic |
|
Diameter [mm] |
|
X |
|
|
|
|
|
|
Emptying |
SHORT |
Basic |
VGU_YesNo (1) |
Emptying |
|
X |
|
|
|
|
|
|
ExtractionElevation |
DOUBLE |
Basic |
|
Elevation extraction [m] |
|
X |
|
|
|
X |
|
|
FireWaterReserve |
FLOAT |
Basic |
|
Fire water reserve [m3] |
|
X |
|
|
|
|
|
|
FlowPressure |
DOUBLE |
Basic |
|
Flow pressure [bar] |
X |
|
|
|
|
|
|
|
InsideCoating |
SHORT |
Basic |
WAT_LineInsideCoating (1) |
Inside coating |
X |
X |
X |
|
|
|
X |
X |
InstallationYear |
SHORT |
Basic |
|
Installation year |
X |
|
|
|
|
|
|
|
InternalDiameter |
DOUBLE |
Basic |
|
Internal diameter [mm] |
|
X |
X |
|
|
|
|
|
KoteAssumption |
DOUBLE |
Basic |
|
Kote Assumption |
|
X |
X |
|
|
|
|
|
KoteReferenceAltitude |
DOUBLE |
Basic |
|
Kote Altitude Reference |
|
X |
X |
|
|
|
|
|
KoteZ |
DOUBLE |
Basic |
|
Kote Z |
X |
|
|
|
|
|
|
|
LayingMethod |
SHORT |
CH |
VGU_LayingMethod (1) |
Laying method |
|
|
X |
|
|
|
|
|
Location |
TEXT, 50 |
CH |
|
Location |
X |
|
|
|
|
|
|
|
Maintenance |
TEXT, 30 |
Basic |
|
Maintenance |
|
|
|
|
|
X |
|
|
MaintenanceResponsible |
SHORT |
CH |
|
Maintenance responsible |
X |
X |
X |
|
|
|
X |
X |
Manufacturer |
TEXT, 50 |
CH |
|
Manufacturer |
|
X |
X |
|
|
|
|
|
ManufacturerModel |
TEXT, 10 |
CH |
|
Manufacturer model |
X |
X |
X |
|
|
|
|
|
Material |
SHORT |
Basic |
WAT_DeviceMaterial (1), WAT_JunctionMaterial (1), WAT_LineMaterial (1) |
Material |
X |
|
|
|
|
|
|
|
MaterialGroup |
SHORT |
Basic |
WAT_LineMaterialGroup (1) |
Material group |
|
|
|
|
X |
|
|
|
MaxPressure |
DOUBLE |
Basic |
|
Max. pressure [bar] |
|
|
X |
|
|
|
|
X |
Meter_ID |
LONG |
Basic |
|
Meter ID |
|
|
|
|
X |
|
|
|
MinPressure |
DOUBLE |
Basic |
|
Minimum pressure [bar] |
X |
X |
X |
|
|
|
|
|
NET_ConductElectricity |
LONG |
|
CCP_ConductElectricity (0) |
Conduct Electricity |
|
X |
|
|
|
|
|
|
NET_PressureIn |
DOUBLE |
Basic |
|
Pressure in [bar] |
|
X |
|
|
|
|
|
|
NET_PressureOut |
DOUBLE |
Basic |
|
Pressure out [bar] |
X |
X |
X |
|
|
|
X |
X |
NET_Quality |
SHORT |
Basic |
WAT_Quality (0) |
Quality |
X |
X |
X |
|
|
|
|
|
NominalDiameter |
DOUBLE |
Basic |
|
Nominal diameter |
X |
X |
X |
|
|
|
|
|
OperatingPressureMax |
DOUBLE |
Basic |
|
Max. operating pressure [bar] |
X |
X |
X |
|
|
|
X |
X |
Operator |
SHORT |
Basic |
VGU_Organization (1) |
Operator |
X |
|
|
|
|
|
|
|
OutsideCoating |
SHORT |
Basic |
WAT_LineOutsideCoating (1) |
Outside coating |
X |
|
|
|
|
|
|
|
OutsideDiameter |
DOUBLE |
Basic |
|
Outside diameter [mm] |
|
X |
|
|
|
|
|
|
PermissibleQuantity |
DOUBLE |
Basic |
|
Permissible quantity [l/min] |
|
X |
|
|
|
X |
|
|
Power |
TEXT, 30 |
Basic |
|
Power [m3/h] |
X |
|
|
|
|
|
|
|
RehabilitationProcedure |
SHORT |
CH |
VGU_RehabilitationProcedure (1) |
Rehabilitation procedure |
|
X |
X |
|
|
|
|
|
RemoteControlled |
SHORT |
Basic |
VGU_YesNo (1) |
Remote Controlled |
X |
|
|
|
|
|
|
|
Roughness |
FLOAT |
CH |
|
Roughness |
|
X |
|
|
|
X |
|
|
ServiceWaterReserve |
FLOAT |
Basic |
|
Service water reserve [m3] |
|
|
X |
|
|
|
|
|
SIA_EndElementType |
SHORT |
CH |
WAT_JunctionSIAEndElementType (1) |
End Element Type |
|
X |
|
|
|
|
|
|
SIA_FlowControlDeviceTypeInfo |
SHORT |
CH |
WAT_DeviceFlowControlDeviceTypeInfo (1) |
Flow Control Device Type Info |
|
X |
|
|
|
|
|
|
SIA_HydrantTypeInfo |
SHORT |
CH |
WAT_DeviceHydrantSIATypeInfo (1) |
Hydrant Type Info |
|
|
X |
|
|
|
|
|
SIA_SaddleType |
SHORT |
CH |
WAT_JunctionSIASaddleType (1) |
Saddle Type |
|
X |
|
|
|
|
|
|
SIA_ServiceConnectionType |
TEXT, 10 |
CH |
|
Service Connection Type |
|
|
X |
|
|
|
|
|
SIA_SleeveThrustProtection |
SHORT |
CH |
VGU_ThrustProtection (1), WAT_JunctionSIA_SleeveThrustProtection |
Sleeve Thrust Protection |
|
|
X |
|
|
|
|
|
SIA_SleeveType |
SHORT |
CH |
WAT_JunctionSIASleeveType |
Sleeve Type |
|
|
X |
|
|
|
|
|
SleeveThrustProtection |
SHORT |
Basic |
VGU_ThrustProtection (1) |
Sleeve Thrust Protection |
|
|
X |
|
|
|
|
|
SparkGap |
SHORT |
Basic |
CCP_JunctionSparkGap (0) |
Spark Gap |
|
X |
|
|
|
X |
|
|
SpillwayHeight |
FLOAT |
Basic |
|
Overflow height [m] |
|
X |
|
|
|
|
|
|
StaticPressure |
DOUBLE |
Basic |
|
StaticPressure [bar] |
|
X |
|
|
|
X |
|
|
StorageCapacity |
DOUBLE |
Basic |
|
Storage capacity [m3] |
|
X |
|
|
|
|
|
|
SubscriberID |
TEXT, 255 |
Basic |
|
Subscriber ID |
|
X |
|
|
|
|
|
|
SwitchDrive |
SHORT |
Basic |
VGU_SwitchDrive (1) |
Switch drive |
X |
|
|
|
|
|
|
|
ThrustProtection |
SHORT |
CH |
VGU_ThrustProtection (1) |
Shear protection |
In addition, simple feature classes and tables that are not part of the Utility Network core model are used in the model.
Table name |
Field name |
Field type |
Localization |
Domain |
Description |
WATDamageLocation |
AssetText |
TEXT, 255 |
CH |
|
Asset text |
WATDamageLocation |
CommentGeneral |
TEXT, 255 |
CH |
|
Comment |
WATDamageLocation |
DamageReason |
SHORT |
CH |
WAT_DamageLocationReason (1) |
Damage reason |
WATDamageLocation |
DamageType |
SHORT |
CH |
WAT_DamageLocationType (1) |
Damage type |
WATDamageLocation |
Line_ref |
GUID |
CH |
|
Pipe Global ID |
WATDamageLocation |
Originator |
SHORT |
CH |
VGU_Organization (1) |
Originator |
WATDamageLocation |
PosDeterm_XY_Method |
SHORT |
CH |
VGU_PositionDetermination_XY_Method (1) |
XY position determination method |
WATDamageLocation |
RemediationDate |
DATE |
CH |
|
Remediation date |
WATDamageLocation |
SurveyDate |
DATE |
CH |
|
Survey date |
