SMT201 AY2019-20T1 EX1 Erika Aldisa Gunawan

From Geospatial Analytics for Urban Planning
Revision as of 04:36, 15 September 2019 by Erikaaldisa.2018 (talk | contribs)
Jump to navigation Jump to search

Part 1: Thematic Mapping

1. Using school information from data.gov.sg, prepare a thematic map showing the distribution of public education institution by school types

  • Public School.jpg

    Public Schools in Singapore

I used SVG Marker to differentiate the levels of public education institutions in Singapore to facilitate easier observation. I also try to not use too many SVG marker icon and have the same icon for Centralized Institute, Junior College and Mixed Level because I find it easier to look at. Strong colours of the icon in contrast to the light background also makes it easier to spot the schools.

2. Using road GIS data of LTA, prepare a thematic map showing the hierarchy of road network system of Singapore such as expressway, major road, minor road, etc.

  • Road Network of Singapore

The map above merges different vector layers of RoadSectionLine which I visualize as a simple line, Gantry as the red dot and Cycling Path as red hashed line, although it looks like a solid line from this scale.

3. Using master plan landuse GIS data from data.gov.sg, prepare a thematic map showing 2014 Master Plan Landuse

  • Landuse planning.jpg
  • Screenshot (8).jpg

The reason why I have 2 maps is because the original land use planning map (2nd picture) takes too long to render when I try to print layout, so I saved the file into a shapefile and simplified it into 8 pixels instead of 1 pixel. Please refer to the 2nd picture for the actual map. For similar attributes such as Business 1 and Business 2, I chose the same colour for similar attributes to get more insights from my map. From the map above, we can see businesses crowding the west area while residential areas cover the central and east area. You can also clearly see Tuas and Changi Airport as one colour on both ends of the map.


Part 2: Choropleth Mapping

1. Using planning subzone GIS data from data.gov.sg and Singapore residents by age group and gender, prepare the following choropleth maps:
* Aged population (+65) in 2010 and 2018.

  • 2010.jpg

    Aged Population (65+) in 2010

The map above shows that the Aged Population in 2010 is mainly concentrated on the east, highest in Bedok Area and some lower numbers in Bukit Batok and Bukit Timah Area. Populated areas are still accessible and a fair distance from the central area. I created a new column in the attribute table for Age 65+ by using expressions to add the relevant values. I use the newly calculated column for symbology.

  • 2018.jpg

    Aged Population (65+) in 2018

The map above shows that the Aged Population in 2018 is mainly concentrated on the east, highest still in Bedok Area. I use the newly added column of Age 65+ in the attribute table for symbology.



  • Proportional of aged population in 2010 and 2018.

  • Proportion of Aged Population (65+) in 2010

From the map above, we can see that a big part of central area, east area, north eastern area and western catchment area have approximately ~10%-20% aged population dwelling in those areas. I added the Age 65+ value and divide it with the total population of each subzone to get the percentage of aged population.

  • Proportion of Aged Population (65+) in 2018

From the 2018 data, one subzone area stands out with high percentage, so this makes the colours of the zone paler compared to map of proportion of aged population in 2010. Loyang west’s aged population is approximately 75% of its entire population. I added the Age 65+ value and divide it with the total population of each subzone to get the percentage of aged population.



  • Percentage change of aged population between 2010 and 2018.
  • PercentageChangebetween2010and2018.jpg

    Percentage change of aged population between 2010 and 2018

%Change = Difference of Aged Population between 2018 & 2010 / Aged Population of 2010
For 2010 Age 65+ data which is 0, %Change would be infinity so I used an IF condition whereby if 2010 Age 65+ is equal to 0, %Change would be difference divided by 1. However, if 2010 Age 65+ data is null, this would greatly exaggerate the difference hence the %Change, explaining the 716000%. The more prominent areas with significant change are Hougang area, Rivervale, Kovan, Anchorvale and Yuhua.

Retrieved from ‘https://wiki.smu.edu.sg/1920t1smt201/index.php?title=SMT201_AY2019-20T1_EX1_Erika_Aldisa_Gunawan&oldid=1045’