View on GitHub

Data Products and Interpolation

Oak Ridges Moraine Groundwater Program

Data Management


The following is a description of the ORMGP’s data management practice. All data can be cited using the link below.

Contents


Data Warehousing

The ORMGP Database (MSSQL)

Our main MSSQL Server database holds all the information to support our decision-making tools. The ORMGP data systems are active, in that they are automatically updated at near real-time. From hourly and daily intervals, a series of web-scraping routines have been written to access open data made available from many sources including international, federal, provincial, municipal and conservation authority agencies. The objective is to centralize hydrogeological and hydrological data for the south-central Ontario (Canada) jurisdiction that currently makes-up the ORMGP.

Data source references.

Delft-FEWS

The Delft-FEWS platform offers a streamlined user interface that allows practitioners to visualize time-varying spatially-distributed data from a variety of sources and formats. For instance, spatial/vector/raster time-series datasets common to climatology differ from the point/location datasets contained in the SQL database. We maintain a Delft-FEWS platform to manage these data formats. Our ORMGP-FEWS system periodically ($\leq$ 1 day) scrapes data from federal, provincial, municipal and partner agencies to support a variety of APIs serving near-real-time historical climatologies to our partner users.

More information:

  1. About the Delft-FEWS product by Deltares.
  2. More information on ORMGP web data scraping and the sources scraped on a nightly basis.


ORMGP Servers

Databases and REST-APIs

Web Scraping


Data Sources

Geology

Description of the geological layers, their interpreted depositional setting, and of the procedures used to interpolate the surfaces.

Hydrogeology

Monitoring locations with >35 monitoring dates


Elevation, Drainage and Topology

For groundwater elevations, digital elevation data are used to correct depths of measure to metres above sea level (masl). Therefore, vertical accuracy and datum are tied to the digital elevation (terrain) model (DEM) we used as reference. Currently, correction are taken to the 10m 2006 OMNR Digital Elevation Model - Version 2.0.0 - Provincial Tiled Dataset.

Overland flow drainage and their pathways (topology) are defined using the 30m Provincial Digital Elevation Model - South (CGVD2013).

Sub-watershed characterization and flow topology



Hydro-meteorological station data


Technologies

A number of open-source and proprietary data analysis tools have been employed in our overall data management system. In contribution to the open-source community, much of our work has also left open on our Github.