Co Contributing t to LA LAs Green Rep eporti rting Sara Graham - - PowerPoint PPT Presentation

▶
co contributing t to la la s green rep eporti rting
SMART_READER_LITE
LIVE PREVIEW

Co Contributing t to LA LAs Green Rep eporti rting Sara Graham - - PowerPoint PPT Presentation

Aug 01, 2023 13 likes •213 views

HIGHWAY SAFETY RESEARCH GROUP Co Contributing t to LA LAs Green Rep eporti rting Sara Graham & Jeff Dickey HIGHWAY SAFETY RESEARCH GROUP Ove verview ew About the HSRG Electronic Reporting Collaboration Location

slide-1
SLIDE 1

HIGHWAY SAFETY RESEARCH GROUP

Co Contributing t to LA LA’s Green Rep eporti rting

Sara Graham & Jeff Dickey

slide-2
SLIDE 2

HIGHWAY SAFETY RESEARCH GROUP

Ove verview ew

  • About the HSRG
  • Electronic Reporting
  • Collaboration
  • Location
  • On-going – Data Quality
slide-3
SLIDE 3

HIGHWAY SAFETY RESEARCH GROUP

About t the HS e HSRG

  • HSRG formed in 2002 to collect, enter, and store Louisiana’s crash

data – in partnership with the LA DOTD

  • 3 full-time staff members in 2004
  • HSRG released LACRASH software in 2005 to assist agencies in

electronic reporting

  • 20 full-time positions in 2019
  • Still collect, enter, and store
  • Data Quality, GIS, Infrastructure, Data Analysis, Business Analytics, Research
slide-4
SLIDE 4

HIGHWAY SAFETY RESEARCH GROUP

Elect ectronic R c Report rting

50 100 150 200 250 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018

Number of Agencies Using LACRASH

slide-5
SLIDE 5

HIGHWAY SAFETY RESEARCH GROUP

Elect ectronic R c Report rting

50000 100000 150000 200000 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017

Reports Received Paper vs. Electronically

ELECTRONIC PAPER

slide-6
SLIDE 6

HIGHWAY SAFETY RESEARCH GROUP

El Electr tronic R Repo porti ting g - Timelin liness ss

YEAR WITHIN 30 DAYS WITHIN 60 DAYS WITHIN 90 DAYS AVERAGE NUMBER OF DAYS 2006 39 % 41 % 44 % 121 2007 48 % 53 % 64 % 71 2008 64 % 74 % 83 % 41 2009 66 % 70 % 75 % 47 2010 70 % 72 % 77 % 44 2011 75 % 84 % 89 % 32 2012 79 % 84 % 88 % 26 2013 85 % 91 % 93 % 19 2014 88 % 91 % 95 % 16 2015 92 % 95 % 98 % 11 2016 93 % 96 % 97 % 10 2017 96 % 98 % 99 % 7

slide-7
SLIDE 7

HIGHWAY SAFETY RESEARCH GROUP

Elec ectronic R Rep eport rting g - Timelines ess o s of CM CMV R V Rep eporting

YEAR WITHIN 30 DAYS WITHIN 60 DAYS WITHIN 90 DAYS AVERAGE NUMBER OF DAYS 2006 58 % 67 % 72 % 74 2007 70 % 80 % 85 % 40 2008 77 % 86 % 92 % 29 2009 82 % 88 % 91 % 23 2010 86 % 93 % 95 % 17 2011 87 % 94 % 96 % 17 2012 87 % 93 % 96 % 15 2013 88 % 94 % 97 % 14 2014 92 % 96 % 98 % 11 2015 92 % 96 % 98 % 11 2016 93 % 96 % 98 % 11 2017 95 % 98 % 99 % 9

slide-8
SLIDE 8

HIGHWAY SAFETY RESEARCH GROUP

Elect ectronic R c Report rting

  • Increased the number of identified CMV crashes
  • 2001 – 2,047
  • 2004 – 2,628
  • 2005 – 4,260
  • 2017 – 4,030
slide-9
SLIDE 9

HIGHWAY SAFETY RESEARCH GROUP

Collabor

  • ration
  • n
  • HSRG staff worked with LA DPS and FMCSA to clarify what should be

reported and when

  • Conducted continuous testing to reduce errors on reportable CMV

crashes

  • Worked closely with FARS team to match MCMIS and FARS numbers
  • Research differences
  • Make corrections to either database, when needed
slide-10
SLIDE 10

HIGHWAY SAFETY RESEARCH GROUP

Location

  • HSRG began locating crashes in 2010
  • All local road crashes and a subset of problematic state road crashes
  • Assumed responsibility for all crashes in 2017
  • 170,000 crashes per year
slide-11
SLIDE 11

HIGHWAY SAFETY RESEARCH GROUP

Location

  • Automatically locate and validate 60% of crashes
  • Manually locate remaining crashes using

Specially Trained Undergraduate Data ENtry Technicians

slide-12
SLIDE 12

HIGHWAY SAFETY RESEARCH GROUP

Location

  • Locate 90-95% of crashes
  • Assign control section and logmile
  • Link to roadway data for analysis
slide-13
SLIDE 13

HIGHWAY SAFETY RESEARCH GROUP

Location – Commo mmon I n Issues

  • No latitude/longitude
  • Wrong latitude/longitude
  • Missing/misspelled street names
  • Conflict between data and narrative
slide-14
SLIDE 14

HIGHWAY SAFETY RESEARCH GROUP

A Tale of Two Cities? Or is something wrong?

slide-15
SLIDE 15

HIGHWAY SAFETY RESEARCH GROUP

Pattern does not match city streets Degree minute seconds recorded as decimal degrees

slide-16
SLIDE 16

HIGHWAY SAFETY RESEARCH GROUP

Crashes in Lake Pontchartrain

slide-17
SLIDE 17

HIGHWAY SAFETY RESEARCH GROUP

Location – Ana Analysis

Correlation of Seat Belt Use by Zip Code

slide-18
SLIDE 18

HIGHWAY SAFETY RESEARCH GROUP

Fatal C Crash R Rate & D Distan ance t to H Hospital al (Z)

slide-19
SLIDE 19

HIGHWAY SAFETY RESEARCH GROUP

On-goin ing D Data Q Qualit lity

  • Regularly monitor crashes for completeness of driver and vehicle

fields required for SafetyNet

  • Reports with missing data are pulled and investigated weekly
  • Identifies agencies regularly reporting incomplete data to make

contact and offer training

slide-20
SLIDE 20

HIGHWAY SAFETY RESEARCH GROUP

Sara Graham sgraha2@lsu.edu Jeff Dickey, Ph.D. jdickey@lsu.edu