We built an operational flight tracking and weather system that uses
One data feed (FAA ASDI) uses both aircraft registration
numbers (tail numbers) and airline-assigned flight numbers. Typically
if you have the latter, you won't get the former. This feed only has
information for flights in the U.S. or to/from the U.S. The data feed also
includes flight plans, so it wouldn't be too hard
to build up a flight number schedule over a short period of time.
Outside the U.S. the problem is more difficult.
> Has anyone from the postgresql camp ever solved such a problem?
In response to
pgsql-sql by date
|Next:||From: Niklas Johansson||Date: 2006-03-29 23:49:18|
|Subject: Re: Ugly group by problem|
|Previous:||From: Simon Riggs||Date: 2006-03-29 20:12:16|
|Subject: Re: [SQL] Flight numbers data|
pgsql-general by date
|Next:||From: David Bernal||Date: 2006-03-29 21:09:04|
|Subject: Re: postgresql.conf listen_addresses causing connection problems|
|Previous:||From: karly||Date: 2006-03-29 20:40:21|
|Subject: Re: ODed on overloads|