Enterprise GIS Development at West Virginia Department of Transportation

1. Enterprise GIS Development at West Virginia Department of Transportation Yueming Wu, Ph.D., GISP GIS Manager November 15, 2012

2. GIS Programat WVDOT

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

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

5. 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 • …

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

7. Enterprise GIS Development at WVDOT

8. What Is Enterprise GIS? Enterprise GIS is a platform for delivering organization-wide geospatial capabilities while improving access to geographic information and extending geospatial capabilities to nontraditional users of GIS (Esri, 2012).

9. Why Do We Need An Enterprise GIS? • Small Successes Over the Past • Do Not Guarantee A • Sustainable Growth in the Future • Growing w/ Evolving Geospatial Technology • Seamlessly Integrating w/ Numerous Changing External IT Systems • Scalable to Support Large User Base at WVDOT & Answer Numerous Citizen Requests • Flexible to Handle Various Business Cases • Etc.

10. WVDOT Enterprise GIS Strategic Plan Development • Enterprise License Agreement (ELA) w/ Esri • Effective October 2009 • Technical Advisor • Project Initiated in October 2009 • Partnership with Esri • Online Survey • Information Assessment • Multiple Versions of Draft • Plan Finalized in March 2011

11. WVDOT Enterprise GIS Strategic Plan • Effective April 2011 • 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

12. Current State (2011) Roll out Roads & Highways 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)

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

15. 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 Implement Standards GIS Steering Committee Oversight and Support for ERP/GIS Rollout Define Business Units Data Roles and Responsibilities Identify GIS Champions in Business Units 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

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

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

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

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

20. Revised Tasks

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

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

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

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

25. Where Are We?

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

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

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

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

30. Future Work

31. Future Work • Complete Ongoing Tasks • Incorporate and Implement Ideas from the New 2012 Geospatial Strategic Plan by Cambridge Systematics/Transcend Spatial

32. Overwhelmed or Confused? GTI Web PORTAL CORS FLEET MANAGEMENT SLD VIDEOLOG VIEWER OTHERS

33. Yueming Wu , Ph.D., GISP GIS Manager WVDOT (304) 558-7437 yueming.wu@wv.gov