albar965 / littlenavmap

Little Navmap is a free flight planner, navigation tool, moving map, airport search and airport information system for Flight Simulator X, Microsoft Flight Simulator 2020, Prepar3D and X-Plane.
https://albar965.github.io/littlenavmap.html
GNU General Public License v3.0
1.23k stars 161 forks source link

navdata.sqlite is missing runways that appear in Navigraph and MSFS #1019

Closed cogwheel closed 1 year ago

cogwheel commented 1 year ago

NZFX (antarctica) has runway 33/15. I can make flight plans in simbrief and in the G5000 in-game, the runway appears in the world, and has multiple arrival/approach procedures.

When I run navdatareader, the resulting navdata.sqlite has NZFX airport, but it does not contain any runways. The num_runways is 0, and the runways table doesn't have any entries for NZFX.

This is reflected in Little Navmap. With MSFS scenery and navigraph procedures, there is no runway displayed. If I switch to Navigraph for scenery, then the runway appears.

albar965 commented 1 year ago

NZFX is only contained in the Navigraph database and not in MSFS stock scenery (X-Plane has it). Navdatareader reads only what is in the MSFS scenery library and therefore cannot find the airport.

You use an airport add-on if you can see it in the MSFS scenery. Maybe an error in the add-on if runways are missing. Do you have a link to the used add-ons?

LNM ignores the Navigraph updates in MSFS since there is also the Navigraph navdatabase update for LNM. Another reason is the nightmarish complexity in the scenery library to update navdata.

Alex

cogwheel commented 1 year ago

NZFX is only contained in the Navigraph database and not in MSFS stock scenery (X-Plane has it). Navdatareader reads only what is in the MSFS scenery library and therefore cannot find the airport.

But it does find the airport. It just doesn't assign any runways. The whole reason I ran navdatareader was to get updated airports for NeoFly and it works fine for the most part.

sqlite> select airport_id,ident, is_addon, num_runways, scenery_local_path from airport where ident = "NZFX";
airport_id,ident,is_addon,num_runways,scenery_local_path
119817,NZFX,0,0,"D:\Games\Microsoft Flight Simulator\Packages\Community\navigraph-navdata"

I don't have any scenery addons, just the navigraph data. When I fly to the location, MSFS shows a runway even though it's not in the base scenery:

Screenshot 2023-04-15 202227
albar965 commented 1 year ago

I see. Navigraph adds the airport somehow and LNM "thinks" it is a procedure update. Need to debug into this.

albar965 commented 1 year ago

Fixed. Now reading all airports from update. These are not marked as add-on.