Sarawak Data

Water Consumption Analysis in Sarawak By Division and Type of Usage for Year 2017

WATER CONSUMPTION ANALYSIS IN SARAWAK BY DIVISION AND TYPE OF USAGE

Data Explorer

Columns

No	Field	Type
1	_id	Integer
2	Month	Date and Time
3	Division	Text
4	Domestic Consumption	Numeric
5	Domestic / Commercial Consumption	Numeric
6	Commercial Consumption	Numeric
7	Special Commercial Consumption	Numeric
8	Standpipes Consumption	Numeric
9	Others Consumption	Numeric
10	Total	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=8d005ba1-b2e0-498e-85df-32af03726157&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=8d005ba1-b2e0-498e-85df-32af03726157&q=jones

Example: Javascript »

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

var data = {
    resource_id: '8d005ba1-b2e0-498e-85df-32af03726157', // 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=8d005ba1-b2e0-498e-85df-32af03726157&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()