Sarawak Data

Inventory of Wastewater Treatment Facilities in Sarawak 2014

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/196
Description	This data is provided by relevant local authorities.
Format	XLSX
File Size	11 KB
Downloads	118
Package ID	6f7df2e6-45c2-4e7f-9e5b-cecc0eaa397b
Resource ID	b70f2f30-5dbc-4e04-b6a5-86b8fb2f2cce
Revision ID	aa1b2388-5005-436c-bcbc-f911cd79d808
Published Date	03/05/2018 04:42 AM
Last Modified	01/12/2018 10:15 AM
MD5 Checksum	1eacf1ab4bcea722f3694bf32ed30568

Data Explorer

Columns

No	Field	Type
1	_id	Integer
2	Local authority	Text
3	Individual Septic Tank (Nos.)	Numeric
4	Individual Septic Tank (PE)	Numeric
5	Public Communal Septic Tank (Nos.)	Numeric
6	Public Communal Septic Tank (PE)	Numeric
7	Private Communal Septic Tank (Nos.)	Numeric
8	Private Communal Septic Tank (PE)	Text
9	Public Sewage Treatment Plant (Nos.)	Numeric
10	Public Sewage Treatment Plant (PE)	Numeric
11	Sewer Length (km) connected to Public Sewage Treatment Plant	Numeric
12	Stations Pump (Nos.)	Numeric
13	Private Sewage Treatment Plant (Nos.)	Numeric
14	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=b70f2f30-5dbc-4e04-b6a5-86b8fb2f2cce&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=b70f2f30-5dbc-4e04-b6a5-86b8fb2f2cce&q=jones

Example: Javascript »

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

var data = {
    resource_id: 'b70f2f30-5dbc-4e04-b6a5-86b8fb2f2cce', // 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=b70f2f30-5dbc-4e04-b6a5-86b8fb2f2cce&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()