Yueming Wu , Ph.D., GISP GIS Manager May 9, 2012

1. WVDOT GIS Strategic & Business Plan and Its Implementation Yueming Wu, Ph.D., GISP GIS Manager May 9, 2012

2. Agenda • Introduction • WVDOT Enterprise GIS Roadmap • Status Update • Future Work • Questions & Answers

3. Introduction

4. History Historically the West Virginia Department of Transportation (WVDOT) has been utilizing geospatial (GIS, Remote Sensing, & GPS) technology for planning, analysis, and mapping purposes ever since the technology became available. In 2005 the WVDOT GIS Section was created to meet the growing needs for geospatial data and services in transportation. In 2007 the GIS Section was renamed as the GIS Unit and merged with the Highway Data Services (HDS) Unit, a program responsible for processing changes in roadway information, and the update and maintenance of the Roadway Inventory Log, to form the current Geospatial Transportation Information (GTI) Section.

5. Program Planning & Administration Division Geospatial Transportation Information (GTI) Section Highway Data Services Unit GIS Unit - Geospatial Data Management -Geospatial Services • Roadway Inventory Log • -Roadway Statistics • -Public Certified Mileage

6. GTI Mission & Vision Statements • Mission Statement • To improve customer service to the citizens of West Virginia by supplying the latest geospatial transportation information. • Vision Statement • The West Virginia Department of Transportation Geospatial Transportation Information (GTI) Section is committed to managing an enterprise Geospatial Information System that will improve the productivity of the West Virginia Department of Transportation, meet growing customer needs, and play a leading role in West Virginia’s geospatial community.

7. GIS Implementation • Esri Shop • Enterprise License Agreement (ELA) • Esri Technology • Staff • 7 GIS Professionals • 2 Cartographers • 1 GIS Coordinator at District 7 • Enterprise GIS • WVDOT Enterprise GIS Roadmap • Enterprise Resource Planning (ERP)/Asset Management System

8. Major GIS Projects in 2012 • Enterprise GIS Implementation • New Transportation GIS Data Model • District Level GIS Implementation • Workflow Manager • Transportation GIS Data Collection • (MS4, Railroad Crossings, Landslides, Outdoor Advertising, • Right-of-Way, Trails, Meta Data, etc.) • Highway Map Reproduction • Web Mapping Applications • (STIP, Park & Ride, Functional Classifications, etc.) • Mobile GIS Applications (MS4, etc.) • 3D GIS Application Development • GIS Portal Upgrade • ProjectWise Implementation • ERP/Asset Management System Implementation

9. WVDOT Enterprise GIS Roadmap

10. Why? • Small Successes + Healthy Growth • Relatively New GIS Program • Copying Peers • Leveraging Professional Services • Then What? Sustainable Growth? • DOT’s Uniqueness • Growing Needs for Geospatial Technology? • Enterprise GIS? • Staff’s Skill Advancement? • Other Improvements?

11. How? • Goal • Guide the implementation of a sustainable EGIS • Project Initiated in October 2009 • Partnership with Esri • Enterprise License Agreement (ELA) • Technical Advisor • Online Survey • Information Assessment • Multiple Versions of Draft • Roadmap Delivered in March 2011

12. What? • Phased Approach • Suggestions • Best Practices • Four Phases • Phase I: Build enterprise GIS framework • Phase II: Application implementation & preparation for GIS integration for ERP applications • Phase III: Pilot new tools & applications • Phase IV: Roll out Highway Data Maintenance Solutions & ERP • Five Areas • Business Architecture • Data Architecture • Application Architecture • Technical Architecture • GIS Staffing

13. Current State (Now) Roll out Highway Data Maintenance Solutions and ERP to Production Application Implementation and Preparation for GIS integration with ERP Applications Build Enterprise GIS Framework Pilot New Tools and Applications Phase 1 Phase 2 Phase 3 Phase 4 Target State (Vision)

16. Recommended Workflow • 1. Project authorization from FHWA or other third parties. Information is entered in Primavera and notice is sent to the survey field crew to GPS project location. • 2. Field crew collects project location data and other pertinent data as necessary • 3. Data is replicated to the district office using either Web-based disconnected check-in or connected synchronization services for distributed geodatabase versions maintained in supported database platforms. Both types of replication offer two-way workflows necessary to support field crews • 4. Two-way replication is setup between the District Offices and Central Office Production geodatabase to keep geodatabases in sync. • 5. Esri’s Interoperability Extension or Feature Management Extension (FME) is used to provide interoperability between the geodatabase and MicrosStation DGN files for data exchange. For web services, MicroStation V8i can consume WMS. Both options should be available for users. • 6. Project Location Data is sent to Primavera. • 7. All business data within the ERP is linked to the roadway network LRS. • 8. Roadway Network LRS and event data in the production environment is maintained by Esri Highway Data Maintenance System. • 9. Data for Cartographic production (Federal, State, County and City Maps) is located in the • Publication geodatabase and managed by ESRI’s Production Mapping. • 10. Data is replicated one-way to the publication environment for Web Portal and File downloads. • 11. Data is replicated to the new Web Portal Publication Database. Data is projected to Web Mercator (Auxiliary Sphere) Projection before replication. • 12. Data and Maps are available for download via automated ETL.

17. Recommendations for Business Architecture Phase I Phase II Phase III Phase IV Develop GIS Steering Committee Define GIS Data Standards and Field Data Collection Procedures GIS Steering Committee Oversight and Support for ERP/GIS Rollout Implement Standards Identify GIS Champions in Business Units Define Business Units Data Roles and Responsibilities GIS Section and Business Champion continued work with Business Units on ERP/GIS Rollout Data Discovery Workshop with Business Units Define ERP/GIS Integration Requirements Define MicroStation Interoperability Requirements with Business units

18. Recommendations for Data Architecture Phase I Phase II Phase III Phase IV Develop Conceptual and Logical Data Models Pilot Physical Geodatabase Schema in Staging Environment Roll out Physical Geodatabase Schema to Production Environment Data Model Workshop Separate Database Environments – Create Staging and Publication Environments Develop QA/QC Procedures for Data Cleanup Data Cleanup Develop Common Base Maps Develop Data Caching Strategy Test Data Caching Strategy in Staging Environment Roll Out Data Caching Strategy in Production Environment Define Data Maintenance Workflows Develop Data Management Strategy –Versioning- Replication-Archiving Roll Out Versioning- Replication-Archiving in Production Environment Pilot Versioning-Replication-Archiving in Staging Environment Roll Out ETL Tools in Production Environment Automate ETL Tools Test ETL Tools in Staging Define ETL Tools Create Mosaic Datasets Test Mosaic Datasets in Staging Environment Roll Out Mosaic Datasets in Production Environment

19. Recommendations for Application Architecture Phase I Phase II Phase III Phase IV Design Templates for Official Maps in Production Mapping in Staging Environment – Pilot Production Mapping in Staging Environment Pilot Highway DataManagement Solution in Staging Environment Rollout Highway DataManagement Solution to Production Develop Mobile GIS Application Based on Data Collection Standards and Procedures Rollout Mobile GIS Applications Pilot Mobile GIS Applications Test Caching Strategies Pilot WMX in Staging Environment Rollout WMX in Production Environment Automate GIS & MicroStation Interoperability Workflows Pilot GIS & MicroStation Integration using Interoperability in Staging Environment Rollout GIS & CAD Integration using Interoperability Extension in Production Environment Discovery Workshop for SOA/ERP GIS Web Services and Mapping Applications Requirements Pilot GIS/ERP Integration Web Service/Mapping Applications in Staging Environment Rollout GIS/ERP Integration Web Services/Mapping Applications in Production Environment Rollout ERP/GIS Integration to Production Environment

20. Recommendations for Technical Architecture Phase I Phase II Phase III Phase IV Determine High Level ERP/GIS System Integration Requirements for Asset Management, Work Order Management, Safety Management, etc. System Architecture Workshop to Support ERP/GIS Integration Requirements Revisit System Architecture Requirements Integration Requirements Esri Enterprise Health Check Install WMX in Staging Environment Install WMX in Production Environment Install Image Server Extension in Staging Environment – Install Image Server Extension in Production Environment – Install Production Mapping in Staging Environment Install Production Mapping in Production Environment Install Interoperability extension in Staging Environment Install Interoperability extension in Production Environment

21. Recommendations for GIS Staffing Phase I Phase II Phase III Phase IV Hire GIS Database Administrator Hire GIS Developer

22. Revised Tasks

23. Revised Tasks for 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.

24. Revised Tasks for Data Architecture • Conduct Transportation Data Model Workshop • Separate Database Environments • Create Staging and Publication Environment • Develop QA/QC Strategy for Data Clean-up • Develop Common Base Maps for Web Portal and Desktop • Develop Data Caching Strategy • Define Data Maintenance Workflows – RIL and LRS – WMX Workshop • Develop Data Management Strategy • Define ETL/Data Extraction Processes • Design and Create Mosaic Datasets

25. Revised Tasks for Application Architecture • Design Templates in Staging Environment • Test Caching Strategies using Image Server Extension in Staging Environment • Automate GIS & MicroStation Interoperability Workflows

26. Revised Tasks for Technical Architecture • Esri Enterprise Health Check – Initial System Enterprise Health Check with GIS and OT System and Network Administrators • Install WMX in Staging Environment • Install Production Mapping Solution in Staging Environment • Install Image Server extension in Staging Environment • Install Interoperability extension in Staging Environment

27. Status Update

28. Business Architecture • Develop GIS Steering Committee • – In Progress • Identify GIS Champions in Business Units • - In Progress • Conduct Data Discovery workshop with business units to identify pockets of existing GIS data that should be maintained in the enterprise geodatabase. • – In Progress

29. Data Architecture • 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 • Define Data Maintenance Workflows – RIL and LRS – WMX Workshop – In Progress • Develop Data Management Strategy - In Progress • Define ETL/Data Extraction Processes – In Progress • Design and Create Mosaic Datasets - In Progress

30. 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

31. 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

32. Future Work

33. Future Work • Complete Ongoing Tasks • Incorporate Ideas from the Upcoming Geospatial Strategic Plan by Cambridge Systematics/Transcend Spatial

34. Yueming Wu GIS Manager WVDOT (304) 558-7437 yueming.wu@wv.gov