Download
gis one call ticket management n.
Skip this Video
Loading SlideShow in 5 Seconds..
GIS One Call Ticket Management PowerPoint Presentation
Download Presentation
GIS One Call Ticket Management

GIS One Call Ticket Management

175 Vues Download Presentation
Télécharger la présentation

GIS One Call Ticket Management

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. GIS One CallTicket Management Improving the level of public service

  2. Presented By: Russell Camp, GISP Adam Galluzzo • City of Cedar Rapids • GIS Manager • City of Cedar Rapids • GIS Analyst

  3. 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)

  4. One Call Overview

  5. 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.

  6. 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

  7. 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.

  8. 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.

  9. How it works • Tickets are transmitted via FTP to Cedar Rapids

  10. How it works • Tickets reside in FTP folder as text files

  11. How it works Daily Audit E-mail Service OCTM – One Call Ticket Monitoring service. Emergency ticket e-mail and text notification

  12. How it works Records are created in the TICKETS Table on the SQL Server From the ticket files. Daily audit e-mails

  13. 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.

  14. One Call Web Application Demo

  15. 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

  16. 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 