GIS One CallTicket 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: • To protect citizens and prevent damage to underground facilities . • Free Service to excavators/homeowners • Mandated by Law, (chapter 480, Iowa Code)
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 OCTM – One Call Ticket Monitoring service. Emergency ticket e-mail and text notification
How it works Records are created in the TICKETS Table on the SQL Server From the ticket files. Daily audit e-mails
How it works Daily Audit E-mail Service OCTM – One Call Ticket Monitoring service. Emergency ticket e-mail and text notification Accessing One Call Web Application • Applications: • One Call Web Application Accessing Spatial Data for maps • Scheduled Tasks • Geocode tickets every 5 minutes. • Create Address XMLZ file. • Update Days Old Field for • ticket features. • Remove Cleared ticket points • from feature classes.
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