Difference between revisions of "BURP Proposal"

From Geospatial Analytics and Applications
Jump to navigation Jump to search
Line 54: Line 54:
 
<br>
 
<br>
 
<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>
+
 
[[File:Prototype v.1.png|1300px|frameless|center]]
+
<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 PREPARATION</font></div>
<!-- End of Project Prototype--->
+
 
 +
 
 +
<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">DATA SOURCES</font></div>
 +
{| class="wikitable" style="background-color:#FFF; margin: 1em auto;" width="80%; font-size: 18px;"
 +
|+
 +
|-style="font-size: 130%;
 +
! <b>Data Set</b>
 +
! <b>Format</b>
 +
! <b>Attributes</b>
 +
! <b>Source Link</b>
 +
|-style="font-size: 130%;
 +
| HDB Property Information
 +
| CSV
 +
|
 +
*Block
 +
*Street
 +
*Residential Status
 +
| https://data.gov.sg/dataset/hdb-property-information
 +
|-style="font-size: 130%;
 +
| Postal Code Data
 +
| CSV
 +
|
 +
*Address
 +
*Block
 +
*Latitude & Longitude
 +
*Postal Code
 +
*X & Y coordinates
 +
*Road Name
 +
|https://docs.onemap.sg/#authentication-service-post
 +
|-style="font-size: 130%;
 +
| General Information of Schools
 +
| CSV
 +
|
 +
*School Name
 +
*Address
 +
*Postal Code
 +
| https://data.gov.sg/dataset/school-directory-and-information?view_id=ba7c477d-a077-4303-96a1-ac1d4f25b190&resource_id=ede26d32-01af-4228-b1ed-f05c45a1d8ee
 +
|-style="font-size: 130%;
 +
| Route Data
 +
| CSV
 +
|
 +
*Distance
 +
*Duration
 +
*Location
 +
*Destination
 +
| https://cran.r-project.org/web/packages/osrm/index.html
 +
|}
 +
 
 +
<!-- End of Data Sources--->
  
  
Line 104: Line 152:
 
|}
 
|}
 
<!-- 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>
Line 129: Line 176:
  
  
<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%; font-size: 18px;"
 
|+
 
|-style="font-size: 130%;
 
! <b>Data Set</b>
 
! <b>Format</b>
 
! <b>Attributes</b>
 
! <b>Source Link</b>
 
|-style="font-size: 130%;
 
| HDB Property Information
 
| CSV
 
|
 
*Block
 
*Street
 
*Residential Status
 
| xxx
 
|-style="font-size: 130%;
 
| Postal Code Data
 
| CSV
 
|
 
*Address
 
*Block
 
*Latitude & Longitude
 
*Postal Code
 
*X & Y coordinates
 
*Road Name
 
|https://docs.onemap.sg/#authentication-service-post
 
|-style="font-size: 130%;
 
| General Information of Schools
 
| CSV
 
|
 
*School Name
 
*Address
 
*Postal Code
 
| xxx
 
|-style="font-size: 130%;
 
| Route Data
 
| CSV
 
|
 
*Distance
 
*Duration
 
*Location
 
*Destination
 
| https://cran.r-project.org/web/packages/osrm/index.html
 
|}
 
  
<!-- End of Data Sources--->
 
  
 
<!-- End of Body -->
 
<!-- End of Body -->

Revision as of 22:48, 4 April 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. This is due to an increase in Singapore aging population hence, there are lesser residents that requires education services from nearby schools. So government have been coming up with more school mergers and 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 and through our application, we hope these affected areas gain attention from government to improve on their current accessibility.


PROJECT OBJECTIVES

Our project aims to identify the accessibility of Singapore’s residents to schools through public transport. This could assist the Government or MOE to take note of the areas which can be improved to serve the citizens better. Through this project, we aim to:

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


PROJECT MOTIVATION

Our team have decided take up to take up this project topic due to several reasons. The reasons include the followings:

  1. School mergers is an on-going plan by MOE and they have been planning to further increase the mergers due to the reduce in cohort size.
  2. It is quite impactful for the current students and parents which schools have been shifted.
  3. We are curious whether the MOE have ensure that there are equal accessibility for residents before assiging the mergers of the schools.
  4. If there are no equal accessibility, we would like to know which part of the residential areas that are most affected by these mergers so that the government is able to assist them in terms of accessibility.



DATA PREPARATION


DATA SOURCES
Data Set Format Attributes Source Link
HDB Property Information CSV
  • Block
  • Street
  • Residential Status
https://data.gov.sg/dataset/hdb-property-information
Postal Code Data CSV
  • Address
  • Block
  • Latitude & Longitude
  • Postal Code
  • X & Y coordinates
  • Road Name
https://docs.onemap.sg/#authentication-service-post
General Information of Schools CSV
  • School Name
  • Address
  • Postal Code
https://data.gov.sg/dataset/school-directory-and-information?view_id=ba7c477d-a077-4303-96a1-ac1d4f25b190&resource_id=ede26d32-01af-4228-b1ed-f05c45a1d8ee
Route Data CSV
  • Distance
  • Duration
  • Location
  • Destination
https://cran.r-project.org/web/packages/osrm/index.html


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 12 Application Development and Deployment Brendo and Peng Chong
6 Week 13 Poster Submission Brendo and Rebecca
7 Week 14 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.