Assessing Temporal and Territorial Performance of SDG 11 at Local Scale
DOI:
https://doi.org/10.24193/subbgeogr.2025.1.02Keywords:
SDG 11, local level, PostgreSQL, Temporal analysis, Satu MareAbstract
Assessing Temporal and Territorial Performance of SDG 11 at Local Scale. This study aims to evaluate the performance of each LAU (Local Administrative Unit) within Satu Mare County and the Satu Mare Metropolitan Area in achieving Sustainable Development Goal 11 (SDG 11) - “Sustainable Cities and Communities”, for two distinct reference years: 2016 and 2024. For this purpose, a dataset was collected, based on which ten relevant indicators, identical for both years analysed, were calculated. The data were organised in a PostgreSQL database, where most of the computations were performed, including the normalisation process of the indicators. The SDG 11 Index was calculated using the normalised values, applying equal weights to each indicator. This approach enabled the assessment of the progress achieved over the past eight years towards achieving SDG 11, both at the level of Satu Mare County and the metropolitan area.
References
1. Aquilino, M., Tarantino, C., Adamo, M., Barbanente, A., & Blonda, P. (2020), Earth observation for the implementation of Sustainable Development Goal 11 indicators at local scale: Monitoring of the migrant population distribution, Remote Sensing, 12 (6), 950. https://doi.org/10.3390/rs12060950
2. Benedek, J., Ivan, K., Török, I., Temerdek, A., & Holobâcă, I.-H. (2021), Indicator-based assessment of local and regional progress toward the Sustainable Development Goals (SDGs): An integrated approach from Romania, Sustainable Development, 29, 860–875. https://doi.org/10.1002/sd.21808
3. Brown, C. F., Brumby, S. P., Guzder-Williams, B., Birch, T., Brooks Hyde, S., Mazzariello, J., Czerwinski, W., Pasquarella, V. J., Haertel, R., Ilyushchenko, S., Schwehr, K., Weisse, M., Stolle, F., Hanson, C., Guinan, O., Moore, R., & Tait, A. M. (2022), Dynamic World, near real-time global 10 m land use land cover mapping, Scientific Data, 9, 251. https://doi.org/10.1038/s41597-022-01307
4. Consiliul Județean Satu Mare (2021), Strategia de dezvoltare a județului Satu Mare pentru perioada 2021–2030 (varianta integrală), https://www.cjsm.ro/strategia-de-dezvoltare-a-judetului-satu-mare-pentru-perioada-2021-2030.
5. Feng, Y., Huang, C., Song, X., & Gu, J. (2023), Assessing progress and interactions toward SDG 11 indicators based on geospatial big data at prefecture-level cities in the Yellow River Basin between 2015 and 2020, Remote Sensing, 15 (6), 1668. https://doi.org/10.3390/rs15061668.
6. General Inspectorate of Romanian Police (2019), Traffic Department (GIRPTD).
7. Haynes, D., Mitchell, P., & Shook, E. (2020), Developing the raster big data benchmark: A comparison of raster analysis on big data platforms, ISPRS International Journal of Geo-Information, 9 (11), 690. https://doi.org/10.3390/ijgi9110690
8. Holobâcă, I.-H., Benedek, J., Ursu, C.-D., Alexe, M., & Temerdek-Ivan, K. (2022), Ratio of land consumption rate to population growth rate in the major metropolitan areas of Romania, Remote Sensing, 14 (23), 6016. https://doi.org/10.3390/rs14236016.
9. Khalid, A. M., Sharma, S., & Dubey, A. K. (2020), Data gap analysis, indicator selection and index development: A case for developing economies, Social Indicators Research, 148, 893–960. https://doi.org/10.1007/s11205-019-02225-6.
10. Liu, Y., Huang, B., Guo, H., Zhang, J., & Wu, C. (2023), A big data approach to assess progress towards Sustainable Development Goals for cities of varying sizes, Communications Earth & Environment, 4, 66. https://doi.org/10.1038/s43247-023-00730-8.
11. Murphy, E., Murphy, E., Sachs, J. D., & Walsh, P. P. (2025), How does the USA perform in the Sustainable Development Goals: A Northern Hemisphere peer-based index, Sustainable Development. https://doi.org/10.1002/sd.3445.
12. Nagy, J., Benedek, J., & Ivan, K. (2018), Measuring sustainable development goals at a local level: A case of a metropolitan area in Romania, Sustainability, 10 (11), 3962. https://doi.org/10.3390/su10113962.
13. National Institute of Statistics (NIS) (2025), Bucharest, Romania. http://www.insse.ro.
14. Poli, G., Cuntò, S., & Muccio, E. (2024), A data-driven approach to monitor sustainable development transition in Italian regions through SDG 11 indicators, in O. Gervasi, B. Murgante, C. Garau, D. Taniar, A. M. A. C. Rocha, & M. N. Faginas Lago (eds.), Computational Science and Its Applications – ICCSA 2024 Workshops (Lecture Notes in Computer Science, Vol. 14820). Springer. https://doi.org/10.1007/978-3-031-65285-1_22.
15. Primăria Municipiului Satu Mare (2017), Strategia Integrată de Dezvoltare Urbană 2016–2025 (SIDU) a Municipiului Satu Mare, https://www.primariasm.ro/storage/comunicare/sidu-sm-2017-v1.pdf.
16. Sachs, J., Schmidt-Traub, G., Kroll, C., Lafortune, G., Fuller, G., & Woelm, F. (2020), The sustainable development goals and COVID-19, Sustainable Development Report 2020. Cambridge University Press.
17. Schmidt-Traub, G., Kroll, C., Teksoz, K., Durand-Delacre, D., & Sachs, J. D. (2017), National baselines for the Sustainable Development Goals assessed in the SDG Index and Dashboards, Nature Geoscience, 10, 547–555. https://doi.org/10.1038/ngeo2985.
18. Tomalty, R., Alexander, D., Anielski, M., Wilson, J., Jozsa, A., Haider, M., Cartin-Artega, F., Casey, D. (2007), Ontario community sustainability report – 2007, Nanaimo, Vancouver Island University, Canada.
19. UN-Habitat (2020), Sustainable Development Goal 11+ Make Cities and Human Settlements Inclusive, Safe, Resilient and Sustainable: A guide to assist national and local governments to monitor and report on SDG Goal 11+ indicators. https://www.local2030.org/library/60/SDG-Goal-11-Monitoring-Framework-A-guide-to-assist-national-and-local-governments-to-monitor-and-report-on-SDG-goal-11-indicators.pdf.
20. Wang, G. & Zhao, B. (2025), Research hotspots and trends in sustainable development goals, Environmental and Sustainability Indicators, 26, 100722. https://doi.org/10.1016/j.indic.2025.100722.
21. Yamasaki, K. & Yamada, T. (2022), A framework to assess the local implementation of Sustainable Development Goal 11, Sustainable Cities and Society, 86, 104091. https://doi.org/10.1016/j.scs.2022.104091.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Studia Universitatis Babeș-Bolyai Geographia
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
©Studia Universitatis Babeş-Bolyai Geographia. Published by Babeș-Bolyai University.