navdata type not correct?

[Benny]

When I add a route I get wrong image when looking at it on a map.

I get 'fix' img for a VOR and 'vor' img for a FIX.

In file app.config.php following is stated:

define('NAV_NDB', 2);
define('NAV_VOR', 3);
define('NAV_DME', 4);
define('NAV_FIX', 5);
define('NAV_TRACK', 6);

But in the navdata table in MySQL a lot of fixes has type 3 defined and some VORs has mixed type 3 and 5 depending on airway.

Is the definition in app.config.php correct or is the fault in the MySQL table navdata?

Is this navdata.sql keept up to date?

/BR

Benny

[simpilot]

The navdata.sql table is still a work in progress, some of the data is outdated and/or incorrect. Some type of live database is being sought at this point, but there is not much available on the open source level.

[Guest lorathon]

I wrote a script to update a lot of the lat/lng for the navdata. There are a few that are still screwy but most of them are a lot closer than what the original was. I have attached an export from my navdata table.

I did not touch the "type" field. Only the "lat" and "lng"

Enjoy.

EDITED - Will not let me attach. I will upload on my site.

[Guest lorathon]

http://fs-products.net/PhoenixVA/index.php/downloads

Under phpVMS Modules

[mark1million]

Not surprised Jeff that file is massive if i remember right

[Nabeel]

Hey Jeff, maybe it would be a good idea to post that on github

[Nabeel]

You know what else sucks, I can't remember how I build the original set. I have the scripts, but I haven't had the time to look through and see how I compiled them.

I might release those on a repository so people can build their own

[Nabeel]

Looks like my main dataset was from fsbuild, then overlayed with the FAA 152 day cycle I believe then the xplane navdata overlaid on top of that.

I'll see if I get some time to clean this up.

Basically it writes to a temporary table, and then dumps it out. Would anyone be interested?

[Nabeel]

Here you go, guys:

https://github.com/n.../phpvms_navdata

Basic instructions in the README.I didn't include any data, since it balloons to a few hundred megs, at least

[Guest lorathon]

I don't think I have the scripts anymore.

I took a DB from one of the payware I had that I could get into and then just cross-referenced the two of them. I started doing it by hand first and then I decided that it was going to take about 3 years

Anyway, the dump has updated lat/lng and the zipped file is about 2.5M.