The URL can be used to link to this page

Home My WebLink AboutAppendix J - Stormwater Asset GIS DatabaseAppendix Stormwater Asset GIS Database 9 CITY OF SEBASTIAN, Fl. ASSET DATABASE FIELD INVESTIGATION � CHANNEL TYPE REFERENCE STORMWATER MASTER PLAN City of Sebastian, FL Stormwater Master Plan Update Task 800 - Master Plan Development AAARCAD I S City of Sebastian Stormwater Asset GIS Database Fields June 2023 = the Field is not aplicable to the type of asset (nodes versus conduits) Field Description Comments General comments x Survey_Comments Comments from Survey x Inspected Inspected Y/N x Outfall Name Outfall name x Model Modeled Y/N x Join status - provides information j_status x related to the location Model_desc model description and comments x Type Type of Asset x Type_Acronymn Acronymn of Feature Type x 6 Digit Asset ID SW Zone + unique 5 Asset ID — x digit number Address address text x StreetNum address number x SW_Zone Stormwater Management Zone x X X coordinate of GIS Feature x Y Y Coordinate of GIS Feature x Z Elevation from 2007 DEM x Best Available Rim Elevation NAVD F Rim Elev x 88 Best Available Invert Elevation F Inv Elev x NAVD 88 Channel Type as described in field Channel_Type investigation Survey_Type Asset Type - Public/Private/Other Canal —Name Canal Name Survey_Condition Surveyed Condition and Vegetation Survey_Sediment_Depth Survey Sediment Depth inches Name of modeled open channel cross-section geometry, associated Transect with locations F_Cross_Section "Irregular" Best Available number of barrels Barrels (closed pipe networks and culverts) Inlet —AID Inlet Node Asset ID Outlet —AID Outlet Node Asset ID F_Cross_Section Best Available Cross Section Shape Node Conduit x x x x x Example Example Link Node Data Data CB captured fr<Null> Could not <Null> locate Yes Yes <Null> Yes Yes Are identical to, Match -Model Model ID matches GIS ID No IE <Null> Catch Basin Culvert CB CU 300001 490075 INDIAN RIVER RIVER OAK DR DR 1201 3 3 4 828074.9 1266176.3 6.1 7.68 Public <Null> Some Vegetation <Null> <Null> 400072 400071 CIRCULAR Page 1 of 4 City of Sebastian, FL Stormwater Master Plan Update AAARCJ` D I S Task 800 - Master Plan Development City of Sebastian Stormwater Asset GIS Database Fields June 2023 = the Field is not aplicable to the type of asset (nodes versus conduits) Field Description Best Available Geom 1, refer to F_Geom1 Conduit Geometry Field Descriptions Best Available Geom 2, refer to F_Geom2 Conduit Geometry Field Descriptions Best Available Geom 3, refer to F_Geom3 Conduit Geometry Field Descriptions Best Available Geom 4, refer to F_Geom4 Conduit Geometry Field Descriptions Best Available Inlet Elevation NAVD F Inlet IE 88 Best Available Outlet Elevation F Outlet IE NAVD 88 F_Length Best Available Length, feet Material Type based on desktop Conduit Material review and survey Node I Example Example Link Conduit Node Data Data 1.25 N U N 13.92 13.79 58.49 <Null> Page 2 of 4 City of Sebastian, FL Stormwater Master Plan Update Task 800 - Master Plan Development 04ARCADIS Asset Type Descriptions and Type Acronymns Type Description Type_Acronymn Conduit or Node Backyard Ditch Ditch behind houses BD Conduit Backyard Pipe Pipe behind houses BP Conduit Canal Canal CA Conduit Cross Ditch Ditch between two houses CD Conduit Cross Pipe Pipe between two houses CID Conduit Culvert Culvert - at road crossings CU Conduit Ditch General Ditch (unspecified) DI Conduit Driveway Culvert Driveway Culvert DC1 Conduit Orifice Orifice OR Conduit Pipe General Pipe (unspecified) PI Conduit Pump Pump PU Conduit Roadside Ditch Roadside Ditch (not maintained by the City) RD Conduit Weir Weir WR Conduit Baffle Box Baffle Box BB Node (Yard Inlet, storm drain, curb inlet) Pipe to pipe Catch Basin node receiving additional runoff flow CB Node Channel Node Open Channel to Open Channel CN Node Manhole (pipe to pipe node without receiving Manhole additional runoff flow) MH Node Node Created for modeling purposes not a specific Model Node structure MN Node Outfall Outfall OF Node Pipe End Pipe/Culvert to Open Channel or Pond inlet/outlet PE Node Storage Node Storage Node (detention basins, ponds, etc) SN Node created for each address point within the SW Driveway culvert management Zones DC2 Node created for each address point within the SW Roadside Swale management Zones RS Node Page 3 of 4 City of Sebastian, FL Stormwater Master Plan Update /aRCJ` D I S Task 800 - Master Plan Development Conduit Geometry Field Descriptions Type of Feature the Cross F Cross Section F Geomi F Geom2 F Geom3 F Geom4 Section is associated with — — — — — — 1Pipe Circular Diameter, ft J Pipe Horiz_Ellipse Rise, ft Span, ft Open Channel Irregular Open Channel Parabolic Depth, ft Top Width, ft Open Channel Trapezoidal Depth, ft Bottom Left Slope (Horiz ft/ Right Slope (Horiz ft/ Width, ft Vertical ft) Vertical ft) Open Channel Triangular Depth, ft Top Width, ft 1 Pipe Vert_Ellipse Rise, ft Span, ft Weir V-notch Height, ft Top Width, ft Weir Transverse Height, ft Top Width, ft Weir Trapezoidal Height, ft Bottom Side Slope (Horiz ft/ Width, ft Vertical ft) Orifice Circular Diameter, ft Orifice Rect_Closed Height, ft Width, ft Join Status between the Survey Database and the H&H Model JIStatus Field Description Conduit or — Node IAre identical to Spatial join between the features, no Conduit Are identical to, Model ID Spatial join between the features and matches GIS ID ID join with the PCSWMM Model Conduit GIS only, not modeled Feature is in GIS only and not Conduit ID match Spatially not a match but the ID Conduit Only modeled, not on GIS Feature was added in the model but Conduit Orifice Orifice Feature added to Model Conduit (Pump Pump Feature added to Model Conduit Spatially matched Spatially joined but the Feature ID Conduit l Weir Weir Feature added to Model Conduit Combined Node Node feature added for modeling Node GIS only, not modeled Feature is in GIS only and not Node ID join with model but location Match and location changed adjusted during system review Node Match -Model X,Y diff < 1 Spatial join between the features and Node Modeled Feature was added in the model but Node Spatially Matched Spatially joined but the Feature ID Node Page 4 of 4 City of Sebastian, FL Stormwater Master Plan Update Task 800 - Master Plan Development 04 ARCAD I S City of Sebastian Stormwater Asset GIS Database Detailed June 2023 = the Field is not aplicable to the type of asset (nodes versus conduits) Field Description Node lConduit Geospatial Length. Modeled length may Shape_Length not match the geospatial length in x situations in support of hydraulic model representation Desktop Analysis Diameter in inches (or DA_Size elliptical dimensions in inches ex. x 44x68)from record drawings DA Desktop Analysis Pipe Material from Ix —Material record drawings Desktop Analysis Comments and DA Comments x drawing references Ix Desktop Analysis Upstream Invert DA — Invert —In Elevation from record drawings Ix Desktop Analysis Downstream Invert DA Invert Out — — Elevation from record drawings x DA Rim Elev Desktop Analysis Record Drawing Rim x Elevation DA Inv Elev Desktop analysis Record Drawing Invert x Elevation DA Node Type Desktop Analysis Record Drawing Node x Yp Type Desktop Analysis Channel Type in Channel —Type support of field investigations x Inspected Inspected Y/N x x Survey_Comments Comments from Survey x x Survey_Type Asset Type - Public/Private/Other x Survey_Rim_Elev Survey Rim Elevation NAVD 88 x Survey_lnv_Elev Survey Invert Elevation NAVD88 x Survey_Node_Type Survey Node Type x Survey_Condition Surveyed Condition and Vegetation _ Survey_Pipe_Material Surveyed Pipe Material Survey_Conduit_Type Surveyed conduit type ex. Culvert, ditch S u rvey_C h a n n e I_Botto m — Surveyed Channel Bottom Width in feet Width Survey_Channel_Top Surveyed Channel Top Width in feet _Width Survey_Channel_Depth Surveyed Channel Depth in feet _ Survey_Pipe_Size Survey Pipe Size in feet Survey_Sediment_Depth Survey Sediment Depth feet Outfall Name Outfall name x Join status - provides information j_status x related to the location Example (Example Link Node Data Data 58.2 12 IHDPE MH-1 120 I20.15 20 13.35 7.6 Manhole NA Yes Yes <Null> 2 pipes Public <Null> <Null> <Null> Clear JHDPE (Culvert <Null> I<Null> I<Null> 11 0.083 <Null> Are identical to, x Match -Model Model ID GIS ID X,Y diff < 1 matches Page 1 of 4 City of Sebastian, FL Stormwater Master Plan Update Task 800 - Master Plan Development 04 ARCAD I S City of Sebastian Stormwater Asset GIS Database Detailed June 2023 = the Field is not aplicable to the type of asset (nodes versus conduits) Example Example Link Field Description Node Conduit Node Data Data Model Modeled Y/N x x Yes Yes Model_desc model description and comments x x Clear, HDPE 6 Digit Asset ID SW Zone + unique 5 AssetlD x x 590658 digit number 300025 Conduit/Node Asset Type based on Type desktop review, survey, and modeling x x Culvert effort Manhole Type_Acronymn Acronymn of Feature Type x x MH CU U S HIGHWAY PELICAN ADDRESS ADDRESS x x 1 ISLAND PL StreetNum StreetNum x x 1004 138 SW —Zone SW —Zone x x 3 5 Canal —Name Canal Name x <Null> Name of modeled open channel cross- Transect section geometry, associated with x locations F_Cross_Section "Irregular" Inlet AID Inlet Node Asset ID x 502182 outlet AID Outlet Node Asset ID x 502183 F_Cross_Section Best Available Cross Section Shape x CIRCULAR Best Available Geom 1, refer to Conduit F Geom1 Geometry Field Descriptions x 1 Best Available Geom 2, refer to Conduit F Geom2 x 0 Geometry Field Descriptions Best Available Geom 3, refer to Conduit F Geom3 x 0 Geometry Field Descriptions Best Available Geom 4, refer to Conduit F Geom4 Geometry Field Descriptions x 0 Best Available number of barrels (closed Barrels x 2 pipe networks and culverts) F_Inlet_IE Best Available Inlet Elevation x 20.15 F_Outlet_IE Best Available Outlet Elevation x 20 F_Length Best Available Length, feet x 58.2 Best Available Material Type based on Conduit Material x HDPE desktop review and survey X X coordinate of GIS Feature x 828144.5517 Y Y Coordinate of GIS Feature x 1265204.173 Z Elevation from 2007 DEM x 11.48 F Rim Elev Best Available Rim Elevation NAVD 88 x 13.35 F Inv Elev Best Available Invert Elevation NAVD 88 x 7.6 Page 2 of 4 City of Sebastian, FL Stormwater Master Plan Update Task 800 - Master Plan Development 04ARCADIS Asset Type Descriptions and Type Acronymns Type Description Type_Acronymn Conduit or Node Backyard Ditch Ditch behind houses BD Conduit Backyard Pipe Pipe behind houses BP Conduit Canal Canal CA Conduit Cross Ditch Ditch between two houses CD Conduit Cross Pipe Pipe between two houses CID Conduit Culvert Culvert - at road crossings CU Conduit Ditch General Ditch (unspecified) DI Conduit Driveway Culvert Driveway Culvert DC1 Conduit Orifice Orifice OR Conduit Pipe General Pipe (unspecified) PI Conduit Pump Pump PU Conduit Roadside Ditch Roadside Ditch (not maintained by the City) RD Conduit Weir Weir WR Conduit Baffle Box Baffle Box BB Node (Yard Inlet, storm drain, curb inlet) Pipe to pipe Catch Basin node receiving additional runoff flow CB Node Channel Node Open Channel to Open Channel CN Node Manhole (pipe to pipe node without receiving Manhole additional runoff flow) MH Node Node Created for modeling purposes not a specific Model Node structure MN Node Outfall Outfall OF Node Pipe End Pipe/Culvert to Open Channel or Pond inlet/outlet PE Node Storage Node Storage Node (detention basins, ponds, etc) SN Node created for each address point within the SW Driveway culvert management Zones DC2 Node created for each address point within the SW Roadside Swale management Zones RS Node Page 3 of 4 City of Sebastian, FL Stormwater Master Plan Update ARCI�DIS Task 800 - Master Plan Development Conduit Geometry Field Descriptions Type of Feature the Cross- Section is associated with F Cross Section — — F Geom1 — F Geom2 — F Geom3 F Geom4 — — Pipe Circular Diameter, ft Pipe Horiz_Ellipse Rise, ft Span, ft Open Channel Irregular Open Channel Parabolic Depth, ft Top Width, ft Bottom Left Slope (Horiz ft/ Right Slope (Horiz ft/ Open Channel Trapezoidal Depth, ft Width, ft Vertical ft) Vertical ft) Open Channel Triangular Depth, ft Top Width, ft Pipe Vert_Ellipse Rise, ft Span, ft Weir V-notch Height, ft Top Width, ft Weir Transverse Height, ft Top Width, ft Bottom Side Slope (Horiz ft/ Weir Trapezoidal Height, ft Width, ft Vertical ft) Orifice Circular Diameter, ft Orifice Rect_Closed Height, ft Width, ft Join Status between the Survey Database and the H&H Model JIStatus Field Description Conduit or — Node Are identical to Spatial join between the features, no Conduit Are identical to, Model ID Spatial join between the features and matches GIS ID ID join with the PCSWMM Model Conduit GIS only, not modeled Feature is in GIS only and not Conduit ID match Spatially not a match but the ID Conduit Only modeled, not on GIS Feature was added in the model but Conduit Orifice Orifice Feature added to Model Conduit Pump Pump Feature added to Model Conduit Spatially matched Spatially joined but the Feature ID Conduit Weir Weir Feature added to Model Conduit Combined Node Node feature added for modeling Node GIS only, not modeled Feature is in GIS only and not Node ID join with model but location Match and location changed Node adjusted during system review Match -Model X,Y diff < 1 Spatial join between the features and Node Modeled Feature was added in the model but Node Spatially Matched Spatially joined but the Feature ID Node Page 4 of 4