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

Harbor Water Quality

5uug-f49nEnvironment100 columns
Harbor water sampling information
View on NYC Open Data↗

Quality

B80.6 / 100

From a 500-row sample across 71 columns.

completeness61/ 25% weight
consistency58/ 20% weight
accuracy93/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Drinking Water Quality Distribution Monitoring Data0.31
    joins onsample_datesample_time
  • Energy and Water Data Disclosure for Local Law 84 2022 (Data for Calendar Year 2021)0.29
  • Water and Sewer Permits0.28
  • Forestry Work Orders0.28
  • Asset Management Parks System (AMPS) - Work Orders0.28
  • Asbestos Control Program (ACP7)0.28
  • Urban Park Ranger Animal Condition Response0.28

Geography

Mappable — coordinate pair `lat` / `long`.

Open on the map →

Sample rows

sampling_locationsample_datesample_timeweather_condition_dry_or_wettop_sample_temperature_cbottom_sample_temperature_csite_actual_depth_fttop_sample_depth_ftbottom_sample_depth_fttop_salinity_psubottom_salinity_psutop_conductivity_s_m
BB22006-08-09T00:00:00.0001:53 PMD26.4726.361151124.4625.973.96

Columns

102 queryable · 102 profiled

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

FieldTypeDescriptionNullValues
sampling_locationtext—0%N7N8H3
duplicate_sampletext—100%Dof 1
sample_datedatetime—0%1911-09-28T00:00:00.0001911-09-26T00:00:00.0001913-07-09T00:00:00.000
sample_timetext—4%11:00 AM12:00 PM10:00 AM
weather_condition_dry_or_wetcategorical

Query this from your own app

GET /api/datasets/5uug-f49n
GET /api/datasets/5uug-f49n/quality
GET /api/datasets/5uug-f49n/related
GET /api/columns?dataset=5uug-f49n
  • Public Recycling Bins0.28
    • BB22006-09-12T00:00:00.0001:10 PMD21.8821.431651525.6726.273.78
    BB42006-08-09T00:00:00.0002:02 PMD27.3725.761731524.3826.324.02
    BB42006-09-12T00:00:00.0001:17 PMD21.5120.962362125.8626.73.77
    E102006-10-23T00:00:00.00010:46 AMD16.0116.149849425.926.193.35
    E102006-07-31T00:00:00.00010:00 AMD21.4918.759159125.1826.473.68
    E102006-08-21T00:00:00.00011:30 AMD22.8221.219158326.0126.663.89
    E102006-08-28T00:00:00.00010:00 AMW22.0721.998758225.2525.953.73
    E102006-08-08T00:00:00.00011:00 AMD22.819.969949525.7126.393.85
    E102006-09-11T00:00:00.00010:22 AMD21.0220.979448725.2925.573.66

    Showing 12 of 54 columns. All of them are listed below.

    —
    61%
    DDryWof 10
    top_sample_temperature_ccoordinate—20%22.223.322.8
    bottom_sample_temperature_ccoordinate—22%22.222.823.3
    site_actual_depth_fttext—27%201618
    top_sample_depth_fttext—63%33.284
    bottom_sample_depth_fttext—64%201718
    top_salinity_psucoordinate—23%25.925.227.3
    bottom_salinity_psucoordinate—25%25.927.325.2
    top_conductivity_s_mcoordinate—65%3.53.73.6
    bottom_conductivity_s_mcoordinate—67%3.73.83.6
    ctd_conductivity_temperature_depth_profiler_top_dissolved_oxygen_mg_lcoordinate—69%6.146.224.91
    ctd_conductivity_temperature_depth_profiler_bottom_dissolved_oxygen_mg_lcoordinate—71%4.935.95.01
    percentage_o2_saturation_top_samplecoordinate—69%81.583.582.9
    percentage_o2_saturation_bottom_samplecoordinate—71%74.379.682.6
    light_trans_transparency_top_samplecoordinate—77%072.672.7
    light_trans_transparency_bottom_samplecoordinate—78%72.873.272.5
    top_sigma_t_kg_m3coordinate—66%16.5916.216.32
    bottom_sigma_t_kg_m3coordinate—67%17.2918.2718.57
    top_fluorometer_mg_m3coordinate—73%-99-0.032.28
    bottom_fluorometer_mg_m3coordinate—74%-991.941.86
    ctd_conductivity_temperature_depth_profiler_ph_top_samplecoordinate—86%7.797.87.82
    ctd_conductivity_temperature_depth_profiler_ph_bottom_samplecoordinate—87%7.847.687.85
    top_sample_photosysthetically_active_radiation_reference_400_700nm_light_ue_stext—78%188519681918
    top_sample_par_ue_s_m2text—78%02540
    bottom_sample_par_ue_s_ue_s_m2text—82%012
    oxidation_reduction_potential_mv_top_sampletext—81%1.91E+021.97E+021.83E+02
    oxidation_reduction_potential_mv_bottom_sampletext—82%1.92E+021.94E+021.73E+02
    current_speed_knotcoordinate—66%0.20.50.3
    current_direction_current_directiontext—11%SNE
    wind_speed_mphtext—58%5108
    wind_direction_wind_directiontext—59%SWN
    sea_statetext—58%123
    winkler_method_top_dissolved_oxygen_mg_lcoordinate—16%454.5
    winkler_method_bottom_dissolved_oxygen_mg_lcoordinate—19%44.53.5
    secchi_depth_fttext—56%345
    top_phcoordinate—49%7.67.57.8
    bottom_phcoordinate—60%7.67.57.7
    top_total_coliform_cells_100_mltext—71%1100460240
    top_bottom_coliform_cells_100_mltext—71%1100460240
    fecal_coliform_top_sample_less_than_or_greater_than_resultcategorical—91%E<>of 6
    fecal_coliform_bottom_sample_less_than_or_greater_than_resultcategorical—99%E<>of 3
    top_fecal_coliform_bacteria_cells_100mltext—50%412
    bottom_fecal_coliform_bacteria_cells_100mltext—89%1102
    enterococcus_top_sample_less_than_or_greater_than_resultcategorical—82%E<>of 3
    enterococcus_bottom_sample_less_than_or_greater_than_resultcategorical—98%E<>of 4
    top_enterococci_bacteria_cells_100mltext—61%124
    bottom_enterococci_bacteria_cells_100mltext—96%42012
    top_nitrate_nitrite_mg_lcoordinate—50%0.0190.0180.32
    bottom_nitrate_nitrite_mg_lcoordinate—99%0.360.380.01
    top_ammonium_mg_lcoordinate—50%0.0450.310.26
    bottom_ammonium_mg_lcoordinate—99%0.430.40.34
    top_ortho_phosphorus_mg_lcoordinate—61%0.0330.120.032
    bottom_ortho_phosphorus_mg_lcoordinate—99%0.120.140.1
    top_total_kjeldhal_nitrogen_mg_lcoordinate—56%1.021.121.04
    bottom_total_kjeldhal_nitrogen_mg_lcoordinate—99%1.381.011.26
    top_silica_mg_lcoordinate—58%0.1640.0781.28
    bottom_silica_mg_lcoordinate—83%0.1640.0781.3
    total_phosphorus_mg_lcoordinate—50%0.160.140.15
    bottom_total_phosphorus_mg_lcoordinate—99%0.20.180.22
    top_total_suspended_solid_mg_ltext—52%8109
    bottom_total_suspended_solid_mg_ltext—63%81012
    top_active_chlorophyll_a_g_lcoordinate—51%123
    bottom_active_chlorophyll_a_g_lcoordinate—100%1.411.9
    chlorophyll_top_sample_field_u_l_ysicoordinate—88%11.21.3
    chlorophyll_bottom_sample_field_u_l_ysicoordinate—97%10.71.4
    top_total_organic_carbon_mg_lcoordinate—99%4.645.1
    top_dissolved_organic_carbon_mg_lcoordinate—61%3.233.4
    bottom_dissolved_organic_carbon_mg_lcoordinate—100%3.83.834.16of 7
    top_dissolved_organic_carbon_ysi_mg_ltext—100%—
    top_dissolved_oxygen_ysi_mg_lcoordinate—89%7.726.255.89
    bottom_dissolved_organic_carbon_ysi_mg_ltext—100%—
    bottom_dissolved_oxygen_ysi_mg_lcoordinate—97%6.786.374.48
    top_sample_depth_ysi_ftcoordinate—100%3.83.74.3
    bottom_depth_ysi_fttext—100%—
    top_sample_salinity_ysi_psucoordinate—88%25.223.924.4
    bottom_sample_salinity_ysi_psucoordinate—97%23.525.228.5
    top_sample_temperature_ysi_ccoordinate—88%21.52222.4
    bottom_sample_temperature_ysi_ccoordinate—96%21.42222.2
    top_bacteria_per_c_c_1909text—99%1200064009000
    bottom_bacteria_per_c_c_1909text—99%420064003200
    top_beam_attenuation_coefficienttext—100%—
    bottom_beam_attenuation_coefficienttext—100%—
    top_five_day_biochemical_oxygen_demand_mg_ltext—85%213
    bottom_five_day_biochemical_oxygen_demand_mg_ltext—85%123
    top_pcb_plate_count_thous_mlcoordinate—93%00.010.001
    bottom_pcb_plate_count_thous_mlcoordinate—93%00.010.2
    top_coliform_log_no_mlcategorical—96%123of 5
    bottom_coliform_log_no_mlcategorical—96%123of 5
    oakwood_bod_top_sample_mg_lcoordinate—81%1.51.72
    oakwood_bod_bottom_sample_mg_lcoordinate—81%1.71.52
    oakwood_total_suspended_solid_top_sample_mg_ltext—100%—
    oakwood_total_suspended_solid_bottom_sample_mg_ltext—100%—
    top_turbidity_nephelometric_turbidity_unitscoordinate—90%3.22.31.1
    bottom_turbidity_ysi_nephelometric_turbidity_unitscoordinate—97%3.53.84.4
    sampling_commenttext—90%murky watersilty waterBrown water
    longcoordinate—23%-74.045500-74.053833-73.933833
    latcoordinate—22%40.60616740.64383340.803613
    typetext—0%Permanentof 1