Smart Transit Stop Connectivity Log

This dataset provides granular logs of IoT device connectivity and uptime at smart public transit stops, including location, device status, signal strength, and maintenance flags. It enables transit agencies to monitor network reliability, identify outages, and optimize maintenance schedules for improved rider experience and infrastructure investment. The schema is designed for easy integration with operational dashboards and analytics tools.

  • last updated 19 Dec 2025
  • by GoMask
The brief that made it

Real-time monitoring of transit stop IoT device connectivity and uptime

Sample rows

preview · 8 of 75 rows · all 20 columns
log_idstringconnectivity_statusstringsignal_strength_dbmfloatmaintenance_requiredbooleanreported_bystringtransit_stop_idstringtransit_stop_namestringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringaddress_countrystringdevice_idstringdevice_typestringuptime_secondsintegerdowntime_secondsintegerlast_connectivity_changedatetimelog_timestampdatetimenetwork_typestringissue_descriptionstring
L001-20240610-0001online-58.4falsesystem_monitorTS-1001Main & 1st100 Main StSpringfieldIL62701USAD-2001sensor8640002024-06-09T07:35:002024-06-10T07:40:00LTEblank
L001-20240610-0002intermittent-86.7trueops_teamTS-1002Broadway & Pine500 Broadway AveSpringfieldIL62703USAD-2002display3240018002024-06-10T05:15:002024-06-10T07:43:00WiFiDevice experienced frequent dropouts during morning peak.
L001-20240610-0003online-43.9falsesystem_monitorTS-1003Central Station200 Central AveSpringfieldIL62702USAD-2003camera17280002024-06-08T22:00:002024-06-10T07:40:00Ethernetblank
L001-20240610-0004offline-120.6truefield_techTS-1004Elm & 4th400 Elm StSpringfieldIL62704USAD-2004sensor0108002024-06-10T04:30:002024-06-10T07:50:00LTEDevice failed to reconnect after scheduled maintenance.
L001-20240610-0005online-51.2falsesystem_monitorTS-1005Parkside North910 Parkside RdSpringfieldIL62705USAD-2005display60480002024-06-03T11:00:002024-06-10T07:55:00WiFiblank
L001-20240610-0006online-63.9falsesystem_monitorTS-1006Riverfront East305 Riverfront DrColumbusOH43004USAD-3001sensor25920002024-06-07T09:00:002024-06-10T07:50:00LTEblank
L001-20240610-0007intermittent-91.1trueops_teamTS-1007Southgate Plaza1250 Southgate BlvdColumbusOH43005USAD-3002camera2520036002024-06-10T06:30:002024-06-10T07:55:00WiFiCamera dropped connection during rainstorm.
L001-20240610-0008online-72.2falsesystem_monitorTS-1008Northside Hub890 Northside AveColumbusOH43007USAD-3003sensor8640002024-06-09T08:00:002024-06-10T07:58:00Ethernetblank

What the 75 rows show

from the 75-row sample

Offline (connectivity status) stands out: mean signal_strength_dbm is -143.5, against -75.8 for the rest.

  • 44%maintenance_required = true
  • -72.1median signal_strength_dbm
  • 3device types
  • 3network types
  • 7address states
  • 9address cities
signal_strength_dbm75 rows, in bands of 20
01530138662616maintenance_required below -80-160-80-40signal_strength_dbm →

Every row with signal_strength_dbm under -80 has maintenance_required = true. None above it.

reported_by75 rows · top 10 of 12 values
  1. system_monitor50
  2. ops_team8
  3. field_tech8
  4. field_tech_garcia1
  5. field_tech_chen1
  6. field_tech_mendez1
  7. field_tech_wilson1
  8. field_tech_smith1
  9. field_tech_jackson1
  10. field_tech_spencer1
20 columns by typefrom the column list below
  • string 14
  • integer 2
  • float 1
  • datetime 2
  • boolean 1

Columns

20 columns in four groups
blueprint · 20 columns
columntypedescriptionexample
Text 14 columns
log_idstringUnique identifier for each connectivity log entryuniqueL001-20240610-0001
transit_stop_idstringUnique identifier for the smart transit stopTS-1001
transit_stop_namestringName or designation of the transit stopMain & 1st
address_streetstringStreet address of the transit stopoptional100 Main St
address_citystringCity where the transit stop is located9 cities · optionalSpringfield
address_statestringState or region of the transit stop7 states · optionalIL
address_postal_codestringPostal code of the transit stopoptional62701
address_countrystringCountry of the transit stopoptionalUSA
device_idstringUnique identifier for the IoT device at the transit stopD-2001
device_typestringType or model of the IoT device (e.g., sensor, display, camera)3 typessensor
connectivity_statusstringCurrent connectivity status of the deviceonline · offline · intermittentonline
network_typestringType of network connection (e.g., LTE, WiFi, Ethernet)LTE · WiFi · Ethernet · Other · optionalLTE
issue_descriptionstringDetailed description of any identified connectivity or device issueoptionalDisplay not available.
reported_bystringIdentifier or name of the system or person reporting the issue12 values · optionalsystem_monitor
Numbers 3 columns
uptime_secondsintegerTotal uptime in seconds since last reboot or connectivity event0 or more86400
downtime_secondsintegerTotal downtime in seconds since last connectivity event0 or more · optional0
signal_strength_dbmfloatMeasured signal strength in dBm at the time of logging-150 to 0 · optional-58.4
Dates and times 2 columns
last_connectivity_changedatetimeTimestamp of the last connectivity status change2024-06-09T07:35:00
log_timestampdatetimeTimestamp when the log entry was recorded2024-06-10T07:40:00
True or false 1 column
maintenance_requiredbooleanIndicates if maintenance is required based on connectivity or device statusoptionalfalse

Use it for

  • maintenance re…44%33 of 75 rows

    A transportation dashboard

    The maintenance_required rate, signal_strength_dbm by connectivity_status and a breakdown of reported_by. Excel, Power BI or Tableau.

  • Why do the 16 offline rows have a mean signal_strength_dbm of -143.5?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable logs with transit_stop_id, transit_stop_name and address_street to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset75 rows20 columns
Yours1,000 rows20 columnsaddress_street: UK only

blueprint · smart-transit-stop-connectivity-log

Behind this dataset

Same schema. As many rows as you need.

These 75 rows came out of a blueprint — 20 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each row represents a unique device check at a transit stop with timestamp.
  • Status must be one of: 'Online', 'Offline', 'Intermittent'.
  • Outage duration is recorded in minutes if status is 'Offline' or 'Intermittent'.
  • Device type (e.g., display, camera, Wi-Fi) must be specified.
  • Location identifier must be unique per stop.
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
smart-transit-stop-connectivity-log

More in Transportation

Browse all
Also in TransportationSmart Traffic Light Sensor DataConnected Vehicle Telemetry DatasetFleet Route Utilization DatasetAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.