Sarawak Data

Production of Water for 2019

Monthly Production of Water

Source	Monthly Production of Water
URL	https://data.sarawak.gov.my/home/data/resource_download/887
Description	Production of Water for 2019 showing Plant Capacity, Average Daily Demand, Raw Water Extracted, and Treated Water Delivered From Water Treatment Plant
Format	XLSX
File Size	12 KB
Downloads	21
Package ID	2af14ad5-d8c0-478b-84f3-f3a83da61ff8
Resource ID	e77d9429-835b-42f8-9185-ec51a142d271
Revision ID	5d19d453-3ea5-4c07-959c-32d77938b906
Published Date	27/10/2020 03:46 AM
Last Modified	27/10/2020 03:46 AM
MD5 Checksum	11cec35c8c1d7fcef2e39d0fd5e686ca

Data Explorer

Columns

No	Field	Type
1	_id	Integer
2	Years	Text
3	Plant Capacity (Millions of Litres per Day)	Numeric
4	Average Daily Demand (Millions of Litres per Day)	Numeric
5	Raw Water Extracted (Meter cube)	Numeric
6	Treated Water Delivered From Water Treatment Plant (Meter cube)	Numeric

Endpoint »

The Data API can be accessed via the following actions of the CKAN action API.

Query	`https://catalog.sarawak.gov.my/api/3/action/datastore_search`

Querying »

Query example (first 5 results)

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=e77d9429-835b-42f8-9185-ec51a142d271&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=e77d9429-835b-42f8-9185-ec51a142d271&q=jones

Example: Javascript »

A simple ajax (JSONP) request to the data API using jQuery.

var data = {
    resource_id: 'e77d9429-835b-42f8-9185-ec51a142d271', // the resource id
    limit: 5, // get 5 results
    q: 'jones' // query for 'jones'
};
$.ajax({
    url: 'https://catalog.sarawak.gov.my/api/3/action/datastore_search',
    data: data,
    dataType: 'jsonp',
    success: function(data) {
        alert('Total results found: ' + data.result.total)
    }
});

Example: Python »

import urllib
url = 'https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=e77d9429-835b-42f8-9185-ec51a142d271&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()