rem File: e:\wizard\GMD2_data\sql_updates\gmd2sql_x20260710_1729.sql
rem Generated from x20260710_1729
rem GMD2 Water Level Data

set echo on
set heading on
set termout on
set feedback on
set verify on
set pagesize 0
set linesize 300

spool e:\wizard\GMD2_data\sql_updates\gmd2sql_x20260710_1729.lst


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('381013097365101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381013097365101'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 45.59, 'T', 2, 'GMD2', 48.79, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('381013097370101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381013097370101'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 47.62, 'T', 2, 'GMD2', 52.32, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('381011097370401', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381011097370401'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 48.22, 'T', 2, 'GMD2', 49.52, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('381011097370402', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381011097370402'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 52.24, 'T', 2, 'GMD2', 54.34, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('381011097365901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381011097365901'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 55.82, 'T', 2, 'GMD2', 57.82, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('381007097365901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381007097365901'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 52.70, 'T', 2, 'GMD2', 54.95, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375721097262501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375721097262501'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 26.72, 'T', 2, 'GMD2', 29.47, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375721097261901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375721097261901'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 52.97, 'T', 2, 'GMD2', 54.72, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('380935097324301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380935097324301'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 53.21, 'T', 2, 'GMD2', 56.61, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('380943097324001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380943097324001'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 45.00, 'T', 2, 'GMD2', 47.4, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('380945097324601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380945097324601'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 50.51, 'T', 2, 'GMD2', 53.61, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('381012097331301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381012097331301'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 60.18, 'T', 2, 'GMD2', 63.68, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('381011097330501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381011097330501'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 81.14, 'T', 2, 'GMD2', 82.22, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('381007097330501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381007097330501'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 75.01, 'T', 2, 'GMD2', 76.11, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('380136097253901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380136097253901'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 22.62, 'T', 2, 'GMD2', 25.72, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375654098072701', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375654098072701'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 40.05, 'T', 2, 'GMD2', 42.05, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('374903098012301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374903098012301'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 32.92, 'T', 2, 'GMD2', 35.02, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('374903098011801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374903098011801'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 36.47, 'T', 2, 'GMD2', 39.47, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('374909098010901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374909098010901'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 36.47, 'T', 2, 'GMD2', 38.97, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375351098070901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375351098070901'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 42.99, 'T', 2, 'GMD2', 45.49, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375825098024601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375825098024601'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 42.00, 'T', 2, 'GMD2', 45.5, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375733098031801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375733098031801'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 61.89, 'T', 2, 'GMD2', 63.79, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375932098060701', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375932098060701'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 34.59, 'T', 2, 'GMD2', 36.29, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('374823098004601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374823098004601'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 48.48, 'T', 2, 'GMD2', 51.48, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375405098053001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375405098053001'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 51.57, 'T', 2, 'GMD2', 53.57, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375405098053501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375405098053501'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 54.50, 'T', 2, 'GMD2', 55.3, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375405098053701', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375405098053701'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 57.39, 'T', 2, 'GMD2', 59.24, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375815037263601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375815037263601'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 25.06, 'T', 2, 'GMD2', 30.16, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375813097255101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375813097255101'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 80.57, 'T', 2, 'GMD2', 85.67, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375813097253801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375813097253801'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 28.91, 'T', 2, 'GMD2', 31.51, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375814097262201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375814097262201'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 46.86, 'T', 2, 'GMD2', 49.57, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375827097255501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375827097255501'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 24.77, 'T', 2, 'GMD2', 27.07, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375826097261101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375826097261101'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 61.59, 'T', 2, 'GMD2', 62.84, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375915097255201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375915097255201'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 61.78, 'T', 2, 'GMD2', 65.88, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375949097253701', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375949097253701'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 26.98, 'T', 2, 'GMD2', 28.08, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375955097253601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375955097253601'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 22.51, 'T', 2, 'GMD2', 25.61, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375944097253701', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375944097253701'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 30.72, 'T', 2, 'GMD2', 33.82, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('380236097380901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380236097380901'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 43.33, 'T', 2, 'GMD2', 46.33, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375655097253801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375655097253801'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 28.27, 'T', 2, 'GMD2', 29.97, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375702097253601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375702097253601'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 29.62, 'T', 2, 'GMD2', 33.62, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375628097255401', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375628097255401'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 35.08, 'T', 2, 'GMD2', 38.28, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('374441097561201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374441097561201'),
    to_date('02-Jul-2026', 'DD-Mon-YYYY'), 21.38, 'T', 2, 'GMD2', 24.38, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375931097541101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375931097541101'),
    to_date('02-Jul-2026', 'DD-Mon-YYYY'), 19.58, 'T', 2, 'GMD2', 23.38, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375646098064401', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375646098064401'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 30.91, 'T', 2, 'GMD2', 32.61, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('380010098020801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380010098020801'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 37.68, 'T', 2, 'GMD2', 40.38, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('374455097553301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374455097553301'),
    to_date('02-Jul-2026', 'DD-Mon-YYYY'), 16.28, 'T', 2, 'GMD2', 19.18, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375509098015501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375509098015501'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 11.87, 'T', 2, 'GMD2', 13.87, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('380017098024801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380017098024801'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 41.82, 'T', 2, 'GMD2', 44.92, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375621098022701', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375621098022701'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 19.88, 'T', 2, 'GMD2', 23.18, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375707098022801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375707098022801'),
    to_date('02-Jul-2026', 'DD-Mon-YYYY'), 15.88, 'T', 2, 'GMD2', 18.38, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375651097574001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375651097574001'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 14.93, 'T', 2, 'GMD2', 17.73, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375535097585601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375535097585601'),
    to_date('02-Jul-2026', 'DD-Mon-YYYY'), 36.30, 'T', 2, 'GMD2', 39.1, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375444098060201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375444098060201'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 35.07, 'T', 2, 'GMD2', 37.77, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375535098022801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375535098022801'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 14.77, 'T', 2, 'GMD2', 17.87, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375336098065201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375336098065201'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 42.15, 'T', 2, 'GMD2', 45.05, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375509098060301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375509098060301'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 22.14, 'T', 2, 'GMD2', 25.94, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375506098061901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375506098061901'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 27.45, 'T', 2, 'GMD2', 30.55, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375628098052301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375628098052301'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 17.18, 'T', 2, 'GMD2', 20.08, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375602098061801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375602098061801'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 37.52, 'T', 2, 'GMD2', 40.42, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375350097584501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375350097584501'),
    to_date('02-Jul-2026', 'DD-Mon-YYYY'), 23.93, 'T', 2, 'GMD2', 26.93, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375707098070901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375707098070901'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 34.68, 'T', 2, 'GMD2', 37.08, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375732098040801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375732098040801'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 32.99, 'T', 2, 'GMD2', 35.19, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375536098072601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375536098072601'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 30.62, 'T', 2, 'GMD2', 32.82, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375628098075901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375628098075901'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 35.54, 'T', 2, 'GMD2', 38.34, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375720098075901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375720098075901'),
    to_date('01-Jul-2026', 'DD-Mon-YYYY'), 43.38, 'T', 2, 'GMD2', 46.18, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375718097571501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375718097571501'),
    to_date('02-Jul-2026', 'DD-Mon-YYYY'), 19.72, 'T', 2, 'GMD2', 22.62, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375712097565901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375712097565901'),
    to_date('02-Jul-2026', 'DD-Mon-YYYY'), 18.25, 'T', 2, 'GMD2', 21.15, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('381015097372701', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381015097372701'),
    to_date('10-Jul-2026', 'DD-Mon-YYYY'), 44.60, 'T', 2, 'GMD2', 45.35, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375720097553901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375720097553901'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 25.13, 'T', 2, 'GMD2', 27.13, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375720097552001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375720097552001'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 26.28, 'T', 2, 'GMD2', 26.38, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375646097573301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375646097573301'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 14.16, 'T', 2, 'GMD2', 16.86, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375627097573201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375627097573201'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 10.82, 'T', 2, 'GMD2', 13.82, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375628097580101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375628097580101'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 12.65, 'T', 2, 'GMD2', 16.05, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


insert into WIZARD.WATER_LEVELS
   (USGS_ID, SEQUENCE_NUMBER, MEASUREMENT_DATE_AND_TIME, DEPTH_TO_WATER, METHOD,
    ACCURACY_CODE, AGENCY, TAPE_HOLD, CHALK_CUT,
    INITIALS, UPDATE_INITIALS, UPDATE_DATE)
values
   ('375652097572201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375652097572201'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 35.17, 'T', 2, 'GMD2', 36.47, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


spool off

rollback;
rem commit;
