Datasets For Manuscript: Multi-scale Techno-economic Assessment Of Nitrogen Recovery Systems For Livestock Operations
U.S. Environmental Protection Agency
@usgov.epa_gov_datasets_for_manuscript_multi_scale_techno_eco_822fcfc2
U.S. Environmental Protection Agency
@usgov.epa_gov_datasets_for_manuscript_multi_scale_techno_eco_822fcfc2
The datasets contain data required to determine the recovery efficiency and nitrogen losses of each of the six studied technologies and nitrogen recovery cost, as well as an environmental cost-benefit analysis to compare the nitrogen recovery cost versus the economic losses derived from its uncontrolled release into the environment. Also, the Tower flooding capacity correlation considering the packing pressure drop (Figure 3), the relative flows of inorganic nitrogen in the studied processes (Figure 4), the processing and nitrogen recovery costs of the assessed nitrogen recovery technologies for different livestock facility sizes, including the cost of pretreatment and AD stages (Figure 5), the processing and nitrogen recovery costs of the assessed nitrogen recovery technologies for different livestock facility sizes, excluding the cost of anaerobic digestion stage (Figure 6), and the other datasets to obtain the supplemental information figures.
This dataset is associated with the following publication:
Martin-Hernandez, E., C. Montero-Rueda, G.J. Ruiz-Mercado, C. Vaneeckhaute, and M. Martin. Multi-scale techno-economic assessment of nitrogen recovery systems for livestock operations. Sustainable Production and Consumption. Elsevier B.V., Amsterdam, NETHERLANDS, 41: 49-63, (2023).
Organization: U.S. Environmental Protection Agency
Last updated: 2023-09-09T22:14:03.192564
Tags: livestock-industry, nitrogen-and-co-pollutants, nitrogen-recovery, techno-economic-assessment
CREATE TABLE fig1s_a_ad_size_cost (
"animal_population" BIGINT,
"cost" DOUBLE
);CREATE TABLE fig_1s_b_om_unit_cost_ratio (
"animal_population" BIGINT,
"om_cost" BIGINT,
"cost" BIGINT,
"om_unit" DOUBLE
);CREATE TABLE fig3 (
"var" VARCHAR,
"x" DOUBLE,
"p" DOUBLE,
"y" DOUBLE,
"unnamed_4" VARCHAR -- Unnamed: 4,
"log_x" DOUBLE
);CREATE TABLE fig_3s (
"model" VARCHAR,
"diameter_m" DOUBLE -- Diameter (m),
"length_m" DOUBLE -- Length (m),
"volumen_m3" DOUBLE -- Volumen (m3),
"price_no_tax_2021_eur" DOUBLE -- Price No Tax (2021 EUR),
"price_tax_2021_eur" DOUBLE -- Price Tax (2021 EUR),
"price_tax_2021_1e3_usd" DOUBLE -- Price Tax (2021–1E3 USD),
"price_tax_2021_usd" DOUBLE -- Price Tax (2021 USD)
);CREATE TABLE fig_4_ad_balances (
"components" VARCHAR,
"src1bioreactor_kg_day" DOUBLE,
"bioreactorsink1_kg_day" DOUBLE,
"bioreactorsink2_kg_day" DOUBLE,
"src1bioreactor_x" DOUBLE,
"bioreactorsink1_x" DOUBLE,
"bioreactorsink2_x" DOUBLE
);CREATE TABLE fig_4_airstrippingpacked_balances (
"components" VARCHAR,
"src1_stripper_kg_day" DOUBLE,
"src2_stripper_kg_day" DOUBLE,
"stripper_snk1_kg_day" DOUBLE,
"stripper_snk2_kg_day" DOUBLE,
"src1_stripper_x" DOUBLE,
"src2_stripper_x" DOUBLE,
"stripper_snk1_x" DOUBLE,
"stripper_snk2_x" DOUBLE
);CREATE TABLE fig_4_ammoniaevaporation_balances (
"components" VARCHAR,
"src1_beltdryer_kg_day" DOUBLE,
"src2_beltdryer_kg_day" DOUBLE,
"beltdryer_snk1_kg_day" DOUBLE,
"beltdryer_snk2_kg_day" DOUBLE,
"src1_beltdryer_x" DOUBLE,
"src2_beltdryer_x" DOUBLE,
"beltdryer_snk1_x" DOUBLE,
"beltdryer_snk2_x" DOUBLE
);CREATE TABLE fig_4_biogasconditioning_balances (
"components" VARCHAR,
"bioreactor_comp1_kg_day" DOUBLE,
"comp1_hx1_kg_day" DOUBLE,
"hx1_sep1_kg_day" DOUBLE,
"sep1_sink1wa_kg_day" DOUBLE,
"sep1_react1_kg_day" DOUBLE,
"react1_comp2_kg_day" DOUBLE,
"react1_sink2h2s_kg_day" DOUBLE,
"comp2_hx2_kg_day" DOUBLE,
"hx2_sep2_kg_day" DOUBLE,
"sep2_sink3wa_kg_day" DOUBLE,
"sep2_react2_kg_day" DOUBLE,
"react2_sink4biogas_kg_day" DOUBLE,
"react2_sink5exhaust_kg_day" DOUBLE,
"bioreactor_comp1_x" DOUBLE,
"comp1_hx1_x" DOUBLE,
"hx1_sep1_x" DOUBLE,
"sep1_sink1wa_x" DOUBLE,
"sep1_react1_x" DOUBLE,
"react1_comp2_x" DOUBLE,
"react1_sink2h2s_x" DOUBLE,
"comp2_hx2_x" DOUBLE,
"hx2_sep2_x" DOUBLE,
"sep2_sink3wa_x" DOUBLE,
"sep2_react2_x" DOUBLE,
"react2_sink4biogas_x" DOUBLE,
"react2_sink5exhaust_x" DOUBLE
);CREATE TABLE fig_4_centrifuge_balances (
"components" VARCHAR,
"srccentrifuge_kg_day" DOUBLE,
"centrifugesink1_kg_day" DOUBLE,
"centrifugesink2_kg_day" DOUBLE,
"srccentrifuge_x" DOUBLE,
"centrifugesink1_x" DOUBLE,
"centrifugesink2_x" DOUBLE
);CREATE TABLE fig_4_chp_balances (
"components" VARCHAR,
"src1_chp_kg_day" DOUBLE,
"src2_chp_kg_day" DOUBLE,
"chp_fluegases_kg_day" DOUBLE,
"src1_chp_x" DOUBLE,
"src2_chp_x" DOUBLE,
"chp_fluegases_x" DOUBLE
);CREATE TABLE fig_4_maphex_balances (
"components" VARCHAR,
"src_maphex_kg_day" DOUBLE,
"maphex_liqeff_kg_day" DOUBLE,
"maphex_soleff_kg_day" DOUBLE,
"src_maphex_x" DOUBLE,
"maphex_liqeff_x" DOUBLE,
"maphex_soleff_x" DOUBLE
);CREATE TABLE fig_4_membrane_balances (
"components" VARCHAR,
"srcmembrane_kg_day" DOUBLE,
"srcstrippingfluid_kg_day" DOUBLE,
"membranesink1_kg_day" DOUBLE,
"membranesink2_kg_day" DOUBLE,
"srcmembrane_x" DOUBLE,
"srcstrippingfluid_x" DOUBLE,
"membranesink1_x" DOUBLE,
"membranesink2_x" DOUBLE
);CREATE TABLE fig_4_mixer_balances (
"components" VARCHAR,
"srcmixer_kg_day" DOUBLE,
"srcnaoh_kg_day" DOUBLE,
"mixer_sink1_kg_day" DOUBLE,
"srcmixer_x" DOUBLE,
"srcnaoh_x" DOUBLE,
"mixer_sink1_x" DOUBLE
);CREATE TABLE fig_4_multiform_balances (
"components" VARCHAR,
"src1_multiform_kg_day" DOUBLE,
"src2_multiform_kg_day" DOUBLE,
"src3_multiform_kg_day" DOUBLE,
"multiform_liqeff_kg_day" DOUBLE,
"multiform_dryer_kg_day" DOUBLE,
"dryermultiform_vaporeff_kg_day" DOUBLE,
"dryermultiform_peff_kg_day" DOUBLE,
"src1_multiform_x" DOUBLE,
"src2_multiform_x" DOUBLE,
"src3_multiform_x" DOUBLE,
"multiform_liqeff_x" DOUBLE,
"multiform_dryer_x" DOUBLE,
"dryermultiform_vaporeff_x" DOUBLE,
"dryermultiform_peff_x" DOUBLE
);CREATE TABLE fig_4_screwpress_balances (
"components" VARCHAR,
"srcscrewpress_kg_day" DOUBLE,
"screwpresssink1_kg_day" DOUBLE,
"screwpresssink2_kg_day" DOUBLE,
"srcscrewpress_x" DOUBLE,
"screwpresssink1_x" DOUBLE,
"screwpresssink2_x" DOUBLE
);CREATE TABLE fig_4_scrubbingairstrippingpacked_balances (
"components" VARCHAR,
"src1_scrubber_kg_day" DOUBLE,
"src2_scrubber_kg_day" DOUBLE,
"scrubber_snk1_kg_day" DOUBLE,
"scrubber_snk2_kg_day" DOUBLE,
"src1_scrubber_x" DOUBLE,
"src2_scrubber_x" DOUBLE,
"scrubber_snk1_x" DOUBLE,
"scrubber_snk2_x" DOUBLE
);CREATE TABLE fig_4_scrubbingammoniaevaporation_balances (
"components" VARCHAR,
"src1_scrubber_kg_day" DOUBLE,
"src2_scrubber_kg_day" DOUBLE,
"scrubber_snk1_kg_day" DOUBLE,
"scrubber_snk2_kg_day" DOUBLE,
"src1_scrubber_x" DOUBLE,
"src2_scrubber_x" DOUBLE,
"scrubber_snk1_x" DOUBLE,
"scrubber_snk2_x" DOUBLE
);CREATE TABLE fig_4_scrubbing_balances (
"components" VARCHAR,
"src1_scrubber_kg_day" DOUBLE,
"src2_scrubber_kg_day" DOUBLE,
"scrubber_snk1_kg_day" DOUBLE,
"scrubber_snk2_kg_day" DOUBLE,
"src1_scrubber_x" DOUBLE,
"src2_scrubber_x" DOUBLE,
"scrubber_snk1_x" DOUBLE,
"scrubber_snk2_x" DOUBLE
);CREATE TABLE figs_4s_5s (
"au" DOUBLE,
"f_kgday" DOUBLE,
"multiform_equipcost" DOUBLE,
"maphex_equipcost" DOUBLE,
"evaporationscrubbing_equipcost" DOUBLE,
"membrane_equipcost" DOUBLE,
"airstrippingpackedscrubbing_equipcost" DOUBLE,
"multiform_opcost" DOUBLE,
"maphex_opcost" DOUBLE,
"evaporationscrubbing_opcost" DOUBLE,
"membrane_opcost" DOUBLE,
"airstrippingpackedscrubbing_opcost" DOUBLE,
"multiform_tac" DOUBLE,
"maphex_tac" DOUBLE,
"evaporationscrubbing_tac" DOUBLE,
"membrane_tac" DOUBLE,
"airstrippingpackedscrubbing_tac" DOUBLE,
"multiform_nremovaleff" DOUBLE,
"maphex_nremovaleff" DOUBLE,
"evaporationscrubbing_nremovaleff" DOUBLE,
"membrane_nremovaleff" DOUBLE,
"airstrippingpackedscrubbing_nremovaleff" DOUBLE,
"multiform_nrecovered_kg_day" DOUBLE,
"maphex_nrecovered_kg_day" DOUBLE,
"evaporationscrubbing_nrecovered_kg_day" DOUBLE,
"membrane_nrecovered_kg_day" DOUBLE,
"airstrippingpackedscrubbing_nrecovered_kg_day" DOUBLE,
"multiform_nreccost_usd_kgnrecovered" DOUBLE,
"maphex_nreccost_usd_kgnrecovered" DOUBLE,
"evaporationscrubbing_nreccost_usd_kgnrecovered" DOUBLE,
"membrane_nreccost_usd_kgnrecovered" DOUBLE,
"airstrippingpackedscrubbing_nreccost_usd_kgnrecovered" DOUBLE,
"multiform_wasteproccost_usd_kgwaste" DOUBLE,
"maphex_wasteproccost_usd_kgwaste" DOUBLE,
"evaporationscrubbing_wasteproccost_usd_kgwaste" DOUBLE,
"membrane_wasteproccost_usd_kgwaste" DOUBLE,
"airstrippingpackedscrubbing_wasteproccost_usd_kgwaste" DOUBLE,
"multiform_nreccost_vs_wasteproccost" DOUBLE,
"maphex_nreccost_vs_wasteproccost" DOUBLE,
"evaporationscrubbing_nreccost_vs_wasteproccost" DOUBLE,
"membrane_nreccost_vs_wasteproccost" DOUBLE,
"airstrippingpackedscrubbing_nreccost_vs_wasteproccost" DOUBLE,
"multiform_nreccost_usd_kgnrecovered_noad" DOUBLE,
"maphex_nreccost_usd_kgnrecovered_noad" DOUBLE,
"evaporationscrubbing_nreccost_usd_kgnrecovered_noad" DOUBLE,
"membrane_nreccost_usd_kgnrecovered_noad" DOUBLE,
"airstrippingpackedscrubbing_nreccost_usd_kgnrecovered_noad" DOUBLE,
"multiform_wasteproccost_usd_kgwaste_noad" DOUBLE,
"maphex_wasteproccost_usd_kgwaste_noad" DOUBLE,
"evaporationscrubbing_wasteproccost_usd_kgwaste_noad" DOUBLE,
"membrane_wasteproccost_usd_kgwaste_noad" DOUBLE,
"airstrippingpackedscrubbing_wasteproccost_usd_kgwaste_noad" DOUBLE,
"multiform_equipcost_noad" DOUBLE,
"maphex_equipcost_noad" DOUBLE,
"evaporationscrubbing_equipcost_noad" DOUBLE,
"membrane_equipcost_noad" DOUBLE,
"airstrippingpackedscrubbing_equipcost_noad" DOUBLE,
"multiform_opcost_noad" DOUBLE,
"maphex_opcost_noad" DOUBLE,
"evaporationscrubbing_opcost_noad" DOUBLE,
"membrane_opcost_noad" DOUBLE,
"airstrippingpackedscrubbing_opcost_noad" DOUBLE
);CREATE TABLE figs_5_6 (
"au" DOUBLE,
"f_kgday" DOUBLE,
"multiform_equipcost" DOUBLE,
"maphex_equipcost" DOUBLE,
"evaporationscrubbing_equipcost" DOUBLE,
"membrane_equipcost" DOUBLE,
"airstrippingpackedscrubbing_equipcost" DOUBLE,
"multiform_opcost" DOUBLE,
"maphex_opcost" DOUBLE,
"evaporationscrubbing_opcost" DOUBLE,
"membrane_opcost" DOUBLE,
"airstrippingpackedscrubbing_opcost" DOUBLE,
"multiform_tac" DOUBLE,
"maphex_tac" DOUBLE,
"evaporationscrubbing_tac" DOUBLE,
"membrane_tac" DOUBLE,
"airstrippingpackedscrubbing_tac" DOUBLE,
"multiform_nremovaleff" DOUBLE,
"maphex_nremovaleff" DOUBLE,
"evaporationscrubbing_nremovaleff" DOUBLE,
"membrane_nremovaleff" DOUBLE,
"airstrippingpackedscrubbing_nremovaleff" DOUBLE,
"multiform_nrecovered_kg_day" DOUBLE,
"maphex_nrecovered_kg_day" DOUBLE,
"evaporationscrubbing_nrecovered_kg_day" DOUBLE,
"membrane_nrecovered_kg_day" DOUBLE,
"airstrippingpackedscrubbing_nrecovered_kg_day" DOUBLE,
"multiform_nreccost_usd_kgnrecovered" DOUBLE,
"maphex_nreccost_usd_kgnrecovered" DOUBLE,
"evaporationscrubbing_nreccost_usd_kgnrecovered" DOUBLE,
"membrane_nreccost_usd_kgnrecovered" DOUBLE,
"airstrippingpackedscrubbing_nreccost_usd_kgnrecovered" DOUBLE,
"multiform_wasteproccost_usd_kgwaste" DOUBLE,
"maphex_wasteproccost_usd_kgwaste" DOUBLE,
"evaporationscrubbing_wasteproccost_usd_kgwaste" DOUBLE,
"membrane_wasteproccost_usd_kgwaste" DOUBLE,
"airstrippingpackedscrubbing_wasteproccost_usd_kgwaste" DOUBLE,
"multiform_nreccost_vs_wasteproccost" DOUBLE,
"maphex_nreccost_vs_wasteproccost" DOUBLE,
"evaporationscrubbing_nreccost_vs_wasteproccost" DOUBLE,
"membrane_nreccost_vs_wasteproccost" DOUBLE,
"airstrippingpackedscrubbing_nreccost_vs_wasteproccost" DOUBLE,
"multiform_nreccost_usd_kgnrecovered_noad" DOUBLE,
"maphex_nreccost_usd_kgnrecovered_noad" DOUBLE,
"evaporationscrubbing_nreccost_usd_kgnrecovered_noad" DOUBLE,
"membrane_nreccost_usd_kgnrecovered_noad" DOUBLE,
"airstrippingpackedscrubbing_nreccost_usd_kgnrecovered_noad" DOUBLE,
"multiform_wasteproccost_usd_kgwaste_noad" DOUBLE,
"maphex_wasteproccost_usd_kgwaste_noad" DOUBLE,
"evaporationscrubbing_wasteproccost_usd_kgwaste_noad" DOUBLE,
"membrane_wasteproccost_usd_kgwaste_noad" DOUBLE,
"airstrippingpackedscrubbing_wasteproccost_usd_kgwaste_noad" DOUBLE,
"multiform_equipcost_noad" DOUBLE,
"maphex_equipcost_noad" DOUBLE,
"evaporationscrubbing_equipcost_noad" DOUBLE,
"membrane_equipcost_noad" DOUBLE,
"airstrippingpackedscrubbing_equipcost_noad" DOUBLE,
"multiform_opcost_noad" DOUBLE,
"maphex_opcost_noad" DOUBLE,
"evaporationscrubbing_opcost_noad" DOUBLE,
"membrane_opcost_noad" DOUBLE,
"airstrippingpackedscrubbing_opcost_noad" DOUBLE
);Anyone who has the link will be able to view this.