|
|
|
Potential Use of Archived Intelligent Transportation Systems Data for Government Reporting |
| Data Category | Description | Links to ITS Data Sources |
|---|---|---|
| Hazardous Materials | REPORT NUMBER | |
| Hazardous Materials | MULTIPLE CODE | |
| Hazardous Materials | MODE OF TRANSPORT | TMDD: DE_PowerUnitType discerns various highway, air, and rail mode types |
| Hazardous Materials | MODE OTHER DESC | |
| Hazardous Materials | DATE OF INCIDENT | TMDD: "Description Type Incident" identifies whether a hazmat spill has occurred |
| Hazardous Materials | TIME OF INCIDENT | |
| Hazardous Materials | INCIDENT CITY | |
| Hazardous Materials | INCIDENT COUNTY | |
| Hazardous Materials | INCIDENT STATE | |
| Hazardous Materials | INCIDENT ROUTE | TMDD: "Road Number" can be used. |
| Hazardous Materials | CARRIER ID | P1512: Message set "DF_VehicleData" allows for carrier ID using SAE J2313, which is ASCII free text NA: carrier_identity data flow CVIEW: "CARRIER_ID_NUMBER" VARCHAR2(12); "CARRIER_NAME" VARCHAR2(55) |
| Hazardous Materials | CARRIER NAME | |
| Hazardous Materials | CARRIER ADDRESS | CVIEW: "STREET" VARCHAR2(30) |
| Hazardous Materials | CARRIER CITY | CVIEW: "CITY" VARCHAR2(25) |
| Hazardous Materials | CARRIER STATE | CVIEW: "STATE" CHAR(2) |
| Hazardous Materials | CARRIER ZIP | CVIEW: "ZIP_CODE" VARCHAR2(10) |
| Hazardous Materials | CARRIER REPORTING NUMBER | P1512: "DE_ComReg" provides this information for USDOT, ICC, numbers CVIEW: "ICC_NUMBER" Number (6,0) |
| Hazardous Materials | SHIPPER ID | |
| Hazardous Materials | SHIPPER NAME | P1512: "DF_ShippingHeader" may be used directly. |
| Hazardous Materials | SHIPPER ADDRESS | |
| Hazardous Materials | SHIPPER CITY | |
| Hazardous Materials | SHIPPER STATE | |
| Hazardous Materials | SHIPPER ZIP | |
| Hazardous Materials | CONSIGNEE ID | |
| Hazardous Materials | CONSIGNEE NAME | |
| Hazardous Materials | CONSIGNEE ADDRESS | |
| Hazardous Materials | CONSIGNEE CITY | |
| Hazardous Materials | CONSIGNEE STATE | |
| Hazardous Materials | CONSIGNEE ZIP | |
| Hazardous Materials | ORIGIN SAME AS SHIPPER | |
| Hazardous Materials | ORIGIN ADDRESS | |
| Hazardous Materials | ORIGIN CITY | |
| Hazardous Materials | ORIGIN STATE | |
| Hazardous Materials | ORIGIN ZIP | |
| Hazardous Materials | DESTINATION SAME AS CONSIGNEE | |
| Hazardous Materials | DESTINATION ADDRESS | |
| Hazardous Materials | DESTINATION CITY | |
| Hazardous Materials | DESTINATION STATE | |
| Hazardous Materials | DESTINATION ZIP | |
| Hazardous Materials | SHIPPING PAPER | P1512: Can be inferred from the presence of information in "DF_ShippingEntry" |
| Hazardous Materials | COMMODITY CODE | P1512: "DF_ShippingEntry" contains some but not all data: psn ProperShippingName OPTIONAL, -- Proper Shipping Name as per DOT -- regulations as found in papers tradeName TradeName OPTIONAL, |
| Hazardous Materials | COMMODITY SHIPPING NAME | |
| Hazardous Materials | COMMODITY TRADE NAME | |
| Hazardous Materials | COMMODITY CLASS | |
| Hazardous Materials | UN NUMBER | Manufactures product name or common name techName TechnicalName OPTIONAL, -- the technical name, if needed nfpa-hmis SEQUENCE OF NFPA-HMIS OPTIONAL, any NFPA/HMIS markings found, typically this is found on buildings and stationary containers -- rather than mobile shipments hazClass HazardClass, -- Hazard class and division idenNumber MaterialID, -- iden number and reference system -- used (NA or UN) -- when this DF is used the lower data elements -- should be filled out to match the data in this DF notably the: ProperShippingName packGroup and the TradeName shall match; technical ingredients can also be added here ATIS: DE_MAYDAY_Data_cargo_text may be used, but it is free text NA: cf_hazmat_vehicle_information data flow |
| Hazardous Materials | HAZARDOUS SUBSTANCE | |
| Hazardous Materials | RQ MET | |
| Hazardous Materials | QUANTITY RELEASED | P1512: "DF_MaterialRelease" has exhaustive information on release of material |
| Hazardous Materials | QUANTITY RELEASED CODE | |
| Hazardous Materials | UNITS OF QUANT RELEASED | |
| Hazardous Materials | DEATHS | P1512: Highest severity sustained by all involved is coded TMDD: "Incident Human Injuries Count" may be used to derive this data element, although TMDD definition may include nonoccupants. |
| Hazardous Materials | MAJOR INJURIES | |
| Hazardous Materials | MINOR INJURIES | |
| Hazardous Materials | NUMBER EVACUATED | P1512: Can be accumulated from "DE_Injured_Transportation" |
| Hazardous Materials | PRODUCT LOSS | P1512: "DF_MaterialRelease" and "DF_SpillPool" have exhaustive information on release of material, but nothing on other consequences (fire, explosion, etc.) |
| Hazardous Materials | PRODUCT LOSS CODE | |
| Hazardous Materials | CARRIER DAMAGE | |
| Hazardous Materials | CARRIER DAMAGE CODE | |
| Hazardous Materials | PUB PRI DAMAGE | |
| Hazardous Materials | PUB PRI DAMAGE CODE | |
| Hazardous Materials | DECON DAMAGE | |
| Hazardous Materials | DECON DAMAGE CODE | |
| Hazardous Materials | OTHER DAMAGE | |
| Hazardous Materials | OTHER DAMAGE CODE | |
| Hazardous Materials | REPORT DAMAGE | |
| Hazardous Materials | REPORT DAMAGE CODE | |
| Hazardous Materials | INCIDENT DAMAGE | |
| Hazardous Materials | DAMAGE CODE | |
| Hazardous Materials | RESULT VAPOR | |
| Hazardous Materials | RESULT SEWER | |
| Hazardous Materials | RESULT SPILL | |
| Hazardous Materials | RESULT FIRE | |
| Hazardous Materials | RESULT EXPLO | |
| Hazardous Materials | RESULT ENVIR | |
| Hazardous Materials | RESULT NONE | |
| Hazardous Materials | RESULT OTHER | |
| Hazardous Materials | RESULT OTHER DESC | |
| Hazardous Materials | VEHICLE CARGO | P1512: Exhaustive detail on vehicle types exist in DE_PowerUnitType but crosswalk must be developed to match HMIRS codes |
| Hazardous Materials | VEHICLE VAN | |
| Hazardous Materials | VEHICLE FLAT | |
| Hazardous Materials | VEHICLE TANK CAR | |
| Hazardous Materials | VEHICLE RAIL CAR | |
| Hazardous Materials | VEHICLE TOFC | |
| Hazardous Materials | VEHICLE AIRCRFT | |
| Hazardous Materials | VEHICLE BARGE | |
| Hazardous Materials | VEHICLE SHIP | |
| Hazardous Materials | VEHICLE OTHER | |
| Hazardous Materials | VEHICLE OTHER DESC | |
| Hazardous Materials | TRANSPORTATION PHASE | |
| Hazardous Materials | LAND USE | |
| Hazardous Materials | COMMUNITY TYPE | |
| Hazardous Materials | ACCIDENT OR DERAIL | |
| Hazardous Materials | ESTIMATED SPEED | |
| Hazardous Materials | HIGHWAY TYPE | TMDD: "Median Type" may use to infer divided/undivided. |
| Hazardous Materials | HIGHWAY LANES | TMDD: "Number of Through Lanes" on a link can be used. |
| Hazardous Materials | GENERAL CAUSE | |
| Hazardous Materials | MISCELLANEOUS INFO 1 | |
| Hazardous Materials | ATTACHMENTS | |
| Hazardous Materials | RECOMMENDATIONS | |
| Hazardous Materials | REPORTER NAME | |
| Hazardous Materials | REPORTERS TITLE | |
| Hazardous Materials | REPORTER PHONE | |
| Hazardous Materials | REPORT DATE | CVIEW: "PRIOR_DATE" DATE, Near Match |
| Hazardous Materials | DATE ADDED TO DATA SET | |
| Hazardous Materials | DATE OF LAST CHANGE | |
| Hazardous Materials | INTEGER OF ID | |
| Hazardous Container | REPORT NUMBER | P1512: DE_CargoPackageType has much detail on the type of container involved, but no detail on what happened to the container or why it failed: CVIEW: "CARRIER_HAZMAT_PLACARDED" Number (1,0) Near Match |
| Hazardous Container | MULTIPLE CODE | |
| Hazardous Container | CONTAINER SEQUENCE | |
| Hazardous Container | TYPE OF CONTAINER | |
| Hazardous Container | CAPACITY CONTAINER | |
| Hazardous Container | CAPACITY CONTAINER CODE | |
| Hazardous Container | CAPACITY UNITS | |
| Hazardous Container | NUMBER FAILED | |
| Hazardous Container | NUMBER FAILED CODE | |
| Hazardous Container | NUMBER IN SHIPMENT | |
| Hazardous Container | NUMBER IN SHIPMENT CODE | |
| Hazardous Container | GAUGE OF CONTAINER | |
| Hazardous Container | MANUFACTURERS ID | |
| Hazardous Container | MANUFACTURERS NAME | |
| Hazardous Container | MANUFACTURERS CITY | |
| Hazardous Container | MANUFACTURERS STATE | |
| Hazardous Container | TANK SERIAL NO | |
| Hazardous Container | LABEL OR PLACARD | |
| Hazardous Container | REGISTRATION NO | |
| Hazardous Container | INSPECTION DATE | |
| Hazardous Container | EXEMPTION NO | |
| Hazardous Container | VEHICLE COLLISION | |
| Hazardous Container | VEHICLE OVERTURN | |
| Hazardous Container | OVERLOAD OVERFILL | |
| Hazardous Container | LOOSE FITTING | |
| Hazardous Container | DEFECTIVE FITTING | |
| Hazardous Container | DROPPED | |
| Hazardous Container | STRUCK RAMMED | |
| Hazardous Container | IMPROPER LOADING | |
| Hazardous Container | IMPROPER BLOCKING | |
| Hazardous Container | CORROSION | |
| Hazardous Container | METAL FATIGUE | |
| Hazardous Container | FRICTION RUBBING | |
| Hazardous Container | FIRE HEAT | |
| Hazardous Container | FREEZING | |
| Hazardous Container | VENTING | |
| Hazardous Container | VANDALISM | |
| Hazardous Container | INCOMPATIBLE MATERIAL | |
| Hazardous Container | CONTRIBUTING OTHER | |
| Hazardous Container | CONTRIBUTING OTHER DESC | |
| Hazardous Container | OTHER FREIGHT | |
| Hazardous Container | FORKLIFT | |
| Hazardous Container | NAIL PROTRUSION | |
| Hazardous Container | OTHER VEHICLE | |
| Hazardous Container | WATER | |
| Hazardous Container | GROUND FLOOR ROADWAY | |
| Hazardous Container | ROADSIDE OBSTACLE | |
| Hazardous Container | NO OBJECT | |
| Hazardous Container | OBJECT OTHER | |
| Hazardous Container | OBJECT OTHER DESC | |
| Hazardous Container | PUNCTURED | |
| Hazardous Container | CRACKED | |
| Hazardous Container | BURST INTL PRESSURE | |
| Hazardous Container | RIPPED | |
| Hazardous Container | CRUSHED | |
| Hazardous Container | RUBBED ABRADED | |
| Hazardous Container | RUPTURED | |
| Hazardous Container | HOW FAILED OTHER | |
| Hazardous Container | HOW FAILED OTHER DESC | |
| Hazardous Container | END FORWARD | |
| Hazardous Container | END REAR | |
| Hazardous Container | SIDE RIGHT | |
| Hazardous Container | SIDE LEFT | |
| Hazardous Container | TOP | |
| Hazardous Container | BOTTOM | |
| Hazardous Container | CENTER | |
| Hazardous Container | AREA OTHER | |
| Hazardous Container | AREA OTHER DESC | |
| Hazardous Container | PACKAGE MATERIAL | |
| Hazardous Container | FITTING VALVE | |
| Hazardous Container | CLOSURE | |
| Hazardous Container | CHIME | |
| Hazardous Container | WELD SEAM | |
| Hazardous Container | HOSE PIPING | |
| Hazardous Container | INNER LINING | |
| Hazardous Container | WHAT FAILED OTHER | |
| Hazardous Container | WHAT FAILED OTHER DESC | |
| Hazardous Container | DATE ADDED TO DATA BASE | |
| Hazardous Container | DATE OF LAST CHANGE | |
| Hazardous Container | USER OF CHANGE | |
| Hazardous Container | DATE OF DELETE | |
| Hazardous Container | USER OF DELETE | |
| Hazardous Container | INTEGER OF ID | |
| Hazardous Remarks | REPORT NUMBER | |
| Hazardous Remarks | SEQUENCE NUMBER | |
| Hazardous Remarks | REMARKS | |
| Hazardous Remarks | DATE OF CHANGE | |
| Hazardous Remarks | DATE OF ENTRY | |
| Company | COMPANY ID NUMBER | |
| Company | COMPANY NAME | |
| Company | STREET ADDRESS | |
| Company | CITY | |
| Company | STATE | |
| Company | ZIP CODE | |
| Company | SOURCE | |
| Company | MATERIAL SUPPLIER | |
| Company | CONTAINER MANUFACTURER | |
| Company | CONSIGNEE | |
| Company | CARRIER | CVIEW: "CARRIER_NAME" VARCHAR2(55) Near Match |
| Company | SHIPPER | |
| Company | CYLINDER RETESTER REPAIR | |
| Company | PORTABLE TANK TESTER | |
| Company | RECONDITIONER | |
| Company | CYLINDER SALES | |
| Company | OTHER | |
| Company | DATE OF ENTRY | |
| Company | DATE OF CHANGE | |
| Commodity | FIELD OF IDENTIFICATION |
