http://snipplr.com/language/mysql/tags/GPS Recent snippets posted on Snipplr.com en-us Sat, 25 May 2013 10:03:18 GMT http://snipplr.com/view/54961/get-closet-locationpoi/ Get closest location to a set of gps coordinates (x, y) given a database table with columns lat(latitude) and lng(longitude)

]]> Tue, 07 Jun 2011 21:06:58 GMT http://snipplr.com/view/54961/get-closet-locationpoi/ http://snipplr.com/view/39302/working-with-spatial-extension/ In this snippet we have one table with GPS points of Queensland (Australia) borders and table of polygons. One of the polygons are created from QLD points by procedure **createPolygon**. Function **checkCoordinatesInPolygon** can check whether GPS coordinates are within some polygon or not.

]]> Thu, 19 Aug 2010 17:08:09 GMT http://snipplr.com/view/39302/working-with-spatial-extension/