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

[Marcin Mionskowski]

Hi,
I think ST_Translate is what you looking for

https://postgis.net/docs/ST_Translate.html

Greetings

pt., 11 lut 2022, 08:45 użytkownik Abhishek Pandey <
pandey.abhi3112 at gmail.com> napisał:

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220211/c5493288/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/c5493288/attachment.png>