​​​​
​​​​​​​​​​​​​​​​​York, Peel, Durham, Toronto and The Conservation Authorities Moraine Coalition​​​ (YPDT-CAMC)
​​ ​

Database​​

Data management is one of the most critical areas where the partnership continues to have considerable success.  A robust data model has been built for the YPDT-CAMC groundwater program to house a wealth of water related and geological information required for hydrological and hydrogeological analysis of watersheds originating on the Oak Ridges Moraine.  Having initially begun with the Ministry of the Environment's (MOE) Water Well Information System (WWIS) database, the Oak Ridges Moraine Hydrogeology Program's database has now grown into what is likely the most comprehensive, actively-managed water related database in Canada.  The data management model goes well beyond the traditional MOE approach in two very powerful ways: i) by incorporating temporal data measurements such as pumping rates, water quality results, and long term water level measurements; and ii) by assigning each well screen to a geological unit/aquifer using an "authoritative" geological interpretation. 

Since the inception of the program in 2001 the database has grown and as of early 2014, the database now incorporates:

• 428,000 borehole locations (369,000 of these are MOE water well records, with the remainder comprised largely of consultant drilled geotechnical boreholes and various monitoring wells);
• 11,000 geologically logged outcrops/river or bluff sections;
• 1.6 million geological layer descriptions;
• 4,300 geo-referenced consultant/other reports or papers;
• 46 million water-level measurements from over 700 active monitoring wells;
• 400,000 daily pumping rate measurements from 80 active municipal drinking water supply wells;
• 214,000 individual chemical constituent analyses from samples taken from any of the active monitoring or pumping wells;
• 4,700 surface-water monitoring stations and 2.4 million daily streamflow measurements;
• 700 climate stations, with 27.5 million meteorological readings.


The main database is hosted on the server at the program's office.  A database synchronization procedure is in place to ensure that information is routinely shared between the ORM Program and partner agency staff.

A significant component of the data management program has been to inventory, digitally scan and photograph key hydrogeological reports and documents.  This key "knowledgement management' plank has led to over 4,000 documents now scanned and available to the partnered agencies as pdf files.

The need by all agencies for ready access to up-to-date, high quality data has been established and is fundamental to sound water resource management.  The program continues to assist partner agencies to address this need by fostering data collection and sound data management.

​​​