EPSG:9647

COORDINATEOPERATION["Alicante height to EVRF2019 mean-tide height (1)",
    VERSION["EuG-Esp 2019m 2020-09"],
    SOURCECRS[
        VERTCRS["Alicante height",
            VDATUM["Alicante"],
            CS[vertical,1],
                AXIS["gravity-related height (H)",up,
                    LENGTHUNIT["metre",1]],
            ID["EPSG",5782]]],
    TARGETCRS[
        VERTCRS["EVRF2019 mean-tide height",
            VDATUM["European Vertical Reference Frame 2019 mean tide"],
            CS[vertical,1],
                AXIS["gravity-related height (H)",up,
                    LENGTHUNIT["metre",1]],
            ID["EPSG",9390]]],
    METHOD["Vertical Offset by Grid Interpolation (asc)",
        ID["EPSG",1085]],
    PARAMETERFILE["Vertical offset file","es_2019m.asc"],
    INTERPOLATIONCRS[
        GEOGCRS["ETRS89",
            ENSEMBLE["European Terrestrial Reference System 1989 ensemble",
                MEMBER["European Terrestrial Reference Frame 1989"],
                MEMBER["European Terrestrial Reference Frame 1990"],
                MEMBER["European Terrestrial Reference Frame 1991"],
                MEMBER["European Terrestrial Reference Frame 1992"],
                MEMBER["European Terrestrial Reference Frame 1993"],
                MEMBER["European Terrestrial Reference Frame 1994"],
                MEMBER["European Terrestrial Reference Frame 1996"],
                MEMBER["European Terrestrial Reference Frame 1997"],
                MEMBER["European Terrestrial Reference Frame 2000"],
                MEMBER["European Terrestrial Reference Frame 2005"],
                MEMBER["European Terrestrial Reference Frame 2014"],
                ELLIPSOID["GRS 1980",6378137,298.257222101,
                    LENGTHUNIT["metre",1]],
                ENSEMBLEACCURACY[0.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.078],
    USAGE[
        SCOPE["Change of height to a different vertical reference surface."],
        AREA["Spain - mainland onshore."],
        BBOX[35.95,-9.37,43.82,3.39]],
    ID["EPSG",9647],
    REMARK["Determined at 155 points, SD 0.039m. Offset: mean -0.488m, minimum -0.603m, maximum -0.426m."]]

{
    "$schema": "https://proj.org/schemas/v0.7/projjson.schema.json",
    "type": "Transformation",
    "name": "Alicante height to EVRF2019 mean-tide height (1)",
    "source_crs": {
        "type": "VerticalCRS",
        "name": "Alicante height",
        "datum": {
            "type": "VerticalReferenceFrame",
            "name": "Alicante"
        },
        "coordinate_system": {
            "subtype": "vertical",
            "axis": [
                {
                    "name": "Gravity-related height",
                    "abbreviation": "H",
                    "direction": "up",
                    "unit": "metre"
                }
            ]
        },
        "id": {
            "authority": "EPSG",
            "code": 5782
        }
    },
    "target_crs": {
        "type": "VerticalCRS",
        "name": "EVRF2019 mean-tide height",
        "datum": {
            "type": "VerticalReferenceFrame",
            "name": "European Vertical Reference Frame 2019 mean tide"
        },
        "coordinate_system": {
            "subtype": "vertical",
            "axis": [
                {
                    "name": "Gravity-related height",
                    "abbreviation": "H",
                    "direction": "up",
                    "unit": "metre"
                }
            ]
        },
        "id": {
            "authority": "EPSG",
            "code": 9390
        }
    },
    "interpolation_crs": {
        "type": "GeographicCRS",
        "name": "ETRS89",
        "datum_ensemble": {
            "name": "European Terrestrial Reference System 1989 ensemble",
            "members": [
                {
                    "name": "European Terrestrial Reference Frame 1989",
                    "id": {
                        "authority": "EPSG",
                        "code": 1178
                    }
                },
                {
                    "name": "European Terrestrial Reference Frame 1990",
                    "id": {
                        "authority": "EPSG",
                        "code": 1179
                    }
                },
                {
                    "name": "European Terrestrial Reference Frame 1991",
                    "id": {
                        "authority": "EPSG",
                        "code": 1180
                    }
                },
                {
                    "name": "European Terrestrial Reference Frame 1992",
                    "id": {
                        "authority": "EPSG",
                        "code": 1181
                    }
                },
                {
                    "name": "European Terrestrial Reference Frame 1993",
                    "id": {
                        "authority": "EPSG",
                        "code": 1182
                    }
                },
                {
                    "name": "European Terrestrial Reference Frame 1994",
                    "id": {
                        "authority": "EPSG",
                        "code": 1183
                    }
                },
                {
                    "name": "European Terrestrial Reference Frame 1996",
                    "id": {
                        "authority": "EPSG",
                        "code": 1184
                    }
                },
                {
                    "name": "European Terrestrial Reference Frame 1997",
                    "id": {
                        "authority": "EPSG",
                        "code": 1185
                    }
                },
                {
                    "name": "European Terrestrial Reference Frame 2000",
                    "id": {
                        "authority": "EPSG",
                        "code": 1186
                    }
                },
                {
                    "name": "European Terrestrial Reference Frame 2005",
                    "id": {
                        "authority": "EPSG",
                        "code": 1204
                    }
                },
                {
                    "name": "European Terrestrial Reference Frame 2014",
                    "id": {
                        "authority": "EPSG",
                        "code": 1206
                    }
                }
            ],
            "ellipsoid": {
                "name": "GRS 1980",
                "semi_major_axis": 6378137,
                "inverse_flattening": 298.257222101
            },
            "accuracy": "0.1",
            "id": {
                "authority": "EPSG",
                "code": 6258
            }
        },
        "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": 4258
        }
    },
    "method": {
        "name": "Vertical Offset by Grid Interpolation (asc)",
        "id": {
            "authority": "EPSG",
            "code": 1085
        }
    },
    "parameters": [
        {
            "name": "Vertical offset file",
            "value": "es_2019m.asc",
            "id": {
                "authority": "EPSG",
                "code": 8732
            }
        }
    ],
    "accuracy": "0.078",
    "scope": "Change of height to a different vertical reference surface.",
    "area": "Spain - mainland onshore.",
    "bbox": {
        "south_latitude": 35.95,
        "west_longitude": -9.37,
        "north_latitude": 43.82,
        "east_longitude": 3.39
    },
    "id": {
        "authority": "EPSG",
        "code": 9647
    },
    "remarks": "Determined at 155 points, SD 0.039m. Offset: mean -0.488m, minimum -0.603m, maximum -0.426m."
}

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 9647, 'EPSG', 9647, 'None', 'None');