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

[James Howe]

I can confirm it works in PostGIS 2.5, but not PostGIS 3.0+.
I've been using the official Docker images to test.

Time to file a bug then?

James

> I had postgresql10-postgis2.5 running.
> It didn't have 4979, so I inserted it.
> -- ERROR: GetProj4StringSPI: Cannot find SRID (4979) in spatial_ref_sys
> -- https://epsg.io/4979
> INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 4979, 'EPSG', > 4979, '+proj=longlat +datum=WGS84 +no_defs +type=crs', 'None');
> SELECT ST_Transform('SRID=7405;POINT(545068 258591 8.51)'::geometry, 4979);
> That rendered me:
> st_transform                                                   |
> ---------------------------------------------------------------+
> POINT Z(0.1215563454880247 52.20645574758174 55.02789907436818)|
>
>
> Met vriendelijke groet,
> Wouter Scherphof