Re: [SQL] Flight numbers data

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Josh Rovero <rovero(at)sonalysts(dot)com>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [SQL] Flight numbers data
Date: 2006-03-30 08:46:44
Message-ID: Pine.LNX.4.44.0603301145420.22965-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

O Josh Rovero έγραψε στις Mar 29, 2006 :

> We built an operational flight tracking and weather system that uses
> Postgresql,
> http://www.sonalysts.com/wXstation
>
> 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.

Thanx, unfortunately our flights are 90% in middle east/asia.
Are you aware of any such feed in production?

>
> > Has anyone from the postgresql camp ever solved such a problem?
> >
>
>

--
-Achilleus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2006-03-30 09:07:03 Re: pgsql and streams
Previous Message Christopher Condit 2006-03-30 08:44:23 Re: pgsql and streams

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2006-03-30 10:20:23 Re: Ugly group by problem
Previous Message Achilleus Mantzios 2006-03-30 08:41:17 Re: [SQL] Flight numbers data