rem File: e:\wizard\GMD2_data\sql_updates\gmd2sql_x20260710_1730.sql
rem Generated from x20260710_1730
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_1730.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
   ('382142097415902', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '382142097415902'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 92.81, 'T', 2, 'GMD2', 95.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
   ('380239097520603', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380239097520603'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 11.15, '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
   ('380239097520601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380239097520601'),
    to_date('30-Jun-2026', 'DD-Mon-YYYY'), 11.13, 'T', 2, 'GMD2', 13.73, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


spool off

rollback;
rem commit;
