Hi Tim, Are you looking for st_force3d? https://postgis.net/docs/ST_Force_3D.html
Denis On Sat, 20 Apr 2019, 07:13 Tim Sutton, <[email protected]> wrote: > Dear PostGIS Geniuses :-) > > I am in the process of converting many of my tables from using XY to XYZ. > For point tables I did it by adding a new geom2 column and populating it > like this: > > UPDATE poi SET > geom2 = st_geomfromewkt( > 'SRID=20790;POINT(' || > st_x(st_transform(geom, 20790)) || > ' ' || > st_y(st_transform(geom, 20790)) || > ' 0)'); > > > Then dropping the geom column and renaming geom2 to geom. > > I’d like to also have my polygon and line sting layers become Z enabled. > Are there any functions that do this or do I have to come up with a way to > deconstruct the geometries to vertices, use a method like above and then > reconstruct them? > > Any pointers will be greatly appreciated! > > Regards > > Tim > > — > > > > > > > > > *Tim Sutton* > > *Co-founder:* Kartoza > *Ex Project chair:* QGIS.org > > Visit http://kartoza.com to find out about open source: > > Desktop GIS programming services > Geospatial web development > GIS Training > Consulting Services > > *Skype*: timlinux > *IRC:* timlinux on #qgis at freenode.net > > I'd love to connect. Here's my calendar link > <https://calendly.com/timlinux> to make finding time easy. > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
