{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## How to plot a map\n", "\n", "In this last notebook, we'll finally plot our colour-coded map of Singapore, with each road colour representing a different linguistic origin. But first, we need to merge a few files so that our original GeoJSON file that has all the linestring information is augmented with linguistic origin information." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Merging files with (Geo)Pandas" ] }, { "cell_type": "code", "execution_count": 27, "metadata": { "collapsed": false }, "outputs": [], "source": [ "%matplotlib inline\n", "\n", "import geopandas as gpd" ] }, { "cell_type": "code", "execution_count": 28, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | geometry | \n", "highway | \n", "name | \n", "
---|---|---|---|
0 | \n", "LINESTRING (103.8284048 1.3068666, 103.8287382... | \n", "primary | \n", "Orchard Road | \n", "
1 | \n", "LINESTRING (103.8858462 1.3517778, 103.8859356... | \n", "residential | \n", "Hougang Avenue 1 | \n", "
2 | \n", "LINESTRING (103.8387571 1.3126764, 103.83872 1... | \n", "primary | \n", "Scotts Road | \n", "
3 | \n", "LINESTRING (103.8395387 1.3132203, 103.8396493... | \n", "tertiary | \n", "Keng Lee Road | \n", "
4 | \n", "LINESTRING (103.8392505 1.3134495, 103.8394598... | \n", "primary | \n", "Newton Road | \n", "
5 | \n", "LINESTRING (103.8373031 1.3147037, 103.8359738... | \n", "residential | \n", "Sarkies Road | \n", "
6 | \n", "LINESTRING (103.8318305 1.3050277, 103.8315539... | \n", "primary | \n", "Patterson Road | \n", "
7 | \n", "LINESTRING (103.8348293 1.3004045, 103.8342528... | \n", "secondary | \n", "Orchard Boulevard | \n", "
8 | \n", "LINESTRING (103.8348293 1.3004045, 103.8346883... | \n", "secondary | \n", "Grange Road | \n", "
9 | \n", "LINESTRING (103.830813 1.3039006, 103.8302888 ... | \n", "primary | \n", "Paterson Hill | \n", "
10 | \n", "LINESTRING (103.8313547 1.2960058, 103.83227 1... | \n", "primary | \n", "River Valley Road | \n", "
11 | \n", "LINESTRING (103.842836 1.291596, 103.8422129 1... | \n", "residential | \n", "Unity Street | \n", "
12 | \n", "LINESTRING (103.8430392 1.2934171, 103.842244 ... | \n", "residential | \n", "Merbau Road | \n", "
13 | \n", "LINESTRING (103.8387207 1.2909753, 103.8388778... | \n", "residential | \n", "Mohamed Sultan Road | \n", "
14 | \n", "LINESTRING (103.8387207 1.2909753, 103.8386978... | \n", "residential | \n", "Saiboo Street | \n", "
15 | \n", "LINESTRING (103.843357 1.2895812, 103.8436285 ... | \n", "residential | \n", "Merchant Loop | \n", "
16 | \n", "LINESTRING (103.8412716 1.2886074, 103.8414779... | \n", "primary | \n", "Clemenceau Avenue | \n", "
17 | \n", "LINESTRING (103.8420526 1.2900233, 103.8421061... | \n", "secondary | \n", "Merchant Road | \n", "
18 | \n", "LINESTRING (103.8447163 1.2885069, 103.8448984... | \n", "residential | \n", "Read Cresent | \n", "
19 | \n", "LINESTRING (103.8513753 1.3967862, 103.8518491... | \n", "motorway | \n", "Tampines Expressway | \n", "
20 | \n", "LINESTRING (103.8579655 1.3941346, 103.8580422... | \n", "motorway | \n", "Seletar Expressway | \n", "
21 | \n", "LINESTRING (103.8443907 1.3109684, 103.8445533... | \n", "motorway | \n", "Central Expressway | \n", "
22 | \n", "LINESTRING (103.8021677 1.2727921, 103.8022844... | \n", "primary | \n", "Telok Blangah Road | \n", "
23 | \n", "LINESTRING (103.6372541 1.3480363, 103.6373882... | \n", "motorway | \n", "Ayer Rajah Expressway | \n", "
24 | \n", "LINESTRING (103.8341079 1.2723657, 103.8361228... | \n", "motorway | \n", "Ayer Rajah Expressway | \n", "
25 | \n", "LINESTRING (103.8541001 1.3977878, 103.8545108... | \n", "motorway | \n", "Seletar Expressway | \n", "
26 | \n", "LINESTRING (103.8541409 1.3976207, 103.8537589... | \n", "motorway | \n", "Seletar Expressway | \n", "
27 | \n", "LINESTRING (103.7572461 1.4233889, 103.757277 ... | \n", "primary | \n", "Turf Club Avenue | \n", "
28 | \n", "LINESTRING (103.7740277 1.3968194, 103.7740856... | \n", "motorway | \n", "Kranji Expressway | \n", "
29 | \n", "LINESTRING (103.7024781 1.3606672, 103.7029984... | \n", "motorway | \n", "Kranji Expressway | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
10606 | \n", "LINESTRING (103.7456548 1.3238507, 103.7456587... | \n", "primary | \n", "Jurong Town Hall Road | \n", "
10607 | \n", "LINESTRING (103.9278275 1.3236756, 103.9294382... | \n", "primary | \n", "New Upper Changi Road | \n", "
10608 | \n", "LINESTRING (103.9090633 1.4008567, 103.9089959... | \n", "tertiary | \n", "Punggol Central | \n", "
10609 | \n", "LINESTRING (103.9085407 1.4013837, 103.9090685... | \n", "tertiary | \n", "Punggol Central | \n", "
10610 | \n", "LINESTRING (103.8635402 1.3219606, 103.8636524... | \n", "primary | \n", "Serangoon Road | \n", "
10611 | \n", "LINESTRING (103.9878283 1.3174213, 103.9873099... | \n", "secondary | \n", "Tanah Merah Coast Road | \n", "
10612 | \n", "LINESTRING (103.9819889 1.32008, 103.9822557 1... | \n", "secondary | \n", "Tanah Merah Coast Road | \n", "
10613 | \n", "LINESTRING (103.9880358 1.3171467, 103.9882954... | \n", "unclassified | \n", "Tanah Merah Ferry Road | \n", "
10614 | \n", "LINESTRING (103.7480459 1.3364131, 103.7477151... | \n", "unclassified | \n", "Toh Guan Road East | \n", "
10615 | \n", "LINESTRING (103.7471773 1.3321312, 103.7473666... | \n", "secondary | \n", "Toh Guan Road | \n", "
10616 | \n", "LINESTRING (103.7476578 1.3368285, 103.7476645... | \n", "secondary | \n", "Toh Guan Road | \n", "
10617 | \n", "LINESTRING (103.7587476 1.3306791, 103.7580119... | \n", "unclassified | \n", "Toh Tuck Link | \n", "
10618 | \n", "LINESTRING (103.7605157 1.3375774, 103.760884 ... | \n", "residential | \n", "Toh Tuck Road | \n", "
10619 | \n", "LINESTRING (103.7717609 1.3410362, 103.7718022... | \n", "residential | \n", "Toh Tuck Road | \n", "
10620 | \n", "LINESTRING (103.8737945 1.3560351, 103.8735798... | \n", "secondary | \n", "Yio Chu Kang Link | \n", "
10621 | \n", "LINESTRING (103.7667516 1.2907781, 103.7671805... | \n", "secondary | \n", "Harbour Drive | \n", "
10622 | \n", "LINESTRING (103.7666223 1.2908582, 103.7667516... | \n", "secondary | \n", "West Coast Ferry Road | \n", "
10623 | \n", "LINESTRING (103.8479024 1.2838138, 103.8482049... | \n", "residential | \n", "China Street | \n", "
10624 | \n", "LINESTRING (103.8448404 1.2907019, 103.8447671... | \n", "residential | \n", "Clarke Quay | \n", "
10625 | \n", "LINESTRING (103.7465423 1.4078451, 103.7462293... | \n", "secondary | \n", "Sungei Kadut Drive | \n", "
10626 | \n", "LINESTRING (103.7469404 1.4300587, 103.7469354... | \n", "secondary | \n", "Sungei Kadut Drive | \n", "
10627 | \n", "LINESTRING (103.8301091 1.2795678, 103.8297781... | \n", "unclassified | \n", "Macalister Road | \n", "
10628 | \n", "LINESTRING (103.8377302 1.3901191, 103.8380534... | \n", "residential | \n", "Countryside Walk | \n", "
10629 | \n", "LINESTRING (103.850795 1.339425, 103.8508394 1... | \n", "residential | \n", "Lorong 4 Toa Payoh | \n", "
10630 | \n", "LINESTRING (103.8515894 1.3395955, 103.8513506... | \n", "residential | \n", "Lorong 4 Toa Payoh | \n", "
10631 | \n", "LINESTRING (103.8517761 1.3396263, 103.8520148... | \n", "secondary_link | \n", "Lorong 6 Toa Payoh | \n", "
10632 | \n", "LINESTRING (103.67452 1.3306795, 103.6770103 1... | \n", "residential | \n", "PIE | \n", "
10633 | \n", "LINESTRING (103.7878953 1.3008067, 103.7879641... | \n", "residential | \n", "Nepal Park | \n", "
10634 | \n", "LINESTRING (103.7878222 1.3015588, 103.7881668... | \n", "residential | \n", "Nepal Park | \n", "
10635 | \n", "LINESTRING (103.9098645 1.3024331, 103.909354 ... | \n", "residential | \n", "Marine Drive | \n", "
10636 rows × 3 columns
\n", "\n", " | name | \n", "final_name | \n", "road_name | \n", "road_tag | \n", "
---|---|---|---|---|
0 | \n", "Orchard Road | \n", "Orchard Road | \n", "Orchard | \n", "Road | \n", "
1 | \n", "Hougang Avenue 1 | \n", "Hougang Avenue 1 | \n", "Hougang | \n", "Avenue | \n", "
2 | \n", "Scotts Road | \n", "Scotts Road | \n", "Scotts | \n", "Road | \n", "
3 | \n", "Keng Lee Road | \n", "Keng Lee Road | \n", "Keng Lee | \n", "Road | \n", "
4 | \n", "Newton Road | \n", "Newton Road | \n", "Newton | \n", "Road | \n", "
5 | \n", "Sarkies Road | \n", "Sarkies Road | \n", "Sarkies | \n", "Road | \n", "
6 | \n", "Patterson Road | \n", "Paterson Road | \n", "Paterson | \n", "Road | \n", "
7 | \n", "Orchard Boulevard | \n", "Orchard Boulevard | \n", "Orchard | \n", "Boulevard | \n", "
8 | \n", "Grange Road | \n", "Grange Road | \n", "Grange | \n", "Road | \n", "
9 | \n", "Paterson Hill | \n", "Paterson Hill | \n", "Paterson | \n", "Hill | \n", "
10 | \n", "River Valley Road | \n", "River Valley Road | \n", "River | \n", "Valley Road | \n", "
11 | \n", "Unity Street | \n", "Unity Street | \n", "Unity | \n", "Street | \n", "
12 | \n", "Merbau Road | \n", "Merbau Road | \n", "Merbau | \n", "Road | \n", "
13 | \n", "Mohamed Sultan Road | \n", "Mohamed Sultan Road | \n", "Mohamed Sultan | \n", "Road | \n", "
14 | \n", "Saiboo Street | \n", "Saiboo Street | \n", "Saiboo | \n", "Street | \n", "
15 | \n", "Merchant Loop | \n", "Merchant Loop | \n", "Merchant | \n", "Loop | \n", "
16 | \n", "Clemenceau Avenue | \n", "Clemenceau Avenue | \n", "Clemenceau | \n", "Avenue | \n", "
17 | \n", "Merchant Road | \n", "Merchant Road | \n", "Merchant | \n", "Road | \n", "
18 | \n", "Read Cresent | \n", "Read Crescent | \n", "Read | \n", "Crescent | \n", "
19 | \n", "Tampines Expressway | \n", "Tampines Expressway | \n", "Tampines | \n", "Expressway | \n", "
20 | \n", "Seletar Expressway | \n", "Seletar Expressway | \n", "Seletar | \n", "Expressway | \n", "
21 | \n", "Central Expressway | \n", "Central Expressway | \n", "Central | \n", "Expressway | \n", "
22 | \n", "Telok Blangah Road | \n", "Telok Blangah Road | \n", "Telok Blangah | \n", "Road | \n", "
23 | \n", "Ayer Rajah Expressway | \n", "Ayer Rajah Expressway | \n", "Ayer Rajah | \n", "Expressway | \n", "
24 | \n", "Turf Club Avenue | \n", "Turf Club Avenue | \n", "Turf Club | \n", "Avenue | \n", "
25 | \n", "Kranji Expressway | \n", "Kranji Expressway | \n", "Kranji | \n", "Expressway | \n", "
26 | \n", "Prinsep Street | \n", "Prinsep Street | \n", "Prinsep | \n", "Street | \n", "
27 | \n", "Tanglin Road | \n", "Tanglin Road | \n", "Tanglin | \n", "Road | \n", "
28 | \n", "Alexandra Road | \n", "Alexandra Road | \n", "Alexandra | \n", "Road | \n", "
29 | \n", "Nicoll Highway | \n", "Nicoll Highway | \n", "Nicoll | \n", "Highway | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
3404 | \n", "Seletar North Link | \n", "Seletar North Link | \n", "Seletar | \n", "Link | \n", "
3405 | \n", "Ghim Moh Link | \n", "Ghim Moh Link | \n", "Ghim Moh | \n", "Link | \n", "
3406 | \n", "Hougang Street 31 | \n", "Hougang Street 31 | \n", "Hougang | \n", "Street | \n", "
3407 | \n", "Hougang Street 32 | \n", "Hougang Street 32 | \n", "Hougang | \n", "Street | \n", "
3408 | \n", "Serangoon Lane | \n", "Serangoon Lane | \n", "Serangoon | \n", "Lane | \n", "
3409 | \n", "Gambir Walk | \n", "Gambir Walk | \n", "Gambir | \n", "Walk | \n", "
3410 | \n", "Upper Serangoon Crescent | \n", "Upper Serangoon Crescent | \n", "Serangoon | \n", "Crescent | \n", "
3411 | \n", "Ubi Close | \n", "Ubi Close | \n", "Ubi | \n", "Close | \n", "
3412 | \n", "Sin Ming Lane | \n", "Sin Ming Lane | \n", "Sin Ming | \n", "Lane | \n", "
3413 | \n", "Compassvale Lane | \n", "Compassvale Lane | \n", "Compassvale | \n", "Lane | \n", "
3414 | \n", "Lorong 5 Realty Park | \n", "Lorong 5 Realty Park | \n", "Lorong Realty | \n", "Park | \n", "
3415 | \n", "Wee Nam Road | \n", "Wee Nam Road | \n", "Wee Nam | \n", "Road | \n", "
3416 | \n", "Tampines Street 72 | \n", "Tampines Street 72 | \n", "Tampines | \n", "Street | \n", "
3417 | \n", "Changi South Lane | \n", "Changi South Lane | \n", "Changi | \n", "Lane | \n", "
3418 | \n", "Telegraph Street | \n", "Telegraph Street | \n", "Telegraph | \n", "Street | \n", "
3419 | \n", "Biopolis Street | \n", "Biopolis Street | \n", "Biopolis | \n", "Street | \n", "
3420 | \n", "Biopolis Link | \n", "Biopolis Link | \n", "Biopolis | \n", "Link | \n", "
3421 | \n", "Plymouth Avenue | \n", "Plymouth Avenue | \n", "Plymouth | \n", "Avenue | \n", "
3422 | \n", "Gentle Road | \n", "Gentle Road | \n", "Gentle | \n", "Road | \n", "
3423 | \n", "Leicester Road | \n", "Leicester Road | \n", "Leicester | \n", "Road | \n", "
3424 | \n", "Simon Walk | \n", "Simon Walk | \n", "Simon | \n", "Walk | \n", "
3425 | \n", "Joo Hong Road | \n", "Joo Hong Road | \n", "Joo Hong | \n", "Road | \n", "
3426 | \n", "Florence Close | \n", "Florence Close | \n", "Florence | \n", "Close | \n", "
3427 | \n", "Hoot Kiam Road | \n", "Hoot Kiam Road | \n", "Hoot Kiam | \n", "Road | \n", "
3428 | \n", "Yishun Avenue 8 | \n", "Yishun Avenue 8 | \n", "Yishun | \n", "Avenue | \n", "
3429 | \n", "Choa Chu Kang Avenue 6 | \n", "Choa Chu Kang Avenue 6 | \n", "Choa Chu Kang | \n", "Avenue | \n", "
3430 | \n", "Clarke Quay | \n", "Clarke Quay | \n", "Clarke | \n", "Quay | \n", "
3431 | \n", "Countryside Walk | \n", "Countryside Walk | \n", "Countryside | \n", "Walk | \n", "
3432 | \n", "PIE | \n", "Pan-Island Expressway | \n", "Pan-Island | \n", "Expressway | \n", "
3433 | \n", "Nepal Park | \n", "Nepal Park | \n", "Nepal | \n", "Park | \n", "
3434 rows × 4 columns
\n", "\n", " | road_name | \n", "classification | \n", "
---|---|---|
0 | \n", "Abingdon | \n", "British | \n", "
1 | \n", "Abu Talib | \n", "Malay | \n", "
2 | \n", "Adam | \n", "British | \n", "
3 | \n", "Adat | \n", "Malay | \n", "
4 | \n", "Adis | \n", "Other | \n", "
5 | \n", "Admiralty | \n", "British | \n", "
6 | \n", "Ah Hood | \n", "Chinese | \n", "
7 | \n", "Ah Soo | \n", "Chinese | \n", "
8 | \n", "Ahmad Ibrahim | \n", "Malay | \n", "
9 | \n", "Aida | \n", "Other | \n", "
10 | \n", "Airport | \n", "Generic | \n", "
11 | \n", "Alexandra | \n", "British | \n", "
12 | \n", "Aliwal | \n", "Indian | \n", "
13 | \n", "Aljunied | \n", "Other | \n", "
14 | \n", "Allanbrooke | \n", "British | \n", "
15 | \n", "Allenby | \n", "British | \n", "
16 | \n", "Almond | \n", "Generic | \n", "
17 | \n", "Alnwick | \n", "British | \n", "
18 | \n", "Alps | \n", "Other | \n", "
19 | \n", "Ama Keng | \n", "Chinese | \n", "
20 | \n", "Amber | \n", "Other | \n", "
21 | \n", "Amoy | \n", "Chinese | \n", "
22 | \n", "Ampang | \n", "Malay | \n", "
23 | \n", "Ampas | \n", "Malay | \n", "
24 | \n", "Ampat | \n", "Malay | \n", "
25 | \n", "Anak Bukit | \n", "Malay | \n", "
26 | \n", "Anak Patong | \n", "Malay | \n", "
27 | \n", "Anamalai | \n", "Indian | \n", "
28 | \n", "Anchorvale | \n", "Generic | \n", "
29 | \n", "Anderson | \n", "British | \n", "
... | \n", "... | \n", "... | \n", "
1721 | \n", "Woodgrove | \n", "Generic | \n", "
1722 | \n", "Woodland | \n", "Generic | \n", "
1723 | \n", "Woodlands | \n", "Generic | \n", "
1724 | \n", "Woodleigh | \n", "British | \n", "
1725 | \n", "Woodsville | \n", "Generic | \n", "
1726 | \n", "Woollerton | \n", "British | \n", "
1727 | \n", "Worthing | \n", "British | \n", "
1728 | \n", "Xilin | \n", "Chinese | \n", "
1729 | \n", "Yan Kit | \n", "Chinese | \n", "
1730 | \n", "Yarrow | \n", "British | \n", "
1731 | \n", "Yarwood | \n", "British | \n", "
1732 | \n", "Yasin | \n", "Malay | \n", "
1733 | \n", "Yio Chu Kang | \n", "Chinese | \n", "
1734 | \n", "Yishun | \n", "Chinese | \n", "
1735 | \n", "Yong Siak | \n", "Chinese | \n", "
1736 | \n", "York | \n", "British | \n", "
1737 | \n", "Youngberg | \n", "British | \n", "
1738 | \n", "Yuan Ching | \n", "Chinese | \n", "
1739 | \n", "Yuk Tong | \n", "Chinese | \n", "
1740 | \n", "Yung An | \n", "Chinese | \n", "
1741 | \n", "Yung Ho | \n", "Chinese | \n", "
1742 | \n", "Yung Kuang | \n", "Chinese | \n", "
1743 | \n", "Yung Sheng | \n", "Chinese | \n", "
1744 | \n", "Yunnan | \n", "Chinese | \n", "
1745 | \n", "Zamrud | \n", "Malay | \n", "
1746 | \n", "Zehnder | \n", "Other | \n", "
1747 | \n", "Zion | \n", "Other | \n", "
1748 | \n", "Zubir Said | \n", "Malay | \n", "
1749 | \n", "kukoh | \n", "Malay | \n", "
1750 | \n", "one-north Gateway | \n", "Generic | \n", "
1751 rows × 2 columns
\n", "\n", " | name | \n", "final_name | \n", "road_name | \n", "road_tag | \n", "classification | \n", "
---|---|---|---|---|---|
0 | \n", "Orchard Road | \n", "Orchard Road | \n", "Orchard | \n", "Road | \n", "Generic | \n", "
1 | \n", "Hougang Avenue 1 | \n", "Hougang Avenue 1 | \n", "Hougang | \n", "Avenue | \n", "Chinese | \n", "
2 | \n", "Scotts Road | \n", "Scotts Road | \n", "Scotts | \n", "Road | \n", "British | \n", "
3 | \n", "Keng Lee Road | \n", "Keng Lee Road | \n", "Keng Lee | \n", "Road | \n", "Chinese | \n", "
4 | \n", "Newton Road | \n", "Newton Road | \n", "Newton | \n", "Road | \n", "British | \n", "
5 | \n", "Sarkies Road | \n", "Sarkies Road | \n", "Sarkies | \n", "Road | \n", "Other | \n", "
6 | \n", "Patterson Road | \n", "Paterson Road | \n", "Paterson | \n", "Road | \n", "British | \n", "
7 | \n", "Orchard Boulevard | \n", "Orchard Boulevard | \n", "Orchard | \n", "Boulevard | \n", "Generic | \n", "
8 | \n", "Grange Road | \n", "Grange Road | \n", "Grange | \n", "Road | \n", "British | \n", "
9 | \n", "Paterson Hill | \n", "Paterson Hill | \n", "Paterson | \n", "Hill | \n", "British | \n", "
10 | \n", "River Valley Road | \n", "River Valley Road | \n", "River | \n", "Valley Road | \n", "Generic | \n", "
11 | \n", "Unity Street | \n", "Unity Street | \n", "Unity | \n", "Street | \n", "Generic | \n", "
12 | \n", "Merbau Road | \n", "Merbau Road | \n", "Merbau | \n", "Road | \n", "Malay | \n", "
13 | \n", "Mohamed Sultan Road | \n", "Mohamed Sultan Road | \n", "Mohamed Sultan | \n", "Road | \n", "Malay | \n", "
14 | \n", "Saiboo Street | \n", "Saiboo Street | \n", "Saiboo | \n", "Street | \n", "Indian | \n", "
15 | \n", "Merchant Loop | \n", "Merchant Loop | \n", "Merchant | \n", "Loop | \n", "Generic | \n", "
16 | \n", "Clemenceau Avenue | \n", "Clemenceau Avenue | \n", "Clemenceau | \n", "Avenue | \n", "Other | \n", "
17 | \n", "Merchant Road | \n", "Merchant Road | \n", "Merchant | \n", "Road | \n", "Generic | \n", "
18 | \n", "Read Cresent | \n", "Read Crescent | \n", "Read | \n", "Crescent | \n", "British | \n", "
19 | \n", "Tampines Expressway | \n", "Tampines Expressway | \n", "Tampines | \n", "Expressway | \n", "Malay | \n", "
20 | \n", "Seletar Expressway | \n", "Seletar Expressway | \n", "Seletar | \n", "Expressway | \n", "Malay | \n", "
21 | \n", "Central Expressway | \n", "Central Expressway | \n", "Central | \n", "Expressway | \n", "Generic | \n", "
22 | \n", "Telok Blangah Road | \n", "Telok Blangah Road | \n", "Telok Blangah | \n", "Road | \n", "Malay | \n", "
23 | \n", "Ayer Rajah Expressway | \n", "Ayer Rajah Expressway | \n", "Ayer Rajah | \n", "Expressway | \n", "Malay | \n", "
24 | \n", "Turf Club Avenue | \n", "Turf Club Avenue | \n", "Turf Club | \n", "Avenue | \n", "Generic | \n", "
25 | \n", "Kranji Expressway | \n", "Kranji Expressway | \n", "Kranji | \n", "Expressway | \n", "Malay | \n", "
26 | \n", "Prinsep Street | \n", "Prinsep Street | \n", "Prinsep | \n", "Street | \n", "British | \n", "
27 | \n", "Tanglin Road | \n", "Tanglin Road | \n", "Tanglin | \n", "Road | \n", "Chinese | \n", "
28 | \n", "Alexandra Road | \n", "Alexandra Road | \n", "Alexandra | \n", "Road | \n", "British | \n", "
29 | \n", "Nicoll Highway | \n", "Nicoll Highway | \n", "Nicoll | \n", "Highway | \n", "British | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
3404 | \n", "Seletar North Link | \n", "Seletar North Link | \n", "Seletar | \n", "Link | \n", "Malay | \n", "
3405 | \n", "Ghim Moh Link | \n", "Ghim Moh Link | \n", "Ghim Moh | \n", "Link | \n", "Chinese | \n", "
3406 | \n", "Hougang Street 31 | \n", "Hougang Street 31 | \n", "Hougang | \n", "Street | \n", "Chinese | \n", "
3407 | \n", "Hougang Street 32 | \n", "Hougang Street 32 | \n", "Hougang | \n", "Street | \n", "Chinese | \n", "
3408 | \n", "Serangoon Lane | \n", "Serangoon Lane | \n", "Serangoon | \n", "Lane | \n", "Malay | \n", "
3409 | \n", "Gambir Walk | \n", "Gambir Walk | \n", "Gambir | \n", "Walk | \n", "Malay | \n", "
3410 | \n", "Upper Serangoon Crescent | \n", "Upper Serangoon Crescent | \n", "Serangoon | \n", "Crescent | \n", "Malay | \n", "
3411 | \n", "Ubi Close | \n", "Ubi Close | \n", "Ubi | \n", "Close | \n", "Malay | \n", "
3412 | \n", "Sin Ming Lane | \n", "Sin Ming Lane | \n", "Sin Ming | \n", "Lane | \n", "Chinese | \n", "
3413 | \n", "Compassvale Lane | \n", "Compassvale Lane | \n", "Compassvale | \n", "Lane | \n", "Generic | \n", "
3414 | \n", "Lorong 5 Realty Park | \n", "Lorong 5 Realty Park | \n", "Lorong Realty | \n", "Park | \n", "Generic | \n", "
3415 | \n", "Wee Nam Road | \n", "Wee Nam Road | \n", "Wee Nam | \n", "Road | \n", "Chinese | \n", "
3416 | \n", "Tampines Street 72 | \n", "Tampines Street 72 | \n", "Tampines | \n", "Street | \n", "Malay | \n", "
3417 | \n", "Changi South Lane | \n", "Changi South Lane | \n", "Changi | \n", "Lane | \n", "Malay | \n", "
3418 | \n", "Telegraph Street | \n", "Telegraph Street | \n", "Telegraph | \n", "Street | \n", "Generic | \n", "
3419 | \n", "Biopolis Street | \n", "Biopolis Street | \n", "Biopolis | \n", "Street | \n", "Generic | \n", "
3420 | \n", "Biopolis Link | \n", "Biopolis Link | \n", "Biopolis | \n", "Link | \n", "Generic | \n", "
3421 | \n", "Plymouth Avenue | \n", "Plymouth Avenue | \n", "Plymouth | \n", "Avenue | \n", "British | \n", "
3422 | \n", "Gentle Road | \n", "Gentle Road | \n", "Gentle | \n", "Road | \n", "British | \n", "
3423 | \n", "Leicester Road | \n", "Leicester Road | \n", "Leicester | \n", "Road | \n", "British | \n", "
3424 | \n", "Simon Walk | \n", "Simon Walk | \n", "Simon | \n", "Walk | \n", "British | \n", "
3425 | \n", "Joo Hong Road | \n", "Joo Hong Road | \n", "Joo Hong | \n", "Road | \n", "Chinese | \n", "
3426 | \n", "Florence Close | \n", "Florence Close | \n", "Florence | \n", "Close | \n", "Chinese | \n", "
3427 | \n", "Hoot Kiam Road | \n", "Hoot Kiam Road | \n", "Hoot Kiam | \n", "Road | \n", "Chinese | \n", "
3428 | \n", "Yishun Avenue 8 | \n", "Yishun Avenue 8 | \n", "Yishun | \n", "Avenue | \n", "Chinese | \n", "
3429 | \n", "Choa Chu Kang Avenue 6 | \n", "Choa Chu Kang Avenue 6 | \n", "Choa Chu Kang | \n", "Avenue | \n", "Chinese | \n", "
3430 | \n", "Clarke Quay | \n", "Clarke Quay | \n", "Clarke | \n", "Quay | \n", "British | \n", "
3431 | \n", "Countryside Walk | \n", "Countryside Walk | \n", "Countryside | \n", "Walk | \n", "Generic | \n", "
3432 | \n", "PIE | \n", "Pan-Island Expressway | \n", "Pan-Island | \n", "Expressway | \n", "Generic | \n", "
3433 | \n", "Nepal Park | \n", "Nepal Park | \n", "Nepal | \n", "Park | \n", "Other | \n", "
3434 rows × 5 columns
\n", "\n", " | geometry | \n", "highway | \n", "name | \n", "final_name | \n", "road_name | \n", "road_tag | \n", "classification | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "LINESTRING (103.8284048 1.3068666, 103.8287382... | \n", "primary | \n", "Orchard Road | \n", "Orchard Road | \n", "Orchard | \n", "Road | \n", "Generic | \n", "
1 | \n", "LINESTRING (103.8858462 1.3517778, 103.8859356... | \n", "residential | \n", "Hougang Avenue 1 | \n", "Hougang Avenue 1 | \n", "Hougang | \n", "Avenue | \n", "Chinese | \n", "
2 | \n", "LINESTRING (103.8387571 1.3126764, 103.83872 1... | \n", "primary | \n", "Scotts Road | \n", "Scotts Road | \n", "Scotts | \n", "Road | \n", "British | \n", "
3 | \n", "LINESTRING (103.8395387 1.3132203, 103.8396493... | \n", "tertiary | \n", "Keng Lee Road | \n", "Keng Lee Road | \n", "Keng Lee | \n", "Road | \n", "Chinese | \n", "
4 | \n", "LINESTRING (103.8392505 1.3134495, 103.8394598... | \n", "primary | \n", "Newton Road | \n", "Newton Road | \n", "Newton | \n", "Road | \n", "British | \n", "
5 | \n", "LINESTRING (103.8373031 1.3147037, 103.8359738... | \n", "residential | \n", "Sarkies Road | \n", "Sarkies Road | \n", "Sarkies | \n", "Road | \n", "Other | \n", "
6 | \n", "LINESTRING (103.8318305 1.3050277, 103.8315539... | \n", "primary | \n", "Patterson Road | \n", "Paterson Road | \n", "Paterson | \n", "Road | \n", "British | \n", "
7 | \n", "LINESTRING (103.8348293 1.3004045, 103.8342528... | \n", "secondary | \n", "Orchard Boulevard | \n", "Orchard Boulevard | \n", "Orchard | \n", "Boulevard | \n", "Generic | \n", "
8 | \n", "LINESTRING (103.8348293 1.3004045, 103.8346883... | \n", "secondary | \n", "Grange Road | \n", "Grange Road | \n", "Grange | \n", "Road | \n", "British | \n", "
9 | \n", "LINESTRING (103.830813 1.3039006, 103.8302888 ... | \n", "primary | \n", "Paterson Hill | \n", "Paterson Hill | \n", "Paterson | \n", "Hill | \n", "British | \n", "
10 | \n", "LINESTRING (103.8313547 1.2960058, 103.83227 1... | \n", "primary | \n", "River Valley Road | \n", "River Valley Road | \n", "River | \n", "Valley Road | \n", "Generic | \n", "
11 | \n", "LINESTRING (103.842836 1.291596, 103.8422129 1... | \n", "residential | \n", "Unity Street | \n", "Unity Street | \n", "Unity | \n", "Street | \n", "Generic | \n", "
12 | \n", "LINESTRING (103.8430392 1.2934171, 103.842244 ... | \n", "residential | \n", "Merbau Road | \n", "Merbau Road | \n", "Merbau | \n", "Road | \n", "Malay | \n", "
13 | \n", "LINESTRING (103.8387207 1.2909753, 103.8388778... | \n", "residential | \n", "Mohamed Sultan Road | \n", "Mohamed Sultan Road | \n", "Mohamed Sultan | \n", "Road | \n", "Malay | \n", "
14 | \n", "LINESTRING (103.8387207 1.2909753, 103.8386978... | \n", "residential | \n", "Saiboo Street | \n", "Saiboo Street | \n", "Saiboo | \n", "Street | \n", "Indian | \n", "
15 | \n", "LINESTRING (103.843357 1.2895812, 103.8436285 ... | \n", "residential | \n", "Merchant Loop | \n", "Merchant Loop | \n", "Merchant | \n", "Loop | \n", "Generic | \n", "
16 | \n", "LINESTRING (103.8412716 1.2886074, 103.8414779... | \n", "primary | \n", "Clemenceau Avenue | \n", "Clemenceau Avenue | \n", "Clemenceau | \n", "Avenue | \n", "Other | \n", "
17 | \n", "LINESTRING (103.8420526 1.2900233, 103.8421061... | \n", "secondary | \n", "Merchant Road | \n", "Merchant Road | \n", "Merchant | \n", "Road | \n", "Generic | \n", "
18 | \n", "LINESTRING (103.8447163 1.2885069, 103.8448984... | \n", "residential | \n", "Read Cresent | \n", "Read Crescent | \n", "Read | \n", "Crescent | \n", "British | \n", "
19 | \n", "LINESTRING (103.8513753 1.3967862, 103.8518491... | \n", "motorway | \n", "Tampines Expressway | \n", "Tampines Expressway | \n", "Tampines | \n", "Expressway | \n", "Malay | \n", "
20 | \n", "LINESTRING (103.8579655 1.3941346, 103.8580422... | \n", "motorway | \n", "Seletar Expressway | \n", "Seletar Expressway | \n", "Seletar | \n", "Expressway | \n", "Malay | \n", "
21 | \n", "LINESTRING (103.8443907 1.3109684, 103.8445533... | \n", "motorway | \n", "Central Expressway | \n", "Central Expressway | \n", "Central | \n", "Expressway | \n", "Generic | \n", "
22 | \n", "LINESTRING (103.8021677 1.2727921, 103.8022844... | \n", "primary | \n", "Telok Blangah Road | \n", "Telok Blangah Road | \n", "Telok Blangah | \n", "Road | \n", "Malay | \n", "
23 | \n", "LINESTRING (103.6372541 1.3480363, 103.6373882... | \n", "motorway | \n", "Ayer Rajah Expressway | \n", "Ayer Rajah Expressway | \n", "Ayer Rajah | \n", "Expressway | \n", "Malay | \n", "
24 | \n", "LINESTRING (103.8341079 1.2723657, 103.8361228... | \n", "motorway | \n", "Ayer Rajah Expressway | \n", "Ayer Rajah Expressway | \n", "Ayer Rajah | \n", "Expressway | \n", "Malay | \n", "
25 | \n", "LINESTRING (103.8541001 1.3977878, 103.8545108... | \n", "motorway | \n", "Seletar Expressway | \n", "Seletar Expressway | \n", "Seletar | \n", "Expressway | \n", "Malay | \n", "
26 | \n", "LINESTRING (103.8541409 1.3976207, 103.8537589... | \n", "motorway | \n", "Seletar Expressway | \n", "Seletar Expressway | \n", "Seletar | \n", "Expressway | \n", "Malay | \n", "
27 | \n", "LINESTRING (103.7572461 1.4233889, 103.757277 ... | \n", "primary | \n", "Turf Club Avenue | \n", "Turf Club Avenue | \n", "Turf Club | \n", "Avenue | \n", "Generic | \n", "
28 | \n", "LINESTRING (103.7740277 1.3968194, 103.7740856... | \n", "motorway | \n", "Kranji Expressway | \n", "Kranji Expressway | \n", "Kranji | \n", "Expressway | \n", "Malay | \n", "
29 | \n", "LINESTRING (103.7024781 1.3606672, 103.7029984... | \n", "motorway | \n", "Kranji Expressway | \n", "Kranji Expressway | \n", "Kranji | \n", "Expressway | \n", "Malay | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
10606 | \n", "LINESTRING (103.7456548 1.3238507, 103.7456587... | \n", "primary | \n", "Jurong Town Hall Road | \n", "Jurong Town Hall Road | \n", "Jurong Town Hall | \n", "Road | \n", "Malay | \n", "
10607 | \n", "LINESTRING (103.9278275 1.3236756, 103.9294382... | \n", "primary | \n", "New Upper Changi Road | \n", "New Upper Changi Road | \n", "Changi | \n", "Road | \n", "Malay | \n", "
10608 | \n", "LINESTRING (103.9090633 1.4008567, 103.9089959... | \n", "tertiary | \n", "Punggol Central | \n", "Punggol Central | \n", "Punggol | \n", "NaN | \n", "Malay | \n", "
10609 | \n", "LINESTRING (103.9085407 1.4013837, 103.9090685... | \n", "tertiary | \n", "Punggol Central | \n", "Punggol Central | \n", "Punggol | \n", "NaN | \n", "Malay | \n", "
10610 | \n", "LINESTRING (103.8635402 1.3219606, 103.8636524... | \n", "primary | \n", "Serangoon Road | \n", "Serangoon Road | \n", "Serangoon | \n", "Road | \n", "Malay | \n", "
10611 | \n", "LINESTRING (103.9878283 1.3174213, 103.9873099... | \n", "secondary | \n", "Tanah Merah Coast Road | \n", "Tanah Merah Coast Road | \n", "Tanah Merah | \n", "Coast Road | \n", "Malay | \n", "
10612 | \n", "LINESTRING (103.9819889 1.32008, 103.9822557 1... | \n", "secondary | \n", "Tanah Merah Coast Road | \n", "Tanah Merah Coast Road | \n", "Tanah Merah | \n", "Coast Road | \n", "Malay | \n", "
10613 | \n", "LINESTRING (103.9880358 1.3171467, 103.9882954... | \n", "unclassified | \n", "Tanah Merah Ferry Road | \n", "Tanah Merah Ferry Road | \n", "Tanah Merah Ferry | \n", "Road | \n", "Malay | \n", "
10614 | \n", "LINESTRING (103.7480459 1.3364131, 103.7477151... | \n", "unclassified | \n", "Toh Guan Road East | \n", "Toh Guan Road East | \n", "Toh Guan | \n", "Road | \n", "Chinese | \n", "
10615 | \n", "LINESTRING (103.7471773 1.3321312, 103.7473666... | \n", "secondary | \n", "Toh Guan Road | \n", "Toh Guan Road | \n", "Toh Guan | \n", "Road | \n", "Chinese | \n", "
10616 | \n", "LINESTRING (103.7476578 1.3368285, 103.7476645... | \n", "secondary | \n", "Toh Guan Road | \n", "Toh Guan Road | \n", "Toh Guan | \n", "Road | \n", "Chinese | \n", "
10617 | \n", "LINESTRING (103.7587476 1.3306791, 103.7580119... | \n", "unclassified | \n", "Toh Tuck Link | \n", "Toh Tuck Link | \n", "Toh Tuck | \n", "Link | \n", "Chinese | \n", "
10618 | \n", "LINESTRING (103.7605157 1.3375774, 103.760884 ... | \n", "residential | \n", "Toh Tuck Road | \n", "Toh Tuck Road | \n", "Toh Tuck | \n", "Road | \n", "Chinese | \n", "
10619 | \n", "LINESTRING (103.7717609 1.3410362, 103.7718022... | \n", "residential | \n", "Toh Tuck Road | \n", "Toh Tuck Road | \n", "Toh Tuck | \n", "Road | \n", "Chinese | \n", "
10620 | \n", "LINESTRING (103.8737945 1.3560351, 103.8735798... | \n", "secondary | \n", "Yio Chu Kang Link | \n", "Yio Chu Kang Link | \n", "Yio Chu Kang | \n", "Link | \n", "Chinese | \n", "
10621 | \n", "LINESTRING (103.7667516 1.2907781, 103.7671805... | \n", "secondary | \n", "Harbour Drive | \n", "Harbour Drive | \n", "Harbour | \n", "Drive | \n", "Generic | \n", "
10622 | \n", "LINESTRING (103.7666223 1.2908582, 103.7667516... | \n", "secondary | \n", "West Coast Ferry Road | \n", "West Coast Ferry Road | \n", "Coast Ferry | \n", "Road | \n", "Generic | \n", "
10623 | \n", "LINESTRING (103.8479024 1.2838138, 103.8482049... | \n", "residential | \n", "China Street | \n", "China Street | \n", "China | \n", "Street | \n", "Chinese | \n", "
10624 | \n", "LINESTRING (103.8448404 1.2907019, 103.8447671... | \n", "residential | \n", "Clarke Quay | \n", "Clarke Quay | \n", "Clarke | \n", "Quay | \n", "British | \n", "
10625 | \n", "LINESTRING (103.7465423 1.4078451, 103.7462293... | \n", "secondary | \n", "Sungei Kadut Drive | \n", "Sungei Kadut Drive | \n", "Sungei Kadut | \n", "Drive | \n", "Malay | \n", "
10626 | \n", "LINESTRING (103.7469404 1.4300587, 103.7469354... | \n", "secondary | \n", "Sungei Kadut Drive | \n", "Sungei Kadut Drive | \n", "Sungei Kadut | \n", "Drive | \n", "Malay | \n", "
10627 | \n", "LINESTRING (103.8301091 1.2795678, 103.8297781... | \n", "unclassified | \n", "Macalister Road | \n", "MacAlister Road | \n", "MacAlister | \n", "Road | \n", "British | \n", "
10628 | \n", "LINESTRING (103.8377302 1.3901191, 103.8380534... | \n", "residential | \n", "Countryside Walk | \n", "Countryside Walk | \n", "Countryside | \n", "Walk | \n", "Generic | \n", "
10629 | \n", "LINESTRING (103.850795 1.339425, 103.8508394 1... | \n", "residential | \n", "Lorong 4 Toa Payoh | \n", "Lorong 4 Toa Payoh | \n", "Toa Payoh | \n", "Lorong | \n", "Chinese | \n", "
10630 | \n", "LINESTRING (103.8515894 1.3395955, 103.8513506... | \n", "residential | \n", "Lorong 4 Toa Payoh | \n", "Lorong 4 Toa Payoh | \n", "Toa Payoh | \n", "Lorong | \n", "Chinese | \n", "
10631 | \n", "LINESTRING (103.8517761 1.3396263, 103.8520148... | \n", "secondary_link | \n", "Lorong 6 Toa Payoh | \n", "Lorong 6 Toa Payoh | \n", "Toa Payoh | \n", "Lorong | \n", "Chinese | \n", "
10632 | \n", "LINESTRING (103.67452 1.3306795, 103.6770103 1... | \n", "residential | \n", "PIE | \n", "Pan-Island Expressway | \n", "Pan-Island | \n", "Expressway | \n", "Generic | \n", "
10633 | \n", "LINESTRING (103.7878953 1.3008067, 103.7879641... | \n", "residential | \n", "Nepal Park | \n", "Nepal Park | \n", "Nepal | \n", "Park | \n", "Other | \n", "
10634 | \n", "LINESTRING (103.7878222 1.3015588, 103.7881668... | \n", "residential | \n", "Nepal Park | \n", "Nepal Park | \n", "Nepal | \n", "Park | \n", "Other | \n", "
10635 | \n", "LINESTRING (103.9098645 1.3024331, 103.909354 ... | \n", "residential | \n", "Marine Drive | \n", "Marine Drive | \n", "Marine | \n", "Drive | \n", "Generic | \n", "
10636 rows × 7 columns
\n", "