Citation:

Impact/Purpose:

The database was developed under the following guidelines:

-Develop a system having cross-program and -project utility

-Document the quality of all data populating the system

-Ensure that the resulting data base has long-term value

-Avoid duplicating effort with other data systems

Description:

The Great Lakes Environmental Database System(GLENDA) was developed to provide data entry, storage, access and analysis capabilities to meet the needs of mass balance modelers and other potential users of Great Lakes data. Development of GLENDA began in 1993 with a logical model based on the modernized STORET concept and requirements analysis. This was followed in 1994-1995 with the development of field and laboratory reporting requirements, preliminary reference tables, and the initial creation of the physical tables. Recent years have seen the completion of the physical database and most reference tables, the creation of software tools to access the database, and the creation and use of upload routines to load Lake Michigan Mass Balance data. Most recently, GLENDA was revised to allow batch upload of base monitoring program (nutrients) data.

URLs/Downloads:

LMMB data request page

LMMB ON-LINE DATA REQUEST FORM

GREAT LAKES ENVIRONMENTAL DATABASE HOME PAGE

Record Details:

Record Type:DATABASE

Product Published Date:04/12/2000

Record Last Revised:07/08/2003

Record ID: 13039

Show Additional Record Data

Access Procedures :To request data from the Lake Michigan Mass Balance Project, see the data release/download page (http://www.epa.gov/glnpo/lmmb/drp.html) and complete the online Data Request form (http://www.epa.gov/glnpo/lmmb/drform.html)and e-mail it to Ken Klewin, the Data Manager.

Quality Assurance:

Title :GREAT LAKES ENVIRONMENTAL DATABASE SYSTEM (GLENDA)

Data Use & Constraints :The Great Lakes Environmental Monitoring Database is based on the user requirements and logical design from USEPA's STORET Modernization project. The close association with STORET has limited the duplication of effort common to database development projects, and ensures maximum portability to the future central home of most environmental data.