Difference between revisions of "SMT201 AY2019-20T1 EX1 Lee Jung Jae"
Jump to navigation
Jump to search
Reasoning
| (2 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
[[File:Part_1-2.jpg|800px|center]] | [[File:Part_1-2.jpg|800px|center]] | ||
| − | ==== source: data.gov.sg ==== | + | ==== 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.=== | === 1.3 2014 Master Plan Landuse.=== | ||
| Line 24: | Line 21: | ||
== Part two == | == Part two == | ||
| + | |||
| + | === Reasoning <br> === | ||
| + | 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 === | === 2-1 Aged population (+65) in 2010 === | ||
| Line 60: | Line 60: | ||
| − | ==== source: data.gov.sg , singstat.gov.sg ==== | + | ==== 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==== | ||
Latest revision as of 08:20, 16 September 2019
Contents
- 1 Part One
- 2 Part two
- 2.1 Reasoning
- 2.2 2-1 Aged population (+65) in 2010
- 2.3 2-1.1 Aged population (+65) in 2018
- 2.4 2-2 Proportional of aged population in 2010
- 2.5 2-2 Proportional of aged population in 2018
- 2.6 2-3 Percentage change of aged population between 2010 and 2018
- 2.6.1 Percentage change = (Aged 65+ population 2018 - Aged 65+ population 2010)/ Aged 65+ population 2010
- 2.6.2 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.
- 2.6.3 source: data.gov.sg , singstat.gov.sg
Part One
1.1 Distribution of public education institution by school types such as primary, secondary, etc.
source: data.gov.sg
1.2 Hierarchy of road network system of Singapore such as expressway, major road, minor road, etc.
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.
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
source: data.gov.sg , singstat.gov.sg
2-1.1 Aged population (+65) in 2018
source: data.gov.sg , singstat.gov.sg
2-2 Proportional of aged population in 2010
source: data.gov.sg , singstat.gov.sg
2-2 Proportional of aged population in 2018
source: data.gov.sg , singstat.gov.sg
2-3 Percentage change of aged population between 2010 and 2018
