Difference between revisions of "FLATearthers proposal"

From Geospatial Analytics and Applications
Jump to navigation Jump to search
Line 59: Line 59:
 
|-style="font-size: 100%;
 
|-style="font-size: 100%;
 
! <b>Data Set</b>
 
! <b>Data Set</b>
! <b>Format</b>
+
! <b>Source</b>
! <b>Attribute</b>
+
! <b>Data Type/Method</b>
 
|-style="font-size: 100%;
 
|-style="font-size: 100%;
| [https://data.gov.sg/dataset/resale-flat-prices?resource_id=1b702208-44bf-4829-b620-4615ee19b57c HDB Resale Value]
+
| 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
 
| CSV
|
 
*  Month
 
*  Town
 
*  Flat Type
 
*  Block
 
*  Street Name
 
*  Storey Range
 
*  Floor Area
 
*  Remaining Lease (Years)
 
*  Resale Price
 
 
|-style="font-size: 100%;
 
|-style="font-size: 100%;
| [https://en.wikipedia.org/wiki/List_of_shopping_malls_in_Singapore Shopping malls]
+
| Singapore Shopping malls
| csv
+
| [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] <br><br>
 +
# [https://www.koufu.com.sg/our-brands/food-halls/koufu Koufu] <br><br>
 +
# [https://foodrepublic.com.sg/food-republic-outlets/ Food republic] <br><br>
 +
| 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%;
 
|-style="font-size: 100%;
| [https://en.wikipedia.org/wiki/List_of_Singapore_MRT_stations MRT/LRT]
+
| Supermarkets
| csv
+
|  
| -
+
|  
 
|-style="font-size: 100%;
 
|-style="font-size: 100%;
 
| Primary Schools
 
| Primary Schools
| csv (General-information-of-schools.csv Hands-On Ex 3)
 
 
|  
 
|  
* school_name
+
|
* postal_code
 
 
|-style="font-size: 100%;
 
|-style="font-size: 100%;
| [https://docs.onemap.sg/#authentication-service-post Secondary schools]
+
| Premium Primary Schools
| csv (General-information-of-schools.csv Hands-On Ex 3)
+
|  
 
|  
 
|  
* school_name
 
* postal_code
 
 
|-style="font-size: 100%;
 
|-style="font-size: 100%;
| [http://www.polytechnic.edu.sg JCs and Polytechnics]
+
| Premium Pre-schools
| csv (General-information-of-schools.csv Hands-On Ex 3)
 
 
|  
 
|  
* school_name
+
|
* postal_code
 
|-style="font-size: 100%;
 
| [https://en.wikipedia.org/wiki/List_of_hospitals_in_Singapore Hospitals]
 
| csv
 
| -
 
|-style="font-size: 100%;
 
| [https://data.gov.sg/dataset/hawker-centres Hawker Centres]
 
| csv
 
| -
 
 
|}
 
|}
 
</div>
 
</div>

Revision as of 01:21, 8 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
Primary Schools
Premium Primary Schools
Premium Pre-schools


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