EPSG:20038 — NAD83(CSRS)v3 + CGVD2013a(1997) height

COMPOUNDCRS[
    "NAD83(CSRS)v3 + CGVD2013a(1997) height",
    GEOGCRS[
        "NAD83(CSRS)v3",
        DATUM[
            "North American Datum of 1983 (CSRS) version 3",
            ELLIPSOID[
                "GRS 1980",
                6378137,
                298.257222101,
                LENGTHUNIT["metre",1,ID["EPSG",9001]],
                ID["EPSG",7019]
            ],
            ANCHOREPOCH[1997],
            ID["EPSG",1194]
        ],
        CS[ellipsoidal,2,ID["EPSG",6422]],
        AXIS["Geodetic latitude (Lat)",north],
        AXIS["Geodetic longitude (Lon)",east],
        ANGLEUNIT["degree",0.0174532925199433,ID["EPSG",9102]],
        ID["EPSG",8240]
    ],
    VERTCRS[
        "CGVD2013a(1997) height",
        VDATUM[
            "Canadian Geodetic Vertical Datum of 2013 (CGG2013a) epoch 1997",
            ANCHOREPOCH[1997],
            ID["EPSG",1326]
        ],
        CS[vertical,1,ID["EPSG",6499]],
        AXIS["Gravity-related height (H)",up],
        LENGTHUNIT["metre",1,ID["EPSG",9001]],
        ID["EPSG",20035]
    ],
    ID["EPSG",20038]
]

+proj=longlat +ellps=GRS80 +vunits=m +no_defs +type=crs

proj4.defs("EPSG:20038", "+proj=longlat +ellps=GRS80 +vunits=m +no_defs +type=crs");

{
  "type": "CoordinateReferenceSystem",
  "code": 20038,
  "name": "NAD83(CSRS)v3 + CGVD2013a(1997) height",
  "kind": "compound",
  "area": "Canada",
  "unit": null,
  "bbox": [
    38.21,
    -141.01,
    86.46,
    -40.73
  ],
  "proj4": "+proj=longlat +ellps=GRS80 +vunits=m +no_defs +type=crs"
}

INSERT INTO spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext)
VALUES (20038, 'EPSG', 20038, '+proj=longlat +ellps=GRS80 +vunits=m +no_defs +type=crs', 'COMPD_CS["NAD83(CSRS)v3 + CGVD2013a(1997) height",GEOGCS["NAD83(CSRS)v3",DATUM["North_American_Datum_of_1983_CSRS_version_3",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","1194"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","8240"]],VERT_CS["CGVD2013a(1997) height",VERT_DATUM["Canadian Geodetic Vertical Datum of 2013 (CGG2013a) epoch 1997",2005,AUTHORITY["EPSG","1326"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Gravity-related height",UP],AUTHORITY["EPSG","20035"]],AUTHORITY["EPSG","20038"]]');

PROJECTION
  "+proj=longlat"
  "+ellps=GRS80"
  "+vunits=m"
  "+no_defs"
  "+type=crs"
END

20038=COMPD_CS["NAD83(CSRS)v3 + CGVD2013a(1997) height",GEOGCS["NAD83(CSRS)v3",DATUM["North_American_Datum_of_1983_CSRS_version_3",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","1194"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","8240"]],VERT_CS["CGVD2013a(1997) height",VERT_DATUM["Canadian Geodetic Vertical Datum of 2013 (CGG2013a) epoch 1997",2005,AUTHORITY["EPSG","1326"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Gravity-related height",UP],AUTHORITY["EPSG","20035"]],AUTHORITY["EPSG","20038"]]