Sistemas de Información Geoespacial (GIS)

Text.

  • [[#distancia]]
  • [[#ref]]

Distancias

’'’MySQL Harvesine Formula’’’

3956 * 2 * ASIN ( SQRT ( POWER(SIN((orig.lat - dest.lat)*pi()/180 / 2), 2) + COS(orig.lat * pi()/180) * COS(dest.lat * pi()/180) * POWER(SIN((orig.lon - dest.lon) * pi()/180 / 2), 2) ) ) as distance }}}

Referencias

  • [[[http://www.movable-type.co.uk/scripts/latlong.html Calculate distance, bearing and more between Latitude/Longitude points]]]
  • [[[http://www.scribd.com/doc/2569355/Geo-Distance-Search-with-MySQL Geodistance Search With MySQL]]]