Pedal-Powered Health

About

This dashboard aims to compare localized health values with various cycling scores at a Medium Super Output Area Level (MSOA) for UK Cities.

Select any MSOA polygon to get a breakdown of its specific scores. Also use the two left drop down menus for different scores and cities.

The cycling scores are obtained from UK Census Data, The Department for Transportation database and OpenStreetMap.

For the health data, this uses prescription data obtained by the MedSat dataset.

All scores given are in Z Scores. A Z-score tells you how far a value is from the mean in units of standard deviations.

• 0 → exactly at the mean
• +1 z → One Standard Deviation above the mean
• -1 z → One Standard Deviation below the mean

When selecting an MSOA polygon, you will also be provided with the street level Cycling Quality Index (CQI) Scores, calculated from: https://www.osm-verkehrswende.org/cqi/

If the score overlay CQI Space Syntax is selected, the streets will show their CQI scores with the Space Syntax algorithms applied to them.

At the bottom of the page will be a description of what the score selected means.

Generally the goal of the colours is BLUE is GOOD and RED is BAD.

To see the scores overlay with a single colour palette, add the /?colour URL parameter.

To see more scores, add the /?dev URL parameter.

?colour&dev would enable both of these.

Score Descriptions

All scores are displayed in Z-Scores, 0 is the Mean, +1 is one standard deviation above the mean.

Commuter Rate

The percentage of people who reported commuting to work by bicycle in the UK 2021 Census for that MSOA

Crash Rate

The total number of cycling incidents reported by Department of Transport of any severity in that MSOA in 2021

Mean CQI Scores

The average Cycling Quality Index (CQI) score for each MSOA is calculated based on the scores of individual streets (or "ways") within the MSOA, using the methodology provided by osm-verkehrswende.org, with the overall score being the average street CQI score.

When selecting an MSOA, with the Mean CQI Scores drop down selected, the roads will show their individual CQI scores, with the bottom left index showing what colour the score corresponds with, 0 being the worst and 10 the best

CQI Space Syntax

The score for each MSOA is calculated using the Space Syntax methodology, which incorporates edge harmonic and betweenness centrality measures, in addition with the already calculated Cycling Quality Index (CQI) score. These values are then also weighted by the length of each road segment and averaged to produce a final infrastructure score for the MSOA.

When selecting an MSOA, with the CQI Space Syntax overlay drop down selected, the space syntax weighthings can be viewed, with stronger hue showing a higher score (likely from both a good CQI score and good centrality score)

Overall Score

A combination of the CQI Space Index Score + The Commute Rate Score + the Crash Rate Score

Commute Path

Using UK Census 2021 Origin-Destination travel data, the most common commuting destination is identified for each MSOA, regardless of mode of transport. A straight-line path is then drawn from the origin MSOA to its corresponding destination MSOA, and each MSOA intersected by this path is identified. For this route, the average values of three key metrics CQI Space Syntax, Commute Rate, and Crash Rate are calculated across all MSOAs traversed by the line. This composite score provides a route-based view of the cycling conditions a cycling commuter would face for each MSOA

Heath Scores

Each health score for a MSOA (diabetes, anxiety, hypertension, opioids, depression, asthma) is derived using the MedSat dataset, where the score reflects the number of people within an MSOA taking medications that are associated with that condition. The total score is the total prescription rate for that MSOA.