Washington State Play Fairway Analysis - Passive Monitoring Of St. Helens Shear Zone For Tomography And Precision Microseismic Event Detection
Department of Energy
@usgov.doe_gov_washington_state_play_fairway_analysis_passive_d3b03a7e
Department of Energy
@usgov.doe_gov_washington_state_play_fairway_analysis_passive_d3b03a7e
CREATE TABLE all_events (
"latitude" DOUBLE,
"longitude" DOUBLE,
"depth" DOUBLE,
"time" TIMESTAMP,
"pnsnid" BIGINT
);
CREATE TABLE focal_mechanism_summary (
"pnsnid" BIGINT,
"magnitude" DOUBLE,
"date" TIMESTAMP,
"time" VARCHAR,
"lat_pnsn" DOUBLE,
"lon_pnsn" DOUBLE,
"depth_pnsn" DOUBLE,
"lat_reloc" DOUBLE,
"lon_reloc" DOUBLE,
"depth_relo" DOUBLE,
"lat_hypore" DOUBLE,
"lon_hypore" DOUBLE,
"depth_hypo" DOUBLE,
"strike" BIGINT,
"dip" BIGINT,
"rake" BIGINT
);
Anyone who has the link will be able to view this.