Data From: Release And Establishment Of The Weevil Mecinus Janthiniformis For Biological Control Of Dalmatian Toadflax In Southern California

CREATE TABLE consolidated_hv (
  "mean_values_for_each_site_at_hungry_valley_weather_fro_810bc6c1" VARCHAR  -- Mean Values For Each Site At Hungry Valley; Weather Data From Sandberg, CA Station.,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "sorted_by_year_loc_site" VARCHAR  -- Sorted By Year, Loc, Site,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30
);

CREATE TABLE cover_2008_hv (
  "status" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "exotic" VARCHAR,
  "exotic_1" VARCHAR,
  "exotic_2" VARCHAR,
  "exotic_3" VARCHAR,
  "exotic_4" VARCHAR,
  "native" VARCHAR,
  "native_1" VARCHAR,
  "native_2" VARCHAR,
  "native_3" VARCHAR,
  "native_4" VARCHAR,
  "native_5" VARCHAR,
  "native_6" VARCHAR,
  "native_7" VARCHAR,
  "native_8" VARCHAR,
  "native_9" VARCHAR,
  "native_10" VARCHAR,
  "native_11" VARCHAR,
  "native_12" VARCHAR,
  "native_13" VARCHAR,
  "native_14" VARCHAR,
  "exotic_5" VARCHAR,
  "native_15" VARCHAR,
  "native_16" VARCHAR,
  "native_17" VARCHAR,
  "native_18" VARCHAR,
  "native_19" VARCHAR,
  "native_20" VARCHAR,
  "native_21" VARCHAR,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" DOUBLE  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" DOUBLE  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72
);

CREATE TABLE cover_2008_hv_meta (
  "n__collected_by_d_woods_and_v_popescu_california_dept__719c8269" VARCHAR  -- Data Collected By D. Woods And V. Popescu, California Dept. Of Food And Agriculture At Hungry Valley State Vehicular Recreation Area,
  "unnamed_1" VARCHAR  -- Unnamed: 1
);

CREATE TABLE cover_2013_hv (
  "year" DOUBLE,
  "date" TIMESTAMP,
  "site" VARCHAR,
  "trt" VARCHAR,
  "type" VARCHAR,
  "plant" VARCHAR,
  "cover" DOUBLE,
  "bc" DOUBLE,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

CREATE TABLE cover_2013_hv_meta (
  "vegetation_cover_based_on_line_intercept_n_100_per_tra_7d484810" VARCHAR  -- Vegetation Cover Based On Line Intercept (n=100 Per Transect), Thus Numbers Represent Percent.,
  "unnamed_1" VARCHAR  -- Unnamed: 1
);

CREATE TABLE dissections_2009_hv (
  "calculations_updated_5_29_20_by_ls" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "n_3620" VARCHAR  -- 3620,
  "n_453" VARCHAR  -- 453,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

CREATE TABLE dissections_2009_hv_meta (
  "dissection_of_dalmatian_toadflax_stems_at_hungry_valle_60abc1d2" VARCHAR  -- Dissection Of Dalmatian Toadflax Stems At Hungry Valley From 2009 To 2011,
  "unnamed_1" VARCHAR  -- Unnamed: 1
);

CREATE TABLE dissections_2012_hv (
  "year" BIGINT,
  "diss_date" TIMESTAMP,
  "date" TIMESTAMP,
  "site" VARCHAR,
  "trt" VARCHAR,
  "bc" BIGINT,
  "stem" BIGINT  -- Stem #,
  "stem_diam_bottom_mm" DOUBLE  -- Stem Diam Bottom (mm),
  "n__main_stem_length_cm" DOUBLE  -- Main Stem Length (cm),
  "total_meja" BIGINT,
  "meja_100_cm" DOUBLE,
  "infested" BIGINT,
  "diam_top_mm" DOUBLE  -- Diam Top (mm),
  "tip_of_stem_broken" VARCHAR,
  "side_branches_cm" DOUBLE  -- Side Branches (cm),
  "no_empty_chambers" BIGINT  -- No. Empty Chambers,
  "total_chamber_length" DOUBLE,
  "live_adults" VARCHAR,
  "dead_adults" VARCHAR,
  "dead_larvae" DOUBLE,
  "dead_pupae" DOUBLE,
  "parasitoid" VARCHAR,
  "live_pupa" VARCHAR,
  "live_larva" VARCHAR,
  "total_no_adults" BIGINT  -- Total No. Adults
);

CREATE TABLE dissections_2012_hv_meta (
  "variable_name" VARCHAR,
  "description_blank_cells_not_recorded_or_0" VARCHAR  -- Description; Blank Cells = Not Recorded Or 0.
);

CREATE TABLE stem_counts_hv (
  "hvsvra_condor_rd" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "number_of_toadflax_stems_in_25_x_50_cm_quadrat" VARCHAR
);

CREATE TABLE stem_counts_hv_meta (
  "number_of_dalmatian_toadflax_stems_in_25_x_50_cm_quadrat" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1
);

CREATE TABLE stem_height_hv (
  "year" BIGINT,
  "date" TIMESTAMP,
  "site" VARCHAR,
  "trt" VARCHAR,
  "stem" BIGINT,
  "ht" DOUBLE,
  "ppt" DOUBLE
);

CREATE TABLE stem_height_hv_meta (
  "variable_name" VARCHAR,
  "description" VARCHAR
);