fixing experiment descriptions https://github.com/terraref/reference-data/issues/275

updates.sql

BEGIN;
	UPDATE experiments 
	SET description = 'Season 7 RIL experiment closely replicates the RIL experiment from Season 2 in 2016. The description is the same https://terraref.ncsa.illinois.edu/bety/experiments/6000000008
	
	Bi-parental grain sorghum population provided by W. Rooney (Texas A&M), comprised of 158 RILs plus parental lines (TX7000 and SC56-14) that are polymorphic for stay-green (associated with post-flowering drought tolerance) and grain traits.  RILs are F-10 or higher generation.  Plots planted as 2-row plots. The experiment includes 3 replicates, and each replicate includes checks, including BTX623, P_84G62, and P_86Y89.',
	design = 'Resolvable row-column design, 3 replicates, each replicate includes checks BTX623, P_84G62, and P_86Y89.',
	start_date = '2018-08-23',
	end_date = '2018-11-01' 
	WHERE
		ID = 6000000036;
	UPDATE experiments 
	SET design = ' Ranges 14-16 planted AS 2-row plots OF either F2 mutant families,
	the BTX623 wildtype,
	OR filler plots OF P_84G62.F2 mutants were replicated,
	NO SPECIFIC experimental design ',
	start_date = '2018-08-23',
	end_date = '2018-11-01' 
	WHERE
		ID = 6000000039;
	UPDATE experiments 
	SET start_date = ' 2018-08-23 ',
	end_date = ' 2018-11-01 ' 
	WHERE
		ID = 6000000035;
	UPDATE experiments 
	SET design = ' Blocks OF contiguous plots planted TO either P_84G62 
	OR P_86Y89 ( Pioneer hybrids ) IN Ranges 3-13 ( NO experimental design ) ',
	start_date = ' 2018-08-23 ',
	end_date = ' 2018-11-01 ' 
	WHERE
		ID = 6000000037;
	UPDATE experiments 
	SET description = ' LATERAL 
	AND 
	END borders planted IN 2-row plots ON E / W edges 
	AND OUTER ranges ( 1-2 AND 53-54 ) ON the N / S edges TO reduce edge effect.Sorghum Pioneer hybrids P_84G62 
	OR P_86Y89 were planted ON the E / W 
	AND N / S field edges ',
	design = '',
	start_date = ' 2018-08-23 ',
	end_date = ' 2018-11-01 ' 
	WHERE
		ID = 6000000038;
	UPDATE experiments 
	SET description = ' Biomass Association Panel ( BAP ),
	336 accessions IN 2 replicates ( constrained BY 2 height blocks ) IN ranges 4-51.Ranges 3 
	AND 52 planted primarily AS uniform sections OF SP1615 plus CHECK plots FOR observation.See the FOLLOWING reference FOR description OF BAP : Brenton,
	ZW et al.2016.A genomic resource FOR the development,
	improvement,
	
	AND exploitation OF sorghum FOR bioenergy.Genetics 204 : 21-33.',
	design = ' BAP experiment WITH 336 accessions IN 2 replicates ( ranges 4-51 ),
	plus uniformity 
	AND CHECK lines IN ranges 3 
	AND 52.Planted IN 2-row plots.Plot width = 152.4 cm ( 2-rows, ROW width OF 76.2 cm ).Planted LENGTH = 3.385 meters WITH 0.6 meter alley - way ( total 3.985 meters FOR EACH plot ).Experiment arranged IN two replicates ( blocks ) AS A ROW - COLUMN design WITH A further CONSTRAINT that lines ( accessions ) ARE blocked BY height CLASS.This blocking IS applied across ranges.IN specifying A model FOR analysis,
	lines ( accessions ) ARE nested WITHIN height / stature classes.See ALSO the FOLLOWING reference FOR description OF ROW - COLUMN designs : Piepho,
	HP et al.2015.Beyond Latin Squares : A brief tour OF ROW - COLUMN designs.Agronomy Journal 107 : 2263-2270.',
	start_date = ' 2018-04-20 ',
	end_date = ' 2018-08-02 ' 
	WHERE
		ID = 6000000034;
	UPDATE experiments 
	SET description = ' Durum wheat diversity panel ( UNIBO panel ) planted ( 252 accessions x 2 reps ) IN ranges 10-45 plus 14 Ranges planted WITH either Orita 
	OR Tiburon AT ranges 3-9 
	AND 46-52 ',
	design = ' Resolvable ROW - COLUMN design,
	2 replicates ',
	start_date = ' 2017-11-20 ',
	end_date = ' 2018-04-05 ' 
	WHERE
		ID = 6000000033;
	UPDATE experiments 
	SET start_date = ' 2017-04-13 ',
	end_date = ' 2017-09-21 ' 
	WHERE
		ID = 6000000014;
	UPDATE experiments 
	SET start_date = ' 2017-04-13 ',
	end_date = ' 2017-09-21 ' 
	WHERE
		ID = 6000000016;
	UPDATE experiments 
	SET start_date = ' 2017-04-13 ',
	end_date = ' 2017-09-18 ' 
	WHERE
		ID = 6000000015;
	UPDATE experiments 
	SET description = ' LATERAL 
	AND 
	END borders planted IN 2-row plots ON E / W edges 
	AND OUTER ranges ( 1-2 AND 53-54 ) ON the N / S edges TO reduce edge effect.Sorghum variety SP1615 was planted ON the E / W field edges,
	
	AND SP1615 
	AND Big Kahuna were planted IN alternating plots ON the N / S edges ',
	design = '',
	start_date = ' 2017-04-13 ',
	end_date = ' 2017-09-21 ' 
	WHERE
		ID = 6000000017;
	UPDATE experiments 
	SET description = ' Biomass Association Panel ( BAP ),
	350 accessions IN 2 replicates constrained BY 3 height blocks.See the FOLLOWING reference FOR description OF BAP : Brenton,
	ZW et al.2016.A genomic resource FOR the development,
	improvement,
	
	AND exploitation OF sorghum FOR bioenergy.Genetics 204 : 21-33.',
	design = ' BAP experiment WITH 350 accessions IN 2 replicates.Planted IN 2-row plots.Plot width = 152.4 cm ( 2-rows, ROW width OF 76.2 cm ).Planted LENGTH = 3.385 meters WITH 0.6 meter alley - way ( total 3.985 meters FOR EACH plot ).Experiment arranged IN two replicates ( blocks ) AS A ROW - COLUMN design WITH A further CONSTRAINT that lines ( accessions ) ARE blocked BY height CLASS.This blocking IS applied across ranges.Two ranges per replicate ARE assigned TO short stature plants,
	
	AND five ranges per replicate ARE assigned TO medium stature plants.IN specifying A model FOR analysis,
	lines ( accessions ) ARE nested WITHIN height / stature classes.See ALSO the FOLLOWING reference FOR description OF ROW - COLUMN designs : Piepho,
	HP et al.2015.Beyond Latin Squares : A brief tour OF ROW - COLUMN designs.Agronomy Journal 107 : 2263-2270.Ranges blocked BY height OF BAP accessions : Short : Ranges 11,
	20,
	46,
	50.Medium : Ranges 10,
	12,
	18,
	24,
	27,
	29,
	31,
	33,
	38,
	51;
	Tall : Ranges 3-9,
	13-17,
	19,
	21-23,
	25,
	26,
	28,
	30,
	32,
	35-37,
	39-45,
	47-49,
	52 ',
	start_date = ' 2017-04-13 ',
	end_date = ' 2017-09-21 ' 
	WHERE
		ID = 6000000010;
	UPDATE experiments 
	SET NAME = ' MAC Season 7 : Stay - green RILs F10 ',
	description = ' Durum wheat lines planted IN uniform sections WITH the same line across an entire RANGE TO assess WITHIN - field variability USING five strips throughout the field,
	EACH STRIP comprised OF one RANGE OF EACH OF two durum genotypes ( Orita AND Tiburon ).These uniformity strips occupied 20 % OF the scanned area,
	located AT ranges 3-4,
	15-16,
	27-28,
	39-40,
	51-52 ',
	design = ' Single line planted IN ALL plots across A RANGE ( NO experimental design ) ',
	start_date = ' 2016-12-15 ',
	end_date = ' 2017-04-05 ' 
	WHERE
		ID = 6000000027;
	UPDATE experiments 
	SET NAME = ' MAC Season 7 : Pioneer Hybrid Uniformity Blocks ',
	description = ' LATERAL 
	AND 
	END borders planted IN 2-row plots ON E / W edges 
	AND OUTER ranges ( 1 AND 54 ) ON the N / S edges TO reduce edge effect.Durum variety Orita was planted AS the border line',
	design = ' NONE',
	start_date = ' 2016-12-15 ',
	end_date = ' 2017-04-05 ' 
	WHERE
		ID = 6000000026;
	UPDATE experiments 
	SET NAME = ' MAC Season 7 : Border ',
	description = ' The main experiment IN the field trial comprises the durum wheat diversity panel OF 259 lines arranged through collaboration WITH the University OF Bologna,
	supplemented WITH 21 elite durum lines adapted TO irrigated arid environments.The diversity panel includes elite cultivars 
	AND lines originally collected 
	FROM
	Mediterranean countries,
	Mexico,
	Australia,
	Europe,
	
	AND SW USA,
	genotyped FOR association MAPPING studies.Additionally,
	sections were planted TO assess WITHIN field variability USING five strips throughout the field,
	EACH OF two durum genotypes ( Orita AND Tiburon ).',
	design = ' ROW - COLUMN design,
	two replicates,
	280 entries per replicate comprised OF 259 diversity panel lines plus 21 elite lines adapted TO the desert southwest ',
	start_date = ' 2016-12-15 ',
	end_date = ' 2017-04-05 ' 
	WHERE
		ID = 6000000011;
	UPDATE experiments 
	SET description = ' Bi - parental grain sorghum population provided BY W.Rooney ( Texas A & M ),
	comprised OF two replicates OF 172 RILs,
	1 LOCAL CHECK ( Great Scott ),
	
	AND parental lines ( TX7000 AND SC56 - 14 ) polymorphic FOR grain traits 
	AND stay - green ( associated WITH post - flowering drought tolerance ).RILs ARE F - 10 
	OR higher generation.LATERAL 
	AND 
	END borders were Ton - A - Milk ( forage hybrid ) ',
	design = ' Field layout : 54 ranges x 32 ROWS.Plots : 4-rows (
	3.485 M long separated BY 0.5 M alley;
	ROWS 0.76 M wide 
	) WITH FINAL biomass 
	AND hand measurements focused ON INNER 2-rows.Experimental design : 175 entries IN 2 replicates FOLLOWING an alpha lattice design WITH 25 small blocks OF 7 plots EACH.EACH replicate OF 175 entries comprised OF 172 RILs ( TX7000 x SC56 - 14 ),
	1 LOCAL CHECK ( Great Scott, forage hybrid ),
	TX700,
	
	AND SC56 - 14.',
	start_date = ' 2016-07-27 ',
	end_date = ' 2016-12-02 ' 
	WHERE
		ID = 6000000008;
	UPDATE experiments 
	SET description = ' Uniform blocks OF 2 lines ( forage AND photoperiod SENSITIVE ) such that the same line was planted across an entire RANGE;
	ranges 2 
	AND 53 ',
	design = ' Single line planted IN ALL plots across A RANGE ( NO experimental design ) ',
	start_date = ' 2016-04-20 ',
	end_date = ' 2016-07-16 ' 
	WHERE
		ID = 6000000006;
	UPDATE experiments 
	SET description = ' 3 lines ( forage, sweet, PS ) planted IN 6-row plots TO determine the influence OF adjacent plot ON east 
	OR west BY harvesting individual ROWS AT 
	END OF season.6 adjacent plot scenarios were established : 3 lines ( forage, sweet, PS ) x 2 sides ( east OR west ) ',
	design = ' Randomized Complete Block design,
	but NOT balanced WITH ALL treatments IN ALL reps ',
	start_date = ' 2016-04-20 ',
	end_date = ' 2016-07-16 ' 
	WHERE
		ID = 6000000005;
	UPDATE experiments 
	SET description = ' 60 RILs 
	FROM
	two populations provided BY W Rooney ( Texas A & M ) : ( Tx2910 / ( Macia / R07007 ) - CS44 ) - CSF1 - PRF2 
	AND ( R10709 / F08331bmr12 ) - CSF1 - PRF2;
	ranges 3-32 ',
	design = ' Incomplete Block design : 3-replicate ROW - COLUMN alpha lattice design ',
	start_date = ' 2016-04-20 ',
	end_date = ' 2016-07-16 ' 
	WHERE
		ID = 6000000004;
	UPDATE experiments 
	SET description = ' 2 photoperiod SENSITIVE lines planted IN 3 replications WITHIN EACH OF 5 blocks ( 3 x 2 ) separated BY A CHECK line,
	intended FOR 5 different night illumination treatments that ended up NOT being implemented during the season;
	ranges 42-44 ',
	design = ' Designed AS Randomized Complete Block experiment that was NOT implemented ',
	start_date = ' 2016-04-20 ',
	end_date = ' 2016-07-16 ' 
	WHERE
		ID = 6000000007;
	UPDATE experiments 
	SET description = ' 3 sorghum lines ( photoperiod SENSITIVE, forage, sweet ) were thinned TO 3 different densities AFTER seedling emergence;
	ranges 33-35 ',
	design = ' Randomized Complete Block design ( 3 lines x 3 densities ) ',
	start_date = ' 2016-04-20 ',
	end_date = ' 2016-07-16 ' 
	WHERE
		ID = 6000000003;
	UPDATE experiments 
	SET NAME = ' MAC Season 4 : ALL BAP Accessions ',
	description = ' LATERAL 
	AND 
	END borders planted IN 2-row plots ON E / W edges 
	AND OUTER ranges ( 1 AND 54 ) ON the N / S edges TO reduce edge effect.Border types were A mixture OF different lines TO be able TO observe growth ON A RANGE OF sorghum lines IN the Maricopa environment ',
	design = ' NONE',
	start_date = ' 2016-04-20 ',
	end_date = ' 2016-07-16 ' 
	WHERE
		ID = 6000000002;
	UPDATE experiments 
	SET description = ' 3 SELECT
	sorghum lines planted IN 3 replicates OF contiguous 5-plot blocks OF EACH line FOR IN - season destructive sampling TO estimate biomass OVER TIME;
	ranges 36-38 ',
	design = ' Randomized Complete Block design WITH destructive sampling OVER TIME FOR biomass estimates AS A repeated measure',
	start_date = ' 2016-04-20 ',
	end_date = ' 2016-07-16 ' 
	WHERE
		ID = 6000000001;
	UPDATE experiments 
	SET description = ' 30 SELECT
	accessions OF the Biomass Association Panel ( BAP ) INCLUDING 12 photoperiod SENSITIVE,
	12 sweet sorghum,
	
	AND 6 grain sorghum lines,
	EACH planted IN 3 replicates ( 90 plots ) WITHIN central sections OF ranges 45 - 52 ',
	design = ' 30 SELECT
	BAP lines planted FOR observation IN Maricopa environment,
	EACH replicated 3 times FOR preliminary DATA ( NO experimental design ) ',
	start_date = ' 2016-04-20 ',
	end_date = ' 2016-07-16 ' 
	WHERE
	ID = 6000000020;
	DELETE 
	FROM
		experiments 
	WHERE
		ID IN ( 6000000014, 6000000015, 6000000016, 6000000029, 6000000028);
COMMIT;