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

▶
regional crash data
SMART_READER_LITE
LIVE PREVIEW

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

Sep 15, 2023 222 likes •372 views

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-

slide-1
SLIDE 1

Regional Crash Data

Sungmin Lee Principal GIS Analyst H-GAC

slide-2
SLIDE 2

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.

slide-3
SLIDE 3

About Presentation

  • Background
  • Data Development
  • Application Development
  • Demonstration
slide-4
SLIDE 4

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

  • f vehicle crashes in the region
  • Develop a web-based application to

utilize crash information more easily.

BACKGROUND

slide-5
SLIDE 5

Examples

http://crashmapper.org

NYC Crash Mapper

https://crashmapping.utah.gov/

Utah Vehicle Collisions 2015 Vehicle Incidents, Including Fatalities Reported in Houston, Texas

http://arcg.is/1uGmTL

BACKGROUND

slide-6
SLIDE 6

Data Source: C.R.I.S, TxDOT

DATA DEVELOPMENT Automated Crash Data Extract Files

slide-7
SLIDE 7

Data Mining: Automated Crash Data Extract Files

  • Crash (171 variables)
  • Unit (108 variables)
  • Person (34 variables)

DATA DEVELOPMENT

slide-8
SLIDE 8

Design Data Structure

Crash ID Year Crash Date Hour Street Name Latitude Longitude Weather Lighting Traffic Control Harm Severity Intersection-related Day of Week Contributing Factors (factor)

General Crash Information (15)

Fatality Serious Injury Non-Serious Injury Possible Injury Unknown Not Injured Total Injury Fatality: Motorist Serious Injury: Motorist Non-Serious Injury: Motorist Possible Injury: Motorist Not Injured: Motorist Unknown: Motorist Total Injury: Motorist Fatality: Pedestrian Serious Injury: Pedestrian Non-Serious Injury: Pedestrian Possible Injury: Pedestrian Not Injured: Pedestrian Unknown: Pedestrian Total Injury: Pedestrian Fatality: Cyclist Serious Injury: Cyclist Non-Serious Injury: Cyclist Possible Injury: Cyclist Not Injured: Cyclist Unknown: Cyclist Total Injury: Cyclist

Injury Information (7) Detailed Injury Information (21)

County Place Zip Code Tract H3M HBM County Precinct City Council District In/Unincorporated Area

Geographic Information (9)

  • 52 Variables
  • 692,545 records

DATA DEVELOPMENT

slide-9
SLIDE 9

Crash Data Dashboard: Tableau

APPLICATION DEVELOPMENT

Interactive charts and tables Map

Filtering Control Map Legend Dashboard Menu

slide-10
SLIDE 10

Crash Data Viewer: ArcGIS Web App Builder

Basic Widget Advanced Widget APPLICATION DEVELOPMENT

slide-11
SLIDE 11

Layout: ArcGIS Story Map Series (Tab)

APPLICATION DEVELOPMENT

slide-12
SLIDE 12

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

DEMONSTRARION

slide-13
SLIDE 13

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

DEMONSTRARION

slide-14
SLIDE 14

DEMONSTRARION

Any Question?

cegis@h-gac.com Sungmin Lee Principal GIS Analyst H-GAC Sungmin.Lee@h-gac.com