Paper - Esri

X
W
West Virginia Department of Transportation
Division of Highways
Geospatial Transportation Information Section
Y
Y
Y
Y
Y
Background
Project Status
Lessons
Near Future Plan
Qs & As
Y
Y
Y
Current LRS
Major Issues
Goal & Objectives
Y
Development Completed in 2008
o Centerline Geometry: Acquired in 2003
o Measures: DMI Driven Distances Acquired Since 1960’s
Y
Y
Y
State Maintained Routes Only
One LRM: Countywide Milepoint LRM
Maintained in Esri ArcGIS
o Stored in SDE GDB on ArcSDE + MS SQL Sever
o Edited in ArcGIS Desktop
Y
Y
Published as Shapefiles/Web Services
Published on Official Highway Maps
Y
Y
Y
No Non-State Maintained Public Roads
A Statewide Milepoint LRM Needed
Not Closely Tied to Road Inventory Log (RIL)
o RIL: Official Roadway Measure Source
Y
No System Integration w/ Exterior Business Systems
o Multiple Versions
Y
Geospatial Strategic/Business Plan
o 1st Version in 2008
o 2nd Version in 2012
Y
Goal
o To Develop an Enterprise LRS for WVDOT & External Users
Y
Objectives
o Based on Modern LRS Data Model
o Statewide Road Network of All Public Roads
o Sole Official Source to Locate Features & Attributes
o Seamlessly Integrated with RIL
o Part of WVDOT Enterprise GIS Infrastructure
o Part of WVDOT Enterprise IS Infrastructure
o Easy to Maintain
Y
Development of LRS Data Model
o Integration of RIL and LRS
Y
Data Preparation
o Conflation of State Maintained Routes and Non State Public Roads
o Integration of RIL and GIS
o Data Cleanup
Y
Y
Esri Roads & Highway (R&H) Solution
Lack of Resources
o Unstaffed
o High Turn Over
o No ELA
2014: A static copy
of LRS was provided
to wvOASIS in
January. Data
cleanup continued.
Model improved w/
RIL added. …
2012: Data cleanup
continued. Data
conflation completed.
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 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.
Y
Y
Y
Esri Roads & Highways Implementation
Calibration System Improvement
System Integration
Y
Multiple Phases
o
o
o
Y
Y
R&H Version 10.2.2
Comprehensive LRS Data Model
o
o
o
o
o
o
Y
Phase 1: Prototyping
Phase 2: Deployed in Test Environment
Phase 3: Deployed in Production Environment Å TBD
Two LRMs
Network Gaps
Concurrent Routes
RIL
MIRE Data Items
Extensible
Complete Roadway Centerline Dataset
o
o
o
o
o
All Public Roads: State Maintained & Non-State Maintained
Railroads
Ramps
Crossovers
Dual Carriageways
Y
Y
Y
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
Y
Y
Measures are continuous for all routes across the state.
Route ID Definition
o Example: 1006400-MLNB00; 2011900-20NB17058AF
Y
DMI Driven Distance
o State Maintained Routes: Interstates, US Routes, WV Routes, etc.
Y
Geometry Length
o Non-State Maintained Public Roads/Local Streets
o Railroads
o Ramps
o Cross Overs
Y
Y
Y
Y
Y
Sign System “R”
County Code “99”
Supplemental Code “99”
Geometry Length for Measures
RouteID Examples
o Countywide Milepoint LRM: 99R0001019900
o Statewide Milepoint LRM: R000101-990099
Y
Objectives
o Review Current Calibration System
o Make Recommendations
Y
Current Calibration
o Beginning & Ending Points
o Measures from RIL
Y
Calibration in R&H
o Beginning & Ending Points
o Intersections
o Break Points for Network Gaps & Concurrent Routes
o Measures from RIL & Geometry Length
Y
Two Web Services Published by R&H
o LRS Network Updates
o Relocate Events
Y
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
Y
Between Agile’s Asset Management System & Esri R&H
o Agile’s System V. 7
o R&H V. 10.2.2
Y
Y
Y
Y
Data Exchange for LRS Updates & Related Event Updates
Functional Design Completed May 2013
Being Tested
In Production by December 2014
Y
Y
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
Y
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
W
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
Ki k
4th
Qtr
2014
Achieve
X
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
Y
Y
Y
Y
Start Data Conflation ASAP if Needed
Start Data Cleanup ASAP
Leverage External Resources
Don’t Deploy Two Systems Simultaneously
Y
By December 2014
o Deploy Esri R&H in Production Environment – Phase 3 (TBD)
o Deploy the Interface w/ Agile’s System
Y
Y
Y
Keep Cleaning up the Data
Work w/ Business Programs to Improve Asset Data
Configure
o Support More Workflows
Y
Customize
o
o
o
o
Y
Extend R&H Functionality
Support Reporting
Support More System Integration
Make the Usage of 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
Y
IRG
o
Y
Abhishek Bhargava
Eric Perrone
Phil Hardy
Siamak Saliminejad
Tyler Pauley
Etc.
Esri
o
o
o
o
o
o
Y
Chuck Larson
AgileAssets
o
o
o
o
o
o
Y
Y
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 Etc.

Download Report