About this Dataset

Wyoming CV Pilot Traveler Information Message Sample (Schema Version 6)

This dataset contains a sample of the broadcast Traveler Information Messages (TIM) being generated by the Wyoming Connected Vehicle (CV) Pilot. This dataset only contains SchemaVersion 6 TIM sample data from December 18, 2018 to present. It is updated hourly and will hold up to 3 million of the most recent TIM records. The Schema Version 6 data is described further here. For sample TIM data prior to December 18, 2018, please refer to the Schema Version 5 dataset. The full set of TIMs can be found in the ITS Sandbox.
Organization: Department of Transportation
Last updated: 2020-11-12T12:38:11.681135
Tags: connected-vehicle-message, connected-vehicle-pilot-cvp, field-test, intelligent-transportation-systems-its, its-joint-program-office-jpo, traveler-information-message-tim, wyoming, wyoming-connected-vehicle-cv-pilot, wyoming-cv-pilot, wyoming-department-of-transportation-wydot

Tables

Table 1

@usgov.dot_gov_wyoming_cv_pilot_traveler_information_message__f4a8b2c3.table_1

116.59 kB
1,891 rows
69 columns

CREATE TABLE table_1 (
  "datatype" VARCHAR,
  "metadata_generatedat" VARCHAR,
  "metadata_generatedby" VARCHAR,
  "metadata_logfilename" VARCHAR,
  "metadata_schemaversion" BIGINT,
  "messageid" BIGINT,
  "metadata_sanitized" BOOLEAN,
  "metadata_payloadtype" VARCHAR,
  "metadata_recordtype" VARCHAR,
  "metadata_serialid_streamid" VARCHAR,
  "metadata_serialid_bundlesize" BIGINT,
  "metadata_serialid_bundleid" BIGINT,
  "metadata_serialid_recordid" BIGINT,
  "metadata_serialid_serialnumber" BIGINT,
  "metadata_receivedat" VARCHAR,
  "metadata_rmd_elevation" VARCHAR,
  "metadata_rmd_heading" VARCHAR,
  "metadata_rmd_longitude" VARCHAR,
  "metadata_rmd_latitude" VARCHAR,
  "metadata_rmd_speed" VARCHAR,
  "metadata_rmd_rxsource" VARCHAR,
  "metadata_request_rsus" VARCHAR,
  "metadata_request_snmp_channel" DOUBLE,
  "metadata_request_snmp_deliverystart" VARCHAR,
  "metadata_request_snmp_deliverystop" VARCHAR,
  "metadata_request_snmp_enable" DOUBLE,
  "metadata_request_snmp_interval" DOUBLE,
  "metadata_request_snmp_mode" DOUBLE,
  "metadata_request_snmp_msgid" DOUBLE,
  "metadata_request_snmp_rsuid" DOUBLE,
  "metadata_request_snmp_status" DOUBLE,
  "travelerdataframe_anchor_elevation" VARCHAR,
  "travelerdataframe_anchor_lat" BIGINT,
  "travelerdataframe_anchor_long" BIGINT,
  "travelerdataframe_closedpath" VARCHAR,
  "travelerdataframe_content_advisory_sequence" VARCHAR,
  "travelerdataframe_desc_nodes" VARCHAR,
  "travelerdataframe_desc_scale" BIGINT,
  "travelerdataframe_direction" BIGINT,
  "travelerdataframe_directionality" VARCHAR,
  "travelerdataframe_durationtime" VARCHAR,
  "travelerdataframe_frametype" VARCHAR,
  "travelerdataframe_id" VARCHAR,
  "travelerdataframe_lanewidth" BIGINT,
  "travelerdataframe_msgid_crc" VARCHAR,
  "travelerdataframe_msgid_elevation" VARCHAR,
  "travelerdataframe_msgid_lat" BIGINT,
  "travelerdataframe_msgid_long" BIGINT,
  "travelerdataframe_msgid_mutcdcode" VARCHAR,
  "travelerdataframe_msgid_viewangle" BIGINT,
  "travelerdataframe_name" VARCHAR,
  "travelerdataframe_priority" BIGINT,
  "travelerdataframe_ssplocationrights" BIGINT,
  "travelerdataframe_sspmsgrights1" BIGINT,
  "travelerdataframe_sspmsgrights2" BIGINT,
  "travelerdataframe_ssptimrights" BIGINT,
  "travelerdataframe_starttime" BIGINT,
  "travelerdataframe_startyear" BIGINT,
  "travelerdataframe_url" VARCHAR,
  "travelerinformation_msgcnt" BIGINT,
  "travelerinformation_packetid" VARCHAR,
  "travelerinformation_timestamp" BIGINT,
  "travelerinformation_urlb" VARCHAR,
  "metadata_securityresultcode" VARCHAR,
  "travelerdataframe_content_itis" VARCHAR,
  "travelerdataframe_content_workzone_sequence" VARCHAR,
  "travelerdataframe_content_genericsign_sequence" VARCHAR,
  "travelerdataframe_content_speedlimit_sequence" VARCHAR,
  "travelerdataframe_content_exitservice_sequence" VARCHAR
);