Uniform BIXI Open Data

BIXI Montréal is the non-profit organization created in 2014 by the city of Montreal to manage its bike-sharing system.

Every year, the organization publishes trip history and station status open data. However, the format of this data changes from one year to another.

This projects provides the original BIXI open data in a unique, uniform format for the years 2014 to 2021, inclusive. Since 2022, the format of the BIXI data is now incompatible with data from the previous years.

Data

The following data archives are available.

Changes to the original data

Uniformity in the data provided here stems from the following changes to the original BIXI data.

• Archives names always of the form

  <year>-donnees-ouvertes-uniformes-<sha>.zip

  The SHA numbers are the ones of BIXI Montréal.

• Trip history data always provided as one file per month. Since 2020, BIXI Montréal publishes this data as a single file for the year.

• Identical file name structure throughout the years:

  OD-<year>-<month>u.csv

  for the trip history data;

  Stations-<year>u.csv

  for the station status data.

• Identical column names throughout the years, using the names from 2021 as a reference.

  The names start_station_code and end_station_code used by BIXI Montréal since 2014 in the trip history data were replaced by emplacement_pk_start and emplacement_pk_end in 2021. In the same vein, the name code in the station status data (Code in 2019) was changed to pk.

  The “location numbers” now being used in the data are not station codes. The new naming scheme is nevertheless applied to the data prior to 2021 that do use proper station codes.

Auteur

Vincent Goulet, professor, École d’actuariat, Université Laval.

Licence

The uniform BIXI open data are adapted from the open data of BIXI Montréal. Both data sets are licensed under the Creative Commons BY-SA 4.0.