rem File: e:\wizard\GMD2_data\sql_updates\gmd2sql_x20260710_1725.sql
rem Generated from x20260710_1725
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_1725.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
   ('380238097505603', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380238097505603'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 12.24, 'T', 2, 'GMD2', 13.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
   ('380238097505601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380238097505601'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 11.75, 'T', 2, 'GMD2', 14.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
   ('380141097531003', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380141097531003'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 9.18, 'T', 2, 'GMD2', 11.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
   ('380141097531001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380141097531001'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 9.15, 'T', 2, 'GMD2', 11.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
   ('380054097541103', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380054097541103'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 8.06, 'T', 2, 'GMD2', 11.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
   ('380054097541101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380054097541101'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 7.99, 'T', 2, 'GMD2', 10.99, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


spool off

rollback;
rem commit;
