Wow, that’s the first time I’ve heard of that function, looks like it is exactly what I’m looking for. I’ll try that out.
Thanks Simon, I’ll post results. . . . Bobb From: postgis-users <[email protected]> on behalf of Simon Norris <[email protected]> Reply-To: PostGIS Discussion <[email protected]> Date: Wednesday, January 5, 2022 at 11:17 AM To: PostGIS Discussion <[email protected]> Subject: Re: [postgis-users] Prorate values along a line feature based on length. Think Before You Click: This email originated outside our organization. Bobb, It sounds like you want to add measures from the endpoints: 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]<mailto:[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
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
