[postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not form projection

karsten karsten at terragis.net
Fri Oct 15 11:11:59 PDT 2021

Hi All,
on new server with Ubuntu 20.04 , PostgreSQL 13, PostGIS 3.1 I am trying to
import a plain sql dump . This mostly worked but when the script is
executing the creation of a geohash (involving a transformation from srid
2263 to geographic 4326) like this
CREATE INDEX parcels_geohash ON parcels USING btree
(st_geohash(st_transform(geom, 4326)));
I am getting this error:  
could not form projection (PJ) from 'srid=2263' to 'srid=4326'

How can I fix this ?
Here are more details about the environment: 
postgres: PostgreSQL 13.4 (Ubuntu 13.4-4.pgdg20.04+1) on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0,
postgis_version: 3.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
postgis_proj_version: 6.3.1
Karsten Vennemann
 <http://www.terragis.net> www.terragis.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20211015/d4658f53/attachment.html>

More information about the postgis-users mailing list