Baselight

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

Department of Energy

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494

Loading...
Loading...

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.600495
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, pmec, pmec_sets, power, processed-data, remote-sensing, sets, source, south-energy-test-site, stationary, wbat, wildlife

Tables

April

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494.april
  • 1.68 MB
  • 15261 rows
  • 92 columns
Loading...

CREATE TABLE april (
  "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" DOUBLE,
  "n__layer_depth_max" DOUBLE,
  "n__ping_s" BIGINT,
  "n__ping_e" BIGINT,
  "n__ping_m" BIGINT,
  "n__dist_s" DOUBLE,
  "n__dist_e" DOUBLE,
  "n__dist_m" DOUBLE,
  "n__vl_start" DOUBLE,
  "n__vl_end" DOUBLE,
  "n__vl_mid" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__noise_sv_1m" DOUBLE,
  "n__minimum_sv_threshold_applied" BIGINT,
  "n__minimum_integration_threshold" DOUBLE,
  "n__maximum_sv_threshold_applied" BIGINT,
  "n__maximum_integration_threshold" DOUBLE,
  "n__exclude_above_line_applied" BIGINT,
  "n__exclude_above_line_depth_mean" DOUBLE,
  "n__exclude_below_line_applied" BIGINT,
  "n__bottom_offset" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__grid_reference_line" VARCHAR,
  "n__layer_top_to_reference_line_depth" DOUBLE,
  "n__layer_top_to_reference_line_range" DOUBLE,
  "n__layer_bottom_to_reference_line_depth" DOUBLE,
  "n__layer_bottom_to_reference_line_range" DOUBLE,
  "n__exclude_below_line_depth_min" DOUBLE,
  "n__exclude_below_line_range_min" DOUBLE,
  "n__exclude_below_line_depth_max" DOUBLE,
  "n__exclude_below_line_range_max" DOUBLE,
  "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" DOUBLE,
  "n__heave_max" DOUBLE,
  "n__bottom_line_depth_mean" DOUBLE,
  "n__bottom_max_sv" DOUBLE,
  "n__bottom_kurtosis" DOUBLE,
  "n__bottom_skewness" DOUBLE,
  "n__heave_mean" DOUBLE
);

August

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494.august
  • 4.16 MB
  • 40605 rows
  • 92 columns
Loading...

CREATE TABLE august (
  "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" DOUBLE,
  "n__layer_depth_max" DOUBLE,
  "n__ping_s" BIGINT,
  "n__ping_e" BIGINT,
  "n__ping_m" BIGINT,
  "n__dist_s" DOUBLE,
  "n__dist_e" DOUBLE,
  "n__dist_m" DOUBLE,
  "n__vl_start" DOUBLE,
  "n__vl_end" DOUBLE,
  "n__vl_mid" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__noise_sv_1m" DOUBLE,
  "n__minimum_sv_threshold_applied" BIGINT,
  "n__minimum_integration_threshold" DOUBLE,
  "n__maximum_sv_threshold_applied" BIGINT,
  "n__maximum_integration_threshold" DOUBLE,
  "n__exclude_above_line_applied" BIGINT,
  "n__exclude_above_line_depth_mean" DOUBLE,
  "n__exclude_below_line_applied" BIGINT,
  "n__bottom_offset" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__grid_reference_line" VARCHAR,
  "n__layer_top_to_reference_line_depth" DOUBLE,
  "n__layer_top_to_reference_line_range" DOUBLE,
  "n__layer_bottom_to_reference_line_depth" DOUBLE,
  "n__layer_bottom_to_reference_line_range" DOUBLE,
  "n__exclude_below_line_depth_min" DOUBLE,
  "n__exclude_below_line_range_min" DOUBLE,
  "n__exclude_below_line_depth_max" DOUBLE,
  "n__exclude_below_line_range_max" DOUBLE,
  "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" DOUBLE,
  "n__heave_max" DOUBLE,
  "n__bottom_line_depth_mean" DOUBLE,
  "n__bottom_max_sv" DOUBLE,
  "n__bottom_kurtosis" DOUBLE,
  "n__bottom_skewness" DOUBLE,
  "n__heave_mean" DOUBLE
);

July

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494.july
  • 4.13 MB
  • 40936 rows
  • 92 columns
Loading...

CREATE TABLE july (
  "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" DOUBLE,
  "n__layer_depth_max" DOUBLE,
  "n__ping_s" BIGINT,
  "n__ping_e" BIGINT,
  "n__ping_m" BIGINT,
  "n__dist_s" DOUBLE,
  "n__dist_e" DOUBLE,
  "n__dist_m" DOUBLE,
  "n__vl_start" DOUBLE,
  "n__vl_end" DOUBLE,
  "n__vl_mid" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__noise_sv_1m" DOUBLE,
  "n__minimum_sv_threshold_applied" BIGINT,
  "n__minimum_integration_threshold" DOUBLE,
  "n__maximum_sv_threshold_applied" BIGINT,
  "n__maximum_integration_threshold" DOUBLE,
  "n__exclude_above_line_applied" BIGINT,
  "n__exclude_above_line_depth_mean" DOUBLE,
  "n__exclude_below_line_applied" BIGINT,
  "n__bottom_offset" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__grid_reference_line" VARCHAR,
  "n__layer_top_to_reference_line_depth" DOUBLE,
  "n__layer_top_to_reference_line_range" DOUBLE,
  "n__layer_bottom_to_reference_line_depth" DOUBLE,
  "n__layer_bottom_to_reference_line_range" DOUBLE,
  "n__exclude_below_line_depth_min" DOUBLE,
  "n__exclude_below_line_range_min" DOUBLE,
  "n__exclude_below_line_depth_max" DOUBLE,
  "n__exclude_below_line_range_max" DOUBLE,
  "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" DOUBLE,
  "n__heave_max" DOUBLE,
  "n__bottom_line_depth_mean" DOUBLE,
  "n__bottom_max_sv" DOUBLE,
  "n__bottom_kurtosis" DOUBLE,
  "n__bottom_skewness" DOUBLE,
  "n__heave_mean" DOUBLE
);

June

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494.june
  • 4.13 MB
  • 39180 rows
  • 92 columns
Loading...

CREATE TABLE june (
  "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" DOUBLE,
  "n__layer_depth_max" DOUBLE,
  "n__ping_s" BIGINT,
  "n__ping_e" BIGINT,
  "n__ping_m" BIGINT,
  "n__dist_s" DOUBLE,
  "n__dist_e" DOUBLE,
  "n__dist_m" DOUBLE,
  "n__vl_start" DOUBLE,
  "n__vl_end" DOUBLE,
  "n__vl_mid" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__noise_sv_1m" DOUBLE,
  "n__minimum_sv_threshold_applied" BIGINT,
  "n__minimum_integration_threshold" DOUBLE,
  "n__maximum_sv_threshold_applied" BIGINT,
  "n__maximum_integration_threshold" DOUBLE,
  "n__exclude_above_line_applied" BIGINT,
  "n__exclude_above_line_depth_mean" DOUBLE,
  "n__exclude_below_line_applied" BIGINT,
  "n__bottom_offset" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__grid_reference_line" VARCHAR,
  "n__layer_top_to_reference_line_depth" DOUBLE,
  "n__layer_top_to_reference_line_range" DOUBLE,
  "n__layer_bottom_to_reference_line_depth" DOUBLE,
  "n__layer_bottom_to_reference_line_range" DOUBLE,
  "n__exclude_below_line_depth_min" DOUBLE,
  "n__exclude_below_line_range_min" DOUBLE,
  "n__exclude_below_line_depth_max" DOUBLE,
  "n__exclude_below_line_range_max" DOUBLE,
  "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" DOUBLE,
  "n__heave_max" DOUBLE,
  "n__bottom_line_depth_mean" DOUBLE,
  "n__bottom_max_sv" DOUBLE,
  "n__bottom_kurtosis" DOUBLE,
  "n__bottom_skewness" DOUBLE,
  "n__heave_mean" DOUBLE
);

September

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494.september
  • 4.13 MB
  • 39619 rows
  • 92 columns
Loading...

CREATE TABLE september (
  "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" DOUBLE,
  "n__layer_depth_max" DOUBLE,
  "n__ping_s" BIGINT,
  "n__ping_e" BIGINT,
  "n__ping_m" BIGINT,
  "n__dist_s" DOUBLE,
  "n__dist_e" DOUBLE,
  "n__dist_m" DOUBLE,
  "n__vl_start" DOUBLE,
  "n__vl_end" DOUBLE,
  "n__vl_mid" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__noise_sv_1m" DOUBLE,
  "n__minimum_sv_threshold_applied" BIGINT,
  "n__minimum_integration_threshold" DOUBLE,
  "n__maximum_sv_threshold_applied" BIGINT,
  "n__maximum_integration_threshold" DOUBLE,
  "n__exclude_above_line_applied" BIGINT,
  "n__exclude_above_line_depth_mean" DOUBLE,
  "n__exclude_below_line_applied" BIGINT,
  "n__bottom_offset" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__grid_reference_line" VARCHAR,
  "n__layer_top_to_reference_line_depth" DOUBLE,
  "n__layer_top_to_reference_line_range" DOUBLE,
  "n__layer_bottom_to_reference_line_depth" DOUBLE,
  "n__layer_bottom_to_reference_line_range" DOUBLE,
  "n__exclude_below_line_depth_min" DOUBLE,
  "n__exclude_below_line_range_min" DOUBLE,
  "n__exclude_below_line_depth_max" DOUBLE,
  "n__exclude_below_line_range_max" DOUBLE,
  "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" DOUBLE,
  "n__heave_max" DOUBLE,
  "n__bottom_line_depth_mean" DOUBLE,
  "n__bottom_max_sv" DOUBLE,
  "n__bottom_kurtosis" DOUBLE,
  "n__bottom_skewness" DOUBLE,
  "n__heave_mean" DOUBLE
);

Table 3

@usgov.doe_gov_alfa_mhk_biological_monitoring_stationary_depl_b751c494.table_3
  • 4.11 MB
  • 40203 rows
  • 92 columns
Loading...

CREATE TABLE table_3 (
  "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" DOUBLE,
  "n__layer_depth_max" DOUBLE,
  "n__ping_s" BIGINT,
  "n__ping_e" BIGINT,
  "n__ping_m" BIGINT,
  "n__dist_s" DOUBLE,
  "n__dist_e" DOUBLE,
  "n__dist_m" DOUBLE,
  "n__vl_start" DOUBLE,
  "n__vl_end" DOUBLE,
  "n__vl_mid" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__noise_sv_1m" DOUBLE,
  "n__minimum_sv_threshold_applied" BIGINT,
  "n__minimum_integration_threshold" DOUBLE,
  "n__maximum_sv_threshold_applied" BIGINT,
  "n__maximum_integration_threshold" DOUBLE,
  "n__exclude_above_line_applied" BIGINT,
  "n__exclude_above_line_depth_mean" DOUBLE,
  "n__exclude_below_line_applied" BIGINT,
  "n__bottom_offset" DOUBLE,
  "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" DOUBLE,
  "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" DOUBLE,
  "n__grid_reference_line" VARCHAR,
  "n__layer_top_to_reference_line_depth" DOUBLE,
  "n__layer_top_to_reference_line_range" DOUBLE,
  "n__layer_bottom_to_reference_line_depth" DOUBLE,
  "n__layer_bottom_to_reference_line_range" DOUBLE,
  "n__exclude_below_line_depth_min" DOUBLE,
  "n__exclude_below_line_range_min" DOUBLE,
  "n__exclude_below_line_depth_max" DOUBLE,
  "n__exclude_below_line_range_max" DOUBLE,
  "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" DOUBLE,
  "n__heave_max" DOUBLE,
  "n__bottom_line_depth_mean" DOUBLE,
  "n__bottom_max_sv" DOUBLE,
  "n__bottom_kurtosis" DOUBLE,
  "n__bottom_skewness" DOUBLE,
  "n__heave_mean" DOUBLE
);

Share link

Anyone who has the link will be able to view this.