Data Dictionary

The table below is the data dictionary for the model TIM performance measurement database. This table provides the name and a description of each data table in the model TIM performance measurement database, including the lookup tables and the pre-populated values for these data elements. Although differences in nomenclature do exist between response agencies, to the extent possible, the data elements and prepopulated values in the lookup tables are described using common nomenclature. A table with the description of the attributes of each data element identified in the model TIM performance measurement database is available for download ([filedownload file=”/uploads/files/Attributes_for_Each_Table_in_the_TIM_Data_Model_final.pdf” type=”application/pdf”]click here for the data element attributes table[/filedownload] to download).

Model TIM Performance Measurement Data Dictionary

Table Name Table Description
INCIDENT The main table for the data required to calculate and represent TIM performance. The other tables are used to support this incident table.
INCIDENT TYPE* The list of incident types. The prepopulated incident types include: crash, vehicle fire, disabled vehicle, out of fuel, debris, and other.
SEVERITY TYPE* The severity of the incident. The prepopulated severity types include: minor, intermediate, and major.
CONDITIONS The conditions at the time of the incident. Includes links to tables describing lighting and weather conditions.
LIGHTING* The lighting conditions at the time of the incident. The prepopulated lighting conditions include: dawn, daylight, dusk, and dark.
WEATHER* The weather conditions at the time of the incident. The prepopulated weather conditions include: clear, cloudy, drizzle, rain, freezing rain, sleet or hail, snow, and fog.
PARTICIPANTS The number of people involved in the incident and the number of each type of injury (if any).
PARTICIPANT The ID of the participants.
PARTICIPANT TYPE* The type of participant involved in the incident. The prepopulated participant types include: driver, passenger, pedestrian, cyclist, first responder, and other.
INJURY TYPE* The type of injury sustained. The prepopulated injury types include: none, minor, serious, fatality.
ROADWAY The characteristics/conditions of the roadway on which the incident occurred. Includes links to tables describing location type, roadway type, roadway name, location, direction, surface conditions, and lanes involved.
ROADWAY HAS INCIDENT Because the incident can affect more than one roadway (e.g., an intersection of two roadways or both directions of a roadway), this table allows the association of more than one roadway with an incident.
ROADWAY TYPE* The type of roadway on which the incident occurs. The prepopulated roadway types include: freeway, arterial, and collector/distributor.
NAMED ROADWAY* The names of all roadways in the reporting area.  NOTE: no prepopulated values.  Needs to be populated with the names of local roadways in TIM coverage area.
LOCATION TYPE* The way in which the location of the incident is referenced. The prepopulated location types include: mile marker, cross street, and nearest ramp.
DIRECTION TYPE* The roadway direction in which the incident occurs. The prepopulated direction types include: northbound, southbound, eastbound, and westbound.
SURFACE CONDITIONS* The surface conditions of the roadway at the time of the incident. The prepopulated surface conditions include: dry, wet, snow, and ice.
TOTAL LANES The total number of directional lanes at the incident scene and the lanes involved in the incident.
LANES INVOLVED* The lanes that are involved in the incident. The prepopulated lanes include: shoulder only; lane 1; lane 2; lane 3; lane 4; shoulder and lane1; lane 1 and lane 2; lane 2 and lane 3; lane 3 and lane 4; shoulder, lane 1, and lane 2; lane 1, lane 2, and lane 3; lane 2, lane 3, and lane 4; shoulder, lane 1, lane 2, and lane 3; lane 1, lane 2, lane 3, and lane 4; all lanes.
LANE INOVLVED For each lane involved, the lane number, the time the lane is closed, and the time the lane is opened.
VEHICLES The number of vehicles involved in the incident and whether there was a heavy vehicle or hazmat vehicle involved.
RESPONDENTS The number of emergency responders and the number of emergency vehicles at the incident.
RESPONDENT The ID of the respondent, the time the respondent arrives at the scene, and the time the respondent leaves the scene.
RESPONDENT VEHICLE The type of respondent vehicle, the time the respondent vehicle arrives at the scene, and the time the respondent vehicle leaves the scene.
VEHICLE TYPE* The types of response vehicles at the incident. The prepopulated respondent vehicles include: towing, law enforcement, fire, EMS, medical examiner, and transportation, freeway service patrol.
ORGANIZATION* The organizations to which the respondent belongs. The prepopulated organizations include: towing company, police department, fire department, transportation organization, freeway service patrol, private organization, and health department.

*Database look-up tables.