ReadMe Text: This data package contains a selection of water quality and quantity information from York Region’s Annual Drinking Water System Reports. It is not intended as a replacement or equivalent to the complete set of regulatory reporting information provided in the annual reporting packages. For additional details and descriptions, please refer to the full reports found on the York Region official website: http://www.york.ca/drinkingwater Any questions should be directed to York Region’s Environmental Services Department: EnvironmentalServices@york.ca Disclaimer: Values with a less than sign ("<") indicate that the test result is below the method detection limit from the accredited laboratory (i.e. non-detect). Average results include values which were returned as non-detect. Disclaimer: For MECP_APPROVALS table, the following drinking water systems (DWS) are included in the York DWS MDWL: Aurora, Holland Landing, King City, Kleinburg, Newmarket, Sharon/Queensville, Stouffville. The following DWS are included in the Yonge Street Aquifer PTTW: Aurora, Holland Landing, Newmarket, Sharon/Queensville. +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | TABLE NAME | COLUMN NAME | DATA DESCRIPTION | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | REPORTING_YEAR | The year being reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | SYSTEM_NAME | Drinking water system name or sub-system name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | INCIDENT_DATE | The date at which the adverse incident occurred | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | INCIDENT_LOCATION | The location at which the incident occurred | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | ADVERSE_PARAMETER | The parameter whose measurement fell outside mandated standards | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | ADVERSE_TEST_RESULTS | Measured test results of the adverse parameter reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | ADVERSE_TEST_RESULT_UNITS | Units of the adverse test result | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | PARAMETER_REG_LIMIT | Description of the adverse incident and how it deviated from the mandated | | | | standards | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | RESAMPLE_RESULT | Measurement test result of the resample taken after discovery of the | | | | adverse incident | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | RESAMPLE_RESULT_UNITS | Units of the resampled test result | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | CORRECTIVE_ACTION_DATE | Date at which an corrective action took place to correct the adverse incident | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ADVERSE_INCIDENTS | CORRECTIVE_ACTION | Description of the corrective action that took place to correct the | | | | adverse incident | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_CHEM_RESULTS | REPORTING_YEAR | The year being reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_CHEM_RESULTS | SYSTEM_NAME | Drinking water system name or sub-system name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_CHEM_RESULTS | TEST_PARAMETER | The parameter being tested | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_CHEM_RESULTS | SAMPLE_SOURCE | The source of the tested sample. | | | | Where TW refers to Treated Water, RW refers to Raw Water and DS refers to | | | | York Region distribution facilities & a null value indicates a | | | | combination of water types or a sample from a process or disinfection stream | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_CHEM_RESULTS | TEST_UNITS | Units of the test results | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_CHEM_RESULTS | ANNUAL_TEST_MIN_RESULT | The minimum annual test result that was measured and reported for the | | | | tested parameter | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_CHEM_RESULTS | ANNUAL_TEST_MAX_RESULT | The maximum annual test result that was measured and reported for the | | | | tested parameter | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_CHEM_RESULTS | ANNUAL_TEST_AVG_RESULT | The average annual test result calculated for the test parameter | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_MICRO_RESULTS | REPORTING_YEAR | The year being reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_MICRO_RESULTS | SYSTEM_NAME | Drinking water system or sub-system name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_MICRO_RESULTS | TEST_PARAMETER | The parameter being tested | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_MICRO_RESULTS | SAMPLE_SOURCE | The source of the tested sample. | | | | Where TW refers to Treated Water, RW refers to Raw Water and DS refers to | | | | York Region distribution facilities | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_MICRO_RESULTS | COUNT_OF_SAMPLES | A count of the total number of samples tested | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_MICRO_RESULTS | COUNT_OF_PRESENCE | A count of the number of bacteria present in the sample | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SUPPLY_VOLUMES | REPORTING_YEAR | The year being reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SUPPLY_VOLUMES | SYSTEM_NAME | Drinking water system or sub-system name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SUPPLY_VOLUMES | SUPPLY_NAME | Drinking water production supply name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SUPPLY_VOLUMES | PERMITTED_MAX_DAILY_VOL_L | Maximum permitted volume (L) for daily withdrawl. This is a function of the | | | | Permit to Take Water for the facility. In the case of water purchased from | | | | the City of Toronto or Region of Peel, this number is a function of the amount | | | | permitted under the applicable water supply agreement | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SUPPLY_VOLUMES | ANNUAL_MAX_DAILY_VOL_M3 | Actual maximum daily volume (m^3) withdrawn or purchased. No value indicates | | | | that the supply source was offline | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SUPPLY_VOLUMES | ANNUAL_MAX_DAILY_VOL_DAY | Date of actual maximum daily withdrawal. No value indicates that the supply | | | | source was offline | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SUPPLY_VOLUMES | ANNUAL_AVG_DAILY_VOL_M3 | Annual average daily volume (m^3) for the reporting year. No value indicates | | | | that the supply source was offline | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SUPPLY_VOLUMES | NUMBER_OF_PEAK_DAYS_MAY_OCT | Number of days operating at peak capacity for the period from May to October | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SUPPLY_VOLUMES | NUMBER_OF_PEAK_DAYS_ANNUAL | Number of days operating at peak capacity for the reporting year | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SUPPLY_VOLUMES | ANNUAL_VOL_M3 | Actual total volume (m^3) withdrawn or purchased in the entire year for the | | | | drinking water system or sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SYSTEM_PRODUCTION | REPORTING_YEAR | The year being reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SYSTEM_PRODUCTION | SYSTEM_NAME | Drinking water system name or sub-system name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SYSTEM_PRODUCTION | ANNUAL_PRODUCTION_VOL_M3 | Annual volume (m^3) withdrawn from sources or purchased in the system or | | | | sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | ANNUAL_SYSTEM_PRODUCTION | ANNUAL_MAX_PERMITTED_VOL_L | Maximum permitted annual production volume (L) for the drinking water system or | | | | sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | INDIVIDUAL_CHEM_RESULTS | REPORTING_YEAR | The year being reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | INDIVIDUAL_CHEM_RESULTS | SYSTEM_NAME | Drinking water system name or sub-system name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | INDIVIDUAL_CHEM_RESULTS | SAMPLE_FACILITY | The facility from which the sample came | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | INDIVIDUAL_CHEM_RESULTS | SAMPLE_DATE | The date at which the sample was taken | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | INDIVIDUAL_CHEM_RESULTS | SAMPLE_TYPE | Type of the sample being tested. | | | | Where TW refers to Treated Water, RW refers to Raw Water and DS refers to | | | | York Region distribution facilities | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | INDIVIDUAL_CHEM_RESULTS | TEST_PARAMETER | The parameter being tested as required by regulation | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | INDIVIDUAL_CHEM_RESULTS | TEST_RESULT | Measured results of the test parameter reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | INDIVIDUAL_CHEM_RESULTS | TEST_UNITS | Units of the test results | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | INDIVIDUAL_CHEM_RESULTS | PARAMETER_ODWS_LEVEL | Ontario Drinking Water Quality Standards level (ODWS) for the tested parameter | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | INDIVIDUAL_CHEM_RESULTS | PARAMETER_STANDARD_TYPE | The type of the mandated regulatory standard. IMAC refers to Interim Maximum | | | | Allowable Concentration, MAC refers to Maximum Allowable Concentration, OG is | | | | Operational Guideline and AO Is Aesthetic objective | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MECP_APPROVALS | REPORTING_YEAR | The year being reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MECP_APPROVALS | SYSTEM_NAME | Drinking water system or sub-system name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MECP_APPROVALS | APPROVAL_TYPE | The type of approval indicated | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MECP_APPROVALS | APPROVAL_DESCRIPTION | Description of the APPROVAL_TYPE | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MECP_APPROVALS | APPROVAL_NUMBER | The number of the indicated approval | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MECP_APPROVALS | APPROVAL_ISSUE_NUMBER | The issue number of the indicated approval where applicable | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MECP_APPROVALS | APPROVAL_ISSUE_DATE | Date at which the approval was issued | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MECP_APPROVALS | OPERATIONAL_PLAN_NUMBER | Operational plan number where applicable | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MECP_APPROVALS | FINANCIAL_PLAN_NUMBER | Financial plan number where applicable | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MECP_APPROVALS | APPROVAL_EXPIRY_DATE | The expiry date of the approval | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MECP_APPROVALS | APPROVAL_RENEWAL_DATE | The required renewal date of the approval | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SUPPLY_VOLUMES | REPORTING_YEAR | The year being reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SUPPLY_VOLUMES | REPORTING_MONTH | Month of the year that is reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SUPPLY_VOLUMES | SYSTEM_NAME | Drinking water system or sub-system name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SUPPLY_VOLUMES | SUPPLY_NAME | Drinking water production supply name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SUPPLY_VOLUMES | MONTHLY_VOL_M3 | Actual total volume (m^3) withdrawn or purchased in the month of the year for | | | | the drinking water system or sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SUPPLY_VOLUMES | MONTHLY_AVG_DAILY_VOL_M3 | Average daily volume (m^3) for the month of the year. | | | | No value indicates that the supply source was offline | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SUPPLY_VOLUMES | MONTHLY_MAX_DAILY_VOL_M3 | Maximum daily volume (m^3) for the month of the year. | | | | No value indicates that the supply source was offline | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SUPPLY_VOLUMES | MONTHLY_MAX_DAILY_VOL_DAY | Date of actual maximum daily withdrawal within the month. | | | | No value indicates that the supply source was offline | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SUPPLY_VOLUMES | REPORTING_MONTH_TEXT | The reported month in text format | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SYSTEM_FLOWS | REPORTING_YEAR | The year being reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SYSTEM_FLOWS | REPORTING_MONTH | Month of the year that is reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SYSTEM_FLOWS | SYSTEM_NAME | Drinking water system or sub-system name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SYSTEM_FLOWS | FLOW_SOURCE | The source of the water flow for the system or sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SYSTEM_FLOWS | MONTHLY_AVG_DAILY_VOL_M3 | Average daily volume (m^3) for the month of the year. | | | | No value indicates that the supply source was offline | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SYSTEM_FLOWS | MONTHLY_VOL_M3 | Actual total volume (m^3) produced, purchased or sold in the month of the year | | | | for the drinking water system or sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | MONTHLY_SYSTEM_FLOWS | REPORTING_MONTH_TEXT | The reported month in text format | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | REPORTING_YEAR | The year being reported | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | SYSTEM_NAME | Drinking water system or sub-system name | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | SYSTEM_NUMBER | A unique number for the drinking water system of sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | SYSTEM_CATEGORY | Category of the drinking water system or sub-system, which is a function of the | | | | area and population it serves | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | SYSTEM_POPULATION_SERVED | The population that is served by the drinking water system or sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | SYSTEM_RAW_WATER_SOURCE | Source of raw water that feeds the drinking water system or sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | SYSTEM_DISTRIBUTION_WATER_PROF | Source composition of water in York Region distribution system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | SYSTEM_CLASSIFICATION | Description of the system classification which reflects the function of the | | | | drinking water system or sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | SYSTEM_INTRODUCTION | Introduction and a short overview about the drinking water system or sub-system | | | | and the communities it serves | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | SYSTEM_TREATMENT_DESCRIPTION | Overview of the treatment processes that are being utilized by the drinking | | | | water system or sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | RECEIVING_SYSTEMS | List of distribution systems that receive their water from the drinking water | | | | system or sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | WATER_TREATMENT_CHEMICALS | List of water treatment chemicals that are used by the drinking water system | | | | or sub-system | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | SYSTEM_MONETARY_EXPENSES | Major expenses incurred during the reporting period to install, repair or | | | | repair or replace required equipment | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+ | WATER_SYSTEMS | SYSTEM_MONETARY_EXPENSES_DESCR | Description of the major expenses incurred during the reporting period to | | | | install, repair or replace required equipment | +--------------------------+-----------------------------------+-----------------------------------------------------------------------------------+