Sarawak Data

Sarawak Current Water Supply Statistics

Data on Water Supply

Source	Data on Water Supply
URL	https://data.sarawak.gov.my/home/data/resource_download/490
Description	-
Format	XLSX
File Size	8 KB
Downloads	139
Package ID	b75789ae-5b53-4ea5-956e-6493d8a90faf
Resource ID	3ad1bb37-e7d3-4fa6-9864-402af58d0108
Revision ID	fb750c72-9a29-4e04-87ce-bf64e0cd9b1a
Published Date	11/05/2018 07:14 PM
Last Modified	11/05/2018 07:14 PM
MD5 Checksum	830e970cb65d59fa567e47001da3ea69

Data Explorer

Columns

No	Field	Type
1	_id	Integer
2	No of WTP	Numeric
3	Total Design Capacity (MLD)	Numeric
4	Total Daily Production (MLD)	Numeric
5	Total no of Reservoirs/ Towers	Numeric
6	Total Pipe Length (km)	Numeric
7	Total no of Meter Connections	Numeric
8	Total no of Water Supply Dams	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=3ad1bb37-e7d3-4fa6-9864-402af58d0108&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=3ad1bb37-e7d3-4fa6-9864-402af58d0108&q=jones

Example: Javascript »

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

var data = {
    resource_id: '3ad1bb37-e7d3-4fa6-9864-402af58d0108', // 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=3ad1bb37-e7d3-4fa6-9864-402af58d0108&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()