Baselight
Sign In

Unified Field Study 5 (UFS-5)

Department of Energy

@usgov.doe_gov_unified_field_study_5_ufs_5

Loading...
Loading...

About this Dataset

Unified Field Study 5 (UFS-5)

The Unified Field Studies (UFS), established by the Algae Testbed Public-Private Partnership (ATP3), produced data on the effect of environmental and process conditions on algal growth rates and algal composition. The goal of the fifth Unified Field Study (UFS-5), performed December 2014 to March 2015, was to generate a robust inter-testbed dataset in algal biomass and lipid productivity and yield for two algal strains (Nannochloropsis oceanica KA32 and Chlorella vulgaris LRB-AZ-1201) as a function of different regional, and environmental conditions among sites by controlling non-geographical-related variables including production systems, production process and protocols, system scale, and algae strain. This experiment also compared the effect on productivity of three harvests per week with multiple dilution rates vs. one harvest per week with one dilution rate.

For more information about the UFS experiments see the reference resources 0.0 UFS-1 Experiment OpenEI Wiki Page, 0.1 ATP3 OpenEI Wiki Page, 0.2 Report on the Use of ATP3 UFS Data below, and 0.3 ATP3 UFS Journal Article.
Organization: Department of Energy
Last updated: 2024-03-12T23:57:13.229298
Tags: algae, algal-biomass, algal-composition, algal-growth, algal-productivities, algal-testbed, analysis, atp3, biochemical, bioenergy, biofuel, biomass, chlorella-vulgaris, cultivation-strategies, cultivation-trials, data, energy, environmental-conditions, fuels, harvest-yields, modeling, nannochloropsis-oceanica, pond, ponds, power, process-conditions, regional, renewable-energy, seasonal, strain, testbed, ufs, unified-field-study

Tables

1.2 UFS-5 KA32 Pond Operational And Harvest Summary Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_1_2_ufs_5_ka32_pond_operational_and_harvest_summary_data
  • 89.81 kB
  • 19,030 rows
  • 53 columns
Loading... 
CREATE TABLE n_1_2_ufs_5_ka32_pond_operational_and_harvest_summary_data (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "pondid" VARCHAR,
  "datetime" TIMESTAMP,
  "strainid" VARCHAR,
  "sourceid" VARCHAR,
  "batchid" VARCHAR,
  "treatmentid" VARCHAR,
  "time_between_harvests_days" VARCHAR,
  "harvest" VARCHAR  -- Harvest.,
  "harvest_vol_l" VARCHAR  -- Harvest.Vol..L.,
  "afdw_g_l" VARCHAR  -- AFDW..g.L.,
  "afdw_g" VARCHAR  -- AFDW..g.,
  "crash" VARCHAR,
  "comments" VARCHAR,
  "duration_days" DOUBLE,
  "depth_cm" VARCHAR,
  "evaporation_rate_cm_day" VARCHAR,
  "ph" VARCHAR,
  "salinity" VARCHAR,
  "temp_c" VARCHAR,
  "no3_mg_l" VARCHAR,
  "no3_pct_rsd" VARCHAR,
  "nh4_mg_l" VARCHAR,
  "nh4_pct_rsd" VARCHAR,
  "p_mg_l" VARCHAR,
  "p_pct_rsd" VARCHAR,
  "n_p_ratio" VARCHAR,
  "analytical_sample_id" VARCHAR,
  "tracking_id" VARCHAR,
  "dw_g_l" VARCHAR,
  "dw_rsd" VARCHAR,
  "afdw_g_l_52d579" VARCHAR  -- AFDW.g.L,
  "afdw_rsd" VARCHAR,
  "ash" VARCHAR,
  "od750" VARCHAR,
  "od750_pct_rsd" VARCHAR,
  "od680" VARCHAR,
  "od680_pct_rsd" VARCHAR,
  "no3_supplied_g" VARCHAR,
  "no3_utilized_g" VARCHAR,
  "no3_efficiency" VARCHAR  -- NO3.efficiency..,
  "no3_demand_g_n_g_afdw" VARCHAR,
  "nh4_supplied_g" VARCHAR,
  "nh4_utilized_g" VARCHAR,
  "nh4_efficiency" VARCHAR  -- NH4.efficiency..,
  "nh4_demand_g_n_g_afdw" VARCHAR,
  "p_supplied_g" VARCHAR,
  "p_utilized_g" VARCHAR,
  "p_efficiency" VARCHAR  -- P.efficiency..,
  "p_demand_g_p_g_afdw" VARCHAR,
  "mg_afdw_mol_par_input" VARCHAR,
  "mg_afdw_kw_gle_input" VARCHAR
);

1.3 UFS-5 LRB-AZ-1201 Pond Operational And Harvest Summary Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_1_3_ufs_5_lrb_az_1201_pond_operational_and_harvest_s_a3bd64f8
  • 77.91 kB
  • 17,757 rows
  • 53 columns
Loading... 
CREATE TABLE n_1_3_ufs_5_lrb_az_1201_pond_operational_and_harvest_s_a3bd64f8 (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "pondid" VARCHAR,
  "datetime" TIMESTAMP,
  "strainid" VARCHAR,
  "sourceid" VARCHAR,
  "batchid" VARCHAR,
  "treatmentid" VARCHAR,
  "time_between_harvests_days" VARCHAR,
  "harvest" VARCHAR  -- Harvest.,
  "harvest_vol_l" VARCHAR  -- Harvest.Vol..L.,
  "afdw_g_l" VARCHAR  -- AFDW..g.L.,
  "afdw_g" VARCHAR  -- AFDW..g.,
  "crash" VARCHAR,
  "comments" VARCHAR,
  "duration_days" DOUBLE,
  "depth_cm" VARCHAR,
  "evaporation_rate_cm_day" VARCHAR,
  "ph" VARCHAR,
  "salinity" VARCHAR,
  "temp_c" VARCHAR,
  "no3_mg_l" VARCHAR,
  "no3_pct_rsd" VARCHAR,
  "nh4_mg_l" VARCHAR,
  "nh4_pct_rsd" VARCHAR,
  "p_mg_l" VARCHAR,
  "p_pct_rsd" VARCHAR,
  "n_p_ratio" VARCHAR,
  "analytical_sample_id" VARCHAR,
  "tracking_id" VARCHAR,
  "dw_g_l" VARCHAR,
  "dw_rsd" VARCHAR,
  "afdw_g_l_52d579" VARCHAR  -- AFDW.g.L,
  "afdw_rsd" VARCHAR,
  "ash" VARCHAR,
  "od750" VARCHAR,
  "od750_pct_rsd" VARCHAR,
  "od680" VARCHAR,
  "od680_pct_rsd" VARCHAR,
  "no3_supplied_g" VARCHAR,
  "no3_utilized_g" VARCHAR,
  "no3_efficiency" VARCHAR  -- NO3.efficiency..,
  "no3_demand_g_n_g_afdw" VARCHAR,
  "nh4_supplied_g" VARCHAR,
  "nh4_utilized_g" VARCHAR,
  "nh4_efficiency" VARCHAR  -- NH4.efficiency..,
  "nh4_demand_g_n_g_afdw" VARCHAR,
  "p_supplied_g" VARCHAR,
  "p_utilized_g" VARCHAR,
  "p_efficiency" VARCHAR  -- P.efficiency..,
  "p_demand_g_p_g_afdw" VARCHAR,
  "mg_afdw_mol_par_input" VARCHAR,
  "mg_afdw_kw_gle_input" VARCHAR
);

2.2 UFS-5 KA32 Harvest Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_2_2_ufs_5_ka32_harvest_data
  • 13.52 kB
  • 142 rows
  • 14 columns
Loading... 
CREATE TABLE n_2_2_ufs_5_ka32_harvest_data (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "sourceid" VARCHAR,
  "batchid" VARCHAR,
  "date" VARCHAR,
  "pondid" VARCHAR,
  "treatmentid" VARCHAR,
  "harvest" BIGINT  -- Harvest.,
  "time_d" DOUBLE  -- Time..d.,
  "harvest_vol_l" DOUBLE  -- Harvest.Vol..L.,
  "afdw_g_l" DOUBLE  -- AFDW..g.L.,
  "afdw_g" DOUBLE  -- AFDW..g.,
  "crash" VARCHAR
);

2.3 UFS-5 LRB-AZ-1201 Harvest Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_2_3_ufs_5_lrb_az_1201_harvest_data
  • 13.3 kB
  • 127 rows
  • 14 columns
Loading... 
CREATE TABLE n_2_3_ufs_5_lrb_az_1201_harvest_data (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "sourceid" VARCHAR,
  "batchid" VARCHAR,
  "date" VARCHAR,
  "pondid" VARCHAR,
  "treatmentid" VARCHAR,
  "harvest" BIGINT  -- Harvest.,
  "time_d" DOUBLE  -- Time..d.,
  "harvest_vol_l" DOUBLE  -- Harvest.Vol..L.,
  "afdw_g_l" DOUBLE  -- AFDW..g.L.,
  "afdw_g" DOUBLE  -- AFDW..g.,
  "crash" VARCHAR
);

3.2 UFS-5 KA32 Instrumentation Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_3_2_ufs_5_ka32_instrumentation_data
  • 1.59 MB
  • 90,172 rows
  • 13 columns
Loading... 
CREATE TABLE n_3_2_ufs_5_ka32_instrumentation_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "pondid" VARCHAR,
  "strainid" VARCHAR,
  "datetime" VARCHAR,
  "date" VARCHAR,
  "ph" DOUBLE,
  "temp_c" DOUBLE  -- Temp (C),
  "cond_ms_cm" DOUBLE  -- Cond (mS.cm),
  "do_mg_l" DOUBLE  -- DO (mg.L),
  "do_sat" DOUBLE  -- DO (%sat),
  "sal_g_l" DOUBLE  -- Sal (g.L),
  "par_umol_m2_s" DOUBLE  -- PAR (umol.m2.s)
);

3.3 UFS-5 LRB-AZ-1201 Instrumentation Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_3_3_ufs_5_lrb_az_1201_instrumentation_data
  • 962.25 kB
  • 60,017 rows
  • 13 columns
Loading... 
CREATE TABLE n_3_3_ufs_5_lrb_az_1201_instrumentation_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "pondid" VARCHAR,
  "strainid" VARCHAR,
  "datetime" VARCHAR,
  "date" VARCHAR,
  "ph" DOUBLE,
  "temp_c" DOUBLE  -- Temp (C),
  "cond_ms_cm" DOUBLE  -- Cond (mS.cm),
  "do_mg_l" DOUBLE  -- DO (mg.L),
  "do_sat" DOUBLE  -- DO (%sat),
  "sal_g_l" DOUBLE  -- Sal (g.L),
  "par_umol_m2_s" DOUBLE  -- PAR (umol.m2.s)
);

3.5 UFS-5 Winter KA32 Daily Averaged Instrumentation Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_3_5_ufs_5_winter_ka32_daily_averaged_instrumentation_data
  • 42.96 kB
  • 1,044 rows
  • 14 columns
Loading... 
CREATE TABLE n_3_5_ufs_5_winter_ka32_daily_averaged_instrumentation_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "pondid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "ph" DOUBLE,
  "temp_avg_c" DOUBLE  -- Temp.avg (C),
  "temp_max_c" DOUBLE  -- Temp.max (C),
  "temp_min_c" DOUBLE  -- Temp.min (C),
  "cond_ms_cm" DOUBLE  -- Cond (mS.cm),
  "do_mg_l" DOUBLE  -- DO (mg.L),
  "do_sat" DOUBLE  -- DO (%sat),
  "sal_g_l" DOUBLE  -- Sal (g.L),
  "par_umol_m2_s" DOUBLE  -- PAR (umol.m2.s)
);

3.6 UFS-5 LRB-AZ-1201 Daily Averaged Instrumentation Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_3_6_ufs_5_lrb_az_1201_daily_averaged_instrumentation_data
  • 30.18 kB
  • 651 rows
  • 14 columns
Loading... 
CREATE TABLE n_3_6_ufs_5_lrb_az_1201_daily_averaged_instrumentation_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "pondid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "ph" DOUBLE,
  "temp_avg_c" DOUBLE  -- Temp.avg (C),
  "temp_max_c" DOUBLE  -- Temp.max (C),
  "temp_min_c" DOUBLE  -- Temp.min (C),
  "cond_ms_cm" DOUBLE  -- Cond (mS.cm),
  "do_mg_l" DOUBLE  -- DO (mg.L),
  "do_sat" DOUBLE  -- DO (%sat),
  "sal_g_l" DOUBLE  -- Sal (g.L),
  "par_umol_m2_s" DOUBLE  -- PAR (umol.m2.s)
);

4.2 UFS-5 KA32 Weather Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_4_2_ufs_5_ka32_weather_data
  • 224.55 kB
  • 18,482 rows
  • 9 columns
Loading... 
CREATE TABLE n_4_2_ufs_5_ka32_weather_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "airtemp_c" DOUBLE  -- AirTemp(C),
  "rh" DOUBLE  -- RH(%),
  "globallightenergy_w_m2" DOUBLE  -- GlobalLightEnergy(W.m2),
  "windspeed_km_hr" DOUBLE  -- WindSpeed(km.hr),
  "wdir_deg" DOUBLE  -- WDir(deg)
);

4.3 UFS-5 LRB-AZ-1201 Weather Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_4_3_ufs_5_lrb_az_1201_weather_data
  • 146.77 kB
  • 13,242 rows
  • 9 columns
Loading... 
CREATE TABLE n_4_3_ufs_5_lrb_az_1201_weather_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "airtemp_c" DOUBLE  -- AirTemp(C),
  "rh" DOUBLE  -- RH(%),
  "globallightenergy_w_m2" BIGINT  -- GlobalLightEnergy(W.m2),
  "windspeed_km_hr" DOUBLE  -- WindSpeed(km.hr),
  "wdir_deg" DOUBLE  -- WDir(deg)
);

4.5 UFS-5 KA32 Daily Averaged Weather Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_4_5_ufs_5_ka32_daily_averaged_weather_data
  • 13.6 kB
  • 183 rows
  • 10 columns
Loading... 
CREATE TABLE n_4_5_ufs_5_ka32_daily_averaged_weather_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "airtemp_c" DOUBLE  -- AirTemp(C),
  "rh" DOUBLE  -- RH(%),
  "globallightenergy_w_m2" DOUBLE  -- GlobalLightEnergy(W.m2),
  "windspeed_km_hr" DOUBLE  -- WindSpeed(km.hr),
  "wdir_deg" DOUBLE  -- WDir(deg),
  "precip_tot_cm" DOUBLE  -- Precip.tot(cm)
);

4.6 UFS-5 LRB-AZ-1201 Daily Averaged Weather Data

@usgov.doe_gov_unified_field_study_5_ufs_5.n_4_6_ufs_5_lrb_az_1201_daily_averaged_weather_data
  • 11.93 kB
  • 123 rows
  • 10 columns
Loading... 
CREATE TABLE n_4_6_ufs_5_lrb_az_1201_daily_averaged_weather_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "airtemp_c" DOUBLE  -- AirTemp(C),
  "rh" DOUBLE  -- RH(%),
  "globallightenergy_w_m2" DOUBLE  -- GlobalLightEnergy(W.m2),
  "windspeed_km_hr" DOUBLE  -- WindSpeed(km.hr),
  "wdir_deg" DOUBLE  -- WDir(deg),
  "precip_tot_cm" DOUBLE  -- Precip.tot(cm)
);

Share link

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