Bryan Mayer posted a very cool Kml file containing
Flight Simulator flightpaths for Google Earth.
Geoquery.
It was possible to import the database from Bryan's
post with some custom C#.
The resulting SQL CREATE TABLE and INSERT script can be downloaded and run on SQL Server 2008.
Querying the resulting table - SELECT * FROM flightpath - looks like this in SQL Server 2008 Management Studio and Geoquery 2008 respectively:
Management Studio's Dundas graphic sure looks nice - but a little difficult to interpret in isolation. Geoquery's Shape tab looks worse without even the funky pastel colors.
However, the Map tab in Geoquery starts to give the lines some context.
Even more interesting is how the 'curved' lines become straight when viewed on the globe!
