Help creating "corridors"

[SPDBA]

Not familiar with these tables. 

Someone will answer with an actual solution, but it looks like you need to query the base osm_point to return a set of points in the order of your flight lines. Start with that, then aggregate the resulting points using the reference I sent. 

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, 19:37, at 19:37, Luca Bertoncello <lucabert at lucabert.de> wrote:
>Am 06.02.2025 09:16, schrieb 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.
>
>I'll use planet_osm_point and planet_osm_polygon from OpenStreetMaps.
>See 
>https://wiki.openstreetmap.org/wiki/OpenStreetBrowser/Database_Structure
>
>For the airfield I think, I'll just search for the city in the both 
>tables. It must not be soooo precise...
>
>Thanks
>Luca Bertoncello
>(lucabert at lucabert.de)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20250206/050c2b9a/attachment.htm>