Difference between revisions of "FLATearthers proposal"

From Geospatial Analytics and Applications
Jump to navigation Jump to search
 
(5 intermediate revisions by the same user not shown)
Line 6: 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="Arial" color="#040F3D" size=2><b>TEAM</b></font>]]
+
[[FLATearthers  | <font face="Verdana" color="#040F3D" size=2><b>TEAM</b></font>]]
  
 
| style="background:none;" width="1%" | &nbsp;
 
| style="background:none;" width="1%" | &nbsp;
 
| 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 color="#040F3D" size=2><b>PROPOSAL</b></font>]]
+
[[FLATearthers_proposal | <font face="Verdana" color="#040F3D" size=2><b>PROPOSAL</b></font>]]
  
 
| style="background:none;" width="1%" | &nbsp;
 
| style="background:none;" width="1%" | &nbsp;
 
| 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 color="#040F3D" size=2><b>POSTER</b></font>]]
+
[[FLATearthers_poster | <font face="Verdana" color="#040F3D" size=2><b>POSTER</b></font>]]
  
 
| style="background:none;" width="1%" | &nbsp;
 
| style="background:none;" width="1%" | &nbsp;
 
| 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 color="#040F3D" size=2><b>APPLICATION</b></font>]]
+
[[FLATearthers_application | <font face="Verdana" color="#040F3D" size=2><b>APPLICATION</b></font>]]
  
 
| style="background:none;" width="1%" | &nbsp;
 
| style="background:none;" width="1%" | &nbsp;
 
| 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 color="#040F3D" size=2><b>RESEARCH PAPER</b></font>]]
+
[[FLATearthers_research| <font face="Verdana" color="#040F3D" size=2><b>RESEARCH PAPER</b></font>]]
 
|}  
 
|}  
 
</center>
 
</center>
Line 30: Line 30:
 
<!-- Body -->
 
<!-- Body -->
 
<br>
 
<br>
<!-- Project Description -->
 
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"|
 
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:24px; border-top:solid #ffffff; border-bottom:solid #040F3D" width="9999px" | Project Description
 
|}
 
 
 
 
<!-- Project Motivation -->
 
<!-- Project Motivation -->
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"|
+
<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>
  
| style="font-family:Open Sans, Arial, sans-serif; font-size:24px; border-top:solid #ffffff; border-bottom:solid #040F3D" width="9999px" | Project Motivation
+
<!-- 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:
  
<!-- Project Motivation -->
+
# Multiple linear regression
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"|
+
# Geographically weighted regression
 
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:24px; border-top:solid #ffffff; border-bottom:solid #040F3D" width="9999px" | Background
 
|}
 
  
 +
to compare and explain how the factors stated above may, affect resale housing prices.
 +
</div>
 +
<br>
  
 
<!-- Data Sources -->
 
<!-- Data Sources -->
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"|
+
<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-family:Open Sans, Arial, sans-serif; font-size:24px; border-top:solid #ffffff; border-bottom:solid #040F3D" width="9999px" | Data Sources
+
{| 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 -->
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"|
+
<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">
| style="font-family:Open Sans, Arial, sans-serif; font-size:24px; border-top:solid #ffffff; border-bottom:solid #040F3D" width="9999px" | Project Timeline
+
[[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>
  
<!-- Technical Challenges -->
 
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"|
 
  
| style="font-family:Open Sans, Arial, sans-serif; font-size:24px; border-top:solid #ffffff; border-bottom:solid #040F3D" width="9999px" | Technical Challenges
+
<!-- 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
 
|}
 
|}
 
 
<!-- Tools and Technologies -->
 
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"|
 
  
  

Latest revision as of 00:02, 15 April 2019

FLATearthers.jpeg

TEAM

 

PROPOSAL

 

POSTER

 

APPLICATION

 

RESEARCH PAPER


PROJECT MOTIVATION

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.


PROJECT DESCRIPTION

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:

  1. Multiple linear regression
  2. Geographically weighted regression

to compare and explain how the factors stated above may, affect resale housing prices.


DATA SOURCES
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
  1. data.gov.sg

Others

  1. Kopitiam
  2. Koufu
  3. Food republic
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


PROJECT TIMELINE
Timeline flatearthers.png
PROJECT STORYBOARD
Storyboard flatearthers.PNG


KEY CHALLENGES
Key Challenges Mitigation
Unfamiliarity with R and packages required for project
  1. Self-learning online through sites like Datacamp
  2. Read up
Unfamiliarity with proper approach to use for project
  1. Read up on related projects found in research databases
  2. View past projects with similar goals
Limitations of OneMap API to handle large amount of data
  1. Read up on related projects found in research databases
  2. Split up large dataset across group members and across a few days