|
|
| (15 intermediate revisions by the same user not shown) |
| Line 5: |
Line 5: |
| | ! Data !! QGIS Techniques | | ! Data !! QGIS Techniques |
| | |- | | |- |
| − | | data.gov - “School Directory and Information” || | + | | 1.data.gov - “School Directory and Information” || |
| | | | |
| − | New Layer: Schools created from csv file using Geocoding tool MMQGIS plugin. 'Address' attribute is used for openstreet map projection | + | 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<br> | | 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<br> |
| | <br> | | <br> |
| − | [File:Wyj Schoo layer.PNG|250px|center]]<br> | + | [[File:Wyj Schoo layer.PNG|250px|center]]<br> |
| | <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 I</span></span></p> | + | style='color:windowtext'>School types</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'>ROAD SELECTION LINE AND MAP LINE | + | style='color:windowtext'> |
| | </span></span></p> | | </span></span></p> |
| | | | |
| Line 29: |
Line 29: |
| | <br> | | <br> |
| | |- | | |- |
| − | | “Masterplan 2014 Landuse” dataset retrieved from data.gov.sg.|| Layer: Land Use | + | | 2.data.gov - “Masterplan 2014 Landuse” "National Map Line" |
| − | Symbology: Light Grey simple fill
| + | 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. |
| − | [[File:Fig2.png|250px|center]]<br> | + | |
| | + | [[File:WYJ Road Network.png|600px|center]]<br> |
| | <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 II</span></span></p> | + | style='color:windowtext'>Road Network</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'>SCALE VISIBILITY | + | style='color:windowtext'> |
| | </span></span></p> | | </span></span></p> |
| | <br><br> | | <br><br> |
| − | Visualisation Rule: The visibility of Land Use layer is automatically displayed as the user zooms in approximately 1-2 times.
| |
| | | | |
| − | |-
| |
| − | | SLA’s National Map Line retrieved from data.gov.sg. <br> Road Selection Line dataset retrieved from SLA provided by Prof Kam (HandsOnEx1). || Layer: Map Line & Road Network
| |
| − | <br>
| |
| − | Visualisation Rule:
| |
| − |
| |
| − | [[File:Fig3.png|250px|center]] <br>
| |
| − | <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 III</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'>ROAD SELECTION LINE AND MAP LINE
| |
| − | </span></span></p>
| |
| − | Processing: 2 datasets was used to represent different types of road. The national map line only provides expressway, major roads, international boundary and contour lines, the road selection data provides overall road network in Singapore. The Map Line layer highlights its road types using the categorisation rule, applying different colours and line width to emphasize type of road. The minor road can be implied by excluding road network that belongs to express way, intersections, and major roads.
| |
| | | | |
| | |- | | |- |
| − | | “MP14_SUBZONE_NO_SEA_PL” by URA retrieved from data.gov.sg.|| Layer: MP14_SUBZONE_NO_SEA_PL | + | | 3. data.gov - “MP14_SUBZONE_NO_SEA_PL” || Layer: MP14_SUBZONE_NO_SEA_PL |
| − | Symbology: Light Brown simple fill
| |
| | | | |
| − | Was included to provide a macro view base layer as an optional display. The layer represents subzones that could be useful in interpreting where road networks or school is located.
| + | Categorization technique is used to indicate the land used for different purpose. |
| − | | + | <brt |
| − | OpenStreetMap view could also be used, however the subzone layer better express the subzone boundaries through a simple display.
| + | [[File:Wyj Landuse.PNG|700px|center]] |
| − | | |
| − | |}
| |
| − | <br> | |
| − | [[File:Image.jpg|700px|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 IV</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'>OVERVIEW OF THEMATIC MAPPING</span></span></p>
| |
| − | <br>
| |
| − | Firstly, the thematic mapping shown in figure 5 represents the default view of the map. School data points, map line and road network are shown on top of the OpenStreetMap.
| |
| − | <br>
| |
| − | [[File:Img2.png|300px|center]]
| |
| | <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 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'>MICRO VIEW OF LAND USE VISIBILITY WITH ROAD NETWORKS AND SCHOOL DATA POINTS | + | style='color:windowtext'></span></span></p> |
| − | </span></span></p> | |
| − | | |
| − | <br>
| |
| − | The land use data was set with automatic scale visibility, the overall land use layer will only be clearly visible as the user zooms in for interpretation. The land use data provides a micro level data of the indicative polygon of each development land parcel. Thus, there’s no need for this layer to be displayed in a more macro view as lines will not be value-adding to visualisation interpretation.
| |
| | <br> | | <br> |
| | | | |
| − | Next, the national map line only provides expressway (blue line), major roads (magenta line), international boundary and contour lines (excluded), while the road selection data provides overall road network in Singapore. Thus, achieving an overview of all types of road can be done by overlapping the road networks to retrieve minor road (red line) through overlapping as shown in figure V.
| + | |} |
| − | <br>
| |
| | | | |
| − | [[File:Img3.png|700px|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 VI</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'>SUBZONE VIEW
| |
| − | </span></span></p>
| |
| − |
| |
| − | [[File:Img4.png|700px|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 VII</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'>OPENSTREETMAP VIEW
| |
| − | </span></span></p>
| |
| − |
| |
| − | <br>
| |
| − | The `MP14_SUBZONE_NO_SEA_PL` and OpenStreetMap layer (Figure VI & VII) were added as I believe that it might help in terms of data interpretation, eg: finding out where a junior college is located by subzones and its distance to major road where it's usually major road provides better transportation option/accessibility.
| |
| − | <br>
| |
| − | <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>
| |
| − |
| |
| − |
| |
| − | 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> | | </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`.
| |
| | | | |
| | |} | | |} |
| − |
| |
| − | ==== Data Interpretation ====
| |
| − | ===== Aged population (+65) in 2010 and 2018 =====
| |
| − |
| |
| − | [[File:|center|800px]]
| |
| − | <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 XXVI</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'>OVERVIEW MAP OF TOTAL AGED POPULATION IN 2010 BY PLANNING AREA
| |
| − | </span></span></p>
| |
| − |
| |
| − | The plotted map a
| |
| − |
| |
| − |
| |
| − | [[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 XXVII</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'>OVERVIEW MAP OF TOTAL AGED POPULATION IN 2018 BY PLANNING AREA
| |
| − | </span></span></p>
| |
| − |
| |
| − | As we \
| |
| − | -
| |
| − |
| |
| − | [[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 XXVIII</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'>OVERVIEW MAP OF TOTAL AGED POPULATION IN 2010 BY SUBZONE WITH LABEL
| |
| − | </span></span></p>
| |
| − |
| |
| − |
| |
| − | Figure
| |
| − |
| |
| − |
| |
| − | [[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 XXIX</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'>OVERVIEW MAP OF TOTAL AGED POPULATION IN 2010 BY SUBZONE WITHOUT LABEL
| |
| − | </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 XXX</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'>OVERVIEW MAP OF TOTAL AGED POPULATION IN 2018 BY SUBZONE WITHOUT LABEL THAT SHOWS INCREASE AGED POPULATION
| |
| − | </span></span></p>
| |
| − |
| |
| − |
| |
| − | Figure
| |
| − |
| |
| − |
| |
| − |
| |
| − | [[File:|center|300px]]
| |
| − | <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 XXXI</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'>LABELLING FOR TOTAL AGED POPULATION BY PLANNING AREA/SUBZONE
| |
| − | </span></span></p>
| |
| − |
| |
| − | Fie map.
| |
| − |
| |
| − | ===== Proportional of aged population in 2010 and 2018 =====
| |
| − |
| |
| − | [[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 XXXII</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'>OVERVIEW MAP OF THE AGED POPULATION PROPORTION IN 2010 BY SUBZONE
| |
| − | </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 XXXIII</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'>OVERVIEW MAP OF THE AGED POPULATION PROPORTION IN 2018 BY SUBZONE
| |
| − | </span></span></p>
| |
| − |
| |
| − |
| |
| − | We
| |
| − |
| |
| − |
| |
| − |
| |
| − | ===== Percentage change of aged population between 2010 and 2018 =====
| |
| − |
| |
| − | Percentage Change only include those that has non 0 value in year 2010. Thus if 2018 have value it still doesn’t count as the percentage change is not valid,
| |
| − |
| |
| − |
| |
| − |
| |
| − | [[File:|center|600px]]
| |
| − | <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 XXXIV</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'>OVERVIEW MAP OFPERCENTAGE CHANGE BETWEEN 2010 & 2018 BY SUBZONE WITH LABEL
| |
| − | </span></span></p>
| |
| − |
| |
| − |
| |
| − |
| |
| − | Figu
| |
| − |
| |
| − |
| |
| − | [[File:|center|600px]]
| |
| − | <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 XXXV</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'>OVERVIEW MAP OFPERCENTAGE CHANGE BETWEEN 2010 & 2018 BY SUBZONE WITHOUT LABEL
| |
| − | </span></span></p>
| |
| − |
| |
| − |
| |
| − |
| |
| − | ===== Exported Maps from Map Composer =====
| |
| − | [[File:Xg|center|800px]]
| |
| − | [[File:g|center|800px]]
| |
| − | [[File:pg|center|800px]]
| |
| − | [[File:X|center|800px]]
| |
| − | [[File:|center|800px]]
| |
| − | [[File:g|center|800px]]
| |
| − | [[File:g|center|800px]]
| |
| − |
| |
| − | ====bye===
| |
