On Monday 27 March 2006 18:45, Lee Elliott wrote:
> I think we could identify the appropriate countries accurately
> using the geometric stuff in postgres (dunno if other dbms have
> the functions and datatypes).
>
> Basically, I believe we would have to take the country outlines
> and use them to define geometrical shapes that can then be used
> in a query to see, from the lat/lon which shape (country) an
> airfield is in.
>
> That doesn't address how we would use results though - they'd
> either have to be used as an additional index/look-up file or to
> be merged in to the existing airports file, breaking
> compatibility.

Now that would be a really cool way to do it!
We could easily go down the the state/province level and even take it furthur 
and have a function that does a "fetch all airports within X miles of this 
city/town".

Why have a separate look-up file or a merged airports db? Why not just add a 
PostgreSQL driver and shapefile driver to FG with a directory of shapefiles 
and do the calculations in real time with a map interface?  :D

Paul


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Flightgear-devel mailing list
Flightgear-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/flightgear-devel

Reply via email to