WHOLESCALE: Seismic Survey Metadata From San Emidio Nevada 2021
Department of Energy
@usgov.doe_gov_wholescale_seismic_survey_metadata_from_san_em_5a989ecc
Department of Energy
@usgov.doe_gov_wholescale_seismic_survey_metadata_from_san_em_5a989ecc
CREATE TABLE sac_file_metadata (
"path" VARCHAR,
"traces" BIGINT,
"t0" TIMESTAMP,
"next_t0" TIMESTAMP,
"dt" DOUBLE,
"length_s" DOUBLE,
"length_samples" BIGINT,
"lat" DOUBLE,
"lon" DOUBLE,
"elev" DOUBLE
);
CREATE TABLE station_locations_and_orientations (
"name" VARCHAR,
"data_sn" VARCHAR,
"station_type_smart_solo_data_cube" VARCHAR,
"rtk_latitude" DOUBLE,
"rtk_longitude" DOUBLE,
"rtk_ellipsoidal_height" DOUBLE,
"easting_rms" DOUBLE,
"northing_rms" DOUBLE,
"elevation_rms" DOUBLE,
"average_seismograph_lat_deg" DOUBLE,
"average_seismograph_lon_deg" DOUBLE,
"average_seismograph_othometric_hieght_above_geoid_m" DOUBLE,
"seismograph_e_std_dev_m" DOUBLE,
"seismograph_n_std_dev_m" DOUBLE,
"seismograph_h_std_dev_m" DOUBLE,
"seismograph_rtk_e_m" DOUBLE,
"seismograph_rtk_n_m" DOUBLE,
"seismograph_rtk_h_m" DOUBLE,
"demobilization_sensor_orientation_degrees_true_north" BIGINT,
"seismograph_sampling_rate_sps" BIGINT,
"seismograph_gain_v_v" BIGINT,
"ggeophone_sensitivity_v_m_s" DOUBLE,
"geophone_natural_frequency_hz" DOUBLE,
"geophone_damping" DOUBLE,
"positive_up_vertical_velocity_scaling_factor" DOUBLE,
"positive_north_velocity_scaling_factor" DOUBLE,
"positive_east_velocity_scaling_factor" DOUBLE
);
Anyone who has the link will be able to view this.