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 - Hydrology

e3xf-jwmjEnvironment9 columns
Routine stream monitoring results from 1987-Present.
View on NYC Open Data↗

Quality

B85.3 / 100

From a 500-row sample across 7 columns.

completeness97/ 25% weight
consistency86/ 20% weight
accuracy85/ 20% weight
timeliness53/ 15% weight
usability95/ 20% weight

Related datasets

  • Watershed Water Quality - Wastewater0.75
    joins onfinal_resultsample_idanalyte+2
  • Watershed Water Quality - Keypoint0.75
    joins onsample_datefinal_resultsample_id+5
  • Watershed Water Quality - Limnology0.73
    joins onsample_datefinal_resultsample_id+4
  • Watershed Water Quality - Hydrology Qualifiers0.59
    joins onsample_datesample_idanalyte+1

Sample rows

sample_idsample_sitesample_dateanalytefinal_resultunitsstream_group
E-94988DIVERTR1987-01-05T00:00:00.000Alkalinity61.3mg/LEast Branch
C-199439E13I1987-01-05T00:00:00.000Iron, Total0.06mg/LEsopus
C-195825BK1987-01-05T00:00:00.000

Columns

9 queryable · 9 profiled

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

FieldTypeDescriptionNullValues
sample_idtextLaboratory sample identifier0%E-1901638-03E-1901638-07E-1901638-04
sample_sitetextName of sampling site0%CBSE16IMB-1
sample_datedatetimeDate of sample collection0%2001-04-02T00:00:00.0002001-07-02T00:00:00.0001999-07-12T00:00:00.000
sample_timetextTime sample was collected24%10:0010:5010:40

Query this from your own app

GET /api/datasets/e3xf-jwmj
GET /api/datasets/e3xf-jwmj/quality
GET /api/datasets/e3xf-jwmj/related
GET /api/columns?dataset=e3xf-jwmj
Watershed Water Quality - Limnology Qualifiers0.57
joins onsample_datesample_idanalyte+1
  • Watershed Water Quality - Sites0.51
    joins onsample_site
  • Watershed Water Quality - Wastewater Qualifiers0.48
    joins onsample_datesample_idanalyte+1
  • Water and Sewer Permits0.35
  • Iron, Total
    0.01
    mg/L
    Esopus
    C-182099LBK1987-01-05T00:00:00.000Iron, Total0.07mg/LEsopus
    E-96871MIDDLEBRR1987-01-05T00:00:00.000Alkalinity48.7mg/LEOH Hydrology
    E-97121MUSCOOTR1987-01-05T00:00:00.000Alkalinity49.4mg/LEOH Hydrology
    C-198134E10I1987-01-05T00:00:00.000Iron, Total<0.01mg/LEsopus
    C-189020SCL1987-01-05T00:00:00.000Iron, Total<0.01mg/LEsopus
    E-94988DIVERTR1987-01-05T00:00:00.000Apparent Color35CUEast Branch
    C-199439E13I1987-01-05T00:00:00.000Apparent Color11CUEsopus
    analyte
    text
    Component or chemical substance tested for
    0%
    TurbidityTemperaturepH
    statuscategoricalIndicates result status including Done (no issues), Warning (results are reportable, but may indicate a sampling or analytical issue), Cancel (not analyzed), and Failure (data not reportable).80%DoneWarningCancelof 5
    final_resulttextFinal result produced from testing0%Error0<1
    unitstextUnits of final result produced from the test collected8%mg/Lµg/LNTU
    stream_groupcategoricalStream or river network used for grouping sampling sites0%CannonsvilleEsopusPepactonof 16