EPSG:9714 — NAD83(CSRS) / UTM zone 24N + CGVD2013 height

COMPOUNDCRS[
    "NAD83(CSRS) / UTM zone 24N + CGVD2013 height",
    PROJCRS[
        "NAD83(CSRS) / UTM zone 24N",
        BASEGEOGCRS[
            "NAD83(CSRS)",
            DATUM[
                "NAD83 Canadian Spatial Reference System",
                ELLIPSOID[
                    "GRS 1980",
                    6378137,
                    298.257222101,
                    LENGTHUNIT["metre",1,ID["EPSG",9001]],
                    ID["EPSG",7019]
                ],
                ID["EPSG",6140]
            ],
            ID["EPSG",4617]
        ],
        CONVERSION[
            "UTM zone 24N",
            METHOD["Transverse Mercator",ID["EPSG",9807]],
            PARAMETER[
                "Latitude of natural origin",
                0,
                ANGLEUNIT["degree",0.0174532925199433,ID["EPSG",9102]],
                ID["EPSG",8801]
            ],
            PARAMETER[
                "Longitude of natural origin",
                -39,
                ANGLEUNIT["degree",0.0174532925199433,ID["EPSG",9102]],
                ID["EPSG",8802]
            ],
            PARAMETER[
                "Scale factor at natural origin",
                0.9996,
                SCALEUNIT["unity",1,ID["EPSG",9201]],
                ID["EPSG",8805]
            ],
            PARAMETER[
                "False easting",
                500000,
                LENGTHUNIT["metre",1,ID["EPSG",9001]],
                ID["EPSG",8806]
            ],
            PARAMETER[
                "False northing",
                0,
                LENGTHUNIT["metre",1,ID["EPSG",9001]],
                ID["EPSG",8807]
            ],
            ID["EPSG",16024]
        ],
        CS[Cartesian,2,ID["EPSG",4400]],
        AXIS["Easting (E)",east],
        AXIS["Northing (N)",north],
        LENGTHUNIT["metre",1,ID["EPSG",9001]],
        ID["EPSG",9713]
    ],
    VERTCRS[
        "CGVD2013(CGG2013) height",
        VDATUM["Canadian Geodetic Vertical Datum of 2013 (CGG2013)",ID["EPSG",1127]],
        CS[vertical,1,ID["EPSG",6499]],
        AXIS["Gravity-related height (H)",up],
        LENGTHUNIT["metre",1,ID["EPSG",9001]],
        GEOIDMODEL["ITRF2008 to CGVD2013(CGG2013) height (1)",ID["EPSG",9124]],
        GEOIDMODEL["NAD83(CSRS)v6 to CGVD2013(CGG2013) height (1)",ID["EPSG",9246]],
        ID["EPSG",6647]
    ],
    ID["EPSG",9714]
]

+proj=utm +zone=24 +ellps=GRS80 +units=m +vunits=m +no_defs +type=crs

proj4.defs("EPSG:9714", "+proj=utm +zone=24 +ellps=GRS80 +units=m +vunits=m +no_defs +type=crs");

{
  "type": "CoordinateReferenceSystem",
  "code": 9714,
  "name": "NAD83(CSRS) / UTM zone 24N + CGVD2013 height",
  "kind": "compound",
  "area": "Canada - east of 42°W",
  "unit": null,
  "bbox": [
    45.53,
    -42,
    49.53,
    -40.73
  ],
  "proj4": "+proj=utm +zone=24 +ellps=GRS80 +units=m +vunits=m +no_defs +type=crs"
}

INSERT INTO spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext)
VALUES (9714, 'EPSG', 9714, '+proj=utm +zone=24 +ellps=GRS80 +units=m +vunits=m +no_defs +type=crs', 'COMPD_CS["NAD83(CSRS) / UTM zone 24N + CGVD2013 height",PROJCS["NAD83(CSRS) / UTM zone 24N",GEOGCS["NAD83(CSRS)",DATUM["NAD83_Canadian_Spatial_Reference_System",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6140"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4617"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",-39],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","9713"]],VERT_CS["CGVD2013(CGG2013) height",VERT_DATUM["Canadian Geodetic Vertical Datum of 2013 (CGG2013)",2005,AUTHORITY["EPSG","1127"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Gravity-related height",UP],AUTHORITY["EPSG","6647"]],AUTHORITY["EPSG","9714"]]');

PROJECTION
  "+proj=utm"
  "+zone=24"
  "+ellps=GRS80"
  "+units=m"
  "+vunits=m"
  "+no_defs"
  "+type=crs"
END

9714=COMPD_CS["NAD83(CSRS) / UTM zone 24N + CGVD2013 height",PROJCS["NAD83(CSRS) / UTM zone 24N",GEOGCS["NAD83(CSRS)",DATUM["NAD83_Canadian_Spatial_Reference_System",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6140"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4617"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",-39],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","9713"]],VERT_CS["CGVD2013(CGG2013) height",VERT_DATUM["Canadian Geodetic Vertical Datum of 2013 (CGG2013)",2005,AUTHORITY["EPSG","1127"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Gravity-related height",UP],AUTHORITY["EPSG","6647"]],AUTHORITY["EPSG","9714"]]