Sarawak Data

Inventory of Wastewater Treatment Facilities in Sarawak 2012 Inventory of Wastewater Treatment Facilities in Sarawak

Source	Inventory of Wastewater Treatment Facilities in Sarawak
URL	https://data.sarawak.gov.my/home/data/resource_download/194
Description	This data is provided by relevant local authorities.
Format	XLSX
File Size	11 KB
Downloads	75
Package ID	6f7df2e6-45c2-4e7f-9e5b-cecc0eaa397b
Resource ID	1c5adddf-8579-470b-9c68-33e4d13044e3
Revision ID	aa1b2388-5005-436c-bcbc-f911cd79d808
Published Date	03/05/2018 04:42 AM
Last Modified	03/05/2018 04:42 AM
MD5 Checksum	c1e2be39495e8f49b9583d0490de40be

Data Explorer

Download

Columns

No	Field	Type
1	_id	Integer
2	Local authority	Text
3	Individual Septic Tank (Nos.)	Numeric
4	Individual Septic Tank (PE)	Numeric
5	Communal Septic Tank (Nos.)	Numeric
6	Communal Septic Tank (PE)	Text
7	Public Sewage Treatment Plant (Nos.)	Numeric
8	Public Sewage Treatment Plant (PE)	Numeric
9	Sewer Length (m) connected to Public Sewage Treatment Plant	Numeric
10	Stations Pump (Nos.)	Numeric
11	Private Sewage Treatment Plant (Nos.)	Numeric
12	Private Sewage Treatment Plant (PE)	Text

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=1c5adddf-8579-470b-9c68-33e4d13044e3&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=1c5adddf-8579-470b-9c68-33e4d13044e3&q=jones

Example: Javascript »

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

var data = {
    resource_id: '1c5adddf-8579-470b-9c68-33e4d13044e3', // 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=1c5adddf-8579-470b-9c68-33e4d13044e3&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()