Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
cogwheel opened this issue Apr 16, 2023 · 4 comments
Closed

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

cogwheel opened this issue Apr 16, 2023 · 4 comments
Assignees
Labels

Comments

@cogwheel
Copy link

  • OS: Windows 11 64 bit
  • Flight simulator: MSFS 1.31.22
  • AIRAC cycle and navdata source: Navigraph Cycle 2303 rev.1

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
Copy link
Owner

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
Copy link
Author

cogwheel commented Apr 17, 2023

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
Copy link
Owner

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

@albar965 albar965 self-assigned this Apr 17, 2023
@albar965 albar965 added the bug label Apr 17, 2023
@albar965 albar965 added this to the Release 2.8.11 milestone Apr 17, 2023
albar965 added a commit to albar965/atools that referenced this issue Apr 20, 2023
Now reading airport add-ons from update. Navdata and procedures are ignored.
Wrongly excluded package is now read.
Speed up for reading scenery library by ignoring unused procedures from navdata update.
albar965/littlenavmap#1019
@albar965
Copy link
Owner

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants