[postgis-users] [XX000] ERROR: AddToPROJ4SRSCache: could not parse proj4 string

[Andrew Joseph]

I receive the following error when running st_transform(geom,4326) on an
ogr_fdw foreign table:

[XX000] ERROR: AddToPROJ4SRSCache: could not parse proj4 string '+proj=lcc
+lat_1=31.88333333333333 +lat_2=30.11666666666667 +lat_0=29.66666666666667
+lon_0=-100.3333333333333 +x_0=699999.9998983998 +y_0=3000000 +datum=NAD83
+units=us-ft +no_defs ' unknown elliptical parameter name

This does not occur when I import the data into postgis manually using
ogr2ogr and then run st_transform() on the concrete table. 

This issue was not present on the following configuration:

POSTGIS="2.3.2 r15302" GEOS="3.6.1-CAPI-1.10.1 r0" SFCGAL="1.3.0" PROJ="Rel.
4.8.0, 6 March 2012" GDAL="GDAL 2.2.0dev, released 2016/99/99"
LIBXML="2.9.1" LIBJSON="0.11.99" TOPOLOGY RASTER

But appears on the configuration below with the same dataset:

POSTGIS="2.4.1 r16012" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d6"
SFCGAL="1.3.0" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.3.0dev,
released 2017/99/99" LIBXML="2.9.3" LIBJSON="0.11.99" TOPOLOGY RASTER

gdalsrsinfo output
================================================================
gdalsrsinfo -e ESRI::testshp.prj

EPSG:2277

PROJ.4 : +proj=lcc +lat_1=31.88333333333333 +lat_2=30.11666666666667
+lat_0=29.66666666666667 +lon_0=-100.3333333333333 +x_0=699999.9998983998
+y_0=3000000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=us-ft +no_defs

OGC WKT :
PROJCS["NAD83 / Texas Central (ftUS)",
    GEOGCS["NAD83",
        DATUM["North_American_Datum_1983",
            SPHEROID["GRS 1980",6378137,298.257222101,
                AUTHORITY["EPSG","7019"]],
            TOWGS84[0,0,0,0,0,0,0],
            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["standard_parallel_1",31.88333333333333],
    PARAMETER["standard_parallel_2",30.11666666666667],
    PARAMETER["latitude_of_origin",29.66666666666667],
    PARAMETER["central_meridian",-100.3333333333333],
    PARAMETER["false_easting",2296583.333],
    PARAMETER["false_northing",9842500.000000002],
    UNIT["US survey foot",0.3048006096012192,
        AUTHORITY["EPSG","9003"]],
    AXIS["X",EAST],
    AXIS["Y",NORTH],
    AUTHORITY["EPSG","2277"]]




--
Sent from: http://postgis.17.x6.nabble.com/PostGIS-User-f3516033.html