[postgis-users] How to generate offset/parallel points from an existing points table?

[Abhishek Pandey]

Hi,

I have a table with Lat Long and 3 additional values (X, Y, Z). What I want
to do is plot the points and if additional Values are set as True, then
generate a point Parallel to it or a point at an offset distance of 2.5
Meters for X, 5 meters for Y, and 7.5 Meters for Z. Here's a representation
of the same.
[image: image.png]
I tried using this: [postgis-users] Create points along line (osgeo.org)
<https://lists.osgeo.org/pipermail/postgis-users/2012-September/035109.html>
But I am not sure how to do the same for points as I have just started
learning PostGIS and SQL.

thanks,
Abhishek Pandey
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220211/cdc46b2d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 54932 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220211/cdc46b2d/attachment.png>