Difference between revisions of "SMT201 AY2019-20T1 EX1 Zang Yu"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
 
(22 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
=== Distribution of public education institution by school types ===
 
=== Distribution of public education institution by school types ===
 
<br> [[File:Public education institution.png|800px|center]] <br>
 
<br> [[File:Public education institution.png|800px|center]] <br>
Since the nature of the data is discrete, I have categorised the school layer into 4 categories based on the school types and different svg symbols. MP14 planning area layer was used as the background reference map to show the distribution of public education institutions across Singapore.
+
Since the nature of the data is discrete, I have categorised the school layer into 4 categories based on the school types and different svg symbols. MP14 planning area layer was used as the background reference map to show the distribution of public education institutions across Singapore. Data on the locations of the schools shows that more schools are in the central areas.
  
 
=== Road network system of Singapore ===
 
=== Road network system of Singapore ===
Line 18: Line 18:
 
=== Aged population (+65) in 2010 ===
 
=== Aged population (+65) in 2010 ===
 
<br>  
 
<br>  
[[File:Aged population 2010.png|800px|center]] <br>
+
[[File:Aged_Pop_2010.png|800px|center]] <br>
  
For this choropleth map, I used datasets from Singstat and data.gov.sg. In order to do a relational join between population attribute layer and MP14_SubZone GIS layer, I need a unique identifier between these two datasets. Both datasets contain fields about the subzone name but they were different forms. The subzone name in population attribute layer was capitalized only the first letter but in MP14_SubZone GIS layer it is all in capital letters. Therefore, I converted the subzone names all to capital letters using UPPER() function in excel before I imported it into QGIS. I also filtered out the aged population in year 2010. Next, I used GroupStats plugin to sum up the aged population by subzone and created the relational join between the two layers. I have used equal interval classification method as it provides a clear picture of the subzones with more aged population.
+
In order to do a relational join between population attribute layer and MP14_SubZone GIS layer, I needed a unique identifier between these two datasets. Both datasets contain fields with similar subzone names in different forms. The subzone name in population attribute layer was in proper case format in comparison to MP14_SubZone GIS layer's uppercase format.Therefore, I converted it to uppercase as a standarisation. We filtered out the aged population in year 2010. GroupStats plugin was used to sum up the aged population by subzone allowing us to create a relational join between the two layers. We also used the equal interval classification method as it provides a clearer picture of the subzones with more aged population. Datasets from Singstat and data.gov.sg were used as reference.There were some subzones with NULL value in the number of aged population field which causes the subzone to not appear on the map. Therefore, I used the expression shown below to show the population column.
 +
 
 +
<br>
 +
[[File:Capture 10.png|300px|center]] <br>
  
 
=== Aged population (+65) in 2018 ===
 
=== Aged population (+65) in 2018 ===
 
<br> [[File:Aged population 2018.png|800px|center]] <br>
 
<br> [[File:Aged population 2018.png|800px|center]] <br>
 +
 +
Similar steps were used from the 2010 Aged Population map. Since there were no NULL value in the population count column no other expressions were required.
  
 
=== Proportional of aged population in 2010 ===
 
=== Proportional of aged population in 2010 ===
 
<br>  
 
<br>  
 
[[File:Proportion of aged population 2010.png|800px|center]]
 
[[File:Proportion of aged population 2010.png|800px|center]]
 +
<br>
 +
 +
In order to get the proportion of aged population in each subzone, the total population in each subzone in 2010 were filtered out from the whole population data. A new field was added into the MP14_SubZone attribute table to calculate the percentage of aged population out of the total population in 2010. Subzones with higher proportion of aged population are different as the subzones with the greater number of aged populations. This is because the proportion maps describe the share of aged population in relation to the whole population instead of the actual number of aged population count.
 +
 
<br>
 
<br>
  
Line 33: Line 42:
 
<br>  
 
<br>  
 
[[File:Proportion of aged population 2018.png|800px|center]]
 
[[File:Proportion of aged population 2018.png|800px|center]]
 +
<br>
 +
 +
Similar steps were used from the Proportion of aged population in 2010 map.
 +
 
<br>
 
<br>
  
 
=== Percentage change of aged population between 2010 and 2018 ===
 
=== Percentage change of aged population between 2010 and 2018 ===
 
<br>  
 
<br>  
[[File:Percentage change 2010-2018.png|800px|center]]
+
[[File:Percentage change 2010 -2018.png|800px|center]]
 +
<br>
 +
A new field was added to the attribute table to store the percentage change. Since some aged population field in 2010 were NULL so we exclude these subzones to ensure the map shows the correct information about the change in percentage. We used different colours to differentiate the positive and negative percentage change. Different colour intensity were used to represent the different percentage range. From this map, we can see the percentage change of aged population has increased in most of the subzones.
 
<br>
 
<br>
 +
 +
The percentage change between 2010 and 2018 is derived using following formula. We use CASE function to clean the data.
 +
 +
<br>[[File:Capture_13.png|300px|center]]<br>

Latest revision as of 22:00, 15 September 2019

Part 1: Thematic Mapping

Distribution of public education institution by school types


Public education institution.png


Since the nature of the data is discrete, I have categorised the school layer into 4 categories based on the school types and different svg symbols. MP14 planning area layer was used as the background reference map to show the distribution of public education institutions across Singapore. Data on the locations of the schools shows that more schools are in the central areas.

Road network system of Singapore


Road network system.png


Based on the data from road section layer, we are unable distinguish major and minor roads. Therefore, I combined the road section layer with the national map line layer to gain new information about expressways and major roads. The remaining classified as minor roads. Lines with different colours and thickness were used to represent the different roads.

2014 Master Plan Landuse


2014 Master Plan Landuse.png


In the original data, there were too many types of uses for land which made the map difficult for visualisation. Categories with similar functions were merged to form a more general classification. For example, Educational Institution, Place of Worship and Civic & Community Institution are now grouped under one category named Civic & Community Institution. Different colours were then used to represent each type of landuse.

Part 2: Choropleth Mapping

Aged population (+65) in 2010


Aged Pop 2010.png


In order to do a relational join between population attribute layer and MP14_SubZone GIS layer, I needed a unique identifier between these two datasets. Both datasets contain fields with similar subzone names in different forms. The subzone name in population attribute layer was in proper case format in comparison to MP14_SubZone GIS layer's uppercase format.Therefore, I converted it to uppercase as a standarisation. We filtered out the aged population in year 2010. GroupStats plugin was used to sum up the aged population by subzone allowing us to create a relational join between the two layers. We also used the equal interval classification method as it provides a clearer picture of the subzones with more aged population. Datasets from Singstat and data.gov.sg were used as reference.There were some subzones with NULL value in the number of aged population field which causes the subzone to not appear on the map. Therefore, I used the expression shown below to show the population column.


Capture 10.png


Aged population (+65) in 2018


Aged population 2018.png


Similar steps were used from the 2010 Aged Population map. Since there were no NULL value in the population count column no other expressions were required.

Proportional of aged population in 2010


Proportion of aged population 2010.png


In order to get the proportion of aged population in each subzone, the total population in each subzone in 2010 were filtered out from the whole population data. A new field was added into the MP14_SubZone attribute table to calculate the percentage of aged population out of the total population in 2010. Subzones with higher proportion of aged population are different as the subzones with the greater number of aged populations. This is because the proportion maps describe the share of aged population in relation to the whole population instead of the actual number of aged population count.


Proportional of aged population in 2018


Proportion of aged population 2018.png


Similar steps were used from the Proportion of aged population in 2010 map.


Percentage change of aged population between 2010 and 2018


Percentage change 2010 -2018.png


A new field was added to the attribute table to store the percentage change. Since some aged population field in 2010 were NULL so we exclude these subzones to ensure the map shows the correct information about the change in percentage. We used different colours to differentiate the positive and negative percentage change. Different colour intensity were used to represent the different percentage range. From this map, we can see the percentage change of aged population has increased in most of the subzones.

The percentage change between 2010 and 2018 is derived using following formula. We use CASE function to clean the data.


Capture 13.png