Number of Data Files / Resources 1
Updated: 04 Jun 2024
This dataset will provide extended details for the sand shifting service
Request Permission

I acknowledge that I have read and agree to the terms and conditions

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.
Send Feedback
Updated: 04 Jun 2024 File Size : 3.45 MB
Field Value
Data Provenance 1. sand shifting application details are created when applicant creates sand shifting request or NOC request and select building 2. Also when application is resubmitted, details are generated
Dataset Source Relational Database
Format CSV
Created 27 Jan 2021
Last updated 04 Jun 2024
Frequency of Update on Source RealTime
Frequency of Update to SDP
Expected Volume/Ingestion Cycle(Daily if Real-time)
5000 records monthly
Language English~English~English~English~English~English~Arabic~English~English~English~Arabic~English~English
State active
License notspecified
Name Description Primary Key Size Datatype Foreign Key Range of Values Language Classification
sandshift_app_id Unique ID Yes 22 number English Open
application_id Application reference ID No 22 number English Open
application_no Application Number No 20 varchar2 English Open
is_coastal is sand is shifted from coastal area No 20 varchar2 English Open
is_dm_project If the source location is DM project site with permit No 20 varchar2 English Open
source_location_type_en The type of location of source i.e. no parcel, DM parcel, other authority plot No 500 varchar2 English Open
source_location_type_ar The type of location of source i.e. no parcel, DM parcel, other authority plot No 500 varchar2 Arabic Open
oth_auth_plot_no plot number in case of other authority No 12 varchar2 English Open
oth_auth_permit_no permit number in case of other authority No 255 varchar2 English Open
request_type_en Type of request i.e. Sand Transfer or Sand Supply No 500 varchar2 English Open
request_type_ar Type of request i.e. Sand Transfer or Sand Supply No 500 varchar2 Arabic Open
total_sand_qty Total sand quanitty to be shifted No 22 number English Open
last_update_date Last Update Date No 10 date 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
  • 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: 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" ""
  • Query Samples: AND zone_id=2 OR zone_id=2
  • Record Limit Sample:
  • Record Offset Sample:
  • Record Order By Sample:
  • Attribute Limiting Sample: OR zone_id=2 &column=zone_id,line_name,location_id