4 · TCEQ Surface Water Quality — Monitoring Stations & Results

Reads the watershed boundaries from notebook 1, discovers Texas Commission on Environmental Quality (TCEQ) Surface Water Quality Monitoring (SWQM) stations inside them, and fetches their results. TCEQ has no public API of its own — SWQMIS data is submitted to the U.S. Environmental Protection Agency (EPA) Water Quality Portal (WQP) under organization TCEQMAIN, which we query via the same dataretrieval package used for USGS (dataretrieval.wqp). Primary source: https://www.tceq.texas.gov/waterquality/monitoring. API docs: https://www.waterqualitydata.us/.

Step 1 — Imports and setup

Show code
import geopandas as gpd
import hvplot.pandas  # noqa: F401  (registers .hvplot on DataFrames — used by the trend chart)
import pandas as pd
from dataretrieval import wqp

import geoviews as gv
import geoviews.tile_sources as gvts

from _helpers import (
    init_session,
    save_dataframe,
    load_dataframe,
    save_workbook,
    show,
    categorical_colors,
    make_legend_clickable,
    PRIORITY_NAMES,
    classify_parameter,
    fetch_wqp_results,
    tidy_wqp_results,
    coverage,
    trend_by_group,
)

gv.extension("bokeh")
S = init_session()
USGS API key loaded.

Step 2 — Discover monitoring stations

wqp.what_sites returns a plain DataFrame (unlike dataretrieval.waterdata, WQP has no built-in geometry column) — we build one from its lat/long columns, then keep only stations within the watershed polygons, exactly as notebook 3 does for USGS stations.

Caching note: dataretrieval.wqp makes its own HTTP requests, bypassing the on-disk request cache (cache/) HyRiver calls use — so instead we treat the saved tceq_monitoring_locations.parquet itself as a backup cache (load_dataframe, one-week freshness window): if it’s still fresh, we load it and skip the network call entirely.

Show code
boundaries_path = S.data_dir / "hydrography" / "huc8_watersheds.parquet"
if not boundaries_path.exists():
    raise FileNotFoundError(
        f"{boundaries_path} not found — run notebook 1 (1_usgs_hydrography) first."
    )
watersheds_gdf = gpd.read_parquet(boundaries_path)
bbox = list(watersheds_gdf.total_bounds)  # [min_lon, min_lat, max_lon, max_lat]; reused below

stations_path = S.data_dir / "tceq_waterquality" / "tceq_monitoring_locations.parquet"
stations_in_area = load_dataframe(stations_path, max_age_days=7)
stations_were_cached = stations_in_area is not None
if not stations_were_cached:
    sites_df, _ = wqp.what_sites(organization="TCEQMAIN", bBox=",".join(str(v) for v in bbox))
    stations_gdf = gpd.GeoDataFrame(
        sites_df,
        geometry=gpd.points_from_xy(sites_df["LongitudeMeasure"], sites_df["LatitudeMeasure"]),
        crs=4326,
    )
    stations_in_area = gpd.sjoin(
        stations_gdf,
        watersheds_gdf[["huc8", "name", "geometry"]],
        predicate="within",
        how="inner",
    )
    print(
        f"{len(stations_gdf)} TCEQ stations in the bounding box; "
        f"{len(stations_in_area)} within the watersheds."
    )
show(stations_in_area[["MonitoringLocationIdentifier", "MonitoringLocationName", "name"]])
using cached data/tceq_waterquality/tceq_monitoring_locations.parquet (380 rows, < 7 days old)
MonitoringLocationIdentifier MonitoringLocationName name
0 TCEQMAIN-10249 RIO GRANDE RIVER 285 METERS SOUTH 30 METERS WEST FROM THE INTERSECTION OF FM ROAD 813/CANTU ROAD AND AVILIA ROAD Lower Rio Grande
1 TCEQMAIN-13036 NORTH FLOODWAY AT FM 1420 South Laguna Madre
2 TCEQMAIN-13037 NORTH FLOODWAY AT SH 107 South Laguna Madre
3 TCEQMAIN-13038 UNNAMED DITCH AT KM 42.7 South Laguna Madre
4 TCEQMAIN-13039 UNMD DRAIN DTCH SW RANGRVL RD South Laguna Madre
5 TCEQMAIN-13040 UNMD DRAIN DTCH SE FM800 South Laguna Madre
6 TCEQMAIN-13041 UNMD DRAIN DTCH S ARROYO COLO South Laguna Madre
7 TCEQMAIN-13042 LA FERIA DITCH N OF ARROYO COL South Laguna Madre
8 TCEQMAIN-13043 UNMD DRAIN DTCH SE FM 2556 South Laguna Madre
9 TCEQMAIN-13044 UNMD DRAIN DTCH NW FM 2556 South Laguna Madre
10 TCEQMAIN-13045 UNMD DRAIN DTCH SE FM 491 South Laguna Madre
11 TCEQMAIN-13046 ARROYO ANACUITAS South Laguna Madre
12 TCEQMAIN-13047 UNMD DRAIN DTCH ARROYO COLORAD South Laguna Madre
13 TCEQMAIN-13048 UNMD DRAIN DTCH ARROYO COLORAD South Laguna Madre
14 TCEQMAIN-13049 UNMD DRAIN DTCH LLANO GR LAKE South Laguna Madre
15 TCEQMAIN-13050 UNMD DITCH E OF FM 88 South Laguna Madre
16 TCEQMAIN-13051 UNMD DITCH E OF FM 88 South Laguna Madre
17 TCEQMAIN-13052 UNMD DRAIN DTCH S OF LLANO GRN South Laguna Madre
18 TCEQMAIN-13053 UNMD DRAIN DTCH ARROYO COLORAD South Laguna Madre
19 TCEQMAIN-13054 UNMD DITCH END OF MIDWAY RD South Laguna Madre
20 TCEQMAIN-13055 DONNA DITCH N ARROYO COLORADO South Laguna Madre
21 TCEQMAIN-13056 UNMD DITCH S ARROYO COLORADO South Laguna Madre
22 TCEQMAIN-13057 LAGUNA MADRE N PK RD 100 South Laguna Madre
23 TCEQMAIN-13058 UNMD DITCH S OF ARROYO COLORAD South Laguna Madre
24 TCEQMAIN-13059 ALAMO DITCH N ARROYO COLORADO South Laguna Madre
25 TCEQMAIN-13060 UNNAMED DITCH AT BORDER RD. South Laguna Madre
26 TCEQMAIN-13061 PHARR-SAN JUAN DITCH South Laguna Madre
27 TCEQMAIN-13062 UNMD DRAIN PIPE W US281 South Laguna Madre
28 TCEQMAIN-13063 AIRPORT DTCH N ARROYO COLORADO South Laguna Madre
29 TCEQMAIN-13064 UNMD DITCH S OF ARROYO COLORAD South Laguna Madre
30 TCEQMAIN-13065 MCALLEN GOLF COURSE DRAIN South Laguna Madre
31 TCEQMAIN-13066 UNMD DITCH S OF ARROYO COLORAD South Laguna Madre
32 TCEQMAIN-13067 MISSION DITCH N ARROYO COLORAD South Laguna Madre
33 TCEQMAIN-13068 CAYO ATASCOSO NR CONFL ARROYO South Laguna Madre
34 TCEQMAIN-13069 CAYO ATASCOSO AT FM 106 South Laguna Madre
35 TCEQMAIN-13070 ARROYO COLORADO TDL 5KM GIWW South Laguna Madre
36 TCEQMAIN-13071 ARROYO COLORADO AT CM 22 South Laguna Madre
37 TCEQMAIN-13072 ARROYO COLORADO AT FM 106 CAMS 0730 South Laguna Madre
38 TCEQMAIN-13073 ARROYO COLO AT CAMP PERRY South Laguna Madre
39 TCEQMAIN-13074 ARROYO COLORADO /PT.HARLINGEN South Laguna Madre
40 TCEQMAIN-13075 ARROYO COLORADO AT COUNTY RD South Laguna Madre
41 TCEQMAIN-13076 ARROYO COLORADO AT FM 801 South Laguna Madre
42 TCEQMAIN-13077 ARROYO COLORADO AT LOOP 499 South Laguna Madre
43 TCEQMAIN-13078 ARROYO COLORADO AT COMMERCE ST South Laguna Madre
44 TCEQMAIN-13079 ARROYO COLORADO AT US 77 South Laguna Madre
45 TCEQMAIN-13080 ARROYO COLORADO AT FM 506 South Laguna Madre
46 TCEQMAIN-13081 ARROYO COLORADO MAIN FLOODWAY South Laguna Madre
47 TCEQMAIN-13082 ARROYO COLORADO AT FM 493 South Laguna Madre
48 TCEQMAIN-13083 ARROYO COLORADO AT FM 907 South Laguna Madre
49 TCEQMAIN-13084 ARROYO COLORADO AT US 281 South Laguna Madre
50 TCEQMAIN-13085 ARROYO COLORADO AT FM 2061 South Laguna Madre
51 TCEQMAIN-13086 ARROYO COLORADO AT FM 336 South Laguna Madre
52 TCEQMAIN-13087 ARROYO COLORADO AT FM 115 South Laguna Madre
53 TCEQMAIN-13088 ARROYO COLORADO AT FM 494 South Laguna Madre
54 TCEQMAIN-13089 ARROYO COLORADO AT FM 1016 South Laguna Madre
55 TCEQMAIN-13103 LOS OLMOS CREEK AT US 83 Los Olmos
56 TCEQMAIN-13104 LOS OLMOS CREEK AT SH 755 Los Olmos
57 TCEQMAIN-13176 RIO GRANDE RIVER TIDAL AT THE END OF QUICKSILVER AVE Lower Rio Grande
58 TCEQMAIN-13177 RIO GRANDE AT EL JARDIN PUMP Lower Rio Grande
59 TCEQMAIN-13178 RIO GRANDE AT US 77 Lower Rio Grande
60 TCEQMAIN-13179 RIO GRANDE AT RIVER BEND GOLF COURSE BOAT RAMP Lower Rio Grande
61 TCEQMAIN-13180 RIO GRANDE S OF LAS MILPAS Lower Rio Grande
62 TCEQMAIN-13181 RIO GRANDE RIVER AT US 281/INTERNATIONAL BLVD Lower Rio Grande
63 TCEQMAIN-13182 RIO GRANDE EAST BANK AT ANZALDUAS DAM CAMS 0736 Lower Rio Grande
64 TCEQMAIN-13183 RIO GRANDE AT PENITAS Lower Rio Grande
65 TCEQMAIN-13184 RIO GRANDE AT FM 886 Los Olmos
66 TCEQMAIN-13185 RIO GRANDE AT FT RINGOLD Los Olmos
67 TCEQMAIN-13186 RIO GRANDE BELOW RIO ALAMO Los Olmos
68 TCEQMAIN-13187 RIO GRANDE BELOW FALCON DAM Los Olmos
69 TCEQMAIN-13188 RIO GRANDE S TAILRACE Los Olmos
74 TCEQMAIN-13277 PORT MANSFIELD AT HARBOR 1 South Laguna Madre
75 TCEQMAIN-13278 PORT MANSFIELD NW DOCK South Laguna Madre
76 TCEQMAIN-13279 PORT MANSFIELD BOAT LAUNCH South Laguna Madre
77 TCEQMAIN-13280 PORT MANSFIELD SE MARINA South Laguna Madre
78 TCEQMAIN-13281 PORT MANSFIELD AT CM 25 South Laguna Madre
79 TCEQMAIN-13282 PORT ISABEL NR CM 4 South Laguna Madre
80 TCEQMAIN-13283 PORT ISABEL NR CM 142 South Laguna Madre
81 TCEQMAIN-13284 PORT ISABEL AT EAST ENTRANCE South Laguna Madre
82 TCEQMAIN-13285 PORT ISABEL AT SH 100 South Laguna Madre
83 TCEQMAIN-13286 PORT ISABEL NR NORTH ENTRANCE South Laguna Madre
84 TCEQMAIN-13446 LAGUNA MADRE GIWW CM 129 South Laguna Madre
85 TCEQMAIN-13447 LAGUNA MADRE GIWW AND ARROYO South Laguna Madre
88 TCEQMAIN-13459 SOUTH BAY NEAR CLARK ISLAND South Laguna Madre
89 TCEQMAIN-13460 BROWNSVILLE SHIP CHANNEL CM 35 South Laguna Madre
91 TCEQMAIN-13470 GULF OF MEXICO AT PT ISABEL South Laguna Madre
92 TCEQMAIN-13557 ARROYO COLORADO AT THOMAE PARK South Laguna Madre
93 TCEQMAIN-13558 ARROYO COLORADO TIDAL, MKR 18 South Laguna Madre
94 TCEQMAIN-13559 ARROYO COLORADO AT CM27, MI 15 South Laguna Madre
95 TCEQMAIN-13663 RIO ALAMO NR CIUDAD MIER MEX Los Olmos
96 TCEQMAIN-13664 RIO GRANDE BELOW ANZALDUAS Lower Rio Grande
99 TCEQMAIN-13719 PUERTECITOS DRAIN DIAZ ORDAZ Los Olmos
100 TCEQMAIN-13720 ANHELO DRAIN NEAR REYNOSA MEX Lower Rio Grande
101 TCEQMAIN-13782 ARROYO COLORADO CM 16 South Laguna Madre
103 TCEQMAIN-14094 WEIR AT 51+80 BELOW FALCON DAM Los Olmos
104 TCEQMAIN-14095 WEIR AT 73+75 BELOW FALCON DAM Los Olmos
105 TCEQMAIN-14096 WEIR U.S GALLERY FALCON DAM Los Olmos
106 TCEQMAIN-14461 DRAINAGE DITCH AT MIDLANE DR South Laguna Madre
107 TCEQMAIN-14490 DRAINAGE DITCH AT CLEVELAND AV South Laguna Madre
110 TCEQMAIN-14843 LAGUNA MADRE PT MANSFIELD 40 South Laguna Madre
111 TCEQMAIN-14844 LAGUNA MADRE ICWW 49 South Laguna Madre
112 TCEQMAIN-14845 LAGUNA MADRE ICWW 109 South Laguna Madre
113 TCEQMAIN-14849 ARROYO COLORADO TIDAL AT CAYO South Laguna Madre
114 TCEQMAIN-14850 ARROYO COLORADO TIDAL South Laguna Madre
115 TCEQMAIN-14851 ARROYO COLORADO TIDAL AT CM 36 South Laguna Madre
116 TCEQMAIN-14852 ARROYO COLORADO MARKER 54 South Laguna Madre
117 TCEQMAIN-14853 ARROYO COLORADO MARKER 73 South Laguna Madre
118 TCEQMAIN-14855 SOUTH BAY NEAR BRAZOS ISLAND South Laguna Madre
119 TCEQMAIN-14856 SOUTH BAY South Laguna Madre
120 TCEQMAIN-14857 SOUTH BAY South Laguna Madre
121 TCEQMAIN-14858 SOUTH BAY South Laguna Madre
122 TCEQMAIN-14861 LAGUNA MADRE South Laguna Madre
123 TCEQMAIN-14862 LAGUNA MADRE South Laguna Madre
124 TCEQMAIN-14863 PORT ISABEL SIDE CHANNEL South Laguna Madre
125 TCEQMAIN-14865 SOUTH BAY South Laguna Madre
126 TCEQMAIN-14868 LAGUNA MADRE South Laguna Madre
127 TCEQMAIN-14869 LAGUNA MADRE South Laguna Madre
128 TCEQMAIN-14870 LAGUNA MADRE NEAR LAGUNA VISTA South Laguna Madre
129 TCEQMAIN-14871 BROWNSVILLE SHIP CHANNEL South Laguna Madre
130 TCEQMAIN-14872 BROWNSVILLE SHIP CHANNEL South Laguna Madre
131 TCEQMAIN-14873 BROWNSVILLE SHIP CHANNEL South Laguna Madre
132 TCEQMAIN-14874 BROWNSVILLE SHIP CHANNEL South Laguna Madre
133 TCEQMAIN-14875 BROWNSVILLE SHIP CHANNEL South Laguna Madre
134 TCEQMAIN-14876 LAGUNA MADRE NEAR CAUSEWAY South Laguna Madre
135 TCEQMAIN-14877 LAGUNA MADRE NEAR RANGE MARKER South Laguna Madre
136 TCEQMAIN-14878 LAGUNA MADRE South Laguna Madre
137 TCEQMAIN-14879 LAGUNA MADRE South Laguna Madre
138 TCEQMAIN-14880 SOUTH BAY South Laguna Madre
139 TCEQMAIN-15205 LA CRUZ RESACA AT FM 2557 South Laguna Madre
140 TCEQMAIN-15206 DRAINAGE DITCH AT JEFFERSON ST South Laguna Madre
141 TCEQMAIN-15207 DRAINAGE DITCH AT GLASSCOCK South Laguna Madre
142 TCEQMAIN-15208 RESACA DE LOS FRESNOS South Laguna Madre
143 TCEQMAIN-15530 RESACA DE LA GUERRA AT VILLAGE South Laguna Madre
144 TCEQMAIN-15531 RESACA DE LA GUERRA AT US 83 South Laguna Madre
145 TCEQMAIN-15532 RESACA DEL RANCHO VIEJO AT DAN South Laguna Madre
146 TCEQMAIN-15533 RESACA DEL RANCHO VIEJO South Laguna Madre
147 TCEQMAIN-15534 TOWN RESACA AT CITY CEMETARY South Laguna Madre
148 TCEQMAIN-15538 TOWN RESACA AT CORIA ST. South Laguna Madre
149 TCEQMAIN-15539 RESACA DE LA GUERRA AT QUAIL South Laguna Madre
150 TCEQMAIN-15540 TOWN RESACA AT STOVALL RD. South Laguna Madre
151 TCEQMAIN-15541 TOWN RESACA AT PORTER PARK South Laguna Madre
152 TCEQMAIN-15542 TOWN RESACA AT PORTER ZOO South Laguna Madre
153 TCEQMAIN-15543 RESACA DE LA PALMA AT HIDDEN South Laguna Madre
154 TCEQMAIN-15544 IRRIGATION CANAL AT CAGE BLVD. South Laguna Madre
155 TCEQMAIN-15547 ARROYO COLORADO 2.1KM GIWW South Laguna Madre
156 TCEQMAIN-15548 ARROYO COLORADO 3.8KM GIWW South Laguna Madre
157 TCEQMAIN-15549 ARROYO COLORADO 4.2KM GIWW South Laguna Madre
158 TCEQMAIN-15550 ARROYO COLORADO 8.0KM GIWW South Laguna Madre
159 TCEQMAIN-15551 ARROYO COLORADO 8.1KM GIWW South Laguna Madre
160 TCEQMAIN-15552 ARROYO COLORADO 8.6 KM GIWW South Laguna Madre
161 TCEQMAIN-15553 ARROYO COLORADO UPSTM CM18 South Laguna Madre
162 TCEQMAIN-15554 ARROYO COLORADO AT CM 16 South Laguna Madre
163 TCEQMAIN-15555 ARROYO COLORADO 11.2KM GIWW South Laguna Madre
164 TCEQMAIN-15556 ARROYO COLORADO 11.4KM GIWW South Laguna Madre
165 TCEQMAIN-15557 ARROYO COLORADO 13.1KM GIWW South Laguna Madre
166 TCEQMAIN-15558 ARROYO COLORADO 13.8KM GIWW South Laguna Madre
167 TCEQMAIN-15559 ARROYO COLORADO 15.6KM GIWW South Laguna Madre
168 TCEQMAIN-15560 ARROYO COLORADO 16.1KM GIWW South Laguna Madre
169 TCEQMAIN-15561 ARROYO COLORADO 17.0 KM GIWW South Laguna Madre
170 TCEQMAIN-15562 ARROYO COLORADO 21.1KM GIWW South Laguna Madre
171 TCEQMAIN-15563 ARROYO COLORADO 22.9KM GIWW South Laguna Madre
172 TCEQMAIN-15564 ARROYO COLORADO 24.5KM GIWW South Laguna Madre
173 TCEQMAIN-15565 ARROYO COLORADO 26.7KM GIWW South Laguna Madre
174 TCEQMAIN-15566 ARROYO COLORADO 28.6KM GIWW South Laguna Madre
175 TCEQMAIN-15567 ARROYO COLORADO 30.8KM GIWW South Laguna Madre
176 TCEQMAIN-15568 ARROYO COLORADO 32.7KM GIWW South Laguna Madre
177 TCEQMAIN-15569 ARROYO COLORADO 34.7KM GIWW South Laguna Madre
178 TCEQMAIN-15570 ARROYO COLORADO 36.5KM GIWW South Laguna Madre
179 TCEQMAIN-15571 ARROYO COLORADO 38.2KM GIWW South Laguna Madre
180 TCEQMAIN-15572 ARROYO COLORADO 39.9KM GIWW South Laguna Madre
181 TCEQMAIN-15573 ARROYO COLORADO 41.7KM GIWW South Laguna Madre
182 TCEQMAIN-15574 ARROYO COLORADO 7.0KM GIWW South Laguna Madre
183 TCEQMAIN-15575 ARROYO COLORADO 9.5 KM GIWW South Laguna Madre
184 TCEQMAIN-15576 ARROYO COLORADO 10.94KM GIWW South Laguna Madre
185 TCEQMAIN-15577 ARROYO COLORADO 11.3KM GIWW South Laguna Madre
186 TCEQMAIN-15578 ARROYO COLORADO 11.3KM GIWW South Laguna Madre
187 TCEQMAIN-15579 ARROYO COLORADO 11.9KM GIWW South Laguna Madre
188 TCEQMAIN-15580 ARROYO COLORADO 13.0KM GIWW South Laguna Madre
189 TCEQMAIN-15581 ARROYO COLORADO 16.6KM GIWW South Laguna Madre
190 TCEQMAIN-15582 ARROYO COLORADO 19.0 KM GIWW South Laguna Madre
191 TCEQMAIN-15583 CO. DRNGE DITCH 100M FROM SSI South Laguna Madre
192 TCEQMAIN-15584 CO. DRNGE DITCH IN ARROYO CITY South Laguna Madre
193 TCEQMAIN-15585 SAN VINCENTE DRNGE DITCH South Laguna Madre
194 TCEQMAIN-15586 CO. DRNGE DITCH SE OF SSI South Laguna Madre
195 TCEQMAIN-15587 CO. DRNGE DITCH UPSTM OF SSI South Laguna Madre
196 TCEQMAIN-15588 WASTEWATER DISCHARGE FROM SSI South Laguna Madre
197 TCEQMAIN-15589 CO. DRNGE DITCH UPSTRM OF AAA South Laguna Madre
198 TCEQMAIN-15590 WW DSCHG DITCH FROM AAA OUTFL South Laguna Madre
199 TCEQMAIN-15591 CO. DRNGE DWNSTRM OF AAA OUTFL South Laguna Madre
200 TCEQMAIN-15592 AAA WASTEWATER OUTFALL #001 South Laguna Madre
201 TCEQMAIN-15593 SAN VICENTE DRAINAGE DITCH South Laguna Madre
202 TCEQMAIN-15594 TSVA INTAKE B South Laguna Madre
203 TCEQMAIN-15595 TSVA INTAKE A South Laguna Madre
204 TCEQMAIN-15596 LAGUNA MADRE MORANCO BLANCO South Laguna Madre
205 TCEQMAIN-15597 LAGUNA MADRE MORANCO BLANCO South Laguna Madre
206 TCEQMAIN-15598 LAGUNA MADRE MORANCO BLANCO South Laguna Madre
207 TCEQMAIN-15599 LAGUNA MADRE MORANCO BLANCO South Laguna Madre
208 TCEQMAIN-15600 LAGUNA MADRE MORANCO BLANCO South Laguna Madre
209 TCEQMAIN-15601 LAGUNA MADRE MORANCO BLANCO South Laguna Madre
210 TCEQMAIN-15602 LAGUNA MADRE LAGUNDA ATASCOSA South Laguna Madre
211 TCEQMAIN-15603 LAGUNA MADRE LAGUNA ATASCOSA South Laguna Madre
212 TCEQMAIN-15604 LAGUNA MADRE LAGUNA ATASCOSA South Laguna Madre
213 TCEQMAIN-15605 LAGUNA MADRE LAGUNA ATASCOSA South Laguna Madre
214 TCEQMAIN-15794 ARROYO COLORADO UPSTREAM CM36 South Laguna Madre
215 TCEQMAIN-15808 RIO GRANDE ABOVE PHARR BRIDGE Lower Rio Grande
217 TCEQMAIN-16131 ARROYO COLORADO UPSTR FM1926 South Laguna Madre
218 TCEQMAIN-16132 ARROYO COLORADO DWNSTR US281 South Laguna Madre
219 TCEQMAIN-16133 ARROYO COLORADO UPSTR FM2557 South Laguna Madre
220 TCEQMAIN-16134 ARROYO COLORADO DWNSTR FM907 South Laguna Madre
221 TCEQMAIN-16135 ARROYO COLORADO 3.5KM U FM88 South Laguna Madre
222 TCEQMAIN-16136 ARROYO COLORADO 2.1KM U FM88 South Laguna Madre
223 TCEQMAIN-16137 ARROYO COLORADO AT FM88 South Laguna Madre
224 TCEQMAIN-16138 ARROYO COLORADO UPSTR FM491 South Laguna Madre
225 TCEQMAIN-16139 ARROYO COLORADO UPSTR FM506 South Laguna Madre
226 TCEQMAIN-16140 ARROYO COLORADO AT BOTTS PARK South Laguna Madre
227 TCEQMAIN-16141 ARROYO COLORADO & COMMERCE ST South Laguna Madre
228 TCEQMAIN-16142 ARROYO COLORADO & CEMETERY RD South Laguna Madre
229 TCEQMAIN-16143 ARROYO COLORADO UPSTR FM106 South Laguna Madre
230 TCEQMAIN-16144 ARROYO COLORADO DWN CAMP PERRY South Laguna Madre
231 TCEQMAIN-16145 ARROYO COLORADO 8KM U ARR CITY South Laguna Madre
232 TCEQMAIN-16146 ARROYO COLORADO 4KM U ARR CITY South Laguna Madre
233 TCEQMAIN-16147 ARROYO COLORADO 3KM D ARR CITY South Laguna Madre
234 TCEQMAIN-16151 ARROYO COLORADO 31.1KM U MOUTH South Laguna Madre
235 TCEQMAIN-16152 ARROYO COLO 27.116KM U MOUTH South Laguna Madre
236 TCEQMAIN-16153 ARROYO COLO 22.409KM U MOUT South Laguna Madre
237 TCEQMAIN-16154 ARROYO COLORADO 12.7KM U MOUTH South Laguna Madre
238 TCEQMAIN-16155 ARROYO COLO 4.551KM U MOUTH South Laguna Madre
239 TCEQMAIN-16270 LAND O LAKES RESACA South Laguna Madre
240 TCEQMAIN-16285 LINCOLN PARK RESACA-SOUTHEAST South Laguna Madre
241 TCEQMAIN-16286 FORT BROWN RESACA NORTHEAST South Laguna Madre
242 TCEQMAIN-16287 RESACA DE LA PALMA South Laguna Madre
243 TCEQMAIN-16288 RIO GRANDE RIVER AT SABAL PALM SANCTUARY Lower Rio Grande
244 TCEQMAIN-16440 TOWN RESACA AT BARNARD & SYCAM South Laguna Madre
245 TCEQMAIN-16444 ARROYO COLORADO AT FM491 South Laguna Madre
246 TCEQMAIN-16445 ARROYO COLORADO AT DILWORTH RD South Laguna Madre
247 TCEQMAIN-16446 ARROYO COLORADO AT FM509 South Laguna Madre
248 TCEQMAIN-17100 LAGUNA MADRE NEAR BOWIE PARK South Laguna Madre
249 TCEQMAIN-17101 SOUTH BAY South Laguna Madre
250 TCEQMAIN-17102 BROWNSVILLE SHIP CM38 South Laguna Madre
251 TCEQMAIN-17111 DONNA POTW DISCHARGE DITCH South Laguna Madre
252 TCEQMAIN-17112 MERCEDES POTW DISCHARGE DITCH South Laguna Madre
253 TCEQMAIN-17113 DRAINAGE DITCH HARDING RANCH South Laguna Madre
254 TCEQMAIN-17114 HIDALGO POTW OUTFALL South Laguna Madre
255 TCEQMAIN-17115 MISSION POTW DISCHARGE DITCH South Laguna Madre
256 TCEQMAIN-17117 LAGUNA MADRE NEAR ICWW CM 284 South Laguna Madre
257 TCEQMAIN-17247 RIO GRANDE UPSTRM OF FM 1015 Lower Rio Grande
258 TCEQMAIN-17394 LA FERIA RES WEST OF FM 506 South Laguna Madre
260 TCEQMAIN-17415 DONNA RES SITE PS South Laguna Madre
261 TCEQMAIN-17416 DONNA RES SITE E South Laguna Madre
262 TCEQMAIN-17642 DRAINAGE DITCH UPSTRM SOUTH RD South Laguna Madre
263 TCEQMAIN-17643 DRAINAGE DITCH AT FM 1846 South Laguna Madre
264 TCEQMAIN-17644 DRAINAGE DITCH AT FM 2062 South Laguna Madre
265 TCEQMAIN-17650 ARROYO COLORADO TIDAL P OF HAR South Laguna Madre
266 TCEQMAIN-17940 DELTA LK .4 KM UPSTREAM OF DAM South Laguna Madre
267 TCEQMAIN-17975 LAGUNA MADRE TDH-SOU20 South Laguna Madre
268 TCEQMAIN-18196 UNNAMED DITCH AT FM 510 South Laguna Madre
269 TCEQMAIN-18485 ARROYO COLORADO AT VALLEY VIEW South Laguna Madre
270 TCEQMAIN-18486 DONNA CANAL NR MILITARY/US 281 South Laguna Madre
271 TCEQMAIN-18487 DONNA CANAL NR ARROYO SIPHON South Laguna Madre
272 TCEQMAIN-18488 DONNA CANAL NR ARROYO SIPHON South Laguna Madre
273 TCEQMAIN-18489 DONNA CANAL AT VALLEY VIEW RD South Laguna Madre
274 TCEQMAIN-18490 DONNA RESERVOIR WEST MIDLAKE South Laguna Madre
275 TCEQMAIN-20098 ARROYO COLORADO AT ARROYO CITY CAMS 0739 South Laguna Madre
276 TCEQMAIN-20102 ARROYO COLORADO NORTH FLOODWAY AT LLANO GRANDE CAMS 0738 South Laguna Madre
277 TCEQMAIN-20103 ARROYO COLORADO NEAR VALLEY VIEW CAMS 0740 South Laguna Madre
278 TCEQMAIN-20104 RIO GRANDE WEST BANK AT HARDWICKE FARMS CAMS 0737 Lower Rio Grande
279 TCEQMAIN-20200 ARROYO COLORADO TIDAL NEAR PORT HARLINGEN South Laguna Madre
280 TCEQMAIN-20449 RIO GRANDE RIVER AT BROWNSVILLE PUB WATER TREATMENT PLANT NUMBER 1 INTAKE BETWEEN WTP RESERVOIR AND RIO GRANDE LEVEE South Laguna Madre
281 TCEQMAIN-20696 RIO GRANDE AT THE EL MORILLO TRACT OF THE LOWER RIO GRANDE VALLEY NATIONAL WILDLIFE REFUGE Lower Rio Grande
282 TCEQMAIN-20698 OLD RIO GRANDE MEANDER LA PARIDO BANCO NUMBER 144 BOAT RAMP Lower Rio Grande
283 TCEQMAIN-20737 RIO GRANDE RIVER 320 METERS UPSTREAM OF STATE LOOP 200 / BRAVO BOULEVARD CAMS 767 Los Olmos
284 TCEQMAIN-20738 RIO GRANDE RIVER 2.816 KILOMETERS UPSTREAM OF PETE DIAZ AVENUE / BRIDGE AVENUE CAMS 781 Los Olmos
285 TCEQMAIN-20739 RIO GRANDE RIVER 345 METERS WEST AND 70 METERS SOUTH FROM THE INTERSECTION OF KCTM FM ROAD 103 AND PATRIOT LANE CAMS 782 Los Olmos
286 TCEQMAIN-20850 CITY OF MISSION WWTP South Laguna Madre
287 TCEQMAIN-20851 CITY OF MCALLEN WWTP South Laguna Madre
288 TCEQMAIN-20853 CITY OF PHARR WWTP South Laguna Madre
289 TCEQMAIN-20854 CITY OF SAN JUAN WWTP South Laguna Madre
290 TCEQMAIN-20855 SAN JUAN CONSTRUCTED WETLAND OUTFALL South Laguna Madre
291 TCEQMAIN-20856 CITY OF ALAMO WWTP South Laguna Madre
292 TCEQMAIN-20857 ARROYO COLORADO AT MHWSC BALLI ROAD WWTP South Laguna Madre
293 TCEQMAIN-20858 CITY OF DONNA WWTP South Laguna Madre
294 TCEQMAIN-20859 CITY OF WESLACO WWTP South Laguna Madre
295 TCEQMAIN-20860 MHWSC PROGRESO WWTP South Laguna Madre
296 TCEQMAIN-20861 CITY OF MERCEDES WWTP South Laguna Madre
297 TCEQMAIN-20862 LA FERIA WWTP South Laguna Madre
298 TCEQMAIN-20863 LA FERIA CONSTRUCTED WETLAND OUTFALL South Laguna Madre
299 TCEQMAIN-20864 JOINES ROAD WWTP South Laguna Madre
300 TCEQMAIN-20865 ARROYO COLORADO AT HARLINGEN WWTP South Laguna Madre
301 TCEQMAIN-20866 SAN BENITO WWTP OUTFALL South Laguna Madre
302 TCEQMAIN-20867 SAN BENITO CONSTRUCTED WETLAND OUTFALL South Laguna Madre
303 TCEQMAIN-20868 CITY OF RIO HONDO WWTP South Laguna Madre
304 TCEQMAIN-20869 EAST RIO HONDO LOZANO WWTP South Laguna Madre
305 TCEQMAIN-20879 MCAULIFFE MIDDLE SCHOOL STORMWATER DETENTION FACILITY OUTLET South Laguna Madre
306 TCEQMAIN-20901 MCALLEN DOG PARK DRAIN INLET AT TAMARACK AVENUE South Laguna Madre
307 TCEQMAIN-20902 MCAULIFFE MIDDLE SCHOOL STORMWATER DETENTION FACILITY INLET South Laguna Madre
308 TCEQMAIN-20903 MCALLEN DOG PARK DRAIN OUTLET AT TAMARACK AVENUE South Laguna Madre
309 TCEQMAIN-20908 MORRIS MIDDLE SCHOOL STORMWATER DETENTION FACILITY INLET South Laguna Madre
310 TCEQMAIN-20909 MORRIS MIDDLE SCHOOL STORMWATER DETENTION FACILITY OUTLET South Laguna Madre
311 TCEQMAIN-20930 NORTH FLOODWAY AT US 77 South Laguna Madre
312 TCEQMAIN-21012 RIO GRANDE RIVER OFF SHUERBACH ROAD CAMS 792 Lower Rio Grande
313 TCEQMAIN-21101 RIO GRANDE RIVER AT UNITED IRRIG DSTRCT MISSION TX CANAL Lower Rio Grande
314 TCEQMAIN-21120 LOWER LAGUNA MADRE SOUTH OF MOUTH OF ARROYO COLORADO South Laguna Madre
315 TCEQMAIN-21121 LAGUNA MADRE APPROX 1.5 K WEST OF BAY SHORE OF SOUTH PADRE ISLAND South Laguna Madre
316 TCEQMAIN-21122 SOUTH BAY SOUTH OF CUT AND WEST OF BRAZOS ISLAND South Laguna Madre
317 TCEQMAIN-21194 UNNAMED DITCH WEST SIDE OF S RIVER ROAD South Laguna Madre
318 TCEQMAIN-21195 UNMD DRAIN DITCH 0.98 KM SE OF MILE4 N AND FM491 South Laguna Madre
319 TCEQMAIN-21509 OUT OF STREAM VNC-PSR AT VALLEY NATURE CENTER South Laguna Madre
320 TCEQMAIN-21510 OUT OF STREAM VNC-PWT AT VALLEY NATURE CENTER South Laguna Madre
321 TCEQMAIN-21511 OUT OF STREAM VNC-RHS 1 AT VALLEY NATURE CENTER South Laguna Madre
322 TCEQMAIN-21512 OUT OF STREAM VNC-TW AT VALLEY NATURE CENTER South Laguna Madre
323 TCEQMAIN-21522 RIO GRANDE RIVER 165 METERS UPSTREAM OF THE LAS FLORES PROGRESO INTERNATIONAL BRIDGE/FM 1015 Lower Rio Grande
324 TCEQMAIN-21523 RIO GRANDE RIVER DISCHARGE POINT ON US SIDE LEFT BANK 1.59 KILOMETERS SOUTH AND 720 METERS EAST FROM THE INTERSECTION OF MILITARY ROAD AND SHARYLAND ROAD AND SHARY ROAD Lower Rio Grande
325 TCEQMAIN-21524 RIO GRANDE RIVER STORM WATER DISCHARGE POINT ON US SIDE LEFT BANK 395 METERS WEST AND 50 METERS NORTH FROM THE INTERSECTION OF WEST COMA AVENUE AND EAST TEXANO DR/OLD MILITARY ROAD Lower Rio Grande
326 TCEQMAIN-21525 UNNAMED TRIBUTARY AT THE CONFLUENCE OF THE RIO GRANDE RIVER ON MEXICO SIDE 110 METERS NORTH AND 75 METERS EAST FROM THE INTERSECTION OF DEL BORDO AND 20 DE NOVIEMBRE Lower Rio Grande
327 TCEQMAIN-21526 RIO GRANDE RIVER DISCHARGE POINT ON US SIDE LEFT BANK 400 METERS DOWNSTREAM FROM EL ANHELO DRAIN Lower Rio Grande
328 TCEQMAIN-21527 EL ANHELO DRAIN AT CONFLUENCE OF THE RIO GRANDE RIVER Lower Rio Grande
329 TCEQMAIN-21528 RIO GRANDE RIVER RIO GRANDE CITY WWTP DISCHARGE WQ0010802-001 Los Olmos
330 TCEQMAIN-21529 LOS OLMOS CREEK AT THE CONFLUENCE WITH THE RIO GRANDE RIVER Los Olmos
331 TCEQMAIN-21536 OUT OF STREAM LA FERIA REC CENTER PERMEABLE PARKING LOT South Laguna Madre
332 TCEQMAIN-21537 OUT OF STREAM LA FERIA REC CENTER TRADITIONAL PARKING LOT South Laguna Madre
333 TCEQMAIN-21538 OUT OF STREAM LA FERIA REC CENTER RAIN GAUGE South Laguna Madre
334 TCEQMAIN-21554 OUT OF STREAM VNC-RAIN GAUGE AT VALLEY NATURE CENTER South Laguna Madre
335 TCEQMAIN-21573 RIO GRANDE DOWNSTREAM OF FALCON DAM Los Olmos
336 TCEQMAIN-21591 ARROYO LOS OLMOS UPSTREAM OF RIO GRANDE Los Olmos
337 TCEQMAIN-21592 RIO GRANDE AT DONNA PUMP Lower Rio Grande
338 TCEQMAIN-21593 RIO GRANDE AT SANTA MARIA PUMP Lower Rio Grande
339 TCEQMAIN-21602 RIO GRANDE RIVER SILAS RAY BROWNSVILLE POWER PLANT WQ0003096-000 South Laguna Madre
340 TCEQMAIN-21603 RIO GRANDE RIVER BROWNSVILLE SOUTHSIDE WASTEWATER TREATMENT PLANT TPDES WQ0010397-003 South Laguna Madre
341 TCEQMAIN-21604 RIO GRANDE RIVER PENITAS WASTEWATER TREATMENT PLANT WQ0014884-001 South Laguna Madre
342 TCEQMAIN-21605 RIO GRANDE RIVER LA JOYA WASTEWATER TREATMENT FACILITY WQ0012675-001 Los Olmos
343 TCEQMAIN-21606 RIO GRANDE RIVER LA JOYA WASTEWATER TREATMENT FACILITY OUTFALL WQ0012675-001 Los Olmos
344 TCEQMAIN-21607 RIO GRANDE RIVER LA JOYA ISD WASTEWATER TREATMENT PLANT WQ0013523-006 Los Olmos
345 TCEQMAIN-21608 RIO GRANDE RIVER AGUA SUD WASTEWATER TREATMENT PLANT OUTFALL WQ0014415-001 Los Olmos
346 TCEQMAIN-21609 RIO GRANDE RIVER UNION WSC WASTEWATER TREATMENT PLANT WQ0014313-001 Los Olmos
347 TCEQMAIN-21610 RIO GRANDE RIVER UNION WSC WASTEWATER TREATMENT PLANT WQ0014313-001 Los Olmos
348 TCEQMAIN-21611 RIO GRANDE RIVER RIO GRANDE CITY WASTEWATER TREATMENT PLANT WQ0010802-001 Los Olmos
349 TCEQMAIN-21612 RIO GRANDE RIVER ROMA WASTEWATER TREATMENT PLANT WQ0011212-002 Los Olmos
350 TCEQMAIN-21613 RIO GRANDE RIVER ROMA WATER TREATMENT PLANT TPDES WQ0011212-003 Los Olmos
351 TCEQMAIN-21749 RIO GRANDE APPROX 380 METERS DOWNSTREAM OF CONFLUENCE WITH LOS OLMOS CREEK Los Olmos
352 TCEQMAIN-21944 TRADITIONAL PAVEMENT CORNER OF PECAN AND N 29TH ST MCALLEN South Laguna Madre
353 TCEQMAIN-21945 BIOSWALE AT CORNER OF PECAN ST AND N 29TH ST South Laguna Madre
354 TCEQMAIN-21966 OUT OF STREAM MONTE BELLA TRAIL PARK OUTFLOW IMPERVIOUS PARKINGLOT/TRADITIONAL PARKINGLOT South Laguna Madre
355 TCEQMAIN-21967 OUT OF STREAM MONTE BELLA TRAIL PARK OUTFLOW PERVIOUS PARKINGLOT South Laguna Madre
356 TCEQMAIN-21968 OUT OF STREAM MONTE BELLA TRAIL PARK INFLOW BIOSWALE AND RAIN GAUGE South Laguna Madre
357 TCEQMAIN-21969 OUT OF STREAM MONTE BELLA TRAIL PARK OUTFLOW BIOSWALE South Laguna Madre
358 TCEQMAIN-21970 OUT OF STREAM CASCADE PARK OUTFLOW PERVIOUS PARKINGLOT AND RAIN GAUGE South Laguna Madre
359 TCEQMAIN-21971 OUT OF STREAM CASCADE PARK OUTFLOW BIOSWALE South Laguna Madre
360 TCEQMAIN-21977 RIO GRANDE HARLINGEN ID 1 C789 Lower Rio Grande
361 TCEQMAIN-21979 SOUTH RIO RICO RD AT RIO GRANDE RIVER Lower Rio Grande
362 TCEQMAIN-21980 1.22 MILES DOWNSTREAM OF THE PETE DIAZ BRIDGE Los Olmos
363 TCEQMAIN-21988 OUT OF STREAM MONTE BELLA TRAIL PARK OUTFLOW PERMEABLE WALKING TRAIL South Laguna Madre
364 TCEQMAIN-21989 OUT OF STREAM WESLACO PUBLIC LIBRARY RAINWATER HARVESTING SYSTEM AND RAIN GAUGE South Laguna Madre
365 TCEQMAIN-22003 HIDALGO MAIN FLOODWATER CHANNEL AT FM 1420 South Laguna Madre
366 TCEQMAIN-22004 RAYMONDVILLE DRAIN AT WILLACY COUNTY ROAD 445 South Laguna Madre
367 TCEQMAIN-22116 LAGUNA MADRE  NEAR SARGENT BEACH South Laguna Madre
368 TCEQMAIN-22117 GULF OF MEXICO AT ISLA BLANCA PARK South Laguna Madre
369 TCEQMAIN-22118 CAMERON COUNTY DRAINAGE DISTRICT NO.1 (CCDD1) DITCH NO. 2 AT OLD PORT ISABEL ROAD South Laguna Madre
370 TCEQMAIN-22120 CAMERON COUNTY DRAINAGE DISTRICT NO.1 (CCDD1) DITCH NO.1 AT THE BROWNSVILLE PUBLIC WORKS DEPARTMENT South Laguna Madre
371 TCEQMAIN-22121 CAMERON COUNTY DRAINAGE DISTRICT NO.1 (CCDD1) OLD MAIN DRAIN NO. 2 AT THE CITY OF BROWNSVILLE LANDFILL South Laguna Madre
372 TCEQMAIN-22170 SAN MARTIN LAKE MID ESTUARY South Laguna Madre
373 TCEQMAIN-22262 OUT OF STREAM LA ESQUINA COLONIA RIVER ROCK BIORETENTION INFLOW LOCATION IN LOS FRESNOS TEXAS South Laguna Madre
374 TCEQMAIN-22263 OUT OF STREAM LA ESQUINA COLONIA RIVER ROCK BIORETENTION OUTFLOW LOCATION IN LOS FRESNOS TEXAS South Laguna Madre
375 TCEQMAIN-22265 OUT OF STREAM LA ESQUINA COLONIA CONCRETE BIORETENTION INFLOW LOCATION IN LOS FRESNOS TEXAS South Laguna Madre
376 TCEQMAIN-22266 OUT OF STREAM LA ESQUINA COLONIA CONCRETE BIORETENTION OUTFLOW LOCATION IN LOS FRESNOS TEXAS South Laguna Madre
377 TCEQMAIN-22267 OUT OF STREAM PARKING LOT PUMICE BIOSWALE INFLOW AT UTRGV CAMPUS South Laguna Madre
378 TCEQMAIN-22268 OUT OF STREAM PARKING LOT PUMICE BIOSWALE OUTFLOW AT UTRGV CAMPUS South Laguna Madre
379 TCEQMAIN-22269 OUT OF STREAM PARKING LOT MANUFACTURED SAND BIOSWALE INFLOW AT UTRGV CAMPUS South Laguna Madre
380 TCEQMAIN-22270 OUT OF STREAM PARKING LOT MANUFACTURED SAND BIOSWALE OUTFLOW AT UTRGV CAMPUS South Laguna Madre
381 TCEQMAIN-22271 OUT OF STREAM PARKING LOT RECYCLED GLASS BIOSWALE INFLOW AT UTRGV CAMPUS South Laguna Madre
382 TCEQMAIN-22272 OUT OF STREAM PARKING LOT RECYCLED GLASS BIOSWALE OUTFLOW AT UTRGV CAMPUS South Laguna Madre
383 TCEQMAIN-22273 OUT OF STREAM PARKING LOT NATURAL SAND BIOSWALE INFLOW AT UTRGV CAMPUS South Laguna Madre
384 TCEQMAIN-22274 OUT OF STREAM PARKING LOT NATURAL SAND BIOSWALE OUTFLOW AT UTRGV CAMPUS South Laguna Madre
385 TCEQMAIN-22275 RADO ALTERNATE DRAINAGE CHANNEL AT VINE AVENUE AND WARRIOR DRIVE INTERSECTION IN HIDALGO COUNTY South Laguna Madre
386 TCEQMAIN-22276 MISSION MCALLEN LATERAL DRAINAGE CHANNEL AT DAFFODIL AVENUE AND N BENTSEN ROAD INTERSECTION IN HIDALGO COUNTY South Laguna Madre
387 TCEQMAIN-22277 MISSION LATERAL DRAINAGE DITCH CHANNEL AT 2911 NORTH TAYLOR ROAD IN HIDALGO COUNTY South Laguna Madre
388 TCEQMAIN-22401 HACKNEY LAKE INLET AT SOUTH JACKSON ROAD South Laguna Madre
389 TCEQMAIN-22402 RIO GRANDE RIVER BOAT LAUNCH AT HIDALGO CR 1598 Lower Rio Grande
390 TCEQMAIN-22404 RAYMONDVILLE DRAIN AT RODRIGUEZ RD South Laguna Madre
391 TCEQMAIN-22636 RAYMONDVILLE DRAIN AT WEAVER RD South Laguna Madre
392 TCEQMAIN-22638 HIDALGO WILLACY MAIN DRAIN AT FM 88 South Laguna Madre
393 TCEQMAIN-22639 US-IBWC NORTH FLOODWAY AT FM 1425 South Laguna Madre

Step 3 — Fetch the full results record

We fetch every WQP result for TCEQMAIN in the study-area bounding box — not filtered by characteristic up front, mirroring notebook 3’s discrete-samples fetch (fetch_samples), since WQP’s per-organization-plus-bbox query is already small enough to pull in full (verified: tens of thousands of rows, under two minutes) and its exact characteristic-name vocabulary is easier to filter after fetching than to guess before. This is the slow step (~1-2 minutes), so it’s the one most worth caching — same load_dataframe-as-backup-cache approach as Step 2.

Show code
results_path = S.data_dir / "tceq_waterquality" / "tceq_results.parquet"
raw_results = None
tceq_results = load_dataframe(results_path, max_age_days=7)
if tceq_results is None:
    raw_results = fetch_wqp_results(bbox, organization="TCEQMAIN")
    show(raw_results.head())  # peek at the raw WQP response shape before we tidy it
using cached data/tceq_waterquality/tceq_results.parquet (37372 rows, < 7 days old)

Step 4 — Tidy and classify by priority parameter

tidy_wqp_results renames WQP’s columns to the project’s convention, keeps only rows whose characteristic maps to one of our priority groups (classify_parameter), and tags priority_group/huc8. Skipped when tceq_results already came from the cache above.

Show code
huc8_by_station = dict(zip(stations_in_area["MonitoringLocationIdentifier"], stations_in_area["huc8"]))
if tceq_results is None:
    tceq_results = tidy_wqp_results(raw_results, huc8_by_station)
    show(tceq_results.head())
    save_dataframe(tceq_results, results_path)

Which stations measure which priority parameters?

Derived from the tidied results (WQP has no separate lightweight “what does this station measure” endpoint the way USGS WaterData does, so we classify after fetching rather than before).

A note on completeness: in testing, pH was completely absent from TCEQ’s WQP data for every station checked, despite being a routine field measurement — this looks like a gap in how TCEQ’s pH results are tagged for WQP submission, not a bug in this notebook. If pH shows up thin or missing below, that’s this known gap, not a query error.

Show code
groups_by_station = tceq_results.groupby("monitoring_location_id")["priority_group"].agg(set).to_dict()
for group in PRIORITY_NAMES:
    stations_in_area[group] = stations_in_area["MonitoringLocationIdentifier"].map(
        lambda s, g=group: g in groups_by_station.get(s, set())
    )
# Only re-save if something was actually fetched fresh above (stations or results) — otherwise
# both came straight from cache and touching the file would reset its own freshness clock for
# nothing.
if not stations_were_cached or raw_results is not None:
    save_dataframe(stations_in_area, stations_path)

print(f"Stations by priority parameter (of {len(stations_in_area)}):")
print(stations_in_area[PRIORITY_NAMES].sum().to_string())

if raw_results is not None:
    unmatched = sorted({
        str(c) for c in raw_results["CharacteristicName"].dropna().unique()
        if classify_parameter(characteristic=c) is None
    })
    print(f"\n{len(unmatched)} unmatched characteristics (first 25):")
    print("\n".join(unmatched[:25]))
else:
    print("\n(unmatched-characteristics audit skipped — tceq_results came from the cache, not a fresh fetch)")

show(stations_in_area[["MonitoringLocationIdentifier", "MonitoringLocationName", *PRIORITY_NAMES]])
Stations by priority parameter (of 380):
conductivity         96
temperature         101
dissolved_oxygen    124
dissolved_solids     85
chlorophyll          76
pH                    0
nitrogen            130
phosphorus          127
turbidity            17
discharge             0
water_level           6

(unmatched-characteristics audit skipped — tceq_results came from the cache, not a fresh fetch)
MonitoringLocationIdentifier MonitoringLocationName conductivity temperature dissolved_oxygen dissolved_solids chlorophyll pH nitrogen phosphorus turbidity discharge water_level
0 TCEQMAIN-10249 RIO GRANDE RIVER 285 METERS SOUTH 30 METERS WEST FROM THE INTERSECTION OF FM ROAD 813/CANTU ROAD AND AVILIA ROAD True True True True True False True True True False False
1 TCEQMAIN-13036 NORTH FLOODWAY AT FM 1420 False False False False False False False False False False False
2 TCEQMAIN-13037 NORTH FLOODWAY AT SH 107 False False False False False False False False False False False
3 TCEQMAIN-13038 UNNAMED DITCH AT KM 42.7 False False False False False False False False False False False
4 TCEQMAIN-13039 UNMD DRAIN DTCH SW RANGRVL RD True True True False False False True True False False False
5 TCEQMAIN-13040 UNMD DRAIN DTCH SE FM800 False False False False False False False False False False False
6 TCEQMAIN-13041 UNMD DRAIN DTCH S ARROYO COLO False False False False False False False False False False False
7 TCEQMAIN-13042 LA FERIA DITCH N OF ARROYO COL False False False False False False False False False False False
8 TCEQMAIN-13043 UNMD DRAIN DTCH SE FM 2556 False False False False False False False False False False False
9 TCEQMAIN-13044 UNMD DRAIN DTCH NW FM 2556 False False False False False False False False False False False
10 TCEQMAIN-13045 UNMD DRAIN DTCH SE FM 491 False False False False False False False False False False False
11 TCEQMAIN-13046 ARROYO ANACUITAS False False False False False False False False False False False
12 TCEQMAIN-13047 UNMD DRAIN DTCH ARROYO COLORAD False False False False False False False False False False False
13 TCEQMAIN-13048 UNMD DRAIN DTCH ARROYO COLORAD False False False False False False False False False False False
14 TCEQMAIN-13049 UNMD DRAIN DTCH LLANO GR LAKE False False False False False False False False False False False
15 TCEQMAIN-13050 UNMD DITCH E OF FM 88 False False False False False False False False False False False
16 TCEQMAIN-13051 UNMD DITCH E OF FM 88 False False False False False False False False False False False
17 TCEQMAIN-13052 UNMD DRAIN DTCH S OF LLANO GRN False False False False False False False False False False False
18 TCEQMAIN-13053 UNMD DRAIN DTCH ARROYO COLORAD False False False False False False False False False False False
19 TCEQMAIN-13054 UNMD DITCH END OF MIDWAY RD False False False False False False False False False False False
20 TCEQMAIN-13055 DONNA DITCH N ARROYO COLORADO False False False False False False False False False False False
21 TCEQMAIN-13056 UNMD DITCH S ARROYO COLORADO False False False False False False False False False False False
22 TCEQMAIN-13057 LAGUNA MADRE N PK RD 100 False False False False False False False False False False False
23 TCEQMAIN-13058 UNMD DITCH S OF ARROYO COLORAD False False False False False False False False False False False
24 TCEQMAIN-13059 ALAMO DITCH N ARROYO COLORADO False False False False False False False False False False False
25 TCEQMAIN-13060 UNNAMED DITCH AT BORDER RD. False False False False False False False False False False False
26 TCEQMAIN-13061 PHARR-SAN JUAN DITCH False False False False False False False False False False False
27 TCEQMAIN-13062 UNMD DRAIN PIPE W US281 False False False False False False False False False False False
28 TCEQMAIN-13063 AIRPORT DTCH N ARROYO COLORADO False False False False False False False False False False False
29 TCEQMAIN-13064 UNMD DITCH S OF ARROYO COLORAD False False False False False False False False False False False
30 TCEQMAIN-13065 MCALLEN GOLF COURSE DRAIN False False False False False False False False False False False
31 TCEQMAIN-13066 UNMD DITCH S OF ARROYO COLORAD False False False False False False False False False False False
32 TCEQMAIN-13067 MISSION DITCH N ARROYO COLORAD False False False False False False False False False False False
33 TCEQMAIN-13068 CAYO ATASCOSO NR CONFL ARROYO False False False False False False False False False False False
34 TCEQMAIN-13069 CAYO ATASCOSO AT FM 106 False False False False False False False False False False False
35 TCEQMAIN-13070 ARROYO COLORADO TDL 5KM GIWW False False False False False False False False False False False
36 TCEQMAIN-13071 ARROYO COLORADO AT CM 22 True True True True True False True True False False False
37 TCEQMAIN-13072 ARROYO COLORADO AT FM 106 CAMS 0730 True True True True True False True True False False False
38 TCEQMAIN-13073 ARROYO COLO AT CAMP PERRY True True True True True False True True False False False
39 TCEQMAIN-13074 ARROYO COLORADO /PT.HARLINGEN True True True True True False True True False False False
40 TCEQMAIN-13075 ARROYO COLORADO AT COUNTY RD False False False False False False False False False False False
41 TCEQMAIN-13076 ARROYO COLORADO AT FM 801 False False False False False False False False False False False
42 TCEQMAIN-13077 ARROYO COLORADO AT LOOP 499 False False False False False False False False False False False
43 TCEQMAIN-13078 ARROYO COLORADO AT COMMERCE ST False False False False False False False False False False False
44 TCEQMAIN-13079 ARROYO COLORADO AT US 77 True True True True True False True True True False True
45 TCEQMAIN-13080 ARROYO COLORADO AT FM 506 True True True True True False True True True False False
46 TCEQMAIN-13081 ARROYO COLORADO MAIN FLOODWAY True True True True True False True True False False False
47 TCEQMAIN-13082 ARROYO COLORADO AT FM 493 True True True False False False False False False False False
48 TCEQMAIN-13083 ARROYO COLORADO AT FM 907 False False False False False False False False False False False
49 TCEQMAIN-13084 ARROYO COLORADO AT US 281 True True True True True False True True False False False
50 TCEQMAIN-13085 ARROYO COLORADO AT FM 2061 False False False False False False False False False False False
51 TCEQMAIN-13086 ARROYO COLORADO AT FM 336 True True True False False False False False False False False
52 TCEQMAIN-13087 ARROYO COLORADO AT FM 115 False False False False False False False False False False False
53 TCEQMAIN-13088 ARROYO COLORADO AT FM 494 False False False False False False False False False False False
54 TCEQMAIN-13089 ARROYO COLORADO AT FM 1016 False False False False False False False False False False False
55 TCEQMAIN-13103 LOS OLMOS CREEK AT US 83 True True True True True False True True False False False
56 TCEQMAIN-13104 LOS OLMOS CREEK AT SH 755 True True True True True False True True False False False
57 TCEQMAIN-13176 RIO GRANDE RIVER TIDAL AT THE END OF QUICKSILVER AVE True True True True True False True True False False False
58 TCEQMAIN-13177 RIO GRANDE AT EL JARDIN PUMP True True True True True False True True True False True
59 TCEQMAIN-13178 RIO GRANDE AT US 77 True True True True True False True True True False False
60 TCEQMAIN-13179 RIO GRANDE AT RIVER BEND GOLF COURSE BOAT RAMP True True True True True False True True False False False
61 TCEQMAIN-13180 RIO GRANDE S OF LAS MILPAS False False False False False False False False False False False
62 TCEQMAIN-13181 RIO GRANDE RIVER AT US 281/INTERNATIONAL BLVD True True True True True False True True False False False
63 TCEQMAIN-13182 RIO GRANDE EAST BANK AT ANZALDUAS DAM CAMS 0736 False False False False False False False False False False False
64 TCEQMAIN-13183 RIO GRANDE AT PENITAS False False False False False False False False False False False
65 TCEQMAIN-13184 RIO GRANDE AT FM 886 True True True True True False True True False False False
66 TCEQMAIN-13185 RIO GRANDE AT FT RINGOLD True True True True True False True True False False False
67 TCEQMAIN-13186 RIO GRANDE BELOW RIO ALAMO True True True True True False True True False False False
68 TCEQMAIN-13187 RIO GRANDE BELOW FALCON DAM False False False False False False False False False False False
69 TCEQMAIN-13188 RIO GRANDE S TAILRACE True True True True False False True True True False True
74 TCEQMAIN-13277 PORT MANSFIELD AT HARBOR 1 False False False False False False False False False False False
75 TCEQMAIN-13278 PORT MANSFIELD NW DOCK False False False False False False False False False False False
76 TCEQMAIN-13279 PORT MANSFIELD BOAT LAUNCH False False False False False False False False False False False
77 TCEQMAIN-13280 PORT MANSFIELD SE MARINA False False False False False False False False False False False
78 TCEQMAIN-13281 PORT MANSFIELD AT CM 25 False False False False False False False False False False False
79 TCEQMAIN-13282 PORT ISABEL NR CM 4 False False False False False False False False False False False
80 TCEQMAIN-13283 PORT ISABEL NR CM 142 False False False False False False False False False False False
81 TCEQMAIN-13284 PORT ISABEL AT EAST ENTRANCE False False False False False False False False False False False
82 TCEQMAIN-13285 PORT ISABEL AT SH 100 True True True True True False True True False False False
83 TCEQMAIN-13286 PORT ISABEL NR NORTH ENTRANCE False False False False False False False False False False False
84 TCEQMAIN-13446 LAGUNA MADRE GIWW CM 129 True True True True True False True True False False False
85 TCEQMAIN-13447 LAGUNA MADRE GIWW AND ARROYO True True True True True False True True False False False
88 TCEQMAIN-13459 SOUTH BAY NEAR CLARK ISLAND True True True True True False True True False False False
89 TCEQMAIN-13460 BROWNSVILLE SHIP CHANNEL CM 35 True True True True True False True True False False False
91 TCEQMAIN-13470 GULF OF MEXICO AT PT ISABEL True True True True True False True True False False False
92 TCEQMAIN-13557 ARROYO COLORADO AT THOMAE PARK False False False False False False False False False False False
93 TCEQMAIN-13558 ARROYO COLORADO TIDAL, MKR 18 False False False False False False False False False False False
94 TCEQMAIN-13559 ARROYO COLORADO AT CM27, MI 15 True True True True True False True True False False False
95 TCEQMAIN-13663 RIO ALAMO NR CIUDAD MIER MEX False False False False False False False False False False False
96 TCEQMAIN-13664 RIO GRANDE BELOW ANZALDUAS True True True True True False True True False False False
99 TCEQMAIN-13719 PUERTECITOS DRAIN DIAZ ORDAZ False False False False False False False False False False False
100 TCEQMAIN-13720 ANHELO DRAIN NEAR REYNOSA MEX False False False False False False False False False False False
101 TCEQMAIN-13782 ARROYO COLORADO CM 16 True True True True True False True True False False False
103 TCEQMAIN-14094 WEIR AT 51+80 BELOW FALCON DAM False False False False False False False False False False False
104 TCEQMAIN-14095 WEIR AT 73+75 BELOW FALCON DAM False False False False False False False False False False False
105 TCEQMAIN-14096 WEIR U.S GALLERY FALCON DAM False False False False False False False False False False False
106 TCEQMAIN-14461 DRAINAGE DITCH AT MIDLANE DR False False False False False False False False False False False
107 TCEQMAIN-14490 DRAINAGE DITCH AT CLEVELAND AV False False False False False False False False False False False
110 TCEQMAIN-14843 LAGUNA MADRE PT MANSFIELD 40 False False False False False False False False False False False
111 TCEQMAIN-14844 LAGUNA MADRE ICWW 49 False False False False False False False False False False False
112 TCEQMAIN-14845 LAGUNA MADRE ICWW 109 False False False False False False False False False False False
113 TCEQMAIN-14849 ARROYO COLORADO TIDAL AT CAYO False False False False False False False False False False False
114 TCEQMAIN-14850 ARROYO COLORADO TIDAL False False False False False False False False False False False
115 TCEQMAIN-14851 ARROYO COLORADO TIDAL AT CM 36 False False False False False False False False False False False
116 TCEQMAIN-14852 ARROYO COLORADO MARKER 54 False False False False False False False False False False False
117 TCEQMAIN-14853 ARROYO COLORADO MARKER 73 False False False False False False False False False False False
118 TCEQMAIN-14855 SOUTH BAY NEAR BRAZOS ISLAND False False False False False False False False False False False
119 TCEQMAIN-14856 SOUTH BAY False False False False False False False False False False False
120 TCEQMAIN-14857 SOUTH BAY False False False False False False False False False False False
121 TCEQMAIN-14858 SOUTH BAY False False False False False False False False False False False
122 TCEQMAIN-14861 LAGUNA MADRE False False False False False False False False False False False
123 TCEQMAIN-14862 LAGUNA MADRE False False False False False False False False False False False
124 TCEQMAIN-14863 PORT ISABEL SIDE CHANNEL False False False False False False False False False False False
125 TCEQMAIN-14865 SOUTH BAY True True True True True False True True False False False
126 TCEQMAIN-14868 LAGUNA MADRE False False False False False False False False False False False
127 TCEQMAIN-14869 LAGUNA MADRE False False False False False False False False False False False
128 TCEQMAIN-14870 LAGUNA MADRE NEAR LAGUNA VISTA True True True True True False True True False False False
129 TCEQMAIN-14871 BROWNSVILLE SHIP CHANNEL True True True True True False True True False False False
130 TCEQMAIN-14872 BROWNSVILLE SHIP CHANNEL True True True False True False True True False False False
131 TCEQMAIN-14873 BROWNSVILLE SHIP CHANNEL False False False False False False False False False False False
132 TCEQMAIN-14874 BROWNSVILLE SHIP CHANNEL True True True False True False True True False False False
133 TCEQMAIN-14875 BROWNSVILLE SHIP CHANNEL True True True True True False True True False False False
134 TCEQMAIN-14876 LAGUNA MADRE NEAR CAUSEWAY False False False False False False False False False False False
135 TCEQMAIN-14877 LAGUNA MADRE NEAR RANGE MARKER False False False False False False False False False False False
136 TCEQMAIN-14878 LAGUNA MADRE False False False False False False False False False False False
137 TCEQMAIN-14879 LAGUNA MADRE False False False False False False False False False False False
138 TCEQMAIN-14880 SOUTH BAY False False False False False False False False False False False
139 TCEQMAIN-15205 LA CRUZ RESACA AT FM 2557 False False False False False False False False False False False
140 TCEQMAIN-15206 DRAINAGE DITCH AT JEFFERSON ST False False False False False False False False False False False
141 TCEQMAIN-15207 DRAINAGE DITCH AT GLASSCOCK False False False False False False False False False False False
142 TCEQMAIN-15208 RESACA DE LOS FRESNOS False False False False False False False False False False False
143 TCEQMAIN-15530 RESACA DE LA GUERRA AT VILLAGE False False False False False False False False False False False
144 TCEQMAIN-15531 RESACA DE LA GUERRA AT US 83 False False False False False False False False False False False
145 TCEQMAIN-15532 RESACA DEL RANCHO VIEJO AT DAN False False False False False False False False False False False
146 TCEQMAIN-15533 RESACA DEL RANCHO VIEJO False False False False False False False False False False False
147 TCEQMAIN-15534 TOWN RESACA AT CITY CEMETARY False False False False False False False False False False False
148 TCEQMAIN-15538 TOWN RESACA AT CORIA ST. False False False False False False False False False False False
149 TCEQMAIN-15539 RESACA DE LA GUERRA AT QUAIL False False False False False False False False False False False
150 TCEQMAIN-15540 TOWN RESACA AT STOVALL RD. False False False False False False False False False False False
151 TCEQMAIN-15541 TOWN RESACA AT PORTER PARK False False False False False False False False False False False
152 TCEQMAIN-15542 TOWN RESACA AT PORTER ZOO False False False False False False False False False False False
153 TCEQMAIN-15543 RESACA DE LA PALMA AT HIDDEN False False False False False False False False False False False
154 TCEQMAIN-15544 IRRIGATION CANAL AT CAGE BLVD. False False False False False False False False False False False
155 TCEQMAIN-15547 ARROYO COLORADO 2.1KM GIWW True True True True False False False True False False False
156 TCEQMAIN-15548 ARROYO COLORADO 3.8KM GIWW False False False False False False False False False False False
157 TCEQMAIN-15549 ARROYO COLORADO 4.2KM GIWW False False False False False False False False False False False
158 TCEQMAIN-15550 ARROYO COLORADO 8.0KM GIWW False False False False False False False False False False False
159 TCEQMAIN-15551 ARROYO COLORADO 8.1KM GIWW False False False False False False False False False False False
160 TCEQMAIN-15552 ARROYO COLORADO 8.6 KM GIWW True True True False False False False False True False False
161 TCEQMAIN-15553 ARROYO COLORADO UPSTM CM18 False False False False False False False False False False False
162 TCEQMAIN-15554 ARROYO COLORADO AT CM 16 False False False False False False False False False False False
163 TCEQMAIN-15555 ARROYO COLORADO 11.2KM GIWW False False False False False False False False False False False
164 TCEQMAIN-15556 ARROYO COLORADO 11.4KM GIWW False False False False False False False False False False False
165 TCEQMAIN-15557 ARROYO COLORADO 13.1KM GIWW False False False False False False False False False False False
166 TCEQMAIN-15558 ARROYO COLORADO 13.8KM GIWW False False False False False False False False False False False
167 TCEQMAIN-15559 ARROYO COLORADO 15.6KM GIWW False False False False False False False False False False False
168 TCEQMAIN-15560 ARROYO COLORADO 16.1KM GIWW False False False False False False False False False False False
169 TCEQMAIN-15561 ARROYO COLORADO 17.0 KM GIWW False False False False False False False False False False False
170 TCEQMAIN-15562 ARROYO COLORADO 21.1KM GIWW False False False False False False False False False False False
171 TCEQMAIN-15563 ARROYO COLORADO 22.9KM GIWW False False False False False False False False False False False
172 TCEQMAIN-15564 ARROYO COLORADO 24.5KM GIWW False False False False False False False False False False False
173 TCEQMAIN-15565 ARROYO COLORADO 26.7KM GIWW False False False False False False False False False False False
174 TCEQMAIN-15566 ARROYO COLORADO 28.6KM GIWW False False False False False False False False False False False
175 TCEQMAIN-15567 ARROYO COLORADO 30.8KM GIWW False False False False False False False False False False False
176 TCEQMAIN-15568 ARROYO COLORADO 32.7KM GIWW False False False False False False False False False False False
177 TCEQMAIN-15569 ARROYO COLORADO 34.7KM GIWW True True True True False False False True False False False
178 TCEQMAIN-15570 ARROYO COLORADO 36.5KM GIWW False False False False False False False False False False False
179 TCEQMAIN-15571 ARROYO COLORADO 38.2KM GIWW False False False False False False False False False False False
180 TCEQMAIN-15572 ARROYO COLORADO 39.9KM GIWW False False False False False False False False False False False
181 TCEQMAIN-15573 ARROYO COLORADO 41.7KM GIWW False False False False False False False False False False False
182 TCEQMAIN-15574 ARROYO COLORADO 7.0KM GIWW False False False False False False False False False False False
183 TCEQMAIN-15575 ARROYO COLORADO 9.5 KM GIWW False False False False False False False False False False False
184 TCEQMAIN-15576 ARROYO COLORADO 10.94KM GIWW False False False False False False False False False False False
185 TCEQMAIN-15577 ARROYO COLORADO 11.3KM GIWW False False False False False False False False False False False
186 TCEQMAIN-15578 ARROYO COLORADO 11.3KM GIWW False False False False False False False False False False False
187 TCEQMAIN-15579 ARROYO COLORADO 11.9KM GIWW False False False False False False False False False False False
188 TCEQMAIN-15580 ARROYO COLORADO 13.0KM GIWW False False False False False False False False False False False
189 TCEQMAIN-15581 ARROYO COLORADO 16.6KM GIWW False False False False False False False False False False False
190 TCEQMAIN-15582 ARROYO COLORADO 19.0 KM GIWW False False False False False False False False False False False
191 TCEQMAIN-15583 CO. DRNGE DITCH 100M FROM SSI False False False False False False False False False False False
192 TCEQMAIN-15584 CO. DRNGE DITCH IN ARROYO CITY False False False False False False False False False False False
193 TCEQMAIN-15585 SAN VINCENTE DRNGE DITCH False False False False False False False False False False False
194 TCEQMAIN-15586 CO. DRNGE DITCH SE OF SSI False False False False False False False False False False False
195 TCEQMAIN-15587 CO. DRNGE DITCH UPSTM OF SSI False False False False False False False False False False False
196 TCEQMAIN-15588 WASTEWATER DISCHARGE FROM SSI False False False False False False False False False False False
197 TCEQMAIN-15589 CO. DRNGE DITCH UPSTRM OF AAA False False False False False False False False False False False
198 TCEQMAIN-15590 WW DSCHG DITCH FROM AAA OUTFL False False False False False False False False False False False
199 TCEQMAIN-15591 CO. DRNGE DWNSTRM OF AAA OUTFL False False False False False False False False False False False
200 TCEQMAIN-15592 AAA WASTEWATER OUTFALL #001 False False False False False False False False False False False
201 TCEQMAIN-15593 SAN VICENTE DRAINAGE DITCH False False False False False False False False False False False
202 TCEQMAIN-15594 TSVA INTAKE B False False False False False False False False False False False
203 TCEQMAIN-15595 TSVA INTAKE A False False False False False False False False False False False
204 TCEQMAIN-15596 LAGUNA MADRE MORANCO BLANCO False False False False False False False False False False False
205 TCEQMAIN-15597 LAGUNA MADRE MORANCO BLANCO False False True False True False True True False False False
206 TCEQMAIN-15598 LAGUNA MADRE MORANCO BLANCO False False False False False False False False False False False
207 TCEQMAIN-15599 LAGUNA MADRE MORANCO BLANCO False False False False False False False False False False False
208 TCEQMAIN-15600 LAGUNA MADRE MORANCO BLANCO False False False False False False False False False False False
209 TCEQMAIN-15601 LAGUNA MADRE MORANCO BLANCO False False False False False False False False False False False
210 TCEQMAIN-15602 LAGUNA MADRE LAGUNDA ATASCOSA False False False False False False False False False False False
211 TCEQMAIN-15603 LAGUNA MADRE LAGUNA ATASCOSA False False False False False False False False False False False
212 TCEQMAIN-15604 LAGUNA MADRE LAGUNA ATASCOSA False False False False False False False False False False False
213 TCEQMAIN-15605 LAGUNA MADRE LAGUNA ATASCOSA False False False False False False False False False False False
214 TCEQMAIN-15794 ARROYO COLORADO UPSTREAM CM36 False False False False False False False False False False False
215 TCEQMAIN-15808 RIO GRANDE ABOVE PHARR BRIDGE True True True True True False True True True False False
217 TCEQMAIN-16131 ARROYO COLORADO UPSTR FM1926 True True True True True False True True False False False
218 TCEQMAIN-16132 ARROYO COLORADO DWNSTR US281 True True True True True False True True False False False
219 TCEQMAIN-16133 ARROYO COLORADO UPSTR FM2557 True True True True True False True True False False False
220 TCEQMAIN-16134 ARROYO COLORADO DWNSTR FM907 True True True True True False True True False False False
221 TCEQMAIN-16135 ARROYO COLORADO 3.5KM U FM88 True True True True True False True True False False False
222 TCEQMAIN-16136 ARROYO COLORADO 2.1KM U FM88 True True True True True False True True False False False
223 TCEQMAIN-16137 ARROYO COLORADO AT FM88 True True True True True False True True False False False
224 TCEQMAIN-16138 ARROYO COLORADO UPSTR FM491 True True True True True False True True False False False
225 TCEQMAIN-16139 ARROYO COLORADO UPSTR FM506 True True True True True False True True False False False
226 TCEQMAIN-16140 ARROYO COLORADO AT BOTTS PARK True True True True True False True True False False False
227 TCEQMAIN-16141 ARROYO COLORADO & COMMERCE ST True True True True True False True True False False False
228 TCEQMAIN-16142 ARROYO COLORADO & CEMETERY RD True True True True True False True True False False False
229 TCEQMAIN-16143 ARROYO COLORADO UPSTR FM106 True True True True True False True True False False False
230 TCEQMAIN-16144 ARROYO COLORADO DWN CAMP PERRY True True True True True False True True False False False
231 TCEQMAIN-16145 ARROYO COLORADO 8KM U ARR CITY True True True True True False True True False False False
232 TCEQMAIN-16146 ARROYO COLORADO 4KM U ARR CITY True True True True True False True True False False False
233 TCEQMAIN-16147 ARROYO COLORADO 3KM D ARR CITY True True True True True False True True False False False
234 TCEQMAIN-16151 ARROYO COLORADO 31.1KM U MOUTH True True True True False False True True False False False
235 TCEQMAIN-16152 ARROYO COLO 27.116KM U MOUTH True True True True False False True True False False False
236 TCEQMAIN-16153 ARROYO COLO 22.409KM U MOUT True True True True False False True True False False False
237 TCEQMAIN-16154 ARROYO COLORADO 12.7KM U MOUTH True True True True False False True True False False False
238 TCEQMAIN-16155 ARROYO COLO 4.551KM U MOUTH True True True True True False True True False False False
239 TCEQMAIN-16270 LAND O LAKES RESACA False False False False False False False False False False False
240 TCEQMAIN-16285 LINCOLN PARK RESACA-SOUTHEAST False False False False False False False False False False False
241 TCEQMAIN-16286 FORT BROWN RESACA NORTHEAST False False False False False False False False False False False
242 TCEQMAIN-16287 RESACA DE LA PALMA False False False False False False False False False False False
243 TCEQMAIN-16288 RIO GRANDE RIVER AT SABAL PALM SANCTUARY True True True True True False True True False False False
244 TCEQMAIN-16440 TOWN RESACA AT BARNARD & SYCAM False False False False False False False False False False False
245 TCEQMAIN-16444 ARROYO COLORADO AT FM491 True True True True True False True True False False False
246 TCEQMAIN-16445 ARROYO COLORADO AT DILWORTH RD True True True True True False True True True False False
247 TCEQMAIN-16446 ARROYO COLORADO AT FM509 True True True True True False True True False False False
248 TCEQMAIN-17100 LAGUNA MADRE NEAR BOWIE PARK False True False False False False False False False False False
249 TCEQMAIN-17101 SOUTH BAY False True False False False False False False False False False
250 TCEQMAIN-17102 BROWNSVILLE SHIP CM38 False True False False False False False False False False False
251 TCEQMAIN-17111 DONNA POTW DISCHARGE DITCH True True True True True False True True False False False
252 TCEQMAIN-17112 MERCEDES POTW DISCHARGE DITCH True True True True True False True True False False False
253 TCEQMAIN-17113 DRAINAGE DITCH HARDING RANCH True True True True True False True True False False False
254 TCEQMAIN-17114 HIDALGO POTW OUTFALL True True True True True False True True False False False
255 TCEQMAIN-17115 MISSION POTW DISCHARGE DITCH True True True True True False True True False False False
256 TCEQMAIN-17117 LAGUNA MADRE NEAR ICWW CM 284 False True False False False False False False False False False
257 TCEQMAIN-17247 RIO GRANDE UPSTRM OF FM 1015 True True True True True False True True False False False
258 TCEQMAIN-17394 LA FERIA RES WEST OF FM 506 False False False False False False False False False False False
260 TCEQMAIN-17415 DONNA RES SITE PS False False False False False False False False False False False
261 TCEQMAIN-17416 DONNA RES SITE E False False False False False False False False False False False
262 TCEQMAIN-17642 DRAINAGE DITCH UPSTRM SOUTH RD True True True False False False False False True False False
263 TCEQMAIN-17643 DRAINAGE DITCH AT FM 1846 True True True False False False False False True False False
264 TCEQMAIN-17644 DRAINAGE DITCH AT FM 2062 True True True False False False False False True False False
265 TCEQMAIN-17650 ARROYO COLORADO TIDAL P OF HAR True True True False False False False False False False False
266 TCEQMAIN-17940 DELTA LK .4 KM UPSTREAM OF DAM False False False False False False False False False False False
267 TCEQMAIN-17975 LAGUNA MADRE TDH-SOU20 False True False False False False False False False False False
268 TCEQMAIN-18196 UNNAMED DITCH AT FM 510 True True True True True False True True True False False
269 TCEQMAIN-18485 ARROYO COLORADO AT VALLEY VIEW False False False False False False False False False False False
270 TCEQMAIN-18486 DONNA CANAL NR MILITARY/US 281 False False False False False False False False False False False
271 TCEQMAIN-18487 DONNA CANAL NR ARROYO SIPHON False False False False False False False False False False False
272 TCEQMAIN-18488 DONNA CANAL NR ARROYO SIPHON False False False False False False False False False False False
273 TCEQMAIN-18489 DONNA CANAL AT VALLEY VIEW RD False False False False False False False False False False False
274 TCEQMAIN-18490 DONNA RESERVOIR WEST MIDLAKE False False False False False False False False False False False
275 TCEQMAIN-20098 ARROYO COLORADO AT ARROYO CITY CAMS 0739 False False False False False False False False False False False
276 TCEQMAIN-20102 ARROYO COLORADO NORTH FLOODWAY AT LLANO GRANDE CAMS 0738 False False False False False False False False False False False
277 TCEQMAIN-20103 ARROYO COLORADO NEAR VALLEY VIEW CAMS 0740 False False False False False False False False False False False
278 TCEQMAIN-20104 RIO GRANDE WEST BANK AT HARDWICKE FARMS CAMS 0737 False False False False False False False False False False False
279 TCEQMAIN-20200 ARROYO COLORADO TIDAL NEAR PORT HARLINGEN False False False False False False False False False False False
280 TCEQMAIN-20449 RIO GRANDE RIVER AT BROWNSVILLE PUB WATER TREATMENT PLANT NUMBER 1 INTAKE BETWEEN WTP RESERVOIR AND RIO GRANDE LEVEE False False True True False False True False True False False
281 TCEQMAIN-20696 RIO GRANDE AT THE EL MORILLO TRACT OF THE LOWER RIO GRANDE VALLEY NATIONAL WILDLIFE REFUGE False False False False False False False False False False False
282 TCEQMAIN-20698 OLD RIO GRANDE MEANDER LA PARIDO BANCO NUMBER 144 BOAT RAMP True True True True True False True True False False False
283 TCEQMAIN-20737 RIO GRANDE RIVER 320 METERS UPSTREAM OF STATE LOOP 200 / BRAVO BOULEVARD CAMS 767 False False False False False False False False False False False
284 TCEQMAIN-20738 RIO GRANDE RIVER 2.816 KILOMETERS UPSTREAM OF PETE DIAZ AVENUE / BRIDGE AVENUE CAMS 781 False False False False False False False False False False False
285 TCEQMAIN-20739 RIO GRANDE RIVER 345 METERS WEST AND 70 METERS SOUTH FROM THE INTERSECTION OF KCTM FM ROAD 103 AND PATRIOT LANE CAMS 782 False False False False False False False False False False False
286 TCEQMAIN-20850 CITY OF MISSION WWTP False False False False False False True True False False False
287 TCEQMAIN-20851 CITY OF MCALLEN WWTP False False False False False False True True False False False
288 TCEQMAIN-20853 CITY OF PHARR WWTP False False False False False False True True False False False
289 TCEQMAIN-20854 CITY OF SAN JUAN WWTP False False False False False False True True False False False
290 TCEQMAIN-20855 SAN JUAN CONSTRUCTED WETLAND OUTFALL False False False False False False True True False False False
291 TCEQMAIN-20856 CITY OF ALAMO WWTP False False False False False False True True False False False
292 TCEQMAIN-20857 ARROYO COLORADO AT MHWSC BALLI ROAD WWTP False False False False False False True True False False False
293 TCEQMAIN-20858 CITY OF DONNA WWTP False False False False False False True True False False False
294 TCEQMAIN-20859 CITY OF WESLACO WWTP False False False False False False True True False False False
295 TCEQMAIN-20860 MHWSC PROGRESO WWTP False False False False False False True True False False False
296 TCEQMAIN-20861 CITY OF MERCEDES WWTP False False False False False False True True False False False
297 TCEQMAIN-20862 LA FERIA WWTP False False False False False False True True False False False
298 TCEQMAIN-20863 LA FERIA CONSTRUCTED WETLAND OUTFALL False False False False False False True True False False False
299 TCEQMAIN-20864 JOINES ROAD WWTP False False False False False False True True False False False
300 TCEQMAIN-20865 ARROYO COLORADO AT HARLINGEN WWTP False False False False False False True True False False False
301 TCEQMAIN-20866 SAN BENITO WWTP OUTFALL False False False False False False True True False False False
302 TCEQMAIN-20867 SAN BENITO CONSTRUCTED WETLAND OUTFALL False False False False False False True True False False False
303 TCEQMAIN-20868 CITY OF RIO HONDO WWTP False False False False False False True True False False False
304 TCEQMAIN-20869 EAST RIO HONDO LOZANO WWTP False False False False False False True True False False False
305 TCEQMAIN-20879 MCAULIFFE MIDDLE SCHOOL STORMWATER DETENTION FACILITY OUTLET False False True False False False True True False False False
306 TCEQMAIN-20901 MCALLEN DOG PARK DRAIN INLET AT TAMARACK AVENUE False False True False False False True True False False False
307 TCEQMAIN-20902 MCAULIFFE MIDDLE SCHOOL STORMWATER DETENTION FACILITY INLET False False True False False False True True False False False
308 TCEQMAIN-20903 MCALLEN DOG PARK DRAIN OUTLET AT TAMARACK AVENUE False False True False False False True True False False False
309 TCEQMAIN-20908 MORRIS MIDDLE SCHOOL STORMWATER DETENTION FACILITY INLET False False True False False False True True False False False
310 TCEQMAIN-20909 MORRIS MIDDLE SCHOOL STORMWATER DETENTION FACILITY OUTLET False False True False False False True True False False False
311 TCEQMAIN-20930 NORTH FLOODWAY AT US 77 True True True False True False True True False False False
312 TCEQMAIN-21012 RIO GRANDE RIVER OFF SHUERBACH ROAD CAMS 792 True True True True True False True True False False False
313 TCEQMAIN-21101 RIO GRANDE RIVER AT UNITED IRRIG DSTRCT MISSION TX CANAL False False False False False False False False False False False
314 TCEQMAIN-21120 LOWER LAGUNA MADRE SOUTH OF MOUTH OF ARROYO COLORADO True True True False True False True True False False False
315 TCEQMAIN-21121 LAGUNA MADRE APPROX 1.5 K WEST OF BAY SHORE OF SOUTH PADRE ISLAND True True True False False False True False False False False
316 TCEQMAIN-21122 SOUTH BAY SOUTH OF CUT AND WEST OF BRAZOS ISLAND True True True False False False True False False False False
317 TCEQMAIN-21194 UNNAMED DITCH WEST SIDE OF S RIVER ROAD True True True False False False True True False False False
318 TCEQMAIN-21195 UNMD DRAIN DITCH 0.98 KM SE OF MILE4 N AND FM491 True True True False False False True True False False False
319 TCEQMAIN-21509 OUT OF STREAM VNC-PSR AT VALLEY NATURE CENTER False False True False False False False False False False False
320 TCEQMAIN-21510 OUT OF STREAM VNC-PWT AT VALLEY NATURE CENTER False False True False False False False False False False False
321 TCEQMAIN-21511 OUT OF STREAM VNC-RHS 1 AT VALLEY NATURE CENTER False False False False False False False False False False False
322 TCEQMAIN-21512 OUT OF STREAM VNC-TW AT VALLEY NATURE CENTER False False False False False False False False False False False
323 TCEQMAIN-21522 RIO GRANDE RIVER 165 METERS UPSTREAM OF THE LAS FLORES PROGRESO INTERNATIONAL BRIDGE/FM 1015 False False True True False False True True False False False
324 TCEQMAIN-21523 RIO GRANDE RIVER DISCHARGE POINT ON US SIDE LEFT BANK 1.59 KILOMETERS SOUTH AND 720 METERS EAST FROM THE INTERSECTION OF MILITARY ROAD AND SHARYLAND ROAD AND SHARY ROAD False False True True False False True True False False False
325 TCEQMAIN-21524 RIO GRANDE RIVER STORM WATER DISCHARGE POINT ON US SIDE LEFT BANK 395 METERS WEST AND 50 METERS NORTH FROM THE INTERSECTION OF WEST COMA AVENUE AND EAST TEXANO DR/OLD MILITARY ROAD False False True True False False True True False False False
326 TCEQMAIN-21525 UNNAMED TRIBUTARY AT THE CONFLUENCE OF THE RIO GRANDE RIVER ON MEXICO SIDE 110 METERS NORTH AND 75 METERS EAST FROM THE INTERSECTION OF DEL BORDO AND 20 DE NOVIEMBRE False False True True False False True True False False False
327 TCEQMAIN-21526 RIO GRANDE RIVER DISCHARGE POINT ON US SIDE LEFT BANK 400 METERS DOWNSTREAM FROM EL ANHELO DRAIN False False True True False False True False False False False
328 TCEQMAIN-21527 EL ANHELO DRAIN AT CONFLUENCE OF THE RIO GRANDE RIVER False False True True False False True True False False False
329 TCEQMAIN-21528 RIO GRANDE RIVER RIO GRANDE CITY WWTP DISCHARGE WQ0010802-001 False False False True False False True True False False False
330 TCEQMAIN-21529 LOS OLMOS CREEK AT THE CONFLUENCE WITH THE RIO GRANDE RIVER False False False True False False True False False False False
331 TCEQMAIN-21536 OUT OF STREAM LA FERIA REC CENTER PERMEABLE PARKING LOT False False True False False False False False False False False
332 TCEQMAIN-21537 OUT OF STREAM LA FERIA REC CENTER TRADITIONAL PARKING LOT False False True False False False False False False False False
333 TCEQMAIN-21538 OUT OF STREAM LA FERIA REC CENTER RAIN GAUGE False False False False False False False False False False False
334 TCEQMAIN-21554 OUT OF STREAM VNC-RAIN GAUGE AT VALLEY NATURE CENTER False False False False False False False False False False False
335 TCEQMAIN-21573 RIO GRANDE DOWNSTREAM OF FALCON DAM False False False False False False False False False False False
336 TCEQMAIN-21591 ARROYO LOS OLMOS UPSTREAM OF RIO GRANDE True True True True True False True True False False False
337 TCEQMAIN-21592 RIO GRANDE AT DONNA PUMP False False False False False False False False False False False
338 TCEQMAIN-21593 RIO GRANDE AT SANTA MARIA PUMP False False False False False False False False False False False
339 TCEQMAIN-21602 RIO GRANDE RIVER SILAS RAY BROWNSVILLE POWER PLANT WQ0003096-000 False False False False False False False False False False False
340 TCEQMAIN-21603 RIO GRANDE RIVER BROWNSVILLE SOUTHSIDE WASTEWATER TREATMENT PLANT TPDES WQ0010397-003 False False False False False False False False False False False
341 TCEQMAIN-21604 RIO GRANDE RIVER PENITAS WASTEWATER TREATMENT PLANT WQ0014884-001 False False False False False False False False False False False
342 TCEQMAIN-21605 RIO GRANDE RIVER LA JOYA WASTEWATER TREATMENT FACILITY WQ0012675-001 False False False False False False False False False False False
343 TCEQMAIN-21606 RIO GRANDE RIVER LA JOYA WASTEWATER TREATMENT FACILITY OUTFALL WQ0012675-001 False False False False False False False False False False False
344 TCEQMAIN-21607 RIO GRANDE RIVER LA JOYA ISD WASTEWATER TREATMENT PLANT WQ0013523-006 False False False False False False False False False False False
345 TCEQMAIN-21608 RIO GRANDE RIVER AGUA SUD WASTEWATER TREATMENT PLANT OUTFALL WQ0014415-001 False False False False False False False False False False False
346 TCEQMAIN-21609 RIO GRANDE RIVER UNION WSC WASTEWATER TREATMENT PLANT WQ0014313-001 False False False False False False False False False False False
347 TCEQMAIN-21610 RIO GRANDE RIVER UNION WSC WASTEWATER TREATMENT PLANT WQ0014313-001 False False False False False False False False False False False
348 TCEQMAIN-21611 RIO GRANDE RIVER RIO GRANDE CITY WASTEWATER TREATMENT PLANT WQ0010802-001 False False False False False False False False False False False
349 TCEQMAIN-21612 RIO GRANDE RIVER ROMA WASTEWATER TREATMENT PLANT WQ0011212-002 False False False False False False False False False False False
350 TCEQMAIN-21613 RIO GRANDE RIVER ROMA WATER TREATMENT PLANT TPDES WQ0011212-003 False False False False False False False False False False False
351 TCEQMAIN-21749 RIO GRANDE APPROX 380 METERS DOWNSTREAM OF CONFLUENCE WITH LOS OLMOS CREEK True True True True True False True True False False False
352 TCEQMAIN-21944 TRADITIONAL PAVEMENT CORNER OF PECAN AND N 29TH ST MCALLEN False False True False False False True True False False False
353 TCEQMAIN-21945 BIOSWALE AT CORNER OF PECAN ST AND N 29TH ST False False True False False False True True False False False
354 TCEQMAIN-21966 OUT OF STREAM MONTE BELLA TRAIL PARK OUTFLOW IMPERVIOUS PARKINGLOT/TRADITIONAL PARKINGLOT False False True False False False False False False False False
355 TCEQMAIN-21967 OUT OF STREAM MONTE BELLA TRAIL PARK OUTFLOW PERVIOUS PARKINGLOT False False True False False False False False False False False
356 TCEQMAIN-21968 OUT OF STREAM MONTE BELLA TRAIL PARK INFLOW BIOSWALE AND RAIN GAUGE False False False False False False False False False False False
357 TCEQMAIN-21969 OUT OF STREAM MONTE BELLA TRAIL PARK OUTFLOW BIOSWALE False False False False False False False False False False False
358 TCEQMAIN-21970 OUT OF STREAM CASCADE PARK OUTFLOW PERVIOUS PARKINGLOT AND RAIN GAUGE False False True False False False False False False False False
359 TCEQMAIN-21971 OUT OF STREAM CASCADE PARK OUTFLOW BIOSWALE False False True False False False True True False False False
360 TCEQMAIN-21977 RIO GRANDE HARLINGEN ID 1 C789 False False False False False False False False False False False
361 TCEQMAIN-21979 SOUTH RIO RICO RD AT RIO GRANDE RIVER False False False False False False False False False False False
362 TCEQMAIN-21980 1.22 MILES DOWNSTREAM OF THE PETE DIAZ BRIDGE False False False False False False False False False False False
363 TCEQMAIN-21988 OUT OF STREAM MONTE BELLA TRAIL PARK OUTFLOW PERMEABLE WALKING TRAIL False False True False False False False False False False False
364 TCEQMAIN-21989 OUT OF STREAM WESLACO PUBLIC LIBRARY RAINWATER HARVESTING SYSTEM AND RAIN GAUGE False False False False False False False False False False False
365 TCEQMAIN-22003 HIDALGO MAIN FLOODWATER CHANNEL AT FM 1420 True True True True True False True True True False False
366 TCEQMAIN-22004 RAYMONDVILLE DRAIN AT WILLACY COUNTY ROAD 445 True True True True True False True True True False False
367 TCEQMAIN-22116 LAGUNA MADRE  NEAR SARGENT BEACH False False False False False False False False False False False
368 TCEQMAIN-22117 GULF OF MEXICO AT ISLA BLANCA PARK False False False False False False False False False False False
369 TCEQMAIN-22118 CAMERON COUNTY DRAINAGE DISTRICT NO.1 (CCDD1) DITCH NO. 2 AT OLD PORT ISABEL ROAD True True True False False False True True False False True
370 TCEQMAIN-22120 CAMERON COUNTY DRAINAGE DISTRICT NO.1 (CCDD1) DITCH NO.1 AT THE BROWNSVILLE PUBLIC WORKS DEPARTMENT True True True False False False True True False False True
371 TCEQMAIN-22121 CAMERON COUNTY DRAINAGE DISTRICT NO.1 (CCDD1) OLD MAIN DRAIN NO. 2 AT THE CITY OF BROWNSVILLE LANDFILL True True True False False False True True False False True
372 TCEQMAIN-22170 SAN MARTIN LAKE MID ESTUARY True True True True True False True True True False False
373 TCEQMAIN-22262 OUT OF STREAM LA ESQUINA COLONIA RIVER ROCK BIORETENTION INFLOW LOCATION IN LOS FRESNOS TEXAS False False False False False False False False False False False
374 TCEQMAIN-22263 OUT OF STREAM LA ESQUINA COLONIA RIVER ROCK BIORETENTION OUTFLOW LOCATION IN LOS FRESNOS TEXAS False False False False False False False False False False False
375 TCEQMAIN-22265 OUT OF STREAM LA ESQUINA COLONIA CONCRETE BIORETENTION INFLOW LOCATION IN LOS FRESNOS TEXAS False False False False False False False False False False False
376 TCEQMAIN-22266 OUT OF STREAM LA ESQUINA COLONIA CONCRETE BIORETENTION OUTFLOW LOCATION IN LOS FRESNOS TEXAS False False False False False False False False False False False
377 TCEQMAIN-22267 OUT OF STREAM PARKING LOT PUMICE BIOSWALE INFLOW AT UTRGV CAMPUS False False True False False False True True False False False
378 TCEQMAIN-22268 OUT OF STREAM PARKING LOT PUMICE BIOSWALE OUTFLOW AT UTRGV CAMPUS False False True False False False True True False False False
379 TCEQMAIN-22269 OUT OF STREAM PARKING LOT MANUFACTURED SAND BIOSWALE INFLOW AT UTRGV CAMPUS False False True False False False True True False False False
380 TCEQMAIN-22270 OUT OF STREAM PARKING LOT MANUFACTURED SAND BIOSWALE OUTFLOW AT UTRGV CAMPUS False False True False False False True True False False False
381 TCEQMAIN-22271 OUT OF STREAM PARKING LOT RECYCLED GLASS BIOSWALE INFLOW AT UTRGV CAMPUS False False False False False False False False False False False
382 TCEQMAIN-22272 OUT OF STREAM PARKING LOT RECYCLED GLASS BIOSWALE OUTFLOW AT UTRGV CAMPUS False False False False False False False False False False False
383 TCEQMAIN-22273 OUT OF STREAM PARKING LOT NATURAL SAND BIOSWALE INFLOW AT UTRGV CAMPUS False False False False False False False False False False False
384 TCEQMAIN-22274 OUT OF STREAM PARKING LOT NATURAL SAND BIOSWALE OUTFLOW AT UTRGV CAMPUS False False False False False False False False False False False
385 TCEQMAIN-22275 RADO ALTERNATE DRAINAGE CHANNEL AT VINE AVENUE AND WARRIOR DRIVE INTERSECTION IN HIDALGO COUNTY False False False False False False False False False False False
386 TCEQMAIN-22276 MISSION MCALLEN LATERAL DRAINAGE CHANNEL AT DAFFODIL AVENUE AND N BENTSEN ROAD INTERSECTION IN HIDALGO COUNTY False False False False False False False False False False False
387 TCEQMAIN-22277 MISSION LATERAL DRAINAGE DITCH CHANNEL AT 2911 NORTH TAYLOR ROAD IN HIDALGO COUNTY False False False False False False False False False False False
388 TCEQMAIN-22401 HACKNEY LAKE INLET AT SOUTH JACKSON ROAD True True False False True False True True False False False
389 TCEQMAIN-22402 RIO GRANDE RIVER BOAT LAUNCH AT HIDALGO CR 1598 False False False False True False True True False False False
390 TCEQMAIN-22404 RAYMONDVILLE DRAIN AT RODRIGUEZ RD False False False False False False False False False False False
391 TCEQMAIN-22636 RAYMONDVILLE DRAIN AT WEAVER RD False False False False False False False False False False False
392 TCEQMAIN-22638 HIDALGO WILLACY MAIN DRAIN AT FM 88 False False False False False False False False False False False
393 TCEQMAIN-22639 US-IBWC NORTH FLOODWAY AT FM 1425 False False False False False False False False False False False

Step 5 — Map stations by priority parameter

One colored layer per priority parameter, over the watershed outlines. Click a legend entry to hide/show that parameter’s layer.

Show code
PARAM_COLORS = categorical_colors(PRIORITY_NAMES)
watershed_outlines = gv.Path(watersheds_gdf).opts(color="black", line_width=1.5)

stations_param_map = gvts.EsriWorldTopo * watershed_outlines
for param in PRIORITY_NAMES:
    subset = stations_in_area[stations_in_area[param]]
    if len(subset) == 0:
        continue
    stations_param_map = stations_param_map * gv.Points(
        subset,
        vdims=["MonitoringLocationName", "MonitoringLocationIdentifier"],
        label=param,
    ).opts(color=PARAM_COLORS[param], size=7, line_color="white", tools=["hover"])

stations_param_map = stations_param_map.opts(
    data_aspect=1,
    title="TCEQ monitoring stations by priority parameter (click legend to toggle)",
    legend_position="right",
    hooks=[make_legend_clickable],
)
stations_param_map

Step 6 — Data availability

Record count + first/last date per station × priority group.

Show code
show(coverage(tceq_results, "datetime"))
monitoring_location_id priority_group n start end
0 TCEQMAIN-10249 chlorophyll 57 2005-04-11 2025-10-29
13 TCEQMAIN-13071 chlorophyll 63 2005-01-20 2025-10-21
20 TCEQMAIN-13072 chlorophyll 59 2005-02-03 2025-10-21
27 TCEQMAIN-13073 chlorophyll 60 2005-02-03 2025-10-21
34 TCEQMAIN-13074 chlorophyll 74 2005-02-03 2025-10-21
41 TCEQMAIN-13079 chlorophyll 52 2009-10-20 2023-08-08
50 TCEQMAIN-13080 chlorophyll 33 2009-10-20 2018-07-18
58 TCEQMAIN-13081 chlorophyll 68 2005-01-20 2025-10-29
68 TCEQMAIN-13084 chlorophyll 74 2005-01-25 2025-10-29
78 TCEQMAIN-13103 chlorophyll 31 2005-01-25 2023-04-26
85 TCEQMAIN-13104 chlorophyll 5 2016-04-18 2023-04-26
92 TCEQMAIN-13176 chlorophyll 27 2005-01-20 2023-10-25
99 TCEQMAIN-13177 chlorophyll 61 2005-04-28 2023-05-16
108 TCEQMAIN-13178 chlorophyll 14 2011-03-03 2016-07-25
116 TCEQMAIN-13179 chlorophyll 21 2011-03-07 2024-03-11
123 TCEQMAIN-13181 chlorophyll 70 2005-04-13 2023-05-16
130 TCEQMAIN-13184 chlorophyll 44 2010-12-15 2023-05-16
137 TCEQMAIN-13185 chlorophyll 53 2005-07-12 2023-04-26
144 TCEQMAIN-13186 chlorophyll 26 2001-03-14 2017-06-28
159 TCEQMAIN-13189 chlorophyll 32 2010-12-15 2022-06-28
167 TCEQMAIN-13285 chlorophyll 59 2006-06-08 2025-10-22
174 TCEQMAIN-13446 chlorophyll 48 2007-04-18 2025-10-22
181 TCEQMAIN-13447 chlorophyll 58 2005-02-03 2025-10-21
188 TCEQMAIN-13448 chlorophyll 54 2005-03-10 2025-07-29
195 TCEQMAIN-13449 chlorophyll 42 2005-03-10 2025-07-29
202 TCEQMAIN-13459 chlorophyll 46 2007-05-02 2025-10-22
209 TCEQMAIN-13460 chlorophyll 53 2005-03-29 2025-10-28
216 TCEQMAIN-13470 chlorophyll 39 2006-06-08 2020-01-30
223 TCEQMAIN-13559 chlorophyll 41 2005-02-03 2015-07-29
230 TCEQMAIN-13664 chlorophyll 59 2010-12-15 2023-05-16
237 TCEQMAIN-13782 chlorophyll 59 2005-02-03 2025-10-21
244 TCEQMAIN-14865 chlorophyll 42 2007-05-02 2025-10-22
251 TCEQMAIN-14870 chlorophyll 39 2008-02-28 2025-10-22
258 TCEQMAIN-14871 chlorophyll 43 2005-03-29 2025-10-28
265 TCEQMAIN-14872 chlorophyll 4 2017-09-19 2018-08-21
271 TCEQMAIN-14874 chlorophyll 4 2018-01-29 2018-08-21
277 TCEQMAIN-14875 chlorophyll 46 2005-03-29 2025-10-28
298 TCEQMAIN-15597 chlorophyll 1 1996-08-20 1996-08-20
302 TCEQMAIN-15808 chlorophyll 81 1998-04-22 2023-05-15
310 TCEQMAIN-15819 chlorophyll 1 1998-04-28 1998-04-28
317 TCEQMAIN-16131 chlorophyll 2 1998-06-16 1998-06-17
324 TCEQMAIN-16132 chlorophyll 2 1998-06-16 1998-06-17
331 TCEQMAIN-16133 chlorophyll 3 1998-06-16 1998-06-17
338 TCEQMAIN-16134 chlorophyll 3 1998-06-16 1998-06-17
345 TCEQMAIN-16135 chlorophyll 2 1998-06-16 1998-06-17
352 TCEQMAIN-16136 chlorophyll 3 1998-06-16 1998-06-17
359 TCEQMAIN-16137 chlorophyll 4 1998-06-16 1999-03-30
366 TCEQMAIN-16138 chlorophyll 3 1998-06-16 1998-06-17
373 TCEQMAIN-16139 chlorophyll 3 1998-06-16 1998-06-17
380 TCEQMAIN-16140 chlorophyll 3 1998-06-16 1998-06-17
387 TCEQMAIN-16141 chlorophyll 21 1998-06-16 2002-08-12
394 TCEQMAIN-16142 chlorophyll 3 1998-06-16 1999-03-30
401 TCEQMAIN-16143 chlorophyll 3 1998-06-16 1998-06-17
408 TCEQMAIN-16144 chlorophyll 3 1998-06-16 1998-06-17
415 TCEQMAIN-16145 chlorophyll 3 1998-06-16 1998-06-17
422 TCEQMAIN-16146 chlorophyll 3 1998-06-16 1998-06-17
429 TCEQMAIN-16147 chlorophyll 3 1998-06-16 1998-06-17
460 TCEQMAIN-16155 chlorophyll 1 1999-03-30 1999-03-30
467 TCEQMAIN-16288 chlorophyll 22 2004-01-29 2019-04-23
474 TCEQMAIN-16444 chlorophyll 1 1999-03-30 1999-03-30
481 TCEQMAIN-16445 chlorophyll 52 1999-03-30 2018-07-18
489 TCEQMAIN-16446 chlorophyll 2 1999-03-30 1999-03-30
499 TCEQMAIN-17111 chlorophyll 2 2001-01-29 2001-07-23
506 TCEQMAIN-17112 chlorophyll 7 2001-01-29 2001-08-20
513 TCEQMAIN-17113 chlorophyll 9 2001-01-15 2002-07-22
520 TCEQMAIN-17114 chlorophyll 9 2000-11-28 2001-08-06
527 TCEQMAIN-17115 chlorophyll 6 2000-11-28 2001-08-06
535 TCEQMAIN-17247 chlorophyll 57 2002-10-28 2025-10-29
558 TCEQMAIN-18196 chlorophyll 21 2004-01-20 2005-08-02
570 TCEQMAIN-20698 chlorophyll 2 2011-10-27 2012-02-22
633 TCEQMAIN-20930 chlorophyll 44 2011-11-03 2025-10-29
639 TCEQMAIN-21012 chlorophyll 34 2011-10-27 2025-10-29
646 TCEQMAIN-21120 chlorophyll 1 2011-09-20 2011-09-20
702 TCEQMAIN-21591 chlorophyll 10 2016-04-18 2023-04-26
709 TCEQMAIN-21749 chlorophyll 8 2016-07-20 2023-04-26
729 TCEQMAIN-22003 chlorophyll 23 2017-10-04 2024-04-25
737 TCEQMAIN-22004 chlorophyll 25 2017-10-04 2024-04-25
763 TCEQMAIN-22170 chlorophyll 14 2019-11-19 2023-08-08
783 TCEQMAIN-22401 chlorophyll 1 2022-11-16 2022-11-16
788 TCEQMAIN-22402 chlorophyll 1 2022-11-16 2022-11-16
1 TCEQMAIN-10249 conductivity 77 1993-01-14 2026-01-20
8 TCEQMAIN-13039 conductivity 29 2009-01-31 2011-11-29
14 TCEQMAIN-13071 conductivity 191 1998-08-18 2026-05-04
21 TCEQMAIN-13072 conductivity 236 2006-08-28 2026-05-04
28 TCEQMAIN-13073 conductivity 204 2007-08-29 2026-05-04
35 TCEQMAIN-13074 conductivity 134 2007-08-29 2026-05-04
42 TCEQMAIN-13079 conductivity 196 1986-11-20 2023-08-08
51 TCEQMAIN-13080 conductivity 46 2009-10-20 2018-07-18
59 TCEQMAIN-13081 conductivity 60 2006-08-09 2026-01-20
65 TCEQMAIN-13082 conductivity 12 1998-07-28 2015-05-05
69 TCEQMAIN-13084 conductivity 70 2007-07-18 2026-01-20
75 TCEQMAIN-13086 conductivity 10 2014-06-17 2015-05-05
79 TCEQMAIN-13103 conductivity 26 2011-04-12 2023-04-26
86 TCEQMAIN-13104 conductivity 8 2016-04-18 2023-04-26
93 TCEQMAIN-13176 conductivity 15 2000-11-28 2022-01-12
100 TCEQMAIN-13177 conductivity 194 1981-10-22 2023-05-16
109 TCEQMAIN-13178 conductivity 9 1981-10-22 2016-05-25
117 TCEQMAIN-13179 conductivity 15 2011-08-31 2024-03-11
124 TCEQMAIN-13181 conductivity 128 2000-11-29 2023-05-16
131 TCEQMAIN-13184 conductivity 251 1981-10-19 2023-05-16
138 TCEQMAIN-13185 conductivity 326 1981-10-19 2023-05-31
145 TCEQMAIN-13186 conductivity 41 2001-03-14 2016-09-29
151 TCEQMAIN-13188 conductivity 223 1981-10-19 2004-08-24
160 TCEQMAIN-13189 conductivity 35 1995-06-05 2022-06-28
168 TCEQMAIN-13285 conductivity 141 2007-09-26 2026-05-05
175 TCEQMAIN-13446 conductivity 214 2007-06-28 2026-05-05
182 TCEQMAIN-13447 conductivity 105 2007-05-29 2026-05-04
189 TCEQMAIN-13448 conductivity 78 2007-07-24 2026-02-17
196 TCEQMAIN-13449 conductivity 94 2007-07-24 2026-02-17
203 TCEQMAIN-13459 conductivity 202 2007-05-02 2026-05-05
210 TCEQMAIN-13460 conductivity 269 2006-06-08 2026-05-06
217 TCEQMAIN-13470 conductivity 224 2006-06-08 2019-11-06
224 TCEQMAIN-13559 conductivity 126 2002-05-22 2015-07-29
231 TCEQMAIN-13664 conductivity 267 1981-10-13 2023-05-16
238 TCEQMAIN-13782 conductivity 189 1998-08-18 2026-05-04
245 TCEQMAIN-14865 conductivity 82 2006-06-08 2026-05-05
252 TCEQMAIN-14870 conductivity 56 2007-06-28 2026-05-05
259 TCEQMAIN-14871 conductivity 238 2007-04-18 2026-05-06
266 TCEQMAIN-14872 conductivity 39 2017-09-19 2018-08-21
272 TCEQMAIN-14874 conductivity 36 2017-09-19 2018-08-21
278 TCEQMAIN-14875 conductivity 194 2007-04-18 2026-05-06
284 TCEQMAIN-15547 conductivity 15 2013-07-01 2013-08-19
289 TCEQMAIN-15552 conductivity 1 1996-08-20 1996-08-20
293 TCEQMAIN-15569 conductivity 16 2013-07-01 2013-08-20
303 TCEQMAIN-15808 conductivity 154 1998-01-28 2023-05-15
311 TCEQMAIN-15819 conductivity 1 1998-04-28 1998-04-28
318 TCEQMAIN-16131 conductivity 3 1998-06-16 1998-06-17
325 TCEQMAIN-16132 conductivity 3 1998-06-16 1998-06-17
332 TCEQMAIN-16133 conductivity 3 1998-06-16 1998-06-17
339 TCEQMAIN-16134 conductivity 3 1998-06-16 1998-06-17
346 TCEQMAIN-16135 conductivity 3 1998-06-16 1998-06-17
353 TCEQMAIN-16136 conductivity 3 1998-06-16 1998-06-17
360 TCEQMAIN-16137 conductivity 6 1998-06-16 1999-03-30
367 TCEQMAIN-16138 conductivity 3 1998-06-16 1998-06-17
374 TCEQMAIN-16139 conductivity 3 1998-06-16 1998-06-17
381 TCEQMAIN-16140 conductivity 3 1998-06-16 1998-06-17
388 TCEQMAIN-16141 conductivity 24 1998-06-16 2002-08-12
395 TCEQMAIN-16142 conductivity 19 1998-06-16 2013-08-19
402 TCEQMAIN-16143 conductivity 5 1998-06-16 1999-03-30
409 TCEQMAIN-16144 conductivity 5 1998-06-16 1999-03-30
416 TCEQMAIN-16145 conductivity 5 1998-06-16 1999-03-30
423 TCEQMAIN-16146 conductivity 5 1998-06-16 1999-03-30
430 TCEQMAIN-16147 conductivity 5 1998-06-16 1999-03-30
436 TCEQMAIN-16151 conductivity 2 1999-03-30 1999-03-30
442 TCEQMAIN-16152 conductivity 2 1999-03-30 1999-03-30
448 TCEQMAIN-16153 conductivity 2 1999-03-30 1999-03-30
454 TCEQMAIN-16154 conductivity 2 1999-03-30 1999-03-30
461 TCEQMAIN-16155 conductivity 2 1999-03-30 1999-03-30
468 TCEQMAIN-16288 conductivity 19 2003-10-23 2016-05-25
475 TCEQMAIN-16444 conductivity 3 1999-03-30 1999-03-30
482 TCEQMAIN-16445 conductivity 57 1999-03-30 2018-07-18
490 TCEQMAIN-16446 conductivity 3 1999-03-30 1999-03-30
500 TCEQMAIN-17111 conductivity 7 2000-12-11 2001-08-20
507 TCEQMAIN-17112 conductivity 7 2000-12-11 2001-08-20
514 TCEQMAIN-17113 conductivity 53 2001-01-15 2011-11-29
521 TCEQMAIN-17114 conductivity 7 2000-11-28 2001-08-06
528 TCEQMAIN-17115 conductivity 7 2000-11-28 2001-08-06
536 TCEQMAIN-17247 conductivity 77 2001-11-07 2026-01-20
542 TCEQMAIN-17642 conductivity 12 2002-08-26 2003-06-10
546 TCEQMAIN-17643 conductivity 13 2002-07-29 2003-07-17
550 TCEQMAIN-17644 conductivity 12 2002-07-29 2003-07-17
554 TCEQMAIN-17650 conductivity 56 2002-07-01 2003-10-01
559 TCEQMAIN-18196 conductivity 21 2004-01-20 2005-08-02
571 TCEQMAIN-20698 conductivity 2 2011-10-27 2012-02-22
634 TCEQMAIN-20930 conductivity 43 2011-11-03 2026-01-20
640 TCEQMAIN-21012 conductivity 37 2011-10-27 2026-01-20
647 TCEQMAIN-21120 conductivity 1 2011-09-20 2011-09-20
652 TCEQMAIN-21121 conductivity 2 2011-09-20 2011-09-20
656 TCEQMAIN-21122 conductivity 1 2011-09-20 2011-09-20
660 TCEQMAIN-21194 conductivity 35 2008-08-14 2011-11-29
665 TCEQMAIN-21195 conductivity 36 2008-08-14 2011-11-29
703 TCEQMAIN-21591 conductivity 10 2016-04-18 2023-04-26
710 TCEQMAIN-21749 conductivity 10 2016-04-18 2023-04-26
730 TCEQMAIN-22003 conductivity 39 2017-10-04 2024-04-25
738 TCEQMAIN-22004 conductivity 25 2017-10-04 2024-04-25
745 TCEQMAIN-22118 conductivity 10 2020-02-12 2022-07-13
751 TCEQMAIN-22120 conductivity 10 2020-02-11 2022-07-27
757 TCEQMAIN-22121 conductivity 10 2020-02-12 2022-07-27
764 TCEQMAIN-22170 conductivity 15 2019-11-19 2023-08-08
784 TCEQMAIN-22401 conductivity 1 2022-05-18 2022-05-18
2 TCEQMAIN-10249 dissolved_oxygen 72 1993-01-14 2026-01-20
9 TCEQMAIN-13039 dissolved_oxygen 40 2009-01-31 2011-11-29
15 TCEQMAIN-13071 dissolved_oxygen 199 1998-08-18 2026-05-04
22 TCEQMAIN-13072 dissolved_oxygen 238 2006-08-28 2026-05-04
29 TCEQMAIN-13073 dissolved_oxygen 212 2007-08-29 2026-05-04
36 TCEQMAIN-13074 dissolved_oxygen 141 2007-08-29 2026-05-04
43 TCEQMAIN-13079 dissolved_oxygen 267 1986-11-20 2023-08-08
52 TCEQMAIN-13080 dissolved_oxygen 46 2009-10-20 2018-07-18
60 TCEQMAIN-13081 dissolved_oxygen 54 2006-08-09 2026-01-20
66 TCEQMAIN-13082 dissolved_oxygen 12 1998-07-28 2015-05-05
70 TCEQMAIN-13084 dissolved_oxygen 65 2007-07-18 2026-01-20
76 TCEQMAIN-13086 dissolved_oxygen 10 2014-06-17 2015-05-05
80 TCEQMAIN-13103 dissolved_oxygen 50 2011-04-12 2023-04-26
87 TCEQMAIN-13104 dissolved_oxygen 15 2016-04-18 2023-04-26
94 TCEQMAIN-13176 dissolved_oxygen 33 2011-08-31 2023-10-25
101 TCEQMAIN-13177 dissolved_oxygen 364 1981-10-22 2023-05-16
110 TCEQMAIN-13178 dissolved_oxygen 22 1981-10-22 2016-07-25
118 TCEQMAIN-13179 dissolved_oxygen 26 2011-08-31 2024-03-11
125 TCEQMAIN-13181 dissolved_oxygen 112 2010-11-29 2023-05-16
132 TCEQMAIN-13184 dissolved_oxygen 83 2010-12-15 2023-05-16
139 TCEQMAIN-13185 dissolved_oxygen 140 2005-07-12 2023-05-31
146 TCEQMAIN-13186 dissolved_oxygen 44 2001-03-14 2017-11-28
152 TCEQMAIN-13188 dissolved_oxygen 60 1995-10-19 2004-08-24
161 TCEQMAIN-13189 dissolved_oxygen 58 1995-06-05 2022-06-28
169 TCEQMAIN-13285 dissolved_oxygen 145 2007-09-26 2026-05-05
176 TCEQMAIN-13446 dissolved_oxygen 203 2007-06-28 2026-05-05
183 TCEQMAIN-13447 dissolved_oxygen 111 2007-05-29 2026-05-04
190 TCEQMAIN-13448 dissolved_oxygen 87 2007-07-24 2026-02-17
197 TCEQMAIN-13449 dissolved_oxygen 101 2007-07-24 2026-02-17
204 TCEQMAIN-13459 dissolved_oxygen 212 2007-05-02 2026-05-05
211 TCEQMAIN-13460 dissolved_oxygen 267 2006-06-08 2026-05-06
218 TCEQMAIN-13470 dissolved_oxygen 233 2006-06-08 2019-11-06
225 TCEQMAIN-13559 dissolved_oxygen 131 2002-05-22 2015-07-29
232 TCEQMAIN-13664 dissolved_oxygen 99 2010-12-15 2023-05-16
239 TCEQMAIN-13782 dissolved_oxygen 194 1998-08-18 2026-05-04
246 TCEQMAIN-14865 dissolved_oxygen 82 2006-06-08 2026-05-05
253 TCEQMAIN-14870 dissolved_oxygen 56 2007-06-28 2026-05-05
260 TCEQMAIN-14871 dissolved_oxygen 235 2007-04-18 2026-05-06
267 TCEQMAIN-14872 dissolved_oxygen 39 2017-09-19 2018-08-21
273 TCEQMAIN-14874 dissolved_oxygen 36 2017-09-19 2018-08-21
279 TCEQMAIN-14875 dissolved_oxygen 193 2007-04-18 2026-05-06
285 TCEQMAIN-15547 dissolved_oxygen 15 2013-07-01 2013-08-19
290 TCEQMAIN-15552 dissolved_oxygen 2 1996-08-20 1996-08-20
294 TCEQMAIN-15569 dissolved_oxygen 16 2013-07-01 2013-08-20
299 TCEQMAIN-15597 dissolved_oxygen 1 1996-08-20 1996-08-20
304 TCEQMAIN-15808 dissolved_oxygen 190 1998-01-28 2023-05-15
312 TCEQMAIN-15819 dissolved_oxygen 1 1998-04-28 1998-04-28
319 TCEQMAIN-16131 dissolved_oxygen 3 1998-06-16 1998-06-17
326 TCEQMAIN-16132 dissolved_oxygen 3 1998-06-16 1998-06-17
333 TCEQMAIN-16133 dissolved_oxygen 3 1998-06-16 1998-06-17
340 TCEQMAIN-16134 dissolved_oxygen 3 1998-06-16 1998-06-17
347 TCEQMAIN-16135 dissolved_oxygen 3 1998-06-16 1998-06-17
354 TCEQMAIN-16136 dissolved_oxygen 3 1998-06-16 1998-06-17
361 TCEQMAIN-16137 dissolved_oxygen 6 1998-06-16 1999-03-30
368 TCEQMAIN-16138 dissolved_oxygen 3 1998-06-16 1998-06-17
375 TCEQMAIN-16139 dissolved_oxygen 3 1998-06-16 1998-06-17
382 TCEQMAIN-16140 dissolved_oxygen 3 1998-06-16 1998-06-17
389 TCEQMAIN-16141 dissolved_oxygen 24 1998-06-16 2002-08-12
396 TCEQMAIN-16142 dissolved_oxygen 19 1998-06-16 2013-08-19
403 TCEQMAIN-16143 dissolved_oxygen 5 1998-06-16 1999-03-30
410 TCEQMAIN-16144 dissolved_oxygen 5 1998-06-16 1999-03-30
417 TCEQMAIN-16145 dissolved_oxygen 5 1998-06-16 1999-03-30
424 TCEQMAIN-16146 dissolved_oxygen 5 1998-06-16 1999-03-30
431 TCEQMAIN-16147 dissolved_oxygen 5 1998-06-16 1999-03-30
437 TCEQMAIN-16151 dissolved_oxygen 2 1999-03-30 1999-03-30
443 TCEQMAIN-16152 dissolved_oxygen 2 1999-03-30 1999-03-30
449 TCEQMAIN-16153 dissolved_oxygen 2 1999-03-30 1999-03-30
455 TCEQMAIN-16154 dissolved_oxygen 2 1999-03-30 1999-03-30
462 TCEQMAIN-16155 dissolved_oxygen 2 1999-03-30 1999-03-30
469 TCEQMAIN-16288 dissolved_oxygen 32 2003-10-23 2019-04-23
476 TCEQMAIN-16444 dissolved_oxygen 3 1999-03-30 1999-03-30
483 TCEQMAIN-16445 dissolved_oxygen 57 1999-03-30 2018-07-18
491 TCEQMAIN-16446 dissolved_oxygen 3 1999-03-30 1999-03-30
501 TCEQMAIN-17111 dissolved_oxygen 8 2000-12-11 2001-08-20
508 TCEQMAIN-17112 dissolved_oxygen 8 2000-12-11 2001-08-20
515 TCEQMAIN-17113 dissolved_oxygen 69 2001-01-15 2011-11-29
522 TCEQMAIN-17114 dissolved_oxygen 8 2000-11-28 2001-08-06
529 TCEQMAIN-17115 dissolved_oxygen 8 2000-11-28 2001-08-06
537 TCEQMAIN-17247 dissolved_oxygen 73 2001-11-07 2026-01-20
543 TCEQMAIN-17642 dissolved_oxygen 12 2002-08-26 2003-06-10
547 TCEQMAIN-17643 dissolved_oxygen 13 2002-07-29 2003-07-17
551 TCEQMAIN-17644 dissolved_oxygen 12 2002-07-29 2003-07-17
555 TCEQMAIN-17650 dissolved_oxygen 56 2002-07-01 2003-10-01
560 TCEQMAIN-18196 dissolved_oxygen 21 2004-01-20 2005-08-02
566 TCEQMAIN-20449 dissolved_oxygen 171 2009-09-01 2025-05-13
572 TCEQMAIN-20698 dissolved_oxygen 1 2011-10-27 2011-10-27
615 TCEQMAIN-20879 dissolved_oxygen 6 2011-06-28 2012-05-04
618 TCEQMAIN-20901 dissolved_oxygen 1 2012-02-08 2012-02-08
621 TCEQMAIN-20902 dissolved_oxygen 6 2011-06-28 2012-05-04
624 TCEQMAIN-20903 dissolved_oxygen 1 2012-02-08 2012-02-08
627 TCEQMAIN-20908 dissolved_oxygen 4 2011-06-28 2012-05-04
630 TCEQMAIN-20909 dissolved_oxygen 4 2011-06-28 2012-05-04
635 TCEQMAIN-20930 dissolved_oxygen 40 2011-11-03 2026-01-20
641 TCEQMAIN-21012 dissolved_oxygen 33 2011-10-27 2026-01-20
648 TCEQMAIN-21120 dissolved_oxygen 1 2011-09-20 2011-09-20
653 TCEQMAIN-21121 dissolved_oxygen 2 2011-09-20 2011-09-20
657 TCEQMAIN-21122 dissolved_oxygen 1 2011-09-20 2011-09-20
661 TCEQMAIN-21194 dissolved_oxygen 46 2008-08-14 2011-11-29
666 TCEQMAIN-21195 dissolved_oxygen 45 2008-08-14 2011-11-29
670 TCEQMAIN-21509 dissolved_oxygen 7 2014-03-09 2014-11-12
671 TCEQMAIN-21510 dissolved_oxygen 6 2014-03-09 2015-03-09
672 TCEQMAIN-21522 dissolved_oxygen 1 2013-12-02 2013-12-02
676 TCEQMAIN-21523 dissolved_oxygen 1 2013-12-03 2013-12-03
680 TCEQMAIN-21524 dissolved_oxygen 1 2013-12-03 2013-12-03
684 TCEQMAIN-21525 dissolved_oxygen 1 2013-12-03 2013-12-03
688 TCEQMAIN-21526 dissolved_oxygen 1 2013-12-04 2013-12-04
691 TCEQMAIN-21527 dissolved_oxygen 1 2013-12-04 2013-12-04
700 TCEQMAIN-21536 dissolved_oxygen 11 2014-05-13 2016-05-20
701 TCEQMAIN-21537 dissolved_oxygen 11 2014-05-13 2016-05-20
704 TCEQMAIN-21591 dissolved_oxygen 20 2016-04-18 2023-04-26
711 TCEQMAIN-21749 dissolved_oxygen 15 2016-04-18 2023-04-26
716 TCEQMAIN-21944 dissolved_oxygen 9 2015-04-13 2016-05-31
719 TCEQMAIN-21945 dissolved_oxygen 5 2015-05-12 2016-05-31
722 TCEQMAIN-21966 dissolved_oxygen 3 2014-10-21 2014-11-11
723 TCEQMAIN-21967 dissolved_oxygen 4 2014-10-21 2014-11-11
724 TCEQMAIN-21970 dissolved_oxygen 5 2014-10-22 2015-06-09
725 TCEQMAIN-21971 dissolved_oxygen 3 2014-10-22 2014-11-13
728 TCEQMAIN-21988 dissolved_oxygen 4 2014-10-21 2014-11-11
731 TCEQMAIN-22003 dissolved_oxygen 39 2017-10-04 2024-04-25
739 TCEQMAIN-22004 dissolved_oxygen 25 2017-10-04 2024-04-25
746 TCEQMAIN-22118 dissolved_oxygen 9 2020-02-12 2022-07-13
752 TCEQMAIN-22120 dissolved_oxygen 10 2020-02-11 2022-07-27
758 TCEQMAIN-22121 dissolved_oxygen 9 2020-02-12 2022-07-27
765 TCEQMAIN-22170 dissolved_oxygen 15 2019-11-19 2023-08-08
771 TCEQMAIN-22267 dissolved_oxygen 1 2022-04-26 2022-04-26
774 TCEQMAIN-22268 dissolved_oxygen 2 2021-12-20 2022-04-26
777 TCEQMAIN-22269 dissolved_oxygen 1 2022-04-26 2022-04-26
780 TCEQMAIN-22270 dissolved_oxygen 2 2021-12-20 2022-04-26
3 TCEQMAIN-10249 dissolved_solids 35 1993-01-14 2011-05-26
16 TCEQMAIN-13071 dissolved_solids 24 2005-01-20 2011-05-04
23 TCEQMAIN-13072 dissolved_solids 31 2005-02-03 2013-08-19
30 TCEQMAIN-13073 dissolved_solids 25 2005-02-03 2011-05-10
37 TCEQMAIN-13074 dissolved_solids 32 2005-02-03 2013-08-19
44 TCEQMAIN-13079 dissolved_solids 195 1986-11-20 2023-08-08
53 TCEQMAIN-13080 dissolved_solids 26 2009-10-20 2018-07-18
61 TCEQMAIN-13081 dissolved_solids 23 2005-01-20 2011-05-11
71 TCEQMAIN-13084 dissolved_solids 23 2005-01-25 2011-05-11
81 TCEQMAIN-13103 dissolved_solids 40 2005-01-25 2023-04-26
88 TCEQMAIN-13104 dissolved_solids 7 2016-04-18 2023-04-26
95 TCEQMAIN-13176 dissolved_solids 30 2005-01-20 2024-03-11
102 TCEQMAIN-13177 dissolved_solids 232 1981-10-22 2023-05-16
111 TCEQMAIN-13178 dissolved_solids 17 1981-10-22 2016-07-25
119 TCEQMAIN-13179 dissolved_solids 27 2011-03-07 2024-03-11
126 TCEQMAIN-13181 dissolved_solids 93 2005-04-13 2023-05-16
133 TCEQMAIN-13184 dissolved_solids 84 1981-10-19 2023-05-16
140 TCEQMAIN-13185 dissolved_solids 119 1981-10-19 2023-04-26
147 TCEQMAIN-13186 dissolved_solids 39 2001-03-14 2017-11-28
153 TCEQMAIN-13188 dissolved_solids 79 1981-10-19 2004-08-24
162 TCEQMAIN-13189 dissolved_solids 37 1995-06-05 2022-06-28
170 TCEQMAIN-13285 dissolved_solids 27 2005-03-31 2011-03-01
177 TCEQMAIN-13446 dissolved_solids 23 2003-06-17 2011-03-01
184 TCEQMAIN-13447 dissolved_solids 24 2003-05-14 2011-05-04
191 TCEQMAIN-13448 dissolved_solids 25 2003-01-08 2011-03-10
198 TCEQMAIN-13449 dissolved_solids 24 2002-09-26 2011-03-10
205 TCEQMAIN-13459 dissolved_solids 23 2002-03-28 2011-03-01
212 TCEQMAIN-13460 dissolved_solids 21 2003-07-02 2011-03-01
219 TCEQMAIN-13470 dissolved_solids 18 2005-03-31 2011-03-01
226 TCEQMAIN-13559 dissolved_solids 26 2005-02-03 2013-08-19
233 TCEQMAIN-13664 dissolved_solids 97 1981-10-13 2023-05-16
240 TCEQMAIN-13782 dissolved_solids 21 2005-02-03 2011-05-04
247 TCEQMAIN-14865 dissolved_solids 22 2003-09-08 2011-03-01
254 TCEQMAIN-14870 dissolved_solids 21 2005-03-31 2011-03-01
261 TCEQMAIN-14871 dissolved_solids 20 2003-09-08 2011-03-01
280 TCEQMAIN-14875 dissolved_solids 19 2002-03-28 2011-03-01
286 TCEQMAIN-15547 dissolved_solids 3 2013-07-01 2013-08-19
295 TCEQMAIN-15569 dissolved_solids 6 2013-07-01 2013-08-20
305 TCEQMAIN-15808 dissolved_solids 161 1998-01-28 2023-05-15
313 TCEQMAIN-15819 dissolved_solids 1 1998-04-28 1998-04-28
320 TCEQMAIN-16131 dissolved_solids 3 1998-06-16 1998-06-17
327 TCEQMAIN-16132 dissolved_solids 3 1998-06-16 1998-06-17
334 TCEQMAIN-16133 dissolved_solids 3 1998-06-16 1998-06-17
341 TCEQMAIN-16134 dissolved_solids 3 1998-06-16 1998-06-17
348 TCEQMAIN-16135 dissolved_solids 3 1998-06-16 1998-06-17
355 TCEQMAIN-16136 dissolved_solids 3 1998-06-16 1998-06-17
362 TCEQMAIN-16137 dissolved_solids 6 1998-06-16 1999-03-30
369 TCEQMAIN-16138 dissolved_solids 3 1998-06-16 1998-06-17
376 TCEQMAIN-16139 dissolved_solids 3 1998-06-16 1998-06-17
383 TCEQMAIN-16140 dissolved_solids 3 1998-06-16 1998-06-17
390 TCEQMAIN-16141 dissolved_solids 24 1998-06-16 2002-08-12
397 TCEQMAIN-16142 dissolved_solids 10 1998-06-16 2013-08-19
404 TCEQMAIN-16143 dissolved_solids 5 1998-06-16 1999-03-30
411 TCEQMAIN-16144 dissolved_solids 5 1998-06-16 1999-03-30
418 TCEQMAIN-16145 dissolved_solids 5 1998-06-16 1999-03-30
425 TCEQMAIN-16146 dissolved_solids 5 1998-06-16 1999-03-30
432 TCEQMAIN-16147 dissolved_solids 5 1998-06-16 1999-03-30
438 TCEQMAIN-16151 dissolved_solids 2 1999-03-30 1999-03-30
444 TCEQMAIN-16152 dissolved_solids 2 1999-03-30 1999-03-30
450 TCEQMAIN-16153 dissolved_solids 2 1999-03-30 1999-03-30
456 TCEQMAIN-16154 dissolved_solids 2 1999-03-30 1999-03-30
463 TCEQMAIN-16155 dissolved_solids 2 1999-03-30 1999-03-30
470 TCEQMAIN-16288 dissolved_solids 25 2003-10-23 2019-04-23
477 TCEQMAIN-16444 dissolved_solids 3 1999-03-30 1999-03-30
484 TCEQMAIN-16445 dissolved_solids 50 1999-03-30 2018-07-18
492 TCEQMAIN-16446 dissolved_solids 3 1999-03-30 1999-03-30
502 TCEQMAIN-17111 dissolved_solids 9 2000-12-11 2001-08-20
509 TCEQMAIN-17112 dissolved_solids 9 2000-12-11 2001-08-20
516 TCEQMAIN-17113 dissolved_solids 17 2001-01-15 2002-08-12
523 TCEQMAIN-17114 dissolved_solids 9 2000-11-28 2001-08-06
530 TCEQMAIN-17115 dissolved_solids 9 2000-11-28 2001-08-06
538 TCEQMAIN-17247 dissolved_solids 34 2001-11-07 2011-05-11
561 TCEQMAIN-18196 dissolved_solids 21 2004-01-20 2005-08-02
567 TCEQMAIN-20449 dissolved_solids 143 2009-09-01 2025-05-13
573 TCEQMAIN-20698 dissolved_solids 2 2011-10-27 2012-02-22
642 TCEQMAIN-21012 dissolved_solids 2 2011-10-27 2012-02-22
673 TCEQMAIN-21522 dissolved_solids 1 2013-12-02 2013-12-02
677 TCEQMAIN-21523 dissolved_solids 1 2013-12-03 2013-12-03
681 TCEQMAIN-21524 dissolved_solids 1 2013-12-03 2013-12-03
685 TCEQMAIN-21525 dissolved_solids 1 2013-12-03 2013-12-03
689 TCEQMAIN-21526 dissolved_solids 1 2013-12-04 2013-12-04
692 TCEQMAIN-21527 dissolved_solids 1 2013-12-04 2013-12-04
695 TCEQMAIN-21528 dissolved_solids 1 2013-12-06 2013-12-06
698 TCEQMAIN-21529 dissolved_solids 1 2013-12-06 2013-12-06
705 TCEQMAIN-21591 dissolved_solids 13 2016-04-18 2023-04-26
712 TCEQMAIN-21749 dissolved_solids 15 2016-04-18 2023-04-26
732 TCEQMAIN-22003 dissolved_solids 24 2017-10-04 2024-04-25
740 TCEQMAIN-22004 dissolved_solids 24 2017-10-04 2024-04-25
766 TCEQMAIN-22170 dissolved_solids 14 2019-11-19 2023-02-14
4 TCEQMAIN-10249 nitrogen 181 2000-10-16 2025-10-29
10 TCEQMAIN-13039 nitrogen 85 2009-01-31 2011-11-29
17 TCEQMAIN-13071 nitrogen 162 2005-01-20 2025-10-21
24 TCEQMAIN-13072 nitrogen 162 2005-02-03 2025-10-21
31 TCEQMAIN-13073 nitrogen 162 2005-02-03 2025-10-21
38 TCEQMAIN-13074 nitrogen 205 2005-02-03 2025-10-21
45 TCEQMAIN-13079 nitrogen 798 1986-11-20 2023-08-08
54 TCEQMAIN-13080 nitrogen 88 2009-10-20 2018-07-18
62 TCEQMAIN-13081 nitrogen 189 2005-01-20 2025-10-29
72 TCEQMAIN-13084 nitrogen 197 2005-01-25 2025-10-29
82 TCEQMAIN-13103 nitrogen 55 2005-01-25 2023-04-26
89 TCEQMAIN-13104 nitrogen 10 2016-04-18 2023-04-26
96 TCEQMAIN-13176 nitrogen 38 2005-01-20 2022-01-12
103 TCEQMAIN-13177 nitrogen 602 1981-10-22 2023-05-16
112 TCEQMAIN-13178 nitrogen 31 1981-10-22 2016-05-25
120 TCEQMAIN-13179 nitrogen 33 2011-03-07 2024-03-11
127 TCEQMAIN-13181 nitrogen 121 2005-04-13 2023-05-16
134 TCEQMAIN-13184 nitrogen 78 2010-12-15 2023-05-16
141 TCEQMAIN-13185 nitrogen 174 2005-07-12 2023-04-26
148 TCEQMAIN-13186 nitrogen 48 2001-03-14 2017-11-28
154 TCEQMAIN-13188 nitrogen 176 1995-10-19 2004-08-24
163 TCEQMAIN-13189 nitrogen 32 1995-06-05 2022-01-03
171 TCEQMAIN-13285 nitrogen 62 2005-03-31 2025-10-22
178 TCEQMAIN-13446 nitrogen 60 2003-06-17 2025-10-22
185 TCEQMAIN-13447 nitrogen 125 2003-05-14 2025-10-21
192 TCEQMAIN-13448 nitrogen 83 2003-01-08 2025-07-29
199 TCEQMAIN-13449 nitrogen 49 2002-09-26 2025-07-29
206 TCEQMAIN-13459 nitrogen 61 2002-03-28 2025-10-22
213 TCEQMAIN-13460 nitrogen 79 2003-07-02 2025-10-28
220 TCEQMAIN-13470 nitrogen 38 2005-03-31 2019-07-31
227 TCEQMAIN-13559 nitrogen 116 2005-02-03 2015-07-29
234 TCEQMAIN-13664 nitrogen 96 2010-12-15 2023-05-16
241 TCEQMAIN-13782 nitrogen 149 2005-02-03 2025-10-21
248 TCEQMAIN-14865 nitrogen 52 2003-09-08 2025-10-22
255 TCEQMAIN-14870 nitrogen 60 2005-03-31 2025-10-22
262 TCEQMAIN-14871 nitrogen 91 2003-09-08 2025-10-28
268 TCEQMAIN-14872 nitrogen 8 2017-09-19 2018-08-21
274 TCEQMAIN-14874 nitrogen 8 2017-09-19 2018-08-21
281 TCEQMAIN-14875 nitrogen 80 2002-03-28 2025-10-28
300 TCEQMAIN-15597 nitrogen 3 1996-08-20 1996-08-20
306 TCEQMAIN-15808 nitrogen 239 1998-01-28 2023-05-15
314 TCEQMAIN-15819 nitrogen 2 1998-04-28 1998-04-28
321 TCEQMAIN-16131 nitrogen 9 1998-06-16 1998-06-17
328 TCEQMAIN-16132 nitrogen 9 1998-06-16 1998-06-17
335 TCEQMAIN-16133 nitrogen 9 1998-06-16 1998-06-17
342 TCEQMAIN-16134 nitrogen 9 1998-06-16 1998-06-17
349 TCEQMAIN-16135 nitrogen 9 1998-06-16 1998-06-17
356 TCEQMAIN-16136 nitrogen 9 1998-06-16 1998-06-17
363 TCEQMAIN-16137 nitrogen 18 1998-06-16 1999-03-30
370 TCEQMAIN-16138 nitrogen 9 1998-06-16 1998-06-17
377 TCEQMAIN-16139 nitrogen 9 1998-06-16 1998-06-17
384 TCEQMAIN-16140 nitrogen 7 1998-06-16 1998-06-17
391 TCEQMAIN-16141 nitrogen 86 1998-06-16 2002-08-12
398 TCEQMAIN-16142 nitrogen 12 1998-06-16 1999-03-30
405 TCEQMAIN-16143 nitrogen 15 1998-06-16 1999-03-30
412 TCEQMAIN-16144 nitrogen 15 1998-06-16 1999-03-30
419 TCEQMAIN-16145 nitrogen 15 1998-06-16 1999-03-30
426 TCEQMAIN-16146 nitrogen 14 1998-06-16 1999-03-30
433 TCEQMAIN-16147 nitrogen 13 1998-06-16 1999-03-30
439 TCEQMAIN-16151 nitrogen 6 1999-03-30 1999-03-30
445 TCEQMAIN-16152 nitrogen 6 1999-03-30 1999-03-30
451 TCEQMAIN-16153 nitrogen 5 1999-03-30 1999-03-30
457 TCEQMAIN-16154 nitrogen 6 1999-03-30 1999-03-30
464 TCEQMAIN-16155 nitrogen 6 1999-03-30 1999-03-30
471 TCEQMAIN-16288 nitrogen 51 2003-10-23 2019-04-23
478 TCEQMAIN-16444 nitrogen 9 1999-03-30 1999-03-30
485 TCEQMAIN-16445 nitrogen 179 1999-03-30 2018-07-18
493 TCEQMAIN-16446 nitrogen 9 1999-03-30 1999-03-30
503 TCEQMAIN-17111 nitrogen 42 2000-12-11 2001-08-20
510 TCEQMAIN-17112 nitrogen 31 2000-12-11 2001-08-20
517 TCEQMAIN-17113 nitrogen 132 2001-01-15 2011-11-29
524 TCEQMAIN-17114 nitrogen 80 2000-11-28 2011-08-11
531 TCEQMAIN-17115 nitrogen 45 2000-11-28 2001-08-06
539 TCEQMAIN-17247 nitrogen 202 2001-11-07 2025-10-29
562 TCEQMAIN-18196 nitrogen 56 2004-01-20 2005-08-02
568 TCEQMAIN-20449 nitrogen 57 2010-01-05 2023-11-15
574 TCEQMAIN-20698 nitrogen 4 2011-10-27 2012-02-22
577 TCEQMAIN-20850 nitrogen 38 2010-09-27 2011-08-11
579 TCEQMAIN-20851 nitrogen 45 2010-09-27 2011-08-11
581 TCEQMAIN-20853 nitrogen 38 2010-09-27 2011-08-11
583 TCEQMAIN-20854 nitrogen 30 2010-09-27 2011-08-11
585 TCEQMAIN-20855 nitrogen 45 2010-09-27 2011-08-11
587 TCEQMAIN-20856 nitrogen 53 2010-09-27 2011-08-11
589 TCEQMAIN-20857 nitrogen 42 2010-09-27 2011-08-11
591 TCEQMAIN-20858 nitrogen 50 2010-09-27 2011-08-11
593 TCEQMAIN-20859 nitrogen 35 2010-09-27 2011-08-11
595 TCEQMAIN-20860 nitrogen 52 2010-09-27 2011-08-11
597 TCEQMAIN-20861 nitrogen 33 2010-09-27 2011-08-11
599 TCEQMAIN-20862 nitrogen 31 2010-09-27 2011-08-11
601 TCEQMAIN-20863 nitrogen 7 2010-12-13 2011-03-28
603 TCEQMAIN-20864 nitrogen 37 2010-09-29 2011-08-11
605 TCEQMAIN-20865 nitrogen 41 2010-09-29 2011-08-11
607 TCEQMAIN-20866 nitrogen 32 2010-09-27 2011-08-11
609 TCEQMAIN-20867 nitrogen 39 2010-11-22 2011-08-11
611 TCEQMAIN-20868 nitrogen 36 2010-09-29 2011-07-18
613 TCEQMAIN-20869 nitrogen 32 2010-09-29 2011-08-11
616 TCEQMAIN-20879 nitrogen 9 2011-06-28 2012-05-04
619 TCEQMAIN-20901 nitrogen 1 2012-02-08 2012-02-08
622 TCEQMAIN-20902 nitrogen 11 2011-06-28 2012-05-04
625 TCEQMAIN-20903 nitrogen 2 2012-02-08 2012-02-08
628 TCEQMAIN-20908 nitrogen 5 2011-06-28 2012-05-04
631 TCEQMAIN-20909 nitrogen 5 2011-06-28 2012-05-04
636 TCEQMAIN-20930 nitrogen 114 2011-11-03 2025-10-29
643 TCEQMAIN-21012 nitrogen 75 2011-10-27 2025-10-29
649 TCEQMAIN-21120 nitrogen 3 2011-09-20 2011-09-20
654 TCEQMAIN-21121 nitrogen 1 2011-09-20 2011-09-20
658 TCEQMAIN-21122 nitrogen 2 2011-09-20 2011-09-20
662 TCEQMAIN-21194 nitrogen 98 2008-08-14 2011-11-29
667 TCEQMAIN-21195 nitrogen 101 2008-08-14 2011-11-29
674 TCEQMAIN-21522 nitrogen 2 2013-12-02 2013-12-02
678 TCEQMAIN-21523 nitrogen 1 2013-12-03 2013-12-03
682 TCEQMAIN-21524 nitrogen 2 2013-12-03 2013-12-03
686 TCEQMAIN-21525 nitrogen 2 2013-12-03 2013-12-03
690 TCEQMAIN-21526 nitrogen 2 2013-12-04 2013-12-04
693 TCEQMAIN-21527 nitrogen 2 2013-12-04 2013-12-04
696 TCEQMAIN-21528 nitrogen 2 2013-12-06 2013-12-06
699 TCEQMAIN-21529 nitrogen 1 2013-12-06 2013-12-06
706 TCEQMAIN-21591 nitrogen 14 2016-04-18 2023-04-26
713 TCEQMAIN-21749 nitrogen 18 2016-04-18 2023-04-26
717 TCEQMAIN-21944 nitrogen 6 2016-05-18 2016-06-25
720 TCEQMAIN-21945 nitrogen 7 2015-05-12 2016-06-25
726 TCEQMAIN-21971 nitrogen 2 2014-10-22 2014-11-06
733 TCEQMAIN-22003 nitrogen 68 2017-10-04 2024-04-25
741 TCEQMAIN-22004 nitrogen 69 2017-10-04 2024-04-25
747 TCEQMAIN-22118 nitrogen 13 2020-02-12 2022-07-13
753 TCEQMAIN-22120 nitrogen 16 2020-02-11 2022-07-27
759 TCEQMAIN-22121 nitrogen 11 2020-02-12 2022-07-27
767 TCEQMAIN-22170 nitrogen 27 2019-11-19 2023-08-08
772 TCEQMAIN-22267 nitrogen 2 2022-01-21 2022-04-26
775 TCEQMAIN-22268 nitrogen 3 2021-12-20 2022-04-26
778 TCEQMAIN-22269 nitrogen 2 2022-01-21 2022-04-26
781 TCEQMAIN-22270 nitrogen 3 2021-12-20 2022-04-26
785 TCEQMAIN-22401 nitrogen 2 2022-11-16 2022-11-16
789 TCEQMAIN-22402 nitrogen 3 2022-11-16 2022-11-16
5 TCEQMAIN-10249 phosphorus 102 2000-10-16 2025-10-29
11 TCEQMAIN-13039 phosphorus 57 2009-01-31 2011-11-29
18 TCEQMAIN-13071 phosphorus 80 2005-01-20 2025-10-21
25 TCEQMAIN-13072 phosphorus 84 2005-02-03 2025-10-21
32 TCEQMAIN-13073 phosphorus 78 2005-02-03 2025-10-21
39 TCEQMAIN-13074 phosphorus 96 2005-02-03 2025-10-21
46 TCEQMAIN-13079 phosphorus 489 1986-11-20 2023-08-08
55 TCEQMAIN-13080 phosphorus 45 2009-10-20 2018-07-18
63 TCEQMAIN-13081 phosphorus 82 2005-01-20 2025-10-29
73 TCEQMAIN-13084 phosphorus 90 2005-01-25 2025-10-29
83 TCEQMAIN-13103 phosphorus 42 2005-01-25 2023-04-26
90 TCEQMAIN-13104 phosphorus 7 2016-04-18 2023-04-26
97 TCEQMAIN-13176 phosphorus 31 2005-01-20 2024-03-11
104 TCEQMAIN-13177 phosphorus 402 1981-10-22 2023-05-16
113 TCEQMAIN-13178 phosphorus 11 1981-10-22 2016-03-30
121 TCEQMAIN-13179 phosphorus 22 2012-03-28 2024-03-11
128 TCEQMAIN-13181 phosphorus 46 2005-04-13 2023-05-16
135 TCEQMAIN-13184 phosphorus 33 2012-04-03 2023-05-16
142 TCEQMAIN-13185 phosphorus 72 2005-07-12 2023-04-26
149 TCEQMAIN-13186 phosphorus 11 2001-03-14 2015-05-28
155 TCEQMAIN-13188 phosphorus 115 1995-10-19 2004-08-24
164 TCEQMAIN-13189 phosphorus 17 1995-06-05 2022-06-28
172 TCEQMAIN-13285 phosphorus 35 2005-03-31 2025-10-22
179 TCEQMAIN-13446 phosphorus 38 2005-03-31 2025-10-22
186 TCEQMAIN-13447 phosphorus 64 2003-05-14 2025-10-21
193 TCEQMAIN-13448 phosphorus 41 2003-01-08 2025-07-29
200 TCEQMAIN-13449 phosphorus 31 2003-03-05 2025-07-29
207 TCEQMAIN-13459 phosphorus 38 2002-03-28 2025-10-22
214 TCEQMAIN-13460 phosphorus 40 2003-07-02 2025-10-28
221 TCEQMAIN-13470 phosphorus 22 2005-03-31 2019-11-06
228 TCEQMAIN-13559 phosphorus 61 2005-02-03 2015-07-29
235 TCEQMAIN-13664 phosphorus 36 2011-05-24 2023-05-16
242 TCEQMAIN-13782 phosphorus 76 2005-02-03 2025-10-21
249 TCEQMAIN-14865 phosphorus 26 2005-03-29 2025-10-22
256 TCEQMAIN-14870 phosphorus 24 2005-12-28 2025-10-22
263 TCEQMAIN-14871 phosphorus 38 2005-03-29 2025-10-28
269 TCEQMAIN-14872 phosphorus 5 2017-09-19 2018-08-21
275 TCEQMAIN-14874 phosphorus 5 2017-09-19 2018-08-21
282 TCEQMAIN-14875 phosphorus 47 2002-03-28 2025-10-28
287 TCEQMAIN-15547 phosphorus 3 2013-07-01 2013-08-19
296 TCEQMAIN-15569 phosphorus 6 2013-07-01 2013-08-20
301 TCEQMAIN-15597 phosphorus 2 1996-08-20 1996-08-20
307 TCEQMAIN-15808 phosphorus 142 1998-01-28 2023-05-15
315 TCEQMAIN-15819 phosphorus 2 1998-04-28 1998-04-28
322 TCEQMAIN-16131 phosphorus 6 1998-06-16 1998-06-17
329 TCEQMAIN-16132 phosphorus 6 1998-06-16 1998-06-17
336 TCEQMAIN-16133 phosphorus 6 1998-06-16 1998-06-17
343 TCEQMAIN-16134 phosphorus 6 1998-06-16 1998-06-17
350 TCEQMAIN-16135 phosphorus 6 1998-06-16 1998-06-17
357 TCEQMAIN-16136 phosphorus 6 1998-06-16 1998-06-17
364 TCEQMAIN-16137 phosphorus 9 1998-06-16 1999-03-30
371 TCEQMAIN-16138 phosphorus 6 1998-06-16 1998-06-17
378 TCEQMAIN-16139 phosphorus 6 1998-06-16 1998-06-17
385 TCEQMAIN-16140 phosphorus 6 1998-06-16 1998-06-17
392 TCEQMAIN-16141 phosphorus 61 1998-06-16 2002-08-12
399 TCEQMAIN-16142 phosphorus 13 1998-06-16 2013-08-19
406 TCEQMAIN-16143 phosphorus 10 1998-06-16 1999-03-30
413 TCEQMAIN-16144 phosphorus 10 1998-06-16 1999-03-30
420 TCEQMAIN-16145 phosphorus 8 1998-06-16 1999-03-30
427 TCEQMAIN-16146 phosphorus 8 1998-06-16 1999-03-30
434 TCEQMAIN-16147 phosphorus 8 1998-06-16 1999-03-30
440 TCEQMAIN-16151 phosphorus 3 1999-03-30 1999-03-30
446 TCEQMAIN-16152 phosphorus 2 1999-03-30 1999-03-30
452 TCEQMAIN-16153 phosphorus 2 1999-03-30 1999-03-30
458 TCEQMAIN-16154 phosphorus 2 1999-03-30 1999-03-30
465 TCEQMAIN-16155 phosphorus 2 1999-03-30 1999-03-30
472 TCEQMAIN-16288 phosphorus 32 2003-10-23 2019-04-23
479 TCEQMAIN-16444 phosphorus 6 1999-03-30 1999-03-30
486 TCEQMAIN-16445 phosphorus 105 1999-03-30 2018-07-18
494 TCEQMAIN-16446 phosphorus 6 1999-03-30 1999-03-30
504 TCEQMAIN-17111 phosphorus 27 2000-12-11 2001-08-20
511 TCEQMAIN-17112 phosphorus 27 2000-12-11 2001-08-20
518 TCEQMAIN-17113 phosphorus 89 2001-01-15 2011-11-29
525 TCEQMAIN-17114 phosphorus 69 2000-11-28 2011-08-11
532 TCEQMAIN-17115 phosphorus 27 2000-11-28 2001-08-06
540 TCEQMAIN-17247 phosphorus 95 2001-11-07 2025-10-29
563 TCEQMAIN-18196 phosphorus 24 2004-01-20 2005-08-02
575 TCEQMAIN-20698 phosphorus 1 2011-10-27 2011-10-27
578 TCEQMAIN-20850 phosphorus 40 2010-09-27 2011-08-11
580 TCEQMAIN-20851 phosphorus 41 2010-09-27 2011-08-11
582 TCEQMAIN-20853 phosphorus 46 2010-09-27 2011-08-11
584 TCEQMAIN-20854 phosphorus 39 2010-09-27 2011-08-11
586 TCEQMAIN-20855 phosphorus 40 2010-09-27 2011-08-11
588 TCEQMAIN-20856 phosphorus 36 2010-09-27 2011-08-11
590 TCEQMAIN-20857 phosphorus 44 2010-09-27 2011-08-11
592 TCEQMAIN-20858 phosphorus 38 2010-09-27 2011-08-11
594 TCEQMAIN-20859 phosphorus 47 2010-09-27 2011-08-11
596 TCEQMAIN-20860 phosphorus 38 2010-09-27 2011-08-11
598 TCEQMAIN-20861 phosphorus 44 2010-09-27 2011-08-11
600 TCEQMAIN-20862 phosphorus 30 2010-09-27 2011-08-11
602 TCEQMAIN-20863 phosphorus 4 2010-12-13 2011-03-28
604 TCEQMAIN-20864 phosphorus 42 2010-09-29 2011-08-11
606 TCEQMAIN-20865 phosphorus 41 2010-09-29 2011-08-11
608 TCEQMAIN-20866 phosphorus 43 2010-09-27 2011-08-11
610 TCEQMAIN-20867 phosphorus 25 2010-11-22 2011-08-11
612 TCEQMAIN-20868 phosphorus 35 2010-09-29 2011-08-11
614 TCEQMAIN-20869 phosphorus 34 2010-09-29 2011-08-04
617 TCEQMAIN-20879 phosphorus 6 2011-06-28 2012-05-04
620 TCEQMAIN-20901 phosphorus 1 2012-02-08 2012-02-08
623 TCEQMAIN-20902 phosphorus 6 2011-06-28 2012-05-04
626 TCEQMAIN-20903 phosphorus 1 2012-02-08 2012-02-08
629 TCEQMAIN-20908 phosphorus 4 2011-06-28 2012-05-04
632 TCEQMAIN-20909 phosphorus 4 2011-06-28 2012-05-04
637 TCEQMAIN-20930 phosphorus 41 2012-02-23 2025-10-29
644 TCEQMAIN-21012 phosphorus 30 2013-11-12 2025-10-29
650 TCEQMAIN-21120 phosphorus 1 2011-09-20 2011-09-20
663 TCEQMAIN-21194 phosphorus 68 2008-08-14 2011-11-29
668 TCEQMAIN-21195 phosphorus 71 2008-08-14 2011-11-29
675 TCEQMAIN-21522 phosphorus 1 2013-12-02 2013-12-02
679 TCEQMAIN-21523 phosphorus 1 2013-12-03 2013-12-03
683 TCEQMAIN-21524 phosphorus 1 2013-12-03 2013-12-03
687 TCEQMAIN-21525 phosphorus 1 2013-12-03 2013-12-03
694 TCEQMAIN-21527 phosphorus 1 2013-12-04 2013-12-04
697 TCEQMAIN-21528 phosphorus 1 2013-12-06 2013-12-06
707 TCEQMAIN-21591 phosphorus 7 2016-07-20 2023-04-26
714 TCEQMAIN-21749 phosphorus 7 2019-01-23 2023-04-26
718 TCEQMAIN-21944 phosphorus 6 2016-05-18 2016-06-25
721 TCEQMAIN-21945 phosphorus 7 2015-05-12 2016-06-25
727 TCEQMAIN-21971 phosphorus 3 2014-10-22 2014-11-13
734 TCEQMAIN-22003 phosphorus 25 2017-10-04 2024-04-25
742 TCEQMAIN-22004 phosphorus 24 2017-10-04 2024-04-25
748 TCEQMAIN-22118 phosphorus 8 2020-02-12 2022-07-13
754 TCEQMAIN-22120 phosphorus 8 2020-02-11 2022-07-27
760 TCEQMAIN-22121 phosphorus 8 2020-02-12 2022-07-27
768 TCEQMAIN-22170 phosphorus 13 2019-11-19 2023-08-08
773 TCEQMAIN-22267 phosphorus 4 2021-12-20 2022-04-26
776 TCEQMAIN-22268 phosphorus 4 2021-12-20 2022-04-26
779 TCEQMAIN-22269 phosphorus 4 2021-12-20 2022-04-26
782 TCEQMAIN-22270 phosphorus 4 2021-12-20 2022-04-26
786 TCEQMAIN-22401 phosphorus 1 2022-11-16 2022-11-16
790 TCEQMAIN-22402 phosphorus 1 2022-11-16 2022-11-16
6 TCEQMAIN-10249 temperature 79 1993-01-14 2026-01-20
12 TCEQMAIN-13039 temperature 29 2009-01-31 2011-11-29
19 TCEQMAIN-13071 temperature 208 1998-08-18 2026-05-04
26 TCEQMAIN-13072 temperature 257 2006-08-28 2026-05-04
33 TCEQMAIN-13073 temperature 218 2007-08-29 2026-05-04
40 TCEQMAIN-13074 temperature 144 2007-08-29 2026-05-04
47 TCEQMAIN-13079 temperature 249 1986-11-20 2023-08-08
56 TCEQMAIN-13080 temperature 80 2009-10-20 2018-07-18
64 TCEQMAIN-13081 temperature 61 2006-08-09 2026-01-20
67 TCEQMAIN-13082 temperature 12 1998-07-28 2015-05-05
74 TCEQMAIN-13084 temperature 71 2007-07-18 2026-01-20
77 TCEQMAIN-13086 temperature 10 2014-06-17 2015-05-05
84 TCEQMAIN-13103 temperature 72 2011-04-12 2023-04-26
91 TCEQMAIN-13104 temperature 24 2016-04-18 2023-04-26
98 TCEQMAIN-13176 temperature 47 2000-11-28 2024-03-11
105 TCEQMAIN-13177 temperature 319 1981-10-22 2023-05-16
114 TCEQMAIN-13178 temperature 25 1981-10-22 2016-07-25
122 TCEQMAIN-13179 temperature 48 2011-08-31 2024-03-11
129 TCEQMAIN-13181 temperature 233 2000-11-29 2023-05-16
136 TCEQMAIN-13184 temperature 324 1981-10-19 2023-05-16
143 TCEQMAIN-13185 temperature 455 1981-10-19 2023-05-31
150 TCEQMAIN-13186 temperature 91 2001-03-14 2017-11-28
156 TCEQMAIN-13188 temperature 222 1981-10-19 2004-08-24
165 TCEQMAIN-13189 temperature 77 1995-06-05 2022-06-28
173 TCEQMAIN-13285 temperature 152 2007-09-26 2026-05-05
180 TCEQMAIN-13446 temperature 221 2007-06-28 2026-05-05
187 TCEQMAIN-13447 temperature 117 2007-05-29 2026-05-04
194 TCEQMAIN-13448 temperature 87 2007-07-24 2026-02-17
201 TCEQMAIN-13449 temperature 101 2007-07-24 2026-02-17
208 TCEQMAIN-13459 temperature 218 2007-05-02 2026-05-05
215 TCEQMAIN-13460 temperature 275 2006-06-08 2026-05-06
222 TCEQMAIN-13470 temperature 241 2006-06-08 2019-11-06
229 TCEQMAIN-13559 temperature 138 2002-05-22 2015-07-29
236 TCEQMAIN-13664 temperature 356 1981-10-13 2023-05-16
243 TCEQMAIN-13782 temperature 206 1998-08-18 2026-05-04
250 TCEQMAIN-14865 temperature 87 2006-06-08 2026-05-05
257 TCEQMAIN-14870 temperature 59 2007-06-28 2026-05-05
264 TCEQMAIN-14871 temperature 240 2007-04-18 2026-05-06
270 TCEQMAIN-14872 temperature 39 2017-09-19 2018-08-21
276 TCEQMAIN-14874 temperature 36 2017-09-19 2018-08-21
283 TCEQMAIN-14875 temperature 197 2007-04-18 2026-05-06
288 TCEQMAIN-15547 temperature 15 2013-07-01 2013-08-19
291 TCEQMAIN-15552 temperature 1 1996-08-20 1996-08-20
297 TCEQMAIN-15569 temperature 16 2013-07-01 2013-08-20
308 TCEQMAIN-15808 temperature 291 1998-01-28 2023-05-15
316 TCEQMAIN-15819 temperature 1 1998-04-28 1998-04-28
323 TCEQMAIN-16131 temperature 3 1998-06-16 1998-06-17
330 TCEQMAIN-16132 temperature 3 1998-06-16 1998-06-17
337 TCEQMAIN-16133 temperature 3 1998-06-16 1998-06-17
344 TCEQMAIN-16134 temperature 3 1998-06-16 1998-06-17
351 TCEQMAIN-16135 temperature 3 1998-06-16 1998-06-17
358 TCEQMAIN-16136 temperature 3 1998-06-16 1998-06-17
365 TCEQMAIN-16137 temperature 6 1998-06-16 1999-03-30
372 TCEQMAIN-16138 temperature 3 1998-06-16 1998-06-17
379 TCEQMAIN-16139 temperature 3 1998-06-16 1998-06-17
386 TCEQMAIN-16140 temperature 3 1998-06-16 1998-06-17
393 TCEQMAIN-16141 temperature 24 1998-06-16 2002-08-12
400 TCEQMAIN-16142 temperature 19 1998-06-16 2013-08-19
407 TCEQMAIN-16143 temperature 5 1998-06-16 1999-03-30
414 TCEQMAIN-16144 temperature 5 1998-06-16 1999-03-30
421 TCEQMAIN-16145 temperature 5 1998-06-16 1999-03-30
428 TCEQMAIN-16146 temperature 5 1998-06-16 1999-03-30
435 TCEQMAIN-16147 temperature 5 1998-06-16 1999-03-30
441 TCEQMAIN-16151 temperature 2 1999-03-30 1999-03-30
447 TCEQMAIN-16152 temperature 2 1999-03-30 1999-03-30
453 TCEQMAIN-16153 temperature 2 1999-03-30 1999-03-30
459 TCEQMAIN-16154 temperature 2 1999-03-30 1999-03-30
466 TCEQMAIN-16155 temperature 2 1999-03-30 1999-03-30
473 TCEQMAIN-16288 temperature 39 2003-10-23 2019-04-23
480 TCEQMAIN-16444 temperature 3 1999-03-30 1999-03-30
487 TCEQMAIN-16445 temperature 92 1999-03-30 2018-07-18
495 TCEQMAIN-16446 temperature 3 1999-03-30 1999-03-30
496 TCEQMAIN-17100 temperature 56 1996-04-25 2005-03-23
497 TCEQMAIN-17101 temperature 55 1996-04-25 2005-03-23
498 TCEQMAIN-17102 temperature 56 1996-04-25 2005-03-23
505 TCEQMAIN-17111 temperature 8 2000-12-11 2001-08-20
512 TCEQMAIN-17112 temperature 8 2000-12-11 2001-08-20
519 TCEQMAIN-17113 temperature 53 2001-01-15 2011-11-29
526 TCEQMAIN-17114 temperature 8 2000-11-28 2001-08-06
533 TCEQMAIN-17115 temperature 8 2000-11-28 2001-08-06
534 TCEQMAIN-17117 temperature 54 1996-04-24 2005-03-23
541 TCEQMAIN-17247 temperature 79 2001-11-07 2026-01-20
544 TCEQMAIN-17642 temperature 24 2002-08-26 2003-06-10
548 TCEQMAIN-17643 temperature 26 2002-07-29 2003-07-17
552 TCEQMAIN-17644 temperature 24 2002-07-29 2003-07-17
556 TCEQMAIN-17650 temperature 56 2002-07-01 2003-10-01
557 TCEQMAIN-17975 temperature 26 2002-05-10 2005-03-23
564 TCEQMAIN-18196 temperature 42 2004-01-20 2005-08-02
576 TCEQMAIN-20698 temperature 4 2011-10-27 2012-02-22
638 TCEQMAIN-20930 temperature 45 2011-11-03 2026-01-20
645 TCEQMAIN-21012 temperature 40 2011-10-27 2026-01-20
651 TCEQMAIN-21120 temperature 1 2011-09-20 2011-09-20
655 TCEQMAIN-21121 temperature 2 2011-09-20 2011-09-20
659 TCEQMAIN-21122 temperature 1 2011-09-20 2011-09-20
664 TCEQMAIN-21194 temperature 34 2008-08-14 2011-11-29
669 TCEQMAIN-21195 temperature 36 2008-08-14 2011-11-29
708 TCEQMAIN-21591 temperature 26 2016-04-18 2023-04-26
715 TCEQMAIN-21749 temperature 29 2016-04-18 2023-04-26
735 TCEQMAIN-22003 temperature 64 2017-10-04 2024-04-25
743 TCEQMAIN-22004 temperature 50 2017-10-04 2024-04-25
749 TCEQMAIN-22118 temperature 10 2020-02-12 2022-07-13
755 TCEQMAIN-22120 temperature 11 2020-02-11 2022-07-27
761 TCEQMAIN-22121 temperature 10 2020-02-12 2022-07-27
769 TCEQMAIN-22170 temperature 30 2019-11-19 2023-08-08
787 TCEQMAIN-22401 temperature 1 2022-05-18 2022-05-18
7 TCEQMAIN-10249 turbidity 2 1993-01-14 2005-08-04
48 TCEQMAIN-13079 turbidity 180 1986-11-20 2023-08-08
57 TCEQMAIN-13080 turbidity 66 2009-10-20 2018-07-18
106 TCEQMAIN-13177 turbidity 101 1981-10-22 2000-08-16
115 TCEQMAIN-13178 turbidity 2 1981-10-22 1981-12-02
157 TCEQMAIN-13188 turbidity 22 1995-10-19 2001-04-18
166 TCEQMAIN-13189 turbidity 1 1995-06-05 1995-06-05
292 TCEQMAIN-15552 turbidity 1 1996-08-20 1996-08-20
309 TCEQMAIN-15808 turbidity 1 2000-06-20 2000-06-20
488 TCEQMAIN-16445 turbidity 66 2009-10-20 2018-07-18
545 TCEQMAIN-17642 turbidity 12 2002-08-26 2003-06-10
549 TCEQMAIN-17643 turbidity 12 2002-07-29 2003-07-17
553 TCEQMAIN-17644 turbidity 12 2002-07-29 2003-07-17
565 TCEQMAIN-18196 turbidity 42 2004-01-20 2005-08-02
569 TCEQMAIN-20449 turbidity 107 2011-02-01 2025-05-13
736 TCEQMAIN-22003 turbidity 28 2017-10-04 2024-04-25
744 TCEQMAIN-22004 turbidity 28 2017-10-04 2024-04-25
770 TCEQMAIN-22170 turbidity 15 2019-11-19 2023-08-08
49 TCEQMAIN-13079 water_level 35 2000-11-29 2004-07-20
107 TCEQMAIN-13177 water_level 17 2002-05-29 2004-09-08
158 TCEQMAIN-13188 water_level 24 2001-01-22 2004-08-24
750 TCEQMAIN-22118 water_level 9 2020-02-12 2022-07-13
756 TCEQMAIN-22120 water_level 10 2020-02-11 2022-07-27
762 TCEQMAIN-22121 water_level 10 2020-02-12 2022-07-27
Show code
tceq_year = tceq_results.assign(year=pd.to_datetime(tceq_results["datetime"]).dt.year)
availability = tceq_year.groupby(["monitoring_location_id", "year"]).size().reset_index(name="records")
availability.hvplot.heatmap(
    x="year", y="monitoring_location_id", C="records", cmap="blues",
    title="TCEQ result availability (count per station-year)", colorbar=True, rot=45,
)

Step 8 — Export to Excel

Compiles all three saved tables into a single downloadable workbook — one sheet each, frozen header row + first column, with autofilter enabled on the header.

Show code
save_workbook(
    {
        "tceq_monitoring_locations": stations_in_area,
        "tceq_results": tceq_results,
        "tceq_trends": tceq_trends,
    },
    S.data_dir / "tceq_waterquality" / "tceq_waterquality.xlsx",
)
saved 3 sheet(s) → data/tceq_waterquality/tceq_waterquality.xlsx

What’s next

TCEQ results, station inventory, and trends are saved under data/tceq_waterquality/. Notebook 5_twdb_waterdata covers TWDB groundwater; a future shared display notebook can compare trends across USGS/TCEQ/TWDB side by side.

Back to top