Science Inventory

NATIONAL NUTRIENTS DATABASE

Description:

Resource Purpose:The Nutrient Criteria Program has initiated development of a National relational database application that will be used to store and analyze nutrient data. The ultimate use of these data will be to derive ecoregion- and waterbody-specific numeric nutrient criteria ranges, EPA is developing an Oracle application which will be populated with STORET Legacy Data, USGS NAWQA, NASQAN and Benchmark data as the primary datasets. Other relevant nutrient data from universities, states/tribes, and additional data rich entities are being added as they are provided to the Nutrient Criteria Program. The database application is being designed to be a compatible, interactive system in an Oracle environment which allows for easy web-accessibility, geo-referencing/GIS capability, and data analysis on both a state/tribal, regional, and national basis. The total amount of existing nutrient data nationally is large (>25 gigabytes), and it is anticipated that more data will be entered into the system. The Oracle application can easily manage large quantities of data and will provide ample room for expansion as more data are collected. The National Nutrients Database application is being designed for compatibility with EPA's latest edition of STORET (STORET-X) to avoid duplication of effort for users of STORET and the Nutrients database application. Considerable efforts are also being made to assure compatibility with other database systems (e.g., WQS and RAD) currently being developed in EPA's Office of Water. The Oracle application will be online in late spring 2000 in a read-only format. The application is expected to be fully operational in phases, with data entry and analyses capabilities operational by the end of summer 2000, and the geographical components fully operational by December 2000.
Legislation/Enabling Authority:Clean Water Action Plan
Supported Program:Nutrient Criteria Program
Data Type:
Primary Data Type:
Monitoring
Geographical Data Stored By:
Latitude - Longitude
Reach File 1
Reach File 3
National Hydrography DataSet
Data Represented By:
Points
Other
Points primarily, line and polygon information may be included at a later date
Measurement Methods:
variable, depends on source ability
System Access Privileges:
Access Methods:
Resource Website
FTP
Direct
Update Methods:
Direct
Resources Accessible By:
Public
States
Regions
DataSubs
All EPA
EPA Branch
EPA Division
EPA Authorized
Resources Updatable By:
States
DataSubs
EPA Authorized
CBI Security:
No
Data Collection:Update cycles will be defined/determined by users. Real time, data will be entered and stored online, validation will be determined/decided by the user.
Range of Data Start:
19900101
Range of Data End:
20000331
Range of Data:
1990 to the present. Once active, users may elect to enter data from earlier dates.

Record Details:

Record Type:PROJECT
Record ID: 23829