EPSG:26775

PROJCS["NAD27 / Iowa North",
    GEOGCS["NAD27",
        DATUM["North_American_Datum_1927",
            SPHEROID["Clarke 1866",6378206.4,294.978698213898],
            TOWGS84[-22,160,190,0,0,0,0]],
        PRIMEM["Greenwich",0,
            AUTHORITY["EPSG","8901"]],
        UNIT["degree",0.0174532925199433,
            AUTHORITY["EPSG","9122"]],
        AUTHORITY["EPSG","4267"]],
    PROJECTION["Lambert_Conformal_Conic_2SP"],
    PARAMETER["latitude_of_origin",41.5],
    PARAMETER["central_meridian",-93.5],
    PARAMETER["standard_parallel_1",43.2666666666667],
    PARAMETER["standard_parallel_2",42.0666666666667],
    PARAMETER["false_easting",2000000],
    PARAMETER["false_northing",0],
    UNIT["US survey foot",0.304800609601219],
    AXIS["Easting",EAST],
    AXIS["Northing",NORTH],
    AUTHORITY["EPSG","26775"]]

BOUNDCRS[
    SOURCECRS[
        PROJCRS["NAD27 / Iowa North",
            BASEGEOGCRS["NAD27",
                DATUM["North American Datum 1927",
                    ELLIPSOID["Clarke 1866",6378206.4,294.978698213898,
                        LENGTHUNIT["metre",1]]],
                PRIMEM["Greenwich",0,
                    ANGLEUNIT["degree",0.0174532925199433]],
                ID["EPSG",4267]],
            CONVERSION["Iowa CS27 North zone",
                METHOD["Lambert Conic Conformal (2SP)",
                    ID["EPSG",9802]],
                PARAMETER["Latitude of false origin",41.5,
                    ANGLEUNIT["degree",0.0174532925199433],
                    ID["EPSG",8821]],
                PARAMETER["Longitude of false origin",-93.5,
                    ANGLEUNIT["degree",0.0174532925199433],
                    ID["EPSG",8822]],
                PARAMETER["Latitude of 1st standard parallel",43.2666666666667,
                    ANGLEUNIT["degree",0.0174532925199433],
                    ID["EPSG",8823]],
                PARAMETER["Latitude of 2nd standard parallel",42.0666666666667,
                    ANGLEUNIT["degree",0.0174532925199433],
                    ID["EPSG",8824]],
                PARAMETER["Easting at false origin",2000000,
                    LENGTHUNIT["US survey foot",0.304800609601219],
                    ID["EPSG",8826]],
                PARAMETER["Northing at false origin",0,
                    LENGTHUNIT["US survey foot",0.304800609601219],
                    ID["EPSG",8827]]],
            CS[Cartesian,2],
                AXIS["easting (X)",east,
                    ORDER[1],
                    LENGTHUNIT["US survey foot",0.304800609601219]],
                AXIS["northing (Y)",north,
                    ORDER[2],
                    LENGTHUNIT["US survey foot",0.304800609601219]],
            USAGE[
                SCOPE["Engineering survey, topographic mapping."],
                AREA["United States (USA) - Iowa - counties of Allamakee; Benton; Black Hawk; Boone; Bremer; Buchanan; Buena Vista; Butler; Calhoun; Carroll; Cerro Gordo; Cherokee; Chickasaw; Clay; Clayton; Crawford; Delaware; Dickinson; Dubuque; Emmet; Fayette; Floyd; Franklin; Greene; Grundy; Hamilton; Hancock; Hardin; Howard; Humboldt; Ida; Jackson; Jones; Kossuth; Linn; Lyon; Marshall; Mitchell; Monona; O'Brien; Osceola; Palo Alto; Plymouth; Pocahontas; Sac; Sioux; Story; Tama; Webster; Winnebago; Winneshiek; Woodbury; Worth; Wright."],
                BBOX[41.85,-96.65,43.51,-90.15]],
            ID["EPSG",26775]]],
    TARGETCRS[
        GEOGCRS["WGS 84",
            ENSEMBLE["World Geodetic System 1984 ensemble",
                MEMBER["World Geodetic System 1984 (Transit)"],
                MEMBER["World Geodetic System 1984 (G730)"],
                MEMBER["World Geodetic System 1984 (G873)"],
                MEMBER["World Geodetic System 1984 (G1150)"],
                MEMBER["World Geodetic System 1984 (G1674)"],
                MEMBER["World Geodetic System 1984 (G1762)"],
                MEMBER["World Geodetic System 1984 (G2139)"],
                ELLIPSOID["WGS 84",6378137,298.257223563,
                    LENGTHUNIT["metre",1]],
                ENSEMBLEACCURACY[2.0]],
            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]],
            USAGE[
                SCOPE["Horizontal component of 3D system."],
                AREA["World."],
                BBOX[-90,-180,90,180]],
            ID["EPSG",4326]]],
    ABRIDGEDTRANSFORMATION["Transformation from unknown to WGS84",
        METHOD["Position Vector transformation (geog2D domain)",
            ID["EPSG",9606]],
        PARAMETER["X-axis translation",-22,
            ID["EPSG",8605]],
        PARAMETER["Y-axis translation",160,
            ID["EPSG",8606]],
        PARAMETER["Z-axis translation",190,
            ID["EPSG",8607]],
        PARAMETER["X-axis rotation",0,
            ID["EPSG",8608]],
        PARAMETER["Y-axis rotation",0,
            ID["EPSG",8609]],
        PARAMETER["Z-axis rotation",0,
            ID["EPSG",8610]],
        PARAMETER["Scale difference",1,
            ID["EPSG",8611]]]]

PROJCS["NAD_1927_StatePlane_Iowa_North_FIPS_1401",
    GEOGCS["GCS_North_American_1927",
        DATUM["D_North_American_1927",
            SPHEROID["Clarke_1866",6378206.4,294.978698213898]],
        PRIMEM["Greenwich",0.0],
        UNIT["Degree",0.0174532925199433]],
    PROJECTION["Lambert_Conformal_Conic"],
    PARAMETER["False_Easting",2000000.0],
    PARAMETER["False_Northing",0.0],
    PARAMETER["Central_Meridian",-93.5],
    PARAMETER["Standard_Parallel_1",43.2666666666667],
    PARAMETER["Standard_Parallel_2",42.0666666666667],
    PARAMETER["Latitude_Of_Origin",41.5],
    UNIT["US survey foot",0.304800609601219]]

proj4.defs("EPSG:26775","+proj=lcc +lat_0=41.5 +lon_0=-93.5 +lat_1=43.2666666666667 +lat_2=42.0666666666667 +x_0=609601.219202438 +y_0=0 +ellps=clrk66 +towgs84=-22,160,190,0,0,0,0 +units=us-ft +no_defs +type=crs");

{
    "$schema": "https://proj.org/schemas/v0.7/projjson.schema.json",
    "type": "BoundCRS",
    "source_crs": {
        "type": "ProjectedCRS",
        "name": "NAD27 / Iowa North",
        "base_crs": {
            "name": "NAD27",
            "datum": {
                "type": "GeodeticReferenceFrame",
                "name": "North American Datum 1927",
                "ellipsoid": {
                    "name": "Clarke 1866",
                    "semi_major_axis": 6378206.4,
                    "semi_minor_axis": 6356583.8
                }
            },
            "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": 4267
            }
        },
        "conversion": {
            "name": "Iowa CS27 North zone",
            "method": {
                "name": "Lambert Conic Conformal (2SP)",
                "id": {
                    "authority": "EPSG",
                    "code": 9802
                }
            },
            "parameters": [
                {
                    "name": "Latitude of false origin",
                    "value": 41.5,
                    "unit": "degree",
                    "id": {
                        "authority": "EPSG",
                        "code": 8821
                    }
                },
                {
                    "name": "Longitude of false origin",
                    "value": -93.5,
                    "unit": "degree",
                    "id": {
                        "authority": "EPSG",
                        "code": 8822
                    }
                },
                {
                    "name": "Latitude of 1st standard parallel",
                    "value": 43.2666666666667,
                    "unit": "degree",
                    "id": {
                        "authority": "EPSG",
                        "code": 8823
                    }
                },
                {
                    "name": "Latitude of 2nd standard parallel",
                    "value": 42.0666666666667,
                    "unit": "degree",
                    "id": {
                        "authority": "EPSG",
                        "code": 8824
                    }
                },
                {
                    "name": "Easting at false origin",
                    "value": 2000000,
                    "unit": {
                        "type": "LinearUnit",
                        "name": "US survey foot",
                        "conversion_factor": 0.304800609601219
                    },
                    "id": {
                        "authority": "EPSG",
                        "code": 8826
                    }
                },
                {
                    "name": "Northing at false origin",
                    "value": 0,
                    "unit": {
                        "type": "LinearUnit",
                        "name": "US survey foot",
                        "conversion_factor": 0.304800609601219
                    },
                    "id": {
                        "authority": "EPSG",
                        "code": 8827
                    }
                }
            ]
        },
        "coordinate_system": {
            "subtype": "Cartesian",
            "axis": [
                {
                    "name": "Easting",
                    "abbreviation": "X",
                    "direction": "east",
                    "unit": {
                        "type": "LinearUnit",
                        "name": "US survey foot",
                        "conversion_factor": 0.304800609601219
                    }
                },
                {
                    "name": "Northing",
                    "abbreviation": "Y",
                    "direction": "north",
                    "unit": {
                        "type": "LinearUnit",
                        "name": "US survey foot",
                        "conversion_factor": 0.304800609601219
                    }
                }
            ]
        },
        "id": {
            "authority": "EPSG",
            "code": 26775
        }
    },
    "target_crs": {
        "type": "GeographicCRS",
        "name": "WGS 84",
        "datum_ensemble": {
            "name": "World Geodetic System 1984 ensemble",
            "members": [
                {
                    "name": "World Geodetic System 1984 (Transit)",
                    "id": {
                        "authority": "EPSG",
                        "code": 1166
                    }
                },
                {
                    "name": "World Geodetic System 1984 (G730)",
                    "id": {
                        "authority": "EPSG",
                        "code": 1152
                    }
                },
                {
                    "name": "World Geodetic System 1984 (G873)",
                    "id": {
                        "authority": "EPSG",
                        "code": 1153
                    }
                },
                {
                    "name": "World Geodetic System 1984 (G1150)",
                    "id": {
                        "authority": "EPSG",
                        "code": 1154
                    }
                },
                {
                    "name": "World Geodetic System 1984 (G1674)",
                    "id": {
                        "authority": "EPSG",
                        "code": 1155
                    }
                },
                {
                    "name": "World Geodetic System 1984 (G1762)",
                    "id": {
                        "authority": "EPSG",
                        "code": 1156
                    }
                },
                {
                    "name": "World Geodetic System 1984 (G2139)",
                    "id": {
                        "authority": "EPSG",
                        "code": 1309
                    }
                }
            ],
            "ellipsoid": {
                "name": "WGS 84",
                "semi_major_axis": 6378137,
                "inverse_flattening": 298.257223563
            },
            "accuracy": "2.0",
            "id": {
                "authority": "EPSG",
                "code": 6326
            }
        },
        "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": 4326
        }
    },
    "transformation": {
        "name": "Transformation from unknown to WGS84",
        "method": {
            "name": "Position Vector transformation (geog2D domain)",
            "id": {
                "authority": "EPSG",
                "code": 9606
            }
        },
        "parameters": [
            {
                "name": "X-axis translation",
                "value": -22,
                "unit": "metre",
                "id": {
                    "authority": "EPSG",
                    "code": 8605
                }
            },
            {
                "name": "Y-axis translation",
                "value": 160,
                "unit": "metre",
                "id": {
                    "authority": "EPSG",
                    "code": 8606
                }
            },
            {
                "name": "Z-axis translation",
                "value": 190,
                "unit": "metre",
                "id": {
                    "authority": "EPSG",
                    "code": 8607
                }
            },
            {
                "name": "X-axis rotation",
                "value": 0,
                "unit": {
                    "type": "AngularUnit",
                    "name": "arc-second",
                    "conversion_factor": 4.84813681109536e-06
                },
                "id": {
                    "authority": "EPSG",
                    "code": 8608
                }
            },
            {
                "name": "Y-axis rotation",
                "value": 0,
                "unit": {
                    "type": "AngularUnit",
                    "name": "arc-second",
                    "conversion_factor": 4.84813681109536e-06
                },
                "id": {
                    "authority": "EPSG",
                    "code": 8609
                }
            },
            {
                "name": "Z-axis rotation",
                "value": 0,
                "unit": {
                    "type": "AngularUnit",
                    "name": "arc-second",
                    "conversion_factor": 4.84813681109536e-06
                },
                "id": {
                    "authority": "EPSG",
                    "code": 8610
                }
            },
            {
                "name": "Scale difference",
                "value": 0,
                "unit": {
                    "type": "ScaleUnit",
                    "name": "parts per million",
                    "conversion_factor": 1e-06
                },
                "id": {
                    "authority": "EPSG",
                    "code": 8611
                }
            }
        ]
    }
}

<?xml version="1.0" encoding="utf-8"?>
<Map srs="+proj=lcc +lat_0=41.5 +lon_0=-93.5 +lat_1=43.2666666666667 +lat_2=42.0666666666667 +x_0=609601.219202438 +y_0=0 +ellps=clrk66 +towgs84=-22,160,190,0,0,0,0 +units=us-ft +no_defs +type=crs">
	<Layer srs="+proj=lcc +lat_0=41.5 +lon_0=-93.5 +lat_1=43.2666666666667 +lat_2=42.0666666666667 +x_0=609601.219202438 +y_0=0 +ellps=clrk66 +towgs84=-22,160,190,0,0,0,0 +units=us-ft +no_defs +type=crs">
	</Layer>
</Map>

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 26775, 'EPSG', 26775, '+proj=lcc +lat_0=41.5 +lon_0=-93.5 +lat_1=43.2666666666667 +lat_2=42.0666666666667 +x_0=609601.219202438 +y_0=0 +ellps=clrk66 +towgs84=-22,160,190,0,0,0,0 +units=us-ft +no_defs +type=crs', 'PROJCS["NAD27 / Iowa North",GEOGCS["NAD27",DATUM["North_American_Datum_1927",SPHEROID["Clarke 1866",6378206.4,294.978698213898],TOWGS84[-22,160,190,0,0,0,0]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4267"]],PROJECTION["Lambert_Conformal_Conic_2SP"],PARAMETER["latitude_of_origin",41.5],PARAMETER["central_meridian",-93.5],PARAMETER["standard_parallel_1",43.2666666666667],PARAMETER["standard_parallel_2",42.0666666666667],PARAMETER["false_easting",2000000],PARAMETER["false_northing",0],UNIT["US survey foot",0.304800609601219],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","26775"]]');