SA TRIP

The San Antonio Traveler Real-time Information Portal (SATRIP) provides data regarding traffic signals that is regularly and automatically updated. The data can be used to gain insight into current roadway performance and help motorists decide on a route and mode to use for a planned trip.

• Detector Summary
• Intersection Comm
• Flood Sensors

Detector Summary

Description/Purpose: This dataset shows a 15-minute summary of intersection detectors and standalone detectors that are maintained by the Transportation and Capital Improvement (TCI) department in the City of San Antonio.

Output format	csv
Input Criteria	None
Frequency	Snapshots updated every 2 minutes.  Prior extracts are automatically overwritten.
Output File Naming convention	Detection Summary.csv
View on Map	Map It

Output headers and definitions:

Field Name	Description
DetectionType	Detection type Value Meaning 0 Detector Station 1 Intersection Detector
DetName	Detector name
LocationName	Primary location of the intersection or detector station
LocationName2	Intersection or detector station asset number defined by the city
AssetNumber	Intersection or detector station asset number defined by the city
Latitude	Detector station or intersection detector latitude
Longitude	Detector station or intersection detector longitude
Direction	Direction of travel for the given detector
Lanes	Lanes covered by the detector
Timestamp	Date-time when last data was collected
Volume	Vehicle count over a 15-minute period
Occupancy	% of time the detector was occupied by a vehicle
Speed	Estimated speed in miles per hour
Health	Detector health Value Status Explanation Phrase used in Standard TMDD Terminology 0 Valid The detector data is valid. working 1 Chatter The reported data is questionable, because the detector report fluctuates too often from sensing a vehicle and not sensing a vehicle. erraticCount 2 Stuck On The reported data is questionable, because the detector reports sensing a vehicle during the entire reporting period. maxPresence 3 Stuck Off The reported data is questionable, because the detector reports not sensing a vehicle during the entire reporting period. noActivity 4 Watchdog Fault The data is questionable, because there has been no signal from the detector. errorAtSensor -1 Unknown/Unrecognized The database did not recognize the reported status.
UploadSuccess	% of successful upload attempts to the detector
ExportDate	Date-time of the last data snapshot.

Signals in Flash with Communication status

Description/Purpose: : This dataset shows the flashing and communication status of every traffic light that is maintained by the Transportation and Capital Improvement (TCI) department in the City of San Antonio.

Output format	csv
Input Criteria	None
Frequency	Snapshots updated every 2 minutes.  Prior extracts are automatically overwritten.
Output File Naming convention	intersectioncomm.csv
View on Map	Map It

Output headers and definitions:

Field Name	Description
IntName	Intersection name
AssetNum	Intersection asset number, as assigned by the City
Latitude	Intersection latitude
Longitude	Intersection longitude
EqType	Controller equipment type
LastStatusChanged	Date-time of the last intersection status change
Status	Status provides additional detail about the type of Flash operation Value Meaning 0 Online- Intersection is operating correctly 1 Flash – Intersection is intentionally flashing red 2 Conflict – Intersection is flashing red due to a fault 3 Comm Fail – Intersection is not communicating status 5 Disabled – Intersection status polling has been disabled 11 Police Flash – Intersection is intentionally flashing red by a police officer
PlanID	Plan ID the intersection is currently running, as used by the city
IsFlash	A true or false evaluation of if the intersection is in Flash operations
IsOnline	A true or false evaluation of if the intersection communication is online
ExportDate	Date-time of the last data snapshot.

Flood Sensor data

Description/Purpose: This dataset shows the status of every road flood sensor owned and managed by the City of San Antonio and Bexar County within their jurisdictional areas.

Output format	csv
Input Criteria	None
Frequency	Snapshots updated every 2 minutes.  Prior extracts are automatically overwritten.
Output File Naming convention	floodsensors.csv
View on Map	Map It

Output headers and definitions:

Field Name	Description
SensorName	Sensor name (ex. Cave Ln)
Agency	Agency ID reference ID Display Name 1 Bexar County, TX 2 San Antonio, TX 3 TXDOT
AgencyIdentifier	An alphanumeric agency reference to the specific asset (ex. 6301)
Latitude	Flood Sensor Latitude
Longitude	Flood Sensor Longitude
Status	Status reported by the floor sensor ID Meaning 1 Closed – Low water crossing associated with sensor is closed due to flooding. 2 Open – Low water crossing associated with sensor is open. 3 Inactive – Location is currently not providing status information. 4 Caution – Low water crossing may be experiencing water rising or receding leaving debris.
Last Updated	Timestamp for most recently received data
LastStatusChanged	Timestamp of most recent status change
ExportDate	Date-time of the last data snapshot.