Welcome to my Open Notebook

This is an Open Notebook with Selected Content - Delayed. All content is licenced with CC-BY. Find out more Here.

ONS-SCD.png

Aggregation Of Statistical Local Areas

Reproducibility

  • A subset of the data and code used for this blog post is available at https://github.com/ivanhanigan/aggregation-of-slas-or-sa2s
  • Some parts of the data I used are not available due to shared Intellectual Property
  • The spatial data and SEIFA Socioeconomic index data are publicly available from the Australian Bureau of Statistics
  • The New Groups categories were generously contributed by John Glover of the Public Health Information Development Unit, The University of Adelaide.

Introduction

The Aim is to aggregate Statistical Local Areas (SLAs, recently relabelled SA2) Australian Standard Geographical Classification (ASGC, recently relabelled ASGS) to achieve a greater level of privacy protection. The rules to achieve a geography amenable to statistical comparisons are:

  • similar populations (around 20,000 to 30,000)
  • homogenous Index of Relative Socioeconomic Disadvantage
  • nested within the next level up in the ASGC/ASGS
  • so that SSD (recently relabelled SA3) are not split.
  • the SA2s can be aggregated through a process of assigning alike areas to groups, and reviewing/adjusting these assignments
  • This document contains some suggestions for adjusting groupings to better reflect differences in the level of disadvantage, while still adhering to the rules outlined.

Results

Data Prep

  • The data were prepared as spatial files

alttext

Assess proposed split in Belconnen

  • the proposed split in belconnen looks good
  • This involves splitting Belconnen West (old SLA group) into two regions. The first generally has much higher proportion of individuals in a bottom quintile SES score
  • Group 1 = Belconnen/ Charnwood/ Florey/ Higgins/ Holt/ Latham
  • Group 2 = Flynn (ACT)/ Fraser/ Melba/ Spence

alttext

Assess the outliers

  • this can be done by identifying their component CCD SEIFA within new groups
  • the seifa of CCD in outliers are compared to the others within their new groups

alttext

  • zoom in on croweded areas

alttext

sa2_name.x new_sa2_group notes
12 Bruce Bruce/ Evatt/ Giralang/ Kaleen/ Lawson/ McKellar higher than neighbours
14 Campbell Acton/ Braddon/ Campbell/ Civic/ Reid/ Turner ok
20 Civic Acton/ Braddon/ Campbell/ Civic/ Reid/ Turner ok
31 Fadden Fadden/ Gowrie (ACT)/ Macarthur/ Monash ok
32 Farrer Farrer/ Isaacs/ Mawson/ Pearce/ Torrens higher than neighbours bar one ccd
37 Forrest Forrest/ Griffith (ACT)/ Kingston - Barton/ Narrabundah/ Red Hill (ACT) higher than neighbours
60 Isaacs Farrer/ Isaacs/ Mawson/ Pearce/ Torrens higher than neighbours bar one ccd
64 Kingston - Barton Forrest/ Griffith (ACT)/ Kingston - Barton/ Narrabundah/ Red Hill (ACT) higher than neighbours
71 Macarthur Fadden/ Gowrie (ACT)/ Macarthur/ Monash ok
73 Macquarie Aranda/ Cook/ Hawker/ Macquarie/ Page/ Scullin/ Weetangera ok
87 O'Malley Chifley/ Lyons (ACT)/ O'Malley/ Phillip higher than neighbours
89 Page Aranda/ Cook/ Hawker/ Macquarie/ Page/ Scullin/ Weetangera ok
98 Scullin Aranda/ Cook/ Hawker/ Macquarie/ Page/ Scullin/ Weetangera ok

Investigating areas: eg the Kingston - Barton area

  • we can zoom in on some of these areas

alttext

Conclusions

Basically, the problem comes from public housing policies in Canberra which distorts the effect of the housing market and land values in segregating rich from poor. Essentially, there are highly advantaged suburbs with pockets of disadvantaged public housing.

Other ‘problematic’ features re this are:

  • proximity to ornamental lakes
  • proximity to urban green space
  • proximity to rural residential hubs (walaroo road? hall?). This is a bit of a reverse statement – but different to ‘distance from urban centre’
  • elevation, especially with a view.

Potentially the issue is going to be that this can’t be solved if you want to maintain SA2 as the base level - the distinctions are going to be at an SA1 or even mesh block level.

Posted in  spatial


blog comments powered by Disqus