Dataset: Unified Field Study 3 (UFS-3)

About this Dataset

Unified Field Study 3 (UFS-3)

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 third Unified Field Study (UFS-3), performed June to September 2014, was to generate a robust inter-testbed dataset in algal biomass and lipid productivity and yield for two different 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. In UFS-3 we compared the effect on productivity of three harvests per week with multiple dilution rates vs. one harvest per week with one dilution rate using both algal strains.

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, and 0.3 ATP3 UFS Journal Article below.
Organization: Department of Energy
Last updated: 2024-03-12T23:57:06.983313
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

5.2 UFS-3 Compositional Analysis Data

@usgov.doe_gov_unified_field_study_3_ufs_3.n_5_2_ufs_3_compositional_analysis_data

18.03 KB
246 rows
13 columns


CREATE TABLE n_5_2_ufs_3_compositional_analysis_data (
  "tracking_id" BIGINT,
  "analytical_sample_id_x" VARCHAR,
  "datetime" TIMESTAMP,
  "protein_af" VARCHAR,
  "famelipids_af" VARCHAR,
  "carbohydrates_af" DOUBLE,
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "strainid" VARCHAR,
  "sourceid" VARCHAR,
  "batchid" VARCHAR,
  "duration_days" DOUBLE,
  "pondid" VARCHAR
);

2.2 UFS-3 KA32 Harvest Data

@usgov.doe_gov_unified_field_study_3_ufs_3.n_2_2_ufs_3_ka32_harvest_data

16.46 KB
292 rows
14 columns


CREATE TABLE n_2_2_ufs_3_ka32_harvest_data (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "sourceid" VARCHAR,
  "batchid" VARCHAR,
  "date" VARCHAR,
  "pondid" VARCHAR,
  "treatmentid" VARCHAR,
  "harvest" BIGINT,
  "time_d" DOUBLE,
  "harvest_vol_l" DOUBLE,
  "afdw_g_l" DOUBLE,
  "afdw_g" DOUBLE,
  "crash" VARCHAR
);

2.3 UFS-3 LRB-AZ-1201 Harvest Data

@usgov.doe_gov_unified_field_study_3_ufs_3.n_2_3_ufs_3_lrb_az_1201_harvest_data

12.84 KB
117 rows
14 columns


CREATE TABLE n_2_3_ufs_3_lrb_az_1201_harvest_data (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "sourceid" VARCHAR,
  "batchid" VARCHAR,
  "date" VARCHAR,
  "pondid" VARCHAR,
  "treatmentid" VARCHAR,
  "harvest" BIGINT,
  "time_d" DOUBLE,
  "harvest_vol_l" DOUBLE,
  "afdw_g_l" DOUBLE,
  "afdw_g" DOUBLE,
  "crash" VARCHAR
);

3.2 UFS-3 K32 Instrumentation Data

@usgov.doe_gov_unified_field_study_3_ufs_3.n_3_2_ufs_3_k32_instrumentation_data

1.62 MB
94594 rows
13 columns


CREATE TABLE n_3_2_ufs_3_k32_instrumentation_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "pondid" VARCHAR,
  "strainid" VARCHAR,
  "datetime" VARCHAR,
  "date" VARCHAR,
  "ph" DOUBLE,
  "temp_c" DOUBLE,
  "cond_ms_cm" DOUBLE,
  "do_mg_l" DOUBLE,
  "do_sat" DOUBLE,
  "sal_g_l" DOUBLE,
  "par_umol_m2_s" DOUBLE
);

3.5 UFS-3 K32 Daily Averaged Instrumentation Data

@usgov.doe_gov_unified_field_study_3_ufs_3.n_3_5_ufs_3_k32_daily_averaged_instrumentation_data

41.42 KB
1042 rows
14 columns


CREATE TABLE n_3_5_ufs_3_k32_daily_averaged_instrumentation_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "pondid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "ph" DOUBLE,
  "temp_avg_c" DOUBLE,
  "temp_max_c" DOUBLE,
  "temp_min_c" DOUBLE,
  "cond_ms_cm" DOUBLE,
  "do_mg_l" DOUBLE,
  "do_sat" DOUBLE,
  "sal_g_l" DOUBLE,
  "par_umol_m2_s" DOUBLE
);

3.3 UFS-3 LRB-AZ-1201 Instrumentation Data

@usgov.doe_gov_unified_field_study_3_ufs_3.n_3_3_ufs_3_lrb_az_1201_instrumentation_data

1.06 MB
77256 rows
13 columns


CREATE TABLE n_3_3_ufs_3_lrb_az_1201_instrumentation_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "pondid" VARCHAR,
  "strainid" VARCHAR,
  "datetime" VARCHAR,
  "date" VARCHAR,
  "ph" DOUBLE,
  "temp_c" DOUBLE,
  "cond_ms_cm" DOUBLE,
  "do_mg_l" DOUBLE,
  "do_sat" DOUBLE,
  "sal_g_l" DOUBLE,
  "par_umol_m2_s" DOUBLE
);

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

@usgov.doe_gov_unified_field_study_3_ufs_3.n_3_6_ufs_3_lrb_az_1201_daily_averaged_instrumentation_data

32.01 KB
832 rows
14 columns


CREATE TABLE n_3_6_ufs_3_lrb_az_1201_daily_averaged_instrumentation_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "pondid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "ph" DOUBLE,
  "temp_avg_c" DOUBLE,
  "temp_max_c" DOUBLE,
  "temp_min_c" DOUBLE,
  "cond_ms_cm" DOUBLE,
  "do_mg_l" DOUBLE,
  "do_sat" DOUBLE,
  "sal_g_l" DOUBLE,
  "par_umol_m2_s" DOUBLE
);

1.2 UFS-3 KA32 Pond Operation And Harvest Summary Data

@usgov.doe_gov_unified_field_study_3_ufs_3.n_1_2_ufs_3_ka32_pond_operation_and_harvest_summary_data

111.71 KB
15941 rows
53 columns


CREATE TABLE n_1_2_ufs_3_ka32_pond_operation_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_vol_l" VARCHAR,
  "afdw_g_l" VARCHAR,
  "afdw_g" VARCHAR,
  "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_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_demand_g_n_g_afdw" VARCHAR,
  "nh4_supplied_g" VARCHAR,
  "nh4_utilized_g" VARCHAR,
  "nh4_efficiency" VARCHAR,
  "nh4_demand_g_n_g_afdw" VARCHAR,
  "p_supplied_g" VARCHAR,
  "p_utilized_g" VARCHAR,
  "p_efficiency" VARCHAR,
  "p_demand_g_p_g_afdw" VARCHAR,
  "mg_afdw_mol_par_input" VARCHAR,
  "mg_afdw_kw_gle_input" VARCHAR
);

1.3 UFS-3 LRB-AZ-1201 Pond Operation And Harvest Summary Data

@usgov.doe_gov_unified_field_study_3_ufs_3.n_1_3_ufs_3_lrb_az_1201_pond_operation_and_harvest_summary_data

82.85 KB
16920 rows
53 columns


CREATE TABLE n_1_3_ufs_3_lrb_az_1201_pond_operation_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_vol_l" VARCHAR,
  "afdw_g_l" VARCHAR,
  "afdw_g" VARCHAR,
  "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_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_demand_g_n_g_afdw" VARCHAR,
  "nh4_supplied_g" VARCHAR,
  "nh4_utilized_g" VARCHAR,
  "nh4_efficiency" VARCHAR,
  "nh4_demand_g_n_g_afdw" VARCHAR,
  "p_supplied_g" VARCHAR,
  "p_utilized_g" VARCHAR,
  "p_efficiency" VARCHAR,
  "p_demand_g_p_g_afdw" VARCHAR,
  "mg_afdw_mol_par_input" VARCHAR,
  "mg_afdw_kw_gle_input" VARCHAR
);

4.2 UFS-3 KA32 Complete KA32 Weather Data

@usgov.doe_gov_unified_field_study_3_ufs_3.n_4_2_ufs_3_ka32_complete_ka32_weather_data

13.49 KB
193 rows
10 columns


CREATE TABLE n_4_2_ufs_3_ka32_complete_ka32_weather_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "airtemp_c" DOUBLE,
  "rh" DOUBLE,
  "globallightenergy_w_m2" DOUBLE,
  "windspeed_km_hr" DOUBLE,
  "wdir_deg" DOUBLE,
  "precip_tot_cm" DOUBLE
);

4.3 UFS-3 LRB-AZ-1201 Complete Weather Data

@usgov.doe_gov_unified_field_study_3_ufs_3.n_4_3_ufs_3_lrb_az_1201_complete_weather_data

227.4 KB
15474 rows
9 columns


CREATE TABLE n_4_3_ufs_3_lrb_az_1201_complete_weather_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "airtemp_c" DOUBLE,
  "rh" DOUBLE,
  "globallightenergy_w_m2" DOUBLE,
  "windspeed_km_hr" DOUBLE,
  "wdir_deg" DOUBLE
);

4.5 UFS-3 K32 Daily Averaged Weather Data

@usgov.doe_gov_unified_field_study_3_ufs_3.n_4_5_ufs_3_k32_daily_averaged_weather_data

13.49 KB
193 rows
10 columns


CREATE TABLE n_4_5_ufs_3_k32_daily_averaged_weather_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "airtemp_c" DOUBLE,
  "rh" DOUBLE,
  "globallightenergy_w_m2" DOUBLE,
  "windspeed_km_hr" DOUBLE,
  "wdir_deg" DOUBLE,
  "precip_tot_cm" DOUBLE
);

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

@usgov.doe_gov_unified_field_study_3_ufs_3.n_4_6_ufs_3_lrb_az_1201_daily_averaged_weather_data

12.97 KB
170 rows
10 columns


CREATE TABLE n_4_6_ufs_3_lrb_az_1201_daily_averaged_weather_data (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "strainid" VARCHAR,
  "date" VARCHAR,
  "airtemp_c" DOUBLE,
  "rh" DOUBLE,
  "globallightenergy_w_m2" DOUBLE,
  "windspeed_km_hr" DOUBLE,
  "wdir_deg" DOUBLE,
  "precip_tot_cm" DOUBLE
);