[postgis-users] ERROR: transform: Point outside of projection domain (2050)

[Regina Obe]

Could be your ST_Transform index triggering the issue and you have at least one geometry out of bounds in there.

I’d try dropping your geobordervtc_geom_25832_idx  and then rerunning analyze on the table.
If that does fix it then try to gigure out which geometry is at fault.

The 25632 is only good for utm zone 32N

https://epsg.io/25832

So I suspect you have a geometry way off from there causing the issue.  

Or it could be missing grid datum shift files at fault too.

You can update your grid files by running at your command line:

projsync --all

As detailed here - https://proj.org/apps/projsync.html#index-0

--------------------------------------

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of pham lan
Sent: Monday, March 27, 2023 4:02 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] ERROR: transform: Point outside of projection domain (2050)

Hi Regina,
Here are more information:

geodm=# SELECT postgis_full_version();
                                                                                               postgis_full_version

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------
 POSTGIS="2.5.5" [EXTENSION] PGSQL="100" GEOS="3.9.2-CAPI-1.14.3" PROJ="Rel. 7.2.1, January 1st, 2021" GDAL="GDAL 3.2.3, released 2021/04/27" LIBXML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0"
TOPOLOGY RASTER
(1 row)



On Mon, Mar 27, 2023 at 9:43 PM Regina Obe <lr at pcorp.us> wrote:
What’s the structure of the table in question?
 
\d+ name_of_table
 
Should give needed details.
 
Also output of 
 
SELECT postgis_full_version();
 
From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of pham lan
Sent: Monday, March 27, 2023 3:27 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: [postgis-users] ERROR: transform: Point outside of projection domain (2050)
 
Hi everyone,
 
I need your help to figure this out. I have a DB in postgresql 10  with postgis 2.5. I know postgresql 10 is not supported anymore and we have plan to upgrade it soon but it is a different story.
The thing is, I want to make a copy of this DB, so I tried a pg_basebackup to another postgres10+postgis 2.5 VM. After that, a vacuum went well but the analyzer throws an error on 1 specific table:
ERROR:  transform: Point outside of projection domain (2050)
i tried also pg_dump/pg_restore but get the same error. Does anyone know what is the problem?
 
Thanks for your help!
Regards,
Lan
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users