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.

1 Comment(s)

Comments RSS TrackBack Identifier URI

Leave a comment

Name (required)

Mail (will not be published) (required)

Website

 

User contributed tags for this post:

mysql distance (148) - mysql distance function (90) - mysql spatial distance (87) - mysql geo distance (66) - distance between points (57) - Mysql geo (44) - mysql distance between points (38) - distance mysql (36) - distance between coordinates (32) - Geo Distance Search with mySQL (31) - mysql distance between two points (29) - What is the distance between the two points, (8,2) and (2,10)? (27) - MySQL Calculate distance (23) - calculating distance (22) - mysql gis distance (20) - calculate distance between coordinates (18) - mysql point distance (17) - mysql geo search (17) - mysql geo functions (16) - mysql coordinates (16) - calculate distance mysql (13) - mysql distance calculation (13) - mySQL BETWEEN (12) - calculating distances (11) - distance between two geo points (10) - mysql distance coordinates (10) - MySQL Spatial Distance Function (10) - mysql distance point (10) - geo distance mysql (9) - mysql spatial distance between points (9) - distance search mysql (9) - mysql (8) - mileage between points (8) - distance spatial mysql (8) - coordinates mysql (8) - distance between two points mysql (8) - point distance mysql (8) - BETWEEN mysql (7) - between in Mysql (7) - mysql calculate fields (7) - calculating distance between coordinates (7) - calculating distances between places (7) - mysql distance search (7) - mysql distance between coordinates (7) - point mysql (7) - mysql distance between 2 points (7) - mysql geo distance function (7) - php calculate distance (7) - distance between 3 points (7) - mysql distance coordinate (7) - MySQL GIS (6) - mysql DISTANCE() (6) - distances between points (6) - calculate distances (6) - mysql distance spatial (6) - Calculating Distance in GIS (6) - mysql between example (6) - mysql earth distance (6) - mysql calculate distance between two points (6) - distance mysql gis (6) - mysql distance two points (6) - distance between points php (6) - distance between points mysql (6) - mysql spatial calculate distance (5) - distance between coordinate points (5) - php geo distance (5) - mysql distance() gis (5) - mysql distance example (5) - between function in mysql (5) - distance between.in (5) - distance() mysql (5) - mysql distance calculation google maps (5) - spatial distance mysql (5) - mysql coordinate distance (5) - maps.example.com/distance (5) - geodistance with mysql (5) - mysql geo coordinates (5) - mysql spatial data calculating distance between two point (5) - mysql calculate distance between two point (4) - calculating with mysql (4) - calculate distance google earth (4) - mysql GIS calculate distance (4) - mysql geo distance search (4) - mysql calculate (4) - distance geopoints (4) - calculating mileage distance (4) - calculating coordinate points (4) - google save distance mysql (4) - google maps mysql gis (4) - function distance mysql (4) - calculating the distance between two cell phone text message (4) - www.com.geo tv (4) - mysql function distance between coordinates (4) - mysql function calculate distance (4) - calculate distance between points (4) - mysql distance from (4) - MySQL between function (4) - php distance between coordinates (4) - mysql calculate distance between coordinates (4) - mysql calculate distance coordinates (4) - google maps calculate distance (4) - distance between three points (4) - php calculate distance between geocoordinates (4) - google calculate distance (4) - geo mysql spatial (4) - mysql distance between two coordinates (4) - distance gis mysql (4) - calculate distance in MySQL (4) - mysql function distance (4) - geo mysql (4) - mysql calculate geo distance (4) - mysql gis function (4) - calculate mysql (3) - distance between four points (3) - mysql spatial distance example (3) - mysql find distance between two points (3) - mysql calculate distance between points (3) - php geolocation distance between (3) - mysql GIS distance points (3) - mysql distance between two point (3) - earth coordinates calculate distance (3) - distance between points (3,-3) and (7,-1) (3) - geo distance php (3) - calculate geo distance (3) - mysql calculate distance between 2 points (3) - distance mysql geo (3) - google maps calculate distance in mysql (3) - mysql spatial miles from (3) - finding distance between points (3) - mysql distance points (3) - geo distance mysql php (3) - mysql points distance (3) - calculate mileage gis (3) - google maps distance mysql (3) - mysql coordinates distance (3) - mysql GIS calculating distance (3) - google map calculate distance between (3) - distance between two points mysql 5.0 (3) - calculating distance in mysql (3) - calculate distance geolocation (3) - spatial point mysql mileage (3) - mysql get distance (3) - mysql spatial distance miles example (3) - distance function mysql spatial point (3) - distance 2 point mysql (3) - mysql spatial miles between points (3) - mysql calculate distance spatial (3) - calculate distance between coordinates php (3) -