Document ID: EPA-HQ-OW-2008-0465-2056
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2009-12-15T05:00Z

Metadata

Data Filename:	Wall040609.txt

Data Source: Raw data originated from the Surface Water Quality
Monitoring (SWQM) Program and the Clean Rivers Program (CRP) of the
Texas Commission on Environmental Quality (TCEQ), Austin, TX and the
Houston-Galveston Area Council (H-GAC), Houston, TX.

Data Manager: 	Raw data were acquired and managed by the Galveston Bay
Status and Trends Project of the Galveston Bay Estuary Program, Houston,
TX and the Houston Advanced Research Center, The Woodlands, TX.

Data Manager Contact: 	Lisa Gonzalez, HARC, Phone (281) 364-6044, email:
  HYPERLINK "mailto:lgonzalez@harc.edu"  lgonzalez@harc.edu   

Date Published:	6 Apr 2009

Data Period:	6 Jan 1999 – 19 Dec 2007

Number of Records:	110,729

Database Field Descriptions:

COUNTY	County location of the sampling station 

STATION_ID	TCEQ assigned number identifying the sampling station. 

GROUP_NAME	HARC assigned name of waterbody (e.g. Houston Ship Channel)

LATITUDE	The latitude of the sampling station 

LONGITUDE	The longitude of the sampling station

Tag_ID	Analogous to a sample ID number. This field is the key between
TCEQ's event and results tables and is 7 characters long. The first
character(s) is the  prefix code for the submitting agency.

Enddate	The date the sample was collected in the form of MM/DD/YYYY

Year	Year sample was taken

Month	Month sample was taken

Day	Day sample was taken

Endtime	The time the sample was collected in military format (HH:MM)

Enddepth	Depth in meters at which the sample was collected.

Storet Code	Five digit code which identifies the substance or
measurement; EPA/TCEQ parameter code.

Parameter Description	TCEQ assigned field describing the storet code /
parameter; describes parameter and units

GTLT	If the value is above the detection limit then this field should
contain an “>” or may be blank.  If the value is below the detection
limit then this field will contain an “<”.

Value	This is the test result and should be reported in units according
to the storet description

Media	Media type: Water, Sediment, tissue, etc.

Outlier Minimum	TCEQ assigned field describing minimum outlier value for
this storet code

Outlier Maximum	TCEQ assigned field describing maximum outlier value for
this storet code

Parameter Descriptions

StoretCode	Description							

00010		TEMPERATURE, WATER (DEGREES CENTIGRADE)

00300		OXYGEN, DISSOLVED (MG/L)

00400		PH (STANDARD UNITS)

00480		SALINITY - PARTS PER THOUSAND

00530		RESIDUE, TOTAL NONFILTRABLE (MG/L)

00610		NITROGEN, AMMONIA, TOTAL (MG/L AS N)

00615		NITRITE NITROGEN, TOTAL (MG/L AS N)

00620		NITRATE NITROGEN, TOTAL (MG/L AS N)

00625		NITROGEN, KJELDAHL, TOTAL (MG/L AS N)

00665		PHOSPHORUS, TOTAL, WET METHOD (MG/L AS P)

31613		FECAL COLIFORM, MF AGAR (COLONIES/100 ML)

31616		FECAL COLIFORM,MEMBR FILTER,M-FC BROTH, #/100ML (COMBINE w/
31613)

31649		ENTEROCOCCI, ME, MF, #/100ML

31699		E. COLI, COLILERT, IDEXX METHOD, MPN/100ML

32211		CHLOROPHYLL-A UG/L SPECTROPHOTOMETRIC ACID. METH

32218		PHEOPHYTIN-A UG/L SPECTROPHOTOMETRIC ACID. METH. (COMBINE w/
32211)