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

888.24 kB
3,934 rows
92 columns

CREATE TABLE density_measurements (
  "process_id" BIGINT,
  "n__interval" BIGINT  -- Interval,
  "n__layer" BIGINT  -- Layer,
  "n__sv_mean" DOUBLE  -- Sv Mean,
  "n__nasc" DOUBLE  -- NASC,
  "n__sv_max" DOUBLE  -- Sv Max,
  "n__sv_min" DOUBLE  -- Sv Min,
  "n__sv_noise" DOUBLE  -- Sv Noise,
  "n__nasc_noise" DOUBLE  -- NASC Noise,
  "n__height_mean" DOUBLE  -- Height Mean,
  "n__depth_mean" DOUBLE  -- Depth Mean,
  "n__good_samples" BIGINT  -- Good Samples,
  "n__layer_depth_min" BIGINT  -- Layer Depth Min,
  "n__layer_depth_max" BIGINT  -- Layer Depth Max,
  "n__ping_s" BIGINT  -- Ping S,
  "n__ping_e" BIGINT  -- Ping E,
  "n__ping_m" BIGINT  -- Ping M,
  "n__dist_s" BIGINT  -- Dist S,
  "n__dist_e" BIGINT  -- Dist E,
  "n__dist_m" BIGINT  -- Dist M,
  "n__vl_start" BIGINT  -- VL Start,
  "n__vl_end" BIGINT  -- VL End,
  "n__vl_mid" BIGINT  -- VL Mid,
  "n__date_s" BIGINT  -- Date S,
  "n__time_s" VARCHAR  -- Time S,
  "n__date_e" BIGINT  -- Date E,
  "n__time_e" VARCHAR  -- Time E,
  "n__date_m" BIGINT  -- Date M,
  "n__time_m" VARCHAR  -- Time M,
  "n__lat_s" DOUBLE  -- Lat S,
  "n__lon_s" DOUBLE  -- Lon S,
  "n__lat_e" DOUBLE  -- Lat E,
  "n__lon_e" DOUBLE  -- Lon E,
  "n__lat_m" DOUBLE  -- Lat M,
  "n__lon_m" DOUBLE  -- Lon M,
  "n__exclude_below_line_depth_mean" BIGINT  -- Exclude Below Line Depth Mean,
  "n__program_version" VARCHAR  -- Program Version,
  "n__processing_version" BIGINT  -- Processing Version,
  "n__processing_date" BIGINT  -- Processing Date,
  "n__processing_time" VARCHAR  -- Processing Time,
  "n__ev_filename" VARCHAR  -- EV Filename,
  "n__alpha" DOUBLE  -- Alpha,
  "n__gain_constant" BIGINT  -- Gain Constant,
  "n__noise_sv_1m" DOUBLE  -- Noise Sv 1m,
  "n__minimum_sv_threshold_applied" BIGINT  -- Minimum Sv Threshold Applied,
  "n__minimum_integration_threshold" BIGINT  -- Minimum Integration Threshold,
  "n__maximum_sv_threshold_applied" BIGINT  -- Maximum Sv Threshold Applied,
  "n__maximum_integration_threshold" BIGINT  -- Maximum Integration Threshold,
  "n__exclude_above_line_applied" BIGINT  -- Exclude Above Line Applied,
  "n__exclude_above_line_depth_mean" DOUBLE  -- Exclude Above Line Depth Mean,
  "n__exclude_below_line_applied" BIGINT  -- Exclude Below Line Applied,
  "n__bottom_offset" BIGINT  -- Bottom Offset,
  "n__standard_deviation" DOUBLE  -- Standard Deviation,
  "n__skewness" DOUBLE  -- Skewness,
  "n__kurtosis" DOUBLE  -- Kurtosis,
  "n__abc" DOUBLE  -- ABC,
  "n__abc_noise" DOUBLE  -- ABC Noise,
  "n__area_backscatter_strength" DOUBLE  -- Area Backscatter Strength,
  "n__thickness_mean" DOUBLE  -- Thickness Mean,
  "n__range_mean" DOUBLE  -- Range Mean,
  "n__exclude_below_line_range_mean" BIGINT  -- Exclude Below Line Range Mean,
  "n__exclude_above_line_range_mean" DOUBLE  -- Exclude Above Line Range Mean,
  "n__bad_data_no_data_samples" BIGINT  -- Bad Data No Data Samples,
  "n__beam_volume_sum" DOUBLE  -- Beam Volume Sum,
  "n__no_data_samples" BIGINT  -- No Data Samples,
  "n__frequency" BIGINT  -- Frequency,
  "n__grid_reference_line" VARCHAR  -- Grid Reference Line,
  "n__layer_top_to_reference_line_depth" BIGINT  -- Layer Top To Reference Line Depth,
  "n__layer_top_to_reference_line_range" BIGINT  -- Layer Top To Reference Line Range,
  "n__layer_bottom_to_reference_line_depth" BIGINT  -- Layer Bottom To Reference Line Depth,
  "n__layer_bottom_to_reference_line_range" BIGINT  -- Layer Bottom To Reference Line Range,
  "n__exclude_below_line_depth_min" BIGINT  -- Exclude Below Line Depth Min,
  "n__exclude_below_line_range_min" BIGINT  -- Exclude Below Line Range Min,
  "n__exclude_below_line_depth_max" BIGINT  -- Exclude Below Line Depth Max,
  "n__exclude_below_line_range_max" BIGINT  -- Exclude Below Line Range Max,
  "n__samples_below_bottom_exclusion" BIGINT  -- Samples Below Bottom Exclusion,
  "n__samples_above_surface_exclusion" BIGINT  -- Samples Above Surface Exclusion,
  "n__samples_in_domain" BIGINT  -- Samples In Domain,
  "n__bad_data_empty_water_samples" BIGINT  -- Bad Data Empty Water Samples,
  "n__bottom_roughness_normalized" DOUBLE  -- Bottom Roughness Normalized,
  "n__bottom_hardness_normalized" DOUBLE  -- Bottom Hardness Normalized,
  "n__first_bottom_length_normalized" DOUBLE  -- First Bottom Length Normalized,
  "n__second_bottom_length_normalized" DOUBLE  -- Second Bottom Length Normalized,
  "n__bottom_rise_time_normalized" DOUBLE  -- Bottom Rise Time Normalized,
  "n__heave_source" VARCHAR  -- Heave Source,
  "n__heave_min" BIGINT  -- Heave Min,
  "n__heave_max" BIGINT  -- Heave Max,
  "n__bottom_line_depth_mean" DOUBLE  -- Bottom Line Depth Mean,
  "n__bottom_max_sv" DOUBLE  -- Bottom Max Sv,
  "n__bottom_kurtosis" DOUBLE  -- Bottom Kurtosis,
  "n__bottom_skewness" DOUBLE  -- Bottom Skewness,
  "n__heave_mean" BIGINT  -- Heave Mean
);