Difference between revisions of "FLATearthers proposal"
Mswong.2016 (talk | contribs) |
|||
(8 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | + | [[File:FLATearthers.jpeg|center|1000px]] | |
− | |||
<!------ Main Navigation Bar----> | <!------ Main Navigation Bar----> | ||
<center> | <center> | ||
Line 7: | Line 6: | ||
{|style="background-color:#F7F7F7; color:#1D7372; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | {|style="background-color:#F7F7F7; color:#1D7372; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | ||
| style="padding:0.3em; font-size:100%; background-color:#F7F7F7; text-align:center; color:#F5F5F5" width="10%" | | | style="padding:0.3em; font-size:100%; background-color:#F7F7F7; text-align:center; color:#F5F5F5" width="10%" | | ||
− | [[ | + | [[FLATearthers | <font face="Verdana" color="#040F3D" size=2><b>TEAM</b></font>]] |
| style="background:none;" width="1%" | | | style="background:none;" width="1%" | | ||
| style="padding:0.3em; font-size:100%; background-color:#7DA2A9; text-align:center; color:#ff3e09" width="10%" | | | style="padding:0.3em; font-size:100%; background-color:#7DA2A9; text-align:center; color:#ff3e09" width="10%" | | ||
− | [[ | + | [[FLATearthers_proposal | <font face="Verdana" color="#040F3D" size=2><b>PROPOSAL</b></font>]] |
| style="background:none;" width="1%" | | | style="background:none;" width="1%" | | ||
| style="padding:0.3em; font-size:100%; background-color:#F7F7F7; border-bottom:0px solid #3D9DD7; text-align:center; color:#2DB0AF" width="12%" | | | style="padding:0.3em; font-size:100%; background-color:#F7F7F7; border-bottom:0px solid #3D9DD7; text-align:center; color:#2DB0AF" width="12%" | | ||
− | [[ | + | [[FLATearthers_poster | <font face="Verdana" color="#040F3D" size=2><b>POSTER</b></font>]] |
| style="background:none;" width="1%" | | | style="background:none;" width="1%" | | ||
| style="padding:0.3em; font-size:100%; background-color:#F7F7F7; border-bottom:0px solid #3D9DD7; text-align:center; color:#ff3e09" width="12%" | | | style="padding:0.3em; font-size:100%; background-color:#F7F7F7; border-bottom:0px solid #3D9DD7; text-align:center; color:#ff3e09" width="12%" | | ||
− | [[ | + | [[FLATearthers_application | <font face="Verdana" color="#040F3D" size=2><b>APPLICATION</b></font>]] |
| style="background:none;" width="1%" | | | style="background:none;" width="1%" | | ||
| style="padding:0.3em; font-size:100%; background-color:#F7F7F7; border-bottom:0px solid #3D9DD7; text-align:center; color:#ff3e09" width="10%" | | | style="padding:0.3em; font-size:100%; background-color:#F7F7F7; border-bottom:0px solid #3D9DD7; text-align:center; color:#ff3e09" width="10%" | | ||
− | [[ | + | [[FLATearthers_research| <font face="Verdana" color="#040F3D" size=2><b>RESEARCH PAPER</b></font>]] |
|} | |} | ||
</center> | </center> | ||
Line 31: | Line 30: | ||
<!-- Body --> | <!-- Body --> | ||
<br> | <br> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
<!-- Project Motivation --> | <!-- Project Motivation --> | ||
− | + | <div style="background: #C2CAD0; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Verdana">PROJECT MOTIVATION</font></div> | |
+ | <div style= "text-align: left; margin-left: 10em; margin-right: 10em; font-size: 15px"><font color=#000 face="Verdana"> | ||
+ | As Singapore government ramps up efforts to collect and share data sets to the public, various kinds of information are readily available. There are however, no readily available tools that could allow analysts who are well-versed in real estate, but do not have the coding know-how to perform analysis. Thus, our group hopes to bridge the gap and provide these analysts with a friendly user interface and experience. | ||
+ | </div> | ||
+ | <br> | ||
− | + | <!-- Project Description--> | |
− | + | <div style="background: #C2CAD0; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Verdana">PROJECT DESCRIPTION</font></div> | |
+ | <div style= "text-align: left; margin-left: 10em; margin-right: 10em; font-size: 15px"><font color=#000 face="Verdana"> | ||
+ | Our project aims to find out how external and internal factors may affect resale housing prices, specifically for HDB resale flats. External factors are, though not limited to, shopping malls, hawker centers, MRTs and LRTs, supermarkets, primary schools, pre-schools and eldercare services. Internal factors are, though not limited to, remaining lease, floor area, storey, flat type and model. | ||
+ | We will be using 2 different models: | ||
− | + | # Multiple linear regression | |
− | + | # Geographically weighted regression | |
− | |||
− | |||
− | |||
+ | to compare and explain how the factors stated above may, affect resale housing prices. | ||
+ | </div> | ||
+ | <br> | ||
<!-- Data Sources --> | <!-- Data Sources --> | ||
− | {| style="background-color:# | + | <div style="background: #C2CAD0; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Verdana">DATA SOURCES</font></div> |
− | + | <div style= "text-align: left; margin-left: 10em; margin-right: 10em; font-size: 15px"><font color=#000 face="Verdana"> | |
− | | style="font- | + | {| class="wikitable" style="background-color:#FFF; margin: 1em auto;" width="80%; font-size: 15px;" |
+ | |+ | ||
+ | |-style="font-size: 100%; | ||
+ | ! <b>Data Set</b> | ||
+ | ! <b>Source</b> | ||
+ | ! <b>Data Type/Method</b> | ||
+ | |-style="font-size: 100%; | ||
+ | | 2014 Master Plan Planning Subzone | ||
+ | | [https://data.gov.sg/dataset/resale-flat-prices?resource_id=1b702208-44bf-4829-b620-4615ee19b57c data.gov.sg] | ||
+ | | SHP | ||
+ | |-style="font-size: 100%; | ||
+ | | Resale flat prices | ||
+ | | [https://data.gov.sg/dataset/resale-flat-prices?resource_id=1b702208-44bf-4829-b620-4615ee19b57c data.gov.sg] | ||
+ | | CSV | ||
+ | |-style="font-size: 100%; | ||
+ | | Singapore Shopping malls | ||
+ | | [https://en.wikipedia.org/wiki/List_of_shopping_malls_in_Singapore Wikipedia] | ||
+ | | Text to SHP | ||
+ | |-style="font-size: 100%; | ||
+ | | Singapore Hawker Centers | ||
+ | | Hawker Centres <br> | ||
+ | # [https://data.gov.sg/dataset/hawker-centres?resource_id=c2e33097-4f46-4ef5-91db-64eef290ca85 data.gov.sg] <br><br> | ||
+ | Others <br> | ||
+ | # [http://www.kopitiam.biz/search-results/?keywords&zone=allzone&FC=yes&search=Search Kopitiam] | ||
+ | # [https://www.koufu.com.sg/our-brands/food-halls/koufu Koufu] | ||
+ | # [https://foodrepublic.com.sg/food-republic-outlets/ Food republic] | ||
+ | | KML | ||
+ | |-style="font-size: 100%; | ||
+ | | MRT / LRT Stations | ||
+ | | [https://www.mytransport.sg/content/mytransport/home/dataMall/static-data.html LTA Datamall] | ||
+ | | SHP | ||
+ | |-style="font-size: 100%; | ||
+ | | Supermarkets | ||
+ | | [https://en.wikipedia.org/wiki/List_of_shopping_malls_in_Singapore Wikipedia] | ||
+ | | Text to SHP | ||
+ | |-style="font-size: 100%; | ||
+ | | Primary Schools | ||
+ | | [https://data.gov.sg/dataset/school-directory-and-information Primary Schools] | ||
+ | | CSV | ||
+ | |-style="font-size: 100%; | ||
+ | | Premium Primary Schools | ||
+ | | [https://elite.com.sg/primary-schools Premium Primary Schools] | ||
+ | | Text to SHP | ||
+ | |-style="font-size: 100%; | ||
+ | | Premium Pre-schools | ||
+ | | [https://skoolopedia.com/preschool-singapore-infographic/ Pre-Schools] | ||
+ | | Text to SHP | ||
|} | |} | ||
− | + | </div> | |
+ | <br> | ||
<!-- Project Timeline --> | <!-- Project Timeline --> | ||
− | + | <div style="background: #C2CAD0; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Verdana">PROJECT TIMELINE</font></div> | |
− | + | <div style= "text-align: left; margin-left: 10em; margin-right: 10em; font-size: 15px"><font color=#000 face="Verdana"> | |
− | + | [[File:Timeline flatearthers.png|frameless|center|1000px]] | |
− | + | </div> | |
+ | <!-- Project Storyboard --> | ||
+ | <div style="background: #C2CAD0; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Verdana">PROJECT STORYBOARD</font></div> | ||
+ | <div style= "text-align: left; margin-left: 10em; margin-right: 10em; font-size: 15px"><font color=#000 face="Verdana"> | ||
+ | [[File:Storyboard flatearthers.PNG|frameless|center|1000px]] | ||
+ | </div> | ||
− | |||
− | |||
− | + | <!-- Key Challenges --> | |
+ | <div style="background: #C2CAD0; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Verdana">KEY CHALLENGES</font></div> | ||
+ | {| class="wikitable" style="background-color:#FFF; margin: 1em auto;" width="80%; font-size: 15px;" | ||
+ | |+ | ||
+ | |-style="font-size: 100%; | ||
+ | ! <b>Key Challenges</b> | ||
+ | ! <b>Mitigation</b> | ||
+ | |-style="font-size: 100%; | ||
+ | | Unfamiliarity with R and packages required for project | ||
+ | | | ||
+ | #Self-learning online through sites like Datacamp | ||
+ | #Read up | ||
+ | |-style="font-size: 100%; | ||
+ | | Unfamiliarity with proper approach to use for project | ||
+ | | | ||
+ | #Read up on related projects found in research databases | ||
+ | #View past projects with similar goals | ||
+ | |-style="font-size: 100%; | ||
+ | | Limitations of OneMap API to handle large amount of data | ||
+ | | | ||
+ | #Read up on related projects found in research databases | ||
+ | #Split up large dataset across group members and across a few days | ||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
Latest revision as of 00:02, 15 April 2019
As Singapore government ramps up efforts to collect and share data sets to the public, various kinds of information are readily available. There are however, no readily available tools that could allow analysts who are well-versed in real estate, but do not have the coding know-how to perform analysis. Thus, our group hopes to bridge the gap and provide these analysts with a friendly user interface and experience.
Our project aims to find out how external and internal factors may affect resale housing prices, specifically for HDB resale flats. External factors are, though not limited to, shopping malls, hawker centers, MRTs and LRTs, supermarkets, primary schools, pre-schools and eldercare services. Internal factors are, though not limited to, remaining lease, floor area, storey, flat type and model.
We will be using 2 different models:
- Multiple linear regression
- Geographically weighted regression
to compare and explain how the factors stated above may, affect resale housing prices.
Data Set | Source | Data Type/Method |
---|---|---|
2014 Master Plan Planning Subzone | data.gov.sg | SHP |
Resale flat prices | data.gov.sg | CSV |
Singapore Shopping malls | Wikipedia | Text to SHP |
Singapore Hawker Centers | Hawker Centres Others |
KML |
MRT / LRT Stations | LTA Datamall | SHP |
Supermarkets | Wikipedia | Text to SHP |
Primary Schools | Primary Schools | CSV |
Premium Primary Schools | Premium Primary Schools | Text to SHP |
Premium Pre-schools | Pre-Schools | Text to SHP |
Key Challenges | Mitigation |
---|---|
Unfamiliarity with R and packages required for project |
|
Unfamiliarity with proper approach to use for project |
|
Limitations of OneMap API to handle large amount of data |
|