<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Oh! Thank you! I'm thinking maybe I'll generate a trigger in the
database to update the zvalue when the ELEVATION field is updated.<br>
</p>
<div class="moz-cite-prefix">On 2021-08-13 2:04 p.m., Jan Heckman
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAKMUAtBMLt4cb5x97ibA_LRbKbJ_fTGF=7xdY7U04wqc3WrD7w@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Quite possibly in the Z-coordinate of your geometry
column. You can check in pgadmin or psql (or another program
like omnidb) what the exact type of the postgis geometry in your
table is.
<div>You should see something like geometry(LineStringZM,28992)
what i.c. means a dutch projection of a linestring with Z and
M coordinates.</div>
<div>You can access these (outside gdal) only through postgis,
like</div>
<div>select st_astext(st_pointn(polyline,1)) from ehrdtracks
limit 1;<br>
st_astext<br>
----------------------------------<br>
POINT ZM (71905.9 417771 1504 0)<br>
</div>
<div><br>
</div>
<div>Esp with points you can formulate an update query replacing
the geometry element with a condition,</div>
<div>using ST_Makepoint(), see <a
href="https://postgis.net/docs/ST_MakePoint.html"
moz-do-not-send="true">https://postgis.net/docs/ST_MakePoint.html</a></div>
<div><br>
</div>
<div>Perhaps Qgis might help, too, but I can't tell for sure.</div>
<div><br>
</div>
<div>Hope this helps,</div>
<div>Jan</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Fri, Aug 13, 2021 at 10:34
PM Saulteau Don <<a href="mailto:sault.don@gmail.com"
moz-do-not-send="true">sault.don@gmail.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">I used ogr2ogr to append contours into a larger
dataset. I opted for the zfield option using the ELEVATION
field.
<div><br>
</div>
<div>I realized one of my contours has a bad value and need
to modify it to match the other contours it is connected
to.</div>
<div><br>
</div>
<div>I can edit the attribute ELEVATION fine, but when I
rerun a mesh tool it uses the zfield like its the old
value instead of the modified one in the ELEVATION field.</div>
<div><br>
</div>
<div>Where are the zvalues hidden in PostGIS to change them?
Do I delete the old line and re-append after I've made the
change? That's one option but I was wondering if I can
just easily edit it inside postgis first.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Donovan</div>
</div>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank"
moz-do-not-send="true">gdal-dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</blockquote>
</div>
</blockquote>
</body>
</html>