Number of Data Files / Resources 55
Updated: 04 Nov 2021
Contains the number of Solar PV installations connected to DEWA grid under Shams Dubai initiative
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: 06 May 2021 File Size : 0.41 MB
CSV
Updated: 06 Apr 2021 File Size : 0.41 MB
CSV
Updated: 07 Mar 2021 File Size : 0.41 MB
CSV
Updated: 07 Feb 2021 File Size : 0.41 MB
CSV
Updated: 06 Jan 2021 File Size : 0.41 MB
CSV
Updated: 06 Dec 2020 File Size : 0.40 MB
CSV
Field Value
Data Provenance within shams Dubai initiative, each participant will have power contribution out of the solar cells to DEWA grid. Customer contribution will be deducted from the consumption and the customer will be invoinced accordingly
Dataset Source
Format CSV
Created 16 Feb 2018
Last updated 04 Nov 2021
Frequency of Update on Source
Frequency of Update to SDP
Monthly
Expected Volume/Ingestion Cycle(Daily if Real-time)
230 Accounts in SAP
Language English~English~English~English~English~English~English~English~English
State active
Rights N/A
License notspecified
Name Description Size Datatype Foreign Key Range of Values Language Classification
billing_portion Dubai has been divided into 27 portions / cycles for meter reading purpose 50 Alpha Numeric English Open
community Community number refers to the number assigned by Dubai Municipality to the areas in Dubai 10 Numeric English Open
rate_category Customers category refer to as residential, commercial, industrial etc. 255 Text DEWA-Rate Category Tab English Open
consumption_period The monthly period for the bill / invoice 30 Alpha Numeric English Open
calendar_month Refers to the calendar month in which bill / invoice is issued 50 Alpha Numeric English Open
contract_account Customer Contract Account Number in which all financial transactions of customers are recorded i.e. monthly invoiced amount, payments, adjustments and arrears. (This number is to be used by customers in all correspondence with DEWA) 10 Numeric English Open
business_partner Business Partner is a number assigned to a customer at the time of registration with DEWA for the first time. This number is a permanent number for the customer and does not change with change of premise or registering for more than one premise 10 Numeric English Open
import_unit Monthly electricity consumption in Kilo Watt Hours 30 Numeric English Open
export_unit Monthly electricity generated in Kilo Watt Hours 30 Numeric 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/3f3ca001-2983-4e42-b237-2a52b311918f/resource/be12f6f2-6c09-4739-a603-c95686e746a4/download/shams_dubai_2020-04-13_15-35-50.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