rem File: e:\wizard\GMD2_data\sql_updates\gmd2sql_x20260710_1728.sql
rem Generated from x20260710_1728
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_1728.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
   ('375117098040101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375117098040101'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 3.99, 'T', 2, 'GMD2', 6.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
   ('375018098051501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375018098051501'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 24.68, 'T', 2, 'GMD2', 27.58, 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
   ('375018098030301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375018098030301'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 1.78, 'T', 2, 'GMD2', 4.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
   ('375018098030302', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375018098030302'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 1.31, 'T', 2, 'GMD2', 4.21, 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
   ('375024098004401', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375024098004401'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 11.18, 'T', 2, 'GMD2', 13.98, 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
   ('374925098045001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374925098045001'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 34.92, 'T', 2, 'GMD2', 37.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
   ('374925098045002', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374925098045002'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 34.70, 'T', 2, 'GMD2', 37.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
   ('374818098070201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374818098070201'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 16.21, 'T', 2, 'GMD2', 19.01, 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
   ('374725098060501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374725098060501'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 2.38, 'T', 2, 'GMD2', 5.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
   ('374725098060502', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374725098060502'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 2.44, 'T', 2, 'GMD2', 5.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
   ('374827098024001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374827098024001'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 46.34, 'T', 2, 'GMD2', 49.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
   ('374827098024002', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374827098024002'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 46.45, 'T', 2, 'GMD2', 49.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
   ('374634098014201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374634098014201'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 24.35, 'T', 2, 'GMD2', 27, 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
   ('374634098014202', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374634098014202'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 24.45, 'T', 2, 'GMD2', 27.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
   ('374726098034501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374726098034501'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 57.02, 'T', 2, 'GMD2', 60.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
   ('374726098034502', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374726098034502'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 57.95, 'T', 2, 'GMD2', 61.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
   ('374639098080801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374639098080801'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 26.02, 'T', 2, 'GMD2', 29.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
   ('374639098080802', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374639098080802'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 25.92, 'T', 2, 'GMD2', 28.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
   ('374540098055701', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374540098055701'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 18.74, 'T', 2, 'GMD2', 21.74, 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
   ('374540098055702', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374540098055702'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 18.62, 'T', 2, 'GMD2', 21.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
   ('374541098035401', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374541098035401'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 26.41, 'T', 2, 'GMD2', 29.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
   ('374403098045801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374403098045801'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 21.58, 'T', 2, 'GMD2', 24.25, 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
   ('374900098003101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374900098003101'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 27.12, 'T', 2, 'GMD2', 30.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
   ('374900098003102', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374900098003102'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 27.20, 'T', 2, 'GMD2', 30, 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
   ('374828097581801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374828097581801'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 4.02, 'T', 2, 'GMD2', 6.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
   ('374814097560501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374814097560501'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 16.18, 'T', 2, 'GMD2', 18.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
   ('374635097582601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374635097582601'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 39.13, 'T', 2, 'GMD2', 42.03, 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
   ('374549097561401', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374549097561401'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 13.80, 'T', 2, 'GMD2', 16.65, 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
   ('374549097561402', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374549097561402'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 15.94, 'T', 2, 'GMD2', 18.69, 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
   ('374457097582501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374457097582501'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 43.22, 'T', 2, 'GMD2', 46.27, 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
   ('374457097582502', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374457097582502'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 43.09, 'T', 2, 'GMD2', 46.09, 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
   ('374549098001301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374549098001301'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 25.62, 'T', 2, 'GMD2', 28.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
   ('374549098001302', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374549098001302'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 25.60, 'T', 2, 'GMD2', 28.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
   ('375111098072001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375111098072001'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 2.90, 'T', 2, 'GMD2', 5.8, 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
   ('375118098072001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375118098072001'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 3.40, 'T', 2, 'GMD2', 6, 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
   ('375130098004301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375130098004301'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 3.23, 'T', 2, 'GMD2', 6.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
   ('375130098004302', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375130098004302'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 3.28, 'T', 2, 'GMD2', 5.98, 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
   ('375104097562001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375104097562001'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 1.18, 'T', 2, 'GMD2', 4.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
   ('374932097583201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374932097583201'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 22.92, 'T', 2, 'GMD2', 25.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
   ('374442098014201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374442098014201'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 6.22, 'T', 2, 'GMD2', 9.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
   ('374451097541901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374451097541901'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 8.13, 'T', 2, 'GMD2', 10.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
   ('374451097541902', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374451097541902'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 8.31, 'T', 2, 'GMD2', 11.21, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


spool off

rollback;
rem commit;
