Difference between revisions of "Homviz Homies: Proposal Version 1"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 85: Line 85:
 
# We want to filter out the residential area applicable to our analysis
 
# We want to filter out the residential area applicable to our analysis
 
|-
 
|-
−
| <center> Source <br/>
+
 
−
(url) </center>
+
| <center>HDB Resale Flat Prices<br/>
 +
(https://data.gov.sg/dataset/resale-flat-prices) </center>
 
||  
 
||  
−
* Attributes
+
* Month (YYYY-MM)
 +
* Town
 +
* Flat Type
 +
* Block
 +
* Street Name
 +
* Storey Range
 +
* Floor Area Sqm
 +
* Flat Model
 +
* Lease Commence Date
 +
* Remaining Lease
 +
* Resale Price
 +
||
 +
# We can break down the resale price of each flat and look at the average price for each model.
 +
# From the breakdown, we can also identify which flat type or storey range would produce a higher resale price compared to the original selling
 +
|-
  
 +
| <center> HDB Median Resale Prices by Town and Flat Type <br/>
 +
(https://www.hdb.gov.sg/cs/infoweb/residential/buying-a-flat/resale/resale-statistics) </center>
 +
||
 +
* Town
 +
* Year
 +
* Quarter
 +
* Room Type
 +
* Median Resale Price
 
||  
 
||  
−
# Additional Info
+
# For this dataset, we have to transform the data and crawl the data so that we can use it to compare with the min and max selling price by HDB.
 
|-
 
|-
  
 +
| <center> HDB PRICE RANGE OFFERED <br/>
 +
(https://data.gov.sg/dataset/price-range-of-hdb-flats-offered) </center>
 +
||
 +
* Financial Year
 +
* Town
 +
* Room Type
 +
* Min Selling Price
 +
* Max Selling Price
 +
* Min Selling Price Less AHG SHG
 +
* Max Selling Price Less AHG SHG
 +
||
 +
# For this data set, we can look at the Selling Price Range from HDB. We can then compare how the selling price fair from the resell price
 +
|-
 +
 +
| <center> Completion Status of HDB Developments <br/>
 +
(https://data.gov.sg/dataset/number-of-units-of-hdb-developments-by-status?view_id=2f0e2460-4d87-464d-bd1f-aafa17fac75a&resource_id=ff97dd96-6db5-4eb7-ba79-ad8d4840a3aa) </center>
 +
||
 +
* Financial Year
 +
* Property Type
 +
* Completion Status
 +
* No of Unit
 +
||
 +
# We can look at the supply of new HDB flats that the government is building every year and the number of flats completed.
 +
# From this dataset, we can then later identify if the government is supplying enough for the demand if they were to reallocate flat owners
 +
|-
 
|}
 
|}
  

Revision as of 22:31, 3 October 2018

Homeviz Homies logo.jpg


Proposal Version 1


PROBLEM & MOTIVATION

Problem In the recent years, housing prices have been on the rise making it difficult for Singaporeans to own a house. In the National Day Rally 2018, PM Mr. Lee Hsien Loong addressed to the issue of housing to Singaporean. He stated the importance of the 99-year lease of Home Ownership as compared to Singaporean renting a house. However, several older estates were built within short periods such as Marine Parade, Ang Mo Kio and Bedok when their 99-year lease has expired they will all expire at the same time and the flats will be returned to the state. The government has also been progressively taking back flats over the years for redevelopment.

Motivation There is a need to relocate residents for redevelopment such as getting another flat to live in. In response to growing demand for housing, there is a need to analyze housing supply and housing prices to gain insights on how much is enough supply of housing and how much is enough payback price for citizens to afford a new housing.


OBJECTIVES

In this project, we are interested to create a visualization that helps analysts perform the following:

  1. Identify the lease term of the HDB and highlight those that are going to reach their due year.
  2. Identify the number of units and the number of households in the HDB that will be affected by the relocation
  3. Identify the buyback price that will enable affected households to have enough lump sum to buy a new house after buyback
  4. Identify how much housing should be supplied based on the household’s affected by buyback


SELECTED DATASET

The dataset for analysis will be retrieved from multiple databases, as elaborated below:

Dataset/Source Data Attributes Rationale Of Usage
HDB Property Information
(https://data.gov.sg/dataset/hdb-property-information)
  • Block Number
  • Street
  • Max Floor
  • Year_Completed
  • Residential
  • Commercial
  • Town Contract
  • Total Dwellings Unit
  • 1 Room Sold
  • 2 Room Sold
  • 3 Room Sold
  • 4 Room Sold
  • 5 Room Sold
  • Exec Sold
  • Multigen Sold
  • Studio Sold
  • 1 Room Rental
  • 2 Room Rental
  • 3 Room Rental
  • Other Room Rental

FY(1 April - 31 March)

  1. We want to see the number of Units Sold across Singapore that are sold or rented.
  2. This information are for public HDB housing estate.
  3. The dataset contains information on how long the HDB lease left and other information about a HDB property
  4. We want to filter out the residential area applicable to our analysis
HDB Resale Flat Prices
(https://data.gov.sg/dataset/resale-flat-prices)
  • Month (YYYY-MM)
  • Town
  • Flat Type
  • Block
  • Street Name
  • Storey Range
  • Floor Area Sqm
  • Flat Model
  • Lease Commence Date
  • Remaining Lease
  • Resale Price
  1. We can break down the resale price of each flat and look at the average price for each model.
  2. From the breakdown, we can also identify which flat type or storey range would produce a higher resale price compared to the original selling
HDB Median Resale Prices by Town and Flat Type
(https://www.hdb.gov.sg/cs/infoweb/residential/buying-a-flat/resale/resale-statistics)
  • Town
  • Year
  • Quarter
  • Room Type
  • Median Resale Price
  1. For this dataset, we have to transform the data and crawl the data so that we can use it to compare with the min and max selling price by HDB.
HDB PRICE RANGE OFFERED
(https://data.gov.sg/dataset/price-range-of-hdb-flats-offered)
  • Financial Year
  • Town
  • Room Type
  • Min Selling Price
  • Max Selling Price
  • Min Selling Price Less AHG SHG
  • Max Selling Price Less AHG SHG
  1. For this data set, we can look at the Selling Price Range from HDB. We can then compare how the selling price fair from the resell price
Completion Status of HDB Developments
(https://data.gov.sg/dataset/number-of-units-of-hdb-developments-by-status?view_id=2f0e2460-4d87-464d-bd1f-aafa17fac75a&resource_id=ff97dd96-6db5-4eb7-ba79-ad8d4840a3aa)
  • Financial Year
  • Property Type
  • Completion Status
  • No of Unit
  1. We can look at the supply of new HDB flats that the government is building every year and the number of flats completed.
  2. From this dataset, we can then later identify if the government is supplying enough for the demand if they were to reallocate flat owners


BACKGROUND SURVEY OF RELATED WORKS

Some of these visualizations that we draw inspiration from, are as follows:

Reference of Other Interactive Visualization What We Can Learn

title

Source: .....
  • fill here

title

Source: ....
  • fill here


PROPOSED STORYBOARD

Our group has proposed the following storyboard to assist analysts in the use of our visual application:

  • Challenge 1
  • Challenge 2


ADDRESSING KEY TECHNICAL CHALLENGES

The following are some of the key technical challenges that we may face throughout the course of the project:

  • Challenge 1
  • Challenge 2


PROJECT TIMELINE

The following shows our project timeline for the completion of this project:

  • Insert Timeline Here


TOOLS/TECHNOLOGIES

The following are some of the tools/technologies that we will be utilizing during the project:

  • D3.js
  • Chart.js
  • Visual Studio Code
  • Microsoft Powerpoint



REFERENCES
  • Point 1
  • Point 2
  • Point 3


OUR BRAINSTORMING SESSIONS

The following are some of the proposed storyboard that we designed during our brainstorming sessions:

  • Image 1
  • Image 2
  • Image 3


COMMENTS

Feel free to comment on our project

Retrieved from ‘https://wiki.smu.edu.sg/18191is428g1/index.php?title=Homviz_Homies:_Proposal_Version_1&oldid=524’