Baselight
Sign In

CAES 2014 Chemical Analyses Of Thermal Wells And Springs In Southeastern Idaho

Department of Energy

@usgov.doe_gov_caes_2014_chemical_analyses_of_thermal_wells_a_60b3bab6

Loading...
Loading...

About this Dataset

CAES 2014 Chemical Analyses Of Thermal Wells And Springs In Southeastern Idaho

This dataset contains chemical analyses for thermal wells and springs in Southeastern Idaho. Data includes all major cations, major anions, pH, collection temperature, and some trace metals. These samples were collected in 2014 by the Center for Advanced Energy Studies (CAES), and are part of a continuous effort to analyze the geothermal potential of Southeastern Idaho.
Organization: Department of Energy
Last updated: 2025-01-11T21:58:08.883823
Tags: anions, aqueous, aqueous-chemistry, base-metals, cations, chemical-analysis, common-analytes, dissolved-constituents, eastern-snake-river-plain, geochemistry, geothermal, geothermal-potential, idaho, ph, snake-river-plain, southeast-idaho, southeastern-idaho, spring, springs, temperature, trace-metals, usgincm-aqueous-chemistry-basemetals1-10, usgincm-aqueous-chemistry-commonanalytes1-10, usgincm-aqueous-chemistry-majordissolvedconstituents1-10, usgincm-aqueous-chemistry-minordissolvedconstituents1-10, usgincm-aqueous-chemistry-nitrogen1-10, usgincm-aqueous-chemistry-waterquality1-10, water-quality, well, wells

Tables

Common Analytes

@usgov.doe_gov_caes_2014_chemical_analyses_of_thermal_wells_a_60b3bab6.common_analytes
  • 51.46 kB
  • 42 rows
  • 58 columns
Loading... 
CREATE TABLE common_analytes (
  "analysisuri" VARCHAR,
  "analysisname" VARCHAR,
  "notes" VARCHAR,
  "samplingfeaturename" VARCHAR,
  "samplingfeatureuri" VARCHAR,
  "samplingfeaturetype" VARCHAR,
  "othersiteid" VARCHAR,
  "specimenid" VARCHAR,
  "label" VARCHAR,
  "specimendescription" VARCHAR,
  "specimenuri" VARCHAR,
  "specimencollectiondate" TIMESTAMP,
  "specimencollectionmethod" VARCHAR,
  "otheranalyticaldata" VARCHAR,
  "drilleddepth_ft" DOUBLE,
  "fluidtemperature_c" DOUBLE,
  "discharge" DOUBLE,
  "dischargeunits" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "latdegree" DOUBLE,
  "longdegree" DOUBLE,
  "srs" VARCHAR,
  "locationuncertaintystatement" VARCHAR,
  "plssmeridians" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "section" BIGINT,
  "sectionpart" VARCHAR,
  "elevation_ft_msl" BIGINT,
  "source" VARCHAR,
  "sourceuri" VARCHAR,
  "metadatauri" VARCHAR,
  "analysisdatetime" TIMESTAMP,
  "laboratory" VARCHAR,
  "analyticalprocedure" VARCHAR,
  "fractionanalyzed" VARCHAR,
  "br_mgl" DOUBLE,
  "ca_mgl" DOUBLE,
  "cl_mgl" DOUBLE,
  "f_mgl" DOUBLE,
  "fe_mgl" DOUBLE,
  "fetot_mgl" DOUBLE,
  "k_mgl" DOUBLE,
  "na_mgl" DOUBLE,
  "na_k_mgl" DOUBLE,
  "no3_mgl" DOUBLE,
  "sio2_mgl" DOUBLE,
  "so4_mgl" DOUBLE,
  "sr_mgl" DOUBLE,
  "alkalinity_mgl" DOUBLE,
  "alkalinity_method" VARCHAR,
  "bicarbonate_mgl" DOUBLE,
  "carbonate_mgl" DOUBLE,
  "hardness_caco3_mgl" DOUBLE,
  "hardness_method" VARCHAR,
  "totaldissolvedsolids_mgl" DOUBLE,
  "totaldissolvedsolids_method" VARCHAR
);

Major Dissolved Constituents

@usgov.doe_gov_caes_2014_chemical_analyses_of_thermal_wells_a_60b3bab6.major_dissolved_constituents
  • 46.46 kB
  • 42 rows
  • 52 columns
Loading... 
CREATE TABLE major_dissolved_constituents (
  "analysisuri" VARCHAR,
  "analysisname" VARCHAR,
  "notes" VARCHAR,
  "samplingfeaturename" VARCHAR,
  "samplingfeatureuri" VARCHAR,
  "samplingfeaturetype" VARCHAR,
  "othersiteid" VARCHAR,
  "specimenid" VARCHAR,
  "label" VARCHAR,
  "specimendescription" VARCHAR,
  "specimenuri" VARCHAR,
  "specimencollectiondate" TIMESTAMP,
  "specimencollectionmethod" VARCHAR,
  "otheranalyticaldata" VARCHAR,
  "drilleddepth_ft" DOUBLE,
  "fluidtemperature_c" DOUBLE,
  "discharge" DOUBLE,
  "dischargeunits" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "latdegree" DOUBLE,
  "longdegree" DOUBLE,
  "srs" VARCHAR,
  "locationuncertaintystatement" VARCHAR,
  "plssmeridians" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "section" BIGINT,
  "sectionpart" VARCHAR,
  "elevation_ft_msl" BIGINT,
  "source" VARCHAR,
  "sourceuri" VARCHAR,
  "metadatauri" VARCHAR,
  "analysisdatetime" TIMESTAMP,
  "laboratory" VARCHAR,
  "analyticalprocedure" VARCHAR,
  "ca_mgl" DOUBLE,
  "cl_mgl" DOUBLE,
  "f_mgl" DOUBLE,
  "k_mgl" DOUBLE,
  "mg_mgl" DOUBLE,
  "na_mgl" DOUBLE,
  "na_k_mgl" DOUBLE,
  "sio2_mgl" DOUBLE,
  "so4_mgl" DOUBLE,
  "cation_total" DOUBLE,
  "anion_total" DOUBLE,
  "alkalinity_mgl" DOUBLE,
  "alkalinity_method" VARCHAR,
  "chargebalance_pct" DOUBLE,
  "hardness_caco2" DOUBLE,
  "hardness_method" VARCHAR
);

Minor Dissolved Constituents

@usgov.doe_gov_caes_2014_chemical_analyses_of_thermal_wells_a_60b3bab6.minor_dissolved_constituents
  • 44.7 kB
  • 42 rows
  • 52 columns
Loading... 
CREATE TABLE minor_dissolved_constituents (
  "analysisuri" VARCHAR,
  "analysisname" VARCHAR,
  "notes" VARCHAR,
  "samplingfeaturename" VARCHAR,
  "samplingfeatureuri" VARCHAR,
  "samplingfeaturetype" VARCHAR,
  "othersiteid" VARCHAR,
  "specimenid" VARCHAR,
  "label" VARCHAR,
  "specimendescription" VARCHAR,
  "specimenuri" VARCHAR,
  "specimencollectiondate" TIMESTAMP,
  "specimencollectionmethod" VARCHAR,
  "otheranalyticaldata" VARCHAR,
  "drilleddepth_ft" DOUBLE,
  "fluidtemperature_c" DOUBLE,
  "discharge" DOUBLE,
  "dischargeunits" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "latdegree" DOUBLE,
  "longdegree" DOUBLE,
  "srs" VARCHAR,
  "locationuncertaintystatement" VARCHAR,
  "plssmeridians" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "section" BIGINT,
  "sectionpart" VARCHAR,
  "elevation_ft_msl" BIGINT,
  "source" VARCHAR,
  "sourceuri" VARCHAR,
  "metadatauri" VARCHAR,
  "analysisdatetime" TIMESTAMP,
  "laboratory" VARCHAR,
  "analyticalprocedure" VARCHAR,
  "b_mgl" DOUBLE,
  "br_mgl" DOUBLE,
  "fe_mgl" DOUBLE,
  "h_mgl" DOUBLE,
  "i_mgl" DOUBLE,
  "mn_mgl" DOUBLE,
  "nh4_mgl" DOUBLE,
  "no2_field_mgl" DOUBLE,
  "no2_lab_mgl" DOUBLE,
  "no3_field_mgl" DOUBLE,
  "no3_lab_mgl" DOUBLE,
  "oh_mgl" DOUBLE,
  "po4_as_p_mgl" DOUBLE,
  "rb_mgl" DOUBLE,
  "sr_mgl" DOUBLE,
  "zr_mgl" DOUBLE
);

Nitrogen

@usgov.doe_gov_caes_2014_chemical_analyses_of_thermal_wells_a_60b3bab6.nitrogen
  • 42.51 kB
  • 42 rows
  • 49 columns
Loading... 
CREATE TABLE nitrogen (
  "analysisuri" VARCHAR,
  "analysisname" VARCHAR,
  "notes" VARCHAR,
  "samplingfeaturename" VARCHAR,
  "samplingfeatureuri" VARCHAR,
  "samplingfeaturetype" VARCHAR,
  "othersiteid" VARCHAR,
  "specimenid" VARCHAR,
  "label" VARCHAR,
  "specimendescription" VARCHAR,
  "specimenuri" VARCHAR,
  "specimencollectiondate" TIMESTAMP,
  "specimencollectionmethod" VARCHAR,
  "otheranalyticaldata" VARCHAR,
  "drilleddepth_ft" DOUBLE,
  "fluidtemperature_c" DOUBLE,
  "discharge" DOUBLE,
  "dischargeunits" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "latdegree" DOUBLE,
  "longdegree" DOUBLE,
  "srs" VARCHAR,
  "locationuncertaintystatement" VARCHAR,
  "plssmeridians" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "section" BIGINT,
  "sectionpart" VARCHAR,
  "elevation_ft_msl" BIGINT,
  "source" VARCHAR,
  "sourceuri" VARCHAR,
  "metadatauri" VARCHAR,
  "analysisdatetime" TIMESTAMP,
  "laboratory" VARCHAR,
  "analyticalprocedure" VARCHAR,
  "n_kjeldahl_mgl" DOUBLE,
  "nh4_as_n_mgl" DOUBLE,
  "nh4_mgl" DOUBLE,
  "nitrate_field_mgl" DOUBLE,
  "nitrate_lab_mgl" DOUBLE,
  "nitrateplusnitrite_mgl" DOUBLE,
  "nitrite_field_mgl" DOUBLE,
  "nitrite_lab_mgl" DOUBLE,
  "no_mgl" DOUBLE,
  "no2_field_mgl" DOUBLE,
  "no2_lab_mgl" DOUBLE,
  "no3_field_mgl" DOUBLE,
  "no3_lab_mgl" DOUBLE
);

Water Quality

@usgov.doe_gov_caes_2014_chemical_analyses_of_thermal_wells_a_60b3bab6.water_quality
  • 41.48 kB
  • 42 rows
  • 47 columns
Loading... 
CREATE TABLE water_quality (
  "analysisuri" VARCHAR,
  "analysisname" VARCHAR,
  "notes" VARCHAR,
  "samplingfeaturename" VARCHAR,
  "samplingfeatureuri" VARCHAR,
  "samplingfeaturetype" VARCHAR,
  "othersiteid" VARCHAR,
  "specimenid" VARCHAR,
  "label" VARCHAR,
  "specimendescription" VARCHAR,
  "specimenuri" VARCHAR,
  "specimencollectiondate" TIMESTAMP,
  "specimencollectionmethod" VARCHAR,
  "otheranalyticaldata" VARCHAR,
  "drilleddepth_ft" BIGINT,
  "fluidtemperature_c" DOUBLE,
  "discharge" BIGINT,
  "dischargeunits" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "latdegree" DOUBLE,
  "longdegree" DOUBLE,
  "srs" VARCHAR,
  "locationuncertaintystatement" VARCHAR,
  "plssmeridians" VARCHAR,
  "township" VARCHAR,
  "range" VARCHAR,
  "section" BIGINT,
  "sectionpart" VARCHAR,
  "elevation_ft_msl" BIGINT,
  "source" VARCHAR,
  "sourceuri" VARCHAR,
  "metadatauri" VARCHAR,
  "analysisdatetime" TIMESTAMP,
  "laboratory" VARCHAR,
  "analyticalprocedure" VARCHAR,
  "ph_field" DOUBLE,
  "ph_lab" BIGINT,
  "specificconductance_ms" BIGINT,
  "conductancenote" DOUBLE,
  "conductance_method" VARCHAR,
  "totaldissolvedsolids_mgl" DOUBLE,
  "totaldissolvedsolids_method" VARCHAR,
  "totalsuspendedsolids_mgl" BIGINT,
  "totalsuspendedsolids_method" VARCHAR,
  "turbidity_ntu" BIGINT,
  "turbidity_method" VARCHAR
);

Share link

Anyone who has the link will be able to view this.