Two Days, 500 Signs

1
Two Days, 500 Signs
Brandon Brown GIS Administrator City of Dublin
2
Overview

• In timeline fashion
• - Description of the project
• - Collection Methods
• - Products
• - Refinement
• Questions and Comments

3
Dublin, Ohio
4
Project Timeline
Pre 2005

• Memorial Tournament Staff
• Fabricates and installs all signage
• Same staff/volunteers
• No cohesive maps or notes
• Rely on institutional knowledge
• City of Dublin - Engineering
• Installs Trailblazers only
• City of Dublin - GIS
• No involvement

5
Project Timeline
2005
Pre 2005

• Memorial Tournament Staff
• Fabricates and installs all signage
• Begins knowledge transfer
• Phased over two years
• City of Dublin - Engineering
• Installs Trailblazers only
• Assists GIS staff GPS locate and photograph all
  signage
• City of Dublin - GIS
• Develops and tests data collection methods
• Collects sign data
• High grade GPS for on-course signage
• Windshield survey/low grade GPS for exterior
  signage
• Develops products for all parties

6
Collection Methods
2005
Pre 2005

• Requirements
• Week of tournament
• Work to be completed in two days
• No disruption of event (shhhquiet please)
• Course Signage
• Two teams of two
• Trimble GeoXT
• Digital camera
• Exterior Signage
• One team of two
• Laptop USB GPS receiver
• Digital camera
• Jeep

Reenactment
7
Data Manipulation Methods
2005
Pre 2005

• Combining the point features with the images
• Before each capture session
• Camera image number reset to 0001
• New feature class created
• Had to ensure 1 point/1 image
• Hotlink field populated
• Creating Information Image inspection
• Arrow direction, sign text, attachment type and
  notes were entered during image inspection
• Lessons Learned
• Time stamp matching
• Geodatabase domains
• Contingencies

8
Results
2005
Pre 2005

• Sign Totals
• 691 Total Signs
• 448 on Course
• 243 Roadway
• Time and Travel
• Walking
• 5 miles per person
• 20 hours
• Driving
• 100 miles driven
• 20 hours

9
Products
2005
Pre 2005

• ArcReader
• ArcReader application delivered to Memorial
  Tournament Staff
• Report
• Data report to Engineering
• Sign count, types, etc.
• Images available

Category Report Exterior 15 Trailblazer
19 Sky Suite 24 Parking Directional
36 Directional 58 Parking 60 Corp.
Hospitality 64 Parking Lot 167 MVGC
248 TOTAL 691 Sign Location In Muirfield
Sub-Division 493 Outside Muirfield Sub-Division
198
10
Project Timeline
2005
2006
Pre 2005

• Memorial Tournament Staff
• Installs course and parking lot signage
• Teams with Engineering staff to install exterior
  signage
• Verifies and uses GIS created data
• City of Dublin - Engineering
• Fabricates and installs ½ of exterior signage
• Teams with Memorial Tournament staff to install
  exterior signage
• Verifies and uses GIS created data
• City of Dublin - GIS
• Post tournament process review and data
  additions from field notes

11
Project Timeline
2005
2006
2007
Pre 2005

• Memorial Tournament Staff
• Installs course and parking lot signage
• Communicates with Engineering for special needs
• City of Dublin - Engineering
• Fabricates and installs all exterior signage (no
  parking lots)
• Installs sign anchors
• ID tag all exterior signs
• City of Dublin - GIS
• Thermo markers near anchors (late Winter)
• High grade GPS update of anchor locations
• Location verification and photo update
• Develops new products

12
Products
2005
Pre 2005
2006
2007

• Memorial Staff
• Data report course sign frequency
• Course sign location maps
• Sign Data Manual for all parties
• One page per sign
• Multiple scale images

13
Products
14
Products

• Priorities
• Highest
• Lowest

15
Project Timeline
2005
2006
2007
2008
Pre 2005

• Memorial Tournament Staff
• Installs on-course signage
• Communicates with Engineering for special needs
  (new/replacement signs)
• City of Dublin - Engineering
• Fabricates and installs all exterior signage
  (including parking lots)
• Uses sign ID tags and data manual to sequence
  their installation process
• City of Dublin - GIS
• After sign installation - teams with Engineering
  for location verification, new sign location and
  photo update
• Update and distribution of products to all
  parties

16
Savings
2005
2006
2007
2008
Pre 2005

• Muirfield Staff
• Installation
• 243 street signs
• 250 parking lot signs
• 2 weeks
• Responsiveness
• Sign replacement
• Days

17
Further Data Usage
18
The Future and Other Thoughts

• Installation
• Truck based computer/GPS
• Collection
• GPS camera
• Populate EXIF from Trimble GeoXT
• Update course sign data
• Products
• Continued refinement of data manual
• Digital manual
• Web access

19
Questions and Comments
http//www.dublin.oh.us/gis/index.phpBrandon
Brown GIS AdministratorCity of
Dublinbbrown_at_dublin.oh.us614 410 4453