Difference between revisions of "Centroid-Amenities Project Details"

From IS415-Geospatial Analytics for Business Intelligence
Jump to navigation Jump to search
(Created page with "<!--Header Start--> 150px|center {|style="background-color:#F2455A; padding: 2px 0 2px 0; " width="100%" cellspacing="0" cellpadding="0" border="0" |- |...")
 
 
(34 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<!--Header Start-->
+
[[File:filler.png|250px|center]]
[[File:filler.png|150px|center]]
+
<!--Header-->
{|style="background-color:#F2455A; padding: 2px 0 2px 0; " width="100%" cellspacing="0" cellpadding="0" border="0"
+
{|style="background-color:#F5F5F5; color:#F6B419; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" |
|-
+
| style="padding:0.2em; font-size:100%; background-color:#F5F5F5; border-right:1px solid #DDD; text-align:center; color:#5E2705; border-bottom:2px solid #DDD; " width="10%" |  
 
+
[[Centroid-Amenities_Home|<font color="#5E2705" size=3 face="Helvetica">Home</font>]]
| style="font-size:12px;background-color:#ffffff;border-width: 1px;padding: 8px;border-style: solid;border-color: #ffffff;text-align:center"|
+
| style="padding:0.2em; font-size:100%; background-color:#F5F5F5; border-right:1px solid #DDD; text-align:center; color:#5E2705; border-bottom:2px solid #B21C0E; " width="10%" |  
[[Centroid-Amenities_ProjectDetails|<font color="#fc9272" size=3><b>Project Details</b></font>]]
+
[[Centroid-Amenities_Project_Details|<font color="#5E2705" size=3 face="Helvetica">Proposal</font>]]
 
+
| style="padding:0.2em; font-size:100%; background-color:#F5F5F5; border-right:1px solid #DDD; text-align:center; color:#5E2705; border-bottom:2px solid #DDD; " width="10%" |  
| style="font-size:12px;background-color:#ffffff;border-width: 1px;padding: 8px;border-style: solid;border-color: #ffffff;text-align:center"|
+
[[Centroid-Amenities_Project_Poster|<font color="#5E2705" size=3 face="Helvetica">Poster</font>]]
[[Centroid-Amenities_ProjectPoster|<font color="#C9061C" size=3><b>Project Poster</b></font>]]
+
| style="padding:0.2em; font-size:100%; background-color:#F5F5F5; border-right:1px solid #DDD; text-align:center; color:#5E2705; border-bottom:2px solid #DDD; " width="10%" |  
 
+
[[Centroid-Amenities_Project_Application|<font color="#5E2705" size=3 face="Helvetica">Application</font>]]
||
 
| style="font-size:12px;background-color:#ffffff;border-width: 1px;padding: 8px;border-style: solid;border-color: #ffffff;text-align:center"|
 
[[Centroid-Amenities_ProjectApplication |<font color="#C9061C" size=3><b>Project Application</b></font>]]
 
 
 
||
 
| style="font-size:12px;background-color:#ffffff;border-width: 1px;padding: 8px;border-style: solid;border-color: #ffffff;text-align:center"|
 
[[Centroid-Amenities_ResearchPaper |<font color="#C9061C" size=3><b>Research Paper</b></font>]]
 
 
 
|}
 
 
 
<!--Header End-->
 
 
 
 
 
== Motivation and Problem Discovery ==
 
By 2030, Singapore’s Department of Statistics purports that nearly 1 in 3 Singaporeans will be over the age of 65, and will be in need of some form of eldercare. In the face on the oncoming ‘Silver Tsunami’, it is important that we rethink the placement and accessibility of our gerontological and palliative facilities, so Singaporeans can have access to the care that they need.
 
  
Many existing eldercare facilities are located in the fringes of new town suburbs, and often near regional hospitals which are often further and less accessible from residential areas where the elderly would be.  
+
| style="padding:0.2em; font-size:100%; background-color:#F5F5F5; text-align:center; color:#5E2705;  border-bottom:2px solid #DDD; " width="10%" |
 +
[[Centroid-Amenities_Research_Paper|<font color="#5E2705" size=3 face="Helvetica">Research Paper</font>]]
 +
|}
 +
{|style="background-color:#F5F5F5; color:#F5F5F5; padding: 10 0 10 0; margin-bottom: 30px; border-bottom:1px solid #DDD; " width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 +
| style="font-size:100%; background-color:#F5F5F5; text-align:center; color:#5E2705; " width="10%" |
 +
|}
 +
<!--End Header-->
 +
__FORCETOC__
 +
==<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Helvetica; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Motivation and Problem Discovery</font></div>==
 +
As the Singaporean Government looks toward more data-driven approaches to urban planning, it becomes imperative to the cause that we use intelligent ways to determine where we place our built amenities and services, we best serve our citizens' needs.
  
Our project posits that future eldercare facilities would be better positioned within the heartlands, to better serve an aging community. In this, we hope to equip town planners and eldercare facility administrators with the tools decide where best to place eldercare facilities.  
+
Currently, there are no ready tools available that could help planners optimise the placement of amenities and services, to make them as accessible as possible to the citizens they serve. Furthermore, we do not have ready analysis tools to help planners assess how accessible the existing amenities and services are.
  
== Project Objectives ==
+
==<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Helvetica; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Project Objectives</font></div>==
The goal of this project would be to build a GIS tool (an R Shiny app), to help administrators determine where best to put eldercare amenities based on a geographical cluster analysis as determined by k-means clustering.
+
'''Our goals are :'''
 +
* To build a GIS tool (an R Shiny app)
 +
* Help administrators determine where best to put eldercare or any amenities  
 +
* Based on a geographical cluster analysis as determined through k-means clustering
  
== Data Sources ==
+
==<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Helvetica; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Data Sources</font></div>==
 
<table class="wikitable">
 
<table class="wikitable">
 
<tr>
 
<tr>
Line 39: Line 36:
 
<th> Source </th>
 
<th> Source </th>
 
<th> Data Type/Method
 
<th> Data Type/Method
</th></tr>
+
</th>
 +
</tr>
 +
<tr>
 +
<td> OSM Layer (Singapore) </td>
 +
<td> OpenStreet Map  </td>
 +
<td> SHP
 +
</td>
 +
</tr>
 +
<tr>
 +
<td> Master Plan 2014 Subzone Boundary (No Sea) </td>
 +
<td> https://data.gov.sg/dataset/master-plan-2014-subzone-boundary-no-sea </td>
 +
<td> SHP </td>
 +
</tr>
 +
<tr>
 +
<td> Estimated Singapore Resident Population in HDB Flats </td>
 +
<td> https://data.gov.sg/dataset/estimated-resident-population-living-in-hdb-flats </td>
 +
<td> .csv </td>
 +
</tr>
 +
<tr>
 +
<td> Dwelling Units under HDB's Management, by Town and Flat Type </td>
 +
<td> https://data.gov.sg/dataset/number-of-residential-units-under-hdb-s-management </td>
 +
<td> .csv
 +
</td></tr>
 
<tr>
 
<tr>
<td> Population Data </td>
+
<td> Residents by Age Group & Type of Dwelling, Annual </td>
<td> Singstat.gov.sg </td>
+
<td> https://data.gov.sg/dataset/residents-by-age-group-type-of-dwelling-annual </td>
 +
<td> .csv </td>
 +
</tr>
 +
<tr>
 +
<td> Land Area and Dwelling Units by Town </td>
 +
<td> https://data.gov.sg/dataset/land-area-and-dwelling-units-by-town </td>
 
<td> .csv
 
<td> .csv
 
</td></tr>
 
</td></tr>
 
<tr>
 
<tr>
<td> OSM Layer (Singapore) </td>
+
<td> Singapore Residents by Subzone and Type of Dwelling, June 2016 </td>
<td> OpenStreet Map  </td>
+
<td> https://data.gov.sg/dataset/singapore-residents-by-subzone-and-type-of-dwelling-june-2016 </td>
 +
<td> SHP
 +
</td></tr>
 +
<tr>
 +
<td> Singapore Residents by Subzone, Age Group and Sex, June 2016 (Gender) </td>
 +
<td> https://data.gov.sg/dataset/singapore-residents-by-subzone-age-group-and-sex-june-2016-gender </td>
 
<td> SHP
 
<td> SHP
 
</td></tr>
 
</td></tr>
 
<tr>
 
<tr>
<td> Masterplan 2008 </td>
+
<td> Pre-Schools Location </td>
<td> data.gov.sg </td>
+
<td> https://data.gov.sg/dataset/pre-schools-location </td>
 +
<td> KML
 +
</td></tr>
 +
<tr>
 +
<td> Child Care Services </td>
 +
<td> https://data.gov.sg/dataset/child-care-services?resource_id=195b6c5f-c277-4ba9-bcdc-25c264e3ee5c </td>
 
<td> SHP
 
<td> SHP
 
</td></tr>
 
</td></tr>
 
<tr>
 
<tr>
 
</tr></table>
 
</tr></table>
 +
 +
==<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Helvetica; border-bottom:2px solid #B21C0E;"><font color= #5E2705> Project Timeline /Milestones </font></div>==
 +
[[File:Project_Timeline_Centroid_Amenities.png|1250px|center]]
 +
 +
==<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Helvetica; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Related Work</font></div>==
 +
{| class="wikitable"
 +
|-
 +
| '''OneMap SchoolQuery''' (https://www.onemap.sg/main/v2/schoolquery)
 +
|-
 +
| [[File:SchoolQuery_Centroid_Amenities.png|850px|center]]
 +
|-
 +
| Using this as a reference for our user interface and functionalities of our application.
 +
|-
 +
| '''Clustering With GIS''': An Attempt to Classify Turkish District Data
 +
|-
 +
| [[File:Clustering_Centroid_Amenities.png|850px|center]]
 +
|-
 +
| Using this as a reference for the algorithm and analyze.
 +
|-
 +
| '''Buffer Analysis and Modified K-Means Clustering for Geo-Spatial Amenities on Gujarat state'''
 +
|-
 +
| [[File:Buffer_Centroid_Amenities.png|850px|center]]
 +
|-
 +
| Using this as a reference for our k-means clustering.
 +
|}
 +
 +
==<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Helvetica; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Challenges</font></div>==
 +
'''Lack of Data'''
 +
* Diffcult to find insightful data needed for the project
 +
* Data found are not complete
 +
 +
'''Data cleaning and transformation'''
 +
* Data found are not in the format that could be analysed, thus data cleaning is tough
 +
* Documentation of cleaning process
 +
 +
'''Inexperience with QGIS'''
 +
* Self-learning is required
 +
* Listen to Prof Kam in class
 +
* Peer-to-peer learning
 +
 +
==<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Helvetica; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Tools and Techologies</font></div>==
 +
* QGIS
 +
* Shiny
 +
* R Language
 +
* Open Street Map
 +
* Mircosoft Excel
 +
 +
=<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Helvetica; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Meet The Team</font></div>=
 +
[[File:Team_Centroid_Amenities.png|850px|center]]
 +
 +
=<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Helvetica; border-bottom:2px solid #B21C0E;"><font color= #5E2705>References </font></div>=
 +
Aksoy, Ece. (2006). Clustering With GIS: An Attempt to Classify Turkish District Data. Retrieved March 3, 2018, from https://www.researchgate.net/publication/255603804_Clustering_With_GIS_An_Attempt_to_Classify_Turkish_District_Data
 +
 +
Brajesh, S., Katyal, K., Pandya, M., Chaudhary, B., Bodar, H., Thakkar, P., Patel, L., Patel, N., Patel, K. (2014). Buffer Analysis and Modified K-Means Clustering for Geo-Spatial Amenities on Gujarat state. International Journal of Scientific & Engineering Research,5(8), 838-841. Retrieved March 3, 2018, from https://www.ijser.org/researchpaper/Buffer-Analysis-and-Modified-K-Means-Clustering-for-Geo-Spatial-Amenities-on-Gujarat-state.pdf
 +
 +
Tai, J., & Toh, Y. (2016, November 10). Growing old: Should you be worried? Retrieved March 04, 2018, from http://www.straitstimes.com/singapore/growing-old-should-you-be-worried
 +
 +
=<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Helvetica; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Comments </font></div>=
 +
Hello fellow mates! Feel free to add your comments under this section. :)

Latest revision as of 12:15, 10 April 2018

Filler.png

Home

Proposal

Poster

Application

Research Paper

Motivation and Problem Discovery

As the Singaporean Government looks toward more data-driven approaches to urban planning, it becomes imperative to the cause that we use intelligent ways to determine where we place our built amenities and services, we best serve our citizens' needs.

Currently, there are no ready tools available that could help planners optimise the placement of amenities and services, to make them as accessible as possible to the citizens they serve. Furthermore, we do not have ready analysis tools to help planners assess how accessible the existing amenities and services are.

Project Objectives

Our goals are :

  • To build a GIS tool (an R Shiny app)
  • Help administrators determine where best to put eldercare or any amenities
  • Based on a geographical cluster analysis as determined through k-means clustering

Data Sources

Data Source Data Type/Method
OSM Layer (Singapore) OpenStreet Map SHP
Master Plan 2014 Subzone Boundary (No Sea) https://data.gov.sg/dataset/master-plan-2014-subzone-boundary-no-sea SHP
Estimated Singapore Resident Population in HDB Flats https://data.gov.sg/dataset/estimated-resident-population-living-in-hdb-flats .csv
Dwelling Units under HDB's Management, by Town and Flat Type https://data.gov.sg/dataset/number-of-residential-units-under-hdb-s-management .csv
Residents by Age Group & Type of Dwelling, Annual https://data.gov.sg/dataset/residents-by-age-group-type-of-dwelling-annual .csv
Land Area and Dwelling Units by Town https://data.gov.sg/dataset/land-area-and-dwelling-units-by-town .csv
Singapore Residents by Subzone and Type of Dwelling, June 2016 https://data.gov.sg/dataset/singapore-residents-by-subzone-and-type-of-dwelling-june-2016 SHP
Singapore Residents by Subzone, Age Group and Sex, June 2016 (Gender) https://data.gov.sg/dataset/singapore-residents-by-subzone-age-group-and-sex-june-2016-gender SHP
Pre-Schools Location https://data.gov.sg/dataset/pre-schools-location KML
Child Care Services https://data.gov.sg/dataset/child-care-services?resource_id=195b6c5f-c277-4ba9-bcdc-25c264e3ee5c SHP

Project Timeline /Milestones

Project Timeline Centroid Amenities.png

Related Work

OneMap SchoolQuery (https://www.onemap.sg/main/v2/schoolquery)
SchoolQuery Centroid Amenities.png
Using this as a reference for our user interface and functionalities of our application.
Clustering With GIS: An Attempt to Classify Turkish District Data
Clustering Centroid Amenities.png
Using this as a reference for the algorithm and analyze.
Buffer Analysis and Modified K-Means Clustering for Geo-Spatial Amenities on Gujarat state
Buffer Centroid Amenities.png
Using this as a reference for our k-means clustering.

Challenges

Lack of Data

  • Diffcult to find insightful data needed for the project
  • Data found are not complete

Data cleaning and transformation

  • Data found are not in the format that could be analysed, thus data cleaning is tough
  • Documentation of cleaning process

Inexperience with QGIS

  • Self-learning is required
  • Listen to Prof Kam in class
  • Peer-to-peer learning

Tools and Techologies

  • QGIS
  • Shiny
  • R Language
  • Open Street Map
  • Mircosoft Excel

Meet The Team

Team Centroid Amenities.png

References

Aksoy, Ece. (2006). Clustering With GIS: An Attempt to Classify Turkish District Data. Retrieved March 3, 2018, from https://www.researchgate.net/publication/255603804_Clustering_With_GIS_An_Attempt_to_Classify_Turkish_District_Data

Brajesh, S., Katyal, K., Pandya, M., Chaudhary, B., Bodar, H., Thakkar, P., Patel, L., Patel, N., Patel, K. (2014). Buffer Analysis and Modified K-Means Clustering for Geo-Spatial Amenities on Gujarat state. International Journal of Scientific & Engineering Research,5(8), 838-841. Retrieved March 3, 2018, from https://www.ijser.org/researchpaper/Buffer-Analysis-and-Modified-K-Means-Clustering-for-Geo-Spatial-Amenities-on-Gujarat-state.pdf

Tai, J., & Toh, Y. (2016, November 10). Growing old: Should you be worried? Retrieved March 04, 2018, from http://www.straitstimes.com/singapore/growing-old-should-you-be-worried

Comments

Hello fellow mates! Feel free to add your comments under this section. :)