Transportation Asset Management Webinar Series Webinar 22: Data - - PowerPoint PPT Presentation

Transportation Asset Management Webinar Series

Webinar 22: Data Governance and Implementation

Sponsored by FHWA and AASHTO Webinar 22 – August 25, 2016

FHWA-AASHTO Asset Management Webinar Series

• Sharing knowledge is a critical component of advancing asset

management practice

• This is the 22nd in a webinar series that has been running since

2012

• Webinars are held every two months, on topics such as
• ff-system assets, asset management plans, asset

management and risk management, and more

• We welcome ideas for future webinar topics and presentations
• Submit your questions using the webinar’s Q&A feature
• Next webinar October 12, 2016 2:00 PM EST — Tradeoffs

and Cross Asset Resource Allocation

1

Welcome and Overview

2

• Today’s presentations include four perspectives on data governance

in relation to transportation asset management programs and plans

• We will hear from practitioners and subject matter experts who can

share experiences and examples, including:

– Specific governance models for TAM data – Practices for using TAM data to add value to agencies’ decision-making – Impacts of good TAM data management on performance results.

• We will also have a topic introduction from Greg Slater of

Maryland DOT

– A summary of key concepts and an overview of available tools and resources

Learning Objectives

3

– Building working knowledge of key concepts and definitions relevant to data governance and Implementation for transportation asset management – Understanding specific models for data governance and their application to an agency’s TAM practice – Beginning to apply this knowledge in order to answer:

• How can agencies data governance models enhance the management of

infrastructure assets?

• What benefits can states expect by addressing data governance in

coordination with their TAM programs?

• What are the key lessons-learned for agencies seeking to strengthen data

governance capabilities as part of their TAM programs?

• SHARE LESSONS LEARNED, IDEAS, KNOWLEDGE!!!

4

Webinar Agenda

2:00 Webinar Introduction and Overview Steve Gaj (FHWA), and Hyun-A Park (Spy Pond Partners, LLC) 2:15 Data Governance and Implementation – Greg Slater (Maryland Department of Transportation) 2:30 Connecticut Perspective – William Pratt (Connecticut Department of Transportation) 2:45 National Perspective – Omar Smadi (Institute of Transportation, Iowa State University ) 3:00 City of Seattle Perspective – Emily Burns (Seattle Department of Transportation ) 3:15 Q&A and Wrap Up

AASHTO & FHWA TAM Webinar on TAM Data Governance and Implementation

• Data governance is the overall management of the

availability, usability, integrity, and security of the data employed in an entity (DOT/MPO/etc ).

• Asset Management is one area where data Governance is

crucial.

– Critical programmatic decision are made based on heavy influence

• f asset data

– Good data is key

What is Data Governance?

2

Data Principle

• 1. VALUABLE: Data is an asset
• 2. AVAILABLE: Data is open, accessible, transparent and shared
• 3. RELIABLE: Data quality and extent is fit for a variety of applications
• 4. AUTHORIZED: Data is secure and compliant with regulations
• 5. CLEAR: There is a common vocabulary and data definition
• 6. EFFICIENT: Data is not duplicated
• 7. ACCOUNTABLE: Decisions maximize the benefit of the data

Operationalizing AASHTO’s Data Principles

3

Transportation agencies adopting these principles – and putting them into action – should realize steady improvements to data value, and an increased return on their data investments.

A methodology, guide and tools to help agencies answer four key questions:

• Do we have the right data to make good decisions and

meet reporting requirements?

– What data do we need and why?

• Is our current data good enough?

– What level of accuracy, timeliness, completeness, etc. is needed?

• Are we making best use of our data collection and

management resources?

– Are we being efficient about how we collect and manage the data?

• Are we getting full value from the data that we have?

– Are users able to access, integrate and analyze it?

NCHRP 8-92: Implementing A Transportation Agency Data Program Self- Assessment

4

5

• Accessible Data for decisions and scenario planning
• Accurate data for effective evaluation of condition
• Reliable data to manage targets for performance in support
• f MAP-21

– Drive projects – Drive maintenance management – Utilize TSM

The importance of data governance associated with the federal requirements

6

Visualization

• Public GIS

dashboards

– Asset – Mobility

Tools to support data governance

7

Manage Data

• Enterprise GIS - Internal

Tools to support data governance

8

Launch Video

William S. Pratt PE

Principal Engineer - AEC Applications

Project/Asset Management and Implementation @ CTDOT

Capital Projects

• Obligation Plan Database (OBL) – MS Access

– Programming of Capital projects for roads and bridges – Unpublished project status tracking thru design

• CTCORE – PeopleSoft

– CT state government's integrated human resources, payroll, and financial system – Budgeting and payment thru project phases

• SiteManager – AASHTO

– Daily work reports – Contractor estimates and payments – Construction project information

• Composite Project Database

– Federated Project Data from the systems above

• ProjectWise Online

– Project/Asset documents

Current Authoritative Systems

Major Assets

(Assets that require an ID at Design Approval and have inspection documents)

• Bentley InspecTech

– Bridges, Structural Sign Supports, Span Poles and Buildings

• CTDOT Traffic Signal DB

– Traffic Signal Systems and Independent Signals

• ProjectWise Online

– Project/Asset documents

Current Authoritative Systems

Other Assets

• Deighton DTims

– Pavement

• EXOR Linear Reference System (LRS Location)

– Road Network, Road Classification, Traffic Monitoring, VIP and other measures – Traffic Signs (Implementing) – Guiderail (possible Implementation)

• TED - Transportation Enterprise Data (Spatial and LRS Location)
• (Open Source MapServer, SQL and GeoMoose UI)

– Capital Projects, Bridges and Traffic Signals

Current Authoritative Systems

GIS GIS

CTDOT Enterprise GIS

• Project Work Areas
• ROW Acquisition Parcels
• Facilities
• OSTA Permits
• Assets
• Bridge Deck Areas
• Traffic Signal Areas
• Ortho-imagery
• Hydraulics Info
• Soil Borings
• ROW
• Town, County, Regional

Boundaries

• Road Network
• Inventory
• NHS, Func Class
• Projects:
• Capital
• Maintenance VIP
• Assets:
• Bridges
• Traffic Signals
• Traffic Monitoring:
• AADT
• Accidents
• Public Transportation

Spatially Based Data (TED) LRS Based Data

CTDOT GIS Data

Federating Project/Asset Data

Federating Project/Asset Data

Federating Project/Asset Data

Federating Project/Asset Data

10

Year in Infrastructure 2015

Federating Project/Asset Data

• Past Locating and Tracking of Capital Projects

Capital Project Location and Tracking

Project Timeline

FDP Submittal Construction Completed Current Start of Project Tracking in PW (Manual Updates)

• Obligation Plan
• Core-CT

Contract Award

• Obligation Plan
• Core-CT
• Site-Manager

• Obligation Plan
• Core-CT
• Site-Manager

04_Contract-Processing

Project Phases

Current Time Project is Located in RIS

Contract Processing

02_Pre-Design

05_Construction

03_Final-Design

01_STIP 06_Completed

• Proposed Locating and Tracking of Capital Projects

Capital Project Location and Tracking

Project Timeline

RPM PROJECT INITATION Design Approval FDP Submittal Construction Completed Current Start of Project Tracking in PW (Manual Updates) Proposed Start of Project Tracking in PW (Auto Updates) & Proposed Time Project is Located in Exor

• Rough Polygon
• Extract Road Network

• Composite Project DB

Contract Award

• Obligation Plan data
• Core-CT data
• Site-Manager data
• Projects

• n the timeline if changes occur.

04_Contract-Processing

Project Phases

Current Time Project is Located in RIS 06_Completed

01_STIP

Contract Processing

03_Final-Design

05_Construction

02_Pre-Design

• Rough Polygon
• Extract Road Network

• Composite Project DB

• CAD Project Area
• CAD ROW Parcels
• Extract Road Network

• Composite Project DB

• CAD Polygon
• Extract Road Network

• Composite Project DB

• CAD Polygon
• Extract Road Network

• Composite Project DB

• CAD Project Area
• CAD ROW Parcels
• Extract Road Network

• Composite Project DB

Project Timeline

RPM Project Initiation Design Approval FDP Submittal Construction Completed Proposed Start of Project Tracking & Proposed Time Project is Located Contract Award 04_Contract-Processing

Project Phases

06_Completed

Contract Processing

03_Final-Design

02_Pre-Design

01_STIP

05_Construction

• Asset Integrated Data

Capital Project Location and Asset Tracking

Major Asset ID and Location Road Asset ID’s, Location, Cost & other Attribution Road Asset completion and field verification

• Modified
• Removed
• Added

2D/3D Models

Roadway Asset Developments

• Asset Stewardship

– Steward Assigned from Engineering – Liaison from Asset Management – Working Group

• Strategic
• Operations
• Data
• Roadway Assets Identified

Pavements Signals Bridges Signs Guiderail Sign Structures Curb Ramps Retaining Walls Lighting and Illumination

Data Governance and Implementation Punch List

• Develop Remaining Roadside Asset Data Models

– Prototype CAD to GIS (Capital Projects)

• Manage asset data during Design in a CAD environment
• Integrate new/effected assets with construction inspection application

(SiteManager) for location validation and any required attribution modifications

• Inspection acceptance triggers a transaction with asset’s authoritative

database

– Prototype Asset Field Capture (Maintenance, VIP and Encroachment Permits)

• Develop business requirements for asset field capture by Maintenance

personnel

Data andTAM

Omar Smadi CTRE/Iowa State University

Webinar 22: TAM Data Governance and Implementation August 25th, 2016

1,676 Pages

• Safety: 971 times
• Performance: 369
• Data: 361 times
• Condition: 171 times
• Performance Measures: 41 times
• Asset Management: 40 times

Data Buzz Words:

• Data-based decision making
• Performance based
• Accountability
• Transparency
• Efficiency

Managing Assets

design & construction

• Q3. Does your agency have an asset inventory?

Responses Percent Yes 43 100% No 0% Asset Yes Partial No Pavements 43 Bridges 43 Signs 33 6 4 Guardrail 27 8 8 Culverts 26 5 12 Other 23 20 Lighting 21 9 13 Pavement Markings 14 12 17 Retaining Walls 11 10 22 *Responses from 43 agencies Inventory

Asset Data

NCHRP Synthesis on AM Practices: 439

II-6

MIRE HPMS Pavements Bridges Safety RDIP Asset Management & Performance Measures

Collect once, use many, many times

Operations

• DATA
• DATA
• DATA

Garbage IN Garbage OUT

DATA Issues

• Integration
• Quality
• Access
• Cost
• Utilization
• Keeping up-to-date

DATA Issues

INFORMATION INTEGRATION

INTEGRATION

Data QA: Minimum Requirements

Data Element Accuracy Requirement

Curvature Length 100 feet (curves less than 1500 ft radius) Curvature Radius 100 feet (curves less than 1500 ft radius) PC 50 feet PT 50 feet Grade (+ or -) 1.0% Cross Slope/Super Elevation 1.0% Lane Width 1 foot Paved Shoulder Width 1 foot Inventory Features (signs) Location 7 feet

Control sites (2 per location-urban and rural) Random checks

Data Collection Manual

• TAM Objectives
• Asset Inventory/Condition
• Performance Gap
• Life Cycle cost
• Financial Plan
• Investment Strategies
• Risk Management

DATA and Asset Management

Data Governance

The data governance effort should include the following activities:

Catalog exiting data sets Identify which ones are critical Identify strategic data programs Evaluate systems and approve new applications Identify business needs Coordinate with data stakeholders Assess current data standards and coordinate

development of new standards

Establish quality control/quality assurance (QC/QA)

processes for all data being collected

Data Governance

Structure:

• Executive Group:

– Support – Financial decisions

• Governance Committee:

– Overall management of data

• Working Groups:

– Technical and asset specific

FHWA Recent/on-going Efforts

TAMP (Transportation AM Plan) Performance Measures HPMS (Highway Performance Monitoring System) RDIP (Roadway Data Improvement Program) MIRE (Model Inventory Roadway Elements) FDE (Fundamental Data Elements)

Lessons Learned

Location/Location/Location Data Quality No one reliable source of data (Data Integration is critical) Coordination/Communication (multiple stakeholders) Technology:

• Access
• Storage
• Cost

Questions?

FHWA/AASHTO TAM Webinar 22 TAM Data Governance and Implementation Emily M. Burns, PMP August 24, 2016

Seattle Department of Transportation Data Governance

TAM Data Governance

2

Asset Data

Asset & Performance Management Program AM / GIS / AM-WM db Systems T eam Asset Management Steering Committee Asset Owners Forum Asset Maintainer Data Users Group

Reporting & Performance Measures Data Driven Decisions

SDOT’s Integrated Systems

3

Hansen (Infor) AM/WM enterprise database BridgeWorks & StreetSaver Side Systems Geographic Information System (GIS) PeopleSoft Financials

Asset Onboarding - Gap Analysis

• Develop consistent asset onboarding standards &

metadata

• Develop better business processes for communicating

changes to assets

• Establish clear data maintenance responsibility for

assets that cross organizational lines

• Implement Mobile Computing
• Centralize Asset Data Maintenance – more resources
• Establish an Asset Data Users Group and improve

Governance

AM Data Users Group (AMDUG) - Mission

Im Improve SDO SDOT T trans nsportation n asset onb nboarding ng and nd data ma maintenance practices in order to support better asset in inventorie ies, management strategie ies, strategic ic in init itia iativ ives, bu budge dgeting, g, service levels, and d pe performance me metrics

AM Data Users Group - Purpose

• Introduce project as-built plans showing asset changes
• Provide dedicated staff to ensure database onboarding
• Quarterly QA/QC of asset data
• Identify and maintain “backlogged” asset data
• Examine data maintenance roles/responsibilities
• Support system enhancements, training, asset

categorization and hierarchy

• Document where data maintenance is working and not

working

• Identify new business processes and exchange “lessons

learned”

Asset Register Status

• What do we have?
• How much is it worth?
• Do we know the condition?
• Do we need to know the condition?
• Can we trust and rely on the data?
• Do we have accurate metadata?

Answers = Where we focus our resources

Three Inventory Collection Projects

Pr Project Sc Scope Who Who Pr Pros Co Cons Es

• Est. C

. Cost (y (yr.

• c
• ccurred)

As Asset Co Count Co Collection Ti Timeline Bike Rack Inventory Some knowledge of locations, Trimble units, only targeted urban villages, 20 attributes Interns Easy collection, used bikes, transit, minimal vehicles, good data quality Difficult to establish linear referencing associations w/

• Trimble. Asset Maintainer

not invested, lost rack installation data after inventory load ~$40k 2,600 Summer 2009 Curb Ramp Survey Survey of known ramp locations, Trimble unit, 75 attributes, builds on existing inventory (2007-2015) Consultant Met ADA req, redefined

• ur attributes, dissolved

silos in department

• rganization

Partial city coverage, collection tool not defined in contract, vendor not familiar w/ area, complex data – w/ 3 - 5% error rate, expensive ~$900k 27,000 ramps, 34,000 data records June 2015

• Feb

2016 Tree Collection T

• ol

Mobile field tool, GIS Collector, uses field devices, and batch loads data to Hansen daily, 30 attributes, builds on existing inventory (2007-2015) Crews / SME Volunteers Fast collection, performed during regular duties and volunteer counts, intuitive user interface, good data quality Updates in 2 systems, complex scripting, interim solution, risk of data loss with equipment loss ~$50k (dev

• nly)

16,600 Oct 2015

• June

2016 (ongoing)

Decision-Making Tools & Reporting

• Performance Dashboards:

– Performance Seattle: performance.seattle.gov – SDOT Capital Projects: capitalprojects.seattle.gov – Move Seattle: performance.seattle.gov/stat/goals/kppq-md9g

• Status & Condition Report:

seattle.gov/transportation/inventory.htm

• Value / Risk Based Performance T
• ols: Pavement, Signal,

curb ramp, and landscape maintenance prioritization models

• Council District Reporting:

seattle.gov/transportation/reports.htm

Visit our website for more information:

seattle.gov/transportation/assetmanagement.htm

Move Seattle Dashboard

Program Long-Range Plan

• Publish system-wide asset mapping for

public use

• Publish Streetcar Asset Management Plan

(AMP), Support State AMPs for Bridges / Pavement, and System-wide AMP

• Implement comparative risk and

prioritization model

Questions?

emily.burns@seattle.gov | (206) 733-9972 http://www.seattle.gov/transportation/assetmanagement. htm

www.seattle.gov/transportation

Questions?

• Submit your questions using the webinar’s Q&A feature

5

All webinars available online:

http://www.tam-portal.com/event/

Webinar 23 Tradeoffs and Cross Asset Resource Allocation Wednesday, October 12, 2016 – 2:00 PM EST Webinar 24 Life Cycle Planning in Transportation Asset Management Plans Wednesday, December 14, 2016 – 2:00 PM EST Webinar 25 TAM Communications Wednesday, February 8, 2017 – 2:00 PM EST

http://www.tam-portal.com/event/