rem File: e:\wizard\GMD2_data\sql_updates\gmd2sql_x20260710_1726.sql
rem Generated from x20260710_1726
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_1726.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
   ('381210097395701', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381210097395701'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 50.64, 'T', 2, 'GMD2', 53.84, 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
   ('381302097394901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381302097394901'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 44.62, 'T', 2, 'GMD2', 47.72, 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
   ('381354097395101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381354097395101'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 52.53, 'T', 2, 'GMD2', 55.33, 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
   ('381447097395801', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381447097395801'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 51.60, 'T', 2, 'GMD2', 54.1, 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
   ('381539097395901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381539097395901'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 57.98, 'T', 2, 'GMD2', 61.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
   ('381631097395901', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381631097395901'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 53.43, 'T', 2, 'GMD2', 56.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
   ('381724097400001', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381724097400001'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 63.70, 'T', 2, 'GMD2', 66.7, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


spool off

rollback;
rem commit;
