rem File: e:\wizard\GMD2_data\sql_updates\gmd2sql_x20260710_1727.sql
rem Generated from x20260710_1727
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_1727.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
   ('382053097374701', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '382053097374701'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 31.83, 'T', 2, 'GMD2', 34.73, 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
   ('382000097382501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '382000097382501'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 84.96, 'T', 2, 'GMD2', 87.66, 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
   ('381907097382201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381907097382201'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 62.04, 'T', 2, 'GMD2', 64.74, 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
   ('382024097382302', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '382024097382302'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 89.54, 'T', 2, 'GMD2', 92.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
   ('382024097382301', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '382024097382301'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 89.54, 'T', 2, 'GMD2', 92.94, 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
   ('381933097375101', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381933097375101'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 77.13, 'T', 2, 'GMD2', 79.83, 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
   ('382143097385501', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '382143097385501'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 76.54, 'T', 2, 'GMD2', 79.24, 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
   ('381908097393201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381908097393201'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 62.95, 'T', 2, 'GMD2', 65.75, 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
   ('381934097394202', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381934097394202'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 82.23, 'T', 2, 'GMD2', 85.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
   ('381934097394203', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381934097394203'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 82.25, 'T', 2, 'GMD2', 85.15, 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
   ('381934097394201', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381934097394201'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 82.26, 'T', 2, 'GMD2', 84.86, 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
   ('381908097395601', (select max(sequence_number) + 1 from wizard.water_levels where usgs_id = '381908097395601'),
    to_date('07-Jul-2026', 'DD-Mon-YYYY'), 75.66, 'T', 2, 'GMD2', 78.46, 0,
    'DDR', 'BBW', to_date('07/10/2026', 'MM/DD/YYYY')) ;


spool off

rollback;
rem commit;
