Difference between revisions of "AY1516 T2 Team CommuteThere Data"

From Analytics Practicum
Jump to navigation Jump to search
Line 88: Line 88:
  
 
==<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="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">
+
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left">
−
<font face="Open Sans, Arial, sans-serif">
+
 
−
{| class="wikitable"
+
<center>
 +
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; font-size:15px" width="60%"  
 +
|- style="background:#f2f4f4; font-size:17px"  
 +
 
 
|-
 
|-
−
! Variables !! Description
+
| 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>
 +
 
 
|-
 
|-
−
|Card_number_e||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>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
  
−
|Transport||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
  
−
|Entry date||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
  
−
|Entry time||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
  
−
|Exit date||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
  
−
|Exit time||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
  
−
|Commuter_category||Adult, 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
  
−
|Origin_location id||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
  
−
|Destination_location id||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
  
−
|Bus service||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
  
−
|Distance_travelled||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>
  
−
|Travelling_time||Time taken to complete journey
 
−
 
−
|}
 
−
</font>
 
 
</div>
 
</div>
 
<!-- End Body --->
 
<!-- End Body --->

Revision as of 10:05, 17 April 2016

Commutetherelogo.png

HOME

PROJECT OVERVIEW

PROJECT MANAGEMENT

DOCUMENTATION

ANALYSIS & FINDINGS

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
Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=AY1516_T2_Team_CommuteThere_Data&oldid=8130’