Tampa CV Pilot Signal Phasing and Timing (SPaT) Sample

datahub.transportation.gov | Last Updated 1 May 2024
View API View Data

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 <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.

Tags: tampa connected vehicle pilot deployment (tampa cv pilot), tampa, florida, roadside equipment (rse), arterial, intelligent transportation systems (its), its joint program office (jpo), connected vehicle message, field test, tampa hillsborough expressway authority (thea), signal phasing and timing (spat), connected vehicle pilot (cvp)

This dataset has the following 24 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
dataTypedatatypetextThe data type.
spat
view top 100
metadata_generatedAtmetadata_generatedatcalendar_dateClosest 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_generatedBymetadata_generatedbytextSource of the record, whether [OBU, RSU, TMC].
rsu
view top 100
metadata_logFileNamemetadata_logfilenametextName 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_schemaVersionmetadata_schemaversionnumberVersion of the metadata schema.
1.0
view top 100
metadata_RSUIDmetadata_rsuidtextIdentifier of road side unit.
thea5
thea22
thea40
view top 100
metadata_kindmetadata_kindtextMetadata kind.
out
view top 100
metadata_psidmetadata_psidnumberProvider 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_externalIDmetadata_externalidtextExternal ID
NA
view top 100
payload_data_SPAT_timeStampspat_timestampnumberTimestamp 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_namepayload_data_spat_nametextHuman 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_regionalpayload_data_spat_regionaltextRegional Extension. This field is based on the J2735 Standard.view top 100
payload_data_SPAT_intersections_IntersectionState_timeStampspat_intersections_4numberThe 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_moypayload_data_spat_intersections_intersectionstate_moynumberMinute 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_namepayload_data_spat_intersections_intersectionstate_nametextMinute 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_idspat_intersectionsnumberSPAT 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_regionpayload_data_spat_intersections_intersectionstate_id_regiontextRoad 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_statusspat_intersections_3numberGeneral status of the controller(s). This field is based on the J2735 Standard.
0.0
view top 100
payload_data_SPAT_intersections_IntersectionState_regionalpayload_data_spat_intersections_intersectionstate_regionaltextRegional Extension. This field is based on the J2735 Standard.view top 100
payload_data_SPAT_intersections_IntersectionState_revisionspat_intersections_1numberA 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_MovementStatespat_intersections_2textSignal 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_enabledLanespayload_data_spat_intersections_intersectionstate_enabledlanestextEnabled 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_maneuverAssistListpayload_data_spat_intersections_intersectionstate_maneuverassistlisttextAssist data consisting of a list of ConnectionManeuverAssist entries. This field is based on the J2735 Standard.view top 100
randomNumrandomnumnumberRandom 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