Baselight
Sign In

Unified Field Study 4 (UFS-4)

Department of Energy

@usgov.doe_gov_unified_field_study_4_ufs_4

Loading...
Loading...

About this Dataset

Unified Field Study 4 (UFS-4)

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 fourth Unified Field Study (UFS-4), performed September to December 2014, 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.019465
Tags: algae, algal-biomass, 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, regoinal, renewable-energy, seasonal, strain, testbed, ufs, unified-field-study

Tables

1.2 UFS-4 KA32 Pond Operational And Harvest Summary Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_1_2_ufs_4_ka32_pond_operational_and_harvest_summary_data
  • 123.29 kB
  • 1,725 rows
  • 53 columns
Loading... 
CREATE TABLE n_1_2_ufs_4_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" VARCHAR,
  "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-4 LRB-AZ-1201 Pond Operational And Harvest Summary Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_1_3_ufs_4_lrb_az_1201_pond_operational_and_harvest_s_ef819958
  • 93.29 kB
  • 3,018 rows
  • 53 columns
Loading... 
CREATE TABLE n_1_3_ufs_4_lrb_az_1201_pond_operational_and_harvest_s_ef819958 (
  "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" VARCHAR,
  "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-4 KA32 Harvest Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_2_2_ufs_4_ka32_harvest_data
  • 16.56 kB
  • 270 rows
  • 14 columns
Loading... 
CREATE TABLE n_2_2_ufs_4_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-4 LRB-AZ-1201 Harvest Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_2_3_ufs_4_lrb_az_1201_harvest_data
  • 14.02 kB
  • 149 rows
  • 14 columns
Loading... 
CREATE TABLE n_2_3_ufs_4_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-4 KA32 Complete Instrumentation Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_3_2_ufs_4_ka32_complete_instrumentation_data
  • 1.84 MB
  • 100,750 rows
  • 13 columns
Loading... 
CREATE TABLE n_3_2_ufs_4_ka32_complete_instrumentation_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "pondid" VARCHAR,
  "strainid" VARCHAR,
  "datetime" VARCHAR,
  "date" TIMESTAMP,
  "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-4 LRB-AZ-1201 Complete Instrumentation Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_3_3_ufs_4_lrb_az_1201_complete_instrumentation_data
  • 1.32 MB
  • 86,800 rows
  • 13 columns
Loading... 
CREATE TABLE n_3_3_ufs_4_lrb_az_1201_complete_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-4 KA32 Daily Averaged Instrumentation Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_3_5_ufs_4_ka32_daily_averaged_instrumentation_data
  • 46.62 kB
  • 1,176 rows
  • 14 columns
Loading... 
CREATE TABLE n_3_5_ufs_4_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-4 LRB-AZ-1201 Daily Averaged Instrumentation Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_3_6_ufs_4_lrb_az_1201_daily_averaged_instrumentation_data
  • 40.52 kB
  • 1,025 rows
  • 14 columns
Loading... 
CREATE TABLE n_3_6_ufs_4_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-4 KA32 Weather Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_4_2_ufs_4_ka32_weather_data
  • 293.65 kB
  • 23,138 rows
  • 9 columns
Loading... 
CREATE TABLE n_4_2_ufs_4_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-4 LRB-AZ-1201 Weather Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_4_3_ufs_4_lrb_az_1201_weather_data
  • 239.63 kB
  • 18,247 rows
  • 9 columns
Loading... 
CREATE TABLE n_4_3_ufs_4_lrb_az_1201_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.5 UFS-4 KA32 Daily Averaged Weather Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_4_5_ufs_4_ka32_daily_averaged_weather_data
  • 14.84 kB
  • 230 rows
  • 10 columns
Loading... 
CREATE TABLE n_4_5_ufs_4_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-4 LRB-AZ-1201 Daily Averaged Weather Data

@usgov.doe_gov_unified_field_study_4_ufs_4.n_4_6_ufs_4_lrb_az_1201_daily_averaged_weather_data
  • 13.82 kB
  • 189 rows
  • 10 columns
Loading... 
CREATE TABLE n_4_6_ufs_4_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.