Press Alt + R to read the document text or Alt + P to download or print.
This document contains no pages.
HomeMy WebLinkAboutFirst on Main - GIS _BMPOverall Directions (Effective as of 4-19-2009)
(Please note that some sample data can be found in the top cells of the data as noted in parentheses and italicized.)
This spreadsheet is designed to be linked to the exported CAD files to provide accurate GIS information.
There are two cell formulas embedded into the structure sheet for your use to ease calculations.
Do not use ft or in symbols when filling out the tables
Do not rename any of the column headings
The sheet is set up to print multiple pages repeating top and/or left side columns as necessary.
These can be adjusted as required.
It is imperative that the structures and pipe runs be entered in the sheets in the same order.
BMP_Structure
STR_NU - Number from plan or As-Built data
ST_BMP_TY - Populate value from the BMP_Types tab
BMP_STR_TC - Top of Casting Elevation, numbers only I.E. 732.56
INV_1_OUT - The elevation of the invert outflow I.E. 725.73
Invert directions are calculated on 8 compass points
Invert 1 will be N, if there is a North, and progress in a clockwise fashion
In order N,NE,E,SE,S,SW,W,NW
In the event that 2 inverts share the same direction, the shallowest invert shall be listed first
In the event of a drop pipe, the shallowest invert shall be listed first
INV_1_IN - The inflow invert elevation per criteria listed above I.E. 726.75
INV_2_OUT - The outflow invert elevation per criteria listed above I.E. 727.22
INV_2_IN - The inflow invert elevation per criteria listed above I.E. 727.22
INV_3_OUT - The outflow invert elevation per criteria listed above I.E. 726.89
INV_3_IN - The inflow invert elevation per criteria listed above I.E. 726.89
BMP_Non_Structure
BMP_NON_ID - Populate value from the BMP_Types tab
SITE_DESIGN - Refer to any supporting design documentation material here, such as drainage report.
LOCATION - Use if additional information is required.
DESCRIPTION - Use if more detailed description is required.
MISC - Use if additional information is required.
PROJECT - Name of subdivision and section or other project name.
INST_DATE - Date the item was put in place.
SOURCE - Will be AS_BUILT
BMP_Types
This tab has a list of BMP types and the code to use on the associated structure and no structure tabs
Row
ex1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
STR_NU
(104)
10
ST_BMP_TY
A1
A2
A3
B1
B2
B3
B4
C1
C2
C3
D1
D2
D3
D4
D5
E1
E2
E3
F1
F2
F3
G1
H1
H2
(A1)
H2
BMP_STR_TC
(849.76)
836.94
INST_DATE
(MM/DD/YYYY)
BMP_OWNER
WPWD
PRIVATE
(WPWD)
PRIVATE
MANUFACTURE
AQUA-SHIELD
MODEL
AQUA-SWIRL XC-5
SERIAL_NU
INV_1_OUT
(829.76)
INV_1_IN
(829.96)
826.45
INV_2_OUT
826.45
INV_2_IN
INV_3_OUT
INV_3_IN
Row
ex1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
BMP_NON_ID
NSA1
NSA2
NSA3
NSA4
NSA5
NSA6
NSA7
NSB1
NSB2
NSC3
NSD1
NSD2
NSD3
NSE1
NSE2
NSE3
NSE4
NSF1
NSG1
(NSG1)
SITE_DESIG
(Drainage Report Number 1234)
LOCATION
(Bridgewater Lot 7)
DESCRIPTIO
(Behind Building)
MISC
(Northeast Corner)
PROJECT
(Bridgewater)
INST_DATE
(01-01-2008)
SOURCE
(AS_BUILT)
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
AS_BUILT
Structural BMPs
ST_BMP_TY
A
A1
A2
A3
B
B1
B2
B3
B4
C
C1
C2
C3
D
D1
D2
D3
D4
D5
E
E1
E2
E3
F
F1
F2
F3
G
G1
H
H1
H2
Site Design BMPs (Non-Structural)
BMP_NON_ID
NSA
NSA1
NSA2
NSA3
NSA4
NSA5
NSA6
NSA7
NSB
NSB1
NSB2
NSC
NSC3
NSD
NSD1
NSD2
NSD3
NSE
NSE1
NSE2
NSE3
NSE4
NSF
NSF1
NSG
NSG1
Source Control BMPs
§ Storm drain system stenciling and signage
§ Outdoor material and trash storage area designed to reduce or control rainfall runoff
§ Efficient irrigation system
Treatment Control BMPs
Biofilters
§ Grass swale
§ Grass strip
§ Wetland vegetation swale
§ Bioretention
Detention Basins
§ Extended/dry detention basin with grass lining
§ Extended/dry detention basin with impervious lining
§ Catch basin screens
Infiltration Basins
§ Infiltration basin
§ Infiltration trench
§ Porous asphalt
§ Porous concrete
§ Porous modular concrete block
Wet Ponds and Wetlands
§ Wet pond (permanent pool) without lining
§ Wet pond (permanent pool) with impervious lining
§ Constructed wetland
Drainage Inserts
§ Oil/Water separator
§ Catch basin insert
§ Storm drain inserts
Filtration Systems
§ Media filtration
Continuous Flow Deflect
§ Sand filtration ion/ Separation Systems
§ Swirl Concentrator
Minimizing Impervious Areas
§ Reduce sidewalk widths and incorporate landscaped buffer areas between
sidewalks and streets.
§ Design residential streets for the minimum required pavement widths
§ Minimize the number of residential street cul-de-sacs and incorporate landscaped
areas to reduce their impervious cover.
§ Use open space development that incorporates smaller lot sizes
§ Increase building density while decreasing the building footprint
§ Reduce overall lot imperviousness by promoting alternative driveway surfaces and
shared driveways that connect two or more homes together
§ Reduce overall imperviousness associated with parking lots by providing compact
car spaces, minimizing stall dimensions, incorporating efficient parking lanes, and
using pervious materials in spillover parking areas
Increase Rainfall Infiltration
§ Use permeable materials for private sidewalks, driveways, parking lots, and interior
roadway surfaces (examples: hybrid lots, parking groves, permeable overflow
parking, etc.)
§ Direct rooftop runoff to pervious areas such as yards, open channels, or vegetated
areas, and avoid routing rooftop runoff to the roadway or the urban runoff
conveyance system
Maximize Rainfall Interception
§ Maximizing canopy interception and water conservation by preserving existing
native trees and shrubs, and planting additional native or drought tolerant trees and
large shrubs.
Minimize Directly Connected Impervious Areas (DCIAs)
§ Draining rooftops into adjacent landscaping prior to discharging to the storm drain
§ Draining parking lots into landscape areas co-designed as biofiltration areas
§ Draining roads, sidewalks, and impervious trails into adjacent landscaping
Slope and Channel Protection
§ Use of natural drainage systems to the maximum extent practicable
§ Stabilized permanent channel crossings
§ Planting native or drought tolerant vegetation on slopes
§ Energy dissipaters, such as riprap, at the outlets of new storm drains, culverts,
conduits, or channels that enter unlined channels
Maximize Rainfall Interception
§ Foundation planting
Increase Rainfall Infiltration
§ Dry wells