MySQL has some powerful, and perhaps underused spatial extensions, but the most interesting functions are still unimplemented: “Note: Currently, MySQL does not implement these functions…â€
Among those as-yet unimplemented functions is DISTANCE(). Alternatives can be found here and here, though neither is clean or simple. I wonder if a simple MBRContains() is good enough, though…
Posted June 10, 2008 by Casey Bisson
Categories: Technology. Tags: distance, geolocation, mysql, MySQL spatial functions, spatial functions, unimplemented, workaround.
No Comments
No comments yet.
Comments RSS
TrackBack Identifier URI
Leave a comment
User contributed tags for this post:
mysql distance (49) - mysql spatial distance (33) - mysql distance function (26) - distance between points (24) - distance mysql (11) - calculating distances (10) - mysql distance between two points (10) - calculating distance (10) - Mysql geo (9) - MySQL Calculate distance (8) - mysql geo distance (8) - distance spatial mysql (7) - sexsividyolar (7) - mysql gis distance (7) - calculating distances between places (7) - mySQL BETWEEN (6) - mysql calculate fields (6) - Geo Distance Search with mySQL (6) - calculate distances (6) - distance between coordinates (5) - mysql distance between points (5) - mysql distance() gis (5) - mysql (5) - mysql geo functions (4) - distances between points (4) - calculating the distance between two cell phone text message (4) - mysql calculate distance between two points (4) - mysql geo search (4) - What is the distance between the two points, (8,2) and (2,10)? (4) - Calculating Distance in GIS (4) - calculate distance between coordinates (4) - google save distance mysql (4) - distance geopoints (4) - mileage between points (4) - mysql coordinates (4) - BETWEEN mysql (4) - mysql spatial distance between points (4) - mysql distance spatial (3) - mysql spatial miles from (3) - mysql distance search (3) - php geolocation distance between (3) - distance between two geo points (3) - geo distance php (3) - mysql calculate distance between two point (3) - calculate distance google earth (3) - calculate geo distance (3) - mysql GIS distance points (3) - distance between.in (3) - calculate distance mysql (3) - geo distance mysql (3) - distance between points (3,-3) and (7,-1) (3) - google maps calculate distance in mysql (3) - google map calculate distance between (3) - earth coordinates calculate distance (3) - mysql DISTANCE() (3) - calculate mysql (3) - mysql between example (3) - mysql distance point (3) - mysql point distance (3) - distance between four points (3) - www.com.geo tv (3) - mysql spatial calculate distance (3) - calculating coordinate points (3) - distance between the points (-7,7) and (-4,11)? (2) - php geo distance (2) - mysql earth coordinates distance (2) - between mysql geo point (2) - mysql spatial geo distance (2) - distance mysql geo (2) - mysql distance between coordinates (2) - mysql distance example (2) - mysql spatial calculate distance between point (2) - mysql geo distance search (2) - calculate distance geo points (2) - mysql GIS calculate distance (2) - calculate spatial distance mysql (2) - mysql calculate (2) - calculating distance from earth coordinates (2) - mysql>distance function (2) - mysql distance between two point (2) - mysql geopoints distance function (2) - google distance between 2 points (2) - coordinates mysql (2) - calculating between two coordinate points (2) - mysql calculate distance between points (2) - calculating distance between coordinates (2) - mysql gis video (2) - calculate mileage gis (2) - between in Mysql (2) - DISTANCE MINIMUM IN BETWEEN FOUR POINTS (2) - between example in mysql (2) - calculating mileage distance (2) - calculating with mysql (2) - mysql spatial support distance example (2) - google maps distance mysql (2) - mysql find distance between two points (2) - mysql get distance php (2) - length between points (2) - calculate distance google map (2) - get distance between coordinates (2) - mysql GIS calculating distance (2) - distance between two points mysql (2) - MySQL GIS (2) - distance of points (2) - get points with PHP and MySQL in Google Maps (1) - the distance between the points (7,10) and (1,-1) (1) - GIS mysql distance two POINT (1) - Google Earth distance accurate (1) - mysql distance from point (1) - mysql distance gis beta (1) - what is the distance between the points (-5,4) and (-9,1) (1) - php mysql calculate distance (1) - calculating distances in google earth (1) - mysql point between (1) - get distance between two gis points (1) - php distance between two points on google maps (1) - mysql spatial distance points (1) - distance between (2,-2) and (11,-3) (1) - finding distances postal mysql (1) - mysql4 geo distance (1) - calculating distances from coordinates (1) - video how to calculate distance betwwen two points using google maps (1) - php google maps distance between points (1) - what is the distance between (6,8) and (-5,-1) (1) - php distance function (1) - calculate distance between two points and SEP (1) - mysql distance coords (1) - google maps distance between pointts (1) - calculate distances on earth (1) - PHP distance of two points of google maps (1) - calculating coordinates between two points (1) - finding distance between points (1) - mysql distance points (1) - calculating distance and milage (1) - calculate distance php (1) - mysql Calculate the Distance Between Two Coordinates (1) - calculate distance google maps list coordinates (1) - calculating area in google earth (1) - 42.643983, -71.073400 (1) - google maps calculate distance php (1) - mysql gis examples (1) - distance between 2 geo locations (1) - calculate coordinate between 2 points (1) - (-4,11) (-3,4) distance between points (1) - google maps mysql gis (1) - distance between points? (1) - examples of distance with points (1) - how to calculate distance points from coords (1) - mysql calculate distance between coordinate (1) - cell phone coordinates and distance (1) -
