How GIS Can Assist With Other Public Works Departments

by Chris Peal

Transcript

1. T R A N S P O R T A T I O N & U T I L I T I E S How GIS Can Assist With Other Public Works Departments
2. About Temple —  City Population of 66,102 (2010) —  City Limits Approximately 70 Square Miles —  Approximately 1,350 Lane Miles Of Roadway (1,000 City Maintained/350 State Maintained) —  580 Miles Of Water Line (7,500 Valves, 3,100+Hydrants) —  375 Miles Of Sewer Line (5,300 Manholes) —  130 Miles Of Storm Drain Line (4,100+ Inlets) —  63 Traffic Signals Maintained
3. Temple GIS & Public Works — Public Works GIS Division Created in Early 2008 — All Utility Data Was In AutoCAD Format — All Maps Were In .DWF Format — DWF Format Map Had Been Utility Standard For Many Years
4. AutoCAD Utilities.dwf Map —  Last DWF Map Created In Sept 2008. —  Map Was Only Accurate To Time Of Creation & Was Very Cumbersome. (Snapshot of Time)
5. Migration to GIS , As-Built Webpage, & Map Evolution —  In Late 2008 All AutoCAD Data Was Migrated To GIS Shape Files. —  Added Material, Year Installed, & As-Built Number For All Utility Lines & Street Sections. —  Created As-Built Webpage In Microsoft Word
6. ArcReader Maps —  Developed ArcReader Map Primarily For Utilities —  Created ArcReader Maps That Were Department Specific (Streets, Drainage, Engineering, Etc) —  Problem With ArcReader Was These Were Only Snapshot Of Data At Time Of Creation. —  In 2012 Moved To Online Maps So Data Viewed Is Real-Time. Most Prominent Online Map Used Is GeoBlade Due To Its Compatibility With HTE Asset Management Software.
7. Maps Old & New Arc Reader Map • Snapshot Of Time • Time Consuming To Create • Has To Be Updated Regularly • Live Data • More User Friendly • Connects To Asset • Management Software GeoBlade Map
8. Identification Ability
9. Bird Creek I&I —  Numerous Overflows In One Area. —  GPS’d All Manholes Along Creek —  Provided Map To Utilities To Remedy Issue —  This Map Used In 2012 ESRI Plenary Session
10. Mapping Work Orders —  Can Now Map Work Orders —  These Are Tree Trimming Hot Spots
11. Pavement Analysis: Assessment Form —  Evaluation Form Was Developed In-House —  Early On In Assessment Streets Were Evaluated Using This Form. —  This Form Was Moved Into GPS Unit
12. Pavement Analysis —  Done 100% In- House. —  Used Trimble Juno & 1 Street Crew Member —  Completed Feb ‘09-Jan ‘10
13. Pavement Assessment Results —  Results : (By Grade) A)31.2% B)36.6% C)21.9% D)9.0% F)1.3% •  Recommended: 5- Person Crackseal Crew (Approved & In Service) Increase Sealcoat & Mill/Overlay Budget (Approved) Fill 2 Equipment Operator Positions
14. Cracksealing —  Cracksealing Began In October 2010. —  Over 100 Miles Of Roadway Have Been Sealed
15. Sign GPS —  Professional Pavement Products 922 Handheld Sign Reflectometer GPS Purchased (Not To Be Confused With The Illudium Q-36 Explosive Space Modulator!) —  Since January 2012 500 Signs Have Been GPS’d. —  All Signs That Are Replaced Are GPS’d.
16. Sign GPS —  Data Is Downloaded Into Spreadsheet Once Sign Is GPS’d. —  Spreadsheet Is Converted Into Shape File For GIS Records. —  Shape File Is Converted Into Google Earth File For Viewing By Streets Director To Keep Track Of Progress.
17. Creek GPS —  Hog Pen Creek —  Two 2-Man Crews GPS’d Over 3 Days In June/July 2012 —  Creek Length Is 5.48mi —  Council Required Performance Measure —  1st of 9 Creeks To Be GPS’d —  Is 3rd Longest Creek In City
18. Traffic Signals —  Traffic Signal Attribute Data Has Been Added To Signal Shapefile. —  Where As Builts Are Available, Conduit & Pullbox Info Has Been Added.
19. Water/Sewer Division How GIS Has Benefited Water/Sewer Division —  Asset Inventory Ability —  Tracking Water Leaks, Sewer Overflows & Rain Event I&I’s —  Ability To See Line Size, Material, & Year —  Ability To View Map Data In Field & Pull Up As- Builts Without Need To Come Into Office —  GPS’d Hydrants, Valves, & Dead-End Mains —  Office Staff Has The Ability To Make Their Own Maps For Utility Locates
20. Streets Division How GIS Has Benefited Streets Division —  Mapped All Sealcoats & Overlays from 1999-Current —  GPS’d Storm Drain Inlets & School Zones —  Foremen Can Look Up ROW Width /Easement Info Without Help From GIS Personnel —  Conducted Pavement Assessment —  Pavement Assessment Led To Addition Of Cracksealing Crew —  Now Have A Long-Range Plan Of Capital Improvements/Additions To City Streets
21. Presenters Kenny Henderson-Director of Streets khenderson@templetx.gov Thomas Brown-Director Of Distribution & Collection (Water/Wastewater) tbrown@templetx.gov Aaron Gonzales-Mapping/GIS Manager agonzales@templetx.gov Chris Peal-GIS Specialist cpeal@templetx.gov