Difference between revisions of "SMT201 AY2018-19T1 EX1 Lim Shi Xian Alvin"
Line 7: | Line 7: | ||
Source: General Information Of School [https://www.data.gov.sg/dataset/school-directory-and-information]. Master Plan 2014 Subzone Boundary [https://data.gov.sg/dataset/master-plan-2014-subzone-boundary-no-sea]. | Source: General Information Of School [https://www.data.gov.sg/dataset/school-directory-and-information]. Master Plan 2014 Subzone Boundary [https://data.gov.sg/dataset/master-plan-2014-subzone-boundary-no-sea]. | ||
− | 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. | + | 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. | + | 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. |
Line 23: | Line 23: | ||
---- | ---- | ||
− | CASE | + | CASE |
WHEN "RD_CD_DESC" LIKE '%HIGHWAY%' THEN 'HIGHWAY' | WHEN "RD_CD_DESC" LIKE '%HIGHWAY%' THEN 'HIGHWAY' | ||
WHEN "RD_CD_DESC" LIKE '%EXPRESSWAY%' THEN 'HIGHWAY' | WHEN "RD_CD_DESC" LIKE '%EXPRESSWAY%' THEN 'HIGHWAY' | ||
Line 34: | Line 34: | ||
WHEN "RD_CD_DESC" LIKE '%STREET%' THEN 'MINOR ARTERIAL' | WHEN "RD_CD_DESC" LIKE '%STREET%' THEN 'MINOR ARTERIAL' | ||
ELSE 'LOCAL ACCESS' | ELSE 'LOCAL ACCESS' | ||
− | END | + | END |
---- | ---- |
Revision as of 21:03, 15 September 2019
Part 1: Thematic Mapping
Distribution of Public Education Institution 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
Source: Road Section Line [3]
I first imported the shapefile 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
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.