Discipline: Analytics

EMS Portal

  • April 27th, 2015
  • in

About

The Alabama Emergency Medical Services and Trauma data has been configured to display in the dashboard shown below.

Currently there is only one database on this portal but other databases can be added to the portal.

EMS_20150429

Features

  • Displays Summary Data
  • Performs Dynamic Analysis
  • Drill Down tab for specific filtering of data
  • Applies Filters to Data
  • Does Side-By-Side Data Comparisons
  • Performs Crosstabs of Two Variables
  • Fast – Uses CARE Processing Engine
  • Does Timeline Analysis
  • Data sources updated regularly for timely data
  • Exports data, charts and graphs to Excel or as an image

Download the EMS Portal flyer

ADVANCE

  • March 19th, 2014
  • in

About

ADVANCE is a powerful web portal dashboard that allows users to analyze and visualize electronic data in a variety of ways. Any database can be configured to display in an ADVANCE dashboard.

Currently the eCite, eCrash, eWeight and ULTRA databases have been put into ADVANCE. Other databases will be added.

ADVANCE was developed through sponsorship from the Alabama Criminal Justice Information Center and the Alabama Office of Highway Safety. ADVANCE is individually password protected for use by law enforcement personnel.

Dashboard

Features

  • Numerous source databases
  • Displays summary data
  • Performs dynamic analysis
  • Searches records
  • Applies filters to data
  • Generates maps based on GIS
  • Does side-by-side data comparisons
  • Drill down tab for specific filtering of data
  • Uses rapid CARE Processing Engine
  • Can view/print eCite tickets and eCrash reports
  • Data sources are updated nightly for timely data
  • CARE Online Analysis tab for frequency, crosstabs and more
  • Report tab for routine reports
  • Exports data, charts and graphs to Excel or as an image

Download the ADVANCE flyer

SAFETY

  • March 19th, 2014
  • in

About

SAFETY is a powerful web portal dashboard that allows users to analyze and visualize electronic data in a variety of ways.

This dashboard is designed specifically for traffic safety professionals. It contains crash data including location information and is individually password protected for use by official traffic safety personnel.

Features

  • Displays Summary Data
  • Performs Dynamic Analysis
  • Applies Filters to Data
  • Searches Records
  • Crash Report Viewer
  • Generates GIS maps
  • Exports data, charts & graphs to Excel or image
  • Report Scheduler – weekly, monthly, quarterly
  • Reporting tools – get report emailed to you
  • Batch Report Downloads
  • Extremely Fast – Uses CARE Processing Engine
  • Data sources updated nightly for very timely data

Download the SAFETY flyer

SafetyPortal_20131010_2

CARE

  • March 19th, 2014
  • in

About

The Critical Analysis Reporting Environment (CARE) is a data analysis software package originally designed for problem identification and countermeasure development in traffic safety applications.

It uses advanced analytical and statistical techniques to generate valuable information directly form data.
Using CARE’s step-by-step on screen menus, it is easy to turn data into enlightening information.

CARE provides:

  • descriptive statistics
  • information mining
  • geographical information system access
  • roadway engineering support
  • dashboard support

CARE’s dashboard support includes access to real-time statistics on key law enforcement systems including:

  • traffic citations
  • crash reports
  • criminal incident reports
  • other critical systems for which we have developed field data capture software

Dashboards have been deployed for:

  • police agencies
  • traffic engineers
  • traffic safety stakeholders

While its primary use is for traffic safety, CARE can be used to process any database including:

  • emergency medical services
  • medical data
  • nursing data
  • questionnaires
  • criminal justice

The CARE software for traffic safety applications is available free of charge. In order to take full advantage of CARE, existing data must be converted into a CARE dataset. In the case of a state, initial state CARE data sets can be created by having the state’s current database read by CARE’s Extract=Translate-Load (ETL) to produce the various CARE datasets that form the CARE warehouse. CAPS can create the initial state CARE dataset for your state for a reasonable fee. Contact Us.

The CARE software exists in both a desktop version for Windows OS and a Web version. CARE can be downloaded here or installed from a CD. Additionally, some highway safety CARE capabilities are also available online at the CARE Online Analysis site.

CARE is an award-winning program:
NHTSA 1995 Administrator’s Public Service Award
Runner-up for the 20015 ATSIP Best Practice Award.

Using the CARE program will undoubtedly assist the traffic safety program of any organization that chooses to use it.

CARE Overview Video

Features

    • Statistical Generation: CARE retrieves summary information for the entire database or for any part (or subset) of it. Its Filters Menu allows the creation or combination of filters that restrict consideration to any specific subset of the database (e.g., alcohol, pedestrian, bicycle, motorcycle, particular counties or other geographical areas). Any attribute, or any combination of attributes, can be used to create filters, enabling the easy generation of literally any statistic.
    • Data Analysis: Charts and graphical displays are produced for any or all variables in the database. A frequency output of any variable or a cross-tabulation of any two variables is instantly displayed. (Note that the words variables and attributes are used interchangeably – for crash records, these are essentially the data elements collected on the crash report form.)
    • Information Mining Capability: One of the most useful capabilities of CARE lies in its unique information mining capability, called IMPACT. IMPACT automatically generates information from the data without users having to specify queries or, for that matter, even know what the attributes are in their databases. All the user has to do is to specify one or two filters. IMPACT can compare two subsets of data using a single filter, e.g., alcohol crashes vs. non-alcohol crashes. An example of this is given below for the impact speed attribute. In this example, the red bars in the chart are for the alcohol crash subset. The blue bars in the chart are for non-alcohol crashes. It is quite clear that the alcohol crashes have significantly and dramatically higher impact speeds, which clearly accounts for their higher severities.
      care1Users do not have to specify the attributes to be processed by IMPACT. Any or all can be processed simultaneously, and the results can be ordered according to the most significant first. Statistical tests are performed for all IMPACT results. Clearly, IMPACT provides the the ability to obtain crucial information from the database without having to generate endless queries. Latent information is mined out of the database, analyzed, and instantly presented in both graphical and tabular charts. The results are prioritized indicating areas where countermeasures will provide maximum gain. The information discovery potential is unlimited, offering decision-makers unprecedented information-generation power from their data warehouses.
    • Non-Categorical Variables: CARE is not limited to what are called “categorical” variables, i.e., those with discrete values, such as time of day, day of the week, contributing circumstances. Some applications require continuous variables, such as temperatures, distances or other such measurements. Non-categorical variables can be specified to the CARE ETL when creating a CARE dataset, allowing a list of values directly from the available raw data as opposed to being restricted to a known list of discrete values or ranges.
    • Narrative Data Searching: CARE can process narrative descriptions, such as that within traffic crash narratives. The goal is to generate filters to identify those records where particular words of word combinations occur. This can be quite useful since sometimes the narrative contains information that is not in the categorical variables. For example, a categorical variable may contain the fact that a deer was struck. However, it is rare that any categorical variable will contain the fact that a driver was taking evasive action to avoid a deer. This information is contained strictly in the narrative. CARE enables a word or phrase to be used to create the filter from the narrative. This filter can be combined (ORed) with all other related filters to produce the subset desired. In order to assure that the words or phrases are being used appropriately, users can view the context and either approve or disapprove the particular record. At that point, the “Generate Filter” button creates a filter that includes all of the records selected.
    • Hotspot Determination: A hotspot is a location that has a particularly high crash history, sometimes of a particular type of crash (e.g., hotspots for selective enforcement might be defined as those with excessive crashes caused by speed or alcohol). CARE uses a variety of techniques for identifying hotspots. As an example, for mileposted routes, one method is for users to specify a length of the segment and the number of crashes within the segment for it to qualify. For example, in the display given below, the criteria specified was a minimum of 20 crashes in 0.4 miles (note that this is over a four-year period). A map is given along with the strip map to assist engineers in locating the hotspots.

care2

    • Report Generation: There are many options for producing various helpful reports with just the click of the mouse. Of course, the major reason for identifying hotspots is so that some countermeasure can be applied. Note the “Reports” icon in the upper right corner of the display above. This button leads to a very large number of reports that officers or engineers can take to the location in order to run down just exactly what the problems are. These reports range from overall summaries to detailed information on a per-crash basis. Any of the outputs discussed above can be exported to Microsoft Office products, including Word and Excel, enabling them to be formatted for reports or processed further.
    • Collision Diagram Generation: Intersection Magic is a powerful collision diagram generator that has been integrated into CARE to automatically draw collision diagrams for any location specified by CARE. This avoids the issues of having to understand all of the database ramifications of collision diagram generation, since once the location is defined within CARE the collision diagram is generated at the click of the mouse. A separate license must be obtained from Pd’ Programming in order to use this feature; Alabama has obtained a statewide license for the use of Intersection Magic.
    • GIS Integration: Quite analogous to the collision diagram integration, ESRI/ArcGIS has been integrated into CARE enabling analysis results from CARE to be mapped using ArcView with the click of the mouse. In addition, the GIS map can be used to create a filter so that a subset of the mapped crashes can be further analyzed in CARE. For more information on this aspect of CARE’s capabilities, see Crash Mapping Flyer.

care3

    • Open Road: This application links roadway images to route-event data which is generated by the standard CARE software. Users can select a location on a mileposted route and view images along that route just as if they were driving down the road, as shown below.

      care4

      Along with the roadway images, OpenRoad also displays “events” that occur along the route. An event is defined as any object or occurrence that can be located with a specific route and milepost. Events are represented symbolically by a shape and color. Different types of events can be visually displayed with different symbols. For example, in the example above, fatal crashes are shown as red squares, while serious injury crashes are green triangles, and property damage only crashes are given by circles.

  • Continued Innovations: The Center for Advanced Public Safety (CAPS) constantly strives to improve and enhance the CARE software. Essentially each previous version serves as a prototype for the next version that includes both minor and major improvements, many of which are suggested by CARE’s users. Recent improvements include the following:
    • Standard Printing options include: Page Setup, Print, and Print Preview
    • Standard Window manipulation capabilities including: Cascade, Tile Horizontally, Tile Vertically, Arrange Icons, and Close All
    • User control of the variable ordering, filter grouping and exit setting (all within the Tools menu)
    • Dynamic menus: items appear only when available
    • Current data set and filter can be changed in most dialogs without changing the default data set and filter or returning to the main screen
    • The suppress zero-value frequency checkbox has moved to the results screen allowing quick changes in eliminating non-relevant data
    • The variable selection dialogs contain new sorting capabilities
    • The tabular and graphical results data may be reordered by any column
    • The Over Representation, Max Gain, and Threshold Entries are on the results screen instead of in a pop-up window

Training Documentation

Training Videos

Running a Cross-Tabulation
VIDEO COMING SOON

Online Analysis

The Online version of CARE does not contain all the functionality of the desktop version but you can do frequency, crosstab and IMPACT analysis online with public datasets. Click here to do Online Analysis with CARE.

Other CARE Documentation

An Analysis of Teen-Age Driver Crashes 2005-2008

  • January 10th, 2010
  • in

This study was conducted at the request of an advocate group that wanted information to assist them in developing public information and education countermeasuers for teen-age drivers. While most past CAPS studies of youth-involved drivers were limited to 16-20 year olds, the advocate group was also interested in 15 year olds, and they were not interested in 20 year olds since their projects were oriented around teen drivers. Several studies were conducted, including CARE IMPACT studies that compared 15, 16-19 and 15-19 year old causal drivers with causal drivers in the older age group.

A Relation Context Oriented Approach to Identify Strong Ties in Social Networks

  • October 1st, 2009
  • in

Social network graphs have been found to be an extremely effective tool in the identification of potential perpetrators of criminal activity. These graphs can grow extremely large, as illustrated by an example within this paper that contained over 4.9 million nodes and over 211 million edges. Obviously some reduction of these graphs is essential to their being useful. Further, considerable “noise” (false positive relationships) are generated when the graphs are totally comprehensive. This research transformed the original social network into a relational context-oriented edge-dual graph. This was done by evaluating the quality of the connectivity for each edge to obtain a metric to this effect for each edge. By retaining only the strongest edges the overall graph becomes more reliable and more useful in practice.

HIT: A GIS-Based Hotspot Identification Taxonomy

  • June 1st, 2009
  • in

The authors have developed a Hotspot Identification Taxonomy (HIT) that organizes the various methods for viewing hotspots. Basically they are defined as follow:

  • First order – high crash frequency road segments possibly filtered for specific event(s);
  • Second order – road segments defined as those that have high event counts specifically related to a countermeasure under consideration (e.g., selective enforcement for the speed event);
  • Third order – segments having a high frequency of countermeasure-related events and for which the countermeasure was historically effective.

Effective use of the HIT model required four interrelated activities: data-collection, linear hotspot identification, presentation and assessment.

Analysis of the Wet vs. Dry Counties within Alabama

  • January 31st, 2009
  • in

CARE IMPACT analyses were performed to compare 13 dry counties with 13 wet counties over their various crash characteristics for a recent five-year (2003-2007) time period. The results fall into two logical categories: those that compare the demographics of the counties and those that compare the crash characteristics with regard to alcohol. A few of the nearly 200 attribute comparisons are presented in this report in order to guide the future direction of the research project.

Using an Edge-dual Graph and k-connectivity to Identify Strong Connections in Social Networks

  • March 1st, 2008
  • in

The goal of this paper is to use edge-dual graph transformation techniques to improve the accuracy of social network analysis (SNA). SNA is used in law enforcement to determine if relationships exist among potential suspects, and to identify just what those relationships might be. Relationships can be family, friends, past associates, cell mates and even prison enemies. The paper presented results that showed that this transformation had a very high potential for increasing the accuracy of relationship search routines.