I am trying to insert spatial data from GeoJSON to PostgreSQL database and before it I am to reproject geom from EPSG:4326 to EPSG:102027. When working on Windows there were no problems with CRS, but now I get in Python

ERROR 6: EPSG PCS/GCS code 102027 not found in EPSG support files. Is this a valid EPSG coordinate system? ERROR 6: No translation for an empty SRS to PROJ.4 format is known.

Probably the error connected with:

  • That I moved to Ubuntu and maybe I missed some packages?

  • The venv (on Windows I didn't use it)

I have installed pygdal package, GDAL 2.2.2

in database I have POSTGIS=2.1.8

EPSG:102027 is an 'Asia_North_Lambert_Conformal_Conic' projection with description (I have it in QGIS!) +proj=lcc +lat_1=15 +lat_2=65 +lat_0=30 +lon_0=95 +x_0=0 +y_0=0 +datum=WGS84 +units=m +no_defs

I found the same problem but no solution, this issue offers to update EPSG database - I already have GDAL 2.2.2...

Strangely, I really haven't srid = 102027 in spatial_ref_sys table!

I am puzzled, maybe any ideas?

  • 102027 is not an EPSG code epsg-registry.org but something from ESRI and therefore not available in PostGIS by default. You should be able to add the definitions into your PostGIS with the command that you''ll find from spatialreference.org/ref/esri/102027/postgis.
    – user30184
    Commented Aug 29, 2018 at 15:04
  • @user30184, it doesn't help(
    – Jane
    Commented Aug 30, 2018 at 6:28
  • How about using -s_srs epsg:4326 -t_srs "+proj=lcc +lat_1=15 +lat_2=65 +lat_0=30 +lon_0=95 +x_0=0 +y_0=0 +datum=WGS84 +units=m +no_defs"?
    – user30184
    Commented Aug 30, 2018 at 14:58
  • huh, yep, this is now my working version)) but I still wondering if I could call it as ImportFromEPSG(102027). This worked before!
    – Jane
    Commented Aug 30, 2018 at 15:08


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.