# Presentation: 745109

## Keying Great Lakes Water Levels

**Stephen D. Lyles**

**NATIONAL OCEAN SERVICE**
- Center for Operational Oceanographic Products and Services
- (CO-OPS)

## Water Levels on the Great Lakes

**Published Since 1860**
**Uses of Archived data**

**Notes:**
PUBLISDED:
Monthly Means      1860 = 9
	        1900 = 16
Early 1950’s  NEW Datum IGLD ‘55  increased gauging effort
	        1960 = 43
	         1970 = 52

USES:
	Sieche
	Crustal movement
	other scientific studies

## Great Lakes NWLON Stations

**Great Lakes NWLON Stations**

## Project Goals

**Digitize Archived Data**
**Data available on CO-OPS Web Page**

**Notes:**
DIGITIZE:
     Preserve the data in digital format from deteriorating books
     Bound books are very delicate	
WEB:
     make the data readily available to all users
     on the most current datum 

## Data Set Description

**Quantity**
**	****1,400 Station Years of data**
**  ****	****	****    ****(12.9 million entries)**
**Media**
**	****Water Level Books**
**	****Tabular Pages**

**Notes:**
Quantity:
      Hourly & Daily Means   25 entries/day * 365 days = 9,125 entries/yr
      Max/Min & Ann Mean    7 entries/month * 12 months = 84 entries/yr 
       9,209 entries/yr * 1,400 yr = 12,892,600 entries

       Pages of data = 2 page/month * 12 month/yr *1400 yr = 33,600 pages

MEDIA:
      Bound Books  -  two formats show in minute
      Tabular Pages   -  Daily Sheets  - 1 values per day with monthly mean 
                                -  Tri-Daily  3 values per day with daily, monthly means
                                -  Hourly Printouts - most of the 1960 - 1969  years of data
MICRO FICHE:
       most of the books completed in mid 70’s - not of good quality
	upside down
     	not in focus
       possible use only as emergency backup
ALL DATA LOCATED in Silver Spring

## Slide 6

## Slide 7

## Slide 8

## Slide 9

**Notes:**
Copy of Hourly Printouts 

      would not be scanned 

## Required Rescue Activity

**Key Data **
**Quality Control Check**
**Compute Means **
**Determine Maximum & Minimum Values**
**Compare computed data to keyed data**

**Notes:**
SCAN:  Propose scanning original documents and have data keyed from images
	Reduce risk of damage to the bound books
	Provide rapid access to any user that would like to see originals
              NOT scan recent hourly data sheets
              Scan the old daily sheets
 	one value per day & monthly mean
	NOT in bound books, loose sheets with fastener
	scanning them would provide easy access
	NOT key daily sheets
KEY: 
QC:  using hourly data, compute means, & extremes

If contractor is interested, GLERL has developed FORTRAN programs for keying the data under an ESDIM project for the 5 master gauges on the lakes and the Buffalo gauge.  They have currently finished entering the data from Harbor Beach gauge & Ludington gauge.  

## Deliverables

**Data Files on CD**
**	****	****Hourly**
**	****	****Daily Mean**
**	****	****Monthly Mean**
**	****	****Maximum Values**
**	****	****Minimum Values**
**	****	****Discrepancy Report**

**Notes:**
IMAGES:
     Indexed by station number, year, and month

DATA FILES:
  	6 file types (see slide)

## Data Format - Hourly Values

**File Name - gggg_yyy.HLY**
**e.g. ****5014_955.HLY**
**Line of Data**
**         ****1         2         3**
**123456789012345678901234567890**
** ****1955    1   31   24    581.00**
** ****1955    2    1    1    581.13**

**Notes:**
Use -999.99 for no hourly data value

## Data Format - Daily Mean Values

**File Name - gggg_yyy.DLY**
**e.g. ****5014_955.DLY**
**Line of Data**
**  **
**         ****1         2**
**1234567890123456789012345**
** ****1955    1   31    581.10**
** ****1955    2    1    581.16**

## Data Format - Monthly Mean Values

**File Name - gggg_yyy.MON**
**e.g. ****5014_955.MON**
**Line of Data**
**         ****1         2**
**12345678901234567890**
** ****1955    1    581.20**
** ****1955    2    581.00**

## Data Format - Maximum Values

**File Name - gggg_yyy.MAX**
**e.g. ****5014_955.MAX**
**Line of Data**
**         ****1         2         3**
**123456789012345678901234567890**
** ****1955    1    3  228    581.77**
** ****1955    2   12 1125    581.51**

## Data Format - Minimum Values

**File Name - gggg_yyy.MIN**
**e.g. ****5014_955.MIN**
**Line of Data**
**         ****1         2         3**
**123456789012345678901234567890**
** ****1955    1   21 1340    580.37**
** ****1955    2    5 1310    580.22**

## Data Format - Discrepancy Report

**File Name - gggg_yyy.REP**
**e.g. ****5014_955.REP**
**Line of Data**
**         ****1         2           9**
**12345678901234567890123...4567890**
**1955  11 Descriptive  Text**

**Notes:**
This file is not created by the GLERL programs.  
      Use post it notes in book.

Descriptive text would indicate what type of discrepancy there is 
     day xx the daily means do not agree book value 581.23  calc. Value 581.55
     similar for monthly mean, and max/min

## NOS Responsibilities

**Resolve Discrepancies**
**Adjust Datum**
**Access via WEB**

**Notes:**
RESOLVE:
     resolve the discrepancies found in the QC process
DATUM:
     Apply the appropriate correctors to the keyed data to obtain data on IGLD 1985

WEB:
     Load data into the data base that is accessed by the CO-OPS WEB page for access by public

## Projected Costs

**1 COTR ****	****(80 hrs. @ $44.52)****	****$3,562**
**1 Preparer****	****(80 hrs. @ $29.47)****	****      2,358**
**2 Reviewer****	****(500 hrs. @ $19.25)      ****	****9,625**
**Keying****	****	****400,000**
**   ****Total****	****	****$415,545**

## Slide 20