|
|
| Line 18: |
Line 18: |
| | | style="padding:0.2em; font-size:100%; background-color:#143c67; border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" | | | | style="padding:0.2em; font-size:100%; background-color:#143c67; border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" | |
| | ; | | ; |
| − | [[Group08 application| <font color="#FFFFFF">Application</font>]] | + | [[Group02 application| <font color="#FFFFFF">Application</font>]] |
| | | | |
| | | style="background:none;" width="1%" | | | | style="background:none;" width="1%" | |
| Line 35: |
Line 35: |
| | | | |
| | '''<u>Problem</u>''' <br> | | '''<u>Problem</u>''' <br> |
| − | As a buyer looking for Resale HDB flats, it can be difficult to make a purchase decision due to the lack of information in the market. Information such as increasing or decreasing price trends over the years for each estate (e.g. Tampines) or submarket (e.g. 4-ROOM flats) could be essential in the decision making process.
| |
| | | | |
| | '''<u>Motivation</u>''' <br> | | '''<u>Motivation</u>''' <br> |
| − | According to Ms. Christine Sun, head of research and consultancy at OrangeTee, She commented in November last year (2019) that [https://www.straitstimes.com/singapore/more-hdb-resale-flats-sold-in-october-after-higher-housing-grants-income-ceilings-kicked demand for HDB resale flats has been strengthening] in the recent months. However, our group felt that the statement was too generalised as there are several submarkets in the resale of HDB flats such as 3-ROOM flats and 5-ROOM flats just to name a few. [https://www.businesstimes.com.sg/hub-projects/property-2019-september-issue/hdb-resale-market-sees-strong-demand Each submarket could have a different trend]. Additionally, trends could also vary across different estates such as Bukit Merah and Tampines. The information online would not be useful for people looking at specific submarkets in certain estates.
| |
| | | | |
| | ==<div style="background:#143c67; padding: 15px; font-weight: bold; line-height: 0.3em; letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>OBJECTIVES</center></font></div>== | | ==<div style="background:#143c67; padding: 15px; font-weight: bold; line-height: 0.3em; letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>OBJECTIVES</center></font></div>== |
| | <b>Target Group: </b> Resale flat buyers <br> | | <b>Target Group: </b> Resale flat buyers <br> |
| − | Our goal in this project is to design and create an interactive one-stop visualization tool that could provide Resale flat buyers with information such as: <br>
| + | |
| | + | <br> |
| | <ul> | | <ul> |
| − | <li> Changes of flat prices over time for each submarket by estate (e.g. 4-ROOM flats price changes over the past 5 years for Ang Mo Kio) </li> | + | <li> </li> |
| − | <li> High and low value estates based on past prices (e.g. Tampines is a low value estate based on prices from the past 5 years) </li> | + | <li> </li> |
| − | <li> Changes in resale prices based on remaining lease (i.e. age of the estate) for each estate </li> | + | <li> </li> |
| − | <li> Distribution of flat prices for each submarket and estate </li> | + | <li> </li> |
| | </ul> | | </ul> |
| − | These information would help buyers make better purchase decision(s).
| + | |
| | | | |
| | ==<div style="background:#143c67; padding: 15px; font-weight: bold; line-height: 0.3em; letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>DATASET</center></font></div>== | | ==<div style="background:#143c67; padding: 15px; font-weight: bold; line-height: 0.3em; letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>DATASET</center></font></div>== |
| Line 61: |
Line 60: |
| | | | | | |
| | <center> | | <center> |
| − | Resale Flat Prices (January 1, 2017 to January 31, 2020) <br>
| + | |
| − | Taken from: Data.gov.sg <br>
| |
| − | [https://data.gov.sg/dataset/resale-flat-prices Link to Data Source]
| |
| | </center> | | </center> |
| | | | | | |
| | <ol> | | <ol> |
| − | <li> <b> month: </b> Transacted Year & Month </li>
| + | |
| − | <li> <b> Town: </b> Town the flat is situated in </li>
| |
| − | <li> <b> Flat Type: </b> Type of Housing </li>
| |
| − | <li> <b> Block: </b> Identifier for each Housing </li>
| |
| − | <li> <b> Street Name: </b> Identifier for each Street </li>
| |
| − | <li> <b> Storey Range: </b> Range of Storey the flat is situated in </li>
| |
| − | <li> <b> Floor Area Sqm: </b> Size of flat </li>
| |
| − | <li> <b> Flat Model: </b> Flat Model </li>
| |
| − | <li> <b> Lease Commence Date: </b> Start Date of Lease </li>
| |
| − | <li> <b> Remaining Lease: </b> Duration remaining for Lease </li>
| |
| − | <li> <b> Resale Price: </b> Price the Flat is sold for </li>
| |
| | </ol> | | </ol> |
| − | |
| + | |
| − | Obtain information on flat prices by:
| |
| | <ul> | | <ul> |
| − | <li> Town </li>
| + | |
| − | <li> Flat Type </li>
| |
| − | <li> Town & Flat Type (e.g. 4-ROOM in Tampines vs. 4-ROOM in Bedok) </li>
| |
| − | <li> Town & Block (e.g. 105 TAMPINES vs. 115 TAMPINES) </li>
| |
| − | <li> Storey Range </li>
| |
| − | <li> Floor Area </li>
| |
| − | <li> Town & Floor Area </li>
| |
| − | <li> Remaining Lease </li>
| |
| | </ul> | | </ul> |
| − | The list is non exhaustive, more could be added in the future.
| + | |
| | |- | | |- |
| | |} | | |} |
| Line 97: |
Line 76: |
| | | | |
| | ==<div style="background:#143c67; padding: 15px; font-weight: bold; line-height: 0.3em; letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>BACKGROUND SURVEY OF RELATED WORK</center></font></div>== | | ==<div style="background:#143c67; padding: 15px; font-weight: bold; line-height: 0.3em; letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>BACKGROUND SURVEY OF RELATED WORK</center></font></div>== |
| − |
| |
| − | In order for our group to design a new visualisation, it was important to us that we understand the current work out there in the field. This will enable us to make informed decisions on developing our own visualisations. We can also learn from the current visualisations to ensure that our own work adds value and to not repeat any mistakes made. Listed below are screenshots of visualisations and their learning points respectively.
| |
| − |
| |
| | | | |
| | {| class="wikitable" style="margin-left: auto; margin-right: auto; width: 90%; | | {| class="wikitable" style="margin-left: auto; margin-right: auto; width: 90%; |
| Line 105: |
Line 81: |
| | ! style="background: #899db3;color:#fbfcfd;|Reference of Other Interactive Visualization !!style="background: #899db3;color:#fbfcfd;| Learning Points | | ! style="background: #899db3;color:#fbfcfd;|Reference of Other Interactive Visualization !!style="background: #899db3;color:#fbfcfd;| Learning Points |
| | |- | | |- |
| − | | <center><br/> '''Title: Official HDB Map Services ''' | + | | <center><br/> '''Title: s ''' |
| − | [[File:Image5.jpg|thumb|Image5| 500px |center]]
| + | |
| − | Source: https://services2.hdb.gov.sg/web/fi10/emap.html
| |
| | </center> | | </center> |
| | || | | || |
| − | * This is an interactive visualisation by HDB that we can search and filter different regions | + | * |
| − | * This visualisation is quite messy as icons of all current HDB in a particular is shown, and the user might be confused to which house to pick from. Furthermore we are not able to understand the price changes across time | + | * |
| − | * The advantage of this visualisation is being able to visualise the clustering of HDB flats in a particular region | + | * |
| | | | |
| | |- | | |- |
| − | | <center><br/> '''Title: Average HDB resale prices by town treemap ''' | + | | <center><br/> '''Title: ''' |
| − | [[File:Image3.jpg|thumb|Image3| 500px |center]]
| |
| − | Source: http://sgyounginvestment.blogspot.com/2018/03/visualisation-of-hdb-resale-prices-in.html
| |
| | </center> | | </center> |
| | || | | || |
| − | * This is a heatmap that shows the relationship of average resale prices by towns
| |
| − | * One further improvement that we can do to this visualisation is to add in subcategories of the different resale prices. These subcategories could be type of HDB resale flats and which storeys they are on
| |
| | | | |
| | |- | | |- |
| − | | <center><br/> '''Title: Distribution of Past HDB Transactions''' | + | | <center><br/> '''Title: ''' |
| − | [[File:Image7.png|thumb| 500px |center]]
| |
| − | Source: https://hdbviz.shinyapps.io/hdbviz/
| |
| | </center> | | </center> |
| | || | | || |
| − | * This is a highlight table that can be used to depict the distribution of price compared to region and flat type. Furthermore there is a more detailed box plot at the side that visualises the range of price
| |
| − | * One improvement that can be made to this visualisation is labelling the highlight table to include the prices of each cell, this is to give clarity by showing the magnitude of the price
| |
| − | * One other improvement that can be made to this visualisation is to allow the user to have an option to include volume of sales as well.
| |
| | | | |
| | | | |
| | |- | | |- |
| − | | <center><br/> '''Title: Distribution of 4-Room HDB Resale Prices By Town ''' | + | | <center><br/> '''Title: ''' |
| | | | |
| − | [[File:Image2.jpg|thumb|500px|center]]
| |
| − | Source: https://medium.com/@wojiefu/hdb-pusle-visualization-of-singapore-hdb-flat-resale-records-2e2fbedbee91
| |
| | </center> | | </center> |
| | || | | || |
| − | * This is a animated visualisation of HDB resale prices on the map of Singapore, it is very effective in showing us the changes in number of occurrence of transactions being made at what frequency
| |
| − | * A disadvantage of this visualisation is that there is no legend or information to relate the colours of the points and the actual resale price
| |
| − | * A disadvantage of this visualisation is that there is no clear indication of which region belongs to which section in the geography map of Singapore. This leaves the user with the onus to understand the location in Singapore
| |
| | | | |
| | | | |
| Line 151: |
Line 112: |
| | '''<u>References</u>''' <br> | | '''<u>References</u>''' <br> |
| | <ol> | | <ol> |
| − | <li> https://www.straitstimes.com/singapore/more-hdb-resale-flats-sold-in-october-after-higher-housing-grants-income-ceilings-kicked </li> | + | <li> </li> |
| − | <li> https://www.businesstimes.com.sg/hub-projects/property-2019-september-issue/hdb-resale-market-sees-strong-demand </li>
| |
| − | <li> https://www.reddit.com/r/singapore/comments/dubsyk/visualising_30_years_of_hdb_resale_flat_prices/ </li>
| |
| − | <li> https://medium.com/@wojiefu/hdb-pusle-visualization-of-singapore-hdb-flat-resale-records-2e2fbedbee91 </li>
| |
| − | <li> http://sgyounginvestment.blogspot.com/2018/03/visualisation-of-hdb-resale-prices-in.html </li>
| |
| − | <li> https://services2.hdb.gov.sg/web/fi10/emap.html </li>
| |
| − | <li> https://hdbviz.shinyapps.io/hdbviz/ </li>
| |
| | | | |
| | | | |
| Line 171: |
Line 126: |
| | ! style="font-weight: bold;background: #899db3;color:#fbfcfd;width: 40%;" |Mitigation | | ! style="font-weight: bold;background: #899db3;color:#fbfcfd;width: 40%;" |Mitigation |
| | |- | | |- |
| − | | 1. | + | | |
| − | | Lack of Familiarity with Tools
| |
| − | | Everyone in the group do not know how to program in RShiny for visualisation
| |
| − | | We will learn Rshiny during class, call for consultation and rely on Googling for any programming challenges. Alternatively, there is also Datacamp available for us.
| |
| − | |-
| |
| − | | 2.
| |
| − | | Viability of Ideas
| |
| − | | We do not know if the current dataset is sufficient in providing all the information needed to conduct analysis and building of planned visualizations.
| |
| − | | There are multiple dataset online to use and we can use Prof Kam's REALIS dataset provided to us to supplement our dataset if we are lacking of certain variables. We could also derive our own variables based on the current dataset if needed (e.g. Geocoding).
| |
| − | |-
| |
| − | | 3.
| |
| − | | Lack of Domain Knowledge
| |
| − | | HDB resale prices are affected by a spectrum of different factors such as policy measures and redevelopment. It is hard for us to understand without domain knowledge.
| |
| − | | Learn from informative websites such as from HDB and iteratively discover and learn insights into the dataset
| |
| | |} | | |} |
| | </center> | | </center> |
| Line 195: |
Line 137: |
| | |- | | |- |
| | | <center><br/> ''' Dashboard 1: Overall Price Distribution by Submarket and Submarket Sizes ''' | | | <center><br/> ''' Dashboard 1: Overall Price Distribution by Submarket and Submarket Sizes ''' |
| − | [[File:Dashboard1 1.png|thumb|500px|center]] | + | [[File:|thumb|500px|center]] |
| − | [[File:Dashboard1 2.png|thumb|500px|center]] | + | [[File:|thumb|500px|center]] |
| | </center> | | </center> |
| | || | | || |
| − | * The first dashboard that we would like to envision is to have a filter that is visualised by the Singapore map. This will allow users to intuitively find an area that they are familiar with. Since this is only just a filter, it will not show the distribution of HDB Resale Flats in the map itself. | + | * Description 1 |
| − | | + | * Description 2 |
| − | * By clicking on a specific town, the dashboard will dynamically change (a) and provide insights of its submarket price distribution. This will be visualised in the form of a box plot. | + | * Description 3 |
| − | | |
| − | * Furthermore, by clicking on a specific box plot, it is used as a filter for graph (b), where there will be a histogram plot for the volume of different psf sizes of the submarkets. | |
| | | | |
| | |- | | |- |
| | | <center><br/> ''' Dashboard 2 ''' | | | <center><br/> ''' Dashboard 2 ''' |
| − | [[File:Dashboard2.png|thumb|500px|center]]
| |
| | </center> | | </center> |
| | || | | || |
| Line 216: |
Line 155: |
| | |- | | |- |
| | | <center><br/> ''' Dashboard 3: Tree Map of HDB Storeys by Volume and Price ''' | | | <center><br/> ''' Dashboard 3: Tree Map of HDB Storeys by Volume and Price ''' |
| − | [[File:Dashboard3.png|thumb|500px|center]]
| + | |
| | </center> | | </center> |
| | || | | || |
| − | * The final dashboard that we envision to complete is a Tree Map plot to visualise the volume and price of HDB Resale flats by their Storeys. The size of the boxes will be equivalent to the volume transacted value and the colours will represent their respective price. | + | * Description 1 |
| − | * The dashboard will come with filters that enables users to select the particular towns that they will want to compare with. The maximum allowed number to select is up to 2 towns. The number of towns selected will generate the same number of graphs for visualisation. | + | * Description 2 |
| − | * Lastly, one other filter is the submarkets in which the user is able to select the type of submarket for deeper analysis. | + | * Description 3 |
| | |} | | |} |
| | | | |
| | ==<div style="background:#143c67; padding: 15px; font-weight: bold; line-height: 0.3em; letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>MILESTONES</center></font></div>== | | ==<div style="background:#143c67; padding: 15px; font-weight: bold; line-height: 0.3em; letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>MILESTONES</center></font></div>== |
| − | [[Image:Milestones.jpg | frameless | center | 500px ]]
| + | |
| | | | |
| | ==<div style="background:#143c67; padding: 15px; font-weight: bold; line-height: 0.3em; letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>COMMENTS</center></font></div>== | | ==<div style="background:#143c67; padding: 15px; font-weight: bold; line-height: 0.3em; letter-spacing:0.5em;font-size:20px"><font color=#fbfcfd face="Century Gothic"><center>COMMENTS</center></font></div>== |
