Research Data and Analytical Code — Road Drainage Infrastructure Diagnostics and Deficiency Indexing in ENSO-Vulnerable Andean Corridors: A STEM-PjBL Field Assessment
收藏资源简介:
Dataset and Analytical Code for: Road Drainage Infrastructure Diagnostics and Deficiency Indexing in ENSO-Vulnerable Andean Corridors: A STEM-PjBL Field AssessmentThis repository contains the complete research data and analytical code supporting the above manuscript, submitted to Sustainability (MDPI, Special Issue: Resilient Infrastructure for Climate Action: The Nexus of Technology, Management, and Innovation). The study presents a STEM-integrated Project-Based Learning (PjBL) diagnostic framework applied to 42 road segments across six corridors in Loja Province, southern Ecuador, where El Niño–Southern Oscillation (ENSO)-driven precipitation extremes pose recurrent threats to road drainage infrastructure. Using ArcGIS Survey123, standardised field data were collected on the presence, cross-sectional geometry, structural condition, and failure modes of four drainage structure typologies: crown gutters, road gutters, hydraulic chutes, and culverts. A Composite Drainage Deficiency Index (DDI; range 0–100) was derived from five equally weighted binary indicators to provide an operationally deployable, georeferenced prioritisation tool for highway maintenance authorities. Statistical analysis was performed in R v 4.5.2 using a fully non-parametric pipeline comprising Shapiro–Wilk normality assessment, Wilson 95% confidence intervals, Fisher's exact tests, Cramér's V with bootstrap confidence intervals, Spearman rank-order correlations with Benjamini–Hochberg false discovery rate correction, Kruskal–Wallis H-tests with ε² effect sizes, Ward.D2 hierarchical clustering with silhouette optimisation, and jackknife leave-one-out sensitivity analysis. This repository includes the raw field dataset (datos_base.xlsx), the complete annotated R script (codigo_R.R), and the full R console output (Consol_R.txt), enabling end-to-end reproducibility of all reported results, figures, and tables from the primary data.



