Complete Airports List

[APX0475]

Afternoon Gents,

Im stuck in a delma and I just dont know how Im going to go about solving it.

Is there anyone with a complete SQL database for the airports by any chance? I could go in manually and add EVERY airport

because Im just going to have a universal Flight number that everyone will use. But I REALLY dont feel like adding all the airports

in but If thats what needs to happen I will but if anyone can contribute the file I would be GRATEFUL!

Best Regards,

Greg

[Jon]

Yeah this is one addition i'd love to have in phpVMS

Jon

[mark1million]

To be Honest if we all did a dump of our airports in to a file then it could be combined to create a fairly complete file, last time i looked there was just over 10000 airport codes.

[simpilot]

Here is the data dump for my airports table for a charter system I have built if it will help. It has 41533 airfields, helipads, water strips, and private airfields in it, I think there are still some that I do not have in it but its a start. It is a big file so you may have to split it up to import it into your table, if you are on free hosting I would not even try.

phpvms_airports.sql.zip

[TennShadow]

This site has over 43,000 aiports to download.

http://www.ourairports.com/data/

[Kyle]

Here is the data dump for my airports table for a charter system I have built if it will help. It has 41533 airfields, helipads, water strips, and private airfields in it, I think there are still some that I do not have in it but its a start. It is a big file so you may have to split it up to import it into your table, if you are on free hosting I would not even try.

WOW! Thanks simpilot.

[APX0475]

I would never use Free Hosting for a VA.

Thanks for the reply's!

Regards,

Greg

[Allan]

I am currently working on the database for airports, might be a while, I will post when its completed

Regards,

Allan

[Nabeel]

I am currently working on the database for airports, might be a while, I will post when its completed

Regards,

Allan

Simpilot posted one above

[Allan]

Simpilot posted one above

I understand that but its not complete

Regards,

Allan

[TAV1702]

Any of you sql wizards know if there is a way to make it skip entries that exist already instead of stopping? At most all I can get in is 58 airports. Before trying to run this I had only like 30 in my DB.

I suppose I could drop all my airports and start from scratch since it is a dev site anyhow. I hate to do that though due to schedules I already have that I do fly with for testing purposes.

[Allan]

If you drop all airport out of the db you will loose your hubs.

Regards,

Allan

[Tom]

I have an export of all the FSX airports' data. If you fly in FSX that's about as complete a database you need?

[TAV1702]

If you drop all airport out of the db you will loose your hubs.

Regards,

Allan

Loosing the hubs is the least of my worries. It is a dev site that only has me and the old lady on it anyhow. I could always manually remove the ones I already have from the "List O' Airports".

[TAV1702]

I have an export of all the FSX airports' data. If you fly in FSX that's about as complete a database you need?

I am on FS9. I'm one of the ones that refuse to upgrade for various reasons.

[Cor]

Import of the data works just fine, only the airport list won´t show up at the adminsite.

Has more people experienced this.

Regards,

Cor

[Kyle]

Cor, everything works for me.

I'm using a dedicated server with the airports, and no load stress yet!!

So are you sure you putted the import data in the right database, lets say your phpVMS DB is "JUZZ", you go in the database and click inport, and it should do that.

[Cor]

The airports are in the right database. When I try to add for example EHAM, it tells me it is alreay present, so it is present in de the databse.

It only does not show the list at the admin end.

Regards,

Cor

[Kyle]

Ok I think its the tables.

Go to the maintanice part in the admin and clear cache and optimize tables and it should show up.

[Cor]

I will try tonight when I am home from work.

Tnx!!

Regards,

Cor

[Cor]

I tryed it, but still no list in the admin site.

Regards,

Cor

[TAV1702]

Is it safe to say to only use this list for a new install? Upon further review, the only way for me to get around the duplicate error is to A) Drop current airports from database and start fresh, or edit the sql list and update ID numbers an remove airports I already have. Good times eh boys? lol

This is one hell of a list though. Thanks Simpilot!

[TAV1702]

Ok so I dropped all my airports and added the sql file and tah dah!!! Got all the airports. Now I am fighting the exhausted memory error. Tried using my own fix I posted in the code snippets but not getting it to work. All the rest of the site works great. Now I can not view schedules. I'm sure in the end I will get it all fixed up nice like.

[Txmmy83]

Here is the data dump for my airports table for a charter system I have built if it will help. It has 41533 airfields, helipads, water strips, and private airfields in it, I think there are still some that I do not have in it but its a start. It is a big file so you may have to split it up to import it into your table, if you are on free hosting I would not even try.

nice

do I need to drop any of the airports that is currently in my DB or will they overwritten by yours?

will maybe use it with a new VA

Best Regards

Tom

[bravo27]

I have an export of all the FSX airports' data. If you fly in FSX that's about as complete a database you need?

Hello tom that file from fsx is it SQL database already and if so would it be possible to get from you thank you

[vins]

Hi I have installed the big list in my free hosting webspace but after, when I have tried to Add a scheduled flight from the admin pannel I got the following message:

Fatal error: Allowed memory size of 94371840 bytes exhausted (tried to allocate 8208111 bytes) in core/classes/CodonCache.class.php on line 202

what is happened?

I hope you can help me...bye bye!

[Kyle]

OK, Free hosting can limit limit you, so that's the problem, Free Hostings are not good. Paid ones, you won't have that kind of problems.

[vins]

Hi, I have deleted the table phpvms_airports.sql and I don't know how to reinstall it.

Could you help me!!

[mark1million]

You do have a backup?

This is from my development server its empty apart from the 2 airports but it will give you the table back,

--
-- Table structure for table `phpvms_airports`
--

CREATE TABLE IF NOT EXISTS `phpvms_airports` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `icao` varchar(5) NOT NULL DEFAULT '',
 `name` text NOT NULL,
 `country` varchar(50) NOT NULL DEFAULT '',
 `lat` float NOT NULL DEFAULT '0',
 `lng` float NOT NULL DEFAULT '0',
 `hub` smallint(6) NOT NULL DEFAULT '0',
 `fuelprice` float NOT NULL DEFAULT '0',
 `chartlink` text NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `icao` (`icao`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `phpvms_airports`
--

INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES
(1, 'KJFK', 'Kennedy International', 'USA', 40.6398, -73.7787, 0, 0, ''),
(2, 'EGKK', 'Gatwick Airport', 'United Kingdom', 51.1481, -0.190278, 1, 0, '');

[vins]

Thanks a lot for the help!!!!!!!