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

[karsten]

I found this related to the issue but no additional information apart from
that
 
https://gis.stackexchange.com/questions/396058/postgis-st-transform-fails-fo
r-many-srid-on-ubuntu-20-04-2-lts
 
 

  _____  

From: karsten [mailto:karsten at terragis.net] 
Sent: Friday, October 15, 2021 11:12
To: 'PostGIS Users Discussion'
Subject: PostgreSQL 13, PostGIS 3.1 import - could not form projection


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,
64-bit
postgis_version: 3.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
postgis_proj_version: 6.3.1
 
Cheers
Karsten
 
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/175c7d53/attachment.html>