Difference between revisions of "Time-series Analysis on Singapore Public Transportation Train Network Data Source"

From Analytics Practicum
Jump to navigation Jump to search
Line 36: Line 36:
 
| style="padding:0.3em; font-family:Georgia; font-size:100%; border-bottom:2px solid #626262; border-left:2px #FFFFFF; background: #FFFFFF; text-align:left;" width="20%" | <font color="#FE2EC8" size="3em">Source<br></font>
 
| style="padding:0.3em; font-family:Georgia; font-size:100%; border-bottom:2px solid #626262; border-left:2px #FFFFFF; background: #FFFFFF; text-align:left;" width="20%" | <font color="#FE2EC8" size="3em">Source<br></font>
 
|}
 
|}
−
For the project, Land Transport Authority (LTA) provides the data sets through LARC research labs. The dataset is a weeks’ worth of smart card (EZ-Link) transaction used in Singapore’s public transport. The data consist of both bus and also MRT transaction. For this project we will require only MRT transactions.
+
Land Transport Authority (LTA) provides the data sets through Learning Analytics Research Centre (LARC) research labs. The dataset provided by LARC is currently from a MySQL database which consists of the following tables:
 +
*Bus_service_mapping
 +
*Location_gis_mapping
 +
*Location_mapping
 +
*Lta_ride
 +
The dataset is a weeks’ worth of smart card (EZ-Link) transactions used in Singapore’s public transport and it consists of both bus and MRT transactions. As we are only interested in the MRT transactions, we will be looking into 2 tables basically Location_mapping and Lta_ride. We extracted the data by taking a database dump and added a conditional statement to filter transport_type by "RTS" to only include the train dataset.

Revision as of 22:03, 21 April 2015

Home

Project Overview

 

Findings

 

Project Documentation

 

Project Management

Background Data Source Methodology
Source

Land Transport Authority (LTA) provides the data sets through Learning Analytics Research Centre (LARC) research labs. The dataset provided by LARC is currently from a MySQL database which consists of the following tables:

  • Bus_service_mapping
  • Location_gis_mapping
  • Location_mapping
  • Lta_ride

The dataset is a weeks’ worth of smart card (EZ-Link) transactions used in Singapore’s public transport and it consists of both bus and MRT transactions. As we are only interested in the MRT transactions, we will be looking into 2 tables basically Location_mapping and Lta_ride. We extracted the data by taking a database dump and added a conditional statement to filter transport_type by "RTS" to only include the train dataset.

Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=Time-series_Analysis_on_Singapore_Public_Transportation_Train_Network_Data_Source&oldid=2041’