<div dir="auto">Hi Tim,<div dir="auto"><br></div><div dir="auto">Are you looking for st_force3d?</div><div dir="auto"><a href="https://postgis.net/docs/ST_Force_3D.html">https://postgis.net/docs/ST_Force_3D.html</a><br></div><div dir="auto"><br></div><div dir="auto">Denis</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, 20 Apr 2019, 07:13 Tim Sutton, <<a href="mailto:tim@kartoza.com">tim@kartoza.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word;line-break:after-white-space">Dear PostGIS Geniuses :-)<div><br></div><div>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:</div><div><br></div><div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo;color:rgb(15,0,170)">UPDATE<span style="color:#000000"> poi </span>SET</div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo">  geom2 = st_geomfromewkt( </div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo;color:rgb(176,122,28)"><span style="color:#000000">    </span>'SRID=20790;POINT('<span style="color:#000000"> || </span></div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo">    st_x(st_transform(geom, 20790)) || </div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo">    <span style="color:#b07a1c">' '</span> || </div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo">    st_y(st_transform(geom, 20790)) || </div><div style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo">    <span style="color:#b07a1c">' 0)'</span>);</div><p style="margin:0px;font-stretch:normal;font-size:15px;line-height:normal;font-family:Menlo;min-height:18px">    </p><div>Then dropping the geom column and renaming geom2 to geom.</div></div><div><br></div><div>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?</div><div><br></div><div>Any pointers will be greatly appreciated!</div><div><br></div><div>Regards</div><div><br></div><div>Tim</div><div><div><br></div><div>
<div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;line-height:normal;text-align:center"><span>—</span></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;line-height:normal;text-align:center"><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><br class="m_3518679375205505116Apple-interchange-newline" style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none"><span style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none"><span><span><span><span><span><span><span><span><span><span><span><img id="m_351867937520550511669DD5AE6-6A82-4002-AF02-F33DC6EF1FD4" src="cid:1A5DF6DE-E302-4C28-BFBD-29663CBF1351"></span><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br class="m_3518679375205505116Apple-interchange-newline"><br class="m_3518679375205505116Apple-interchange-newline"><br class="m_3518679375205505116Apple-interchange-newline"><br class="m_3518679375205505116Apple-interchange-newline"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><b>Tim Sutton</b></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><b>Co-founder:</b><span class="m_3518679375205505116Apple-converted-space"> </span>Kartoza</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><b>Ex Project chair:</b><span style="font-weight:normal"><span class="m_3518679375205505116Apple-converted-space"> </span><a href="http://QGIS.org" target="_blank" rel="noreferrer">QGIS.org</a></span></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal">Visit <a href="http://kartoza.com/" target="_blank" rel="noreferrer"><span>http://kartoza.com</span></a> to find out about open source:</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal">Desktop GIS programming services</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal">Geospatial web development</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal">GIS Training</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal">Consulting Services</div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal;min-height:14px"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><b>Skype</b>: timlinux </div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><b>IRC:</b><span class="m_3518679375205505116Apple-converted-space"> </span>timlinux on #qgis at <a href="http://freenode.net" target="_blank" rel="noreferrer">freenode.net</a></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><br></div><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:center;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-alternates:normal;font-variant-east-asian:normal;margin:0px;line-height:normal"><span style="color:rgb(102,106,115);font-family:"Proxima Nova",sans-serif;font-size:14px;text-align:left;background-color:rgb(255,255,255)">I'd love to connect. </span><a class="m_3518679375205505116t-quick-start-share-link" href="https://calendly.com/timlinux" style="color:rgb(0,162,255);text-decoration:none;font-family:"Proxima Nova",sans-serif;font-size:14px;text-align:left" target="_blank" rel="noreferrer">Here's my calendar link</a><span style="color:rgb(102,106,115);font-family:"Proxima Nova",sans-serif;font-size:14px;text-align:left;background-color:rgb(255,255,255)"> to make finding time easy.</span></div>
</span></span></span></span></span></span></span></span></span></span></span></div>
</div><br></div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div>