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.

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