On Monday 27 March 2006 19:28, Paul Surgeon wrote: > 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".
Heh :) you can already do this using the lat/lon co-ordinates - I put the airfield and ils lists in to a db just to mess about with this sort of stuff. > > 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 Perhaps, in the longer term, it would be a good idea to incorporate a db engine into FG but in the shorter term I think the developers are probably pretty busy enough as it is. A look-up table might be feasible though. It shouldn't take too much space but would have to be re-generated every time Robin Peel updated. Dunno what options are available re run-time access of the file or how long it would take to search (assuming that we don't want to hold the entire thing in mem) Hmm... perhaps a background script could monitor the current situation and manage the info... LeeE ------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/flightgear-devel
