ArcFM Desktop > ArcFM > Water Tracing > 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.
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