SMT201 AY2019-20T1 EX1 Lee Jung Jae

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search

Part One

1.1 Distribution of public education institution by school types such as primary, secondary, etc.

Part 1-1.JPG

source: data.gov.sg

1.2 Hierarchy of road network system of Singapore such as expressway, major road, minor road, etc.

Part 1-2.jpg

To find out the different types of roads and what class each road belongs to, I searched online and used this link (https://remembersingapore.org/2018/08/15/singapore-street-suffixes/) to help me define which road belongs to which class and then managed to sort them out in the attribution field using filter selections and open field calculations. source: data.gov.sg

1.3 2014 Master Plan Landuse.

Part 1-3.jpg


source: data.gov.sg

Part two

Reasoning

The population csv file that I derived from singstat.gov.sg website was arranged in a very complex manner (divided into regions, genders, age). Thus I manually simplified the csv files into three separate files (Aged population 65+ in 2010, Aged population 65+ in 2018, and the last one showing the population percentage difference between 2010 and 2018 for aged 65+).

2-1 Aged population (+65) in 2010

Part 2-1.jpg


source: data.gov.sg , singstat.gov.sg

2-1.1 Aged population (+65) in 2018

Part 2-1.1.jpg


source: data.gov.sg , singstat.gov.sg

2-2 Proportional of aged population in 2010

Part 2-2.jpg


source: data.gov.sg , singstat.gov.sg

2-2 Proportional of aged population in 2018

Part 2-2.1.jpg


source: data.gov.sg , singstat.gov.sg

2-3 Percentage change of aged population between 2010 and 2018

Part 2-3.jpg


Percentage change = (Aged 65+ population 2018 - Aged 65+ population 2010)/ Aged 65+ population 2010

The limitation for this percentage calculation part was that some of the populations in 2010 were indicated as zero in my data. Thus the value becomes invalid as the denominator becomes zero.

source: data.gov.sg , singstat.gov.sg