Year-end Sale % OFF 
Abstract
In the case of passengers taking the subway many times in a short time, missing cards in and out of the station, and staying in the subway station for a long time, the previous table join method cannot accurately set the time threshold parameters and correctly match the OD pairs of passengers. In order to solve these problems, an OD matching method based on analysis function is proposed in this paper. LAG () is an analytic function in Oracle which allows you to access the row at a given offset prior to the current row without using a self-join. Metro IC card dataset stores the card swiping records of passengers entering and leaving the subway station every time. In this method, the dataset is sorted in ascending order according to the card number and card swiping time, and then, the lag function of Oracle is used to take the offset of the upper line of card ID, transaction date, transaction time, in and out sign, and station ID. Finally, the matching process is completed according to the OD conditions of card number, time, and inbound and outbound sign fields. This method does not need to set a time threshold and so as to deal with the situation where passengers stay too long in the subway station. The OD matching results on in and out IC swiping cards dataset in April and May 2019 of passengers of Xiamen Metro Line verify that analysis function method has better OD matching, missing swiping identification accuracy, and effect compared to the table join method.
Highlights
With the rapid development of economy, rail transit has become the development trend of the city
Compared with the method based on table join, this paper proposes an origin destination (OD) matching algorithm based on analysis function for metro IC card data analysis
(1) Using the original IC card data, the OD results obtained by the analysis function method are compared with the OD results based on the table join method
Summary
With the rapid development of economy, rail transit has become the development trend of the city. E metro OD matching algorithm based on the analysis function mainly uses the lag function of Oracle to replace the table join In this method, the dataset is sorted in ascending order according to the card number and card swiping time, and the lag function of Oracle is used to take the offset of the upper line of five related fields. (1) Select the fields of card number, transaction date, transaction time, inbound and outbound flag, and station ID from the original data table, and change the transaction time into seconds. Taking the metro IC card data in May 2019 as an example, the OD matching SQL statement based on analysis function is as follows:. E following SQL statement uses the LAG () function to get the offsets of the five fields for the metro IC card data in May 2019. Dataset: select the metro IC card data, static station information data, and static card type data in April and May 2019
Sign-in/Register to view highlights & summary Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
