Objective

Obtain and process the necessary data to determine quality of life metrics and commute duration for each postal code in the target area.

Travel Duration Analysis

Calculated using:

  • Google Maps Distance Matrix API
  • Central point of each postal code
  • Work destination (EY office)
  • Specific time: 7:30am weekdays
  • Duration measured in seconds

Quality of Life Metrics

Key factors analyzed:

  • Access to water
  • Access to plumbed ablution
  • Median income

Data Collection Process

Challenges & Solutions

Unlike the UK, South Africa doesn't provide granular quality of life indices per postal code. This led to the development of a custom methodology using ward-level census data from 2011.

Data Sources

  • Census Data:

    Accessed through Stats SA's SuperWeb platform at ward level.View Data Source ↗

  • Postal Code Mapping:

    Web scraped from municipal website to map postal codes to ward data

Traditional vs. Custom Metrics

Traditional Metrics

  • Literacy rates
  • Infant mortality
  • Life expectancy

Selected Metrics

  • Water access
  • Plumbed ablution
  • Median income