Difference between revisions of "AY1516 T2 Team WalkThere Data"

From Analytics Practicum
Jump to navigation Jump to search
 
(17 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 21: Line 19:
  
 
| 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>
 
<!------- End of Main Navigation Bar---->
 
<!------- End of Main Navigation Bar---->
 +
 
<!------- Credits to: https://wiki.smu.edu.sg/ANLY482/Team_BEK---->
 
<!------- Credits to: https://wiki.smu.edu.sg/ANLY482/Team_BEK---->
 
 
<!------- Secondary Navigation Bar---->
 
<!------- Secondary Navigation Bar---->
 
<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: #fff" width="200px" |   
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #fff" width="200px" |   
Line 45: Line 43:
 
<!------- End of Secondary Navigation Bar---->
 
<!------- End of Secondary Navigation Bar---->
 
<!------- Credits to: https://wiki.smu.edu.sg/ANLY482/Team_BEK---->
 
<!------- Credits to: https://wiki.smu.edu.sg/ANLY482/Team_BEK---->
 
 
<!-- Body -->
 
<!-- Body -->
==<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>Data</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>Data Source</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">
  
Line 53: Line 50:
 
{| class="wikitable"
 
{| class="wikitable"
 
|-
 
|-
! Data !! Provided by/ Method of retrieving
+
! Data Provider !! Description
 
|-
 
|-
 
|  
 
|  
* Physical Infrastructure of footpath
+
Living Analytics Research Center(LARC)
* Undeveloped Infrastructure
 
* Travelling distance to POI from residential blocks
 
 
||  
 
||  
Doing a site visit to manually collect the data and collate in QGIS
+
*Ez-link and MRT dataset from 9 January 2012 - 15 January 2012
 +
*Geographical coordinates of the bus stops
 +
*Bus stops ID and name
 +
*Actual bus service number and ID
 
|-
 
|-
 +
 
|
 
|
* Residential blocks
+
Data.gov
* Points of Interest
 
 
||
 
||
Onemap
+
*Schools shapefile
 
|-
 
|-
| Demographic profile of each residential unit || Urban Redevelopment Authority
+
 
 +
|  
 +
Urban Redevelopment Authority (URA)
 +
||
 +
*Singapore Master Plan shapefile 
 +
|-
 +
 
 +
|
 +
Open Street Map (OSM)
 +
||
 +
*Buildings shapefile
 +
*Road shapefile
 
|}
 
|}
 
</font>
 
</font>
 
</div>
 
</div>
 +
<!-- End Body --->
 +
 +
==<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> Data Dictionary for Ez-Link and MRT Dataset</strong></font></div>==
 +
<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">
 +
{| class="wikitable"
 +
|-
 +
! Variables !! Description
 +
|-
 +
|Card_number_e||Commuter’s ez-link card number
 +
|-
 +
 +
|Transport||Mode of transportation eg. Bus, Rapid Transit System
 +
|-
 +
 +
|Entry date||Commuter’s tap in date 
 +
|-
 +
 +
|Entry time||Commuter’s tap in time
 +
|-
  
 +
|Exit date||Commuter’s tap out date 
 +
|-
  
 +
|Exit time||Commuter’s tap out time
 +
|-
 +
 +
|Commuter_category||Adult, Elderly or Student
 +
|-
 +
 +
|Origin_location id||Origin  bus stop/train station id
 +
|-
 +
 +
|Destination_location id||Destination  bus stop/train station id
 +
|-
 +
 +
|Bus service||Bus service number
 +
|-
 +
 +
|Distance_travelled||Distance of the journey
 +
|-
 +
 +
|Travelling_time||Time taken to complete journey
 +
 +
|}
 +
</font>
 +
</div>
 
<!-- End Body --->
 
<!-- End Body --->

Latest revision as of 00:56, 15 April 2016

TeamWalkThereLogo.jpg

HOME

PROJECT OVERVIEW

PROJECT MANAGEMENT

DOCUMENTATION

ANALYSIS & FINDINGS

Overview

Review of Previous Work

Data

Methodology

Data Source

Data Provider Description

Living Analytics Research Center(LARC)

  • Ez-link and MRT dataset from 9 January 2012 - 15 January 2012
  • Geographical coordinates of the bus stops
  • Bus stops ID and name
  • Actual bus service number and ID

Data.gov

  • Schools shapefile

Urban Redevelopment Authority (URA)

  • Singapore Master Plan shapefile

Open Street Map (OSM)

  • Buildings shapefile
  • Road shapefile

Data Dictionary for Ez-Link and MRT Dataset

Variables Description
Card_number_e Commuter’s ez-link card number
Transport Mode of transportation eg. Bus, Rapid Transit System
Entry date Commuter’s tap in date
Entry time Commuter’s tap in time
Exit date Commuter’s tap out date
Exit time Commuter’s tap out time
Commuter_category Adult, Elderly or Student
Origin_location id Origin bus stop/train station id
Destination_location id Destination bus stop/train station id
Bus service Bus service number
Distance_travelled Distance of the journey
Travelling_time Time taken to complete journey