You are here:
EPA Home » Science Inventory » NEUSE RIVER WATER QUALITY DATABASE
NEUSE RIVER WATER QUALITY DATABASE
Contact
http://cfpub.epa.gov/si/si_public_comments.cfm
Citation:
Description:
The Neuse River water quality database is a Microsoft Access application that includes multiple data tables and some associated queries. The database was developed by Prof. Jim Bowen's research group.
Record Details:
Record Type:DATABASE
Product Published Date:12/28/1999
Record Last Revised:12/10/2002
Record ID:
16279
Access Procedures
:http://www.epa.gov/eims/files/ord-nerl/neuse_wq_database.zip
Data Type :NUMBER
Data Element Description :ID of record, in each data table but cannot be used as link
Max Value Length :6
Data Element :TOTAL CHL A
Data Type :NUMBER
Data Element Description :[ug/l] (midriver_wq_algae)
Max Value Length :14
Data Element :DINOFLAGELLATES
Data Type :NUMBER
Data Element Description :(midriver_wq_algae)
Max Value Length :14
Data Element :DIATOMS
Data Type :NUMBER
Data Element Description :(midriver_wq_algae)
Max Value Length :14
Data Element :CYANOBACTERIA
Data Type :NUMBER
Data Element Description :(midriver_wq_algae)
Max Value Length :14
Data Element :CRYPTOPHYTES
Data Type :NUMBER
Data Element Description :(midriver_wq_algae)
Max Value Length :12
Data Element :CHLOROPHYTES
Data Type :NUMBER
Data Element Description :(midriver_wq_algae)
Max Value Length :13
Data Element :DEPTH
Data Type :CHARACTER
Data Element Description :(midriver_wq_algae)
Max Value Length :255
Data Element :COLOR
Data Type :NUMBER
Data Element Description :[APHA], (midriver_wq)
Max Value Length :3
Data Element :CHL-C
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :4
Data Element :CHL-B
Data Type :NUMBER
Data Element Description :[ug/l] (midriver_wq)
Max Value Length :4
Data Element :TP
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :3
Data Element :TKN
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :12
Data Element :HALF METER BIN
Data Type :NUMBER
Data Element Description :[m], (midriver_wq)
Max Value Length :3
Data Element :TSS
Data Type :NUMBER
Data Element Description :[mg/l], (midriver_wq)
Max Value Length :5
Data Element :CHL-A
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :4
Data Element :PO4-P
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :5
Data Element :NH4-N
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :5
Data Element :NOX-N
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :5
Data Element :POC:PON
Data Type :NUMBER
Data Element Description :[mol/mol], (midriver_wq)
Max Value Length :5
Data Element :PON
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :6
Data Element :POC
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :7
Data Element :KD
Data Type :NUMBER
Data Element Description :[1/m], (midriver_wq)
Max Value Length :4
Data Element :LIGHT
Data Type :NUMBER
Data Element Description :[uE/m2/s], (midriver_wq)
Max Value Length :4
Data Element :DO (MG/L)
Data Type :NUMBER
Data Element Description :(midriver_wq)
Max Value Length :6
Data Element :DO (%SAT)
Data Type :NUMBER
Data Element Description :(midriver_wq)
Max Value Length :6
Data Element :SALIN
Data Type :NUMBER
Data Element Description :[Pt], (midriver_wq)
Max Value Length :6
Data Element :SPCOND
Data Type :NUMBER
Data Element Description :[mS/cm], (midriver_wq)
Max Value Length :5
Data Element :PH
Data Type :NUMBER
Data Element Description :pH (midriver_wq)
Max Value Length :4
Data Element :TEMP (C)
Data Type :NUMBER
Data Element Description :(midriver_wq)
Max Value Length :6
Data Element :DEPTH (M)
Data Type :NUMBER
Data Element Description :(midriver_wq)
Max Value Length :5
Data Element :STATION
Data Type :CHARACTER
Data Element Description :(midriver_wq)
Max Value Length :255
Data Element :TIME
Data Type :CHARACTER
Data Element Description :(midriver_wq), time stored as a character string
Max Value Length :11
Data Element :DATE
Data Type :DATE
Data Element Description :(midriver_wq), date only
Max Value Length :8
Data Element :DATA SOURCE
Data Type :CHARACTER
Data Element Description :(midriver_wq)
Max Value Length :255
Data Element :STATION_NUMBER
Data Type :NUMBER
Data Element Description :(midriver_location_descriptions)
Max Value Length :3
Data Element :STATION GROUP
Data Type :CHARACTER
Data Element Description :(midriver_location_descriptions)
Max Value Length :50
Data Element :STATION DESCRIPTION
Data Type :CHARACTER
Data Element Description :(midriver_location_descriptions)
Max Value Length :255
Data Element :STATION_TEXT
Data Type :CHARACTER
Data Element Description :(midriver_location_descriptions)
Max Value Length :50
Data Element :DNSTRM DIST FROM SF
Data Type :NUMBER
Data Element Description :(DWQ_WQ_stations_info), [km], long int
Max Value Length :10
Data Element :LOCATION_TYPE
Data Type :CHARACTER
Data Element Description :(DWQ_WQ_stations_info)
Max Value Length :50
Data Element :LOCATION
Data Type :CHARACTER
Data Element Description :(DWQ_WQ_stations_info)
Max Value Length :50
Data Element :STORET_ID)
Data Type :CHARACTER
Data Element Description :(DWQ_WQ_stations_info)
Max Value Length :50
Data Element :REMARK
Data Type :CHARACTER
Data Element Description :(DWQ_WQ)
Max Value Length :255
Data Element :RESULT
Data Type :NUMBER
Data Element Description :(DWQ_WQ)
Max Value Length :8
Data Element :DEPTH
Data Type :NUMBER
Data Element Description :(DWQ_WQ)
Max Value Length :8
Data Element :DATE (DWQ_WQ)
Data Type :DATE
Data Element Description :date with time
Max Value Length :20
Data Element :DESCRIPTION
Data Type :CHARACTER
Data Element Description :description (DWQ_WQ)
Max Value Length :255
Data Element :PARAMETER
Data Type :NUMBER
Data Element Description :(DWQ_WQ), see DWQ Parameters Table for list of parameters and their descriptions
Max Value Length :5
Data Element :LOCATION
Data Type :CHARACTER
Data Element Description :location (DWQ_WQ)
Max Value Length :255
Data Element :STATION
Data Type :CHARACTER
Data Element Description :description of station (DWQ_WQ, midriver_locations)
Max Value Length :255
Version :1.0
State :NC
Data Elements:
Data Element :IDData Type :NUMBER
Data Element Description :ID of record, in each data table but cannot be used as link
Max Value Length :6
Data Element :TOTAL CHL A
Data Type :NUMBER
Data Element Description :[ug/l] (midriver_wq_algae)
Max Value Length :14
Data Element :DINOFLAGELLATES
Data Type :NUMBER
Data Element Description :(midriver_wq_algae)
Max Value Length :14
Data Element :DIATOMS
Data Type :NUMBER
Data Element Description :(midriver_wq_algae)
Max Value Length :14
Data Element :CYANOBACTERIA
Data Type :NUMBER
Data Element Description :(midriver_wq_algae)
Max Value Length :14
Data Element :CRYPTOPHYTES
Data Type :NUMBER
Data Element Description :(midriver_wq_algae)
Max Value Length :12
Data Element :CHLOROPHYTES
Data Type :NUMBER
Data Element Description :(midriver_wq_algae)
Max Value Length :13
Data Element :DEPTH
Data Type :CHARACTER
Data Element Description :(midriver_wq_algae)
Max Value Length :255
Data Element :COLOR
Data Type :NUMBER
Data Element Description :[APHA], (midriver_wq)
Max Value Length :3
Data Element :CHL-C
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :4
Data Element :CHL-B
Data Type :NUMBER
Data Element Description :[ug/l] (midriver_wq)
Max Value Length :4
Data Element :TP
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :3
Data Element :TKN
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :12
Data Element :HALF METER BIN
Data Type :NUMBER
Data Element Description :[m], (midriver_wq)
Max Value Length :3
Data Element :TSS
Data Type :NUMBER
Data Element Description :[mg/l], (midriver_wq)
Max Value Length :5
Data Element :CHL-A
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :4
Data Element :PO4-P
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :5
Data Element :NH4-N
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :5
Data Element :NOX-N
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :5
Data Element :POC:PON
Data Type :NUMBER
Data Element Description :[mol/mol], (midriver_wq)
Max Value Length :5
Data Element :PON
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :6
Data Element :POC
Data Type :NUMBER
Data Element Description :[ug/l], (midriver_wq)
Max Value Length :7
Data Element :KD
Data Type :NUMBER
Data Element Description :[1/m], (midriver_wq)
Max Value Length :4
Data Element :LIGHT
Data Type :NUMBER
Data Element Description :[uE/m2/s], (midriver_wq)
Max Value Length :4
Data Element :DO (MG/L)
Data Type :NUMBER
Data Element Description :(midriver_wq)
Max Value Length :6
Data Element :DO (%SAT)
Data Type :NUMBER
Data Element Description :(midriver_wq)
Max Value Length :6
Data Element :SALIN
Data Type :NUMBER
Data Element Description :[Pt], (midriver_wq)
Max Value Length :6
Data Element :SPCOND
Data Type :NUMBER
Data Element Description :[mS/cm], (midriver_wq)
Max Value Length :5
Data Element :PH
Data Type :NUMBER
Data Element Description :pH (midriver_wq)
Max Value Length :4
Data Element :TEMP (C)
Data Type :NUMBER
Data Element Description :(midriver_wq)
Max Value Length :6
Data Element :DEPTH (M)
Data Type :NUMBER
Data Element Description :(midriver_wq)
Max Value Length :5
Data Element :STATION
Data Type :CHARACTER
Data Element Description :(midriver_wq)
Max Value Length :255
Data Element :TIME
Data Type :CHARACTER
Data Element Description :(midriver_wq), time stored as a character string
Max Value Length :11
Data Element :DATE
Data Type :DATE
Data Element Description :(midriver_wq), date only
Max Value Length :8
Data Element :DATA SOURCE
Data Type :CHARACTER
Data Element Description :(midriver_wq)
Max Value Length :255
Data Element :STATION_NUMBER
Data Type :NUMBER
Data Element Description :(midriver_location_descriptions)
Max Value Length :3
Data Element :STATION GROUP
Data Type :CHARACTER
Data Element Description :(midriver_location_descriptions)
Max Value Length :50
Data Element :STATION DESCRIPTION
Data Type :CHARACTER
Data Element Description :(midriver_location_descriptions)
Max Value Length :255
Data Element :STATION_TEXT
Data Type :CHARACTER
Data Element Description :(midriver_location_descriptions)
Max Value Length :50
Data Element :DNSTRM DIST FROM SF
Data Type :NUMBER
Data Element Description :(DWQ_WQ_stations_info), [km], long int
Max Value Length :10
Data Element :LOCATION_TYPE
Data Type :CHARACTER
Data Element Description :(DWQ_WQ_stations_info)
Max Value Length :50
Data Element :LOCATION
Data Type :CHARACTER
Data Element Description :(DWQ_WQ_stations_info)
Max Value Length :50
Data Element :STORET_ID)
Data Type :CHARACTER
Data Element Description :(DWQ_WQ_stations_info)
Max Value Length :50
Data Element :REMARK
Data Type :CHARACTER
Data Element Description :(DWQ_WQ)
Max Value Length :255
Data Element :RESULT
Data Type :NUMBER
Data Element Description :(DWQ_WQ)
Max Value Length :8
Data Element :DEPTH
Data Type :NUMBER
Data Element Description :(DWQ_WQ)
Max Value Length :8
Data Element :DATE (DWQ_WQ)
Data Type :DATE
Data Element Description :date with time
Max Value Length :20
Data Element :DESCRIPTION
Data Type :CHARACTER
Data Element Description :description (DWQ_WQ)
Max Value Length :255
Data Element :PARAMETER
Data Type :NUMBER
Data Element Description :(DWQ_WQ), see DWQ Parameters Table for list of parameters and their descriptions
Max Value Length :5
Data Element :LOCATION
Data Type :CHARACTER
Data Element Description :location (DWQ_WQ)
Max Value Length :255
Data Element :STATION
Data Type :CHARACTER
Data Element Description :description of station (DWQ_WQ, midriver_locations)
Max Value Length :255
Geographic Areas:
Title :NEUSE RIVER WATER QUALITY DATABASEVersion :1.0
State :NC