Difference between revisions of "Group01 Proposal"

From Visual Analytics and Applications
Jump to navigation Jump to search
(Blanked the page)
Tag: Blanking
(Undo revision 5071 by Kxzhang.2017 (talk))
Tag: Undo
Line 1: Line 1:
  
 +
== Overview ==
 +
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? 
 +
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. 
 +
 +
<br>
 +
 +
== Project Objectives ==
 +
 +
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. 
 +
 +
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. 
 +
 +
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:
 +
* Availability of & proximity to MRT and buses
 +
* Availability of & proximity to car parks
 +
* Proximity to HDB blocks as a proxy for population
 +
* Hawker stall size and type
 +
 +
 +
== 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]

Revision as of 12:00, 22 November 2018

Overview

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. [1]. 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? 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.


Project Objectives

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.

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.

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:

  • Availability of & proximity to MRT and buses
  • Availability of & proximity to car parks
  • Proximity to HDB blocks as a proxy for population
  • Hawker stall size and type


Critique of Existing Sites

1. 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. 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.

The metadata table of our main working file is shown below.

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


Timeline

G1-ProjectTimeline.png

Tools & Packages

  • R
  • GWModel
  • Shiny
  • Ggplot
  • Leaflet
  • Tidyverse
  • Readxl
  • Scales
  • Ggrepel
  • Plotly


References

Retrieved from ‘https://wiki.smu.edu.sg/18191isss608g1/index.php?title=Group01_Proposal&oldid=5226’