An Integrated GIS approach to Municipal Pavement Management

1. An Integrated GIS approach to Municipal Pavement Management Presented By: Jeff Steele, City of Greensburg Michael Bieberitz, GISP, HNTB Corporation

2. An Integrated GIS approach to Municipal Pavement Management Here’s the Problem: The city of Greensburg Streets Department needed a way to: • Determine if the same streets were being paved more often than necessary. • Track historic project and material costs. • Estimate future project costs from assumptions based upon user input. (currently, this is done manually through a paper-based system.) Intro

3. City has a great GIS resource in use by some of other departments called GLANCE+ GLANCE+ Already in use by the city departments for several purposes

4. Sanitary GLANCE+

5. Water Utilities GLANCE+

6. Stormwater GLANCE+

7. Is there a way to adapt existing technology for new uses?

8. The Challenge • Develop a way to display and track projects from many years that can exist on the same piece of pavement. • Use existing GIS layers wherever possible. • Incorporate new street application into existing GLANCE+ The Challenge

9. Challenge: How do we get so many projects to live on the same piece of road? • Data Storage • Display • Solution: cross-reference table. The Challenge

10. What We Learned Along the Way • Challenge: Greensburg centerline file • Street segments generally stretch from intersection to intersection. • City discovered that many past projects didn’t extend entirely from intersection to intersection. How do we get an accurate cost estimate? • Solution: split lines into smaller segments. TheChallenge

11. Challenge: Splitting segments causes other problems. • Sometimes the entire segment is already part of another project. • Solution: Track split segments so they can be related to each project. The Challenge

12. What Does the application Look Like? • Select road segments on a map The Solution

13. Enter a few variables: • Width • Asphalt Cost • Historic prices of asphalt are also kept. • Utilities that could affect project costs The Solution

14. Form returns values for • Estimated tonnage • Estimated tack cost • Estimated total cost The Solution

15. Results • City entered projects from last five years to test accuracy of the product • Actual cost and tonnage of material used versus what software estimated • 130 projects completed between 2000 and 2005 Results

16. Results

17. Summary Results for all 130 Projects • Average Tack Coat Tonnage Used: • Estimated: 234.08 • Actual: 221.90 • Difference: +12.18 • % Difference: 5.4% • Average Project Cost: • Estimated: $8605 • Actual: $8095 • Difference: +$510 • % Difference: 6.3% Results

18. Findings: • Costs are a little inflated because centerline file stretches from center of intersection to center of intersection. • Projects are usually edge to edge, so we overestimate by about 5%. • Only 17 segments of road (totaling 1.22 miles) were paved more than once in the last five years. Results

19. Questions