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