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
(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.
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 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 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.
| 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 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 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.
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.
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.
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.
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.
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
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
NOTE: SAS variable names and longer explanatory names are shown above each listing. (See Discussion for in formation on SAS formats.)
ACCIDENT DATE
NON-LABELED VARIABLE
NOTE: Year/Month/Date of accident (YYYYMMDD).
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.
TYPE OF CRASH (FIRST HARMFUL EVENT)
ACCIDENT YEAR
NON-LABELED VARIABLE
NOTE: Year of Accident (YYYY).
TURN CRASH INDICATOR (GENERATED)
ANIMAL TYPE
UNIQUE ACCIDENT CASE NUMBER
NON-LABELED VARIABLE
NOTE: Accident Case Number. The first 4 digits show the accident year.
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
DIRECTION FROM REFERENCE
DIRECTION 1
DIRECTION 2
DISTANCE OFFSET
NON-LABELED VARIABLE
DISTRICT
NON-LABELED VARIABLE
ROAD IDENTIFICATION
VIOLATOR
FIPS CODE
NON-LABELED VARIABLE
INDICATES DUPLICATE RECORD GENERATION
NOTE: Categories 6 and 7 apply for data generated before 2000.
FREEWAY / NON-FREEWAY INDICATOR
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 OF DAY
INTERSTATE HIGHWAY INDICATOR
JURISDICTION
LIGHT CONDITION
LOCAL REPORT NUMBER
NON-LABELED VARIABLE
LOCATION
MILEPOST
NON-LABELED VARIABLE
NOTE: Milepost of crash in miles (XXX.XX).
MUNICIPALITY CODE
NON-LABELED VARIABLE
MILLION VEHICLE MILES OF TRAVEL
NON-LABELED VARIABLE
NATIONAL HIGHWAY SYSTEM INDICATOR
NUMBER OF LANES
NUMBER OF PEDESTRIANS
NON-LABELED VARIABLE
NUMBER OF VEHICLES
NON-LABELED VARIABLE
ON-OFF ROAD OCCURANCE
PEDESTRIANS INJURED
NON-LABELED VARIABLE.
NOTE: Variable added in 2000.
PEDESTRIANS KILLED
NON-LABELED VARIABLE.
NOTE: Variable added in 2000.
POPULATION
PUBLIC PROPERTY DAMAGE
RAMP CODE
NON-LABELED VARIABLE
CONTOUR OF ROADWAY
ROAD CONDITION
ROADWAY TYPE
NOTE: Urban crashes increased considerably from 2000 onwards due to OH DOT’s better ability to locate the crashes in this area.
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.
ORIGINAL JURISDICTION CODED BY HIGHWAY SAFETY
NON-LABELED VARIABLE
SPECIAL AREA CODE
CRASH SEVERITY (GENERATED)
CRASH SEVERITY (ORIGINAL)
SOURCE OF REPORT
STATION EQUATION SORT FIELD
NON-LABELED VARIABLE
NOTE: Not required from year 2000.
STREET ON
NON-LABELED VARIABLE
STREET AT/CROSS ROUTE
NON-LABELED VARIABLE
TYPE 1 TOTAL KILLED
TYPE 5 NO INDICATED INJURY
TYPE 0 INJURY NOT STATED
TYPE 2 SERIOUS VISIBLE INJURY
TYPE 3 MINOR VISIBLE INJURY
TYPE 4 NO VISIBLE INJURY
TOWNSHIP ABBREVIATION
NON-LABELED VARIABLE
TYPE OF REFERENCE
WEATHER CONDITION
DAY OF WEEK
| 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 |
NOTE: SAS variable names and longer explanatory names are shown above each listing. (See Discussion for information on SAS formats.)
ACCIDENT YEAR
NON-LABELED VARIABLE
ACTION
NOTE: Variable added in 2000.
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.
UNIQUE ACCIDENT CASE NUMBER
NON-LABELED VARIABLE
NOTE: Accident Case Number. The first 4 digits show the accident year.
TRUCK/BUS CDL CLASS
CONTRIBUTING FACTOR OF VEHICLE
MOTORIST
NON-MOTORIST
NOTE: Categories 34-37 and 40-48 apply to data generated before 2000.
VEHICLE DAMAGE SEVERITY (VDS)
NOTE: Variable added in 2000.
VEHICLE DAMAGE SCALE
VEHICLE DAMAGE SCALE
NOTE: Variable discontinued in 2000.
DIRECTION OF VEHICLE
NOTE: Variable discontinued in 2000.
DL CLASS
NOTE: Variable discontinued in 2000.
STATE
NON-LABELED VARIABLE
COUNTY
NOTE: See listings under accident section of the guidebook.
DRIVER AGE
DRIVER PRESENCE
NOTE: Variable discontinued in 2000.
DRIVER INJURY
DRIVER SAFETY EQUIPMENT
MOTORIST
NON-MOTORIST
DRIVE SEX
IN EMERGENCY RESPONSE
NOTE: Variable added in 2000.
SEQUENCE OF EVENTS 1
SEQUENCE OF EVENTS 2
SEQUENCE OF EVENTS 3
SEQUENCE OF EVENTS 4
NON-COLLISION
COLLISION W/PERSON, VEHICLE, OR OBJECT NOT FIXED
COLLISION WITH FIXED OBJECT
NOTE: Variables added in 2000.
FIRST HARMFUL EVENT
FIRE
NOTE: Variable discontinued in 2000.
TRUCK/BUS WEIGHT
HAZARDOUS MATERIAL RELEASED
NOTE: Variable added in 2000.
HAZARDOUS MATERIAL PLACARD
NOTE: Variable added in 2000.
VEHICLE INSURED
NON-MOTORIST LOCATION PRIOR TO IMPACT
MAKE OF VEHICLE
NON-LABELED VARIABLE
PRE-CRASH ACTIONS
MOTORIST
NON-MOTORIST
NOTE: Variable added in 2000.
MODEL OF VEHICLE
NON-LABELED VARIABLE
MOST HARMFUL EVENT
MOVEMENT OF VEHICLE
NOTE: Codes 1-17 are for driver actions and 18 onwards are for pedestrian actions.
NUMBER OF OCCUPANTS
NUMBER OF VEHICLES
NON-LABELED VARIABLE
OBJECT STRUCK BY VEHICLE
NOTE: Variable discontinued in 2000.
ODOT-AT-FAULT-FLAG
NON-LABELED VARIABLE
ODOT-PEOPLE-FOUND-COUNT
NON-LABELED VARIABLE
VEHICLE OWNERSHIP
PUBLIC PROPERTY DAMAGE
PUBLIC PROPERTY DAMAGE
NOTE: Variable discontinued in 2000.
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.
STRIKING VEHICLE
TOWED FLAG
TRAFFIC CONTROL OF VEHICLE
NOTE: Categories 20 and 21 apply to data generated before 2000.
CARGO BODY TYPE
NOTE: Variable added in 2000.
TYPE OF TRUCK LOAD
NOTE: Variable discontinued in 2000.
NUMBER OF TRUCK AXLES
NON-LABELED VARIABLE
SPEED DETECTED
VEHICLE DISPOSITION
VEHICLE/NON-MOTORIST DIRECTION
VEHICLE/NON-MOTORIST DIRECTION TO
SPEED OF VEHICLE
NOTE: Variable added in 2000.
ESTIMATED SPEED OF VEHICLE
NOTE: Variable discontinued in 2000.
PRIMARY CONDITION 1
PRIMARY CONDITION 2
VEHICLE NUMBER
NON-LABELED VARIABLE
VEHICLE STATE
NON-LABELED VARIABLE
NOTE: Linkage Variable.
VEHICLE TYPE
NOTE: Categories 50-55 apply to data generated before 2000.
VEHICLE MODEL YEAR
NON-LABELED VARIABLE
NOTE: Model Year of the Vehicle (YYYY).
VIN NUMBER
NON-LABELED VARIABLE
NOTE: Vehicle Identification Number.
| 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.
NOTE: SAS variable names and longer explanatory names are shown above each listing. (See Discussion for information on SAS formats.)
OCCUPANT AGE
AIRBAG
NOTE: Variable added in 2000.
AIRBAG SWITCH
ALCOHOL TEST STATUS
NOTE: Categories 7 and 8 apply for data generated before 2000.
ALCOHOL TEST TYPE
BLOOD ALCOHOL CONTENT IN %
NON-LABELED VARIABLE
UNIQUE ACCIDENT CASE NUMBER
NON-LABELED VARIABLE
NOTE: Accident Case Number. The first 4 digits show the accident year.
CITATION LOCAL CODE
NOTE: Variable added in 2000.
CITATION GIVEN
NOTE: Variable discontinued in 2000.
DL CLASS
NOTE: Variable discontinued in 2000.
DL STATE
NON-LABELED VARIABLE
DL COUNTY
NOTE: See formats in the accident section of the guidebook.
DRUG TEST 1 RESULT
DRUG TEST 2 RESULT
DRUGS INVOLVED
NOTE: Variable discontinued in 2000.
DRUGS TEST STATUS
NOTE: Categories 7 and 8 apply for data generated before 2000.
DRUG TEST TYPE
EJECTED FROM VEHICLE
NOTE: Category 6 applies for data generated before 2000.
HELMET USE
NOTE: Variable discontinued in 2000.
OCCUPANT INJURY
OCCUPANT TYPE
PEDESTRIAN PHYSICAL CONDITION
SAFETY EQUIPMENT
MOTORIST
NON-MOTORIST
NOTE: Categories 15-17 apply for data generated before 2000.
SEATING POSITION
NOTE: Categories 20-26 apply for data generated before 2000.
OCCUPANT GENDER
ALCOHOL INVOLVED
NOTE: Categories 0 and 7 apply for data generated before 2000.
INJURED TAKEN BY
NOTE: Variable added in 2000.
TRAPPED
NOTE: Variable added in 2000.
VEHICLE NUMBER
NON-LABELED VARIABLE
NOTE: Linkage Variable.
| 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 |
NOTE: SAS variable names and explanatory names are shown above each listing. (See Discussion for information on SAS formats.)
WEIGHTED AVERAGE TOTAL ADT
NOTE: This variable gives the total AADT.
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).
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.
YEARS OF ADT COUNTS
NON-LABELED VARIABLE
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 CODE
NON-LABELED VARIABLE
BEGINNING MILE POST
NON-LABELED VARIABLE – Beginning milepost in miles (XXX.XX)
COUNTY TRUE LOG
NON-LABELED VARIABLE
NOTE: This field is the true log mileage for the route within the county.
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
NOTE: See listings under accident section of the guidebook.
DISTRICT
NON-LABELED VARIABLE
ROAD IDENTIFICATION
END MILE POST
NON-LABELED VARIABLE
NOTE: Ending milepost in miles (XXX.XX).
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.
FHWA TYPE OF FACILITY
NOTE: FHWA HPMS required item.
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.
FHWA SPECIAL SYSTEMS
NOTE: FHWA HPMS required item.
FIPS CODE (GENERATED FOR MUNI SECTIONS ONLY)
NON-LABELED VARIABLE
FUNCTIONAL CLASS
FHWA HOV VEHICLES
NOTE: FHWA HPMS required item.
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 CONTROL CODE
INVENTORY DATE
NON-LABELED VARIABLE
JURISDICTION
LRS BEGINNING MILE POINT
NON-LABELED VARIABLE
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 ENDING MILE POINT
NON-LABELED VARIABLE
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 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 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 NODE CODE (COUNTY)
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 NODE SEQUENCE NUMBER
NON-LABELED VARIABLE
LRS NODE RTE DESIGNATION
NON-LABELED VARIABLE
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.
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.
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.
MILE CLASS (INCORPORATED/UNINCORPORATED)
MUNICIPALITY NAME
NON-LABELED VARIABLE
MILLION VEHICLE MILES OF TRAVEL (CREATED)
NON-LABELED VARIABLE
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 INTERMODAL NUMBER
NON-LABELED VARIABLE
NOTE: This field will be used to uniquely identify each NHS intermodal route.
NUMBER OF LANES
PAS/NHS INTERSECTION MARKER
NOTE: This field in needed for the Linear Referencing System (LRS) reporting required by HPMS.
PAVEMENT ROUGHNESS
NON-LABELED VARIABLE
PAVEMENT CONDITION
PEAK LOAD LANES
NON-LABELED VARIABLE
NOTE: Peak lanes are the prevailing number of thru lanes carrying traffic during peak hours of use.
POPULATION
NOTE: Population figure is in hundreds. This variable is populated only when MI_CLASS = 2 (Municipal).
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.
ROADWAY TYPES (CREATED)
NOTE: Created variable added to accident and roadway inventory files. See Discussion.
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.
STATE ROUTE NUMBER SUFFIX
NOTE: Code ‘I’ is for a route within an interchange used to connect ramps.
ROUTE TYPE (GENERATED)
POPULATION (OVER/UNDER 5000) GENERATED
NOTE: This variable is populated only when MI_CLASS = 2(Municipal).
SCENIC BYWAYS
SEGMENT LENGTH
NON-LABELED VARIABLE – Length of section in miles (XXX.XX)
SEQUENCE NUMBER
NON-LABELED VARIABLE
NOTE: Variable added in 2005.
SHOULDER LEFT INSIDE
SHOULDER LEFT OUTSIDE
SHOULDER RIGHT INSIDE
SHOULDER RIGHT OUTSIDE
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.
STANDARD BASE CLASSIFICATION
LEFT SIDE SURFACE BASE TYPE
RIGHT SIDE SURFACE BASE CLASS TYPE
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.
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.
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.
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.
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.
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.
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.
STREET NAME DIRECTIONAL SUFFIX
NOTE: The street name field must be coded for this field to be coded.
STREET NAME
NON-LABELED VARIABLE
NOTE: This name should correspond with maps and street signs.
STANDARD SURFACE CLASSIFICATION
NOTE: This is the variable to be used to capture information on surface types for all analysis.
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.
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.
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.
SYSTEM CLASS
UPDATE YEAR
NON-LABELED VARIABLE
NOTE: This code is the two digit year of update or change.
| 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 |
NOTE: SAS variable names and explanatory names are shown above each listing. (See Discussion for information on SAS formats.)
RECORD CHANGE YEAR
NON-LABELED VARIABLE
NOTE: This is a four-digit year (yyyy).
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 TRUE LOG
NON-LABELED VARIABLE
COUNTY
NOTE: See listings under accident section of the guidebook.
LOCATION DESCRIPTION
NON-LABELED VARIABLE
NOTE: Refer to “Notes” for REC_TYPE variable for more information.
DISTRICT
NON-LABELED VARIABLE
LOG POPINT SUFFIX
NON-LABELED VARIABLE
LOG POINT
NON-LABELED VARIABLE
NOTE: Milepost of the point in miles (XXX.XX).
MUNICIPAL CODE
NON-LABELED VARIABLE
NOTE: This field is for the three digit municipality code (political jurisdiction).
OVERLAP LOG DIRECTION
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.
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.
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.
STATE ROUTE PREFIX
NOTE: An alphabetic character designating the type of route.
STATE ROUTE SUFFIX
NOTE: Code 'I' is for a route within an interchange used to connect ramps
SEQUENCE NUMBER
NON-LABELED VARIABLE
NOTE: This field allows more than one record with the same record type, at the same log point.
SPECIAL DESCRIPTION
NOTE: If this field is coded 'I', then the record type must be code 'O' or 'U'.
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).
STREET SUFFIX
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.
CROSS ROAD COUNTY ROUTE
NON-LABELED VARIABLE
NOTE: Linkage variable consisting of COUNTY + RTE_NBR + RTE_SUFX + STATE_EQ.
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.
CROSS ROUTE MILEPOST
NON-LABELED VARIABLE
NOTE: Milepost of the crossing route in miles (XXX.XX).
CROSS ROUTE NUMBER
NON-LABELED VARIABLE
NOTE: If this field is coded, then the cross route prefix must be coded.
CROSS ROUTE SUFFIX
NOTE: Code 'I' is for a route within an interchange used to connect ramps.
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.
| 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 |
NOTE: SAS variable names and explanatory names are shown above each listing. (See Discussion for information on SAS formats.)
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 CODE
NON-LABELED VARIABLE
BEGIN LOG POINT OF CURVE
NON-LABELED VARIABLE
NOTE: Beginning milepost of the curve in miles (XXX.XX).
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
NOTE: See listings under accident section of the guidebook.
DEGREE OF CURVE
DESCRIPTION
NON-LABELED VARIABLE
DIRECTION OF CURVE
DISTRICT
NON-LABELED VARIABLE
DIVIDED HIGHWAY INDICATOR
END LOG POINT OF CURVE
NON-LABELED VARIABLE
NOTE: Ending milepost of the curve in miles (XXX.XX).
FUNCTIONAL CLASS
YEAR OF CODING CHANGE
NON-LABELED VARIABLE
MILE CLASS
NON-LABELED VARIABLE
NUMBER OF LANES
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
STATE ROUTE SUFFIX
NOTE: Code 'I' is for a route within an interchange used to connect ramps.
SEGMENT LENGTH
NON-LABELED VARIABLE
NOTE: Length of curve in miles (XXX.XX).
SEQUENCE NUMBER
NON-LABELED VARIABLE
STATION EQUATION SORT FIELD
NON-LABELED VARIABLE
SYSTEM CLASS
| 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 |
NOTE: SAS variable names and explanatory names are shown above each listing. (See Discussion for information on SAS formats.)
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 CODE
NON-LABELED VARIABLE
BEGIN LOG POINT OF CURVE
NON-LABELED VARIABLE
NOTE: Beginning milepost of the grade in miles (XXX.XX).
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
NOTE: See listings under accident section of the guidebook.
DESCRIPTION
NON-LABELED VARIABLE
DIRECTION OF GRADE
DISTRICT
NON-LABELED VARIABLE
DIVIDED HIGHWAY INDICATOR
END LOG POINT OF CURVE
NON-LABELED VARIABLE
NOTE: Ending milepost in miles (XXX.XX).
FUNCTIONAL CLASS
YEAR OF CODING CHANGE
NON-LABELED VARIABLE
MILE CLASS
NON-LABELED VARIABLE
NUMBER OF LANES
PERCENT OF GRADE
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.
STATE ROUTE SUFFIX
NOTE: Code 'I' is for a route within an interchange used to connect ramps
SEGMENT LENGTH
NON-LABELED VARIABLE
NOTE: Length of grade in feet (XXX.XX).
SEQUENCE NUMBER
NON-LABELED VARIABLE
STATION EQUATION SORT FIELD
NON-LABELED VARIABLE
SYSTEM CLASS
| 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 |
NOTE: SAS variable names and explanatory names are shown above each listing. (See Discussion for information on SAS formats.)
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 CODE
NON-LABELED VARIABLE
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.
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
NOTE: See listings under accident section of the guidebook.
DEGREE OF CURVE
DESCRIPTION
NON-LABELED VARIABLE
DIRECTION OF CURVE
DISTRICT
NON-LABELED VARIABLE
DIVIDED HIGHWAY INDICATOR
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.
FUNCTIONAL CLASS
YEAR OF CODING CHANGE
NON-LABELED VARIABLE
MILE CLASS
NON-LABELED VARIABLE
NUMBER OF LANES
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.
STATE ROUTE SUFFIX
NOTE: Code 'I' is for a route within an interchange used to connect ramps.
SEGMENT LENGTH
NON-LABELED VARIABLE
NOTE: All the segment lengths are zero since it describes only a point.
SEQUENCE NUMBER
NON-LABELED VARIABLE
STATION EQUATION SORT FIELD
NON-LABELED VARIABLE
SYSTEM CLASS