Skip to contents

Water quality data from two sites on the Arroyo Colorado

Source: R/data.R
arroyo_wetland.Rd

Includes water quality monitoring data from two sites on the Arroyo Colorado from 1973 through 2022. Multiple parameters are included. Station 13079 is upstream of station 13074. In 2011 a treatment wetland started operation at a wastewater treatment plant between the two stations. This data is typical of data downloaded from the TCEQ SWQMIS database.

Usage

data(arroyo_wetland)

Format

A data frame with 7005 rows and 13 variables:

basin_id

two digit basin identifier

segment_id

TCEQ segment identifier

on_segment

data flag indicating location of station

rfa_tag_id

trip identifer, records with the same value were collected on the same trip and location

station_id

station identifier

end_date

monitoring trip date

end_time

time of collection

end_depth

depth sample was collected at

monitoring_type

monitoring type codes are used to distinguish monitoring purporse. TCEQ DMRG includes a record and description of type codes

parameter_code

distinct parameter codes described below

greater_than_less_than

censored data flag; "<" indicates below the minimum detection limit, ">" indicates above the maximum detection limit

value

measured value

mdl

minimum detection limit reported by the lab

Source

TCEQ SWQMIS database.

Details

Additional details... LIST OF UNIQUE PARAMETERS

  • 00010 TEMPERATURE, WATER (DEGREES CENTIGRADE)

  • 00061 FLOW STREAM, INSTANTANEOUS (CUBIC FEET PER SEC)

  • 00070 TURBIDITY, (JACKSON CANDLE UNITS)

  • 00076 TURBIDITY,HACH TURBIDIMETER (FORMAZIN TURB UNIT)

  • 00094 SPECIFIC CONDUCTANCE,FIELD (US/CM @ 25C)

  • 00300 OXYGEN, DISSOLVED (MG/L)

  • 00400 PH (STANDARD UNITS)

  • 00530 RESIDUE, TOTAL NONFILTRABLE (MG/L)

  • 00600 NITROGEN, TOTAL (MG/L AS N)

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

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

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

  • 00630 NITRITE PLUS NITRATE, TOTAL ONE LAB DETERMINED VALUE (MG/L AS N)

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

  • 00671 ORTHOPHOSPHATE PHOSPHORUS,DISS,MG/L,FLDFILT<15MIN

  • 00680 CARBON, TOTAL ORGANIC, NPOC (TOC), MG/L

  • 01351 FLOW SEVERITY:1=No Flow,2=Low,3=Normal,4=Flood,5=High,6=Dry

  • 31616 FECAL COLIFORM,MEMBR FILTER,M-FC BROTH, #/100ML

  • 31648 E. COLI, MTEC, MF, #/100 ML

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

  • 70507 ORTHOPHOSPHATE PHOSPHORUS,DISS,MG/L,FILTER >15MIN

  • 72053 DAYS SINCE PRECIPITATION EVENT (DAYS)

  • 74069 STREAM FLOW ESTIMATE (CFS)

  • 82078 TURBIDITY,FIELD NEPHELOMETRIC TURBIDITY UNITS, N

  • 82903 DEPTH OF BOTTOM OF WATER BODY AT SAMPLE SITE

  • 89835 FLOW MTH 1=GAGE 2=ELEC 3=MECH 4=WEIR/FLU 5=DOPPLER