Regional Crash Data Sungmin Lee Principal GIS Analyst H-GAC - PowerPoint PPT Presentation

Regional Crash Data Sungmin Lee Principal GIS Analyst H-GAC

Regional Data Lab • Socio-economic modeling team in Community & Environmental Planning Department at H-GAC • Regional Growth Forecast (population/employment/land use), Socio- economic data (Census & Employment), and Environmental Modeling (Land Cover/Water quality) • Develop web applications including Activity-Connectivity Explorer (ACE), Regional Flood Information, Regional Demographic Snapshot, Regional Commute Patterns, Houston Growth Reports, & so on.

About Presentation • Background • Data Development • Application Development • Demonstration

BACKGROUND Background • Identify and monitor safety issues; Implement roadway safety improvements at hazardous locations; and, support the safety efforts of other community organizations and agencies • Allows policy makers and traffic safety professionals to better assess the location and magnitude of various types of vehicle crashes in the region • Develop a web-based application to utilize crash information more easily.

BACKGROUND Examples Utah Vehicle Collisions NYC Crash Mapper https://crashmapping.utah.gov/ http://crashmapper.org http://arcg.is/1uGmTL 2015 Vehicle Incidents, Including Fatalities Reported in Houston, Texas

DATA DEVELOPMENT Data Source: C.R.I.S, TxDOT Automated Crash Data Extract Files

DATA DEVELOPMENT Data Mining: Automated Crash Data Extract Files • Crash (171 variables) • Unit (108 variables) • Person (34 variables)

DATA DEVELOPMENT Design Data Structure General Crash Information (15) Injury Information (7) Detailed Injury Information (21) Geographic Information (9) Crash ID Fatality: Motorist County Fatality Year Serious Injury: Motorist Place Serious Injury Crash Date Non-Serious Injury: Motorist Zip Code Non-Serious Injury Hour Tract Possible Injury: Motorist Street Name Possible Injury Not Injured: Motorist H3M Latitude Unknown: Motorist Unknown HBM Longitude Total Injury: Motorist County Precinct Not Injured Weather Fatality: Pedestrian City Council District Lighting Total Injury Serious Injury: Pedestrian In/Unincorporated Area Traffic Control Non-Serious Injury: Pedestrian Harm Possible Injury: Pedestrian Severity Not Injured: Pedestrian Intersection-related Unknown: Pedestrian Day of Week Total Injury: Pedestrian • 52 Variables Contributing Factors (factor) Fatality: Cyclist Serious Injury: Cyclist • 692,545 records Non-Serious Injury: Cyclist Possible Injury: Cyclist Not Injured: Cyclist Unknown: Cyclist Total Injury: Cyclist

APPLICATION DEVELOPMENT Crash Data Dashboard: Tableau Interactive charts and tables Map Filtering Control Map Legend Dashboard Menu

APPLICATION DEVELOPMENT Crash Data Viewer: ArcGIS Web App Builder Basic Widget Advanced Widget

APPLICATION DEVELOPMENT Layout: ArcGIS Story Map Series (Tab)

DEMONSTRARION https://datalab.h-gac.com/crash/

DEMONSTRARION https://h-gac.com/go/apps

DEMONSTRARION Any Question? cegis@h-gac.com Sungmin Lee Principal GIS Analyst H-GAC Sungmin.Lee@h-gac.com