David LeBauer dlebauer

trait_description	variable	units	mean	sd	date
Leaf Percent Nitrogen	leafN	percent	2.48	1.07	2019-08-26
Specific Leaf Area	SLA	m2 kg-1	15.3	8.86	2019-08-26
maximum rubisco carboxylation capacity	Vcmax	umol CO2 m-2 s-1	64.5	48	2019-08-26
Leaf Area Index	LAI	m2 leaf m-2 ground	3.96	2.95	2019-08-26
rate of fine root respiration at reference soil temperature

	citation_author	citation_year	citation_title	cultivar	species	site	treatment	date	rhizome_biomass	root_biomass_area_SE	root_biomass_area_n	leaf_biomass_area	stem_biomass	root_biomass_area	notes
	rosenthal	2012		60444	Manihot esculenta	SoyFace	Ambient CO2

	traits <- data.table(db.query("select * from traitsview;", con))
	### return only soil respiration data entered by Moein
	ghgtraits <- traits[trait %in% c("Rsoil_annual", "Rsoil_het_annual", "R_root_fine_annual", "Soil Het Respiration ", "Soil Respiration", "soil_respiration_m2"),]
	# keycols <- c("site_id", "treatment_id", "scientificname", "citation_id", "date")
	# setkeyv(ghgtraits, keycols)
	#
	# x <- ghgtraits[,interaction(site_id, treatment_id, scientificname, citation_id, date)]
	# x <- ghgtraits[,.SD, by = list()]

	setkey(entity, id)

	citation_author,citation_year,citation_title,species,site,treatment,year,month,day,SLA,leafP,leafN,leafC,c2n_leaf,access_level
	Xiaohui Feng,2015,Luquillo census field data,Micropholis garciniifolia,Luquillo,Observations,1992,6,15,5.767714286,0.032078849,1.84,45.98,24.98913043,4
	Xiaohui Feng,2015,Luquillo census field data,Ocotea moschata,Luquillo,Observations,1990,8,30,6.683,0.045924224,1.6395,49.0955,29.94541019,4
	Xiaohui Feng,2015,Luquillo census field data,Rheedia portoricensis,Luquillo,Observations,1992,6,22,7.215833333,0.042370331,1.7025,49.6575,29.16740088,4
	Xiaohui Feng,2015,Luquillo census field data,Ocotea spathulata,Luquillo,Observations,1992,6,22,7.297285714,0.13125,2.02,43.25,21.41089109,4
	Xiaohui Feng,2015,Luquillo census field data,Matayba domingensis,Luquillo,Observations,1990,8,28,7.317,0.046564296,1.9855,45.1055,22.71745152,4
	Xiaohui Feng,2015,Luquillo census field data,Cyrilla racemiflora,Luquillo,Observations,1990,12,5,7.963625,0.031024672,1.9,48.3,25.42105263,4
	Xiaohui Feng,2015,Luquillo c

	## Code provided by Corentin M. Barbu
	## http://stackoverflow.com/a/28678741/513006

	library("testthat")
	library("devtools")

	#' @title Replace a value for a given tag on file in memory
	#' @description Scan the lines and change the value for the named tag if one line has this tag,
	#' add a line at the end if no line has this tag and return a warning if several lines
	#' matching the tag

	<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN">
	<html>
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<title></title>
	<style>
	.red { background-color: red }
	.orange { background-color: orange }
	.green { background-color: #19A319 }
	.gray { background-color: gray }