gis one call ticket management
DESCRIPTION
GIS One Call Ticket Management. Improving the level of public service. Presented By:. Russell Camp, GISP. Adam Galluzzo. City of Cedar Rapids GIS Manager. City of Cedar Rapids GIS Analyst. One Call Overview. Commonly referred to as “Call Before you Dig” Goal of Iowa One Call: - PowerPoint PPT PresentationTRANSCRIPT
GIS ONE CALLTICKET MANAGEMENTImproving the level of public service
Presented By:
City of Cedar Rapids GIS Manager
City of Cedar Rapids GIS Analyst
Russell Camp, GISP Adam Galluzzo
One Call Overview Commonly referred to as “Call Before you Dig” Goal of Iowa One Call:
To protect citizens and prevent damage to underground facilities .
Free Service to excavators/homeowners Mandated by Law, (chapter 480, Iowa Code)
One Call Overview
City Owned
underground
utilities:
850 miles of Water Mains
725 miles of Sanitary Sewer Pipe
592 miles of Storm Sewer Pipe
130 miles of
Fiber Optic Cable
Locate Requests Old Method:
Excavator contacts Iowa one call (IOC) IOC records all necessary information, and
determines if the excavation is within the utility service area for Cedar Rapids
IOC E-mailed appropriate tickets (locate requests) to a designated Cedar Rapids e-mail inbox.
Tickets were printed daily and Office Staff and locators for each utility would sort through each ticket to determine if the excavation was near their underground utility.
Locate Requests Cedar Rapids receives Approximately
20,000 locate requests per year. X4 utilities (Water, Sewer, Signals, Fiber) =
80,000 80,000 X avg. 3 Min. per ticket for office
staff to sort and map (Arc Reader) = 4000 man hours per year.
Sorted tickets (paper copies) distributed to locate staff for field verification.
Located tickets returned to office staff for response.16 X 7 X
GIS Ticket Management The Need
To improve efficiency and reduce expense in the response to 20,000 + utility One-Call locates annually preformed by city staff for city owned utilities.
The Solution New GIS software application for processing
One-Call locate tickets.
GIS Ticket Management RFP issued
The City selected Pro West & associates to develop the GIS One-Call utility locate system. http://www.prowestgis.com
Pro West worked closely with stakeholders to develop the scope for the new GIS ticket management system.
The new system went live October 9th 2012.
How it works Tickets are transmitted via FTP to Cedar
Rapids
How it works Tickets reside in FTP folder as text files
How it works
Daily Audit E-mail Service
Emergency ticket e-mail and text notification
OCTM – One Call Ticket Monitoring
service.
How it worksRecords are created in the TICKETS Table on the SQL ServerFrom the ticket files.
Daily audite-mails
How it works
Daily Audit E-mail Service
Emergency ticket e-mail and text notification
OCTM – One Call Ticket Monitoring
service.
Accessing Spatial Data for maps
Applications:• One Call Web ApplicationScheduled Tasks•Geocode tickets every 5 minutes.•Create Address XMLZ file.•Update Days Old Field for ticket features.•Remove Cleared ticket points from feature classes.
Accessing One Call Web
Application
One Call Web Application Demo
Return on investment 3475.2 man hours re-directed to other
priorities Reduced incidents resulting in damage to city
owned infrastructure Increased accountability of locating staff Greater efficiency of locators, wireless
integration provides real-time GIS data access and search capabilities in the field.
Reduced paper/printing costs Increased service level to customers
Error notification One Call System e-mails staff error
messages if: Connection between CEDAR RAPIDS and
Iowa one call goes down ArcGIS Server goes down GIS or SQL connection goes down
Contingency application