rem File: e:\wizard\GMD2_data\sql_updates\gmd2sql_x20260710_1724.sql
rem Generated from x20260710_1724
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_1724.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
   ('380700097385305', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380700097385305'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 19.32, 'T', 2, 'GMD2', 22.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
   ('380700097385303', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380700097385303'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 20.93, 'T', 2, 'GMD2', 24.43, 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
   ('380746097384504', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380746097384504'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 46.38, 'T', 2, 'GMD2', 49.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
   ('380746097384505', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380746097384505'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 46.60, 'T', 2, 'GMD2', 49.9, 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
   ('380746097384503', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380746097384503'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 46.66, 'T', 2, 'GMD2', 49.26, 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
   ('380839097384501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380839097384501'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 45.14, 'T', 2, 'GMD2', 47.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
   ('380839097384504', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380839097384504'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 45.87, 'T', 2, 'GMD2', 48.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
   ('380839097384503', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380839097384503'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 45.67, 'T', 2, 'GMD2', 48.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
   ('380931097385304', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380931097385304'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 43.52, 'T', 2, 'GMD2', 46.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
   ('380931097385305', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380931097385305'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 44.56, 'T', 2, 'GMD2', 47.26, 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
   ('380931097385303', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380931097385303'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 44.65, 'T', 2, 'GMD2', 47.45, 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
   ('380621097395101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380621097395101'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 27.58, 'T', 2, 'GMD2', 31.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
   ('380621097395102', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380621097395102'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 27.92, 'T', 2, 'GMD2', 31.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
   ('380621097395103', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380621097395103'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 27.98, 'T', 2, 'GMD2', 31.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
   ('380720097400001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380720097400001'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 24.98, 'T', 2, 'GMD2', 27.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
   ('380720097400002', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380720097400002'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 24.99, 'T', 2, 'GMD2', 26.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
   ('380720097400003', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380720097400003'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 24.63, 'T', 2, 'GMD2', 27.23, 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
   ('380812097400002', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380812097400002'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 40.29, 'T', 2, 'GMD2', 42.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
   ('380812097400003', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380812097400003'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 40.62, 'T', 2, 'GMD2', 44.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
   ('380905097395104', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380905097395104'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 47.52, 'T', 2, 'GMD2', 50.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
   ('380905097395105', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380905097395105'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 47.45, 'T', 2, 'GMD2', 50.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
   ('380905097395103', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380905097395103'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 48.39, 'T', 2, 'GMD2', 51.89, 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
   ('380608097410601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380608097410601'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 31.14, 'T', 2, 'GMD2', 34.44, 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
   ('380608097410602', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380608097410602'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 31.22, 'T', 2, 'GMD2', 34.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
   ('380608097410603', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380608097410603'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 32.94, 'T', 2, 'GMD2', 35.64, 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
   ('380700097405804', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380700097405804'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 34.98, 'T', 2, 'GMD2', 37.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
   ('380700097405805', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380700097405805'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 36.95, 'T', 2, 'GMD2', 39.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
   ('380700097405803', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380700097405803'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 37.51, 'T', 2, 'GMD2', 40.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
   ('380746097410601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380746097410601'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 26.43, 'T', 2, 'GMD2', 29.53, 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
   ('380746097410604', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380746097410604'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 26.14, 'T', 2, 'GMD2', 29.14, 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
   ('380746097410603', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380746097410603'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 26.89, 'T', 2, 'GMD2', 30.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
   ('380832097410604', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380832097410604'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 38.22, 'T', 2, 'GMD2', 40.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
   ('380832097410605', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380832097410605'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 39.16, 'T', 2, 'GMD2', 42.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
   ('380832097410603', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380832097410603'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 39.52, 'T', 2, 'GMD2', 41.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
   ('380931097410604', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380931097410604'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 31.21, 'T', 2, 'GMD2', 33.91, 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
   ('380931097410605', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380931097410605'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 53.45, 'T', 2, 'GMD2', 56.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
   ('380931097410603', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380931097410603'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 52.77, 'T', 2, 'GMD2', 55.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
   ('380634097420204', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380634097420204'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 41.70, 'T', 2, 'GMD2', 44.7, 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
   ('380634097420203', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380634097420203'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 41.79, 'T', 2, 'GMD2', 44.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
   ('380726097420204', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380726097420204'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 39.85, 'T', 2, 'GMD2', 42.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
   ('380726097420205', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380726097420205'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 40.84, 'T', 2, 'GMD2', 43.44, 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
   ('380726097420203', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380726097420203'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 40.63, 'T', 2, 'GMD2', 43.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
   ('380812097420204', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380812097420204'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 28.89, 'T', 2, 'GMD2', 31.89, 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
   ('380812097420205', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380812097420205'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 28.85, 'T', 2, 'GMD2', 31.75, 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
   ('380812097420203', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380812097420203'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 28.87, 'T', 2, 'GMD2', 32.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
   ('380911097420204', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380911097420204'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 34.29, 'T', 2, 'GMD2', 37.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
   ('380911097420205', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380911097420205'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 34.40, 'T', 2, 'GMD2', 37.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
   ('380911097420203', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380911097420203'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 34.61, 'T', 2, 'GMD2', 37.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
   ('380654097405002', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380654097405002'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 29.08, 'T', 2, 'GMD2', 32.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
   ('380710097404602', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380710097404602'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 29.51, 'T', 2, 'GMD2', 33.71, 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
   ('375256098040201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375256098040201'),
    to_date('29-Jun-2026', 'DD-Mon-YYYY'), 15.38, 'T', 2, 'GMD2', 19.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
   ('375348097504901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375348097504901'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 11.33, 'T', 2, 'GMD2', 15.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
   ('375111097483701', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375111097483701'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 7.13, 'T', 2, 'GMD2', 10.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
   ('374824097444601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374824097444601'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 16.84, 'T', 2, 'GMD2', 20.64, 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
   ('374501097430601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374501097430601'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 9.51, 'T', 2, 'GMD2', 12.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
   ('380937097505001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380937097505001'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 10.47, 'T', 2, 'GMD2', 13.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
   ('381022097551501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381022097551501'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 11.87, 'T', 2, 'GMD2', 14.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
   ('380752097534401', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380752097534401'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 15.38, 'T', 2, 'GMD2', 18.23, 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
   ('380600097505801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380600097505801'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 14.97, 'T', 2, 'GMD2', 17.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
   ('380601097452901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380601097452901'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 14.23, 'T', 2, 'GMD2', 17.43, 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
   ('380416097474101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380416097474101'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 20.26, 'T', 2, 'GMD2', 23.66, 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
   ('380417097431601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380417097431601'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 7.87, 'T', 2, 'GMD2', 10.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
   ('380643097353001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380643097353001'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 22.29, 'T', 2, 'GMD2', 24.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
   ('374956097231601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '374956097231601'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 18.60, 'T', 2, 'GMD2', 20.7, 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
   ('375259097252901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375259097252901'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 23.81, 'T', 2, 'GMD2', 25.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
   ('380424097343801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380424097343801'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 17.32, 'T', 2, 'GMD2', 18.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
   ('380237097324401', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380237097324401'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 18.28, 'T', 2, 'GMD2', 20.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
   ('380028097311001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380028097311001'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 16.16, 'T', 2, 'GMD2', 18.23, 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
   ('375304097291301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375304097291301'),
    to_date('08-Jul-2026', 'DD-Mon-YYYY'), 16.28, 'T', 2, 'GMD2', 17.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
   ('375141097243201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '375141097243201'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 16.17, 'T', 2, 'GMD2', 18.47, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


spool off

rollback;
rem commit;
