Homviz Homies: Proposal Version 1

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Homeviz Homies logo.jpg


Proposal


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 : Property prices and household income over the years

Related Works Line Graph.jpg

Source: https://sbr.com.sg/residential-property/exclusive/10-charts-prove-singapore-propertys-down-in-doldrums

  • The use of time series chart allows users to view the rise and fall of prices and prevents users from getting overwhelmed by too much cluttered data as compared to using bar charts.

Title : An Animated Time-Lapse Visualization

Related Works Animated nodes Map.png

Source: https://medium.com/@wojiefu/hdb-pusle-visualization-of-singapore-hdb-flat-resale-records-2e2fbedbee91

  • We can learn from this animation the temporal transition of the data points.
  • We can see the evolution of the data points for example in our case we can show the time transition for the lease end date. User will be able to see the change of the node from green to red if the lease is ending soon.

Title : Interactive Map

Related Works Interactive Filter Map.jpg

Source: https://wiki.smu.edu.sg/is480/IS480_Team_wiki%3A_2015T2_REALIS_Project_Overview

  • What we can learn on this project is the use of cross filtering to provide an interactive filtering of data.
  • The charts on the map will zoom into the details based on the user’s filter preference.

Title : Area Shading Map

Related Works Geospatial Heatmap.jpg

Source:http://www.viz.sg/viz/map_housing/

  • Area shading map allows us to quickly see which area has more HDB flats of which type.
  • We can also understand that there are new areas and drawing of boundary changes across the years.
  • There is also the information at a glance at the side for the users to view.

Title : Bar chart and Box plot

Related Works Bar Chart and Box Plot.png.jpg

Source: https://public.tableau.com/profile/priyadarsan.shankar#!/vizhome/Singapore4-ROOMHDBresalepricesvisualization/HDBdashboard

  • Data is sorted in descending order, making sure that the viewer will be able to have quick inference.

Title : Interactive Zoom Map

Interactive Zoom in Map.jpg

Source: https://lhuasheng.carto.com/builder/b897e86d-e394-4fb5-ac8a-b00d179b1c67/embed

  • Interactive map allows viewers to see the data at a quick glance, the viewer is able to zoom into the data that they are interested in. This allows the creator to convey a lot of geospatial data without overloading the user.

PROPOSED STORYBOARD

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

Proposed Layout What can we Analyse

Analyze the lease due by subzones by year

Homeviz Homies Storyboard Map.png
  • Firstly, we present an overview of Singapore Map to display the “age” of HDB in Singapore
  • By using different intensity, we can identify the remaining Lease Years all over Singapore by the different dimensions, by Town, Sector and Area.

A line graph of the number of houses supplied vs the number of houses reclaimed over the years

Homeviz Homies Storyboard Line Chart.png
  • From the number of HDBbuild and the number of HDB expiring, we can then look at the trend if we have enough supply to catch up on our demand.

Box plot of housing price by flat types

Homeviz Homies Storyboard Box plot.png
  • Using a Box Plot, we can show that the Min, Max and Median price of Resale Flat across Flat Type.
  • This would give us a better estimate of how we should expect for a buyback price if government would to buyback the flat before the lease ends
  • We could break it down to look at the transactional resale price by their remaining lease year

Bar Chart of Number of Room types by dwelling

Barchart num dwelling units.JPG
  • Using a bar chart, we can show the number of each room types across the dwelling.
  • This would give us a better estimate of how many households of each room type will be affected


ADDRESSING KEY TECHNICAL CHALLENGES

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

Key Technical Challenge Proposed Solution

Unfamiliarity of Visualization Tool Usage

  • Independent learning on visualization tools
  • Peer Learning

Data Cleaning and Transformation

  • Need to crawl data like postal codes and areas codes missing from dataset
  • Clean, transform and analyze data together

Unfamiliar with Javascript and Rshiny Libraries

  • Attend R shiny Workshop
  • Independent learning via online tutorial


PROJECT TIMELINE

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

VA Proj Timeline V5.png


Gantt Chart Timeline.JPG

TOOLS/TECHNOLOGIES

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

Technologies Homeviz Homies.JPG


REFERENCES


OUR BRAINSTORMING SESSIONS

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

Brainstorm Session.JPG
  • [1] Map of Singapore that the users are able to choose to filter by subzones or by individual dwellings. There will also be a timeline slider at the bottom of the Map. This will enable the users to pick a particular year. The map will change to show which dwelling's lease year is going to hit it's expiry mark
  • [2] This will contain information at a glance of the dwellings of the user's choice such as number of households, number of units, the subzone etc.
  • [3] The box plot will contain the transactional price of resale flats of each room type (1 room, 2 room, 3 room etc) in the dwelling. This will be based on what the user has clicked in the map.
  • [4] A line graph of the number of houses supplied vs the number of houses reclaimed over the years.
  • [5] A radar chart to show the distribution of the number of room types by the chosen area sector.
  • [6] A bar chart of the number of dwelling by room type and area number.

After meeting with professor, we have decided to brainstorm again on what kind of charts should we be plotting and have come out with the following:

Brainstorm V2.jpg
  • [1] Map of Singapore that the users are able to choose to filter by newtown or by individual dwellings. There will also be a timeline slider at the bottom of the Map. This will enable the users to pick a particular year. The map will change to show which dwelling's lease year is going to hit it's expiry mark
  • [2] This will contain information at a glance of the dwellings of the user's choice such as number of households, number of units, the newtown etc.
  • [3] The box plot will contain the transactional price of resale flats of each room type (1 room, 2 room, 3 room etc) in the dwelling. This will be based on what the user has clicked in the map.
  • [4] A line graph of the number of houses supplied vs the number of houses reclaimed over the years.
  • [5] A bar chart to show the distribution of the number of room types by the chosen new town as well as the number of household living in each room type.
  • [6] A bar chart of the number of dwelling by room type and area number.


COMMENTS

Feel free to comment on our project