Techniques Used to Analyse the Affordability, Commutability and Demographics of Real Estate in School Catchment Areas Anthony Joseph My House Geek Chief Technology Officer YOW! Data 2019: 7 May 2019 linkedin.com/in/ blog.myhousegeek info@myhousegeek anthony-joseph .com.au .com.au
Acknowledgement of country We acknowledge the Traditional Owners of the country on which we meet today, the Gadigal people of the Eora nation , and recognise their continuing connection to land, waters and culture. We pay our respects to their Elders past, present and emerging. Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 2 Slide 2 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 3 Slide 3 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Catchment area introduction “T hat every child is entitled to enrol in a particular school based on his or her residential address. Every public school reserves enough places within their school for students in their local enrolment area.” (NSW Education Department) Priority Intake placement Area/Zones area (ACT) (NSW, TAS) School Priority School catchments Enrolment zones (SA) (NSW, QLD, WA) Area (NT) Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 4 Slide 4 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 5 Slide 5 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Case Studies Demographics Affordability Commutability 1. Catchment area Longitudinal Time to commute in a size analysis on catchment area 2. Students per property sales catchment area Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 6 Slide 6 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Data Sources Demographics Affordability Commutability Property Public sales data transport data School and Suburb data Openstreetmap catchments data road network NAPLAN data Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 7 Slide 7 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Technology Used Data analysis Microsoft Excel Geoprocessing ArcGIS Pro (Win) QGIS (MacOS) Python/Pycharm Vehicle Routing OpenTripPlanner Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 8 Slide 8 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Demographics analysis Catchment area size • Geoprocessing with geometries Students per catchment area • Spatial joins • Geoprocessing with attributes Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 9 Slide 9 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Catchment area size Catchment area size “The Surveyor General of NSW has also endorsed • Calculate geometry the use of a 'GDA Lambert' projection for • Shade catchments state-wide GIS and mapping applications.” by area Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 10 Slide 10 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 11 Slide 11 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Students per catchment area NSW Catchments Catchment area Data Students per catchment area NSW Schools Data Number of (number of students per students) school Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 12 Slide 12 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 13 Slide 13 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Affordability analysis Historical sales prices vs school results Longitudinal data analysis • Combining vector datasets • Statistical analysis with spatial datasets Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 14 Slide 14 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Analysis challenges School data Sales data • By catchments • By suburb Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 15 Slide 15 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Combining data sets Vector data Point data • Union • Intersection Image sources: • https://pro.arcgis.com/en/pro-app/tool-reference/analysis/union.htm • https://pro.arcgis.com/en/pro-app/tool-reference/analysis/intersect.htm • https://pro.arcgis.com/en/pro-app/tool-reference/spatial-statistics/h-whyhexagons.htm Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 16 Slide 16 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Darlington Primary School and suburbs Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 17 Slide 17 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Combining catchments and suburbs Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 18 Slide 18 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Combining catchments and suburbs Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 19 Slide 19 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Combining catchments and suburbs Name Proportion Newtown 15.0% Redfern 8.5% Eveleigh 24.3% Chippendale 27.2% Darlington 16.2% Haymarket 8.8% Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 20 Slide 20 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Sales data House sales Unit sales $1,800,000.00 $1,200,000.00 $1,600,000.00 $1,000,000.00 $1,400,000.00 $1,200,000.00 $800,000.00 Chippendale Chippendale Darlington Darlington $1,000,000.00 Eveleigh Eveleigh $600,000.00 Haymarket Haymarket $800,000.00 Newtown Newtown Redfern Redfern $600,000.00 $400,000.00 $400,000.00 $200,000.00 $200,000.00 $- $- 2010 2011 2012 2013 2014 2015 2016 2017 2018 2010 2011 2012 2013 2014 2015 2016 2017 2018 Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 21 Slide 21 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Affordability analysis 700 $1,200,000.00 600 $1,000,000.00 500 Proportionate house sales $800,000.00 Proportionate unit sales Year 3: Reading Sale price ($AU) NAPLAN Score 400 Year 3: Writing Year 3: Spelling $600,000.00 Year 3: Grammar Year 3: Numeracy 300 Year 5: Reading Year 5: Writing $400,000.00 Year 5: Spelling 200 Year 5: Grammar Year 5: Numeracy $200,000.00 100 0 $- 2010 2011 2012 2013 2014 2015 2016 2017 2018 Year Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 22 Slide 22 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Commutability analysis Time to commute in a school catchment • Isochrones • Intersections Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 23 Slide 23 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 24 Slide 24 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Isochrone definition How far can travel from a point for a particular time… Dependent on: • Transport mode • Time of day • Ground elevation • Walking speed • Budget… Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 25 Slide 25 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Darlington Primary School commutability Centre: Darlington Primary School Inputs: • Transport mode: walking/public transport • Time of day: 8am 29 April 2019 • Walking speed: 4km/hr Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 26 Slide 26 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Key learnings • Basic geoproessing • Spatial joins • Intersect/unions • Isochrones • Combining datasets • Beware of map projections • Automate the boring bits Techniques Used to Analyse the Affordability, Commutability Anthony Joseph – My House Geek Slide 27 Slide 27 and Demographics of Real Estate in School Catchment Areas YOW! Data 2019
Recommend
More recommend
