HIGHWAY SAFETY INFORMATION SYSTEM GUIDEBOOK FOR THE OHIO 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

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

The Ohio data system that is provided to HSIS includes the following basic files:

Data from all of these files are captured by HSIS. Raw file data are provided to the Highway Safety Research Center 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 is available at FHWA offices. The conversion programs developed by HSRC and LENDIS to convert the files into SQL and SAS formats are also available at the HSIS offices at FHWA.

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 California 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. 

As noted above, the SAS accident data is 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 in each accident case. The vehicle and occupant data can be linked to the basic accident data for specific cases using the accident case number. The accident subfile can be linked to the Roadlog file using three common variables – county, route number, and milepost.

Unlike an Accident file record that is referenced to a point on the roadway, each record on the Roadlog file contains information on a homogenous section of the roadway (i.e. a stretch of road which is consistent in terms of certain 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. Information on curves and grades is captured in separate curve and grade files. The Curve File has data on all horizontal curves while the Grade File has information on grades greater than 3 percent. For curves having a degree of curvature greater than 90 degrees, Ohio designates them as “angle points” and that data is captured in a separate Angle Point File. Ohio doesn’t maintain a separate intersection inventory file. However, a “Points” file is available that contains point descriptors for a number of items including at-grade intersections, overpasses, underpasses, bridges etc.

Details of these accident and roadlog files are presented in the following section.

DETAILS OF MAJOR FILES

The Accident Files

An accident is reported if it involves a personal injury or total property damage of $400 or more. However, in some cases crashes with damages below $400 are also recorded on accident report forms. The Ohio State Highway Patrol (SHP) and the local sheriff’s offices do most of the crash reporting in Ohio. Ohio doesn’t include accidents reported by citizens in their system. All police reports statewide are sent to the Ohio Department of Public Safety. Prior to 1997, the Department of Public safety was responsible for keypunching and location coding the accidents (after performing QC checks). After 1997, this task was outsourced to private contractors. (Note that 1997 is the first year of Ohio data in the HSIS system.)

All agencies across Ohio use the same accident report form to report accidents. A new form with major changes was introduced in 2000. In addition to this, as noted above, the State Highway Patrol began to outsource the data coding to private contractors in 1997.

Approximately 380,000 crashes occur in Ohio statewide each year. The HSIS data set contains a subset of these accidents that occurred on the state-inventoried system. This data set includes approximately 150,000 accidents per year, approximately 270,000 vehicles per year and approximately 370,000 occupants per year. Police officers reporting accident locate them within 0.01 miles of a given milepost. There are physical mileposts available on all rural state routes and some county routes, and on Interstates in all incorporated areas. It is estimated that about 10% of the accidents in the accident subfiles cannot be matched to segments on the roadlog file. Ohio DOT suspects outsourcing of the location coding to be the main reason for this. Since the majority of the HSIS analyses involve linkage with roadway data, a decision was made to delete these accidents from the accident subfiles.  This results in approximately a 10 percent reduction in the total number of accidents (and vehicle and occupants) in the files.

In general, Ohio accident files capture information on all relevant variables. Our discussions with Ohio DOT staff revealed that they think the police make some errors in coding the angle, left turn, and head on crashes at intersections.  They expect the new accident report forms being used in 2000 and later correct this shortcoming since it provides a sequence of events and pre-crash maneuvers/directions. Also, due to the change in accident report form in 2000, a number of variables has been changed or added in the Ohio accident files in subsequent years.

Approximately 75 percent of the accidents on the linkable file are property damage only and less than 0.5 percent are fatal accidents. Approximately 70 percent vehicles are multi-vehicle in nature, while the remaining 30 percent are single-vehicle accidents of one type or the other.

An assessment of the completeness and accuracy of the data is based on conversations with OH staff and a series of single-variable tabulations run each year for key analysis variables. These quality-control runs allow the HSIS staff to examine both the percent uncoded for each variable and changes across time in the individual codes within each key variable. These yearly runs are performed on all formatted variables.  These runs have consistently indicated that almost all of the variables in the three subfiles have very few uncoded and very few error codes. Where high numbers of uncoded cases or inconsistencies in codes are found, a “NOTE” has been included under the pertinent variable in the later SAS format sections.

In addition to the quality-control checks noted above, in order to further check the accuracy of some of the accident variables, a series of comparisons were made of variables that should have been somewhat similar on the accident subfiles according to their definitions (both within the same subfiles and across subfiles). For example, NUMPEDS variable is populated largely only when ACCTYPE is pedestrian. Again, if there are any cases in which variables are either less than totally consistent with other variables or have changed across time, a “NOTE” will be included in the SAS formats section that follows.

The Roadway Inventory Files

The Ohio roadway inventory files contain current characteristics of the state road system for each year. These data are divided into five files within the HSIS system. The first is the basic roadway characteristics file (i.e. the “Roadlog”) containing information on the roadway mainline cross-section. The second is a Curve File, which contains information on each horizontal curve on any inventoried segments (except for curves of degree greater than 90 – see below). The third is the Grade File, which contains information on each vertical grade that is greater than 3 percent. Fourth is the Angle Points File, which has information on those curves that have a degree of curvature greater than 90 degrees. And fifth is the Points File, which contains point descriptors for a number of items such as at-grade intersections, railroad grade-crossings, etc. Ohio provides the curve and grade information in a single inventory file named “State Supplemental Inventory.”  HSIS staff processes this inventory file and creates three separate files -- the curve file, the grade file and the angle point file. All the roadway inventory files are developed by the ODOT staff based on as-built plans. Updates on the file are done based on the respective project plans. In general the ODOT Roadway inventory office feels that the data is quite accurate.

The Roadlog File

The ODOT Roadway Inventory section of the Office of Technical services is responsible for maintaining inventory of all public highway in Ohio, about 116,000 miles in total. Of these, there is detailed inventory information on approximately 19,500 miles of roadway, which is captured by HSIS and is shown in Table 1 below. This includes all functional classes of roads within the state system – Freeways, Arterials and collector, both rural and urban. This file contains information on approximately 1,500 miles of Interstates, 4,000 miles of U.S. Routes and 14,000 miles of State Routes. Currently there are nine roadlog inventory files in the HSIS system, 1997 – 2005. Because a new record is generated each time any of the items in the file changes, the sections that are generated are fairly short, resulting in a large number of individual records. The approximately 19,500 miles of inventory information is divided into approximately 29,000 records, resulting in an average section length of 0.67 miles.

Table 1.  HSIS roadway mileage by roadway category (2005 data).
Roadway Category Mileage
Urban freeways 1,262.87
Urban freeways < 4 Lanes 24.03
Urban multilane divided non-freeways 445.06
Urban multilane undivided non-freeways 947.76
Urban 2 In highways 2,259.90
Rural freeways 722.54
Rural freeways < 4 Ins 0.43
Rural multilane divided non-freeways 944.92
Rural multilane undivided non-freeways 137.91
Rural 2 In highways 12,775.60
Other 1.28
Total 19,522.30

The file contains general cross section information related to travel way widths (indicated by surface widths and roadway widths), number of lanes, median width and other variables. All standard cross-section variables appear to be present except for individual measures of shoulder width (paved and unpaved) and shoulder type for each side (inside and outside) of the roadway in the 1997-2000 data.  For these years, the total shoulder width for both sides can be calculated based on “Surface Width” and “Roadway Width” but not distributed to each side. From 2001 onwards, new variables are added that give inside and outside shoulder widths. Thus it is important to note here that the shoulder width variables available in the HSIS file are not populated for 1997 – 2000 data.

It is noted that in some cases, OH data has two different variables providing the same information. For example, surface type is described by the two different variables SURF_TYP and SRF_TYPF. This is because OH collects some additional variables that are required by FHWA for HPMS reporting or other purposes. Data analysis by HSIS staff and conversations with ODOT staff revealed that in general, where two variables explain the same characteristic, the non-FHWA required variable is more detailed and reliable due to the updating system. The only exception is for “access control,” where ODOT recommended the use of the FHWA variable. Appropriate notes are provided under each of these variables in the formats section that follows.

Unlike most states, OH data contains both the standard location variables -- County / Route / Beginning and Ending Mileposts -- and a link/node linear referencing system for each segment.  However, since the crashes do not have link/node indicators, county/route/milepost is still used to locate the crashes on an individual roadway segment. The link/node referencing system allows the state to track and update information easily and accurately.

Traffic information in the form of Average Daily Traffic is included for each section on the file. This information is covered by three variables -- total AADT, AADT for passenger cars and trucks type A; and AADT for truck types B and C. A detailed description of the traffic count procedures in included below in the section “Traffic Monitoring Procedures.”  

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 inquiries from data users, whose most frequent questions have concerned either crash frequencies or rates (per MVMT) for one or more of these roadway classes.

To assess the accuracy of roadway inventory variables in this roadlog file and the related files concerning points, curves and grades, we questioned the ODOT staff and examined a series of single-variable tables for key variables in each of the files. The ODOT staff feels that the overall quality of the variables in all the three files is very high. It should be noted that the data developed by ODOT is based on as-built plans and is updated systematically each year. Project plans are used for these updates. In addition, a field person in each highway district completes a “field sheet” to verify changes in the system each year and these are sent to the Roadway Inventory group for use in the computer file updates.  This is a more extensive update system than in most HSIS states.

In addition to information received from ODOT staff, single-variable tabulations were run to examine the questions of reporting completeness and data accuracy. Here, study of percentage of “unknown”, “not applicable” and “not stated” values for more than 30 key variables in the Roadlog file indicate that, in general, the data are coded to a high degree of completeness. For most variables, there were no missing data. The data also appear to be quite consistent across years, and similar variables appear to have similar values. We also attempted to determine if there was consistency between pairs of similar variables found in the Inventory File.  In general, there was.  For example, the total mileage for divided highways appeared to be consistent with total mileage for segments having a valid median width. Notes are included for those few variables that were found to be inconsistent in the format section of the guidebook. 

In general, based on both the interviews and the data comparisons conducted, the data are felt to be quite accurate. In the limited number of cases where possible inaccuracies or missing values were found or where more detailed definitions might be critical in future analyses, notes are included under the specific variables in the later format section.

The Curve File

The Curve File contains information on all horizontal curves present on the 19,500 miles of inventoried data present in the roadlog file. The total length of all curves present in this file is about 1,150 miles, which is captured by approximately 18,500 records, resulting in an average curve length of approximately 0.06 miles. The file currently contains information on curve length, degree of curve and direction of curve. The inventory group is currently examining the possibility of collecting ball-bank data for future inclusion. A segment on this file can be located using the begin milepost, end milepost, county, route number and station equation information – similar to the roadlog file. Again, as-built plans are used to create this file and project plans to update information, similar to what is followed for all the five roadway inventory files. Our discussions with Ohio staff indicated that, though the quality of data may be slightly inferior compared to the cross-section data, it is free of any major shortcomings.

The Grade File

The Grade File has information on all vertical grades greater than 3 percent. Total length of all grades present in this file is about 2,340 miles, which is captured by approximately 20,000 records, resulting in an average grade length of approximately 0.11 miles. The file currently contains information on the grade length, direction of grade and percent of grade. This file can be linked to the other files using the same location variables – county, route number, begin milepost, end milepost and station equation. Since the curve file and grade file are developed from the same inventory, the way in which these files are created and updated and the data quality are similar.

The Angle Points File

Sharp horizontal curves having degree of curvature greater than 90 degrees are designated by ODOT as “angle points”. All variables and the manner in which the file is developed remain similar to that of the Curve File. While even these sharp curves would have some curve length in reality, the segment length in this file is set to zero for all the records.

The Points File

Ohio doesn’t have a computerized intersection inventory file but has a “Points” file that contains point descriptors for a number of features including at-grade intersections, overpasses, underpasses, bridges, railroad crossings etc.  The file has approximately 58,000 intersections, 4,500 interchanges, 5,000 bridges and 1,800 railroad crossings.

For intersections and interchanges, the file contains a mainline milepost for all state-system crossing routes (i.e., all intersections or interchanges where an Interstate, State Route or U. S. Route crosses an Interstate, State Route or U. S. Route), and a mainline milepost for many intersections where a state-system road intersects with a county or local road or street.  ODOT staff is continually updating the file by adding additional intersections with city or county crossing roads, but the file cannot be yet considered a census of all intersections. For all intersection of two state-system roads, there is location information for both the mainline and the crossing route, which makes it possible to link to roadlog inventory information (and accident information) on both intersecting routes. There is no information on signalization, channelization, type of intersections/interchanges etc. Ohio is making efforts to include this information in the future. There are approximately 200 interstate-to-interstate junctions, 6,000 state-to-state and 900 US route-to-US route intersections. Like all other roadway inventory file, this file has been developed from as-built plans and updated based on project plans.

Traffic Monitoring Procedures

The Traffic Monitoring Section of the Office Of Technical Services is in charge of collecting traffic counts information. This information is covered by three variables – total AADT, AADT for passenger vehicles, and AADT for medium and large trucks. These data are based on a combination of permanent counters that count traffic 24-hours each day for 365 days each year and a series of short-term counts conducted each year. Ohio has 47 automatic traffic recorders (ATRs) recording 24-hour, full-year data by vehicle class / length categories. There are 16 additional vehicle-length and classification sites, and 37 weight-in-motion sites. These data are used to develop seasonal and daily adjustment factors for the 11,500 short counts that are done on a three- year cycle. Each short count is for 48 hours. Ohio attempts to collect vehicle classification data during these short counts also. At times, only volume data is collected and the 48-hour period is shortened. In some cases only the number of axle impulses is counted. The ODOT districts are responsible for doing these short counts.

To convert the short-term coverage counts to AADT, Ohio applies adjustments for seasonal differences in the daily traffic. For seasonal corrections, each coverage count location is assigned to one of the functional classes where permanent counters are located. The seasonal factors are based on averages from all ATRs in that group. Thus Ohio adjusts short-term counts to AADT using seasonal adjustment factors for each functional class.

When a road section is not counted during a given year, annual adjustment factors are developed and applied to the most recent prior year’s count. Ohio develops two types of annual adjustment factors – one that can be applied from year to year and second that is a cumulative adjustment factor that can be applied from any given year to the current year. Average growth factors are created each year for each functional class of roadway using ATR data and data from short counts for the current year. The adjustment factor applied to a particular uncounted section is based on its functional class. For sections where no prior AADT exists, AADT/mile averages by functional class are developed and then used in order to “fill in” the AADTs.

As noted earlier, some of the short AADT counts measure only the number of axles passing a particular location. To adjust that to the actual volume at that location, axle correction factors are applied. Axle correction factors are calculated by combining data from Automatic Traffic Recorders (ATR’s) and 48-hour vehicle classification counts. An average axle correction factor is calculated for each functional classification of highway. These factors are obtained by computing the total number of axles crossing a point and dividing that by the total number of vehicles. These factors are then applied to those short term AADT counts, which collects only the number of axles to get a count of the number of vehicles passing that section.

Significant improvements have been made in the quality and coverage of traffic data since 1997. There are some location-to-location differences in vehicle classifications in the short-term counts due to difference in vendor equipment, but they are moving to standardization. In general Ohio DOT staff is confident about the quality of traffic data.

Issue Related To Merging Of Files

As noted above, the accident data are subdivided into three subfiles – accident, vehicle and occupant. The Accident and Vehicle Subfiles can be linked together using the accident report number (i.e., CASENO).  When linking the occupant subfile, the additional linking variable related to vehicle number (i.e., VEHNO) must match so that the occupants are associated with the vehicle in which they were traveling. To link vehicles with accidents, first sort both subfiles by CASENO. 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 be linked by specifying as 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 pre-sorted and the output will not be in any particular sort order unless ORDER BY is specified.

The Accident Subfile can be linked to the Roadlog File using the CNTYRTE and MILEPOST variables in the crash record, and the CNTY_RTE, BEGMP and ENDMP variables in the Roadlog File. (Note that the “station equation” is included as part of county-route in the HSIS variables.) Similarly, the accident subfiles can be linked to Curve, Grade, and Angle Points using similar variables found in each respective file. To link the Accident File and the Points File, CNTYRTE and MILEPOST variables from the Accident file are matched with CNTY_RTE and MILEPOST variables of the Points File. To extract data on the intersecting (crossing) state-system route in the Points File, the Roadlog File can be linked to the XMILEPST and XCNTYRTE variables.

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 CNTYRTE and MILEPOST on the Accident file and by CNTY_RTE 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 CNTYRTE and a range match where MILEPOST occurs between BEGMP and ENDMP. (Programs to accomplish this merging and division are available from HSIS staff at FHWA).

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

OHIO CONTACTS

State Computer files -- Tom Ramsay (614-752-5757) -- Mr. Ramsay -- is our main contact within the State of Ohio when questions arise concerning the Ohio state data files in general or the specifics of the accident data. He works within the Office of Roadway Safety and Mobility of the Ohio DOT. He should be the primary contact for all questions, and will direct questions he can’t answer to others.

Crash data and file linkage – Shirley Shokouhi (614-644-8181) -- Ms. Shokouhi --is the Systems Analyst in the Office of System Analysis and Planning who is responsible for Ohio DOT’s high crash location efforts and other safety-related analyses.  As such, she is very knowledgeable about both the crash data and the linkage of crash data with other ODOT files.

Roadway Inventory data – Joe Hausman (614-752-5732) --  Mr. Hausman is Section Manager, Roadway Inventory, within the ODOT Office of Technical Services.  He is responsible for roadway inventory operations and files for all roadways in Ohio, and is the primary contact for details of the five ODOT inventory subfiles within the HSIS system.  Additional information on the ODOT inventory data can be found at http://www.dot.state.oh.us/techservsite/offceorg/roadwayinfo/roadwayinfo.htm

COMPOSITE LIST OF VARIABLES

SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
AADT WEIGHTED AVERAGE TOTAL ADT Roadlog NUM 75
AADT_BC ADT FOR TYPE B AND C TRUCKS Roadlog NUM 75
AADT_PT ADT FOR PASSENGER CARS AND A Roadlog NUM 75
TYPE TRUCKS
AADT_YR YEAR OF ADT COUNTS Roadlog CHA(2) 76
ACC_DATE ACCIDENT DATE YYYYMMDD Accident CHA(8) 33
ACCESS ACCESS CONTROL Accident CHA(1) 33
ACCESS ACCESS CONTROL Angle Point CHA(1) 114
ACCESS ACCESS CONTROL Curves CHA(1) 102
ACCESS ACCESS CONTROL Grades CHA(1) 108
ACCESS ACCESS CONTROL Roadlog CHA(1) 76
ACCTYPE TYPE OF CRASH(FIRST HARMFUL EVENT) Accident NUM 33
ACCYR ACCIDENT YEAR Accident NUM 33
ACCYR ACCIDENT YEAR Vehicle CHA(4) 47
ACTION ACTION Vehicle NUM 47
AGE OCCUPANT AGE Inj. Occupants NUM 66
AIRBAG AIRBAG Inj. Occupants NUM 66
AIRBAG_SW AIRBAG SWITCH Inj. Occupants NUM 66
ALCOHOL_TEST_STATUS ALCOHOL TEST STATUS Inj. Occupants NUM 66
ALTSTTYP ALCOHOL TEST TYPE Inj. Occupants NUM 67
ANGLE TURN CRASH INDICATOR Accident NUM 34
ANIMAL ANIMAL TYPE Accident NUM 34
AREA_CDE AREA CODE Roadlog NUM 76
AREACODE AREA CODE Angle Point NUM 114
AREACODE AREA CODE Curves NUM 102
AREACODE AREA CODE Grades NUM 108
BAC BLOOD ALCOHOL CONTENT IN % Inj. Occupants CHA(3) 67
BEGMP BEGIN LOG POINT OF CURVE Angle Point NUM 114
BEGMP BEGIN LOG POINT OF CURVE Curves NUM 102
BEGMP BEGIN LOG POINT OF CURVE Grades NUM 108
BEGMP BEGINNING MILE POST Roadlog NUM 76
BODY BODY TYPE Vehicle CHA(2) 47
CASENO UNIQUE ACCIDENT CASE NUMBER Accident CHA(11) 34
CASENO UNIQUE ACCIDENT CASE NUMBER Inj. Occupants CHA(11) 67
CASENO UNIQUE ACCIDENT CASE NUMBER Vehicle CHA(11) 48
CDL_CLASS TRUCK / BUS CDL CLASS Vehicle CHA(1) 48
CHNG_YR RECORD CHANGE YEAR Point CHA(4) 94
CIT_LOC_CDE CITATION LOCAL CODE Inj. Occupants NUM 67
CITATION CITATION GIVEN Inj. Occupants CHA(11) 67
CNT_TLOG COUNTY TRUE LOG Roadlog NUM 76
CNTY_RTE COUNTY ROUTE Point CHA(8) 94
CNTY_RTE COUNTY ROUTE Curves CHA(8) 102
CNTY_RTE COUNTY ROUTE Grades CHA(8) 108
CNTY_RTE COUNTY ROUTE Point CHA(8) 94
CNTY_RTE COUNTY ROUTE Roadlog CHA(8) 76
CNTYLOG COUNTY TRUE LOG Point CHA(4) 94
CNTYRTE COUNTY ROUTE Accident CHA(8) 34
COMPOSITE LIST OF VARIABLES (CONT’D)
SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
CONTRIB1 CONTRIBUTING FACTOR OF VEHICLE Vehicle NUM 48
COUNTY COUNTY Accident CHA(3) 34
COUNTY COUNTY Point CHA(3) 94
COUNTY COUNTY Curves CHA(3) 102
COUNTY COUNTY Grades CHA(3) 108
COUNTY COUNTY Point CHA(3) 94
COUNTY COUNTY Roadlog CHA(3) 77
DAMAGE VEHICLE DAMAGE SEVERITY Vehicle NUM 49
DAMSEV VEHICLE DAMAGE SCALE Vehicle NUM 49
DAMSEV2 VEHICLE DAMAGE SCALE Vehicle NUM 50
DEG_CURV DEGREE OF CURVE Curves NUM 102
DEG_CURV DEGREE OG CURVE Angle Point NUM 114
DESC LOCATION DESCRIPTION Point CHA(32) 94
DESC DESCRIPTION Curves CHA(18) 103
DESC DESCRIPTION Grades CHA(18) 108
DESC LOCATION DESCRIPTION Point CHA(32) 94
DIR_CURV DIRECTION OF CURVE Angle Point CHA(18) 115
DIR_CURV DIRECTION OF CURVE Curves CHA(18) 103
DIR_GRAD DIRECTION OF GRADE Grades CHA(1) 108
DIR_REF DIRECTION FROM REFERENCE Accident CHA(1) 36
DIR_TRVL DIRECTION OF VEHICLE Vehicle NUM 50
DIRECTION DIRECTION 1 Accident CHA(1) 36
DIRECTION2 DIRECTION 2 Accident CHA(1) 36
DIST_OFF DISTRICT OFFSET Accident CHA(3) 36
DISTRICT DISTRICT Accident NUM 36
DISTRICT DISTRICT Point NUM 94
DISTRICT DISTRICT Curves NUM 103
DISTRICT DISTRICT Grades NUM 109
DISTRICT DISTRICT Point NUM 94
DISTRICT DISTRICT Roadlog NUM 77
DIV_CODE ROAD IDENTIFICATION Accident CHA(1) 36
DIVIDED DIVIDED HIGHWAY INDICATOR Angle Point CHA(1) 115
DIVIDED DIVIDED HIGHWAY INDICATOR Curves CHA(1) 103
DIVIDED DIVIDED HIGHWAY INDICATOR Grades CHA(1) 109
DIVIDED ROAD IDENTIFICATION Roadlog CHA(1) 77
DL_CLASS DL CLASS Inj. Occupants CHA(2) 67
DL_CLASS DL CLASS Vehicle CHA(2) 51
DL_STATE DL STATE Inj. Occupants CHA(2) 68
DL_STATE DL STATE Vehicle CHA(2) 52
DLCOUNTY COUNTY Vehicle CHA(3) 52
DLCOUNTY DL COUNTY Inj. Occupants CHA(3) 68
DRG_RES1 DRUG TEST 1 RESULT Inj. Occupants NUM 68
DRG_RES2 DRUG TEST 2 RESULT Inj. Occupants NUM 68
DRUG_INV DRUGS INVOLVED Inj. Occupants NUM 68
DRUG_TEST_STATUS DRUGS TEST STATUS Inj. Occupants NUM 68
DRUG_TEST_TYPE DRUG TEST TYPE Inj. Occupants NUM 69
DRV_AGE DRIVER AGE Vehicle NUM 52
COMPOSITE LIST OF VARIABLES (CONT’D)
SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
DRV_FLAG DRIVE PRESENCE Vehicle CHA(1) 52
DRV_INJ DRIVER INJURY Vehicle NUM 52
DRV_REST DRIVER SAFETY EQUIPMENT Vehicle NUM 53
DRV_SEX DRIVER SEX Vehicle CHA(1) 53
EJECT EJECTED FROM VEHICLE Inj. Occupants NUM 69
EMER_USE IN EMERGENCY RESPONSE Vehicle NUM 53
ENDMP END LOG POINT OF CURVE Angle Point NUM 115
ENDMP END LOG POINT OF CURVE Curves NUM 103
ENDMP END LOG POINT OF CURVE Grades NUM 109
ENDMP END MILE POST Roadlog NUM 77
EVENT1 SEQUENCE OF EVENTS 1 Vehicle NUM 53
EVENT2 SEQUENCE OF EVENTS 2 Vehicle NUM 53
EVENT3 SEQUENCE OF EVENTS 3 Vehicle NUM 53
EVENT4 SEQUENCE OF EVENTS 4 Vehicle NUM 53
F_HARM FIRST HARMFUL EVENT Vehicle NUM 54
FAULT VIOLATOR Accident NUM 36
FED_ACES FEDERAL ACCESS CONTROL Roadlog CHA(1) 77
FED_FACI FHWA TYPE OF FACILITY Roadlog CHA(1) 77
FED_MEDW FHWA MEDIAN WIDTH Roadlog CHA(3) 78
FED_SPSY FHWA SPECIAL SYSTEMS Roadlog CHA(2) 78
FIPS_CDE FIPS CODE Roadlog CHA(5) 78
FIPSMUNI FIPS CODE Accident CHA(5) 37
FIRE FIRE Vehicle NUM 55
FLIP_IND INDICATES DUPLICATE RECORD GENERATION Accident CHA(1) 37
FRWY_IND FREEWAY / NON-FREEWAY INDICATOR Accident CHA(1) 37
FUNC_CLS FUNCTIONAL CLASS Angle Point CHA(2) 115
FUNC_CLS FUNCTIONAL CLASS Curves CHA(2) 103
FUNC_CLS FUNCTIONAL CLASS Grades CHA(2) 109
FUNC_CLS FUNCTIONAL CLASS Roadlog CHA(2) 78
FUNCLS FUNCTIONAL CLASSFICATION Accident NUM 37
GVWR TRUCK/BUS WEIGHT Vehicle NUM 55
HAZMAT HAZARDOUS MATERIAL RELEASED Vehicle NUM 55
HAZPLACD HAZARDOUS MATERIAL PLACARD Vehicle NUM 55
HELMET HELMET USE Inj. Occupants CHA(1) 69
HOUR HOUR OF DAY Accident NUM 38
HOV FHWA HOV VEHICLES Roadlog NUM 78
HPMS HPMS CODES Roadlog CHA(1) 79
ID_CNTRL ID CONTROL CODE Roadlog CHA(1) 79
INJ OCCUPANT INJURY Inj. Occupants NUM 69
INSURFLG VEHICLE INSURED Vehicle NUM 55
INTER_IND INTERSTATE HIGHWAY INDICATOR Accident CHA(1) 38
INV_DATE YEAR OF CODING CHANGE Angle Point NUM 115
INV_DATE YEAR OF CODING CHANGE Curves NUM 103
INV_DATE YEAR OF CODING CHANGE Grades NUM 109
INV_DTE INVENTORY DATE Roadlog CHA(4) 79
JUR_TYPE JURISDICTION Accident CHA(1) 38
COMPOSITE LIST OF VARIABLES (CONT’D)
SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
JUR_TYPE JURISDICTION Roadlog CHA(1) 79
LIGHT LIGHT CONDITION Accident CHA(1) 38
LOC_CASE LOCAL REPORT NUMBER Accident CHA(10) 38
LOC_TYPE LOCATION Accident NUM 39
LOC_VEH NON-MOTORIST LOCATION PRIOR TO IMPACT Vehicle NUM 55
LOG_SUFX LOG POINT SUFFIX Point CHA(1) 94
LRS_BGPT LRS BEGINNING MILE POINT Roadlog CHA(7) 79
LRS_BNDE LRS B NODE Roadlog CHA(4) 79
LRS_EDPT LRS ENDING MILE POINT Roadlog CHA(7) 80
LRS_ENDE LRS END NODE Roadlog CHA(4) 80
LRS_ID LRS INVENTORY ROUTE NUMBER(10 CHARC) + LRS SUBROUTE NUMBER Roadlog CHA(12) 80
LRS_INRT LRS INVENTORY ROUTE NUMBER Roadlog CHA(10) 81
LRS_NDCN LRS NODE CODE (COUNTY/STATE) Roadlog CHA(2) 81
LRS_NDNM LRS NODE NAME Roadlog CHA(10) 81
LRS_NDSQ LRS NODE SEQUENCE NUMBER Roadlog CHA(3) 81
LRS_NRDE LRS NODE RTE DESIGNATION Roadlog CHA(5) 81
LRS_SBRT LRS SUBROUTE NUMBER Roadlog CHA(2) 81
MAKE MAKE OF VEHICLE Vehicle CHA(4) 56
MED_TYPE FHWA MEDIAN TYPE Roadlog CHA(1) 81
MED_WID MEDIAN WIDTH Roadlog NUM 82
MI_CLASS MILE CLASS (INCORPORATED/ UNINCORPORATED) Roadlog CHA(1) 82
MILE_CLS MILE CLASS Angle Point CHA(1) 115
MILE_CLS MILE CLASS Curves CHA(1) 103
MILE_CLS MILE CLASS Grades CHA(1) 109
MILEPOST MILEPOST Accident NUM 39
MILEPOST LOG POINT Point NUM 94
MISCACT1 PRE-CRASH ACTIONS Vehicle NUM 56
MODEL MODEL OF VEHICLE Vehicle NUM 56
MOSTHARM MOST HARMFUL EVENT Vehicle NUM 56
MOVMNT MOVEMENT OF VEHICLE Vehicle NUM 57
MUN_NAM MUNICIPALITY NAME Roadlog CHA(16) 82
MUNI_CDE MUNICIPAL CODE Point NUM 95
MUNICODE MUNICIPALITY CODE Accident CHA(3) 39
MVMT MILLION VEHICLE MILES OF TRAVEL Accident NUM 39
MVMT MILLION VEHICLE MILES OF TRAVEL Roadlog NUM 82
NHS NATIONAL HIGHWAY SYSTEM INDICATOR Accident CHA(1) 39
NHS_CDE NATIONAL HIGHWAY SYSTEM CODE Roadlog CHA(1) 82
NHS_INTR NHS INTERMODAL NUMBER Roadlog CHA(2) 83
NO_LANES NUMBER OF LANES Accident CHA(1) 39
NO_LANES NUMBER OF LANES Angle Point NUM 116
NO_LANES NUMBER OF LANES Curves NUM 104
NO_LANES NUMBER OF LANES Grades NUM 109
COMPOSITE LIST OF VARIABLES (CONT’D)
SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
NO_LANES NUMBER OF LANES Roadlog NUM 83
NUM_OCCS NUMBER OF OCCUPANTS Vehicle NUM 57
NUMPEDS NUMBER OF PEDESTRIANS Accident NUM 40
NUMVEH NUMBER OF VEHICLES Vehicle NUM 57
NUMVEHS NUMBER OF VEHICLES Accident NUM 40
OBJECT1 OBJECT STRUCK BY VEHICLE Vehicle NUM 57
ODT_ATFAULT ODOT-AT-FAULT-FLAG Vehicle CHA(1) 58
ODT_PERSON_CNT ODOT-PEOPLE-FOUND-COUNT Vehicle NUM 58
ONOFF_RD ON-OFF ROAD OCCURANCE Accident NUM 40
OVRLDIR OVERLAP LOG DIRECTION Point CHA(1) 95
OWNERID VEHICLE OWNERSHIP Vehicle NUM 58
P_TYPE OCCUPANT TYPE Inj. Occupants CHA(1) 69
PAS_NHS PAS/NHS INTERSECTION MARKER Roadlog CHA(1) 83
PAV_ROUG PAVEMENT ROUGHNESS Roadlog CHA(3) 83
PAVECOND PAVEMENT CONDITION Roadlog CHA(2) 83
PCT_GRAD PERCENT OF GRADE Grades NUM 110
PEDS_INJ PEDESTRIANS INJURED Accident NUM 40
PEDS_KILLED PEDESTRIANS KILLED Accident NUM 40
PHYSCOND PEDESTRIAN PHYSICAL CONDITION Inj. Occupants NUM 69
PK_LANES PEAK LOAD LANES Roadlog CHA(3) 84
POC1 POINT OF IMPACT Vehicle NUM 58
POP_GRP POPULATION Accident CHA(1) 40
POP_GRP POPULATION Roadlog CHA(4) 84
PUB_PROP PUBLIC PROPERTY DAMAGE Vehicle CHA(1) 59
PUBDMG PUBLIC PROPERTY DAMAGE Accident CHA(1) 41
RAMP RAMP CODE Accident CHA(2) 41
RD_CHAR1 CONTOUR OF ROADWAY Accident NUM 41
RD_WIDTH ROADWAY WIDTH THRU LANES N/MEDIANS Roadlog NUM 84
RDSURF ROAD CONDITION Accident NUM 41
REC_TYPE RECORD TYPE Point CHA(1) 95
REST1 SAFETY EQUIPMENT Inj. Occupants NUM 70
RODWYCLS ROAD TYPE Accident CHA(2) 41
RODWYCLS ROADWAY TYPES Roadlog CHA(2) 84
RTE_DIR ROUTE DIRECTION Point CHA(2) 96
RTE_NBR ROUTE NUMBER Accident CHA(5) 41
RTE_NBR STATE ROUTE NUMBER Point CHA(5) 96
RTE_NBR STATE ROUTE NUMBER Curves CHA(5) 104
RTE_NBR STATE ROUTE NUMBER Grades NUM 110
RTE_NBR STATE ROUTE NUMBER Point CHA(5) 96
RTE_NBR STATE ROUTE NUMBER Roadlog CHA(5) 85
RTE_PREF STATE ROUTE PREFIX Point CHA(1) 96
RTE_SUFX STATE ROUTE SUFFIX Point CHA(1) 96
RTE_SUFX STATE ROUTE SUFFIX Curves CHA(1) 104
RTE_SUFX STATE ROUTE SUFFIX Grades CHA(1) 110
RTE_SUFX STATE ROUTE SUFFIX Point CHA(1) 96
RTE_SUFX STATE ROUTR NUMBER SUFFIX Roadlog CHA(1) 85
RTE_TYPE ROUTE TYPE Roadlog NUM 85
COMPOSITE LIST OF VARIABLES (CONT’D)
SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
RURUID POPULATION (OVE/UNDER 5000) Roadlog CHA(1) 85
SAFTJUR ORIGINAL JURISDICTION CODED BY HIGHWAY SAFETY Accident CHA(1) 42
SCENIC SCENIC BYWAYS Roadlog CHA(1) 86
SCH_WZON SPECIAL AREA CODE Accident NUM 42
SEATPOS SEATING POSITION Inj. Occupants NUM 70
SEG_LNG SEGMENT LENGTH Angle Point NUM 116
SEG_LNG SEGMENT LENGTH Curves NUM 104
SEG_LNG SEGMENT LENGTH Grades NUM 110
SEG_LNG SEGMENT LENGTH Roadlog NUM 86
SEQ_NBR SEQUENCE NUMBER Point CHA(1) 97
SEQ_NBR SEQUENCE NUMBER Curves NUM 105
SEQ_NBR SEQUENCE NUMBER Grades NUM 111
SEQ_NBR SEQUENCE NUMBER Point CHA(1) 97
SEQ_NBR SEQUENCE NUMBER Roadlog CHA(1) 86
SEVERITY CRASH SEVERITY (GENERATED) Accident CHA(1) 42
SEVERITY_OH CRASH SEVERITY (ORIGINAL) Accident NUM 42
SEX OCCUPANT GENDER Inj. Occupants CHA(1) 71
SHWD_LEFT_INSIDE SHOULDER LEFT INSIDE Roadlog NUM 86
SHWD_LEFT_OUTSIDE SHOULDER RIGHT OUTSIDE Roadlog NUM 86
SHWD_RIGHT_INSIDE SHOULDER LEFT OUTSIDE Roadlog NUM 86
SHWD_RIGHT_OUTSIDE SHOULDER RIGHT INSIDE Roadlog NUM 86
SOB_TST ALCOHOL INVOLVED Inj. Occupants NUM 71
SPD_LIMT SPEED LIMIT OF ROAD Vehicle NUM 59
SPDLIMT SPEED LIMIT Roadlog NUM 86
SPECDESC SPECIAL DESCRIPTION Point CHA(1) 97
SRC_RPT SOURCE OF REPORT Accident CHA(1) 42
SRF_BAS STANDARD BASE CLASSIFICATION Roadlog CHA(1) 87
SRF_BASL LEFT SIDE SURFACE BASE TYPE Roadlog CHA(1) 87
SRF_BASR RIGHT SIDE SURFACE BASE CLASS TYPE Roadlog CHA(1) 87
SRF_TYPF SUMMARY OF FHWA SURFACE TYPE Roadlog CHA(2) 88
SRF_TYPL LEFT SIDE STANDARD SURFACE TYPE Roadlog CHA(1) 88
SRF_TYPR RIGHT SIDE SURFACE CLASS TYPE Roadlog CHA(1) 88
SRFTYPLL LEFT SIDE FHWA SURFACE TYPE Roadlog CHA(2) 89
SRFTYPLR FHWA RIGHT SIDE SURFACE TYPE Roadlog CHA(2) 89
STAT_EQ STATE EQUATION SORT Point CHA(1) 97
STAT_EQ STATION EQUATION SORT FILED Roadlog NUM 89
STAT_EQU STATION EQUATION SORT FIELD Angle Point NUM 117
STAT_EQU STATION EQUATION SORT FIELD Curves NUM 105
STAT_EQU STATION EQUATION SORT FIELD Grades NUM 111
STATE_EQ STATION EQUATION SORT FIELD Accident NUM 42
STN_SUF STREET NAME SUFFIX Roadlog CHA(4) 90
STR_PFX STREET NAME DIRECTIONAL PREFIX Roadlog CHA(1) 90
STREET_1 STREET ON Accident CHA(10) 42
STREET_2 STREET AT/CROSS ROUTE Accident CHA(10) 42
COMPOSITE LIST OF VARIABLES (CONT’D)
SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
STRKN_VEH STRIKING VEHICLE Vehicle NUM 59
STRT_DIR STREET NAME DIRECTIONAL SUFFIX Roadlog CHA(1) 90
STRT_NAM STREET NAME Roadlog CHA(22) 90
STRT_SUF STREET SUFFIX Point CHA(2) 97
SURF_TYP STANDARD SURFACE CLASSIFICATION Roadlog CHA(1) 90
SURF_WID SURFACE WIDTH THRU LANES N/SHOULDERS Roadlog NUM 91
SURFWIDL LEFT SIDE SURFACE WIDTH IN FEET Roadlog NUM 91
SURFWIDR RIGHT SIDE SURFACE WIDTH IN FEET Roadlog NUM 91
SYS_CLAS SYSTEM CLASS Angle Point CHA(1) 117
SYS_CLAS SYSTEM CLASS Curves CHA(1) 105
SYS_CLAS SYSTEM CLASS Grades CHA(1) 111
SYS_CLAS SYSTEM CLASS Roadlog CHA(1) 92
TAKEN_BY INJURED TAKEN BY Inj. Occupants NUM 71
TOT_KILL TYPE 1 TOTAL KILLED Accident NUM 43
TOT_NON TYPE 5 NO INDICATED INJURY Accident NUM 43
TOT_UNK TYPE 0 NO INDICATED INJURY Accident NUM 43
TOTAINJ TYPE 2 SERIOUS VISIBLE INJURY Accident NUM 43
TOTBINJ TYPE 3 MINOR VISIBLE INJURY Accident NUM 43
TOTCINJ TYPE 4 NO VISIBLE INJURY Accident NUM 43
TOWED TOWED FLAG Vehicle NUM 59
TRAPPED TRAPPED Inj. Occupants NUM 71
TRF_CNTL TRAFFIC CONTROL OF VEHICLE Vehicle NUM 59
TRK_BODY CARGO BODY TYPE Vehicle NUM 60
TRK_LOAD TYPE OF TRUCK LOAD Vehicle NUM 60
TRKAXLES NUMBER OF TRUCK AXLES Vehicle NUM 60
TRUE_LOG STATE ROUTE TRUE LOG Point CHA(5) 98
TRVL_SPD SPEED DETECTED Vehicle NUM 60
TWNSHIP TOWNSHIP ABBREVIATION Accident NUM 43
TYPE_BD TYPE OF REFERENCE Accident CHA(1) 44
UPDT_YR UPDATE YEAR Roadlog CHA(4) 92
VEH_DISP VEHICLE DISPOSTION Vehicle NUM 61
VEH_N_FROM VEHICLE/NON-MOTORIST DIRECTION FROM Vehicle NUM 61
VEH_N_TO VEHICLE/NON-MOTORIST DIRECTION FROM Vehicle NUM 61
VEH_SPEED_POST_2000 SPEED OF VEHICLE Vehicle NUM 61
VEH_SPEED_PRE_2000 ESTIMATED SPEED OF VEHICLE Vehicle NUM 61
VEHCOND1 PRIMARY CONDITION 1 Vehicle NUM 62
VEHCOND2 PRIMARY CONDITION 2 Vehicle NUM 62
VEHNO VEHICLE NUMBER Inj. Occupants NUM 71
VEHNO VEHICLE NUMBER Vehicle NUM 62
VEHSTATE VEHICLE STATE Vehicle CHA(2) 62
VEHTYPE VEHICLE TYPE Vehicle NUM 62
VEHYR VHHICLE MODEL YEAR Vehicle NUM 63
VIN VIN NUMBER Vehicle CHA(17) 63
WEATHER WEATHER CONDITION Accident NUM 44
WEEKDAY DAY OF WEEK Accident CHA(1) 44
XCNTYRTE CROSS ROAD COUNTY ROUTE Point CHA(1) 98
XLOG_SUF CROSS ROUTE LOG SUFFIX Point CHA(1) 98
XMILEPST CROSS ROUTE MILEPOST Point NUM 98
XRTE_NBR CROSS ROUTE NUMBER Point CHA(4) 98
XRTE_SUF CROOS ROUTE SUFFIX Point CHA(1) 98
XRTEPREF CROSS ROUTE PREFIX Point CHA(1) 99

ACCIDENT FILE

LIST OF VARIABLES FOR THE OHIO ACCIDENT SUBFILE

SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
ACC_DATE ACCIDENT DATE YYYYMMDD Accident CHA(8) 33
ACCESS ACCESS CONTROL Accident CHA(1) 33
ACCTYPE TYPE OF CRASH(FIRST HARMFUL EVENT) Accident NUM 33
ACCYR ACCIDENT YEAR Accident NUM 33
ANGLE TURN CRASH INDICATOR Accident NUM 34
ANIMAL ANIMAL TYPE Accident NUM 34
CASENO UNIQUE ACCIDENT CASE NUMBER Accident CHA(11) 34
CNTYRTE COUNTY ROUTE Accident CHA(8) 34
COUNTY COUNTY Accident CHA(3) 34
DIR_REF DIRECTION FROM REFERENCE Accident CHA(1) 36
DIRECTION DIRECTION 1 Accident CHA(1) 36
DIRECTION2 DIRECTION 2 Accident CHA(1) 36
DIST_OFF DISTRICT OFFSET Accident CHA(3) 36
DISTRICT DISTRICT Accident NUM 36
DIV_CODE ROAD IDENTIFICATION Accident CHA(1) 36
FAULT VIOLATOR Accident NUM 36
FIPSMUNI FIPS CODE Accident CHA(5) 37
FLIP_IND INDICATES DUPLICATE RECORD GENERATION Accident CHA(1) 37
FRWY_IND FREEWAY / NON-FREEWAY INDICATOR Accident CHA(1) 37
FUNCLS FUNCTIONAL CLASSFICATION Accident NUM 37
HOUR HOUR OF DAY Accident NUM 38
INTER_IND INTERSTATE HIGHWAY INDICATOR Accident CHA(1) 38
JUR_TYPE JURISDICTION Accident CHA(1) 38
LIGHT LIGHT CONDITION Accident CHA(1) 38
LOC_CASE LOCAL REPORT NUMBER Accident CHA(10) 38
LOC_TYPE LOCATION Accident NUM 39
MILEPOST MILEPOST Accident NUM 39
MUNICODE MUNICIPALITY CODE Accident CHA(3) 39
MVMT MILLION VEHICLE MILES OF TRAVEL Accident NUM 39
NHS NATIONAL HIGHWAY SYSTEM INDICATOR Accident CHA(1) 39
NO_LANES NUMBER OF LANES Accident CHA(1) 39
NUMPEDS NUMBER OF PEDESTRIANS Accident NUM 40
NUMVEHS NUMBER OF VEHICLES Accident NUM 40
ONOFF_RD ON-OFF ROAD OCCURANCE Accident NUM 40
PEDS_INJ PEDESTRIANS INJURED Accident NUM 40
PEDS_KILLED PEDESTRIANS KILLED Accident NUM 40
POP_GRP POPULATION Accident CHA(1) 40
PUBDMG PUBLIC PROPERTY DAMAGE Accident CHA(1) 41
RAMP RAMP CODE Accident CHA(2) 41
RD_CHAR1 CONTOUR OF ROADWAY Accident NUM 41
RDSURF ROAD CONDITION Accident NUM 41
RODWYCLS ROAD TYPE Accident CHA(2) 41
RTE_NBR ROUTE NUMBER Accident CHA(5) 41
SAFTJUR ORIGINAL JURISDICTION CODED BY HIGHWAY SAFETY Accident CHA(1) 42
SCH_WZON SPECIAL AREA CODE Accident NUM 42
SEVERITY CRASH SEVERITY (GENERATED) Accident CHA(1) 42
SEVERITY_OH CRASH SEVERITY (ORIGINAL) Accident NUM 42
SRC_RPT SOURCE OF REPORT Accident CHA(1) 42
STATE_EQ STATION EQUATION SORT FIELD Accident NUM 42
STREET_1 STREET ON Accident CHA(10) 42
STREET_2 STREET AT/CROSS ROUTE Accident CHA(10) 42
TOT_KILL TYPE 1 TOTAL KILLED Accident NUM 43
TOT_NON TYPE 5 NO INDICATED INJURY Accident NUM 43
TOT_UNK TYPE 0 NO INDICATED INJURY Accident NUM 43
TOTAINJ TYPE 2 SERIOUS VISIBLE INJURY Accident NUM 43
TOTBINJ TYPE 3 MINOR VISIBLE INJURY Accident NUM 43
TOTCINJ TYPE 4 NO VISIBLE INJURY Accident NUM 43
TWNSHIP TOWNSHIP ABBREVIATION Accident NUM 43
TYPE_BD TYPE OF REFERENCE Accident CHA(1) 44
WEATHER WEATHER CONDITION Accident NUM 44
WEEKDAY DAY OF WEEK Accident CHA(1) 44

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE OHIO 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

       ACCIDENT DATE

NON-LABELED VARIABLE

NOTE: Year/Month/Date of accident (YYYYMMDD).

ACCESS

         ACCESS CONTROL

NOTE: Access control as defined by OH State. For example, ‘F’ Indicates that Ohio DOT owns the access control and can change it whenever deemed required. The use of this variable may result in some difficulties and we recommend the use of FED_ACES, available in the roadlog file to get information on the access control of segments.

ACCTYPE

        TYPE OF CRASH (FIRST HARMFUL EVENT)

ACCYR

          ACCIDENT YEAR

NON-LABELED VARIABLE

NOTE: Year of Accident (YYYY).

ANGLE

          TURN CRASH INDICATOR (GENERATED)

ANIMAL

         ANIMAL TYPE

CASENO

         UNIQUE ACCIDENT CASE NUMBER

NON-LABELED VARIABLE

NOTE: Accident Case Number. The first 4 digits show the accident year.  

CNTYRTE

        COUNTY ROUTE

NON-LABELED VARIABLE

NOTE: Linkage variable consisting of COUNTY + RTE_NBR + RTE_SUFX + STATE_EQ. From year 2000, STATE_EQ is not required. Also RTE_SUFX became last digit of RTE_NBR.

COUNTY

         COUNTY

DIR_REF

        DIRECTION FROM REFERENCE

DIRECTION

      DIRECTION 1

DIRECTION2

     DIRECTION 2

DIST_OFF

       DISTANCE OFFSET

NON-LABELED VARIABLE

DISTRICT

       DISTRICT

NON-LABELED VARIABLE

DIV_CODE

      ROAD IDENTIFICATION

FAULT

         VIOLATOR

FIPSMUNI

      FIPS CODE

NON-LABELED VARIABLE

FLIP_IND

       INDICATES DUPLICATE RECORD GENERATION

NOTE: Categories 6 and 7 apply for data generated before 2000.

FRWY_IND

       FREEWAY / NON-FREEWAY INDICATOR

FUNCLS

         FUNCTIONAL CLASSIFICATION

NOTE: Urban crashes increased considerably from 2000 onwards due to OH DOT’s better ability to locate the crashes in this area.

HOUR

          HOUR OF DAY

INTER_IND

      INTERSTATE HIGHWAY INDICATOR

JUR_TYPE

       JURISDICTION

LIGHT

          LIGHT CONDITION

LOC_CASE

      LOCAL REPORT NUMBER

NON-LABELED VARIABLE

LOC_TYPE

      LOCATION

MILEPOST

       MILEPOST

NON-LABELED VARIABLE

NOTE: Milepost of crash in miles (XXX.XX).

MUNICODE

      MUNICIPALITY CODE

NON-LABELED VARIABLE

MVMT

           MILLION VEHICLE MILES OF TRAVEL

NON-LABELED VARIABLE

NHS

            NATIONAL HIGHWAY SYSTEM INDICATOR

NO_LANES

       NUMBER OF LANES

NUMPEDS

        NUMBER OF PEDESTRIANS

NON-LABELED VARIABLE

NUMVEHS

       NUMBER OF VEHICLES

NON-LABELED VARIABLE

ONOFF_RD

       ON-OFF ROAD OCCURANCE

PEDS_INJ

       PEDESTRIANS INJURED

NON-LABELED VARIABLE.

NOTE: Variable added in 2000.

PEDS_KILLED

    PEDESTRIANS KILLED

NON-LABELED VARIABLE.

NOTE: Variable added in 2000.

POP_GRP

       POPULATION

PUBDMG

         PUBLIC PROPERTY DAMAGE

RAMP

           RAMP CODE

NON-LABELED VARIABLE

RD_CHAR1

       CONTOUR OF ROADWAY

RDSURF

         ROAD CONDITION

RODWYCLS

       ROADWAY TYPE

NOTE: Urban crashes increased considerably from 2000 onwards due to OH DOT’s better ability to locate the crashes in this area.

RTE_NBR

        ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: From year 2000, this variable became 5 characters with first digit being ‘0’ and last digit as RTE_SUFX.

SAFTJUR

        ORIGINAL JURISDICTION CODED BY HIGHWAY SAFETY

NON-LABELED VARIABLE

SCH_WZON

       SPECIAL AREA CODE

SEVERITY

       CRASH SEVERITY (GENERATED)

SEVERITY_OH

    CRASH SEVERITY (ORIGINAL)

SRC_RPT

        SOURCE OF REPORT

STATE_EQ

       STATION EQUATION SORT FIELD

NON-LABELED VARIABLE

NOTE: Not required from year 2000.

STREET_1

       STREET ON

NON-LABELED VARIABLE

STREET_2

       STREET AT/CROSS ROUTE

NON-LABELED VARIABLE

TOT_KILL

       TYPE 1 TOTAL KILLED

TOT_NON

        TYPE 5 NO INDICATED INJURY

TOT_UNK

        TYPE 0 INJURY NOT STATED

TOTAINJ

        TYPE 2 SERIOUS VISIBLE INJURY

TOTBINJ

        TYPE 3 MINOR VISIBLE INJURY

TOTCINJ

        TYPE 4 NO VISIBLE INJURY

TWNSHIP

        TOWNSHIP ABBREVIATION

NON-LABELED VARIABLE

TYPE_BD

        TYPE OF REFERENCE

WEATHER

        WEATHER CONDITION

WEEKDAY

        DAY OF WEEK

LIST OF VARIABLES FOR THE OHIO VEHICLE SUBFILE

SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
ACCYR ACCIDENT YEAR Vehicle CHA(4) 47
ACTION ACTION Vehicle NUM 47
BODY BODY TYPE Vehicle CHA(2) 47
CASENO UNIQUE ACCIDENT CASE NUMBER Vehicle CHA(11) 48
CDL_CLASS TRUCK / BUS CDL CLASS Vehicle CHA(1) 48
CONTRIB1 CONTRIBUTING FACTOR OF VEHICLE Vehicle NUM 48
DAMAGE VEHICLE DAMAGE SEVERITY Vehicle NUM 49
DAMSEV VEHICLE DAMAGE SCALE Vehicle NUM 49
DAMSEV2 VEHICLE DAMAGE SCALE Vehicle NUM 50
DIR_TRVL DIRECTION OF VEHICLE Vehicle NUM 50
DL_CLASS DL CLASS Vehicle CHA(2) 51
DL_STATE DL STATE Vehicle CHA(2) 52
DLCOUNTY COUNTY Vehicle CHA(3) 52
DRV_AGE DRIVER AGE Vehicle NUM 52
DRV_FLAG DRIVE PRESENCE Vehicle CHA(1) 52
DRV_INJ DRIVER INJURY Vehicle NUM 52
DRV_REST DRIVER SAFETY EQUIPMENT Vehicle NUM 53
DRV_SEX DRIVER SEX Vehicle CHA(1) 53
EMER_USE IN EMERGENCY RESPONSE Vehicle NUM 53
EVENT1 SEQUENCE OF EVENTS 1 Vehicle NUM 53
EVENT2 SEQUENCE OF EVENTS 2 Vehicle NUM 53
EVENT3 SEQUENCE OF EVENTS 3 Vehicle NUM 53
EVENT4 SEQUENCE OF EVENTS 4 Vehicle NUM 53
F_HARM FIRST HARMFUL EVENT Vehicle NUM 54
FIRE FIRE Vehicle NUM 55
GVWR TRUCK/BUS WEIGHT Vehicle NUM 55
HAZMAT HAZARDOUS MATERIAL RELEASED Vehicle NUM 55
HAZPLACD HAZARDOUS MATERIAL PLACARD Vehicle NUM 55
INSURFLG VEHICLE INSURED Vehicle NUM 55
LOC_VEH NON-MOTORIST LOCATION PRIOR TO IMPACT Vehicle NUM 55
MAKE MAKE OF VEHICLE Vehicle CHA(4) 56
MISCACT1 PRE-CRASH ACTIONS Vehicle NUM 56
MODEL MODEL OF VEHICLE Vehicle NUM 56
MOSTHARM MOST HARMFUL EVENT Vehicle NUM 56
MOVMNT MOVEMENT OF VEHICLE Vehicle NUM 57
NUM_OCCS NUMBER OF OCCUPANTS Vehicle NUM 57
NUMVEH NUMBER OF VEHICLES Vehicle NUM 57
OBJECT1 OBJECT STRUCK BY VEHICLE Vehicle NUM 57
ODT_ATFAULT ODOT-AT-FAULT-FLAG Vehicle CHA(1) 58
ODT_PERSON_CNT ODOT-PEOPLE-FOUND-COUNT Vehicle NUM 58
OWNERID VEHICLE OWNERSHIP Vehicle NUM 58
POC1 POINT OF IMPACT Vehicle NUM 58
PUB_PROP PUBLIC PROPERTY DAMAGE Vehicle CHA(1) 59
SPD_LIMT SPEED LIMIT OF ROAD Vehicle NUM 59
STRKN_VEH STRIKING VEHICLE Vehicle NUM 59
TOWED TOWED FLAG Vehicle NUM 59
TRF_CNTL TRAFFIC CONTROL OF VEHICLE Vehicle NUM 59
TRK_BODY CARGO BODY TYPE Vehicle NUM 60
TRK_LOAD TYPE OF TRUCK LOAD Vehicle NUM 60
TRKAXLES NUMBER OF TRUCK AXLES Vehicle NUM 60
TRVL_SPD SPEED DETECTED Vehicle NUM 60
VEH_DISP VEHICLE DISPOSTION Vehicle NUM 61
VEH_N_FROM VEHICLE/NON-MOTORIST DIRECTION FROM Vehicle NUM 61
VEH_N_TO VEHICLE/NON-MOTORIST DIRECTION FROM Vehicle NUM 61
VEH_SPEED_POST_2000 SPEED OF VEHICLE Vehicle NUM 61
VEH_SPEED_PRE_2000 ESTIMATED SPEED OF VEHICLE Vehicle NUM 61
VEHCOND1 PRIMARY CONDITION 1 Vehicle NUM 62
VEHCOND2 PRIMARY CONDITION 2 Vehicle NUM 62
VEHNO VEHICLE NUMBER Vehicle NUM 62
VEHSTATE VEHICLE STATE Vehicle CHA(2) 62
VEHTYPE VEHICLE TYPE Vehicle NUM 62
VEHYR VHHICLE MODEL YEAR Vehicle NUM 63
VIN VIN NUMBER Vehicle CHA(17) 63

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE OHIO STATE VEHICLE SUBFILE

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

ACCYR

          ACCIDENT YEAR

NON-LABELED VARIABLE

ACTION

         ACTION

NOTE: Variable added in 2000.

BODY

           BODY TYPE

NOTES: (1) This variable shows 48 percent of the values to be missing. Also there are no formats available for the convectional 4-door automobile. Any analysis performed using this variable should take this in account.

(2) Variable discontinued in 2000.

CASENO

         UNIQUE ACCIDENT CASE NUMBER

NON-LABELED VARIABLE

NOTE: Accident Case Number. The first 4 digits show the accident year.

CDL_CLASS

      TRUCK/BUS CDL CLASS

CONTRIB1

       CONTRIBUTING FACTOR OF VEHICLE

MOTORIST

NON-MOTORIST

NOTE: Categories 34-37 and 40-48 apply to data generated before 2000.

DAMAGE

         VEHICLE DAMAGE SEVERITY (VDS)

NOTE: Variable added in 2000.

DAMSEV

         VEHICLE DAMAGE SCALE

DAMSEV2

        VEHICLE DAMAGE SCALE

NOTE: Variable discontinued in 2000.

DIR_TRVL

       DIRECTION OF VEHICLE

NOTE: Variable discontinued in 2000.

DL_CLASS

       DL CLASS

NOTE: Variable discontinued in 2000.

DL_STATE

       STATE

NON-LABELED VARIABLE

DLCOUNTY

       COUNTY

NOTE: See listings under accident section of the guidebook. 

DRV_AGE

        DRIVER AGE

DRV_FLAG

       DRIVER PRESENCE

NOTE: Variable discontinued in 2000.

DRV_INJ

        DRIVER INJURY

DRV_REST

       DRIVER SAFETY EQUIPMENT

MOTORIST

NON-MOTORIST

DRV_SEX

        DRIVE SEX

EMER_USE

       IN EMERGENCY RESPONSE

NOTE: Variable added in 2000.

EVENT1

         SEQUENCE OF EVENTS 1

EVENT2

         SEQUENCE OF EVENTS 2

EVENT3

         SEQUENCE OF EVENTS 3

EVENT4

         SEQUENCE OF EVENTS 4

NON-COLLISION

COLLISION W/PERSON, VEHICLE, OR OBJECT NOT FIXED

COLLISION WITH FIXED OBJECT

NOTE: Variables added in 2000.

F_HARM

         FIRST HARMFUL EVENT

FIRE

           FIRE

NOTE: Variable discontinued in 2000.

GVWR

           TRUCK/BUS WEIGHT

HAZMAT

         HAZARDOUS MATERIAL RELEASED

NOTE: Variable added in 2000.

HAZPLACD

       HAZARDOUS MATERIAL PLACARD

NOTE: Variable added in 2000.

INSURFLG

       VEHICLE INSURED

LOC_VEH

        NON-MOTORIST LOCATION PRIOR TO IMPACT

MAKE

           MAKE OF VEHICLE

NON-LABELED VARIABLE

MISCACT1

       PRE-CRASH ACTIONS

MOTORIST

NON-MOTORIST

NOTE: Variable added in 2000.

MODEL

          MODEL OF VEHICLE

NON-LABELED VARIABLE

MOSTHARM

       MOST HARMFUL EVENT

MOVMNT

         MOVEMENT OF VEHICLE

NOTE: Codes 1-17 are for driver actions and 18 onwards are for pedestrian actions.

NUM_OCCS

       NUMBER OF OCCUPANTS

NUMVEH

         NUMBER OF VEHICLES

NON-LABELED VARIABLE

OBJECT1

        OBJECT STRUCK BY VEHICLE

NOTE: Variable discontinued in 2000.

ODT_ATFAULT

    ODOT-AT-FAULT-FLAG

NON-LABELED VARIABLE

ODT_PERSON_CNT

ODOT-PEOPLE-FOUND-COUNT

NON-LABELED VARIABLE

OWNERID

        VEHICLE OWNERSHIP

POC1

           PUBLIC PROPERTY DAMAGE

PUB_PROP

       PUBLIC PROPERTY DAMAGE

NOTE: Variable discontinued in 2000.

SPD_LIMT

       SPEED LIMIT OF ROAD

NOTES: 5-20 Contains all speeds less than or equal to 20 recorded from 1997 to 1999.  56-65 Contains all speeds greater than or equal to 56 recorded from 1997 to 1999.

STRKN_VEH

      STRIKING VEHICLE

TOWED

          TOWED FLAG

TRF_CNTL

       TRAFFIC CONTROL OF VEHICLE

NOTE: Categories 20 and 21 apply to data generated before 2000.

TRK_BODY

       CARGO BODY TYPE

NOTE: Variable added in 2000.

TRK_LOAD

       TYPE OF TRUCK LOAD

NOTE: Variable discontinued in 2000.

TRKAXLES

       NUMBER OF TRUCK AXLES

NON-LABELED VARIABLE

TRVL_SPD

       SPEED DETECTED

VEH_DISP

       VEHICLE DISPOSITION

VEH_N_FROM

     VEHICLE/NON-MOTORIST DIRECTION

VEH_N_TO

       VEHICLE/NON-MOTORIST DIRECTION TO

VEH_SPEED_POST_2000

SPEED OF VEHICLE

NOTE: Variable added in 2000.

VEH_SPEED_PRE_2000

  ESTIMATED SPEED OF VEHICLE

NOTE: Variable discontinued in 2000.

VEHCOND1

       PRIMARY CONDITION 1

VEHCOND2

       PRIMARY CONDITION 2

VEHNO

          VEHICLE NUMBER

NON-LABELED VARIABLE

VEHSTATE

       VEHICLE STATE

NON-LABELED VARIABLE

NOTE: Linkage Variable.

VEHTYPE

        VEHICLE TYPE

NOTE: Categories 50-55 apply to data generated before 2000.

VEHYR

          VEHICLE MODEL YEAR

NON-LABELED VARIABLE

NOTE: Model Year of the Vehicle (YYYY).

VIN

            VIN NUMBER

NON-LABELED VARIABLE

NOTE: Vehicle Identification Number.

LIST OF VARIABLES FOR THE OHIO INJURED OCCUPANTS SUBFILE

SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
AGE OCCUPANT AGE Inj. Occupants NUM 66
AIRBAG AIRBAG Inj. Occupants NUM 66
AIRBAG_SW AIRBAG SWITCH Inj. Occupants NUM 66
ALCOHOL_TEST_STATUS ALCOHOL TEST STATUS Inj. Occupants NUM 66
ALTSTTYP ALCOHOL TEST TYPE Inj. Occupants NUM 67
BAC BLOOD ALCOHOL CONTENT IN % Inj. Occupants CHA(3) 67
CASENO UNIQUE ACCIDENT CASE NUMBER Inj. Occupants CHA(11) 67
CIT_LOC_CDE CITATION LOCAL CODE Inj. Occupants NUM 67
CITATION CITATION GIVEN Inj. Occupants CHA(11) 67
DL_CLASS DL CLASS Inj. Occupants CHA(2) 67
DL_STATE DL STATE Inj. Occupants CHA(2) 68
DLCOUNTY DL COUNTY Inj. Occupants CHA(3) 68
DRG_RES1 DRUG TEST 1 RESULT Inj. Occupants NUM 68
DRG_RES2 DRUG TEST 2 RESULT Inj. Occupants NUM 68
DRUG_INV DRUGS INVOLVED Inj. Occupants NUM 68
DRUG_TEST_STATUS DRUGS TEST STATUS Inj. Occupants NUM 68
DRUG_TEST_TYPE DRUG TEST TYPE Inj. Occupants NUM 69
EJECT EJECTED FROM VEHICLE Inj. Occupants NUM 69
HELMET HELMET USE Inj. Occupants CHA(1) 69
INJ OCCUPANT INJURY Inj. Occupants NUM 69
P_TYPE OCCUPANT TYPE Inj. Occupants CHA(1) 69
PHYSCOND PEDESTRIAN PHYSICAL CONDITION Inj. Occupants NUM 69
REST1 SAFETY EQUIPMENT Inj. Occupants NUM 70
SEATPOS SEATING POSITION Inj. Occupants NUM 70
SEX OCCUPANT GENDER Inj. Occupants CHA(1) 71
SOB_TST ALCOHOL INVOLVED Inj. Occupants NUM 71
TAKEN_BY INJURED TAKEN BY Inj. Occupants NUM 71
TRAPPED TRAPPED Inj. Occupants NUM 71
VEHNO VEHICLE NUMBER Inj. Occupants NUM 71

NOTE:   This file contains information on all passengers plus injured (but not uninjured) drivers.

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE OHIO STATE INJURED OCCUPANTS SUBFILE

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

AGE

            OCCUPANT AGE

AIRBAG

         AIRBAG

NOTE: Variable added in 2000.

AIRBAG_SW

      AIRBAG SWITCH

ALCOHOL_TEST_STATUS

ALCOHOL TEST STATUS

NOTE: Categories 7 and 8 apply for data generated before 2000.

ALTSTTYP

       ALCOHOL TEST TYPE

BAC

            BLOOD ALCOHOL CONTENT IN %

NON-LABELED VARIABLE

CASENO

         UNIQUE ACCIDENT CASE NUMBER

NON-LABELED VARIABLE

NOTE: Accident Case Number. The first 4 digits show the accident year.

CIT_LOC_CDE

    CITATION LOCAL CODE

NOTE: Variable added in 2000.

CITATION

       CITATION GIVEN

NOTE: Variable discontinued in 2000.

DL_CLASS

       DL CLASS

NOTE: Variable discontinued in 2000.

DL_STATE

       DL STATE

NON-LABELED VARIABLE

DLCOUNTY

       DL COUNTY

NOTE: See formats in the accident section of the guidebook.

DRG_RES1

       DRUG TEST 1 RESULT

DRG_RES2

       DRUG TEST 2 RESULT

DRUG_INV

       DRUGS INVOLVED

NOTE: Variable discontinued in 2000.

DRUG_TEST_STATUS

    DRUGS TEST STATUS

NOTE: Categories 7 and 8 apply for data generated before 2000.

DRUG_TEST_TYPE

     DRUG TEST TYPE

EJECT

          EJECTED FROM VEHICLE

NOTE: Category 6 applies for data generated before 2000.

HELMET

         HELMET USE

NOTE: Variable discontinued in 2000.

INJ

            OCCUPANT INJURY

P_TYPE

         OCCUPANT TYPE

PHYSCOND

       PEDESTRIAN PHYSICAL CONDITION

REST1

          SAFETY EQUIPMENT

MOTORIST

NON-MOTORIST

NOTE: Categories 15-17 apply for data generated before 2000.

SEATPOS

        SEATING POSITION

NOTE: Categories 20-26 apply for data generated before 2000.

SEX

            OCCUPANT GENDER

SOB_TST

        ALCOHOL INVOLVED

NOTE: Categories 0 and 7 apply for data generated before 2000.

TAKEN_BY

       INJURED TAKEN BY

NOTE: Variable added in 2000.

TRAPPED

        TRAPPED

NOTE: Variable added in 2000.

VEHNO

          VEHICLE NUMBER

NON-LABELED VARIABLE

NOTE: Linkage Variable.

LIST OF VARIABLES FOR THE OHIO ROADLOG FILE

SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
AADT WEIGHTED AVERAGE TOTAL ADT Roadlog NUM 75
AADT_BC ADT FOR TYPE B AND C TRUCKS Roadlog NUM 75
AADT_PT ADT FOR PASSENGER CARS AND A TYPE TRUCKS Roadlog NUM 75
AADT_YR YEAR OF ADT COUNTS Roadlog CHA(2) 76
ACCESS ACCESS CONTROL Roadlog CHA(1) 76
AREA_CDE AREA CODE Roadlog NUM 76
BEGMP BEGINNING MILE POST Roadlog NUM 76
CNT_TLOG COUNTY TRUE LOG Roadlog NUM 76
CNTY_RTE COUNTY ROUTE Roadlog CHA(8) 76
COUNTY COUNTY Roadlog CHA(3) 77
DISTRICT DISTRICT Roadlog NUM 77
DIVIDED ROAD IDENTIFICATION Roadlog CHA(1) 77
ENDMP END MILE POST Roadlog NUM 77
FED_ACES FEDERAL ACCESS CONTROL Roadlog CHA(1) 77
FED_FACI FHWA TYPE OF FACILITY Roadlog CHA(1) 77
FED_MEDW FHWA MEDIAN WIDTH Roadlog CHA(3) 78
FED_SPSY FHWA SPECIAL SYSTEMS Roadlog CHA(2) 78
FIPS_CDE FIPS CODE Roadlog CHA(5) 78
FUNC_CLS FUNCTIONAL CLASS Roadlog CHA(2) 78
HOV FHWA HOV VEHICLES Roadlog NUM 78
HPMS HPMS CODES Roadlog CHA(1) 79
ID_CNTRL ID CONTROL CODE Roadlog CHA(1) 79
INV_DTE INVENTORY DATE Roadlog CHA(4) 79
JUR_TYPE JURISDICTION Roadlog CHA(1) 79
LRS_BGPT LRS BEGINNING MILE POINT Roadlog CHA(7) 79
LRS_BNDE LRS B NODE Roadlog CHA(4) 79
LRS_EDPT LRS ENDING MILE POINT Roadlog CHA(7) 80
LRS_ENDE LRS END NODE Roadlog CHA(4) 80
LRS_ID LRS INVENTORY ROUTE NUMBER(10 CHARC) + LRS SUBROUTE NUMBER Roadlog CHA(12) 80
LRS_INRT LRS INVENTORY ROUTE NUMBER Roadlog CHA(10) 81
LRS_NDCN LRS NODE CODE (COUNTY/STATE) Roadlog CHA(2) 81
LRS_NDNM LRS NODE NAME Roadlog CHA(10) 81
LRS_NDSQ LRS NODE SEQUENCE NUMBER Roadlog CHA(3) 81
LRS_NRDE LRS NODE RTE DESIGNATION Roadlog CHA(5) 81
LRS_SBRT LRS SUBROUTE NUMBER Roadlog CHA(2) 81
MED_TYPE FHWA MEDIAN TYPE Roadlog CHA(1) 81
MED_WID MEDIAN WIDTH Roadlog NUM 82
MI_CLASS MILE CLASS (INCORPORATED/ UNINCORPORATED) Roadlog CHA(1) 82
MUN_NAM MUNICIPALITY NAME Roadlog CHA(16) 82
MVMT MILLION VEHICLE MILES OF TRAVEL Roadlog NUM 82
NHS_CDE NATIONAL HIGHWAY SYSTEM CODE Roadlog CHA(1) 82
NHS_INTR NHS INTERMODAL NUMBER Roadlog CHA(2) 83
NO_LANES NUMBER OF LANES Roadlog NUM 83
PAS_NHS PAS/NHS INTERSECTION MARKER Roadlog CHA(1) 83
PAV_ROUG PAVEMENT ROUGHNESS Roadlog CHA(3) 83
PAVECOND PAVEMENT CONDITION Roadlog CHA(2) 83
PK_LANES PEAK LOAD LANES Roadlog CHA(3) 84
POP_GRP POPULATION Roadlog CHA(4) 84
RD_WIDTH ROADWAY WIDTH THRU LANES N/MEDIANS Roadlog NUM 84
RODWYCLS ROADWAY TYPES Roadlog CHA(2) 84
RTE_NBR STATE ROUTE NUMBER Roadlog CHA(5) 85
RTE_SUFX STATE ROUTR NUMBER SUFFIX Roadlog CHA(1) 85
RTE_TYPE ROUTE TYPE Roadlog NUM 85
RURUID POPULATION (OVE/UNDER 5000) Roadlog CHA(1) 85
SCENIC SCENIC BYWAYS Roadlog CHA(1) 86
SEG_LNG SEGMENT LENGTH Roadlog NUM 86
SEQ_NBR SEQUENCE NUMBER Roadlog CHA(1) 86
SHWD_LEFT_INSIDE SHOULDER LEFT INSIDE Roadlog NUM 86
SHWD_LEFT_OUTSIDE SHOULDER RIGHT OUTSIDE Roadlog NUM 86
SHWD_RIGHT_INSIDE SHOULDER LEFT OUTSIDE Roadlog NUM 86
SHWD_RIGHT_OUTSIDE SHOULDER RIGHT INSIDE Roadlog NUM 86
SPDLIMT SPEED LIMIT Roadlog NUM 86
SRF_BAS STANDARD BASE CLASSIFICATION Roadlog CHA(1) 87
SRF_BASL LEFT SIDE SURFACE BASE TYPE Roadlog CHA(1) 87
SRF_BASR RIGHT SIDE SURFACE BASE CLASS TYPE Roadlog CHA(1) 87
SRF_TYPF SUMMARY OF FHWA SURFACE TYPE Roadlog CHA(2) 88
SRF_TYPL LEFT SIDE STANDARD SURFACE TYPE Roadlog CHA(1) 88
SRF_TYPR RIGHT SIDE SURFACE CLASS TYPE Roadlog CHA(1) 88
SRFTYPLL LEFT SIDE FHWA SURFACE TYPE Roadlog CHA(2) 89
SRFTYPLR FHWA RIGHT SIDE SURFACE TYPE Roadlog CHA(2) 89
STAT_EQ STATION EQUATION SORT FILED Roadlog NUM 89
STN_SUF STREET NAME SUFFIX Roadlog CHA(4) 90
STR_PFX STREET NAME DIRECTIONAL PREFIX Roadlog CHA(1) 90
STRT_DIR STREET NAME DIRECTIONAL SUFFIX Roadlog CHA(1) 90
STRT_NAM STREET NAME Roadlog CHA(22) 90
SURF_TYP STANDARD SURFACE CLASSIFICATION Roadlog CHA(1) 90
SURF_WID SURFACE WIDTH THRU LANES N/SHOULDERS Roadlog NUM 91
SURFWIDL LEFT SIDE SURFACE WIDTH IN FEET Roadlog NUM 91
SURFWIDR RIGHT SIDE SURFACE WIDTH IN FEET Roadlog NUM 91
SYS_CLAS SYSTEM CLASS Roadlog CHA(1) 92
UPDT_YR UPDATE YEAR Roadlog CHA(4) 92

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE OHIO ROADLOG FILE

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

AADT

           WEIGHTED AVERAGE TOTAL ADT

NOTE: This variable gives the total AADT.

AADT_BC

        ADT FOR TYPE B AND C TRUCKS

NOTE: This variable gives the AADT for medium and large trucks. This includes tractor or truck with semi-trailers and trucks with trailers; single unit trucks most generally with dual rear tires (may be greater than 2-axle units).

AADT_PT

        ADT FOR PASSENGER CARS AND A TYPE TRUCKS

NOTE: This variable gives the AADT for passenger cars and small trucks. This includes panel and pick-up trucks, motorized recreational vehicles and school buses.

AADT_YR

        YEARS OF ADT COUNTS

NON-LABELED VARIABLE

ACCESS

         ACCESS CONTROL

NOTE: Access control as defined by OH State. For example, ‘F’ indicates that Ohio DOT owns the access control and can change it whenever deemed required. The use of this variable may result in some difficulties and we recommend the use of FED_ACES to get information on the access control of segments.

AREA_CDE

       AREA CODE

NON-LABELED VARIABLE

BEGMP

          BEGINNING MILE POST

NON-LABELED VARIABLE – Beginning milepost in miles (XXX.XX)

CNT_TLOG

       COUNTY TRUE LOG

NON-LABELED VARIABLE

NOTE: This field is the true log mileage for the route within the county.

CNTY_RTE

       COUNTY ROUTE

NON-LABELED VARIABLE – Linkage Variable consisting of COUNTY + RTE_NBR + RTE_SUFX + STATE_EQ

NOTE: From year 2000, STATE_EQ is not required. Also RTE_SUFX became last digit of RTE_NBR.

COUNTY

         COUNTY

NOTE: See listings under accident section of the guidebook.

DISTRICT

       DISTRICT

NON-LABELED VARIABLE

DIVIDED

        ROAD IDENTIFICATION

ENDMP

          END MILE POST

NON-LABELED VARIABLE

NOTE: Ending milepost in miles (XXX.XX).

FED_ACES

       FEDERAL ACCESS CONTROL

NOTE: Data is accurate for segments falling under category “1” beginning from 1998. 1997 data appears to have some errors. It should be noted that category “1” represents all interstates or interstates look alike segments with no at grade intersections. The accuracy of segments falling under other access control categories (2, 3 or 4), is still being reviewed.

FED_FACI

       FHWA TYPE OF FACILITY

NOTE: FHWA HPMS required item.

FED_MEDW

       FHWA MEDIAN WIDTH

NON-LABELED VARIABLE

NOTE: FHWA required Median width. OH collects this variable for FHWA purpose. We are not sure about the data quality of this variable and recommend the use of MED_WID for all purposes.

FED_SPSY

       FHWA SPECIAL SYSTEMS

NOTE: FHWA HPMS required item.

FIPS_CDE

       FIPS CODE (GENERATED FOR MUNI SECTIONS ONLY)

NON-LABELED VARIABLE

FUNC_CLS

       FUNCTIONAL CLASS

HOV

            FHWA HOV VEHICLES

NOTE: FHWA HPMS required item.

HPMS

           HPMS CODES

NOTE: An HPMS code indicates a section that was selected at random to be monitored periodically for changes, as defined in the FHWA HPMS field manual (HPMS = Highway Performance Monitoring System).

ID_CNTRL

       ID CONTROL CODE

INV_DTE

        INVENTORY DATE

NON-LABELED VARIABLE

JUR_TYPE

       JURISDICTION

LRS_BGPT

       LRS BEGINNING MILE POINT

NON-LABELED VARIABLE

LRS_BNDE

       LRS B NODE

NOTE: It is used to build the node/link files for the LRS (Linear Referencing System). Up to four attributes (in any sequence) may be coded for the node.  This field indicates the beginning of a node or the continuation of a node.

LRS_EDPT

       LRS ENDING MILE POINT

NON-LABELED VARIABLE

LRS_ENDE

       LRS END NODE

NOTE: It is used to build the node/link files for the LRS (Linear Referencing System). Up to four attributes (in any sequence) may be coded for the node.  This field indicates the ending of a node or the continuation of a node. The formats of these attributes are available with HSIS staff and will be provided upon request.

LRS_ID

         LRS Inventory Route Number (10 CHARAC) + LRS Sub-route Number

NON-LABELED VARIABLE

NOTE: This field is used for HPMS Item 7B in the conversion.  It is used as part of the LRS location identifier. If coded – record must be PAS (Principal Arterial System) or NHS (National Highway System) or Rural Minor Arterial (functional class is 06).

LRS_INRT

       LRS INVENTORY ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: This is a number used to uniquely identify a route within a county or perhaps throughout the state.

LRS_NDCN

       LRS NODE CODE (COUNTY)

LRS_NDNM

       LRS NODE NAME

NON-LABELED VARIABLE

NOTE: It is used to build the node/link files for the LRS (Linear Referencing System). It is comprised of a node code, node route, and a node sequence number. It is used to identify a node. An ‘*’ after the column numbers indicates that this field will be broken down into some individual fields immediately following this field. A ‘+’ after the column numbers indicates that this is a sub-field.

LRS_NDSQ

       LRS NODE SEQUENCE NUMBER

NON-LABELED VARIABLE

LRS_NRDE

       LRS NODE RTE DESIGNATION

NON-LABELED VARIABLE

LRS_SBRT

       LRS SUBROUTE NUMBER

NON-LABELED VARIABLE

NOTE: This is a number that uniquely identifies the AHEAD and BACK portions of an inventory route section where duplicate log points occur.

MED_TYPE

       FHWA MEDIAN TYPE

NOTE: This variable has usable data only for 2001. We checked the total mileage for divided segments and segments having valid median types and found that they were consistent for only 2001 data. The use of this variable for years before 2001 is not recommended.

MED_WID

        MEDIAN WIDTH

NOTE: This field is coded for divided highways and is blank for undivided highways. For 1997 – 2000 data, 99 indicates 99 or higher. For future years median widths greater than 99 is available. This variable is to be used to get information on Median widths for all analysis.

MI_CLASS

       MILE CLASS (INCORPORATED/UNINCORPORATED)

MUN_NAM

        MUNICIPALITY NAME

NON-LABELED VARIABLE

MVMT

           MILLION VEHICLE MILES OF TRAVEL (CREATED)

NON-LABELED VARIABLE

NHS_CDE

        NATIONAL HIGHWAY SYSTEM CODE

NOTE: NHS replaces the old Federal-Aid system. All interstate routes are coded ‘N’. Codes 2-9 (intermodal connectors) are new for June 1997 FHWA HPMS submittal.

NHS_INTR

       NHS INTERMODAL NUMBER

NON-LABELED VARIABLE

NOTE: This field will be used to uniquely identify each NHS intermodal route.

NO_LANES

       NUMBER OF LANES

PAS_NHS

        PAS/NHS INTERSECTION MARKER

NOTE: This field in needed for the Linear Referencing System (LRS) reporting required by HPMS.

PAV_ROUG

       PAVEMENT ROUGHNESS

NON-LABELED VARIABLE

PAVECOND

       PAVEMENT CONDITION

PK_LANES

       PEAK LOAD LANES

NON-LABELED VARIABLE

NOTE: Peak lanes are the prevailing number of thru lanes carrying traffic during peak hours of use.

POP_GRP

        POPULATION

NOTE: Population figure is in hundreds. This variable is populated only when MI_CLASS = 2 (Municipal).

RD_WIDTH

       ROADWAY WIDTH THRU LANES N/MEDIANS

NOTE: Highway surface width plus shoulders (in feet). Median width is not included. For 1997 – 1999 data category 99 indicates 99 or higher. For future years observations on roadway widths greater than 99 is available.

RODWYCLS

       ROADWAY TYPES (CREATED)

NOTE: Created variable added to accident and roadway inventory files. See Discussion.

RTE_NBR

        STATE ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: From year 2000, this variable became 5 characters with first digit being ‘0’ and last digit as RTE_SUFX.

RTE_SUFX

       STATE ROUTE NUMBER SUFFIX

NOTE: Code ‘I’ is for a route within an interchange used to connect ramps.

RTE_TYPE

       ROUTE TYPE (GENERATED)

RURUID

         POPULATION (OVER/UNDER 5000) GENERATED

NOTE: This variable is populated only when MI_CLASS = 2(Municipal).

SCENIC

         SCENIC BYWAYS

SEG_LNG

        SEGMENT LENGTH

NON-LABELED VARIABLE – Length of section in miles (XXX.XX)

SEQ_NBR

        SEQUENCE NUMBER

NON-LABELED VARIABLE

NOTE: Variable added in 2005.

SHWD_LEFT_INSIDE

    SHOULDER LEFT INSIDE

SHWD_LEFT_OUTSIDE

   SHOULDER LEFT OUTSIDE

SHWD_RIGHT_INSIDE

   SHOULDER RIGHT INSIDE

SHWD_RIGHT_OUTSIDE

  SHOULDER RIGHT OUTSIDE

SPDLIMT

        SPEED LIMIT

NOTE: Quality of data is questionable for 1997 to 1999.  Approximately 80 percent of the mileage in our system doesn’t have speed limit information for 1997 and 1998. For 1999, about 50 percent of mileage doesn’t have this information. For 2000 and 2001 data, this field covers about 99 percent of the mileage.

SRF_BAS

        STANDARD BASE CLASSIFICATION

SRF_BASL

       LEFT SIDE SURFACE BASE TYPE

SRF_BASR

       RIGHT SIDE SURFACE BASE CLASS TYPE

SRF_TYPF

       SUMMARY OF FHWA SURFACE TYPE

NOTE: This variable is collected for FHWA purposes. Though the codes are generally similar to SURF_TYP variable they do not match exactly. We recommend using SURF_TYP variable for all analysis.

SRF_TYPL

       LEFT SIDE STANDARD SURFACE CLASS

NOTE: Categories are same as standard surface type (SURF_TYP). It is populated only for divided segments or for those segments that have a combination base. Categories E, X or Z of SRF_BAS variable denote combination bases.

SRF_TYPR

       RIGHT SIDE SURFACE CLASS TYPE

NOTE: This variable is populated only for divided segments or for segments having a combination base. Combination bases are denoted by categories E, X or Z of standard Base classification variable (SRF_BAS). The codes of this SRF_TYPL and SRF_TYPR vary only when SURF_TYP is combined denoted by category A.

SRFTYPLL

       LEFT SIDE FHWA SURFACE TYPE

NOTE: This variable is collected for FHWA purposes. Though the codes are generally similar to SRF_TYPL, they don’t match exactly. We suggest that SRF_TYPL be used for all analysis.

SRFTYPLR

       FHWA RIGHT SIDE SURFACE TYPE

NOTE: The variable is collected for FHWA purposes. Though the codes are generally similar to SRF_TYPR, they don’t match exactly. We recommend that SRF_TYPR be used for all purposes.

STAT_EQ

        STATION EQUATION SORT FIELD

NON-LABELED VARIABLE

NOTES: (1) This sort code enables the records for a route to be sorted in the correct order (as the route would be driven).

(2) Variable discontinued in 2002.

STN_SUF

        STREET NAME SUFFIX

NON-LABELED VARIABLE

NOTE: Based on US Postal Service suffix abbreviations.  The street name field must be coded for this field to coded, except for suffix RAMP. For suffix RAMP, the street name field may be blank.

STR_PFX        STREET NAME DIRECTIONAL PREFIX

NOTE: This field is a directional prefix associated with the street name. The street name field must be coded for this field to be coded.

STRT_DIR

       STREET NAME DIRECTIONAL SUFFIX

NOTE: The street name field must be coded for this field to be coded.

STRT_NAM

       STREET NAME

NON-LABELED VARIABLE

NOTE: This name should correspond with maps and street signs.

SURF_TYP

       STANDARD SURFACE CLASSIFICATION

NOTE: This is the variable to be used to capture information on surface types for all analysis.

SURF_WID

       SURFACE WIDTH THRU LANES N/SHOULDERS

NOTE: Units are in feet. For 1997–1999, 99 indicates 99 or higher. For future years median widths greater than 100 feet are captured.

SURFWIDL

       LEFT SIDE SURFACE WIDTH IN FEET

NOTE: This variable is populated for divided segments and segments with combination bases. For combination bases, this variable provides the width of one unit of combined base. Categories E, X and Z of variable SRF_BAS denote combination bases.

SURFWIDR

       RIGHT SIDE SURFACE WIDTH IN FEET

NOTE: This variable is populated for divided segments and segments with combination bases. For combination bases, this variable provides the width of base other than that provided by SURFWIDL. For all segments having valid observations, summation of SURFWIDL and SURFWIDR always equals to SURF_WID.

SYS_CLAS

       SYSTEM CLASS

UPDT_YR

        UPDATE YEAR

NON-LABELED VARIABLE

NOTE: This code is the two digit year of update or change.

LIST OF VARIABLES FOR THE OHIO POINT FILE

SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
CHNG_YR RECORD CHANGE YEAR Point CHA(4) 94
CNTY_RTE COUNTY ROUTE Point CHA(8) 94
CNTYLOG COUNTY TRUE LOG Point CHA(4) 94
COUNTY COUNTY Point CHA(3) 94
DESC LOCATION DESCRIPTION Point CHA(32) 94
DISTRICT DISTRICT Point NUM 94
LOG_SUFX LOG POINT SUFFIX Point CHA(1) 94
MILEPOST LOG POINT Point NUM 94
MUNI_CDE MUNICIPAL CODE Point NUM 95
OVRLDIR OVERLAP LOG DIRECTION Point CHA(1) 95
REC_TYPE RECORD TYPE Point CHA(1) 95
RTE_DIR ROUTE DIRECTION Point CHA(2) 96
RTE_NBR STATE ROUTE NUMBER Point CHA(5) 96
RTE_PREF STATE ROUTE PREFIX Point CHA(1) 96
RTE_SUFX STATE ROUTE SUFFIX Point CHA(1) 96
SEQ_NBR SEQUENCE NUMBER Point CHA(1) 97
SPECDESC SPECIAL DESCRIPTION Point CHA(1) 97
STAT_EQ STATE EQUATION SORT Point CHA(1) 97
STRT_SUF STREET SUFFIX Point CHA(2) 97
TRUE_LOG STATE ROUTE TRUE LOG Point CHA(5) 98
XCNTYRTE CROSS ROAD COUNTY ROUTE Point CHA(1) 98
XLOG_SUF CROSS ROUTE LOG SUFFIX Point CHA(1) 98
XMILEPST CROSS ROUTE MILEPOST Point NUM 98
XRTE_NBR CROSS ROUTE NUMBER Point CHA(4) 98
XRTE_SUF CROOS ROUTE SUFFIX Point CHA(1) 98
XRTEPREF CROSS ROUTE PREFIX Point CHA(1) 99

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE OHIO POINT FILE

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

CHNG_YR

        RECORD CHANGE YEAR

NON-LABELED VARIABLE

NOTE: This is a four-digit year (yyyy).

CNTY_RTE

       COUNTY ROUTE

NON-LABELED VARIABLE

NOTE: Linkage variable consisting of COUNTY + RTE_NBR + RTE_SUFX + STAT_EQ. From year 2000, STATE_EQ is not required. Also RTE_SUFX became last digit of RTE_NBR.

CNTYLOG

        COUNTY TRUE LOG

NON-LABELED VARIABLE

COUNTY

         COUNTY

NOTE: See listings under accident section of the guidebook. 

DESC

           LOCATION DESCRIPTION

NON-LABELED VARIABLE

NOTE: Refer to “Notes” for REC_TYPE variable for more information.

DISTRICT

       DISTRICT

NON-LABELED VARIABLE

LOG_SUFX

       LOG POPINT SUFFIX

NON-LABELED VARIABLE

MILEPOST

       LOG POINT

NON-LABELED VARIABLE

NOTE: Milepost of the point in miles (XXX.XX).

MUNI_CDE

       MUNICIPAL CODE

NON-LABELED VARIABLE

NOTE: This field is for the three digit municipality code (political jurisdiction).

OVRLDIR

        OVERLAP LOG DIRECTION

REC_TYPE

       RECORD TYPE

NOTE: Categories F and W added in 1999.

The record types noted above define the types of records (e.g., beginning or route, beginning or gap) or facility (e.g., overpass, RR grade crossing) present at the given location. Details of the coding for these types area available from the HSIS staff upon request. However, since “at grade intersections” (Record type “I”) are of most interest to HSIS users, the following describes these intersection records. The location of the intersection on the mainline is specified by CNTY_RTE. The DESC variable contains the following information on the cross route and cross route log point.

Example: C0042Aclaremont

Position 1 – Prefix of the cross route.

Position 2-5 – Numeric route number of the cross route.

Position 6 – Route suffix of the cross route.

Position 7-32 – Alphabetic name of the cross route/street.

RTE_DIR

        ROUTE DIRECTION

NOTE: This is a two character field representing the general direction of the route. The first position always reflects the legal logged (inventoried) direction of the route. The second position is used as a tendency direction. The first position can not change during the course of the route.

RTE_NBR

        STATE ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: From year 2000, this variable became 5 characters with first digit being ‘0’ and last digit as RTE_SUFX.

RTE_PREF

       STATE ROUTE PREFIX

NOTE: An alphabetic character designating the type of route.

RTE_SUFX

       STATE ROUTE SUFFIX

NOTE: Code 'I' is for a route within an interchange used to connect ramps

SEQ_NBR

        SEQUENCE NUMBER

NON-LABELED VARIABLE

NOTE: This field allows more than one record with the same record type, at the same log point.

SPECDESC

       SPECIAL DESCRIPTION

NOTE: If this field is coded 'I', then the record type must be code 'O' or 'U'.

STAT_EQ

        STATE EQUATION SORT

NON-LABELED VARIABLE

NOTE: This sort code enables the records for a route to be sorted in the correct order (as the route would be driven).

STRT_SUF

       STREET SUFFIX

TRUE_LOG

       STATE ROUTE TRUE LOG

NON-LABELED VARIABLE

NOTE: This is a state based log point giving the physical mileage from a route's entry into the State or its beginning within the State. The mileage does not re-start at county boundaries and equations are eliminated.

XCNTYRTE

       CROSS ROAD COUNTY ROUTE

NON-LABELED VARIABLE

NOTE: Linkage variable consisting of COUNTY + RTE_NBR + RTE_SUFX + STATE_EQ.

XLOG_SUF

       CROSS ROUTE LOG SUFFIX

NOTE: "B" is for back station, which indicates that the log point is within a station equation. It is used for an add equation.

XMILEPST

       CROSS ROUTE MILEPOST

NON-LABELED VARIABLE

NOTE: Milepost of the crossing route in miles (XXX.XX).

XRTE_NBR

       CROSS ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: If this field is coded, then the cross route prefix must be coded.

XRTE_SUF

       CROSS ROUTE SUFFIX

NOTE: Code 'I' is for a route within an interchange used to connect ramps.

XRTEPREF

       CROSS ROUTE PREFIX

NOTE: An alphabetic character designating the type of cross route. If this field is coded, then the cross route number must be coded. If this field is coded: 'I' or 'U' or 'S', then the cross route suffix and cross route log must be coded.

LIST OF VARIABLES FOR THE OHIO CURVES FILE

SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
ACCESS ACCESS CONTROL Curves CHA(1) 102
AREACODE AREA CODE Curves NUM 102
BEGMP BEGIN LOG POINT OF CURVE Curves NUM 102
CNTY_RTE COUNTY ROUTE Curves CHA(8) 102
COUNTY COUNTY Curves CHA(3) 102
DEG_CURV DEGREE OF CURVE Curves NUM 102
DESC DESCRIPTION Curves CHA(18) 103
DIR_CURV DIRECTION OF CURVE Curves CHA(18) 103
DISTRICT DISTRICT Curves NUM 103
DIVIDED DIVIDED HIGHWAY INDICATOR Curves CHA(1) 103
ENDMP END LOG POINT OF CURVE Curves NUM 103
FUNC_CLS FUNCTIONAL CLASS Curves CHA(2) 103
INV_DATE YEAR OF CODING CHANGE Curves NUM 103
MILE_CLS MILE CLASS Curves CHA(1) 103
NO_LANES NUMBER OF LANES Curves NUM 104
RTE_NBR STATE ROUTE NUMBER Curves CHA(5) 104
RTE_SUFX STATE ROUTE SUFFIX Curves CHA(1) 104
SEG_LNG SEGMENT LENGTH Curves NUM 104
SEQ_NBR SEQUENCE NUMBER Curves NUM 105
STAT_EQU STATION EQUATION SORT FIELD Curves NUM 105
SYS_CLAS SYSTEM CLASS Curves CHA(1) 105

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE OHIO CURVES FILE

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

ACCESS

         ACCESS CONTROL

NOTE: Access control as defined by OH State. For example, ‘F’ indicates that Ohio DOT owns the access control and can change it whenever deemed required. The use of this variable may result in some difficulties and we recommend the use of FED_ACES to get information on the access control of segments.

AREACODE

       AREA CODE

NON-LABELED VARIABLE

BEGMP

          BEGIN LOG POINT OF CURVE

NON-LABELED VARIABLE

NOTE: Beginning milepost of the curve in miles (XXX.XX).

CNTY_RTE

       COUNT ROUTE

NON-LABELED VARIABLE

NOTE: Linkage variable consisting of COUNTY + RTE_NBR + RTE_SUFX + STAT_EQ. From year 2000, STATE_EQ is not required. Also RTE_SUFX became last digit of RTE_NBR.

COUNTY

         COUNTY

NOTE: See listings under accident section of the guidebook. 

DEG_CURV

       DEGREE OF CURVE

DESC

           DESCRIPTION

NON-LABELED VARIABLE

DIR_CURV

       DIRECTION OF CURVE

DISTRICT

       DISTRICT

NON-LABELED VARIABLE

DIVIDED

        DIVIDED HIGHWAY INDICATOR

ENDMP

          END LOG POINT OF CURVE

NON-LABELED VARIABLE

NOTE: Ending milepost of the curve in miles (XXX.XX).

FUNC_CLS

       FUNCTIONAL CLASS

INV_DATE

       YEAR OF CODING CHANGE

NON-LABELED VARIABLE

MILE_CLS

       MILE CLASS

NON-LABELED VARIABLE

NO_LANES

       NUMBER OF LANES

RTE_NBR

        STATE ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: From year 2000, this variable became 5 characters with first digit being ‘0’ and last digit as RTE_SUFX

RTE_SUFX

       STATE ROUTE SUFFIX

NOTE: Code 'I' is for a route within an interchange used to connect ramps.

SEG_LNG

        SEGMENT LENGTH

NON-LABELED VARIABLE

NOTE: Length of curve in miles (XXX.XX).

SEQ_NBR

        SEQUENCE NUMBER

NON-LABELED VARIABLE

STAT_EQU

       STATION EQUATION SORT FIELD

NON-LABELED VARIABLE

SYS_CLAS

       SYSTEM CLASS

LIST OF VARIABLES FOR THE OHIO GRADES FILE

SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
ACCESS ACCESS CONTROL Grades CHA(1) 108
AREACODE AREA CODE Grades NUM 108
BEGMP BEGIN LOG POINT OF CURVE Grades NUM 108
CNTY_RTE COUNTY ROUTE Grades CHA(8) 108
COUNTY COUNTY Grades CHA(3) 108
DESC DESCRIPTION Grades CHA(18) 108
DIR_GRAD DIRECTION OF GRADE Grades CHA(1) 108
DISTRICT DISTRICT Grades NUM 109
DIVIDED DIVIDED HIGHWAY INDICATOR Grades CHA(1) 109
ENDMP END LOG POINT OF CURVE Grades NUM 109
FUNC_CLS FUNCTIONAL CLASS Grades CHA(2) 109
INV_DATE YEAR OF CODING CHANGE Grades NUM 109
MILE_CLS MILE CLASS Grades CHA(1) 109
NO_LANES NUMBER OF LANES Grades NUM 109
PCT_GRAD PERCENT OF GRADE Grades NUM 110
RTE_NBR STATE ROUTE NUMBER Grades NUM 110
RTE_SUFX STATE ROUTE SUFFIX Grades CHA(1) 110
SEG_LNG SEGMENT LENGTH Grades NUM 110
SEQ_NBR SEQUENCE NUMBER Grades NUM 111
STAT_EQU STATION EQUATION SORT FIELD Grades NUM 111
SYS_CLAS SYSTEM CLASS Grades CHA(1) 111

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE OHIO GRADES FILE

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

ACCESS

         ACCESS CONTROL

NOTE: Access control as defined by OH state. For example, ‘F’ indicates that Ohio DOT owns the access control and can change it whenever deemed required. The use of this variable may result in some difficulties and we recommend the use of FED_ACES to get information on the access control of segments.

AREACODE

       AREA CODE

NON-LABELED VARIABLE

BEGMP

          BEGIN LOG POINT OF CURVE

NON-LABELED VARIABLE

NOTE: Beginning milepost of the grade in miles (XXX.XX).

CNTY_RTE

       COUNTY ROUTE COUNTY + RTE_NBR + RTE_SUFX + STAT_EQ

NON-LABELED VARIABLE

NOTE: Linkage variable consisting of COUNTY + RTE_NBR + RTE_SUFX + STAT_EQ. From year 2000, STATE_EQ is not required. Also RTE_SUFX became last digit of RTE_NBR.

COUNTY

         COUNTY

NOTE: See listings under accident section of the guidebook. 

DESC

           DESCRIPTION

NON-LABELED VARIABLE

DIR_GRAD

       DIRECTION OF GRADE

DISTRICT

       DISTRICT

NON-LABELED VARIABLE

DIVIDED

        DIVIDED HIGHWAY INDICATOR

ENDMP

          END LOG POINT OF CURVE

NON-LABELED VARIABLE

NOTE: Ending milepost in miles (XXX.XX).

FUNC_CLS

       FUNCTIONAL CLASS

INV_DATE

       YEAR OF CODING CHANGE

NON-LABELED VARIABLE

MILE_CLS

       MILE CLASS

NON-LABELED VARIABLE

NO_LANES

       NUMBER OF LANES

PCT_GRAD

       PERCENT OF GRADE

RTE_NBR

        STATE ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: From year 2000, this variable became 5 characters with first digit being ‘0’ and last digit as RTE_SUFX.

RTE_SUFX

       STATE ROUTE SUFFIX

NOTE: Code 'I' is for a route within an interchange used to connect ramps

SEG_LNG

        SEGMENT LENGTH

NON-LABELED VARIABLE

NOTE: Length of grade in feet (XXX.XX).

SEQ_NBR

        SEQUENCE NUMBER

NON-LABELED VARIABLE

STAT_EQU

       STATION EQUATION SORT FIELD

NON-LABELED VARIABLE

SYS_CLAS

       SYSTEM CLASS

LIST OF VARIABLES FOR THE OHIO ANGLE POINT FILE

SAS VARIABLE NAME DESCRIPTION SAS VARIABLE FILE FORMAT TYPE PAGE NO.
ACCESS ACCESS CONTROL Angle Point CHA(1) 114
AREACODE AREA CODE Angle Point NUM 114
BEGMP BEGIN LOG POINT OF CURVE Angle Point NUM 114
CNTY_RTE COUNTY ROUTE Angle Point CHA(8) 114
COUNTY COUNTY Angle Point CHA(3) 114
DEG_CURV DEGREE OG CURVE Angle Point NUM 114
DESC DESCRIPTION Angle Point CHA(18) 115
DIR_CURV DIRECTION OF CURVE Angle Point CHA(18) 115
DISTRICT DISTRICT Angle Point NUM 115
DIVIDED DIVIDED HIGHWAY INDICATOR Angle Point CHA(1) 115
ENDMP END LOG POINT OF CURVE Angle Point NUM 115
FUNC_CLS FUNCTIONAL CLASS Angle Point CHA(2) 115
INV_DATE YEAR OF CODING CHANGE Angle Point NUM 115
MILE_CLS MILE CLASS Angle Point CHA(1) 115
NO_LANES NUMBER OF LANES Angle Point NUM 116
RTE_NBR STATE ROUTE NUMBER Angle Point CHA(5) 116
RTE_SUFX STATE ROUTE SUFFIX Angle Point CHA(1) 116
SEG_LNG SEGMENT LENGTH Angle Point NUM 116
SEQ_NBR SEQUENCE NUMBER Angle Point NUM 117
STAT_EQU STATION EQUATION SORT FIELD Angle Point NUM 117
SYS_CLAS SYSTEM CLASS Angle Point CHA(1) 117

SAS FORMAT DEFINITIONS FOR VARIABLES FROM THE OHIO ANGLE POINT FILE

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

ACCESS

         ACCESS CONTROL

NOTE: Access control as defined by OH state. For example, ‘F’ indicates that Ohio DOT owns the access control and can change it whenever deemed required. The use of this variable may result in some difficulties and we recommend the use of FED_ACES to get information on the access control of segments.

AREACODE

       AREA CODE

NON-LABELED VARIABLE

BEGMP

          BEGIN LOG POINT OF CURVE

NON-LABELED VARIABLE

NOTE: Beginning milepost of the angle point in miles (XXX.XX). The value is same as ending milepost.

CNTY_RTE

       COUNTY ROUTE

NON-LABELED VARIABLE

NOTE: Linkage variable consisting of COUNTY + RTE_NBR + RTE_SUFX + STAT_EQ. From year 2000, STATE_EQ is not required. Also RTE_SUFX became last digit of RTE_NBR.

COUNTY

         COUNTY

NOTE: See listings under accident section of the guidebook. 

DEG_CURV

       DEGREE OF CURVE

DESC

           DESCRIPTION

NON-LABELED VARIABLE

DIR_CURV

       DIRECTION OF CURVE

DISTRICT

       DISTRICT

NON-LABELED VARIABLE

DIVIDED

        DIVIDED HIGHWAY INDICATOR

ENDMP

          END LOG POINT OF CURVE

NON-LABELED VARIABLE

NOTE: Ending milepost of the angle point in miles (XXX.XX). The value is same as beginning milepost.

FUNC_CLS

       FUNCTIONAL CLASS

INV_DATE

       YEAR OF CODING CHANGE

NON-LABELED VARIABLE

MILE_CLS

       MILE CLASS

NON-LABELED VARIABLE

NO_LANES

       NUMBER OF LANES

RTE_NBR

        STATE ROUTE NUMBER

NON-LABELED VARIABLE

NOTE: From year 2000, this variable became 5 characters with first digit being ‘0’ and last digit as RTE_SUFX.

RTE_SUFX

       STATE ROUTE SUFFIX

NOTE: Code 'I' is for a route within an interchange used to connect ramps.

SEG_LNG

        SEGMENT LENGTH

NON-LABELED VARIABLE

NOTE: All the segment lengths are zero since it describes only a point.

SEQ_NBR

        SEQUENCE NUMBER

NON-LABELED VARIABLE

STAT_EQU

       STATION EQUATION SORT FIELD

NON-LABELED VARIABLE

SYS_CLAS

       SYSTEM CLASS