EPSG:9117

COORDINATEOPERATION["NAD83 to NAD83(CSRS)v3 (7)",
    VERSION["GeoBC-Can BC CRD"],
    SOURCECRS[
        GEOGCRS["NAD83",
            DATUM["North American Datum 1983",
                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",4269]]],
    TARGETCRS[
        GEOGCRS["NAD83(CSRS)v3",
            DATUM["North American Datum of 1983 (CSRS) version 3",
                ELLIPSOID["GRS 1980",6378137,298.257222101,
                    LENGTHUNIT["metre",1]],
                ANCHOREPOCH[1997]],
            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",8240]]],
    METHOD["NTv2",
        ID["EPSG",9615]],
    PARAMETERFILE["Latitude and longitude difference file","CRD93_00.GSB"],
    OPERATIONACCURACY[0.1],
    USAGE[
        SCOPE["Geodesy."],
        AREA["Canada - British Columbia - Vancouver Island - Capital Regional District."],
        BBOX[48.25,-124.52,49.06,-123]],
    ID["EPSG",9117],
    REMARK["Derived through NAD83(CSRS)v3."]]

proj4.defs("EPSG:9117","+proj=pipeline +step +proj=axisswap +order=2,1 +step +proj=unitconvert +xy_in=deg +xy_out=rad +step +proj=hgridshift +grids=ca_nrc_CRD93_00.tif +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": "NAD83 to NAD83(CSRS)v3 (7)",
    "source_crs": {
        "type": "GeographicCRS",
        "name": "NAD83",
        "datum": {
            "type": "GeodeticReferenceFrame",
            "name": "North American Datum 1983",
            "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": 4269
        },
        "remarks": "Longitude is POSITIVE EAST. The adjustment included connections to Greenland and Mexico but the system was not adopted there. For applications with an accuracy of better than 1m replaced by NAD83(HARN) in the US and PRVI and by NAD83(CSRS) in Canada."
    },
    "target_crs": {
        "type": "GeographicCRS",
        "name": "NAD83(CSRS)v3",
        "datum": {
            "type": "GeodeticReferenceFrame",
            "name": "North American Datum of 1983 (CSRS) version 3",
            "anchor_epoch": 1997,
            "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": 8240
        },
        "remarks": "Adopted by the Canadian federal government from 1999-01-01 and by the provincial governments of Alberta, British Columbia, Manitoba, Newfoundland and Labrador, Nova Scotia, Ontario and Saskatchewan. Replaces NAD83(CSRS)v2. Replaced by NAD83(CSRS)v4."
    },
    "method": {
        "name": "NTv2",
        "id": {
            "authority": "EPSG",
            "code": 9615
        }
    },
    "parameters": [
        {
            "name": "Latitude and longitude difference file",
            "value": "CRD93_00.GSB",
            "id": {
                "authority": "EPSG",
                "code": 8656
            }
        }
    ],
    "accuracy": "0.1",
    "scope": "Geodesy.",
    "area": "Canada - British Columbia - Vancouver Island - Capital Regional District.",
    "bbox": {
        "south_latitude": 48.25,
        "west_longitude": -124.52,
        "north_latitude": 49.06,
        "east_longitude": -123
    },
    "id": {
        "authority": "EPSG",
        "code": 9117
    },
    "remarks": "Derived through NAD83(CSRS)v3."
}

<?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=hgridshift +grids=ca_nrc_CRD93_00.tif +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=hgridshift +grids=ca_nrc_CRD93_00.tif +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 ( 9117, 'EPSG', 9117, '+proj=pipeline +step +proj=axisswap +order=2,1 +step +proj=unitconvert +xy_in=deg +xy_out=rad +step +proj=hgridshift +grids=ca_nrc_CRD93_00.tif +step +proj=unitconvert +xy_in=rad +xy_out=deg +step +proj=axisswap +order=2,1', 'None');