Difference between revisions of "AY1516 T2 Team WalkThere Methodology"

From Analytics Practicum
Jump to navigation Jump to search
 
(38 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
<center>
 
<center>
<!------- Insert Logo Here---->
+
[[File:TeamWalkThereLogo.jpg]]
 
 
 
</center>
 
</center>
<br>
 
  
 
<!------- Main Navigation Bar---->
 
<!------- Main Navigation Bar---->
Line 18: Line 16:
  
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="190px" |   
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="190px" |   
[[AY1516_T2_Team_WalkThere_Documentation|<font color="#3c3c3c"><strong>DOCUMENTATION</strong></font>]]
+
[[AY1516_T2_Team_WalkThere_Main Deliverables|<font color="#3c3c3c"><strong>DOCUMENTATION</strong></font>]]
  
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="230px" |   
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="230px" |   
[[AY1516_T2_Team_WalkThere_Analysis_Findings|<font color="#3c3c3c"><strong>ANALYSIS & FINDINGS</strong></font>]]
+
[[AY1516_T2_Team_WalkThere_Project_Interim_Progress|<font color="#3c3c3c"><strong>ANALYSIS & FINDINGS</strong></font>]]
 
|}
 
|}
 
</center>
 
</center>
Line 30: Line 28:
 
<center>
 
<center>
 
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px;" width="80%"|
 
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px;" width="80%"|
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #f5f5f5; background-color: #f5f5f5" width="200px" |  
+
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="200px" |  
 
[[AY1516_T2_Team_WalkThere_Overview|<font color="#3c3c3c"><strong>Overview</strong></font>]]
 
[[AY1516_T2_Team_WalkThere_Overview|<font color="#3c3c3c"><strong>Overview</strong></font>]]
  
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="200px" |   
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="200px" |   
[[AY1516_T2_Team_WalkThere_Sponsor|<font color="#3c3c3c"><strong>About Sponsor</strong></font>]]
+
[[AY1516_T2_Team_WalkThere_ReviewofPreviousWork|<font color="#3c3c3c"><strong>Review of Previous Work</strong></font>]]
  
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="200px" |   
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="200px" |   
Line 47: Line 45:
  
 
<!-- Body -->
 
<!-- Body -->
==<div style="background: #ffffff; padding: 17px; line-height: 0.1em;  text-indent: 10px; font-size:17px; font-family: Helvetica;  border-left:8px solid #0091b3"><font color= #000000><strong>Methodology</strong></font></div>==
+
==<div style="font-family:Open Sans, Arial, sans-serif; background: #ffffff; padding: 17px; line-height: 0.1em;  text-indent: 10px; font-size:17px; border-left:8px solid #0091b3"><font color= #000000><strong>Methodology</strong></font></div>==
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; text-align:left">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; text-align:left">
 +
<font face="Open Sans, Arial, sans-serif;">
 +
===Part 1: Identify Commuter Patterns===
 +
This analysis aims to identify commuter patterns of each demographic groups - students, adults and elderly - as each group has differing interests and preferences in the places to frequent at. These patterns are recognized by areas with high volumes of people commuting by bus using the ez-link data. We aim to identify any commonalities where people travel for short distances, with only a few bus stops, within journeys, as well as recognize what are the common places of interests that the various demographic groups frequent at and at what periods of the week.
 +
 +
 +
Our data for this analysis consists of the following:
 +
 +
<u>1.Ez-link transactions</u><br>
 +
With the support from LARC, we were able to obtain ez-link transactions data from 20 to 26 January 2014. We have selected just a week of data in January 2014 because the travelling patterns for each week in a month are similar and there are neither no public holidays nor school holidays in the selected week for analysis. However, regardless of scaling down the data into just a week’s period, there are still millions of transactions presented. As such, analysis of the data will be further scaled down to grouping the transactions based on demographic profiles, followed by aggregating the timings of transactions to every 15 minutes given that the timings presented come in seconds.
 +
 +
<u>2.Points of interests</u><br>
 +
Given that the places that each demographic groups frequent at varies due to differing interests and preferences, to include points of interests (POI) in this analysis will be helpful to understand which places attract various groups of people at various periods of the week. With that, our team conclude that POI should be places that serve the primary needs of the people. As such, POI include:<br>
 +
 +
• MRT stations<br>
 +
• Schools (primary, secondary, pre-tertiary and tertiary education)<br>
 +
• Shopping malls<br>
 +
• Sports complex<br>
 +
• Parks<br>
 +
• Childcare<br>
 +
• Community centers<br>
 +
• Shapefiles for the identified POI can be retrieved from data.gov.sg, Openstreetmap, Onemap and LTA Data Mall<br>
 +
 +
===Part 2: Identify Gaps in Infrastructure===
 +
After conducting the analysis in part 1, various POIs for the various age groups are identified. Certain places will attract a particular age group more and this leads us to question whether these places serve that particular age group well enough?
 +
 +
The second part of analysis involves identifying gaps in the infrastructure within Tampines planning area. Why are people commuting by bus instead of walking? Will safety be compromised if people choose to walk? Or are there roads hindering the connectivity between the point of start with the destination? Thus, the second part of this analysis aims to highlight areas where the time taken to travel by bus is longer than walking and recommend improvements to the  current infrastructure to encourage people to walk. 
 +
 +
Our data for this analysis consists of the following:
 +
  
We will be doing our research on an area in Tampines East Zone 2 (the purple region) to identify the connectivity of the given residential blocks to the points of interests.  
+
<u>1. Mapping Out Pedestrian Network</u><br>
 +
We will map out the pedestrian network around the various POIs identified. This data allows us to understand whether pedestrians can arrive at their destinations via walking. This data is available to us on OSM. Furthermore, we will also make use of raster analysis where we will draw a 5m x 5x square over residential buildings. The combination of raster layer and pedestrian network from OSM will allow us to find out the shortest walking path from the origin to the destination.  
  
=== Objective 1: Identify how accessible the facilities, that are within walking distance and meet the basic needs, to the residents.===
+
Besides using raster analysis, we will also make use of other geospatial tools such as pgrouting to allow us to map out the shortest walking path. We will then compare the various walking distance to the distance travelled by the bus and find out the difference. An average walking speed for the different age groups will also be used to find out the time taken if one choose to walk. We will then compare the time taken if one choose to walk to the time taken if one travel by bus.  
1. Using QGIS and residential blocks shapefile, draw a 400 metres buffer radius from each postal codes and identify the facilities that are within the radius. These facilities include schools, bus stops, green space, convenience stores, and places of worship.
 
2. Conduct site visit at Tampines East Zone 2 where an actual distance will be plotted with use of QGIS mobile application, Map It! While plotting out the actual distance taken to travel to the various facilities identified, areas that are in need of improvements such as areas catered to elderly, uncovered linkways, undeveloped footpath and dimly lighted pathways.
 
a. Site visits will be conducted during 5pm - 7pm on weekdays, under sunny and rainy conditions, where majority of the mobility of the residents can be observed.
 
b. The actual distances to various facilities will show the real distance of travelling despite having the facilities being located within the 400 metres buffer radius.
 
3. Display a heatmap of the travelled lines where the colour of the lines show the time taken to travel by 2 categories of pedestrians - young and old.
 
a. Young individual: 5.4 km/hour
 
b. Old individual: 4.6 km/hour
 
  
=== Objective 2: Fine-tune the design of the residential areas to ensure that the points of interests are connected and are well-served to the needs of the residents (based on demographics - elderly and children)===
+
<u>2.Bus routes</u><br>
 +
Busrouters.sg is an online portal where bus routes in Singapore are displayed in a map version. Data for bus routes is public available by the developer. The bus routes are updated to the latest bus profiles provided by the Land Transport Authority (LTA). However, the bus routes are published in json format. In order for us to conduct geospatial analysis using QGIS, a conversion of json to csv format is required. Besides having the bus routes plotted out in lines using QGIS, we realized that it is also important to have the bus stops included in the bus routes, where points of the bus stops and lines of the bus routes are snapped as a whole. Busrouters.sg has provided data of bus stops for each bus services. With that information, our team will be working on incorporating bus stops with the routes using PostGIS and QGIS.
  
 +
</font>
 
</div>
 
</div>
  
==<div style="background: #ffffff; padding: 17px; line-height: 0.1em;  text-indent: 10px; font-size:17px; font-family: Helvetica;  border-left:8px solid #0091b3"><font color= #000000><strong>Work Scope</strong></font></div>==
+
==<div style="font-family:Open Sans, Arial, sans-serif; background: #ffffff; padding: 17px; line-height: 0.1em;  text-indent: 10px; font-size:17px; border-left:8px solid #0091b3"><font color= #000000><strong>Work Scope</strong></font></div>==
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; text-align:left">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; text-align:left">
  
</div>
+
<font face="Open Sans, Arial, sans-serif;">
 +
=== Literature Study ===
 +
To understand previous studies on walkability in Singapore and in other countries, and the types of infrastructures that can be introduced so as to be able to make recommendations to improve the connectivity between residential estates and points of interest.
 +
 
 +
=== Software Learning ===
 +
Learn how to use the QGis software, both on the laptop as well as on the mobile phone (to aid data collection)
 +
 
 +
=== Data Collection ===
 +
Ez-link data will be provided by LARC while points of interests data sets are publicly available on Openstreetmap, Data.gov.sg, LTA data mall and Onemap. Pedestrian network will be manually mapped out through conducting site visits and with the integration of road network.
 +
 
 +
=== Data Exploration ===
 +
Ez-link data of one week will be segmented into 3 sections for analysis: student, adult and elderly. Each team members has to identify trends and patterns for each profile groups with the use of analytics tools such as JMP and QGIS.
 +
 
 +
=== Geospatial Analysis ===
 +
Using QGIS, for the following:<br>
 +
• Commuters behaviours throughout the entire one week.<br>
 +
• Map out paths that residents may take from their houses to identified points of interest<br>
 +
• Understand the coverage of street lamps to analyse the safety of walking paths at night. Through measuring the radius of coverage and the height of the lamp post, we can understand how the distribution of the lamp post should be placed.<br>
  
==<div style="background: #ffffff; padding: 17px; line-height: 0.1em;  text-indent: 10px; font-size:17px; font-family: Helvetica;  border-left:8px solid #0091b3"><font color= #000000><strong>Proposed Timeline</strong></font></div>==
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; text-align:left">
 
  
 +
</font>
 
</div>
 
</div>
<!-- End Body --->
 

Latest revision as of 22:12, 6 March 2016

TeamWalkThereLogo.jpg

HOME

PROJECT OVERVIEW

PROJECT MANAGEMENT

DOCUMENTATION

ANALYSIS & FINDINGS

Overview

Review of Previous Work

Data

Methodology

Methodology

Part 1: Identify Commuter Patterns

This analysis aims to identify commuter patterns of each demographic groups - students, adults and elderly - as each group has differing interests and preferences in the places to frequent at. These patterns are recognized by areas with high volumes of people commuting by bus using the ez-link data. We aim to identify any commonalities where people travel for short distances, with only a few bus stops, within journeys, as well as recognize what are the common places of interests that the various demographic groups frequent at and at what periods of the week.


Our data for this analysis consists of the following:

1.Ez-link transactions
With the support from LARC, we were able to obtain ez-link transactions data from 20 to 26 January 2014. We have selected just a week of data in January 2014 because the travelling patterns for each week in a month are similar and there are neither no public holidays nor school holidays in the selected week for analysis. However, regardless of scaling down the data into just a week’s period, there are still millions of transactions presented. As such, analysis of the data will be further scaled down to grouping the transactions based on demographic profiles, followed by aggregating the timings of transactions to every 15 minutes given that the timings presented come in seconds.

2.Points of interests
Given that the places that each demographic groups frequent at varies due to differing interests and preferences, to include points of interests (POI) in this analysis will be helpful to understand which places attract various groups of people at various periods of the week. With that, our team conclude that POI should be places that serve the primary needs of the people. As such, POI include:

• MRT stations
• Schools (primary, secondary, pre-tertiary and tertiary education)
• Shopping malls
• Sports complex
• Parks
• Childcare
• Community centers
• Shapefiles for the identified POI can be retrieved from data.gov.sg, Openstreetmap, Onemap and LTA Data Mall

Part 2: Identify Gaps in Infrastructure

After conducting the analysis in part 1, various POIs for the various age groups are identified. Certain places will attract a particular age group more and this leads us to question whether these places serve that particular age group well enough?

The second part of analysis involves identifying gaps in the infrastructure within Tampines planning area. Why are people commuting by bus instead of walking? Will safety be compromised if people choose to walk? Or are there roads hindering the connectivity between the point of start with the destination? Thus, the second part of this analysis aims to highlight areas where the time taken to travel by bus is longer than walking and recommend improvements to the current infrastructure to encourage people to walk.

Our data for this analysis consists of the following:


1. Mapping Out Pedestrian Network
We will map out the pedestrian network around the various POIs identified. This data allows us to understand whether pedestrians can arrive at their destinations via walking. This data is available to us on OSM. Furthermore, we will also make use of raster analysis where we will draw a 5m x 5x square over residential buildings. The combination of raster layer and pedestrian network from OSM will allow us to find out the shortest walking path from the origin to the destination.

Besides using raster analysis, we will also make use of other geospatial tools such as pgrouting to allow us to map out the shortest walking path. We will then compare the various walking distance to the distance travelled by the bus and find out the difference. An average walking speed for the different age groups will also be used to find out the time taken if one choose to walk. We will then compare the time taken if one choose to walk to the time taken if one travel by bus.

2.Bus routes
Busrouters.sg is an online portal where bus routes in Singapore are displayed in a map version. Data for bus routes is public available by the developer. The bus routes are updated to the latest bus profiles provided by the Land Transport Authority (LTA). However, the bus routes are published in json format. In order for us to conduct geospatial analysis using QGIS, a conversion of json to csv format is required. Besides having the bus routes plotted out in lines using QGIS, we realized that it is also important to have the bus stops included in the bus routes, where points of the bus stops and lines of the bus routes are snapped as a whole. Busrouters.sg has provided data of bus stops for each bus services. With that information, our team will be working on incorporating bus stops with the routes using PostGIS and QGIS.

Work Scope

Literature Study

To understand previous studies on walkability in Singapore and in other countries, and the types of infrastructures that can be introduced so as to be able to make recommendations to improve the connectivity between residential estates and points of interest.

Software Learning

Learn how to use the QGis software, both on the laptop as well as on the mobile phone (to aid data collection)

Data Collection

Ez-link data will be provided by LARC while points of interests data sets are publicly available on Openstreetmap, Data.gov.sg, LTA data mall and Onemap. Pedestrian network will be manually mapped out through conducting site visits and with the integration of road network.

Data Exploration

Ez-link data of one week will be segmented into 3 sections for analysis: student, adult and elderly. Each team members has to identify trends and patterns for each profile groups with the use of analytics tools such as JMP and QGIS.

Geospatial Analysis

Using QGIS, for the following:
• Commuters behaviours throughout the entire one week.
• Map out paths that residents may take from their houses to identified points of interest
• Understand the coverage of street lamps to analyse the safety of walking paths at night. Through measuring the radius of coverage and the height of the lamp post, we can understand how the distribution of the lamp post should be placed.