Hydrants

GIS File Name

INFRA_Hydrants

Description

Fire Hydrants are maintained by the Engineering group at the Cambridge Water Department, Hydrants are also monitored by Cambridge Fire Department. Used for public safety, mapping, and water distribution.

Purpose

Fire Hydrants within the City of Cambridge

Download Layer Data

Last Modified

12-19-2023

Attributes

Name Type Details Description
ANCILLARYROLE type: SmallInteger
width: 2
precision: 5
Ancillary role for hydrant.

Values

Value Description
0 None
1 Source
2 Sink
ENABLED type: SmallInteger
width: 2
precision: 5
Enabled?

Values

Value Description
0 False
1 True
INSTALLDATE type: Date
width: 8
precision: 0
Installation date.
ROTATION type: Double
width: 8
precision: 38
Annotation rotation value.
LIFECYCLESTATUS type: String
width: 20
precision: 0
Lifecycle status.

Values

Value Description
ACT Active
ABN Abandoned
PROP Proposed
MITFL MIT Fire Loop
SUBTYPE type: Integer
width: 4
precision: 10
Subtype.

Values

Value Description
1 GateHydrant
2 NonGateHydrant
LASTEDITOR type: String
width: 20
precision: 0
Last editor.
LASTEDITDATE type: Date
width: 8
precision: 0
Last edit date.
LASTSOURCE type: String
width: 20
precision: 0
Last edit source.
HYDRANT_ID type: String
width: 30
precision: 0
Unique hydrant ID.
GATE type: SmallInteger
width: 2
precision: 5
Gate?

Values

Value Description
0 False
1 True
CONTRACTAUTHORITY type: String
width: 50
precision: 0
Contract authority

Values

Value Description
MWRA MWRA
CAM City
PRI Private
HVDU Harvard
MIT MIT
UNK Unknown
HYDRANT_GPM type: Double
width: 8
precision: 8
Gallons per minute.
NOTES type: String
width: 255
precision: 0
Notes.
HYDRANT_LOCATION type: String
width: 100
precision: 0
HYDRANT_MANF type: String
width: 50
precision: 0
HYDRANT_COLOR type: String
width: 25
precision: 0
HYDRANT_OWNER type: String
width: 50
precision: 0
SWEEPER_HYDRANT type: String
width: 1
precision: 0
HYDRANT_DRAIN type: String
width: 20
precision: 0
LAST_DATE_TESTED type: Date
width: 8
precision: 0
COMMENTS type: String
width: 255
precision: 0
CREATED_USER type: String
width: 255
precision: 0
CREATED_DATE type: Date
width: 8
precision: 0
LAST_EDITED_USER type: String
width: 255
precision: 0
LAST_EDITED_DATE type: Date
width: 8
precision: 0

Coordinate System

NAD 1983 StatePlane Massachusetts Mainland FIPS 2001 Feet