Skip site navigation (1) Skip section navigation (2)

Re: [SQL] Flight numbers data

From: Josh Rovero <rovero(at)sonalysts(dot)com>
To: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [SQL] Flight numbers data
Date: 2006-03-29 20:56:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-sql
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 JohanssonDate: 2006-03-29 23:49:18
Subject: Re: Ugly group by problem
Previous:From: Simon RiggsDate: 2006-03-29 20:12:16
Subject: Re: [SQL] Flight numbers data

pgsql-general by date

Next:From: David BernalDate: 2006-03-29 21:09:04
Subject: Re: postgresql.conf listen_addresses causing connection problems
Previous:From: karlyDate: 2006-03-29 20:40:21
Subject: Re: ODed on overloads

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group