Historical air quality database in Navarre, Spain (2011–2025): Harmonized hourly records and relational Star Schema of atmospheric pollutants
Abstract
Administrative air quality monitoring networks often release public data across fragmented repositories, variable formats, and inconsistent time encodings, hindering automated scientific re-use. This paper presents a curated, harmonized, and quality-controlled environmental dataset covering 15 consecutive years (2011–2025) of hourly atmospheric observations in Navarre, Spain. Integrating approximately 8.6 million hourly observations collected across 14 official monitoring stations, the raw multi-variable wide tables were ingested, validated, and normalized into a relational Star Schema following Tidy Data principles. Chemical variables are harmonized using the European Environment Agency (EEA / EIONET) standardized pollutant ontology. Strict temporal continuity (UTC normalization) and explicit missingness tracking were enforced to preserve auditability for atmospheric modeling, machine learning, and epidemiological research. The complete dataset, tabular schemas, and reproducible Python ETL pipelines are openly accessible via Zenodo under a CC-BY 4.0 license.
Related
- A harmonized method for the analysis of 32 PFAS in priority food matrices for interagency regulatory analysis
- 多孔框架材料用于食品中新污染物的样品前处理研究进展 Recent progress on sample pretreatment methods of emerging pollutants in food based on porous framework materials
- Turning NOx Pollutants into Green Ammonia Fuel via COF Cavity Confinement
- Metal-organic frameworks (MOFs) based adsorbents for efficient removal of antibiotic pollutants from water
- Challenging the Surface Area Paradigm: A Critical Review of Low-BET Metal–Organic Frameworks for the Adsorption of Organic Water Pollutants
BibTeX
@misc{rollangonzalez2026historical,
title = {{Historical air quality database in Navarre, Spain (2011–2025): Harmonized hourly records and relational Star Schema of atmospheric pollutants}},
author = {Aimar Rollán-González},
howpublished = {EarthArXiv},
year = {2026},
month = oct,
doi = {10.31223/x5pz3d},
url = {https://eartharxiv.org/repository/view/15846/},
note = {CC BY 4.0},
}
RIS
TY - UNPB
TI - Historical air quality database in Navarre, Spain (2011–2025): Harmonized hourly records and relational Star Schema of atmospheric pollutants
AU - Aimar Rollán-González
PY - 2026
DA - 2026/10/30
PB - EarthArXiv
DO - 10.31223/x5pz3d
UR - https://eartharxiv.org/repository/view/15846/
AB - Administrative air quality monitoring networks often release public data across fragmented repositories, variable formats, and inconsistent time encodings, hindering automated scientific re-use. This paper presents a curated, harmonized, and quality-controlled environmental dataset covering 15 consecutive years (2011–2025) of hourly atmospheric observations in Navarre, Spain. Integrating approximately 8.6 million hourly observations collected across 14 official monitoring stations, the raw multi-variable wide tables were ingested, validated, and normalized into a relational Star Schema following Tidy Data principles. Chemical variables are harmonized using the European Environment Agency (EEA / EIONET) standardized pollutant ontology. Strict temporal continuity (UTC normalization) and explicit missingness tracking were enforced to preserve auditability for atmospheric modeling, machine learning, and epidemiological research. The complete dataset, tabular schemas, and reproducible Python ETL pipelines are openly accessible via Zenodo under a CC-BY 4.0 license.
ER -