|
|
| Line 1: |
Line 1: |
| − | [[File:1718T1G1 Logo.png|center|250px]]
| |
| | | | |
| − | {| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" |
| |
| − |
| |
| − | | style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: bold; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[Project_Groups | <b>Home</b>]]
| |
| − |
| |
| − | | style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: 100; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[1718t1is428T2 | <b>Proposal</b>]]
| |
| − |
| |
| − | | style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: 100; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[1718t1is428T2: Poster | <b>Poster</b>]]
| |
| − |
| |
| − | | style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: 100; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[1718t1is428T2: Application | <b>Application</b>]]
| |
| − |
| |
| − | | style="vertical-align:top;width:16%;" | <div style="padding: 3px; font-weight: 100; text-align:center; line-height: wrap_content; font-size:16px; border-bottom:1px solid #50B4B2; border-top:1px solid #50B4B2; font-family: helvetica"> [[1718t1is428T2: Research Paper | <b>Research Paper</b>]]
| |
| − | |}
| |
| − |
| |
| − | <p></p><br/>
| |
| − | <div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">PROBLEM & MOTIVATION</font></div>
| |
| − | With housing prices being a hot topic that most undergraduates are talking about as we approach that final period called graduation, don't you wish that there was a way for us to get a better picture of the housing market so that we can make our big decision on where we are going to live from now on? Thus, we sought out to look for a dataset which would be able to provide us with the required information we needed to come up with useful visualizations. Unfortunately, most datasets are incomplete or not useful in providing us with any insight unless a good amount of data cleaning and wrangling is done. For example, transaction data which only gives you the block number and road name with no postal code. How is that useful? Therefore, one of our primary goals is to come up with a visualization which would provide users with useful information about the resale market in Singapore and help people gain access to a better data set than the ones currently out there.
| |
| − |
| |
| − | In terms of what visualizations we would be going for, we felt that it would be interesting to look into the historical flat data so that we can see which flats in Singapore would be the most value for money so that we can actually get a home which is worth its investment. We also felt that it would be fun to explore trends in the resale flat prices and see what factors really affect the prices of HDBs and see how much of a premium people attach to amenities such as proximity to public transport, schools and etc...
| |
| − |
| |
| − | <br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OBJECTIVES</font></div>
| |
| − | <p>In this project, we are interested to create a visualisation that helps users perform the following:</p>
| |
| − | # View the trend in the resale prices over time with respect to major events that happened in the year (Example: 1993 Change in Pricing Model,1997 Recession
| |
| − | # Identify which areas are more expensive and possible reasons for the high value (Proximity to public transport, Schools, Shopping Malls, Park)
| |
| − | # To find out if getting a specific HDB is a good investment based on the number of year left on the lease and which locations may potentially be more profitable based on the age of the HDB.
| |
| − |
| |
| − | <p>By using our visualisation, we will be able to give users a better idea of the pricing situation of the resale HDBs so that people can make better decisions in the HDB which they want to choose to call their home. Such as when is the best time to buy as HDB; where are the most profitable / cheapest locations; whether a HDB is expensive </p>
| |
| − |
| |
| − | <br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">SELECTED DATASET</font></div>
| |
| − | <p>In our analysis, we will only be using data within the year of 1990 - 2017. The rationale for the range of data selected is as follows:</p>
| |
| − |
| |
| − | <p>The dataset for analysis will be retrieved from multiple databases, as elaborated below:</p>
| |
| − | {| class="wikitable" style="background-color:#FFFFFF;" width="100%"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 30%;" | Dataset/Source
| |
| − | ! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 30%" | Data Attributes
| |
| − | ! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;" | Rationale Of Usage
| |
| − | |-
| |
| − | | <center>Resales flat prices from Mar 2012 onwards<br/>
| |
| − | (https://data.gov.sg/dataset/resale-flat-prices?resource_id=83b2fc37-ce8c-4df4-968b-370fd818138b ) </center>
| |
| − | <center>Resales flat prices from 2002 - Feb 2012 <br/>
| |
| − | (https://data.gov.sg/dataset/resale-flat-prices?resource_id=8c00bf08-9124-479e-aeca-7cc411d884c4 ) </center>
| |
| − | <center>Resales flat prices from 1990 - 1999<br/>
| |
| − | (https://data.gov.sg/dataset/resale-flat-prices?resource_id=adbbddd3-30e2-445f-a123-29bee150a6fe ) </center>
| |
| − | ||
| |
| − | * Month
| |
| − | * Town
| |
| − | * Flat Type
| |
| − | * Block
| |
| − | * Street Name
| |
| − | * Storey Range
| |
| − | * Floor Area (Sqm)
| |
| − | * Flat Model
| |
| − | * Lease Commence Date
| |
| − | * Resale Price (S$)
| |
| − | ||
| |
| − | <center>This dataset will be used as a main source of information in our analysis to understand the number of HDB around Singapore from 1990 to 1999, 2002 to Feb 2012 and Mar 2012 onwards respectively.</center>
| |
| − | |-
| |
| − | | <center>Bus Stop Names and Locations<br/>
| |
| − | (https://www.mytransport.sg/content/mytransport/home/dataMall.html#)</center>
| |
| − | ||
| |
| − | * Bus Stop Number
| |
| − | * Bus Stop Roof Number
| |
| − | * Bus Stop Name
| |
| − | * X
| |
| − | * Y
| |
| − | * Latitude
| |
| − | * Longitude
| |
| − | ||
| |
| − | <center>This dataset aims to complement the main dataset by providing detailed information about the latitude and longitude of the bus stops located around HDB. We use a javascript script to convert all the X and Y coordinates to EPSG:4326 latitude and longitude coordinates.</center>
| |
| − | |-
| |
| − | | <center>Mrt Stations Names and Locations <br/>
| |
| − | (https://www.mytransport.sg/content/mytransport/home/dataMall.html#)</center>
| |
| − | ||
| |
| − | * MRT Station Number
| |
| − | * MRT Station Name
| |
| − | * X
| |
| − | * Y
| |
| − | * Latitude
| |
| − | * Longitude
| |
| − | ||
| |
| − | <center>This dataset aims to complement the main dataset by providing detailed information about the latitude and longitude of the MRT stations located around HDB. We use a javascript script to convert all the X and Y coordinates to EPSG:4326 latitude and longitude coordinates</center>
| |
| − | |-
| |
| − | | <center>Schools (Primary, Secondary, Junior College) Names and Locations <br/>
| |
| − | (https://data.gov.sg/dataset/school-directory-and-information)</center>
| |
| − | ||
| |
| − | * School Name
| |
| − | * Address
| |
| − | * Postal Code
| |
| − | * Planning Area
| |
| − | ||
| |
| − | <center>This dataset aims to complement the main dataset by providing detailed information about the address of schools located around HDB.</center>
| |
| − | |}
| |
| − |
| |
| − |
| |
| − | <br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">BACKGROUND SURVEY OF RELATED WORKS</font></div>
| |
| − | There are many charts and visualisations available which illustrates the various trends of house prices and index. We have selected a few of these to study and learn before we begin developing our own visualizations.
| |
| − | {| class="wikitable" style="background-color:#FFFFFF;" width="100%"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 50%;" | Related Works
| |
| − | ! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;" | What We Can Learn
| |
| − | |-
| |
| − | |
| |
| − | <p><center>'''An Analysis of the trend and correlation between resale prices and flat production''' </center></p>
| |
| − | [[File:1718T1G1 BackgroundSurvey1.png|400px|center]]
| |
| − | <p><center>'''Source''': http://www.teoalida.com/singapore/hdbprices/</center></p>
| |
| − | ||
| |
| − | * The use of 2 different chart types with a secondary axis is effective in illustrating the correlation between resale prices and flat production.
| |
| − | * The colours used are striking and contrast well with each other.
| |
| − | * There are dips in both variables which are not explained in the infographic itself (E.g. 1997 Asian crisis, 2003 SARs outbreak). This events could be incorporated into the charts to make it more informative.
| |
| − | |-
| |
| − | | <p><center> '''An interactive heatmap of Singapore’s house prices in various districts''' </center></p>
| |
| − | [[File:1718T1G1 BackgroundSurvey2.png|400px|center]]
| |
| − | <p><center> '''Source''': https://www.srx.com.sg/heat-map </center> </p>
| |
| − | ||
| |
| − | * This heatmap uses colours appropriately so that the house prices of each district can be identified intuitively (Red means expensive, blue means cheap, orange means mid-range)
| |
| − | * The use of filters allows user to find out more about the price distribution of each house type easily.
| |
| − | * When user mouseover a district on the heatmap, the corresponding district on the legend is highlighted. This improves usability as users do not have to match district numbers manually.
| |
| − | |-
| |
| − | | <p><center> '''An interactive visualization of house prices along MRT stations''' </center></p>
| |
| − | [[File:1718T1G1 BackgroundSurvey3.png|400px|center]]
| |
| − | <p><center> '''Source''': https://www.srx.com.sg/mrt-home-prices/property-listings-near-east-west-line </center></p>
| |
| − | ||
| |
| − | * This visualization makes use of unique ways to illustrate the relation between nearby facilities and house prices.
| |
| − | * The separating of the various MRT lines using filters at the top prevent too much information from being shown in one page
| |
| − | |}
| |
| − |
| |
| − | <br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">PROPOSED STORYBOARD</font></div>
| |
| − | {| class="wikitable" style="background-color:#FFFFFF;" width="100%"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 50%;" | Proposed Layout
| |
| − | ! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;" | How Analyst Can Conduct Analysis
| |
| − | |-
| |
| − | | [[File:HSH Home.png|600px|center]]
| |
| − | ||
| |
| − | # Introduce analysts to the topic of HDB Resale Price and the objectives of the visualization project
| |
| − | # Upon clicking "Find your Dream Home", analysts will then begin their process of exploration
| |
| − | |-
| |
| − | | [[File:HSH Insight1.png|600px|center]]
| |
| − | ||
| |
| − | # When a user enters our app, we will show them a brief history of HDB followed by the problem that most young people are facing with regards to understanding the HDB situation.
| |
| − | # The 2 screens of different insights we are trying to show will be displayed as 2 clickable buttons so that it is easy for a user to know what exactly he wants to look for at a glance.
| |
| − | # The dual axis bar-line chart will indicate the number of units sold vs the HDB price index to show the performing over the years.
| |
| − | # The scatter plot groups attacks based on 3 main categories - Planning Area, HDB resale price, Life left on lease. Firstly, by grouping based on planning area, it shows the the different HDB of how many years they left on lease. The size of the circle indicate the resale price of the HDB
| |
| − | |-
| |
| − | | [[File:HSH Insight2.png|600px|center]]
| |
| − | ||
| |
| − | # In the next phase of the exploration, we
| |
| − | # The radar chart shows 5 different governance indicators that defines how well a HDB is price with several other indicators. The closer the area is to the center of the chart, the less well the indicators is. Upon mouse-over of each area, one can also retrieve the exact values of each governance indicator.
| |
| − | # Using the map of Singapore as a filter condition, analysts can selected their choice of HDB to see if its near any bus stop, MRT, schools.
| |
| − | # By looking at both charts, the analyst will then be able to compare and establish possible linkages between the different indicators for HDB over the years. As such, these 2 charts are placed side by side to assist the analyst in their data exploration.
| |
| − | |}
| |
| − |
| |
| − | <br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">ADDRESSING KEY TECHNICAL CHALLENGES</font></div>
| |
| − | The following are some of the key technical challenges that we may face throughout the course of the project:
| |
| − | {| class="wikitable" style="background-color:#FFFFFF;" width="100%"
| |
| − | |-
| |
| − | ! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;width: 50%;" | Key Technical Challenges
| |
| − | ! style="font-weight: bold;background: #56C0BE;color:#fbfcfd;" | How We Propose To Resolve
| |
| − | |-
| |
| − | | <center> Unfamiliarity of Visualization Tool Usage </center> ||
| |
| − | * Independent Learning on Visualization Tools
| |
| − | * Peer Learning
| |
| − | |-
| |
| − | | <center> Data Cleaning & Transformation </center> ||
| |
| − | * Work together to clean, transform and analyze the data
| |
| − | |-
| |
| − | | <center> Unfamiliarity in Programming using Javascript & D3 Libraries </center> ||
| |
| − | * Attend D3 Programming Workshop
| |
| − | * Independent Learning on D3 Libraries & Technical Tools
| |
| − | * Peer Learning
| |
| − | |-
| |
| − | | <center> Unfamiliarity in Implementing Interactivity and Animation Tools/Techniques in Visualization App </center> ||
| |
| − | * Develop a Storyboard/Design Flow
| |
| − | * Assign members to specialize on Interactivity/Animation Techniques
| |
| − | |}
| |
| − |
| |
| − | <br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">PROJECT TIMELINE</font></div>
| |
| − | <p>The following shows our project timeline for the completion of this project:</p>
| |
| − | <div style="width:100%">[[File:1718T1G1 Timeline.png|1000px|center]]</div>
| |
| − |
| |
| − | <br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">TOOLS/TECHNOLOGIES</font></div>
| |
| − | <p>The following are some of the tools/technologies that we will be utilizing during the project:</p>
| |
| − | * Excel
| |
| − | * D3.js
| |
| − | * Proj4.js
| |
| − | * Google Maps Distance Matrix API
| |
| − | * Google Search API
| |
| − | * Github
| |
| − | * Node.js
| |
| − | * Angular.js
| |
| − |
| |
| − | <br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">REFERENCES</font></div>
| |
| − | * DrWealth’s infographic (https://www.drwealth.com/singapore-property-prices-along-mrt-lines/)
| |
| − | * Data Gov Database (https://data.gov.sg)
| |
| − | * D3.js (https://d3js.org/)
| |
| − | * Examples By Mike Bostock (https://bost.ocks.org/mike/example/)
| |
| − | * Housing Development Board (http://www.hdb.gov.sg/cs/infoweb/residential/buying-a-flat/resale/resale-statistics)
| |
| − |
| |
| − | <br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR BRAINSTORMING SESSIONS</font></div>
| |
| − | <p>The following are some of the proposed storyboard that we designed during our brainstorming sessions:</p>
| |
| − | [[File:HSH Homesketch.jpeg|800px|center]]<br/>
| |
| − | [[File:HSH Insight 1 and 2.jpg|800px|center]]<br/>
| |
| − | [[File:HSH insight1.jpg|800px|center]]<br/>
| |
| − |
| |
| − | Our idea was to provide charts which are able to visualise the trends of HDB over the years in Singapore. We decided to split into multiple charts to be able to showcase the information more clearly.
| |
| − |
| |
| − | <br/><div style="background: #347473; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">COMMENTS</font></div>
| |
| − | <p>Feel free to comments, suggestions and feedbacks to help us improve our project! (:</p>
| |
