Tampa CV Pilot Signal Phasing and Timing (SPaT) Sample
datahub.transportation.gov | Last Updated 1 May 2024The 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 <a href="http://usdot-its-cvpilot-publicdata.s3.amazonaws.com/index.html" target="_blank" >ITS Sandbox</a>. 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.
This dataset has the following 24 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
dataType | datatype | text | The data type. | spat view top 100 |
metadata_generatedAt | metadata_generatedat | calendar_date | Closest time to which the record was created, either signed or received by the generatedBy source in UTC format. This information is taken from the communication header. | 2021-03-16T00:02:40.000 2021-03-16T00:30:44.000 2021-03-16T00:17:30.000 2021-03-16T00:18:26.000 2021-03-16T00:23:53.000 view top 100 |
metadata_generatedBy | metadata_generatedby | text | Source of the record, whether [OBU, RSU, TMC]. | rsu view top 100 |
metadata_logFileName | metadata_logfilename | text | Name of the original file that deposited the message. | 2021_3_16_0_thea5.csv 2021_3_16_0_thea22.csv 2021_3_16_0_thea40.csv view top 100 |
metadata_schemaVersion | metadata_schemaversion | number | Version of the metadata schema. | 1.0 view top 100 |
metadata_RSUID | metadata_rsuid | text | Identifier of road side unit. | thea5 thea22 thea40 view top 100 |
metadata_kind | metadata_kind | text | Metadata kind. | out view top 100 |
metadata_psid | metadata_psid | number | Provider Service Identifier. A number that identifies a service provided by an application. PSID is defined in IEEE Std 1609.12. | 32770.0 view top 100 |
metadata_externalID | metadata_externalid | text | External ID | NA view top 100 |
payload_data_SPAT_timeStamp | spat_timestamp | number | Timestamp of the Signal Phase and Timing (SPAT) message, expressed in minute of the year - the number of elapsed minutes of the current year in the time system being used (typically UTC time). This field is based on the J2735 Standard. | 106802.0 106822.0 106804.0 106827.0 106814.0 view top 100 |
payload_data_SPAT_name | payload_data_spat_name | text | Human readable name for this collection of SPAT messages - to be used only in debug mode. This field is based on the J2735 Standard. | view top 100 |
payload_data_SPAT_regional | payload_data_spat_regional | text | Regional Extension. This field is based on the J2735 Standard. | view top 100 |
payload_data_SPAT_intersections_IntersectionState_timeStamp | spat_intersections_4 | number | The mSec point in the current UTC minute that the message was constructed. This field is based on the J2735 Standard. | 47825.0 30637.0 27012.0 6620.0 47925.0 view top 100 |
payload_data_SPAT_intersections_IntersectionState_moy | payload_data_spat_intersections_intersectionstate_moy | number | Minute of current UTC year, used only with messages to be archived. This field is based on the J2735 Standard. | view top 100 |
payload_data_SPAT_intersections_IntersectionState_name | payload_data_spat_intersections_intersectionstate_name | text | Minute of current UTC year, used only with messages to be archived. This field is based on the J2735 Standard. | view top 100 |
payload_data_SPAT_intersections_IntersectionState_id_id | spat_intersections | number | SPAT intersection reference ID for a single intersection, consisting of a regionID and intersection ID assignment, and provides a unique mapping to the intersection MAP in question which provides complete location and approach/move/lane data. This field is based on the J2735 Standard. | 1858.0 55627.0 55351.0 view top 100 |
payload_data_SPAT_intersections_IntersectionState_id_region | payload_data_spat_intersections_intersectionstate_id_region | text | Road Regulator ID - a globally unique regional assignment value, typically assigned to a regional DOT authority. The value zero is used for testing. This field is based on the J2735 Standard. | view top 100 |
payload_data_SPAT_intersections_IntersectionState_status | spat_intersections_3 | number | General status of the controller(s). This field is based on the J2735 Standard. | 0.0 view top 100 |
payload_data_SPAT_intersections_IntersectionState_regional | payload_data_spat_intersections_intersectionstate_regional | text | Regional Extension. This field is based on the J2735 Standard. | view top 100 |
payload_data_SPAT_intersections_IntersectionState_revision | spat_intersections_1 | number | A sequence number within a stream of messages with the same DSRCmsgID and from the same sender. The receipt of a non-sequential MsgCount value (from the same sending device and message type) implies that one or more messages from that sending device may have been lost, unless MsgCount has been re-initialized due to an identity change. This field is based on the J2735 Standard. | 58.0 59.0 60.0 14.0 3.0 view top 100 |
payload_data_SPAT_intersections_IntersectionState_states_MovementState | spat_intersections_2 | text | Signal phase state mapping to the lanes it applies to, and point in time it will end. It may contain both active and future states. This field is based on the J2735 Standard. | [{'signalGroup': '2', 'state-time-speed': {'MovementEvent': {'eventState': {'stop-And-Remain': None}, 'timing': {'minEndTime': '2113'}}}}, {'signalGroup': '4', 'state-time-speed': {'MovementEvent': {'eventState': {'protected-Movement-Allowed': None}, 'timing': {'minEndTime': '2055'}}}}, {'signalGroup': '9', 'state-time-speed': {'MovementEvent': {'eventState': {'stop-And-Remain': None}, 'timing': {'minEndTime': '2113'}}}}, {'signalGroup': '10', 'state-time-speed': {'MovementEvent': {'eventState': {'protected-clearance': None}, 'timing': {'minEndTime': '2055'}}}}] [{'signalGroup': '2', 'state-time-speed': {'MovementEvent': {'eventState': {'stop-And-Remain': None}, 'timing': {'minEndTime': '6314'}}}}, {'signalGroup': '4', 'state-time-speed': {'MovementEvent': {'eventState': {'protected-Movement-Allowed': None}, 'timing': {'minEndTime': '6256'}}}}, {'signalGroup': '9', 'state-time-speed': {'MovementEvent': {'eventState': {'stop-And-Remain': None}, 'timing': {'minEndTime': '6314'}}}}, {'signalGroup': '10', 'state-time-speed': {'MovementEvent': {'eventState': {'protected-clearance': None}, 'timing': {'minEndTime': '6256'}}}}] [{'signalGroup': '2', 'state-time-speed': {'MovementEvent': {'eventState': {'stop-And-Remain': None}, 'timing': {'minEndTime': '15915'}}}}, {'signalGroup': '4', 'state-time-speed': {'MovementEvent': {'eventState': {'protected-Movement-Allowed': None}, 'timing': {'minEndTime': '15857'}}}}, {'signalGroup': '9', 'state-time-speed': {'MovementEvent': {'eventState': {'stop-And-Remain': None}, 'timing': {'minEndTime': '15915'}}}}, {'signalGroup': '10', 'state-time-speed': {'MovementEvent': {'eventState': {'protected-clearance': None}, 'timing': {'minEndTime': '15857'}}}}] [{'signalGroup': '2', 'state-time-speed': {'MovementEvent': {'eventState': {'stop-And-Remain': None}, 'timing': {'minEndTime': '14715'}}}}, {'signalGroup': '4', 'state-time-speed': {'MovementEvent': {'eventState': {'protected-Movement-Allowed': None}, 'timing': {'minEndTime': '14657'}}}}, {'signalGroup': '9', 'state-time-speed': {'MovementEvent': {'eventState': {'stop-And-Remain': None}, 'timing': {'minEndTime': '14715'}}}}, {'signalGroup': '10', 'state-time-speed': {'MovementEvent': {'eventState': {'protected-clearance': None}, 'timing': {'minEndTime': '14657'}}}}] [{'signalGroup': '2', 'state-time-speed': {'MovementEvent': {'eventState': {'stop-And-Remain': None}, 'timing': {'minEndTime': '4513'}}}}, {'signalGroup': '4', 'state-time-speed': {'MovementEvent': {'eventState': {'protected-Movement-Allowed': None}, 'timing': {'minEndTime': '4455'}}}}, {'signalGroup': '9', 'state-time-speed': {'MovementEvent': {'eventState': {'stop-And-Remain': None}, 'timing': {'minEndTime': '4513'}}}}, {'signalGroup': '10', 'state-time-speed': {'MovementEvent': {'eventState': {'protected-clearance': None}, 'timing': {'minEndTime': '4455'}}}}] view top 100 |
payload_data_SPAT_intersections_IntersectionState_enabledLanes | payload_data_spat_intersections_intersectionstate_enabledlanes | text | Enabled lanes list - a list of lanes where the RevocableLane bit has been set which are now active and therefore part of the current intersection. Used for intersection at REL ramp. This field is based on the J2735 Standard. | view top 100 |
payload_data_SPAT_intersections_IntersectionState_maneuverAssistList | payload_data_spat_intersections_intersectionstate_maneuverassistlist | text | Assist data consisting of a list of ConnectionManeuverAssist entries. This field is based on the J2735 Standard. | view top 100 |
randomNum | randomnum | number | Random decimal number, to be used for random sampling of data within Socrata. This field is created for use within Socrata and is not present in the data Sandbox. | 0.000013766994284125644 0.000026111791849636745 0.000028571497070806195 0.00004768629093798715 0.00005003355862021053 view top 100 |