Bobb, It sounds like you want to add measures from the endpoints: https://postgis.net/docs/ST_AddMeasure.html <https://postgis.net/docs/ST_AddMeasure.html>
Then grab the interpolated elevations with something like this: SELECT ST_Z(ST_PointN(geom, generate_series(1, ST_NPoints(geom) - 1))) AS elevation Simon > On Jan 5, 2022, at 9:03 AM, Basques, Bob (CI-StPaul) > <[email protected]> wrote: > > All, > > Ok, this is sort of a weird one (to me). > > I have a feature dataset of MutliLineStrings, all with no Z value, but with a > Elevation attribute on each end. I need to prorate the elevation for each > vertex along the line based on the distance for either/or each of the ends. > > I was planning on attaching this from the client side originally, but though > I would ask here if anyone has tried a SQL approach to extracting/creating. > > Maybe recreate the feature with the attiributes on the fly? Then extract the > vertex info. The intent is to import into a CAD application and build a 3D > CAD model. > > Anyway, any thoughts? > > Bobb > > > > Get me in Teams > <https://teams.microsoft.com/l/chat/0/[email protected]> > PW19-S295-C024 > > > _______________________________________________ > postgis-users mailing list > [email protected] <mailto:[email protected]> > https://lists.osgeo.org/mailman/listinfo/postgis-users > <https://lists.osgeo.org/mailman/listinfo/postgis-users>
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
