Difference between revisions of "DreamWorks: Proposal"
(Created page with "<br/> <div style="background: #364558; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face=...") |
Hschan.2016 (talk | contribs) |
||
(17 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | <!-- Header Start --> | ||
+ | {|style="background-color:#1E6DA9; color:#000000; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | ||
+ | |||
+ | | style="border-bottom:0px solid #000000; background:none;" width="1%" | | ||
+ | | style="padding:0.3em; font-size:100%; background-color:#0A3E66; border-bottom:0px solid #000000; text-align:center; color:#000000" width="24%" | | ||
+ | [[DreamWorks: Proposal|<font color="#fffff" size=2><b>PROPOSAL</b></font>]] | ||
+ | |||
+ | | style="border-bottom:0px solid #000000; background:none;" width="1%" | | ||
+ | | style="padding:0.3em; font-size:100%; background-color:#1E6DA9; border-bottom:0px solid #000000; text-align:center; color:#000000" width="24%" | | ||
+ | [[DreamWorks: Poster|<font color="#fffff" size=2><b>POSTER</b></font>]] | ||
+ | |||
+ | | style="border-bottom:0px solid #000000; background:none;" width="1%" | | ||
+ | | style="padding:0.3em; font-size:100%; background-color:#1E6DA9; border-bottom:0px solid #000000; text-align:center; color:#000000" width="24%" | | ||
+ | [[DreamWorks: Application|<font color="#fffff" size=2><b>APPLICATION</b></font>]] | ||
+ | |||
+ | | style="border-bottom:0px solid #000000; background:none;" width="1%" | | ||
+ | | style="padding:0.3em; font-size:100%; background-color:#1E6DA9; border-bottom:0px solid #000000; text-align:center; color:#000000" width="24%" | | ||
+ | [[DreamWorks: Research Paper|<font color="#fffff" size=2><b>RESEARCH PAPER</b></font>]] | ||
+ | |} | ||
+ | |||
+ | <!-- Header End --> | ||
+ | |||
<br/> | <br/> | ||
− | <div style="background: # | + | <div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">PROBLEM & MOTIVATION</font></div> |
+ | |||
+ | <p> | ||
+ | The Housing Development Board (HDB) is the primary source of information for all things related to housing estates in Singapore. However, the team identifies that there is a lack of context in the understanding of how the Singapore population influences the price of resale and rental in Singapore. Hence, the team would like to identify trends that would highlight the fluctuations in price and present a visual representation of the relevant data that is publicly available. | ||
+ | </p> | ||
+ | |||
+ | <br/> | ||
+ | <div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR DATA</font></div> | ||
+ | |||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 20%;" | Sources | ||
+ | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%" | Data name | ||
+ | ! style="font-weight: bold;background: #536a87;color:#fbfcfd;width: 40%" | Purpose | ||
+ | |- | ||
+ | || [https://data.gov.sg/ Data.gov.sg] | ||
+ | || [https://data.gov.sg/dataset/master-plan-1998-subzone-boundary-no-sea Planning Zone & Subzone] | ||
+ | || Extract data to form the Singapore Map for data association. | ||
+ | |- | ||
+ | || [https://data.gov.sg/ Data.gov.sg] | ||
+ | || [https://data.gov.sg/dataset/estimated-resident-population-living-in-hdb-flats Singapore Population Living in HDB Flats] | ||
+ | || Extract data to analyze Singapore population currently residing in HDB flats by planning zones. | ||
+ | |- | ||
+ | || [https://data.gov.sg/ Data.gov.sg] | ||
+ | || [https://data.gov.sg/dataset/median-rent-by-town-and-flat-type Median Rent by Town & Flat type] | ||
+ | || Extract data to analyze median rent rate by town and flat type. | ||
+ | |- | ||
+ | || [https://data.gov.sg/ Data.gov.sg] | ||
+ | || [https://data.gov.sg/dataset/median-resale-prices-for-registered-applications-by-town-and-flat-type Median Resale Price for Registered Application by Town & Flat type] | ||
+ | || Extract data to analyze median resale price by town and flat type. | ||
+ | |- | ||
+ | || [https://www.singstat.gov.sg/ Singstat] | ||
+ | || [https://www.singstat.gov.sg/find-data/search-by-theme/population/geographic-distribution/latest-data Geographic Distribution of Singapore] | ||
+ | || Extract data to analyze Singapore population for each dwelling type within Singapore's 2014 Planning Zones | ||
+ | |} | ||
+ | |||
+ | <br/> | ||
+ | <div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR BACKGROUND SURVEY</font></div> | ||
+ | |||
+ | <b>1.</b> Housing Development Board - Map Service | ||
+ | [https://services2.hdb.gov.sg/web/fi10/emap.html HDB Map Service] | ||
+ | <p> | ||
+ | The map service provides instant access to understand various property-related information such as facilities in the vicinity, resale price, and rental rate. | ||
+ | However, the map is useful only for searching for specific buildings in a location but not as a platform for storytelling and visualization. | ||
+ | </p> | ||
+ | [[File:HDB Dreamworks.png|500px|center]] | ||
+ | |||
+ | |||
+ | <b>2.</b> Datadriven.sg hackathon - a look at Singapore's property prices | ||
+ | [https://public.tableau.com/profile/hx.chua#!/vizhome/hackathon_3/Dashboard1 Tableau Public] | ||
+ | <p> | ||
+ | The visualization is created by HX Chua for the hackathon as indicated above on Oct 22, 2016. The visualization endeavors to create an analysis tool to identify patterns and trends for the rise and fall of resale price and rental rates in Singapore property based on flat type. The project gathered data from Data.gov.sg and PropertyGuru.com. | ||
+ | </p> | ||
+ | [[File:Tableau Dreamworks.png|500px|center]] | ||
+ | |||
+ | |||
+ | <b>3.</b> Visualization of Population in Singapore | ||
+ | [https://www.citypopulation.de/php/singapore-admin.php Singapore City Population by Planning Area] | ||
+ | <p> | ||
+ | The visualization provides an overview of the resident population in the urban planning areas and subzones in Singapore according to census results and latest official estimates. It serves well to be used as a reference to showcase the density of the population in each Singapore's Planning Area and Subzones. The visualization also incorporates a table to showcase the exact value for the population that resides in a given location. | ||
+ | </p> | ||
+ | [[File:CityPop Dreamworks.png|500px|center]] | ||
+ | |||
+ | <div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">DASHBOARD IDEATION</font></div> | ||
+ | |||
+ | <br> | ||
+ | {| style="margin-left: auto; margin-right: auto; border: none;" | ||
+ | |- | ||
+ | | [[File:Slide1_Dreamworks.png|400px|center]] || [[File:Slide2_Dreamworks.png|400px|center]] || [[File:Slide3_Dreamworks.png|400px|center]] | ||
+ | |} | ||
+ | |||
+ | <br/> | ||
+ | <div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR CHALLENGES</font></div> | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! Potential Challenges !! Issues !! Mitigation | ||
+ | |- | ||
+ | | <b>1.</b> Lack of Domain Knowledge || Singapore real estate is a challenging topic to cover, given that there are alot of external factors that affect a property's value. || Learn more from HDB and understand trends from exsisting data sources. | ||
+ | |- | ||
+ | | <b>2.</b> Data Constraints || There are few access to datasets where it is comprehensive enough to cover the real estate industry in Singapore. || Make do with what we can find from Singapore's exsisting data sources such as Data.gov and Sing Stat. | ||
+ | |- | ||
+ | | <b>3.</b> Experience with R Programming|| Our members are new to R programming and it will take some time to fully understand the new programming language. || Anticipate risks when using R packages, and rely on Prof Kam's notes and stack overflow for directions. | ||
+ | |} | ||
+ | |||
+ | <br/> | ||
+ | <div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">OUR PROPOSED MILESTONES</font></div> | ||
+ | <br> | ||
+ | {| style="margin-left: auto; margin-right: auto; border: none;" | ||
+ | |- | ||
+ | | [[File:Tasklist_Dreamworks.png|500px|center]] || [[File:Timeline_Dreamworks.png|500px|center]] | ||
+ | |} | ||
+ | |||
+ | <br/> | ||
+ | <div style="background: #1E6DA9; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; border-left: #0A3E66 solid 32px; border-right: #0A3E66 solid 32px; letter-spacing:-0.08em;font-size:20px"><font color=#fbfcfd face="Century Gothic">COMMENTS</font></div> | ||
+ | Feel free to comment! |
Latest revision as of 18:36, 17 November 2019
The Housing Development Board (HDB) is the primary source of information for all things related to housing estates in Singapore. However, the team identifies that there is a lack of context in the understanding of how the Singapore population influences the price of resale and rental in Singapore. Hence, the team would like to identify trends that would highlight the fluctuations in price and present a visual representation of the relevant data that is publicly available.
Sources | Data name | Purpose |
---|---|---|
Data.gov.sg | Planning Zone & Subzone | Extract data to form the Singapore Map for data association. |
Data.gov.sg | Singapore Population Living in HDB Flats | Extract data to analyze Singapore population currently residing in HDB flats by planning zones. |
Data.gov.sg | Median Rent by Town & Flat type | Extract data to analyze median rent rate by town and flat type. |
Data.gov.sg | Median Resale Price for Registered Application by Town & Flat type | Extract data to analyze median resale price by town and flat type. |
Singstat | Geographic Distribution of Singapore | Extract data to analyze Singapore population for each dwelling type within Singapore's 2014 Planning Zones |
1. Housing Development Board - Map Service HDB Map Service
The map service provides instant access to understand various property-related information such as facilities in the vicinity, resale price, and rental rate. However, the map is useful only for searching for specific buildings in a location but not as a platform for storytelling and visualization.
2. Datadriven.sg hackathon - a look at Singapore's property prices
Tableau Public
The visualization is created by HX Chua for the hackathon as indicated above on Oct 22, 2016. The visualization endeavors to create an analysis tool to identify patterns and trends for the rise and fall of resale price and rental rates in Singapore property based on flat type. The project gathered data from Data.gov.sg and PropertyGuru.com.
3. Visualization of Population in Singapore
Singapore City Population by Planning Area
The visualization provides an overview of the resident population in the urban planning areas and subzones in Singapore according to census results and latest official estimates. It serves well to be used as a reference to showcase the density of the population in each Singapore's Planning Area and Subzones. The visualization also incorporates a table to showcase the exact value for the population that resides in a given location.
Potential Challenges | Issues | Mitigation |
---|---|---|
1. Lack of Domain Knowledge | Singapore real estate is a challenging topic to cover, given that there are alot of external factors that affect a property's value. | Learn more from HDB and understand trends from exsisting data sources. |
2. Data Constraints | There are few access to datasets where it is comprehensive enough to cover the real estate industry in Singapore. | Make do with what we can find from Singapore's exsisting data sources such as Data.gov and Sing Stat. |
3. Experience with R Programming | Our members are new to R programming and it will take some time to fully understand the new programming language. | Anticipate risks when using R packages, and rely on Prof Kam's notes and stack overflow for directions. |
Feel free to comment!