Laserfiche WebLink
Task 3 — Customize Database <br />To monitor the progress of various maintenance and rehabilitation (M&R) treatments, the <br />database shall update the customized field to track project updates for example details of <br />treatment types (i.e. 2" AHRM over 3/8" ARAM, over 2" AC over native). <br />Additionally, the Consultant shall coordinate with StreetSaver developer to prepare a customized <br />report to include the following fields (all of these fields are currently in the database but there is <br />no single report output including all of them) in one single report: <br />• Local Street Preventative Maintenance's date <br />• Pavement treatment data in pavement section table <br />• Project number in M&R section <br />• Number of slabs (PCC streets only) <br />• Verify treatment history to be reflected on each pavement section <br />Furthermore, the City frequently prepares various reports for City Council. Therefore, the <br />Consultant shall coordinate with StreetSaver developer to prepare up to five custom maps. <br />Task 4 - Budgetary Analysis <br />The City will provide the list of completed streets over the past two fiscal years to be updated in <br />the database and the list of streets planned for repair over the next seven fiscal years for the <br />budgetary analysis. <br />Forecast future PCI values for each segment and create OCTA-required budget scenarios for <br />each network utilizing the latest version of StreetSaver software. The consultant shall coordinate <br />with City staff to develop a 7-year maintenance & rehabilitation strategy (including but not limited <br />to selecting segments, treatment type, costs, and year of implementation). <br />Task 5 - Final Report <br />The consultant shall prepare a final Pavement Management Program report and any other <br />required submittal items, as per OCTA guidelines. The report shall include, without limitation, the <br />methods, findings and recommendations of the consultant, which shall be presented in a single <br />comprehensive document which, should include findings generated as part of other tasks <br />described herein. <br />Task 6 - Database Update and GIS Map Integration <br />Anticipate approximately 30 or less segments of roadway to be added/deleted/combined from <br />database (City will confirm if this scope is needed and will provide a list). <br />The Consultant shall integrate GIS mapping (ESRI) with StreetSaver database / Generate <br />updated GIS shapefile and provide data upon City request. Consultant to provide <br />recommendation for integrating StreetSaver with City's GIS platform via ESRI. Additionally, as - <br />needed GIS integration services upon request. <br />Run at least five (5) Budget and/or Target -Driven scenario analyses and show the impacts <br />through the use of GIS maps with the StreetSaver GIS toolbox. Two of the five scenarios should <br />include: <br />a. Future pavement condition based on historical funding of pavement maintenance. <br />b. Anticipated annual funding needed to acquire and maintain a minumum PCI of 75 <br />Citywide. <br />