NSW Estuary Water Quality Data Compilation: 2007 - 2020 - NSW Estuary Water Quality Data Compilation: 2007 - 2020

Department of Planning, Industry and Environment

NSW Estuary Water Quality Data Compilation: 2007 - 2020

Back to dataset

Download URL: https://datasets.seed.nsw.gov.au/dataset/b0eded3a-e58a-4b39-a0c5-1f3d4efd0b51/resource/d2929493-a965-44d7-b2c9-dcf596623188/download/nsw-dpie-estuary-water-quality-data-20072020.csv

There are no views created for this resource yet.

Additional Information

Field	Value
Title	NSW Estuary Water Quality Data Compilation: 2007 - 2020
Data last updated	27/08/2020
Metadata last updated	27/08/2020
Format	CSV
License	Creative Commons Attribution
Original URL	https://datasets.seed.nsw.gov.au/dataset/b0eded3a-e58a-4b39-a0c5-1f3d4efd0b51/resource/d2929493-a965-44d7-b2c9-dcf596623188/download/nsw-dpie-estuary-water-quality-data-20072020.csv

Data Dictionary

Label	Type	Description
OrganisationCode	text
CMARegionCode	text
MERRegionName	text
ProgramCode	text
ProjectCode	text
EstuaryNo	numeric
Estuary	text
EstuaryCode	text
LGACode	text
MarineParkCode	text
EstuaryTypeCode	text
DisturbanceClassCode	text
TripType	text
TripCode	text
TripNumber	numeric
Time	text
SiteTypeName	text
SiteTypeCode	text
Zone	text
SiteCode	text
Date	timestamp
StartLatitude	numeric
StartLongitude	numeric
EndLatitude	numeric
EndLongitude	numeric
Entrance	text
Tide	text
Secchi_m	text
Depth_m	text
Temp_C	numeric
SpCond_uScm	text
pH_pHu	numeric
Sal_psu	numeric
Turb_ntu	numeric
Chl-a_ugL	numeric
CDOM_RFU	text
fDOM_RFU	numeric
fDOM_QSU	numeric
BGA-PE_ugL	numeric
DOsat_sat	numeric
DOmgl_mgL	numeric
Col-A_Pt-Co	text
Col-T_Pt-Co	numeric
Chl-a_ugL2	numeric
NH3-N_ugL	numeric
FRP_ugL	text
NOx_ugL	numeric
SiO2-Si_ugL	text
TDP_ugL	numeric
TDN_ugL	text
TP_ugL	numeric
TN_ugL	text

download Download CSV

Updates
Last updated	27/08/2020
Date Created	27/08/2020
File format	CSV

Licence
Creative Commons Attribution

CKAN Data API

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

Code examples:

curl JavaScript PowerShell Python R

Querying

Get 5 results containing "jones" in any field:

curl https://uatweb.datansw.links.com.au/data/api/action/datastore_search \
  -H"Authorization:$API_TOKEN" -d '
{
  "resource_id": "cb0ea2d8-54da-4a4e-813e-d7745926b6a8",
  "limit": 5,
  "q": "jones"
}'

const resp = await fetch(`https://uatweb.datansw.links.com.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({
        resource_id: 'cb0ea2d8-54da-4a4e-813e-d7745926b6a8',
        limit: 5,
        q: 'jones'
    })
})
await resp.json()

$json = @'
{
  "resource_id": "cb0ea2d8-54da-4a4e-813e-d7745926b6a8",
  "limit": 5,
  "q": "jones"
}
'@
$response = Invoke-RestMethod https://uatweb.datansw.links.com.au/data/api/action/datastore_search`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

(using the ckanapi client library)

from ckanapi import RemoteCKAN

rc = RemoteCKAN('https://uatweb.datansw.links.com.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="cb0ea2d8-54da-4a4e-813e-d7745926b6a8",
    limit=5,
    q="jones",
)
print(result['records'])

library(httr2)

req <- request("https://uatweb.datansw.links.com.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id = 'cb0ea2d8-54da-4a4e-813e-d7745926b6a8',
        limit = 5,
        q = 'jones'))
    req_perform %>% 
    resp_body_json

Get results with either "watershed" or "survey" as subject and "active" as its stage:

curl https://uatweb.datansw.links.com.au/data/api/action/datastore_search \
-H"Authorization:$API_TOKEN" -d '
{
"resource_id": "cb0ea2d8-54da-4a4e-813e-d7745926b6a8",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}'

const resp = await fetch(`https://uatweb.datansw.links.com.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({resource_id: 'cb0ea2d8-54da-4a4e-813e-d7745926b6a8', filters: {
        subject: ['watershed', 'survey'],
        stage: 'active'
    }})})
await resp.json()

$json = @'
{
  "resource_id": "cb0ea2d8-54da-4a4e-813e-d7745926b6a8",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}
'@
$response = Invoke-RestMethod https://uatweb.datansw.links.com.au/data/api/action/datastore_search`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

from ckanapi import RemoteCKAN

rc = RemoteCKAN('https://uatweb.datansw.links.com.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="cb0ea2d8-54da-4a4e-813e-d7745926b6a8",
    filters={
      "subject": ["watershed", "survey"],
      "stage": "active",
    },
)
print(result['records'])

library(httr2)

req <- request("https://uatweb.datansw.links.com.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id='cb0ea2d8-54da-4a4e-813e-d7745926b6a8', 
        filters = list(
            subject = list("watershed", "survey"), 
            stage = "active")))
    req_perform %>% 
    resp_body_json

Using the API with this Web Browser

Some API endpoints may be accessed using a GET query string.

Query example (first 5 results)

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=cb0ea2d8-54da-4a4e-813e-d7745926b6a8&limit=5

Query example (results containing 'jones')

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=cb0ea2d8-54da-4a4e-813e-d7745926b6a8&q=jones