Difference between revisions of "Time-series Analysis on Singapore Public Transportation Train Network Data Source"
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> | ||
|} | |} | ||
− | + | 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
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.