Difference between revisions of "AY1516 T2 Team CommuteThere Data"

From Analytics Practicum
Jump to navigation Jump to search
 
(7 intermediate revisions by 2 users not shown)
Line 11: Line 11:
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #0091b3" width="210px" |   
 
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #0091b3" width="210px" |   
 
[[AY1516_T2_Team_CommuteThere_Overview|<font color="#3c3c3c"><strong>PROJECT OVERVIEW</strong></font>]]
 
[[AY1516_T2_Team_CommuteThere_Overview|<font color="#3c3c3c"><strong>PROJECT OVERVIEW</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" | 
 +
[[AY1516_T2_Team_CommuteThere_Project_Data_Preparation|<font color="#3c3c3c"><strong>ANALYSIS & FINDINGS</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" |   
Line 18: Line 21:
 
[[AY1516_T2_Team_CommuteThere_Main Deliverables|<font color="#3c3c3c"><strong>DOCUMENTATION</strong></font>]]
 
[[AY1516_T2_Team_CommuteThere_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" | 
 
[[AY1516_T2_Team_CommuteThere_Analysis_Findings|<font color="#3c3c3c"><strong>ANALYSIS & FINDINGS</strong></font>]]
 
 
|}
 
|}
 
</center>
 
</center>
Line 45: Line 46:
 
<!-- 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</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: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left">
 +
 
 +
<center>
 +
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; font-size:15px" width="85%"
 +
|- style="background:#f2f4f4; font-size:17px"
  
<font face="Open Sans, Arial, sans-serif">
 
{| class="wikitable"
 
 
|-
 
|-
! Data !! Provided by/ Method of retrieving
+
| style="font-family:Open Sans, Arial, sans-serif; font-size:16px; text-align: center; padding:5px; border-bottom:solid #0091b3" | <font color="#3c3c3c"><strong>Data Provider</strong></font>
 +
| style="font-family:Open Sans, Arial, sans-serif; font-size:16px; text-align: center; padding:5px; border-bottom:solid #0091b3" | <font color="#3c3c3c"><strong>Description</strong></font>
 +
 
 
|-
 
|-
|  
+
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Living Analytics Research Center(LARC)</strong>
Ez-link data
+
| style="font-family:Open Sans, Arial, sans-serif; text-align: left; padding:3px 10px; border-bottom:solid 1px #d8d8d8" |
||
+
*Ez-link and MRT dataset from 9 January 2012 - 15 January 2012
LARC
+
*Geographical coordinates of the bus stops
 +
*Bus stops ID and name
 +
*Actual bus service number and ID
 +
 
 
|-
 
|-
|
+
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Data.gov.sg </strong>
Points of Interest
+
| style="font-family:Open Sans, Arial, sans-serif; text-align: left; padding:3px 10px; border-bottom:solid 1px #d8d8d8" |
||
+
*Planning area boundary shapefile
Openstreetmap<br>
+
*Points of Interests (POIs)
Data.gov.sg<br>
+
**MRT stations
LTA data mall <br>
+
**Schools (Primary, Secondary & Junior Colleges)
Onemap
+
**Shopping malls
 +
**Sports complex
 +
**Parks
 +
**Childcare
 +
**Community centers
 +
 
 
|-
 
|-
| Pedestrian network 
+
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Open Street Map (OSM)</strong>
||
+
| style="font-family:Open Sans, Arial, sans-serif; text-align: left; padding:3px 10px; border-bottom:solid 1px #d8d8d8" |  
Manually mapped out through:
+
*Buildings shapefile
*Conducting site visits
+
*Road shapefile
*Integration of road network.
 
 
|}
 
|}
</font>
+
</center>
 +
 
 
</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: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left">
  
 +
<center>
 +
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; font-size:15px" width="60%"
 +
|- style="background:#f2f4f4; font-size:17px"
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; font-size:16px; text-align: center; padding:5px; border-bottom:solid #0091b3" | <font color="#3c3c3c"><strong>Variables</strong></font>
 +
| style="font-family:Open Sans, Arial, sans-serif; font-size:16px; text-align: center; padding:5px; border-bottom:solid #0091b3" | <font color="#3c3c3c"><strong>Description</strong></font>
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Card_number_e</strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" |
 +
Commuter’s ez-link card number
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Transport </strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" |
 +
Mode of transportation eg. Bus, Rapid Transit System
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Entry date </strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | Commuter’s tap in date
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Entry time </strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | Commuter’s tap in time
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Exit date </strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | Commuter’s tap out date
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Exit time </strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | Commuter’s tap out time
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Commuter_category </strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | Adult, Senior Citizen (Elderly) or Student
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Origin_location id </strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | Origin  bus stop/train station id
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Destination_location id </strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | Destination  bus stop/train station id
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Bus service </strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | Bus service number
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Distance_travelled </strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | Distance of the journey
 +
 +
|-
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | <strong>Travelling_time </strong>
 +
| style="font-family:Open Sans, Arial, sans-serif; text-align: center; padding:3px 10px; border-bottom:solid 1px #d8d8d8" | Time taken to complete journey
 +
|}
 +
</center>
 +
 +
</div>
 
<!-- End Body --->
 
<!-- End Body --->

Latest revision as of 10:30, 17 April 2016

Commutetherelogo.png

HOME

PROJECT OVERVIEW

ANALYSIS & FINDINGS

PROJECT MANAGEMENT

DOCUMENTATION

Overview

Review of Previous Work

Data

Methodology

Data

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.sg
  • Planning area boundary shapefile
  • Points of Interests (POIs)
    • MRT stations
    • Schools (Primary, Secondary & Junior Colleges)
    • Shopping malls
    • Sports complex
    • Parks
    • Childcare
    • Community centers
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, Senior Citizen (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