WOOD RODGERS, INC. (#2026291) - Laserfiche WebLink

City of Pleasanton | Stormwater System Management Plan | PWD 25.601 | PAGE 11 Wood Rodgers will convert the collected data into a geodatabase and will document the results on a map showing where necessary data is missing. The map will serve as a basis for determining which missing data is essential and for prioritizing field inspections. Deliverable(s): Data Collection Memo | Data Gap Map | Updated Geodatabase Task 2.4 – Geodatabase Refinement Wood Rodgers proposes to refine/design a geodatabase to store and manage storm drain facility information; prioritize data collection and inventory; facilitate condition assessment; and facilitate hydrologic and hydraulic model development (see Exhibit 3). Leveraging our geodatabase design and management experience, Wood Rodgers’ GIS programmers will work closely with the City to create or refine the existing grid or numerically‐based numbering/naming procedure to systematically assign a unique identifier to each feature. Wood Rodgers will deploy a cost‐effective system and inventory approach developed and refined during previous drainage master plan studies. See exhibit 3 – Geodatabase. Wood Rodgers will review the City’s existing geodatabase and recommend any necessary refinements to capture all storm drain facility properties and conditions to be inspected. The refinements will be based on a comprehensive geodatabase with related tables and domain values that have already been designed and are being used for other public agencies. For those municipalities, Wood Rodgers modified the Environmental Systems Research Institute (Esri) file geodatabase using the Esri Local Government Information System Model as the basis, and then supplemented it with drainage feature datasets such as field surveys, topography, drainage facilities (including storm drains, maintenance holes, pumps, open channels, structures, etc.), georeferenced as‐ built drawings, parcel maps, streets, municipal boundaries, photographs from field visits and inspections with photo locations, watersheds, land use data, soil data, and hydrologic and hydraulic parameter data. Wood Rodgers will store all the surveyed and inspected drainage facility data, condition assessments, model development data, and results in the geodatabase and make it a centralized repository for this Storm Drain Master Plan Project. Deliverable(s): Refined geodatabase Task 2.5 – Desktop Asset Inventory Depending on the completeness of the City’s existing geodatabase, Wood Rodgers will perform a desktop GIS inventory task for the City’s drainage facilities using georeferenced record drawings for approximately 10 miles of pipes (see Exhibit 4) to further supplement the data gaps identified in Task 2.3 and to verify the existing attributes in the City’s geodatabase. This task is important for complicated or curved storm drain systems. Wood Rodgers will complete storm drain properties in the geodatabase with the record drawings that were created prior to field inspections. This has been proven to be the most cost‐effective approach in other drainage studies and assessment projects, when combined with limited field inspection data, to provide a more complete inventory of storm drainsystems. This approach will also provide sufficient resolution and accuracy for capacity and condition assessments. Wood Rodgers will georeference record drawings and use existing survey data to complete the geodatabase inventory of the City’s systems. We will use NearMap (or any orthoimagery) with three‐inch or better resolution and Google Street View to locate facilities and to create or refine existing spatial locations. This approach provides horizontal accuracy between 1 to 2 feet, which is sufficient to determine locations for a maintenance hole, a catch basin and an outfall structure, and to estimate the connecting storm drain lengths. The latest LiDAR data will be used to determine the facility rim or ground elevations when survey data is not available. Newer LiDAR data typically has sufficient point resolution and vertical accuracy (typically less than three inches) to determine Exhibit 3 Exhibit 4 EXHIBIT A Docusign Envelope ID: DF86282A-2A84-404C-9F8A-A035AEFBCFF8