scraping.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Web Scraping & Data Population"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import re\n",
    "import time\n",
    "import requests\n",
    "import sqlite3\n",
    "from bs4 import BeautifulSoup\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.webdriver.chrome.service import Service"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Implementation Code for Web Scraping & Data Handling"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "total items found: 135\n",
      "total sorted items found: 135\n",
      "location name: Subway NU Sentral\n",
      "4\n",
      "address: L4.13, Level Four, NU Sentral, No. 201 Jalan Tun Sambanthan, Kuala Lumpur, 50470\n",
      "operating hour: Monday - Sunday, 9:00 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-nu-sentral-l4.13,-level-four,-nu-sentral-kuala-lumpur?place=w.66650143.666435897.27398085\n",
      "latitude: 3.133075, longitude: 101.687034\n",
      "\n",
      "location name: Subway Menara UOA Bangsar\n",
      "4\n",
      "address: Jalan Bangsar Utama 1, Unit 1-2-G, Menara UOA Bangsar, Kuala Lumpur, 59000\n",
      "operating hour: Monday - Sunday, 8:00 AM - 8:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/federal-territory-of-kuala-lumpur/kuala-lumpur/subway-@-menara-uoa-bangsar?place=ChIJPWFRH5RJzDERvHvlO1uTQpY\n",
      "latitude: 3.128099, longitude: 101.678678\n",
      "\n",
      "location name: Subway Mid Valley KL\n",
      "4\n",
      "address: 1st Floor, Zone 3, Kiosk FK-05, Mid Valley Megamall,  Lingkaran Syed Putra, Mid Valley City, 59200 Kuala Lumpur\n",
      "operating hour: Monday - Sunday (8:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.118753,101.677459\n",
      "latitude: 3.118753, longitude: 101.677459\n",
      "\n",
      "location name: Subway TM\n",
      "8\n",
      "address: Lower Ground 1 (LG1), Menara TM, Jalan Pantai Baharu, 50672 Kuala Lumpur\n",
      "operating hour: Monday, 10:00 AM – 8:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/federal-territory-of-kuala-lumpur/kuala-lumpur/subway-@-menara-tm?place=ChIJ97qHTY1JzDEREeRr6wtfSts\n",
      "latitude: 3.116129, longitude: 101.665866\n",
      "\n",
      "location name: Subway KWC (Kenanga)\n",
      "4\n",
      "address: KWC Fashion Mall, No.2, Jalan Gelugor, Lot G-08, Kuala Lumpur, 55200\n",
      "operating hour: Monday - Sunday, 10:00 AM - 8:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-kwc-fashion-mall-lot-g-08-kwc-fashion-mall-kuala-lumpur?place=w.66650143.666566970.27400904\n",
      "latitude: 3.136102, longitude: 101.708431\n",
      "\n",
      "location name: Subway Menara Aras Jaya\n",
      "5\n",
      "address: LG Floor, Menara Bumiputra Commerce, No 11, Jalan Raja Laut, 50350 Kuala Lumpur\n",
      "operating hour: Monday - Friday, 8:00 AM – 9:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-cimb-cimb-11-jalan-raja-laut,-lower-ground-floor-kuala-lumpur?place=w.66650144.666501436.27395039\n",
      "latitude: 3.155606, longitude: 101.695688\n",
      "\n",
      "location name: Subway UOA Damansara\n",
      "5\n",
      "address: Unit 50-G-5, Ground Floor, Wisma UOA Damansara, No. 50, Jalan Dungun, Kuala Lumpur, 50490\n",
      "operating hour: Monday - Saturday, 8:00 AM – 8:30PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-@-wisma-uoa-damansara?place=ChIJa5Vpq1RIzDER8-Wwe3eFNUI\n",
      "latitude: 3.151729, longitude: 101.666006\n",
      "\n",
      "location name: Subway Capsquare\n",
      "5\n",
      "address: Ground Floor, Unit 01-02, Cap Square Tower, 10 Jalan Munshi Abdullah, Kuala Lumpur, 50100\n",
      "operating hour: Monday - Saturday, 8:00 AM – 9:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-@-capsquare?place=ChIJy-MVCLdJzDER31pWsrn_WZE\n",
      "latitude: 3.154416, longitude: 101.698823\n",
      "\n",
      "location name: Subway KL Gateway\n",
      "4\n",
      "address: G1.K5, Lower Ground 1, KL Gateway Mall, 2, Jalan Kerinchi, 59200 Kuala Lumpur\n",
      "operating hour: Monday - Sunday (8:00AM - 10:00PM)\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-kl-gateway-mall?place=ChIJ1cy2C85JzDERxEe6xZaRRyg\n",
      "latitude: 3.114111, longitude: 101.663270\n",
      "\n",
      "location name: Subway Southgate\n",
      "4\n",
      "address: Pusat Komersial Southgate, No. 2, Jalan Dua, Unit E-1-6, Off Jalan Chan Sow Lin, Lvl 1, Kuala Lumpur, 55200\n",
      "operating hour: Monday - Sunday, 8:00 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-@-southgate-commercial-center?place=ChIJd4K2SBw2zDERvbRfvxkCiEw\n",
      "latitude: 3.124517, longitude: 101.710679\n",
      "\n",
      "location name: Subway Berjaya Times Square\n",
      "4\n",
      "address: LG-08A, Berjaya Times Square, No. 1, Jalan Imbi, Kuala Lumpur, 55100\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-berjaya-times-square-lot-03-103,-3rd-floor,-berjaya-times-square-kuala-lumpur?place=w.66650143.666566970.27413449\n",
      "latitude: 3.142198, longitude: 101.710551\n",
      "\n",
      "location name: Subway Taman Danau Desa\n",
      "3\n",
      "address: None\n",
      "operating hour: Monday - Sunday (8:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.100857,101.687222\n",
      "latitude: 3.100857, longitude: 101.687222\n",
      "\n",
      "location name: Subway Quill City (LG)\n",
      "4\n",
      "address: Quill City Mall, LG-02, No. 1018, Jalan Sultan Ismail, Kuala Lumpur , 50250\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/federal-territory-of-kuala-lumpur/kuala-lumpur/subway-@-quill-city-mall?place=ChIJl7-7OS9IzDERa282ngJCTKs\n",
      "latitude: 3.159488, longitude: 101.700170\n",
      "\n",
      "location name: Subway University Malaya\n",
      "5\n",
      "address: Faculty of Dentistry, Level 1, Block B, University of Malaya, Kuala Lumpur, 50603\n",
      "operating hour: Monday - Friday, 6:30 AM – 10:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-university-of-malaya-university-of-malaya-faculty-of-dentistry-petaling-jaya?place=w.66650143.666173751.27402188\n",
      "latitude: 3.121723, longitude: 101.653684\n",
      "\n",
      "location name: Subway Razak City\n",
      "4\n",
      "address: Block B-G-19 Residensi Bandar Razak, No 01 Jln Razak Mansion, 57100 Sungai Besi, K.L\n",
      "operating hour: Monday - Sunday (08:00AM to 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.108465,101.706308\n",
      "latitude: 3.108465, longitude: 101.706308\n",
      "\n",
      "location name: Subway Jln Pinang\n",
      "5\n",
      "address: G9, Wisma UOA II, 19, Jalan Pinang, Kuala Lumpur, 50450\n",
      "operating hour: Monday - Saturday, 8:00 AM – 9:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-@-jalan-pinang-kl?place=ChIJIzvym9Q3zDER9MZj809Opn0\n",
      "latitude: 3.152705, longitude: 101.712034\n",
      "\n",
      "location name: Subway Sunway Putra\n",
      "4\n",
      "address: Lot 4-60 & 4-79A, Fourth Floor, Sunway Putra Mall, No. 100, Jalan Putra, 50350 Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/federal-territory-of-kuala-lumpur/kuala-lumpur/subway-@-sunway-putra-mall?place=ChIJZ9G0hjxIzDERadDFIQqD8Ck\n",
      "latitude: 3.166426, longitude: 101.692419\n",
      "\n",
      "location name: Subway Central Square\n",
      "4\n",
      "address: 23 Jalan Kampung Baru Lot GK-02 Central Square Shopping Center, 08000 Sungai Petani, Kedah\n",
      "operating hour: Monday - Sunday, 9:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-central-square-lot-gk-02,-central-square-shopping-center-sungai-petani?place=w.65863736.658571828.27396324\n",
      "latitude: 3.163051, longitude: 101.706183\n",
      "\n",
      "location name: Subway My Town\n",
      "4\n",
      "address: Lot B1-07 & B1-08, Level Basement 1, MyTOWN Shopping Centre, Jalan Cochrane, Seksyen 90, Kuala Lumpur, 55100\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-mytown-shopping-centre-b1-07-and-b1-08,-mytown-shopping-centre,-55100-kuala-lumpur?place=w.66650143.666632505.27397019\n",
      "latitude: 3.134863, longitude: 101.722843\n",
      "\n",
      "location name: Subway KLCC\n",
      "4\n",
      "address: Lot F208, Second Floor, Suria KLCC, Jalan Ampang, Golden, 50088 Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-@-suria-klcc?place=ChIJ4w-9zNY3zDER1BwAcFWcn74\n",
      "latitude: 3.159186, longitude: 101.712392\n",
      "\n",
      "location name: Subway Avenue K\n",
      "4\n",
      "address: Lot UC-8 & 9, Upper Concourse Level, Avenue K, No. 156, Jalan Ampang, Kuala Lumpur, 50450\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-avenue-k-lot-uc-8-and-9,-upper-concourse-level,-avenue-k-kuala-lumpur?place=w.66650144.666566972.27413004\n",
      "latitude: 3.159477, longitude: 101.713515\n",
      "\n",
      "location name: Subway Bandar Sri Permaisuri\n",
      "4\n",
      "address: Lot R-G-07, Ground Floor Q Avenue, Kompleks Permaisuri Q, No.6,Jalan Sri Permaisuri, Bandar Sri Permaisuri, Cheras 56000 Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 10:00 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-@-bandar-sri-permaisuri?place=ChIJOdM1NoI1zDERNMFVeFKzCJk\n",
      "latitude: 3.101187, longitude: 101.711708\n",
      "\n",
      "location name: Subway Hartamas SC\n",
      "4\n",
      "address: Lot G-22A & G-22B . Hartamas Shopping Center, 60, Jalan Sri Hartamas 1, Taman Sri Hartamas, 50480 Kuala Lumpur, Wilayah Persekutuan Kuala Lumpur\n",
      "operating hour: Monday - Sunday (10:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.163504,101.656995\n",
      "latitude: 3.163504, longitude: 101.656995\n",
      "\n",
      "location name: Subway Aeon Taman Maluri\n",
      "5\n",
      "address: Lot G32,AEON Mall Taman Maluri, Jalan Jejaka, Taman Maluri Cheras 55100, Kuala Lumpur\n",
      "operating hour: Sunday - Thursday, 10:00 AM – 10:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/cheras/subway-aeon-taman-maluri?place=ChIJxZc1CgI3zDER0L07egWJ6A4\n",
      "latitude: 3.125925, longitude: 101.728399\n",
      "\n",
      "location name: Subway Amcorp Mall\n",
      "5\n",
      "address: (Canopy Area), Lot KG-05, 18 Jln Persiaran, Ground Floor, Barat, Petaling Jaya, 46050\n",
      "operating hour: Monday - Friday, 9:00 AM – 10:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/subway-@-amcorp-mall-pj?place=ChIJgcEy_dpLzDERqz_XQPpVA2U\n",
      "latitude: 3.104774, longitude: 101.647341\n",
      "\n",
      "location name: Subway Jalan Ipoh\n",
      "4\n",
      "address: No. 447, Jalan Ipoh, Batu 3, Taman Million, 51200 Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-rivercity-village-468-1(1),-ground-floor,-block-f-rivercity-village-kuala-lumpur?place=w.66650144.666370366.16193787\n",
      "latitude: 3.178158, longitude: 101.685121\n",
      "\n",
      "location name: Subway Intermark Mall\n",
      "4\n",
      "address: The Intermark, Intermark Mall, 348, Jalan Tun Razak, 50400 Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-the-intermark?place=ChIJ48goZMU3zDERrTBFRU1gP-Mhttps://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-the-intermark?place=ChIJ48goZMU3zDERrTBFRU1gP-M\n",
      "latitude: 3.161545, longitude: 101.719918\n",
      "\n",
      "location name: Subway Mont Kiara\n",
      "4\n",
      "address: E-01-16 ,Block E, Plaza Mont Kiara, 2 Jalan Kiara, Mont Kiara, Kuala Lumpur, 50480\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-@-plaza-montkiara?place=ChIJ62Fw6vFIzDEReI7qDH2RtxQ\n",
      "latitude: 3.165686, longitude: 101.651956\n",
      "\n",
      "location name: Subway Pearl Point\n",
      "4\n",
      "address: Lot No. 1.0.69 (Ground Floor), Pearl Point Shopping Mall, Batu 5, Jalan Klang Lama, 58000 Kuala Lumpur\n",
      "operating hour: Monday - Sunday (9:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.083153,101.669445\n",
      "latitude: 3.083153, longitude: 101.669445\n",
      "\n",
      "location name: Subway Jaya One\n",
      "4\n",
      "address: 100-P2.015, Level 2, Block J, The School Jaya One, No.72A Jalan Prof Diraja Ungku Aziz, 46200 Petaling Jaya, Selangor\n",
      "operating hour: Monday - Sunday, 10:30 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/subway-jaya-one?place=ChIJcQghqGVJzDERLSVTpukyla4\n",
      "latitude: 3.117373, longitude: 101.635064\n",
      "\n",
      "location name: Subway SPARK\n",
      "4\n",
      "address: 1-01 Plaza Salak Park, No 2, Jalan 1/125E, Taman Desa Petaling, 57100 Kuala Lumpur\n",
      "operating hour: Monday - Sunday (8:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.082778,101.702471\n",
      "latitude: 3.082778, longitude: 101.702471\n",
      "\n",
      "location name: Subway Gurney Mall (UTMKL)\n",
      "5\n",
      "address: Lot 1-03, Level 1, Residensi UTMKL, No 8 Jalan Maktab, 54000 Kuala Lumpur\n",
      "operating hour: Tuesday – Sunday, 10:00 AM – 9:30PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-utmkl?place=ChIJ7_y8Q5A3zDER6JGmn1Nfmqc\n",
      "latitude: 3.171561, longitude: 101.721805\n",
      "\n",
      "location name: Subway BHP Jalan Kuching\n",
      "4\n",
      "address: BHPetrol Jalan Kuching, Lot PT 4283 & Lot 6086 Jalan Kuching, 52100 Kuala Lumpur.\n",
      "operating hour: Monday - Sunday, 7:30 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-@-bhp-jalan-kuching?place=ChIJH9__naBJzDERIoGI17o-ttQ\n",
      "latitude: 3.188440, longitude: 101.670158\n",
      "\n",
      "location name: Subway Lotus Ampang\n",
      "5\n",
      "address: LOTUS’S AMPANG - OL1, Jalan Pandan Prima Dataran, Pandan Indah, 55100 Kuala Lumpur\n",
      "operating hour: Monday - Sunday (10:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.143814,101.741630\n",
      "latitude: 3.143814, longitude: 101.741630\n",
      "\n",
      "location name: Subway TTDI\n",
      "4\n",
      "address: Lvl1, Petronas Svs Station TTDI,Lot29395 & 29396, Pinggir Zaaba, Taman Tun Dr Ismail, Kuala Lumpur, 60000\n",
      "operating hour: Monday - Sunday, 8:30 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-@-pinggir-zaaba-taman-tun?place=ChIJuRYqITBJzDER76oB2espXlU\n",
      "latitude: 3.141958, longitude: 101.625217\n",
      "\n",
      "location name: Subway Great Eastern Mall\n",
      "5\n",
      "address: Great Eastern Mall, Lot 4C Lower Ground Floor, No 303 Jalan Ampang, Kuala Lumpur, 50450\n",
      "operating hour: Monday - Friday, 8:30 AM – 8:30PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-great-eastern-mall-great-eastern-mall,-lot-4c-lower-ground-floor-kuala-lumpur?place=w.66650144.666763580.27398397\n",
      "latitude: 3.160073, longitude: 101.736901\n",
      "\n",
      "location name: Subway Lotus Cheras\n",
      "4\n",
      "address: Lot G27-G29, No.2, Jalan Midah 2, Taman Midah, 56000 Cheras, Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 9:30 AM - 9:00 PM\n",
      "waze link: https://waze.com/ul?ll=3.099541,101.734766\n",
      "latitude: 3.099541, longitude: 101.734766\n",
      "\n",
      "location name: Subway TBS\n",
      "5\n",
      "address: Unit L4-29, 4th Floor, Terminal Bersepadu Selatan, Bandar Tasik Selatan, Kuala Lumpur, 57100\n",
      "operating hour: Monday - Sunday, 10:00 AM – 8:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/federal-territory-of-kuala-lumpur/kuala-lumpur/subway-@-tbs?place=ChIJAVz8DF81zDERXWs-EKFOIF8\n",
      "latitude: 3.078001, longitude: 101.710922\n",
      "\n",
      "location name: Subway OUG\n",
      "4\n",
      "address: A1-07 Jalan 1/52, Taman OUG Parklane Off Jalan Klang Lama 58200 Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 9:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-oug-parklane?place=ChIJW9BS3nlLzDERdemjQm9QkBE\n",
      "latitude: 3.074779, longitude: 101.661593\n",
      "\n",
      "location name: Subway Sri Petaling\n",
      "4\n",
      "address: No. 53, Jalan Radin Bagus, 57000 Sri Petaling, Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-sri-petaling-jalan-radin-bagus-53-kuala-lumpur?place=w.66650143.666435891.12280737\n",
      "latitude: 3.070392, longitude: 101.695026\n",
      "\n",
      "location name: Subway Axis Atrium\n",
      "4\n",
      "address: Axis Atrium, Lot No. G-3 Ground Floor, Jalan Cempaka, Taman Cempaka Ampang, 68000\n",
      "operating hour: Monday - Sunday, 8:00 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-axis-atrium-axis-atrium,-lot-no.-g-3-ground-floor-kuala-lumpur?place=w.66650143.666829114.27401140\n",
      "latitude: 3.136505, longitude: 101.747491\n",
      "\n",
      "location name: Subway Atria\n",
      "4\n",
      "address: Atria Shopping Gallery, Lot C11, Jalan SS 22/23, Damansara Jaya, Petaling Jaya, 47400\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-atria-shoppinggallery-lot-c11-atria-shopping-gallery-petaling-jaya?place=w.66584607.665977145.27398112\n",
      "latitude: 3.127096, longitude: 101.616518\n",
      "\n",
      "location name: Subway Ikon Connaught\n",
      "4\n",
      "address: Ikon Connaught, G-02A & Alfresco GA-02A, Ground Floor, Jalan Cerdas, Taman Connaught, Kuala Lumpur, 56100\n",
      "operating hour: Monday - Sunday, 10:00 AM - 8:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-ikon-connaught-lot-g-02a-ikon-connaught-kuala-lumpur?place=w.66650143.666698036.27398136\n",
      "latitude: 3.081465, longitude: 101.731419\n",
      "\n",
      "location name: Subway Matahari Mall\n",
      "4\n",
      "address: Lot S15 & S16 , Ground Floor, Matahari Mall, No. 1, PJS 2/18, Taman Maju Jaya, 46000 Petaling Jaya,Selangor\n",
      "operating hour: Monday - Sunday (10:00AM - 9:30PM)\n",
      "waze link: https://waze.com/ul?ll=3.080121,101.638012\n",
      "latitude: 3.080121, longitude: 101.638012\n",
      "\n",
      "location name: Subway Endah Parade\n",
      "4\n",
      "address: Endah Parade Shopping Complex, Lot G-013A, Ground Floor, Jalan 1/149E, Kuala Lumpur, 57000\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-endah-parade-endah-parade-shopping-complex,-kuala-lumpur?place=w.66650143.666501426.27401582\n",
      "latitude: 3.063303, longitude: 101.695198\n",
      "\n",
      "location name: Subway One Utama\n",
      "5\n",
      "address: 318A One Utama, Lower Ground Floor, New Wing, 1 Utama Shopping Centre, Petaling Jaya, 47800\n",
      "operating hour: 0800 - 2200 (Sun - Thur)\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/1-utama-shopping-centre?place=ChIJL-Qvn9JOzDERBLmeTTrrgf0\n",
      "latitude: 3.151251, longitude: 101.615116\n",
      "\n",
      "location name: Subway Sime Darby Parkcity\n",
      "4\n",
      "address: Sime Darby Parkcity, CP Retail 2, No. 2 Jalan Intisari, Perdana Desa Parkcity, Kuala Lumpur, 52200\n",
      "operating hour: Monday - Sunday, 8:00 AM - 9:30 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-desa-park-city-sime-darby-parkcity,-cp-retail-2-kuala-lumpur?place=w.66584608.666108223.14350474\n",
      "latitude: 3.189334, longitude: 101.638541\n",
      "\n",
      "location name: Subway Brem Mall\n",
      "4\n",
      "address: G-06, Brem Mall, Jalan Kepong, Kepong, Kuala Lumpur, 52000\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-brem-mall-g-06,-brem-mall,-jalan-kepong,-kepong-kuala-lumpur?place=w.66650144.666304832.27401872\n",
      "latitude: 3.204461, longitude: 101.667600\n",
      "\n",
      "location name: Subway KLTS\n",
      "4\n",
      "address: 45-G, Plaza KLTS, Block C, Jalan Gombak, 53000 Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 9:00 AM - 9:30 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/federal-territory-of-kuala-lumpur/kuala-lumpur/subway-klts?place=ChIJKd965yNHzDERs76aJJNwaw4\n",
      "latitude: 3.204075, longitude: 101.703480\n",
      "\n",
      "location name: Subway Kidzania KL\n",
      "4\n",
      "address: Kidzania Kuala Lumpur, Lot 11, Lower Ground Curve NX, No.18 Jalan PJU 7/5, 47810 Mutiara Damansara, Petaling Jaya Selangor\n",
      "operating hour: Mon - Sun : 10am-6pmTues : Close\n",
      "waze link: https://waze.com/ul?ll=3.158034,101.613800\n",
      "latitude: 3.158034, longitude: 101.613800\n",
      "\n",
      "location name: Subway Center Point\n",
      "8\n",
      "address: Lebuh Bandar Utama, Center Point, Lot G104B Gr Floor, Petaling Jaya, 47800\n",
      "operating hour: Monday, 8:00 AM – 10:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-lebuh-bandar-utama-lebuh-bandar-utama,-center-point,-lot-g104b-petaling-jaya?place=w.66584607.665911610.27441776\n",
      "latitude: 3.136096, longitude: 101.607964\n",
      "\n",
      "location name: Subway Trillium, Lake Fields\n",
      "4\n",
      "address: No.66, Jalan Tasik Utama 7, Medan Niaga Tasik Damai, (Trillium) Lake Field, Sg Besi, Kuala Lumpur, 57000\n",
      "operating hour: Monday - Sunday, 8:30 AM - 10:00 PM\n",
      "waze link: https://waze.com/ul?ll=3.059890,101.710432\n",
      "latitude: 3.059890, longitude: 101.710432\n",
      "\n",
      "location name: Subway Petronas Ampang Point\n",
      "4\n",
      "address: Petronas Gas Station/C-Store, Lot 36904 TT27423, Jalan Air Kolam Lama, Ampang, 68000\n",
      "operating hour: Monday - Sunday, 8:30 AM - 9:00 PM\n",
      "waze link: https://waze.com/ul?ll=3.160388,101.756010\n",
      "latitude: 3.160388, longitude: 101.756010\n",
      "\n",
      "location name: Subway Sentul Sky Awani\n",
      "4\n",
      "address: Ground Floor , Unit No. G-11, Residensi Awani, Sky Awani, No. 27 Jalan Sentul Perdana 51100, Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-sky-awani-jalan-sentul-perdana-g-11-kuala-lumpur?place=w.66650144.666435905.27398084\n",
      "latitude: 3.209174, longitude: 101.691372\n",
      "\n",
      "location name: Subway Bukit Jalil\n",
      "4\n",
      "address: Level 1 Axiata Arena, KL Sport City, Bukit Jalil, 57000, Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 9:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-axiata-arena-bukit-jalil?place=ChIJ_1r32pdKzDERwqb1Q3n6L9o\n",
      "latitude: 3.053815, longitude: 101.693434\n",
      "\n",
      "location name: Subway Putra Ampang\n",
      "4\n",
      "address: No 46-G, Jalan Bunga Tanjung 9B, Taman Putra, Ampang 68000, Selangor\n",
      "operating hour: Monday - Sunday (08:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.120457,101.762861\n",
      "latitude: 3.120457, longitude: 101.762861\n",
      "\n",
      "location name: Subway Tesco Kepong\n",
      "4\n",
      "address: Tesco Kepong Village Mall, Lot No. 14, 1st Floor, No. 3 Jalan 7A/62A Bandar Manjalara, Kuala Lumpur, 52200\n",
      "operating hour: Monday - Sunday, 10:15 AM - 9:30 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-lotuss-kepong-village-lot-no.-14,-1st-floor,-lotuss-kepong-village-mall-kuala-lumpur?place=w.66584608.666042687.27399057\n",
      "latitude: 3.194423, longitude: 101.633699\n",
      "\n",
      "location name: Subway Aeon AU2\n",
      "4\n",
      "address: Aeon AU2 Shopping Center, 6, Jln 37/36 Taman Setiawangsa, Lot G49, Taman Keramat, Kuala Lumpur, 54200\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-aeon-au2-aeon-au2-shopping-center-kuala-lumpur?place=w.66715680.666829118.27413005\n",
      "latitude: 3.177185, longitude: 101.750558\n",
      "\n",
      "location name: Subway SS3\n",
      "5\n",
      "address: Jalan SS3/39, Ground Floor, Unit 16, Bangunan PJ21, Petaling Jaya, 47300\n",
      "operating hour: Monday - Saturday, 8:00 AM – 10:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/subway-ss3?place=ChIJuTzSm3VMzDERLk_bVVw9iTg\n",
      "latitude: 3.090677, longitude: 101.614668\n",
      "\n",
      "location name: Subway Festival City\n",
      "4\n",
      "address: Setapak Central Mall, Lot S-23, No. 67 Jalan Taman Ibu Kota, Taman Danau Kota, Setapak, Kuala Lumpur, 53200\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/federal-territory-of-kuala-lumpur/kuala-lumpur/subway-@-setapak-central-mall?place=ChIJ6fjTnRE4zDEReW77Yg4uqrY\n",
      "latitude: 3.204575, longitude: 101.720530\n",
      "\n",
      "location name: Subway Setapak Central Mall\n",
      "4\n",
      "address: Kl Festival City, Lot S-23, No 67 Jalan Taman Ibu Kota, Taman Danau Kota, Setapak, Kuala Lumpur, 53200\n",
      "operating hour: Monday - Sunday (10:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.205267,101.720020\n",
      "latitude: 3.205267, longitude: 101.720020\n",
      "\n",
      "location name: Subway Pavilion Bukit Jalil\n",
      "4\n",
      "address: Lot 1.40.00, Persiaran Jalil Utama, Bukit Jalil, Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 9:30 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/federal-territory-of-kuala-lumpur/kuala-lumpur/subway-@-pavilion-bukit-jalil?place=ChIJ5feNFj5LzDERnz6TuHwTHFo\n",
      "latitude: 3.050264, longitude: 101.671016\n",
      "\n",
      "location name: Subway Damansara Perdana\n",
      "5\n",
      "address: D-S-G-01, Metropolitan Square, Jalan PJU 8/1, Damansara Perdana, Petaling Jaya, 47820, Selangor\n",
      "operating hour: Monday - Friday, 8:00 AM – 10:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/subway-@-damansara-perdana-or-metropolitan-sq?place=ChIJWz04PAdPzDERiU-tHTIPyiY\n",
      "latitude: 3.166098, longitude: 101.607914\n",
      "\n",
      "location name: Subway Aeon Alpha Angle\n",
      "4\n",
      "address: AEON Alpha Angle Shopping Ctr, Lot F37A, Jalan R1, Seksyen 1, Bandar Baru Wangsa Maju, Kuala Lumpur, 53300\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/federal-territory-of-kuala-lumpur/kuala-lumpur/subway-@-aeon-alpha-angle?place=ChIJKfuHkjw4zDERcBLnlBYSXNw\n",
      "latitude: 3.201844, longitude: 101.731845\n",
      "\n",
      "location name: Subway Caltex Serdang\n",
      "4\n",
      "address: No.2, Lot.14985, Jalan SR 8/1, Taman Putra Indah, 43300, Seri Kembangan, Selangor\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://waze.com/ul?ll=3.047098,101.704403\n",
      "latitude: 3.047098, longitude: 101.704403\n",
      "\n",
      "location name: Subway Aeon Big Wangsamaju\n",
      "4\n",
      "address: Aeon Big Wangsa Maju, F1-09, First Floor, Jalan 8/27A, Section 5, Wangsa Maju, 53300 Kuala Lumpur.\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-aeon-big-wangsa-maju-f1-09,-first-floor,-aeon-big-wangsa-maju,-wangsa-maju-kuala-lumpur?place=w.66650144.666763584.27401144\n",
      "latitude: 3.196496, longitude: 101.743179\n",
      "\n",
      "location name: Subway Wangsa Walk\n",
      "4\n",
      "address: Wangsa Ave, Bandar Wangsa Maju, #9 Jalan Perdana 1, G-52, Wangsa Walk Mall, Kuala Lumpur, 53300\n",
      "operating hour: Monday - Sunday, 9:30 AM - 9:30 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-wangsa-walk-mall-g-52,-wangsa-walk-mall-kuala-lumpur?place=w.66650144.666763584.27401138\n",
      "latitude: 3.198582, longitude: 101.742206\n",
      "\n",
      "location name: Subway Kelana Jaya (KJ)\n",
      "4\n",
      "address: Suite 109b, Ground Floor, Office Tower, Kelana Park View, No.1, Jalan SS6/2, 47301 Petaling Jaya, Selangor\n",
      "operating hour: Monday - Sunday, 8:30 AM - 8:30 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/subway-kelana-jaya-or-kelana-parkview?place=ChIJRU4RwhBMzDERZ_FO9UjGJ7g\n",
      "latitude: 3.100862, longitude: 101.599716\n",
      "\n",
      "location name: Subway Giant Bandar Kinrara  - Puchong\n",
      "4\n",
      "address: Giant Hypermkt Bandar Kinrara, Lot No:G8, Lot 449, Jalan BK 5A/1, Bandar Kinrara, Puchong, 47100\n",
      "operating hour: Monday - Sunday, 9:30 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/puchong/subway-@-giant-hypermarket-bandar-kinrara?place=ChIJQWetUDxLzDERNXcKhA-KR-A\n",
      "latitude: 3.050157, longitude: 101.646321\n",
      "\n",
      "location name: Subway Shell Sunway Mentari\n",
      "4\n",
      "address: 1, Jalan PJS 8/9 (Shell) Bandar Sunway, 46000 Selangor\n",
      "operating hour: Monday - Sunday (08:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.079525,101.609623\n",
      "latitude: 3.079525, longitude: 101.609623\n",
      "\n",
      "location name: Subway Kota Damansara\n",
      "4\n",
      "address: 15-1, Jalan PJU 5/6, Dataran Sunway, Kota Damansara, Petaling Jaya, 47810\n",
      "operating hour: Monday - Sunday, 8:00 AM - 8:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/subway-@-dataran-sunway?place=ChIJjaT4bSBPzDERdko25w89Fq8\n",
      "latitude: 3.153206, longitude: 101.594907\n",
      "\n",
      "location name: Subway Lotuss Selayang\n",
      "4\n",
      "address: Lot F-18 & 18 (External) No. 1081, Jalan Ipoh Mukim Batu 51200 Kuala Lumpur\n",
      "operating hour: Monday - Sunday (10:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.222777,101.670945\n",
      "latitude: 3.222777, longitude: 101.670945\n",
      "\n",
      "location name: Subway Paradigm Mall\n",
      "4\n",
      "address: LG-33A(P), LG Floor No. 1, Jalan SS7/26A Kelana Jaya 47301 Petaling Jaya Selangor\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://waze.com/ul?ll=3.105084,101.596048\n",
      "latitude: 3.105084, longitude: 101.596048\n",
      "\n",
      "location name: Subway Tropicana Garden\n",
      "4\n",
      "address: CC-K55A, Concourse Floor, No. 2A, Persiaran Surian Tropicana Indah, 47810 Petaling Jaya, Selangor\n",
      "operating hour: Monday - Sunday (10:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.149188,101.593094\n",
      "latitude: 3.149188, longitude: 101.593094\n",
      "\n",
      "location name: Subway Caltex Bukit Indah Ampang\n",
      "4\n",
      "address: Caltex Bukit Indah, PT13887, Medan Bukit Indah, Taman Bukit Indah, 69000 Ampang, Selangor\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://waze.com/ul?ll=3.152855,101.774414\n",
      "latitude: 3.152855, longitude: 101.774414\n",
      "\n",
      "location name: Subway Ativo Plaza\n",
      "5\n",
      "address: Ativo Plaza, #1 Jalan PJU 9/1, Damansara Ave, B-G-2, Block B, Bandar Sri Damansara, Kuala Lumpur, 52200\n",
      "operating hour: Monday - Saturday, 8:30 AM – 10:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-ativo-plaza-jalan-pju-91-kuala-lumpur?place=w.66584608.665977152.5632979\n",
      "latitude: 3.196263, longitude: 101.616271\n",
      "\n",
      "location name: Subway Kepong\n",
      "4\n",
      "address: 91, Jalan Metro Barat Perdana 1, Taman Usahawan Kepong, 52100 Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 8:00 AM - 8:30 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-kepong-metro-prima?place=ChIJcyKJRLdHzDERdeFs6es6yK4\n",
      "latitude: 3.214719, longitude: 101.639538\n",
      "\n",
      "location name: Subway Syopz\n",
      "5\n",
      "address: G-5, The Boardwalk, No.2, Jalan Taylor’s, 47500 Subang Jaya, Selangor Darul Ehsan\n",
      "operating hour: Monday - Saturday, 10:00 AM – 10:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-syopz-mall-lot-lg1-7-taylor-college-lakeside-campus-subang-jaya?place=w.66584607.665977138.27399053\n",
      "latitude: 3.064467, longitude: 101.616106\n",
      "\n",
      "location name: Subway Sunway Pinnacle\n",
      "6\n",
      "address: M-01, Mezzanine Floor, The Pinnacle, Persiaran Lagoon, Bandar Sunway, 46150 Petaling Jaya, Selangor\n",
      "operating hour: Monday - Friday, 8:00 AM – 8:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/subway@sunway-pinnacle?place=ChIJQ3L-SYFMzDER_wOO4aHBkQs\n",
      "latitude: 3.070182, longitude: 101.610049\n",
      "\n",
      "location name: Subway Sunway Pyramid\n",
      "4\n",
      "address: LG2.32, Lower Ground Two, Sunway Pyramid, 3, Jalan PJS 11/15, Bandar Sunway, 47500 Petaling Jaya, Selangor\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/subway-sunway-pyramid?place=ChIJm21YdodMzDERFtdyEMzPHLI\n",
      "latitude: 3.072606, longitude: 101.607723\n",
      "\n",
      "location name: Subway Sunway Lagoon\n",
      "4\n",
      "address: Sunway Lagoon Theme Park, FB-Z-001, 3, Jalan PJS 11/11, Bandar Sunway, Petaling Jaya, 46150\n",
      "operating hour: Monday - Sunday (10:00AM - 6:00PM)Tuesday : Close\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-sunway-lagoon-sunway-lagoon-theme-park,-fb-z-001,-3-petaling-jaya?place=w.66584607.665911603.27401305\n",
      "latitude: 3.071533, longitude: 101.605323\n",
      "\n",
      "location name: Subway Sunway Medical\n",
      "4\n",
      "address: Sunway Medical Centre, Ground Floor,No. 5, Jalan Lagoon Selatan, 47500 Selangor\n",
      "operating hour: Monday - Sunday, 8:00 AM - 8:00 PM\n",
      "waze link: https://waze.com/ul?ll=3.066085,101.608626\n",
      "latitude: 3.066085, longitude: 101.608626\n",
      "\n",
      "location name: Subway Kiara Bay\n",
      "4\n",
      "address: \"Lot G-22, The Beat Kiara Bay Kepong Metropolitan Park,Jalan Lingkaran Tengah 52100 Kuala Lumpur.\"\n",
      "operating hour: Monday - Sunday (10:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.226999,101.650259\n",
      "latitude: 3.226999, longitude: 101.650259\n",
      "\n",
      "location name: Subway Taman Melati\n",
      "4\n",
      "address: No. 71-G Jalan Melati Utama 4, Taman Melati Utama, 53100 Setapak, Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 7:30 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/federal-territory-of-kuala-lumpur/kuala-lumpur/subway-taman-melati?place=ChIJO6zeoZQ5zDERd8uBXlgh8CE\n",
      "latitude: 3.222755, longitude: 101.731182\n",
      "\n",
      "location name: Subway Melawati Mall\n",
      "4\n",
      "address: L3-22, Third Floor, Melawati Mall, UP2-01, Melawati Mall, 355, Jalan Bandar Melawati, Pusat Bandar Melawati, 53100 Kuala Lumpur\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-melawati-mall-lot-l3-22-melawati-mall,-ampang-kuala-lumpur?place=w.66650144.666829121.27398467\n",
      "latitude: 3.211379, longitude: 101.748677\n",
      "\n",
      "location name: Subway Sunway U\n",
      "4\n",
      "address: No. 27 Jalan PJS 11/9, Bandar Sunway, Petaling Jaya, 46150\n",
      "operating hour: Monday - Sunday, 9:00 AM - 8:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-sunway-university-no.-27-jalan-pjs-119,-bandar-sunway,-46150-subang-jaya?place=w.66584607.665846067.26717443\n",
      "latitude: 3.067818, longitude: 101.603107\n",
      "\n",
      "location name: Subway KL East Mall\n",
      "5\n",
      "address: LG 37  , Lower Ground Floor, KL East Mall, 823 Jalan Lingkaran Tengah 2, KL Timur, 53100 Kuala Lumpur\n",
      "operating hour: Sunday – Thursday, 10:00 AM – 8:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/wilayah-persekutuan-kuala-lumpur/kuala-lumpur/subway-kl-east-mall?place=ChIJ98w9Q285zDERzcGnUTqyW_U\n",
      "latitude: 3.224754, longitude: 101.730533\n",
      "\n",
      "location name: Subway Thomson Hospital\n",
      "5\n",
      "address: GF-Unit 1109-3, 11 Jalan Teknologi PJU 5, 47810 Kota Damansara, Petaling Jaya, Selangor\n",
      "operating hour: Monday - Friday, 8:00 AM – 9:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/subway-thomson-hospital-kota-damansara?place=ChIJA8VxjANPzDERHq2EmG3gs9Q\n",
      "latitude: 3.149023, longitude: 101.578800\n",
      "\n",
      "location name: Subway Citta Mall\n",
      "4\n",
      "address: Lot F-09, 1st Floor, Citta Mall, No.1 Jln PJU 1A/48, PJU 1A, Ara Damansara, Petaling Jaya, 47301\n",
      "operating hour: Monday - Sunday, 9:30 AM - 8:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-citta-mall-unit-f-09,-citta-mall,-ara-damansara,-ara-damansara-petaling-jaya?place=w.66584607.665714999.27401586\n",
      "latitude: 3.112187, longitude: 101.579071\n",
      "\n",
      "location name: Subway Sri Gombak\n",
      "4\n",
      "address: No. G100, Jalan Prima SG3/2, Taman Prima, Sri Gombak, Kuala Lumpur, 68100\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:30 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/batu-caves/subway?place=ChIJi5BmZXtHzDER519jKGFtoFk\n",
      "latitude: 3.237666, longitude: 101.700343\n",
      "\n",
      "location name: Subway Taman Ehsan\n",
      "4\n",
      "address: No 520(GF) Jalan E3/8, Tmn Ehsan, 52100 Kepong, Selangor\n",
      "operating hour: Monday - Sunday (8:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.220409,101.622847\n",
      "latitude: 3.220409, longitude: 101.622847\n",
      "\n",
      "location name: Subway Aeon Big Subang\n",
      "4\n",
      "address: F1-23 AEON BIG, Level 1 No.3 Jalan SS 16/1,Subang Jaya, Selangor 47500\n",
      "operating hour: Monday - Sunday, 9:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-aeon-big-f1-23-aeon-big,-level-1-no.3-subang-jaya?place=w.66584607.665780532.27413993\n",
      "latitude: 3.082580, longitude: 101.588016\n",
      "\n",
      "location name: Subway Cova Square\n",
      "4\n",
      "address: G16, Cova Square Jalan Teknologi Pju5 Kota Damansara 47810 Petaling Jaya Selangor\n",
      "operating hour: Monday - Sunday, 8:00 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-cova-square-jalan-teknologi-16-petaling-jaya?place=w.66584607.665649467.17215766\n",
      "latitude: 3.147444, longitude: 101.575434\n",
      "\n",
      "location name: Subway The Grand SS15\n",
      "4\n",
      "address: G7, The Grand Subang Jaya, Jalan SS 15/8a, Ss 15, 47500 Subang Jaya, Selangor\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/subang-jaya/subway-the-grand-subang-jaya?place=ChIJJxTAK6JNzDER4MbW2WX_jG0\n",
      "latitude: 3.074415, longitude: 101.590297\n",
      "\n",
      "location name: Subway The Mines\n",
      "4\n",
      "address: Lot L1-93, Level 1, Mines Shopping Fair,Jln Dulang, Mines Resort City, Seri Kembangan, 43300\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-the-mines-shopping-mall-jalan-dulang,-l1-93-seri-kembangan?place=w.66650142.666632495.27412970\n",
      "latitude: 3.027692, longitude: 101.718905\n",
      "\n",
      "location name: Subway Shell Melati\n",
      "4\n",
      "address: PT 5729, Batu 6 1/2, Ulu Gombak, 68100 Gombak. Selangor\n",
      "operating hour: Monday - Sunday, 8:30 AM - 6:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-shell-melati-jalan-lingkaran-tengah-2,-pt5729,-shell-melati-kuala-lumpur?place=w.66650144.666632516.27398141\n",
      "latitude: 3.235291, longitude: 101.723508\n",
      "\n",
      "location name: Subway Subang Parade\n",
      "4\n",
      "address: LGC17, Lower Ground Floor, Subang Parade Shopping Centre, Jalan Kemajuan Subang, Ss 16, 47500 Subang Jaya, Selangor\n",
      "operating hour: Monday - Sunday, 9:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/subang-jaya/subway-subang-parade-mall?place=ChIJR-sOzp5NzDERyLXi0ZNbEGw\n",
      "latitude: 3.081489, longitude: 101.585103\n",
      "\n",
      "location name: Subway Petron Ukay Perdana\n",
      "4\n",
      "address: No. PT 5765, Jln Ukay Perdana, Ukay Perdana, 68000 Ampang, Selangor\n",
      "operating hour: Monday - Sunday (8:00AM - 10:00PM)\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/ampang/subway-petron-ukay-perdana?place=ChIJo0u0S085zDERqPaK5YAiCEU\n",
      "latitude: 3.197120, longitude: 101.775058\n",
      "\n",
      "location name: Subway Damansara Damai\n",
      "4\n",
      "address: G001, Seasons Square, Jalan Pju 10/3C, Damansara Damai, 47830  Petaling Jaya, Selangor\n",
      "operating hour: Monday - Sunday, 7:30 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/subway-damansara-damai-outlet?place=ChIJC3Ibl2hFzDERwxPbt2vGpi4\n",
      "latitude: 3.195960, longitude: 101.592210\n",
      "\n",
      "location name: Subway Puncak Jalil\n",
      "4\n",
      "address: 116 Jalan PUJ 3/2,Taman Puncak Jalil, Bandar Putra Permai,Seri Kembangan, 63300\n",
      "operating hour: Monday - Sunday, 9:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/seri-kembangan/subway?place=ChIJzXasDDu1zTERjmQ2GXJQHxk\n",
      "latitude: 3.020222, longitude: 101.675020\n",
      "\n",
      "location name: Subway Selayang Mall\n",
      "4\n",
      "address: Selayang Mall, GSW .5A, Ground Floor, Batu Caves, 68100\n",
      "operating hour: Monday - Sunday, 9:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-selayang-mall-5a,-ground-floor,-selayang-mall-batu-caves?place=w.66584608.666108228.27398140\n",
      "latitude: 3.237131, longitude: 101.643784\n",
      "\n",
      "location name: Subway Shell Karak\n",
      "4\n",
      "address: PT 5946, Lebuhraya Karak, 68100 Gombak, Selangor\n",
      "operating hour: Monday - Sunday, 8:30 AM - 10:30 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-lebuhraya-karak-pt-5946,-lebuhraya-karak,-68100-gombak,-selangor-kuala-lumpur?place=w.66650144.666632516.27398042\n",
      "latitude: 3.241128, longitude: 101.716156\n",
      "\n",
      "location name: Subway BTHO\n",
      "4\n",
      "address: No 5A, Ground Floor, Jalan Suarasa 8/3 Bandar Tun Hussien Onn, 43200 Cheras, Selangor Darul Ehsan\n",
      "operating hour: Monday - Sunday, 7:30 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/cheras/subway-bandar-tun-hussein-onn?place=ChIJKQ4pWYM1zDER1Z5A7QP-0XI\n",
      "latitude: 3.046735, longitude: 101.760650\n",
      "\n",
      "location name: Subway Damen\n",
      "4\n",
      "address: LG38, Lower Ground Floor Damen USJ 1 Jalan Persiaran Kewajipan USJ 1 47600 Subang Jaya\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/subang-jaya/subway-da-men?place=ChIJ9-92ti9NzDERgRUlEJ3Y8Wc\n",
      "latitude: 3.058525, longitude: 101.592670\n",
      "\n",
      "location name: Subway Mydin USJ\n",
      "4\n",
      "address: G-42 & G-43, Ground Floor,Persiaran Subang Permai, USJ 1, 47500 Subang Jaya, Selangor.\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/pj/subway-(mydin-subang-jaya-hypermarket)?place=ChIJA4PoRR5NzDERe-Q_fZOYgKM\n",
      "latitude: 3.057877, longitude: 101.592775\n",
      "\n",
      "location name: Subway Hero Puchong\n",
      "4\n",
      "address: Lot No G-13 , Hero Puchong, Lot 1, Jalan Puteri 1/1 , 43200 Puchong, Selangor.\n",
      "operating hour: Monday - Sunday, 9:00 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/puchong/subway-@-hero-market-bandar-puteri?place=ChIJVVVVVaK0zTERxDwfsn9pkkI\n",
      "latitude: 3.025863, longitude: 101.618133\n",
      "\n",
      "location name: Subway Sri Serdang\n",
      "4\n",
      "address: No 11 Jalan 18/34 Taman Sri Serdang, Seri Kembangan 43300 Selangor\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-sri-serdang-jalan-1834-11-seri-kembangan?place=w.66650142.666566957.26164017\n",
      "latitude: 3.008624, longitude: 101.713288\n",
      "\n",
      "location name: Subway Selayang 18\n",
      "4\n",
      "address: Lot 3.06, 3rd Floor vendor letter SH-15-G,Grd Floor,Selayang, Kuala Lumpur, 68000 , Batu Caves, 68100\n",
      "operating hour: Monday - Sunday, 8:00 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-selayang-18-persiaran-3-batu-caves?place=w.66650145.666173766.21949236\n",
      "latitude: 3.255174, longitude: 101.654411\n",
      "\n",
      "location name: Subway Aeon Cheras Selatan\n",
      "4\n",
      "address: F60, First Floor, ÆON Cheras Selatan, Lebuh Utama Tun Hussein Onn, Tun Hussein Onn, Cheras, Selangor\n",
      "operating hour: Monday to Sunday (10:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.033015,101.765206\n",
      "latitude: 3.033015, longitude: 101.765206\n",
      "\n",
      "location name: Subway Taipan\n",
      "4\n",
      "address: 7A, Jalan USJ 10/1j, Taipan Business Centre, 47620 Subang Jaya, Selangor\n",
      "operating hour: Monday - Sunday, 8:00 AM - 8:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-taipan-jalan-usj-101j-7-subang-jaya?place=w.66584606.665780529.2845552\n",
      "latitude: 3.047932, longitude: 101.586015\n",
      "\n",
      "location name: Subway Utropolis\n",
      "4\n",
      "address: G-B2a, Utropolis Marketplace, Jalan Kontracktor U1/14, Seksyen U1, 40150 Shah Alam, Selangor\n",
      "operating hour: Monday - Sunday, 8:30 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-utropolis-marketplace-g-b2a,-utropolis-marketplace-shah-alam?place=w.66584607.665583925.27402093\n",
      "latitude: 3.090114, longitude: 101.559864\n",
      "\n",
      "location name: Subway Star Avenue\n",
      "4\n",
      "address: Star Avenue Lifestyle Mall,  Lot No: L1-13 & L1-K2, No. 3, Jalan Zuhal U5/179, Pusat Komersial Arena Bintang,Seksyen U5, Shah Alam, 40150\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://waze.com/ul?ll=3.154583,101.553631\n",
      "latitude: 3.154583, longitude: 101.553631\n",
      "\n",
      "location name: Subway GPS\n",
      "4\n",
      "address: Petronas Green Plus Station, Plus Hwy & Sungai Besi Hwy, Lot 896, Ground Floor, QSR 3, Mukim Kajang, Hulu Langat, 43300\n",
      "operating hour: Monday - Sunday, 8:00 AM - 11:00 PM\n",
      "waze link: https://waze.com/ul?ll=3.005880,101.725544\n",
      "latitude: 3.005880, longitude: 101.725544\n",
      "\n",
      "location name: Subway Mahkota Cheras\n",
      "4\n",
      "address: 32G, Jalan Temenggung 1/9, Bandar Mahkota Cheras, 43200 Cheras, Selangor\n",
      "operating hour: Monday - Sunday, 10:00 AM - 11:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/cheras/subway-mahkota-cheras?place=ChIJMyT9PzA1zDER7wCQsKhyL2s\n",
      "latitude: 3.050916, longitude: 101.789313\n",
      "\n",
      "location name: Subway Equine Park\n",
      "4\n",
      "address: 7-G, Jalan Putra Permai 1A, Taman Equine, 43300 Seri Kembangan, Selangor.\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/seri-kembangan/subway-equine-park?place=ChIJQWbBMNO1zTERb4qKY97QGxs\n",
      "latitude: 2.996182, longitude: 101.669745\n",
      "\n",
      "location name: Subway Petronas Grand Saga 3\n",
      "1\n",
      "address: Lot 432, Lebuhraya Grand Saga, (Kajang Bound)  43300, Kajang, Selangor\n",
      "operating hour: None\n",
      "waze link: https://waze.com/ul?ll=3.025706,101.771637\n",
      "latitude: 3.025706, longitude: 101.771637\n",
      "\n",
      "location name: Subway Subang Perdana\n",
      "4\n",
      "address: No. 17-G, Jalan Dinar D U3/D, Seksyen U3, 40150 Shah Alam, Selangor\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/subang-jaya/subway-subang-perdana?place=ChIJ4cb8F1BPzDERwkdC9tagYg0\n",
      "latitude: 3.148819, longitude: 101.545546\n",
      "\n",
      "location name: Subway MSU\n",
      "4\n",
      "address: Lot S0205 Management & Science University, Seksyen 13, 40100 Shah Alam, Selangor\n",
      "operating hour: Monday - Sunday, 8:00 AM – 8:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-msu-lot-s0205,-management-and-science-university-(msu)-shah-alam?place=w.66584607.665518388.27402347\n",
      "latitude: 3.077918, longitude: 101.552916\n",
      "\n",
      "location name: Subway Sungai Buloh\n",
      "4\n",
      "address: 2390, Jalan 1A-1, Bdr Baru Sg Buloh, Seksyen U20, 40610 Shah Alam, Selangor\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/sungai-buloh/subway?place=ChIJN48KfTJFzDERqzad5XvCtwo\n",
      "latitude: 3.210350, longitude: 101.564883\n",
      "\n",
      "location name: Subway Seksyen 13\n",
      "4\n",
      "address: Tadisma Business Park, Seksyen 13, 40100 Shah Alam, Selangor\n",
      "operating hour: Monday - Sunday (9:30AM - 10:30PM)\n",
      "waze link: https://waze.com/ul?ll=3.089032,101.546357\n",
      "latitude: 3.089032, longitude: 101.546357\n",
      "\n",
      "location name: Subway Subang Bestari\n",
      "4\n",
      "address: No 4, Jalan Nova N U5/N, Seksyen U5, 40150 Shah Alam, Selangor\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-subang-bestari-jalan-nova-u5n-4-shah-alam?place=w.66519072.665518398.26851094\n",
      "latitude: 3.178129, longitude: 101.547335\n",
      "\n",
      "location name: Subway Petronas Kesas\n",
      "5\n",
      "address: Petronas Station, Lebuhraya Kesas Arah Barat KM34.5, Lebuhraya Kesas, 40000 Shah Alam, Selangor\n",
      "operating hour: Monday - Saturday, 7:30 AM – 10:00PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/subang-jaya/subway-petronas-kesas-highway-arah-barat-km34.-5?place=ChIJ9bLY5B5NzDERCu0iuXkBptY\n",
      "latitude: 3.050101, longitude: 101.563370\n",
      "\n",
      "location name: Subway NKVE\n",
      "4\n",
      "address: Lot 15385KM 15.3, (NKVE), Petronas New Klang Expressway, Damansara Bound, Sungai Buloh, 47000\n",
      "operating hour: Monday - Sunday, 10:00 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/sungai-buloh/subway?place=ChIJ4VodophOzDERaGq4H8ZxsAw\n",
      "latitude: 3.094220, longitude: 101.541431\n",
      "\n",
      "location name: Subway Main Place\n",
      "4\n",
      "address: LG33, Main Place Mall USJ, Jalan USJ 21/10, Persiaran Kewajipan, 47630 Subang Jaya, Selangor.\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/subang-jaya/subway?place=ChIJjb3QkzGzzTERYh-RwcOFeEY\n",
      "latitude: 3.026320, longitude: 101.581147\n",
      "\n",
      "location name: Subway One City\n",
      "4\n",
      "address: One City@Skypark, C-GF-01 Ground Floor, Jalan USJ 25/1, Subang Jaya, 47650\n",
      "operating hour: Monday - Sunday, 9:00 AM - 7:45 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/subang-jaya/subway?place=ChIJSx9gBCWzzTER0Qhz_gj_2QQ\n",
      "latitude: 3.021501, longitude: 101.581089\n",
      "\n",
      "location name: Subway Radia Bukit Jelutong\n",
      "4\n",
      "address: G0-23, Radia Sales Gallery, Persiaran Arked, Bukit Jelutong, 40150 Shah Alam, Selangor\n",
      "operating hour: Monday - Sunday, 7:30 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/shah-alam/subway-radia-bukit-jelutong?place=ChIJ98G9H_JNzDERRS_vEqme9_s\n",
      "latitude: 3.101122, longitude: 101.535394\n",
      "\n",
      "location name: Subway AEON BIG Puchong\n",
      "4\n",
      "address: AEON BIG Shopping Center, Lot No G04 Ground Floor, Lot 4029 Persiaran Selangor, Puchong Utama, 47100\n",
      "operating hour: Monday - Sunday, 10:00 AM - 10:00 PM\n",
      "waze link: https://ul.waze.com/ul?preview_venue_id=66584606.665911595.26934483&navigate=yes&utm_campaign=default&utm_source=waze_website&utm_medium=lm_share_location\n",
      "latitude: 2.991741, longitude: 101.615601\n",
      "\n",
      "location name: Subway Jade Hills\n",
      "1\n",
      "address: No 40-G, Jalan Jade Hills Utama 1/2, Commerce Village, Jade Hills, 43000 Kajang, Selangor.\n",
      "operating hour: None\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/kajang/subway-jade-hill?place=ChIJuRzJknvLzTERiX5pZXHT0gw\n",
      "latitude: 2.994114, longitude: 101.758669\n",
      "\n",
      "location name: Subway Sierra 16 Puchong\n",
      "4\n",
      "address: Lot 3A-1, Sierra Fresco, Jln Sierra 10/1, Bandar 16 Sierra, 47110 Puchong, Selangor.\n",
      "operating hour: Monday - Sunday (8:00AM - 10:00PM)\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/puchong/subway16sierra?place=ChIJ4cJ0tYW1zTERx74e0tVmW9g\n",
      "latitude: 2.974426, longitude: 101.655052\n",
      "\n",
      "location name: Subway IOI City Mall\n",
      "4\n",
      "address: IOI City Mall, Lebuh IRC, IOI Resort City, 62502 Putrajaya, Malaysia\n",
      "operating hour: Monday - Sunday, 10:00 AM - 9:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-ioi-city-mall-ioi-city-mall,-lebuh-irc,-ioi-resort-city,-62502-putrajaya?place=w.66650142.666566953.27400823\n",
      "latitude: 2.970663, longitude: 101.713668\n",
      "\n",
      "location name: Subway Plaza Shah Alam\n",
      "4\n",
      "address: Lot No. G 17, Ground Floor, Plaza Shah Alam, Sekysen 9, Shah Alam, 40100\n",
      "operating hour: Monday - Sunday, 9:30 AM – 09:30PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-@plaza-shah-alam-lot-g17,-plaza-shah-alam?place=w.66519071.665321780.27398400\n",
      "latitude: 3.084338, longitude: 101.523317\n",
      "\n",
      "location name: Subway Taman Prima Saujana\n",
      "4\n",
      "address: G-2A-GB, Jalan Prima Saujana 2/D, Taman Prima Saujana, 43000 Kajang, Selangor\n",
      "operating hour: Monday - Sunday, 8:00 AM - 10:00 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/kajang/subway-prima-saujana?place=ChIJ5T1_lhrNzTERznG7echZSEc\n",
      "latitude: 3.008788, longitude: 101.804503\n",
      "\n",
      "location name: Subway Denai Alam\n",
      "4\n",
      "address: Unit Ground Floor, No 7, Jalan Electron E U16/E, Seksyen U16, 40160 Shah Alam,Selangor\n",
      "operating hour: Monday - Sunday, 8:15 AM - 9:45 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/my/selangor/shah-alam/subway-denai-alam?place=ChIJ-3Els5pRzDERJRqqSNFklxg\n",
      "latitude: 3.161212, longitude: 101.511881\n",
      "\n",
      "location name: Subway Taman Sri Muda\n",
      "4\n",
      "address: No 40 (GF), Jalan Murni 25/61, Taman Sri Muda, 40400 Shah Alam, Selangor\n",
      "operating hour: Monday - Sunday (8:00AM - 10:00PM)\n",
      "waze link: https://waze.com/ul?ll=3.032726,101.536497\n",
      "latitude: 3.032726, longitude: 101.536497\n",
      "\n",
      "location name: Subway Metro Point\n",
      "4\n",
      "address: Metro Point Complex, Lot G03 Ground Floor, Jalan Jelok 8, Kajang, 43000\n",
      "operating hour: Monday - Sunday, 9:30 AM - 9:30 PM\n",
      "waze link: https://www.waze.com/en/live-map/directions/subway-metro-point-complex-metro-point-complex,-lot-g03-ground-floor-kajang?place=w.66715678.667091243.27400766\n",
      "latitude: 2.991637, longitude: 101.793722\n",
      "\n"
     ]
    }
   ],
   "source": [
    "url = 'https://subway.com.my/find-a-subway'\n",
    "\n",
    "# disable it as current version only support 114.0.5735.90\n",
    "# s = Service(os.getcwd() + \"\\\\chromedriver.exe\")\n",
    "# driver = webdriver.Chrome(service = s)\n",
    "\n",
    "driver = webdriver.Chrome()\n",
    "driver.get(url)\n",
    "\n",
    "# wait for the results to load\n",
    "# time.sleep(2)\n",
    "\n",
    "# driver.find_element(\"id\", \"fp_searchAddress\").send_keys('kuala lumpur')\n",
    "# wait for the search field to be visible and enter the search query\n",
    "search_field = WebDriverWait(driver, 10).until(EC.visibility_of_element_located((By.ID, \"fp_searchAddress\")))\n",
    "search_field.send_keys('kuala lumpur')\n",
    "\n",
    "# driver.find_element(\"id\", \"fp_searchAddressBtn\").click()\n",
    "# click the search button\n",
    "search_button = WebDriverWait(driver, 10).until(EC.element_to_be_clickable((By.ID, \"fp_searchAddressBtn\")))\n",
    "search_button.click()\n",
    "\n",
    "# wait for 10 seconds after clicking the button\n",
    "time.sleep(10)\n",
    "\n",
    "soup = BeautifulSoup(driver.page_source, 'html.parser')\n",
    "\n",
    "pattern = re.compile(r'fp_listitem fp_list_marker\\d+')\n",
    "items = soup.find_all('div', class_ = pattern, style = lambda value: value is None or 'display: none' not in value)\n",
    "sorted_items = sorted(items, key = lambda x: int(x['style'].split(':')[1].replace(';', '').strip()))\n",
    "\n",
    "print(\"total items found:\", len(items))\n",
    "print(\"total sorted items found:\", len(sorted_items))\n",
    "\n",
    "# connect to SQLite database\n",
    "conn = sqlite3.connect('database.db')\n",
    "\n",
    "# create a cursor object\n",
    "c = conn.cursor()\n",
    "\n",
    "for item in sorted_items:\n",
    "    insert_location_name, insert_address, insert_operating_hour, \\\n",
    "        insert_waze_link, insert_latitude, insert_longitude = '', '', '', '', '', ''\n",
    "\n",
    "    # check if the item is hidden just to be safe\n",
    "    if 'style' in item.attrs and 'display: none' in item['style']:\n",
    "        continue  # skip this item if it's hidden\n",
    "\n",
    "    location_left_div = item.find('div', class_ = 'location_left')\n",
    "    location_right_div = item.find('div', class_ = 'location_right')\n",
    "\n",
    "    if location_left_div:\n",
    "        h4_tag = location_left_div.find('h4')\n",
    "\n",
    "        if h4_tag:\n",
    "            insert_location_name = h4_tag.text.strip()\n",
    "            print(\"location name:\", h4_tag.text.strip())\n",
    "\n",
    "        infoboxcontent_div = location_left_div.find('div', class_ = 'infoboxcontent')\n",
    "\n",
    "        if infoboxcontent_div:\n",
    "            paragraphs = infoboxcontent_div.find_all('p', class_ = lambda x: x != 'infoboxlink')\n",
    "            # paragraphs = infoboxcontent_div.select('p:not(.infoboxlink)')\n",
    "            print(len(paragraphs))\n",
    "\n",
    "            if len(paragraphs) >= 4:\n",
    "                address = paragraphs[0].text.strip()\n",
    "                operating_hour = paragraphs[2].text.strip()\n",
    "                insert_address = address\n",
    "                insert_operating_hour = operating_hour\n",
    "                print(\"address:\", address)\n",
    "                print(\"operating hour:\", operating_hour)\n",
    "            elif len(paragraphs) == 1:\n",
    "                address = paragraphs[0].text.strip()\n",
    "                operating_hour = None\n",
    "                insert_address = address\n",
    "                insert_operating_hour = operating_hour\n",
    "                print(\"address:\", address)\n",
    "                print(\"operating hour:\", operating_hour)\n",
    "            elif len(paragraphs) == 3:\n",
    "                address = None\n",
    "                operating_hour = paragraphs[1].text.strip()\n",
    "                insert_address = address\n",
    "                insert_operating_hour = operating_hour\n",
    "                print(\"address:\", address)\n",
    "                print(\"operating hour:\", operating_hour)\n",
    "            else:\n",
    "                print(\"missed\")\n",
    "\n",
    "    if location_right_div:\n",
    "        direction_button = location_right_div.find('div', class_ = 'directionButton')\n",
    "        a_links = location_right_div.find_all('a')\n",
    "\n",
    "        if len(a_links) >= 2:\n",
    "            waze_link = a_links[1]['href'] if a_links[1]['href'] else None\n",
    "            insert_waze_link = waze_link\n",
    "            print(\"waze link:\", waze_link)\n",
    "\n",
    "    # retrieve geocoding data\n",
    "    if 'data-latitude' and 'data-longitude' in item.attrs:\n",
    "        insert_latitude = item['data-latitude']\n",
    "        insert_longitude = item['data-longitude']\n",
    "        print(f\"latitude: {item['data-latitude']}, longitude: {item['data-longitude']}\")\n",
    "        print(\"\")\n",
    "\n",
    "    # insert data into database\n",
    "    c.execute('''\n",
    "        INSERT INTO subway (location_name, address, operating_hour, waze_link, latitude, longitude)\n",
    "        VALUES (?, ?, ?, ?, ?, ?)\n",
    "    ''', (insert_location_name, insert_address, insert_operating_hour, insert_waze_link, insert_latitude, insert_longitude))\n",
    "\n",
    "driver.quit()\n",
    "\n",
    "# commit the transaction\n",
    "conn.commit()\n",
    "\n",
    "# close the connection\n",
    "conn.close()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "pytorch",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}