280 likes | 422 Views
WVDOT Transportation Roadway Network and ERP Overview, Deployment, and Application In The District and Central Offices. Hussein S. El Khansa Geospatial Transportation Information Section Program Planning & Administration Division Division of Highways
E N D
WVDOT Transportation Roadway Network and ERP Overview, Deployment, and Application InThe District and Central Offices Hussein S. El Khansa Geospatial Transportation Information Section Program Planning & Administration Division Division of Highways West Virginia Department of Transportation
Agenda • GIS Program at WVDOT • Enterprise GIS Development at WVDOT • Geospatial Resources at WVDOT: • EsriRoads & Highways • ERP(wvOASIS) - Asset Management System • Questions & Discussion
GISProgramatWVDOT Program Planning & Administration Division Geospatial Transportation Information (GTI) Section Highway Data Services Unit GIS Unit • Roadway Inventory Log • - Roadway Statistics • - Public Certified Mileage - Geospatial Data Management - Geospatial Services
Ongoing Major GIS Projects • Support for ERP(wvOASIS) - Asset Management System • Our Advanced Solution with Integrated Systems • Enterprise GIS Development • ProjectWise Implementation • Transportation GIS Data Collection • GIS Portal • New Straight Line Diagram • New Highway Maps • Web Mapping Applications • 3D GIS
Data Sources WVDOT • Routes (linear referencing system, LRS) • Non-State Public Routes (NSPR) • Ramps • Roadway Inventory Log (RIL) New county-level geometry and attribute edits • Local roads • Segmentation - split geometry at intersections (nodes) • Addressing
Methods Overview • Automated geoprocessing steps to combine WVDOT and SAM data for entire state • Deploy into new LRS data model for Esri Roads and Highways (R&H)
Future Project Ideas • Improved Federal Highway Performance Monitoring System reporting • Enhanced connections to local routes on printed and web-based maps • Updated routing for analysis – desktop and web mapping • Maintenance materials acquisition • Coal Resource Transportation System (CRTS)
ESRI Roads and Highways • Advanced Linear Referencing System capabilities. • Easily manage, visualize, and analyze roadway networks and associated data for better planning, management, and maintenance. • Intelligently manage the location and position of asset data and information. • Use a workflow-driven process to improve quality and simplify management and maintenance of roadway geometry and asset data. • Integrate with existing roadway data and information stored in separate data systems. • Redlining capabilities to allow district and other central offices the ability to submit edits to our roadway network and assets.
WVDOT “To-Be” Target GIS Conceptual Architecture Production Environment Automated ETL WVDOT Maps PDF and Shapefile Download ArcGIS Desktop 10 w/Two-Tier QA Versioning Strategy WVDOT Web Portal LRS SLD HPMS ITA ERP GIS Web Services Future Services GIS Portal Publication GDB, WM (SQL Server/SDE) Publication GDB, UTM (SQL Server/SDE) Web Server ArcGIS Server ArcGIS Flex API ArcGIS JavaScript API IIS One-Way Replication One-Way Replication 10 District Offices Mobile Field Crews ArcGIS Desktop ArcGIS Server Extensions Develop/Test Applications Tools Esri PRODUCTION MAPPING CARTOGRAPHIC Production Editing GDB LRS/Events (SQL Server/SDE) Two-Way Replication District Offices GDB DGN (MicroStation) Esri Interoperability Extension Esri Roads & Highway Solution MicroStation DGN WMS HR Finance State Rail Authority Maintenance, Materials, ROW, Engineering, Traffic Engineering …………….…………………………………….. Two-Way Replication Live Or Disconnected InRoads Parkways Traffic Engineering Maintenance Districts Engineering HDS RIL AAAD Primavera P7 AASHTO Trns*port Site Manager Contracts Project Location Develo pment Development Environment Virtual Server Staging Publication GDB (SQL Server/SDE) Mobile Field Crews GDB ArcGIS Desktop ArcGIS Server Extensions Solutions Test Environment Upgrades Service Packs Applications Tools HR Finance Parkways E-ZPass Railroad ITS Traffic Monitoring Outdoor Advertising Salvage Yards Crash Work Orders Assets Pavement Bridge Application Xxtender Primavera Application Interface One-Way Replication HR Finance Applications Parkways E-ZPass RailConnect TransMatric Outdoor Advertising Salvage Crash Reporting AMS Fugro Roadway Deighton Bridge Inspect Materials Control Soils/Testing ProjectWise Staging Editing GDB (SQL Server/SDE) GPS Project Location At Inception Project Authorization ERP SUITE GIS Integration FHWA Other Third Parties
Where Are We? Business Architecture • Develop GIS Steering Committee • Identify GIS Champions in Business Units • Conduct Data Discovery workshop with business units to identify pockets of existing GIS data that should be maintained in the enterprise geodatabase. – In Progress • Conduct Transportation Data Model Workshop –Complete • Separate Database Environments – Complete • Create Staging and Publication Environment – Complete • Develop QA/QC Strategy for Data Clean-up – In Progress • Develop Common Base Maps for Web Portal and Desktop – Complete • Develop Data Caching Strategy –In Progress
Application Architecture • Design Templates in Staging Environment • – In Progress • Test Caching Strategies using Image Server Extension in Staging Environment • - In Progress • Automate GIS & MicroStation Interoperability Workflows • – In Progress
Technical Architecture • Esri Enterprise Health Check – Initial System Enterprise Health Check with GIS and OT System and Network Administrators - Complete • Install WMX in Staging Environment • - Complete • Install Production Mapping Solution in Staging Environment • - Complete • Install Image Server extension in Staging Environment • - Complete • Install Interoperability extension in Staging Environment • - Complete
Future Work • Complete Ongoing Tasks • Incorporate and Implement Ideas from the New 2012 Geospatial Strategic Plan by Cambridge Systematics/Transcend Spatial
WVDOT Geospatial Resources At WV DOT • Open to the Public • GTI Web Portal Continuously Operating Reference Stations (CORS) Network • WVDOT • GTI Web Portal • CORS Network • Fleet Management • Videolog Viewer • GIS Portal • Straight Line Diagram Viewer • WVDOH District GIS Coordinator Network • GIS/GPS Training • Other Services (Transportation GIS User Group, etc.)
Data Catalog • Bridges • Byways & Backways • Guardrails • Major Roads by Sign/District/County • Railroads • River Ports • Public Airports • WVDOT Facilities • WVDOT Rest Areas • WVDOT Substations • Etc. • http://www.transportation.wv.gov/highways/programplanning/gti/GIS/Pages/DataCatalog.aspx
WVDOT Transportation Maps • City Maps (205) • General Highway County Maps (55) • State Functional Classification Maps • State General Highway Maps • State Highway Base Map • Urban Area Maps (26) • http://www.transportation.wv.gov/highways/programplanning/gti/GIS/MAPS/Pages/default.aspx
Web Mapping Applications • WVDOT Facility Locations • WVDOT Statewide Transportation Improvement Program • WVDOT River Port Locations • WVDOT Airport Locations • WVDOT Snow Removal & Ice Control (SRIC) • WV American Recovery and Reinvestment (ARRA) Reporting • WVDOT Coal Resource Transportation System (CRTS) http://www.transportation.wv.gov/highways/programplanning/gti/GIS/Pages/MappingApplications.aspx
WVDOTCORSNetwork Newest Station State Police in Franklin, WV 35 STATIONS TRANSMITTING TO NETWORK 169 Subscriptions 109 Organizations 187 Users 2011 22 WV STATIONS INSTALLED
WVDOT CORS Network Cooperative Effort Site Owners Include USCOE NRAO WVDNR WVDEP WVRJA WVU, MU, FSU, SCTC, EWVTC, Marshall, Braxton, and Wirt County Schools Partnerships – Surrounging State Ohio Kentucky Pennsylvania Virginia http://wvcors01.cors.us/
WVDOT GeoManagerGPS Fleet Management Upgrade to System Embrace Latest Technology User Friendly Online Training for Managers Fleet Productivity Fuel Reduction Driver Safety Environmental Impact Asset Utilization Diagnostics & Messaging NMEA GPS Data Feed NMEA WiFi Data Feed
International Recognition • 2008 ESRI Special Achievement Award in GIS • 2010 WV GIS Conference Mapping Awards • 2011 ESRI Special Achievement Award in GIS • 2011 GIS-T People’s Choice Award • 2012 GIS-T People’s Choice Award
Key Success Factors Focus and alignment on the common project vision will ensure customer satisfaction! • Clear Communication • Strong methodology • Commitment • Executive Support • Right People. Right Activities. Right Time. • Avoid pitfalls: • Scope Creep • Lack/Timeliness of Communication Customer Satisfaction Project Outcome Meets Customer Needs