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 <lucab...@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 >(lucab...@lucabert.de)
