LASAN is soliciting a qualified consultant firm to provide sewer planning support services, including: assessing sewer pipe condition; performing hydraulic modeling and flow estimation; evaluating and recommending pipe renewal actions; preparing sewer master plans and concept reports; packaging projects for design and construction; developing and/or integrating asset management and/or project management software; and developing GIS-based tools to facilitate planning activities. The services shall include but are not limited to: Task 1: Sewer Collection System Planning Support The Consultant will provide specialized and/or as-needed engineering services to assist the City in the following tasks: Prepare primary and secondary sewer master plans and concept reports for design and construction. Prepare project packages for Difficult Access Reaches (DAR) for design and construction. Prepare sewer concept reports for extending the existing sewer system to serve properties that are presently served by septic tanks/cesspools. Coordinate with the Bureau of Engineering to facilitate the design and implementation of sewer renewal and relief projects. Perform Sewer Capacity Availability Reviews (SCAR) and prepare CEQA responses to sewer availability requests. Perform field investigation, desktop research, data gathering and data analysis. Review and assess the structural and operational condition of sewers based on CCTV inspection and following sewer assessment guidelines. Provide expertise and support in the development, calibration, and application of hydraulic, treatment process, and/or odor models. Provide expertise and support in the development and maintenance of databases and related applications for sewer condition assessment, hydraulic assessment, flow projection, Inflow/Infiltration (I/I) analysis, and various hydraulic models. Task 2: GIS Enterprise System Support The City will utilize specialized skills of Consultant in the GIS Programmer/Web development for the development of GIS Enterprise. The following are services needed: Provide expertise and support, as needed, in computer/web programming and in the development and maintenance of web applications specifically designed to increase the productivity of city staff or to provide information to the public. Provide expertise and support in tasks related to Geographic Information Systems; dataset creation and maintenance; preparation of paper and web maps; and analysis of geographic data as related to the field of sewer services. Provide expertise and support in software development in creating GIS-based tools that facilitate sewer planning activities Provide expertise and support in implementation and/or integration of Enterprise-level asset management, project management, and GIS Enterprise software related to the field of wastewater utilities and assets. Task 3: Technical and Miscellaneous Support Closed Circuit Television (CCTV) inspection is used to review and visually inspect sewer reaches to allow analysis, evaluation and ranking of the sewer pipes for structural integrity. The objectives of CCTV are to assess the structural and operational condition of sewers based on industry standard or LASAN-specific guidelines. The Consultant will provide technical engineering services to assist the City in the following tasks: Review CCTV, document defects, and make a determination of the overall structural and operational condition of sewers according to established guidelines Document information from CCTV videos and log sheets in the condition assessment database. Assist in the transition of CCTV condition rating system and database management systems Investigate and prepare special studies on the sewer system as needed Coordinate activities of CCTV inspection crews, operational staff, and contractors. Provide support for processing, tracking and filing the numerous videos, log sheets and other documents.