{"id":127014,"date":"2017-06-21T09:19:50","date_gmt":"2017-06-21T13:19:50","guid":{"rendered":"https:\/\/today.uconn.edu\/?p=127014"},"modified":"2017-07-25T14:30:01","modified_gmt":"2017-07-25T18:30:01","slug":"crash-database-developed-uconn-gets-national-attention","status":"publish","type":"post","link":"https:\/\/today.uconn.edu\/2017\/06\/crash-database-developed-uconn-gets-national-attention\/","title":{"rendered":"Crash Database Developed at UConn Gets National Attention"},"content":{"rendered":"

An interactive public database that provides unprecedented levels of detail for thousands of Connecticut motor vehicle crashes is drawing the attention of other states interested in replicating the model. The database was built by UConn transportation engineers and information technology experts.<\/p>\n

\"A<\/a>
A sample from the database showing a detailed diagram of a crash.<\/figcaption><\/figure>\n

More than six years in the making, the Connecticut Crash Data Repository<\/a> is becoming an essential tool for transportation safety engineers, regional planning agencies, police departments, and town leaders seeking to improve safety on Connecticut\u2019s highways and roads.<\/p>\n

Interest in the online database extends far beyond Connecticut. Officials in Massachusetts, New York, Vermont, and South Carolina have contacted UConn transportation safety engineers in recent months, inquiring about the database and how they might duplicate the system in their state.<\/p>\n

\u201cThese data visualization tools are becoming a national trend,\u201d says Eric Jackson, director of the Connecticut Transportation Safety Research Center<\/a>, which built the database and keeps it up to date.<\/p>\n

\"A<\/a>
A sample view of the website’s ‘ticker’ showing fatalities.<\/figcaption><\/figure>\n

Jackson says Connecticut\u2019s database is highly interactive, accessible to the public, and allows for rapid, real-time analysis of data to identify trouble spots and trends. The homepage includes a daily \u2018ticker\u2019 comparing Connecticut traffic fatalities this year to other years. System information is updated daily.<\/p>\n

\u201cWith our database, members of the public can find very detailed information about crashes with very little effort,\u201d says Jackson. \u201cThat\u2019s what we were going for, a very user-friendly Google-esque application, where you don\u2019t need to be a data expert to use it.\u201d<\/p>\n

\n

When it comes to highway safety, change is driven by data. — Amy Parmenter, AAA<\/cite><\/p>\n<\/blockquote>\n

Once logged into the repository, users can search for statewide crash trends spanning years, or drill down to one particular town or even street corner to see how many crashes occurred there, what kinds of crashes occurred, and what, if any, injuries were reported. Users can also find out if the driver was wearing a seat belt, their sex and age, and whether the operator was charged with being under the influence of alcohol or drugs. The site even includes an investigator\u2019s drawings of the crash scene and a Google street view of the crash location.<\/p>\n

The database is already churning out some pretty\u00a0interesting information.<\/p>\n

\"In<\/a>
In this chart of DUI crashes by day and hour of day, darker colors mean more crashes.<\/figcaption><\/figure>\n

Once recent query, for instance, revealed that in 2016, fatal pedestrian crashes in Connecticut occurred most often on Thursdays between the hours of 5 p.m. and 7 p.m. Car vs. pedestrian crashes in general occurred most often during daylight hours on Wednesdays.<\/p>\n

Another query found there were five fatal motorcycle crashes in one week in June this year\u00a0\u2013<\/span><\/span> a potential red flag for law enforcement and safety advocates heading into the summer months.<\/p>\n

\u201cWhen it comes to highway safety, change is driven by data,\u201d says Amy Parmenter, public and government affairs manager for AAA in Greater Hartford. \u201cThe rich repository the UConn team has created is not only a robust, user-friendly reference tool, it is an invaluable resource that may ultimately save lives. I feel lucky to have access to it every day.\u201d<\/p>\n

\"This<\/a>
This Hartford injury sat map shows how many accidents with injuries occurred at the intersection of Main Street and Maple Avenue in Hartford, and the location of those accidents.<\/figcaption><\/figure>\n

Engineers and information technologists at the Connecticut Transportation Safety Research Center at UConn\u2019s main campus in Storrs began building the repository in 2011 in collaboration with the Connecticut Department of Transportation\u2019s Highway Safety Office and the Connecticut Department of Emergency Services and Public Protection.<\/p>\n

UConn staff spent over a year inputting details from thousands of paper state crash reports to create the database. Data collection dramatically improved with the implementation of a new state system that allows police departments to file digital versions of their crash reports.<\/p>\n

Ultimately, the UConn team hopes to improve the database and data integration to the point where it meets all of the guidelines currently recommended by the federal government. If successful, Connecticut would be the first state in the country to meet that high standard, Jackson says.<\/p>\n

As part of that goal, Jackson and his team are working with Connecticut\u2019s Judicial Branch and departments of public health, motor vehicles, and transportation to obtain more transportation safety data. That data includes such things as toxicology reports, injury and treatment information from hospitals, and citation and adjudication information, as well as records involving driver and vehicle history.<\/p>\n

\"A<\/a>
A close-up Google street view of the same Hartford intersection, showing where accidents occurred.<\/figcaption><\/figure>\n

\u201cHopefully, we\u2019ll be able to merge that data with our crash data so that when a crash occurs, we can find out how may prior DUIs a person had, how many speeding tickets they\u2019ve had, what injuries they suffered, how long they were in the hospital, how much it cost to treat those injuries, etc.,\u201d says Jackson. \u201cWe can then analyze that data to see whether current drunk driving or speeding laws are adequate.\u201d<\/p>\n

Information will be coded so that no personal identifying information about drivers and injuries will be accessible through the database.<\/p>\n

As a first step, UConn\u2019s Transportation Safety Research Center is currently working with the Connecticut Department of Motor Vehicles on a pilot project involving the transfer of data from the state\u2019s graduated driver license program for teens and first-time drivers.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

The database is becoming an essential tool for anyone seeking to improve safety on Connecticut\u2019s roads and nationwide.<\/p>\n","protected":false},"author":12,"featured_media":127186,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_crdt_document":"","wds_primary_category":0,"wds_primary_series":0,"wds_primary_attribution":0,"footnotes":""},"categories":[1866,1715,2076,2225],"tags":[],"magazine-issues":[],"coauthors":[1928],"class_list":["post-127014","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-engr","category-community-impact","category-research","category-uconn-storrs"],"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","acf":[],"publishpress_future_action":{"enabled":false,"date":"2026-04-11 16:19:00","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/posts\/127014","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/comments?post=127014"}],"version-history":[{"count":10,"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/posts\/127014\/revisions"}],"predecessor-version":[{"id":127644,"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/posts\/127014\/revisions\/127644"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/media\/127186"}],"wp:attachment":[{"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/media?parent=127014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/categories?post=127014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/tags?post=127014"},{"taxonomy":"magazine-issue","embeddable":true,"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/magazine-issues?post=127014"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/today.uconn.edu\/wp-rest\/wp\/v2\/coauthors?post=127014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}