Benny Posted January 7, 2011 Report Share Posted January 7, 2011 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 Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted January 8, 2011 Administrators Report Share Posted January 8, 2011 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. Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted January 8, 2011 Report Share Posted January 8, 2011 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. Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted January 8, 2011 Report Share Posted January 8, 2011 http://fs-products.net/PhoenixVA/index.php/downloads Under phpVMS Modules Quote Link to comment Share on other sites More sharing options...
Moderators mark1million Posted January 9, 2011 Moderators Report Share Posted January 9, 2011 Not surprised Jeff that file is massive if i remember right Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted January 10, 2011 Administrators Report Share Posted January 10, 2011 Hey Jeff, maybe it would be a good idea to post that on github Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted January 10, 2011 Administrators Report Share Posted January 10, 2011 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 Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted January 10, 2011 Administrators Report Share Posted January 10, 2011 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? Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted January 10, 2011 Administrators Report Share Posted January 10, 2011 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 Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted January 10, 2011 Report Share Posted January 10, 2011 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.