[postgis-users] ST_Transform Z heights between ODN and WSG

[James Howe]

I have elevation data in SRID 7405 (Ordinance Survey Great Britain 1936 with Ordinance Datum Newlyn) and I want to convert it to SRID 4979 (World Geodetic System 1984 ensemble).

Both SRs have three axes defined in their spatial_ref_sys entries.

However, ST_Transform doesn't change the Z coordinate.

SELECT ST_Transform('SRID=7405;POINT(545068 258591 8.51)'::geometry, 4979);
-> POINT(0.121585415593599 52.206415868084655 8.51)

Am I missing something?
Also asked on SE: https://gis.stackexchange.com/q/447648/183667

Tried with postgres12-postgis3.0 and postgres14-postgis3.2.

Thanks,
James

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230131/b631915e/attachment.htm>