2021
Zaragozí, Benito; Trilles-Oliver, Sergio; Gutiérrez, Aaron; Miravet, Daniel
Development of a Common Framework for Analysing Public Transport Smart Card Data Journal Article
In: Energies, vol. 14, no. 19, pp. 6083, 2021, ISSN: 1996-1073.
Abstract | Links | BibTeX | Tags: Open science, public transport, smart data card
@article{Zaragozi2021c,
title = {Development of a Common Framework for Analysing Public Transport Smart Card Data},
author = {Benito Zaragozí and Sergio Trilles-Oliver and Aaron Gutiérrez and Daniel Miravet},
doi = {https://doi.org/10.3390/en14196083},
issn = {1996-1073},
year = {2021},
date = {2021-09-24},
journal = {Energies},
volume = {14},
number = {19},
pages = {6083},
abstract = {The data generated in public transport systems have proven to be of great importance in improving knowledge of public transport systems, being very valuable in promoting the sustainability of public transport through rational management. However, the analysis of this data involves numerous tasks, so that when the value of analysing the data is finally verified, the effort has already been very great. The management and analysis of the collected data face some difficulties. This is the case of the data collected by the current automated fare collection systems. These systems do not follow any open standards and are not usually designed with a multipurpose nature, so they do not facilitate the data analysis workflow (i.e., acquisition, storage, quality control, integration and quantitative analysis). Intending to reduce this workload, we propose a conceptual framework for analysing data from automated fare collection systems in mobility studies. The main components of this framework are (1) a simple data model, (2) scripts for creating and querying the database and (3) a system for reusing the most useful queries. This framework has been tested in a real public transport consortium in a Spanish region shaped by tourism. The outcomes of this research work could be reused and applied, with a lower initial effort, in other areas that have data recorded by an automated fare collection system but are not sure if it is worth investing in exploiting the data. After this experience, we consider that, even with the legal limitations applicable to the analysis of this type of data, the use of open standards by automated fare collection systems would facilitate the use of this type of data to its full potential. Meanwhile, the use of a common framework may be enough to start analysing the data.},
keywords = {Open science, public transport, smart data card},
pubstate = {published},
tppubtype = {article}
}
The data generated in public transport systems have proven to be of great importance in improving knowledge of public transport systems, being very valuable in promoting the sustainability of public transport through rational management. However, the analysis of this data involves numerous tasks, so that when the value of analysing the data is finally verified, the effort has already been very great. The management and analysis of the collected data face some difficulties. This is the case of the data collected by the current automated fare collection systems. These systems do not follow any open standards and are not usually designed with a multipurpose nature, so they do not facilitate the data analysis workflow (i.e., acquisition, storage, quality control, integration and quantitative analysis). Intending to reduce this workload, we propose a conceptual framework for analysing data from automated fare collection systems in mobility studies. The main components of this framework are (1) a simple data model, (2) scripts for creating and querying the database and (3) a system for reusing the most useful queries. This framework has been tested in a real public transport consortium in a Spanish region shaped by tourism. The outcomes of this research work could be reused and applied, with a lower initial effort, in other areas that have data recorded by an automated fare collection system but are not sure if it is worth investing in exploiting the data. After this experience, we consider that, even with the legal limitations applicable to the analysis of this type of data, the use of open standards by automated fare collection systems would facilitate the use of this type of data to its full potential. Meanwhile, the use of a common framework may be enough to start analysing the data.
Zaragozí, Benito; Gutierrez, Aaron; Trilles-Oliver, Sergio
Analysis of Public Transport Mobility Data: A System for Sharing and Reusing GIS Database Queries Proceedings Article
In: Geographical Information Systems Theory, Applications and Management. GISTAM 2020, pp. 102-118, Springer, Cham, 2021, ISBN: 978-3-030-76374-9.
Abstract | Links | BibTeX | Tags: Geographic Information Systems (GIS), public transport, urban mobility
@inproceedings{Zaragozi2021d,
title = {Analysis of Public Transport Mobility Data: A System for Sharing and Reusing GIS Database Queries},
author = {Benito Zaragozí and Aaron Gutierrez and Sergio Trilles-Oliver},
doi = {https://doi.org/10.1007/978-3-030-76374-9_7},
isbn = {978-3-030-76374-9},
year = {2021},
date = {2021-06-01},
booktitle = {Geographical Information Systems Theory, Applications and Management. GISTAM 2020},
volume = {1411},
pages = {102-118},
publisher = {Springer, Cham},
series = {Communications in Computer and Information Science},
abstract = {Data from automated fare collection systems have become almost essential in the study of the mobility of people using public transport. Among other advantages, the data collected enable longitudinal studies to be carried out with a detail that other sources cannot approximate. However, despite the great potential of these data, the data collecting systems are usually intended for purely accounting purposes and not for carrying out mobility studies. Largely for this reason, these data are not always used to their full potential, and so it is necessary to propose strategies that allow the preparation and exploitation of these data, especially in those cases where the usefulness and value of the data have not yet been proven. This study proposes a workflow that seeks to prevent duplication of efforts when querying this type of data. The implementation of a generic database model and a protocol for sharing meaningful queries and results greatly facilitates an initial analysis of these data. This strategy has been applied within a specific project, but it could be the basis for sharing methods between different studies.},
keywords = {Geographic Information Systems (GIS), public transport, urban mobility},
pubstate = {published},
tppubtype = {inproceedings}
}
Data from automated fare collection systems have become almost essential in the study of the mobility of people using public transport. Among other advantages, the data collected enable longitudinal studies to be carried out with a detail that other sources cannot approximate. However, despite the great potential of these data, the data collecting systems are usually intended for purely accounting purposes and not for carrying out mobility studies. Largely for this reason, these data are not always used to their full potential, and so it is necessary to propose strategies that allow the preparation and exploitation of these data, especially in those cases where the usefulness and value of the data have not yet been proven. This study proposes a workflow that seeks to prevent duplication of efforts when querying this type of data. The implementation of a generic database model and a protocol for sharing meaningful queries and results greatly facilitates an initial analysis of these data. This strategy has been applied within a specific project, but it could be the basis for sharing methods between different studies.