About this Dataset

Tampa CV Pilot Signal Phasing And Timing (SPaT) Sample

The Tampa CV Pilot generates data from the interaction between vehicles and between vehicles and infrastructure. This dataset consists of Signal Phasing and Timing Message (SPaT) Messages transmitted by road-side units (RSU) located throughout the Tampa CV Pilot Study area. The full set of raw, SPaT data from Tampa CV Pilot can be found in the ITS Sandbox. The data fields follow SAE J2735 data frames (Section 6) and structure (Section 7). This dataset holds a flattened sample of the SPaT data from Tampa CV Pilot. A column of random numbers (randomNum) was added to allow for random sampling of data points within Socrata.
Organization: Department of Transportation
Last updated: 2020-11-12T13:02:09.941808
Tags: arterial, connected-vehicle-message, connected-vehicle-pilot-cvp, field-test, florida, intelligent-transportation-systems-its, its-joint-program-office-jpo, roadside-equipment-rse, signal-phasing-and-timing-spat, tampa, tampa-connected-vehicle-pilot-deployment-tampa-cv-pilot, tampa-hillsborough-expressway-authority-thea

Tables

Table 1

@usgov.dot_gov_tampa_cv_pilot_signal_phasing_and_timing_spat_sample.table_1

3.21 MB
82,392 rows
24 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,
  "metadata_externalid" VARCHAR,
  "payload_data_spat_timestamp" BIGINT,
  "payload_data_spat_name" VARCHAR,
  "payload_data_spat_regional" VARCHAR,
  "payload_data_spat_intersections_intersectionstate_timestamp" BIGINT,
  "payload_data_spat_intersections_intersectionstate_moy" VARCHAR,
  "payload_data_spat_intersections_intersectionstate_name" VARCHAR,
  "payload_data_spat_intersections_intersectionstate_id_id" BIGINT,
  "payload_data_spat_intersections_intersectionstate_id_region" VARCHAR,
  "payload_data_spat_intersections_intersectionstate_status" BIGINT,
  "payload_data_spat_intersections_intersectionstate_regional" VARCHAR,
  "payload_data_spat_intersections_intersectionstate_revision" BIGINT,
  "payload_data_spat_intersections_intersectionstate_stat_d13428f0" VARCHAR  -- Payload Data SPAT Intersections IntersectionState States MovementState,
  "payload_data_spat_intersections_intersectionstate_enabledlanes" VARCHAR,
  "payload_data_spat_intersections_intersectionstate_mane_cf2f54fc" VARCHAR  -- Payload Data SPAT Intersections IntersectionState ManeuverAssistList,
  "randomnum" DOUBLE
);