rem File: e:\wizard\GMD2_data\sql_updates\gmd2sql_x20260710_1731.sql
rem Generated from x20260710_1731
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_1731.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
   ('380525097400101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380525097400101'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 44.98, 'T', 2, 'GMD2', 48.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
   ('380540097410301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380540097410301'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 34.01, '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
   ('380605097403001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380605097403001'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 28.39, 'T', 2, 'GMD2', 31.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
   ('380622097410301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380622097410301'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 32.58, 'T', 2, 'GMD2', 35.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
   ('380658097403101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380658097403101'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 26.63, 'T', 2, 'GMD2', 29.63, 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
   ('380643097410301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380643097410301'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 27.76, 'T', 2, 'GMD2', 31.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
   ('380631097403101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '380631097403101'),
    to_date('06-Jul-2026', 'DD-Mon-YYYY'), 28.39, 'T', 2, 'GMD2', 31.59, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


spool off

rollback;
rem commit;
