yueming wu, ph.d., gisp gis manager may 9, 2012 wvdot gis strategic & business plan and its...
TRANSCRIPT
Yueming Wu, Ph.D., GISPGIS Manager
May 9, 2012
WVDOT GIS Strategic & Business Plan and Its Implementation
Agenda
IntroductionWVDOT Enterprise GIS RoadmapStatus UpdateFuture WorkQuestions & Answers
Introduction
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.
- Roadway Inventory Log
-Roadway Statistics
-Public Certified Mileage
- Geospatial Data Management
-Geospatial Services
Geospatial Transportation Information (GTI) Section
Program Planning & Administration Division
Highway Data Services UnitGIS Unit
GTI Mission & Vision Statements
Mission StatementTo improve customer service to the citizens of West Virginia by supplying the latest geospatial transportation information.
Vision StatementThe 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.
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
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
WVDOT Enterprise GIS Roadmap
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?
How?
Goal Guide the implementation of a sustainable EGIS
Project Initiated in October 2009Partnership with Esri
Enterprise License Agreement (ELA) Technical Advisor
Online SurveyInformation AssessmentMultiple Versions of DraftRoadmap Delivered in March 2011
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
Phase 1
Current State(Now)
Phase 2 Phase 3 Phase 4
Target State(Vision)
Build Enterprise GISFramework
Application Implementation and Preparation for GIS integration with ERP Applications
Pilot New Tools and Applications
Roll out Highway Data Maintenance Solutions and ERP to Production
ArcGIS Desktop10
Default Editing
ArcGIS Desktop10
Editingw/Two-Tier QA
Versioning Strategy
Web MapsArcGIS FLEX AP I
•Airport•Riverport•Facilities
•ARRA•SRIC
Web ServerArcGIS Server
IIS 7
WVDOT Maps and
Shapefile Download
ContractsMaintenance
DistrictsEngineering
Engineeringand
TrafficEngineering
Maintenance,Materials,
ROW,Engineering,
Traffic Engineering
…………….……………………………………………………..
Work OrdersAssets
PavementBridge
PrimaveraP7
AASHTOTrns*port
MicroStationDesign
Cartographic Production
MS4Over heightOverweight
G
MS4 Super loadGot Permit
InRoadsFederal/StateCounty/CityMaps in PDF
PrimaveraInterfaceTrns*portInterface
ReimusSurveyor
Fugro RoadwayDeighton
Bridge Inspect Collector/Manager
Document Management
SLD
ApplicationXtender
RIL
RILInterface
GeoDecisionSLD Application
Manual ETL
GTI_EDIT INGLRS Maintenance
GDB(SQL Server/SDE)
GTI_PUB_WMGDB
(SQL Server/SDE)
GTI_PUB_UTMPublication
GDB(SQL Server/SDE)
SRICMaintenance/Publication
GDB(SQL Server/SDE)
GTIHDSGIS
ITSTraffic MonitoringOutdoor Advertising
Salvage Y ardsCrash
TrafficEngineering
ITSTraffic Server 5
Outdoor Advertising
SalvageCrash Reporting
GeoDecisionsPortal
GDBRIL/SLD
WVDOHWeb Portal
WVDOT Current “As-Is” GIS Conceptual Architecture
GIS Integration
ProductionEnvironment
WV_MAPGDB
(SQL Server/SDE)
Web ServerArcGIS Server
I IS 7
ArcGIS Desktop10
Default Editing
Web ServerArcGIS Server
IIS 7
ArcGIS Desktop10
w/Two-Tier QAVersioning
Strategy
Web MapsArcGIS FLEX API
•Airport•Riverport•Facilities
•ARRA
Web ServerArcGIS Server
IIS 7
WVDOT Maps and
Shapefile Download
ContractsMaintenance
DistrictsEngineering
Engineeringand
TrafficEngineering
Maintenance,Materials,
ROW,Engineering,
Traffic Engineering
…………….……………………………………………………..
Work OrdersAssets
PavementBridge
PrimaveraP7
AASHTOTrns*port
MicroStationDesign
Cartographic Production
MS4Over heightOverweight
G
MS4 Super loadGot Permit
InRoadsFederal/StateCounty/CityMaps in PDF
PrimaveraInterfaceTrns*portInterface
ReimusSurveyor
Fugro RoadwayDeighton
Bridge Inspect Collector/Manager
Document Management
ApplicationXxtender
RILSLD
RILInterface
GeoDecisionsSLD Application
Manual ETL
Production Environment
GTI EditingLRS Maintenance
GDB(SQL Server/SDE)
GTI PUB WMGDB
(SQL Server/SDE)
GTI PUB UTMPublication
GDB(SQL Server/SDE)
SRICMaintenance/Publication
GDB(SQL Server/SDE)
GTIHDSGIS
ITSTraffic MonitoringOutdoor Advertising
Salvage Y ardsCrash
TrafficEngineering
ITSTraffic Server 5
Outdoor Advertis ing
SalvageCrash Reporting
GeoDecisionsPortal
GDBRIL/SLD
WVDOHWeb Portal
WVDOT Current “As-Is” GIS Conceptual Architecture
GIS Integration
WV MapGDB
(SQL Server/SDE)
MS4 Super loadGot PermiteBONDS
Web ServerArcGIS Server 10
ArcGIS Flex API 2.0FLEX 4.0
IIS 7
Development
Development Environment
Virtual Server
SRICMaintenance
GDB(SQL Server/SDE)
Production Environment
StagingGDB
(SQL Server/SDE)
GeoDecisionsPortal
Publication GDB
RIL/SLD
WVDOHWeb Portal
LRSSLD
HPMSITAERP
GIS Web ServicesFuture Services
WVDOT “To-Be” Target GIS Conceptual Architecture
One-Way Replication
Automated ETLWVDOT Maps
PDF and
Shapefile Download
10 District Offi ces
MobileField
Crews
Mobile FieldCrewsGDB
(SQL Server/SDE)
District OfficesGDB
(SQL Server/SDE)DGN
(MicroStation)
Two-WayReplicationLive Or Disconnected
GPS Project
LocationAt
Inception
One-WayReplication One-Way
Replication
TransportationMaintenanceLRS/Events
GDB(SQL Server/SDE)
SRICPublication
GDB(SQL Server/SDE)
Two-WayReplication
FHWAOther Third Parties
Project Authorization
Project Location
State Rail
Authority
HRFinance
Maintenance,Materials,
ROW,Engineering,
Traffic Engineering
…………….……………………………………..
PrimaveraP7
AASHTOTrns*port
Site Manager
MS4Over heightOverweight
PrimaveraApplicationInterface
ApplicationXxtender
Documents Contracts
MicroStationDGN
Esri Interoperability
Extension or FME
HRFinance
EsriHighway DataManagement
SolutionGIS/HDS
Railroad
ITSTraffic Server 5
Outdoor Advertising
SalvageCrash Reporting
ERP SUITE GIS Integration
InRoads
EsriPRODUCTION
MAPPINGCARTOGRAPHIC
Production GIS/HDS
MaintenanceDistricts
Engineering
Work OrdersAssets
PavementBridge
Asset ManagementFugro Roadway
DeightonBridge Inspect
Materials ControlSoils/Testing
ITSTraffic Monitoring
Outdoor AdvertisingSalvage Y ards
Crash
TrafficEngineering
RailConnect
GTIGISHDS
HRFinance
Applications
Parkways
ParkwaysE-ZPass
ParkwaysE-ZPass
2
3
4
5
6
17
8
910
11
12
WMS
13
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 necessary3. 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.
Recommendations for Business Architecture
Develop GIS Steering Committee
Identify GIS Champions in Business Units
Data Discovery Workshop with Business Units
Define GIS Data Standards and Field Data Collection Procedures
Define Business Units Data Roles and Responsibilities
Define ERP/GIS Integration Requirements
Define MicroStation Interoperability Requirements with Business units
Implement Standards GIS Steering Committee Oversight and Support for ERP/GIS Rollout
GIS Section and Business Champion continued work with Business Units on ERP/GIS Rollout
Phase I Phase II Phase III Phase IV
Recommendations for Data Architecture
Phase I Phase II Phase III Phase IVData Model Workshop
Separate Database Environments – Create Staging and Publication Environments
Develop QA/QC Procedures for Data Cleanup
Develop Common Base Maps
Develop Data Caching Strategy
Develop Data Management Strategy –Versioning-
Replication-Archiving
Define ETL Tools
Create Mosaic Datasets
Develop Conceptual and Logical Data Models
Data Cleanup
Test Data Caching Strategy in Staging Environment
Pilot Versioning-Replication-Archiving in Staging Environment
Define Data Maintenance Workflows
Automate ETL Tools
Test Mosaic Datasets in Staging Environment
Pilot Physical Geodatabase Schema
in Staging Environment
Roll Out Data Caching Strategy in Production Environment
Roll Out Versioning-
Replication-Archiving in Production Environment
Test ETL Tools in Staging
Roll Out Mosaic Datasets in Production Environment
Roll out Physical Geodatabase Schema
to Production Environment
Roll Out ETL Tools in Production Environment
Recommendations for Application Architecture
Phase I Phase II Phase III Phase IVDesign Templates for Official Maps in Production Mapping in Staging Environment –
Test Caching Strategies
Pilot Production Mapping in Staging Environment
Develop Mobile GIS Application Based on Data Collection Standards and Procedures
Pilot WMX in Staging Environment
Pilot GIS & MicroStation Integration using Interoperability in Staging Environment
Automate GIS & MicroStation Interoperability Workflows
Pilot Highway Data Management Solution in Staging Environment
Pilot Mobile GIS Applications
Rollout WMX in Production Environment
Rollout GIS & CAD Integration using Interoperability Extension in Production Environment
Rollout Highway Data Management Solution to Production
Rollout Mobile GIS Applications
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
Recommendations for Technical Architecture
Phase I Phase II Phase III Phase IV
Esri Enterprise Health Check
Install WMX in Staging Environment
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
Install Image Server Extension in Staging Environment –
Install Production Mapping in Staging Environment
Install Interoperability extension in Staging Environment
Install WMX in Production Environment
Install Image Server Extension in Production Environment –
Install Production Mapping in Production Environment
Install Interoperability extension in Production Environment
Recommendations for GIS Staffing
Phase I Phase II Phase III Phase IV
Hire GIS Database Administrator Hire GIS Developer
Revised Tasks
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.
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
Revised Tasks for Application Architecture
Design Templates in Staging Environment Test Caching Strategies using Image Server Extension
in Staging EnvironmentAutomate GIS & MicroStation Interoperability
Workflows
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
Status Update
Business Architecture
Develop GIS Steering Committee – In Progress Identify GIS Champions in Business Units - In ProgressConduct Data Discovery workshop with business
units to identify pockets of existing GIS data that should be maintained in the enterprise geodatabase.
– In Progress
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
Application Architecture
Design Templates in Staging Environment– In Progress Test Caching Strategies using Image Server
Extension in Staging Environment - In ProgressAutomate 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
Future Work
Complete Ongoing TasksIncorporate Ideas from the Upcoming
Geospatial Strategic Plan by Cambridge Systematics/Transcend Spatial
