Skip to content
View in the app

A better way to browse. Learn more.

The AVSIM Community

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

MSFS sqlite database/geometry data

Featured Replies

Maybe this question is more of a GIS/data question than an LNM question, but I'm hoping maybe someone familiar with the mapping component of LNM can point me in the right direction.

I'd like to extract the boundary (airspace) data from the MSFS sqlite database that feeds LNM. Other tables have coordinates, but the boundary data geometries are stored as BLOBs. I've tried using various GIS tools as well as Spatialite to convert the data to something that I can use in a GIS, but nothing has worked. I'm curious how LNM processes the BLOB geometry data in order to map it, but the LNM source code is too complex for my code-reading abilities.

Any ideas on how to accomplish would be appreciated.

22 hours ago, shoegazer100 said:

I'd like to extract the boundary (airspace) data from the MSFS sqlite database that feeds LNM. Other tables have coordinates, but the boundary data geometries are stored as BLOBs. I've tried using various GIS tools as well as Spatialite to convert the data to something that I can use in a GIS, but nothing has worked. I'm curious how LNM processes the BLOB geometry data in order to map it, but the LNM source code is too complex for my code-reading abilities.

I use a custom binary format for better performance. The format is very simple. Reading and writing is done by this class:

https://github.com/albar965/atools/blob/master/src/fs/common/binarygeometry.h

https://github.com/albar965/atools/blob/master/src/fs/common/binarygeometry.cpp

Alex

  • Author

DELETE

Edited by shoegazer100

  • Author
On 11/13/2022 at 11:38 AM, albar965 said:

I use a custom binary format for better performance. The format is very simple. Reading and writing is done by this class:

https://github.com/albar965/atools/blob/master/src/fs/common/binarygeometry.h

https://github.com/albar965/atools/blob/master/src/fs/common/binarygeometry.cpp

Alex

Thanks! I will play around with this and see what I can do.

Archived

This topic is now archived and is closed to further replies.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.