River Basin Pollution Monitoring
Data as of 2021Proportion of river basins classified as clean, slightly polluted, or polluted based on 3 primary indicators of water pollution.
0 views·0 downloads
How is this data produced?
The Department of Environment (DOE) is mandated to monitor the quality of environmental resources in Malaysia. As part of this mandate, the DOE monitors the water quality of rivers in Malaysia via a combination of manual and automated monitoring at over 1300 stations, covering nearly 700 rivers and 150 river basins. This dataset presents the results of this monitoring on an annual basis.
There are 3 primary water pollution indicators monitored by the DOE presented in this dataset:
- Biochemical Oxygen Demand (BOD), which measures the amount of oxygen that microorganisms require to decompose organic matter in the water. High BOD levels indicate the presence of a large amount of organic pollution, which can deplete oxygen in the water, harming aquatic life.
- Ammoniacal Nitrogen (NH₃-N), which is a measure of ammonia in the water primarily coming from agricultural runoff, sewage, and industrial discharges. High levels of ammoniacal nitrogen are toxic to fish and other aquatic organisms and can lead to the depletion of dissolved oxygen as it is broken down.
- Suspended Solids (SS), which are tiny particles suspended in the water, including soil, silt, organic matter, and industrial waste. High concentrations of suspended solids can reduce water clarity, block sunlight for aquatic plants, and clog the gills of fish.
River basins are classified as clean, slightly polluted, or polluted based on Water Quality Index (WQI) values for each of these 3 indicators. For a deeper understanding of the methodology, please refer to the DOE's Environmental Quality Report.
What caveats I should bear in mind when using this data?
—
Publication(s) using this data
—
Metadata
Dataset description
Proportion of river basins classified as clean, slightly polluted, or polluted based on 3 primary indicators of water pollution.
Variable definitions
- Date
- Basins Monitored
- Pollution Indicator
- Pollution Status
- Number of Basins
- Proportion
Name in Dataset | Variable | Definition |
|---|---|---|
date (Date) | Date | The date in YYYY-MM-DD format, with MM-DD set to 01-01 as the data is at yearly frequency. |
basins_monitored (Integer) | Basins Monitored | The number of river basins monitored during the year. |
measure (Categorical) | Pollution Indicator | The pollution indicator measured, either Biochemical Oxygen Demand ('bod5'), Ammoniacal Nitrogen ('nh3n'), or Suspended Solids ('ss'). |
status (Categorical) | Pollution Status | The classification of the river basins based on pollution levels, either Clean ('clean'), Slightly Polluted ('slightly_polluted'), or Polluted ('polluted'). |
n_basins (Integer) | Number of Basins | The number of basins that fall under each pollution classification. |
proportion (Float) | Proportion | The number of basins divided by the total number of basins monitored, expressed as a percentage. |
Last updated:
01 Sept 2024, 12:00
Next update:
31 Dec 2024, 12:00
Data source(s)
- Department of Environment
URLs to dataset
License
This data is made open under the Creative Commons Attribution 4.0 International License (CC BY 4.0). A copy of the license is available Here.
Download
Data
Full Dataset (CSV)
Recommended for individuals seeking an Excel-friendly format.
0
Full Dataset (Parquet)
Recommended for data scientists seeking to work with data via code.
0
Code
Connect directly to the data with Python.
# If not already installed, do: pip install pandas fastparquet
import pandas as pd
URL_DATA = 'https://storage.data.gov.my/environment/water_pollution_basin.parquet'
df = pd.read_parquet(URL_DATA)
if 'date' in df.columns: df['date'] = pd.to_datetime(df['date'])
print(df)Sample OpenAPI query
The following code is an example of how to make an API query to retrieve the data catalogue mentioned above. You can use different programming languages by switching the code accordingly. For a complete guide on possible query parameters and syntax, please refer to the official Open API Documentation.
import requests
import pprint
url = "https://api.data.gov.my/data-catalogue?id=water_pollution_basin&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
Department of Statistics Malaysia
© 2024 Public Sector Open Data
Open Data
data.gov.my