Number of Data Files / Resources 1
Updated: 18 Mar 2024
Project Level information
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
Updated: 18 Mar 2024 File Size : 104.62 MB
CSV
Field Value
Data Provenance 1. Project Information is generated once project is created by consultant/ contractor. 2. Project is directly related to Parcel Number and owner 3. Table used PRT_CASES
Dataset Source Oracle Database
Format CSV
Created 29 Jul 2019
Last updated 18 Mar 2024
Frequency of Update on Source Daily
Frequency of Update to SDP
Monthly
Expected Volume/Ingestion Cycle(Daily if Real-time)
On average 350 records can be expected in a day
Language English~English~English~English~Arabic~English~Arabic~English~Arabic~English~English~English~English~English~English~English~English~English
State active
Rights
License notspecified
Name Description Primary Key Size Datatype Foreign Key Range of Values Language Classification
work_start_date Project work started date No Date N English Open
expected_completion_date Expected project completion date No Date N English Open
project_no Project Number Yes 22 Number N English Open
consultant_english Consultant Name in English No 600 Text N English Open
consultant_arabic Consultant Name in Arabic No 600 Text N Arabic Open
contractor_english Contractor Name - English No 600 Text N English Open
contractor_arabic Contractor Name - Arabic No 600 Text N Arabic Open
project_status_english Project Status - English No 100 Text N English Open
project_status_arabic Project Status - Arabic No 100 Text N Arabic Open
project_creation_date Project creation date No Date N English Open
project_completion_date Project work completion date No Date N English Open
parcel_id Parcel ID No 15 Number N English Open
related_entity_name_en Project Related entity - developer Name No 100 Text N English Open
related_entity_name_ar Project Related entity - developer Name No 100 Text N English Open
applicanttype Applicant Type No 100 Text N English Open
consultant_license_no Consultant License Number No 25 Text N English Open
contractor_license_no Contractor License Number No 25 Text N English Open
permit_date The first permit issued date on the project No Date N English Open

Dubai Pulse Data API

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

The Data API can be accessed via the following actions of the CKAN action API.
  • Query
    https://www.dubaipulse.gov.ae/dataset/9cf35f27-6513-46fe-92bc-914cafd5ee35/resource/295296c6-97dd-48d3-9203-4bd307720b65/download/project_information.csv
  • 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