<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.10570.1001"></HEAD>
<BODY>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=172210418-15102021>Hi All,</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=172210418-15102021></SPAN></FONT></FONT></FONT> </DIV>
<DIV><SPAN class=172210418-15102021></SPAN><FONT face=Arial><FONT
color=#000080><FONT size=2><SPAN class=172210418-15102021>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</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=172210418-15102021></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=172210418-15102021>CREATE INDEX parcels_geohash ON parcels USING btree
(st_geohash(st_transform(geom, 4326)));</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=172210418-15102021></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#000080><FONT size=2><SPAN
class=172210418-15102021>I am getting this error: <SPAN
class=172210418-15102021></SPAN> <BR>could not form projection (PJ) from
'srid=2263' to 'srid=4326'</SPAN></FONT></FONT></FONT></DIV><SPAN
class=172210418-15102021>
<DIV><BR><FONT color=#000080 size=2 face=Arial>Ho<SPAN
class=172210418-15102021>w</SPAN> can I fix this ?</FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial></FONT> </DIV>
<DIV></SPAN><SPAN class=172210418-15102021><FONT color=#000080 size=2
face=Arial>Here are more details about the environment: <BR></FONT></SPAN><SPAN
class=172210418-15102021><B><FONT color=#000080 size=2 face=Arial><SPAN
class=172210418-15102021>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<BR></SPAN></FONT><FONT face=Arial><FONT color=#000080><FONT
size=2>postgis_version<SPAN class=172210418-15102021>: 3.1 USE_GEOS=1 USE_PROJ=1
USE_STATS=1<BR></SPAN></FONT></FONT></FONT></B></SPAN><SPAN
class=172210418-15102021><B><FONT face=Arial><FONT color=#000080><FONT
size=2>postgis_proj_version<SPAN class=172210418-15102021>:
</SPAN></FONT></FONT></FONT></B><FONT color=#000080 size=2
face=Arial>6.3.1</FONT></SPAN></DIV>
<DIV><FONT color=#000080 size=2 face=Arial></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=172210418-15102021>Cheers</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=172210418-15102021>Karsten</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial></FONT> </DIV>
<DIV align=left>
<DIV><SPAN style="FONT-SIZE: 11pt; FONT-FAMILY: 'Verdana','sans-serif'">Karsten
Vennemann<BR></SPAN><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Verdana','sans-serif'"><SPAN
style="COLOR: #003264"><A
title="http://www.terragis.net/
blocked::http://www.terragis.net/"
href="http://www.terragis.net"><FONT title=http://www.terragis.net/
color=#0000ff>www.terragis.net</FONT></A></SPAN></SPAN><?xml:namespace prefix =
"o" ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></DIV>
<DIV align=left><FONT color=#003264
face=Verdana></FONT> </DIV></DIV></BODY></HTML>