gis & lrs for wvoasis (s etting up gis & lrs in wvoasis for transportation asset...
DESCRIPTION
Yueming Wu, Ph.D., GISP June 4, 2014. GIS & LRS for wvOASIS (S etting up GIS & LRS in wvOASIS for Transportation Asset Management). West Virginia Department of Transportation Division of Highways. Geospatial Transportation Information Section. Agenda. Background GIS in wvOASIS - PowerPoint PPT PresentationTRANSCRIPT
GIS & LRS for wvOASIS(Setting up GIS & LRS in wvOASIS for Transportation
Asset Management)
West Virginia Department of Transportation Division of Highways
Geospatial Transportation Information Section
Yueming Wu, Ph.D., GISP June 4, 2014
Agenda Background GIS in wvOASIS LRS in wvOASIS Setting up GIS & LRS in wvOASIS Near Future Plan Qs & As
Background
Background wvOASIS LRS
wvOASIS 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 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
4th Quarter
2012
1st Quarter
2013
2nd Quarter
2013
3rd Quarter
2013
4th Quarter
2013
1st Quarter
2014
2nd Quarter
2014
3rd Quarter
2014
4th Qtr
2014
1st Qtr 2015
2nd Qtr
2015Scope
Budget Development
Safety, Right of Way, Utility, Transportation Asset Inventory
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
HR/Payroll, Time & Leave, Position Control, Class & Comp, Benefits, Learning, EE Relations, Billing, EES
Transportation Ops & Assets, Safety, FHWA Billing, Fleet, Facilities & Real Estate, Travel, Federal Reciprocity
AchieveBuild
Phase EEnvision
Build Achieve
August 2013
January2014
July2014
January 2015
Phase AEnvision
Phase BEnvision
Phase DEnvision
Phase CEnvision
Build Achieve
Achieve
Achieve Build
Build
Build
wvOASIS LRS Interface Design Kickoff
A Snapshot of LRS Was Provided.
WVDOT Future ERP System Overview
ERP Suite
AASHTO SiteManagerTM
or PRS
AASHTO Trns*portTM
Construction Contractor Payments
CPMS
FHWA
Other Third Parties
ePermits & ebonds
Salvage Yards and Outdoor
Advertisting
Superload
DMV Cash Register
RailConnect
Materials Control, Soil and Testing
Gas and Lube
RoadwarePayment
Mgt System
Crash Reporting
System
Equip & MaterialUsage & Employee Time
3rd P
arty
Te
stin
g B
ills
Test Results
Project Information, Schedule and Budget
Project andGrant Billing
ConstructionContract Awards
Asset Inventory &Condition Information
CrashHistory
Existing WVDOT Systems
Future WVDOT Systems
External Systems
Advantage ERP and Agile Applications
LEGEND
FuelCosts
Employee,Equip, Inv Balances
WVDOT GIS
Project Authorization
ConstructionContract Awards
ReceiptsGeneralJournal
ParkwaysE-ZPass
TRANSPORTATION ASSET MANANGEMENT
● Maintenance Management ● RoW/Utility Management● Asset Inventory ● Real Estate/Facilities Mgt● Safety Management
Deighton Pavement
Management
InspecTechBridge
Management
Asset Inventory &Condition Info,
Project and Budget Info
Asset Inventory &Condition Info,
Project and Budget InfoInterface
WVDOT Enterprise GIS & LRS
(AgileAssets AMS)
LRS“ A linear reference system stores data using a relative position along existing line features. That is, location is given in terms of a known linear feature and a position, or measure, along it. For example, route I-10, mile 23.2, uniquely identifies a position in geographic space, and can be used instead of an x,y coordinate.”
(http://resources.arcgis.com/en/help/main/10.1/index.html#//003m00000002000000)
LRS @ WVDOT Two Linear Referencing Methods (LRMs)
o Countywide LRMo Statewide LRM
LRS Roadway Networko All Public Roads
• State Maintained Routes• Non State Local Streets
o Rampso Crossoverso Railroadso Routes De-segmented at Intersectionso Directionality
GIS in wvOASIS
GIS in wvOASIS/AgileAssets
AMS Client-Server GIS Solutiono GIS Explorer o Oracle Spatial: SDO_GEOMETRY
Other Featureso Support Spatial Data in Multiple Formatso Support Integration w/ Esri ArcGIS o Possess Simple Mapping Functions
GIS Explorer Easy-to-Follow GIS Layout Data from Multiple Sources in Multiple Formats Simple Symboligy Print or Export as PDF Map Save As Etc.
LRS in wvOASIS
LRS in wvOASIS/AgileAssets
AMS Two Linear Referencing Methodso Statewide LRM Base LRMo Countywide LRM Alternate LRM
All Public Roadso State Maintained Routeso Non State Local Streets
Railroads Special Road Network Features
o Network Gapso Concurrency
BASE LRM Routes
Mapping b/w Base LRM & Alternate LRM
Concurrent Routes (805 Concurrency)
Network Gaps (134)
Demonstration
Setting GIS & LRS in wvOASIS
WVDOT GIS/LRS Team = wvOASIS GIS/LRS Team
Goal Make Sure GIS & LRS in wvOASIS Seamlessly
Integrated into the WVDOT GIS & LRS Infrastructure
LRS and RoadwayCharacteristics Database
BridgeDatabase
Business DataEditing
LRS Editing
TrafficCount
Database
PvmtDatabase
ArcGIS Server and R&H
(Transactional Environment)
Business DataEditing
Business DataEditing
Browser with RCE and Road Analyzer for RCE (HQ Offices)
Browser with RCE and Road Analyzer for RCE (District Offices)
Browser with RCE and Road Analyzer for RCE (Local Gov’t Offices)Future Project
WebServices
Read Only Read Only Read Only
UpdateableViews orExtracts Published Data Structures
Read Only
Existing Viewing and Analysis Applications
R&H Desktopw/ WMX
Read Only
Various New WVDOTEnterprise Data
Analysis and Reporting
Applications
Ente
rpris
e An
alys
is a
nd R
epor
ting
LRS and Road Data M
aintenance
ERP DataEnvironment
WebServices Web
Services
WebServices
LRSData
ArcGIS Serverand R&H
(Published Environment)
WebServices
Read Only
WebServices
WebServices
Road AnalyzerTM
(Enterprise)
WebServices
UpdateableViews orExtracts
WebServices
Extracts
GTI-PubData
Geo-RILData
FHWA
HLS
Census
Various External Data Sources
Read Only &Extracts
What Have We Done? LRS Data Preparation for Phase B
o LRS Model Improvedo LRS Data Cleaned, Reformatted, Delivered, & Converted
GIS Data Preparation for Phase Bo Cultural/Economic/Social GIS Data Deliveredo Web Services Publishedo Business GIS Data Delivered (e.g. Right-of-Way)
Knowledge Transfero Training in March 2014
What Are We Doing? Maintaining GIS & LRS in wvOASIS/AgileAssets Implementing Esri Roads & Highways (R&H)
Solution Integrating R&H & AgilesAssets AMS
The Interface Between AgileAsset AMS & Esri R&H Data Exchange for LRS Updates & Related Event
Updates Functional Design Completed May 2013 In Production by December 2014
The Puzzle
ERP Suite
AASHTO SiteManagerTM
or PRS
AASHTO Trns*portTM
Construction Contractor Payments
CPMS
FHWA
Other Third Parties
ePermits & ebonds
Salvage Yards and Outdoor
Advertisting
Superload
DMV Cash Register
RailConnect
Materials Control, Soil and Testing
Gas and Lube
RoadwarePayment
Mgt System
Crash Reporting
System
Equip & MaterialUsage & Employee Time
3rd P
arty
Te
stin
g B
ills
Test Results
Project Information, Schedule and Budget
Project andGrant Billing
ConstructionContract Awards
Asset Inventory &Condition Information
CrashHistory
Existing WVDOT Systems
Future WVDOT Systems
External Systems
Advantage ERP and Agile Applications
LEGEND
FuelCosts
Employee,Equip, Inv Balances
WVDOT GIS
Project Authorization
ConstructionContract Awards
ReceiptsGeneralJournal
ParkwaysE-ZPass
TRANSPORTATION ASSET MANANGEMENT
● Maintenance Management ● RoW/Utility Management● Asset Inventory ● Real Estate/Facilities Mgt● Safety Management
Deighton Pavement
Management
InspecTechBridge
Management
Asset Inventory &Condition Info,
Project and Budget Info
Asset Inventory &Condition Info,
Project and Budget InfoInterface
Esri Roads & Highways
PHASE B
The Puzzle
ERP Suite
AASHTO SiteManagerTM
or PRS
AASHTO Trns*portTM
Construction Contractor Payments
CPMS
FHWA
Other Third Parties
ePermits & ebonds
Salvage Yards and Outdoor
Advertisting
Superload
DMV Cash Register
RailConnect
Materials Control, Soil and Testing
Gas and Lube
RoadwarePayment
Mgt System
Crash Reporting
System
Equip & MaterialUsage & Employee Time
3rd P
arty
Te
stin
g B
ills
Test Results
Project Information, Schedule and Budget
Project andGrant Billing
ConstructionContract Awards
Asset Inventory &Condition Information
CrashHistory
Existing WVDOT Systems
Future WVDOT Systems
External Systems
Advantage ERP and Agile Applications
LEGEND
FuelCosts
Employee,Equip, Inv Balances
WVDOT GIS
Project Authorization
ConstructionContract Awards
ReceiptsGeneralJournal
ParkwaysE-ZPass
TRANSPORTATION ASSET MANANGEMENT
● Maintenance Management ● RoW/Utility Management● Asset Inventory ● Real Estate/Facilities Mgt● Safety Management
Deighton Pavement
Management
InspecTechBridge
Management
Asset Inventory &Condition Info,
Project and Budget Info
Asset Inventory &Condition Info,
Project and Budget InfoInterface
Esri Roads & Highways
PHASE B
Near Future Plan
Near Future Plan Deploy Esri R&H on time Deploy the Interface on time Improve LRS Data Fine Tune GIS Explorer Improve Web Services Customize Develop Applications Etc.
Thanks to Others
o Carrie Haighto Dustin Lowerso Everett Perryo Jessica Perkinso Lingyang Cheno Marla Johnsono Robert Maynardo Etc.
IRGo Chuck Larson
AgileAssetso Abhishek Bhargavao Eric Perroneo Phil Hardyo Siamak Saliminejado Etc.
Esrio Adrien Littono Jackie Magnanto Silvia Casaso Will Isleyo Etc.
Transcend Spatialo Andrea Comptono Bill Schumano Jesse Jayo Steven Korzekwao Etc.