SEWER/DRAIN NETWORKS
Status: Completed in January 1997
GENERAL DESCRIPTION
Sewer/drain lateral pipe lines, service lines, catchbasin connections, and facilities such as manholes, syphon chambers, catchbasins, and private pumping stations.
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 manholes, pumping stations, and syphon chambers are represented by nodes to those arcs in ARC/INFO format. After scrubbing all the paper documents, CDM registered each workplan with acceptable RMS error standards to the digital landbase data from Boston Edison Company. Sewer facilities and pipe segments were digitized in AutoCAD, and AutoCAD LISP routines were used to help with their placement and coding. Service connections were also digitized but onto a separate layer. Drains system catchbasins and associated connections were digitized as shown on the workplans. All annotation was placed on a separate text data layer. QA/QC plots were generated by CDM for all 110 tiles and delivered to the Town for quality checking. Brookline GIS staff from the Information Services Department and engineers from DPW have compared all 110 check plots to the original workplans. A list of edits was generated and sent back to CDM for modification. They now are all incorporated into the final sewer/drain networks.
COVERAGE NAMES
SPIPES
S_EASE
S_ANNO
SERVICE
CATCHBASIN
FEATURE TYPES
The SPIPES coverage has feature type arc representing pipe segments and feature type node representing facilities. The S_EASE coverage has polygon features representing various easement lines. The S_ANNO coverage has annotation feature representing various annotation. The SERVICE coverage has feature type arc representing the sewer and drain pipes connecting the residence.
The CATCHBASIN coverage has both arc and point feature types with arcs representing catchbasin feeder pipes and points representing catchbasin features.
ATTRIBUTES
Arc: items spipes.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 | 4 | 12 | F | 3 | - | |
| 21 | SPIPES# | 4 | 5 | B | - | - | |
| 25 | SPIPES_ID | 4 | 5 | B | - | - | |
| 29 | SD_PIPE_ID | 25 | 25 | C | - | - | |
| 54 | STREET | 40 | 40 | C | - | - | |
| 94 | IS_NODE_ID | 5 | 5 | C | - | - | |
| 99 | TILE_UP | 3 | 3 | C | - | - | |
| 102 | US_INVERT | 8 | 9 | F | 2 | - | |
| 110 | DS_NODE_ID | 5 | 5 | C | - | - | |
| 115 | TILE_DWN | 3 | 3 | C | - | - | |
| 118 | DS_INVERT | 8 | 9 | F | 2 | - | |
| 126 | DIMENSION1 | 8 | 9 | F | 2 | - | |
| 126 | DIMENSION2 | 8 | 9 | F | 2 | - | |
| 142 | COORD_LENG | 8 | 11 | F | 2 | - | |
| 150 | OWNDER | 25 | 25 | C | - | - | |
| 175 | MATERIAL | 8 | 8 | C | - | - | |
| 183 | NOTES | 50 | 50 | C | - | - |
* See Appendix G for detail
Some SPIPES coverage AAT field descriptions:
Field DescriptionSD_PIPES_ID Unique pipe identification code
US_NODE_ID Identification code of the upstream node
DS_NODE_ID Identification code of the downstream node
DIMENSION1 First dimension of a multi-dimensional pipe or the diameter of a single dimension pipe
DIMENSION2 Second dimension of a mullet-dimensional pipe
MATERIAL Pipes material where listed on the workplans
LENGTH length of pipe were listed on the workplans
OWNER Owner of the facility: Brookline, MDC, or MWRA
Sample record from the SPIPES coverage arc attribute table:
Arc: list spipes.aat
1
FNODE# = 3763
TNODE# = 3679
LPOLY# = 0
RPOLY# = 0
LENGTH = 315.679
SPIPES# = 1
SPIPES-ID = 1
SD_PIPE_ID = S003-042-S004-042
STREET = MIDDLESEX RD
TILE_UP = 42
US_INVERT = 0.00
DS_NODE_ID = S004
TILE_DWN = 42
DS_INVERT = 0.00
DIMENSION1 = 12.00
DIMENSION2 = 0.00
COORD_LENG = 318.58
OWNER = BROOKLINE
MATERIAL =
NOTES =
| COLUMN | ITEM NAME | WIDTH | OUTPUT | TYPE | N.DEC | ALTERNATE NAME | INDEXED? |
| 1 | ARC# | 4 | 5 | B | - | - | |
| 5 | SPIPES# | 4 | 5 | B | - | - | |
| 9 | SPIPES-ID | 4 | 5 | B | - | - | |
| 13 | TILE_NUM | 4 | 4 | C | - | - | |
| 17 | SD_NODE_ID | 10 | 10 | C | - | - | |
| 27 | STREET | 40 | 40 | C | - | - | |
| 67 | NTYPE | 2 | 2 | C | - | - | |
| 69 | INVERT_EL | 8 | 9 | F | 2 | - | |
| 77 | OWNER | 25 | 25 | C | - | - | |
| 102 | NOTES | 50 | 50 | C | - | - |
SD_NODE_ID** Unique identification code
NODE_TYPE Type of facilities
INVERT_EL Invert elevation for the manholes/syphon facilities
TILENUM Workplan tile that the facility appears
OWNER Owner of the facility: Brookline, MDC, or MWRA
** The SD_NODE_ID is in the following format, A###-???, where
A = Node Facility Type
S for sanitary manhole
D for stormwater manhole
C for combined manhole
Y for syphon chamber
P for pump stations
T for ties in’s
E for ends
### = Sequential number unique to a node within a workplan (tile)
??? = Workplan (tile) number
Sample record from SPIPES coverage’s Node Attribute Table:Arc: list spipes.nat
2
ARC# = 4309
SPIPES# = 2
SPIPES-ID = 5678
TILENUM = 2
SD_NODE_ID = S051-002
STREET = WINSLOW RD
NTYPE = S
INVERT_EL = 39.84
OWNER = BROOKLINE
NOTES =
COORDINATE SYSTEM
Massachusetts State Plane North America Datum (NAD) 83 Feet