Polycyclic Aromatic Hydrocarbon Samples - 2011-2023 - OSPR [ds714]
State of California
@usgov.ca_gov_polycyclic_aromatic_hydrocarbon_samples_2011_to_44644853
State of California
@usgov.ca_gov_polycyclic_aromatic_hydrocarbon_samples_2011_to_44644853
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"objectid" BIGINT,
"lab_num" VARCHAR,
"sample_typ" VARCHAR,
"sample_id" VARCHAR,
"medium" VARCHAR,
"region" VARCHAR,
"location" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"date_col" TIMESTAMP,
"time_col" TIMESTAMP,
"date_rec" TIMESTAMP,
"date_extrc" TIMESTAMP,
"date_analy" TIMESTAMP,
"mass_vol_extrc" DOUBLE,
"dry_samp_mass" DOUBLE,
"moisture" DOUBLE,
"rl" VARCHAR,
"measure" VARCHAR,
"naph" DOUBLE,
"f2_menaph" DOUBLE,
"f1_menaph" DOUBLE,
"f2_6_menaph" DOUBLE,
"f2_3_5_menaph" DOUBLE,
"c1_naph" DOUBLE,
"c2_naph" DOUBLE,
"c3_naph" DOUBLE,
"c4_naph" DOUBLE,
"biphenyl" DOUBLE,
"acy" DOUBLE,
"ace" DOUBLE,
"fluor" DOUBLE,
"f1_mefluor" DOUBLE,
"c1_fluor" DOUBLE,
"c2_fluor" DOUBLE,
"c3_fluor" DOUBLE,
"dbt" DOUBLE,
"f4_medbt" DOUBLE,
"c1_dbt" DOUBLE,
"c2_dbt" DOUBLE,
"c3_dbt" DOUBLE,
"phen" DOUBLE,
"f1_mephen" DOUBLE,
"f3_6_dimeph" DOUBLE,
"c1_phen_ant" DOUBLE,
"c2_phen_ant" DOUBLE,
"c3_phen_ant" DOUBLE,
"c4_phen_ant" DOUBLE,
"ant" DOUBLE,
"fluorant" DOUBLE,
"f2_mefluorant" DOUBLE,
"c1_fluorant_pyr" DOUBLE,
"c2_fluorant_pyr" DOUBLE,
"c3_fluorant_pyr" DOUBLE,
"c4_fluorant_pyr" DOUBLE,
"pyr" DOUBLE,
"b_a_ant" DOUBLE,
"chry" DOUBLE,
"c1_chry" DOUBLE,
"c2_chry" DOUBLE,
"c3_chry" DOUBLE,
"c4_chry" DOUBLE,
"b_b_fluorant" DOUBLE,
"b_k_fluorant" DOUBLE,
"b_e_pyr" DOUBLE,
"b_a_pyr" DOUBLE,
"pery" DOUBLE,
"idp" DOUBLE,
"d_a_h_ant" DOUBLE,
"c1_d_a_h_ant" VARCHAR,
"c2_d_a_h_ant" DOUBLE,
"c3_d_a_h_ant" VARCHAR,
"b_g_h_i_pe" DOUBLE,
"sum_pah" DOUBLE,
"per_recov" VARCHAR,
"naph_d8" DOUBLE,
"biphen_d10" DOUBLE,
"ace_d10" DOUBLE,
"phen_d10" DOUBLE,
"pyr_d10" DOUBLE,
"b_a_ant_d12" DOUBLE,
"pery_d12" DOUBLE,
"chry_d12" DOUBLE,
"b_g_h_i_pery_d12" DOUBLE,
"avg_recov" DOUBLE,
"b_b_thph" DOUBLE,
"c1_b_b_thph" DOUBLE,
"c2_b_b_thph" DOUBLE,
"c3_b_b_thph" DOUBLE,
"c4_b_b_thph" DOUBLE,
"cis_dec" DOUBLE,
"trans_dec" DOUBLE,
"dec" DOUBLE,
"c1_dec" DOUBLE,
"c2_dec" DOUBLE,
"c3_dec" DOUBLE,
"c4_dec" DOUBLE,
"ret" DOUBLE
);
Anyone who has the link will be able to view this.