Loading...
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