rem File: e:\wizard\GMD2_data\sql_updates\gmd2sql_x20260710_1732.sql
rem Generated from x20260710_1732
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_1732.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
   ('379721097425501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '379721097425501'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 24.63, 'T', 2, 'GMD2', 27.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
   ('379721097424501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '379721097424501'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 24.61, 'T', 2, 'GMD2', 27.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
   ('379721097423501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '379721097423501'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 23.99, 'S', 2, 'GMD2', 26.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
   ('379731097426901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '379731097426901'),
    to_date('09-Jul-2026', 'DD-Mon-YYYY'), 30.24, 'T', 2, 'GMD2', 32.84, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


spool off

rollback;
rem commit;
