About this Dataset

Unified Field Study 1 (UFS-1)

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 UFS-1 experiment, performed October to December 2013, was to establish the operational capability to simultaneously perform the same algal growth experiment using identical equipment, media, strain, experimental protocol, and analytical techniques across the 6 ATP3 testbed sites. A common algal species (Nannochloropsis oceanica KA32) was grown at all sites. The UFS-1 Experiment was intended as a first live run-through using the full volume and capabilities of the 6 identical ATP3 ponds to build pond operator familiarity with the equipment and procedures in an effort to eliminate operator error from the upcoming UFS Production runs.

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:56:59.476743
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, process-conditions, regional, renewable-energy, seasonal, strain, testbed, ufs, unified-field-study

Tables

1.2 UFS-1 Pond Operation Data

@usgov.doe_gov_unified_field_study_1_ufs_1.n_1_2_ufs_1_pond_operation_data

83.53 kB
4,175 rows
53 columns

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

2.2 Complete UFS-1 Instrumentation Data

@usgov.doe_gov_unified_field_study_1_ufs_1.n_2_2_complete_ufs_1_instrumentation_data

2.1 MB
121,704 rows
13 columns

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

2.4 Daily Averaged UFS-1 Instrumentation Data

@usgov.doe_gov_unified_field_study_1_ufs_1.n_2_4_daily_averaged_ufs_1_instrumentation_data

51.33 kB
1,344 rows
14 columns

CREATE TABLE n_2_4_daily_averaged_ufs_1_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.2 UFS-1 Complete Weather Data

@usgov.doe_gov_unified_field_study_1_ufs_1.n_3_2_ufs_1_complete_weather_data

14.29 kB
201 rows
10 columns

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

3.4 UFS-1 Daily Averaged Weather Data

@usgov.doe_gov_unified_field_study_1_ufs_1.n_3_4_ufs_1_daily_averaged_weather_data

14.29 kB
201 rows
10 columns

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