Percentage of residential addresses within walking distance of a cool place in South Holland, Overijssel, and Gelderland, the Netherlands.

In a geographic information system (GIS) study, a spatial join was conducted using QGIS to integrate three datasets: Afstand tot Koelte (ATK), CBS Buurten 2021, and BAG Verblijsobjecten (VO) across three provinces. The resulting output comprised a point dataset which included the ATK and buurten for each VO.It was observed that approximately 5% of the VOs lacked ATK data. Consequently, a field calculation was initiated to ascertain the direct distance, as the crow flies, to the nearest cool place ("koele plek"). A key distinction is that ATK data is based on walking distances along road networks, whereas direct distance measurements do not incorporate such networks. Comparative analysis revealed marginal differences between the two methods, with ATK data generally showing distances 50-100 meters greater.Subsequently, a selection process isolated the VOs categorized as residential ("woning,") which were then exported to an Excel format for further analysis. This was followed by the creation of a distinct list of neighborhoods ("buurten.") Utilizing the 'COUNTIFS' formula, a summation of distances per neighborhood was calculated, leading to the computation of their respective percentages. This methodology integrates spatial data analysis and quantitative techniques to understand geographic proximity and distribution.