Difference between revisions of "SMT201 AY2019-20T1 EX1 Wang Youjin"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
 
(10 intermediate revisions by the same user not shown)
Line 34: Line 34:
 
Layer Imported: Land Use, Road Selection Line, National Map Line
 
Layer Imported: Land Use, Road Selection Line, National Map Line
  
Different color lines and width are used to represent different types of road with cateogirized technique performed on the map line layer use
+
Different color lines and width are used to represent different types of road with cateogirized technique performed on the map line layer use.Road_Type was created as the new column to assign category to each road based on its type.
  
 
[[File:WYJ Road Network.png|600px|center]]<br>
 
[[File:WYJ Road Network.png|600px|center]]<br>
Line 58: Line 58:
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>FIGURE IV</span></span></p>
+
   style='color:windowtext'>Land Use</span></span></p>
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>OVERVIEW OF THEMATIC MAPPING</span></span></p>
+
   style='color:windowtext'></span></span></p>
 
<br>
 
<br>
  
 +
|}
  
 
== Part 2: Choropleth Mapping ==
 
== Part 2: Choropleth Mapping ==
[[File:|center]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE VIII</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>LAYERS EXPORTED
 
</span></span></p>
 
  
The choropleth mapping developed uses these following data and applied techniques:
+
Below explain how the choropleth maps are developed and some elaboration.
  
==== Sources and Methods ====
 
  
 
{| class="wikitable"
 
{| class="wikitable"
 
|-
 
|-
! Dataset !! Visualisation & Processing Technique
+
! Data !! QGIS Techniques
 
|-
 
|-
 
| “Singapore Residents by Planning Area/Subzone, Age Group and Sex, June 2000 - 2018” from Department of Statistics Singapore.
 
| “Singapore Residents by Planning Area/Subzone, Age Group and Sex, June 2000 - 2018” from Department of Statistics Singapore.
 
||  
 
||  
Layer: respopagsex2000to2018_unfiltered
+
Layer: respopagsex2000to2018_
 +
Processing:
  
Processing:
+
1.Singapore's Aged Population (65+) in 2010
1.
 
 
   
 
   
[[File: |center|600px]]
+
created new filtered layer with age 65+ and year = 2010. New column is created and caculated as the sum of the 65+ population for 2010.
 +
Join technique is used in the MP14 layer to join the Area Name.
 +
 
 +
[[File:Wyj 2010 65+.PNG|center|600px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>FIGURE IX</span></span></p>
+
   style='color:windowtext'>2010 65+ Map</span></span></p>
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>FILTERING AGED POPULATION
+
   style='color:windowtext'>
 
</span></span></p>
 
</span></span></p>
  
2. .
+
2.Singapore's Aged Population (65+) in 2018
 
   
 
   
 +
created new filtered layer with age 65+ and year = 2018. New column is created and caculated as the sum of the 65+ population for 2018.
 +
Join technique is used in the new MP14 layer to join the Area Name.
  
[[File:|center|500px]]
+
[[File:Wyj 2018 65.PNG|center|500px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>FIGURE X</span></span></p>
+
   style='color:windowtext'>2018 65+ Map</span></span></p>
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>AGGREGATING DATA USING GROUPSTATS
+
   style='color:windowtext'>
 
</span></span></p>
 
</span></span></p>
  
 
[[File:|center|400px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XI</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>IMPORTING GROUPSTATS GENERATED CSV USING CUSTOM DELIMITER
 
</span></span></p>
 
s:
 
a. `is.
 
b. ones.
 
 
[[File:|center|400px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XII</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>DATA OVERVIEW OF IMPORTED GROUPSTATS DATA
 
</span></span></p>
 
  
 +
3.Proportion of Singapore's Aged Population in 2010
  
+
We are looking at the ratio of population that is above 65 and the total residence number
[[File:|center|400px]]
+
The observation is that the 1)downtown area has a higher proportion of aged population. 2)North region also has high proportion of senior polulaiton.  
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XIII</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>DATA OVERVIEW OF IMPORTED GROUPSTATS DATA
 
</span></span></p>
 
  
4. Led.
+
[[File:Wyj 2010 proportion.png|center|400px]]
5. We
 
 
[[File:|center|400px]]
 
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>FIGURE XIV</span></span></p>
+
   style='color:windowtext'>Proportion of Aged population of 2018</span></span></p>
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>PROPORTION FIELD CREATION
+
   style='color:windowtext'>
 
</span></span></p>
 
</span></span></p>
  
 +
4.Proportion of Singapore's Aged Population in 2018
  
 +
When we look at 2010 and 2018 map in terms of the aged population ratio that has been explained earlier. we can see that the 2018 statistics is more well spread as seen by the dark color block compared to that of 2010. This might be an indication of the aging population.
  
a.
+
[[File:Wyj 2018 proportion.png|center|400px]]
[[File:|center|300px]]
 
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>FIGURE XV</span></span></p>
+
   style='color:windowtext'>Proportion of Aged population of 2018</span></span></p>
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>DERIVING PERCENTAGE CHANGE
+
   style='color:windowtext'>
 
</span></span></p>
 
</span></span></p>
 
6. L
 
 
 
 
 
  
  
  
 
|-
 
|-
| Singapore Master Plan 2014 Subzone and Planning Area 2014 boundary data retrieved from data.gov
+
| Percentage Change of Aged Population From 2010 to 2018
 
||  
 
||  
  
  
  
1. `SumAgedPopulation2010_PA` layer joined with `sum_aged_pop_2010_pa` by matching attribute `PLN_AREA_N` and `Zone_ID_PA`.
+
The prominent difference is the increase in the ratio of aged population in the North region especially with the color block indication.  
a. Symbology (Natural Jenks):
 
  
[[File:|center|400px]]
+
[[File:Wyj Difference.png|center|400px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>FIGURE XVI</span></span></p>
+
   style='color:windowtext'>& Change from 2010 to 2018 map</span></span></p>
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
   mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
   style='color:windowtext'>CATEGORISATION OF PLANNING AREA SUM AGED POPULATION DATA
+
   style='color:windowtext'>
 
</span></span></p>
 
</span></span></p>
  
  
 
 
2. `SumAgedPopulation2018_PA` layer joined with `sum_aged_pop_2018_pa` by matching attribute `PLN_AREA_N` and `Zone_ID_PA`.
 
a. Symbology (Natural Jenks):
 
 
[[File:|center|400px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XVII</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>CATEGORISATION OF PLANNING AREA SUM AGED POPULATION DATA
 
 
</span></span></p>
 
</span></span></p>
  
  
3. `SumAgedPopulation2010_SZ` layer joined with `sum_aged_pop_2010_sz` by matching attribute `SUBZONE_N` and `Zone_ID_SZ`.
 
a. Symbology (Natural Jenks):
 
 
[[File:|center|400px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XVIII</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>CATEGORISATION OF SUBZONE SUM AGED POPULATION DATA
 
</span></span></p>
 
 
4. `SumAgedPopulation2018_SZ`layer joined with `sum_aged_pop_2018_sz` by matching attribute `SUBZONE_N` and `Zone_ID_SZ`.
 
a. Symbology (Natural Jenks):
 
 
[[File:|center|400px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XIX</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>CATEGORISATION OF SUBZONE SUM AGED POPULATION DATA
 
</span></span></p>
 
 
5. `ProportionAgedPopulation2010_SZ` layer joined with `propotion_aged_pop_2010` by matching attribute `SUBZONE_N` and `Zone_ID_SZ`.
 
a. Symbology (Natural Jenks):
 
 
 
[[File:|center|400px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XX</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>CATEGORISATION OF SUBZONE PROPORTION AGED POP DATA
 
</span></span></p>
 
 
6. `ProportionAgedPopulation2018_SZ` layer joined with `propotion_aged_pop_2018` by matching attribute `SUBZONE_N` and `Zone_ID_SZ`.
 
a. Symbology (Natural Jenks):
 
 
[[File:|center|400px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XXI</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>CATEGORISATION OF SUBZONE PROPORTION AGED POP DATA
 
</span></span></p>
 
 
7. `Percentage_Change_SZ` layer joined with `2010_2018_percentage_change` by matching attribute `SUBZONE_N` and `Zone_ID_SZ`.
 
a. Symbology: Below is the configuration used for percentage change of aged population. The legend classification intervals were split into 2 ways, negative changes which represents a decrease change were categorised using an equal distribution from the minimum decrease value of -100% to 0. Next, Natural Breaks (Jenks) were used to classify the 5 next categories for the positive values to indicate. Due to its high variance value, the Jenks classification represents best for this case. Additionally, 2 distinct colours (red and blue) were used to appropriately display the nature of percentage change of the aged population from 2010 to 2018.
 
[[File:|center|500px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XXII</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>CATEGORISATION OF SUBZONE PERCENTAGE CHANGE DATA
 
</span></span></p>
 
 
[[File:|center|500px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XXIII</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>3 BASE COLOR PICK FOR SUBZONE PERCENTAGE CHANGE DATA
 
</span></span></p>
 
 
 
[[File:|center|400px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XXIV</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>DATA LABELLING
 
</span></span></p>
 
 
For
 
 
 
[[File:|center|200px]]
 
<p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>FIGURE XXV</span></span></p>
 
  <p class=MsoNormal align=center style='text-align:center;line-height:normal'><span
 
  lang=EN-GB style='font-size:8.0pt;font-family:"Times New Roman",serif;
 
  mso-fareast-font-family:"Times New Roman";font-variant:small-caps;color:white'><span
 
  style='color:windowtext'>CATEGORISATION OF SUBZONE PERCENTAGE CHANGE DATA
 
</span></span></p>
 
  
  
Enabling each layer’s label can be done via `Layer Properties`.
 
  
 
|}
 
|}

Latest revision as of 23:56, 15 September 2019

Part 1: Thematic Mapping

Explain how the mapping were developed with elaboration:

Data QGIS Techniques
1.data.gov - “School Directory and Information”

New Layer created: Schools created from csv file using Geocoding tool MMQGIS plugin. 'Address' attribute is used for openstreet map projection

Distribution of school types: Under Symbology, select categoriszation by `mainlevel_` attribute.Different colors are used to indication different school types for easy illustrative reference purpose

Wyj Schoo layer.PNG

School types


Data not found CSV from geocoding:
- RAFFLES INSTITUTION
- BOWEN SECONDARY SCHOOL

2.data.gov - “Masterplan 2014 Landuse” "National Map Line"

SLA - "Road Selection Line"

Layer Imported: Land Use, Road Selection Line, National Map Line

Different color lines and width are used to represent different types of road with cateogirized technique performed on the map line layer use.Road_Type was created as the new column to assign category to each road based on its type.

WYJ Road Network.png

Road Network




3. data.gov - “MP14_SUBZONE_NO_SEA_PL” Layer: MP14_SUBZONE_NO_SEA_PL

Categorization technique is used to indicate the land used for different purpose. <brt

Wyj Landuse.PNG

Land Use


Part 2: Choropleth Mapping

Below explain how the choropleth maps are developed and some elaboration.


Data QGIS Techniques
“Singapore Residents by Planning Area/Subzone, Age Group and Sex, June 2000 - 2018” from Department of Statistics Singapore.

Layer: respopagsex2000to2018_ Processing:

1.Singapore's Aged Population (65+) in 2010

created new filtered layer with age 65+ and year = 2010. New column is created and caculated as the sum of the 65+ population for 2010. Join technique is used in the MP14 layer to join the Area Name.

Wyj 2010 65+.PNG

2010 65+ Map

2.Singapore's Aged Population (65+) in 2018

created new filtered layer with age 65+ and year = 2018. New column is created and caculated as the sum of the 65+ population for 2018. Join technique is used in the new MP14 layer to join the Area Name.

Wyj 2018 65.PNG

2018 65+ Map


3.Proportion of Singapore's Aged Population in 2010

We are looking at the ratio of population that is above 65 and the total residence number The observation is that the 1)downtown area has a higher proportion of aged population. 2)North region also has high proportion of senior polulaiton.

Wyj 2010 proportion.png

Proportion of Aged population of 2018

4.Proportion of Singapore's Aged Population in 2018

When we look at 2010 and 2018 map in terms of the aged population ratio that has been explained earlier. we can see that the 2018 statistics is more well spread as seen by the dark color block compared to that of 2010. This might be an indication of the aging population.

Wyj 2018 proportion.png

Proportion of Aged population of 2018


Percentage Change of Aged Population From 2010 to 2018


The prominent difference is the increase in the ratio of aged population in the North region especially with the color block indication.

Wyj Difference.png

& Change from 2010 to 2018 map