Published by
RTA
Number of Data Files / Resources 1030
Updated: 12 Nov 2019
This dataset contains comprehensive details about all the citizens ridership in Bus
Request Permission

I acknowledge that I have read and agree to the terms and conditions

Cancel
Send Request
Your request has been successfully submitted
You will receive a confirmation within 14days time period. If you are
having any query feel free to contact us.
Done
Field Value
Data Provenance
Tags / Keywords one two three four five
Dataset Source ITIC
Language
Remarks/Special Business Rules In progress
Coverage (Geographic area)
Dataset Temporal Windows
Incremental for the day before upload
Rights
N/A
Frequency of Update on Source
daily
Frequency of Update to SDP
daily
Expected Volume/Ingestion Cycle(Daily if Real-time)
100 -> 500
Source Platform Type
ITIC is the RTA Corporate Data Warehouse
Already Shared?
Y
If Shared, with which Entities?
Shared for Dubai Data Pilot
Already Published?
Y
If Published, where?
Published as statistical data in RTA Website & Dubai Statistics Center Website
Attribute Name Attribute Description Attribute Language Attribute Classification Attribute Datatype Attribute Size Attribute Range of Values Attribute Foreign Key
txn_type Transaction type (e.g. Check In, Check Out) Open NVARCHAR(5) 5 “Check In”, “Check Out”
txn_date Date on which the transaction is processed by SP Open DATE Dates “YYYY-MM-DD”
txn_time Time at which the transaction is processed by the device Open TIME Time “hh:mm:ss“
start_location Entry gate location of the transaction e.g. stop name Open VARCHAR(200) 200 Values in “STOP_NAME” in “Bus Stops” Dataset
end_location Upload location of the transaction e.g. stop name Open VARCHAR(200) 200 Values in “STOP_NAME” in “Bus Stops” Dataset
route_name Bus Route Name Open VARCHAR(100) 100 Values in “ROUTE_NAME” In “Bus Routes” Dataset
start_zone Trip start zone Open VARCHAR(6) 6 “Zone 0”, “Zone 1” , “Zone 2” , “Zone 3” , “Zone 4” , “Zone 5” , “Zone 6” , “Zone 7” , “Zone 8” , “Zone 9”
end_zone Zone Name Open VARCHAR(6) 6 “Zone 0”, “Zone 1” , “Zone 2” , “Zone 3” , “Zone 4” , “Zone 5” , “Zone 6” , “Zone 7” , “Zone 8” , “Zone 9”