Difference between revisions of "SMT201 AY2019-20T1 EX1 Tu Yang Lin"

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search
 
(9 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
   
 
   
 
=== School Information ===  
 
=== School Information ===  
 +
[[File:SchoolInformation.jpg|thumb|center]]
 
With the data from data gov, I converted the csv file into shp file using geocode. Since schools are discrete information, I use the book symbol to display it on the map. Each school type is differentiated based on its colour.  
 
With the data from data gov, I converted the csv file into shp file using geocode. Since schools are discrete information, I use the book symbol to display it on the map. Each school type is differentiated based on its colour.  
 
 
 
=== Road Network System ===  
 
=== Road Network System ===  
 +
[[File:RoadSectionLine.jpg|thumb|center]]
 
Using the road section data, I classify them according to the types of road (expressway, major road, minor road). Each different type of road is differentiated based on its colour.   
 
Using the road section data, I classify them according to the types of road (expressway, major road, minor road). Each different type of road is differentiated based on its colour.   
 
 
 
=== Master Plan Land Use ===
 
=== Master Plan Land Use ===
 +
[[File:LandUse.jpg|thumb|center]]
 
The land use layer has different shades of blue representing the different use of the area. With the grey lines representing the road.  
 
The land use layer has different shades of blue representing the different use of the area. With the grey lines representing the road.  
 
 
Line 15: Line 18:
 
[[File:Age65(2010).jpg|thumb|center|age65]]
 
[[File:Age65(2010).jpg|thumb|center|age65]]
 
I retrieve the data from Singstat, I did some cleaning to the data before adding it into QGIS. Besides filtering the data and replacing values that are not readable with 0, I must sort the data accordingly so that it is easier to view and retrieve the data. Using planning subzone 2008 and age group 2010, I have come up with this choropleth map, showing the distribution of the aged population (age 65 and above) in 2010. After joining the two layers, I calculated the number of people aged 65 and above in the different subzone with the formula below:
 
I retrieve the data from Singstat, I did some cleaning to the data before adding it into QGIS. Besides filtering the data and replacing values that are not readable with 0, I must sort the data accordingly so that it is easier to view and retrieve the data. Using planning subzone 2008 and age group 2010, I have come up with this choropleth map, showing the distribution of the aged population (age 65 and above) in 2010. After joining the two layers, I calculated the number of people aged 65 and above in the different subzone with the formula below:
"AgeGroup2010_AGE65-69" + "AgeGroup2010_AGE70-74" + "AgeGroup2010_AGE75-79" + "AgeGroup2010_AGE80-84" + "AgeGroup2010_AGE85"
+
"AgeGroup2010_AGE65-69" + "AgeGroup2010_AGE70-74" + "AgeGroup2010_AGE75-79" + "AgeGroup2010_AGE80-84" + "AgeGroup2010_AGE85".
 
Using the new calculated field, I derived the classified class as shown in the image above. As the colour of the area gets darker it implies that there are more who are aged 65 and above. Some subzones are not found in the map as they are either places with no aged population or no one lived in that area.
 
Using the new calculated field, I derived the classified class as shown in the image above. As the colour of the area gets darker it implies that there are more who are aged 65 and above. Some subzones are not found in the map as they are either places with no aged population or no one lived in that area.
  
Line 23: Line 26:
  
 
=== Proportion of Aged Population in 2010 ===
 
=== Proportion of Aged Population in 2010 ===
 +
[[File:Proportion2010.jpg|thumb|center]]
 
The proportion of the aged population (age 65 and above) has been calculated by using the number of aged populations divided by the total population. The formula that I used is: "Age+65(2010)" / "AgeTotal2010". The darker the colour becomes, the higher the proportion of aged population is.  
 
The proportion of the aged population (age 65 and above) has been calculated by using the number of aged populations divided by the total population. The formula that I used is: "Age+65(2010)" / "AgeTotal2010". The darker the colour becomes, the higher the proportion of aged population is.  
 
 
 
=== Proportion of Aged Population in 2018 ===  
 
=== Proportion of Aged Population in 2018 ===  
 +
[[File:Proportion2018.jpg|thumb|center]]
 
Similar to the previous map, the calculation is derived from the formula: "Age+65(2018)" / "AgeTotal2018". The darker the shade of the yellow, the higher the proportion of people aged 65 and above is.
 
Similar to the previous map, the calculation is derived from the formula: "Age+65(2018)" / "AgeTotal2018". The darker the shade of the yellow, the higher the proportion of people aged 65 and above is.
  
=== Percentage change in Aged Population between 2010 and 2018 ===  
+
=== Percentage change in Aged Population between 2010 and 2018 ===
The formula of the percentage change is calculated by getting the difference between the two field that was derived from the proportion and multiplied by 100. The formula is: ("AgeProportion2018" - "MP08_SubzoneProportion2010_AgeProportion2010" ) * 100  
+
[[File:Percentagechange.jpg|thumb|center]]
 +
The formula of the percentage change is calculated by getting the difference between the two field that was derived from the proportion and multiplied by 100. The formula is: ("AgeProportion2018" - "MP08_SubzoneProportion2010_AgeProportion2010" ) * 100.
 
Subzone that are the darkest have a higher percentage change in the number of people aged 65 and above. While those subzones that are white in colour are those with negative or little percentage change.
 
Subzone that are the darkest have a higher percentage change in the number of people aged 65 and above. While those subzones that are white in colour are those with negative or little percentage change.

Latest revision as of 00:05, 30 October 2019

Part 1: Thematic Mapping

School Information

SchoolInformation.jpg

With the data from data gov, I converted the csv file into shp file using geocode. Since schools are discrete information, I use the book symbol to display it on the map. Each school type is differentiated based on its colour.  

Road Network System

RoadSectionLine.jpg

Using the road section data, I classify them according to the types of road (expressway, major road, minor road). Each different type of road is differentiated based on its colour.  

Master Plan Land Use

LandUse.jpg

The land use layer has different shades of blue representing the different use of the area. With the grey lines representing the road.  

Part 2: Choropleth Mapping

Aged Population (+65) in 2010

age65

I retrieve the data from Singstat, I did some cleaning to the data before adding it into QGIS. Besides filtering the data and replacing values that are not readable with 0, I must sort the data accordingly so that it is easier to view and retrieve the data. Using planning subzone 2008 and age group 2010, I have come up with this choropleth map, showing the distribution of the aged population (age 65 and above) in 2010. After joining the two layers, I calculated the number of people aged 65 and above in the different subzone with the formula below: "AgeGroup2010_AGE65-69" + "AgeGroup2010_AGE70-74" + "AgeGroup2010_AGE75-79" + "AgeGroup2010_AGE80-84" + "AgeGroup2010_AGE85". Using the new calculated field, I derived the classified class as shown in the image above. As the colour of the area gets darker it implies that there are more who are aged 65 and above. Some subzones are not found in the map as they are either places with no aged population or no one lived in that area.

Aged Population (+65) in 2018

Age65(2018).jpg

Similar to the previous map, this map is created from using planning subzone 2014 and age group 2018. As the blue colour becomes darker, it indicates that there are more people aged 65 and above living in that area. The formula for the calculation is: "AgeGroup2018_AGE65-69" + "AgeGroup2018_AGE70-74" + "AgeGroup2018_AGE75-79" + "AgeGroup2018_AGE80-84" + "AgeGroup2018_AGE85".

Proportion of Aged Population in 2010

Proportion2010.jpg

The proportion of the aged population (age 65 and above) has been calculated by using the number of aged populations divided by the total population. The formula that I used is: "Age+65(2010)" / "AgeTotal2010". The darker the colour becomes, the higher the proportion of aged population is.  

Proportion of Aged Population in 2018

Proportion2018.jpg

Similar to the previous map, the calculation is derived from the formula: "Age+65(2018)" / "AgeTotal2018". The darker the shade of the yellow, the higher the proportion of people aged 65 and above is.

Percentage change in Aged Population between 2010 and 2018

Percentagechange.jpg

The formula of the percentage change is calculated by getting the difference between the two field that was derived from the proportion and multiplied by 100. The formula is: ("AgeProportion2018" - "MP08_SubzoneProportion2010_AgeProportion2010" ) * 100. Subzone that are the darkest have a higher percentage change in the number of people aged 65 and above. While those subzones that are white in colour are those with negative or little percentage change.