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

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-sql
O Josh Rovero έγραψε στις Mar 29, 2006 :

> We built an operational flight tracking and weather system that uses 
> Postgresql,
> 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?
> >   


In response to

pgsql-sql by date

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

pgsql-general by date

Next:From: Tino WildenhainDate: 2006-03-30 09:07:03
Subject: Re: pgsql and streams
Previous:From: Christopher ConditDate: 2006-03-30 08:44:23
Subject: Re: pgsql and streams

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