Georeferenced Electromagnetic-Field Exposure Measurements in Colombia
Description
This repository contains a curated and reproducible data package for georeferenced electromagnetic-field exposure measurements in Colombia. The package was prepared to support the associated Data Descriptor manuscript and to facilitate reuse of the dataset in environmental monitoring, geospatial analysis, telecommunications planning, and non-ionizing electromagnetic-field exposure assessment. The source records are derived from the official Colombian open-data portal Datos Abiertos Colombia, under the dataset “Mediciones de exposición a campos electromagnéticos”, supplied by the Agencia Nacional del Espectro – ANE, Bogotá D.C. The source dataset contains timestamped measurements collected through fixed monitoring stations. Each record includes the station identifier, city/department label, measurement date and time, exposure level, restrictive limit, exposure percentage, and georeferenced point geometry encoded as WKT. The dataset includes 1,286,346 source records and seven original variables. The temporal coverage extends from 2 November 2023 to 30 June 2024. A 2024 analysis subset containing 995,238 records was used to generate the main station-level summaries and the illustrative spatial workflow. Because the source file contains repeated measurements at fixed monitoring locations, the repository provides both row-level validation outputs and station-level aggregated summaries. The repository includes the raw or source-derived CSV file, an R script for reproducible cleaning and validation, station-level summaries for 2024, technical validation tables, temporal coverage tables, a variable schema, IDW leave-one-out validation outputs, and figures used to document the processing workflow. The R script parses date-time values, extracts longitude and latitude from WKT geometries, validates coordinate plausibility, checks missing values and duplicate records, verifies the relationship between exposure level, restrictive limit, and exposure percentage, and exports analysis-ready tables. The inverse distance weighting (IDW) example included in the repository is intended as an exploratory spatial-use case based on 2024 station-level mean exposure values. It should not be interpreted as a physical propagation model, regulatory compliance assessment, or uncertainty-based prediction surface.
Files
Steps to reproduce
Download or clone the repository and open the project folder in R or RStudio. Place the raw CSV file in the data_raw/ folder using the expected filename indicated in the README. Install the required R packages listed in cleaning_analysis.R, then run: source("cleaning_analysis.R") The script recreates the cleaned tables, station-level summaries, validation outputs, figures, and session information in the outputs/ folder.