rta_public_transportation_stations-open

Published by
Roads and Transport Authority (RTA) Powered by
Number of Data Files / Resources 1
Updated: 24 Jul 2024
Open Data
This dataset contains comprehensive details about transportation stations
Show more
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
Send Feedback
Public_Transportation_Stations.csv
Updated: 24 Jul 2024 File Size : 0.05 MB
CSV
Field Value
Data Provenance Transportation system department
Dataset Source SDSC
Format CSV
Created 25 Nov 2020
Last updated 24 Jul 2024
Frequency of Update on Source Others
Frequency of Update to SDP
Quarterly
Expected Volume/Ingestion Cycle(Daily if Real-time)
Language English~English~Arabic~English~English~Arabic~English~English~English~English~English~English~English~English~English~English~English~English~English~English~English~English~English~English~English~English~English~English~English~English~English
State active
Rights ,Who has rights for attribute
License notspecified
Show more
Name Description Primary Key Size Datatype Foreign Key Range of Values Language Classification
transport_mode Metro ,Tram, Marine and Bus Yes 50 nvarchar No English Open
station_name_english Station name in English No 200 nvarchar English Open
station_name_arabic Station name in Arabic No 50 nvarchar Arabic Open
station_number Station code Yes 50 nvarchar English Open
station_location_type_english Station construction location (Elevated / Underground) in English No 50 nvarchar English Open
station_location_type_arabic Station construction location (Elevated / Underground) in Arabic No 50 nvarchar Arabic Open
current_service_status station service status No 50 nvarchar English Open
number_stops Number of Bus Stops in the Station (if transport mode is Bus) No 3 numeric English Open
number_layby Number of Laybys in the Station (if transport mode is Bus) No 3 numeric English Open
customer_facilities Facility availability such as WiFi, Restrooms, Waiting Area, Air-conditioning, Shopping, Restaurants, Café, Vending Machines. No 200 nvarchar English Open
parking_facilities Availability of short-term and long-term parking. No 50 nvarchar English Open
zone_id Zone ID No 50 nvarchar English Open
line_name Metro Line Name (Value = Red or Green),and the all route name in case of Bus No 250 nvarchar English Open
station_location_longitude Longitude part of Bus Stop Coordinate No 9 numeric English Open
station_location_latitude Latitude part of Bus Stop Coordinate No 9 numeric English Open
station_opening_date Station Opening Date No 10 date DD/MM/YYYY English Open
station_closing_date Station Closing Date No 10 date DD/MM/YYYY English Open
station_starttime_saturday station opening time on Saturday No 5 timestamp HH24:MI English Open
station_endtime_saturday station closing time on Saturday No 5 timestamp HH24:MI English Open
station_starttime_sunday station opening time on Sunday No 5 timestamp HH24:MI English Open
station_endtime_sunday station closing time on Sunday No 5 timestamp HH24:MI English Open
station_starttime_monday station opening time on Monday No 5 timestamp HH24:MI English Open
station_endtime_monday station closing time on Monday No 5 timestamp HH24:MI English Open
station_starttime_tuesday station opening time on Tuesday No 5 timestamp HH24:MI English Open
station_endtime_tuesday station closing time on Tuesday No 5 timestamp HH24:MI English Open
station_starttime_wednesday station opening time on Wednesday No 5 timestamp HH24:MI English Open
station_endtime_wednesday station closing time on Wednesday No 5 timestamp HH24:MI English Open
station_starttime_thursday station opening time on Thursday No 5 timestamp HH24:MI English Open
station_endtime_thursday station closing time on Thursday No 5 timestamp HH24:MI English Open
station_starttime_friday station opening time on Friday No 5 timestamp HH24:MI English Open
station_endtime_friday station closing time on Friday No 5 timestamp HH24:MI English Open
Show more Show less

Dubai Pulse Data API

Access resource data via a web API with powerful query support.

Endpoints
Expand
Collapse
The Data API can be accessed via the following actions of the CKAN action API.
  • Query
    https://www.dubaipulse.gov.ae/dataset/fd25f886-5c7a-496e-b547-0bed0df5f5ef/resource/75ee9a69-9744-4356-91ea-66d4713a9f1d/download/public_transportation_stations.csv
How to Use?
Expand
Collapse
  • End Users will receive "API Key" and "API Secret" in two separate emails on the first time Grant of a Dataset, first Purchase of a Commercial Dataset, or Purchase of an API Package. This API Key and API Secret combination should be used to generate API token and the token will need to be included in the http headers of every API call made.

    Authentication Service to generate API token: https://api.dubaipulse.gov.ae/oauth/client_credential/accesstoken?grant_type=client_credentials with body 'client_id={API Key}&client_secret={API Secret}

    Read the value of "access_token" from the response of the above service and use it in the header of every API call. The obtained API token is valid for certain duration (for example 30 minutes) after which a fresh token needs to be obtained.

    Header Name : Authorization
    Value : Bearer {access_token}

  • Query Parameters
    API calls can be made for full dataset result (subject to maximum results limit) or to a subset of results. Different filters can be applied on the results. Developers can use the attributes to apply a combination of filters with and/or conditions.
  • Limiting the Response Size
    Developers can limit the number of records returned by an API call passing the "Limit" parameter in the call. The value of the "Limit" must be less than the allowed maximum limit.
  • Limiting the Attributes
    Developers can limit the API response to specific set of attributes by passing the attribute names in the API call. The example below explains how the attributes can be specified in the API call. This feature can be used in conjunction with query parameters.
Examples
Expand
Collapse
  • Curl Command Sample:
    curl -X GET --header "Authorization: qMtn6xQapeouAlirfHXD7DWJFabV" "https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api"
  • Query Samples:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?filter=location_id=223 AND zone_id=2 https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?filter=location_id=223 OR zone_id=2
  • Record Limit Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?limit=10
  • Record Offset Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?order_by=primary_key_attribute&offset=10
  • Record Order By Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?order_by=location_id
  • Attribute Limiting Sample:
    https://api.dubaipulse.gov.ae/shared/rta/rta_tram_stations-open-api?filter=location_id=223 OR zone_id=2 &column=zone_id,line_name,location_id