forc-db / IPCC-EFDB-integration

Creative Commons Attribution 4.0 International
4 stars 3 forks source link

ensure that ANPP_woody_stem records show up in the variables table #43

Closed teixeirak closed 1 year ago

teixeirak commented 1 year ago

@ValentineHerr , I noticed that there are no records for ANPP_woody_stem in this table, although we've definitely sent some (e.g., Piponiot study). The problem may be that the table is not up to date (#42 ) or that I'm expecting ANPP_woody_stem records to show up as part of ANPP_woody (lumping for simplicity). I the problem is the latter, could you please adjust code such that these show up as part of ANPP_woody?

teixeirak commented 1 year ago

AGB or Classified otherwise (OTH) would be broader categories. I think the issue is just that ForC makes a fairly fine distinction between ANPP_woody and ANPP_woody_stem that I'm dropping for the purposes of this paper. I think that at some point your code just pulls ANPP_woody and doesn't pull in ANPP_woody_stem.

ValentineHerr commented 1 year ago

ok I look into this more carefully

ValentineHerr commented 1 year ago

OK, the following variable are filtered out because the script only looks at variables listed in this file. Can you tick the variables that should not be dropped and should be lumped into another?

ValentineHerr commented 1 year ago

For the variables that needs their own rows, if you add them in that C_variables_order_template.csv file, they will be pulled in the summary table.

teixeirak commented 1 year ago

I see NPP_woody in this list, but it's also in this table. Ditto for ANPP_woody.

teixeirak commented 1 year ago

ANPP_woody_branch

Not sure what to do about this one. IPCC wants it, but it's a minor variable and I'd prefer not to bog down the figure and table with it. I'll come back to this.

ValentineHerr commented 1 year ago

I see NPP_woody in this list, but it's also in this table. Ditto for ANPP_woody.

oops.. sorry, I'll see what happened there.

teixeirak commented 1 year ago

I see NPP_woody in this list, but it's also in this table. Ditto for ANPP_woody.

Actually, I think that's a list of all variables.

Those of interest to IPCC are in the provide.to.IPCC field of this file.

There's some discrepancy between the ones that IPCC wants and the ones I wanted to show in the figure & table. I need to think about that.

teixeirak commented 1 year ago

What would be helpful is to get a list of the variables not in this table but flagged in the provide.to.IPCC field of this file.

teixeirak commented 1 year ago

I guess we need to either list them all or create an "other variables" category.

ValentineHerr commented 1 year ago

FYI, edited the list. It now only shows the ones that are not in the C_variables_order_template.csv file.

We look into your other comments now.

ValentineHerr commented 1 year ago

What would be helpful is to get a list of the variables not in this table but flagged in the provide.to.IPCC field of this file.

Here it is

teixeirak commented 1 year ago

I edited your list to remove covariates.

ValentineHerr commented 1 year ago

I guess we need to either list them all or create an "other variables" category.

The main concern is space in the C_variable_mapping.png diagram?

teixeirak commented 1 year ago

Here's my list of what to do with each (I'll edit this gradually):

teixeirak commented 1 year ago

@ValentineHerr , I think the above list is good now.

teixeirak commented 1 year ago

Replicating the list above so that I can check off my edits:

Here's my list of what to do with each (I'll edit this gradually):

ValentineHerr commented 1 year ago

let me know when you've pushed your edits

teixeirak commented 1 year ago

For the variables that needs their own rows, if you add them in that C_variables_order_template.csv file, they will be pulled in the summary table.

Oops, I missed this. Will do it now.

teixeirak commented 1 year ago

when multiple variables should be combined in the same row, should I separate with "/"? It looks like that's what we did for SOC/ SOM.

ValentineHerr commented 1 year ago

when multiple variables should be combined in the same row, should I separate with "/"? It looks like that's what we did for SOC/ SOM.

Hmmm... I think in that case it is just showing the variable "soil" as SOM/SOC, it is not pulling any variables together.

ValentineHerr commented 1 year ago

For now add a row but repeat the value in the third column (variable).

teixeirak commented 1 year ago

Oh, so variable is what's displayed? (I'll need to adjust what I've been doing.)

ValentineHerr commented 1 year ago

Oh, so variable is what's displayed? (I'll need to adjust what I've been doing.) yes. I use that table to have an easy way to order he variables in the way you wanted, and also to display prettier names