Dataset: Tampa CV Pilot Traveler Information Message (TIM) Sample

About this Dataset

Tampa CV Pilot Traveler Information Message (TIM) Sample

The Tampa CV Pilot generates data from the interaction between vehicles and between vehicles and infrastructure. This dataset consists of Traveler Information Messages (TIMs) transmitted by road-side units (RSU) located throughout the Tampa CV Pilot Study area. The full set of raw, TIM data from Tampa CV Pilot can be found in the ITS Sandbox. The data fields follow a SAE J2735 TIM message structure to convey important traffic information to onboard units (OBU) of equipped vehicles. Refer to SAE J2735 Section 5.16 Message: MSG_TravelerInformation Message (TIM). This dataset holds a flattened sample of the TIM data from Tampa CV Pilot. Three additional fields were added to this Socrata dataset during ETL: a geo column (travelerdataframe_msgId_position) to allow for mapping of the geocoded TIM data within Socrata, a random number column (randomNum) to allow for random sampling of data points within Socrata, and a time of day generated column (metadata_generatedAt_timeOfDay) to allow for filtering of data by generated time.
Organization: Department of Transportation
Last updated: 2020-11-12T12:49:40.794377
Tags: arterial, connected-vehicle-message, connected-vehicle-pilot-cvp, field-test, florida, intelligent-transportation-systems-its, its-joint-program-office-jpo, roadside-equipment-rse, tampa, tampa-connected-vehicle-pilot-deployment-tampa-cv-pilot, tampa-hillsborough-expressway-authority-thea, traveler-information-message-tim

Tables

Table 1

@usgov.dot_gov_tampa_cv_pilot_traveler_information_message_tim_sample.table_1

155.04 KB
4926 rows
51 columns


CREATE TABLE table_1 (
  "datatype" VARCHAR,
  "metadata_generatedat" VARCHAR,
  "metadata_generatedby" VARCHAR,
  "metadata_logfilename" VARCHAR,
  "metadata_schemaversion" BIGINT,
  "metadata_rsuid" VARCHAR,
  "metadata_kind" VARCHAR,
  "metadata_psid" BIGINT,
  "travelerinformation_timestamp" VARCHAR,
  "travelerinformation_packetid" VARCHAR,
  "travelerinformation_urlb" VARCHAR,
  "travelerinformation_msgcnt" BIGINT,
  "travelerinformation_regional" VARCHAR,
  "travelerdataframe_closedpath" BOOLEAN,
  "travelerdataframe_anchor_elevation" BIGINT,
  "travelerdataframe_anchor_lat" BIGINT,
  "travelerdataframe_anchor_long" BIGINT,
  "travelerdataframe_anchor_regional" VARCHAR,
  "travelerdataframe_name" VARCHAR,
  "travelerdataframe_lanewidth" BIGINT,
  "travelerdataframe_directionality" VARCHAR,
  "travelerdataframe_desc_nodes" VARCHAR,
  "travelerdataframe_desc_scale" VARCHAR,
  "travelerdataframe_direction" BIGINT,
  "travelerdataframe_id_id" VARCHAR,
  "travelerdataframe_id_region" VARCHAR,
  "travelerdataframe_sspmsgrights1" BIGINT,
  "travelerdataframe_sspmsgrights2" BIGINT,
  "travelerdataframe_startyear" BIGINT,
  "travelerdataframe_msgid_viewangle" BIGINT,
  "travelerdataframe_msgid_mutcdcode" VARCHAR,
  "travelerdataframe_msgid_elevation" BIGINT,
  "travelerdataframe_msgid_lat" BIGINT,
  "travelerdataframe_msgid_long" BIGINT,
  "travelerdataframe_msgid_furtherinfoid" VARCHAR,
  "travelerdataframe_msgid_msgcrc" VARCHAR,
  "travelerdataframe_msgid_regional" VARCHAR,
  "travelerdataframe_priority" BIGINT,
  "travelerdataframe_content_advisory_sequence" VARCHAR,
  "travelerdataframe_content_exitservice_sequence" VARCHAR,
  "travelerdataframe_content_genericsign_sequence" VARCHAR,
  "travelerdataframe_content_speedlimit_sequence" VARCHAR,
  "travelerdataframe_content_workzone_sequence" VARCHAR,
  "travelerdataframe_ssptimrights" BIGINT,
  "travelerdataframe_ssplocationrights" BIGINT,
  "travelerdataframe_frametype" VARCHAR,
  "travelerdataframe_starttime" BIGINT,
  "travelerdataframe_duratontime" BIGINT,
  "travelerdataframe_msgid_position" VARCHAR,
  "randomnum" DOUBLE,
  "metadata_generatedat_timeofday" DOUBLE
);