In 2021, while working as a Geospatial Analyst at UN-Habitat, I created a series of cartographic visualizations for the Moscow Voluntary Local Review on the progress towards the SDGs implementation. To show some of the visualizations, I made an interactive map in Foursquare Studio, a geospatial analysis tool based on kepler.gl.
To create these maps, statistical data were gathered from government agencies and open sources, analyzed and systematised in cohesive datasets corresponding to each SDG. Data harmonisation included cleaning and unifying varying file formats, measurement units and time periods. The harmonised data were then transformed into a spatial format using spatial join and geocoding operations.
Various mapping techniques were used to present the results of the geospatial analysis of 146 Moscow's districts:
- Choropleth maps
- Heatmaps
- Hexagon maps
SDG 1 - No Poverty:
- Recipients of utility subsidies, % of the district's population
SDG 3 - Good Health:
- Road accident fatalities density
- Open sportgrounds per 100,000 people
SDG 4 - Quality Education:
- Places in kindergartens per 1000 kids aged 1-6
SDG 11 - Sustainable Cities:
- Housing Affordability, years to save up for a 54 sq m flat
- Rental Affordability, % of monthly rent from salary
- Urbanized area, % of the built-up area from the total district's area
- Cultural Heritage Sites per district
- CCTV cameras density
- Street lights density
SDG 13 - Climate Action:
- Share of treecover in the total district area
- Moscow Integrated Data Warehouse (https://ehd.moscow)
- Moscow Open Data Portal (https://data.mos.ru)
- Road Accident Map (https://dtp-stat.ru)
- UN-Habitat (https://data.unhabitat.org)