novascotia-ca/nova-scotia-lake-chemistry-data-vn55-yjyi
Icon for Socrata external plugin
  •  
    Overview
  •  
    Tables
  •  
    REST API
  •  
    SQL Query
Open repository in Console
 
Readme
Updated 4 years ago
‧
Indexed 11 months ago

Nova Scotia Lake Chemistry Data

The Nova Scotia Lake Survey program is a partnership initiative between the Department of Environment and Climate Change and the Department of Fisheries and Aquaculture to inventory lakes throughout the province determining baseline water quality, in support of both sport fisheries and water resource management areas.

The following weblink connects to a Department of Environment and Climate Change web map that includes the locations of the monitored lakes within the province and an alternative method for downloading the same lake chemistry dataset: http://nse.maps.arcgis.com/apps/webappviewer/index.html?id=7ded7a30bef44f848e8a4fc8672c89bd"

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"novascotia-ca/nova-scotia-lake-chemistry-data-vn55-yjyi\".\"nova_scotia_lake_chemistry_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • nova_scotia_lake_chemistry_data
     
    Left sidebar is currently unimplemented
     
     
     
     
    Right sidebar is currently unimplemented
Upstream Metadata
Detailed MetadataLanguageengFrequencyAs neededDepartmentEnvironment and Climate ChangeRelated Documentshttps://www.novascotia.ca/nse/surface.water/Time Period Coverage1940-01-01/2019-06-05Usage ConsiderationsWater quality samples are collected at approximately 10 different lakes per annum. The samples are submitted to the Nova Scotia Environmental Services Laboratory operated by the Nova Scotia Health Authority in Halifax, NS for analysis. Field parameters are measured using a multiparameter instrument. The following are the monitored water quality parameters and applicable measurement units: field temperature (°C), field dissolved oxygen (mg/L), Secchi disc depth (m), select metals (µg/L), calcium (mg/L), magnesium (mg/L), hardness as CaCO3 (mg/L), lab conductivity (umho/cm), lab pH (-), lab turbidity (-), alkalinity as CaCO3 (mg/L), chloride (mg/L), colour (TCU), silica (mg/L), sulphate (mg/L), total nitrogen (mg/L), nitrate and nitrite as N (mg/L), ammonia as N (mg/L), orthophosphorus as P, (mg/L), total phosphorus (mg/L), total suspended solids (mg/L), total organic carbon (mg/L), chlorophyll a (mg/m3) and pheophytin (µg/L). Bathymetric maps have been produced for most of the sampled lakes and their attributes (surface area, volume, max & mean depths) are included in the dataset.Geographic Region NameNova Scotia

About

Nova Scotia Lake Chemistry Data
4 years ago (updated)
11 months ago (indexed)
Loading...

Topics

  • chemistry
  • fish
  • lakes
  • water bodies
  • water quality
  • + 1

Source

  • Open Data Nova Scotia - Nova Scotia Lake Chemistry Data

License

Nova Scotia Open Government Licence