Water Tracing Step 5: Add Fields

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.

NOTE: 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 Line 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 Line 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 Line 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 Line 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 Line 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 Line 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

 
QR code for this page

Was this helpful?