Help creating "corridors"

[SPDBA]

Can you show us the structure of a table containing the codes and the latitude longitude columns? There are ways to take an ordered list of points in a table and generate linestrings as I assume this is what you want to do.
https://gis.stackexchange.com/questions/338973/postgresql-create-line-from-points
Simon

⁣39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
(P) 03 62 396 397
(M) 0418 396 391
(W) www.spdba.com.au​

On 6 Feb 2025, 18:20, at 18:20, Luca Bertoncello <lucabert at lucabert.de> wrote:
>I have a problem and no idea how to solve it...
>
>So, for everyone knowing general aviation, I'm trying to define the 
>GAFOR-Routes of Austria and Switzerland.
> From the internet site of Austrocontrol (general aviation portal for 
>Austria) I have a detailled description for these routes, but only "for
>
>human beings"...
>Something like:
>
>10 LOWI - Mieminger Plateau - Fernpass - Reutte - Pfronten - EDMK 4700
>11 LOWI - Inntal - Landeck - Arlberg - Feldkirch - LOIH 7000
>12 LOWI - Autobahn A12 - LOIK 2600
>
>and so on...
>LOWI, EDMK, LOIH, LOIK are airfield (ICAO codes). Of course I have the 
>coordinates of these airfield.
>And I have the coordinates of the cities, too.
>I think, in OpenStreetMaps I can get the coordinates of other points 
>(eg.: Mieminger Plateau).
>
>So, now the problem: I need to create a "corridor" over these regions. 
>Then I have to export the coordinates as GeoJSON to display the 
>corridors with Leaflet.
>
>And, as I sayd, I have no idea how to start solving my problem... ;)
>
>Thank you very much for your help!
>Luca Bertoncello
>(lucabert at lucabert.de)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20250206/6ca2bca4/attachment.htm>