Number of Data Files / Resources 21
Updated: 05 Oct 2022
Contains information about the Required load, Power NOC, cost estimation
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: 04 Jul 2022 File Size : 0.51 MB
CSV
Updated: 04 Jul 2022 File Size : 0.00 MB
CSV
Updated: 04 Jul 2022 File Size : 0.00 MB
CSV
Updated: 05 Oct 2022 File Size : 0.08 MB
CSV
Updated: 05 Oct 2022 File Size : 0.19 MB
CSV
Updated: 04 Jul 2022 File Size : 0.18 MB
CSV
Field Value
Data Provenance On submission of the application a unique application number is generated by the system and the customer is expected to submitted with required docs such as building NOC's and DM documents . (In case resubmission of documents is found necessary customer is informed.) The application is seperated based on the water demand requirements (Bulk vs House Connection) and thereafter processed. The concerned engineer inspects the site and approves the connection request and prepare the estimated cost for the connection. The customer can followup the status through online system and remit the necessary fees for DEWA to proceed. Once the payment is received and the site is ready the work is executed and supply released.
Dataset Source SAP-CRM
Format CSV
Created 16 Feb 2018
Last updated 05 Oct 2022
Frequency of Update on Source Upon transaction
Frequency of Update to SDP
Quarterly
Expected Volume/Ingestion Cycle(Daily if Real-time)
8000 yearly
Language Mix~Mix~English~English~Mix~Mix~Mix~English~English~Mix~Mix
State active
Rights N/A
License notspecified
Name Description Primary Key Size Datatype Foreign Key Range of Values Language Classification
posting_date Submission date for the application No date (DD.MM.YYYY) Mix Open
project_type Type of the project such as developer projects, industrial,contractors etc. No 255 alphanumeric Mix Open
plot_number Location of customer's premises Yes 10 alphanumeric English Open
community Community number refers to the number assigned by Dubai Municipality to the areas in Dubai Yes 10 Numeric English Open
load_type Category based on demand/ small or large meter No 255 alphanumeric DEWA-Load Type Tab Mix Open
application_no Application number generated when the customer initiates an application with DEWA Yes 30 alphanumeric Mix Open
revision Number of revisions/submissions No 10 alphanumeric Mix Open
dm_reference_no Refrence for Application No. in DM No 30 alphanumeric English Open
category Customer's category refer to as residential, commercial, industrial etc. No 255 Text DEWA-Rate Tab English Open
cable_laid_date Date on which the cable laid to the customer No date (DD.MM.YYYY) Mix Open
estimate_payment_date Date of payment received for the estimated value of the new connection No date (DD.MM.YYYY) Mix 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/535f7eea-7ea8-469e-9d89-60017b063518/resource/51098f1e-0608-4fc9-8a43-6a4811d70036/download/new_electricity_connection_2017-10-31_00-00-00.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