Skip to main content

Filling in the Missing Details


This is the first field I looked at and it seems that this is only available in the original out of date supplied data from VAM.

For my initial entry for this I set a default of 'airport' which makes some sense.  However later on providing i have enough data that matches back to the VAM data I can update this to their values such as 'small_airport' , 'large_airport' etc.


This is one of the more difficult fields to get the correct data from as many airports change their name and sometimes they change the ICAO code if available. Remember my test case of Jan Smuts Airport in South Africa that was FAJS becoming OR Tambo and FAOR.

I needed a set of data that was correct with the names of Airports associated with the ICAO code if possible.

It so happens if you are careful you can get a free set of data using an API KEY from a real world website in fact it is ICAO themselves

https://www.icao.int/safety/iStars/Pages/API-Data-Service.aspx

For free you get 100 hits per month so I needed lists of airports that they hold and I managed to get a good set , yes I had to download several CSV files but that was my choice to group countries by letters i.e. A then B etc.

You can do the same with JSON output as well but I need data I can store and look at etc. and CSV is easier for that purpose at present for this project.  No doubt some API returns will be JSON or XML and I will deal with them as required to do so

After downloading these 24 files I created a script to build a reference table to help fill in these missing fields.
 So now I have another table to use and this is the layout and sample data


I had to work on some of the data as the Name was in CAPITALS and I wanted normal format
LONDON HEATHROW to be London Heathrow

so here is the table

Now I can update the name to the database.


Since elevation is in the ICAO airport table I can now just update the value just like airport name as I calculated the data as feet and not metres.


This one had a bit more work to do as the VAM table uses the 2 character ISO code and the ICAO information table has the 3 character ISO code.  Fortunately on the ICAO website there is a download  in CSV of all country codes  which of course I did and added this to my reference database as well




So that's the Country code sorted out by another ICAO table.


This field was not in the ICAO data I downloaded but is available in another API they have but I think it will take me over my 100 hits for one month, so I will see if other databases and api's have this information as well so for now I default this to 'no city'.

Finally we have the last missing field


This is in the main ICAO table and as such it can be copied to update this field 

So now we have nearly a full data table for airports which looks like this now 




In theory now this table could be used in VAM but I would like to have data in the two fields I defaulted data into 


So next I must try and find this data 















Comments

Post a Comment

Popular posts from this blog

Roadmap for my Project

Given that for my project I have chosen the package Virtual Airline Manager references will be made regarding the tables and data of that package.  However the roadmap can apply in theory to any software for a Virtual Airline. Firstly with any software package you need to install it and get some understanding of how it works so that what you create in a refined process is suitable for use.  The same applies if the Virtual Airline already has been built with software other than a package. Once I am happy with the basic installation of Virtual Airline Manager , it does come with some data but since you are starting out to build a new airline many tables are empty and those that have data in would apply to any airline created.  Well thats the theory I guess but in reality is the supplied data what I really want . The main data that is supplied in Virtual Airline Manager  is for Airports and their associated runways and local navigation aids. Because this is an i...
Post a Comment
Read more
Welcome to my new blog !!!. Well the title explains a lot but i will explain why I started my project One of the main if only the main reason for doing this is that so much data is out there which may or may not be correct or exactly what I want to achieve for this exercise. Virtual Airlines have been around for many years to make the experience of flying with a flight simulator such as Microsoft Flight Simulator or X-Plane or indeed any other flight simulation platform that has appeared over the last 10 to 20 years. Virtual Airlines come in all shapes and formats , many emulate their real world entities and many others are fictional or in other words exist only for the Virtual Aviation world. Obviously the Virtual Airline needs a website address and web-pages to operate and many have spent the time to develop extensive websites with a plethora of download files to support their Virtual Airline such as Aircraft Liveries and unique ACARS reporting systems. Others...
Post a Comment
Read more