Jessica D. PerkinsGIS Programmer Analyst 2

Geospatial Transportation Information SectionProgram Planning & Administration

Division of HighwaysWest Virginia Department of Transportation

May 9, 2012

West Virginia Department of Transportation

WV Transportation Roadway Network:Integrating Routing Capabilities and Best Practices through

Detailed Editing and an Updated Data Model

Outline Background Data Sources Methods Future Project Ideas Questions &

Discussion

- 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 Background and Why?Mission Statement

To improve customer service to the citizens of West Virginia by supplying the latest transportation information.

Vision StatementCommitted to managing an enterprise Geospatial Information System that will improve the productivity of the WVDOT, meet growing customer needs, and play a leading role in West Virginia’s geospatial community. Data Availabilityhttp://www.transportation.wv.gov/highways/ programplanning/gti/

Data SourcesWVDOT

•Routes (linear referencing system, LRS)•Non-State Public Routes (NSPR)•Ramps•Roadway Inventory Log (RIL)

Data SourcesWV State Addressing and Mapping Centerline Dataset – Division of Homeland Security and Emergency Management

•New county-level geometry and attribute edits•Local roads•Segmentation - split geometry at intersections

(nodes)•Addressing

MethodsAutomated Processes• Extraction, transformation, and loading (ETL) in

Data Interpretability Extension

MethodsGeoprocessing steps for entire state dataset• Midpoints of both line feature classes (WVDOT_Midpoints

and SAM_Midpoints)• Spatial join – WVDOT_Midpoints to SAM_Midpoints• Join features from SAM_Lines to SAM_WVDOT_MidPoints

by SAM_ID• Field calculations to simplify attributes (all attributes for

WVDOT and SAM)• Identify features that were not intersected by SAM data

(“Missing_WVDOTsource”). Introduces duplicate geometry - removed during manual cleanup• Extend and Trim to connect intersections• Delete features less than 1 meter and run Extend again

MethodsManual Processes by County

Phase 1•Use “Missing_WVDOTsource” to identify and

clean-up errors• Symbology used to visualize additional errors

and duplicates•Attribute edits using attribute transfer tool• Remove duplicate geometry

MethodsManual Processes by County - Phase 1

MethodsManual Processes by County

Phase 2•Geometry edits• Scan and overview clean-up•Geoprocessing model to check attribute transfer• Topology fixes in Data Reviewer•Geometry edits to ramps• Final overview clean-up

MethodsManual Processes by County - Phase 2

MethodsManual Processes by County - Phase 2 Complete

MethodsManual Processes by County

Phase 3• Stitching counties back together•Deploy into updated data model

ESRI Roads and Highways Solution integrated with Roadway Inventory Log for measures

Methods

Methods

MethodsMaintenance steps to update and strengthen process•Maintaining SAM Street_ID through editing process• Periodic updates from Counties through Division of

Homeland Security and Emergency Management linked back by Street_ID• Explore automated updates in future

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)

Future Project Ideas

Export

ReprojectUpload

Update

Store

Download &Add

Metadata

Version - Edit GTI_EDITING

TRANSPORTATIONGIS DATA

• Commissioner Orders• Paper Maps• Field Data• Consultant Reports• Etc.

GTI_PUB_WM

GTI_PUB_UTM

UploadREFERENCE

GIS DATA • WV GIS Tech Center• WVGES• USGS• Esri• Etc.

IMAGERY• Aerial Photos• Shade Relief• Hillshade• Topo• Etc.

Editing

Publication

Source Data

Shapefiles

Imagery GIS Services

Shapefiles for

Download

Store

Download &Add

Metadata

Version - Edit Update

Geospatial Analysis

Map Production

WebApps

Reproject

Export

WVDOT Geospatial Data

Repository

Replicate

ReprojectUpload

UpdateGTI_EDITING

GTI_PUB_WM

GTI_PUB_UTM

Upload

Editing

Publication

Shapefiles

Update

Reproject

Headquarters

Replicate

Districts 1- 10

GTI_PUB_UTMFGDB

Publication

Replicate

WVDOT Geospatial Data

Repository

Imagery

Questions and Discussion