EPSG:8789

COMPD_CS["NAD83 / Virginia South (ftUS) + NAVD88 height (ftUS)",
    PROJCS["NAD83 / Virginia South (ftUS)",
        GEOGCS["NAD83",
            DATUM["North_American_Datum_1983",
                SPHEROID["GRS 1980",6378137,298.257222101,
                    AUTHORITY["EPSG","7019"]],
                AUTHORITY["EPSG","6269"]],
            PRIMEM["Greenwich",0,
                AUTHORITY["EPSG","8901"]],
            UNIT["degree",0.0174532925199433,
                AUTHORITY["EPSG","9122"]],
            AUTHORITY["EPSG","4269"]],
        PROJECTION["Lambert_Conformal_Conic_2SP"],
        PARAMETER["latitude_of_origin",36.3333333333333],
        PARAMETER["central_meridian",-78.5],
        PARAMETER["standard_parallel_1",37.9666666666667],
        PARAMETER["standard_parallel_2",36.7666666666667],
        PARAMETER["false_easting",11482916.667],
        PARAMETER["false_northing",3280833.333],
        UNIT["US survey foot",0.304800609601219,
            AUTHORITY["EPSG","9003"]],
        AXIS["Easting",EAST],
        AXIS["Northing",NORTH],
        AUTHORITY["EPSG","2284"]],
    VERT_CS["NAVD88 height (ftUS)",
        VERT_DATUM["North American Vertical Datum 1988",2005,
            AUTHORITY["EPSG","5103"]],
        UNIT["US survey foot",0.304800609601219,
            AUTHORITY["EPSG","9003"]],
        AXIS["Gravity-related height",UP],
        AUTHORITY["EPSG","6360"]],
    AUTHORITY["EPSG","8789"]]

COMPOUNDCRS["NAD83 / Virginia South (ftUS) + NAVD88 height (ftUS)",
    PROJCRS["NAD83 / Virginia South (ftUS)",
        BASEGEOGCRS["NAD83",
            DATUM["North American Datum 1983",
                ELLIPSOID["GRS 1980",6378137,298.257222101,
                    LENGTHUNIT["metre",1]]],
            PRIMEM["Greenwich",0,
                ANGLEUNIT["degree",0.0174532925199433]],
            ID["EPSG",4269]],
        CONVERSION["SPCS83 Virginia South zone (US survey foot)",
            METHOD["Lambert Conic Conformal (2SP)",
                ID["EPSG",9802]],
            PARAMETER["Latitude of false origin",36.3333333333333,
                ANGLEUNIT["degree",0.0174532925199433],
                ID["EPSG",8821]],
            PARAMETER["Longitude of false origin",-78.5,
                ANGLEUNIT["degree",0.0174532925199433],
                ID["EPSG",8822]],
            PARAMETER["Latitude of 1st standard parallel",37.9666666666667,
                ANGLEUNIT["degree",0.0174532925199433],
                ID["EPSG",8823]],
            PARAMETER["Latitude of 2nd standard parallel",36.7666666666667,
                ANGLEUNIT["degree",0.0174532925199433],
                ID["EPSG",8824]],
            PARAMETER["Easting at false origin",11482916.667,
                LENGTHUNIT["US survey foot",0.304800609601219],
                ID["EPSG",8826]],
            PARAMETER["Northing at false origin",3280833.333,
                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]]],
    VERTCRS["NAVD88 height (ftUS)",
        VDATUM["North American Vertical Datum 1988"],
        CS[vertical,1],
            AXIS["gravity-related height (H)",up,
                LENGTHUNIT["US survey foot",0.304800609601219]]],
    USAGE[
        SCOPE["Engineering survey, topographic mapping."],
        AREA["United States (USA) - Virginia - counties of Accomack; Albemarle; Alleghany; Amelia; Amherst; Appomattox; Bedford; Bland; Botetourt; Bristol; Brunswick; Buchanan; Buckingham; Campbell; Carroll; Charles City; Charlotte; Chesapeake; Chesterfield; Colonial Heights; Craig; Cumberland; Dickenson; Dinwiddie; Essex; Floyd; Fluvanna; Franklin; Giles; Gloucester; Goochland; Grayson; Greensville; Halifax; Hampton; Hanover; Henrico; Henry; Isle of Wight; James City; King and Queen; King William; Lancaster; Lee; Louisa; Lunenburg; Lynchburg; Mathews; Mecklenburg; Middlesex; Montgomery; Nelson; New Kent; Newport News; Norfolk; Northampton; Northumberland; Norton; Nottoway; Patrick; Petersburg; Pittsylvania; Portsmouth; Powhatan; Prince Edward; Prince George; Pulaski; Richmond; Roanoke; Rockbridge; Russell; Scott; Smyth; Southampton; Suffolk; Surry; Sussex; Tazewell; Washington; Wise; Wythe; York."],
        BBOX[36.54,-83.68,38.28,-75.31]],
    ID["EPSG",8789]]

PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",
    GEOGCS["GCS_North_American_1983",
        DATUM["D_North_American_1983",
            SPHEROID["GRS_1980",6378137.0,298.257222101]],
        PRIMEM["Greenwich",0.0],
        UNIT["Degree",0.0174532925199433]],
    PROJECTION["Lambert_Conformal_Conic"],
    PARAMETER["False_Easting",11482916.667],
    PARAMETER["False_Northing",3280833.333],
    PARAMETER["Central_Meridian",-78.5],
    PARAMETER["Standard_Parallel_1",37.9666666666667],
    PARAMETER["Standard_Parallel_2",36.7666666666667],
    PARAMETER["Latitude_Of_Origin",36.3333333333333],
    UNIT["US survey foot",0.304800609601219]],
VERTCS["NAVD88_height_(ftUS)",
    VDATUM["North_American_Vertical_Datum_1988"],
    PARAMETER["Vertical_Shift",0.0],
    PARAMETER["Direction",1.0],
    UNIT["US survey foot",0.304800609601219]]

proj4.defs("EPSG:8789","+proj=lcc +lat_0=36.3333333333333 +lon_0=-78.5 +lat_1=37.9666666666667 +lat_2=36.7666666666667 +x_0=3500000.0001016 +y_0=999999.9998984 +datum=NAD83 +units=us-ft +vunits=us-ft +no_defs +type=crs");

{
    "$schema": "https://proj.org/schemas/v0.7/projjson.schema.json",
    "type": "CompoundCRS",
    "name": "NAD83 / Virginia South (ftUS) + NAVD88 height (ftUS)",
    "components": [
        {
            "type": "ProjectedCRS",
            "name": "NAD83 / Virginia South (ftUS)",
            "base_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."
            },
            "conversion": {
                "name": "SPCS83 Virginia South zone (US survey foot)",
                "method": {
                    "name": "Lambert Conic Conformal (2SP)",
                    "id": {
                        "authority": "EPSG",
                        "code": 9802
                    }
                },
                "parameters": [
                    {
                        "name": "Latitude of false origin",
                        "value": 36.3333333333333,
                        "unit": "degree",
                        "id": {
                            "authority": "EPSG",
                            "code": 8821
                        }
                    },
                    {
                        "name": "Longitude of false origin",
                        "value": -78.5,
                        "unit": "degree",
                        "id": {
                            "authority": "EPSG",
                            "code": 8822
                        }
                    },
                    {
                        "name": "Latitude of 1st standard parallel",
                        "value": 37.9666666666667,
                        "unit": "degree",
                        "id": {
                            "authority": "EPSG",
                            "code": 8823
                        }
                    },
                    {
                        "name": "Latitude of 2nd standard parallel",
                        "value": 36.7666666666667,
                        "unit": "degree",
                        "id": {
                            "authority": "EPSG",
                            "code": 8824
                        }
                    },
                    {
                        "name": "Easting at false origin",
                        "value": 11482916.667,
                        "unit": {
                            "type": "LinearUnit",
                            "name": "US survey foot",
                            "conversion_factor": 0.304800609601219
                        },
                        "id": {
                            "authority": "EPSG",
                            "code": 8826
                        }
                    },
                    {
                        "name": "Northing at false origin",
                        "value": 3280833.333,
                        "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
                        }
                    }
                ]
            }
        },
        {
            "type": "VerticalCRS",
            "name": "NAVD88 height (ftUS)",
            "datum": {
                "type": "VerticalReferenceFrame",
                "name": "North American Vertical Datum 1988"
            },
            "coordinate_system": {
                "subtype": "vertical",
                "axis": [
                    {
                        "name": "Gravity-related height",
                        "abbreviation": "H",
                        "direction": "up",
                        "unit": {
                            "type": "LinearUnit",
                            "name": "US survey foot",
                            "conversion_factor": 0.304800609601219
                        }
                    }
                ]
            }
        }
    ],
    "scope": "Engineering survey, topographic mapping.",
    "area": "United States (USA) - Virginia - counties of Accomack; Albemarle; Alleghany; Amelia; Amherst; Appomattox; Bedford; Bland; Botetourt; Bristol; Brunswick; Buchanan; Buckingham; Campbell; Carroll; Charles City; Charlotte; Chesapeake; Chesterfield; Colonial Heights; Craig; Cumberland; Dickenson; Dinwiddie; Essex; Floyd; Fluvanna; Franklin; Giles; Gloucester; Goochland; Grayson; Greensville; Halifax; Hampton; Hanover; Henrico; Henry; Isle of Wight; James City; King and Queen; King William; Lancaster; Lee; Louisa; Lunenburg; Lynchburg; Mathews; Mecklenburg; Middlesex; Montgomery; Nelson; New Kent; Newport News; Norfolk; Northampton; Northumberland; Norton; Nottoway; Patrick; Petersburg; Pittsylvania; Portsmouth; Powhatan; Prince Edward; Prince George; Pulaski; Richmond; Roanoke; Rockbridge; Russell; Scott; Smyth; Southampton; Suffolk; Surry; Sussex; Tazewell; Washington; Wise; Wythe; York.",
    "bbox": {
        "south_latitude": 36.54,
        "west_longitude": -83.68,
        "north_latitude": 38.28,
        "east_longitude": -75.31
    },
    "id": {
        "authority": "EPSG",
        "code": 8789
    }
}

<?xml version="1.0" encoding="utf-8"?>
<Map srs="+proj=lcc +lat_0=36.3333333333333 +lon_0=-78.5 +lat_1=37.9666666666667 +lat_2=36.7666666666667 +x_0=3500000.0001016 +y_0=999999.9998984 +datum=NAD83 +units=us-ft +vunits=us-ft +no_defs +type=crs">
	<Layer srs="+proj=lcc +lat_0=36.3333333333333 +lon_0=-78.5 +lat_1=37.9666666666667 +lat_2=36.7666666666667 +x_0=3500000.0001016 +y_0=999999.9998984 +datum=NAD83 +units=us-ft +vunits=us-ft +no_defs +type=crs">
	</Layer>
</Map>

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 8789, 'EPSG', 8789, '+proj=lcc +lat_0=36.3333333333333 +lon_0=-78.5 +lat_1=37.9666666666667 +lat_2=36.7666666666667 +x_0=3500000.0001016 +y_0=999999.9998984 +datum=NAD83 +units=us-ft +vunits=us-ft +no_defs +type=crs', 'COMPD_CS["NAD83 / Virginia South (ftUS) + NAVD88 height (ftUS)",PROJCS["NAD83 / Virginia South (ftUS)",GEOGCS["NAD83",DATUM["North_American_Datum_1983",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6269"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4269"]],PROJECTION["Lambert_Conformal_Conic_2SP"],PARAMETER["latitude_of_origin",36.3333333333333],PARAMETER["central_meridian",-78.5],PARAMETER["standard_parallel_1",37.9666666666667],PARAMETER["standard_parallel_2",36.7666666666667],PARAMETER["false_easting",11482916.667],PARAMETER["false_northing",3280833.333],UNIT["US survey foot",0.304800609601219,AUTHORITY["EPSG","9003"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","2284"]],VERT_CS["NAVD88 height (ftUS)",VERT_DATUM["North American Vertical Datum 1988",2005,AUTHORITY["EPSG","5103"]],UNIT["US survey foot",0.304800609601219,AUTHORITY["EPSG","9003"]],AXIS["Gravity-related height",UP],AUTHORITY["EPSG","6360"]],AUTHORITY["EPSG","8789"]]');