Identify unique variables from input4MIPs and obs4MIPs

[durack1]

Identify and document additional (non-CMIP6) variables that have been added to the input4mips-cmor-tables and obs4mips-cmor-tables

[durack1]

Will need to add new variables e.g. siconcbcs, tosbcs, etc to tables

[durack1]

Notes to progress:

conda create --name mip-cmor-tables python=3.10 pytest
https://github.com/PCMDI/mip-cmor-tables/blob/main/mip_cmor_tables/mip_cmor_tables_demo_2023-02-10.ipynb

@taylor13 @matthew-mizielinski ping

[durack1]

For new variables that are not produced by models, e.g., tosbcs, make sure that a "product" entry is also added (and existing model variables also get a "modelOutput" (camelCase?) added too)

Ala https://github.com/PCMDI/input4MIPs-cmor-tables/blob/master/input4MIPs_product.json

{
    "product":[
        "derived",
        "observations",
        "reanalysis"
    ]
}

[durack1]

@wolfiex as promised here are the unique variables that are defined in the input4MIPs-cmor-tables

New variables/tables:

destination MIP table	variable_id	input4MIPs entry
AP3hr	prra	link
AP3hrPt	huss	link
AP3hrPt	psl	link
AP3hrPt	tas	link
AP3hrPt	uas	link
AP3hrPt	vas	link
AP3hrPt	ts	link
APfx	sftof	link
APyr	evspsbl	link
APyr	pr	link
APyr	ts	link
LIday	licalvf	link
LIfx	areacellg	link
LIyrC*	licalvf	link
LIyrAnt	acabf	link
LIyrGre	acabf	link
LPday	friver	link
LPyr	mrros	link
OPday	ficeberg2d	link
OPday	friver	link
OPday	tos	link
OPmon	tosbcs^	link
OPmon	volcello	link
OPmonC*	sos	link
OPyr	so	link
OPyrC*	uos	link
OPyrC*	vos	link
SImon	siconcbcs^	link

C* - note all *C (climatological) table entries have dimensions = longitude latitude time2 as time2 is a climatological (not standard time) axis entry
^ - the tosbcs and siconcbcs variables are both unique to input4MIPs, all others are extracted from a cmip6-cmor-table upstream example and relocated to the appropriate table (e.g. the monthly tos CMIP6_Omon is copied into tos input4MIPs_Oday.

All these entries should be tagged with a "Provenance" entry of "input4MIPs".

Cleanups:

I started to tabulate entries that include a period, most often in the comment entry. There are too many to mention, and these are all redundant so should be removed from all entries. We also have quite a number of double spaced entries e.g. OPmon ficeberg2d, may as well squash all these as we go.

I think this is everything, let me know if the format needs tweaking or there is missing info required.

• 230515 - added siconcbcs which was omitted on the first pass