    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('13/08/2015 8:40', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('13/08/2015 8:40', 'DD/MM/YYYY HH24:MI'), 'Temperature', 1.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/04/2016 8:49', 'DD/MM/YYYY HH24:MI'), 'Clarity', 2.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/04/2016 8:49', 'DD/MM/YYYY HH24:MI'), 'Discharge', 5.699, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/04/2016 8:49', 'DD/MM/YYYY HH24:MI'), 'E. coli', 13.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/04/2016 8:49', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 317.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/04/2016 8:49', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/04/2016 8:49', 'DD/MM/YYYY HH24:MI'), 'pH', 7.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/04/2016 8:49', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 12.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/04/2016 8:49', 'DD/MM/YYYY HH24:MI'), 'Temperature', 11.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/07/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 0.48, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/07/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 2.507, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/07/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 248.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/07/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 490.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/07/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/07/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.55, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/07/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 24.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('14/07/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 5.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('16/07/2015 8:40', 'DD/MM/YYYY HH24:MI'), 'Clarity', 2.36, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('16/07/2015 8:40', 'DD/MM/YYYY HH24:MI'), 'Discharge', 2.162, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('16/07/2015 8:40', 'DD/MM/YYYY HH24:MI'), 'E. coli', 25.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('16/07/2015 8:40', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 686.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('16/07/2015 8:40', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('16/07/2015 8:40', 'DD/MM/YYYY HH24:MI'), 'pH', 7.53, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('16/07/2015 8:40', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 7.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('16/07/2015 8:40', 'DD/MM/YYYY HH24:MI'), 'Temperature', 3.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/01/2016 8:30', 'DD/MM/YYYY HH24:MI'), 'Clarity', 2.79, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/01/2016 8:30', 'DD/MM/YYYY HH24:MI'), 'Discharge', 4.618, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/01/2016 8:30', 'DD/MM/YYYY HH24:MI'), 'E. coli', 365.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/01/2016 8:30', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 451.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/01/2016 8:30', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/01/2016 8:30', 'DD/MM/YYYY HH24:MI'), 'pH', 7.86, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/01/2016 8:30', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 9.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/01/2016 8:30', 'DD/MM/YYYY HH24:MI'), 'Temperature', 15.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/05/2015 8:35', 'DD/MM/YYYY HH24:MI'), 'Clarity', 1.81, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/05/2015 8:35', 'DD/MM/YYYY HH24:MI'), 'Discharge', 1.788, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/05/2015 8:35', 'DD/MM/YYYY HH24:MI'), 'E. coli', 235.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/05/2015 8:35', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 435.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/05/2015 8:35', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/05/2015 8:35', 'DD/MM/YYYY HH24:MI'), 'pH', 7.53, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/05/2015 8:35', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 9.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('7/05/2015 8:35', 'DD/MM/YYYY HH24:MI'), 'Temperature', 9.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/01/2015 7:40', 'DD/MM/YYYY HH24:MI'), 'Clarity', 1.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/01/2015 7:40', 'DD/MM/YYYY HH24:MI'), 'Discharge', 8.555, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/01/2015 7:40', 'DD/MM/YYYY HH24:MI'), 'E. coli', 131.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/01/2015 7:40', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 321.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/01/2015 7:40', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/01/2015 7:40', 'DD/MM/YYYY HH24:MI'), 'pH', 7.64, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/01/2015 7:40', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 15.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/01/2015 7:40', 'DD/MM/YYYY HH24:MI'), 'Temperature', 15.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/09/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/09/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 2.442, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/09/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 11.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/09/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 549.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/09/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/09/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.73, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/09/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 6.0, NULL)
SELECT 1 FROM DUAL;

INSERT ALL
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/09/2016 8:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 4.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/10/2015 8:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 0.44, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/10/2015 8:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 6.485, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/10/2015 8:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 28.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/10/2015 8:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 933.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/10/2015 8:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/10/2015 8:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.46, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/10/2015 8:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 40.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('8/10/2015 8:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 8.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/04/2015 8:30', 'DD/MM/YYYY HH24:MI'), 'Clarity', 1.21, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/04/2015 8:30', 'DD/MM/YYYY HH24:MI'), 'Discharge', 1.817, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/04/2015 8:30', 'DD/MM/YYYY HH24:MI'), 'E. coli', 224.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/04/2015 8:30', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 413.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/04/2015 8:30', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/04/2015 8:30', 'DD/MM/YYYY HH24:MI'), 'pH', 7.58, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/04/2015 8:30', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 21.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/04/2015 8:30', 'DD/MM/YYYY HH24:MI'), 'Temperature', 12.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/06/2016 8:40', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/06/2016 8:40', 'DD/MM/YYYY HH24:MI'), 'Discharge', 1.957, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/06/2016 8:40', 'DD/MM/YYYY HH24:MI'), 'E. coli', 30.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/06/2016 8:40', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 395.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/06/2016 8:40', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/06/2016 8:40', 'DD/MM/YYYY HH24:MI'), 'pH', 7.64, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/06/2016 8:40', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK3', to_date('9/06/2016 8:40', 'DD/MM/YYYY HH24:MI'), 'Temperature', 5.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/03/2016 12:00', 'DD/MM/YYYY HH24:MI'), 'Clarity', 4.28, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/03/2016 12:00', 'DD/MM/YYYY HH24:MI'), 'Discharge', 289.061, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/03/2016 12:00', 'DD/MM/YYYY HH24:MI'), 'E. coli', 9.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/03/2016 12:00', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 58.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/03/2016 12:00', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/03/2016 12:00', 'DD/MM/YYYY HH24:MI'), 'pH', 7.78, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/03/2016 12:00', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/03/2016 12:00', 'DD/MM/YYYY HH24:MI'), 'Temperature', 19.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/09/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.64, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/09/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Discharge', 330.778, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/09/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'E. coli', NULL, '< 1')
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/09/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 45.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/09/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/09/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'pH', 7.93, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/09/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/09/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Temperature', 7.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/12/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/12/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 226.383, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/12/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 2.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/12/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 54.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/12/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/12/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.85, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/12/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('10/12/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 17.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/02/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/02/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Discharge', 494.084, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/02/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'E. coli', 16.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/02/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 55.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/02/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/02/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'pH', 7.81, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/02/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/02/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Temperature', 19.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/06/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.59, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/06/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Discharge', 355.807, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/06/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'E. coli', NULL, '< 1')
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/06/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 43.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/06/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/06/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'pH', 7.73, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/06/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/06/2015 12:55', 'DD/MM/YYYY HH24:MI'), 'Temperature', 8.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/08/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 4.84, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/08/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 431.628, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/08/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', NULL, '< 1')
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/08/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 45.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/08/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/08/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.81, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/08/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 2.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('11/08/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 5.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/02/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 4.44, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/02/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 396.068, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/02/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 20.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/02/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 62.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/02/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/02/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'pH', 8.04, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/02/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/02/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 19.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/03/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/03/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 355.227, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/03/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 8.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/03/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 57.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/03/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/03/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.94, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/03/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 7.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/03/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/05/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 6.22, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/05/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 358.831, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/05/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 27.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/05/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 39.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/05/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/05/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.89, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/05/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/05/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 13.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/11/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.36, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/11/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Discharge', 247.74, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/11/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'E. coli', NULL, '< 1')
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/11/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 91.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/11/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/11/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'pH', 7.95, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/11/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('12/11/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Temperature', 13.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('13/08/2015 12:40', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.81, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('13/08/2015 12:40', 'DD/MM/YYYY HH24:MI'), 'Discharge', 349.506, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('13/08/2015 12:40', 'DD/MM/YYYY HH24:MI'), 'E. coli', 27.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('13/08/2015 12:40', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 55.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('13/08/2015 12:40', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('13/08/2015 12:40', 'DD/MM/YYYY HH24:MI'), 'pH', 8.11, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('13/08/2015 12:40', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('13/08/2015 12:40', 'DD/MM/YYYY HH24:MI'), 'Temperature', 6.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/04/2016 13:03', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.91, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/04/2016 13:03', 'DD/MM/YYYY HH24:MI'), 'Discharge', 394.579, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/04/2016 13:03', 'DD/MM/YYYY HH24:MI'), 'E. coli', 4.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/04/2016 13:03', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 74.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/04/2016 13:03', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/04/2016 13:03', 'DD/MM/YYYY HH24:MI'), 'pH', 7.96, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/04/2016 13:03', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/04/2016 13:03', 'DD/MM/YYYY HH24:MI'), 'Temperature', 16.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/07/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Clarity', 4.84, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/07/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Discharge', 393.075, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/07/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'E. coli', NULL, '< 1')
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/07/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 74.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/07/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/07/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'pH', 7.83, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/07/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('14/07/2016 12:40', 'DD/MM/YYYY HH24:MI'), 'Temperature', 7.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('16/07/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 6.12, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('16/07/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 350.71, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('16/07/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', NULL, '< 1')
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('16/07/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 57.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('16/07/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('16/07/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.78, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('16/07/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('16/07/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 5.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/01/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/01/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 279.764, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/01/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 10.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/01/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 75.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/01/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/01/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.78, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/01/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 7.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/01/2016 12:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/05/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.84, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/05/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Discharge', 434.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/05/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'E. coli', 7.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/05/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 49.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/05/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/05/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'pH', 7.72, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/05/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('7/05/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Temperature', 13.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/01/2015 11:55', 'DD/MM/YYYY HH24:MI'), 'Clarity', 4.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/01/2015 11:55', 'DD/MM/YYYY HH24:MI'), 'Discharge', 485.57, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/01/2015 11:55', 'DD/MM/YYYY HH24:MI'), 'E. coli', 8.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/01/2015 11:55', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 56.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/01/2015 11:55', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/01/2015 11:55', 'DD/MM/YYYY HH24:MI'), 'pH', 7.85, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/01/2015 11:55', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/01/2015 11:55', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/09/2016 12:20', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.35, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/09/2016 12:20', 'DD/MM/YYYY HH24:MI'), 'Discharge', 476.754, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/09/2016 12:20', 'DD/MM/YYYY HH24:MI'), 'E. coli', NULL, '< 1')
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/09/2016 12:20', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 103.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/09/2016 12:20', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/09/2016 12:20', 'DD/MM/YYYY HH24:MI'), 'pH', 7.93, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/09/2016 12:20', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/09/2016 12:20', 'DD/MM/YYYY HH24:MI'), 'Temperature', 7.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/10/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Clarity', 2.14, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/10/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Discharge', 324.452, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/10/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'E. coli', 2.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/10/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 51.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/10/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/10/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'pH', 7.86, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/10/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('8/10/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Temperature', 10.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/04/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.96, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/04/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 254.014, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/04/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 8.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/04/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 49.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/04/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/04/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.97, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/04/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/04/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 16.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/06/2016 12:35', 'DD/MM/YYYY HH24:MI'), 'Clarity', 4.81, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/06/2016 12:35', 'DD/MM/YYYY HH24:MI'), 'Discharge', 234.076, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/06/2016 12:35', 'DD/MM/YYYY HH24:MI'), 'E. coli', 2.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/06/2016 12:35', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 57.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/06/2016 12:35', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/06/2016 12:35', 'DD/MM/YYYY HH24:MI'), 'pH', 7.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/06/2016 12:35', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK4', to_date('9/06/2016 12:35', 'DD/MM/YYYY HH24:MI'), 'Temperature', 9.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/03/2016 12:25', 'DD/MM/YYYY HH24:MI'), 'Clarity', 8.61, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/03/2016 12:25', 'DD/MM/YYYY HH24:MI'), 'Discharge', 0.652, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/03/2016 12:25', 'DD/MM/YYYY HH24:MI'), 'E. coli', 178.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/03/2016 12:25', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 78.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/03/2016 12:25', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/03/2016 12:25', 'DD/MM/YYYY HH24:MI'), 'pH', 7.98, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/03/2016 12:25', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 6.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/03/2016 12:25', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/09/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Clarity', 8.81, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/09/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Discharge', 2.782, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/09/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'E. coli', 18.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/09/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 81.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/09/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/09/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'pH', 7.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/09/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/09/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Temperature', 7.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/12/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Clarity', 9.83, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/12/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Discharge', 1.233, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/12/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'E. coli', 60.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/12/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 103.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/12/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/12/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'pH', 7.86, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/12/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 6.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('10/12/2015 13:05', 'DD/MM/YYYY HH24:MI'), 'Temperature', 17.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/02/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.86, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/02/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Discharge', 1.353, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/02/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'E. coli', 36.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/02/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 109.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/02/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/02/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'pH', 7.68, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/02/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/02/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Temperature', 19.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/06/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Clarity', 7.49, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/06/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Discharge', 1.941, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/06/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/06/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Temperature', 9.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/08/2016 13:05', 'DD/MM/YYYY HH24:MI'), 'Clarity', 10.43, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/08/2016 13:05', 'DD/MM/YYYY HH24:MI'), 'Discharge', 4.921, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/08/2016 13:05', 'DD/MM/YYYY HH24:MI'), 'E. coli', 29.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/08/2016 13:05', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 363.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/08/2016 13:05', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 13.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/08/2016 13:05', 'DD/MM/YYYY HH24:MI'), 'pH', 8.21, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/08/2016 13:05', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 2.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('11/08/2016 13:05', 'DD/MM/YYYY HH24:MI'), 'Temperature', 6.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/02/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Clarity', 7.04, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/02/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Discharge', 0.482, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/02/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'E. coli', 25.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/02/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 112.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/02/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 8.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/02/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'pH', 7.72, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/02/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 7.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/02/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/03/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Clarity', 8.44, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/03/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Discharge', 0.467, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/03/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'E. coli', 38.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/03/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 94.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/03/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/03/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'pH', 7.74, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/03/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 7.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/03/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Temperature', 17.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/05/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Clarity', 6.66, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/05/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Discharge', 0.824, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/05/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'E. coli', 125.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/05/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 75.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/05/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/05/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'pH', 7.89, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/05/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/05/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Temperature', 13.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/11/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Clarity', 7.33, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/11/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Discharge', 1.161, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/11/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'E. coli', 59.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/11/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 109.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/11/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/11/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'pH', 7.91, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/11/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('12/11/2015 13:20', 'DD/MM/YYYY HH24:MI'), 'Temperature', 15.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('13/08/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Clarity', 9.25, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('13/08/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Discharge', 2.073, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('13/08/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'E. coli', 1.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('13/08/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 94.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('13/08/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 13.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('13/08/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'pH', 8.28, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('13/08/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('13/08/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Temperature', 6.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/04/2016 13:30', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.78, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/04/2016 13:30', 'DD/MM/YYYY HH24:MI'), 'Discharge', 0.939, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/04/2016 13:30', 'DD/MM/YYYY HH24:MI'), 'E. coli', 105.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/04/2016 13:30', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 81.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/04/2016 13:30', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/04/2016 13:30', 'DD/MM/YYYY HH24:MI'), 'pH', 7.93, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/04/2016 13:30', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/04/2016 13:30', 'DD/MM/YYYY HH24:MI'), 'Temperature', 16.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/07/2016 13:10', 'DD/MM/YYYY HH24:MI'), 'Clarity', 3.43, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/07/2016 13:10', 'DD/MM/YYYY HH24:MI'), 'Discharge', 6.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/07/2016 13:10', 'DD/MM/YYYY HH24:MI'), 'E. coli', 26.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/07/2016 13:10', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 245.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/07/2016 13:10', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/07/2016 13:10', 'DD/MM/YYYY HH24:MI'), 'pH', 8.03, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/07/2016 13:10', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 13.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('14/07/2016 13:10', 'DD/MM/YYYY HH24:MI'), 'Temperature', 7.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('16/07/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Clarity', 9.31, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('16/07/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Discharge', 2.763, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('16/07/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'E. coli', 3.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('16/07/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 108.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('16/07/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 13.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('16/07/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'pH', 8.09, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('16/07/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('16/07/2015 13:15', 'DD/MM/YYYY HH24:MI'), 'Temperature', 6.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/01/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.51, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/01/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Discharge', 0.796, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/01/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'E. coli', 131.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/01/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 94.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/01/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/01/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'pH', 7.98, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/01/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/01/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Temperature', 17.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/05/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'Clarity', 3.85, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/05/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'Discharge', 2.47, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/05/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'E. coli', 344.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/05/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 118.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/05/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/05/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'pH', 7.92, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/05/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 9.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('7/05/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'Temperature', 13.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/01/2015 12:33', 'DD/MM/YYYY HH24:MI'), 'Clarity', 5.17, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/01/2015 12:33', 'DD/MM/YYYY HH24:MI'), 'Discharge', 0.645, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/01/2015 12:33', 'DD/MM/YYYY HH24:MI'), 'E. coli', 461.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/01/2015 12:33', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 127.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/01/2015 12:33', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/01/2015 12:33', 'DD/MM/YYYY HH24:MI'), 'pH', 7.81, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/01/2015 12:33', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 6.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/01/2015 12:33', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/09/2016 12:30', 'DD/MM/YYYY HH24:MI'), 'Clarity', 10.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/09/2016 12:30', 'DD/MM/YYYY HH24:MI'), 'Discharge', 3.388, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/09/2016 12:30', 'DD/MM/YYYY HH24:MI'), 'E. coli', 9.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/09/2016 12:30', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 288.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/09/2016 12:30', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 13.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/09/2016 12:30', 'DD/MM/YYYY HH24:MI'), 'pH', 8.37, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/09/2016 12:30', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/09/2016 12:30', 'DD/MM/YYYY HH24:MI'), 'Temperature', 8.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/10/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'Clarity', 7.58, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/10/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'Discharge', 1.812, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/10/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'E. coli', 101.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/10/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/10/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'pH', 7.66, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('8/10/2015 13:25', 'DD/MM/YYYY HH24:MI'), 'Temperature', 11.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/04/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Clarity', 8.56, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/04/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Discharge', 0.612, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/04/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'E. coli', 16.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/04/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 88.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/04/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/04/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'pH', 7.81, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/04/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 6.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/04/2015 13:00', 'DD/MM/YYYY HH24:MI'), 'Temperature', 15.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/06/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Clarity', 8.921, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/06/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Discharge', 2.476, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/06/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'E. coli', 53.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/06/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 109.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/06/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/06/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'pH', 8.04, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/06/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK5', to_date('9/06/2016 13:00', 'DD/MM/YYYY HH24:MI'), 'Temperature', 9.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/03/2016 10:55', 'DD/MM/YYYY HH24:MI'), 'Clarity', 4.31, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/03/2016 10:55', 'DD/MM/YYYY HH24:MI'), 'Discharge', 287.689, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/03/2016 10:55', 'DD/MM/YYYY HH24:MI'), 'E. coli', 110.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/03/2016 10:55', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 74.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/03/2016 10:55', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/03/2016 10:55', 'DD/MM/YYYY HH24:MI'), 'pH', 7.89, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/03/2016 10:55', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/03/2016 10:55', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/09/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 2.87, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/09/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 350.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/09/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 11.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/09/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 54.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/09/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/09/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.89, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/09/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 3.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/09/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 8.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/12/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Clarity', 1.97, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/12/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Discharge', 310.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/12/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'E. coli', 73.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/12/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 80.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/12/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/12/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'pH', 7.77, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/12/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('10/12/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Temperature', 17.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/02/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Clarity', 1.26, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/02/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Discharge', 450.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/02/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'E. coli', 73.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/02/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 106.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/02/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/02/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'pH', 7.91, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/02/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 10.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/02/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/06/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Clarity', 1.05, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/06/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Discharge', 350.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/06/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'E. coli', 39.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/06/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 70.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/06/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/06/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'pH', 7.72, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/06/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 14.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/06/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Temperature', 8.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/08/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Clarity', 2.42, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/08/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Discharge', 435.826, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/08/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'E. coli', 9.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/08/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 98.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/08/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 13.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/08/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'pH', 7.77, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/08/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 5.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('11/08/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Temperature', 5.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/02/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Clarity', 3.43, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/02/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Discharge', 380.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/02/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'E. coli', 110.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/02/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 66.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/02/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/02/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'pH', 8.03, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/02/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 6.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/02/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/03/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Clarity', 3.02, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/03/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Discharge', 360.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/03/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'E. coli', 26.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/03/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 89.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/03/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/03/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'pH', 7.93, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/03/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 19.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/03/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/05/2016 11:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 1.99, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/05/2016 11:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 320.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/05/2016 11:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 15.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/05/2016 11:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 85.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/05/2016 11:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/05/2016 11:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.81, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/05/2016 11:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/05/2016 11:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 13.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/11/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 2.23, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/11/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 250.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/11/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 44.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/11/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 137.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/11/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/11/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/11/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 6.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('12/11/2015 12:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 13.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('13/08/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Clarity', 3.35, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('13/08/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Discharge', 360.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('13/08/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'E. coli', 30.5, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('13/08/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 90.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('13/08/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 13.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('13/08/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'pH', 7.98, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('13/08/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('13/08/2015 11:40', 'DD/MM/YYYY HH24:MI'), 'Temperature', 5.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/04/2016 12:02', 'DD/MM/YYYY HH24:MI'), 'Clarity', 2.51, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/04/2016 12:02', 'DD/MM/YYYY HH24:MI'), 'Discharge', 396.253, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/04/2016 12:02', 'DD/MM/YYYY HH24:MI'), 'E. coli', 46.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/04/2016 12:02', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 108.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/04/2016 12:02', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/04/2016 12:02', 'DD/MM/YYYY HH24:MI'), 'pH', 7.83, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/04/2016 12:02', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 7.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/04/2016 12:02', 'DD/MM/YYYY HH24:MI'), 'Temperature', 15.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/07/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Clarity', 2.65, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/07/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Discharge', 432.938, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/07/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'E. coli', 70.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/07/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 95.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/07/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/07/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'pH', 7.73, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/07/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 7.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('14/07/2016 11:40', 'DD/MM/YYYY HH24:MI'), 'Temperature', 7.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('16/07/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Clarity', 1.86, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('16/07/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Discharge', 360.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('16/07/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'E. coli', 32.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('16/07/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 70.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('16/07/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('16/07/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'pH', 7.79, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('16/07/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('16/07/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Temperature', 6.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/01/2016 11:35', 'DD/MM/YYYY HH24:MI'), 'Clarity', 1.55, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/01/2016 11:35', 'DD/MM/YYYY HH24:MI'), 'Discharge', 420.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/01/2016 11:35', 'DD/MM/YYYY HH24:MI'), 'E. coli', 66.9, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/01/2016 11:35', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 77.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/01/2016 11:35', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/01/2016 11:35', 'DD/MM/YYYY HH24:MI'), 'pH', 8.04, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/01/2016 11:35', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 8.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/01/2016 11:35', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.6, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/05/2015 11:52', 'DD/MM/YYYY HH24:MI'), 'Clarity', 0.77, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/05/2015 11:52', 'DD/MM/YYYY HH24:MI'), 'Discharge', 450.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/05/2015 11:52', 'DD/MM/YYYY HH24:MI'), 'E. coli', 135.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/05/2015 11:52', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 73.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/05/2015 11:52', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.8, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/05/2015 11:52', 'DD/MM/YYYY HH24:MI'), 'pH', 7.81, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/05/2015 11:52', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 9.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('7/05/2015 11:52', 'DD/MM/YYYY HH24:MI'), 'Temperature', 13.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/01/2015 10:48', 'DD/MM/YYYY HH24:MI'), 'Clarity', 0.87, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/01/2015 10:48', 'DD/MM/YYYY HH24:MI'), 'Discharge', 500.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/01/2015 10:48', 'DD/MM/YYYY HH24:MI'), 'E. coli', 121.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/01/2015 10:48', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 97.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/01/2015 10:48', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 9.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/01/2015 10:48', 'DD/MM/YYYY HH24:MI'), 'pH', 7.81, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/01/2015 10:48', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 15.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/01/2015 10:48', 'DD/MM/YYYY HH24:MI'), 'Temperature', 18.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/09/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Clarity', 2.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/09/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Discharge', 401.564, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/09/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'E. coli', 35.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/09/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 97.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/09/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 12.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/09/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'pH', 7.76, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/09/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 6.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/09/2016 11:30', 'DD/MM/YYYY HH24:MI'), 'Temperature', 7.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/10/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Clarity', 1.28, NULL)
SELECT 1 FROM DUAL;

INSERT ALL
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/10/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Discharge', 350.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/10/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'E. coli', 387.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/10/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 110.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/10/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/10/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'pH', 7.74, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/10/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 8.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('8/10/2015 11:50', 'DD/MM/YYYY HH24:MI'), 'Temperature', 10.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/04/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Clarity', 3.28, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/04/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Discharge', 310.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/04/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'E. coli', 12.1, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/04/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 47.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/04/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 10.2, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/04/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'pH', 7.89, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/04/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/04/2015 11:45', 'DD/MM/YYYY HH24:MI'), 'Temperature', 15.4, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/06/2016 11:36', 'DD/MM/YYYY HH24:MI'), 'Clarity', 3.11, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/06/2016 11:36', 'DD/MM/YYYY HH24:MI'), 'Discharge', 234.957, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/06/2016 11:36', 'DD/MM/YYYY HH24:MI'), 'E. coli', 71.7, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/06/2016 11:36', 'DD/MM/YYYY HH24:MI'), 'Nitrogen', 76.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/06/2016 11:36', 'DD/MM/YYYY HH24:MI'), 'Oxygen', 11.3, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/06/2016 11:36', 'DD/MM/YYYY HH24:MI'), 'pH', 7.65, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/06/2016 11:36', 'DD/MM/YYYY HH24:MI'), 'Phosphorus', 4.0, NULL)
    INTO Measurement (Site_ID, Recorded_On, Name, Value, Outlier_Indicator) VALUES ('TK6', to_date('9/06/2016 11:36', 'DD/MM/YYYY HH24:MI'), 'Temperature', 8.3, NULL)
SELECT 1 FROM DUAL;


COMMIT;
