Number of Data Files / Resources 1
Updated: 01 Feb 2023
This dataset contains comprehensive details about all type of Real-Estate Transactions, it includes all available columns
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: 01 Feb 2023 File Size : 601.68 MB
CSV
Field Value
Data Provenance All sales, mortgage, inheritance, merge, separation and sub-separation transactions are recorded by Dubai Land Dept.
Dataset Source TABU System
Format CSV
Created 06 Apr 2022
Last updated 01 Feb 2023
Frequency of Update on Source Daily
Frequency of Update to SDP
Daily
Expected Volume/Ingestion Cycle(Daily if Real-time)
598907.0,598908.0,598909.0,598910.0,598911.0,598912.0,598913.0,598914.0,598916.0,598917.0,598918.0,598919.0,598920.0,598921.0,598922.0,598923.0,598924.0,598925.0,598926.0,,598927.0,598928.0,598929.0,598930.0,598931.0,598932.0,598933.0,598934.0,598935.0,598936.0,598937.0,598938.0,598939.0,598940.0,598942.0,598943.0,598945.0,598946.0,598947.0,598948.0,598949.0,598950.0,598951.0
Language English~Arabic~English~English~Arabic~English~English~Arabic~English~English~English~English~Arabic~English~English~English~English~Arabic~English~English~Arabic~Arabic~English~Arabic~English~Arabic~English~Arabic~English~English~English~English~English~English~English~English~English~English~Arabic~English~Arabic~English~Arabic~English~English~Arabic
State active
Rights No,Personal Information (DNRD),
License notspecified
Name Description Primary Key Size Datatype Foreign Key Range of Values Language Classification
property_sub_type_en sub type of the property (ex. For units : apartment , shop , office ..etc) No 100 nvarchar English Open
property_usage_ar property use based zoning authority's regulations (Residential , Commercial , Industrial .. Etc) in Arabic No 100 nvarchar Arabic Open
property_usage_en property use based zoning authority's regulations (Residential , Commercial , Industrial .. Etc) No 100 nvarchar English Open
reg_type_id Type of registration (off-plan or existing properties) No 1 numeric English Open
reg_type_ar Type of registration (off-plan or existing properties) in Arabic No 100 nvarchar Arabic Open
reg_type_en Type of registration (off-plan or existing properties) No 100 nvarchar English Open
area_id Area (community) ID No 10 numeric English Open
area_name_ar community name in Arabic as per Dubai Municipality No 200 nvarchar Arabic Open
area_name_en community name in English as per Dubai Municipality No 200 nvarchar English Open
transaction_id A Unique ID of the transaction Yes 100 nvarchar English Open
procedure_id number generated through the system No 3 numeric English Open
trans_group_id The unique ID of transaction group No 3 numeric English Open
trans_group_ar high level group type of the transaction (Sales , Mortgages , Gifts) No 200 nvarchar Arabic Open
trans_group_en high level group type of the transaction (Sales , Mortgages , Gifts) in Arabic No 200 nvarchar English Open
procedure_name_en Sub type of the transaction (pre-registration sale , delayed sale , update mortgage , release mortgage ..etc) No 200 nvarchar English Open
instance_date Transaction registration data No 10 date DD-MM-YYYY English Open
project_number Developer's project number No 30 numeric English Open
project_name_ar Developer's project Arabic name No 200 nvarchar Arabic Open
project_name_en Developer's project English name No 200 nvarchar English Open
master_project_en master developer name in Arabic No 200 nvarchar English Open
master_project_ar master developer name in English No 200 nvarchar Arabic Open
nearest_landmark_ar the nearest landmark to the property of the transaction in Arabic No 200 nvarchar Arabic Open
nearest_landmark_en the nearest landmark to the property of the transaction in English No 200 nvarchar English Open
nearest_metro_ar the nearest metro station to the property of the transaction in Arabic No 200 nvarchar Arabic Open
nearest_metro_en the nearest metro station to the property of the transaction In English No 201 nvarchar English Open
nearest_mall_ar the nearest mall to the property of the transaction in Arabic No 202 nvarchar Arabic Open
nearest_mall_en the nearest mall to the property of the transaction in English No 203 nvarchar English Open
rooms_ar number of rooms in Arabic No 200 nvarchar Arabic Open
rooms_en number of room in English No 200 nvarchar English Open
has_parking does the unit has a parking ? (0=No, 1=Yes) No 1 numeric English Open
procedure_area The area (size) in suare meter on which the transaction was carried out No 18 numeric English Open
actual_worth property price in the transaction No 8 numeric English Open
meter_sale_price meter price in the transaction No 18 numeric English Open
rent_value the mortgage value in lease to own procedures No 8 numeric English Open
meter_rent_price the mortgage price per meter in lease to own procedures No 8 numeric English Open
no_of_parties_role_1 number of transaction's parties with first role (seller , mortgagor .. Etc ) No 3 numeric English Open
no_of_parties_role_2 number of transaction's parties of second role (buyer , mortgagee .. Etc ) No 3 numeric English Open
no_of_parties_role_3 number of transaction's parties of third role (lessee , usufrutor .. Etc ) No 3 numeric English Open
building_name_ar Building name in Arabic a given by the developer (not nessesarly to similar to common name) No 200 nvarchar Arabic Open
building_name_en Building name in English given by the developer (not nessesarly to similar to common name) No 200 nvarchar English Open
procedure_name_ar Sub type of the transaction (pre-registration sale , delayed sale , update mortgage , release mortgage ..etc) in Arabic No 200 nvarchar Arabic Open
property_type_id number generated through the system No 4 numeric English Open
property_type_ar main type of the property (land , Building , villa or unit) in Arabic No 50 nvarchar Arabic Open
property_type_en main type of the property (land , Building , villa or unit) No 50 nvarchar English Open
property_sub_type_id PROPERTY_SUB_TYPE_ID No 10 numeric English Open
property_sub_type_ar sub type of the property (ex. For units : apartment , shop , office ..etc) in Arabic No 100 nvarchar Arabic 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/3b25a6f5-9077-49d7-8a1e-bc6d5dea88fd/resource/a37511b0-ea36-485d-bccd-2d6cb24507e7/download/transactions.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