EPSG:5024

COORDINATEOPERATION["Azores Oriental 1995 to PTRA08 (1)",
    VERSION["IGP-Prt Az E"],
    SOURCECRS[
        GEOGCRS["Azores Oriental 1995",
            DATUM["Azores Oriental Islands 1995",
                ELLIPSOID["International 1924",6378388,297,
                    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]],
            ID["EPSG",4664]]],
    TARGETCRS[
        GEOGCRS["PTRA08",
            DATUM["Autonomous Regions of Portugal 2008",
                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]],
            ID["EPSG",5013]]],
    METHOD["Geocentric translations (geog2D domain)",
        ID["EPSG",9603]],
    PARAMETER["X-axis translation",-204.926,
        LENGTHUNIT["metre",1],
        ID["EPSG",8605]],
    PARAMETER["Y-axis translation",140.353,
        LENGTHUNIT["metre",1],
        ID["EPSG",8606]],
    PARAMETER["Z-axis translation",55.063,
        LENGTHUNIT["metre",1],
        ID["EPSG",8607]],
    OPERATIONACCURACY[2.0],
    USAGE[
        SCOPE["Transformation of coordinates at 2m level of accuracy."],
        AREA["Portugal - eastern Azores onshore - Sao Miguel, Santa Maria, Formigas."],
        BBOX[36.87,-25.92,37.96,-24.72]],
    ID["EPSG",5024],
    REMARK["Derived at 53 points in May 2009. Residuals at 58 test points within 0.2m horizontal and 2m vertical. Info source also provides a Position Vector tfm of similar accuracy. See codes 5025-26 for preferred tfms for islands of Sao Miguel and Santa Maria."]]

proj4.defs("EPSG:5024","+proj=pipeline +step +proj=axisswap +order=2,1 +step +proj=unitconvert +xy_in=deg +xy_out=rad +step +proj=push +v_3 +step +proj=cart +ellps=intl +step +proj=helmert +x=-204.926 +y=140.353 +z=55.063 +step +inv +proj=cart +ellps=GRS80 +step +proj=pop +v_3 +step +proj=unitconvert +xy_in=rad +xy_out=deg +step +proj=axisswap +order=2,1");

{
    "$schema": "https://proj.org/schemas/v0.7/projjson.schema.json",
    "type": "Transformation",
    "name": "Azores Oriental 1995 to PTRA08 (1)",
    "source_crs": {
        "type": "GeographicCRS",
        "name": "Azores Oriental 1995",
        "datum": {
            "type": "GeodeticReferenceFrame",
            "name": "Azores Oriental Islands 1995",
            "ellipsoid": {
                "name": "International 1924",
                "semi_major_axis": 6378388,
                "inverse_flattening": 297
            }
        },
        "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": 4664
        }
    },
    "target_crs": {
        "type": "GeographicCRS",
        "name": "PTRA08",
        "datum": {
            "type": "GeodeticReferenceFrame",
            "name": "Autonomous Regions of Portugal 2008",
            "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": 5013
        }
    },
    "method": {
        "name": "Geocentric translations (geog2D domain)",
        "id": {
            "authority": "EPSG",
            "code": 9603
        }
    },
    "parameters": [
        {
            "name": "X-axis translation",
            "value": -204.926,
            "unit": "metre",
            "id": {
                "authority": "EPSG",
                "code": 8605
            }
        },
        {
            "name": "Y-axis translation",
            "value": 140.353,
            "unit": "metre",
            "id": {
                "authority": "EPSG",
                "code": 8606
            }
        },
        {
            "name": "Z-axis translation",
            "value": 55.063,
            "unit": "metre",
            "id": {
                "authority": "EPSG",
                "code": 8607
            }
        }
    ],
    "accuracy": "2.0",
    "scope": "Transformation of coordinates at 2m level of accuracy.",
    "area": "Portugal - eastern Azores onshore - Sao Miguel, Santa Maria, Formigas.",
    "bbox": {
        "south_latitude": 36.87,
        "west_longitude": -25.92,
        "north_latitude": 37.96,
        "east_longitude": -24.72
    },
    "id": {
        "authority": "EPSG",
        "code": 5024
    },
    "remarks": "Derived at 53 points in May 2009. Residuals at 58 test points within 0.2m horizontal and 2m vertical. Info source also provides a Position Vector tfm of similar accuracy. See codes 5025-26 for preferred tfms for islands of Sao Miguel and Santa Maria."
}

<?xml version="1.0" encoding="utf-8"?>
<Map srs="+proj=pipeline +step +proj=axisswap +order=2,1 +step +proj=unitconvert +xy_in=deg +xy_out=rad +step +proj=push +v_3 +step +proj=cart +ellps=intl +step +proj=helmert +x=-204.926 +y=140.353 +z=55.063 +step +inv +proj=cart +ellps=GRS80 +step +proj=pop +v_3 +step +proj=unitconvert +xy_in=rad +xy_out=deg +step +proj=axisswap +order=2,1">
	<Layer srs="+proj=pipeline +step +proj=axisswap +order=2,1 +step +proj=unitconvert +xy_in=deg +xy_out=rad +step +proj=push +v_3 +step +proj=cart +ellps=intl +step +proj=helmert +x=-204.926 +y=140.353 +z=55.063 +step +inv +proj=cart +ellps=GRS80 +step +proj=pop +v_3 +step +proj=unitconvert +xy_in=rad +xy_out=deg +step +proj=axisswap +order=2,1">
	</Layer>
</Map>

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 5024, 'EPSG', 5024, '+proj=pipeline +step +proj=axisswap +order=2,1 +step +proj=unitconvert +xy_in=deg +xy_out=rad +step +proj=push +v_3 +step +proj=cart +ellps=intl +step +proj=helmert +x=-204.926 +y=140.353 +z=55.063 +step +inv +proj=cart +ellps=GRS80 +step +proj=pop +v_3 +step +proj=unitconvert +xy_in=rad +xy_out=deg +step +proj=axisswap +order=2,1', 'None');