DOI: 10.5281/zenodo.16744483
title: Supplementary Material – Divergent Frameworks, Shared Challenges: A Comparative Analysis of National and State Water Security Plans in Minas Gerais, Brazil (Ferreira; Macedo; Magalhães Junior)

description: Supplementary Materials – Article Submission to RBRH  Author: Matheus Vinícius Ferreira; Diego Rodrigues Macedo; Antônio Pereira Magalhães JuniorArticle Title: Divergent Frameworks, Shared Challenges: A Comparative Analysis of National and State Water Security Plans in Minas Gerais, Brazil  Date: August 2025  

This folder contains supplementary material related to the manuscript submitted to the Brazilian Journal of Water Resources (RBRH). It includes:  - An Excel spreadsheet with the original variables used in the construction of the ISH and IGP indices (prior to spatial aggregation),  - Three figures illustrating the statistical correlation between ISH and IGP,  - Five shapefiles used in the spatial analysis of water security.

-------------------------------------------------------------1. Excel File-------------------------------------------------------------

- ISH_PMSH_Variables.xlsx    → Spreadsheet containing the **original variables** used in the construction of the Water Security Index (ISH) and in the PMSH prioritization analysis via the IGP. These data represent indicator-level values **before municipal aggregation** and are organized by original analytical units.

-------------------------------------------------------------2. Figures-------------------------------------------------------------

- ISH_IGP_Correlation_Mean.jpg    → Scatter plot showing the correlation between the **mean** values of the ISH and IGP indices.      Equation: y = 0.0204x + 3.8775      R² = 0.0057

- ISH_IGP_Correlation_Median.jpg    → Scatter plot showing the correlation between the **median** values of the ISH and IGP indices.      Equation: y = 0.0156x + 3.9425      R² = 0.0033

- ISH_IGP_Correlation_Mode.jpg    → Scatter plot showing the correlation between the **mode** values of the ISH and IGP indices.      Equation: y = 0.0507x + 3.7813      R² = 0.0328

-------------------------------------------------------------3. Shapefiles-------------------------------------------------------------

Each folder contains a complete set of shapefile components (.shp, .shx, .dbf, .prj). All spatial layers are projected in **SIRGAS 2000 (EPSG: 4674)**.

- /ISH_2017/    → Original ISH values for the year 2017, calculated and mapped by **ottobacias**.

- /ISH_2035/    → Projected ISH values for the year 2035, by **ottobacias**.

- /ISH_standardized/    → Standardized ISH values **converted to the municipal scale** for comparative analysis.

- /IGP_standardized/    → Standardized IGP values **converted to the municipal scale**, representing PMSH priority classification.

- /PMSH_IGP_components/    → Spatial layers of the IGP index and its components used in the PMSH, represented by **aggregated planning units (Unidades Agregadas)**.

-------------------------------------------------------------

All data and figures are original and were used to support the spatial and statistical analyses presented in the manuscript. For further information, please contact the corresponding author.

End of README