Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Watershed Water Quality Data

y43c-5n92Environment10 columns
Data collected to fulfill the requirements of the SWTR (Surface Water Treatment Rule) and FAD (Filtration Avoidance Determination). Data is collected via grab sampling, analysis, LIMS data capture and reporting. Each record represents either a four hour turbidity result, a 24 hour average turbidty result, or a daily fecal coliform result from DEL18DT (Delaware Shaft 18 downtake). Data is used to monitor compliance with the requirements above. There are no limitations for the data.
View on NYC Open Data↗

Quality

A90.9 / 100

From a 500-row sample across 10 columns.

completeness100/ 25% weight
consistency60/ 20% weight
accuracy99/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Drinking Water Quality Distribution Monitoring Data0.44
  • Water and Sewer Permits0.35
  • Water and Sewer Permits (Historic)0.33
  • DSNY Litter Basket Inventory0.32
  • Watershed Water Quality - Limnology0.31
    joins onsite
  • Urban Park Ranger Animal Condition Response0.31
  • DSNY Special Waste Drop-off Sites0.30

Sample rows

sitedateturbidity_ntu_at_12amturbidity_ntu_at_4amturbidity_ntu_at_8amturbidity_ntu_at_12pmturbidity_ntu_at_4pmturbidity_ntu_at_8pmaverage_24hrturbidity_ntucoliform_fecal_fc_100ml
DEL18DT2026-04-30T00:00:00.0000.750.710.770.750.690.90.76<1
DEL18DT2026-04-29T00:00:00.0000.770.7

Columns

10 queryable · 10 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
sitetextAqueduct site DEL18DT0%DEL18DTof 1
datedatetimeCalendar date0%2019-03-23T00:00:00.0002015-06-30T00:00:00.0002018-03-22T00:00:00.000
turbidity_ntu_at_12amfloatTurbidity result for the respective 4 hour grab sample0%0.750.80.7
turbidity_ntu_at_4amfloatTurbidity result for the respective 4 hour grab sample0%0.80.70.75

Query this from your own app

GET /api/datasets/y43c-5n92
GET /api/datasets/y43c-5n92/quality
GET /api/datasets/y43c-5n92/related
GET /api/columns?dataset=y43c-5n92
Watershed Water Quality - Keypoint
0.30
0.68
0.69
0.69
0.71
0.71
E1
DEL18DT2026-04-28T00:00:00.0000.760.730.70.650.710.680.71E2
DEL18DT2026-04-27T00:00:00.0000.650.680.70.610.70.770.69E1
DEL18DT2026-04-26T00:00:00.0000.70.740.760.70.630.630.69E1
DEL18DT2026-04-25T00:00:00.0000.70.760.690.720.820.720.74<1
DEL18DT2026-04-24T00:00:00.0000.70.870.750.750.710.780.76<1
DEL18DT2026-04-23T00:00:00.0000.760.730.760.820.770.710.76E1
DEL18DT2026-04-22T00:00:00.0000.780.770.910.810.740.730.79E1
DEL18DT2026-04-21T00:00:00.0000.760.70.760.710.680.750.73<1
turbidity_ntu_at_8am
float
—
0%
0.750.70.8
turbidity_ntu_at_12pmfloatTurbidity result for the respective 4 hour grab sample0%0.750.70.8
turbidity_ntu_at_4pmfloatTurbidity result for the respective 4 hour grab sample0%0.750.70.8
turbidity_ntu_at_8pmfloatTurbidity result for the respective 4 hour grab sample0%0.750.70.8
average_24hrturbidity_ntufloatAverage turbidity of the six 4 hour grab samples0%0.780.730.83
coliform_fecal_fc_100mltextDaily fecal coliform result0%<1E1E2