About this Dataset

ALFA MHK Biological Monitoring Stationary Deployment - South Energy Test Site, Newport, Oregon

Acoustic backscatter data from a WBAT operating at 70kHz deployed at PMEC-SETS from April to September of 2016. 180 pings were collected at 1Hz every two hours, as part of the Advanced Laboratory and Field Arrays (ALFA) for Marine Energy project.
Data was subject to preliminary processing (noise removal, a threshold of -75dB was applied, surface turbulence and data below 0.5m from the bottom was removed).
Organization: Department of Energy
Last updated: 2025-01-11T23:34:38.600499
Tags: acoustic, acoustic-backscatter-data, acoustic-data, active, advanced-laboratory-and-field-arrays, alfa, backscatter, biologic, biology, density, echo-sounding, echosounder, energy, environment, environmental, hydroacoustic, hydrokinetic, marine, mhk, monitoring, newport, or, oregon, pacific-marine-energy-center, pacwave, pmec, pmec-sets, power, processed-data, remote-sensing, sets, source, south-energy-test-site, stationary, wbat, wildlife

Tables

August

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494.august

4.36 MB
40,605 rows
92 columns

CREATE TABLE august (
  "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" DOUBLE  -- Layer Depth Min,
  "n__layer_depth_max" DOUBLE  -- Layer Depth Max,
  "n__ping_s" BIGINT  -- Ping S,
  "n__ping_e" BIGINT  -- Ping E,
  "n__ping_m" BIGINT  -- Ping M,
  "n__dist_s" DOUBLE  -- Dist S,
  "n__dist_e" DOUBLE  -- Dist E,
  "n__dist_m" DOUBLE  -- Dist M,
  "n__vl_start" DOUBLE  -- VL Start,
  "n__vl_end" DOUBLE  -- VL End,
  "n__vl_mid" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Gain Constant,
  "n__noise_sv_1m" DOUBLE  -- Noise Sv 1m,
  "n__minimum_sv_threshold_applied" BIGINT  -- Minimum Sv Threshold Applied,
  "n__minimum_integration_threshold" DOUBLE  -- Minimum Integration Threshold,
  "n__maximum_sv_threshold_applied" BIGINT  -- Maximum Sv Threshold Applied,
  "n__maximum_integration_threshold" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Frequency,
  "n__grid_reference_line" VARCHAR  -- Grid Reference Line,
  "n__layer_top_to_reference_line_depth" DOUBLE  -- Layer Top To Reference Line Depth,
  "n__layer_top_to_reference_line_range" DOUBLE  -- Layer Top To Reference Line Range,
  "n__layer_bottom_to_reference_line_depth" DOUBLE  -- Layer Bottom To Reference Line Depth,
  "n__layer_bottom_to_reference_line_range" DOUBLE  -- Layer Bottom To Reference Line Range,
  "n__exclude_below_line_depth_min" DOUBLE  -- Exclude Below Line Depth Min,
  "n__exclude_below_line_range_min" DOUBLE  -- Exclude Below Line Range Min,
  "n__exclude_below_line_depth_max" DOUBLE  -- Exclude Below Line Depth Max,
  "n__exclude_below_line_range_max" DOUBLE  -- 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" DOUBLE  -- Heave Min,
  "n__heave_max" DOUBLE  -- 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" DOUBLE  -- Heave Mean
);

July

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494.july

4.33 MB
40,936 rows
92 columns

CREATE TABLE july (
  "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" DOUBLE  -- Layer Depth Min,
  "n__layer_depth_max" DOUBLE  -- Layer Depth Max,
  "n__ping_s" BIGINT  -- Ping S,
  "n__ping_e" BIGINT  -- Ping E,
  "n__ping_m" BIGINT  -- Ping M,
  "n__dist_s" DOUBLE  -- Dist S,
  "n__dist_e" DOUBLE  -- Dist E,
  "n__dist_m" DOUBLE  -- Dist M,
  "n__vl_start" DOUBLE  -- VL Start,
  "n__vl_end" DOUBLE  -- VL End,
  "n__vl_mid" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Gain Constant,
  "n__noise_sv_1m" DOUBLE  -- Noise Sv 1m,
  "n__minimum_sv_threshold_applied" BIGINT  -- Minimum Sv Threshold Applied,
  "n__minimum_integration_threshold" DOUBLE  -- Minimum Integration Threshold,
  "n__maximum_sv_threshold_applied" BIGINT  -- Maximum Sv Threshold Applied,
  "n__maximum_integration_threshold" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Frequency,
  "n__grid_reference_line" VARCHAR  -- Grid Reference Line,
  "n__layer_top_to_reference_line_depth" DOUBLE  -- Layer Top To Reference Line Depth,
  "n__layer_top_to_reference_line_range" DOUBLE  -- Layer Top To Reference Line Range,
  "n__layer_bottom_to_reference_line_depth" DOUBLE  -- Layer Bottom To Reference Line Depth,
  "n__layer_bottom_to_reference_line_range" DOUBLE  -- Layer Bottom To Reference Line Range,
  "n__exclude_below_line_depth_min" DOUBLE  -- Exclude Below Line Depth Min,
  "n__exclude_below_line_range_min" DOUBLE  -- Exclude Below Line Range Min,
  "n__exclude_below_line_depth_max" DOUBLE  -- Exclude Below Line Depth Max,
  "n__exclude_below_line_range_max" DOUBLE  -- 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" DOUBLE  -- Heave Min,
  "n__heave_max" DOUBLE  -- 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" DOUBLE  -- Heave Mean
);

June

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494.june

4.33 MB
39,180 rows
92 columns

CREATE TABLE june (
  "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" DOUBLE  -- Layer Depth Min,
  "n__layer_depth_max" DOUBLE  -- Layer Depth Max,
  "n__ping_s" BIGINT  -- Ping S,
  "n__ping_e" BIGINT  -- Ping E,
  "n__ping_m" BIGINT  -- Ping M,
  "n__dist_s" DOUBLE  -- Dist S,
  "n__dist_e" DOUBLE  -- Dist E,
  "n__dist_m" DOUBLE  -- Dist M,
  "n__vl_start" DOUBLE  -- VL Start,
  "n__vl_end" DOUBLE  -- VL End,
  "n__vl_mid" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Gain Constant,
  "n__noise_sv_1m" DOUBLE  -- Noise Sv 1m,
  "n__minimum_sv_threshold_applied" BIGINT  -- Minimum Sv Threshold Applied,
  "n__minimum_integration_threshold" DOUBLE  -- Minimum Integration Threshold,
  "n__maximum_sv_threshold_applied" BIGINT  -- Maximum Sv Threshold Applied,
  "n__maximum_integration_threshold" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Frequency,
  "n__grid_reference_line" VARCHAR  -- Grid Reference Line,
  "n__layer_top_to_reference_line_depth" DOUBLE  -- Layer Top To Reference Line Depth,
  "n__layer_top_to_reference_line_range" DOUBLE  -- Layer Top To Reference Line Range,
  "n__layer_bottom_to_reference_line_depth" DOUBLE  -- Layer Bottom To Reference Line Depth,
  "n__layer_bottom_to_reference_line_range" DOUBLE  -- Layer Bottom To Reference Line Range,
  "n__exclude_below_line_depth_min" DOUBLE  -- Exclude Below Line Depth Min,
  "n__exclude_below_line_range_min" DOUBLE  -- Exclude Below Line Range Min,
  "n__exclude_below_line_depth_max" DOUBLE  -- Exclude Below Line Depth Max,
  "n__exclude_below_line_range_max" DOUBLE  -- 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" DOUBLE  -- Heave Min,
  "n__heave_max" DOUBLE  -- 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" DOUBLE  -- Heave Mean
);

September

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494.september

4.34 MB
39,619 rows
92 columns

CREATE TABLE september (
  "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" DOUBLE  -- Layer Depth Min,
  "n__layer_depth_max" DOUBLE  -- Layer Depth Max,
  "n__ping_s" BIGINT  -- Ping S,
  "n__ping_e" BIGINT  -- Ping E,
  "n__ping_m" BIGINT  -- Ping M,
  "n__dist_s" DOUBLE  -- Dist S,
  "n__dist_e" DOUBLE  -- Dist E,
  "n__dist_m" DOUBLE  -- Dist M,
  "n__vl_start" DOUBLE  -- VL Start,
  "n__vl_end" DOUBLE  -- VL End,
  "n__vl_mid" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Gain Constant,
  "n__noise_sv_1m" DOUBLE  -- Noise Sv 1m,
  "n__minimum_sv_threshold_applied" BIGINT  -- Minimum Sv Threshold Applied,
  "n__minimum_integration_threshold" DOUBLE  -- Minimum Integration Threshold,
  "n__maximum_sv_threshold_applied" BIGINT  -- Maximum Sv Threshold Applied,
  "n__maximum_integration_threshold" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Frequency,
  "n__grid_reference_line" VARCHAR  -- Grid Reference Line,
  "n__layer_top_to_reference_line_depth" DOUBLE  -- Layer Top To Reference Line Depth,
  "n__layer_top_to_reference_line_range" DOUBLE  -- Layer Top To Reference Line Range,
  "n__layer_bottom_to_reference_line_depth" DOUBLE  -- Layer Bottom To Reference Line Depth,
  "n__layer_bottom_to_reference_line_range" DOUBLE  -- Layer Bottom To Reference Line Range,
  "n__exclude_below_line_depth_min" DOUBLE  -- Exclude Below Line Depth Min,
  "n__exclude_below_line_range_min" DOUBLE  -- Exclude Below Line Range Min,
  "n__exclude_below_line_depth_max" DOUBLE  -- Exclude Below Line Depth Max,
  "n__exclude_below_line_range_max" DOUBLE  -- 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" DOUBLE  -- Heave Min,
  "n__heave_max" DOUBLE  -- 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" DOUBLE  -- Heave Mean
);

Table 3

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494.table_3

4.31 MB
40,203 rows
92 columns

CREATE TABLE table_3 (
  "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" DOUBLE  -- Layer Depth Min,
  "n__layer_depth_max" DOUBLE  -- Layer Depth Max,
  "n__ping_s" BIGINT  -- Ping S,
  "n__ping_e" BIGINT  -- Ping E,
  "n__ping_m" BIGINT  -- Ping M,
  "n__dist_s" DOUBLE  -- Dist S,
  "n__dist_e" DOUBLE  -- Dist E,
  "n__dist_m" DOUBLE  -- Dist M,
  "n__vl_start" DOUBLE  -- VL Start,
  "n__vl_end" DOUBLE  -- VL End,
  "n__vl_mid" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Gain Constant,
  "n__noise_sv_1m" DOUBLE  -- Noise Sv 1m,
  "n__minimum_sv_threshold_applied" BIGINT  -- Minimum Sv Threshold Applied,
  "n__minimum_integration_threshold" DOUBLE  -- Minimum Integration Threshold,
  "n__maximum_sv_threshold_applied" BIGINT  -- Maximum Sv Threshold Applied,
  "n__maximum_integration_threshold" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Frequency,
  "n__grid_reference_line" VARCHAR  -- Grid Reference Line,
  "n__layer_top_to_reference_line_depth" DOUBLE  -- Layer Top To Reference Line Depth,
  "n__layer_top_to_reference_line_range" DOUBLE  -- Layer Top To Reference Line Range,
  "n__layer_bottom_to_reference_line_depth" DOUBLE  -- Layer Bottom To Reference Line Depth,
  "n__layer_bottom_to_reference_line_range" DOUBLE  -- Layer Bottom To Reference Line Range,
  "n__exclude_below_line_depth_min" DOUBLE  -- Exclude Below Line Depth Min,
  "n__exclude_below_line_range_min" DOUBLE  -- Exclude Below Line Range Min,
  "n__exclude_below_line_depth_max" DOUBLE  -- Exclude Below Line Depth Max,
  "n__exclude_below_line_range_max" DOUBLE  -- 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" DOUBLE  -- Heave Min,
  "n__heave_max" DOUBLE  -- 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" DOUBLE  -- Heave Mean
);