Number of Data Files / Resources 1
Updated: 18 Oct 2021
This dataset contains details about all projects registered in Dubai Land Department including all the available attributes.
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 Oct 2021 File Size : 1.00 MB
CSV
Field Value
Data Provenance The project will be registered by developer(s) if: - Land is freehold. - Units will be sold. An escrow account should be created in a bank and license should be provided from DED or other zoning authorities. Master or sub developer should be the owner of the land or development contract should signed
Dataset Source TABU System
Format CSV
Created 16 Feb 2018
Last updated 18 Oct 2021
Frequency of Update on Source Upon transaction
Frequency of Update to SDP
Monthly
Expected Volume/Ingestion Cycle(Daily if Real-time)
24865
Language English~English~English~English~English~English~English~English~English~English~English~English~Arabic~English~Arabic~English~English~English~Arabic~English~English~English~Arabic~English~English~English~Arabic~English
State active
Rights N/A
License notspecified
Name Description Primary Key Size Datatype Foreign Key Range of Values Language Classification
project_id Number generated through the system Yes 10 NUMBER(10) English Open
project_number Number generated through the system No 10 NUMBER(10) English Open
project_name Name that was developed by the developer No 200 VARCHAR2(200) English Open
developer_id Number generated through the system No 10 NUMBER(10) Developers.DEVELOPER_ID English Open
developer_number Number generated through the system No NUMBER English Open
developer_name DEVELOPER_NAME No 200 NVARCHAR2(200) English Open
master_developer_id Number generated through the system No 10 NUMBER(10) Developers.DEVELOPER_ID English Open
master_developer_number Number generated through the system No NUMBER English Open
master_developer_name MASTER_DEVELOPER_NAME No 200 NVARCHAR2(200) English Open
project_start_date The expected date for the start of the project No DATE (DD-MM-YYYY) English Open
project_end_date The expected date for the end of the project No DATE (DD-MM-YYYY) English Open
project_type_id Number generated through the system No NUMBER English Open
project_type_ar Project Type in Arabic No 100 NVARCHAR2(100) Arabic Open
project_classification_id Number generated through the system No 10 NUMBER(10) English Open
project_classification_ar Classification of the project : Apartment complex, Villas,..etc.. No 50 NVARCHAR2(50) Arabic Open
escrow_agent_id Number generated through the system No 10 NUMBER(10) English Open
escrow_agent_name Is the trustee Bank name No 200 NVARCHAR2(200) English Open
project_status The project Status: active, canceled, canceled at the request of the institution, canceled based on the request of the developer No 200 NVARCHAR2(200) English Open
project_status_ar The project Status: active, canceled, canceled at the request of the institution, canceled based on the request of the developer in Arabic No 100 NVARCHAR2(100) Arabic Open
percent_completed Percentage of completion is calculated by conducting an inspection request for the project No 10 NUMBER(10,3) English Open
completion_date Completion date expected date of termination of the project No DATE (DD-MM-YYYY) English Open
cancellation_date The date of cancellation date when the cancellation of the project happened No DATE (DD-MM-YYYY) English Open
project_description_ar Project description in which to write any details regarding the project by the auditor in Arabic No 2000 NVARCHAR2(2000) Arabic Open
project_description_en Project description in which to write any details regarding the project by the auditor in English No 2000 VARCHAR2(2000) English Open
property_id Number generated through the system No 10 NUMBER(10) Land_Registry.PROPERTY_ID English Open
area_id Number generated through the system No 10 NUMBER(10) English Open
area_name_ar The name of the area on which the project in Arabic No 200 NVARCHAR2(200) Arabic Open
area_name_en The name of the area on which the project in English No 200 NVARCHAR2(200) 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/0b782e64-5950-4507-8f6e-02a0c30c7054/resource/db35b0cd-d291-4dde-b176-9b8d5765c7d9/download/projects.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?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