cct-datascience / organization

Initial repository for organizing group activities
1 stars 0 forks source link

Generate PFT priors for SRER #796

Closed dlebauer closed 2 years ago

dlebauer commented 2 years ago
dlebauer commented 2 years ago

next step David and Jessica to meet to flesh out next steps

dlebauer commented 2 years ago

We have set up PFTs 9e9+13-20 with priors and with associated species

To query all priors:

    select pfts.name as pft,
        variables.name variable,
        priors.phylogeny,
        distn,
        parama,
        paramb,
        n,
        concat(citations.author, ' ', citations.year, ' ', citations.title) as citation 
    from
        priors
        join variables on priors.variable_id = variables.id 
        join pfts_priors on pfts_priors.prior_id = priors.id 
        join pfts on pfts_priors.pft_id = pfts.id 
        join citations on priors.citation_id = citations.id
    where
    pfts.id in ( 9000000013, 9000000016, 9000000020 )

results in srer_priors.csv or see them as a table here: https://gist.github.com/dlebauer/e527d0314be211c8f54b8fb3d3956468

dlebauer commented 2 years ago

Still need to document, add ED2 defaults for reference