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": {
                "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
                }
            },
            "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"]]');