Example: Apollo moon landings

The map data in Geoquery 2008 is stored in a configurable Xml file - MapSources.xml so it's relatively simple to include different tile servers for Earth images (as well as the Moon & Mars). This example shows a couple of significant points plotted on the moon map tiles. 


/* http://www.fi.edu/pieces/schutte/landchart.html */
select         -- Apollo landings
  geography::STGeomFromText('POINT( 23.49  0.67)', 4326)--11
, geography::STGeomFromText('POINT(-23.45 -2.94)', 4326)--12
, geography::STGeomFromText('POINT(-17.46 -3.67)', 4326)--14
, geography::STGeomFromText('POINT(3.66   26.11)', 4326)--15
, geography::STGeomFromText('POINT(15.31  -8.6 )', 4326)--16
, geography::STGeomFromText('POINT(30.8   20.17)', 4326)--17
, 15.0 AS [Thickness], '#770000ff' AS [Color]

Apollo moon landings

It has been pointed out that 4326 probably isn't the 'correct' SRID for the moon (eg. any distance calculations would clearly be quite overstated) but I'll leave it "as blogged" for now...