EPSG:5500 — NAD83(NSRS2007) + NAVD88 height

COMPOUNDCRS[
    "NAD83(NSRS2007) + NAVD88 height",
    GEOGCRS[
        "NAD83(NSRS2007)",
        DATUM[
            "NAD83 (National Spatial Reference System 2007)",
            ELLIPSOID[
                "GRS 1980",
                6378137,
                298.257222101,
                LENGTHUNIT["metre",1,ID["EPSG",9001]],
                ID["EPSG",7019]
            ],
            ID["EPSG",6759]
        ],
        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",4759]
    ],
    VERTCRS[
        "NAVD88 height",
        VDATUM["North American Vertical Datum 1988",ID["EPSG",5103]],
        CS[vertical,1,ID["EPSG",6499]],
        AXIS["Gravity-related height (H)",up],
        LENGTHUNIT["metre",1,ID["EPSG",9001]],
        GEOIDMODEL["NAD83(2011) to NAVD88 height (1)",ID["EPSG",6326]],
        GEOIDMODEL["NAD83(2011) to NAVD88 height (2)",ID["EPSG",6327]],
        GEOIDMODEL["NAD83(HARN) to NAVD88 height (1)",ID["EPSG",9160]],
        GEOIDMODEL["NAD83(HARN) to NAVD88 height (2)",ID["EPSG",9161]],
        GEOIDMODEL["NAD83(HARN) to NAVD88 height (3)",ID["EPSG",9162]],
        GEOIDMODEL["NAD83(HARN) to NAVD88 height (4)",ID["EPSG",9163]],
        GEOIDMODEL["NAD83(HARN) to NAVD88 height (5)",ID["EPSG",9164]],
        GEOIDMODEL["NAD83(HARN) to NAVD88 height (6)",ID["EPSG",9165]],
        GEOIDMODEL["NAD83(HARN) to NAVD88 height (7)",ID["EPSG",9166]],
        GEOIDMODEL["NAD83(HARN) to NAVD88 height (8)",ID["EPSG",9167]],
        GEOIDMODEL["NAD83(FBN) to NAVD88 height (1)",ID["EPSG",9168]],
        GEOIDMODEL["NAD83(HARN) to NAVD88 height (9)",ID["EPSG",9169]],
        GEOIDMODEL["NAD83(NSRS2007) to NAVD88 height (1)",ID["EPSG",9173]],
        GEOIDMODEL["NAD83(NSRS2007) to NAVD88 height (2)",ID["EPSG",9174]],
        GEOIDMODEL["NAD83(2011) to NAVD88 height (3)",ID["EPSG",9229]],
        ID["EPSG",5703]
    ],
    ID["EPSG",5500]
]

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

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

{
  "type": "CoordinateReferenceSystem",
  "code": 5500,
  "name": "NAD83(NSRS2007) + NAVD88 height",
  "kind": "compound",
  "area": "USA - CONUS - onshore",
  "unit": null,
  "bbox": [
    24.41,
    -124.79,
    49.38,
    -66.91
  ],
  "proj4": "+proj=longlat +ellps=GRS80 +vunits=m +no_defs +type=crs"
}

INSERT INTO spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext)
VALUES (5500, 'EPSG', 5500, '+proj=longlat +ellps=GRS80 +vunits=m +no_defs +type=crs', 'COMPD_CS["NAD83(NSRS2007) + NAVD88 height",GEOGCS["NAD83(NSRS2007)",DATUM["NAD83_National_Spatial_Reference_System_2007",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6759"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4759"]],VERT_CS["NAVD88 height",VERT_DATUM["North American Vertical Datum 1988",2005,AUTHORITY["EPSG","5103"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Gravity-related height",UP],AUTHORITY["EPSG","5703"]],AUTHORITY["EPSG","5500"]]');

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

5500=COMPD_CS["NAD83(NSRS2007) + NAVD88 height",GEOGCS["NAD83(NSRS2007)",DATUM["NAD83_National_Spatial_Reference_System_2007",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6759"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4759"]],VERT_CS["NAVD88 height",VERT_DATUM["North American Vertical Datum 1988",2005,AUTHORITY["EPSG","5103"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Gravity-related height",UP],AUTHORITY["EPSG","5703"]],AUTHORITY["EPSG","5500"]]