ALFA Biological Monitoring Density Values - South Energy Test Site, Newport, Oregon by US Government | Healthcare

About this Dataset

ALFA Biological Monitoring Density Values - South Energy Test Site, Newport, Oregon

Density values from active acoustic measurements at South Energy Test Site. This data correspond to a bottom mounted upward-looking WBAT, deployed from April 19th to September 30th. Samples (175 pings) were collected hourly at 1Hz.
Organization: Department of Energy
Last updated: 2025-01-11T23:32:32.687030
Tags: acoustic, acoustics, active, active-source, alfa, backscatter-strength, biologic, biological, biology, density, depth, ea, echo-sounding, echosounder, energy, environment, environmental, frequency, hardness, heave, height, hydroacoustic, hydrokinetic, kurtosis, marine, mhk, monitoring, or, oregon, power, range, roughness, sets, skewness, south-energy-test-site, wbat, wildlife

Tables

Density Measurements

@usgov.doe_gov_alfa_biological_monitoring_density_values_sout_43974607.density_measurements

867.42 KB
3934 rows
92 columns


CREATE TABLE density_measurements (
  "process_id" BIGINT,
  "n__interval" BIGINT,
  "n__layer" BIGINT,
  "n__sv_mean" DOUBLE,
  "n__nasc" DOUBLE,
  "n__sv_max" DOUBLE,
  "n__sv_min" DOUBLE,
  "n__sv_noise" DOUBLE,
  "n__nasc_noise" DOUBLE,
  "n__height_mean" DOUBLE,
  "n__depth_mean" DOUBLE,
  "n__good_samples" BIGINT,
  "n__layer_depth_min" BIGINT,
  "n__layer_depth_max" BIGINT,
  "n__ping_s" BIGINT,
  "n__ping_e" BIGINT,
  "n__ping_m" BIGINT,
  "n__dist_s" BIGINT,
  "n__dist_e" BIGINT,
  "n__dist_m" BIGINT,
  "n__vl_start" BIGINT,
  "n__vl_end" BIGINT,
  "n__vl_mid" BIGINT,
  "n__date_s" BIGINT,
  "n__time_s" VARCHAR,
  "n__date_e" BIGINT,
  "n__time_e" VARCHAR,
  "n__date_m" BIGINT,
  "n__time_m" VARCHAR,
  "n__lat_s" DOUBLE,
  "n__lon_s" DOUBLE,
  "n__lat_e" DOUBLE,
  "n__lon_e" DOUBLE,
  "n__lat_m" DOUBLE,
  "n__lon_m" DOUBLE,
  "n__exclude_below_line_depth_mean" BIGINT,
  "n__program_version" VARCHAR,
  "n__processing_version" BIGINT,
  "n__processing_date" BIGINT,
  "n__processing_time" VARCHAR,
  "n__ev_filename" VARCHAR,
  "n__alpha" DOUBLE,
  "n__gain_constant" BIGINT,
  "n__noise_sv_1m" DOUBLE,
  "n__minimum_sv_threshold_applied" BIGINT,
  "n__minimum_integration_threshold" BIGINT,
  "n__maximum_sv_threshold_applied" BIGINT,
  "n__maximum_integration_threshold" BIGINT,
  "n__exclude_above_line_applied" BIGINT,
  "n__exclude_above_line_depth_mean" DOUBLE,
  "n__exclude_below_line_applied" BIGINT,
  "n__bottom_offset" BIGINT,
  "n__standard_deviation" DOUBLE,
  "n__skewness" DOUBLE,
  "n__kurtosis" DOUBLE,
  "n__abc" DOUBLE,
  "n__abc_noise" DOUBLE,
  "n__area_backscatter_strength" DOUBLE,
  "n__thickness_mean" DOUBLE,
  "n__range_mean" DOUBLE,
  "n__exclude_below_line_range_mean" BIGINT,
  "n__exclude_above_line_range_mean" DOUBLE,
  "n__bad_data_no_data_samples" BIGINT,
  "n__beam_volume_sum" DOUBLE,
  "n__no_data_samples" BIGINT,
  "n__frequency" BIGINT,
  "n__grid_reference_line" VARCHAR,
  "n__layer_top_to_reference_line_depth" BIGINT,
  "n__layer_top_to_reference_line_range" BIGINT,
  "n__layer_bottom_to_reference_line_depth" BIGINT,
  "n__layer_bottom_to_reference_line_range" BIGINT,
  "n__exclude_below_line_depth_min" BIGINT,
  "n__exclude_below_line_range_min" BIGINT,
  "n__exclude_below_line_depth_max" BIGINT,
  "n__exclude_below_line_range_max" BIGINT,
  "n__samples_below_bottom_exclusion" BIGINT,
  "n__samples_above_surface_exclusion" BIGINT,
  "n__samples_in_domain" BIGINT,
  "n__bad_data_empty_water_samples" BIGINT,
  "n__bottom_roughness_normalized" DOUBLE,
  "n__bottom_hardness_normalized" DOUBLE,
  "n__first_bottom_length_normalized" DOUBLE,
  "n__second_bottom_length_normalized" DOUBLE,
  "n__bottom_rise_time_normalized" DOUBLE,
  "n__heave_source" VARCHAR,
  "n__heave_min" BIGINT,
  "n__heave_max" BIGINT,
  "n__bottom_line_depth_mean" DOUBLE,
  "n__bottom_max_sv" DOUBLE,
  "n__bottom_kurtosis" DOUBLE,
  "n__bottom_skewness" DOUBLE,
  "n__heave_mean" BIGINT
);