WATER NETWORKS
Status: Completed in January 1997
GENERAL DESCRIPTION
GIS data layers representing information such as water pipes, and facilities such as fire hydrants, gate valves, meterboxes, T-junctions, cross-junctions, reducers, blow-off valves, and end caps.
SOURCE/CONVERSION METHODOLOGY
This datalayer is developed by the Town’s GIS consulting firm, Camp Dresser and McKee, Inc. . CDM has used AutoCAD, ArcCAD and ARC/INFO software packages to convert the 110 coordinate plans from the Department of Public Works into ARC/INFO coverages with arc/node topology. Pipe segments are represented by arcs and facilities such as fire hydrants, gate valves, meterboxes, T-junctions, cross-junctions, reducers, blow-off valves, and end caps are represented by nodes to those arcs. After scrubbing all the paper documents, CDM registered each plan with acceptable RMS error standards to the digital landbase data from Boston Edison Company. Water system features were digitized in AutoCAD, and AutoCAD LISP routines were used to help with their placement and coding. About 10,000 images were scanned from the Water and Sewer Department’s service and valve books. They are linked to the water networks. QA/QC plots were generated for all 110 tiles and delivered to the Town for quality checking. Brookline GIS staff from the Information Services Department have compared all 110 check plots with the original workplans. A list of edits was generated and sent back to CDM for modification to the GIS data. They are incorporated into the final sewer/drain network data.
COVERAGE NAMES
WPIPES
W_EASE
FEATURE TYPES
The WPIPES coverage has feature type arc representing pipe segments and feature type node representing facilities.
The W_EASE coverage has polygon features representing various easement lines.
ATTRIBUTES
Arc: items wpipes.aat
| COLUMN | ITEM NAME | WIDTH | OUTPUT | TYPE* | N.DEC | ALTERNATE NAME | INDEXED? |
1 |
FNODE# | 4 |
5 |
B | - | - | |
5 |
TNODE# | 4 |
5 |
B | - | - | |
9 |
LPOLY# | 4 |
5 |
B | - | - | |
13 |
RPOLY# | 4 |
5 |
B | - | - | |
17 |
LENGTH | 8 |
18 |
F | 5 |
- | |
25 |
WPIPES# | 4 |
5 |
B | - | - | |
29 |
WPIPES-ID | 4 |
5 |
B | - | - | |
33 |
C_L_DATE | 4 |
4 |
C | - | - | |
37 |
MATERIAL | 10 |
10 |
C | - | - | |
47 |
STREET | 40 |
40 |
C | - | - | |
87 |
NOTES | 80 |
80 |
C | - | - | |
167 |
PZONE | 1 |
1 |
C | - | - | |
168 |
OWNER | 25 |
25 |
C | - | - | |
193 |
DIAMETER | 5 |
5 |
N | 1 |
- |
* See Appendix G for detail
Some WPIPES coverage AAT field descriptions:
Field DescriptionWPIPES_ID ARC/INFO inernal number assigned to each pipe segment
FNODE# Identification code of the from node
TNODE# Identification code of the to node
DIAMETER Pipe diameter of as listed in the work plans
C_L_DATE Cleaning and Lining dates for the pipes where they appear on the plans
MATERIAL Pipes material where listed on the workplans
LENGTH length of pipe calculated by ARC/INFO
OWNER Owner of the facility: Brookline, MDC, or MWRA
TILENUM Work plan tile that the facilities appears
Sample record from the WPIPES coverage arc attribute table:
Arc: list wpipes.aat
1
FNODE# = 172
TNODE# = 171
LPOLY# = 0
RPOLY# = 0
LENGTH = 4.97651
WPIPES# = 1
WPIPES-ID = 1
C_L_DATE =
MATERIAL =
STREET = LAWTON STREET
NOTES =
PZONE = L
OWNER = BROOKLINE
DIAMETER = 6.0
| COLUMN | ITEM NAME | WIDTH | OUTPUT | TYPE | N.DEC | ALTERNATE NAME | INDEXED? |
| 1 | ARC# | 4 | 5 | B | - | - | |
| 5 | WPIPES# | 4 | 5 | B | - | - | |
| 9 | WPIPES-ID | 4 | 5 | B | - | - | |
| 13 | NTYPE | 25 | 25 | C | - | - | |
| 38 | ROTATION | 10 | 10 | C | - | - | |
| 48 | TILENUM | 4 | 4 | C | - | - |
Field Description
NODE# ARC/INFO internal Node ID number
NTYPE** Type of facilities
TILENUM Workplan tile that the facility appears
OWNER Owner of the facility: Brookline, MDC, or MWRA
** Type of Node Facilities: Gate Valves, meter boxes, T-junctions, cross-junctions, reducers, blow-off valves, hydrants and end caps
Sample record from WPIPES coverage’s Node Attribute Table:Arc: list wpipes.nat
| Record | ARC# | WPIPES# | WPIPES-ID | NTYPE | ROTATION | TILENUM |
| 1 | 77 | 1 | 75 | END_CAP | 0 | 002 |
| 2 | 3887 | 2 | 7874 | HYDRANT | ||
| 3 | 3886 | 3 | 7873 | HYDRANT VALVE | ||
| 4 | 69 | 4 | 76 | HYDRANT JUNC | 166.33 | 002 |
| 5 | 78 | 5 | 3 |
COORDINATE SYSTEM
Massachusetts State Plane North America Datum (NAD) 83 Feet