The Task

Datasets

Download and use the following datasets to calculate a walkability index:

• street_network - contains street segments.
• eu_stat_clipped - contains population counts for a 1x1km grid (persons per km2).
• madrid_infrast - contains infrastructure points, including public transportation stops.

Outputs

Create a new GeoPackage file called madrid_walkable.gpkg containing street intersections as Point data. Calculate the following attributes:

• pop_km2 - the population count per square kilometre (at a given street intersection). Joined from the census grid.
• itx_num - the number of reachable street intersections (within 1km2 from a given street intersection). Use radial thresholds (circles rather than squares) for determining the 1km2 areas around each intersection.
• transport_num - the number of reachable transport stops (within 1km2 from a given street intersection). Use radial thresholds.
• is_walkable - whether a given street intersection meets all three walkability thresholds (true else false): at least 5,700 people/km2, at least 100 intersections/km2, and at least 28 transport stops/km2.