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: 442AF473.7020600@sonalysts.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-sql
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. 

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



In response to

Responses

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-2014 The PostgreSQL Global Development Group