ArcFM Desktop Configuration Guide
Water Tracing Step 5: Add Fields

Resource Center Home

You may need to add fields to the following feature classes. You may use any names for your fields. The names shown are those used in the sample data.

The CPSystemObjectID field acts as the foreign key of the CPSystemStatus table.

 wClear Well

This feature class isn't currently used by water tracing. However, it is part of the network and requires the WaterTraceWeight field.

 

Field

Data Type

WaterTraceWeight

long integer

 

wControl Valve

Field

Data Type

Domain

BondedIndicator

text (length=5)

Yes/No Indicator

CPSystemStatus

long integer

CPSystemStatus

EmerIsolationSysStatus

text (length=20)

 

InsulatedIndicator

text (length=5)

Yes/No Indicator

Material

text (length=5)

Water Material

NormalPosition

long integer

Normal Position

OperatingClassification

text (length=5)

Operating Classification

Status

text (length=5)

Station Status

WaterPressureSystemStatus

text (length=20)

GasWaterSystemStatus - String

WaterSystemStatus

text (length=20)

GasWaterSystemStatus - String

WaterTraceWeight

long integer

 

 

wFitting

Field

Data Type

Domain

BondedIndicator

text (length=5)

Yes/No Indicator

CPSystemStatus

long integer

CPSystemStatus

EmerIsolationSysStatus

text (length=20)

 

InsulatedIndicator

text (length=5)

Yes/No Indicator

Material

text (length=5)

Water Material

NormalPosition

long integer

Normal Position

WaterPressureSystemStatus

text (length=20)

GasWaterSystemStatus - String

WaterSystemStatus

text (length=20)

GasWaterSystemStatus - String

WaterTraceWeight

long integer

 

 

wGravity Pressure Main

Field

Data Type

Domain

BondedIndicator

text (length=20)

Yes/No Indicator

CPSystemObjectID

long integer

 

CPSystemStatus

long integer

CPSystemStatus

InsulatedIndicator

text (length=5)

Yes/No Indicator

Material

text (length=5)

Water Material

MeasuredLength

double

 

PipeStatusIndicator

long integer

Normal Position

PipeType

text (length=50)

Pipe Type

OperatingPressure

double

 

Status

text (length=5)

Station Status

WaterTraceWeight

long integer

 

 

wHydrant

This feature class isn't currently used by water tracing. However, it is part of the network and requires the WaterTraceWeight field.

 

Field

Data Type

WaterTraceWeight

long integer

 

wLateral Point

This feature class isn't currently used by water tracing. However, it is part of the network and requires the WaterTraceWeight field.

 

Field

Data Type

WaterTraceWeight

long integer

 

wLateral Service

Field

Data Type

Domain

BondedIndicator

text (length=5)

Yes/No Indicator

CPSystemObjectID

long integer

 

CPSystemStatus

long integer

CPSystemStatus

InsulatedIndicator

text (length=5)

Yes/No Indicator

Material

text (length=5)

Water Material

MeasuredLength

double

 

OperatingPressure

double

 

Status

text (length=5)

Station Status

WaterTraceWeight

long integer

 

 

wManhole

This feature class isn't currently used by water tracing. However, it is part of the network and requires the WaterTraceWeight field.

 

Field

Data Type

WaterTraceWeight

long integer

 

wMeter

This feature class isn't currently used by water tracing. However, it is part of the network and requires the WaterTraceWeight field.

 

Field

Data Type

WaterTraceWeight

long integer

 

wNetwork Structure

Field

Data Type

Domain

EmerIsolationSysStatus

text (length=20)

 

Status

text (length=5)

Station Status

WaterPressureSystemStatus

text (length=20)

GasWaterSystemStatus - String

WaterSystemStatus

text (length=20)

GasWaterSystemStatus - String

WaterTraceWeight

long integer

 

 

wPump

This feature class isn't currently used by water tracing. However, it is part of the network and requires the WaterTraceWeight field.

 

Field

Data Type

WaterTraceWeight

long integer

 

wPumpPressureMain

Field

Data Type

Domain

BondedIndicator

text (length=5)

Yes/No Indicator

CPSystemObjectID

long integer

 

CPSystemStatus

long integer

CPSystemStatus

InsulatedIndicator

text (length=5)

Yes/No Indicator

Material

text (length=5)

Water Material

MeasuredLength

double

 

OperatingPressure

double

 

PipeStatusIndicator

long integer

Normal Position

PipeType

text (length=5)

Pipe Type

Status

text (length=5)

Station Status

WaterTraceWeight

long integer

 

 

wPumpStation

You may create a feature class that acts as a pressure system barrier. You may also choose to use an existing feature class to serve as a barrier (e.g., Pump). The feature class must contain the following fields with the listed data type.

 

Field

Data Type

Domain

CPSystemStatus

long integer

CPSystemStatus

EmerIsolationStatus

text (length=20)

 

InletPressure

long integer

 

OutletPressure

long integer

 

WaterPressureSystemStatus

text (length=20)

GasWaterSystemStatus - String

WaterSystemStatus

text (length=20)

GasWaterSystemStatus - String

WaterTraceWeight

long integer

 

 

wSampling Station

This feature class isn't currently used by water tracing. However, it is part of the network and requires the WaterTraceWeight field.

 

Field

Data Type

WaterTraceWeight

long integer

 

wSystem Valve

Field

Data Type

Domain

BondedIndicator

text (length=5)

Yes/No Indicator

CPSystemStatus

long integer

CPSystemStatus

EmerIsolationSysStatus

text (length=20)

 

InsulatedIndicator

text (length=5)

Yes/No Indicator

Material

text (length=5)

Water Material

NormalPosition

long integer

Normal Position

OperatingClassification

text (length=5)

Operating Classification

Status

text (length=5)

Station Status

WaterPressureSystemStatus

text (length=20)

GasWaterSystemStatus - String

WaterSystemStatus

text (length=20)

GasWaterSystemStatus - String

WaterTraceWeight

long integer

 

 

 

 


Send Comment to ArcFMdocumentation@schneider-electric.com