I have a points layer with hundreds of features at variable distance from each other. Now what I want to do is create 4 new points for each feature of this layer at a fixed distance (30m) AND orientation (exactly North, East, South, West).
Something like this (forgive my draw skills):
Where grey points are from input and the color ones are the output.
I was willing to do in QGIS, but can be also PostGIS or another solution.
geometry by expression
tool to create points based on the answer @ThingumaBob linked to. Or if you just want to visualize those points, use them in ageometry generator
style.