Difference between revisions of "Centroid-Amenities Project Details"

From IS415-Geospatial Analytics for Business Intelligence
Jump to navigation Jump to search
 
(22 intermediate revisions by 3 users not shown)
Line 2: Line 2:
 
<!--Header-->
 
<!--Header-->
 
{|style="background-color:#F5F5F5; color:#F6B419; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" 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="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%" |  
 
| 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_Project_Details|<font color="#5E2705" size=3 face="Trebuchet MS">Proposal</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="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_Poster|<font color="#5E2705" size=3 face="Trebuchet MS">Poster</font>]]
+
[[Centroid-Amenities_Project_Poster|<font color="#5E2705" size=3 face="Helvetica">Poster</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="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="Trebuchet MS">Application</font>]]
+
[[Centroid-Amenities_Project_Application|<font color="#5E2705" size=3 face="Helvetica">Application</font>]]
  
 
| style="padding:0.2em; font-size:100%; background-color:#F5F5F5; text-align:center; color:#5E2705;  border-bottom:2px solid #DDD; " width="10%" |  
 
| 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="Trebuchet MS">Research Paper</font>]]
+
[[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="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"  |
Line 17: Line 19:
 
<!--End Header-->
 
<!--End Header-->
 
__FORCETOC__
 
__FORCETOC__
−
==<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Motivation and Problem Discovery</font></div>==
+
==<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>==
−
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.  
+
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.
  
−
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.  
+
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.
  
−
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.
+
==<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>==
 +
'''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
  
−
==<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Project Objectives</font></div>==
+
==<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>==
−
 
 
−
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 through 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:Trebuchet MS; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Data Sources</font></div>==
 
 
<table class="wikitable">
 
<table class="wikitable">
 
<tr>
 
<tr>
Line 34: 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> SHP
 
</td></tr>
 
</td></tr>
 
<tr>
 
<tr>
−
<td> Masterplan 2008 </td>
+
<td> Singapore Residents by Subzone, Age Group and Sex, June 2016 (Gender) </td>
−
<td> data.gov.sg </td>
+
<td> https://data.gov.sg/dataset/singapore-residents-by-subzone-age-group-and-sex-june-2016-gender </td>
 +
<td> SHP
 +
</td></tr>
 +
<tr>
 +
<td> Pre-Schools Location </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>
Line 53: Line 92:
 
</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:Trebuchet MS; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Milestones </font></div>==
+
==<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>==
−
To be Updated
+
[[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:Trebuchet MS; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Related Work</font></div>==
+
==<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>==
−
To be Updated
+
{| 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:Trebuchet MS; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Challenges</font></div>==
+
==<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'''
 
'''Lack of Data'''
 
* Diffcult to find insightful data needed for the project
 
* Diffcult to find insightful data needed for the project
Line 73: Line 131:
 
* Peer-to-peer learning
 
* 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:Trebuchet MS; border-bottom:2px solid #B21C0E;"><font color= #5E2705>Tools and Techologies</font></div>==
+
==<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
 
* QGIS
 
* Shiny
 
* Shiny
Line 80: Line 138:
 
* Mircosoft Excel
 
* Mircosoft Excel
  
−
=<div style="background: #F5F5F5; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; border-bottom:2px solid #B21C0E;"><font color= #5E2705>References </font></div>=
+
=<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>=
−
To be Updated
+
[[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. :)

Retrieved from ‘https://wiki.smu.edu.sg/1718t2is415g1/index.php?title=Centroid-Amenities_Project_Details&oldid=1473’