CUP Export -> NavAID, Frequency contains the word "Frequency"

[lordfolken]

Hi,

It seems that the navaid export, is to verbose on the frequency fields It seems to add the word Frequency infront of the frequency. The Frequency field should only be the number.

"ANAA","AA",PF,1721.378S,14530.547W,8.0M,10,,,332.000,"NAVAID, ID AA, Frequency 332.000, , Magnetic declination 12.878, Aligned to true north FALSE"
"BORA BORA","BB",PF,1626.663S,15145.263W,7.0M,10,,,384.000,"NAVAID, ID BB, Frequency 384.000, , Magnetic declination 12.655, Aligned to true north FALSE"
"FANGATAU","FN",PF,1549.255S,14053.181W,7.0M,10,,,339.000,"NAVAID, ID FN, Frequency 339.000, , Magnetic declination 12.315, Aligned to true north FALSE"
"HAO","HAO",PF,1804.916S,14056.426W,5.0M,10,,,370.000,"NAVAID, ID HAO, Frequency 370.000, , Magnetic declination 12.982, Aligned to true north FALSE"
"HIVA OA","AN",PF,0945.146S,13900.079W,440.0M,10,,,294.000,"NAVAID, ID AN, Frequency 294.000, , Magnetic declination 10.748, Aligned to true north FALSE"
"HIVA OA","HV",PF,0946.459S,13900.886W,430.0M,10,,,383.000,"NAVAID, ID HV, Frequency 383.000, , Magnetic declination 10.753, Aligned to true north FALSE"
"HUAHINE","HH",PF,1641.449S,15101.764W,9.0M,10,,,345.000,"NAVAID, ID HH, Frequency 345.000, , Magnetic declination 12.728, Aligned to true north FALSE"
"HUAHINE","HHN",PF,1641.127S,15100.635W,7.0M,9,,,112.700,"NAVAID, ID HHN, Frequency 112.700/74X, , Magnetic declination 12.726, Aligned to true north FALSE"
"MAKEMO","MK",PF,1635.296S,14339.216W,5.0M,10,,,383.000,"NAVAID, ID MK, Frequency 383.000, , Magnetic declination 12.612, Aligned to true north FALSE"
"MANIHI","MH",PF,1425.978S,14603.730W,2.0M,10,,,284.000,"NAVAID, ID MH, Frequency 284.000, , Magnetic declination 12.046, Aligned to true north FALSE"
"MAUPITI","MA",PF,1625.633S,15214.500W,6.0M,10,,,316.000,"NAVAID, ID MA, Frequency 316.000, , Magnetic declination 12.650, Aligned to true north FALSE"
"MOOREA","MO",PF,1728.613S,14946.516W,7.0M,10,,,377.000,"NAVAID, ID MO, Frequency 377.000, , Magnetic declination 12.963, Aligned to true north FALSE"
"NAPUKA","NP",PF,1410.551S,14115.928W,7.0M,10,,,376.000,"NAVAID, ID NP, Frequency 376.000, , Magnetic declination 11.876, Aligned to true north FALSE"
"NUKA HIVA","NH",PF,0847.672S,14013.121W,75.0M,10,,,353.000,"NAVAID, ID NH, Frequency 353.000, , Magnetic declination 10.586, Aligned to true north FALSE"
"RAIATEA","RU",PF,1643.292S,15127.980W,5.0M,10,,,372.000,"NAVAID, ID RU, Frequency 372.000, , Magnetic declination 12.738, Aligned to true north FALSE"
"RANGIROA","OA",PF,1457.356S,14739.629W,4.0M,10,,,358.000,"NAVAID, ID OA, Frequency 358.000, , Magnetic declination 12.208, Aligned to true north FALSE"
"RANGIROA","RAN",PF,1457.027S,14740.421W,4.0M,9,,,115.050,"NAVAID, ID RAN, Frequency 115.050/97Y, , Magnetic declination 12.206, Aligned to true north FALSE"
"REAO","RE",PF,1827.818S,13626.649W,3.0M,10,,,327.000,"NAVAID, ID RE, Frequency 327.000, , Magnetic declination 12.912, Aligned to true north FALSE"
"RURUTU","RT",PF,2225.959S,15122.130W,8.0M,10,,,282.000,"NAVAID, ID RT, Frequency 282.000, , Magnetic declination 14.628, Aligned to true north FALSE"
"TAHITI","FXI",PF,1730.218S,14928.837W,7.0M,10,,,393.000,"NAVAID, ID FXI, Frequency 393.000, , Magnetic declination 12.969, Aligned to true north FALSE"
"TAHITI","TAF",PF,1732.826S,14936.094W,0.0M,9,,,112.900,"NAVAID, ID TAF, Frequency 112.900/76X, , Magnetic declination 12.983, Aligned to true north FALSE"
"TAHITI FAA'A","FA",PF,1733.178S,14936.830W,0.0M,10,,,305.000,"NAVAID, ID FA, Frequency 305.000, , Magnetic declination 12.985, Aligned to true north FALSE"

[lordfolken]

https://github.com/Turbo87/aerofiles/issues/273

[lordfolken]

According to naviter cup file document: https://downloads.naviter.com/docs/SeeYou_CUP_file_format.pdf

Number field representing the frequency of the airport of length 7. Decimal separator must be a point. It can also be embraced in double quotes: https://en.wikipedia.org/wiki/Airband and is used only in connection with waypoint styles 2, 3, 4, 5

There is also a formatting limit as to the digits: Char0 1 char1 1-3 Char2 0-9 ...

Please remove the NDB/VOR frequencies from the freq field in the cup export. The thought is nice, but unfortunalty violates the standard.

[reskume]

Thanks for the heads up. Fix is online! Complete set of export files available tomorrow.

[lordfolken]

Super speedy as always! Thank you.

[lordfolken]

I checked today, and the frequency is still in the field. Could you check? (I take the files from the googlestorage)

[reskume]

Hm, at least for me the columns are now correct, e.g. https://console.cloud.google.com/storage/browser/_details/29f98e10-a489-4c82-ae5e-489dbcd4912f/de_nav.cup;tab=live_object?project=openaip-187622. The frequency is in column 11 with the "freq" header.

[lordfolken]

Hey, maybe a missunderstanding:

When i download de_nav.cup: name,code,country,lat,lon,elev,style,rwdir,rwlen,rwwidth,freq,desc "ALLGAEU","ALG",DE,4759.833N,01015.733E,617.0M,10,,,,341.000,"NAVAID, ID ALG, Frequency 341.000, Range 25 NM, Magnetic declination 3.476, Aligned to true north FALSE"

Field 11 should be empty for a waypoint type 10. Frequency field is only valid for waypoint types 2,3,4,5 (airfields). Also the frequency has to start with 1 i.e. only Radio Communication frequencies.

[lordfolken]

I really wish the standard wheren't so limited. But at the moment its what we've got. Thank you. :-)

[reskume]

Ah, yes, I misunderstood. Changes are being deployed now.