Implementation of CMMS/GIS, and Field Integration Technology · Implementation of CMMS/GIS, and Field Integration Technology Edward H. Oyama, P.E. BAYWORK South Bay Workshop June
34
Implementation of CMMS/GIS, and Field Integration Technology Edward H. Oyama, P.E. BAYWORK South Bay Workshop June 4, 2014
Implementation of CMMS/GIS, and Field Integration Technology
Edward H. Oyama, P.E.
BAYWORK South Bay Workshop
June 4, 2014
Presenter
Presentation Notes
Good evening ladies, gentlemen, and wastewater colleagues. I am delighted to be here at tonight’s CWEA Training Meeting. The purpose of this presentation is not to promote one software over another, or to provide a dissertation on technical aspects of CMMS/GIS. Rather, it is a presentation of the District’s journey in the use and applications of CMMS/GIS and field integration technology. To begin, I’ll quickly describe the District. a
Map of WVSD
Presenter
Presentation Notes
The District serves the communities of Campbell, Los Gatos, Monte Sereno, Saratoga, and intervening areas of Santa Clara County. a One mile west of Saratoga Ave to the west To Hamilton Ave. to the north To South Bascom Rd North of 85, and Harwood Rd South of 85 to the east To city limits in the hills to the south
System Info
Total Service Area: 28.4 sq. miles
Population Served: 108,000
Sewer Mains: 415 mi.
Laterals: 210 mi.
Presenter
Presentation Notes
The District’s Service Area encompasses about 28 square miles, serving a population of 108,000 people. We own and maintain 415 miles of sewer main and are one of the lucky agencies to have responsibilities for about 210 miles of lower laterals. a
CMMS/GIS Milestones
Pre-1983 Spreadsheet tracking and paper map work orders 1983-2002 COSMO (Computerization of Sewer Maint Operations) CCTV Inspections and Condition Assessment (VHS) 2003 Lucity (formerly GBA Master Series)/GIS CCTV Inspections and Condition Assessment (DVD)
Presenter
Presentation Notes
a Prior to 1983, maintenance management was accomplished through the use of spreadsheets. a Implementation of CMMS/GIS started in 1983 with the use of COSMO (a CMMS software developed through combined efforts of the District, West Bay, Union San, & Nolte & Assoc.). It utilized FORTRAN programming to evaluate historical cleaning debris to establish the next cleaning date and tracked labor hours. It was a great advancement from spreadsheets and served us well for nearly 20 years. a In 2003 GBA was selected because of its applicability to public utility work, ability to link with GIS, incorporate CCTV condition assessment data, and cost data. a a
CMMS/GIS Milestones
2006 Initiated Geozone Cleaning (1st application of GIS) GIS mapping & scanned paper maps used in office 2008 Acquired GIS Analyst Implemented Lateral Maint Program (expanded use of GIS) Corrected GIS mapping/lateral mapping began Post-2008 Use of GIS w/ Risk Model, Hydraulic Model, & other uses InfraMap – Field Accessible WO & GIS Mapping NO MORE paper maps (almost)
Presenter
Presentation Notes
a In 2006 Geozone cleaning was the the District’s first application of GIS. GIS mapping of the system was not fully developed and reliance on paper mapping continued. a The acquisition of a GIS Analyst in 2008 was a significant event (best investment the District has made) to advance the use of CMMS/GIS and Field Integration technology. GIS mapping was corrected and made usable by office staff. a a A significant milestone was the introduction of field integration technology to the maintenance staff in 2011. It was key to increasing efficiency and overall capability in Operations and providing accurate and accessible mapping info (NO MORE paper maps). a a
Conversion of Paper Maps
Presenter
Presentation Notes
A basic, but significant improvement was the conversion of paper maps to GIS mapping. This was a long drawn out effort initially due to underestimation of effort and lack of resources applied to the conversion process when the CMMS/GIS software was first installed. Although cleanup of the mapping system is an ongoing effort, much of the necessary improvements to GIS mapping occurred when the GIS Analyst was brought on-board. a
Elimination of Paper Maps
Too cumbersome
Presenter
Presentation Notes
a Paper maps were too cumbersome. a It could take some time to locate lines, needed to flip back and forth, and pages would fall out. a Updating was done every 4 to 6 months and required a lot of time (ink drafting, reproduction, updating individual map volumes). a By itself, this saved 45 days of work ≈ $35k/yr a The maps were difficult to read, especially the 8 ½ X 11 field books. a
Elimination of Paper Maps Updating is infrequent and time intensive
45 days annually
Presenter
Presentation Notes
a Paper maps were too cumbersome. a It could take some time to locate lines, needed to flip back and forth, and pages would fall out. a Updating was done every 4 to 6 months and required a lot of time (ink drafting, reproduction, updating individual map volumes). a By itself, this saved 45 days of work ≈ $35k/yr a The maps were difficult to read, especially the 8 ½ X 11 field books. a
Elimination of Paper Maps Difficult to read
Presenter
Presentation Notes
a Paper maps were too cumbersome. a It could take some time to locate lines, needed to flip back and forth, and pages would fall out. a Updating was done every 4 to 6 months and required a lot of time (ink drafting, reproduction, updating individual map volumes). a By itself, this saved 45 days of work ≈ $35k/yr a The maps were difficult to read, especially the 8 ½ X 11 field books. a
Applications of CMMS/GIS
Presenter
Presentation Notes
Although some of these applications of CMMS/GIS may not seem significant or revolutionary, it was a real accomplishment for the District to actually start utilizing the power of GIS. Some of the different applications we are using CMMS/GIS for include: a
Geozone Cleaning
Created 24 Zones of cleaning (≈100,000 lf/zone) Resulted in a 20% +/- increase in cleaning footage
Presenter
Presentation Notes
The District’s Geozone provided a systematic approach to cleaning, thereby increasing efficiency by performing cleaning by zones and avoiding excessive travel time. These zones were created to envelope approximately 100,000 lf of mainlines, creating a 24 month system cleaning frequency. a Actual cleaning = 350 miles/yr
GIS Utilization for Risk Model
District Risk Model is used to help prioritize CIP projects
CO
NSE
QU
ENC
E O
F FA
ILU
RE
Severe 10 20 30 40 50 60 70 80 90 100
9 18 27 36 45 54 63 72 81 90
8 16 24 32 40 48 56 64 72 80 Moder
ate 7 14 21 28 35 42 49 56 63 70
6 12 18 24 30 36 42 48 54 60
5 10 15 20 25 30 35 40 45 50
Low 4 8 12 16 20 24 28 32 36 40
3 6 9 12 15 18 21 24 27 30
2 4 6 8 10 12 14 16 18 20 Neglig
ible 1 2 3 4 5 6 7 8 9 10
Neg
ligi
ble
Poss
ibl
e
Like
ly
Very
Li
kely
LIKELIHOOD OF FAILURE
Risk =
Likelihood of Failure (LoF) x
Consequence of Failure (CoF)
Presenter
Presentation Notes
Another application of GIS is used in conjunction with the District’s Risk Model. The Risk Model is used to help prioritize our CIP projects. This is a typical Risk Model matrix showing Likelihood of Failure and Consequence of Failure on the axis. The resulting Risk is determined by the product of these two factors producing a Risk score between 1 and 100; 1 meaning no risk and 100 meaning we’d better get our butt out there to fix it right now. a
Risk Model Map
Risk Model Map
Quito Basin 7, Area 1
Quito Basin 7, Area 3&4
Quito Basin 5&7, Area 1
Presenter
Presentation Notes
Illustrated are three CIP projects that specifically address this high risk line. a Q 7,1 = 2012 $1.2MM, 2 mi Q57,2 = 2014 $4.1MM, 1.5 mi Q7,34 = 2016 $2.1MM, 1.5 mi
FOG Program
Presenter
Presentation Notes
CMMS/GIS helps identify lines/areas with heavy FOG issues. a This info assists with the District’s FOG inspection program of FSEs and FOG outreach to multi-family properties. a
FOG Program
Facilitates Focus of Residential FOG Outreach Program
Provides Visual Map of Restaurant (FSE) related FOG
Presenter
Presentation Notes
CMMS/GIS helps identify lines/areas with heavy FOG issues. a This info assists with the District’s FOG inspection program of FSEs and FOG outreach to multi-family properties. a
Spill Response
Presenter
Presentation Notes
The use of the GIS Storm System layer is extremely helpful to Maintenance Staff when trying to circumvent a Category 1 SSO. Knowing where to berm up a storm catch basin or where to set up vacuum units to intercept wastewater flow is crucial and very time sensitive. a
Lateral Maintenance Program Lateral Cleaning & Mapping
Presenter
Presentation Notes
Starting in 2009, the District’s Lateral Maintenance Program consists of two elements. To provide proactive cleaning/inspection of lower laterals, and to GPS PL cleanouts (to establish the location of laterals on maps). Lateral cleaning has helped to reduce the number of lateral SSOs and is a vast improvement over our prior reactive cleaning program. a Stoppages and overflows were plotted to help prioritize which areas to start first. a
Lateral Maintenance Program Lateral Cleaning & Mapping
Presenter
Presentation Notes
Starting in 2009, the District’s Lateral Maintenance Program consists of two elements. To provide proactive cleaning/inspection of lower laterals, and to GPS PL cleanouts (to establish the location of laterals on maps). Lateral cleaning has helped to reduce the number of lateral SSOs and is a vast improvement over our prior reactive cleaning program. a Stoppages and overflows were plotted to help prioritize which areas to start first. a
Other GIS Utilization Sewer Main Tracing Tool
Start Trace
End Trace
Presenter
Presentation Notes
The sewer tracing tool is used to easily trace out all upstream lines that contribute to flow from a starting manhole. This has been used to calculate a SSO volume by selecting all of the properties connected to these lines and providing a count of commercial and residential properties. a
Field Integration Technology
Presenter
Presentation Notes
Field integration technology has had a very positive impact upon the Operations Department. And one of our more recent successes. There have been a number of efficiencies gained through the use of field integration technology, but one of the most significant benefit has been the availability of sewer system mapping and accessibility of GIS mapping information and asset data in the field. a
Increase Information Access
Collection system map and property lines
always current
Access to addresses, owner’s names
Access to maintenance history/pipe defect
Field notes & redlines available to all
Aerial views provide familiar benchmarks
Presenter
Presentation Notes
a Improvements made and information that is now accessible in the field: Current sewer maps, accurate property lines Ability to query addresses and owner manes Access to maintenance history & pipe defects Access to field notes & redlines Aerial view overlays to help locate structures and homes a Positive feedback from the maintenance staff shows their sentiment about this technology a
Increase Information Access
Feedback from the Operations Staff: “Having all of this information readily available puts the less experienced Maintenance Worker on the same playing field as the seasoned worker. From manhole locations, gate codes, low pressure lines, property access, etc.”
Presenter
Presentation Notes
a Improvements made and information that is now accessible in the field: Current sewer maps, accurate property lines Ability to query addresses and owner manes Access to maintenance history & pipe defects Access to field notes & redlines Aerial view overlays to help locate structures and homes a Positive feedback from the maintenance staff shows their sentiment about this technology a
Increase Maintenance Efficiency
All WOs auto loaded on laptop before shift
Cleaning data filled out using pull-down menu
Field data auto downloaded to CMMS at end of shift
a Some of the efficiencies gained using field integration technology includes: Laptops are docked and pre-loaded with WO before the shift begins Drop down menus reduce typing Maintenance documentation, notes & redlines are downloaded when laptops are docked at end of shift Use of GIS map and visual WO list allows Maintenace Staff to plan out cleaning route GPS in laptop helps MW locate themselves relative to property and structures a
Streamlined Input Screens
Auto-filled Main Info
Generous Use of Pulldowns reduces typing time
Green Highlights Shows Fields with Data Yellow Highlights Shows Fields Requiring Input
Presenter
Presentation Notes
Instead of issuing pages of paper WO that have hundreds of lines to clean and cleaning data to hand write, the MW can now enter data using pull-down menus. a
Screen Shots
Map shows all lines in WO to better schedule workflow
Presenter
Presentation Notes
GIS map lets the MW know what lines are on the WO. Looking at the expanded zoom, they can decide how best to route cleaning crews. a They can distinguish between lines that need to be cleaned vs those that have been completed. a a Line queries can provide asset information and notes (nozzle type, low pressure lines , etc.) a
Screen Shots
Closer view shows the individual lines on the WO
Presenter
Presentation Notes
GIS map lets the MW know what lines are on the WO. Looking at the expanded zoom, they can decide how best to route cleaning crews. a They can distinguish between lines that need to be cleaned vs those that have been completed. a a Line queries can provide asset information and notes (nozzle type, low pressure lines , etc.) a
Screen Shots
Line inquiry shows asset information and notes/comments
Presenter
Presentation Notes
GIS map lets the MW know what lines are on the WO. Looking at the expanded zoom, they can decide how best to route cleaning crews. a They can distinguish between lines that need to be cleaned vs those that have been completed. a a Line queries can provide asset information and notes (nozzle type, low pressure lines , etc.) a
Screen Shots
Lines completed
Presenter
Presentation Notes
GIS map lets the MW know what lines are on the WO. Looking at the expanded zoom, they can decide how best to route cleaning crews. a They can distinguish between lines that need to be cleaned vs those that have been completed. a a Line queries can provide asset information and notes (nozzle type, low pressure lines , etc.) a
Aerial View & Redline Edits
Use of Aerial View Provides MW w/ Reference Point to Find Manholes & Locate Property (especially on stormy nights)
X
Selected Property
Vehicle Location
Presenter
Presentation Notes
The ability to locate a property/manhole. Even those who are not as familiar with the entire district, can easily locate themselves on the map. Imagine yourself looking for a manhole in an overgrown easement late at night. Note the GPS location shown relative to the property being searched. a Field crew can provide edits and comments as they encounter changes in the field. a Edits are visible by the red circle denotation a a
Aerial View & Redline Edits
Field crews can provide edits and comments as they encounter them which are incorporated in system within a matter of days
Presenter
Presentation Notes
The ability to locate a property/manhole. Even those who are not as familiar with the entire district, can easily locate themselves on the map. Imagine yourself looking for a manhole in an overgrown easement late at night. Note the GPS location shown relative to the property being searched. a Field crew can provide edits and comments as they encounter changes in the field. a Edits are visible by the red circle denotation a a
Aerial View & Redline Edits
Presenter
Presentation Notes
The ability to locate a property/manhole. Even those who are not as familiar with the entire district, can easily locate themselves on the map. Imagine yourself looking for a manhole in an overgrown easement late at night. Note the GPS location shown relative to the property being searched. a Field crew can provide edits and comments as they encounter changes in the field. a Edits are visible by the red circle denotation a a
