Wrocław MPK (tram and buses) historical, geolocation data

Data example

2019-06-30T02:07:24.527025;tram;7;13397250;51.124763;17.038773
2019-06-30T02:07:24.527025;tram;10;13396302;51.12382;17.04098
2019-06-30T02:07:24.527025;bus;246;13411103;51.114193;16.967928
2019-06-30T02:07:24.527025;bus;d;13413603;51.148746;17.021032
Since September 2019, microsecond part is omitted:
2019-09-01T14:57:49;tram;33;13815687;51.130753;16.966825
2019-09-01T14:57:49;tram;17;13816387;51.06587;16.987036
2019-09-01T14:57:49;tram;7;13816135;51.09048;17.016829
2019-09-01T14:57:49;tram;9;13816366;51.07401;17.015736

Data format

Each contains 6 columns (cells) separated by ; (semicolon), each cell representing:

  1. API call time as UTC (you need to convert it to local Wrocław time on your side)
  2. Line type (bus or tram)
  3. Bus/tram line number
  4. Bus/tram unit identifier
  5. Latitude (N/S) in given time
  6. Longitude (E/W) in given time

Data quality

Data is stored daily as a zipped CSV file, each line representing position of a single tram/bus unit in given time

The API is called each 15 seconds and the response is translated directly into CSV format, without any attempt to validate or clean up the data

There might be missing measures for few minutes here and there, as infrastructure collecting the data is self-hosted and requires occasional maintenance

Background

Since May 2019, I've been collecting nearly-real-time geolocation data of Wrocław trams and buses using MPK public API

Here you can download the data and do something helpful to society with it :)

For ideas, discussions or suggestions, please contact me at emkor93@gmail.com

Source code and setup

The hardware is Raspberry Pi running in my local LAN

RPi runs simple script that utilizes my MPK API client

Disclosure

Data is hosted on Backblaze's B2 Cloud Storage service, and since I'm using cheap plan, daily download is capped at 2GB.

It means that if Backblaze cancels your download, please try again the other day.

Download

Please wait while file list is being retrieved from B2...