Loading...
HomeMy WebLinkAboutStorm Water GIS As-Built Submittal Tables 8.29.22Overall Directions (Please note that some sample data can be found in the top cells of the data as noted in parentheses and italicized.) Do not use feet, inches or percent symbols when filling out the tables Do not rename any of the column headings It is imperative that the structures and pipe runs be entered in the sheets in the same order. Storm_Structure Storm Structure Number (STR_NU) - This is the unique identifer number information that will match the attribute number in CAD Structure Type (STR_TYPE) - Manhole, Curb Inlet, Beehive Inlet, End Section, Yard Inlet, Catch Basin, etc Structure Material (STR_MAT) Material of storm structure. (Concrete, Brick, etc.) Top of Casting (TC_ELEV) - Elevation at the rim or top of casting Casting Type (CAST_TYPE) - Neenah R-3501-TR, East Jordan 7495M1, etc. Shape of Structure (STR_SHAPE) - Eliptical, Square, Rectangular, Round, etc. Invert of Sump (SUMP_INV) - Enter the invert elevation of the sump Owner (Owner) - Ownership of structures Appenditure (Appenditure) - Additional appenditure on storm water structure. If none present mark field as 'none'. Outfall (Outfall) - If structure is storm water outfall. Mark 'Y' or 'N' Number of Inverts (NUM_INVERT) - Enter the number of inverts This sheet is set up to handle a maximum of 8 inverts into a structure 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 It is suggested that pipe runs be separated by a blank row Structures may need to appear more than once if they are common to more than one profile (just copy the information as needed) As an example, str 104 is in the main profile and also the furthest downstream structure in a secondary run (this is usually the case when there are more than 3 inverts) The Top of casting for end sections should be shown as NA Storm_Pipe Pipe runs must be listed in the same order as the structures including skipped lines Sheet must be filled out going from upstream to downstream Up stream structure ID (UPS_STR_ID) - This is the unique ID of the structure upstream Down stream structure ID (DOW_STR_ID) - This is the unique ID of the structure downstream Slope (SLOPE) - The slope of the pipe. Diameter (Diameter) - This is the size or diameter of the pipe. Structure Shape (STR_SHAPE) - This is the shape of the structure: eliptical, square, rectangular, round, etc. Pipe Length (PIPE_LEN) - This is the length of the pipe. Material (MATERIAL) - RCP, PVC, HDPE, CMP, Concrete Length of Granular Backfill (BACKFILL) - length of the granular backfill Owner (Owner) - Ownership of structures Sub-Surface Drain (SSD) - If storm water pipe functions as sub-surface drain Culvert (Culvert) - If storm water pipe is culvert drain Average Depth (AVE_DEPTH) - the average depth of the storm pipe. Up stream Invert (UPSTRM_INV) - This is the invert of the structure upstream Down stream invert (DNSTRM_INV) - This is the inver of the structure downstream Note: The formula for the ave. depth will have to be adjusted slightly for each pipe run. Impervious Surface Project - Name of subdivision and section or other project name. INST_DATE - Date the impervious surface was installed. Format will be MM/DD/YYYY. If month or day is unknown, use 01. Field can be left blank if unknown SQ_FT - Total area in square feet of impervious surface installed Project Type (ProjectType) - If project is residential or non-residential BMP_Structure STR_NU - Number from plan or As-Built data BMP_TYPE- type of BMP Structure (Water Quality Unit, Inlet Insert, Tree Box, etc.) MODEL_NAME - Model name of BMP structure (i.e. Aquaswirl, Stormceptor, etc.) MODEL NUMBER - Model Number of BMP structure if applicable INST_DATE- date the BMP was installed ORIENTATION - If BMP structure lies upon storm water main or off storm water main line DIVERSION - If BMP diverts flow off storm water main WEIR - If weir was installed with BMP structure WEIR HEIGHT - Height of weir structure (if applicable) UNIT NAME - SUMP - Is a sump present CAPACITY - Capacity of the BMP structure BMP_OWNER- responsible party for BMP (Private, Municipal, County) TC_ELEV - 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 Ponds BASIN - HUC Code corresponding to what drainage basin pond falls within Normal Pool Elevation (POOL_NORMAL) - Normal pool elevation of pond 100 Year Pool Elevation (POOL_100YR) - 100 year event elevation of pond Bottom Elevation (BOTTOM_ELEVATION) - Bottom elevation of pond Type (Type) - Type of pond. (Wet, Dry, Underground) BMP (BMP) - Does pond function as BMP BMP Type (BMP_Type) - If pond functions as BMP type must be provided Open Conveyance Upstream inversion (UPS_STR_INV) - Upstream invert elevation of conveyance Downstream inversion (DOW_STR_INV) - Downstream invert elevation of conveyance Slope (SLOPE) - The slope of the conveyance. Bottom Width (BOTTOM_WIDTH) - Bottom width of conveyance (in feet) Top Width (TOP_WIDTH) - Top width of conveyance (in feet) Length (LENGTH) - Length of conveyance Material (MATERIAL) - Material that makes up conveyance Location (LOCATION) - Ownership of conveyance Easement Width (EASEMENT_WIDTH) - Width of easement associated with conveyance Type (TYPE) - Type of conveyance BMP Signage Sign Text - Text of what is displayed on sign BMP Protected - Type of BMP sign is protecting Basin Type - Type of BMP basin Row 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 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 STR_NU 1 2 3 4 5 16 15 14 13 11 10 9 8 7 6 22 21 20 32 31 30 29 28 27 26 25 24 23 35 34 33 38 37 36 39 39A 45 44 43 42A 42 41 46 47 49 48 52 51 53A 53B 8052 8025 18008 18007 18002 18003 18004 STR_TYPE CATCH BASIN CATCH BASIN CURB INLET CURB INLET MANHOLE MANHOLE CURB INLET CURB INLET CURB INLET MANHOLE CURB INLET CURB INLET MANHOLE CURB INLET CURB INLET MANHOLE CURB INLET CURB INLET MANHOLE CURB INLET CURB INLET CURB INLET MANHOLE CURB INLET CURB INLET MANHOLE CURB INLET CURB INLET MANHOLE CURB INLET CURB INLET MANHOLE CURB INLET CURB INLET MANHOLE MANHOLE MANHOLE CURB INLET CURB INLET MANHOLE CURB INLET CATCH BASIN MANHOLE CURB INLET MANHOLE CATCH BASIN MANHOLE CURB INLET MANHOLE MANHOLE CURB INLET CURB INLET CURB INLET CURB INLET MANHOLE MANHOLE MANHOLE STR_MAT CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CONCRETE CAST_TYPE R-4215-C R-4215-C R-3501-TB R-3501-TL R-1714 R-1714 R-3501 R-3501 R-3501 R-1714 R-3501-TR R-3501-TL R-1714 R-3501-TR R-3501-TL R-1714 R-3501 R-3501 R-1714 R-3287-15 R-3287-15 R-3287-15 R-1714 R-3501-TR R-3501-TL R-1714 R-3501-TR R-3501-TL R-1714 R-3287-10V R-3287-10V R-1714 R-3287-10V R-3287-10V R-1714 R-1714 R-1714 R-3287-10V R-3287-10V R-1714 R-3287-10V R-4215-C R-1714 R-3287-10V R-1714 R-4215-C R-1714 R-3287-10V R-1714 R-1714 R-3501 R-3502 R-3502 R-3502 R-1714 R-1714 R-1714 STR_SHAPE SQUARE SQUARE RECTANGULAR RECTANGULAR ROUND ROUND RECTANGULAR RECTANGULAR RECTANGULAR ROUND RECTANGULAR RECTANGULAR ROUND RECTANGULAR RECTANGULAR ROUND RECTANGULAR RECTANGULAR ROUND RECTANGULAR RECTANGULAR RECTANGULAR ROUND RECTANGULAR RECTANGULAR ROUND RECTANGULAR RECTANGULAR ROUND RECTANGULAR RECTANGULAR ROUND RECTANGULAR RECTANGULAR ROUND ROUND ROUND RECTANGULAR RECTANGULAR ROUND RECTANGULAR SQUARE ROUND RECTANGULAR ROUND SQUARE ROUND RECTANGULAR ROUND ROUND RECTANGULAR RECTANGULAR RECTANGULAR RECTANGULAR ROUND ROUND ROUND OWNER Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal Municpal APPENDITURE None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None None Outfall N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N SUMP_INV - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - TC_ELEV 838.65 838.23 838.24 838.32 839.39 839.00 837.79 837.53 837.39 839.87 839.48 839.52 841.67 840.83 840.78 837.35 836.74 836.54 837.07 835.87 835.80 835.96 837.11 836.35 836.26 837.28 837.13 837.00 836.79 836.04 836.22 837.05 836.25 836.46 837.26 837.28 837.73 836.72 836.81 838.22 836.88 836.97 838.07 837.2 836.97 836.67 835.57 834.84 835.12 834.95 838.38 836.27 836.56 834.81 834.94 834.98 834.13 NUM_INVERT 1 3 2 2 2 3 2 2 2 3 2 1 2 2 1 3 2 1 3 2 3 1 3 2 1 2 2 1 3 2 1 3 2 1 3 2 4 2 1 2 2 1 2 2 3 1 3 1 3 3 1 1 - - - - - I1_ELEV 835.06 834.01 833.34 833.29 833.29 828.45 828.59 829.25 832.31 835.46 834.76 835.88 837.30 837.38 837.47 828.46 831.65 832.60 828.85 831.87 832.25 833.01 832.47 832.51 833.17 833.08 833.16 833.74 828.69 831.55 832.10 829.00 832.23 832.74 832.21 826.41 830.00 829.96 834.30 830.27 836.88 834.13 826.25 826.05 825.59 830.23 823.19 830.93 823.04 822.76 837.01 832.91 - - - - - I1_DIR E E S N N N N E N N E E S E E N N S N N N E N E E S E E N N S N N S N NE NE SE SE SW N S E S N E SE E S SE N N - - - - - I1_DIA 12 15 15 15 15 15 15 15 12 12 12 12 12 12 12 12 12 12 15 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 8 30 12 12 12 12 12 12 36 36 36 12 36 12 12 36 8 8 - - - - - I1_MAT RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP - - - - - I2_ELEV 837.01 833.39 833.29 833.29 828.43 828.48 828.75 829.68 834.69 835.80 837.30 837.38 826.66 828.89 827.36 829.54 832.25 832.42 832.92 833.08 833.52 827.10 828.79 826.75 829.45 826.55 826.51 826.39 832.82 830.42 830.62 826.25 826.06 824.48 830.37 823.55 820.55 I2_DIR S W S E E S S W S W W W E S E S S S W W W E S E S NE SW SE NW W E NW W S SW SE S I2_DIA 8 15 15 15 30 15 15 12 12 12 12 12 30 12 30 15 12 12 12 12 12 30 12 30 12 30 30 36 12 12 12 36 36 36 12 36 12 I2_MAT RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP I3_ELEV 834.42 832.88 834.69 827.82 827.33 832.57 832.42 827.15 826.81 826.63 826.39 829.38 823.21 823.07 823.51 I3_DIR W W W W W W W W W W SW W NW NW NW I3_DIA 12 15 12 30 30 12 12 30 30 30 30 12 36 36 36 I3_MAT RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP I4_ELEV 829.63 I4_DIR NW I4_DIA 12 I4_MAT RCP I5_ELEV I5_DIR I5_DIA I5_MAT I6_ELEV I6_DIR I6_DIA I6_MAT I7_ELEV I7_DIR I7_DIA I7_MAT I8_ELEV I8_DIR I8_DIA I8_MAT Row 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 UPS_STR_ID 1 2 3 4 5 15 14 13 16 21 20 9 10 6 7 22 31 8 11 29 30 26 27 28 23 24 25 32 34 33 35 37 36 38 39 39A 43 44 42A 42 41 45 46 47 49 52 53A 53B 51 18009 53A 53B 8052 8025 DOW_STR_ID 2 3 4 5 16 16 15 14 22 22 21 10 11 7 8 32 32 11 13 30 31 27 28 30 24 25 28 35 35 34 38 38 37 39 39A 45 44 45 45 42A 42 46 47 49 52 53A 53B 18005 52 49 18002 18004 2 39 SLOPE 1.88% 1.32% 0.22% 0.00% 0.35% 0.25% 0.47% 0.96% 0.28% 3.31% 4.13% 0.31% 0.70% 0.39% 0.89% 0.21% 6.27% 1.34% 1.60% 0.90% 1.06% 1.04% 1.13% 0.22% 0.76% 1.60% 0.39% 0.19% 0.83% 2.20% 0.31% 3.00% 1.96% 0.23% 0.07% 0.04% 5.92% 3.00% 0.38% 1.54% 0.18% 0.09% 0.21% 0.98% 0.30% 0.36% 0.11% 5.60% 0.0706 24.90% 20.09% 0.50% 5.83% DIAMETER 12 15 15 15 15 15 15 15 30 12 12 12 12 12 12 30 15 12 12 12 12 12 12 12 12 12 12 30 12 12 30 12 12 30 30 30 12 12 12 12 12 36 36 36 36 36 36 36 12 12 12 12 8 8 STR_SHAPE ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND ROUND PIPE_LEN 34 47 23 7 116 12 34 45 217 13 23 23 10 23 9 159 11 137 149 49 36 24 8 77 29 5 158 108 12 25 95 15 26 52 59 54 25 11 71 13 38 145 91 47 40 11 35 10 12 10 11 14 12 MATERIAL RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP RCP OWNER Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal Municipal SSD N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N Culvert N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N BACKFILL AVE_DEPTH UPSTRM_INV 835.06 834.01 833.34 833.29 833.29 828.48 828.75 829.68 828.43 828.89 832.60 835.88 834.76 837.47 837.38 827.66 829.54 837.30 834.69 833.01 832.25 833.17 832.51 832.42 833.74 833.16 833.08 827.36 828.79 832.10 827.10 829.45 832.74 826.75 826.55 826.41 834.30 829.96 830.27 830.62 834.13 826.39 826.25 826.05 823.19 823.55 822.76 830.93 830.23 823.04 822.76 837.08 832.91 DNSTRM_INV 834.42 833.39 833.29 833.29 832.88 828.45 828.59 829.25 827.82 828.46 831.65 835.80 834.69 837.38 837.30 827.33 828.85 835.46 832.31 832.57 831.87 832.92 832.42 832.25 833.52 833.08 832.47 827.15 828.69 831.55 826.81 829.00 832.23 826.63 826.51 826.39 832.82 829.63 830.00 830.42 834.06 826.25 826.06 825.59 823.07 823.51 822.72 830.37 829.38 820.55 820.55 837.01 832.21 PROJECT_NAME The Woods at Lions Creek INST_DATE (MM/DD/YYYY) (MM/DD/YYYY) (MM/DD/YYYY) IMPERVIOUS_SQ_FT 9648 PROJECT_TYPE Residential Non Residential STR_NU 104 105 106 BMP_TYPE Water Quality Unit Inlet Insert Media Filter Unit Tree Box Outlet Hood MODEL_NAME MODEL_NUMBER INST_DATE (MM/DD/YYYY) (MM/DD/YYYY) (MM/DD/YYYY) BMP_OWNER Municipal Private County MAINTENANCE_DATE (MM/DD/YYYY) (MM/DD/YYYY) (MM/DD/YYYY) ORIENTATION Inline Offline DIVERSION Yes No WEIR Concrete Steel Invert None WEIR_HEIGHT UNIT_NAME SUMP Yes No CAPACITY TC_ELEV INV_1_OUT INV_1_IN INV_2_OUT INV_2_IN INV_3_OUT INV_3_IN BASIN 51202011002 POOL_NORMAL 668.2 POOL_100YR 700.38 BOTTOM_ELEVATION 589.22 TYPE Wet Dry Underground Above Ground Dry BMP Yes No BMP_TYPE Isolator Row Bio-Retention Bio-Swale Vegetated Swale Infiltration Trench Infiltration Basin Naturalized Filter Strip Preservation Area Cistern UPS_STR_INV 856.92 DOW_STR_INV 853.33 SLOPE Bottom Width 2 Top Width 8 Length 133 Material Vegetated Concrete Stone Vegetated Location Private Public County State Easement_Width Type Swale Roadside Swale Ditch Trench Swale BMP Y N Naturalized Y N Sign_Text DO NOT MOW OR SPRAY PROTECTED WETLAND STORMWATER MANAGEMENT AREA DO NOT DISTURB DO NOT MOW OR SPRAY PROTECTED WETLAND STORMWATER MANAGEMENT AREA DO NOT DISTURB BMP_Protected Bio-Retention Bio-Swale Vegetated Swale Infiltration Trench Infiltration Basin Naturalized Filter Strip Preservation Area Basin_Type Wet Dry Underground Above Ground Dry Above Ground Wet