WaterTAP-REFLO Models Of Solar Still, Solar Still ZLD, Enhanced Evaporation Pond Results For Baseline Analysis
Department of Energy
@usgov.doe_gov_watertap_reflo_models_of_solar_still_solar_sti_624b0cf2
Department of Energy
@usgov.doe_gov_watertap_reflo_models_of_solar_still_solar_sti_624b0cf2
CREATE TABLE e_epm_organicdye (
"city" VARCHAR,
"state" VARCHAR,
"salinity_mg_l" BIGINT,
"daily_freshwater_requirement_m3_day" BIGINT,
"land_cost_acre" BIGINT,
"land_clearing_acre" BIGINT,
"daily_evaporation_mm_day" DOUBLE,
"terrain_type" VARCHAR,
"total_area_acre" DOUBLE,
"evaporation_pond_unit_cost" DOUBLE,
"total_cost_organic_dye" DOUBLE,
"total_capital_cost" DOUBLE,
"annual_operational_cost_year" DOUBLE,
"lcow_m3" DOUBLE
);
CREATE TABLE e_epm_waiv (
"city" VARCHAR,
"state" VARCHAR,
"salinity_mg_l" BIGINT,
"daily_freshwater_requirement_m3_day" BIGINT,
"land_cost_acre" DOUBLE,
"land_clearing_acre" BIGINT,
"evaporation_rate_per_waiv_module" DOUBLE,
"terrain_type" VARCHAR,
"total_area_acre" DOUBLE,
"number_of_ep_waiv_modules" DOUBLE,
"total_cost_storage_tank_installed" DOUBLE,
"total_capital_cost" DOUBLE,
"annual_operational_cost_year" DOUBLE,
"lcow_m3" DOUBLE
);
CREATE TABLE ss_model (
"city" VARCHAR,
"state" VARCHAR,
"salinity_mg_l" BIGINT,
"daily_freshwater_requirement_m3_day" BIGINT,
"evaporation_per_ss_kg_day" DOUBLE,
"total_area_m2" DOUBLE,
"number_of_solar_stills_required" DOUBLE,
"total_capital_cost" DOUBLE,
"annual_operational_cost_year" DOUBLE,
"lcow_m3" DOUBLE
);
CREATE TABLE ss_zld_model (
"city" VARCHAR,
"state" VARCHAR,
"salinity_mg_l" BIGINT,
"daily_freshwater_requirement_m3_day" BIGINT,
"evaporation_per_ss_kg_day" DOUBLE,
"total_area_m2" DOUBLE,
"number_of_solar_stills_required" DOUBLE,
"waste_disposal_cost_year" DOUBLE,
"value_recovered_solid_year" DOUBLE,
"total_capital_cost" DOUBLE,
"annual_operational_cost_year" DOUBLE,
"lcow_m3" DOUBLE
);
Anyone who has the link will be able to view this.