190 likes | 284 Views
Advancing Technologies for Working with Underground Utilities Current SHRP 2 Research. Overview of SHRP 2 Utilities Products. R01 - Encouraging Innovation in Locating and Characterizing Underground Utilities
E N D
Advancing Technologies for Working with Underground UtilitiesCurrent SHRP 2 Research
Overview of SHRP 2 Utilities Products • R01 - Encouraging Innovation in Locating and Characterizing Underground Utilities • R01(A) - Technologies to Support Storage, Retrieval, and Utilization of 3-D Utility Location
Overview of SHRP 2 Utilities Products • R01(B) - Utility Locating Technology Development Utilizing Multi-Sensor Platforms • R01(C) - Innovation in Location of Deep Utility Pipes and Tunnels
Overview of SHRP 2 Utilities Products • R15(B) - Identification of Utility Conflicts and Solutions, also referred to as Utility Conflict Management • R15 - Strategies for Integrating Utility and Transportation Agency Priorities in Highway Renewal Projects (COMPLETED)
Utility Conflict Management • Online survey of 50 states • 103 responses - 34 states • Follow-up interviews • 38 interviews - 23 states • Feedback workshops • Texas, California and Georgia • Pilot training workshops • Arkansas and South Dakota
Utility Conflict Management • Prototype 1: UCM spreadsheet • Microsoft Excel • Prototype 2: Utility conflict database and data model • Microsoft Access
Utility Conflict Management • Prototype 1 • Benefits • Easy to use • Simple to implement • Inexpensive implementation • No I.T. involvement required • Limitations • No relational data structure • Not designed for data querying • Not designed for complex reports
Utility Conflict Management • Prototype 2: Microsoft Access • Flexible design & structure • Based on large number of diverse UCMs • Uses state-of-the-art data model • Enterprise database support (Oracle, SQL Server,…) • Relational • Can link to existing DOT data systems • Scalable • Add records in lookup tables as needed
Utility Conflict Management • Prototype 2 • Benefits • Powerful reports • Adapts to business process • Link to existing DOT data • Avoids redundancies • Built-in tracking & archiving • Simple customization
Utility Conflict Management • One Day Training Course • Extensive hands-on utility conflict exercise • Training Materials • Presenter notes and participant handouts • Sample project plans • UCM templates • Companion CD • All training materials • UCM (Excel Spreadsheet) • Utility conflict database (Microsoft Access)
TRB Webinar – New SHRP 2 Tools for Underground Location Data Collection & Analysis • Field testing of prototype versions now underway, webinar will present the preliminary results • February 15, 2012 from 1:00 to 3:00 PM • Registration - http://www.trb.org/Main/Blurbs/166549.aspx