A consolidated list of all open datasets available in Dubai Pulse along with their attributes details such as names, descriptions, classifications and types. This list helps analysts and other data users to find the data that they need.
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.
having any query feel free to contact us.
Done
Send Feedback
CSV
Field | Value | |||||||
---|---|---|---|---|---|---|---|---|
Data Provenance | Data Provenance | |||||||
Dataset Source | Source | |||||||
Format | CSV | |||||||
Created | 18 Oct 2021 | |||||||
Last updated | 24 Apr 2024 | |||||||
Frequency of Update on Source | Weekly | |||||||
Frequency of Update to SDP
|
Weekly
|
|||||||
Expected Volume/Ingestion Cycle(Daily if Real-time)
|
400 records initial load
|
|||||||
Language | 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 |
---|---|---|---|---|---|---|---|---|
entity | Primary Entity that controls the dataset | Yes | 200 | varchar2 | N | English | Open | |
dataset | Formal name of the dataset | Yes | 200 | varchar2 | N | English | Open | |
dataset_classification_type | Classification of data under which data need to be added. | No | 50 | varchar2 | N | English | Open | |
dataset_description | Statement about the dataset describes the contents and the fields included | No | 4000 | varchar2 | N | English | Open | |
dataset_id | Unique identifyer for each dataset | No | 10 | number | N | English | Open | |
attribute_order_id | Unique identifyer for each attribute per dataset | No | 10 | number | N | English | Open | |
attribute_name | The attributes names in the dataset | Yes | 200 | varchar2 | N | English | Open | |
attribute_description | Statement describing the contents and the nature of data in the attribute | No | 400 | varchar2 | N | English | Open | |
attribute_language | Language used in the data within the attribute | No | 50 | varchar2 | N | English | Open | |
attribute_classification | Security classification as per Dubai Data Law for each attribute (Open - Confidential - Sensitive - Secret) | No | 50 | varchar2 | N | English | Open | |
attribute_datatype | Format of the data type of the attribute (Text, number, ..etc.) | No | 50 | varchar2 | N | English | Open | |
attribute_format | Defines the data formatting for numeric and date time fields, for input and display. | No | 50 | varchar2 | N | English | Open | |
attribute_size | Size in number of characters or bytes of the attribute | No | 50 | number | N | English | Open | |
attribute_range_of_values | The domain of possible values for the data in the attribute | No | 50 | varchar2 | N | English | Open | |
attribute_foreign_key | Flag for a referential relationship which indicates that the attribute is a foreign key from a referenced dataset; if this value Yes please state the join rule in the next item. | No | 100 | varchar2 | N | English | Open | |
is_primary_key | Describe whether the attribute is primary key or not | No | 10 | varchar2 | N | English | Open | |
column_name | Techinical name of the columns | No | 100 | varchar2 | N | English | Open | |
Show more Show less |
Dubai Pulse Data API
Access resource data via a web API with powerful query support.
-
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.
-
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