EPSG: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"]]

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]]],
        PRIMEM["Greenwich",0,
            ANGLEUNIT["degree",0.0174532925199433]],
        CS[ellipsoidal,2],
            AXIS["geodetic latitude (Lat)",north,
                ORDER[1],
                ANGLEUNIT["degree",0.0174532925199433]],
            AXIS["geodetic longitude (Lon)",east,
                ORDER[2],
                ANGLEUNIT["degree",0.0174532925199433]]],
    VERTCRS["CGVD2013a(1997) height",
        VDATUM["Canadian Geodetic Vertical Datum of 2013 (CGG2013a) epoch 1997"],
        CS[vertical,1],
            AXIS["gravity-related height (H)",up,
                LENGTHUNIT["metre",1]]],
    USAGE[
        SCOPE["Spatial referencing."],
        AREA["Canada - onshore and offshore - Alberta; British Columbia; Manitoba; New Brunswick; Newfoundland and Labrador; Northwest Territories; Nova Scotia; Nunavut; Ontario; Prince Edward Island; Quebec; Saskatchewan; Yukon."],
        BBOX[38.21,-141.01,86.46,-40.73]],
    ID["EPSG",20038]]

GEOGCS["GCS_NAD83_CSRS_v3",
    DATUM["North_American_Datum_of_1983_(CSRS)_version_3",
        SPHEROID["GRS_1980",6378137.0,298.257222101]],
    PRIMEM["Greenwich",0.0],
    UNIT["Degree",0.0174532925199433]],
VERTCS["CGVD2013a(1997)_height",
    VDATUM["Canadian_Geodetic_Vertical_Datum_of_2013_(CGG2013a)_epoch_1997"],
    PARAMETER["Vertical_Shift",0.0],
    PARAMETER["Direction",1.0],
    UNIT["Meter",1.0]]

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

{
    "$schema": "https://proj.org/schemas/v0.7/projjson.schema.json",
    "type": "CompoundCRS",
    "name": "NAD83(CSRS)v3 + CGVD2013a(1997) height",
    "components": [
        {
            "type": "GeographicCRS",
            "name": "NAD83(CSRS)v3",
            "datum": {
                "type": "GeodeticReferenceFrame",
                "name": "North American Datum of 1983 (CSRS) version 3",
                "ellipsoid": {
                    "name": "GRS 1980",
                    "semi_major_axis": 6378137,
                    "inverse_flattening": 298.257222101
                }
            },
            "coordinate_system": {
                "subtype": "ellipsoidal",
                "axis": [
                    {
                        "name": "Geodetic latitude",
                        "abbreviation": "Lat",
                        "direction": "north",
                        "unit": "degree"
                    },
                    {
                        "name": "Geodetic longitude",
                        "abbreviation": "Lon",
                        "direction": "east",
                        "unit": "degree"
                    }
                ]
            }
        },
        {
            "type": "VerticalCRS",
            "name": "CGVD2013a(1997) height",
            "datum": {
                "type": "VerticalReferenceFrame",
                "name": "Canadian Geodetic Vertical Datum of 2013 (CGG2013a) epoch 1997"
            },
            "coordinate_system": {
                "subtype": "vertical",
                "axis": [
                    {
                        "name": "Gravity-related height",
                        "abbreviation": "H",
                        "direction": "up",
                        "unit": "metre"
                    }
                ]
            }
        }
    ],
    "scope": "Spatial referencing.",
    "area": "Canada - onshore and offshore - Alberta; British Columbia; Manitoba; New Brunswick; Newfoundland and Labrador; Northwest Territories; Nova Scotia; Nunavut; Ontario; Prince Edward Island; Quebec; Saskatchewan; Yukon.",
    "bbox": {
        "south_latitude": 38.21,
        "west_longitude": -141.01,
        "north_latitude": 86.46,
        "east_longitude": -40.73
    },
    "id": {
        "authority": "EPSG",
        "code": 20038
    }
}

<?xml version="1.0" encoding="utf-8"?>
<Map srs="+proj=longlat +ellps=GRS80 +vunits=m +no_defs +type=crs">
	<Layer srs="+proj=longlat +ellps=GRS80 +vunits=m +no_defs +type=crs">
	</Layer>
</Map>

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"]]');