New leaf photosynthesis compilation on DAAC

[mdietze]

The following dataset was recently posted on the ORNL DAAC and we should really get this into the database

http://daac.ornl.gov//VEGETATION/guides/Leaf_Photosynthesis_Traits.html

David, do you have any undergrads that can work on this import?

[dlebauer]

Its hard to assess the effort required - I can't find the actual data. But if you have someone who can put it into an upload template then we can certainly import it.

[mdietze]

Could you point us to the template? Is it able to capture the entity relationships? One of the strengths of this data set is that the trait variables are connected, which we need for the covariances

I downloaded the data and here's the header

Author Species Plant_taxonomy Plant_type Longitude Latitude Elevation Measurement_year Vcmax_reported Jmax_reported Vcmax_25C Jmax_25C Leaf_N Leaf_P SLA Needle_age Treatment_CO2 Treatment_N Treatment_P Treatment_light Treatment_other Treatment_other_levels Measurement_temperature Photosynthetic_reference Kinetic_reference Km Kc Ko Tau Gamma_star Wj_reference J_reference J_flag Irradiance Alpha Theta O2_reported Notes

[dlebauer]

The column names for the bulk upload csv are:

,dateloc,time,timeloc,mean,n,SE,notes,<covariate_1>,<covariate_n>,entity_id,access_level```

The sites and treatments would be entered separately, preferably via the
web interface but we could also bulk upload them. The "site", "treatments",
and "species" columns point to the sitename, treatment name, and
scientificname of these tables.

If you include multiple variables in a single row, they will be associated
with the same entity_id. Otherwise, you can add link multiple rows by
giving them the same entity_id

[mdietze]

How do you enter the SE for different variables? Is the specific variable name in BETY?

[dlebauer]

yes variable_n refers to the variables.name field.

We haven't yet implemented it, but we will be able to upload SE and sample size with the column names <variable_1> SE and <variable_1> n

On Tue, Jul 1, 2014 at 10:54 AM, Michael Dietze notifications@github.com wrote:

How do you enter the SE for different variables? Is the specific variable name in BETY?

On Jul 1, 2014, at 11:50 AM, David LeBauer <notifications@github.com mailto:notifications@github.com> wrote:

The column names for the bulk upload csv are:

,dateloc,time,timeloc,mean,n,SE,notes,<covariate_1>,<covariate_n>,entity_id,access_level```

The sites and treatments would be entered separately, preferably via the
web interface but we could also bulk upload them. The "site",
"treatments",
and "species" columns point to the sitename, treatment name, and
scientificname of these tables.

If you include multiple variables in a single row, they will be associated
with the same entity_id. Otherwise, you can add link multiple rows by
giving them the same entity_id

—
Reply to this email directly or view it on GitHub<
https://github.com/PecanProject/pecan/issues/164#issuecomment-47673566>.

—
Reply to this email directly or view it on GitHub
<https://github.com/PecanProject/pecan/issues/164#issuecomment-47674136>.

[github-actions[bot]]

This issue is stale because it has been open 365 days with no activity.