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

[karsten]

yes they are in there the queries give me back

PROJCS["NAD83 / New York Long Island
(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"]],UN
IT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4
269"]],PROJECTION["Lambert_Conformal_Conic_2SP"],PARAMETER["standard_paralle
l_1",41.03333333333333],PARAMETER["standard_parallel_2",40.66666666666666],P
ARAMETER["latitude_of_origin",40.16666666666666],PARAMETER["central_meridian
",-74],PARAMETER["false_easting",984250.0000000002],PARAMETER["false_northin
g",0],UNIT["US survey
foot",0.3048006096012192,AUTHORITY["EPSG","9003"]],AXIS["X",EAST],AXIS["Y",N
ORTH],AUTHORITY["EPSG","2263"]]

and 

GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS
84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]
],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251
99433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]

as I hoped it would 

-----Original Message-----
From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
Of Paul Ramsey
Sent: Friday, October 15, 2021 11:22
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not
form projection

srid entries have to exist in spatial_ref_sys table, do they?

select srtext from spatial_ref_sys where srid in (2263, 4326);

> On Oct 15, 2021, at 11:11 AM, karsten <karsten at terragis.net> wrote:
> 
> 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
> www.terragis.net
>  
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users