SMT201 AY2019-20T1 EX1 Heng Bing Chow

Part 1: Thematic Mapping

Distribution of public education institution by school types

First, I loaded the Coastal Outline and MP14 PLNG AREA NO SEA PL into QGIS, to serve as the base layer.

Next, I used MMQGIS > Geocode CSV with Web Service > General information of schools > Set Address as Address

Finally, Symbology > Categorized by mainlevel_ , Classify > then select SVG Marker Symbols.

I chose P for Primary, a Baby Symbol for Secondary, a Graduation Hat for Mixed Level, a ABC board for Junior College and a Stack of Books for
Centralised Institute.

Source: https://www.data.gov.sg/dataset/school-directory-and-information

Road Network System of Singapore

After Downloading the RoadSectionLine data from LTA DataMall,

Open Attribute Table > Toggle Editing > Create New Field, RD_TYPE

Next, Filter and Select all rows with Expressway, Update Road_Type field as 'EXPRESSWAY'

Do the same steps for all other road types e.g. Road, Drive, Way, Lane, Link etc

Once done, RoadSectionLine > Properties > Symbology > Categorized by RD_TYPE > Classify Lines in Green are for Expressway, Orange for Major Arterial, Blue for Minor Arterial, and Purple for Local Access.

Source: https://www.mytransport.sg/content/mytransport/home/dataMall/search_datasets.html?searchText=RoadSectionLine

https://www.ura.gov.sg/-/media/Corporate/Resources/Publications/Streets-and-Building-Names/SBNB_handbook_streets.pdf?la=en

2014 Master Plan Landuse

First, load G_MP14 LAND_USE_PL into QGIS.

Next, Properties > Symbology > Categorized by LU_DESC > Classify > Apply > OK

The layer will display different colours according to the different type of use. E.g. Red for Business, Green for Open Space etc.

Source: https://data.gov.sg/dataset/master-plan-2014-land-use?resource_id=0d1a6cda-7cad-4b17-b9a8-9e173afebbc1

Part 2: Choropleth Mapping

Aged population (+65) in 2010 and 2018

2010 Aged Population [[1]]

2018 Aged Population [[2]]

Uploaded screenshots to imgur due to uploading error on wiki

Create Layer Group called 2010 Age65+ > load MP14 SUBZONE NO SEA PL into group.

Next, open up Excel file of Population according to Planning Zones, Sex and Age, filter out 2010 entries, save as csv file. Create the column Age65+, Proportion. Populate newly created columns.

Next, QGIS > Add layer > Delimited text layer > CSV file > Join with Subzone Layer.

Finally, Subzone layer > Properties > Symbology > Graduated by Age65+ column.

Age65+ column is calculated by summing up age groups 65-69, 70-74, 75-79, 80-84 and 85 and above.

Repeat for 2018, but in the csv file, add in 2010 Proportion column so that you can populate a new column for % change.

Proportional of aged population in 2010 and 2018

In Layer Group 2010 Age65+, duplicate subzone layer.

Make sure to join back to same csv file.

Next, Subzone Layer > Properties > Symbology > Graduated by Proportion.

Proportion is calculated using the Age65+ column / Total population in Singapore.

Repeat for 2018.

Percentage change of aged population between 2010 and 2018

Load MP14 Subzone into project, join to 2018 csv file.

Subzone layer > Properties > Symbology > Graduated by % Change

The % Change column is calculated by 2018 Proportion of Aged Population – 2010 Proportion of Aged Population.

On the map, blue represents areas in Singapore with the highest decreasing change in Aged Population while red represents the highest increasing change.

Purple areas represent minimal changes in aged population.

Source: https://data.gov.sg/dataset/master-plan-2014-subzone-boundary-no-sea

https://www.singstat.gov.sg/find-data/search-by-theme/population/geographic-distribution/latest-data