Difference between revisions of "SMT201 AY2019-20G1 Ex1 Yiap Mei Lin Andrea"
Line 9: | Line 9: | ||
[[File:sgroadnetworksystem.jpg|thumb|centre]] | [[File:sgroadnetworksystem.jpg|thumb|centre]] | ||
− | I classified the roads by their symbol id, using this code | + | I classified the roads by their symbol id, using this code: |
− | CASE WHEN "SYMBOLID" = '2' | + | ==== CASE WHEN "SYMBOLID" = '2' |
THEN 'expressways' | THEN 'expressways' | ||
ELSE | ELSE | ||
Line 22: | Line 22: | ||
END | END | ||
END | END | ||
+ | ==== | ||
=== 2014 Master Plan Landuse === | === 2014 Master Plan Landuse === |
Revision as of 00:26, 16 September 2019
Part 1: Thematic Mapping
Distribution of Public Education Institution
In terms of visual representation, I used different sizes and colours to represent the various institutions. Therefore, at a glance we can see that there's only one centralised institution and both the primary and secondary schools are well spread out in all areas. Overall, there are lesser schools in the south compared to other parts of Singapore.
Hierarchy of Singapore's Road Network System
I classified the roads by their symbol id, using this code: ==== CASE WHEN "SYMBOLID" = '2'
THEN 'expressways' ELSE CASE WHEN "SYMBOLID" = '3' THEN 'minor roads' ELSE CASE WHEN "SYMBOLID" = '1' THEN 'expressways' ELSE 'major roads' END END END ====
2014 Master Plan Landuse
Part 2: Choropleth Mapping
Aged population (+65) in 2010 and 2018
2010 | 2018 |
---|---|
Proportional of aged population in 2010 and 2018
2010 | 2018 |
---|---|
Percentage change of aged population between 2010 and 2018
I filtered out the 2010 and 2018 data from the original data and saving it as a geopackage. From there, I filtered out the age 65 and above by using this code: "AG" LIKE '65%' OR "AG" LIKE '7%' OR "AG" LIKE '8%'. Afterwards, I joined it to the subzone layer to vizualise the aged population map. For the proportional maps, I tabulated the total subzone population then divide by the total aged population.