Iteration 2: Building a System to Consume All the (Unsecured) Real-Time Transit Data in the World

Published in

Cloudera

10 min readDec 14, 2023

This is the remix. Building on some happy accidents, we found a better source with some extra attributes. Let’s try again.

Iteration 1: Building a System to Consume All the Real-Time Transit Data in the World At Once

Source Code: https://github.com/tspannhw/FLaNK-EveryTransitSystem

medium.com\

In the original version I called github like so which requires a login.

Invoke the List of All GTFS Transit Systems

Let’s download a giant CSV file of systems.

Split out Systems that Require Logins

For now we only want real-time systems

Ingesting Global Systems Generically

Extract All the Good Fields

EvaluateJsonPath

Split Out into 1 Record

JSONRecordSetWriter

CSVReader

Add a Time Stamp

Build a New JSON Record Defining What is a Transit System?

Now let’s call all the available GTFS-RT transit systems and parse their data.

Routing Between Trip Updates, Service Alerts and Vehicle Positions

Generic Processing

Trip Updates

Service Alerts

Vehicle Positions

EXAMPLE DATA

{
  "stopsequence" : "1",
  "arrivaltime" : "1699995300",
  "stopid" : "246",
  "tripid" : "128507",
  "tripstartdate" : "",
  "departuretime" : "",
  "triprouteid" : "",
  "locationcountrycode" : "CA",
  "maxlat" : "50.860312",
  "locationmunicipality" : "Kamloops",
  "maxlong" : "-120.078766",
  "minlong" : "-120.42291",
  "locationsubdivisionname" : "British Columbia",
  "minlat" : "50.634135",
  "ts" : "1699994955447",
  "uuid" : "df53322e-eb62-4f1a-8b52-788f54703e24",
  "rundate" : "Tue, 14 Nov 2023 20:49:15 GMT",
  "providername" : "BC Transit (Kamloops Transit System)",
  "transitname" : ""
}

Still debating if I should have 1 unified topic, one per location.

tripupdates${providername:trim():replaceAll(‘ ‘, ‘’):replaceAll(‘[^a-zA-Z0–9 -]’,’’)}

SLACK OUTPUT — TRIP UPDATES

==== NiFi from  Updates
On Date: Tue, 14 Nov 2023 20:49:15 GMT
File Name: gtfrealtime_TripUpdates.bin
UUID: 41e14fe2-e535-4194-8f2c-cb40861bbb17
topic:
arrivaltime: 1699995300
departuretime:
tripstartdate:
triprouteid:
stopid: 246
tripid: 128507
stopsequence: 1
Data Flow: {"stopsequence":"1","arrivaltime":"1699995300","stopid":"246","tripid":"128507","tripstartdate":"","departuretime":"","triprouteid":"","locationcountrycode":"CA","maxlat":"50.860312","locationmunicipality":"Kamloops","maxlong":"-120.078766","minlong":"-120.42291","locationsubdivisionname":"British Columbia","minlat":"50.634135","ts":"1699994955447","uuid":"df53322e-eb62-4f1a-8b52-788f54703e24","rundate":"Tue, 14 Nov 2023 20:49:15 GMT","providername":"BC Transit (Kamloops Transit System)","transitname":""}
GTFS URL: http://kamloops.mapstrat.com/current/gtfrealtime_TripUpdates.bin
Last Modified: Thu, 09 Nov 2023 14:33:33 GMT
Provider:
Transit Name:
Transit Note:
Transit URL:
Trip Route ID:
Trip Str Date:
Source Age:
extractedon: 2022-03-16T22:05:14+00:00
flow: {"stopsequence":"1","arrivaltime":"1699995300","stopid":"246","tripid":"128507","tripstartdate":"","departuretime":"","triprouteid":"","locationcountrycode":"CA","maxlat":"50.860312","locationmunicipality":"Kamloops","maxlong":"-120.078766","minlong":"-120.42291","locationsubdivisionname":"British Columbia","minlat":"50.634135","ts":"1699994955447","uuid":"df53322e-eb62-4f1a-8b52-788f54703e24","rundate":"Tue, 14 Nov 2023 20:49:15 GMT","providername":"BC Transit (Kamloops Transit System)","transitname":""}
license: https://www.bctransit.com/open-data/terms-of-use
locationcountrycode: CA
locationmunicipality: Kamloops
locationsubdivisionname: British Columbia
maxlat: 50.860312
maxlong: -120.078766
minlat: 50.634135
minlong: -120.42291
staticrref: 707
=====

{
  "routeid4" : "",
  "routeid5" : "",
  "descriptionlang" : "",
  "cause" : "MAINTENANCE",
  "stopid" : "",
  "alertlang" : "en",
  "alerttext" : "Routes 12 & 68 will not serve Crosby Loop due to tree trimming. During the closure, please use stop #1074 located at the Mottman Rd. entrance to SPSCC.",
  "routeid" : "12",
  "effect" : "DETOUR",
  "stopid5" : "",
  "descriptiontext" : "",
  "stopid4" : "",
  "activeperiodend" : "1700179200",
  "stopid3" : "",
  "stopid2" : "",
  "routeid2" : "68",
  "routeid3" : "",
  "activeperiodstart" : "1700179200",
  "locationcountrycode" : "US",
  "maxlat" : "47.1609191895",
  "locationmunicipality" : "Olympia",
  "maxlong" : "-122.483109",
  "minlong" : "-122.977127",
  "locationsubdivisionname" : "Washington",
  "minlat" : "46.93304",
  "ts" : "1699995456318",
  "uuid" : "e899a134-a65c-41a0-a473-78af111a4e1f",
  "providername" : "Intercity Transit",
  "rundate" : "",
  "transitname" : ""
}

SLACK OUTPUT

==== NiFi from Service Alerts
On Date: Tue, 14 Nov 2023 01:20:19 GMT
File Name: alerts.pb
UUID: 0bdfb190-6779-4fc2-afb3-5d107d9caf10
activeperiodend :
activeperiodstart : 1719834480
alertlang :
alerttext:
cause: UNKNOWN_CAUSE
descriptionlang :
descriptiontext :
effect : NO_SERVICE
routeid :
routeid2 :
routeid3 :
routeid4 :
routeid5 :
stopid : 110093
stopid2 : 110108
stopid3 :
stopid4 :
stopid5 :
GTFS URL: https://bct.tmix.se/gtfs-realtime/alerts.pb?operatorIds=10
Last Modified: Thu, 09 Nov 2023 14:33:33 GMT
Provider:
Source Age:
Topic: sa
Transit Name:
Transit Note:
Transit URL:
extractedon: 2022-03-16T22:04:16+00:00
flow:
license:
locationcountrycode: CA
locationmunicipality:
locationsubdivisionname: British Columbia
maxlat: 48.998334
maxlong: -123.364449
minlat: 48.418266
minlong: -124.218623
staticrref: 694
=====

CREATE TABLE `ssb`.`Meetups`.`tripupdates` (
  `stopsequence` VARCHAR(2147483647),
  `arrivaltime` VARCHAR(2147483647),
  `stopid` VARCHAR(2147483647),
  `tripid` VARCHAR(2147483647),
  `tripstartdate` VARCHAR(2147483647),
  `departuretime` VARCHAR(2147483647),
  `triprouteid` VARCHAR(2147483647),
  `locationcountrycode` VARCHAR(2147483647),
  `maxlat` VARCHAR(2147483647),
  `maxlong` VARCHAR(2147483647),
  `locationmunicipality` VARCHAR(2147483647),
  `minlong` VARCHAR(2147483647),
  `locationsubdivisionname` VARCHAR(2147483647),
  `minlat` VARCHAR(2147483647),
  `ts` VARCHAR(2147483647),
  `uuid` VARCHAR(2147483647),
  `rundate` VARCHAR(2147483647),
  `providername` VARCHAR(2147483647),
  `transitname` VARCHAR(2147483647),
  `eventTimeStamp` TIMESTAMP(3) WITH LOCAL TIME ZONE METADATA FROM 'timestamp',
  WATERMARK FOR `eventTimeStamp` AS `eventTimeStamp` - INTERVAL '3' SECOND
) WITH (
  'deserialization.failure.policy' = 'ignore_and_log',
  'properties.request.timeout.ms' = '120000',
  'format' = 'json',
  'properties.bootstrap.servers' = 'kafka:9092',
  'connector' = 'kafka',
  'properties.transaction.timeout.ms' = '900000',
  'topic' = 'tripupdates',
  'scan.startup.mode' = 'earliest-offset',
  'properties.auto.offset.reset' = 'earliest'
)

[{"stopsequence":"47","arrivaltime":"1701625920","stopid":"505213","tripid":"JA_D3-Sunday-073100_Q17_304","tripstartdate":"20231203","departuretime":"1701625920","triprouteid":"Q17","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623954876","uuid":"d1a75668-6c9c-4753-baa8-d158d372e535","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.922"},{"stopsequence":"0","arrivaltime":"1701628800","stopid":"803195","tripid":"MV_D3-Sunday-082000_M11_603","tripstartdate":"20231203","departuretime":"1701628800","triprouteid":"M11","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623954891","uuid":"024ecdaf-433a-4baf-a214-351531db29f4","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.924"},{"stopsequence":"41","arrivaltime":"1701624298","stopid":"503172","tripid":"JA_D3-Sunday-070500_MISC_754","tripstartdate":"20231203","departuretime":"1701624298","triprouteid":"Q5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623954918","uuid":"aa4521d3-6b19-456f-b305-ab20439ef84c","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.927"},{"stopsequence":"25","arrivaltime":"1701625132","stopid":"308571","tripid":"EN_D3-Sunday-073200_B45_803","tripstartdate":"20231203","departuretime":"1701625132","triprouteid":"B65","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623954914","uuid":"8e7f039f-96bb-403d-8456-381101ec7f08","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.929"},{"stopsequence":"15","arrivaltime":"1701626980","stopid":"301044","tripid":"EN_D3-Sunday-077000_B83_306","tripstartdate":"20231203","departuretime":"1701626980","triprouteid":"B83","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623954916","uuid":"9290e7d2-1117-43d7-8956-51b39900c925","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.929"},{"stopsequence":"65","arrivaltime":"1701625919","stopid":"500309","tripid":"QV_D3-Sunday-072600_Q27_403","tripstartdate":"20231203","departuretime":"1701625919","triprouteid":"Q27","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623954969","uuid":"45f36d13-65fd-4b03-9c1c-ea6b1d740b28","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.935"},{"stopsequence":"78","arrivaltime":"1701624938","stopid":"803067","tripid":"MV_D3-Sunday-065800_M4_418","tripstartdate":"20231203","departuretime":"1701624938","triprouteid":"M4","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623954984","uuid":"f3a7a65d-398f-4011-91a2-4020a6d4cd72","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.939"},{"stopsequence":"29","arrivaltime":"1701627554","stopid":"400856","tripid":"MV_D3-Sunday-076000_M104_105","tripstartdate":"20231203","departuretime":"1701627554","triprouteid":"M104","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955018","uuid":"a7e314cf-3cb8-4187-af25-04949cfe3015","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.943"},{"stopsequence":"46","arrivaltime":"1701624630","stopid":"804053","tripid":"JA_D3-Sunday-070900_Q5_202","tripstartdate":"20231203","departuretime":"1701624630","triprouteid":"Q5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955039","uuid":"3bc9cb5a-271d-462f-8d15-a876aa662922","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.944"},{"stopsequence":"55","arrivaltime":"1701625527","stopid":"301148","tripid":"EN_D3-Sunday-070600_B15_116","tripstartdate":"20231203","departuretime":"1701625527","triprouteid":"B15","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955034","uuid":"e42ff0af-5ff6-48b5-bf4c-fe8e88f30684","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.947"},{"stopsequence":"27","arrivaltime":"1701627079","stopid":"500510","tripid":"JA_D3-Sunday-076500_Q5_202","tripstartdate":"20231203","departuretime":"1701627079","triprouteid":"Q5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955098","uuid":"52621284-e961-4e65-a21d-a24e6e559560","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.95"},{"stopsequence":"6","arrivaltime":"1701627353","stopid":"501373","tripid":"JA_D3-Sunday-078700_Q17_304","tripstartdate":"20231203","departuretime":"1701627353","triprouteid":"Q17","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955110","uuid":"e34a8eee-b88d-4875-ac5a-a35f31e305fa","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.951"},{"stopsequence":"9","arrivaltime":"1701626681","stopid":"305561","tripid":"EN_D3-Sunday-077600_B45_803","tripstartdate":"20231203","departuretime":"1701626681","triprouteid":"B65","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955122","uuid":"b4f0af6f-6e6f-4fc6-8f9f-14ba37b25984","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.953"},{"stopsequence":"18","arrivaltime":"1701624067","stopid":"306258","tripid":"EN_D3-Sunday-072500_B83_306","tripstartdate":"20231203","departuretime":"1701624067","triprouteid":"B83","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955127","uuid":"1dadce69-1486-4a6f-bb9a-af0cf9aaf096","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.953"},{"stopsequence":"61","arrivaltime":"1701628087","stopid":"803194","tripid":"MV_D3-Sunday-073800_M11_603","tripstartdate":"20231203","departuretime":"1701628087","triprouteid":"M11","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955188","uuid":"bfcd8660-1332-4e21-a159-21ed8714b448","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.958"},{"stopsequence":"27","arrivaltime":"1701624074","stopid":"500430","tripid":"JA_D3-Sunday-072000_MISC_729","tripstartdate":"20231203","departuretime":"1701624074","triprouteid":"Q4","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955190","uuid":"7fec9edc-d039-4698-b365-fa782f0cdcd9","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.958"},{"stopsequence":"3","arrivaltime":"1701627186","stopid":"404846","tripid":"MV_D3-Sunday-078900_M104_112","tripstartdate":"20231203","departuretime":"1701627186","triprouteid":"M104","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955192","uuid":"2dee82a1-f6b3-45fc-9163-9a3a6a609f77","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.96"},{"stopsequence":"35","arrivaltime":"1701627508","stopid":"403148","tripid":"MV_D3-Sunday-075000_M4_418","tripstartdate":"20231203","departuretime":"1701627508","triprouteid":"M4","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955283","uuid":"49ca0589-7037-4c9a-a82d-582794087696","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:26:56.963"},{"stopsequence":"66","arrivaltime":"1701625028","stopid":"306949","tripid":"EN_D3-Sunday-067900_B82_624","tripstartdate":"20231203","departuretime":"1701625028","triprouteid":"B82","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955291","uuid":"05b263a9-9b94-413a-98e0-414fce0389aa","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.564"},{"stopsequence":"39","arrivaltime":"1701625744","stopid":"400950","tripid":"MV_D3-Sunday-071800_M104_112","tripstartdate":"20231203","departuretime":"1701625744","triprouteid":"M104","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955303","uuid":"8726b9ea-e115-4710-8224-b7c213edbc04","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.564"},{"stopsequence":"40","arrivaltime":"1701627498","stopid":"804053","tripid":"JA_D3-Sunday-075400_MISC_754","tripstartdate":"20231203","departuretime":"1701627498","triprouteid":"Q5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955361","uuid":"199750ee-5014-47ac-be5e-b2daeae54c53","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.57"},{"stopsequence":"32","arrivaltime":"1701624479","stopid":"403125","tripid":"MV_D3-Sunday-070300_M104_106","tripstartdate":"20231203","departuretime":"1701624479","triprouteid":"M104","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955362","uuid":"ff5e799a-a717-49fb-9797-59d324c2732c","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.57"},{"stopsequence":"2","arrivaltime":"1701626709","stopid":"501369","tripid":"JA_D3-Sunday-076400_MISC_751","tripstartdate":"20231203","departuretime":"1701626709","triprouteid":"Q17","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955362","uuid":"374ac436-c218-4069-9936-c94582f101ff","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.57"},{"stopsequence":"53","arrivaltime":"1701624659","stopid":"304841","tripid":"FP_D3-Sunday-068600_Q58_831","tripstartdate":"20231203","departuretime":"1701624659","triprouteid":"Q58","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955395","uuid":"3db2d1b0-cf42-4810-ae55-d2917d32f67a","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.574"},{"stopsequence":"22","arrivaltime":"1701623998","stopid":"403975","tripid":"MV_D3-Sunday-071500_M3_328","tripstartdate":"20231203","departuretime":"1701623998","triprouteid":"M3","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955399","uuid":"1bebca0a-bf31-4bd6-acba-426e62af5918","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.574"},{"stopsequence":"29","arrivaltime":"1701627375","stopid":"400479","tripid":"MV_D3-Sunday-075800_M3_328","tripstartdate":"20231203","departuretime":"1701627375","triprouteid":"M3","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955418","uuid":"a98aa27a-c9a4-485e-bce7-14deaf1a6e42","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.575"},{"stopsequence":"45","arrivaltime":"1701625123","stopid":"502082","tripid":"QV_D3-Sunday-071900_MISC_110","tripstartdate":"20231203","departuretime":"1701625123","triprouteid":"Q43","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955442","uuid":"24a3c6ad-bf02-4d6b-9794-c20cc90750fe","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.577"},{"stopsequence":"56","arrivaltime":"1701625388","stopid":"801063","tripid":"EN_D3-Sunday-070000_Q56_452","tripstartdate":"20231203","departuretime":"1701625388","triprouteid":"Q56","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955476","uuid":"737f0e39-0480-44d0-b9f8-3e598ce20e8c","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.58"},{"stopsequence":"52","arrivaltime":"1701626076","stopid":"400618","tripid":"MV_D3-Sunday-071500_M5_501","tripstartdate":"20231203","departuretime":"1701626076","triprouteid":"M5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955505","uuid":"1fbe11fb-fa9b-47d0-817e-1ae31f8cd126","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.583"},{"stopsequence":"2","arrivaltime":"1701627588","stopid":"104113","tripid":"GH_D3-Sunday-079800_BX256_515","tripstartdate":"20231203","departuretime":"1701627588","triprouteid":"BX25","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955511","uuid":"e6198c68-c3fd-4b3b-9455-3e9658f3e8bd","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.583"},{"stopsequence":"0","arrivaltime":"1701628200","stopid":"803195","tripid":"MV_D3-Sunday-081000_M11_611","tripstartdate":"20231203","departuretime":"1701628200","triprouteid":"M11","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955515","uuid":"f521b7cc-078d-4f91-9bb8-e59b9d60169c","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.583"},{"stopsequence":"14","arrivaltime":"1701627285","stopid":"308044","tripid":"EN_D3-Sunday-078000_B82_624","tripstartdate":"20231203","departuretime":"1701627285","triprouteid":"B82","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955513","uuid":"0a261c26-a2d5-4bc2-86ed-6f0d2dc248be","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.587"},{"stopsequence":"7","arrivaltime":"1701627410","stopid":"400815","tripid":"MV_D3-Sunday-079000_M5_501","tripstartdate":"20231203","departuretime":"1701627410","triprouteid":"M5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955517","uuid":"061c2612-3ec5-4c1c-87db-625c56f0a316","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.588"},{"stopsequence":"2","arrivaltime":"1701627471","stopid":"307331","tripid":"EN_D3-Sunday-079100_B15_116","tripstartdate":"20231203","departuretime":"1701627471","triprouteid":"B15","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955517","uuid":"f9e36f0d-006d-4d67-980f-af7408cb2a89","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.589"},{"stopsequence":"62","arrivaltime":"1701626355","stopid":"903231","tripid":"MV_D3-Sunday-070000_M5_525","tripstartdate":"20231203","departuretime":"1701626355","triprouteid":"M5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955560","uuid":"0902ae1c-3bdb-4090-ae7c-7238da5e5c37","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.596"},{"stopsequence":"4","arrivaltime":"1701626850","stopid":"400812","tripid":"MV_D3-Sunday-077800_M5_525","tripstartdate":"20231203","departuretime":"1701626850","triprouteid":"M5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955565","uuid":"20f810c1-ee9d-416d-aef9-044de9e14ea4","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.596"},{"stopsequence":"29","arrivaltime":"1701627180","stopid":"503387","tripid":"EN_D3-Sunday-076000_B15_115","tripstartdate":"20231203","departuretime":"1701627180","triprouteid":"Q56","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955615","uuid":"7d96de26-004e-40fd-b996-99e27318e2fd","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.601"},{"stopsequence":"31","arrivaltime":"1701624653","stopid":"902139","tripid":"GH_D3-Sunday-071000_BX256_501","tripstartdate":"20231203","departuretime":"1701624653","triprouteid":"BX30","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955617","uuid":"5c0b3e8b-98d7-4dfb-9c1f-3d987a72be39","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.601"},{"stopsequence":"19","arrivaltime":"1701627302","stopid":"101745","tripid":"GH_D3-Sunday-077000_BX256_501","tripstartdate":"20231203","departuretime":"1701627302","triprouteid":"BX30","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955654","uuid":"4aec4a0f-7920-4cf4-aa2c-85f23b58d707","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.604"},{"stopsequence":"63","arrivaltime":"1701628333","stopid":"304072","tripid":"EN_D3-Sunday-073800_B82_625","tripstartdate":"20231203","departuretime":"1701628333","triprouteid":"B82","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955703","uuid":"8f71f98c-9f27-48c7-bebe-0a384a52e06d","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.606"},{"stopsequence":"46","arrivaltime":"1701624424","stopid":"501364","tripid":"JA_D3-Sunday-070100_MISC_749","tripstartdate":"20231203","departuretime":"1701624424","triprouteid":"Q17","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955707","uuid":"97ef1c26-3ea0-435a-8ebc-7c488db6cde2","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:29:40.607"},{"stopsequence":"48","arrivaltime":"1701626203","stopid":"804041","tripid":"JA_D3-Sunday-070900_MISC_751","tripstartdate":"20231203","departuretime":"1701626203","triprouteid":"Q17","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955855","uuid":"918f27ac-f723-4556-a5a8-9aa0f88dbd22","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.791"},{"stopsequence":"30","arrivaltime":"1701626009","stopid":"101724","tripid":"GH_D3-Sunday-073500_BX256_506","tripstartdate":"20231203","departuretime":"1701626009","triprouteid":"BX25","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955862","uuid":"ca9f896b-2603-4d90-a367-5fee041ed4a7","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.791"},{"stopsequence":"33","arrivaltime":"1701627460","stopid":"400769","tripid":"MV_D3-Sunday-076000_M5_508","tripstartdate":"20231203","departuretime":"1701627460","triprouteid":"M5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955889","uuid":"cb6520d8-4068-4e0d-b989-99094fe38616","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.794"},{"stopsequence":"36","arrivaltime":"1701626891","stopid":"501405","tripid":"JA_D3-Sunday-075700_MISC_749","tripstartdate":"20231203","departuretime":"1701626891","triprouteid":"Q17","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955932","uuid":"be9a8b03-b232-44ba-b772-7a19f8f63a23","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.797"},{"stopsequence":"53","arrivaltime":"1701624918","stopid":"304841","tripid":"FP_D3-Sunday-069600_Q58_810","tripstartdate":"20231203","departuretime":"1701624918","triprouteid":"Q58","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955950","uuid":"9c50d1f0-8f17-4426-a6e2-92e4f9a5a57e","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.798"},{"stopsequence":"0","arrivaltime":"1701628800","stopid":"400001","tripid":"MV_D3-Sunday-082000_M3_303","tripstartdate":"20231203","departuretime":"1701628800","triprouteid":"M3","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955970","uuid":"2070ca22-d977-4eda-aab6-3a052dae8be9","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.799"},{"stopsequence":"54","arrivaltime":"1701626690","stopid":"403757","tripid":"MV_D3-Sunday-072300_M11_617","tripstartdate":"20231203","departuretime":"1701626690","triprouteid":"M11","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955977","uuid":"3e313fdf-0028-4e5a-9c76-8d8fbe9616b0","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.802"},{"stopsequence":"23","arrivaltime":"1701624118","stopid":"301332","tripid":"EN_D3-Sunday-072000_B15_113","tripstartdate":"20231203","departuretime":"1701624118","triprouteid":"B12","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955978","uuid":"8d81586b-8162-4084-a4e0-42c903934269","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.802"},{"stopsequence":"12","arrivaltime":"1701627576","stopid":"306438","tripid":"EN_D3-Sunday-078000_B25_206","tripstartdate":"20231203","departuretime":"1701627576","triprouteid":"B12","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955999","uuid":"a93c6938-0b1f-4ed9-b357-55d8815c2527","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.804"},{"stopsequence":"60","arrivaltime":"1701624494","stopid":"400323","tripid":"MV_D3-Sunday-068200_M5_508","tripstartdate":"20231203","departuretime":"1701624494","triprouteid":"M5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623955999","uuid":"ab706cfa-61bf-487c-bb6f-022c60fdf1d0","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.804"},{"stopsequence":"37","arrivaltime":"1701626137","stopid":"500480","tripid":"JA_D3-Sunday-074500_MISC_742","tripstartdate":"20231203","departuretime":"1701626137","triprouteid":"Q84","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956020","uuid":"3602dd10-5dce-4ecf-9194-e19c81c47c0f","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.807"},{"stopsequence":"46","arrivaltime":"1701626467","stopid":"904236","tripid":"JA_D3-Sunday-074600_Q77_501","tripstartdate":"20231203","departuretime":"1701626467","triprouteid":"Q77","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956057","uuid":"36b6bbb3-2f17-451d-b310-f64dd71e31c5","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.814"},{"stopsequence":"8","arrivaltime":"1701627550","stopid":"502992","tripid":"FP_D3-Sunday-077100_Q58_810","tripstartdate":"20231203","departuretime":"1701627550","triprouteid":"Q58","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956064","uuid":"87598b86-6f59-46ce-a4bd-126957007d45","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.814"},{"stopsequence":"55","arrivaltime":"1701626232","stopid":"503793","tripid":"JA_D3-Sunday-072200_MISC_722","tripstartdate":"20231203","departuretime":"1701626232","triprouteid":"Q3","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956084","uuid":"85b7d381-0218-4f39-8254-82e61bb78eaf","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.816"},{"stopsequence":"0","arrivaltime":"1701627360","stopid":"904254","tripid":"JA_D3-Sunday-079600_MISC_722","tripstartdate":"20231203","departuretime":"1701627360","triprouteid":"Q3","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956097","uuid":"28ba6298-111b-451e-a73b-1488236a2ad9","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.819"},{"stopsequence":"17","arrivaltime":"1701627102","stopid":"405249","tripid":"MV_D3-Sunday-077200_M104_116","tripstartdate":"20231203","departuretime":"1701627102","triprouteid":"M104","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956098","uuid":"be550903-6c14-4b3c-837b-7ab92404b03d","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.819"},{"stopsequence":"81","arrivaltime":"1701627440","stopid":"404010","tripid":"MV_D3-Sunday-069800_M3_303","tripstartdate":"20231203","departuretime":"1701627440","triprouteid":"M3","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956154","uuid":"c2c97375-3967-4d90-aee1-3fcbf0cb9385","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:17.826"},{"stopsequence":"50","arrivaltime":"1701625651","stopid":"501414","tripid":"JA_D3-Sunday-071200_MISC_758","tripstartdate":"20231203","departuretime":"1701625651","triprouteid":"Q3","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956157","uuid":"62815ad2-355b-459c-a1d9-afa48232ea56","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.422"},{"stopsequence":"4","arrivaltime":"1701627273","stopid":"308864","tripid":"EN_D3-Sunday-079000_B82_628","tripstartdate":"20231203","departuretime":"1701627273","triprouteid":"B82","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956158","uuid":"d4a024ed-fdab-419b-87d4-12cc27a62f84","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.422"},{"stopsequence":"16","arrivaltime":"1701627556","stopid":"500220","tripid":"JA_D3-Sunday-078200_MISC_758","tripstartdate":"20231203","departuretime":"1701627556","triprouteid":"Q3","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956173","uuid":"1ddd599a-5dc3-4205-a6a9-7a6d9b8177d4","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.423"},{"stopsequence":"22","arrivaltime":"1701623931","stopid":"302419","tripid":"EN_D3-Sunday-070500_B25_208","tripstartdate":"20231203","departuretime":"1701623931","triprouteid":"B25","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956173","uuid":"86067bac-b541-40ed-829e-edb8f625543c","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.424"},{"stopsequence":"42","arrivaltime":"1701623940","stopid":"901211","tripid":"EN_D3-Sunday-067800_B25_203","tripstartdate":"20231203","departuretime":"1701623940","triprouteid":"B25","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956227","uuid":"3ae60bb7-ef91-4f73-9630-0677df1b3de8","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.425"},{"stopsequence":"7","arrivaltime":"1701626029","stopid":"302358","tripid":"EN_D3-Sunday-076800_B25_208","tripstartdate":"20231203","departuretime":"1701626029","triprouteid":"B25","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956206","uuid":"58c6a233-b12e-4b44-9961-b4a9af18e272","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.426"},{"stopsequence":"65","arrivaltime":"1701624096","stopid":"300493","tripid":"EN_D3-Sunday-066600_B82_619","tripstartdate":"20231203","departuretime":"1701624096","triprouteid":"B82","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956208","uuid":"c45918fa-6e4c-4c21-b51a-68804405234d","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.426"},{"stopsequence":"61","arrivaltime":"1701626013","stopid":"307206","tripid":"EN_D3-Sunday-069900_B82_603","tripstartdate":"20231203","departuretime":"1701626013","triprouteid":"B82","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956269","uuid":"e7fa1ff3-9222-42f8-b5b4-839319da2345","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.429"},{"stopsequence":"36","arrivaltime":"1701625243","stopid":"903089","tripid":"MV_D3-Sunday-071000_M104_116","tripstartdate":"20231203","departuretime":"1701625243","triprouteid":"M104","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956282","uuid":"99f2a9c9-6a61-4350-a74f-2726f4c0ac9a","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.431"},{"stopsequence":"6","arrivaltime":"1701626492","stopid":"301521","tripid":"EN_D3-Sunday-077500_B14_703","tripstartdate":"20231203","departuretime":"1701626492","triprouteid":"B14","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956292","uuid":"cb2aebc3-e038-4033-9ee2-921a3e2f8fd1","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.432"},{"stopsequence":"51","arrivaltime":"1701625753","stopid":"300564","tripid":"UP_D3-Sunday-071100_B6_225","tripstartdate":"20231203","departuretime":"1701625753","triprouteid":"B6","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956326","uuid":"601ced79-9115-40cf-9ace-efca7a7eea49","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.435"},{"stopsequence":"0","arrivaltime":"1701628200","stopid":"801177","tripid":"EN_D3-Sunday-081000_B25_205","tripstartdate":"20231203","departuretime":"1701628200","triprouteid":"B25","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956352","uuid":"d3f5fb0a-2765-445e-8f8d-90071b4444a9","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.437"},{"stopsequence":"41","arrivaltime":"1701625008","stopid":"804039","tripid":"JA_D3-Sunday-072000_MISC_732","tripstartdate":"20231203","departuretime":"1701625008","triprouteid":"Q84","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956386","uuid":"78a13d82-8dc1-41b5-a48c-49ed71c0a637","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.439"},{"stopsequence":"52","arrivaltime":"1701625424","stopid":"501699","tripid":"QV_D3-Sunday-073100_MISC_155","tripstartdate":"20231203","departuretime":"1701625424","triprouteid":"Q27","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956384","uuid":"69761a21-a767-4985-bb4f-ee1aabcc2475","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.44"},{"stopsequence":"28","arrivaltime":"1701627686","stopid":"301342","tripid":"EN_D3-Sunday-076800_B12_7","tripstartdate":"20231203","departuretime":"1701627686","triprouteid":"B12","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956391","uuid":"38f42dfa-dc07-4fea-a18f-b2177fd81fd1","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.441"},{"stopsequence":"46","arrivaltime":"1701624113","stopid":"403908","tripid":"MV_D3-Sunday-066800_M2_214","tripstartdate":"20231203","departuretime":"1701624113","triprouteid":"M2","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956393","uuid":"70dbfe3c-bb00-46f8-a1f2-94f62bec5732","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.442"},{"stopsequence":"46","arrivaltime":"1701625009","stopid":"307984","tripid":"EN_D3-Sunday-071500_B14_703","tripstartdate":"20231203","departuretime":"1701625009","triprouteid":"B14","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956418","uuid":"c63db176-2e47-4b56-a9ad-fe576831b0e1","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.442"},{"stopsequence":"25","arrivaltime":"1701627310","stopid":"403118","tripid":"MV_D3-Sunday-075500_M104_119","tripstartdate":"20231203","departuretime":"1701627310","triprouteid":"M104","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956438","uuid":"4cedebf7-4bae-4f14-94c7-6eb92b539d77","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.444"},{"stopsequence":"20","arrivaltime":"1701626185","stopid":"302418","tripid":"EN_D3-Sunday-075000_B25_203","tripstartdate":"20231203","departuretime":"1701626185","triprouteid":"B25","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956456","uuid":"2bf56338-450f-47c3-822e-8e485e976f9a","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.447"},{"stopsequence":"41","arrivaltime":"1701624311","stopid":"804039","tripid":"JA_D3-Sunday-070000_MISC_742","tripstartdate":"20231203","departuretime":"1701624311","triprouteid":"Q84","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956456","uuid":"45f37858-e48b-40f3-a5d8-480ebdd80e50","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.447"},{"stopsequence":"75","arrivaltime":"1701624662","stopid":"403976","tripid":"MV_D3-Sunday-066600_M3_314","tripstartdate":"20231203","departuretime":"1701624662","triprouteid":"M3","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956487","uuid":"7c269519-3cc8-4334-8b88-f2f3aa539c97","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.447"},{"stopsequence":"4","arrivaltime":"1701627414","stopid":"501372","tripid":"QV_D3-Sunday-079200_MISC_155","tripstartdate":"20231203","departuretime":"1701627414","triprouteid":"Q27","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956495","uuid":"271768c0-5464-4af3-9339-3ad4b025644d","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.45"},{"stopsequence":"21","arrivaltime":"1701627632","stopid":"308053","tripid":"UP_D3-Sunday-077600_B74_604","tripstartdate":"20231203","departuretime":"1701627632","triprouteid":"B6","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956508","uuid":"f512dd30-2aa0-425c-8b3a-15cdafabc34a","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.452"},{"stopsequence":"32","arrivaltime":"1701624800","stopid":"500560","tripid":"JA_D3-Sunday-072400_MISC_714","tripstartdate":"20231203","departuretime":"1701624800","triprouteid":"Q5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956511","uuid":"a615a3cf-c755-4e20-a3d8-ac23ea3be255","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.452"},{"stopsequence":"42","arrivaltime":"1701627372","stopid":"306343","tripid":"EN_D3-Sunday-075100_B15_114","tripstartdate":"20231203","departuretime":"1701627372","triprouteid":"B15","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956561","uuid":"cb7f04d2-688b-4960-b417-833d4067936e","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.455"},{"stopsequence":"44","arrivaltime":"1701623928","stopid":"500087","tripid":"JA_D3-Sunday-070000_Q77_501","tripstartdate":"20231203","departuretime":"1701623928","triprouteid":"Q77","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956562","uuid":"915913da-43d7-41ef-a28a-afed93c80bf8","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:25.455"},{"stopsequence":"3","arrivaltime":"1701627319","stopid":"300609","tripid":"UP_D3-Sunday-079200_B6_225","tripstartdate":"20231203","departuretime":"1701627319","triprouteid":"B6","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956568","uuid":"0e8dde46-49b3-4ecb-9f57-9747986e267f","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.503"},{"stopsequence":"0","arrivaltime":"1701628260","stopid":"307393","tripid":"EN_D3-Sunday-081100_B15_118","tripstartdate":"20231203","departuretime":"1701628260","triprouteid":"B15","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956599","uuid":"d966115c-c6cc-4eca-b65d-c57c747d58a2","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.503"},{"stopsequence":"14","arrivaltime":"1701627360","stopid":"500584","tripid":"JA_D3-Sunday-078000_MISC_714","tripstartdate":"20231203","departuretime":"1701627360","triprouteid":"Q5","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956572","uuid":"f85e81c1-39fe-45f7-a68c-a8282d89b01d","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.504"},{"stopsequence":"32","arrivaltime":"1701627082","stopid":"503437","tripid":"EN_D3-Sunday-074000_B12_3","tripstartdate":"20231203","departuretime":"1701627082","triprouteid":"Q56","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956604","uuid":"2bf04b69-4368-418f-9e39-62e012867103","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.505"},{"stopsequence":"56","arrivaltime":"1701626928","stopid":"300490","tripid":"UP_D3-Sunday-072800_B6_218","tripstartdate":"20231203","departuretime":"1701626928","triprouteid":"B6","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956651","uuid":"27cd7216-d71f-44a7-a1ba-a0eec501e810","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.508"},{"stopsequence":"22","arrivaltime":"1701627570","stopid":"400471","tripid":"MV_D3-Sunday-077000_M3_313","tripstartdate":"20231203","departuretime":"1701627570","triprouteid":"M3","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956689","uuid":"f823f316-5e82-49fb-808b-52800576ee98","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.509"},{"stopsequence":"37","arrivaltime":"1701625393","stopid":"901019","tripid":"EN_D3-Sunday-073100_B14_706","tripstartdate":"20231203","departuretime":"1701625393","triprouteid":"B17","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956710","uuid":"0a8172b0-4556-41a4-9e46-c1e540ba4020","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.51"},{"stopsequence":"38","arrivaltime":"1701624158","stopid":"404050","tripid":"MV_D3-Sunday-068700_M104_119","tripstartdate":"20231203","departuretime":"1701624158","triprouteid":"M104","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956716","uuid":"fa43bcb6-3e96-4771-b93f-43a32d4e0d4b","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.511"},{"stopsequence":"69","arrivaltime":"1701623951","stopid":"904253","tripid":"EN_D3-Sunday-066400_B15_114","tripstartdate":"20231203","departuretime":"1701623951","triprouteid":"B15","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956748","uuid":"7b526522-6f80-42c3-9837-46c588a150c2","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.512"},{"stopsequence":"38","arrivaltime":"1701626801","stopid":"307259","tripid":"EN_D3-Sunday-073800_B25_205","tripstartdate":"20231203","departuretime":"1701626801","triprouteid":"B25","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956749","uuid":"ea35bc97-efd4-4f80-b509-1630176fef2c","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.513"},{"stopsequence":"54","arrivaltime":"1701624411","stopid":"300663","tripid":"UP_D3-Sunday-069600_B6_206","tripstartdate":"20231203","departuretime":"1701624411","triprouteid":"B6","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956767","uuid":"8d4e405f-2895-48fe-9dbd-951bd6acc36e","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.514"},{"stopsequence":"25","arrivaltime":"1701627157","stopid":"300452","tripid":"EN_D3-Sunday-075900_B82_621","tripstartdate":"20231203","departuretime":"1701627157","triprouteid":"B82","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956770","uuid":"65dbc7ae-dbf7-4df0-82a7-2d460b0e8b73","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.514"},{"stopsequence":"55","arrivaltime":"1701624622","stopid":"503614","tripid":"EN_D3-Sunday-068000_B12_3","tripstartdate":"20231203","departuretime":"1701624622","triprouteid":"Q56","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956798","uuid":"defd336f-c1c8-4d46-bb40-4fc32c14d1ab","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.515"},{"stopsequence":"28","arrivaltime":"1701624265","stopid":"301414","tripid":"EN_D3-Sunday-070800_B12_7","tripstartdate":"20231203","departuretime":"1701624265","triprouteid":"B12","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956799","uuid":"6a805375-1a81-4100-a9d9-4dcb9c726238","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.515"},{"stopsequence":"29","arrivaltime":"1701623921","stopid":"901089","tripid":"EN_D3-Sunday-068400_Q56_457","tripstartdate":"20231203","departuretime":"1701623921","triprouteid":"B12","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956799","uuid":"fb71dbcc-eab1-45b4-874b-f94b5daadf64","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.515"},{"stopsequence":"51","arrivaltime":"1701623939","stopid":"904121","tripid":"QV_D3-Sunday-068800_MISC_149","tripstartdate":"20231203","departuretime":"1701623939","triprouteid":"Q46","locationcountrycode":"","maxlat":"","maxlong":"","locationmunicipality":"","minlong":"","locationsubdivisionname":"","minlat":"","ts":"1701623956802","uuid":"6e1d8a2a-0733-42c4-9973-78f8ff6a53f7","rundate":"","providername":"","transitname":"","eventTimeStamp":"2023-12-03 17:30:42.515"}]