  West Virginia Department of Transportation



West Virginia Department of Transportation
Division of Highways
Geospatial Transportation Information Section





Background
Project Status
Lessons
Near Future Plan
Qs & As



Current LRS
Major Issues
Goal & Objectives

Development Completed in 2008
o Centerline Geometry: Acquired in 2003
o Measures: DMI Driven Distances Acquired Since 1960’s



State Maintained Routes Only
One LRM: Countywide Milepoint LRM
Maintained Using Esri ArcGIS
o Stored in SDE GDB on ArcSDE + MS SQL Sever
o Edited in ArcGIS Desktop


Published as Shapefiles/Web Services
Published on Official Highway Maps




No Non-State Maintained Public Roads
No Temporality
A Statewide Milepoint LRM Needed
Disconnection from Road Inventory Log (RIL)
o RIL: Official Roadway Measure Source

No System Integration w/ Exterior Business Systems
o Multiple Versions  Out of Sync

Geospatial Strategic/Business Plan
o 1st Version in 2010
o 2nd Version in 2012

Goal
o To Develop an Enterprise LRS for WVDOT & External Users

Objectives
o
o
o
o
o
o
o
o
Based on Modern LRS Data Model (e.g. Temporality)
Support FHWA Requirements
Statewide Road Network of All Public Roads
Sole Official Source to Locate Features & Attributes
Seamlessly Integrated with RIL
Part of WVDOT Enterprise GIS Infrastructure
Part of WVDOT Enterprise IS Infrastructure
Easy to Maintain

Development of LRS Data Model
o Integration of RIL and LRS

Data Preparation
o Conflation of State Maintained Routes and Non State Public Roads
o Integration of RIL and GIS
o Data Cleanup


Esri Roads & Highway (R&H) Solution
Lack of Resources
o Understaffed
o Few Experts on R&H
o Few Successful Cases of R&H Implementation
2014: A static copy
of LRS was provided
to wvOASIS in
January. Data
cleanup continued.
Model improved w/
RIL added. …
2012: Data conflation
completed. Data
cleanup continued.
wvOASIS (ERP)
became a key
potential user of ELRS.
2011: WVDOT initiated the
project after Esri R&H demo
at GIS-T. First LRS data
model developed by Esri.
Data conflation started.
Data cleanup started.
2013: Transcend
Spatial & Esri hired to
implement R&H and
system integration
and improve
calibration. Model
improved w/ a new
LRM & railroads
added. Data cleanup
continued.



Esri Roads & Highways Implementation
Calibration System Improvement
System Integration

Multiple Phases
o Phase 1: Prototyping
o Phase 2: Deployed in Test Environment
o Phase 3: Deployed in Production Environment
• Planning

R&H Version 10.2.2






Two LRMs
Network Gaps
Concurrent Routes
Road Inventory Log
Model Minimum Inventory of Roadway Element (MMIRE)
Extensibility

All Public Roads
o State Maintained
o Non-State Maintained





Ramps
Crossovers
Dual Carriageways
Railroads
Railroad Trails

Workflow Manager Extension
o Versioning

Three Generic Workflows
o Commissioner’s Order Process
o Route Editing
o Event or Roadway Characteristics Editor (RCE) Editing

Three Roles
o LRS Manager
o Route Editor
o RCE Editor



Measures are reset at county boundaries for all routes
except for Interstates whose measures are continuous
across the state.
Widely Used at WVDOT
Route ID Definition
o Examples: 20201190017NB; 20201190017NB058AF


Measures are continuous for all routes across the state.
Route ID Definition
o Example: 1006400-MLNB00; 2011900-20NB17058AF

DMI Driven Distance
o State Maintained Routes: Interstates, US Routes, WV Routes, etc.

Geometry Length
o Non-State Maintained Public Roads/Local Streets
o Ramps
o Cross Overs
o Railroads
o Railroad Trails







Sign System “R”
County Code “99”
Supplemental Code “99”
Sub-Route Code for Tracks
Direction Code “00”
Geometry Length for Measures
RouteID Examples
o Countywide Milepoint LRM: 99R0001019900
o Statewide Milepoint LRM: R000101-990099

Objectives
o Review Current Calibration System
o Make Recommendations

Current Calibration
o Beginning & Ending Points
o Measures from RIL

Calibration in R&H
o Beginning & Ending Points
o Intersections
o Break Points for Network Gaps & Concurrent Routes
o Measures from RIL & Geometry Length

Two APIs Published by R&H
o LRS Network Updates
o Event Relocation

Three Interfaces
o R&H Interface w/wvOASIS Agile’s Asset Management System
• Version 7
o R&H Interface w/ Deighton’s Pavement Condition System
• Version 9
o R&H Interface w/ Transmetric’s Traffic Server

Between Agile’s Asset Management System & Esri R&H
o Agile’s System V. 7
o R&H V. 10.2.2




Data Exchange for LRS Updates & Related Event Updates
Functional Design Completed May 2013
System Testing in November 2014
In Production by July 2015


Our Advanced Solution w/ Integrated Systems
Goals
o Replace multiple outdated, stand-alone system w/ one integrated
ERP System
o Standardize business processes & practices across the state
o Facilitate timely access to information for daily business

Multiple Phases
o Phase B: Safety, ROW, Transportation Asset Inventory, LRS, & GIS
o Phase E: Transportation Asset Inventory, Transportation Operations
Management, Capital Planning, Fleet, Facilities, Real Esate, & the
Interface w/ Esri R&H
4th
Quarter
2012
1st
Quarter
2013
Phase A
Envision
Phase B
Envision
2nd
Quarter
2013
Build
3rd
Quarter
2013
4th
Quarter
2013
Phase C
Envision
2nd
Quarter
2014
1st
Qtr
2015
2nd
Qtr
2015
Budget Development
GL, Budget Control, AP, Revenue
Accounting, Pcard, Grants, Cost
Accounting, Project Accounting,
Cash Management, Fixed Assets,
Investments, Purchasing,
Contracts, Inventory, Travel
Expense, Financial Transparency,
CAFR
Achieve
Build

Build
Phase E
Envision
Interface Completed
January
2014
HR/Payroll, Time & Leave,
Position Control, Class & Comp,
Benefits, Learning, EE Relations,
Billing, EES
Achieve
Transportation Ops & Assets,
Safety, FHWA Billing, Fleet,
Facilities & Real Estate, Travel,
Federal Reciprocity, LRS,
Transportation Asset Inventory
Build
August
2013
Scope
Safety, Right of Way, Utility,
Transportation Asset Inventory,
LRS
Build
LRS Interface Design Kickoff
4th
Qtr
2014
Achieve

Phase D
Envision
3rd
Quarter
2014
A Snapshot of LRS Was
Provided.
Achieve
Build
1st
Quarter
2014
July
2014
January
2015
PHASE B
Materials
Control, Soil
and Testing
Construction
Contract
Awards
AASHTO
Trns*portTM
Construction
Contract
Awards
DMV Cash
Register
AASHTO
SiteManagerTM
or PRS
Construction
Contractor Payments
3rd Party Testing Bills
Test Results
CPMS
RailConnect
Project
Authorization
Receipts
General
Journal
Project Information,
Schedule and Budget
ERP Suite
ePermits &
ebonds
Project and
Grant Billing
Salvage
Yards and
Outdoor
Advertisting
Employee,
Equip, Inv Balances
FHWA
Other Third
Parties
Equip & Material
Usage & Employee Time
Fuel
Costs
Superload
Parkways
E-ZPass
Gas and
Lube
TRANSPORTATION ASSET MANANGEMENT
● Maintenance Management
● Asset Inventory
● Safety Management
Asset Inventory &
Condition Information
Crash
History
Roadware
Payment
Mgt System
Crash
Reporting
System
LEGEND
● RoW/Utility Management
● Real Estate/Facilities Mgt
Asset Inventory &
Asset Inventory &
Condition Info,
Condition Info,
Project and Budget InfoProject and Budget Info
Deighton
Pavement
Management
WVDOT GIS
InspecTech
Bridge
Management
Existing WVDOT
Systems
Interface
Esri Roads &
Highways
Future WVDOT
Systems
External Systems
Advantage ERP and
Agile Applications
PHASE B
Materials
Control, Soil
and Testing
Construction
Contract
Awards
AASHTO
Trns*portTM
Construction
Contract
Awards
DMV Cash
Register
AASHTO
SiteManagerTM
or PRS
Construction
Contractor Payments
3rd Party Testing Bills
Test Results
CPMS
RailConnect
Project
Authorization
Receipts
General
Journal
Project Information,
Schedule and Budget
ERP Suite
ePermits &
ebonds
Project and
Grant Billing
Salvage
Yards and
Outdoor
Advertisting
Employee,
Equip, Inv Balances
FHWA
Other Third
Parties
Equip & Material
Usage & Employee Time
Fuel
Costs
Superload
Parkways
E-ZPass
Gas and
Lube
TRANSPORTATION ASSET MANANGEMENT
● Maintenance Management
● Asset Inventory
● Safety Management
Asset Inventory &
Condition Information
Crash
History
Roadware
Payment
Mgt System
Crash
Reporting
System
LEGEND
● RoW/Utility Management
● Real Estate/Facilities Mgt
Asset Inventory &
Asset Inventory &
Condition Info,
Condition Info,
Project and Budget InfoProject and Budget Info
Deighton
Pavement
Management
WVDOT GIS
InspecTech
Bridge
Management
Existing WVDOT
Systems
Interface
Esri Roads &
Highways
Future WVDOT
Systems
External Systems
Advantage ERP and
Agile Applications
Materials
Control, Soil
and Testing
Construction
Contract
Awards
AASHTO
Trns*portTM
Construction
Contract
Awards
DMV Cash
Register
AASHTO
SiteManagerTM
or PRS
Construction
Contractor Payments
3rd Party Testing Bills
Test Results
CPMS
RailConnect
Project
Authorization
Receipts
General
Journal
Project Information,
Schedule and Budget
ERP Suite
ePermits &
ebonds
Project and
Grant Billing
Salvage
Yards and
Outdoor
Advertisting
Employee,
Equip, Inv Balances
Fuel
Costs
Parkways
E-ZPass
Gas and
Lube
Other Third
Parties
Equip & Material
Usage & Employee Time
TRANSPORTATION ASSET MANANGEMENT
(Agile’s System)
Superload
● Maintenance Management
● Asset Inventory
● Safety Management
Asset Inventory &
Condition Information
Crash
History
Roadware
Payment
Mgt System
Crash
Reporting
System
LEGEND
● RoW/Utility Management
● Real Estate/Facilities Mgt
Asset Inventory &
Asset Inventory &
Condition Info,
Condition Info,
Project and Budget InfoProject and Budget Info
Deighton
Pavement
Management
WVDOT GIS
InspecTech
Bridge
Management
FHWA
Existing WVDOT
Systems
Interface
Esri Roads &
Highways
Future WVDOT
Systems
External Systems
Advantage ERP and
Agile Applications




Have a Strategic/Business Plan
Do an Enterprise System Design
Leverage External Resources
Don’t Deploy Two Systems Simultaneously!

By March 2015
o Deploy Esri R&H in Production Environment – Phase 3 (TBD)
o Get the Interface w/ Agile’s System Ready for Deployment



Keep Cleaning up the Data
Work w/ Business Programs to Improve Asset Data
Configure
o Support More Workflows
o Make RCE More User Friendly

Customize
o Extend R&H Functionality
o Support More System Integration
o Make LRS More User Friendly

Improve
o Add New LRMs (Address Ranges, Cross Street Referencing, etc.)
Web
Services
Web
Services
ERP Data
Environment
Road AnalyzerTM
(Enterprise)
Web
Services
Web
Services
Read Only
Extracts
Read Only
LRS
Data
LRS and Roadway
Characteristics Database
Web
Services
Esri R&H
Solution
Updateable
Views or
Extracts
R&H Desktop
w/ WMX
Read Only
Read Only &
Extracts
Updateable
Views or
Extracts
Web
Services
Web
Services
Geo-RIL
Data
Published Data Structures
Web
Services
LRS Editing
GTI-Pub
Data
Read Only
Read Only
Read Only
Bridge
Database
Traffic
Count
Database
Pvmt
Database
Various New WVDOT
Enterprise Data
Analysis and
Reporting
Applications
Web
Services
ArcGIS Server
and R&H
(Transactional
Environment)
LRS and Road Data Maintenance
Business Data
Editing
Browser with RCE and Road
Analyzer for RCE (HQ Offices)
Census
HLS
Business Data
Editing
Business Data
Editing
Enterprise Analysis and Reporting
ArcGIS Server
and R&H
(Published
Environment)
Existing Viewing and
Analysis Applications
Browser with RCE and Road
Analyzer for RCE (District Offices)
Browser with RCE and Road Analyzer
for RCE (Local Gov’t Offices)
Future Project
FHWA
Various External
Data Sources

IRG
o

Abhishek Bhargava
Eric Perrone
Phil Hardy
Siamak Saliminejad
Tyler Pauley
Etc.
Esri
o
o
o
o
o
o

Chuck Larson
AgileAssets
o
o
o
o
o
o


Adrien Litton
Bruce Field
Jackie Magnant
Silvia Casas
Will Isley
Etc.
Transcend Spatial
o
o
o
o
o
Andrea Compton
Bill Schuman
Jesse Jay
Steven Korzekwa
Etc.
Others
o Carrie Haight
o Dustin Lowers
o Everett Perry
o Jessica Perkins
o Kyle Weatherholt
o Lingyang Chen
o Marla Johnson
o Robert Maynard
o Robin Goff
o Roger Dorsey
o Shiriedel Acayan
o Etc.