Difference between revisions of "AY1516 T2 Team CommuteThere Data"

From Analytics Practicum
Jump to navigation Jump to search
Line 45: Line 45:
 
<!-- 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="80%"
 +
|- style="background:#f2f4f4; font-size:17px"
  
<font face="Open Sans, Arial, sans-serif">
 
{| class="wikitable"
 
 
|-
 
|-
! Data Provider !! 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>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>
Living Analytics Research Center(LARC)
+
| 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
 
*Ez-link and MRT dataset from 9 January 2012 - 15 January 2012
 
*Geographical coordinates of the bus stops
 
*Geographical coordinates of the bus stops
 
*Bus stops ID and name  
 
*Bus stops ID and name  
 
*Actual bus service number and ID  
 
*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>
|
+
| style="font-family:Open Sans, Arial, sans-serif; text-align: left; padding:3px 10px; border-bottom:solid 1px #d8d8d8" |  
Data.gov  
 
||
 
 
*Planning area boundary shapefile
 
*Planning area boundary shapefile
 
*Points of Interests (POIs)
 
*Points of Interests (POIs)
Line 75: Line 77:
  
 
|-
 
|-
 
+
| 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" |  
Open Street Map (OSM)
 
||
 
 
*Buildings shapefile
 
*Buildings shapefile
 
*Road shapefile  
 
*Road shapefile  
 
|}
 
|}
</font>
+
</center>
 +
 
 
</div>
 
</div>
 
<!-- End Body --->
 
<!-- End Body --->

Revision as of 09:55, 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, 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