CCSF DPW

1

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
2
Asset Management andSewer 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

3
SF Public Utilities Commision
Owns and Operates the Water Distribution Network
And San Franciscos Sewer System
4

CCSF DPW
Bureau Of Engineering

Hydraulics Section
Responsible for maintaining information about
City of San Francisco Sewer System
5
History of SF Sewers
6
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

7
To Access Sewer Information

• Hydraulics Section Has Used

8
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

9
ValueCADs 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

10
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

11
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

12
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

13
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

14

For Sewer GIS Project
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.
15
To Access the Scanned Drawings

• Hydraulics Developed and is Using the

As Built Viewer
16
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
17
We can use the Viewer to Insert the Drawings Into
AutoCAD
18
Indexing By Street Allows Finding Files By
Location

• Enter Street and Cross Streets

Get List of Files for Those Blocks
19
All Files Are Linked To CCSF BasemapStreet
Centerline network

• Linked To Blocks and Intersections By CNN

• Allows look up for cross street

20
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

21
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

22
Current Efforts and Future Directions
Spring-Summer 2003

• Catch Basins ArcPad
• Storm Water Discharge Permits
• Integrate AWSS

23
(No Transcript)
24
CCSF DPW
Bureau Of Engineering
Hydraulics Section

• Thank You