HTMUA Asset Management System Database Dictionary

Potable Water System - Network Features

 

Dataset Name:	Water Network
Feature Types:	Lines
	Points
External Table Relations:	None

 

This dataset represents all water system pipes, polygons and services. Water mains are broken (and points present) at the following appurtenance types:

· Fitting (Tee, Bends, Cross, Dead End and Reducer)

· P R Station

· B P Station

· Intertie

· Tank

· Well

· System Valves (Gate, Butterfly and Tapping)

· Hydrant

· Control Valves (Air Release, Blow Off, Detector Check, Pressure Relief, Anti Back flow and Double Check)

· Blending Facility

· Back Flow Device

· Sampling Point

· Network Structure (Access Manhole, Pneumatic Tank and Treatment Plant)

· Meter (Domestic, Fire Service, Commercial, Irrigation and Land Scape)

 

 

 

 

The following appurtenance types do not break the associated water mains and are represented w.r.t. the symbol assigned to it:

Corrosion Test Station

Line Features

 

The structure of Line features including item definitions and attribute domains for Mainline and Lateral Line feature class is as follows:

 

Sl.No.	Description	Item Name	Type	Width
	Common Items
1	Internal Unique Number	ObjectID	ObjectID	4
2	GIS Facility ID	FacilityID	String	40
3	New Grid Number	NewGridNo	String	255
4	Old Grid Number	OldGridNo	String	255
5	Feature Type in Integer	Subtype	Long	4
6	Feature Type / Name in String	SubtypeName	String	50
7	Year of Installation	InstallYear	Long	4
8	Service Status	Status	String	15
9	Reference Source	Source	String	15
10	Pipe Owner	Owner	String	15
11	Source Number	Barcode	String	40
12	Pressure Zone for Pipe	PressureZone	String	40
13	Field Verification Code	FieldVerification	String	15
14	Pipe Diameter	Diameter	Double	8
15	Pipe Material	Material	String	255
16	Length of arcs	Shape_Length	Double	8
17	Length of Line	LineLength	Double	8
	Mainline
18	Offset Value	Offset	Double	8
19	Offset Reference	OffsetRef	String	255
20	Length of Line	Length	Double	8
21		Roughness	Double	8
	Lateral Line
22	Station Points	StationPt	String	25

 

Item Definitions

Common Items:

Point Features

 

The structure of Point features including item definitions and attribute domains for below listed feature class is as follows

 

· Fitting

· Intertie

· Tank

· P R Station

· System Valve

· Control Valve

· Hydrant

· Well

· B P Station

· Meter

· Blending Facility

· Network Structure

· Back Flow Device and

· Sampling Point

 

Sl.No.	Description	Item Name	Type	Width
	Common Items
1	Internal Unique Number	ObjectID	ObjectID	4
2	GIS Facility ID	FacilityID	String	40
3	New Grid Number	NewGridNo	String	255
4	Old Grid Number	OldGridNo	String	255
5	Feature Type in Integer	Subtype	Long	4
6	Feature Type / Name in String	SubtypeName	String	50
7	Year of Installation	InstallYear	Long	4
8	Service Status	Status	String	15
9	Reference Source	Source	String	15
10	Pipe Owner	Owner	String	15
11	Source Number	Barcode	String	40
12	Pressure Zone for Pipe	PressureZone	String	40
13	Field Verification Code	FieldVerification	String	15
14	Last exercised date	LastExercised	Date	8
15	Rotation Angle	Angle	Double	8
	Well
16	Facility Number	WellNo	String	25
17	Total Discharge	TotalDischarge	Long	4
18	Casing Size	CasingSize	Double	8
19	Feature Address	Address	String	10
20	Feature's City	City	String	15
21	Assessor Parcel Number	APN	String	255

Item Definitions

Common Items