012303 SF sewer

Slide1: 

Asset Management and Sewer Engineering Using GIS Integrated with Document Management in San Francisco Greg Braswell - City & County of San Francisco, Bureau of Engineering Bijoy Nair - ValueCAD

Asset Management andSewer Basemap Project Report: 

Asset Management and Sewer Basemap Project Report Outline Background/History of Sewer Mapping/Engineering in San Francisco Data Requirements, Problems and Solutions As-Built Viewer Conversion Methods and Processes Current Status and Future Plans

Slide3: 

Owns and Operates the Water Distribution Network And San Francisco’s Sewer System

Slide4: 

Bureau Of Engineering Responsible for maintaining information about City of San Francisco Sewer System CCSF DPW

History of SF Sewers: 

History of SF Sewers

History of Sewer Mapping: 

History of Sewer Mapping Typical Paper Mapping System All Information Lost in 1906 Fire 1909-1934 Inspection Books 1934-1940 WPA effort Section Maps Map Books (Atlas) Different versions with different Man Hole Numbers 1989 Earthquake First Electronic Version 14 separate ACAD files 1994 Sink Hole Field data collection and corrected approx 200 blocks North Beach Area Marked on aerial photos

To Access Sewer Information: 

To Access Sewer Information Hydraulics Section Has Used :

City Wide Basemap by ValueCAD : 

Creation of CCSF Basemap (1993-5) Aerial Photos Parcels Features Street Centerlines Major portion of funding from Clean Water Program City Wide Basemap by ValueCAD

ValueCAD’s First Sewer Basemap Efforts: 

Updating Sewer Basemap (1998-Present) Combine previous ACAD files Reference to City Basemap (NAD83CaStPlIII) Rubbersheet to correct location Add attributes in object data to pipes from annotation Renumber Manholes Processes automated to reduce cost ValueCAD’s First Sewer Basemap Efforts

Decision Time: 

Decision Time Sewer Basemap Obviously Lacked a large number of manholes – “Schematic map” not useful for asset mgmt. Basic attributes incomplete or outdated Material – Size - Date No Hydraulic modeling information Rim Invert Investigate GPS – Survey $$$$$$$$$$$ Pipes the priority AsBuilts? 50 engineeering Drawings tested $$$$$

On Site Investigation: 

On Site Investigation Contractor to sit and work with Hydraulic Staff to: Evaluate alternatives for sewer basemap data collection and conversion Work with city staff, evaluate processes and business needs Document Management Not as easy as city staff thought Engineering AsBuilts represent less then 15% of possible data Wide variety of document types with different data value Evaluate Variety of Needs Engineers view Vs. Citywide view Develop Possible Uses and Prototypes Set Goals and Standards for GIS efforts “Balkanized” City Departments

Goals for Sewer GIS Basemap Project: 

Cost effectiveness – relative return on investment Document Management $$ Engineering Decision Support $$$ Provide engineers with efficient access to all available information, not replace good engineering… METADATA – engineer understands the value and completeness of the information to make the best engineering decisions Hydraulic Modeling – Master Planning $$ Asset Management - $$$$$$ Public decision making Cost effectiveness of engineering and maintenance decision Management of maintenance efforts Integrate Asset Management with Engineering Process $ Information Organized in one place for various agencies $$ Emergency Response/ Environmental/ Waste Management Goals for Sewer GIS Basemap Project

Goals for Data Collection and Conversion: 

Goals for Data Collection and Conversion Efficiency Speed Accuracy Multiple Uses of Data Collected Sustainable Pace and Budget “Do-able” – Reasonable Expectations Exception Process Flexible

Slide14: 

All Sewer related drawings have been collected and Scanned Drawings Were Indexed by Street New sewer GIS map and sewer information have been developed block by block using the original drawings. Pipes, manholes and structure information collected have been automatically linked to as built drawings or best available documents.

To Access the Scanned Drawings: 

To Access the Scanned Drawings Hydraulics Developed and is Using the As Built Viewer

Hydraulics Has Been Able to Link To the Index Cards: 

Hydraulics Has Been Able to Link To the Index Cards Index Cards had been transferred to Excel Spreadsheet called SMS Index SMS Index turned into Access Database table and cleaned up Drawings that the SMS Index referenced were picked first to be scanned Links made between scanned drawings and SMS Index Links made between SMS and Centerline file Spatial Join between Streets and Pipes to put SMS information onto pipes So Now We can Look Up Pipe Information and drawings by Street

We can use the Viewer to Insert the Drawings Into AutoCAD: 

We can use the Viewer to Insert the Drawings Into AutoCAD

Slide18: 

Enter Street and Cross Streets Get List of Files for Those Blocks Indexing By Street Allows Finding Files By Location

Slide19: 

Linked To Blocks and Intersections By “CNN” All Files Are Linked To CCSF Basemap Street Centerline network Allows look up for cross street

ValueCAD Data Conversion Process : 

ValueCAD Data Conversion Process Divide into subsections based on Drainage basins Use asbuilt viewer to select correct document Enter correct location of pipes and manholes Add pipe and manholes if required Enter additional attribute data Automatic link of data collected to documents Exception Handling to increase efficiency and accuracy Automated using AutoCAD vba

Current Efforts and Future Directions – Spring-Summer 2003: 

Current Efforts and Future Directions – Spring-Summer 2003 QA/QC Large Pipes and Structures Automated QA/QC Exceptions Automation of CAD to integrate Engineering Design and Maintenance of Asset Management Database - Oracle Integrate with Sewer TV Tape, Inspections, Asset Management Major Structures – East Side Web based applications

Current Efforts and Future Directions Spring-Summer 2003: 

Current Efforts and Future Directions Spring-Summer 2003 Catch Basins – ArcPad Storm Water Discharge Permits Integrate AWSS

CCSF DPW: 

CCSF DPW Thank You Bureau Of Engineering