phpVMS Forums: SQL Navdata - phpVMS Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

SQL Navdata Rate Topic: -----

#1 User is offline   CPC900 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 307
  • Joined: 27-June 09
  • LocationLondon, ON

Posted 31 July 2010 - 02:50 PM

So, has anyone had the same issues with the navdat.sql file?! It does NOT show accurately where certain VOR's are, nor correct listings of fixes etc.
For instance, MANY vor's don't list a correct latitude. It just will put a '0' in there. This is very prevalent in many U.S. vor's. So when someone flies a route, on the map, it shows the vor along the equator. Also, many FIX'es get listed as vors and vice versa, on the map.
So what I am getting at, is.....did I do something wrong with the install, or is the navdata file just really bad?!
Posted Image
0

#2 User is offline   CPC900 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 307
  • Joined: 27-June 09
  • LocationLondon, ON

Posted 31 July 2010 - 03:09 PM

Also, is there a way to refresh the data AFTER I change an item in the database, so the map shows correctly?! In other words, refreshing a pilot report map to reflect the newly chnaged/corrected data.
I hope I am not confusing anyone here.
Posted Image
0

#3 User is offline   CPC900 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 307
  • Joined: 27-June 09
  • LocationLondon, ON

Posted 31 July 2010 - 03:13 PM

Sorry, the "Reset cached PIREP routes" took care of that. :)
Posted Image
0

#4 User is offline   Nabeel 

  • Advanced Member
  • Group: Administrators
  • Posts: 6227
  • Joined: 17-February 08
  • LocationWestchester, NY

Posted 01 August 2010 - 05:47 PM

The data is incomplete, I don't have a complete set of all the points, etc, so I have to cobble them together from various sources
Twitter | Docs | API Docs | Bug Tracker | Getting Debug Info
phpVMS Hosting - Cheap, fast, and reliable! Check it out here
0

#5 User is offline   CPC900 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 307
  • Joined: 27-June 09
  • LocationLondon, ON

Posted 02 August 2010 - 02:48 AM

Oh, ok. So when I fix some data to make it show correctly, I should NOT do the navdata.sql in an update then, because it will overwrite anything I have fixed?!
Posted Image
0

#6 User is offline   Nabeel 

  • Advanced Member
  • Group: Administrators
  • Posts: 6227
  • Joined: 17-February 08
  • LocationWestchester, NY

Posted 03 August 2010 - 03:34 PM

Yeah, you can do it directly in the DB. Don't reimport the navdata.sql. I haven't had the time to regen a new one anyway
Twitter | Docs | API Docs | Bug Tracker | Getting Debug Info
phpVMS Hosting - Cheap, fast, and reliable! Check it out here
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic