EPSG:7870

COORDINATEOPERATION["NZVD2016 height to Stewart Island 1977 height (1)",
    VERSION["LINZ-NZ STWT"],
    SOURCECRS[
        VERTCRS["NZVD2016 height",
            VDATUM["New Zealand Vertical Datum 2016"],
            CS[vertical,1],
                AXIS["gravity-related height (H)",up,
                    LENGTHUNIT["metre",1]],
            ID["EPSG",7839]]],
    TARGETCRS[
        VERTCRS["Stewart Island 1977 height",
            VDATUM["Stewart Island 1977"],
            CS[vertical,1],
                AXIS["gravity-related height (H)",up,
                    LENGTHUNIT["metre",1]],
            ID["EPSG",5772]]],
    METHOD["Vertical Offset by Grid Interpolation (NZLVD)",
        ID["EPSG",1071]],
    PARAMETERFILE["Vertical offset file","stewartisland-1977-to-nzvd2016-conversion.csv"],
    INTERPOLATIONCRS[
        GEOGCRS["NZGD2000",
            DATUM["New Zealand Geodetic Datum 2000",
                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]]]],
    OPERATIONACCURACY[0.18],
    USAGE[
        SCOPE["Change of height to a different vertical reference surface."],
        AREA["New Zealand - Stewart Island."],
        BBOX[-47.33,167.29,-46.63,168.34]],
    ID["EPSG",7870],
    REMARK["Derived at 4 control points. Mean offset 0.299m, standard deviation 0.025m, maximum difference from mean 0.039m."]]

proj4.defs("EPSG:7870","+proj=vgridshift +grids=nz_linz_stisht1977-nzvd2016.tif +multiplier=1");

{
    "$schema": "https://proj.org/schemas/v0.7/projjson.schema.json",
    "type": "Transformation",
    "name": "NZVD2016 height to Stewart Island 1977 height (1)",
    "source_crs": {
        "type": "VerticalCRS",
        "name": "NZVD2016 height",
        "datum": {
            "type": "VerticalReferenceFrame",
            "name": "New Zealand Vertical Datum 2016"
        },
        "coordinate_system": {
            "subtype": "vertical",
            "axis": [
                {
                    "name": "Gravity-related height",
                    "abbreviation": "H",
                    "direction": "up",
                    "unit": "metre"
                }
            ]
        },
        "id": {
            "authority": "EPSG",
            "code": 7839
        }
    },
    "target_crs": {
        "type": "VerticalCRS",
        "name": "Stewart Island 1977 height",
        "datum": {
            "type": "VerticalReferenceFrame",
            "name": "Stewart Island 1977"
        },
        "coordinate_system": {
            "subtype": "vertical",
            "axis": [
                {
                    "name": "Gravity-related height",
                    "abbreviation": "H",
                    "direction": "up",
                    "unit": "metre"
                }
            ]
        },
        "id": {
            "authority": "EPSG",
            "code": 5772
        }
    },
    "interpolation_crs": {
        "type": "GeographicCRS",
        "name": "NZGD2000",
        "datum": {
            "type": "GeodeticReferenceFrame",
            "name": "New Zealand Geodetic Datum 2000",
            "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"
                }
            ]
        },
        "id": {
            "authority": "EPSG",
            "code": 4167
        }
    },
    "method": {
        "name": "Vertical Offset by Grid Interpolation (NZLVD)",
        "id": {
            "authority": "EPSG",
            "code": 1071
        }
    },
    "parameters": [
        {
            "name": "Vertical offset file",
            "value": "stewartisland-1977-to-nzvd2016-conversion.csv",
            "id": {
                "authority": "EPSG",
                "code": 8732
            }
        }
    ],
    "accuracy": "0.18",
    "scope": "Change of height to a different vertical reference surface.",
    "area": "New Zealand - Stewart Island.",
    "bbox": {
        "south_latitude": -47.33,
        "west_longitude": 167.29,
        "north_latitude": -46.63,
        "east_longitude": 168.34
    },
    "id": {
        "authority": "EPSG",
        "code": 7870
    },
    "remarks": "Derived at 4 control points. Mean offset 0.299m, standard deviation 0.025m, maximum difference from mean 0.039m."
}

<?xml version="1.0" encoding="utf-8"?>
<Map srs="+proj=vgridshift +grids=nz_linz_stisht1977-nzvd2016.tif +multiplier=1">
	<Layer srs="+proj=vgridshift +grids=nz_linz_stisht1977-nzvd2016.tif +multiplier=1">
	</Layer>
</Map>

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 7870, 'EPSG', 7870, '+proj=vgridshift +grids=nz_linz_stisht1977-nzvd2016.tif +multiplier=1', 'None');