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

Table A.7. MCMIS Data from ITS Sources
Data ElementDescriptionLinks to ITS Data Sources
RPT_STREPORT STATE 
RPTNUMCRASH REPORT NUMBER STATE 
ACDT_DATECRASH DATE 
ACDT_TIMECRASH TIME 
CARRID_USCENSUS NUMBER 
CARRID_ICICC NUMBERP1512: "DE_ComReg" provides this information for HazMat
CVIEW: "ICC_NUMBER" Number (6,0)
CARRID_SNSTATE CENSUS NUMBER 
CARRID_STSTATE ISSUING STATE CENSUS NUMBER 
CARRID_NONO CENSUS NUMBER 
INTERSTATEINTERSTATECVIEW: "CARRIER INTERSTATE" CHAR(1) Near Match
FATALITYNUMBER OF FATALITIESTMDD: "Incident Human Fatalities Count" may be used to derive this data element.
INJURYNUMBER OF INJURIESTMDD: "Incident Human Injuries Count" may be used to derive this data element.
CARR_NAMECARRIER NAMEP1512: Carrier is allowed for using SAE J2313, which is free-form text
CVIEW: "CARRIER_NAME" VAR CHAR2(55)
CARR_STRCARRIER ADDRESS/STREETCVIEW: "STREET" VARCHAR2(30)
CARR_CITYCARRIER ADDRESS/CITY NAMECVIEW: "CITY" VARCHAR2(25)
CARRCTYCDCARRIER ADDRESS/CITY CODE  
BARRIOCARRIER ADDRESS/MEXICAN NEIGHBORHOODCVIEW: "COLONIA" VARCHAR2(25) Near Match
CARR_STATCARRIER ADDRESS/STATECVIEW: "STATE" CHAR(2)
CARR_ZIPCARRIER ADDRESS/ZIP CODECVIEW: "ZIP_CODE" VARCHAR2(10)
CARR_SOURCARRIER NAME SOURCE 
TOWAWAYTOW AWAYTMDD: "Towaway" may be roughly inferred, but not directly obtainable
P1512: DF_CargoUnits has information on towing that can be used to infer this element.
FEDRPTFEDERALLY RECORDABLE 
STATERPTSTATE REPORTABLE 
TRUCKBUSTRUCK/BUSCVIEW: "BUS" CHAR(1) Near Match
RD_TWAYROAD TRAFFICWAYTMDD: "Median Type" may use to infer divided/undivided.
RD_ACCESSROAD ACCESS CONTROL 
RD_SURFROAD SURFACE CONDITIONTMDD: Codes are: Dry; Wet; Chemically Wet; Snow/Ice; Absorption; Absorption 2; Dew; Frost; some FARS codes are derivable but not all

NTCIP DCM: "essPavementTemperature" Integer (-1000..1001) Near Match
WEATHERWEATHER CONDITIONTMDD: Codes are: Sunny; Rain; Hurricane; Severe Rain; Flood; Sleet; Snow; Blizzard; Overcast Cloudy; Sun Glare; Earthquake Landslide; some FARS codes may be derived
ATIS: Weather message includes information on:
dayOfWeek     Day-of-week
temperature     Weather-Temperature
highTemperature     Weather-HighTemperature
lowTemperature     Weather-LowTemperature
skyConditions     Weather-SkyConditions
probability     Weather-Probability
-- level of faith in this information
specialConditions     Weather-SpecialConditions
visibility     Weather-Visibility
windSpeed     Weather-WindSpeed
windDirection     Weather-WindDirection
humidity     Weather-Humidity
pressure     Weather-Pressure
sunriseTime     ATIS-Time
sunsetTime     ATIS-Time
LIGHTLIGHT CONDITION 
DRV_CONDAPPARENT DRIVER CONDITION 
SEQ_ONESEQUENCE OF EVENTS, FIRST 
ACDT_STRCRASH STREET LOCATION 
ACDT_MUNCRASH CITY/NAME 
ACDT_MUNCDCRASH CITY/CODE 
ACDT_JURISCRASH STATE 
ACDT_CNTYCRASH COUNTY CODE 
AGENCYREPORTING AGENCY 
OFFIDENTNOOFFICER BADGE NUMBER 
ACDTVEHICSVEHICLES IN CRASHTMDD: "Incident Vehicles Involved (count)" may be used, but definitions vary slightly.
P1512: May be derived by summing all involved vehicles.
VEHIC_CONFVEHICLE CONFIGURATIONP1512: Allows distinguishing trucks of this definition (DE_Axle_Count and DE_PowerUnitType)
CMLVEHICAXNUMBER OF AXLESP1512: DE_Axle_Count can be used directly
CVIEW: "NUMBER_OF_VEHICLES" Number (2,0)
NTIP DCM: "dcmNumAxles" Integer (0..255)
VEHICCARGOCARGO BODY TYPETMDD: "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.
VEHIC_GVWRGROSS VEHICLE WEIGHT RATINGCVIEW: "GVW" Number (8,0)
NTCIP DCM: "dcmGrossVehicleWeight" Integer (0..16711425)
VEHIC_IDNOVEHICLE IDENTIFICATION NUMBER (VIN)P1512: VIN for trucks optionally provided for in HazMat message sets
CVIEW: "VIN" VARCHAR2(30)
NTCIP DCM: "dcmVehicleID" Octet string, Near Match
REG_PL_NOVEHICLE LICENSE NUMBERP1512: Optionally provided for in HazMat message sets
CVIEW: "LICENSE_PLATE_NUMBER" VARCHAR2(12)
REGPLJURISVEHICLE LICENSE STATEP1512: Optionally provided for in HazMat message sets
CVIEW: "LICENSE_PLATE_STATE" VARCHAR2(2)
HAZ_PLACHAZARDOUS MATERIALS PLACARDSP1512: DF_HazardClass message set contains this data
CVIEW: "CARRIER_HAZMAT_PLACARDED" Number (1,0)
HAZ_4DIGHAZARDOUS MATERIALS 4-DIGIT NUMBERP1512: DF_PlacardsAndLabels message contains these data
CVIEW: "HAZMAT_CODE" VARCHAR2(3) Near Match
HAZ_NAMEHAZARDOUS MATERIALS NAMEP1512: DF_HazardClass message set contains this data
HAZ_1DIGHAZARDOUS MATERIALS CLASS 1-DIGIT NUMBERP1512: DF_PlacardsAndLabels message contains these data
CVIEW: "HAZMAT_CODE" VARCHAR2(3) Near Match
HAZ_CARGHAZARDOUS MATERIALS RELEASE OF CARGOTMDD: "Description Type Incident" may be used directly
P1512: DF_MaterialRelease message set has exhaustive detail.


Table of Contents | Appendix A, Table A.6 | Appendix A, Table A.8

FHWA Home | Feedback
FHWA