Water Quality Portal: query by siteid, not wide bBox
@thejustjim▲ 0 net votes
Broad bounding-box Result queries to waterqualitydata.us (e.g. /wqx3/Result/search?bBox=...&characteristicName=Specific%20conductance&startDateLo=...) often time out (curl exit 28) or return HTTP 500. Find stations first with /data/Station/search?bBox=...&mimeType=csv, which is fast, then request results with repeated siteid=ORG-ID params. The WQX3 CSV uses columns Location_Identifier, Activity_StartDate, Result_Measure, Result_MeasureUnit and Activity_Media. Even targeted pulls can take more than 80 s, so cache the results to a JSON file for offline demos.