Scott Hamilton wrote:
> However I really like the idea of getting back an array of airports
> within some radius of a centre lat/lon pair, and/or within a bounding
> box (2 or 4 lat/lon pairs), and if the same could be done with other
> navigation elements in nav.dat it would be most excellent!
Hehe, I'm still looking for a place to drop those features which are already
availale from our Landcover-DB. This is just the SQL prompt, but it's no
big deal casting this into some CGI - for those people who don't mind having
internet connection and using a HTTP-request:
landcover=> SELECT navaid AS "ID", freq as "Frequency", asText(wkb_geometry)
AS "Lon/Lat"
landcover-> FROM apt_navaid
landcover-> WHERE wkb_geometry && ST_Buffer(
landcover(> (SELECT wkb_geometry FROM apt_airfield WHERE icao LIKE 'KSFO'),
0.05
landcover(> )
landcover-> ORDER BY navaid;
ID | Frequency | Lon/Lat
---------------------------+-----------+----------------------------------
KSFO 19L DME-ILS | 10890 | POINT(-122.383167 37.605194)
KSFO 19L GS | 10890 | POINT(-122.369581 37.625436)
KSFO 19L ILS-cat-I | 10890 | POINT(-122.382236 37.604519)
KSFO 19L MM | 0 | POINT(-122.36115 37.636325)
KSFO 28L DME-ILS | 10955 | POINT(-122.394317 37.626092)
KSFO 28L GS | 10955 | POINT(-122.361136 37.613922)
KSFO 28L ILS-cat-I | 10955 | POINT(-122.393778 37.626569)
KSFO 28R DME-ILS | 11170 | POINT(-122.394608 37.630178)
KSFO 28R GS | 11170 | POINT(-122.361114 37.613956)
KSFO 28R ILS-cat-III | 11170 | POINT(-122.395311 37.629539)
KSFO 28R IM | 0 | POINT(-122.354544 37.612442)
KSFO 28R MM | 0 | POINT(-122.347272 37.609386)
SAN FRANCISCO VOR-DME | 11580 | POINT(-122.37388889 37.61947222)
SAN FRANCISCO VOR-DME DME | 11580 | POINT(-122.37388889 37.61947222)
The same is available for airfield positions and all the other related
stuff.
Cheerio,
Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Flightgear-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/flightgear-devel
