SMT201 AY2018-19T1 EX1 Lim Shi Xian Alvin

From Geospatial Analytics for Urban Planning
Jump to navigation Jump to search

Part 1: Thematic Mapping

Distribution of Public Education Institution by School Types

Distribution of Public Education Institutions by School Types

Source: General Information Of School [1]. Master Plan 2014 Subzone Boundary [2].

To properly depict the public education institution of Singapore, I used the mainlevel_ attribute column to categorise each unique point on the map. With the mainlevel_ column, I was able to uniquely identify each type of public institution, such as primary schools, secondary schools, junior colleges etcetera. I've used the inbuilt SVG markers in QGIS to better differentiate the markers instead of the default simple dots and used a grey background to accentuate the colours of the markers.


Road Network System Hierarchy of Singapore


Road Network System Hierarchy of Singapore


Source: Road Section Line [3]

I downloaded the shapefile from mytransport.sg and proceeded to import it into QGIS, and discovered that all the road names are mapped out inside the attribute table. As such, my approach was to follow URA handbook guidelines to classify them to their respective category. I used the following code to classify it:

 CASE
 WHEN "RD_CD_DESC" LIKE '%HIGHWAY%' THEN 'HIGHWAY'
 WHEN "RD_CD_DESC" LIKE '%EXPRESSWAY%' THEN 'HIGHWAY'
 WHEN "RD_CD_DESC" LIKE '%PARKWAY%' THEN 'HIGHWAY'
 WHEN "RD_CD_DESC" LIKE '%BOULEVARD%' THEN 'MAJOR ARTERIAL'
 WHEN "RD_CD_DESC" LIKE '%AVENUE%' THEN 'MAJOR ARTERIAL'
 WHEN "RD_CD_DESC" LIKE '%WAY%' THEN 'MAJOR ARTERIAL'
 WHEN "RD_CD_DESC" LIKE '%DRIVE%' THEN 'MINOR ARTERIAL'
 WHEN "RD_CD_DESC" LIKE '%ROAD%' THEN 'MINOR ARTERIAL'
 WHEN "RD_CD_DESC" LIKE '%STREET%' THEN 'MINOR ARTERIAL'
 ELSE 'LOCAL ACCESS'
 END

I did not include a case for Primary Access Road due to the fact that they share overlapping naming conventions with "Local Access". In terms of visual representation, the width of a road is representative of its class. Highways will be the thickest as it is the broadest in the real world, and vice-versa.


Part 2: Choropleth Mapping

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.