United States Department of Transportation - Federal Highway Administration FHWA HomeFeedback
Potential Use of Archived Intelligent Transportation Systems
Data for Government Reporting

Table A.3. HSIS Data from ITS Sources
Data CategoryData ElementDescriptionLinks to ITS Data Sources
AccidentACC_DATE DATE OF ACCIDENT -YMD TMDD: Direct correspondence
P1512: Direct correspondence
AccidentACCTYPETYPE-OF-COLLISIONTMDD: Direct correspondence
P1512: Direct correspondence
AccidentACCYR COLLISION ACCIDENT YEAR TMDD: Direct correspondence
P1512: Direct correspondence
AccidentCASENO UNIQUE ACCIDENT CASE NO 
AccidentCAUSE1PRIMARY COL FACTOR  
AccidentCAUSHPALCOLL FACTOR ALPHA (CHP) 
AccidentCAUSHPCDCOLL FACTOR CODING (CHP)  
AccidentCAUSHPCT COLL FACTOR CATEGORY (CHP) 
AccidentCAUSHPLG COLL FACTOR LEGAL CODE(CHP) 
AccidentCAUSHPSBCOLL FACTOR CODE SUBSECTION (CHP)  
AccidentCNTY_RTE COUNTY ROUTE  
AccidentCOUNTYCOUNTY  
AccidentDISTANCEDISTANCE 
AccidentDISTRICTDISTRICT  
AccidentFAULTVEHICLE AT FAULT 
AccidentFILETYPFILE TYPE  
AccidentHIT_RUNHIT AND RUN 
AccidentHOUR TIME OF ACCIDENT 
AccidentHWY_GRP HIGHWAY GROUPTMDD: Divided/undivided may be derived from TMDD median data
AccidentINT_RMPINTS/RAMP ACC LOCATION TMDD: "Relation to Junction" may be used to derive the majority of codes.
AccidentJUR_TYPEJURISDICTION TYPE  
AccidentLIGHTLIGHT CONDITION  
AccidentMILEPOSTRAMP MILEPOSTTMDD: Should be derivable from linear referencing data.
AccidentNUM_OCCSOCCUPANTSP1512: "othVehOccCnt" may be used directly.
AccidentNUMVEHS TOT-NBR-VEHICLESTMDD: "Incident Vehicles Involved (count)" may be used, but definitions vary slightly.
P1512: May be derived by summing all involved vehicles.
AccidentPOP_GRP POPULATION GROUP = (CITY/RURAL GROUP) 
AccidentPSMILPRFPOSTMILE PREFIX  
AccidentPSMILSUFPOSTMILE SUFFIX  
AccidentRD_DEF1 or 2 or 3ROADWAY CONDITION TMDD: Construction zone, roadway debris, and flooding codes may be obtained from "Description Type Incident" and "Incident Condition Pavement"
NTCIP DCM: "essPavementTemperature" Integer (-1000..1001) Near Match
AccidentRDSURF ROAD-SURFACETMDD: "Slippery/Muddy" only HSIS code that cannot be derived.
AccidentRODWYCLSROADWAY CLASSIFICATION TMDD: HSIS codes may be derived from "Link Type", "Number of Through Lanes" and "Median Type".
AccidentRPT_LEV ACCIDENT REPORT LEVEL 
AccidentRTE_NBR RDWAY ROUTE NUMBER TMDD: "Road Number" can be used directly, but must follow state coding rules.
AccidentRTE_SUF RDWAY ROUTE SUFFIX  
AccidentSDE_HWY SIDE-OF-HIGHWAY 
AccidentSEVERITYCOLLISION SEVERITY TMDD: "Incident Human Injuries" may be used to derive this data element.
AccidentTOT_INJOCCUPANTS INJURED TMDD: "Incident Human Injuries Count" may be used to derive this data element, although TMDD definition may include nonoccupants.
AccidentTOT_KILL OCCUPANTS KILLED TMDD: "Incident Human Fatalities Count" may be used to derive this data element although TMDD definition may include nonoccupants.
AccidentTOWAWAY INJURY, FATAL, OR TOWAWAY? TMDD: "Towaway" may be roughly inferred, but not directly obtainable
P1512: DF_CargoUnits has information on towing that can be used to infer this element.
AccidentTRF_OPERTRAFFIC CONTROL OPERATING TMDD: "Controller Signal State" indicates is signal was "off"
AccidentVEH_INVLMOTOR VEHICLES INVOLVED WITHTMDD: "Incident Vehicles Involved" used directly
AccidentWEATHERWEATHER TMDD: Most codes except for "fog" can be derived
AccidentWEEKDAYDAY-OF-WEEK TMDD: Direct correspondence
OccupantACCYRCOLLISION ACCYR TMDD: Direct correspondence
OccupantAGEOCCUPANT AGE  
OccupantCASENOUNIQUE ACCIDENT CASEO 
OccupantINJ DRV/OCC INJURY  
OccupantOCC_TYP OCCUPANT TYPE 
OccupantOCCNUM OCCUPANT NUMBER  
OccupantREST1 SAFETY EQUIPMENT  
OccupantSEATPOS SEATING POSTION  
OccupantSEX OCCUPANT SEX 
OccupantVEHNO VEHICLE NUMBER CVIEW: "VIN" VARCHAR2(30) Near Match
NTCIP DCM: "dcmVehicleID" Octet string, Near Match
Vehicle DIR_TRVLDIRECTION OF TRAVEL TMDD: Direct correspondence
Vehicle DRV_AGEDRIVER AGE 
Vehicle DRV_INJDRIVER EXTENT OF INJURY 
Vehicle DRV_SEXDRIVER SEX 
Vehicle HAZMATHAZARDOUS MATERIAL TMDD: "Description Type Incident" used directly
P1512: HazMat well covered in P1512.3
ATIS: DE_MAYDAY_Data_cargo_text may be used, but it is free text
NA: cf_hazmat_vehicle_information data flow
CVIEW: "HAZMAT_STATUS" CHAR(1); "CARRIER_HAZMAT_PLACARDED" Number (1,0) Near Match
Vehicle INTOXALCOHOL INVOLVED  
Vehicle LOC_TYP1 or 2 or 3 or 4COLLISION LOCATIONS (up to 4) 
Vehicle MAKEVEHICLE MAKE P1512: Vehicle make and model are free form text; usually only used in HazMat messages for trucks only
CVIEW: "MAKE" VARCHAR2(10)
Vehicle MISCACT1MOVEMENT PRECEDING COLL 
Vehicle NUM_INJ TOTAL NUMBER INJURED 
Vehicle NUM_KILLTOTAL NUMBER KILLED 
Vehicle OBJECT1 or 2 or 3 or 4OBJECTS STRUCK (up to 4) 
Vehicle PART_TYP PARTY TYPE 
Vehicle PHYSCONDDRIVER PHYSICAL CONDITION  
Vehicle RTE_TYPE HIGHWAY TYPE INDICATOR 
Vehicle SOB_TESTFIRST SOBRIETY/CONDITION 
Vehicle SOB_TST2 SECOND SOBRIETY/CONDITION  
Vehicle VEHNO VEHICLE NUMBER CVIEW: "VIN" VARCHAR2(30) Near Match
NTCIP DCM: "dcmVehicleID" Octet string, Near Match
Vehicle VEHTYPEVEHICLE TYPE TMDD: "Incident Vehicles Involved"has similar codes" but 1-to-1 matching for all FARS categories not possible. TMDD has several "reserved codes that may be used.
P1512: Can be derived from DE_PowerUnitType and DE_CargoPackageType directly.
CVIEW: "TYPE" VARCHAR2(2)
NTCIP DCM: "dcmVehicleClass" Integer (0..255) Near Match
Vehicle VEHYRVEHICLE MODEL YEAR CVIEW: "MODEL_YEAR" VARCHAR2(4)
Vehicle VIOLVIOLATION CATEGORY 
Road AADT AADT TMDD: Only link volume is provided, with no formal specification of time period. AADT may be derived from link volumes only if they are archived with appropriate time and location stamps.
Road ACC_DTEACCESS CONTROL DATE  
Road ACC_HIST ACCESS CONTROL HISTORY 
Road ACCESS ACCESS CONTROL  
Road ADT_DTEADT DATE 
Road ADT_DVM DAILY VEHICLE MILES(DVM)  
Road ADT_HSTADT HISTORY 
Road ADT_MSGALPHA MESSAGE 
Road ADT_STUS ADT STATUS PROFILE  
Road BEGMP POSTMILE-BEGMP 
Road CITY CITY  
Road CNTYRTE ROAD COUNTY ROUTE TMDD: "Road Number" can be used directly, but must follow state coding rules. Route signing is included in "Road Number" but is free form text, not HPMS valid values.
Road COUNTYCOUNTY
Road CURB1 CURB AND LANDSCAPE
Road DES_NBR ROAD DESC NUMBER
Road DESG_SPDDESIGN SPEED TMDD: Direct correspondence
Road DISTRICTDISTRICT  
Road DIVIDED DIVIDED HIGHWAY TMDD: May be inferred from median type
Road ENDMPPOSTMILE + SEG_LNG  
Road FEAT_LFLEFT RDBD SPECIAL FEATURE 
Road FEAT_RGRIGHT RDBD SPECIAL FEATURE 
Road FED_AIDFEDERAL AID (IN LIEU) 
Road FED_PREFFEDERAL AID RTE PREFIX  
Road FED_RTEFEDERAL AID RTE  
Road FILETYPFILE TYPE  
Road FUNC_CLS FUNCTIONAL CLASS TMDD: "Link Type" has coding inconsistent (less detailed) than HPMS: Freeway, Arterial, Collector, and Local only
Road HIST_ADDHISTORY ELEMENTS RELATIVE ADDR  
Road HWY_GRPHIGHWAY GROUP 
Road INS_OTSINSIDE OUTSIDE CITY 
Road LANEWID AVERAGE LANE WIDTH 
Road LSHL_WD2LEFT SHOULDER WIDTH RD2TMDD: Direct correspondence
Road LSHLDWIDLEFT SHOULDER WIDTH RD1TMDD: Direct correspondence
Road LTRD_DTELEFT ROADBED DATE  
Road LTRD_HSTLEFT ROADBED HISTORY  
Road MED_DTERAMP MEDIAN DATE 
Road MED_HISTMEDIAN HISTORY 
Road MED_TYPE MEDIAN TYPE TMDD: Only a few codes may be derived (HSIS has many more valid values)
Road MED_VARMEDIAN VARIANCE 
Road MEDBARTY MEDIAN BARRIER TYPE  
Road MEDWIDMEDIAN WIDTH  
Road MVMTMILLION VEHICLE MILES TRAVELED  
Road NA_MILE NON-ADD MILEAGE 
Road NAT_LND NATIONAL LANDS  
Road NO_LANE1NUMBER OF LANES RD1TMDD: Direct correspondence
Road NO_LANE2NUMBER OF LANES RD2TMDD: Direct correspondence
Road NO_LANESTOTAL NUMBER OF LANESTMDD: Direct correspondence
Road PAV_WDL LEFT PAVED SHLD WDTH RD1TMDD: No distinction between paved and unpaved shoulders
Road PAV_WDL2LEFT PAVED SHLD WIDTH RD2 
Road PAV_WDR2 RIGHT PAVED SHLD WIDTH RD2 
Road PAV_WIDR RIGHT PAVED SHLD WDTH RD1 
Road PSMILPRFPOSTMILE PREFIX  
Road PSMILSUFPOSTMILE SUFFIX  
Road RD_DATE ROAD DATE  
Road RD_DESC ROAD DESCRIPTION  
Road RECTYPE RECORD TYPE 
Road RGRD_DTE RIGHT ROADBED DATE 
Road RGRD_HSR RIGHT ROADBED HISTORY  
Road RO_SEQ ROUTE ORDER SEQUENCE  
Road RODWYCLS ROADWAY CLASSIFICATION  
Road RSHL_WD2 RIGHT SHOULDER WIDTH RD2 
Road RSHLDWID RIGHT SHOULDER WIDTH RD1TMDD: Direct correspondence
Road RTE_NBR RDWAY ROUTE NUMBER TMDD: Direct correspondence
Road RTE_SUFRDWAY ROUTE SUFFIX  
Road RU_IO RURAL/URBAN INSIDE OUTSIDE CITY  
Road RURURB RURAL URBAN  
Road SCN_FRWYSCENIC FREEWAY  
Road SEG_LNG SECTION LENGTHTMDD: Direct correspondence
Road SURF_TY2 SURFACE TYPE RD2 TMDD: Some codes may be derived, but HSIS has more detail
Road SURF_TYPSURFACE TYPE RD1  
Road SURF_WD2TRAVELED-WAY WIDTH RD2  
Road SURF_WIDTRAVELED-WAY WIDTH RD1  
Road TERRAINTERRAIN  
Road TOLL TOLL AND FOREST RDS  
Road TRK2AX2-AXLE TRUCK AADT 
Road TRK3AX 3-AXLE TRUCK AADT  
Road TRK4AX 4-AXLE TRUCK AADT  
Road TRK5AX 5+-AXLE TRUCK AADT 
Road TRKCNTFL TRUCK COUNT FLAG 
Road TRKTOT TOTAL TRUCK AADT 
Intersection CNTYRTEINTERSECTION COUNTY ROUTE 
Intersection COUNTYCOUNTY  
Intersection DISTRICTDISTRICT  
Intersection HWY_GRPHIGHWAY GROUP 
Intersection INT_ADDRHISTORY ELEMENTS RELATIVE ADDR 
Intersection INT_DESCINTERSECTION DESCRIPTION  
Intersection INT_DTEINTERSECTION EFFECTIVE DATE 
Intersection INT_HSTINTERSECTION TYPE HISTORY  
Intersection INT_PRFINTERSECTING RTE PREFIX  
Intersection INT_RSUFINTERSECTING RTE SUFFIX 
Intersection INT_RTEINTERSECTING RTE NBR 
Intersection INT_SEQINTERSECTING RTE ORDER SEQ NBR 
Intersection INTY_RTEINTERSECTION COUNTY ROUTE  
Intersection JUCTYPEJUNCTION TYPETMDD: "Intersection Control Type" contains some codes but not all
Intersection LGHT_DTEINTERSECTION LIGHT TYPE DATE  
Intersection LGHT_HSTINTERSECTION LIGHT TYPE HISTORY  
Intersection LGHT_TYPINTERSECTION LIGHT TYPE 
Intersection LOG_ERRLOG ERROR INDICATOR 
Intersection MED_DTERAMP MEDIAN DATE 
Intersection MED_HISTMEDIAN HISTORY 
Intersection MED_INDRAMP MEDIAN INDICATOR  
Intersection MILEPOSTRAMP MILEPOST 
Intersection ML_AADT MAINLINE AADT TMDD: Only link volume is provided, with no formal specification of time period. AADT may be derived from link volumes only if they are archived with appropriate time and location stamps.
Intersection ML_ADTDTMAINLINE ADT DATE  
Intersection ML_ADTHS MAINLINE ADT HISTORY  
Intersection ML_DATE MAINLINE HISTORY DATE 
Intersection ML_HIST MAINLINE HISTORY  
Intersection ML_LANESMAINLINE NUMBER OF LANESTMDD: Direct correspondence
Intersection ML_LEFTMAINLINE LEFT TURN CHANNELIZATIONTMDD: "Left Turn Pocket Lane" only indicates the presence of a turn lane, not the type
Intersection ML_LNGTMAINLINE SECTION LENGTH  
Intersection ML_MASTMAINLINE SIGNAL MASTARM  
Intersection ML_RIGHTMAINLINE RIGHT TURN CHANNELIZATIONTMDD: "Right Turn Pocket Lane" only indicates the presence of a turn lane, not the type
Intersection ML_TRFLOMAINLINE TRAFFIC FLOW  
Intersection PSMILPRFPOSTMILE PREFIX  
Intersection PSMILSUFPOSTMILE SUFFIX  
Intersection RECTYPE RECORD TYPE  
Intersection RO_SEQ ROUTE ORDER SEQUENCE  
Intersection RTE_NBR RDWAY ROUTE NUMBER  
Intersection RTE_SUF RDWAY ROUTE SUFFIX  
Intersection TRF_CNTLTRAFFIC CONTROL TYPE TMDD: Some codes may be derived, but HSIS has more detail
Intersection TRFCTLDTTRAFFIC CONTROL TYPE DATE  
Intersection TRFCTLHSTRAFFIC CONTROL TYPE HISTORY  
Intersection TYPEDESC INTERSECTION TYPE 
Intersection XSTAADTX-STREET AADTTMDD: Only link volume is provided, with no formal specification of time period. AADT may be derived from link volumes only if they are archived with appropriate time and location stamps.
Intersection XSTADTDT X-STREET ADT DATE  
Intersection XSTADTHSX-STREET ADT HISTORY  
Intersection XSTLANESX-STREET NUMBER OF LANES TMDD: Direct correspondence
Intersection XSTLNGTX-STREET SECTION LENGTH  
Intersection XSTRTDTEX-STREET DATE  
Intersection XSTRTHSTX-STREET HISTORY 
Intersection XSTRTLFTX-STREET LEFT TURN CHANNELIZATIONTMDD: "Left Turn Pocket Lane" only indicates the presence of a turn lane, not the type
Intersection XSTRTMST X-STREET SIGNAL MASTARM CHANNELIZATION 
Intersection XSTRTRGHX-STREET RIGHT TURN  
Intersection XSTSTRT X-STREET STATE ROUTE INDICATOR 
Intersection XSTTRFLOX-STREET TRAFFIC FLOW  
RampAREA4 RAMP AREA 4 INDICATOR 
RampCNTYRTE RAMP COUNTY ROUTE  
RampHWY_GRPHIGHWAY GROUP 
RampMED_DTERAMP MEDIAN DATE 
RampMED_HSTRAMP MEDIAN HISTORY 
RampMED_INDRAMP MEDIAN INDICATOR 
RampMILEPOSTRAMP MILEPOST 
RampON_OFFRP ON/OFF RAMP INDICATOR  
RampRECTYPE RECORD TYPE  
RampRMADTDTE RAMP ADT DATE  
RampRMADTHST RAMP ADT HISTORY  
RampRMP_ADT RAMP AADT 
RampRMP_DTE RAMP TYPE DATE  
RampRMP_HST RAMP HISTORY  
RampRMP_SEQ RAMP SEQUENCE NUMBER 
RampRMP_TYPE RAMP TYPE  


Table of Contents | Appendix A, Table A.2 | Appendix A, Table A.4
FHWA Home | Feedback
FHWA
United States Department of Transportation - Federal Highway Administration