About this Dataset

Unified Field Study 7 (UFS-7)

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 seventh Unified Field Study (UFS-7), performed June to July 2015, was to provide baseline dilution rate/strain performance evaluation for this new strain (C046). The UFS-7 Experiment was a direct comparison of two dilution rates (0.11 and 0.214 per day) with the algal species Desmodesmus intermedius C046.

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:19.023173
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-7 Pond Operational And Harvest Summary Data

@usgov.doe_gov_unified_field_study_7_ufs_7.n_1_2_ufs_7_pond_operational_and_harvest_summary_data

130.78 kB
14,285 rows
53 columns

CREATE TABLE n_1_2_ufs_7_pond_operational_and_harvest_summary_data (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "pondid" VARCHAR,
  "datetime" VARCHAR,
  "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-7 Harvest Data

@usgov.doe_gov_unified_field_study_7_ufs_7.n_2_2_ufs_7_harvest_data

17.53 kB
328 rows
14 columns

CREATE TABLE n_2_2_ufs_7_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-7 Instrumentation Data

@usgov.doe_gov_unified_field_study_7_ufs_7.n_3_2_ufs_7_instrumentation_data

1.64 MB
99,013 rows
13 columns

CREATE TABLE n_3_2_ufs_7_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.4 UFS-7 Daily Averaged Instrumentation Data

@usgov.doe_gov_unified_field_study_7_ufs_7.n_3_4_ufs_7_daily_averaged_instrumentation_data

42.01 kB
1,069 rows
14 columns

CREATE TABLE n_3_4_ufs_7_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-7 Weather Data

@usgov.doe_gov_unified_field_study_7_ufs_7.n_4_2_ufs_7_weather_data

260.97 kB
22,327 rows
9 columns

CREATE TABLE n_4_2_ufs_7_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.4 UFS-7 Daily Averaged Weather Data

@usgov.doe_gov_unified_field_study_7_ufs_7.n_4_4_ufs_7_daily_averaged_weather_data

14.04 kB
205 rows
10 columns

CREATE TABLE n_4_4_ufs_7_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)
);