Open-source geospatial technologies for census data mapping and visualization: The Romanian 2021 census
DOI:
https://doi.org/10.55779/ng52348Keywords:
census, geospatial, open-data, open-source, Romania, visualizationAbstract
Romania conducted in 2022 the Population and Housing Census – with the 1st of December 2021 as reference date. Starting from 2023, the National Institute of Statistics (INS) began publishing the results. This contribution presents a methodological approach for transforming census parameters originally published as Excel tables into geospatial datasets. The process was carried out using open-source geospatial technologies. The datasets released by INS were analyzed, standardized, and then transformed into geospatial data using specific techniques, with results reported at both the county (NUTS 3) and Local Administrative Unit (LAU) levels. A key innovation of this study is the integration of the 1 km² population grid produced by EUROSTAT, to which we added 13 statistical parameters derived from the census data. The resulting datasets are stored in a PostgreSQL/PostGIS database and served through GeoServer, enabling the development of interactive web applications using MapStore. As part of this study, three interactive applications and two dynamic dashboards were created. The newly generated data is published under an open-source license, and can be viewed and analyzed online, accessed via standard web services, or downloaded for further use. By aligning the census results with the EUROSTAT 1 km² population grid, this article offers a new perspective on demographic data, allowing for in-depth analysis of population dynamics even at the level of cities and counties.
Metrics
References
Andrei T (2018). România un secol de istorie – date statistice [Romania one century of history – Statistics Data]. Editura Institutul National de Statistica, București, România.
Chen Y, Xu C, Ge Y, Zhang X, Zhou Y (2024). A 100 m gridded population dataset of China’s seventh census using ensemble learning and big geospatial data. Earth System Science Data 16:3705-3718. https://doi.org/10.5194/essd-16-3705-2024
Eurostat (2023a). Statistics explained population and housing census 2021 – population grids. Retrieved 2025 March 15 from https://ec.europa.eu/eurostat/statistics-explained/SEPDF/cache/114355.pdf
Eurostat (2023b). Statistics explained population grids. Retrieved 2025 March 15 from https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Population_grids#
GeoServer Documentation (2024). Retrieved 2024 October 1 from https://docs.geoserver.org/
GEOSTAT 1A (2012). Representing census data in a European population grid final report. Retrieved 2025 April 15 from https://www.efgs.info/wp-content/uploads/geostat/1a/GEOSTAT1A-final-report.pdf
Iftimoaei C (2022). Legislative, methodological and technical aspects of the population and housing census – 2021 round. Sustainable Economic and Social Development of Euroregions and Cross-Border Areas 42:237-253.
Iftimoaei C, Gabor V-R (2024). Regional demographic disparities reflected in the 2021 Census results. In: Resilience and sustainability in rural systems. Presa Universitară Clujeană pp 100-123. Retrieved 2025 March 1 from http://www.editura.ubbcluj.ro/bd/ebooks/pdf/3868.pdf
INS (2021). Institutul National de Statistica. Metodologia de recenzare și prelucrare a datelor – recensământul populației și locuințelor – runda 2021 [Census Data Collection and Processing Methodology – 2021 Population and Housing Census Round]. Retrieved 2024 October 1 from https://www.recensamantromania.ro/
INS (2023). Institutul National de Statistica. Romanian population and housing census data. Retrieved 2024 October 1 from https://www.recensamantromania.ro/
Laaboudi C, Karlberg M, Islam M (2024). Open data dissemination at Eurostat: State of the art. Statistical Journal of the IAOS 40(1):81-90. https://doi.org/10.3233/SJI-230115
Mapstore Documentation (2024). Retrieved 2024 October 1 from http://docs.mapstore.geosolutionsgroup.com/en/latest/developer-guide/
Mihăescu C, Oțoiu A, Gheorghe M, Velișcă NV (2021). Final research report – The history of Romania through the lens of population and housing censuses. https://www.recensamantromania.ro/
Muntele I, Horea-Șerban R-I (2024). Demographic dynamics and regional contrasts in Romania. Revue Roumaine de Géographie 68(2):137-153. https://doi.org/10.59277/RRG.2024.2.01
Muntele I, Istrate M, Athes H, Bănică A (2023). An overview of population dynamics in the Romanian Carpathians (1912-2021): Factors, spatial patterns and urban-rural disparities. Land 12(9):1756. https://doi.org/10.3390/land12091756
Paprotny D, Mengel M (2023). Population, land use and economic exposure estimates for Europe at 100 m resolution from 1870 to 2020. Scientific Data 10:372. https://doi.org/10.1038/s41597-023-02282-0
Pesaresi M, Schiavina M, Politis P, Freire S, Krasnodębska K, Uhl JH, ... Kemper T (2024). Advances on the Global Human Settlement Layer by joint assessment of Earth Observation and population survey data. International Journal of Digital Earth 17(1):2390454. https://doi.org/10.1080/17538947.2024.2390454
PostGIS Documentation (2024). Retrieved 2024 October 1 from https://postgis.net/documentation/
Python Documentation (2024). Retrieved 2024 October 1 from https://devguide.python.org/
QGIS.org (2024). QGIS 3.40. Geographic Information System User Guide. QGIS Association. Electronic document. Retrieved 2024 October 1 from https://docs.qgis.org/3.34/en/docs/user_manual/index.html
Reichardt M (2017). Open Geospatial Consortium standards. International Encyclopedia of Geography: People, the Earth, Environment and Technology 1-8. https://doi.org/10.1002/9781118786352.wbieg0348
Săgeată R, Dumitrică C, Baroiu D (2025). Depopulation and the development of peri-urban green areas of large cities: Lessons learned from Romania. Sustainability 17(7):2925. https://doi.org/10.3390/su17072925
Tache A-V, Popescu O-C, Petrișor A-I (2024). Planning blue–green infrastructure for facing climate change: The case study of Bucharest and its metropolitan area. Urban Science 8(4):250. https://doi.org/10.3390/urbansci8040250
Wang X, Meng X, Long Y (2022). Projecting 1 km-grid population distributions from 2020 to 2100 globally under shared socioeconomic pathways. Scientific Data 9:563. https://doi.org/10.1038/s41597-022-01675-x
Wilke A, Ngonga Ngomo AC (2023). LauNuts: A knowledge graph to identify and compare geographic regions in the European Union. In: Pesquita C et al. (Eds). The Semantic Web. ESWC 2023. Lecture Notes in Computer Science, Vol 13870. Springer, Cham. https://doi.org/10.1007/978-3-031-33455-9_24
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Andi M. LAZĂR, Florin IOSUB, Daniel URDĂ, Marius BUDILEANU
This work is licensed under a Creative Commons Attribution 4.0 International License.
Distribution - Permissions - Copyright
Papers published in Nova Geodesia are Open-Access, distributed under the terms and conditions of the Creative Commons Attribution License.
© Articles by the authors; licensee SMTCT, Cluj-Napoca, Romania. The journal allows the author(s) to hold the copyright/to retain publishing rights without restriction.
License:
Open Access Journal - the journal offers free, immediate, and unrestricted access to peer-reviewed research and scholarly work, due to SMTCT support to increase the visibility, accessibility, and reputation of the researchers, regardless of geography and their budgets. Users are allowed to read, download, copy, distribute, print, search, or link to the full texts of the articles, or use them for any other lawful purpose, without asking prior permission from the publisher or the author.
