Articles producció científica> Geografia

Towards an Affordable GIS for Analysing Public Transport Mobility Data: A Preliminary File Naming Convention for Avoiding Duplication of Efforts

  • Datos identificativos

    Identificador: imarina:9161965
    Autores:
    Zaragozi, BenitoGutierrez, AaronTrilles, Sergio
    Resumen:
    Automated fare collection systems for public transport generate a large volume of information on the mobility of people in urban environments. New technologies associated with Big Data can facilitate the analysis of these data. However, the application of these technologies can be expensive and resource-demanding, especially in medium and small cities. This paper presents the case of the metropolitan transport authority of Tarragona, for which an affordable and extensible analysis system has been developed, based on relational databases and custom scripts. Among the technical problems that have had to be overcome, one of the first has been the unambiguous definition of the numerous queries required by mobility experts. For different reasons, mobility researchers request aggregate data queries from smart transport cards logs (e.g. providing a descriptive statement) and expect manageable tables to be analysed in a spreadsheet. To standardise the definition of queries, a domain-specific language as a file naming convention has been proposed with which database managers and mobility experts can communicate efficiently, avoiding confusion, duplication of efforts and other problems detected. The file naming convention has been applied as an early version within the defined use case to verify the viability of this idea.
  • Otros:

    Autor según el artículo: Zaragozi, Benito; Gutierrez, Aaron; Trilles, Sergio;
    Departamento: Geografia
    Autor/es de la URV: Gutiérrez Palomero, Aaron / Zaragozí Zaragozí, Benito Manuel
    Palabras clave: Smart card data Public transportation Medium-sized data File naming convention Domain-specific language Card data
    Resumen: Automated fare collection systems for public transport generate a large volume of information on the mobility of people in urban environments. New technologies associated with Big Data can facilitate the analysis of these data. However, the application of these technologies can be expensive and resource-demanding, especially in medium and small cities. This paper presents the case of the metropolitan transport authority of Tarragona, for which an affordable and extensible analysis system has been developed, based on relational databases and custom scripts. Among the technical problems that have had to be overcome, one of the first has been the unambiguous definition of the numerous queries required by mobility experts. For different reasons, mobility researchers request aggregate data queries from smart transport cards logs (e.g. providing a descriptive statement) and expect manageable tables to be analysed in a spreadsheet. To standardise the definition of queries, a domain-specific language as a file naming convention has been proposed with which database managers and mobility experts can communicate efficiently, avoiding confusion, duplication of efforts and other problems detected. The file naming convention has been applied as an early version within the defined use case to verify the viability of this idea.
    Grupo de investigación: GRATET. Anàlisi Territorial i Estudis Turístics
    Acceso a la licencia de uso: https://creativecommons.org/licenses/by/3.0/es/
    Direcció de correo del autor: benito.zaragozi@urv.cat aaron.gutierrez@urv.cat
    Identificador del autor: 0000-0003-2501-484X 0000-0003-0557-6319
    Fecha de alta del registro: 2023-11-18
    Versión del articulo depositado: info:eu-repo/semantics/publishedVersion
    Enlace a la fuente original: https://www.scitepress.org/PublicationsDetail.aspx?ID=dvBIDRlpbxA=&t=1
    Referencia al articulo segun fuente origial: Proceedings Of The 6th International Conference On Geographical Information Systems Theory, Applications And Management (Gistam). 302-309
    Referencia de l'ítem segons les normes APA: Zaragozi, Benito; Gutierrez, Aaron; Trilles, Sergio; (2020). Towards an Affordable GIS for Analysing Public Transport Mobility Data: A Preliminary File Naming Convention for Avoiding Duplication of Efforts.
    URL Documento de licencia: https://repositori.urv.cat/ca/proteccio-de-dades/
    DOI del artículo: 10.5220/0009766303020309
    Entidad: Universitat Rovira i Virgili
    Año de publicación de la revista: 2020
    Tipo de publicación: Proceedings Paper
  • Palabras clave:

    Smart card data
    Public transportation
    Medium-sized data
    File naming convention
    Domain-specific language
    Card data
  • Documentos:

  • Cerca a google

    Search to google scholar