Help creating "corridors"

[Luca Bertoncello]

Am 06.02.2025 um 19:37 schrieb Regina Obe:

Hi again,

> I was thinking sources like https://openflights.org  or
> https://opensky-network.org/  might have it but not seeing corridor data
> there

So, I checked all things and I decided, that looking for coordinates in
the database is too much time-intensive.

I wrote a little Javascript-page using Leaflet and in about ein hour I
drawed all GAFOR-routes in Austria.
Since just seeking for the coordinates _ONE_ point requires about 5
minutes, this is better...

Now: I have this coordinates list and I can save them in the database.
Let's say, I create a table as following:

CREATE TABLE gafor_points
(
  gafor int,
  position int,
  coords geography(POINT)
);

the name of the point is for me not interesting, I just need to get a
list of coordinates for the given GAFOR-route.

Now my problem is to create these "corridors", so let's say 20 km left
and 20 km right of the lines.
In other words, I need to convert my lines in polygons, then export them
as GeoJSON.

And now the very question: how can I create these polygons?

Thanks a lot
Luca Bertoncello
(lucabert at lucabert.de)