Download

Access resource data via a web API with powerful query support. Further information in the main CKAN Data API and DataStore documentation.

Endpoints »

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

Create	`https://www.data.gov.my/data/api/3/action/datastore_create`
Update / Insert	`https://www.data.gov.my/data/api/3/action/datastore_upsert`
Query	`https://www.data.gov.my/data/api/3/action/datastore_search`
Query (via SQL)	`https://www.data.gov.my/data/api/3/action/datastore_search_sql`

Querying »

Query example (first 5 results)

https://www.data.gov.my/data/api/3/action/datastore_search?limit=5&resource_id=2903e39a-dde6-4053-818e-ebdb8066d8b7

Query example (results containing 'jones')

https://www.data.gov.my/data/api/3/action/datastore_search?q=jones&resource_id=2903e39a-dde6-4053-818e-ebdb8066d8b7

Query example (via SQL statement)

https://www.data.gov.my/data/api/3/action/datastore_search_sql?sql=SELECT * from "2903e39a-dde6-4053-818e-ebdb8066d8b7" WHERE title LIKE 'jones'

Example: Javascript »

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

        var data = {
          resource_id: '2903e39a-dde6-4053-818e-ebdb8066d8b7', // the resource id
          limit: 5, // get 5 results
          q: 'jones' // query for 'jones'
        };
        $.ajax({
          url: 'https://www.data.gov.my/data/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://www.data.gov.my/data/api/3/action/datastore_search?limit=5&resource_id=2903e39a-dde6-4053-818e-ebdb8066d8b7&q=title:jones'
      fileobj = urllib.urlopen(url)
      print fileobj.read()

dataset

URL: https://archive.data.gov.my/data/dataset/27bff928-6264-4483-8042-059b525d0531/resource/a43e06a9-0fe6-44f4-b601-9ae3f88d23a5/download/m-20210316112244_202112280550090_11.10-water-treatment-plants-design-capacity-by-state-malaysia-.csv

This dataset shows the Water Treatment Plants Design Capacity by State, Malaysia, 2000 - 2020.

Footnote
The increase of water treatment plants design capacity is due to the addition of new plant and expansion of present plant design. The decrease of water treatment plants design capacity is due to the closing of plants and temporary closure of water treatment plant (will be reopened when needed). Beginning of 2016, design capacity for Johor, Perlis and Terengganu include private operator where the designated capacity based on agreement both parties. Sarawak includes The Northern Sarawak Water Board (LAKU), Sibu Water Board, Kuching Water Board and Public Works Department Sarawak. Selangor includes W.P. Kuala Lumpur and W.P. Putrajaya. Unit for Value is Million litres per day (MLD). The values for Sarawak in the year 2016-2019 are revised The values for the year 2020 are preliminary

Source : Ministry of Environment and Water , National Water Services Commission

Fullscreen Embed

This resource view is not available at the moment. Click here for more information.

Download resource

Data Dictionary

Column	Type	Label	Description

Additional Information

Field	Value
Data last updated	June 20, 2022
Metadata last updated	June 20, 2022
Created	June 20, 2022
File Format	CSV
License	Creative Commons Attribution

CKAN Data API

dataset

Embed resource view

Data Dictionary

Additional Information