Difference between revisions of "BURP Proposal"

From Geospatial Analytics and Applications
Jump to navigation Jump to search
Line 22: Line 22:
 
<br>
 
<br>
 
<!-- Body -->
 
<!-- Body -->
 +
 
<div style="background: #f6c630; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">PROJECT DESCRIPTION</font></div>
 
<div style="background: #f6c630; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">PROJECT DESCRIPTION</font></div>
 
+
<div style= "text-align: left; margin-left: 10em; margin-right: 10em; font-size: 18px"><font color=#000 face="Tw Cen MT">
<div style= "text-align: left; padding: 20px; margin-left: 6em; margin-right: 6em;">In recent years, the Ministry of Education (MOE) has been appointing new mergers between schools and relocating them. These schools include primary schools, secondary schools as well as junior colleges. The merging and relocation of schools would mean lesser schools in each neighbourhoods. This would affect the students' accessibility to certain schools, especially those in primary schools where parents need to send their children to schools. With more upcoming mergers of school by MOE, it is important for the government and schools to know the inconvenience in terms of time and distance travelled caused by the mergers and implement measures to ensure that these areas have better accessibility. Thus, our team aims to identify the HDB residential areas that are affected due to the merger of schools.
+
In recent years, the Ministry of Education (MOE) has been appointing new mergers between schools and relocating them. These schools include primary schools, secondary schools as well as junior colleges. The merging and relocation of schools would mean lesser schools in each neighbourhoods. This would affect the students' accessibility to certain schools, especially those in primary schools where parents need to send their children to schools. With more upcoming mergers of school by MOE, it is important for the government and schools to know the inconvenience in terms of time and distance travelled caused by the mergers and implement measures to ensure that these areas have better accessibility. Thus, our team aims to identify the HDB residential areas that are affected due to the merger of schools.
 
</div>
 
</div>
 
<!-- End of Project Description--->
 
<!-- End of Project Description--->
Line 30: Line 31:
  
 
<div style="padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align:left; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">PROJECT OBJECTIVES</font></div>
 
<div style="padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align:left; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">PROJECT OBJECTIVES</font></div>
<div style= "text-align: left; padding: 20px; margin-left: 6em; margin-right: 6em;">
+
<div style= "text-align: left; margin-left: 10em; margin-right: 10em; font-size: 18px;">
:Building an application that uses Geospatial to identify the accessibility of HDB residential areas to schools affected by the mergers.
+
#Identify the accessibility of HDB residential areas to schools affected by the mergers.
 +
#Analyze and highlight the affected HDB residential areas
 +
#Identify clustering of these affected HDB residential areas
 +
#Building an application to project our ideas and insights obtained based on our findings.
 
</div>
 
</div>
 
<!-- End of Project Objectives--->
 
<!-- End of Project Objectives--->
Line 37: Line 41:
  
 
<div style="padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align:left; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">PROJECT MOTIVATION</font></div>
 
<div style="padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align:left; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">PROJECT MOTIVATION</font></div>
<div style= "text-align: left; padding: 20px; margin-left: 6em; margin-right: 6em;">
+
<div style= "text-align: left; margin-left: 10em; margin-right: 10em; font-size: 18px;">
:xxx
+
With the increase in Singapore population, there are more residents that requires education services from nearby schools. However, government have been coming up with more school mergers. Thus, it is difficult to identify the locations which areas lack of educational accessibility. So our main reason to take up this project is to provide a proper visualisation of residential areas that are most affected by these mergers. Through our application, we hope let these affected areas gain attention from government to improve on their current accessibility.
 
</div>
 
</div>
 
<!-- End of Project Motivation--->
 
<!-- End of Project Motivation--->
  
 +
<br>
 +
<br>
 
<div style="background: #f6c630; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">PROJECT PROTOTYPE</font></div>
 
<div style="background: #f6c630; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">PROJECT PROTOTYPE</font></div>
<div style= "text-align: left; padding: 20px; margin-left: 6em; margin-right: 6em;">
 
 
[[File:Prototype v.1.png|1300px|frameless|center]]
 
[[File:Prototype v.1.png|1300px|frameless|center]]
</div>
 
 
<!-- End of Project Prototype--->
 
<!-- End of Project Prototype--->
  
  
 
<div style="background: #f6c630; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">PROJECT MILESTONES</font></div>
 
<div style="background: #f6c630; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">PROJECT MILESTONES</font></div>
<div style= "text-align: left; padding: 20px; margin-left: 6em; margin-right: 6em;">
 
 
[[File:BURP Milestone.png|frameless|center|1000px]]
 
[[File:BURP Milestone.png|frameless|center|1000px]]
</div>
 
 
<!-- End of Project Milestones--->
 
<!-- End of Project Milestones--->
  
  
 
<div style=" padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align:center; margin-left: 3em; margin-right: 3em;"><font color=#000 face="Tw Cen MT">TASKS ALLOCATION</font></div>
 
<div style=" padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align:center; margin-left: 3em; margin-right: 3em;"><font color=#000 face="Tw Cen MT">TASKS ALLOCATION</font></div>
<div style= "text-align: left; padding: 20px; margin-left: 6em; margin-right: 6em;">
+
{| class="wikitable" style="background-color:#FFF; margin: 1em auto; " width="80%;"
{| class="wikitable" style="background-color:#FFF; margin: 1em auto; " width="80%"
 
 
|+
 
|+
|-
+
|- style="font-size: 130%;
 
! <b>Iteration</b>
 
! <b>Iteration</b>
 
! <b>Week</b>
 
! <b>Week</b>
 
! <b>Task</b>
 
! <b>Task</b>
 
! <b>In-charge</b>
 
! <b>In-charge</b>
|-
+
|-style="font-size: 130%;
 
| 1 and 2
 
| 1 and 2
 
| Week 2 to 7
 
| Week 2 to 7
 
| Idea Development and Project Proposal
 
| Idea Development and Project Proposal
 
| All
 
| All
|-
+
|-style="font-size: 130%;
 
| 3
 
| 3
 
| Week 8
 
| Week 8
 
| Wiki Update (Project Assessment)
 
| Wiki Update (Project Assessment)
 
| Rebecca
 
| Rebecca
|-
+
|-style="font-size: 130%;
 
| 4  
 
| 4  
 
| Week 9
 
| Week 9
 
| Data Preparation
 
| Data Preparation
 
| Peng Chong
 
| Peng Chong
|-
+
|-style="font-size: 130%;
 
| 5  
 
| 5  
 
| Week 10 to 11
 
| Week 10 to 11
 
| Application Development and Deployment
 
| Application Development and Deployment
 
| Brendo and Peng Chong
 
| Brendo and Peng Chong
|-
+
|-style="font-size: 130%;
 
| 6  
 
| 6  
 
| Week 12
 
| Week 12
 
| Poster Submission
 
| Poster Submission
 
| Brendo and Rebecca
 
| Brendo and Rebecca
|-
+
|-style="font-size: 130%;
 
| 7  
 
| 7  
 
| Week 13
 
| Week 13
Line 96: Line 97:
 
| All
 
| All
 
|}
 
|}
</div>
 
 
<!-- End of Tasks Allocation--->
 
<!-- End of Tasks Allocation--->
  
  
 
<div style="padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align:center; margin-left: 3em; margin-right: 3em;"><font color=#000 face="Tw Cen MT">KEY CHALLENGES</font></div>
 
<div style="padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align:center; margin-left: 3em; margin-right: 3em;"><font color=#000 face="Tw Cen MT">KEY CHALLENGES</font></div>
{| class="wikitable" style="background-color:#FFF; margin: 1em auto; " width="80%"
+
{| class="wikitable" style="background-color:#FFF; margin: 1em auto;" width="80%; font-size: 18px;"
 
|+
 
|+
|-
+
|-style="font-size: 130%;
 
! <b>Key Challenges</b>
 
! <b>Key Challenges</b>
 
! <b>Description</b>
 
! <b>Description</b>
 
! <b>Solution</b>
 
! <b>Solution</b>
|-
+
|-style="font-size: 130%;
 
| Cross Referencing of Data
 
| Cross Referencing of Data
 
| As there are many datasets involved, it is difficult to cross reference the data as they are of different level.
 
| As there are many datasets involved, it is difficult to cross reference the data as they are of different level.
Line 114: Line 114:
 
#Consult prof for advise  
 
#Consult prof for advise  
 
#Find for packages helps to link data
 
#Find for packages helps to link data
|-
+
|-style="font-size: 130%;
 
| Restriction of Public Api  
 
| Restriction of Public Api  
 
| To calibrate data on routes, we used public api. However, the public api do not allow us to call more than 10,000 times.  
 
| To calibrate data on routes, we used public api. However, the public api do not allow us to call more than 10,000 times.  
Line 125: Line 125:
 
<div style="background: #f6c630; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">DATA SOURCES</font></div>
 
<div style="background: #f6c630; padding: 20px; line-height: 0.3em; letter-spacing:0.1em; font-size:150%; font-weight:bold; text-align: center; margin-left: 5em; margin-right: 5em;"><font color=#000 face="Tw Cen MT">DATA SOURCES</font></div>
  
{| class="wikitable" style="background-color:#FFF; margin: 1em auto;" width="80%"
+
{| class="wikitable" style="background-color:#FFF; margin: 1em auto;" width="80%; font-size: 18px;"
 
|+
 
|+
|-
+
|-style="font-size: 130%;
 
! <b>Data Set</b>
 
! <b>Data Set</b>
 
! <b>Format</b>
 
! <b>Format</b>
 
! <b>Attributes</b>
 
! <b>Attributes</b>
|-
+
|-style="font-size: 130%;
 
| HDB Property Information
 
| HDB Property Information
 
| CSV
 
| CSV
Line 138: Line 138:
 
*Street
 
*Street
 
*Residential Status
 
*Residential Status
|-
+
|-style="font-size: 130%;
 
| [https://docs.onemap.sg/#authentication-service-post Postal Code Data]
 
| [https://docs.onemap.sg/#authentication-service-post Postal Code Data]
 
| CSV
 
| CSV
Line 148: Line 148:
 
*X & Y coordinates
 
*X & Y coordinates
 
*Road Name
 
*Road Name
|-
+
|-style="font-size: 130%;
 
| General Information of Schools
 
| General Information of Schools
 
| CSV
 
| CSV
Line 155: Line 155:
 
*Address
 
*Address
 
*Postal Code
 
*Postal Code
|-
+
|-style="font-size: 130%;
 
| [https://cran.r-project.org/web/packages/osrm/index.html Route Data]
 
| [https://cran.r-project.org/web/packages/osrm/index.html Route Data]
 
| CSV
 
| CSV

Revision as of 02:28, 28 February 2019

BURP Logo.png

PROPOSAL

POSTER

PROJECT APPLICATION

RESEARCH PAPER


PROJECT DESCRIPTION

In recent years, the Ministry of Education (MOE) has been appointing new mergers between schools and relocating them. These schools include primary schools, secondary schools as well as junior colleges. The merging and relocation of schools would mean lesser schools in each neighbourhoods. This would affect the students' accessibility to certain schools, especially those in primary schools where parents need to send their children to schools. With more upcoming mergers of school by MOE, it is important for the government and schools to know the inconvenience in terms of time and distance travelled caused by the mergers and implement measures to ensure that these areas have better accessibility. Thus, our team aims to identify the HDB residential areas that are affected due to the merger of schools.


PROJECT OBJECTIVES
  1. Identify the accessibility of HDB residential areas to schools affected by the mergers.
  2. Analyze and highlight the affected HDB residential areas
  3. Identify clustering of these affected HDB residential areas
  4. Building an application to project our ideas and insights obtained based on our findings.


PROJECT MOTIVATION

With the increase in Singapore population, there are more residents that requires education services from nearby schools. However, government have been coming up with more school mergers. Thus, it is difficult to identify the locations which areas lack of educational accessibility. So our main reason to take up this project is to provide a proper visualisation of residential areas that are most affected by these mergers. Through our application, we hope let these affected areas gain attention from government to improve on their current accessibility.



PROJECT PROTOTYPE
Prototype v.1.png


PROJECT MILESTONES
BURP Milestone.png


TASKS ALLOCATION
Iteration Week Task In-charge
1 and 2 Week 2 to 7 Idea Development and Project Proposal All
3 Week 8 Wiki Update (Project Assessment) Rebecca
4 Week 9 Data Preparation Peng Chong
5 Week 10 to 11 Application Development and Deployment Brendo and Peng Chong
6 Week 12 Poster Submission Brendo and Rebecca
7 Week 13 Final Project Paper Submission All


KEY CHALLENGES
Key Challenges Description Solution
Cross Referencing of Data As there are many datasets involved, it is difficult to cross reference the data as they are of different level.
  1. Find more data online to merge connect the different data
  2. Consult prof for advise
  3. Find for packages helps to link data
Restriction of Public Api To calibrate data on routes, we used public api. However, the public api do not allow us to call more than 10,000 times.
  1. Host locally to call unlimited number of times.


DATA SOURCES
Data Set Format Attributes
HDB Property Information CSV
  • Block
  • Street
  • Residential Status
Postal Code Data CSV
  • Address
  • Block
  • Latitude & Longitude
  • Postal Code
  • X & Y coordinates
  • Road Name
General Information of Schools CSV
  • School Name
  • Address
  • Postal Code
Route Data CSV
  • Distance
  • Duration
  • Location
  • Destination