Welcome, Guest. Please Login or Register
Dynon Avionics, Inc.
 
Welcome to the Dynon Avionics forum!


  HomeHelpSearchLoginRegister  
 
 
Page Index Toggle Pages: 1
Send Topic Print
FREE Australian airport database (Read 1031 times)
Feb 21st, 2018 at 8:14pm

KRviator   Offline
Full Member
Sydney, Aust.

Posts: 128
***
 
Because I am a good-natured bloke (and get bored easily) I decided to work out a way to import all published Australian airports into SkyView - a process that was relatively painless using the DAH, Adobe and Excel.

Now, given there are many hundreds of Certified and Uncertified/ALA's in Australia, I cannot guarantee these are accurate inasmuch as I haven't screwed up something in the PDF-XLS conversion, but those in my immediate vicinity correlate perfectly with the OzRunways VTC overlay. That is my way of saying you use these files and the data therein at your own risk. If you get lost, that's your own fault, these are intended for situational awareness only.

Furthermore, I haven't been anal enough to go through and categorise each and every airport to their respective icon in SkyView. If it's a Certified airport, per the DAH, it gets a "Filled" icon, if it is a Uncertified aerodrome or an ALA, it gets a "Hollow" icon. Additionally, these will show up as User Waypoints in SkyView, so you need to have the "display user waypoints" option selected at a suitable map range to enable you to see them.

To install these to SkyView, copy them to a USB stick, press buttons 7 & 8, go to Full Screen Setup, then "Load Files" and upload both of these to SkyView.

I will endeavour to keep these two files updated with each revision of the DAH unless AsA has a dummy spit, or I get tired of doing so. Anyway these are based on the November 2017 revision, with the next being due in May 2018. Eventually I might do the NavAids as well, but for now, here's the two airport files.

EDIT: Actually, the Aids didn't take as long as I thought they would do, so here they are as well. A VOR has a VOR Icon (funny about that... Grin) while an NDB has a "Tower_Short" icon. Feel free to update them to an icon of your choosing if you don't like them.

I have not included any runway or frequency data yet, mainly due to time constraints. I might include that 'later'. Maybe.

Happy Flying!  Wink
« Last Edit: Feb 21st, 2018 at 11:10pm by KRviator »  

DynonALA.csv (18 KB | 114 )
DynonCERT.csv (19 KB | 78 )
DynonAIDS.csv (8 KB | 68 )
IP Logged
 
Reply #1 - May 23rd, 2018 at 4:24am

KRviator   Offline
Full Member
Sydney, Aust.

Posts: 128
***
 
The new DAH goes live tomorrow, so I spent a good portion of my commute to work today updating these files. Then doing it again because a quirk in Excel corrupted an entire column of longitude in the Certified airport file that I wasn't confident I hadn't replicated across all three...  Angry

So, as ASA hasn't told me off - yet - here are the ALA, Certified and NavAid files with data sourced from the 24th MAy 18 revision of the DAH.

As before, you use these at your own risk. Don't try flying without proper planning, yadda yadda...

If you have the previous files installed on your system, when you load these, you may notice the summary lists X added, X removed, X modified. That's normal. And if you find an error, or they don't load, please let me know and I'll try to fix any mistakes. I haven't tested this revision on my SkyView as I am interstate for work, but wanted to get these out.

EDIT: IT seems the Dynon forum adds the '_001' to the filename following on from the initial ones of months ago.
« Last Edit: May 23rd, 2018 at 4:26am by KRviator »  

DynonAIDS_001.csv (10 KB | 37 )
DynonALA_001.csv (18 KB | 37 )
DynonCERT_001.csv (19 KB | 34 )
IP Logged
 
Reply #2 - May 28th, 2018 at 5:07am

BWOK   Offline
Frequent Poster
I love flying!

Posts: 10
**
 
Thanks a heap mate!
 
IP Logged
 
Reply #3 - May 28th, 2018 at 4:00pm

Terry D   Offline
Frequent Poster

Posts: 10
**
 
Thanks from me too (without implying that I’ve loaded these files previously Smiley)
 
IP Logged
 
Reply #4 - May 29th, 2018 at 2:41am

KRviator   Offline
Full Member
Sydney, Aust.

Posts: 128
***
 
I'm whacking this here because I hope the good folk Dynon won't mind me helping out those poor, ill-informed Australian pilots who bought a G3X system.   Wink

Below is ALA and Certified aerodrome files that will (hopefully) be able to be imported into their inferior G3X's to display the aerodromes in a User Waypoint listing in the same manner we can with our SkyViews.

I do not have a G3X so there is absolutely no way for me to verify these files will work well, if at all, but the XML format is based on a post found over at the Vans forums, so I'm hoping it does. It is renamed into *.TXT files to permit hosting here.

From what I can tell, if you have a G3X, copy these two files, rename them from *.TXT to *.FPL and then load them onto your G3X's SD card, and import the flight plans as you normally would. According to VAF's resident G3xpert, that should then save the waypoints on your system for you to either display or navigate with.

No promises of any kind as to whether or not they actually work though - so good luck! Tongue

And any digs at the competition are meant only as a harmless pi$$take, nothing more sinister than that.
« Last Edit: May 29th, 2018 at 3:01am by KRviator »  

GarminG3X_ALAs.txt (57 KB | 42 )
GarminG3X_CERT.txt (62 KB | 32 )
IP Logged
 
Reply #5 - May 29th, 2018 at 9:07pm

BWOK   Offline
Frequent Poster
I love flying!

Posts: 10
**
 
Anyone else having any issues udating using the latest versionof files?
Ive tried in setup to load files & through waypoint menu to import but it is showing as 0 points updated, added & ignored??
This is the first time ive uploaded any user waypoints.

Also, have updated all the database files i can get my hands on - still getting hi-res terrain annunciator message..  I havent been able to upgrade from hi-res DB 2014-08-26
Anyone know a work around given update isnt available?

Thanks
 
IP Logged
 
Reply #6 - May 29th, 2018 at 9:35pm

KRviator   Offline
Full Member
Sydney, Aust.

Posts: 128
***
 
Ahhh, f#*k, I know exactly what is happening...And it is what caught me out too.

Apologies everyone, to fix it, until I update the files myself, you need to open the *.CSV file in Notepad and copy the following text and add it immediately after the "narrative text" header. It doesn't have to be bold text, that's just for highlighting it in this post.

,Dynon User Waypoints File V1.0

Make sure you get the comma at the start. I will update the files above when I get home from work.

Sorry everyone! I got caught the very first time I tried to install the November files until I realised what the problem was. Guess I am a slow learner... Lips Sealed
« Last Edit: May 30th, 2018 at 2:07am by KRviator »  
IP Logged
 
Reply #7 - May 29th, 2018 at 11:18pm

KRviator   Offline
Full Member
Sydney, Aust.

Posts: 128
***
 
Here are the files that should work correctly with the "Dynon Waypoint" header included. Different filename to the above just to reference their release date. Other than the replacement headers, actually copied from one of the known-good November files there are no changes.
 

DynonCERT_MAY18.csv (19 KB | 28 )
DynonALA_MAY18.csv (18 KB | 27 )
IP Logged
 
Reply #8 - May 30th, 2018 at 1:43am

BWOK   Offline
Frequent Poster
I love flying!

Posts: 10
**
 
Thanks at KRaviator,

I just noticed that was different off my user waypoint export file. looks like it should be changeable in excel too - its just in the next column header.

Dynon User Waypoints File V1.0

Cheers & thanks for the confirmation.

BK
 
IP Logged
 
Reply #9 - May 30th, 2018 at 1:48am

BWOK   Offline
Frequent Poster
I love flying!

Posts: 10
**
 
Dynon support,

Any chance you can put a user guide amendment in for page 7-71 to include format required/fields for user data?:

*missing last column required after narrative text

It is included in the example below field data but its obvious from the above it wont load otherwise.

Cheers
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Print