Actual AIRAC

[simpilot]

I have everything working except the order of the waypoints on the airway. I just need to find some type of listing that has all the waypoints for each airway. simroutes has the listings but only one at a time, there has to be some type of data file available somewhere so it does not have to be done manually.

[mseiwald]

hmmm i haven`t found a free data file for it yet. The waypoint order was included in one of navigraphs files but i can`t remember in which one...i would have to look for it but anyway it`s payware and also not useable for this for license reasons i think.

[Aaron]

From my sectorfile developing on VATSIM, I know a way to get all the waypoints on an airway. There is a program called SectEd, it is a sectorfile developing tool that allows developers to drag lines and add waypoints without using code. There is a way to import the Level-D airac and take the waypoints and airways from the sectorfile it creates (simply check a box to plot all of the worldwide data and save it to sct).

Here are some excerpt of a sectorfile:

[VOR]

;---*----1--*------2-------*-3---------4-

ACO 114.400 N041.06.28.449 W081.12.05.438

AIR 117.100 N040.01.01.200 W080.49.02.400

ALB 115.300 N042.44.50.400 W073.48.11.400

APE 116.700 N040.09.03.600 W082.35.30.000

ART 109.800 N043.57.07.800 W076.03.52.800

ASP 116.100 N044.26.57.000 W083.23.39.600

BAE 116.400 N043.07.00.600 W088.17.03.600

...

[NDB]

;-----*--1----*----2---------*---------4---

2Q 373 N046.36.12.000 W075.28.12.000

4L 236 N042.18.44.000 W082.04.39.000

7B 375 N042.46.15.000 W081.06.21.000

7L 405 N048.54.38.250 W079.10.44.209

7P 382 N048.42.30.240 W080.44.09.359

9Q 291 N048.33.30.000 W078.14.36.000

C7 362 N049.46.20.179 W086.58.17.029

...

[AIRPORT]

;CZYZ FIR Airports

CNA3 07-25 N044.24.58.196 W079.44.25.988 G

CNB9 10-28 N044.29.07.120 W079.33.19.480 G

CYLS 10-28 N044.29.7.239 W079.33.23.998 G

CNC3 15-33 N043.45.37.704 W079.52.41.456 G

CNC4 . N043.33.49.994 W080.11.46.000 E ; Guelph

CNE4 14-32 N048.44.30.000 W080.47.36.000 G

CNF4 13-31 N044.21.53.000 W078.47.02.000 G

...

[FIXES]

GEFRC N041.47.54.301 W081.28.55.110

HILEK N041.48.47.289 W081.13.20.578

WONOP N041.48.53.791 W081.13.07.888

FAILS N041.50.16.090 W081.25.13.249

GONNE N041.50.22.621 W082.03.02.109

HIMEZ N041.50.58.909 W082.12.03.999

BEELR N041.51.55.551 W081.15.05.990

HUDUG N041.52.18.339 W081.18.05.961

IROME N041.52.30.842 W080.40.01.340

OBONE N041.52.40.332 W080.44.01.949

COTRO N041.52.44.741 W080.45.54.251

WIGAP N041.52.46.649 W080.46.42.369

GILLS N041.53.07.061 W081.51.00.961

AZTRO N041.53.43.360 W081.56.35.109

RAQEF N041.53.55.262 W080.27.27.100

...

[LOW AIRWAY]

V10 JUSUL JUSUL CRL CRL

V10 CRL CRL MACCS MACCS

V10 MACCS MACCS SSUNN SSUNN

V10 SSUNN SSUNN AZTRO AZTRO

V10 AZTRO AZTRO GILLS GILLS

V10 GILLS GILLS FAILS FAILS

V10 FAILS FAILS WONOP WONOP

V103 AZTRO AZTRO SPHRE SPHRE

V103 SPHRE SPHRE MAARS MAARS

V103 MAARS MAARS VEELA VEELA

V103 VEELA VEELA CAGAP CAGAP

V103 CAGAP CAGAP DXO DXO

V103 DXO DXO PSI PSI

V103 PSI PSI SPRTN SPRTN

V104 GD GD HENSL HENSL

V104 HENSL HENSL ETCHL ETCHL

V104 ETCHL ETCHL YXU YXU

V104 YXU YXU EMBRO EMBRO

V104 EMBRO EMBRO PIGLI PIGLI

V104 PIGLI PIGLI ANCOL ANCOL

V104 ULAMO ULAMO RNDDC RNDDC

V104 RNDDC RNDDC MSS MSS

V104 MSS MSS MALAE MALAE

V104 MALAE MALAE PLB PLB

V115 JHW JHW LANGS LANGS

V115 LANGS LANGS BUF BUF

V116 DEXER DEXER SVM SVM

V116 SVM SVM YQG YQG

V116 YQG YQG OCTAS OCTAS

V116 OCTAS OCTAS ERRTH ERRTH

V116 ERRTH ERRTH CODDS CODDS

V116 CODDS CODDS TRACE TRACE

V116 TRACE TRACE ERI ERI

...

[Aaron]

In airways, each waypoint is listed twice because they can take the place of lat/lon as long so they must be there twice for the sectorfile to work.

V10 JUSUL JUSUL CRL CRL

JUSUL and CRL are waypoints on V10, so when it detects the V10 checkbox enabled in euroscope, it plots a line from JUSUL to CRL as well as the rest of the required segments

[freshJet]

The first one is what I'm wondering how.

The Second Part, Your lucky Day/Night, I'll share mine.

<?php
if($pirep->route != '')
{
?>
<h3>Flight Route</h3>
<?php
$params->deplat = $schedule->deplat;
$params->deplng = $schedule->deplng;
$params->route = $schedule->route;
$routedata = NavData::parseRoute($params);
?>
<table>
<thead>
<tr>
<th>Flight Route Data</th>
</tr>
</thead>
</table>
<div align="center"><a href="#" onclick="$('#routedata').toggle(); return false;">View Route Data</a></div>
<div id="routedata" style="display: none;">
<table>
<thead>
<tr>
<th>Name</th>
<th>Title</th>
<th>Airway</th>
<th>Airway Type</th>
<th>Frequency</th>
<th>Type</th>
<th>Latitude</th>
<th>Longitude</th>
</tr>
</thead>
<tbody>
<?php
$rowclass = 0;
foreach($routedata as $routeline) {
?>
<tr class="row<?php echo $rowclass ?>">
<td align="center"><?php echo $routeline->name;?></td>
<td align="center"><?php echo $routeline->title;?></td>
<td align="center"><?php echo $routeline->airway;?></td>
<td align="center"><?php echo $routeline->airway_type;?></td>
<td align="center"><?php echo $routeline->freq;?></td>
<td align="center"><?php echo $routeline->type;?></td>
<td align="center"><?php echo $routeline->lat;?></td>
<td align="center"><?php echo $routeline->lng;?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<?php
}
?>

Kyle when did you get this working???

[Kyle]

Kyle when did you get this working???

It has been working for a while for me. Were you still having this issue?

[freshJet]

Yes I never worked it out

[hurkulez]

PHPVMS Navadata 1601

http://forum.phpvms.net/topic/4282-phpvms-navdata/

[OmerAslan]

PHPVMS Navadata 1601

http://forum.phpvms....phpvms-navdata/

I download it. Can anyone explain to me, how to setup this first time step by step? Thanks.

Ok i had a problem to add this database. I erased all navdata folder from database and add it new one and it worked. Thanks.

Edited April 6, 2016 by OmerAslan

[eliezerazevedo]

You can run the script: https://github.com/nabeelio/phpvms_navdata

And simple just follow the tutorial:

Running the script

----------------

On the command line, to set the permissions:

chmod +x ./importdata

Then run it:

./importdata

That will write the temporary nav to the phpvms_navdata table, and then

create a dump of the navdata.sql file as well. You should be set then

However, this procedure should be done in linux terminal, used the ubunutu 16.04 ... And the file "db.php" must properly connected to your database.

Forgiveness for my bad English.

[eliezerazevedo]

Segue arquivo de atualização ciclo 1608: https://mega.nz/#!TM...62rJRUS9QwGtqP8

The following update file cycle in 1608: https://mega.nz/#!TM...62rJRUS9QwGtqP8

Sempre que possível estarei atualizando esse post com a ultima versão disponível.

Whenever possible I will be updating this post with the latest version.

http://forum.phpvms.net/topic/23871-update-airac/

Edited August 9, 2016 by eliezerazevedo

[KenSATX]

I took the code Kyle posted (https://github.com/n.../phpvms_navdata) and got it working. Here is a SQL file containing the up-to-date nav data:

http://www.airamvirtual.com/downloads/navdata.sql

[hurkulez]

phpvms_navdata 1609: UPDATED 18 August 2016 | 06:58 Hrs US Central Time | 11:58 Zulu

See Original Post