|
|
| (24 intermediate revisions by 2 users not shown) |
| Line 4: |
Line 4: |
| | {| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"| | | {| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"| |
| | | | |
| − | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #000000" width="190px" | | + | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #00A4EF" width="190px" | |
| | [[NeighbourhoodWatchDocs|<font color="#3c3c3c"><strong>HOME</strong></font>]] | | [[NeighbourhoodWatchDocs|<font color="#3c3c3c"><strong>HOME</strong></font>]] |
| | | | |
| − | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #000000" width="210px" | | + | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="190px" | |
| | + | [[NeighbourhoodWatchDocs_Proposal|<font color="#3c3c3c"><strong>PROPOSAL</strong></font>]] |
| | + | |
| | + | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="210px" | |
| | [[NeighbourhoodWatchDocs_Poster|<font color="#3c3c3c"><strong>POSTER</strong></font>]] | | [[NeighbourhoodWatchDocs_Poster|<font color="#3c3c3c"><strong>POSTER</strong></font>]] |
| | | | |
| − | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #000000" width="230px" | | + | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="230px" | |
| | [[NeighbourhoodWatchDocs_Project_Application|<font color="#3c3c3c"><strong>APPLICATION</strong></font>]] | | [[NeighbourhoodWatchDocs_Project_Application|<font color="#3c3c3c"><strong>APPLICATION</strong></font>]] |
| | | | |
| − | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #000000" width="230px" | | + | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="230px" | |
| | [[NeighbourhoodWatchDocs_Research_Paper|<font color="#3c3c3c"><strong>RESEARCH PAPER</strong></font>]] | | [[NeighbourhoodWatchDocs_Research_Paper|<font color="#3c3c3c"><strong>RESEARCH PAPER</strong></font>]] |
| | | | |
| Line 22: |
Line 25: |
| | <br><br> | | <br><br> |
| | | | |
| − | <div><h1>GROUP MEMBERS</h1></div>
| + | <div style="background: #00A4EF; padding: 20px; line-height: 0.3em; text-indent: 16px;letter-spacing:0.1em;font-size:26px"><font color=#fbfcfd face="Bebas Neue">PROJECT MEMBERS</font></div> |
| − | <div>Debbie Lee Shan Ying | Goh Chun Ming | Tan Guan Ze</div>
| + | <br> |
| − | | + | [[File:NeighbourhoodWatchDocs TeamMembers.JPG|center|800px]] |
| − | <div><h1>PROJECT DESCRIPTION</h1></div>
| |
| − | <div>Our project aims to make use of geospatial intelligence to explore the potential of allocating nearby doctors within estates to the residents, in particular the elderly to combat the issues of an ageing population. </div>
| |
| − | | |
| − | <div><h1>DATA COLLECTION</h1></div>
| |
| − | <div>To achieve our project objectives, it is necessary for us to obtain the datasets that is available online for use. The following table depicts the list of datasets we require and how we can obtain them:<div>
| |
| − | <div style="margin:0px; padding: 10px; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left"> | |
| − | {| class="wikitable" style="background-color:#FFFFFF;" width="100%"
| |
| − | |-
| |
| − | |
| |
| − | <b>No.</b>
| |
| − | ||
| |
| − | <b>Dataset</b>
| |
| − | ||
| |
| − | <b>Description</b>
| |
| − | ||
| |
| − | <b>Source(s)</b>
| |
| − | |-
| |
| − | |
| |
| − | 1.
| |
| − | ||
| |
| − | Singapore Planning Subzone (MP14_SUBZONE_WEB_PL)
| |
| − | ||
| |
| − | This dataset is necessary for us to be able to plot the Singapore map out at a planning subzone level.
| |
| − | ||
| |
| − | Included in our In-Class and Take-Home exercises
| |
| − | |-
| |
| − | |
| |
| − | 2.
| |
| − | ||
| |
| − | Singapore Population by Planning Area/Subzone
| |
| − | ||
| |
| − | This dataset is necessary for us to filter out the elderly population and subsequently join it with the Subzone attributes of other datasets.
| |
| − | ||
| |
| − | Included in our In-Class and Take-Home exercises
| |
| − | |-
| |
| − | |
| |
| − | 3.
| |
| − | ||
| |
| − | Singapore Population by Type of Dwelling
| |
| − | ||
| |
| − | This dataset is necessary for us to find out the total number of elderly population in a specific Subzone, so that we are able to locate the mature estates in Singapore.
| |
| − | ||
| |
| − | Included in our In-Class and Take-Home exercises
| |
| − | |-
| |
| − | |
| |
| − | 4.
| |
| − | ||
| |
| − | Total Number of Neighborhood Clinics in Singapore
| |
| − | ||
| |
| − | This dataset is necessary for us to locate all the neighborhood clinics in Singapore and find out which Subzone they belong to, so as to aid in our proximity analysis with the dwellings.
| |
| − | | |
| − | As this data is not readily available to us, we will need to perform web scraping to "scrape" the data off the Singapore YellowPages website. A Python script can help us achieve the following and more details can be found below.
| |
| − | ||
| |
| − | https://www.yellowpages.com.sg/
| |
| − | |}
| |
| − | </div> | |
| − | {| class="wikitable"
| |
| − | |-
| |
| − | ! Code Snippet 1 !! Code Snippet 2
| |
| − | |-
| |
| − | | [[File:NeighbourhoodWatchDocs Scraper1.png|thumb]] || [[File:NeighbourhoodWatchDocs Scraper2.png|thumb]]
| |
| − | |}
| |
| − | <div>The code snippets above shows how we can perform web scraping using a Python script. The script mainly does the following in a nutshell:
| |
| − | 1. Visit through each page of the YellowPages Singapore's clinics results in a loop.</br>
| |
| − | 2. Make use of XPATH expressions to retrieve the content (clinic name, address, latitude and longitude) located at specific HTML attributes.</br>
| |
| − | 3. Check whether the retrieved clinic info is a Dental clinic, if yes we will SKIP the result, if not we will proceed to save it.</br>
| |
| − | 4. When all pages are visited, the retrieved clinics information will be parsed and stored into a .CSV file with the respective columns.</br>
| |
| − | </div>
| |
| − | | |
| − | <div><h1>PROJECT TIMELINE</h1></div>
| |
| − | [[File:NeighbourhoodWatchDocs Timeline.jpg|center|800px]] | |
| | | | |
| − | <div><h1>PROJECT CHALLENGES</h1></div> | + | <!-- END OF PROJECT MEMBERS ---> |
| − | <div style="margin:0px; padding: 10px; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left">
| |
| − | {| class="wikitable" style="background-color:#FFFFFF;" width="100%"
| |
| − | |-
| |
| − | |
| |
| − | <b>No.</b>
| |
| − | ||
| |
| − | <b>Key Technical Challenges</b>
| |
| − | ||
| |
| − | <b>Description</b>
| |
| − | ||
| |
| − | <b>Proposed Solution</b>
| |
| − | ||
| |
| − | <b>Outcome</b>
| |
| − | |-
| |
| − | |
| |
| − | 1.
| |
| − | ||
| |
| − | Unfamiliarity with R packages and R Shiny
| |
| − | ||
| |
| − | Our team may encounter the use of additional R resources that were not taught in class.
| |
| − | ||
| |
| − | - Independent Learning on R packages and R Shiny<br>
| |
| − | - Browsing the official RDocumentation website for support and reference<br>
| |
| − | - Research for online tutorials that have a specific use case for certain R packages
| |
| − | ||
| |
| − | We managed to solve the mentioned challenge with the following resources:<br>
| |
| − | -
| |
| − | |-
| |
| − | |
| |
| − | 2.
| |
| − | ||
| |
| − | Data Cleaning and Transformation
| |
| − | ||
| |
| − | As we need to collect the data from various sources, they may have different attributes such as the Coordinate Reference System (CRS), units of measurement and etc.
| |
| − | ||
| |
| − | Adopt a standardized process of cleaning the data, focusing with what we only need. Most of the datasets used for our project can be found in our Hands-On or Take-Home exercises and we can rely on those existing data.
| |
| − | ||
| |
| − | We managed to solve our technical challenge with the following:<br>
| |
| − | - | |
| − | |-
| |
| − | |
| |
| − | 3.
| |
| − | ||
| |
| − | Limitations & Constraints in Datasets
| |
| − | ||
| |
| − | There are certain assumptions that we need to make based on the context and purpose of our project, such as the average number of doctors in a particular clinic, which cannot be derived from our datasets.
| |
| − | ||
| |
| − | Working out with the team together and figuring out a reasonable and valid assumption, together with adequate online research and consultation with Prof. Kam.
| |
| − | ||
| |
| − | We managed to solve our technical challenge with the following:<br>
| |
| − | - | |
| − | |}
| |
| − | </div>
| |
