HIGHWAY SAFETY INFORMATION SYSTEM GUIDEBOOK FOR THE MINNESOTA STATE DATA FILES

SAS File Formats

Prepared by

Forrest M. Council
University of North Carolina
Highway Safety Research Center
730 Airport Road
Chapel Hill, NC 27599-3430

Yusuf M. Mohamedshah
LENDIS Corporation
Turner Fairbank Highway Research Center
Federal Highway Administration
6300 Georgetown Pike
McLean, VA 22101-2296

Prepared for

Federal Highway Administration
Office of Safety and Traffic Operations Research & Development
U.S. Department of Transportation
Washington, DC 20590

Revised, August 2007

TABLE OF CONTENTS

• INTRODUCTION
• DETAILS OF MAJOR FILES
  • The Accident Files
  • The Roadlog File
  • Traffic Data
  • The Intersection/Interchange File
  • Issues Related to Merging Files
• MINNESOTA CONTACTS
• COMPOSITE LIST OF VARIABLES
• ACCIDENT FILE
  • ACCIDENT SUBFILE
  • VEHICLE SUBFILE
  • OCCUPANT SUBFILE
• ROADLOG FILE
• INTERSECTION/INTERCHANGE FILE
• "GENERAL" VARIABLES
• SEGMENT (ROUTE) SPECIFIC VARIABLES
• LEG (APPROACH) SPECIFIC VARIABLES

INTRODUCTION

(NOTE:  Changes from the previous edition of the Guidebook are shown in bold and italic.)

The Minnesota data system includes the following basic files:

• Accident data:
  • Accident File
  • Vehicle File
  • Occupant File
• Roadlog File
• Reference Post File
• Traffic File
• Intersection File
• Bridge (Structures) File
• RR Grade Crossing File

For ease of use, the three accident subfiles, the Roadlog File, and the Intersection File have been converted to SAS files.  The Traffic file (volume data) and data from the Reference Post file (True Mileage) have been merged with the Roadlog file beginning with 1990 data, and no longer exist as separate files within HSIS.  The Roadlog file prior to 1990 has only the traffic data merged.  Raw file data are provided to the Highway Safety Research Center (HSRC) where they are retained as backup information.  The documentation (variable listings, definitions, etc.) for these raw files and for the SAS files that are developed from them are available at Federal Highway Administration (FHWA) offices.

Beginning in 2004, the HSIS system was converted from SYBASE relational database to ORACLE relational database for internal use.   This ORACLE database stores the data received from Minnesota and other States, and the data files for a given State are linked and manipulated using SAS code.  However, this conversion from the original SAS-based system to the ORACLE relational system is somewhat transparent to the end-user of the data since the output files produced by ORACLE for modeling and analysis will be SAS formatted.  As in the past, we have continued to produce SAS format libraries for each of the variables in each of the files.  Because it is envisioned that the majority of analyses will utilize these SAS files and formats, this Guidebook will concern these SAS files - their formats, completeness, and quality. 

The accident data are in three separate subfiles, the first containing the basic accident information on a case-by-case basis, and then separate files containing information on vehicles and occupants  (injured occupants in 1985-90, injured plus some uninjured occupants in 1991, and all occupants beginning in 1992) in each accident case.  The vehicle and occupant data (which includes pedestrians and bicyclists) can be linked to the basic accident data for a specific case using the accident report number and vehicle number.  Again, please note the change in the file to all occupants for 1992 and later.  The accident subfile can be linked to the other major files (e.g., Roadlog, Intersection/Interchange) using three common variables -- route-system, route-number, and reference point.  Beginning in 1991 the Minnesota Department of Transportation (MnDOT) made extensive changes in their accident reporting system. These will be described in more detail in the later text.

Unlike an Accident File record which is referenced to a point on the roadway, each record on the Roadlog File contains information on a homogeneous section of roadway (i.e., a stretch of road which is consistent in terms of characteristics), with each new section being defined by a new beginning reference point.  Each record on this Roadlog File contains current characteristics of the road system including surface type and width, shoulder and median information, lane information, etc.

The Reference Post (“True Mileage”) File received from MN contains "true mileage" information on some of the sections within the Roadlog File, primarily the Interstate and major arterials.  This information is used in the calculation of the lengths of homogeneous sections in the Roadlog File where available.  For sections where Reference Post File data do not exist, the section length is estimated by subtracting the beginning milepoints for two consecutive sections of roadway.  In 1990, HSIS staff conducted comparative analyses to determine whether the lack of “true mileage” information on some lower-order roadway sections significantly affects the section-length data and subsequent crash rate calculations.  In summary, the analyses indicated that the use of length estimates based on milepoints (where “true mileage” is absent) does not appear to result in a significant error, i.e., the use of the length estimates based on mileposts appears sufficiently accurate for analyses conducted with HSIS data.  (A fuller description of these analyses and findings is available from HSIS staff.)  Again, please note that beginning with 1990, pertinent data from the Reference Post File were merged with the Roadlog file and the entire file is no longer available as a separate file on the HSIS system.

The Traffic File contains estimated count information (yearly AADT's) for a series of count stations located on all roadways described in the Roadlog File.  It is maintained by the eight different MnDOT District Offices.  This AADT information can be linked with the sections on the Roadlog File using the reference point.  This file also contains AADT's for heavy commercial vehicles which are defined as vehicles with two axles and six tires or larger.  The file is updated on a two-year cycle, and indications are that these traffic count data are excellent for the trunkline system and fairly good for the county state-aid systems.  Again, please note that traffic data were merged with the Roadlog File beginning in 1987.  The Traffic File also still remains a separate file on the HSIS system for years 1987 thru 1989, but is no longer available as a separate file on the HSIS system after 1989.

The Intersection/Interchange File contains information concerning intersections on major roadways that are maintained by the eight different MnDOT Districts across the state.  It contains a number of different variables including approach lane information, entering AADT, intersection control type, and added details for signalized intersections.  The file will contain intersections of US/US, US/state, and all interchanges. 

Due to established priorities of effort, HSRC staff did not work with the Bridge File or the Railroad Grade-Crossing File.  As is the case with most States, the Bridge File data contain information on bridge structures across the State.  The data are considered quite accurate since it is based on the federal bridge inventory.  It is also noted that the MnDOT Bridge Division that updates this file has a file of pictures of each bridge that is greater than 10 feet in length.  In a similar fashion, the Railroad Grade Crossing File is a file containing information on all grade-crossings in the State, and is prepared and maintained according to FHWA requirements.

Details of the Accident, Roadlog, and Intersection/Interchange files and the traffic data are presented in the following section.

DETAILS OF MAJOR FILES

The Accident Files

Minnesota law requires that an accident report be filed by the investigating police officer whenever there is injury in the crash or property damage of greater than $500.  The property damage threshold increased to $1,000 in August, 1994.  The accident data are controlled by the Department of Public Safety (DPS), where a group of coder/editors not only keys in the data, but also locates each of the accidents based on the inputs provided on the report by the investigating officer and a series of maps showing the route identification and locations of prominent features and intersections.  While incorrectly coded locations are identified by MnDOT edit programs and are passed back to the coders for possible correction, DPS staff limitations have prevented correction of all such errors.  Thus, from an engineering analysis standpoint, there remain some location errors in the system.  However, given the relatively small percentage of location errors identified and the fact that the main result of these errors is to reduce the sample size of available accidents (a problem partially overcome by the large samples available for most HSIS-type analyses), the location information should be of higher quality than in most States.  It is also noted that accidents that occur on interchange ramps are located to the center of the interchange.  Thus, in bridge-related analyses, if the major route crosses over the minor route, the ramp accidents will be (erroneously?) located to the bridge.

MnDOT send an annual accident file to HSIS each year.  Currently, there are 21 years of accident data in the linkable Minnesota files obtained for the HSIS -- 1985-2005.  Prior to 1991, the original data set received from Minnesota included approximately 90,000 accidents per year and approximately 170,000 vehicles per year.  However, for use in the HSIS system, the "citizen reports" (i.e., code "0" under "Officer Type”) have been deleted due to both missing data and inherent biases in these reports.  In addition, the very limited number of crashes which cannot be linked to the roadway file have also been deleted.  This process has left approximately 71,000 - 86,000 crashes and 132,000 - 160,000 vehicles in the HSIS files for 1985-2005.  

The number of crashes increased from 71,000 up to 86,000 with some fluctuations.  Based on conversations with MnDOT staff, the fluctuations may have been due to increased snow/ice and related increases in crashes.  Changes in the numbers of vehicles in the HSIS Vehicle subfiles track the changes in accidents very closely- there are no “abnormal” years.  Indeed, the ratio of vehicles/crash is between 1.83 and 1.87 for this full 21-year span. 

Beginning in 1991, the Minnesota Department of Public Safety made extensive changes in their accident reporting system.  These changes affect both the coverage and accuracy of the data in the HSIS files.  The changes that have had the most effect on the HSIS system are as follows: (1) changed computer platforms from IBM MVS to VAX (March 11, 1991) which changed data coding screens and codes; (2) changed the accident report form in January 1991; (3) initiated a state-wide campaign to promote the use of the new report forms. The effects of these changes are noticeable in both the 1990 and later occupant data. (Note that there may also be changes in the overall accident severity distributions beginning in 1995 and later, given that the property-damage-only reporting threshold changed to $1000 in August, 1994.)

The Vehicle and Occupant subfiles are similar in format to those in other states.  The Vehicle Subfile contains variables on both the vehicle (e.g., make, model, type, direction traveling, contributing factors), and on the driver (e.g., age, sex, physical condition).  The Vehicle Subfile also contains information on a four-part sequence of events for each vehicle, which provides more detail on vehicle "paths" than do most state files.  The Occupant subfile contains information on such descriptors as age, injury, position in vehicle, ejection, etc. for each occupant in the vehicle, including the driver.  It is again noted that the occupant records are not total occupant records for years 1985-1989, but simply consist of those occupants who are injured in the crashes.  For those earlier years, there are approximately 39,000 occupants in the file each year.  While coding of uninjured occupants began in 1990, it appears that complete coding on all occupants is present in 1992 and later years.  Except of this major change, the only other change in the Occupant Subfile across the time frame was in 1996 and later, when the number of occupants per vehicle increased by approximately 10% over the preceding years.  Conversations with MnDOT staff indicate that they began adding additional “placeholder” occupant records in this file so that the total number of records in the Occupant File for a given vehicle matched the “number of occupants” for that vehicle as entered by the investigating officer.  The assumption was that the officer would record the “count” variable correctly, but might not include data on each uninjured occupant.  Based on the pattern in the file, our assumption is that these “placeholders” were added beginning in 1996.

Information related to data completeness and accuracy in these three subfiles is based on three sources -- conversations with Minnesota staff who use the data, information developed through past use of the data by HSIS staff and other researchers, and comparisons of a series of single-variable tables for key variables in each file with the same variables in all other years.  This latter set of quality control checks is conducted each year that a new file is received from MnDOT.   

A check of the percent "unknown" for each variable in the files indicated that, once citizen and "unknown-officer" reports are removed, almost all the variables studied show a very low percentage of unknowns or obviously miscoded variables -- usually around l-3 percent of the total sample in each variable.  The 1991 file seems to have a slightly higher percent of unknown codes than the earlier or later years, but the 1992 and later years’ percent seldom exceeds 4 percent.

In terms of data accuracy, a series of comparisons were made of variables which should have been somewhat similar on the accident file according to their definitions.  In general, the variables were found to be internally consistent.  For example, a comparison of the number of vehicle records with a count of single and multi-vehicle crashes matched quite accurately.  The urban/rural codes matched well with "investigating officer" codes, and the location of pedestrian/bike accidents matched well with accident type.  The variable indicating "interchange-related" compared well with the number of interchange elements noted in a separate variable, and counts of traffic control devices in accidents were found to match well with the number of intersection-related crashes.

However, there are two variables whose coding formats may lead to inconsistent or erroneous data.  First, (like most other States) the driver-related “physical condition” variable on the vehicle subfile has categories which are clearly not mutually exclusive.  For example, while only one code is allowed, a driver could be both “under the influence” and “ill” or “handicapped”.  Conversations with Minnesota accident officials indicate that the officers are most likely to code alcohol involvement if a choice is present.  Second, the variable related to "safety equipment" in the injured-occupant subfile includes a mixture of codes related to occupant restraints, motorcycle helmet and headlight use, and pedestrian clothing colors.  As verified by Minnesota, the layout of this variable makes it very difficult to code correctly, and they are planning to modify this variable in the future.  For now, the data are suspect. 

In addition, inconsistencies were noted in comparisons of three variables related to the type of accident – “accident diagram”, “accident type”, and “vehicle movement” in the accident.  Conversations with Minnesota accident records officials indicated that the "accident diagram" variable is often recoded (corrected) by coders who review each of the accident reports, while the coding for “accident type” is captured as recorded by the officer.  The coding for “vehicle movement” is (subjectively) assigned by the coders to reflect the nature of movement based on the officer's description.  (Note that “vehicle movement” was not coded for 1990 and later data.)  Since the "accident diagram" variable describes the general nature of the vehicle movements in the crash, it would be expected to be consistent with the vehicle movement prior to accident.  However, there were major inconsistencies noted in the comparison of the two variables.  There are many more possible categories within the second variable related to vehicle movement, and there were notable inconsistencies between the percentages within accident types that would be expected to match certain vehicle maneuvers.  In this case, because it is corrected by the in-house coders, it may be somewhat more accurate to use the accident diagram variable for this application. 

In a similar comparison of “accident diagram” with “accident type” (when driver self-reports are deleted), consistency was found for many of the categories which should be related.  For example, 90 percent of the accident diagram “ran-off-road left” codes were noted under accident type to be either collisions with fixed objects or rollovers.  However, further examination revealed that the accident diagram variable provides the general nature of the crash without reference to what is involved.  For example, for those crashes coded as “head-on” in the accident diagram variable (which one might assume means head-on with a second moving vehicle), 40 percent were coded as “collision with motor vehicle in transport”, and 5 percent were coded as “collision with parked motor vehicle” in the accident type variable.  In like fashion, 15 percent of “sideswipe - opposite direction” under the accident diagram variable were “collisions with parked vehicle” in the accident-type variable.  Clearly, if the analyst is interested in “what” is struck (e.g. another vehicle) in what fashion (e.g. head-on), then some combination of both variables should be used.

Further HSIS analyses using the "accident diagram" variable have also indicated that the “head-on” and “sideswipe opposing” codes reflect the direction of the opposing vehicles immediately prior to impact rather than their initial direction.  While this coding procedure is correct, it does affect analyses in which the researcher is attempting to isolate, say, head-on or sideswipe crashes involving opposing vehicles.  For example, many of the "head-on" or “sideswipe” crashes on multilane facilities, which one might assume to be cross-median crashes, actually involve vehicles originally traveling in the same direction where one of the vehicle spun around (perhaps due to ice or wet pavement) and struck the other vehicle front-to-front or side-to-side.  Again, this does not represent a coding error (since no other alternative is easily proposed), but will affect certain analyses where the type of crash is used to imply something about original direction of travel.

Additional HSIS analysis indicates less than total agreement between two variables which should define whether or not an accident is intersection-related – “intersection relationship” and certain groups of codes within “vehicle movement”.  Note that the former is coded by the officer on the scene, and the latter is coded in-house by coders based on the sketch and narrative.  Since there is no clear choice between the two, one possibility is to use a combination of the two (requiring both to be coded as “intersection-related”), a procedure which would result in a conservative definition of a crash's relationship to an intersection.

Use of the LOC_TYPE variable concerning “Intersection Relationship” has also indicated some problems with the data related to interchange ramps on divided roadways.  A full discussion of the problem is found in the “NOTE” under the variable in the SAS formats.

Finally, the changes in the 1991 accident report system affected the consistency and accuracy of the data in comparison to earlier years.  Certain categories in specific variables changed in either frequencies (e.g., “collision with vehicle other roadway” in ACCTYPE increased), and coding (e.g., “not applicable” changed to “no object struck” under the “fixed object struck” variable for 1991, but not for 1992 and later).  When questioned about these differences in the data, Minnesota staff indicated that (1) some data entry edits were not in place in the early use of the new system, allowing inclusion of some invalid data values for some variables; (2) the new system has automatic default values for data entry screens, and in initial use of these screens, the data entry personnel may not have replaced the default values with actual codes from the accident report form; (3) wording of the accident report form changed for some variables, which could have led to different interpretations of the appropriate code to check on the new form; and (5) the new accident report form increased the number of “other” and “unknown” categories available for use by the officer.  It should also be noted that the code changes for data in 1990 and 1991 made some variables inconsistent with the prior years of data (1985-89). To correct this problem, where possible, 1990 and 1991 data with code changes for existing variables were re-coded to match earlier years.    

In summary, analysis of the Minnesota accident files indicated that the files are, in general, quite accurate and internally quite consistent with few exceptions. The 1991 changes did result in some new codes and some inconsistency with prior years’ data, particularly for the 1991 data.  The 1992 and later data appear to again be consistent with fewer uncoded cases than in 1991.  Where high percentages of uncoded data or possible inaccuracies/inconsistencies have been found, a "NOTE" has been included under the variable listing in the later format section of this Guidebook.

The Roadlog File

As noted above, the Roadlog file contains current characteristics of the road system.  The 135,000-mile system contains approximately 12,000 miles of the primary “trunk” roadway, 33,000 miles of additional state-maintained county and municipal systems, and 90,000 miles of (non-state maintained) county and local roads. Table 1 provides a breakdown of the 55,000 miles of paved, two-way roadway and 80,000 miles of “other” roadway in the state (i.e., either unpaved or county/local roads without complete inventory information).

The state maintained portion of the file is basically updated daily based on construction and maintenance plans and input from the local division engineers.  Data changes are extracted from these plans and are activated in the system on the date that the project has been completed.  An "effective date" is placed on the file at that time to indicate that one or more of the variables for that roadway section have been changed.

Again, the DPS makes a frozen copy of the roadlog file annually for submission to HSIS.  However, unlike other states, this is not done at the end of the calendar year, but at the time when the accident file is finalized for a preceding year.  This is usually between March and July of the following year.   The file received by HSIS from MnDOT contains approximately 303,000 records.  Approximately 103,000 of these records are “false” records used to signify ends of routes, beginnings of coinciding routes, gaps in sections, and other records needed to allow analysis of the files.  These "false" records are flagged by values in the "Remark" variable, and, thus, any record with blanks in this variable (approximately 220,000 "true" records) represents a section of "homogeneous" roadway where characteristics remain constant. For the 1994 and later HSIS files, all “false” records are deleted.

These 220,000 records cover approximately 135,000 miles of roadway.  The HSIS system currently contains fifteen Roadlog files, representing current characteristics in 1989-1992, 1994-1996 and 1998-2005.  (The 1987 file, which was originally in the HSIS system, could not be reformatted for consistency in recent file modifications.  Thus, it is no longer a part of the system.  The 1993 file was omitted from the system due to missing mileage in the raw file. The 1997 file received could not be linked with crash data.  The analyst can link the 1997 crash data with either the 1996 or 1998 files.)  Because of the complexity of the necessary programming, computer checks for changes in each variable between years were not conducted, but conversations with Minnesota staff indicate that only a very small proportion of the file would be expected to change each year.  

The number of total crashes in 2003 is approximately 10,000 lower than for prior or subsequent years.  Conversations with MN DOT staff indicated that this was during a transition to a new crash reporting system, and that almost all of the decrease would be in non-injury (PDO) crashes.  HSIS quality control runs on critical variables indicated that the 2003 distributions are similar to other years. However, the user should be aware of this bias in the data.

Two new variables, RODWYCLS and MVMT, have been created by HSIS staff in the roadway segment file of each of the HSIS states.  The RODWYCLS (Roadway Class) variable is based on the combination of rural/urban, access control, number of lanes and median type variables. This variable classifies each roadway segment into one of ten roadway types described in the later “Format” section.  This variable is also included as an accident-file variable by matching each crash to its corresponding roadway segment. The MVMT variable (Million Vehicle Miles of Travel) is calculated for each segment in the roadway file by multiplying the segment length, AADT and 365 days in a year, and dividing by one million.  Both these variables were created in response to inquires from data users, whose most frequent questions have concerned either crash frequencies or rates (per MVMT) for one or more of these roadway classes.  The accuracy and completeness of the file was again assessed through conversations with Minnesota staff, a series of single-variable tabulations for 30 key variables which are compared across years each time a new file is received, and past HSIS analyses with the data.  Minnesota staff feels that, in general, the updating system and the quality of the data are excellent on 12,000 miles of the primary roadway, good on an additional 33,000 miles of state-maintained systems, and adequate or "average" on an additional 90,000 miles of county and local roads.

Single-variable runs were then made for variables related to shoulder type and width, median type and width, access control, surface type and width, divided/undivided designation, functional class, design speed, and urban/rural coding.  With few exceptions, the runs indicated very low percentages of "unknown" or "not applicable" codes.  Two variables related to "design speed" and "storm sewers" have very high proportions of unknowns.  As expected, since they only relate to the approximately two percent of the mileage that is on divided highways, variables related to "Road 2" and those related to medians are characterized by very high proportions of "not applicable."  Finally, variables related to left and right shoulder type and width and surface type and width for Road 1 all contain approximately 12 percent of "not applicable" values in the 1990 and earlier files, and approximately 5 percent in the later files.  Further conversations with Minnesota staff and computer runs revealed that in most cases, "not applicable" actually means "not coded".  However, both information from Minnesota and a cross-tabulation of two of the key variables (shoulder type and surface type) with the variable "road system" in the 1987 file indicated that approximately 92% of these "not applicable (not coded)" sections were on the lower-order township or municipal roadways.  All the higher order routes were coded a very high proportion of the time. 

With respect to data accuracy, cross checks of the similar variables on the file such as shoulder width and type on different sides of the roadway, pavement type on the divided sections of highway, and others indicated quite consistent data across the variables once the uncoded values were removed.  Thus, the file appears accurate, as would be expected from the continuous update procedures in place.

Finally, there is the remaining issue of how to handle the linkage of accidents with divided roadways where the Roadlog information is divided into "roads 1 and 2".  Unfortunately, because there is no information on the accident report related to "road 1 or 2", there is no simple way of linking a given crash with the proper piece of pavement.  As part of their merging system, Minnesota has attempted to develop some logic for such an assignment based on the direction of travel from the crash form and the mileposting direction from the Roadlog file.  However, they are not satisfied that even their best attempt at such logic is accurately assigning the accidents. 

We further examined this issue by printing out 200 records related to divided highways in the 1987 file and compared the individual variables for road 1 with road 2 which are related to right shoulder width, right shoulder type, surface width, surface type, left shoulder width, left shoulder type, and the presence or absence of curbs on one or both sides of the roadway.  The question being examined here was whether or not there were significant differences between, say, the right shoulder width or type on road 1 versus the same variable for road 2.  If little difference is found, it would be possible to simply link any accident occurring on a divided highway section with the characteristics of road 1. 

The analysis indicated very little difference between most of the variables on the two roads.  Right and left shoulder type, shoulder width, and curb presence on the two roads "disagreed" in only 1 - 4 percent of the cases.  The only major area of disagreement was in the variable related to "surface width" for the two roads, where differences were noted in 26 (13%) of the records.  Of the 26 disagreements, three surface widths disagreed by two feet, five disagreed by 3-5 feet, 13 disagreed by 10-14 feet (an additional lane), and 5 disagreed by 15 to 20 feet. 

Based on these findings, we suggest that two options exist for the analyst in future efforts.  First, in all cases where the "divided and one-way code" indicates a "divided rd1 and rd2," programs could be developed to check for differences between road 1 and road 2 values for the variables in question, and records could be dropped from the analysis where differences exist.  Or second, for all variables except surface width, the analyst could simply link accidents on divided roadways with "road 1" data.  We feel that this second option is quite defensible given the low "disagreement rate" (which would most likely be lower than the error rate related to crash data).  With respect to surface width, we suggest that the disagreeing records be dropped from the analysis since there is no good way to accurately link accidents with the appropriate surface width. 

Finally, while the basic Roadlog File described above does not contain data on horizontal or vertical alignment, we note that under a separate FHWA contract, alignment data were collected on a sample of approximately 700 miles of two-lane rural paved roads in Minnesota.  These data can be made available by the HSIS staff if needed in research projects.

Traffic Data

The Traffic File sent by MnDOT contains information related to AADT data for all roadway sections across the state.  For ease of analysis, HSIS programs link these data with the Roadlog file, producing an estimated AADT for each homogeneous section in that file.  Details of this linkage process are at the end of this section.

The traffic information is manually derived from sample and continuous counts taken at temporary and permanent count stations throughout the State.  It contains total AADT’s and AADT's for heavy commercial vehicles which are defined as vehicles with two axles and six tires or larger.

Like other states, Minnesota develops traffic volume estimates based on automatic traffic recorder stations (ATR’s) and short-term (48-hour) “coverage” counts.  There are approximately 120 ATR’s which count traffic 24 hours per day, 365 days per year across the various roadway types.  These are located on all classes of both rural and urban highway, with approximately 55% of the locations being on urban roadways and 45% on rural roadways.

In addition, there are approximately 34,000 coverage (temporary) count locations across the State where 48-hour counts are made.  Approximately 12,000 of these locations are covered each year.  For the trunk highway system (including Interstate roads), these counts are made on a two-year cycle, as are counts on roads within the Twin Cities Metro Area.  For the lower-order County State-Aid Highways and the Municipal State-Aid System outside the Twin Cities Metro Area, the counts are made on a four-year cycle.

The seasonal adjustment factor for a given coverage count is based on counts made at ATR’s which are similar to the coverage count location.  Here, ATR’s are grouped into the following classifications:

Outside (i.e., Non-Metropolitan area)

• Rural, farm to market roads
• Rural, weekend recreational road
• Rural, summer peak recreational road
• Municipal, non-recreational road, under 5000 population
• Municipal, non-recreational road, over 5000 population
• Municipal, recreational road, under 5000 population
• Municipal, recreational road, over 5000 population

Metropolitan Area

• High commuter route
• Commuter shopper route
• Low recreational route

Seasonal adjustment factors, based on the data for the previous three years, are developed for each classification and are applied to all coverage counts collected at locations within that classification.

For the "non-count" years, a growth factor is applied to the previous year's data based on changes in counts at the ATR stations located on the same functional class of roadway.  When new data are available at the end of the next count cycle, these data for the interim, non-count years are readjusted to represent the average of prior and subsequent count years (e.g., a 1987 "non-count" year estimate based on the growth factor would be readjusted to represent the average of 1986 and 1988 counts at that location as soon as the 1988 count year is completed).

In developing AADT estimates for each section of roadway, there are sometimes road sections with no historical count data (e.g., lower order local facilities including township roadways and local streets).  In these cases, an original “baseline” estimate is based on ATR counts on lowest order roadways with the lowest counted volumes.  Growth factors for these uncounted sections are also based on this same ATR group.

MnDOT also collects vehicle classification counts at about 300 sites per year.  These are 16-hour (e.g., 6 AM to 10 PM) manual classification counts usually over two different days.  In addition, portable vehicle classifiers are deployed to collect 48-hour data.  Currently, there is no program to seasonally adjust the classification counts.  There are an additional 25 Weigh-in-Motion stations statewide that collect classification data.  However, these data are used less than the manual classification counts. 

The new count data are placed in the Traffic file within the first six months of the subsequent calendar year.  While the Traffic File can also be thought of as a "section" file (with a specified AADT at the beginning count station being assumed constant over the entire section), it differs from the Roadlog File to which it will often be merged in that the beginning and end points (termini) are often located at different points on the roadway.  The linking variables are again the route system/route number/reference point (milepost). 

There are approximately 208,000 records on the file, but these do not represent a one-to-one match with the 220,000 "true" records on the Roadlog file.  Often there are Roadlog sections with multiple Traffic File records (i.e., multiple count stations), and often there are Roadlog sections with no Traffic File records (i.e., corresponding count stations) located within the section. 

Each raw file record contains up to 30 years of AADT information (with the related year "attached").  Thus, to determine the average AADT for a given year for a series of sections on a given route, (1) the traffic section reference points must be matched with the appropriate Roadlog sections by comparing the reference point with the beginning and ending milepoint on Roadlog sections (with the ending milepoint being "assigned" as being equal to the beginning milepoint on the succeeding section), (2) the appropriate yearly AADT for each contained Traffic file record must be extracted, and (3) the counts must be averaged for sections where multiple Traffic file records exist.  If no Traffic file record exists for a given Roadlog section, then the section AADT is assumed to be equal to the AADT at the previous (upstream) traffic section on the same route.  (This is the assumption made by Minnesota and by HSRC programs.  However, other procedures could be followed in calculating AADT if felt to be more appropriate for a given research question.)  Any AADT assignment program developed must not carry over counts from one route to another, a mistake that can easily be made since the Roadlog File is a continuous file in route order.  Obviously, averaging traffic over more than one year will require additional programming.

Currently, there are two HSIS SAS-formatted Traffic Files -- one developed for 1987 and earlier data, and one containing data for only 1988 and 1989.  Again, please note that traffic data were merged with the Roadlog File for years 1989, 1990-1992, 1994-1996, and 1998-2005.  The Traffic File still remains a separate file on the HSIS system for years 1987 thru 1989.  It is no longer available as a separate file on the HSIS system after 1989.

The first (1987) Traffic File is similar to the raw file in that it contains up to ten years of data with 1987 counts being the most recent data.  The second (1988-89) file contains only counts for 1988 and 1989.  Each record on the file contains information on traffic counts for one year for a given location.  To combine across years for a given counter location, records with the same location information can be merged.

As noted above, to make the AADT information even more easily usable in subsequent analyses, HSRC developed a linking program which links the basic AADT information from the SAS Traffic File with the Roadlog file to produce a separate single "Average AADT" variable for each Roadlog section on each Roadlog file.  Where necessary, averaging across traffic sections in a given Roadlog section for a given year, and "carrying down" AADT information from the prior record has been done in this linkage program.  The 1988-89 traffic data are linked with the 1989 Roadlog file for use with the 1988-89 accidents.  In this case, the AADT variable on the 1989 Roadlog file represents an average AADT over that two-year time period.  Different AADT's (say for individual accident years) could be developed by modifying the existing computer program.

Since it is not possible to perform an independent "check" of the accuracy of the AADT information, it is assumed that the procedure in place in Minnesota to monitor count stations and update the file provides adequate information.   As indicated above, these are felt to be excellent data for the trunkline system where they are updated on a two-year cycle.  There is also fairly good data for the county state-aid systems which are generally updated on a four-year cycle.

The Intersection/Interchange File

As noted above, the Interchange/Intersection File is a file of intersections on major roadways that are maintained by the eight different MnDOT Districts across the state.  The file will contain intersections of US/US, US/state, and all interchanges on the Interstate roadways.  The files currently available include years 1987 and individual files for years 1990-2005.  There are individual records in the file for approximately 2,500 interchanges, 26,600 intersections, and 3,900 intersections within interchanges.

Conversations with a limited sample of current district traffic engineers and a retired State Traffic Engineer who helped "design" the system indicate that while the criteria for choosing the "original" intersections may have differed slightly from district-to-district (since no criteria were actually defined), the overall purpose for building the file was to allow for subsequent identification of high-accident locations.  Thus, originally, all intersections which were to be examined for accident problems were included, which appears to mean all "major" intersections, regardless of past accident problems.  Once on the file, an intersection has remained so that its accident frequency and rate can be examined each subsequent year.  (Thus, "low accident sites" for a given year are not dropped from the file.)  In summary, while not a "random" sample of major intersections, the original (or subsequent) intersection choice does not seem to greatly bias the file for analysis purposes. 

There is no regular system of update, but changes are noted when they are found.  One district now seems to have well updated data while the other districts may or may not have data updated on a regular basis.  Using this file, accident rates for the intersections can be developed.  It is noted that the file is characterized by intersections of one roadway with all of the roads that cross it.  Since location information is present for all crossing routes, it is possible to link all routes with the Roadlog file information.

As noted above, there are approximately 2,500 interchange records within the file.  Each interchange will have a primary record, and for some interchange types (primarily diamond interchanges), there will be additional supplemental records on each “intersection within interchange.”  There are approximately 3,900 of these supplemental records in the file. These supplemental records will also contain additional information the type of interchange element (e.g., mainline between ramps, exit ramp, intersection at ramp terminal on crossing roadway, etc.)  More detail on the coding is provided under ELEM_NBR in the later format section.

Each SAS intersection record in the HSIS file contains three different types of "subrecords":  (1) a set of "general" variables describing the entire intersection (e.g., intersection type), (2) a set of "reference" variables for each of six possible incoming routes, referred to as "segment" variables, and (3) a set of variables for up to two "legs" (or approaches) per route (e.g. approach AADT, speed limit).

Because of the complexity of the file, there will be times when the analyst wishes to look at routes rather than on individual intersection “legs.” For this reason, HSIS staffs have developed programs which will produce a modified file named the Intersection Route File.  This file consists of a record for each route of the intersecting routes of an intersection. Many of the variables are still the same as in the basic Intersection File.  The major difference in this file is that the variables represent descriptions for each route.  The "In" and "Out" descriptors denote the incoming and outgoing routes of each leg.  This file format can be produced for the user by HSIS staff on request.

The completeness and accuracy of the data in these files were again assessed through the above-noted conversations with Minnesota system designers and users, examination of single-variable tabulations for key variables, HSIS analyses, and limited cross-checking of data in the files versus videologs of intersections found in the Minnesota videodisk system.    

Examination of the single-variable tables indicates that while there is a higher proportion of uncoded data than in other major files, adequate coding exists for most variables.  It is noted that there is a significant amount of missing AADT data (10 to 30 percent) in the "segment 2, leg 2" records -- records usually related to the second (opposing) approach of the minor crossing roadway.  AADT's are usually present for both legs of the major roadway and for the first leg of the minor roadway.  One solution that has been used thus far is to assume that the missing leg 2 AADT is equal to the leg 1 AADT on the same route. 

More importantly, we have determined from analyses and conversations with MnDOT staff that the majority of the AADT data in the Intersection/Interchange file are not current -- they do not match the year of the file.  The user can determine which year the AADT was collected for each leg from the "AADT Year" variable attached to each leg.  However, we have found that the "AADT Year" will very seldom be the current (file) year, and that the year of the AADT count can be different for different legs of the same intersection. For major routes, more recent AADT information can be extracted from the Roadlog File by linking the intersection leg with the appropriate roadway segment in that file. Unfortunately, we cannot suggest a method for "updating" the AADT data to later years for crossing roadways not found on the Roadlog file.  Since multiple year data are often shown in the file, the user may be able to develop a "trend-related update", but we cannot assure that the estimates will be correct. 

With this AADT exception, the file is complete in that there are few true "missing" or miscoded values.  Other variables seem to be updated in a more timely manner. There is large number of "not applicable" codes within many of the variable, but this appears to result from the fact that some of the variables are specific to special types of intersections (e.g., intersections within interchanges, signalized intersections, and pedestrian crossings).  

The preliminary HSIS analyses have indicated some additional problems with a limited number of variables.  As with all files, incomplete coding or apparent inaccuracies are detailed in a “NOTE” under the pertinent variable in the later SAS format section.

In a final check of accuracy, the descriptive variables for a significant sample of the intersections on the file were manually compared to a videotaped picture of the intersection.  The picture was located in the Minnesota videodisk system which covers all major Minnesota routes, and which is available at FHWA for research efforts.  In general, it was found that the data on the Intersection File are accurate and reliable for interchanges, signalized intersections, and major unsignalized intersections (e.g., unsignalized intersections with turn lanes on major routes).  The comparison pointed out that there are cases in which more than one intersection is located on the File at the same milepoint.  The videolog indicated that this usually happens when there are intersections within an interchange, as would be the case with diamond interchanges.  This situation can be detected using the TYPE variable. 

In general, while not perfect, the Intersection/Interchange File is clearly adequate for analysis purposes.  The only major problem is with the timeliness of the AADT data.

Issues Related to Merging Files

According to MnDOT, HSRC was to receive "linkable" accident data.  This was true almost all of the time.  However, during later merging efforts by HSRC programmers, it was discovered that some route numbers on the accident file did not exist on the Roadlog file.  MnDOT confirmed that they had only recently discovered the problem and that it was unlikely that they would be able to restore the correct location of those accidents.  This problem represented less than 1% of the total accident file.  Minnesota indicated that the "bad" accident routes were likely to have route numbers with the last three or four digits repeating (i.e., 190008888).  HSRC runs confirmed this in many, but not all, cases. 

As noted above, the accident data are subdivided into three subfiles -- accident, vehicle and occupant.  These subfiles can be linked together using the "case number" variable (i.e., CASENO) present in each of the three files.  When linking the occupant subfile, the additional linking variable "vehicle number" (i.e., VEHNO) must match so that the occupants are associated with the vehicle in which they were traveling.  To link the Vehicle subfile with the Accident alone, first sort both subfiles by case number.  To link the Occupant file with the other two subfiles, first sort both the Vehicle subfile and Occupant subfile by case number and vehicle number. Next sort the Accident subfile by case number.  Alternatively, the separate subfiles can blinked by specifying an SQL JOIN operation with the constraining condition that case number and vehicle number from each table are equal.  SQL processing does not require the data to be presorted and the output will not be in any particular sort order unless ORDER BY is specified.

The Accident subfile can then be linked with the Roadlog File using information related to route system, route number, and milepost on the route.  The actual linkage variables on the Accident file which are used in the merging operation are RTSYSNBR (a combination of route system and route number) and MILEPOST.  The linkage variables on the Roadlog File are BEGMP, ENDMP, and RTSYSNBR.

To prepare the Accident subfile for linking with the Roadlog File using a SAS data step process, the analyst must sort both the Accident and the Roadway File into location order by RTSYSNBR and MILEPOST on the Accident file and by RTSYSNBR and BEGMP on the Roadlog File.  Similar sorts would be done with other files to be merged.  For the alternative SQL join, the analyst must specify an exact match on RTSYSNBR from both files and a range match where MILEPOST occurs between BEGMP and ENDMP

To link the Accident File with the Intersection/Interchange File requires similar logic, but somewhat more file manipulation.  Again, the basic linkage variables are route system, route number, and milepost.

For the primary route within the Intersection/Interchange File (i.e., the initial reference route identified in the “general” variables), route system, and route number have already been combined into INT_SYNB and reference point information has been converted to MILEPOST.  Thus, the linkage is similar to the Roadlog file linkage.   However, matching crashes (or Roadlog information) to the individual Asegment@ variables which define all possible crossing routes is somewhat more complex.  Here, the Intersection File does not contain the combined route/system variable (INT_SYNB), so the two individual variables (RTE_SYS, RTE_NBR) must be combined before matching.  In addition, the milepost variables must be derived from the “Reference Point” variable (REF_PNT).  The REF_PNT variable consists of 10 bytes (i.e., 050+00.900).  The first three bytes is the "reference post" and the last three bytes is the offset from the reference post.  To develop the milepost variable, bytes 5-6 will need to be removed (i.e., 50.900). Once these new variables are formed, the same linking logic described above can be used.  Note that programs to carry out these conversions and file linkages have been developed by HSIS staff and can be obtained from the staff when needed.

Finally, where appropriate and possible, a format which defines categories within a given variable has been developed for HSIS SAS variables.  These categories are shown in the pages below.  If you are a SAS user and wish to receive a formatting program which includes these SAS formats (with linkage to the pertinent variable name), please request these from the HSIS staff who provides the data file to you. 

MINNESOTA CONTACTS

Dave Engstrom (651-234-7016) – Mr. Engstrom is our main contact within the state of Minnesota when questions arise concerning the crash, intersection, and videolog data in the Transportation Information System (TIS).  He is the Traffic Safety Engineer for the Minnesota DOT.

Matt Koukol (651-366-3859) – Mr. Koukol is the primary contact within Minnesota DOT regarding the traffic and roadway data, as well as data acquisition.

COMPOSITE LIST OF VARIABLES

Accident File

LIST OF VARIABLES FOR THE MINNESOTA ACCIDENT SUBFILE

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE MINNESOTA STATE ACCIDENT SUBFILE

NOTE: SAS variable names and longer explanatory names are shown above each listing. (See Discussion for in formation on SAS formats.)

ACC_DATE

DATE ACCIDENT OCCURRED 

NON-LABELED VARIABLE

NOTE: YYYYMMDD = Year-Month-Day accident occurred.

ACCDIGM

DIAGRAM OF ACCIDENT CODE

• 00 = 'OFFICER LEFT FIELD BLANK'
• 01 = 'REAR END'                   
• 02 = 'SIDESWIPE -- PASSNG'        
• 03 = 'LEFT TURN'                  
• 04 = 'RAN OFF ROAD LEFT SIDE'
• 05 = 'RIGHT ANGLE'                
• 06 = 'RIGHT TURN'                 
• 07 = 'RAN OFF ROAD RIGHT SIDE'
• 08 = 'HEAD ON'                    
• 09 = 'SIDESWIPE -- OPPOSING'      
• 10 = 'OTHER/UNKNOWN'              
• 98 = 'NOT STATED/NOT APPLICABLE'  
• 99 = 'UNKNOWN'                    
• OTHER = 'ERROR/OTHER CODE'

NOTE: See discussion.  This variable does not indicate "what" is struck, only "how" something is struck.  In addition, the "head-on" and "sideswipe opposing" codes reflect the direction of the opposing vehicles immediately prior to impact rather than their initial direction. 

ACCTYPE

TYPE OF ACCIDENT

• 01    = 'COLLISION WITH MOTOR VEHICLE IN TRANSPORT'
• 02    = 'COLLISION WITH PARKED MOTOR VEHICLE'
• 03    = 'COLLISION WITH ROADWAY EQUIPMENT--SNOWPLOW'
• 04    = 'COLLISION WITH ROADWAY EQUIPMENT--OTHER'
• 05    = 'COLLISION WITH TRAIN'
• 06    = 'COLLISION WITH PEDALCYCLE'
• 07    = 'COLLISION WITH PEDESTRIAN'
• 08    = 'COLLISION WITH DEER'
• 09    = 'COLLISION WITH OTHER ANIMAL'
• 10    = 'COLLISION -- UNDERRIDE, REAR'
• 11    = 'COLLISION -- UNDERRIDE, SIDE'
• 12    = 'COLLISION WITH NON-FIXED OBJECT OF OTHER TYPE'
• 13    = 'OTHER TYPE OF COLLISION'
• 14    = 'COLLISION WITH NON-FIXED OBJECT OF UNKNOWN TYPE'
• 21    = 'COLLISION WITH CONSTRUCTION EQUIPMENT'
• 22    = 'COLLISION WITH TRAFFIC SIGNAL'
• 23    = 'COLLISION WITH RR CROSSING DEVICE'
• 24    = 'COLLISION WITH LIGHT POLE'
• 25    = 'COLLISION WITH UTILITY POLE'
• 26    = 'COLLISION WITH SIGN STRUCTURE OR POST'
• 27    = 'COLLISION WITH MAILBOXES AND/OR POSTS'
• 28    = 'COLLISION WITH OTHER POLES'
• 29    = 'COLLISION WITH HYDRANT'
• 30    = 'COLLISION WITH TREE/SHRUBBERY'
• 31    = 'COLLISION WITH BRIDGE PIERS'
• 32    = 'COLLISION WITH MEDIAN SAFETY BARRIER'
• 33    = 'COLLISION WITH CRASH CUSHION'
• 34    = 'COLLISION WITH GUARDRAIL'
• 35    = 'COLLISION WITH FENCE (NON-MEDIAN BARRIER)'
• 36    = 'COLLISION WITH CULVERT / HEADWALL'
• 37    = 'COLLISION WITH EMBANKMENT / DITCH / CURB'
• 38    = 'COLLISION WITH BUILDING / WALL'
• 39    = 'COLLISION WITH ROCK OUTCROPS'
• 40    = 'COLLISION WITH PARKING METER'
• 41    = 'COLLISION WITH OTHER FIXED OBJECT'
• 42    = 'COLLISION WITH UNKNOWN TYPE OF FIXED OBJECT'
• 51    = 'OVERTURN / ROLLOVER'
• 52    = 'SUBMERSION'
• 53    = 'FIRE / EXPLOSION'
• 54    = 'JACKKNIFE'
• 55    = 'LOSS/SPILLAGE NON-HAZ MAT'
• 56    = 'LOSS/SPILLAGE HAZARDOUS MAT'
• 64    = 'NON-COLLISION OF OTHER TYPE'
• 65    = 'NON-COLLISION OF UNKNOWN TYPE'
• 66    = 'COLL FIXOBJ'             
• 67    = 'FALLING OBJECT'          
• 90    = 'OTHER TYPE OF ACCIDENT'  
• 99    = 'ACCIDENT OF UNKNOWN ACCIDENT TYPE'
• OTHER = 'ERROR/OTHER CODE'

ACCYR

YEAR ACCIDENT OCCURRED

NON-LABELED VARIABLE

NOTE: 'YYYY' = Year of accident. Variable discontinued in 2000.

AMBL_NBR

AMBULANCE NUMBER

NON-LABELED VARIABLE -- Ambulance number

NOTE: Variable added in 1991.

CASENO

ACCIDENT NUMBER

NON-LABELED VARIABLE

NOTE: 'YYYYDDDNNNN' where YYYY = Year, DDD = Julian day of year, and NNNN = Unique case number (0000-9999).

COUNTY

COUNTY

NON-LABELED VARIABLE

NOTE: 01-87 = County number

DIV_CODE

ROAD DESIGN

• 00 = 'NOT SPECIFIED'
• 01 = 'FREEWAY--MAINLINE'
• 02 = 'FREEWAY--RAMPS'             
• 03 = 'OTHER DIVIDED HIGHWAY'
• 04 = 'ONE-WAY STREET'
• 05 = '4-6 LANES UNDIVIDED (2 TO 3 LANES EACH WAY)'
• 06 = '3 LANES UNDIVIDED'
• 07 = '5 LANES UNDIVIDED (CENTER LEFT TURN LANE)'
• 08 = '2 LANES--1 EACH WAY'
• 09 = 'ALLEY / DRIVEWAY'
• 10 = 'ROAD ON PRIVATE PROPERTY'
• 90 = 'OTHER'
• 98 = 'NOT STATED'                 
• 99 = 'UNKNOWN'

HAZMAT

HAZARDOUS MATERIAL CARRIED

• 'Y'   = 'YES'
• 'N'   = 'NO'
• OTHER = 'ERROR/OTHER CODE'

NOTE: Variable discontinued in 1990.

HIT_RUN

HIT AND RUN

• 'N' = 'NO'                        
• 'Y' = 'YES'                       
• OTHER ='ERROR/OTHER CODE'

NOTE:  Variable added in 1990.

HOUR

HOUR ACCIDENT OCCURRED

NON-LABELED VARIABLE

NOTE: 'HHMM' = Hour and minute that accident occurred ('0000'-'0059'='12 AM - 1259 AM',… '9800'='LEFT BLANK', '9900'='UNKNOWN').

Values before 2003 are rounded to the nearest hour.

INTERCH

INTERCHANGE ELEMENT CODE

NON-LABELED VARIABLE

NOTE: This is a three-character variable giving the code for a certain intersection element where the crash occurred.  The coding is either 'ANN' or 'NNN', where "A" is alphabet and "N" is numeric.  Three blanks indicate "not in an interchange".  Unfortunately, no other detail on the element descriptors is available.

LIGHT

LIGHT CONDITIONS

• 01 = 'DAYLIGHT'                   
• 02 = 'DAWN'                       
• 03 = 'DUST'                       
• 04 = 'DARK STREET LIGHTS ON'
• 05 = 'DARK STREET LIGHTS OFF'
• 06 = 'DARK NO STREET LIGHTS'
• 07 = 'DARK UNKNOWN LIGHTING'
• 90 = 'OTHER'
• 98 = 'NOT STATED'
• 99 = 'UNKNOWN'
• OTHER = 'ERROR/OTHER CODE'

LOC_BIKE

LOCATION OF PEDESTRIAN/BIKE ACCIDENT

• 0     = 'NOT STATED'
• 1     = 'SCH CROSS'
• 2     = 'INTERSECT'
• 3     = 'NOT INTERSEC'
• 4     = 'UNKNOWN'
• 5     = 'NOT BIKE/PED'
• OTHER = 'ERROR/OTHER CODE'

NOTE: Variable discontinued in 1989.

LOC_HARM

LOCATION OF FIRST HARMFUL EVENT

• 00 = 'NOT SPECIFIED'              
• 01 = 'ON THE ROADWAY (ALLEY, DRIVEWAY, ETC)'
• 02 = 'OFF THE ROADWAY ON THE SHOULDER'
• 03 = 'OFF THE ROADWAY ON THE MEDIAN'
• 04 = 'OFF THE ROADWAY ON THE ROADSIDE'
• 05 = 'OFF THE ROADWAY ON THE SEPARATOR'
• 06 = 'PARKING LOT'
• 07 = 'PRIVATE PROPERTY'
• 08 = 'OUTSIDE RIGHT-OF-WAY'
• 90 = 'OTHER'
• 99 = 'UNKNOWN'

LOC_NARR

LOCATION DESCRIPTION

NON-LABELED VARIABLE

NOTE:  Variable added in 1990.

LOC_TYPE

RELATION TO INTERSECTION

• 00    = 'NOT SPECIFIED'
• 01    = 'NOT AT INTERSECTION OR JUNCTION'
• 02    = 'T-INTERSECTION'          
• 03    = 'Y-INTERSECTION'
• 04    = '4-LEGGED INTERSECTION'
• 05    = '5-OR-MORE-LEGGED INTERSECTION'
• 06    = 'TRAFFIC CIRCLE OR ROUNDABOUT'
• 07    = 'INTERSECTION-RELATED'
• 08    = 'AT ALLEY OR DRIVEWAY ACCESS'
• 09    = 'AT SCHOOL CROSSING'
• 10    = 'AT RAILROAD CROSSING'
• 11    = 'AT RECREATIONAL TRAIL CROSSING'
• 20    = 'INTERCHANGE -- ON RAMP'
• 21    = 'INTERCHANGE -- OFF RAMP'
• 22    = 'INTERCHANGE -- OTHER AREA'
• 23    = 'INTERCHANGE AREA'
• 24    = 'INTERSECTION'
• 25    = 'NON JUNCTION'
• 90    = 'OTHER'
• 99    = 'OFFICER REPORTED THAT INTREL WAS UNKNOWN'
• OTHER = 'ERROR/OTHER CODE'

LOC_WRK_ZNE

LOCATION OF ACC IN WORKZONE

• '00' = 'NOT SPECIFIED'
• '01' = 'BEFORE 1ST WARNING SIGN'
• '02' = 'ADVANCE WARNING SIGN'
• '03' = 'TRANSITION AREA'
• '04' = 'ACTIVITY AREA'
• '05' = 'TERMINATION AREA'
• '90' = 'OTHER'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'

NOTE: Variable added in 2003.

LOCN_REL

LOCATION RELIABILITY

• '1' = 'NO LOCATION ERROR EXPECTED'
• '2' = 'POSSIBLE LOCATION ERROR'   
• '3' = 'PROBABLE LOCATION ERROR (OR NO-GEOCODED)'
• OTHER = 'ERROR/OTHER CODE'

NOTE:  Variable added in 1990.

MILEPOST

MODIFIED REFERENCE POINT

NON-LABELED VARIABLE

NOTE: This is a reformatted version of the original "Reference Point" variable in the MN files. The reformatting was done to facilitate computer linkage with other files.

NUMVEHS

NUMBER OF VEHICLES INVOLVED

NON-LABELED VARIABLE

OBJECT1

FIXED OBJECT STRUCK

• 00 = 'NO OBJECT STRUCK'           
• 01 = 'CONSTRUCTION BARRICADES/EQUIPMENT'
• 02 = 'TRAFFIC SIGNAL'             
• 03 = 'RAILROAD CROSSING DEVICE'   
• 04 = 'LIGHT POLE'                 
• 05 = 'UTILITY POLE'               
• 06 = 'SIGN STRUCTURE OR POST'     
• 07 = 'MAILBOX'                    
• 08 = 'OTHER POLE, POSTS OR SUPPORTS'
• 09 = 'FIRE HYDRANT OR PARKING METER'
• 10 = 'TREE OR SHRUBBERY'          
• 11 = 'CRASH CUSHION'              
• 12 = 'MEDIAN SAFETY BARRIER'      
• 13 = 'BRIDGE PIERS (INCLUDES PROTECTION GUARDRAIL)'
• 14 = 'OTHER GUARDRAIL'            
• 15 = 'FENCING NOT MEDIAN BARRIER' 
• 16 = 'CULVERT OR HEADWALL'        
• 17 = 'EMBANKMENT, DITCH OR CURB'  
• 18 = 'BUILDING OR WALL'           
• 19 = 'ROCK OUTCROPS'              
• 20 = 'UNKNOWN'                    
• 21 = 'NOT APPLICABLE'             
• 22 = 'PARKING METER'              
• 90 = 'OTHER FIX OBJ'              
• OTHER = 'ERROR/OTHER CODE'

NOTE: (1) Code '00' (No object stuck) and code '21' (Not applicable) are equivalent.

(2) In the 1991 data, the number and percent of "NO OBJECT STRUCK" was significantly lower and the number/percent of "UNKNOWN" significantly higher than in other years. The percent of "UNKNOWN" remains slightly higher (i.e., 4 percent) in later years.

(3) See ACCTYPE (Accident Subfile) and EVENT (Vehicle Subfile).

(4) Variable discontinued in 2000.

OFF_TYPE

TYPE OF INVESTIGATING OFFICER

• 0 = 'NOT SPECIFIED'               
• 1 = 'MN STATE PATROL'                                         
• 2 = 'COUNTY SHERIFF'              
• 3 = 'LOCAL (CITY POLICE)'         
• 4 = 'OTHER INVEST OFFICER'
• 90 = 'OTHER OFFICER TYPE'
• 98 = 'NOT APPLICABLE'
• 99 = 'UNKNOWN'

NOTE: Records coded as OFF_TYPE = "UNKNOWN" have been removed in 1991 and later years to improve quality of data. See Discussion.

ON_BRDG

ACCIDENT OCCURRED ON BRIDGE

• 'Y' = 'YES'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Z' = 'NOT SPECIFIED' 

NOTE: Preliminary analyses have shown this variable to be inaccurate. It appears that uncoded cases default to "NO."  In addition, note that in bridge analyses based on matching accident and bridge locations, interchange ramp accidents are located to the center of the interchange, which may be a bridge.  This will erroneously increase the number of "bridge accidents" unless accounted for.

POP_FROM_CITY

POPULATION OF CITY

NON-LABELED VARIABLE

NOTE: Variable added in 2003.

POP_FROM_COUNTY

POPULATION OF COUNTY

NON-LABELED VARIABLE

NOTE: Variable added in 2003.

POP_GRP

URBAN/RURAL POPULATION CODES

• 0 = 'UNKNOWN'                     
• 1 = 'URBAN 250000-AND OVER'       
• 2 = 'URBAN 100,000-249,999'
• 3 = 'URBAN 50,000-99,999'
• 4 = 'URBAN 25,000-49,999'
• 5 = 'URBAN 10,000-24,999'
• 6 = 'URBAN 5,000-9,999'
• 7 = 'RURAL 2,500-4,999'
• 8 = 'RURAL 1,000-2,499'
• 9 = 'RURAL 1-999 OR NON-MUNICIPAL'

PUBDMG

PUBLIC PROPERTY DAMAGE

• 'Y' = 'YES'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Z' = 'NOT SPECIFIED'

NOTE:  Variable added in 1991.

RD_CHAR1

ROAD CHARACTERISTICS

• 1 = 'STRAIGHT AND LEVEL'
• 2 = 'STRAIGHT AND GRADE'
• 3 = 'STRAIGHT AND HILLCREST'
• 4 = 'STRAIGHT IN SAG'
• 5 = 'CURVE AND LEVEL'
• 6 = 'CURVE AND GRADE'
• 7 = 'CURVE AT HILLCREST'
• 8 = 'CURVE IN SAG'
• 9 = 'UNKNOWN NOT STATED'
• 90 = 'OTHER (INCLUDES COMBINATION)'
• 99 = 'UNKNOWN'                    
• OTHER = 'ERROR/OTHER CODE'

RDSURF

ROAD SURFACE CONDITIONS

• 00 = 'NOT SPECIFIED'              
• 01 = 'DRY'
• 02 = 'WET'
• 03 = 'SNOW'
• 04 = 'SLUSH'
• 05 = 'ICE / PACKED SNOW'
• 06 = 'WATER (STANDING, MOVING)'
• 07 = 'MUDDY'
• 08 = 'DEBRIS'
• 09 = 'OILY'
• 10 = 'SNOW/SLUSH'                 
• 90 = 'OTHER'
• 99 = 'UNKNOWN'

RDWORK

ROAD WORK BEING PERFORMED

• 01 = 'NONE'                       
• 02 = 'MARKED CONSTRUCTION ZONE'
• 03 = 'MARKED MAINTENANCE ZONE'
• 04 = 'MARKED UTILITY WORK ZONE'
• 05 = 'UNMARKED CONSTRUCTION ZONE'
• 06 = 'UNMARKED MAINTENANCE ZONE'
• 07 = 'UNMARKED UTILITY WORK ZONE'
• 90 = 'OTHER'
• 99 = 'UNKNOWN'

NOTE: Variable discontinued in 2003.

RODWYCLS

ROADWAY CLASSIFICATION

• '01' = 'URBAN FREEWAY >= 4 LANES' 
• '02' = 'URBAN FREEWAY < 4 LANES'  
• '03' = 'URBAN 2-LANE ROADS'       
• '04' = 'URBAN MULTILANE DIVIDED NON-FREEWAY'
• '05' = 'URBAN MULTILANE UNDIVIDED NON-FREEWAY'  
• '06' = 'RURAL FREEWAY >= 4 LANES' 
• '07' = 'RURAL FREEWAY < 4 LANES'  
• '08' = 'RURAL 2-LANE ROADS'       
• '09' = 'RURAL MULTILANE DIVIDED NON-FREEWAY'
• '10' = 'RURAL MULTILANE UNDIVIDED NON-FREEWAY'
• '99' = 'OTHERS'                   

NOTE:  Created variable added to HSIS accident and roadway inventory files in all states in 1999.  See Discussion.

RTE_NBR

ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: 'NNNNNNNNX' = ROUTE NUMBER (N=0-9, and X is numeric, alpha, or blank.  Note that in a few cases with county/township roads, an alpha character will appear in other columns.) This variable is used for file linkage. See RTSYSNBR.

RTE_SYS

ROUTE SYSTEM 

• '01' = 'INTERSTATE--ISTH'         
• '02' = 'US TRUNK HIGHWAY--USTH'
• '03' = 'MN TRUNK HWY--MNTH'
• '04' = 'COUNTY STATE AID HIGHWAY--CSAH'
• '05' = 'MUNICIPAL STATE AID HIGHWAY--MSAH'
• '07' = 'COUNTY ROAD--CNTY'
• '08' = 'TOWNSHIP ROAD--TWNS'
• '09' = 'UNORGANIZED TOWNSHIP ROAD--UTWN'
• '10' = 'MUNICIPAL STREET--MUN'
• '11' = 'NATIONAL PARK ROAD--NATP'
• '12' = 'NATIONAL FOREST ROAD--NATF'
• '13' = 'INDIAN SERVICE ROAD--IND'
• '14' = 'STATE FOREST ROAD--SFR'
• '15' = 'STATE PARK ROAD--SPRK'
• '16' = 'MILITARY ROAD--MIL'
• '17' = 'NATIONAL MONUMENT ROAD--NATM'
• '18' = 'NATIONAL WILDLIFE REFUGE ROAD--NATW'
• '19' = 'FRONTAGE ROAD--FRNT'
• '20' = 'STATE GAME RESERVE ROAD--SGAM'
• '21' = 'PRIVATE ROAD OPEN TO PUBLIC'
• '23' = 'AIRPORT ROADS'                                    
• '25' = 'NON-TRAFFIC WAYS'
• '30' = 'ALLEYWAYS'
• '98' = 'NOT GEOCODED'

NOTE: See RTSYSNBR.

RTSYSNBR

COMBINED ROUTE SYSTEM/ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: This is a combined version of the RTE_NBR and RTE_SYS variables above.  This combining was done to facilitate computer linkage with other files.

SCHLBUS

SCHOOL BUS INVOLVED ACCIDENT

• '00'   = 'NOT SPECIFIED'                                      
• '01'   = 'YES, INVOLVED DIRECTLY'                             
• '02'   = 'YES, INVOLVED INDIRECTLY'                           
• '03'   = 'NO'                                                 
• '99'   = 'UNKNOWN'                                            
• OTHER = 'ERROR/OTHER CODE'

NOTE: Variable added in 2000. Valid data are not available before 2003.

SEVERITY

ACCIDENT SEVERITY

• ' ' = 'NOT APPLICABLE'
• 'K' = 'FATAL'
• 'A' = 'INCAPACITATING INJURY'
• 'B' = 'NON-INCAPACITATING INJURY'
• 'C' = 'POSSIBLE INJURY'
• 'D', 'X' = 'INJURY UNKNOWN'
• 'P', 'N' = 'PROPERTY DAMAGE'

SPEED

POSTED SPEED LIMIT

NON-LABELED VARIABLE

NOTE: Posted speed limit in miles per hour. '00','99' = 'SPEED LIMIT UNKNOWN'.                                  

TOT_INJ

NUMBER OF PERSONS INJURED

NON-LABELED VARIABLE

TOT_KILL

NUMBER OF PERSONS KILLED

NON-LABELED VARIABLE

TRF_CNTL

TRAFFIC CONTROL DEVICES

• 00 = 'NOT SPECIFIED'              
• 01 = 'TRAFFIC SIGNALS'
• 02 = 'OVERHEAD FLASHERS'
• 03 = 'STOP SIGN - ALL APPROACHES'
• 04 = 'STOP SIGN - OTHER'
• 05 = 'YIELD SIGN'
• 06 = 'OFFICER, FLAGMAN, OR SCHOOL PATROL'
• 07 = 'SCHOOL BUS STOP ARM'
• 08 = 'SCHOOL ZONE SIGN'
• 09 = 'NO PASSING ZONE'
• 10 = 'RAILROAD CROSSING - GATES'
• 11 = 'RAILROAD CROSSING - FLASHING LIGHTS'
• 12 = 'RAILROAD CROSSING - STOP SIGNS'
• 13 = 'RAILROAD CROSSING - OVERHEAD FLASHERS'
• 14 = 'RAILROAD CROSSING - OVERHEAD FLASHERS AND GATES'
• 15 = 'RAILROAD CROSSING - CROSSBUCK'
• 16 = 'RR CROS OTHER'
• 90 = 'OTHER'
• 98 = 'NOT APPLICABLE'
• 99 = 'UNKNOWN'

TRFCNTLW

TRAFFIC CONTROL WORKING

• 00    = 'NOT SPECIFIED'
• 01    = 'SIGNAL WORKING PROPERLY' 
• 02    = 'SIGNAL NOT WORKING PROPERLY'
• 03    = 'SIGNAL WORKING MODIFIED (FLASHING)'                  
• 04    = 'SIGNAL OBSCURED OR DAMAGED'
• 90    = 'OTHER'                                               
• 98    = 'NOT APPLICABLE'                                      
• 99    = 'UNKNOWN'                                             
• OTHER = 'ERROR/OTHER CODE'

TRVL_DIR

TRAVEL DIRECTION

• 'E'   = 'EAST'
• 'N'   = 'NORTH'
• 'S'   = 'SOUTH'
• 'W'   = 'WEST'
• 'Z'   = 'NOT SPECIFIED'
• OTHER = 'ERROR/OTHER CODE

NOTE: Variable added in 2003.

TWNSHIP

TOWNSHIP NUMBER

NON-LABELED VARIABLE

NOTE: 000 = Unknown, 001-999 = Township number.

VEH_MOV1

VEHICLE MOVEMENT

• 01    = 'ENTER AT ANG'
• 02    = 'SAME DIREC STR'
• 03    = 'SIDESWP PASSING'
• 04    = 'ONE TURN ONE STR'
• 05    = 'ONE STOPPED'
• 06    = 'SAME DIREC OTHER'
• 07    = 'HEAD ON AT INTEC'
• 08    = 'SIDESWIP MEETIN'
• 09    = 'OPPOSITE DIR'
• 10    = 'OPPOSITE OTHER'
• 11    = 'BACKED INTO'
• 12    = 'N/S 2 VEH INTESC'
• 21    = 'HEAD ON NOT INTS'
• 22    = 'SME DIR NOT INTS'
• 23    = 'SDSWP PAS NO INT'
• 24    = 'ONE PRK NOT INTS'
• 25    = 'ONE STP IN TRF'
• 26    = 'ONE ENTR PRK POS'
• 27    = 'ONE LEAV PRK POS'
• 28    = 'ONE ENTR DRVWY'
• 29    = 'ONE LEAV DRVWY'
• 30    = 'BACKED INTO'
• 31    = 'OTHER'
• 32    = 'NOT STATED'
• 41    = 'PED VEH STRGHT'
• 42    = 'PED VEH TRN LEFT'
• 43    = 'PED VEH TRN RGHT'
• 44    = 'PED VEH BACKING'
• 45    = 'PED - OTHER'
• 46    = 'PED NOT STATED'
• 51    = 'INTER RR OR VEH'
• 52    = 'INTER FIX OBJ'
• 53    = 'INTER OBJ OR ANI'
• 54    = 'INTER OVERTURN'
• 55    = 'INTER OTH NONCOL'
• 56    = 'NOT INT RR/VEH'
• 57    = 'NOT INT FIX OBJ'
• 58    = 'NOT INT OBJ/ANI'
• 59    = 'NOT INT OVERTN'
• 60    = 'NOT INT NONCOLL'
• 99    = 'NOT STATED'
• OTHER = 'ERROR/OTHER CODE'

NOTE: Variable discontinued in 1990.

WAST_MAT

WASTE MATERIAL CARRIED

• 'Y'   = 'YES'
• 'N'   = 'NO'
• OTHER = 'ERROR/OTHER CODE'

NOTE: Variable discontinued in 1990.

WEATHER

WEATHER CONDITIONS

WEATHER1

WEATHER CONDITIONS

WEATHER2

WEATHER CONDITIONS

• 01 = 'CLEAR'
• 02 = 'CLOUDY'
• 03 = 'RAIN'
• 04 = 'SNOW'
• 05 = 'SLEET, HAIL OR FREEZING RAIN'
• 06 = 'FOG, SMOG OR DUST'          
• 07 = 'BLOWING SAND, DUST OR SNOW' 
• 08 = 'SEVERE CROSS WINDS'         
• 90 = 'OTHER'                      
• 98 = 'NOT STATED'                 
• 99 = 'UNKNOWN'                    

NOTE: The variable WEATHER was replaced by WEATHER1 and WEATHER2 in 2003.

WEEKDAY

DAY OF WEEK ACCIDENT OCCURRED

• 1 = 'SUNDAY'
• 2 = 'MONDAY'
• 3 = 'TUESDAY'
• 4 = 'WEDNESDAY'
• 5 = 'THURSDAY'
• 6 = 'FRIDAY'
• 7 = 'SATURDAY'     
• OTHER = 'ERROR/OTHER CODE'

WORK_ZONE

WORKZONE MARKED

• '00' = 'NOT SPECIFIED'
• '01' = 'LANE CLOSURE'
• '02' = 'LANE SHIFT/CROSSOVER'
• '03' = 'WORK ON SHOULDER OR MEDIAN'
• '04' = 'INTERMITTENT OR MOVING WORKZONE'
• '90' = 'OTHER'
• '98' = 'NO OR NOT APPLICABLE'
• '99' = 'UNKNOWN'

NOTE: Variable added in 2003.

WRKS_PRESNT

WORKER PRESENT

• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'YES'
• 'Z' = 'NOT SPECIFIED'

NOTE: Variable added in 2003.

LIST OF VARIABLES FOR THE MINNESOTA VEHICLE SUBFILE

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE MINNESOTA STATE VEHICLE SUBFILE

NOTE:  SAS variable names and longer explanatory names are shown above each listing. (See Discussion for information on SAS formats.)

CASENO

ACCIDENT NUMBER

NON-LABELED VARIABLE

NOTE: 'YYYYDDDNNNN' where YYYY = Year, DDD = Julian day of year,

NNNN = Unique case number (0000-9999).

CONTRIB1

FIRST CONTRIBUTING FACTOR

CONTRIB2

SECOND CONTRIBUTING FACTOR

• 00 = 'NOT SPECIFIED'
• 01 = 'NO CLEAR CONTRIBUTING FACTOR'
• 02 = 'FAILURE TO YIELD RIGHT OF WAY'
• 03 = 'ILLEGAL OR UNSAFE SPEED'
• 04 = 'FOLLOWING TOO CLOSELY'
• 05 = 'DISREGARD TRAFFIC CONTROL DEVICE'
• 06 = 'DRIVING LEFT OF ROADWAY CENTER - NOT PASSING'
• 07 = 'IMPROPER PASSING OR OVERTAKING'
• 08 = 'IMPROPER OR UNSAFE LANE USE'
• 09 = 'IMPROPER PARKING, STARTING, OR STOPPING'
• 10 = 'IMPROPER TURN'
• 11 = 'UNSAFE BACKING'
• 12 = 'NO SIGNAL OR IMPROPER SIGNAL'
• 13 = 'OVER-CORRECTING'
• 14 = 'IMPEDING TRAFFIC'
• 15 = 'DRIVER INATTENTION OR DISTRACTION'
• 16 = 'DRIVER INEXPERIENCE'
• 17 = 'PEDESTRIAN VIOLATION OR ERROR'
• 18 = 'CHEMICAL IMPAIRMENT'
• 19 = 'FAILURE TO USE LIGHTS'
• 20 = 'DRIVER ON CAR PHONE, CB, OR TWO-WAY RADIO'
• 21 = 'OTHER HUMAN CONTRIBUTING FACTOR'
• 31 = 'VISION OBSCURED - WINDSHIELD GLASS'
• 32 = 'VISION OBSCURED - SUN OR HEADLIGHTS'
• 33 = 'VISION OBSCURED - OTHER'
• 41 = 'DEFECTIVE BRAKES'
• 42 = 'DEFECTIVE TIRE OR TIRE FAILURE'
• 43 = 'DEFECTIVE LIGHTS'
• 44 = 'INADEQUATE WINDSHIELD GLASS'
• 45 = 'OVERSIZE OR OVERWEIGHT VEHICLE'
• 46 = 'SKIDDING'
• 50 = 'OTHER VEHICLE DEFECTS OR FACTORS'
• 61 = 'WEATHER'
• 62 = 'ROAD DEFECT'                
• 63 = 'FAIL USE LIGHTS'
• 64 = 'DRV/PHNE/CB/RDO'
• 65 = 'PHSICAL IMPAIRMENT'
• 90 = 'OTHER'
• 99 = 'UNKNOWN'

DAMSEV

VEHICLE DAMAGE SEVERITY

• '00' = 'NOT SPECIFIED'            
• '01' = 'NONE'
• '02' = 'LIGHT'
• '03' = 'MODERATE'
• '04' = 'SEVERE'
• '05' = 'TOTAL'
• '90' = 'OTHER'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'

DRV_AGE

AGE OF DRIVER

NON-LABELED VARIABLE

NOTE: 98 = '98 YRS OR OLDER', 99 = 'UNKNOWN'. In the 1990 file, only injured driver information is available. Between 5 - 10 percent of the cases are uncoded after 1990. 

DRV_INJ

DRIVER INJURY

• 'K' = 'KILLED'                    
• 'A' = 'INJURED - INCAPACITATING'
• 'B' = 'INJURED - NON-INCAPACITATING'
• 'C' = 'INJURED - POSSIBLE INJURY'
• ' ','N' = 'NO INJURY'             
• 'X','U' = 'INJURED - SEVERITY UNKNOWN'
• OTHER = 'ERROR/OTHER CODE'

NOTE: (1) This variable was copied from the Occupant Subfile to this Vehicle Subfile beginning in 1990.  Prior driver-injury data can be extracted from the Occupant Subfile. 

(2) The "NO INJURY" code is new beginning in 1990. However, full data on all uninjured drivers is probably not available until 1991 or 1992. In addition, the "NO INJURY" code is not used after 1991. MN staffs indicate that a blank code also means "NO INJURY", as captured in the format above.

DRV_SEX

SEX OF DRIVER

• 'M' = 'MALE'
• 'F' = 'FEMALE'
• 'N' = 'NS/NOT APPLIC'
• OTHER = 'ERROR/OTHER CODE'

NOTE: In 1990, only injured driver information is available. "NS/NOT APPLIC" plus other "ERROR/OTHER CODE" represent approximately 10 percent of the cases for all years.

EVENT1

SEQUENCE OF EVENT ‑1

EVENT2

SEQUENCE OF EVENT ‑2

EVENT3

SEQUENCE OF EVENT ‑3

EVENT4

SEQUENCE OF EVENT ‑4

Collision with                    

• '01' = 'MOTOR VEHICLE IN TRANSPORT'
• '02' = 'PARKED MOTOR VEHICLE'
• '03' = 'ROADWAY EQUIPMENT--SNOWPLOW'
• '04' = 'ROADWAY EQUIPMENT--OTHER'
• '05' = 'TRAIN'
• '06' = 'PEDALCYCLE'
• '07' = 'PEDESTRIAN'
• '08' = 'DEER'
• '09' = 'OTHER ANIMAL'
• '10' = 'UNDERRIDE--REAR'
• '11' = 'UNDERRIDE--SIDE'
• '12' = 'OTHER NON-FIXED OBJECT'
• '13' = 'OTHER COLLISION TYPE'
• '14' = 'UNKNOWN COLLISION TYPE'

Collision with fixed object

• '21' = 'CONSTRUCTION EQUIPMENT'
• '22' = 'TRAFFIC SIGNAL'
• '23' = 'RR CROSSING DEVICE'
• '24' = 'LIGHT POLE'
• '25' = 'UTILITY POLE'
• '26' = 'SIGN STRUCTURE OR POST'
• '27' = 'MAILBOXES AND/OR POSTS'
• '28' = 'OTHER POLES'
• '29' = 'HYDRANT'
• '30' = 'TREE/SHRUBBERY'
• '31' = 'BRIDGE PIERS'
• '32' = 'MEDIAN SAFETY BARRIER'
• '33' = 'CRASH CUSHION'
• '34' = 'GUARDRAIL'
• '35' = 'FENCE (NON-MEDIAN BARRIER)'
• '36' = 'CULVERT / HEADWALL'
• '37' = 'EMBANKMENT / DITCH / CURB'
• '38' = 'BUILDING / WALL'
• '39' = 'ROCK OUTCROPS'
• '40' = 'PARKING METER'
• '41' = 'OTHER FIXED OBJECT'
• '42' = 'UNKNOWN FIXED OBJECT'

Non-collision

• '51' = 'OVERTURN / ROLLOVER'
• '52' = 'SUBMERSION'
• '53' = 'FIRE / EXPLOSION'
• '54' = 'JACKKNIFE'
• '55' = 'LOSS/SPILLAGE NON-HAZ MAT'
• '56' = 'LOSS/SPILLAGE HAZARDOUS MAT'
• '57' = 'RAN OFF ROAD--RIGHT'
• '58' = 'RAN OFF ROAD--LEFT'
• '59' = 'EQUIP FAIL (TIRE, BRAKE, ETC.)'
• '60' = 'SEPARATION OF UNITS'
• '61' = 'DOWNHILL RUNAWAY'
• '62' = 'CROSS MEDIAN / CENTERLINE'
• '63' = 'CARGO / EQUIPMENT SHIFT'
• '64' = 'NON-COLLISION OF OTHER TYPE'
• '65' = 'NON-COLLISION OF UNKNOWN TYPE'
• '66' = 'COL WITH FIX OBJ'                       
• '67' = 'COL WITH FAL OBJ'                                 
• '68' = 'RAN OFF ROAD'                                     

Residual categories

• '90' = 'EVENT OF OTHER TYPE'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'
• '00' = 'NOT SPECIFIED'

NOTE:Valid data are not available for 2003. No EVENT4 is available for 2004.

FIRE

FIRE IN VEHICLE

• 'I' = 'NOT APPLICABLE'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'YES'
• 'Z' = 'NOT SPECIFIED'

HAZMTL

VEHICLE CARRYING HAZARDOUS MATERIAL

• 'I' = 'NOT APPLICABLE'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'YES'
• 'Z' = 'NOT SPECIFIED'

INTRANSPORT

WAS VEHICLE IN TRANSPORT

• 'I' = 'NOT APPLICABLE'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'YES'

NOTE: Variable added in 2003.

LICTYPE

VALID DRIVER LICENSE

• 'Y' = 'VALID LICENSE'
• 'N' = 'INVALID LICENSE'
• 'X' = 'UNKNOWN'
• 'I' = 'NOT APPLICABLE'
• OTHER = 'ERROR/OTHER CODE'

NOTE: Variable discontinued in 1990.

MAKE

MAKE OF VEHICLE

NON-LABELED VARIABLE

NOTE: New variable added in 1990. This is a four character code indicating the vehicle make.  While some codes are obvious (e.g., FORD, BUIC, CHEV), others are not as obvious.  Approximately 13% of the data are uncoded.

MCAXLDN

MOTOR CARRIER AXLES DOWN

NON-LABELED VARIABLE

NOTE: Axles down making contact with pavement (00-99).

Variable discontinued in 2003.

MCAXLUUP

MOTOR CARRIER AXLES UP

NON-LABELED VARIABLE

NOTE: Axles up not making contact with pavement (00-99).

Variable discontinued in 2003.

MCBDYTYP

MOTOR CARRIER BODY TYPE

• '00' = 'NOT SPECIFIED'
• '01' = 'VAN'
• '02' = 'DRY BULK CARGO TANK'
• '03' = 'LIQUID BULK CARGO TANK'
• '04' = 'GAS BULK CARGO TANK'
• '05' = 'FLATBED OR PLATFORM'
• '06' = 'DUMP'
• '07' = 'CONCRETE MIXER'
• '08' = 'AUTO TRANSPORTER'
• '09' = 'GARBAGE OR REFUSE'
• '10' = 'COMBINATION'
• '11' = 'SPECIAL PERMIT LOAD'
• '12' = 'GRAIN/CHIPS/GRAVEL'
• '13' = 'POLE'
• '14' = 'BUS'
• '90' = 'OTHER'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'

MCGVWRCD

MOTOR GROSS VEHICLE WEIGHT CODE

• '00' = 'NOT APPLICABLE'
• '01' = '< 10,000 LBS'
• '02' = '10,000 TO 11,999 LBS'
• '03' = '12,000 TO 25,999 LBS'
• '04' = '26,000 TO 56,999 LBS'
• '05' = '57,000 TO 80,000 LBS'
• '06' = '80,001 TO 105,000 LBS'
• '07' = '105,001 TO 120,000 LBS'
• '08' = '> 120,000 LBS'
• '99' = 'UNKNOWN'

NOTE: Variable discontinued in 2003.

MCHZPLAC

MOTOR HAZARDOUS MATERIAL PLACARD FLAG

• 'I' = 'NOT APPLICABLE'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'YES'
• 'Z' = 'NOT SPECIFIED'

NOTE: Variable discontinued in 2003.

MCSOURCE

SOURCE OF IDENTIFICATION

• '01' = 'CAB BOARD'
• '02' = 'SHIPPING PAPERS'
• '03' = 'SIDE OF VEHICLE'
• '04' = 'DRIVER'
• '90' = 'OTHER'
• OTHER = 'ERROR/OTHER CODE'

NOTE: Variable discontinued in 2003.

MCTRHTCH

MOTOR TRAILER HITCH CODE

• '00' = 'NOT APPLICABLE'
• '01' = 'TRAILER WITH BALL HITCH'
• '02' = 'TRAILER WITH FIFTH WHEEL'
• '03' = 'A‑TRAIN WITH 5TH WHEEL'
• '04' = 'B‑TRAIN WITH 5TH WHEEL'
• '05' = 'C‑TRAIN WITH 5TH WHEEL'
• '06' = 'PINTLE HITCH'
• '90' = 'OTHER (INCLUDING COMBINATIONS)'
• '99' = 'UNKNOWN'

NOTE: Variable discontinued in 2003.

MISCACT1

ACTION PRIOR TO ACCIDENT

• 01 = 'VEHICLE - GOING STRAIGHT AHEAD OR FOLLOWING ROADWAY'
• 02 = 'VEHICLE - WRONG WAY INTO OPPOSING TRAFFIC'
• 03 = 'VEHICLE - RIGHT TURN ON RED'
• 04 = 'VEHICLE - LEFT TURN ON RED'
• 05 = 'VEHICLE - MAKING RIGHT TURN'
• 06 = 'VEHICLE - MAKING LEFT TURN'
• 07 = 'VEHICLE - MAKING U TURN'
• 08 = 'VEHICLE - STARTING FROM PARKED POSITION'
• 09 = 'VEHICLE - STARTING IN TRAFFIC'
• 10 = 'VEHICLE - SLOWING IN TRAFFIC'
• 11 = 'VEHICLE - STOPPED IN TRAFFIC'
• 12 = 'VEHICLE - ENTERING PARKED POSITION'
• 13 = 'VEHICLE - AVID UNIT/OBJECT IN ROAD'
• 14 = 'VEHICLE - CHANGING LANES'
• 15 = 'VEHICLE - OVERTAKING/PASSING'
• 16 = 'VEHICLE - MERGING'
• 17 = 'VEHICLE - BACKING'
• 18 = 'VEHICLE - STALLED ON ROADWAY'
• 21 = 'PARKED VEHICLE - PARKED LEGALLY'
• 22 = 'PARKED VEHICLE - PARKED ILLEGALLY'
• 23 = 'PARKED VEHICLE - STOPPED OFF ROADWAY'
• 30 = 'VEHICLE OTHER ACTION'  
• 31 = 'PEDESTRIAN - CROSSING WITH SIGNAL'
• 32 = 'PEDESTRIAN - CROSSING AGAINST SIGNAL'
• 33 = 'PEDESTRIAN - DARTING INTO TRAFFIC'
• 34 = 'PEDESTRIAN - OTHER IMPROPER CROSSING'
• 35 = 'PEDESTRIAN - CROSSING IN A MARKED CROSSWALK'
• 36 = 'PEDESTRIAN - CROSSING (NO SIGNAL OR CROSSWALK)'
• 37 = 'PEDESTRIAN - FAIL TO YIELD R/W TO TRAFFIC'
• 38 = 'PEDESTRIAN - INNATENTION/DISTRACTION'
• 39 = 'PEDESTRIAN - WALKING/RUNNING IN ROAD WITH TRAFFIC'
• 40 = 'PEDESTRIAN - WALKING/RUNNING IN ROAD AGAINST TRAFFIC'
• 41 = 'PEDESTRIAN - STANDING/LYING IN ROAD'
• 42 = 'PEDESTRIAN - EMERGING FROM BEHIND PARKED VEHICLE'
• 43 = 'PEDESTRIAN - CHILD GETTTING ON/OFF SCHOOL BUS'
• 44 = 'PEDESTRIAN - PERON GETTING ON/OFF VEHICLE'
• 45 = 'PEDESTRIAN - PUSHING/WORKING ON VEHICLE'
• 46 = 'PEDESTRIAN - WORKING IN ROADWAY'
• 47 = 'PEDESTRIAN - PLAYING IN ROADWAY'
• 48 = 'PEDESTRIAN - NOT IN ROADWAY'
• 51 = 'BICYCLIST - RIDING WITH TRAFFIC'
• 52 = 'BICYCLIST - RIDING AGAINST TRAFFIC'
• 53 = 'BICYCLIST - MAKING RIGHT TURN'
• 54 = 'BICYCLIST - MAKING LEFT TURN'
• 55 = 'BICYCLIST - MAKING U TURN'
• 56 = 'BICYCLIST - RIDING ACROSS ROAD'
• 57 = 'BICYCLIST - SLOWING/STOPPING/STARTING'
• 60 = 'PED OTH ACTION'             
• 80 = 'BIKE OTH/ACTION'            
• 98 = 'NOT STATED'                 
• 90 = 'OTHER ACTION'
• 99 = 'UNKNOWN'
• OTHER = 'ERROR/OTHER CODE'

MODEL

MOTOR MODEL

NON-LABELED VARIABLE

NOTE: Variable discontinued in 2003.

MOST_EVENT

MOST HARMFUL EVENT

• '00' = 'NOT SPECIFIED'
• '01' = 'MOTOR VEHICLE IN TRANSPORT'
• '02' = 'PARKED MOTOR VEHICLE'
• '03' = 'ROADWAY EQUIPMENT--SNOWPLOW'
• '04' = 'ROADWAY EQUIPMENT--OTHER'
• '05' = 'TRAIN'
• '06' = 'PEDALCYCLE'
• '07' = 'PEDESTRIAN'
• '08' = 'DEER'
• '09' = 'OTHER ANIMAL'
• '10' = 'UNDERRIDE--REAR'
• '11' = 'UNDERRIDE--SIDE'
• '12' = 'OTHER NON-FIXED OBJECT'
• '13' = 'OTHER COLLISION TYPE'
• '14' = 'UNKNOWN COLLISION TYPE'
• '21' = 'CONSTRUCTION EQUIPMENT'
• '22' = 'TRAFFIC SIGNAL'
• '23' = 'RR CROSSING DEVICE'
• '24' = 'LIGHT POLE'
• '25' = 'UTILITY POLE'
• '26' = 'SIGN STRUCTURE OR POST'
• '27' = 'MAILBOXES AND/OR POSTS'
• '28' = 'OTHER POLES'
• '29' = 'HYDRANT'
• '30' = 'TREE/SHRUBBERY'
• '31' = 'BRIDGE PIERS'
• '32' = 'MEDIAN SAFETY BARRIER'
• '33' = 'CRASH CUSHION'
• '34' = 'GUARDRAIL'
• '35' = 'FENCE (NON-MEDIAN BARRIER)'
• '36' = 'CULVERT / HEADWALL'
• '37' = 'EMBANKMENT / DITCH / CURB'
• '38' = 'BUILDING / WALL'
• '39' = 'ROCK OUTCROPS'
• '40' = 'PARKING METER'
• '41' = 'OTHER FIXED OBJECT'
• '42' = 'UNKNOWN FIXED OBJECT'
• '51' = 'OVERTURN / ROLLOVER'
• '52' = 'SUBMERSION'
• '53' = 'FIRE / EXPLOSION'
• '54' = 'JACKKNIFE'
• '55' = 'LOSS/SPILLAGE NON-HAZ MAT'
• '56' = 'LOSS/SPILLAGE HAZARDOUS MAT'
• '57' = 'RAN OFF ROAD--RIGHT'
• '58' = 'RAN OFF ROAD--LEFT'
• '59' = 'EQUIP FAIL (TIRE, BRAKE, ETC.)'
• '60' = 'SEPARATION OF UNITS'
• '61' = 'DOWNHILL RUNAWAY'
• '62' = 'CROSS MEDIAN / CENTERLINE'
• '63' = 'CARGO / EQUIPMENT SHIFT'
• '64' = 'NON-COLLISION OF OTHER TYPE'
• '65' = 'NON-COLLISION OF UNKNOWN TYPE'
• '66' = 'COL WITH FIX OBJ'
• '67' = 'COL WITH FAL OBJ'
• '68' = 'RAN OFF ROAD'
• '90' = 'EVENT OF OTHER TYPE'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'

NOTE: New variable added in 2003.

MVCLASS

MOTOR CLASS

NON-LABELED VARIABLE

NOTE: Variable discontinued in 2003.

MVTYPE

MOTOR TYPE

NON-LABELED VARIABLE

NOTE: Variable discontinued in 2003.

NUMOCCS

NUMBER OF OCCUPANTS

NON-LABELED VARIABLE

NOTE: Number of occupants in the vehicle (0-99).

Variable added in 1991.

PHYSCOND

PHYSICAL CONDITION OF DRIVER

• 00 = 'NOT SPECIFIED'
• 01 = 'NORMAL - NO DRUGS OR DRINKING'
• 02 = 'UNDER THE INFLUENCE'
• 03 = 'HAD BEEN DRINKING'
• 04 = 'COMMERCIAL DRIVER OVER .04 BAC'
• 05 = 'HAD BEEN TAKING DRUGS'
• 06 = 'AGGRESSIVE'
• 07 = 'ASLEEP'
• 08 = 'PHYSICAL DISABILITY'
• 09 = 'ILL'
• 10 = 'FATIGUES'                                 
• 90 = 'OTHER'
• 98 = 'NOT APPLICABLE'
• 99 = 'UNKNOWN'

SERIES

SERIES OF VEHICLE

NON-LABELED VARIABLE

NOTE: Variable added in 1990. This is a three-character code identifying the vehicle series (e.g., 626, 6LE, CIV) within a given vehicle make. While we do not have a listing of all possible formats, it appears that the data can be "decoded" when combined with MAKE.  Approximately 20% of the data are uncoded.

TOWAWAY

VEHICLE TOWED

• 'Y' = 'YES'
• 'N' = 'NO'
• OTHER = 'ERROR/OTHER CODE'

TOWING

TOWING FLAG

• 'Y' = 'NON-TRUCK VEHICLE TOWING TRAILER, BOAT, ETC'
• 'N' = 'OTHERWISE'

NOTE: Variable added in 1991.

V_DAMAGE

VEHICLE DAMAGE AREA

• 00 = 'NOT SPECIFIED'
• 01 = 'FRONT'
• 02 = 'FRONT RIGHT'
• 03 = 'RIGHT SIDE'
• 04 = 'REAR RIGHT'
• 05 = 'REAR'
• 06 = 'REAR LEFT'
• 07 = 'LEFT SIDE/CENTER'
• 08 = 'LEFT FRONT'
• 09 = 'TOP'
• 10 = 'UNDER'
• 11 = 'MULTIPLE AREAS'
• 12 = 'FRONT CENTER'
• 00 = 'NOT APPLICABLE'
• 99 = 'UNKNOWN'
• OTHER = 'ERROR/OTHER CODE'

VEH_DIR

DIRECTION VEHICLE WAS TRAVELING

• 1 = 'NORTH'
• 2 = 'NORTHEAST'                   
• 3 = 'EAST'                        
• 4 = 'SOUTHEAST'                   
• 5 = 'SOUTH'                       
• 6 = 'SOUTHWEST'                   
• 7 = 'WEST'                        
• 8 = 'NORTHWEST'                   
• 99 = 'UNKNOWN/NOT APPLICABLE'     

NOTE: Variable added in 1990.

VEH_USE

SPECIAL VEHICLE USE

• '01' = 'NORMAL'
• '02' = 'TAXICAB'
• '03' = 'SCHOOL BUS'
• '04' = 'BUS (NON SCHOOL)'
• '05' = 'MILITARY VEH'
• '06' = 'HIT AND RUN VEH'
• '07' = 'POLICE NO LIGHTS/SIRENS'
• '08' = 'POLICE WITH LIGHTS/SIRENS'
• '09' = 'FIRE NO LIGHTS/SIRENS'
• '10' = 'FIRE WITH LIGHTS/SIRENS'
• '11' = 'AMBULANCE NO LIGHTS/SIRENS'
• '12' = 'AMBULANCE WITH LIGHTS/SIRENS'
• '13' = 'SNOWPLOW WORKING'
• '14' = 'SNOWPLOW IN TRANSIT'
• '15' = 'OTHER MAINT VEH WORKING'
• '16' = 'OTHER MAINT VEH IN TRANS'
• '17' = 'OTHER PUBLIC VEH'
• '90' = 'OTHER VEH USE'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'

NOTE: Variable only available for 2003 and 2004.

VEHNO

RELATIVE VEHICLE NUMBER

NON-LABELED VARIABLE

NOTE: Number of vehicle on accident report or relative vehicle number (01-60). Used to link with occupant file.

VEHSTATE

STATE OF VEHICLE REGISTRATION

NON-LABELED VARIABLE

NOTE: Variable added in 1997. However, all codes are currently blanks.

VEHTYPE

TYPE OF VEHICLE

• 01 = 'PASSENGER CAR'
• 02 = 'PICKUP'
• 03 = 'SPORT UTILITY VEHICLE'
• 04 = 'VAN OR MINIVAN'
• 05 = 'MOTORHOME, CAMPER, RV'
• 06 = 'LIMOUSINE'
• 07 = 'BUS (7-15 SEATS)'
• 08 = 'BUS (16+ SEATS)'
• 09 = 'SNOWMOBILE'
• 10 = 'ATV'
• 11 = 'MOTORCYCLE'
• 12 = 'MOTORSCOOTER, MOTORBIKE'
• 13 = 'MOPED, MOTORIZED BICYCLE'
• 14 = 'FARM EQUIPMENT'
• 31 = '2AXLE, 6TIRE 1UNIT TRUCK'
• 32 = '3+ AXLE 1UNIT TRUCK'
• 33 = '1 UNIT TRUCK WITH TRAILER'
• 34 = 'TRUCK TRACT. NO TRAILER'
• 35 = 'TRUCK TRACT. SEMITRAILER'
• 36 = 'TRUCK TRACT. 2 TRAILERS'
• 37 = 'TRUCK TRACT. 3 TRAILERS'
• 38 = 'HEAVY TRUCK UNKNOWN TYPE'
• 51 = 'PEDESTRIAN'
• 52 = 'SKATER'
• 53 = 'BICYCLIST'
• 54 = 'OTHER NON-MOTORIST'
• 55 = 'AUTO+TRAILR (<90)'          
• 56 = 'TRUCK/TRACTOR (<90)'        
• 57 = 'TRU/TRAT W/OTHER'           
• 58 = 'SCHOOL BUS'                 
• 59 = 'OTHER BUS'                  
• 60 = 'TAXICAB'                    
• 61 = 'HIT&RUN VEH'                
• 62 = 'POLICE VEH'                 
• 63 = 'FIRE DEPT VEH'              
• 64 = 'AMBULANCE'                  
• 65 = 'MILITARY VEH'               
• 66 = 'RD MAIN VEH'                
• 67 = 'OTH PUB OWN VEH'            
• 68 = 'OTH PRIV OWN VEH'           
• 69 = '2-AX/SINGLE TRK'                                    
• 70 = '3-AX SINGLE TRK'                                    
• 71 = 'TT W/TRIP TRAIL'                                    
• 90 = 'OTHER MOTOR VEHICLE TYPE'
• 99 = 'UNKNOWN'

VEHYR

MODEL YEAR OF VEHICLE

NON-LABELED VARIABLE

NOTE: Model year of vehicles (NNNN). This variable discontinued in 1991.

WAIVED

COMMERCIAL VEHICLE INSPECTION WAIVED

• 'I' = 'NOT APPLICABLE'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'YES'

NOTE: Variable only available for 2003 and 2004.

WASTE_MT

VEHICLE CARRYING WASTE MATERIAL

• 'Y' = 'YES'
• 'N' = 'NO'

NOTE: Variable discontinued in 1990.

LIST OF VARIABLES FOR THE MINNESOTA OCCUPANT SUBFILE

NOTE: This file only contains data on the injured occupants in the vehicle for 1985-1990 data.  Thus, none of the "successes" (non-injured occupants) are included for these years.  Beginning in 1991 and 1992, this file contains data on all occupants. See discussion

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE MINNESOTA STATE OCCUPANT SUBFILE

NOTE: (1) SAS variable names and explanatory names are shown above each listing. (See Discussion for information on SAS formats.)

(2)  This file only contains data on the injured occupants in the vehicle for 1985-1990 data.  Thus, none of the "successes" (non-injured occupants) are included for these years.  Beginning in 1991, this file contains data on all occupants.  See discussion.

AGE

AGE OF INJURED/KILLED OCCUPANT

NON-LABELED VARIABLE

NOTE: 98 = '98 YRS OR OLDER', 99 = 'UNKNOWN'.

AIRBAG

AIRBAG DEPLOYED

• '00' = 'NOT SPECIFIED'
• '01' = 'DEPLOYED--FRONT'
• '02' = 'DEPLOYED--SIDE'
• '03' = 'DEPLOYED--FRONT+SIDE'
• '04' = 'NOT DEPLOYED--SWITCH ON'
• '05' = 'NOT DEPLOYED--SWITCH ON'
• '06' = 'NOT DEPLOYED--UNKNOWN IF SWITCH ON OR OFF'
• '90' = 'OTHER'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'

NOTE: Variable added in 2000.

ALCOHOL_RESULT

BLOOD ALCOHOL TEST RESULT

• '00' = 'NEGATIVE'
• '01' = 'POSITIVE FOR ALCOHOL AT THE 0.01% BAC'
• '02' = 'POSITIVE FOR ALCOHOL AT THE 0.02% BAC'
• '03' = 'POSITIVE FOR ALCOHOL AT THE 0.03% BAC'
• '04' = 'POSITIVE FOR ALCOHOL AT THE 0.04% BAC'
• '05' = 'POSITIVE FOR ALCOHOL AT THE 0.05% BAC'
• '90' = 'OTHER'
• '91' = 'PERSON WAS NOT A DRIVER'
• '92' = 'PERSON WAS A DRIVER BUT PERSON WAS NOT TESTED'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'

NOTE: Variable added in 2003.

ALCOHOL_TEST

BLOOD ALCOHOL TEST PERFORMANCE

• 'I' = 'NOT APPLICABLE'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'YES'
• 'Z' = 'NOT SPECIFIED'

NOTE: Variable added in 2003.

BIRTH_DT

BIRTHDAY

NON-LABELED VARIABLE

NOTE: Date of birth (YYYYMMDD). Variable added 1991.

CASENO

ACCIDENT NUMBER

NON-LABELED VARIABLE

NOTE: 'YYYYDDDNNNN' where YYYY = Year, DDD = Julian day of year,

NNNN = Unique case number (0000-9999).

CORN_RPT

CORONER REPORT RECORD

• 'I' = 'NOT APPLICABLE'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'YES'
• 'Z' = 'NOT SPECIFIED'

NOTE: Variable added in 1991.

DL_CLASS

DRIVER LICENSE CLASS

• 'A' = 'COMMERCIAL - ANY VEHICLE OR COMBINATION'
• 'B' = 'COMMERCIAL - ANY BASIC SINGLE UNIT MOTOR VEHICLE'
• 'C' = 'COMMERCIAL - ANY CLASS D VEHICLE TRANSPORTING HAZMAT AND FOR SCHOOL BUS'
• 'D' = 'THE NORMAL DRIVER LICENSE'
• 'I' = 'ID CARD ONLY'
• 'M' = 'MOPED LICENSE ONLY'
• 'R' = 'TRACER RECORD'
• 'T' = 'LIFETIME ID CARD ONLY'
• 'X' = 'CONAX RECORD'

NOTE: Variable added in 1991.

DL_STATE

DRIVER LICENSE STATE

NON-LABELED VARIABLE

NOTE: Two-character State name (i.e., MN). Variable added in 1991.

DL_WITHD

DRIVER LICENSE WITHDRAWAL

• 'I' = 'NOT APPLICABLE'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'LICENSE SUSPENDED, REVOKED, CANCELLED OR NEVER LICENSED'
• 'Z' = 'NOT SPECIFIED'

NOTE: Variable added in 1990 and discontinued in 1999.

DRIV_REC

DRIVER RECOMMENDATION

• '0' = 'NOT SPECIFIED'
• '1' = 'NONE'
• '2' = 'PHYSICAL EXAM'
• '3' = 'DRIVERS EXAM'
• '4' = 'DRIVER AND PHYSICAL EXAM'
• '5' = 'OTHER'
• '8' = 'NET APPLICABLE'

NOTE: Variable added in 1990.

DRUG_TEST

DRUG TEST PERFORMED

• 'I' = 'NOT APPLICABLE'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'YES'
• 'Z' = 'NOT SPECIFIED'

NOTE: Variable added in 2003.

EJECT

EJECTION FROM VEHICLE

• 00 = 'NOT SPECIFIED'
• 01 = 'TRAPPED, EXTRICATED (BY MECHANICAL MEANS)'
• 02 = 'TRAPPED, FREED BY NON- MECHANICAL MEANS'
• 03 = 'PARTIALLY EJECTED'
• 04 = 'EJECTED'
• 05 = 'NOT EJECTED'
• 90 = 'OTHER'
• 98 = 'NOT APPLICABLE'
• 99 = 'UNKNWON'

EQUIP_TYPE

TYPE OF SAFETY EQUIPMENT

• '00' = 'NOT SPECIFIED'
• '01' = 'NOT IN PLACE'
• '02' = 'LAP BELT'
• '03' = 'SHOULDER BELT'
• '04' = 'LAP AND SHOULDER BELT'
• '05' = 'CHILD SAFETY SEAT'
• '06' = 'CHILD BOOSTER SEAT'
• '90' = 'OTHER'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'

NOTE: New variable added in 2000.

FAT_NUM

FATALITY NUMBER

NON-LABELED VARIABLE

NOTE: Internal fatality number assigned by Minnesota.

Not of use for analysis efforts.

FATLDATE

FATALITY DATE

NON-LABELED VARIABLE

NOTE: Date of fatality (YYYYMMDD). Variable added in 1998.

HOSP

INJURED TAKEN TO HOSPITAL

• 'I' = 'NOT APPLICABLE'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'YES'
• 'Z' = 'NOT SPECIFIED'

HOSPTRAN

TRANSPORTED TO HOSPITAL METHOD

• 'A' = 'AMBULANCE'
• 'O' = 'OTHER'
• 'I' = 'NOT APPLICABLE'
• 'X' = 'UNKNOWN'
• 'Z' = 'NOT SPECIFIED'

NOTE: New variable added in 1991.

INJ

INJURY SEVERITY

• 'K' = 'KILLED'
• 'A' = 'INJURED - INCAPACITATING'
• 'B' = 'INJURED – NON-INCAPACITATING'
• 'C' = 'INJURED - POSSIBLE INJURY'
• ' ','N' = 'NO INJURY'
• 'X','U' = 'INJURED - SEVERITY UNKNOWN'
• OTHER = 'ERROR/OTHER CODE'

NOTE: The "NO INJURY" code is new beginning in 1990, since MN did not begin coding uninjured occupants until that year.  After 1991, MN staff indicate that a blank code also can mean "NO INJURY" as captured in the format above.  However, since additional blank "place holder" occupant records are added to the Occupant File, while not likely the case, there may be some blank codes which represent other injury classes. See Discussion.

LIS_RSTR

COMPLIANCE WITH LICENSE RESTRICTIONS

• '00' = 'NOT SPECIFIED'
• '01' = 'NONE'
• '02' = 'CORRECTIVE LENSES'
• '03' = 'MECHANICAL DEVICES'
• '04' = 'PROSTHETIC AID'
• '05' = 'AUTOMATIC TRANSMISSION'
• '06' = 'OUTSIDE MIRROR'
• '07' = 'LIMIT TO DAYLIGHT HOURS'
• '08' = 'LIMIT TO EMPLOYMENT ONLY'
• '09' = 'LIMITED - OTHER'
• '10' = 'LEARNERS PERMIT'
• '11' = 'CDL - COMMERCIAL DRIVER LICENSE'
• '12' = 'VEHICLES WITHOUT AIR BRAKES'
• '13' = 'EXCEPT CLASS A BUS'
• '14' = 'EXCEPT CLASS A AND CLASS B BUS'
• '15' = 'EXCEPT TRACTOR TRAILER'
• '16' = 'FARM WAIVER'
• '17' = 'MULTIPLE RESTRICTIONS'
• '90' = 'OTHER'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'

NOTE: New variable added in 1991.

PHYSCOND

PHYSICAL CONDITION

• 00 = 'NOT SPECIFIED'
• 01 = 'NORMAL - NO DRUGS OR DRINKING'
• 02 = 'UNDER THE INFLUENCE'
• 03 = 'HAD BEEN DRINKING'
• 04 = 'COMMERCIAL DRIVER OVER .04 BAC'
• 05 = 'HAD BEEN TAKING DRUGS'
• 06 = 'AGGRESSIVE'
• 07 = 'ASLEEP'
• 08 = 'PHYSICAL DISABILITY'
• 09 = 'ILL'
• 10 = 'FATIGUES'
• 90 = 'OTHER'
• 98 = 'NOT APPLICABLE'
• 99 = 'UNKNOWN'

NOTE: Codes are not mutually exclusive.  If more than one condition exists, officer is most likely to use alcohol-related codes. 

RES_CNTY

RESIDENCE COUNTY

NON-LABELED VARIABLE

NOTE: County of residence (same codes as COUNTY).

Variable added in 1991. Valid data are not available for 1997.

REST1

SAFETY EQUIPMENT USED

• '00' = 'NOT SPECIFIED'
• '01' = 'BELTS NOT USED'
• '02' = 'LAP BELT ONLY USED'
• '03' = 'SHOULDER BELT ONLY USED'
• '04' = 'LAP AND SHOULDER BELT USED'
• '05' = 'CHILD SEAT NOT USED'
• '06' = 'CHILD SET USED IMPROPERLY'
• '07' = 'CHILD SEAT USED PROPERLY'
• '08' = 'BOOSTER SEAT NOT USED'
• '09' = 'BOOSTER SEAT USED IMPROPERLY'
• '10' = 'BOOSTER SEAT USED PROPERLY'
• '11' = 'HELMET NOT USED'
• '12' = 'HELMET USED'
• '13' = 'DARK (NON-LIGHT-REFLECTIVE CLOTHING)'
• '14' = 'LIGHT-REFLECTIVE CLOTHING'
• '15' = 'NO PROTECTIVE (ELBOW, KNEE, ETC) PADS'
• '16' = 'PROTECTIVE PADS'
• '17' = 'CHILD REST'               
• '18' = 'REST DEV NOT INS'         
• '19' = 'REST DEV NOT USE'         
• '20' = 'REST DEV USED'
• '21' = 'MOTOCY HELM USED'         
• '22' = 'MOTOCY HELM/LGHT'         
• '23' = 'HELM USE LGHT/OF'         
• '24' = 'HELMET NOT USED'          
• '25' = 'NO HLMT/LGHT ON'                                  
• '26' = 'NO HLMT/LGHT OFF'                                 
• '27' = 'MTRCYCL LGHT ON'                                  
• '28' = 'MTRCYCL LGHT OFF'                                 
• '29' = 'SEAT BELT IMP US'                                 
• '30' = 'PAS BELT INS/USE'         
• '31' = 'PAS BELT INS CIR'                                 
• '32' = 'AIRBAG + SB USE'                                  
• '33' = 'AIRBAG-NO SB USE'                                 
• '34' = 'CRD NOT INSTALL'                                  
• '35' = 'CRD INSTL/NO USE'                                 
• '36' = 'CRD INST/IMPR US'                                 
• '90' = 'OTHER'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'

SEATPOS

POSITION IN VEHICLE

• 01 = 'DRIVER (INCLUDE MOTORCYCLE OPERATORS)'
• 02 = 'FRONT CENTER'
• 03 = 'FRONT RIGHT'
• 04 = 'SECOND SEAT LEFT'
• 05 = 'SECOND SEAT CENTER'
• 06 = 'SECOND SEAT RIGHT'
• 07 = 'THIRD SEAT LEFT'
• 08 = 'THIRD SEAT CENTER'
• 09 = 'THIRD SEAT RIGHT'
• 10 = 'OUTSIDE OF VEHICLE'
• 11 = 'TRAILING UNIT'
• 12 = 'PICKUP TRUCK BED'
• 13 = 'TRUCK CAB SLEEPER SECTION'
• 14 = 'PASSENGER IN OTHER POSITION (INCLUDE MOTORCYCLE PASSENGER)'
• 15 = 'PASSENGER IN UNKNOWN POSITION'
• 16 = 'FRONT LEFT (NON-DRIVER)'
• 19 = 'NOT KNOWN IF PERSON WAS A DRIVER OR A PASSENGER POSITIONS (LOCATIONS) FOR NON-MOTORISTS'
• 21 = 'CROSSWALK, MARKED, AT INTERSECTION'
• 22 = 'CROSSWALK, NOT MARKED, AT INTERSECTION'
• 23 = 'CROSSWALK, NOT AT INTERSECT'
• 24 = 'CROSSWALK--AT DRIVEWAY ACCESS'
• 25 = 'IN ROADWAY'
• 26 = 'NOT IN ROADWAY'
• 27 = 'MEDIAN (BUT NOT ON SHOULDER)'
• 28 = 'ISLAND'
• 29 = 'SHOULDER'
• 30 = 'SIDEWALK'
• 31 = 'WITHIN 10 FEET OF ROADWAY (BUT NOT ON MEDIAN, ISLAND, SHOULDER OR SIDEWALK)'
• 32 = 'BEYOND 10 FEET OF ROADWAY (BUT STILL IN TRAFFICWAY)'
• 33 = 'OUTSIDE TRAFFICWAY'
• 34 = 'SHARED-USE PATH OR TRAILS'
• 35 = 'OTHER NON-MOTORIST LOCATION'
• 36 = 'UNKNOWN NON-MOTORIST LOCATION'
• 37 = 'OTHER PASSNG'
• 38 = 'RDER HANG ON VEH'           
• 39 = 'MO/BIK/SNWBL DRV'           
• 40 = 'MO/BIK/SNWBL PAS'           
• 41 = 'SLED HANG ON'

SEX

SEX OF INJURED/KILLED OCCUPANT

• 'M' = 'MALE'
• 'F' = 'FEMALE'
• 'N' = 'NS/NOT APPLIC'
• 'X' = 'UNKNOWN'
• 'Z' = 'NOT SPECIFIED

VALID_LICENSE

VALID DRIVER LICENSE

• '00' = 'NOT SPECIFIED'
• '01' = 'VALID, AND WITHIN ALL RESTRICTIONS'
• '02' = 'VIOLATION -- BEYOND RESTRICTIONS'
• '03' = 'VIOLATION -- NOT ENDORSED FOR THIS TYPE OF VEHICLE'
• '04' = 'VIOLATION -- LICENSE SUSPENDED'
• '05' = 'VIOLATION -- LICENSE REVOKED'
• '06' = 'VIOLATION -- LICENSE CANCELLED'
• '07' = 'VIOLATION OF LIMITED LICENSE PROVISIONS'
• '08' = 'VIOLATION -- EXPIRED LICENSE'
• '90' = 'OTHER'
• '98' = 'NOT APPLICABLE'
• '99' = 'UNKNOWN'

NOTE: Variable added in 2003.

VEHNO

VEHICLE OCCUPIED BY INJURED/KILLED

NON-LABELED VARIABLE

NOTE: Vehicle number on accident report.  Used to link with vehicle file. Preliminary analyses indicate that pedestrians and bicyclists are often given a VEHNO = '0'.

VIOLATIONS

DRIVER CITED FOR VIOLATIONS

• 'I' = 'NOT APPLICABLE'
• 'N' = 'NO'
• 'X' = 'UNKNOWN'
• 'Y' = 'YES'
• 'Z' = 'NOT SPECIFIED

NOTE: Variable added in 2003.

WORK_REL

WORK RELATED ACCIDENT

• 'Y' = 'YES'
• 'N' = 'NO'

NOTE: Variable added in 1990.  Data appear to be consistent in 1991 and later. Variable discontinued in 2003.

LIST OF VARIABLES FOR THE MINNESOTA ROADLOG FILE

NOTE: Prior to 1994, approximately one-third of the records on this file are "false records" coded other than 'blank'.  These must be taken into account when using this file -- see introductory discussion.

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE MINNESOTA ROADLOG FILE

NOTE:  SAS variable names and explanatory names are shown above each listing. (See Discussion for information on SAS formats.)

AADT

CALCULATED AVERAGE AADT

• 0            = '0'
• 1-100        = '     1 -    100'
• 101-500      = '   101 -    500'
• 501-1000     = '   501 -  1,000'
• 1001-2000    = ' 1,001 -  2,000'
• 2001-5000    = ' 2,001 -  5,000'
• 5001-10000   = ' 5,001 - 10,000'
• 10001-15000  = '10,001 - 15,000'
• 15001-20000  = '15,001 - 20,000'
• 20001-40000  = '20,001 - 40,000'
• 40001-999999 = '>= 40,001'

NOTE: This is the calculate average AADT (annual average daily traffic) assigned to this section.  It is averaged over years (1985-87 in the 1987 File, 1988-89 in the 1989 File), and over counters within the section.  If no counters exist, the average is brought forward from the preceding upstream section.  See Discussion.  Approximately 2%-4% of the sections have AADT which is either uncoded or '0.' While the percentages of uncoded/"0" seem to vary across years, we can see no discernable pattern.

ACCESS

CONTROL OF ACCESS

• 0 = 'NOT APPLICABLE'
• 1 = 'NO CONTROL OF ACCESS'
• 2 = 'PARTIAL CONTROL OF ACCESS'
• 3 = 'FULL CONTROL OF ACCESS'
• 4 = 'NOT A PUBLIC ROAD'

ADLN_RD1

ADDITIONAL LANES ‑ ROAD 1

ADLN_RD2

ADDITIONAL LANES ‑ ROAD 2

• ' ' = 'NOT APPLICABLE'
• '0' = 'NO ADDITION LANES'
• '1' = 'CLIMBING LANES ON LEFT'
• '2' = 'CLIMBING LANES ON RIGHT'
• '3' = 'CLIMBING LANES ON BOTH SIDES'
• '4' = 'ESCAPE LANE ON LEFT'
• '5' = 'ACCELERATION LANES ON LEFT'
• '6' = 'ACCELERATION LANES ON RIGHT'
• '7' = 'ACCELERATION LANES ON BOTH SIDES'
• '8' = 'ESCAPE LANES ON RIGHT'
• '9' = 'OTHER ADDITIONAL LANES'

NOTE: Road 2 data only exist for divided roadways.  In addition, since there is no accurate way of linking a given accident with the proper road, and the low number of "disagreements" between Road 1 and Road 2 data, it is suggested that accidents always be linked with Road 1 data for ease of handling. (See earlier discussion.)

BAS_TKR1

BASE THICKNESS ‑ ROAD 1

• '   ' = 'NOT APPLICABLE'
• 'UN ' = 'UNKNOWN'
• '010'-'100' = ' 1.0 - 10.0'
• '101'-'200' = '10.1 - 20.0'
• '201'-'300' = '20.1 - 30.0'
• '301'-'400' = '30.1 - 40.0'
• '401'-'600' = '40.1 - 60.0'
• '601'-'900' = '60.1 - 90.0'
• '901'-'999' = ' >= 90.1'
• OTHER ='ERROR/OTHER CODE'

NOTE: This is the thickness of the pavement base to the nearest tenth of an inch (e.g., 094 = 9.4 inches).  Over 99% of the data are coded as "Not Applicable", which probably means that a blank also means "Not Coded".

BEGMP

CALCULATED BEGIN MILEPOST

NON-LABELED VARIABLE

NOTE: Calculated beginning milepost. See Discussion.

BRK_CD

BREAK CODE

• 1 = 'ROADLOG REPORTS'
• 2 = 'CONTROL SECTION BOOK'
• 3 = 'LOGPOINT LISTINGS'
• 4 = 'LOGPOINT LISTINGS & CONTROL SECTION BOOK'
• 5 = 'ROADLOG REPORT & CONTROL SECTION BOOK'
• 6 = 'ROADLOG REPORT & LOGPOINT LISTINGS'
• 7 = 'ROADLOG REPORTS & LOGPOINT LISTINGS & CONTROL SECTION BOOK'

COMM_ADT

CALCULATED AVERAGE COMMERCIAL AADT

• 0            = '0'
• 1-100        = '     1 -    100'
• 101-500      = '   101 -    500'
• 501-1000     = '   501 -  1,000'
• 1001-2000    = ' 1,001 -  2,000'
• 2001-5000    = ' 2,001 -  5,000'
• 5001-10000   = ' 5,001 - 10,000'
• 10001-15000  = '10,001 - 15,000'
• 15001-20000  = '15,001 - 20,000'
• 20001-40000  = '20,001 - 40,000'
• 40001-999999 = '>= 40,001'

COUNTY

COUNTY

NON-LABELED VARIABLE

NOTE: 01-87 = COUNTY NUMBER.

CURB1

CURBS - ROAD 1

CURB2

CURBS - ROAD 2

• ' ' = 'NOT APPLICABLE'
• 'N' = 'NO CURBS'
• 'L' = 'CURBS ON LEFT SIDE'
• 'R' = 'CURBS ON RIGHT SIDE'
• 'B' = 'CURBS ON BOTH SIDES'
• 'U' = 'UNKNOWN'

NOTE: Road 2 data only exist for divided roadways.  In addition, since there is no accurate way of linking a given accident with the proper road, and because of the low number of "disagreements" between Road 1 and Road 2 data, it is suggested that accidents always be linked with Road 1 data for ease of handling. (See discussion.)

DIR_CDE

DIRECTION CODE

• 'N ' = 'NORTH'
• 'S ' = 'SOUTH'
• 'E ' = 'EAST'
• 'W ' = 'WEST'
• 'NE' = 'NORTHEAST'
• 'NW' = 'SOUTHWEST'
• 'SE' = 'NORTHEAST'
• 'SW' = 'SOUTHWEST'

NOTE: Variable added in 2001.

ENDMP

CALCULATED ENDING MILEPOST

NON-LABELED VARIABLE

NOTE: Calculated ending milepost. See Discussion.

FED_AID

FEDERAL AID SYSTEM

• ' ' = 'NOT APPLICABLE'             Not applicable
• 'N' = 'NOT ON FEDERAL AID SYSTEM'  Not on federal aid system
• 'I' = 'FEDERAL AID INTERSTATE'     Federal aid interstate
• 'P' = 'FEDERAL AID PRIMARY'        Federal aid primary
• 'S' = 'FEDERAL AID SECONDARY'      Federal aid secondary
• 'U' = 'FEDERAL AID URBAN'          Federal aid urban

FED_SYSD

FEDERAL AID SYSTEM ‑ DESIGNATED

• ' ' = 'NO TRAVELLED WAY'
• 'D' = 'PROJECTED WAY'
• 'T' = 'TRAVELLED WAY'

FED_SYSR

FEDERAL AID SYSTEM ‑ REGULAR

• ' ' = 'NO TRAVELLED WAY INVOLVED'
• 'I' = 'TRAVELLED WAY OF INTERSTATE SYSTEM'
• 'P' = 'TRAVELLED WAY OF PRIMARY SYSTEM'
• 'S' = 'TRAVELLED WAY OF SECONDARY SYSTEM'
• 'U' = 'TRAVELLED WAY OF URBAN SYSTEM'
• 'N' = 'TRAVELLED WAY OF NON-FEDERAL SYSTEM'

FUNC_CLS

FUNCTIONAL CLASS

• 00 = 'Not applicable'

Rural

• 01 = 'RURAL Principal arterial - Interstate'
• 02 = 'RURAL Principal arterial - Other'
• 06 = 'RURAL Minor arterial'
• 07 = 'RURAL Major collector'
• 08 = 'RURAL Minor collector'
• 09 = 'RURAL Local systems'

Urban

• 11 = 'URBAN Principal arterial - Interstate'
• 12 = 'URBAN Principal arterial - Other' freeway -connecting'
• 13 = 'URBAN Principal arterial - Other' freeway - Non-connecting'
• 14 = 'URBAN Principal arterial - Other' connecting link'
• 15 = 'URBAN principal arterial - Other non-connecting link'
• 16 = 'URBAN Minor arterial'
• 17 = 'URBAN Collector'
• 19 = 'URBAN Local systems'

NOTE: Beginning with 1990 data, codes 13 and 15 are no longer valid.  Code 13 was changed to 12 and 15 was changed to 14. This explains why there are 'zeros' in the Guidebook tables’ cells for these codes.

H_COUNT

NUMBER OF COUNT STATIONS PER SECTION

NON-LABELED VARIABLE

NOTE: Number of traffic count stations per section.

INTE_CAT

INTERSECTION CATEGORY

• 00 = 'NO INTERSECTION'
• 01 = 'ISTH - Interstate trunk highway'
• 02 = 'USTH - U.S. trunk highway'
• 03 = 'MNTH - Minnesota trunk highway'
• 04 = 'CSAH - County state-aid highway'
• 05 = 'MSAS - Municipal state-aid street'
• 07 = 'CNTY - County road'
• 08 = 'TWNS - Township road'
• 09 = 'UTWN - Unorganized township road'
• 10 = 'MUN - City streets'
• 11 = 'NATP - National park road'
• 12 = 'NFD - National forest development road'
• 13 = 'IND - Indian reservation road'
• 14 = 'SFR - State forest road'
• 15 = 'SPRK - State park road'
• 16 = 'MIL - Military road'
• 17 = 'NATM - National monument road'
• 18 = 'NATW - National wildlife refuge road'
• 19 = 'FRNT - Frontage road'
• 20 = 'SGAM - State game preserve road'
• 21 = 'LEG - Leg'
• 22 = 'RAMP - Ramp'
• 23 = 'PRIV - Private jurisdiction road'

NOTE: This is a "point" variable describing the intersection at the beginning of the segment.

INV_DTE

INVENTORY DATE

NON-LABELED VARIABLE

NOTE: YYYYMMDD = DATE OF MOST RECENT INVENTORY, 00000000 = DATE OF INVENTORY UNKNOWN.

LANEWID

LANE WIDTH

NON-LABELED VARIABLE

NOTE: This variable shows the calculated lane width. Lane width (in feet) is not provided in the raw data file from Minnesota.  Instead, this variable is calculated using the following method suggested by Minnesota staff:

(1)  If roadway is undivided (i.e., ONEWAY not equal to 'D'), and if a curb is not present (CURB1 = 'N'), then: LANEWID = SURF_WID/NO_LANES. If a curb is present (CURB1 = 'L', 'R', or 'B'), then LANEWID = 12;

(2)  If roadway is divided (i.e., ONEWAY = 'D') and if a curb is not present (CURB1 = 'N'), then: LANEWID = (SURF_WID + SURF_WD2)/NO_LANES.  If a curb is present (CURB1 = 'L', 'R', or 'B'), then LANEWID = 12.

LSHL_TY2

LEFT SHOULDER TYPE ‑ ROAD 2

LSHL_TYP

LEFT SHOULDER TYPE ‑ ROAD 1

• '  ' = 'Not applicable'
• 'A ' = 'PRIMITIVE'
• 'B ' = 'UNIMPROVED'
• 'C ' = 'Graded and drained'
• 'D ' = 'Soil-surfaced'
• 'E ' = 'Gravel or stone'
• 'F ' = 'Bituminous surface - traveled'
• 'G ' = 'Mixed bituminous road - type unknown'
• 'G1' = 'Mixed bituminous road - low-type'
• 'G2' = 'Mixed bituminous road - high-type'
• 'G3' = 'Mixed bituminous surface - resurfacing'
• 'G4' = 'Mixed bituminous surface - new construction'
• 'I ' = 'Bituminous concrete or asphalt road'
• 'I3' = 'Bituminous concrete or asphalt resurfacing'
• 'I4' = 'Bituminous concrete or asphalt new construction'
• 'J ' = 'Portland cement concrete road'
• 'J3' = 'Portland cement concrete resurfacing'
• 'J4' = 'Portland cement concrete new construction'
• 'K ' = 'BRICK'
• 'L ' = 'BLOCK'
• 'M1' = 'Composite shoulder - 1 ft bituminous'
• 'M2' = 'Composite shoulder - 2 ft bituminous'
• 'M3' = 'Composite shoulder - 3 ft bituminous'
• 'M4' = 'Composite shoulder - 4 ft bituminous'
• 'M5' = 'Composite shoulder - 5 ft bituminous'
• 'M6' = 'Composite shoulder - 6 ft bituminous'
• 'M7' = 'Composite shoulder - 7 ft bituminous'
• 'M8' = 'Composite shoulder - 8 ft bituminous'
• 'M9' = 'Composite shoulder - 9 ft bituminous'
• 'N1' = 'Composite shoulder - 1 ft bituminous composite concrete'
• 'N2' = 'Composite shoulder - 2 ft bituminous composite concrete'
• 'N3' = 'Composite shoulder - 3 ft bituminous composite concrete'
• 'N4' = 'Composite shoulder - 4 ft bituminous composite concrete'
• 'N5' = 'Composite shoulder - 5 ft bituminous composite concrete'
• 'N6' = 'Composite shoulder - 6 ft bituminous composite concrete'
• 'N7' = 'Composite shoulder - 7 ft bituminous composite concrete'
• 'N8' = 'Composite shoulder - 8 ft bituminous composite concrete'
• 'N9' = 'Composite shoulder - 9 ft bituminous composite concrete'
• 'S ' = 'SOD SHOULDER'
• '00' = 'NO SHOULDER'
• OTHER = 'ERROR/OTHER CODE'

NOTE: (1) Composite shoulders (i.e., part paved, part unpaved) are coded as "Mn" or "Nn" in the above format.  The "n" or numeric part of these codes defines the width of the paved part of the shoulder.  The shoulder width variables (e.g., LSHLDWID, RSHLWID) will provide the total shoulder width in these composite cases.

(2) Road 2 data only exist for divided roadways.  In addition, since there is no accurate way of linking a given accident with the proper road, and because of the low number of "disagreements" between Road 1 and Road 2 data, it is suggested that accidents always be linked with Road 1 data for ease of handling. (See earlier discussion.)

LSHL_WD2

LEFT SHOULDER WIDTH - ROAD 2

LSHLDWID

LEFT SHOULDER WIDTH - ROAD 1

NON-LABELED VARIABLE

NOTE: This is the actual left shoulder width in feet. A blank means "not applicable"; a "UN" means "unknown"; and a "00" means "no shoulder".

(1) Road 2 data only exist for divided roadways.  In addition, since there is no accurate way of linking a given accident with the proper road, and because of the low number of "disagreements" between Road 1 and Road 2 data, it is suggested that accidents always be linked with Road 1 data for ease of handling. (See earlier discussion.)

(2) When MN/DOT codes shoulder width, it is total shoulder width.  For sod/gravel, it is from edge of lane to ditch, guardrail, or taper to ditch.  When there is partial paved and partial sod/gravel, the shoulder type should be coded as "composite."

In the composite codes under shoulder type, the shoulder type codes gives the feet of paved shoulder within the measurement.  The total measure for shoulder width presented here is the width of the total composite shoulder -- from edge of lane to ditch.  When the shoulder is "paved", the width is total width of the paved shoulder.  There may be some cases where the coding is slightly in error.  For example, a paved width may have some added sod/gravel which is unmeasured.  However, if there is a wide area of sod/gravel, the shoulder type will be "composite" and the total width will be measured. There are also some cases where composite shoulders may be coded in error; however, it can be assumed that the total width is for all types of shoulders.

MED_TYPE

MEDIAN TYPE

• ' ' = 'Not applicable'
• '0' = 'Median type unknown'
• '1' = 'No median barrier, raise median'
• '2' = 'No median barrier, depressed median'
• '3' = 'Plate beam barrier'
• '4' = 'City block (one-way couplet)'
• '6' = 'Concrete barrier'
• '5' = 'Box beam barrier'
• '7' = 'Chain link barrier, raise median'
• '8' = 'Chain link barrier, Depressed median'

MEDWID

MEDIAN WIDTH (IN FEET)

• '  ' = 'NOT APPLICABLE'
• 'UN' = 'UNKNOWN'
• 'VR' = 'VARIES'
• '01'-'10' = '01 - 10'
• '11'-'20' = '11 - 20'
• '21'-'30' = '21 - 30'
• '31'-'40' = '31 - 40'
• '41'-'60' = '41 - 60'
• '61'-'90' = '61 - 90'
• '91'-'99' = ' >= 91'

MVMT

MILLION VEHICLE MILES TRAVELED

NON-LABELED VARIABLE

NOTE: The Million Vehicle Miles Traveled on road segment. Created variable added in 1999 for all HSIS roadway-inventory files.  See Discussion.

NBRVOL

TOTAL NUMBER OF TRAFFIC VOLUME COUNTS

NON-LABELED VARIABLE

NOTE: The number of total (full plus blank) volume fields in the record containing AADT values. Variable discontinued in 1999.

NBRVOLB

NUMBER OF BLANK TRAFFIC VOLUME COUNTS

NON-LABELED VARIABLE

NOTE: The number of blank (unused) volume fields in the record.

Variable discontinued in 1999.

NBRVOLF

NUMBER OF FULL TRAFFIC VOLUME COUNTS

NON-LABELED VARIABLE

NOTE: Number of volume fields in the record containing AADT values. Variable discontinued in 1999.

NO_LANE1

NUMBER THROUGH LANES TOWARDS INCREASING MILEPOINTS

NO_LANE2

NUMBER THROUGH LANES TOWARDS DECREASING MILEPOINTS

• ' ' = 'Not applicable (no lanes)'
• '1' = 'One through lane'
• '2' = 'Two through lanes'
• '3' = 'Three through lanes'
• '4' = 'Four through lanes'
• '5' = 'Five through lanes'

NOTE: This variable and NO_LANE1 must be summed to obtain the total number of lanes on a section of roadway, even for 2-lane, 2-way roadways.  This has been done under NO_LANES.

NO_LANES

TOTAL NUMBER OF LANES

• . = 'NO LANES'
• 1 = 'ONE LANE'
• 2 = 'TWO LANES'
• 3 = 'THREE LANES'
• 4 = 'FOUR LANES'
• 5 = 'FIVE LANES'
• 6 = 'SIX LANES'
• 7 = 'SEVEN LANES'
• 8 = 'EIGHT LANES'
• 9-20 = '> EIGHT LANES'

NOTE: This is the sum of NO_LANE1 + NO_LANE2, and is the total number of lanes on a section of roadway.

ONEWAY

DIVIDED AND ONE‑WAY CODE

• ' ' = 'Not applicable'
• 'D' = 'Divided roadway - Road-1 & road-2 present'
• '0' = 'One-way couplet - Road-1 & road-2 present'
• 'U' = 'Undivided 2-way - road-1 present'
• 'X' = 'One-way street towards decreasing reference posts - Road-2 present'
• 'Z' = 'One-way street towards increasing reference posts - Road-1 present'

PARKING1

PARKING ON ROAD 1

PARKING2

PARKING ON ROAD 2

• ' ' = 'Not applicable'
• '0' = 'Unknown'
• '1' = 'Left-none Right-none'
• '2' = 'Left-none Right-parallel'
• '3' = 'Left-none Right-diagonal'
• '4' = 'Left-parallel Right-none'
• '5' = 'Left-parallel Right-parallel'
• '6' = 'Left-parallel Right-diagonal'
• '7' = 'Left-diagonal Right-none'
• '8' = 'Left-diagonal Right-parallel'
• '9' = 'Left-diagonal Right-diagonal'

NOTE: Road 2 data only exist for divided roadways.  In addition, since there is no accurate way of linking a given accident with the proper road, and because of the low number of "disagreements" between Road 1 and Road 2 data, it is suggested that accidents always be linked with Road 1 data for ease of handling. (See earlier discussion.)

REF_PST

REFERENCE POST

NON-LABELED VARIABLE

NOTE: Reference post number ('000'-'999'). New variable added in 1996.

REMARK

REMARKS ‑ TYPE OF RECORD

• '  ' = 'Mileage record - Normal section (roadlog file)'
• 'NE' = 'Mileage record - Non-existent section (roadlog file)'
• 'CO' = 'Descriptor record - Coincident (roadlog file)'
• 'EN' = 'Descriptor record - End-of-route record (roadlog file)'
• 'GP' = 'Descriptor record - Gap (roadlog file)'
• 'DS' = 'Descriptor record - Intersection description (logpoint file)'

NOTE: Prior to 1994, approximately one-third of the records on this file are "false records" coded other than 'blank'.  These must be taken into account when using this file -- see introductory discussion. These false records are deleted from the files for 1994 and later years.

RODWYCLS

ROADWAY CLASSIFICATION

• '01' = 'Urban freeways, four or more lanes'
• '02' = 'Urban freeways, less than 4 lanes'
• '03' = 'Urban two-lane roads'
• '04' = 'Urban multi-lane divided, non-freeway'
• '05' = 'Urban multilane undivided, non-freeway'
• '06' = 'Rural freeways, four or more lanes'
• '07' = 'Rural freeways, less than 4 lanes'
• '08' = 'Rural two-lane roads'
• '09' = 'Rural multilane divided, non-freeway'
• '10' = 'Rural Multilane undivided, non-freeway'
• '99' = 'OTHERS'

NOTE:  Created variable added to HSIS accident and roadway inventory files in all states in 1999.  See Discussion.

ROW

RIGHT OF WAY WIDTH

NON-LABELED VARIABLE

NOTE: Average right of way width in feet. New variable added in 1994.

RSHL_TY2

RIGHT SHOULDER TYPE - ROAD 2

RSHL_TYP

RIGHT SHOULDER TYPE - ROAD 1

• '  ' = 'Not applicable'
• 'A ' = 'PRIMITIVE'
• 'B ' = 'UNIMPROVED'
• 'C ' = 'Graded and drained'
• 'D ' = 'Soil-surfaced'
• 'E ' = 'Gravel or stone'
• 'F ' = 'Bituminous surface - traveled'
• 'G ' = 'Mixed bituminous road - type unknown'
• 'G1' = 'Mixed bituminous road - low-type'
• 'G2' = 'Mixed bituminous road - high-type'
• 'G3' = 'Mixed bituminous surface - resurfacing'
• 'G4' = 'Mixed bituminous surface - new construction'
• 'I ' = 'Bituminous concrete or asphalt road'
• 'I3' = 'Bituminous concrete or asphalt resurfacing'
• 'I4' = 'Bituminous concrete or asphalt new construction'
• 'J ' = 'Portland cement concrete road'
• 'J3' = 'Portland cement concrete resurfacing'
• 'J4' = 'Portland cement concrete new construction'
• 'K ' = 'BRICK'
• 'L ' = 'BLOCK'
• 'M1' = 'Composite shoulder - 1 ft bituminous'
• 'M2' = 'Composite shoulder - 2 ft bituminous'
• 'M3' = 'Composite shoulder - 3 ft bituminous'
• 'M4' = 'Composite shoulder - 4 ft bituminous'
• 'M5' = 'Composite shoulder - 5 ft bituminous'
• 'M6' = 'Composite shoulder - 6 ft bituminous'
• 'M7' = 'Composite shoulder - 7 ft bituminous'
• 'M8' = 'Composite shoulder - 8 ft bituminous'
• 'M9' = 'Composite shoulder - 9 ft bituminous'
• 'N1' = 'Composite shoulder - 1 ft bituminous composite concrete'
• 'N2' = 'Composite shoulder - 2 ft bituminous composite concrete'
• 'N3' = 'Composite shoulder - 3 ft bituminous composite concrete'
• 'N4' = 'Composite shoulder - 4 ft bituminous composite concrete'
• 'N5' = 'Composite shoulder - 5 ft bituminous composite concrete'
• 'N6' = 'Composite shoulder - 6 ft bituminous composite concrete'
• 'N7' = 'Composite shoulder - 7 ft bituminous composite concrete'
• 'N8' = 'Composite shoulder - 8 ft bituminous composite concrete'
• 'N9' = 'Composite shoulder - 9 ft bituminous composite concrete'
• 'S ' = 'SOD SHOULDER'
• '00' = 'NO SHOULDER'
• OTHER = 'ERROR/OTHER CODE'

NOTE: (1) Composite shoulders (i.e., part paved, part unpaved) are coded as "Mn" or "Nn" in the above format.  The "n" or numeric part of these codes defines the width of the paved part of the shoulder.  The shoulder width variables (e.g., LSHLDWID, RSHLWID) will provide the total shoulder width in these composite cases.

(2)  Road 2 data only exist for divided roadways.  In addition, since there is no accurate way of linking a given accident with the proper road, and because of the low number of "disagreements" between Road 1 and Road 2 data, it is suggested that accidents always be linked with Road 1 data for ease of handling. (See earlier discussion.)

RSHL_WD2

RIGHT SHOULDER WIDTH - ROAD 2

RSHLDWID

RIGHT SHOULDER WIDTH - ROAD 1

NON-LABELED VARIABLE

NOTE: This is the actual right shoulder width in feet. A blank means "not applicable"; a "UN" means "unknown"; and a "00" means "no shoulder".

(1)  Road 2 data only exist for divided roadways.  In addition, since there is no accurate way of linking a given accident with the proper road, and because of the low number of "disagreements" between Road 1 and Road 2 data, it is suggested that accidents always be linked with Road 1 data for ease of handling. (See earlier discussion.)

(2)  When Mn/DOT codes shoulder width, it is total shoulder width. For sod/gravel, it is from edge of lane to ditch, quardrail, or taper to ditch.  When there is partial paved and partial sod/gravel, the shoulder type should be coded as "composite."

In the composite codes under shoulder type, the shoulder type codes gives the feet of paved shoulder within the measurement.

The total measure for shoulder width presented here is the width of the total composite shoulder -- from edge of lane to ditch.

When the shoulder is "paved", the width is total width of the paved shoulder.  There may be some cases where the coding is slightly in error.  For example, a paved width may have some added sod/gravel which is unmeasured.  However, if there is a wide area of sod/gravel, the shoulder type will be "composite" and the total width will be measured. There are also some cases where composite shoulders may be coded in error; however, it can be assumed that the total width is for all types of shoulders.

RTE_NBR

ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: 'NNNNNNNNX' = ROUTE NUMBER (N=0-9, and X is numeric, alpha, or blank.  Note that in a few cases with county/township roads, an alpha character will appear in other columns.) This variable is used for file linkage * see RTSYSNBR.

RTE_SYS

ROUTE SYSTEM

• '01' = 'ISTH - Interstate trunk highway'
• '02' = 'USTH - U.S. trunk highway'
• '03' = 'MNTH - Minnesota trunk highway'
• '04' = 'CSAH - County state-aid highway'
• '05' = 'MSAS - Municipal state-aid highway'
• '07' = 'CNTY - County road'
• '08' = 'TWNS - Township road'
• '09' = 'UTWN - Unorganized township road'
• '10' = 'MUN - City streets'
• '11' = 'NATP - National park road'
• '12' = 'NFD - National forest development road'
• '13' = 'IND - Indian reservation road'
• '14' = 'SFR - State forest road'
• '15' = 'SPRK - State park road'
• '16' = 'MIL - Military road'
• '17' = 'NATM - National monument road'
• '18' = 'NATW - National wildlife refuge road'
• '19' = 'FRNT - Frontage road'
• '20' = 'SGAM - State game preserve road'
• '21' = 'PRV RD PUBLIC - Private road open to public'
• '23' = 'ALLEY/CEMTERY - Alleys and cemeteries'

NOTE: See RTESYSNBR.

RTSYSNBR

COMBINED ROUTE SYSTEM/ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: This is a combined version of the RTE_NBR and RTE_SYS variables above.  This combining was done to facilitate computer linkage with other files.

SEG_LNG

CALCULATED SECTION LENGTH

NON-LABELED VARIABLE

NOTE: For 1990 and later files, the calculated section length is based on true beginning and ending mileposts where available from the Reference Post File.  Prior to 1990, it was based on the difference between the standard beginning and ending mileposts.  See discussion.

SIDE_WLK

SIDEWALKS

• ' ' = 'Not applicable'
• 'N' = 'No sidewalks'
• 'L' = 'Sidewalks on left side'
• 'R' = 'Sidewalks on right side'
• 'B' = 'Sidewalks on both sides'
• 'C' = 'Combination (divided roadways and one-way couplets only)'
• 'U' = 'Unknown'

STM_SEW

STORM SEWERS

• ' ' = 'Not applicable or not stated'
• 'Y' = 'Yes - Storm sewers present'
• 'N' = 'No - Storm sewers not present'
• 'U' = 'Unknown'

NOTE:  High percentage of "UNKNOWN" codes.

SUF_TYP1

SURFACE SPECIFICATION NUMBER ‑ ROAD 1

SUF_TYP2

SURFACE SPECIFICATION NUMBER ‑ ROAD 2

• '    ' = 'Not applicable or not stated'
• '0000' = 'Gravel (aggregate) surface'
• '2301' = 'Concrete pavement'
• '2321' = 'Road-mixed bituminous surface'
• '2331' = 'Plant-mixed bituminous pavement'
• '2341' = 'Plant-mixed bituminous surface'
• '2351' = 'Asphaltic concrete surface'
• '2361' = 'Asphaltic concrete surface (fine mix)'

NOTE: Road 2 data only exist for divided roadways.  In addition, since there is no accurate way of linking a given accident with the proper road, and because of the low number of "disagreements" between Road 1 and Road 2 data, it is suggested that accidents always be linked with Road 1 data for ease of handling. (See earlier discussion.)

SUR_TKR1

SURFACE THICKNESS – ROAD 1

SUR_TKR2

SURFACE THICKNESS – ROAD 2

• '   ' = 'NOT APPLICABLE'
• 'UN ' = 'UNKNOWN'

NOTE: The variable SUR_TKR1 was discontinued in 1996. The variable SUR_TRK2 was only recorded for the year 1997.

SURF_TY2

SURFACE TYPE - ROAD 2

SURF_TYP

SURFACE TYPE - ROAD 1

• '  ' = 'Not applicable'
• 'A ' = 'Primitive'
• 'B ' = 'Unimproved'
• 'C ' = 'Graded and drained'
• 'D ' = 'Soil-surfaced'
• 'E ' = 'Gravel or stone'
• 'F ' = 'Bituminous surface - traveled'
• 'G ' = 'Mixed bituminous road - type unknown'
• 'G1' = 'Mixed bituminous road - low-type'
• 'G2' = 'Mixed bituminous road - high-type'
• 'G3' = 'Mixed bituminous surface - resurfacing'
• 'G4' = 'Mixed bituminous surface - new construction'
• 'I ' = 'Bituminous concrete or asphalt road'
• 'I3' = 'Bituminous concrete or asphalt resurfacing'
• 'I4' = 'Bituminous concrete or asphalt new construction'
• 'J ' = 'Portland cement concrete road'
• 'J3' = 'Portland cement concrete resurfacing'
• 'J4' = 'Portland cement concrete new construction'
• 'K ' = 'Brick'
• 'L ' = 'Block'

NOTE: Road 2 data only exist for divided roadways.  In addition, since there is no accurate way of linking a given accident with the proper road, and because of the low number of "disagreements" between Road 1 and Road 2 data, it is suggested that accidents always be linked with Road 1 data for ease of handling. (See earlier discussion.)

SURF_WID

SURFACE WIDTH - ROAD 1 (IN FEET)

SURF_WD2

SURFACE WIDTH - ROAD 2 (IN FEET)

• '  ' = 'NOT APPLICABLE'
• 'UN' = 'UNKNOWN'
• 'VR' = 'VARIES'
• '01'-'15' = '01 - 05'
• '16'-'18' = '16 - 18'
• '19'-'22' = '19 - 22'
• '23'-'25' = '23 - 25'
• '26'-'30' = '26 - 30'
• '31'-'40' = '31 - 40'
• '41'-'50' = '41 - 50'
• '51'-'60' = '51 - 60'
• '61'-'80' = '61 - 80'
• '81'-'99' = ' >= 81'

NOTE: Road 2 data only exist for divided roadways.  In addition, since there is no accurate way of linking a given accident with the proper road, and because of the low number of "disagreements" between Road 1 and Road 2 data, it is suggested that accidents always be linked with Road 1 data for ease of handling. (See earlier discussion.)

TURN_LN

TURNING LANES TOWARD INCREASING MILEPOSTS

TURN_LN2

TURNING LANES TOWARD DECREASING MILEPOSTS

• ' ' = 'Not applicable'
• 'N' = 'No turning lanes'
• 'L' = 'Turning lanes on left sides'
• 'R' = 'Turning lanes on right side'
• 'B' = 'Turning lanes on both sides'

UPDATE_

DATE OF UPDATE

NON-LABELED VARIABLE

NOTE: Most recent date on which record was modified (YYYYMMDD). Variable added in 1994.

URB_MNC

URBAN/MUNICIPAL CODE

• 0 = 'Not applicable'
• 1 = 'Nonmunicipal - rural'
• 2 = 'Nonmunicipal - urban'
• 3 = 'Municipal - rural'
• 4 = 'Municipal - urban'

VOLGRP

TRAFFIC VOLUME GROUP

• '  ' = 'Group unknown or unassigned'
• '01' = 'Outstate rural - blue (farm to market)'
• '02' = 'Outstate rural - green (some recreational)'
• '03' = 'Outstate rural - red (moderate recreational)'
• '04' = 'Outstate rural - yellow (high recreational)'
• '05' = 'Outstate municipal - recreational over 5000'
• '06' = 'Outstate municipal - non-recreational over 5000'
• '07' = 'Outstate municipal - recreational under 5000'
• '08' = 'Outstate municipal - non-recreational under 5000'
• '09' = 'Metro - urban commuter'
• '10' = 'Metro - urban-suburban mix'
• '11' = 'Metro - suburban commuter'
• '12' = 'Metro - outlying commuter'
• '13' = 'Metro - outlying mix'
• '14' = 'Metro - outlying recreational'
• '15' = 'Metro - urban-suburban shopping'
• '16' = 'Metro - urban mix'
• '17' = 'Metro - suburban mix'
• OTHER = 'ERROR/OTHER CODE'

NOTE: Variable added in 1989.

VOLTYP

TRAFFIC VOLUME TYPE

• 'A' = 'ACTUAL'
• 'C' = 'COMPTR GENERATED'
• 'E' = 'ESTIMATED'

YEAR

YEAR OF TRAFFIC

NON-LABELED VARIABLE

NOTE: Denotes year of volume count.

LIST OF VARIABLES FOR MINNESOTA INTERSECTION/INTERCHANGE FILE

NOTE: The Intersection File consists of variable length records ranging from 228-1204 bytes each, depending on the number of intersecting routes and legs.  Each record consists of a fixed-length "general" portion with variables describing the entire intersection (e.g.,"General Environment", "Traffic Control Device"), and a variable length portion which describes up to six segments (routes), and up to two legs (approaches) for each segment.  Variables for segments include such variables as "Route Number" and "Number of Legs", and variables for each leg include multiple years of AADT information and "Number of Approach Thru Lanes."  This variable-length record has been converted into a SAS-formatted, fixed length record for ease of use.  In this conversion, each variable for every possible leg on each route had to be given a separate SAS variable name.  The listing below includes the SAS names for all "general" variables and example names for the route-specific and leg-specific variables.  Unlike the other file descriptions, for clarity, the variables are primarily listed in raw-file order rather than alphabetical order.

"GENERAL" VARIABLES

SEGMENT (ROUTE) SPECIFIC VARIABLES

NOTE: Variables for Segments 2-6 would be identical, with last character denoting the Segment number (e.g., RTESYS2, RTESYS3, etc.)

LEG (APPROACH) SPECIFIC VARIABLES

NOTE: Variables for all other Legs would be identical.  The first numerical character at the end of each variable denotes the segment number, the second numerical character denotes the leg number, and the third numerical character (if present) denotes the year of the data.  For example, DIRECT21 would denote the direction variable for segment 2, leg 1. In like fashion, AADT223 would denote the AADT for segment 2, leg 2, year 3.

"GENERAL" VARIABLES

SAS FORMAT DEFINITIONS FOR "GENERAL" VARIABLES FROM THE MINNESOTA INTERSECTION/INTERCHANGE FILE

NOTE: SAS variable names and explanatory names are shown above each listing. (See Discussion for information on SAS formats.)

RTE_SYS

ROUTE SYSTEM

• '01' = 'ISTH - Interstate trunk highway'
• '02' = 'USTH - U.S. trunk highway'
• '03' = 'MNTH - Minnesota trunk highway'
• '04' = 'CSAH - County state-aid highway'
• '05' = 'MSAS - Municipal state-aid highway'
• '07' = 'CNTY - County road'
• '08' = 'TWNS - Township road'
• '09' = 'UTWN - Unorganized township road'
• '10' = 'MUN - City streets'
• '11' = 'NATP - National park road'
• '12' = 'NFD - National forest development road'
• '13' = 'IND - Indian reservation road'
• '14' = 'SFR - State forest road'
• '15' = 'SPRK - State park road'
• '16' = 'MIL - Military road'
• '17' = 'NATM - National monument road'
• '18' = 'NATW - National wildlife refuge road'
• '19' = 'FRNT - Frontage road'
• '20' = 'SGAM - State game preserve road'
• '21' = 'PRV RD PUBLIC - Private road open to public'
• '23' = 'ALLEY/CEMTERY - Alleys and cemeteries'

RTE_NBR

ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: 'NNNNNNNNX' = ROUTE NUMBER (N=0-9, and X is numeric, alpha, or blank.  Note that in a few cases with county/township roads, an alpha character will appear in other columns.) This variable is used for file linkage * see INT_SYNB.

INT_SYNB

COMBINED RTE_SYS/RTE_NBR

NON-LABELED VARIABLE

NOTE: This is a combined version of the RTE_NBR and RTE_SYS variables above.  This combining was done to facilitate computer linkage with other files.

MILEPOST

MODIFIED REFERENCE POINT LOCATION

NON-LABELED VARIABLE

NOTE: (1) This is a reformatted version of the original "Reference Point" variable in the MN files.  The reformatting was done to facilitate computer linkage with other files.

(2) Variable discontinued in 2001.

REF_PNT

REFERENCE POINT

NON-LABELED VARIABLE

NOTE: Reference point location - Reformatted to MILEPOST for linkage.

ELEM_NBR

INTERCHANGE ELEMENT CODE

NON-LABELED VARIABLE

NOTE: The reader should first see the Note under INT_TYPE below. ELEM_NBR is a three-character variable giving the code for interchange elements (e.g., mainline between ramps, exit ramp, intersection at ramp terminal on crossing roadway, etc.)  These codes are only present for a subset of interchanges in the file - primarily diamond interchanges - and denote that this record is a supplemental record for this interchange.  They are retained in the file to assist in linking accidents to specific interchange elements within these diamond interchanges -- the same code is found in the Accident File.  The coding is either "ANN" or "NNN", where "A" is alpha and "N" is numeric. The formats for the possible codes (i.e., possible interchange element types) is very complex. It is not presented here, but can be obtained from HSIS staff.

ENDMP

CALCULATED ENDING MILEPOST

NON-LABELED VARIABLE

NOTE: The calculated ending milepost. See Discussion. Variable added in 2001.

INT_TYPE

INTERSECTION TYPE

• 1 = 'INTERCHANGE'
• 2 = 'Intersection within interchange'
• 3 = 'INTERSECTION'
• 4 = 'Mid-Block pedestrian crossing'
• 5 = 'Railroad crossing'
• 6 = 'Recreational crossing'

NOTE: (1) As detailed in the earlier Discussion, basic intersections (i.e., those not part of an interchange) are coded as "3".  Each interchange will have a record in the file coded as INT_TYPE = "1". In addition, some interchanges (primarily diamond interchanges) will have supplemental records in the file which will have the same milepost as the type "1" record (and the same general descriptors), but which will be coded as type "2" -- intersections within an interchange.  These type "2" supplemental records will also have an Interchange Element Code as a further identifier.  See ELEM_NBR above.

(2) AADT data for “Type 2 = Intersection within interchange” are not updated on a regular basis. Contact HSIS staff for more information.

DESC_

INTERSECTION DESCRIPTION

NON-LABELED VARIABLE

NOTE: (1) Due to its complexity in the Minnesota raw files, this variable was reformatted into TYPEDESC (see below).

(2) Variable discontinued in 2001.

TYPEDESC

INTERSECTION DESCRIPTION-REVISED

• 10 = 'Other Interchange'
• 11 = 'Diamond Interchange'
• 12 = 'Half Diamond Interchange'
• 13 = 'Folded Diamond Interchange'
• 14 = 'Other Diamond Interchange'
• 15 = 'Trumpet Interchange'
• 16 = 'Cloverleaf Interchange'
• 17 = 'Partial Directional Interchange'
• 18 = 'Full directional Interchange'
• 19 = 'Complex Interchange'
• 20 = 'Other Intersection'
• 21 = 'Diamond Intersection'
• 22 = 'Half Diamond Intersection'
• 23 = 'Folded Diamond Intersection'
• 24 = 'Other Diamond Intersection'
• 25 = 'Trumpet Intersection'
• 26 = 'Cloverleaf Intersection'
• 27 = 'Partial Directional Intersection'
• 28 = 'Full directional Intersection'
• 29 = 'Complex Intersection'
• 31 = 'Tee Intersection'
• 32 = 'Wyee Intersection'
• 33 = 'Crossing at Right Angles Intersection'
• 34 = 'Crossing Skewed Intersection'
• 35 = 'Greater than four leg Intersection'
• 41 = 'School or Pedestrian Crossing'
• 42 = 'Central Business District Crossing'
• 43 = 'Other Crossing'
• 51 = 'Single Track, Right Angle Railroad Crossing'
• 52 = 'Single Track, Skewed Railroad Crossing'
• 53 = 'Multi-Track, Right Angle Railroad Crossing'
• 54 = 'Multi-Track, Skewed Railroad Crossing'
• 60 = 'Recreational Crossing-Not Applicable'

NOTE: In some cases, intersection types denoted by codes 20-34 will not match exactly with information on number of legs in the NBR_LEGS variable.  The Minnesota Department of Transportation has been notified of this problem and it should be corrected in data in future years.

RAIL_NBR

RAILROAD CROSSING NUMBER

NON-LABELED VARIABLE

NOTES: (1) '        ' = 'NOT STATED', 'NNNNNNNA' = Railroad crossing number.

(2) No data available since 1997.

TRAF_DEV

TRAFFIC CONTROL DEVICES

NON-LABELED VARIABLE

NOTE: Due to its complexity in the Minnesota raw files, this variable was reformatted into TRF_CNTL (see below).

TRF_CNTL

TRAFFIC CONTROL DEVICES-REVISED

• 10 = 'Not applicable'
• 11 = 'Unsignalized Ramp Terminals'
• 12 = 'Signalized Ramp Terminals'
• 21 = 'No Interchange'
• 22 = 'Thru/Yield Interchange'
• 23 = 'Thru/Stop Interchange'
• 24 = 'All Stop Interchange'
• 25 = 'Flashers - Amber/Red Interchange'
• 26 = 'Flashers - Red/Red Interchange'
• 27 = 'Signalized Interchange'
• 28 = 'Other Interchange'
• 31 = 'No Intersection'
• 32 = 'Thru/Yield Intersection'
• 33 = 'Thru/Stop Intersection'
• 34 = 'All Stop Intersection'
• 35 = 'Flashers - Amber/Red Intersection'
• 36 = 'Flashers - Red/Red Intersection'
• 37 = 'signalized Intersection'
• 38 = 'Other Intersection'
• 41 = 'Mid-block pedestrian crossing - Pavement marking and signing'
• 42 = 'Mid-block pedestrian crossing - Flasher - pedestal mount'
• 43 = 'Mid-block pedestrian crossing - Flasher - overhead'
• 44 = 'Mid-block pedestrian crossing - Signal'
• 51 = 'Crossbuck plus RXR'
• 52 = 'Crossbuck plus RXR plus other warning signs'
• 53 = 'Crossbuck plus stop sign'
• 54 = 'Railroad crossing signal w/o gates - Pedestal mount'
• 55 = 'Railroad crossing signal w/o gates - Cantilever'
• 56 = 'Railroad crossing signal w/gates - Pedestal mount'
• 57 = 'Railroad crossing signal w/gates - Cantilever'
• 58 = 'Other or None'
• 60 = 'Recreational Crossing Not Applicable'

NOTE: Variable discontinued in 2001.

SIGN_PRO

TRAFFIC SIGNALS PROGRESSION

• 0 = 'NOT APPLICABLE'
• 1 = 'Not in progression system'
• 2 = 'In progression system'

SIGN_TIM

TRAFFIC SIGNALS TIMING

• 0 = 'NOT APPLICABLE'
• 1 = 'FIXED TIME'
• 2 = 'ACTUATED'

SIGN_CON

TRAFFIC SIGNALS CONSTRUCTION

• 0 = 'NOT APPLICABLE'
• 1 = 'TEMPORARYTemporary (includes wood poles)'
• 2 = 'PERMANENT'

SIGN_PLA

SIGNAL HEAD PLACEMENT

• 0 = 'NOT APPLICABLE'
• 1 = 'PEDESTRIAN MOUNT ONLY'
• 2 = 'OVERHEAD'

SIGN_PED

TRAFFIC SIGNALS PEDESTRIAN SIGNALS

• 0 = 'Not applicable'
• 1 = 'No pedestrian signals'
• 2 = 'Pedestrian signals - Not pedestrian actuated'
• 3 = 'Pedestrian signals - Pedestrian actuated - Walk with green'
• 4 = 'Pedestrian signals - Pedestrian actuated - Scramble system'

TRAF_TMO

FLASHING SIGNAL TIME ON

• '  ' = 'NOT APPLICABLE'
• '00' = 'Not on parttime flash system'
• '01'-'24' = 'Time parttime flash system begins'

TRAF_TMF

FLASHING SIGNAL TIME OFF

• '  ' = 'NOT APPLICABLE'
• '00' = 'Not on parttime flash system'
• '01'-'24' = 'Time parttime flash system TERMINATES'

TRAF_PHS

TRAFFIC SIGNALS NUMBER OF PHASES

• 0 = 'NOT APPLICABLE'
• 2 = 'TWO PHASES'
• 3 = 'THREE PHASES'
• 4 = 'FOUR PHASES'
• 5 = 'FIVE PHASES'
• 6 = 'SIX PHASES'
• 7 = 'SEVEN PHASES'
• 8 = 'EIGHT PHASES' 

TRAF_PRE

TRAFFIC SIGNALS PREEMPTION

• 0 = 'NOT APPLICABLE'
• 1 = 'NO PREEMPTION'
• 2 = 'RAILROAD ONLY'
• 3 = 'Emergency vehicle only - Vehicle actuated'
• 4 = 'Emergency vehicle only - Hard wire'
• 5 = 'BUS ONLY'
• 6 = 'Railroad and emergency vehicle'
• 7 = 'Railroad and bus'
• 8 = 'Emergency vehicle and bus'
• 9 = 'Railroad & emergency vehicle & bus'

RDWY_LGH

ROADWAY LIGHTING

• 1 = 'NONE'
• 2 = 'PARTIAL'
• 3 = 'FULL'
• 4 = 'CONTINUOUS'
• 5 = 'Partial (energy conservation program)'
• 6 = 'Full (energy conservation program)'
• 7 = 'Continuous (energy conservation program)'
• 8 = 'POINT LIGHTING'

GEN_ENIV

GENERAL ENVIRONMENT

• 1 = 'URBAN'
• 2 = 'SUBURBAN'
• 3 = 'CITY BYPASS'
• 4 = 'RURAL'

SPEC_ENV

SPECIFIC ENVIRONMENT

• 01 = 'Central business district'
• 02 = 'Strip commercial area'
• 03 = 'Shopping center'
• 04 = 'Industrial area'
• 05 = 'Residential area'
• 06 = 'School or school crossing'
• 07 = 'Agriculture and isolated business/school'
• 08 = 'Agriculture'
• 09 = 'Emergency service (hospital, fire station, or police)'
• 10 = 'Forest'
• 11 = 'Park or campground'
• 12 = 'Other recreational area (e.g., golf course)'
• 13 = 'Elderly or handicapped'
• 14 = 'OTHER'

DIST_CAT

CATEGORY ASSIGNED BY DISTRICT

NON-LABELED VARIABLE

NOTE: Intersection/interchange category assigned by individual districts only limited use, and no format available.

CNTL_CAT

CENTRAL OFFICE CATEGORY

NON-LABELED VARIABLE

NOTE: '  ' = No category assigned by central office.

'01' - '99' = Category assigned by central office.

SFTY_IMY

SAFETY IMPROVEMENT YEAR

NON-LABELED VARIABLE

NOTE: Safety improvement year where '  ' = No safety improvement,

'70' - 'XX' = Year of improvement.

SFTY_IMD

SAFETY IMPROVEMENT DISTRICT

NON-LABELED VARIABLE

NOTE: ' ' = 'No safety improvement', '1' - '9' = District responsible for improvement.

SFTY_PRJ

SAFETY IMPROVEMENT PROJECT NUMBER

NON-LABELED VARIABLE

NOTE: '  ' = ' No safety improvement ', '01' - '99' = Project number assigned.

SFTY_CLS

SAFETY IMPROVEMENT CLASSIFICATION

NON-LABELED VARIABLE

NOTE: '  ' = ' No safety improvement ', '01' - '99' = Safety improvement code.

EFEC_DTE

DATE OF ACCIDENT GEOCODING

NON-LABELED VARIABLE

NOTE: 0=Accident data coded since system startup, YYMMDD=Date from which accident data are geocoded to intersection.

NBR_RTES

NUMBER OF ROUTES INTO INTERSECTION

NON-LABELED VARIABLE

NOTE: 1-9 = Number of routes involved.

NBR_LEGS

NUMBER OF LEGS INTO INTERSECTION

NON-LABELED VARIABLE

NOTE: 1-9 = Number of legs in intersection.

TRAFCNTL

TRAFFIC CONTROL DEVICES

• 10 = 'NOT APPLICABLE'
• 11 = 'UNSIG RAMP TERM'
• 12 = 'SIGNAL RAMP TERM'
• 21 = 'NONE INTERCHANGE'
• 22 = 'THRU YIELD INCHG'
• 23 = 'THRU STOP INCHG'
• 24 = 'ALL STOP INCHG'
• 25 = 'FLS AMB/RD INCHG'
• 26 = 'FLS RED/RED INCH'
• 27 = 'SIGNALS INCHG'
• 28 = 'OTHER INCHG'
• 31 = 'NONE INTERSECTON'
• 32 = 'THRU YIELD INTER'
• 33 = 'THRU STOP INTER'
• 34 = 'ALL STOP INTER'
• 35 = 'FLS AMB/RD INTER'
• 36 = 'FLS RED/RED INTE'
• 37 = 'SIGNALS INTER'
• 38 = 'OTHER INTER'
• 41 = 'MDBK PED-MRK/SGN'
• 42 = 'MDBK PED-PST FLS'
• 43 = 'MDBK PED-OVH FLS'
• 44 = 'MDBK PED-SIGNAL'
• 51 = 'RR XBUCK+RRX'
• 52 = 'RR XBUCK+RXR+WRN'
• 53 = 'RR XBUCK+STOPSGN'
• 54 = 'RR SIG ONLY PDST'
• 55 = 'RR SIG ONLY CANT'
• 56 = 'RR SIG/GATE PDST'
• 57 = 'RR SIG/GATE CANT'
• 58 = 'RR OTHER/NONE'
• 60 = 'REC CRS NOT APPL'

NOTE: Variable added in 2001.

SEGMENT (ROUTE) SPECIFIC VARIABLES

NOTE: Variables for Segments 2-6 would be identical, with last character denoting the Segment number (e.g., RTESYS2, RTESYS3, etc.)

SAS FORMAT DEFINITIONS FOR SEGMENT-RELATED VARIABLES FROM THE MINNESOTA INTERSECTION/INTERCHANGE FILE

NOTE: SAS variable names and explanatory names are shown above each listing. (See Discussion for information on SAS formats.)

RTESYS1

ROUTE SYSTEM - ROUTE 1

• '01' = 'ISTH - Interstate trunk highway'
• '02' = 'USTH - U.S. trunk highway'
• '03' = 'MNTH - Minnesota trunk highway'
• '04' = 'CSAH - County state-aid highway'
• '05' = 'MSAS - Municipal state-aid street'
• '07' = 'CNTY - County road'
• '08' = 'TWNS - Township road'
• '09' = 'UTWN - Unorganized township road'
• '10' = 'MUN - City streets'
• '11' = 'NATP - National park road'
• '12' = 'NFD - National forest development road'
• '13' = 'IND - Indian reservation road'
• '14' = 'SFR - State forest road'
• '15' = 'SPRK - State park road'
• '16' = 'MIL - Military road'
• '17' = 'NATM - National monument road'
• '18' = 'NATW - National wildlife refuge road'
• '19' = 'FRNT - Frontage road'
• '20' = 'SGAM - State game preserve road'
• '21' = 'PRV RD PUBLIC - Private road open to public'
• '23' = 'ALLEY/CEMTERY - Alleys and cemeteries'

NOTE: This variable is used in linkage to other files.  See Note under REFPNT1 below.

RTENBR1

ROUTE NUMBER - ROUTE 1

NON-LABELED VARIABLE

NOTE: 'NNNNNNNNX' = ROUTE NUMBER (N=0-9, and X is numeric, alpha, or blank.  Note that in a few cases with county/township roads, an alpha character will appear in other columns.) This variable is used for file linkage. See REFPNT1. 

REFPNT1

REFERENCE POINT-ROUTE 1

NON-LABELED VARIABLE

NOTE: Reference point location on Route number 1. In over 97% of the cases, Route 1 is usually the "primary" route used for general intersection location.  Thus, RTESYS1 and RTENBR1 is usually the same as RTE_SYS and RTE_NBR, and REFPNT1 is the same as REF_PNT.  For the crossing roads, RTESYS2, RTENBR2 and REFPNT2 will be used for the first crossing route, RTESYS3, etc. for the second crossing route, etc.  While the original REF_PNT was converted to MILEPOST for ease of computer linkage, REFPNT1-X has not been converted.  However, HSIS staff has developed a computer program to allow linkage of these crossing routes with other files.  The user can request the program or variables from the linked files from our staff.

RDESC1

ROAD DESCRIPTION

• 1 = '2 lanes 2-way'
• 2 = '3/5 lanes undivided (2-way with left turn lane)'
• 3 = '4/6 lanes undivided (no left turn lanes)'
• 4 = '4/6 Lanes undivided (with left turn lanes)'
• 5 = '4/6 lanes divided (no left turn lanes)'
• 6 = '4/6 lanes divided (with left turn lanes)'
• 7 = 'One-way'
• 8 = 'Freeway'
• 9 = 'Other'

NOTE: Coding for this variable is somewhat questionable since two identical intersections may be coded into different categories.  Specifically, it appears that the number of lanes shown at the first of each category (e.g., "3/5," or "4/6") could be interpreted by the district coders as either the total number of lanes (counting left-turn lanes) or the total number of through lanes.  The main problem appears to be in categories "2" and "4."

Here, for example, an undivided four-lane roadway with opposing left-turn lanes at the intersection might be coded as a category "2" or a category "4."  It also appears that category "6" is a rather broad category.  Here, all divided roadway with a median continuing up to the intersection proper which have four or more through lanes and either single or double left-turn lanes would be coded as a "6."   

LOLIMT1

SEGMENT 1 LOWER LIMIT

NON-LABELED VARIABLE

NOTE: Lower reference point limit: 0000-9999 = Dist. in ft from intersection towards beginning of route used as lower search limit for accident occurrences.

UPLIMT1

SEGMENT 1 UPPER LIMIT

NON-LABELED VARIABLE

NOTE: Upper reference point limit: 0000-9999 = Dist. in ft from intersection towards end of route used as upper search limit for accident occurrences.

NBR_LEG1

NUMBER OF LEGS ON SEGMENT 1

NON-LABELED VARIABLE

NOTE: Number of legs described in this record: 1-2 = Number of legs.

LEG (APPROACH) SPECIFIC VARIABLES

NOTE: Variables for all other Legs would be identical.  The first numerical character at the end of each variable denotes the segment number, the second numerical character denotes the leg number, and the third numerical character (if present) denotes the year of the data.  For example, DIRECT21 would denote the direction variable for segment 2, leg 1. In like fashion, AADT223 would denote the AADT for segment 2, leg 2, year 3.

SAS FORMAT DEFINITIONS FOR LEG-RELATED VARIABLES FROM THE MINNESOTA INTERSECTION/INTERCHANGE FILE

NOTE: SAS variable names and explanatory names are shown above each listing. (See Discussion for information on SAS formats.)

LEGNBR11

SEGMENT 1, LEG NUMBER 1

NON-LABELED VARIABLE

NOTE: Leg number of first leg: 0 = 'NOT APPLICABLE', 1-12 = Number assigned.

DIRECT11

SEGMENT 1, LEG 1 DIRECTION

• 0 = 'NOT APPLICABLE'
• 1 = 'NORTH'
• 2 = 'NORTHEAST'
• 3 = 'EAST'
• 4 = 'SOUTHEAST'
• 5 = 'SOUTH'
• 6 = 'SOUTHWEST'
• 7 = 'WEST'
• 8 = 'NORTHWEST'

AADT111

SEGMENT 1, LEG 1, YEAR 1 AADT 

NON-LABELED VARIABLE

NOTE: 000000 = Not applicable or no traffic, 000001-999999 = 2-way volume on leg, most recent available year.

Most AADT's are probably not current.  The user can determine which year the AADT was collected for each leg from the "AADT Year" variable attached to each leg.  However, we have found that the "AADT Year" will seldom be the current (file) year, and that the year of the AADT count can be different for different legs of the same intersection.  Unfortunately, we cannot suggest a method for "updating" the AADT data to later years.  Since multiple years data are often shown in the file, the user may be able to develop a "trend-related update", but we cannot assure that the estimates will be correct.

ADTYR111

SEGMENT 1, LEG 1, YEAR 1

NON-LABELED VARIABLE

NOTE: Year AADT111 was collected: 'YY' or YY = Last two digits of year, '  ',' 0','00', 0, or blank = No AADT available.

This variable can either be a numeric or a character variable.

AADT112

SEGMENT 1, LEG 1, YEAR 2 AADT

NON-LABELED VARIABLE

NOTE: See AADT111 above.

ADTYR112

SEGMENT 1, LEG 1, YEAR 2

NON-LABELED VARIABLE

NOTE: See AADT111 above.

AADT113

SEGMENT 1, LEG 1, YEAR 3 AADT

NON-LABELED VARIABLE –- See AADT111 above.

NON-LABELED VARIABLE

NOTE: See AADT111 above.

ADTYR113

SEGMENT 1, LEG 1, YEAR 3

NON-LABELED VARIABLE

NOTE: See AADT111 above.

AADT114

SEGMENT 1, LEG 1, YEAR 4 AADT

NON-LABELED VARIABLE

NOTE: See AADT111 above.

ADTYR114

SEGMENT 1, LEG 1, YEAR 4

NON-LABELED VARIABLE

NOTE: See AADT111 above.

AADT115

SEGMENT 1, LEG 1, YEAR 5 AADT

NON-LABELED VARIABLE

NOTE: See AADT111 above.

ADTYR115

SEGMENT 1, LEG 1, YEAR 5

NON-LABELED VARIABLE

NOTE: See AADT111 above.

AP_SPD11

SEGMENT 1, LEG 1, APPROACH SPEED LIMIT

NON-LABELED VARIABLE

NOTE: 00 = 'UNKNOWN', 01-70 = Approach speed in MPH.

APCNTL11

SEGMENT 1, LEG 1, APPROACH TRAFFIC CONTROL

If INT_TYPE (intersection type) is anything except a

Railroad grade crossing (i.e., INT_TYPE ne 5):

• 0 = 'NOT APPLICABLE'
• 1 = 'Through or one-way leaving intersection'
• 2 = 'YIELD SIGN'
• 3 = 'STOP SIGN'
• 4 = 'FLASHER - AMBER'
• 5 = 'FLASHER - RED'
• 6 = 'SIGNAL'

If INT_TYPE is railroad grade crossing (i.e., INT_TYPE = 5):

• 0 = 'RR NOT APPLCABLE'
• 1 = 'Crossbuck plus RXR sign'
• 2 = 'Crossbuck plus RXR plus other warning sign'
• 3 = 'Crossbuck plus stop sign'
• 4 = 'Crossing signal w/o gates - Pedestal mount'
• 5 = 'Crossing signal w/o gates - Cantilever'
• 6 = 'Railroad crossing signal w/gates - Pedestal mount'
• 7 = 'Railroad crossing signal w/gates - Cantilever'
• 8 = 'Railroad crossing other or no protection'