Name: Harbor Water Quality
Creator: US Government
License: https://www.usa.gov/government-works
About this Dataset

Harbor Water Quality

Harbor water sampling information
Organization: City of New York
Last updated: 2020-11-10T17:00:53.140404
Tags: 2018od4a-video, dep, department-of-environmental-protection, environment, harbor, harbor-sampling-data, healthy-living, sample, sampling, water
Tables

Table 1

@usgov.city_of_new_york_harbor_water_quality.table_1
6.33 MB
95,933 rows
100 columns
CREATE TABLE table_1 (
  "sampling_location" VARCHAR,
  "duplicate_sample" VARCHAR,
  "sample_date" TIMESTAMP,
  "sample_time" VARCHAR,
  "weather_condition_dry_or_wet" VARCHAR  -- Weather Condition (Dry Or Wet),
  "top_sample_temperature_c" VARCHAR  -- Top Sample Temperature (ºC),
  "bottom_sample_temperature_c" VARCHAR  -- Bottom Sample Temperature (ºC),
  "site_actual_depth_ft" VARCHAR  -- Site Actual Depth (ft),
  "top_sample_depth_ft" DOUBLE  -- Top Sample Depth(ft),
  "bottom_sample_depth_ft" DOUBLE  -- Bottom Sample Depth (ft),
  "top_salinity_psu" VARCHAR  -- Top Salinity (psu),
  "bottom_salinity_psu" VARCHAR  -- Bottom Salinity (psu),
  "top_conductivity_s_m" VARCHAR  -- Top Conductivity (S/m),
  "bottom_conductivity_s_m" VARCHAR  -- Bottom Conductivity (S/m),
  "ctd_conductivity_temperature_depth_profiler_top_dissol_aa856a5e" DOUBLE  -- CTD (conductivity, Temperature, Depth Profiler) Top Dissolved Oxygen (mg/L),
  "ctd_conductivity_temperature_depth_profiler_bottom_dis_dfb79c66" DOUBLE  -- CTD (conductivity, Temperature, Depth Profiler) Bottom Dissolved Oxygen (mg/L),
  "percentage_o2_saturation_top_sample" DOUBLE,
  "percentage_o2_saturation_bottom_sample" DOUBLE,
  "light_trans_transparency_top_sample" DOUBLE  -- Light Trans (% Transparency) Top Sample,
  "light_trans_transparency_bottom_sample" DOUBLE  -- Light Trans (% Transparency) Bottom Sample,
  "top_sigma_t_kg_m3" VARCHAR  -- Top Sigma-T (kg/m3),
  "bottom_sigma_t_kg_m3" VARCHAR  -- Bottom Sigma-T (kg/m3),
  "top_fluorometer_mg_m3" DOUBLE  -- Top Fluorometer (mg/m3),
  "bottom_fluorometer_mg_m3" DOUBLE,
  "ctd_conductivity_temperature_depth_profiler_ph_top_sample" DOUBLE  -- CTD (conductivity, Temperature, Depth Profiler) PH Top Sample,
  "ctd_conductivity_temperature_depth_profiler_ph_bottom_sample" DOUBLE  -- CTD (conductivity, Temperature, Depth Profiler) PH Bottom Sample,
  "top_sample_photosysthetically_active_radiation_referen_d2e33c85" VARCHAR  -- Top Sample Photosysthetically Active Radiation Reference (400-700nm Light (uE/S),
  "top_sample_par_ue_s_m2" VARCHAR  -- Top Sample Par (uE/S M2),
  "bottom_sample_par_ue_s_ue_s_m2" DOUBLE  -- Bottom Sample Par UE/S (uE/S M2),
  "oxidation_reduction_potential_mv_top_sample" DOUBLE  -- Oxidation Reduction Potential (mV) Top Sample,
  "oxidation_reduction_potential_mv_bottom_sample" DOUBLE  -- Oxidation Reduction Potential (mV) Bottom Sample,
  "current_speed_knot" VARCHAR  -- Current Speed (knot),
  "current_direction_current_direction" VARCHAR  -- Current Direction (Current Direction),
  "wind_speed_mph" VARCHAR  -- Wind Speed (mph),
  "wind_direction_wind_direction" VARCHAR  -- Wind Direction (Wind Direction),
  "sea_state" VARCHAR,
  "winkler_method_top_dissolved_oxygen_mg_l" VARCHAR  -- Winkler Method Top Dissolved Oxygen (mg/L),
  "winkler_method_bottom_dissolved_oxygen_mg_l" VARCHAR  -- Winkler Method Bottom Dissolved Oxygen (mg/L),
  "secchi_depth_ft" VARCHAR  -- Secchi Depth (ft),
  "top_ph" VARCHAR,
  "bottom_ph" VARCHAR,
  "top_total_coliform_cells_100_ml" VARCHAR,
  "top_bottom_coliform_cells_100_ml" VARCHAR,
  "fecal_coliform_top_sample_less_than_or_greater_than_result" VARCHAR,
  "fecal_coliform_bottom_sample_less_than_or_greater_than_result" VARCHAR,
  "top_fecal_coliform_bacteria_cells_100ml" VARCHAR  -- Top Fecal Coliform Bacteria (Cells/100mL),
  "bottom_fecal_coliform_bacteria_cells_100ml" VARCHAR  -- Bottom Fecal Coliform Bacteria (Cells/100mL),
  "enterococcus_top_sample_less_than_or_greater_than_result" VARCHAR,
  "enterococcus_bottom_sample_less_than_or_greater_than_result" VARCHAR,
  "top_enterococci_bacteria_cells_100ml" VARCHAR  -- Top Enterococci Bacteria (Cells/100mL),
  "bottom_enterococci_bacteria_cells_100ml" VARCHAR  -- Bottom Enterococci Bacteria (Cells/100mL),
  "top_nitrate_nitrite_mg_l" VARCHAR  -- Top Nitrate/Nitrite (mg/L),
  "bottom_nitrate_nitrite_mg_l" VARCHAR  -- Bottom Nitrate/Nitrite (mg/L),
  "top_ammonium_mg_l" VARCHAR  -- Top Ammonium (mg/L),
  "bottom_ammonium_mg_l" VARCHAR  -- Bottom Ammonium (mg/L),
  "top_ortho_phosphorus_mg_l" VARCHAR  -- Top Ortho-Phosphorus (mg/L),
  "bottom_ortho_phosphorus_mg_l" DOUBLE  -- Bottom Ortho-Phosphorus (mg/L),
  "top_total_kjeldhal_nitrogen_mg_l" VARCHAR  -- Top Total Kjeldhal Nitrogen (mg/L),
  "bottom_total_kjeldhal_nitrogen_mg_l" DOUBLE  -- Bottom Total Kjeldhal Nitrogen (mg/L),
  "top_silica_mg_l" VARCHAR  -- Top Silica (mg/L),
  "bottom_silica_mg_l" VARCHAR  -- Bottom Silica (mg/L),
  "total_phosphorus_mg_l" VARCHAR  -- Total Phosphorus(mg/L),
  "bottom_total_phosphorus_mg_l" DOUBLE  -- Bottom Total Phosphorus (mg/L),
  "top_total_suspended_solid_mg_l" VARCHAR  -- Top Total Suspended Solid (mg/L),
  "bottom_total_suspended_solid_mg_l" VARCHAR  -- Bottom Total Suspended Solid (mg/L),
  "top_active_chlorophyll_a_g_l" VARCHAR  -- Top Active Chlorophyll 'A' (µg/L),
  "bottom_active_chlorophyll_a_g_l" DOUBLE  -- Bottom Active Chlorophyll 'A' (µg/L),
  "chlorophyll_top_sample_field_u_l_ysi" VARCHAR  -- Chlorophyll Top Sample Field (u/L (YSI),
  "chlorophyll_bottom_sample_field_u_l_ysi" VARCHAR  -- Chlorophyll Bottom Sample Field (u/L (YSI),
  "top_total_organic_carbon_mg_l" DOUBLE  -- TOP Total Organic Carbon (mg/L),
  "top_dissolved_organic_carbon_mg_l" VARCHAR  -- Top Dissolved Organic Carbon (mg/L),
  "bottom_dissolved_organic_carbon_mg_l" DOUBLE  -- Bottom Dissolved Organic Carbon (mg/L),
  "top_dissolved_organic_carbon_ysi_mg_l" DOUBLE  -- Top Dissolved Organic Carbon YSI (mg/L),
  "bottom_dissolved_organic_carbon_ysi_mg_l" DOUBLE  -- Bottom Dissolved Organic Carbon YSI (mg/L),
  "top_sample_depth_ysi_ft" DOUBLE  -- Top Sample Depth YSI (ft),
  "bottom_depth_ysi_ft" VARCHAR  -- Bottom Depth YSI (ft),
  "top_sample_salinity_ysi_psu" VARCHAR  -- Top Sample Salinity YSI (psu),
  "bottom_sample_salinity_ysi_psu" VARCHAR  -- Bottom Sample Salinity YSI (psu),
  "top_sample_temperature_ysi_c" DOUBLE  -- Top Sample Temperature YSI (ºC),
  "bottom_sample_temperature_ysi_c" VARCHAR  -- Bottom Sample Temperature YSI (ºC),
  "top_bacteria_per_c_c_1909" DOUBLE  -- Top Bacteria # Per C.C. 1909,
  "bottom_bacteria_per_c_c_1909" DOUBLE  -- Bottom Bacteria # Per C.C. 1909,
  "top_beam_attenuation_coefficient" VARCHAR,
  "bottom_beam_attenuation_coefficient" VARCHAR,
  "top_five_day_biochemical_oxygen_demand_mg_l" DOUBLE  -- Top Five-Day Biochemical Oxygen Demand(mg/L),
  "bottom_five_day_biochemical_oxygen_demand_mg_l" DOUBLE  -- Bottom Five-Day Biochemical Oxygen Demand(mg/L),
  "top_pcb_plate_count_thous_ml" DOUBLE  -- Top PCB Plate Count (Thous/mL),
  "bottom_pcb_plate_count_thous_ml" DOUBLE  -- Bottom PCB Plate Count (Thous/mL),
  "top_coliform_log_no_ml" DOUBLE  -- Top Coliform (Log No/mL),
  "bottom_coliform_log_no_ml" DOUBLE  -- Bottom Coliform (Log No/mL),
  "oakwood_bod_top_sample_mg_l" DOUBLE  -- Oakwood BOD Top Sample (mg/L),
  "oakwood_bod_bottom_sample_mg_l" VARCHAR  -- Oakwood BOD Bottom Sample(mg/L),
  "oakwood_total_suspended_solid_top_sample_mg_l" VARCHAR  -- Oakwood Total Suspended Solid Top Sample (mg/L),
  "oakwood_total_suspended_solid_bottom_sample_mg_l" VARCHAR  -- Oakwood Total Suspended Solid Bottom Sample (mg/L),
  "top_turbidity_nephelometric_turbidity_units" VARCHAR  -- Top Turbidity( Nephelometric Turbidity Units),
  "bottom_turbidity_ysi_nephelometric_turbidity_units" VARCHAR  -- Bottom Turbidity YSI (Nephelometric Turbidity Units),
  "sampling_comment" VARCHAR,
  "long" DOUBLE,
  "lat" DOUBLE,
  "type" VARCHAR
);