leveraging strip map to build a sign inventory system · 12 benefits of sign inventory system...
TRANSCRIPT
Leveraging Strip Map to Build
a Sign Inventory System
John Nevares, P.E.
Austin District
1
Agenda
• Project Background
• Project Scope
• Benefits of Sign Inventory System
• Live Demonstration
• Challenges and Solutions
• Looking Forward
2
House Bill 1353
(75 mph speed limit)
Project Background - Regulatory Requirements
Establish speed limits up to 75
mph:
• TRF conducted speed studies
on high-speed roadways
• Austin District evaluated the list
• Update of speed limit signs and
strip maps was required
3
Project Background – Strip Map
General description of strip map
• A strip map is a document that records speed limits, roadway details, and
requires legislative approval
4
Project Scope:
– Project Location Map
600 Roadway Miles – 11 Counties
5
Project Scope:
– Strip Map
Strip Map Updates included the following:
• Field data collection of roadway details
• horizontal and vertical curves analysis
• Identifying new and existing cross streets, culverts, and other strip map
features
• Ball-banked and calculated curve advisory speeds
• Verify or update all speed related signs
6
Project Scope:
– Sign Inventory System
• Leveraged strip map work to add sign inventory system
• Smart, efficient use of time and budget
!( Guide Signs
!( Other
!( Regulatory Signs
!( Warning Signs
7
Project Scope:
– What is a Sign Inventory System?
• Multi-formatted GIS database
of signage
EXCEL
Google Earth
• Utilizes pull-down menus to
provide information:
Sign Type
Support Type
Anchor System
Sign Condition
Location
Date of Fabrication
MUTCD code
Photos
8
Benefits of Sign Inventory System
– Comprehensive Database (EXCEL)
9
Benefits of Sign Inventory System
– Map-based Interface (Google Earth)
10
Benefits of Sign Inventory System
– GIS Desktop Dashboard
11
Benefits of Sign Inventory System
– Signage Statistics
5,517
308
Acceptable Condition
Poor / unacceptable Condition
Number of Signs by Conditions
Total miles: 600
Total signs: 5,825
12
Benefits of Sign Inventory System
– Signage Statistics
County <5 Years
Old
5-10 Years
Old
10+ Years
Old
Date
Unknown
Bastrop 150 595 340 70
Blanco 123 180 196 66
Burnet 115 192 83 59
Caldwell 15 26 19 3
Gillespie 187 261 110 114
Hays 32 25 7 14
Lee 96 226 107 34
Llano 212 222 106 95
Mason 210 200 115 37
Travis 154 218 77 72
Williamson 177 361 66 71
25% 43% 21% 11%Data from initial 600 miles of roadway
13
Benefits of Sign Inventory System
– Example
Austin District
W8-13 Replacement*
(260 signs)
Bastrop
(34 signs)
SH 21 US 290SH 71
CS 0265-03
CS 0265-04
CS 0265-05
CS 0265-06
SH 304
Blanco
(26 signs)
Gillespie
(49 signs)
Lee
(24 signs)
Llano
(45 signs)
Mason
(29 signs)
Others
(53 signs)
4 signs
3 signs
5 signs
7 signs
W8-13 W8-13aT
Data from initial 600 miles of roadway
* Per MUTCD Requirement
14
Benefits of Sign Inventory System
– Example
Evaluate Priority Budget Implement
Replace if:
• Condition
• Plywood
• Bent
• Cracked
• Faded beyond
acceptable
• MUTCD
requirement
• Anchor or
foundation failure
• Age
Plan budget for each
fiscal year
• Learn our needs
& Availability
• Justify the budget
request
Prioritized by:
• Sign Condition
• MUTCD
requirement
• Date of fabrication
Plan:
• Create schedule
• Check inventory
• Order
• Replace
15
Benefits of Sign Inventory System
– Summary
Benefits
• Proactive approach to sign maintenance, budget planning,
and creation of work orders
• Complete log and understanding of District-maintained
signs
• Provides comprehensive data of each sign with accurate
location
• Easy to use – Ability to sort and manage signs
• GIS-format – EXCEL and Google Earth
Interesting StatsAnchor Types Percentage
• Triangular Slip Base (72%)
• Wedge Anchor (24%)
• All others (4%)
16
Demonstration
Download ArcGIS Collector to your smartphone or
tablet and try it out!
Login: Txdot.01
Password: txdot2015
https://ursattexas.maps.arcgis.com
17
Demonstration
Download ArcGIS Collector to your smartphone or
tablet and try it out!
Login: TxDOT_SC
Password: TxDOT2015
https://ursattexas.maps.arcgis.com Login: Txdot.01 Password: txdot2015
18
Challenges and Solutions
Challenge
Safety Field collection
Solution
Proper PPE, daily safety meetings,
hydration, vehicle safety
Data Storage Large data required
for data and photos
Data stored on ArcGIS server (ESRI)
for easy access and redundancy
backup
Organization Unique sign identifier Each sign has a unique ID by using
control section and given sign number
Efficiency Significant data
collection
Consolidate field work for strip map
and signage inventory
Consistency Consistent data
collected and
organized
Use MUTCD sign classifications, drop
down menus, and photos for
verification
https://ursattexas.maps.arcgis.com Login: Txdot.01 Password: txdot2015
19
Challenges and Solutions
ArcGIS Application
• Uses ArcGIS Collector on any computer, smartphone, or tablet
• Inputs and stores information
• Easily access information
• Creates queries and filters data
• Sign points store sign information as well as field photos
of sign face, anchor, and fabrication sticker.
• ArcGIS connects with Excel and Google Earth to create
files readable by anyone
https://ursattexas.maps.arcgis.com Login: Txdot.01 Password: txdot2015
20
Looking Forward
Looking Forward
• Maintenance, storage and ongoing updates to the database
• Training
• Develop sign history
• Proactive sign maintenance
• Budget
• Report labor, equipment, and material with increased accuracy
Sign Inventory System is an Asset Management Tool
• A system that monitors and maintains assets of value
• Helps to determine level of service in the most cost-effective
manner
• Scalable to fit any size or type project
https://ursattexas.maps.arcgis.com Login: Txdot.01 Password: txdot2015
21
Looking Forward
Asset Management Tool can apply to numerous disciplines:
• Bridges
• Culverts
• Illumination
• Signals
• ITS
• Signage
• Rumble Strips/Striping
• Drainage pipes
• Safety End Treatments
• And more…
https://ursattexas.maps.arcgis.com Login: Txdot.01 Password: txdot2015
22
Looking Forward:
– Project Map
Additional 1175 Roadway Miles – 3 Counties – Est. 25,000 signs
Urban – Strip maps older than 5 years
Rural – Strip maps older than 10 years
https://ursattexas.maps.arcgis.com Login: Txdot.01 Password: txdot2015
23
Partnership between:
John Song, PE, PTOE - Project Manager
Matt Williamson, PE - Task Lead
Gary Callahan - GIS Specialist
John Nevares, PE
Hector Tamez, PE
Mahendran Thivakaran, PE
David Baroi, PE
https://ursattexas.maps.arcgis.com Login: Txdot.01 Password: txdot2015
24
Questions?
https://ursattexas.maps.arcgis.com Login: Txdot.01 Password: txdot2015