About this Dataset

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

This dataset contains a sample of the broadcast Traveler Information Messages (TIM) being generated by the Wyoming Connected Vehicle (CV) Pilot. The full set of TIMs can be found in the ITS DataHub data sandbox. Revision Note: This dataset only contains TIM sample data prior to December 18, 2018. For the most recent sample of TIM data, please refer to the Schema Version 6 dataset or retrieve the data from the ITS DataHub data sandbox.
Organization: Department of Transportation
Last updated: 2020-11-12T12:34:31.167046
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__0cca3e20.table_1

808.73 KB
16839 rows
54 columns


CREATE TABLE table_1 (
  "metadata_generatedat" VARCHAR,
  "metadata_recordgeneratedby" VARCHAR,
  "metadata_logfilename" VARCHAR,
  "metadata_securityresultcode" VARCHAR,
  "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" DOUBLE,
  "metadata_rmd_heading" DOUBLE,
  "metadata_rmd_latitude" DOUBLE,
  "metadata_rmd_longitude" DOUBLE,
  "metadata_rmd_speed" DOUBLE,
  "metadata_rmd_rxsource" VARCHAR,
  "metadata_schemaversion" BIGINT,
  "datatype" VARCHAR,
  "messageid" BIGINT,
  "travelerinformation_timestamp" DOUBLE,
  "travelerinformation_packetid" VARCHAR,
  "travelerinformation_urlb" VARCHAR,
  "travelerinformation_msgcnt" BIGINT,
  "travelerdataframe_closedpath" VARCHAR,
  "travelerdataframe_anchor_elevation" DOUBLE,
  "travelerdataframe_anchor_lat" DOUBLE,
  "travelerdataframe_anchor_long" DOUBLE,
  "travelerdataframe_name" VARCHAR,
  "travelerdataframe_lanewidth" DOUBLE,
  "travelerdataframe_directionality" VARCHAR,
  "travelerdataframe_desc_nodes" VARCHAR,
  "travelerdataframe_desc_scale" DOUBLE,
  "travelerdataframe_id" VARCHAR,
  "travelerdataframe_direction" VARCHAR,
  "travelerdataframe_durationtime" BIGINT,
  "travelerdataframe_sspmsgrights1" BIGINT,
  "travelerdataframe_sspmsgrights2" BIGINT,
  "travelerdataframe_startyear" DOUBLE,
  "travelerdataframe_msgid_crc" VARCHAR,
  "travelerdataframe_msgid_viewangle" VARCHAR,
  "travelerdataframe_msgid_mutcdcode" VARCHAR,
  "travelerdataframe_msgid_elevation" DOUBLE,
  "travelerdataframe_msgid_lat" DOUBLE,
  "travelerdataframe_msgid_long" DOUBLE,
  "travelerdataframe_priority" BIGINT,
  "travelerdataframe_content_itis" DOUBLE,
  "travelerdataframe_url" VARCHAR,
  "travelerdataframe_ssptimrights" BIGINT,
  "travelerdataframe_ssplocationrights" BIGINT,
  "travelerdataframe_frametype" VARCHAR,
  "travelerdataframe_starttime" BIGINT
);