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

2021-10-19 Thread karsten
uesday, October 19, 2021 19:51 To: PostGIS Users Discussion Subject: Re: [postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not form projection On Tue, Oct 19, 2021 at 1:34 PM karsten wrote: Is anyone out there that happens to know how can I make PostgreSQL use the new proj lib version

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

2021-10-19 Thread Richard Greenwood
gt; 6. Rich > -Original Message- > From: karsten [mailto:kars...@terragis.net] > Sent: Friday, October 15, 2021 12:03 > To: 'PostGIS Users Discussion' > Subject: RE: [postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not > form projection > > I installed proj-b

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

2021-10-19 Thread karsten
m: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of karsten Sent: Friday, October 15, 2021 11:47 To: 'PostGIS Users Discussion' Subject: Re: [postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not form projection Yes will try to get this to work and report back here.

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

2021-10-15 Thread karsten
users-boun...@lists.osgeo.org] On Behalf Of karsten Sent: Friday, October 15, 2021 11:47 To: 'PostGIS Users Discussion' Subject: Re: [postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not form projection Yes will try to get this to work and report back here. The stack exchange issue mentioned that

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

2021-10-15 Thread karsten
] On Behalf Of Paul Ramsey Sent: Friday, October 15, 2021 11:36 To: PostGIS Users Discussion Subject: Re: [postgis-users] PostgreSQL 13, PostGIS 3.1 import - could not form projection There's something very particular about your environment and I don't know what it is. Try upgrading your proj version

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

2021-10-15 Thread Paul Ramsey
There's something very particular about your environment and I don't know what it is. Try upgrading your proj version, and jimmying with other version combinations. There's nothing special about the SRID numbers, they work fine for me locally. I can't invest the time in setting up a mirror

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

2021-10-15 Thread karsten
HEROID["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"]]

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

2021-10-15 Thread karsten
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

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

2021-10-15 Thread Paul Ramsey
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 wrote: > > Hi All, > > on new server with Ubuntu 20.04 , PostgreSQL 13, PostGIS 3.1 I am trying to > import a plain sql dump .

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

2021-10-15 Thread karsten
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