This is a working document showing the conversion status for publishing E3SM data to CMIP6. The variables listed are unordered, and pulled from the priority 1 request list as well as scientist input. If you think that an important variable is missing please add it.

The conversion formulas are for the most part compiled with input from domain exports. There is the very real possibility they may be incorrect, please verify the conversions in your area of expertise and mark the "verified" column with your name.

Much of this information is pulled from the previous discussion page E3SM data conversion for CMIP6, but I wanted to distill the information down to the bare necessities.

Data Tables Pages

A table summarizing all the variables published (original names and CMIP names) is on Default Set of Model Output for ESGF publication

Resources:

CMIP6 data request https://www.earthsystemcog.org/projects/wip/CMIP6DataRequest
CESM Amon conversion table for CMIP5: https://github.com/NCAR/CCP_Processing_Suite/blob/master/CMOR2/Xwalks
http://clipc-services.ceda.ac.uk/dreq/data/tabs02/cmvme_CMIP_piControl_1_1.xlsx
CMIP6 tables : http://clipc-services.ceda.ac.uk/dreq/index/miptable.html
JSON tables on GitHub https://github.com/PCMDI/cmip6-cmor-tables

ATM

Amon (monthly atmospheric data)

Notes:

Full request: http://clipc-services.ceda.ac.uk/dreq/u/MIPtable::Amon.html
CESM Amon conversion table for CMIP5 (https://github.com/NCAR/CCP_Processing_Suite/blob/master/CMOR2/Xwalks/xwalk_CMIP5_Amon, thanks to Peter Caldwell for finding this).
All fields must be interpolated in the horizontal to the new CMIP6 grids for which Charlie Zender prepared mapping files (see CMIP6 Grid-files and Map-files).
Some 3d variables must be reported on model levels and others interpolated to the standard 19 pressure levels.

First set of atmospheric data has been cmorized provided by Sterling:

atm metadata sample

{
dimensions:
time = UNLIMITED ; // (6000 currently)
lat = 180 ;
lon = 360 ;
bnds = 2 ;
variables:
double time(time) ;
time:bounds = "time_bnds" ;
time:units = "days since 0001-01-01 00:00:00" ;
time:calendar = "noleap" ;
time:axis = "T" ;
time:long_name = "time" ;
time:standard_name = "time" ;
double time_bnds(time, bnds) ;
double lat(lat) ;
lat:bounds = "lat_bnds" ;
lat:units = "degrees_north" ;
lat:axis = "Y" ;
lat:long_name = "latitude" ;
lat:standard_name = "latitude" ;
double lat_bnds(lat, bnds) ;
double lon(lon) ;
lon:bounds = "lon_bnds" ;
lon:units = "degrees_east" ;
lon:axis = "X" ;
lon:long_name = "Longitude" ;
lon:standard_name = "longitude" ;
double lon_bnds(lon, bnds) ;
float evspsbl(time, lat, lon) ;
evspsbl:standard_name = "water_evapotranspiration_flux" ;
evspsbl:long_name = "Evaporation including Sublimation and Transpiration" ;
evspsbl:comment = "Evaporation at surface (also known as evapotranspiration): flux of water into the atmosphere due to conversion of both liquid and solid phases to vapor (from underlying surface and vegetation)" ;
evspsbl:units = "kg m-2 s-1" ;
evspsbl:cell_methods = "area: time: mean" ;
evspsbl:cell_measures = "area: areacella" ;
evspsbl:missing_value = 1.e+20f ;
evspsbl:_FillValue = 1.e+20f ;

// global attributes:
:Conventions = "CF-1.7 CMIP-6.2" ;
:activity_id = "CMIP" ;
:branch_method = "Spin-up documentation" ;
:branch_time_in_child = 0. ;
:branch_time_in_parent = 0. ;
:contact = "Dave Bader (bader2@llnl.gov)" ;
:creation_date = "2019-02-06T22:05:27Z" ;
:data_specs_version = "01.00.27" ;
:experiment = "pre-industrial control" ;
:experiment_id = "piControl" ;
:external_variables = "areacella" ;
:forcing_index = 1 ;
:frequency = "mon" ;
:further_info_url = "https://furtherinfo.es-doc.org/CMIP6.E3SM-Project.E3SM-1-0.piControl.none.r1i1p1f1" ;
:grid = "gs1x1" ;
:grid_label = "gr" ;
:history = "2019-02-06T22:05:27Z ;rewrote data to be consistent with CMIP for variable evspsbl found in table Amon.;\n",
"Output from 20180129.DECKv1b_piControl.ne30_oEC.edison" ;
:initialization_index = 1 ;
:institution = "LLNL (Lawrence Livermore National Laboratory, Livermore, CA 94550, USA); ANL (Argonne National Laboratory, Argonne, IL 60439, USA); BNL (Brookhaven National Laboratory, Upton, NY 11973, USA); LANL (Los Alamos National Laboratory, Los Alamos, NM 87545, USA); LBNL (Lawrence Berkeley National Laboratory, Berkeley, CA 94720, USA); ORNL (Oak Ridge National Laboratory, Oak Ridge, TN 37831, USA); PNNL (Pacific Northwest National Laboratory, Richland, WA 99352, USA); SNL (Sandia National Laboratories, Albuquerque, NM 87185, USA). Mailing address: LLNL Climate Program, c/o David C. Bader, Principal Investigator, L-103, 7000 East Avenue, Livermore, CA 94550, USA" ;
:institution_id = "E3SM-Project" ;
:mip_era = "CMIP6" ;
:nominal_resolution = "100 km" ;
:parent_activity_id = "CMIP" ;
:parent_experiment_id = "piControl-spinup" ;
:parent_mip_era = "CMIP6" ;
:parent_source_id = "E3SM-1-0" ;
:parent_time_units = "days since 0001-01-01" ;
:parent_variant_label = "r1i1p1f1" ;
:physics_index = 1 ;
:product = "model-output" ;
:realization_index = 1 ;
:realm = "atmos" ;
:references = "Golaz, J.-C., P. M. Caldwell, L. P. Van Roekel and co-authors, 2019: The DOE E3SM coupled model version 1: Overviewand evaluation at standard resolution. JAMES, submitted; http://e3sm.org" ;
:source = "E3SM 1.0 (2018): \n",
"aerosol: MAM4 with resuspension, marine organics, and secondary organics (same grid as atmos)\n",
"atmos: EAM (v1.0, cubed sphere spectral-element grid; 5400 elements with p=3; 1 deg average grid spacing; 90 x 90 x 6 longitude/latitude/cubeface; 72 levels; top level 0.1 hPa)\n",
"atmosChem: Troposphere specified oxidants for aerosols. Stratosphere linearized interactive ozone (LINOZ v2) (same grid as atmos)\n",
"land: ELM (v1.0, cubed sphere spectral-element grid; 5400 elements with p=3; 1 deg average grid spacing; 90 x 90 x 6 longitude/latitude/cubeface; satellite phenology mode), MOSART (v1.0, 0.5 degree latitude/longitude grid)\n",
"landIce: none\n",
"ocean: MPAS-Ocean (v6.0, oEC60to30 unstructured SVTs mesh with 235160 cells and 714274 edges, variable resolution 60 km to 30 km; 60 levels; top grid cell 0-10 m)\n",
"ocnBgchem: none\n",
"seaIce: MPAS-Seaice (v6.0, same grid as ocean)" ;
:source_id = "E3SM-1-0" ;
:source_type = "AOGCM AER" ;
:sub_experiment = "none" ;
:sub_experiment_id = "none" ;
:table_id = "Amon" ;
:table_info = "Creation Date:(30 July 2018) MD5:fa9bc503f57fb067bf398cab2c4ba77e" ;
:title = "E3SM-1-0 output prepared for CMIP6" ;
:variable_id = "evspsbl" ;
:variant_label = "r1i1p1f1" ;
:license = "CMIP6 model data produced by E3SM is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License (https://creativecommons.org/licenses/). Consult https://pcmdi.llnl.gov/CMIP6/TermsOfUse for terms of use governing CMIP6 output, including citation requirements and proper acknowledgment. Further information about this data, including some limitations, can be found via the further_info_url (recorded as a global attribute in this file). The data producers and data providers make no warranty, either express or implied, including, but not limited to, warranties of merchantability and fitness for a particular purpose. All liabilities arising from the supply of the information (including any liability arising in negligence) are excluded to the fullest extent permitted by law." ;
:cmor_version = "3.4.0" ;
:tracking_id = "hdl:21.14100/aa17980b-4aed-4e89-9d38-27b835aa03ff" ;
:e3sm_source_code_doi = "10.11578/E3SM/dc.20180418.36" ;
:e3sm_source_code_reference = "https://github.com/E3SM-Project/E3SM/releases/tag/v1.0.0" ;
:doe_acknowledgement = "This research was supported as part of the Energy Exascale Earth System Model (E3SM) project, funded by the U.S. Department of Energy, Office of Science, Office of Biological and Environmental Research." ;
:computational_acknowledgement = "The data were produced using resources of the National Energy Research Scientific Computing Center, a DOE Office of Science User Facility supported by the Office of Science of the U.S. Department of Energy under Contract No. DE-AC02-05CH11231." ;
:ncclimo_generation_command = "ncclimo --var=$

Unknown macro: {var}

-7 --dfl_lvl=1 --no_cll_msr --no_frm_trm --no_stg_grd --yr_srt=1 --yr_end=500 --ypf=500 --map=map_ne30np4_to_cmip6_180x360_aave.20181001.nc " ;
:ncclimo_version = "4.7.9-alpha04" ;
}

Amon variable conversion table

Additional tables to consider

3hr, 6hrLev, 6hrPlev, 6hrPlevPt
CF3hr, CFday, CFmon (suggest consulting with Yuying Zhang on most useful variables and variables not impacted by COSP bug).
AERmon

CFMon

CFmon variable conversion table

Land

Lmon variable conversion table

Ocean

Omon variable conversion table

Ice

ICE. – Notz et al. 2016 – https://www.geosci-model-dev.net/9/3427/2016/gmd-9-3427-2016.pdf
SImon variable conversion table

fx/Ofx

(Fixed variables, auxiliary variables useful for diagnostics: including cell_area of land/ocean, land_area_fraction, land_ice_area_fraction)

fx/Ofx variable conversion table

Browser not supported