HomeMy WebLinkAboutPROJ 21-05 CITY CENTER DR Storm Water GIS As-Built Submittal TablesOverall 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
Stormwater Easements
Drainage - Is easement a drainage easement yes/no?
BMP - Is easement a BMP easement yes/no?
Access - Is easement an access easement yes/no?
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
STR_NU
10
11
12
13
14
15
16
18
19
20
21
22
EX 23
18A
STR_TYPE
MANHOLE
CURB INLET
DBL CURB INLET
BEEHIVE INLET
END SECTION
YARD INLET
CATCH BASIN
OPEN PIPE OUTLET
FLAPGATE
CLEANOUT
STUB
OUTLET CONTROL STRUCTURE
CURB INLET
CURB INLET
CURB INLET
MANHOLE
CURB INLET
CURB INLET
CURB INLET
CURB INLET
MANHOLE
CURB INLET
CURB INLET
CURB INLET
MANHOLE
MANHOLE
STR_MAT
Concrete
Concrete
Concrete
Concrete
Concrete
Concrete
Concrete
Concrete
Concrete
Concrete
Concrete
Concrete
Concrete
Concrete
CAST_TYPE
CURB GRATE
CURB GRATE
CURB GRATE
MANHOLE SOLID
CURB GRATE
CURB GRATE
CURB GRATE
CURB GRATE
MANHOLE SOLID
CURB GRATE
CURB GRATE
CURB GRATE
MANHOLE SOLID
MANHOLE SOLID
STR_SHAPE
ELIPTICAL
SQUARE
RECTANGULAR
ROUND
BOX
RECTANGULAR
RECTANGULAR
RECTANGULAR
ROUND
RECTANGULAR
RECTANGULAR
RECTANGULAR
RECTANGULAR
ROUND
RECTANGULAR
RECTANGULAR
RECTANGULAR
ROUND
ROUND
OWNER
Municpal
Private
County
State
Municpal
Municpal
Municpal
Municpal
Municpal
Municpal
Municpal
Municpal
Municpal
Municpal
Municpal
Municpal
Municpal
Municpal
APPENDITURE
Trash Guard
Flap Gate
Duck Bills
Weir
None
None
None
None
None
None
None
None
None
None
None
None
Trash Guard
None
None
Outfall
Y
N
N
N
N
N
N
N
N
N
N
N
N
N
Y
N
SUMP_INV
TC_ELEV
844.11
844.48
844.22
844.58
845.01
844.99
843.70
843.37
844.43
843.49
842.29
842.07
843.84
843.63
NUM_INVERT
1
1
2
3
1
2
2
3
3
1
1
2
4
2
I1_ELEV
840.11
840.88
840.52
839.78
841.67
841.45
841.30
839.67
836.38
839.22
838.14
837.99
836.93
840.29
I1_DIR
N
NE
E
SE
S
SW
W
NW
SE
E
W
S
E
W
SW
S
W
S
E
W
NW
N
I1_DIA
12
12
12
12
12
12
12
12
18
12
12
12
12
12
I1_MAT
PVC
RCP
HDPE
CMP
VCP
BRICK
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
I2_ELEV
840.16
839.77
841.37
839.10
838.97
838.93
837.3
834.54
840.47
I2_DIR
N
NE
E
SE
S
SW
W
NW
N
NW
NE
E
W
S
SE
S
E
I2_DIA
12
12
12
12
18
12
I2_MAT
PVC
RCP
HDPE
CMP
VCP
BRICK
RCP
RCP
RCP
RCP
RCP
RCP
I3_ELEV
839.69
839.03
839.06
834.02
I3_DIR
N
NE
E
SE
S
SW
W
NW
E
N
N
W
I3_DIA
12
12
12
24
I3_MAT
PVC
RCP
HDPE
CMP
VCP
BRICK
RCP
RCP
RCP
RCP
I4_ELEV
834.02
I4_DIR
N
NE
E
SE
S
SW
W
NW
E
I4_DIA
24
I4_MAT
PVC
RCP
HDPE
CMP
VCP
BRICK
RCP
I5_ELEV
I5_DIR
N
NE
E
SE
S
SW
W
NW
I5_DIA
I5_MAT
PVC
RCP
HDPE
CMP
VCP
BRICK
I6_ELEV
I6_DIR
N
NE
E
SE
S
SW
W
NW
I6_DIA
I6_MAT
PVC
RCP
HDPE
CMP
VCP
BRICK
I7_ELEV
I7_DIR
N
NE
E
SE
S
SW
W
NW
I7_DIA
I7_MAT
PVC
RCP
HDPE
CMP
VCP
BRICK
I8_ELEV
I8_DIR
N
NE
E
SE
S
SW
W
NW
I8_DIA
I8_MAT
PVC
RCP
HDPE
CMP
VCP
BRICK
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
10
11
12
13
14
15
16
18
19
20
17
21
22
18A
DOW_STR_ID
13
12
13
17
15
16
18
19
17
19
EX 23
22
EX 23
18
SLOPE
0.4
1.3
1.6
2.0
0.86
0.11
0.39
0.34
0.3
0.37
0.12
0.3
0.80
5.79
DIAMETER
12
12
12
12
12
12
12
12
18
12
18
12
12
12
STR_SHAPE
ELIPTICAL
SQUARE
RECTANGULAR
ROUND
BOX
ROUND
ROUND
ROUND
ROUND
ROUND
ROUND
ROUND
ROUND
ROUND
ROUND
ROUND
ROUND
ROUND
ROUND
PIPE_LEN
71.7
28.8
23.7
121.8
25.5
62.6
33.2
29.2
23.3
42.9
87.3
54.5
44.3
10.7
MATERIAL
PVC
RCP
HDPE
CMP
VCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
RCP
OWNER
Municipal
Private
County
State
Municipal
Municipal
Municipal
Municipal
Municipal
Municipal
Municipal
Municipal
Municipal
Municipal
Municipal
Municipal
Municipal
Municipal
SSD
Y
N
Y
Y
Y
N
Y
N
Y
Y
N
Y
N
Y
Y
N
Culvert
Y
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
BACKFILL
AVE_DEPTH
UPSTRM_INV
840.11
840.88
840.16
839.69
841.67
841.37
839.10
839.03
836.38
839.22
834.61
838.14
837.3
840.29
DNSTRM_INV
839.77
840.52
839.78
837.26
841.45
841.30
838.97
838.93
836.31
839.06
834.54
837.99
836.93
839.67
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
17
BMP_TYPE
Water Quality Unit
Inlet Insert
Media Filter Unit
Tree Box
Outlet Hood
Water Quality Unit
MODEL_NAME
CONTECH CASCADE SEPERATOR
MODEL_NUMBER
CS-5
INST_DATE
(MM/DD/YYYY)
(MM/DD/YYYY)
(MM/DD/YYYY)
04/01/2023
BMP_OWNER
Municipal
Private
County
Municipal
MAINTENANCE_DATE
(MM/DD/YYYY)
(MM/DD/YYYY)
(MM/DD/YYYY)
ORIENTATION
Inline
Offline
Inline
DIVERSION
Yes
No
No
WEIR
Concrete
Steel
Invert
None
None
WEIR_HEIGHT
UNIT_NAME
SUMP
Yes
No
Yes
CAPACITY
TC_ELEV
844.41
INV_1_OUT
834.61
INV_1_IN
837.26
INV_2_OUT
INV_2_IN
834.61
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
Bio-Retention
Bio-Swale
Vegetated Swale
Infiltration Trench
Infiltration Basin
Naturalized
Filter Strip
Preservation Area
Cistern
Native Bottom
Native Bank
Wetland Shelf
Pre Treatment Chamber
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
Drainage
Yes
No
BMP
Yes
No
Access
Yes
No