About this Dataset

Trace Element Concentration Data

Selenium, Arsenic, Cadmium data daily concentration for USGS stream sites.

This dataset is associated with the following publication:
Beyene, M., S. Leibowitz, C. Dunn, and K. Bladon. To Burn or Not to Burn: An Empirical Assessment of the Impacts of Wildfires and Prescribed Fires on Trace Element Concentrations in Western US Streams. SCIENCE OF THE TOTAL ENVIRONMENT. Elsevier BV, AMSTERDAM, NETHERLANDS, 863(10): 160731, (2023).
Organization: U.S. Environmental Protection Agency
Last updated: 2023-02-07T10:29:41.096785
Tags: arsenic, cadmium, prescribed-fires, selenium, water-quality, western-us-wildfires

Tables

Sites Arsenic Data

@usgov.epa_gov_trace_element_concentration_data.sites_arsenic_data

82.28 kB
144 rows
85 columns

CREATE TABLE sites_arsenic_data (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "watershed_and_climate_characteristics_for_the_37_studi_a64534ce" VARCHAR  -- Watershed And Climate Characteristics For The 37 Studied USGS Stream Sites With Arsenic Data.,
  "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,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- 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" VARCHAR  -- 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,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84
);

Sites Arsenic Discharge Data

@usgov.epa_gov_trace_element_concentration_data.sites_arsenic_discharge_data

1.21 MB
14,610 rows
41 columns

CREATE TABLE sites_arsenic_discharge_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "day" BIGINT,
  "month" BIGINT,
  "year" BIGINT,
  "n_6037500" VARCHAR  -- 6037500,
  "n_6154410" VARCHAR  -- 6154410,
  "n_6299980" VARCHAR  -- 6299980,
  "n_6307600" VARCHAR  -- 6307600,
  "n_6316400" VARCHAR  -- 6316400,
  "n_6317000" DOUBLE  -- 6317000,
  "n_6324000" VARCHAR  -- 6324000,
  "n_6324500" DOUBLE  -- 6324500,
  "n_6326500" DOUBLE  -- 6326500,
  "n_6386500" VARCHAR  -- 6386500,
  "n_6426500" VARCHAR  -- 6426500,
  "n_7103700" DOUBLE  -- 7103700,
  "n_7103970" VARCHAR  -- 7103970,
  "n_7103970_1" VARCHAR  -- 7103970.1,
  "n_7104905" VARCHAR  -- 7104905,
  "n_7105500" DOUBLE  -- 7105500,
  "n_7105530" VARCHAR  -- 7105530,
  "n_7105800" DOUBLE  -- 7105800,
  "n_7106000" VARCHAR  -- 7106000,
  "n_9041090" VARCHAR  -- 9041090,
  "n_9209400" DOUBLE  -- 9209400,
  "arsenic_discharge_m3_sec_09303000" VARCHAR  -- Arsenic Discharge..m3.sec..09303000,
  "n_9304800" DOUBLE  -- 9304800,
  "n_9466500" DOUBLE  -- 9466500,
  "n_9498500" DOUBLE  -- 9498500,
  "n_9504000" VARCHAR  -- 9504000,
  "n_9504000_1" VARCHAR  -- 9504000.1,
  "n_9508500" VARCHAR  -- 9508500,
  "n_9508500_1" VARCHAR  -- 9508500.1,
  "n_9512800" DOUBLE  -- 9512800,
  "n_12334510" DOUBLE  -- 12334510,
  "n_12340000" DOUBLE  -- 12340000,
  "n_12340000_1" DOUBLE  -- 12340000.1,
  "n_12340500" DOUBLE  -- 12340500,
  "arsenic_discharge_m3_sec_12413000" DOUBLE  -- Arsenic Discharge..m3.sec..12413000,
  "n_12413500" VARCHAR  -- 12413500,
  "n_12413860" VARCHAR  -- 12413860
);

Sites Cadmium Data

@usgov.epa_gov_trace_element_concentration_data.sites_cadmium_data

75.13 kB
28 rows
85 columns

CREATE TABLE sites_cadmium_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "watershed_area" DOUBLE,
  "per_burn_area" DOUBLE,
  "per_ripburn_area" DOUBLE,
  "per_burn_mh" DOUBLE,
  "per_ripburn_mh" DOUBLE,
  "dist_st_burn" DOUBLE,
  "elevation" DOUBLE,
  "slope" DOUBLE,
  "facingn" DOUBLE,
  "facings" DOUBLE,
  "water_dpt" DOUBLE,
  "rock_dpt" DOUBLE,
  "permeability" DOUBLE,
  "cti" DOUBLE,
  "soil_water_capacity" DOUBLE,
  "soil_bdh" DOUBLE,
  "fert" DOUBLE,
  "manure" DOUBLE,
  "feo" DOUBLE,
  "sio" DOUBLE,
  "s2o" DOUBLE,
  "p2o" DOUBLE,
  "nao" DOUBLE,
  "ko" DOUBLE,
  "mgo" DOUBLE,
  "cao" DOUBLE,
  "alo" DOUBLE,
  "bed_perm" DOUBLE,
  "clayicide_use_clay_content" DOUBLE  -- Clayicide Use (%clay Content),
  "sand" DOUBLE,
  "pest" DOUBLE,
  "carbonate_residual" DOUBLE,
  "noncarbonate_residual" DOUBLE,
  "alkaline_intrusive_volcanic_rock" DOUBLE,
  "silicic_residual" DOUBLE,
  "extrusive_volcanic_rock" DOUBLE,
  "colluvial_sediment" DOUBLE,
  "glacial_till_clayey" BIGINT  -- Glacial Till, Clayey,
  "glacial_till_loamy" DOUBLE  -- Glacial Till, Loamy,
  "glacial_till_coarse" DOUBLE  -- Glacial Till, Coarse,
  "glacial_outwash_coarse" BIGINT  -- Glacial Outwash, Coarse,
  "glacial_lake_sediment_fine" DOUBLE  -- Glacial Lake Sediment, Fine,
  "glacial_outwash_coarse_1" BIGINT  -- Glacial Outwash, Coarse.1,
  "hydric_peat" BIGINT  -- Hydric, Peat,
  "eolian_sediment_coarse" DOUBLE  -- Eolian Sediment, Coarse,
  "eoalian_sediment_fine" DOUBLE  -- Eoalian Sediment, Fine,
  "saline_lake_sediment" DOUBLE,
  "alluvium_fine_textured_coastal_zone" DOUBLE,
  "coastal_zone_coarse" BIGINT  -- Coastal Zone, Coarse,
  "water" DOUBLE,
  "organic_matter_om_by_weight" DOUBLE  -- Organic Matter (%OM By Weight),
  "open_water" DOUBLE,
  "ice_snow" DOUBLE,
  "developed_openspace" DOUBLE,
  "developed_li" DOUBLE,
  "urb" DOUBLE,
  "barren" DOUBLE,
  "forest" DOUBLE,
  "short_veg" DOUBLE,
  "agri" DOUBLE,
  "wetland" DOUBLE,
  "rip_forest" DOUBLE,
  "rip_agri" DOUBLE,
  "rip_wetland" DOUBLE,
  "fall_ppt" DOUBLE,
  "winter_ppt" DOUBLE,
  "spring_ppt" DOUBLE,
  "summer_ppt" DOUBLE,
  "oct_mar_ppt" DOUBLE,
  "oct_june_ppt" DOUBLE,
  "annual_ppt" DOUBLE,
  "fall_temp" DOUBLE,
  "winter_temp" DOUBLE,
  "spring_temp" DOUBLE,
  "summer_temp" DOUBLE,
  "oct_mar_temp" DOUBLE,
  "annual_temp" DOUBLE,
  "climatology_temp" DOUBLE,
  "climatology_ppt" DOUBLE,
  "post_fire_fire" DOUBLE,
  "pre_fire_fire" DOUBLE,
  "soil_kfactor_erodibility_index" DOUBLE  -- SOil KFactor (Erodibility Index)
);

Sites Cadmium Flow Data

@usgov.epa_gov_trace_element_concentration_data.sites_cadmium_flow_data

917.86 kB
14,610 rows
32 columns

CREATE TABLE sites_cadmium_flow_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "day" BIGINT,
  "month" BIGINT,
  "year" BIGINT,
  "n_6154410" VARCHAR  -- 6154410,
  "n_6306300" DOUBLE  -- 6306300,
  "n_6307600" VARCHAR  -- 6307600,
  "n_6307740" VARCHAR  -- 6307740,
  "n_6324500" DOUBLE  -- 6324500,
  "n_6326500" DOUBLE  -- 6326500,
  "n_7097000" VARCHAR  -- 7097000,
  "n_7103970" VARCHAR  -- 7103970,
  "n_7105500" DOUBLE  -- 7105500,
  "n_9431500" VARCHAR  -- 9431500,
  "n_9448500" DOUBLE  -- 9448500,
  "n_9448500_1" DOUBLE  -- 9448500.1,
  "cadm09448500_2" DOUBLE,
  "cadmium09466500" DOUBLE,
  "n_9466500_1" DOUBLE  -- 9466500.1,
  "n_9498500" DOUBLE  -- 9498500,
  "n_9498500_1" DOUBLE  -- 9498500.1,
  "n_9498500_2" DOUBLE  -- 9498500.2,
  "n_9504000" DOUBLE  -- 9504000,
  "n_9504000_1" DOUBLE  -- 9504000.1,
  "n_9504000_2" DOUBLE  -- 9504000.2,
  "n_9508500" VARCHAR  -- 9508500,
  "n_9508500_1" VARCHAR  -- 9508500.1,
  "n_9512800" DOUBLE  -- 9512800,
  "n_12334510" DOUBLE  -- 12334510,
  "n_12340000" DOUBLE  -- 12340000,
  "c12413000" DOUBLE,
  "n_12413500" VARCHAR  -- 12413500
);

Sites Daily Arsenic Data

@usgov.epa_gov_trace_element_concentration_data.sites_daily_arsenic_data

142.23 kB
14,612 rows
41 columns

CREATE TABLE sites_daily_arsenic_data (
  "unnamed_0" DOUBLE  -- Unnamed: 0,
  "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,
  "daily_arsenic_concentration_g_l_from_1980_2018_for_the_0e243342" VARCHAR  -- Daily Arsenic Concentration (µg/l) Data From 1980-2018 For The 37 Studied USGS Stream Sites.,
  "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,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40
);

Sites Daily Cadmium Data

@usgov.epa_gov_trace_element_concentration_data.sites_daily_cadmium_data

126.9 kB
14,612 rows
32 columns

CREATE TABLE sites_daily_cadmium_data (
  "unnamed_0" DOUBLE  -- Unnamed: 0,
  "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,
  "daily_cadmium_concentration_g_l_from_1980_2018_for_the_9cf11106" VARCHAR  -- Daily Cadmium Concentration (çg/l) Data From 1980-2018 For The 28 Studied USGS Stream Sites.,
  "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,
  "unnamed_31" VARCHAR  -- Unnamed: 31
);

Sites Daily Selenium Data

@usgov.epa_gov_trace_element_concentration_data.sites_daily_selenium_data

150.87 kB
14,612 rows
41 columns

CREATE TABLE sites_daily_selenium_data (
  "unnamed_0" DOUBLE  -- Unnamed: 0,
  "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,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "daily_selenium_concentration_g_l_from_1980_2018_for_th_c9e20ce6" VARCHAR  -- Daily Selenium Concentration (µg/l) Data From 1980-2018 For The 37 Studied USGS Stream Sites.,
  "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,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40
);

Sites Selenium Data

@usgov.epa_gov_trace_element_concentration_data.sites_selenium_data

80.79 kB
37 rows
85 columns

CREATE TABLE sites_selenium_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "watershed_area" DOUBLE,
  "per_burn_area" DOUBLE,
  "per_ripburn_area" DOUBLE,
  "per_burn_mh" DOUBLE,
  "per_ripburn_mh" DOUBLE,
  "dist_st_burn" DOUBLE,
  "elevation" DOUBLE,
  "slope" DOUBLE,
  "facingn" DOUBLE,
  "facings" DOUBLE,
  "water_dpt" DOUBLE,
  "rock_dpt" DOUBLE,
  "permeability" DOUBLE,
  "cti" DOUBLE,
  "soil_water_capacity" DOUBLE,
  "soil_bdh" DOUBLE,
  "fert" DOUBLE,
  "manure" DOUBLE,
  "feo" DOUBLE,
  "sio" DOUBLE,
  "s2o" DOUBLE,
  "p2o" DOUBLE,
  "nao" DOUBLE,
  "ko" DOUBLE,
  "mgo" DOUBLE,
  "cao" DOUBLE,
  "alo" DOUBLE,
  "bed_perm" DOUBLE,
  "clayicide_use_clay_content" DOUBLE  -- Clayicide Use (%clay Content),
  "sand" DOUBLE,
  "pest" DOUBLE,
  "carbonate_residual" DOUBLE,
  "noncarbonate_residual" DOUBLE,
  "alkaline_intrusive_volcanic_rock" DOUBLE,
  "silicic_residual" DOUBLE,
  "extrusive_volcanic_rock" DOUBLE,
  "colluvial_sediment" DOUBLE,
  "glacial_till_clayey" BIGINT  -- Glacial Till, Clayey,
  "glacial_till_loamy" DOUBLE  -- Glacial Till, Loamy,
  "glacial_till_coarse" DOUBLE  -- Glacial Till, Coarse,
  "glacial_outwash_coarse" BIGINT  -- Glacial Outwash, Coarse,
  "glacial_lake_sediment_fine" DOUBLE  -- Glacial Lake Sediment, Fine,
  "glacial_outwash_coarse_1" BIGINT  -- Glacial Outwash, Coarse.1,
  "hydric_peat" BIGINT  -- Hydric, Peat,
  "eolian_sediment_coarse" DOUBLE  -- Eolian Sediment, Coarse,
  "eoalian_sediment_fine" DOUBLE  -- Eoalian Sediment, Fine,
  "saline_lake_sediment" BIGINT,
  "alluvium_fine_textured_coastal_zone" DOUBLE,
  "coastal_zone_coarse" BIGINT  -- Coastal Zone, Coarse,
  "water" DOUBLE,
  "organic_matter_om_by_weight" DOUBLE  -- Organic Matter (%OM By Weight),
  "open_water" DOUBLE,
  "ice_snow" DOUBLE,
  "developed_openspace" DOUBLE,
  "developed_li" DOUBLE,
  "urb" DOUBLE,
  "barren" DOUBLE,
  "forest" DOUBLE,
  "short_veg" DOUBLE,
  "agri" DOUBLE,
  "wetland" DOUBLE,
  "rip_forest" DOUBLE,
  "rip_agri" DOUBLE,
  "rip_wetland" DOUBLE,
  "fall_ppt" DOUBLE,
  "winter_ppt" DOUBLE,
  "spring_ppt" DOUBLE,
  "summer_ppt" DOUBLE,
  "oct_mar_ppt" DOUBLE,
  "oct_june_ppt" DOUBLE,
  "annual_ppt" DOUBLE,
  "fall_temp" DOUBLE,
  "winter_temp" DOUBLE,
  "spring_temp" DOUBLE,
  "summer_temp" DOUBLE,
  "oct_mar_temp" DOUBLE,
  "annual_temp" DOUBLE,
  "climatology_temp" DOUBLE,
  "climatology_ppt" DOUBLE,
  "post_fire_fire" DOUBLE,
  "pre_fire_fire" DOUBLE,
  "kfact" DOUBLE
);