Powered by OpenAIRE graph
Found an issue? Give us feedback
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/ ZENODOarrow_drop_down
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
ZENODO
Other literature type . 2022
License: CC BY
Data sources: ZENODO
ZENODO
Other literature type . 2022
License: CC BY
Data sources: Datacite
ZENODO
Other literature type . 2022
License: CC BY
Data sources: Datacite
versions View all 2 versions
addClaim

Extracting, Transforming, and Loading School Data from OpenStreetMap: A Comprehensive Analysis

Authors: Yeneneh, Yonas;

Extracting, Transforming, and Loading School Data from OpenStreetMap: A Comprehensive Analysis

Abstract

This article presents a comprehensive analysis of developing and implementing an ETL (Extract, Transform, Load) pipeline for processing school data from OpenStreetMap (OSM) across multiple countries. The project's primary goal was to create a reliable database of educational institutions that could serve various applications, from educational planning to infrastructure development. The implementation faced significant challenges, including varying data quality across regions, multilingual content, and inconsistent classification systems. The solution involved a sophisticated three-phase approach: extraction using the OSM Overpass API, transformation with robust cleaning and validation processes, and loading into a standardized database format. The technical implementation proved particularly interesting in its handling of complex data scenarios. The system successfully processed school data for multiple countries, including Albania and Ukraine, implementing intelligent solutions for duplicate detection, education level classification, and multilingual data handling. Key achievements included the development of a sophisticated validation system, efficient handling of different OSM element types (nodes, ways, and relations), and the creation of a standardized data structure that maintained data quality while accommodating regional variations. The project demonstrated the potential of leveraging crowd-sourced data for educational planning while highlighting the importance of careful data processing and validation. The lessons learned and solutions developed provide valuable insights for similar projects working with geographical and educational infrastructure data.

  • BIP!
    Impact byBIP!
    selected citations
    These citations are derived from selected sources.
    This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    0
    popularity
    This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
    Average
    influence
    This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    Average
    impulse
    This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
    Average
Powered by OpenAIRE graph
Found an issue? Give us feedback
selected citations
These citations are derived from selected sources.
This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Citations provided by BIP!
popularity
This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
0
Average
Average
Average
Green