|
|
| Line 1: |
Line 1: |
| | + | <!--MAIN HEADER --> |
| | + | <div style="background-color:#242176;"> |
| | | | |
| − | == Overview == | + | [[File:Group 11.png|200px|left]]<br> |
| − | Hawker centres are a staple in the Singapore food scene. In July 2018, there was a bid of $10,028 monthly rental for a drinks stall at Chomp Chomp Food Centre. [https://www.straitstimes.com/singapore/10028-monthly-rental-bid-for-chomp-chomp-hawker-stall-highest-in-3-years-bidder-walked]. The hawker in question has since ended the tenancy agreement, but this has led us to wonder: do hawkers know what is the market rate for hawker stalls and do they know how much to bid?
| + | <font size = 6; color = #ffffff><span style="font-family:Helvetica;"><b>Unlock a Bike Unlock New York</b><br></span></font> |
| − | NEA manages and regulates 114 public hawker centres in Singapore. Every month, NEA puts up vacant stalls at various hawker centres for tender, which are then awarded to the highest bidders. Aspiring hawkers will need to submit a tender bid for a selected stall. If they are the winning bidder, they have a license to operate the stall for 3 years, after which they may need to renew or bid for a stall again. Bidders who fail to sign the Tenancy Agreement after being awarded the stall will have their deposit forfeited and be debarred from participating in all future government tenders. Therefore, it is important for bidders to know what is a ‘fair’ market rate to pay for their stall, as well as what is sustainable for their business.
| + | <font size = 3; color = #ffffff><span style="font-family:Helvetica;"><b>Visual Analysis of Citi Bike Data of New York City</b></span></font> |
| | + | <br><br> |
| | + | </div> |
| | | | |
| − | <br> | + | <!--NAV BAR --> |
| | + | {|style= background-color:"#242176"; width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" border-width="10"| |
| | | | |
| − | == Project Objectives == | + | | style="font-family:’Helvetica’,font-size:100%; solid:#0433ff; background:#3d8fd1; text-align:center;" width="16%" | |
| | + | ; |
| | + | [[Group11_Overview| <font color="#FFFFFF">Overview</font>]] |
| | + | |
| | + | | style="font-family:’Helvetica’, font-size:100%; solid #0433ff; background:#242176; text-align:center;" width="16%" | |
| | + | ; |
| | + | [[Group11_Proposal|<font color="#FFFFFF">Proposal</font>]] |
| | | | |
| − | Although information on past rentals are publicly available on NEA’s website, it is not in a form that is easily accessible to users. Our project aims to understand hawker centre rentals by visualising the rental price trends of different hawker centres, and to analyse the factors that affect stall rentals.
| + | | style="font-family:’Helvetica’, font-size:100%; solid #0433ff; background:#3d8fd1; text-align:center;" width="16%" | |
| | + | ; |
| | + | [[Group11_Poster| <font color="#FFFFFF">Poster</font>]] |
| | | | |
| − | Our group aims to build an app to allow users to explore Singapore’s public hawker centre rental data. Users will be able to view price trends, and lookup prices of hawker stall rentals in the selected hawker centre. Users may be able to use our app to see if their rental bid price is within the market range for the type of stalls in their desired market.
| + | | style="font-family:’Helvetica’, font-size:100%; solid #0433ff; background:#3d8fd1; text-align:center;" width="16%" | |
| − | | + | ; |
| − | More advanced users can use our app to view a geo-weighted regression to understand how locations and different variables affect the rental price of the hawker stalls. The variables include:
| + | [[Group11_Application| <font color="#FFFFFF">Application</font>]] |
| − | * Availability of & proximity to MRT and buses
| + | |
| − | * Availability of & proximity to car parks
| + | | style="font-family:’Helvetica’, font-size:100%; solid #0433ff; background:#3d8fd1; text-align:center;" width="16%" | |
| − | * Proximity to HDB blocks as a proxy for population
| + | ; |
| − | * Hawker stall size and type
| + | [[Group11_Report| <font color="#FFFFFF">Report</font>]] |
| − | | + | |
| − | | |
| − | == Critique of Existing Sites ==
| |
| − | | |
| − | 1. [https://www.sgcharts.com/hawker-rental SG Charts] shows a visualisation of hawker stall centre rentals from 2012 – mid 2015. It shows a trellis chart of the min, median and max rentals and rental per square metre for 3 main categories of stalls in each hawker centre. However, it does not show the overall trend for different stalls across Singapore and users have to search for their target hawker centre.
| |
| − | | |
| − | 2. [https://www.ichefpos.com/en-sg/blog/how-much-does-it-cost-to-rent-a-hawker-stall-in-singapore iChef Club SG] shows a range of rentals and the price trends at selected popular hawker centres, for the cooked food stalls only.
| |
| − | | |
| − | Both sites are meant to be static and do not allow for interactivity.
| |
| − | | |
| − | | |
| − | == Data Source and Overview == | |
| − | | |
| − | Our project uses data from published tender notice on the National Environmental Agency 's website as well as information retrieved various publicly available and personal sources. Special credits to Prof. Kam Tin Seong for providing us a list of geocoded HDB postal code as one of the parameters for our project. <br/>
| |
| − | | |
| − | The metadata table of our main working file is shown below. <br/>
| |
| − | | |
| − | {| class="wikitable"
| |
| − | |-
| |
| − | ! Column !! Description !! Example !! Data Source
| |
| − | |-
| |
| − | | HAWKER_CENTRE || Name of hawker centre || AMOY STREET FOOD CENTRE || NEA "LIST OF 5 HIGHEST TENDER BIDS"
| |
| − | |- | |
| − | | STALL_NO || Unit number of stall || 01-66B || NEA "LIST OF 5 HIGHEST TENDER BIDS"
| |
| − | |-
| |
| − | | STALL_AREA || Size of stall (sqm) || 5.65 || NEA "TENDER BIDS FOR HAWKER STALLS FROM MARCH 2012 TO SEPTEMBER 2018" | |
| − | |-
| |
| − | | TRADE || Example || Example || Example
| |
| − | |-
| |
| − | | TRADE_GENERIC || Example || Example || Example
| |
| − | |-
| |
| − | | TENDERED_BID || Example || Example || Example
| |
| − | |-
| |
| − | | AVERAGE_BID_PRICE || Example || Example || Example
| |
| − | |-
| |
| − | | MONTH || Example || Example || Example
| |
| − | |-
| |
| − | | YEAR || Example || Example || Example
| |
| − | |-
| |
| − | | DATE || Example || Example || Example
| |
| − | |-
| |
| − | | TYPE_OF_STALL|| Example || Example || Example
| |
| − | |-
| |
| − | | POSTAL CODE || Example || Example || Example
| |
| − | |-
| |
| − | | LAT || Example || Example || Example
| |
| − | |-
| |
| − | | LONG || Example || Example || Example
| |
| − | |-
| |
| − | | BID_PRICE_PER_SQM || Example || Example || Example
| |
| − | |-
| |
| − | | LAST_RENOVATION || Example || Example || Example
| |
| − | |-
| |
| − | | AGE_OF_HAWKER || Example || Example || Example
| |
| − | |-
| |
| − | | TYPE_OF_UPGRADING || Example || Example || Example
| |
| | |} | | |} |
| − |
| |
| − | <br/>
| |
| − |
| |
| − | == Timeline ==
| |
| − |
| |
| − | [[File: G1-ProjectTimeline.png|700px]]
| |
| − |
| |
| − | == Tools & Packages ==
| |
| − |
| |
| − | * R
| |
| − | * GWModel
| |
| − | * Shiny
| |
| − | * Ggplot
| |
| − | * Leaflet
| |
| − | * Tidyverse
| |
| − | * Readxl
| |
| − | * Scales
| |
| − | * Ggrepel
| |
| − | * Plotly
| |
| − |
| |
| − |
| |
| − | == References ==
| |
| − |
| |
| − | * Brunsdon, C. (2015, August 18). [https://rpubs.com/chrisbrunsdon/101305 Geographically Weighted Regression]. Retrieved from RPubs.
| |
| − | * Brunsdon, C. (2015, Aug 10). [https://rpubs.com/chrisbrunsdon/99667 Geographically Weighted Summary Statistics]. Retrieved from RPubs.
| |
| − | * Dennett, A. (2014, November 17). An Introduction to Geographically Weighted Regression in R. Retrieved from RPubs.
| |
| − | * Gollini, I., Lu, B., Charlton, M., Brunsdon, C., & Harris, P. (2015). GWmodel: An R Package for Exploring Spatial Heterogeneity Using Geographically Weighted Models. JournalofStatisticalSoftware.
| |
| − | * Lu, B. (2018, 08 20). [http://gwr.maynoothuniversity.ie/ Geographically-Weighted Models. Retrieved from Package GWmodel]
| |
| − | * Tender Notices (2018). Retrieved from [https://www.nea.gov.sg/corporate-functions/resources/tender-notices The National Environmental Agency]
| |
