SAMPLES website - data updates - 03-08-2017

samples-update-03-08-2017.sql

-- Experiment
INSERT INTO `samples_db`.`wp_experiment` (`idexperiment`, `exp_name`, `exp_keywords`, `exp_brief_desc`, `exp_country`, `exp_province_state`, `exp_nearest_city`, `exp_latitude`, `exp_longitude`, `exp_year_began`, `exp_year_ended`, `exp_mean_annual_precipitation`, `exp_mean_annual_temperature`, `exp_soil_taxo_desc`, `exp_soil_taxo_sys`, `exp_soil_surface_tex`, `exp_soil_ph`, `exp_key_findings`) VALUES ('PELSTERGHG', 'Manure factors East Africa', 'Manure management, cattle, pasture, East Africa', 'Manure management emission factor for manure from cattle managed as a solid on pastures and ranges in East Africa\n', 'Kenya', 'Nairobi', 'Nairobi', '1.270556', '36.72444', '2015', '2015', '980', '17.5', 'well-drained humic nitisols', 'FAO', 'Clay', '7', 'The CH4 emission factors (EFs) (246 ± 49.5 and 87 ± 12.7 g CH4–C yr-1 animal-1 for Friesan and Boran, respectively) were lower than the International Panel on Climate Change EFs (750 g CH4–C animal-1 yr-1), whereas the N2O EFs (0.1 and 0.2% for the Friesian and Boran feces, respectively, and 1.2% for urine) were also lower than International Panel on Climate Change estimates. \n');

-- Contact info
INSERT INTO `samples_db`.`wp_contact_info` (`cont_journal_citation`, `cont_email_primary`, `cont_where_assoc_downloaded`, `wp_experiment_idexperiment`) VALUES ('David E. Pelster, Betty Gisore, James K. Koske, John Goopy, Daniel Korir, Mariana C. Rufino, Klaus Butterbach-Bahl, Methane and nitrous oxide emissions from cattle excreta on an East African grassland, Journal of Environmental Quality (2016)', '[email protected]', 'http://dx.doi.org/10.1071/AN15569', 'PELSTERGHG');

-- EF Manure
INSERT INTO `samples_db`.`wp_ef_manure` (`idef_manure`, `man_ipcc_1996`, `man_ipcc_2006`, `man_gas`, `man_type_emiss_fact`, `man_type_manure_manag_sys`, `man_animal_weight`, `man_subspacies`, `man_num_animals_operation`, `man_operat_conditions`, `man_diet_feed_charact_anim`, `man_mitigation_tech`, `man_ef_value`, `man_ef_units`, `man_equation`, `man_lower_bound`, `man_upper_bound`, `wp_experiment_idexperiment`) VALUES ('0','4B1b - Manure management - Cattle - Non-dairy', '3A2aii - Manure management - Cattle - Other cattle', 'CH4', 'Emission factor- CH4', 'Pasture/Range/Paddock ', '126 ± 3.4 kg', 'Bos indicus (Boran)', '1', 'Fresh feces managed as a solid applied to grasslands', 'Boran steers fed wheat (Triticum aestivum L.) straw supplemented with Calliandra (Calliandra calothyrsus Meissner) ', 'None', '0.087', 'kg CH4–C yr-1 animal-1', '10.22', '0.088', '1.46', 'PELSTERGHG');
INSERT INTO `samples_db`.`wp_ef_manure` (`idef_manure`, `man_ipcc_1996`, `man_ipcc_2006`, `man_gas`, `man_type_emiss_fact`, `man_type_manure_manag_sys`, `man_animal_weight`, `man_subspacies`, `man_num_animals_operation`, `man_operat_conditions`, `man_diet_feed_charact_anim`, `man_mitigation_tech`, `man_ef_value`, `man_ef_units`, `man_equation`, `man_lower_bound`, `man_upper_bound`, `wp_experiment_idexperiment`) VALUES ('1','4B1b - Manure management - Cattle - Non-dairy', '3A2aii - Manure management - Cattle - Other cattle', 'CH4', 'Emission factor- CH4', 'Pasture/Range/Paddock ', '183 ± 5.8 kg', 'Bos taurus (Friesian)', '1', 'Fresh feces managed as a solid applied to grasslands', 'Friesian steers fed wheat (Triticum aestivum L.) straw supplemented with Calliandra (Calliandra calothyrsus Meissner) ', 'None', '0.246', 'kg CH4–C yr-1 animal-1', '10.22', '0.212', '0.444', 'PELSTERGHG');
INSERT INTO `samples_db`.`wp_ef_manure` (`idef_manure`, `man_ipcc_1996`, `man_ipcc_2006`, `man_gas`, `man_type_emiss_fact`, `man_type_manure_manag_sys`, `man_animal_weight`, `man_subspacies`, `man_num_animals_operation`, `man_operat_conditions`, `man_diet_feed_charact_anim`, `man_mitigation_tech`, `man_ef_value`, `man_ef_units`, `man_equation`, `wp_experiment_idexperiment`) VALUES ('2','4B1b - Manure management - Cattle - Non-dairy', '3A2aii - Manure management - Cattle - Other cattle', 'N2O', 'Emission factor- N2O', 'Pasture/Range/Paddock ', '126 ± 3.4 kg', 'Bos indicus (Boran)', '1', 'Fresh feces managed as a solid applied to grasslands', 'Boran steers fed wheat (Triticum aestivum L.) straw supplemented with Calliandra (Calliandra calothyrsus Meissner) ', 'None', '0.002', 'kg N2O-N kg N input-1', '11.2', 'PELSTERGHG');
INSERT INTO `samples_db`.`wp_ef_manure` (`idef_manure`, `man_ipcc_1996`, `man_ipcc_2006`, `man_gas`, `man_type_emiss_fact`, `man_type_manure_manag_sys`, `man_animal_weight`, `man_subspacies`, `man_num_animals_operation`, `man_operat_conditions`, `man_diet_feed_charact_anim`, `man_mitigation_tech`, `man_ef_value`, `man_ef_units`, `man_equation`, `wp_experiment_idexperiment`) VALUES ('3','4B1b - Manure management - Cattle - Non-dairy', '3A2aii - Manure management - Cattle - Other cattle', 'N2O', 'Emission factor- N2O', 'Pasture/Range/Paddock ', '126 ± 3.4 kg', 'Bos taurus (Friesian)', '1', 'Fresh feces managed as a solid applied to grasslands', 'Friesian steers fed wheat (Triticum aestivum L.) straw supplemented with Calliandra (Calliandra calothyrsus Meissner) ', 'None', '0.001', 'kg N2O-N kg N input-1', '11.2', 'PELSTERGHG');
INSERT INTO `samples_db`.`wp_ef_manure` (`idef_manure`, `man_ipcc_1996`, `man_ipcc_2006`, `man_gas`, `man_type_emiss_fact`, `man_type_manure_manag_sys`, `man_animal_weight`, `man_subspacies`, `man_num_animals_operation`, `man_operat_conditions`, `man_diet_feed_charact_anim`, `man_mitigation_tech`, `man_ef_value`, `man_ef_units`, `man_equation`, `wp_experiment_idexperiment`) VALUES ('4','4B1b - Manure management - Cattle - Non-dairy', '3A2aii - Manure management - Cattle - Other cattle', 'N2O', 'Emission factor- N2O', 'Pasture/Range/Paddock ', '126 ± 3.4 kg', 'Bos taurus (Friesian)', '1', 'Urine applied to grasslands', 'Friesian steers fed wheat (Triticum aestivum L.) straw supplemented with Calliandra (Calliandra calothyrsus Meissner) ', 'None', '0.012', 'kg N2O-N kg N input-1', '11.2', 'PELSTERGHG');