Using MySQL’s geospatial extension for a location finder

by Ollie on January 20, 2014 in Geography, MySQL, Reference • 6 Comments

version 5.7.5 or later of MySQL
ALTER TABLE flags ADD SPATIAL INDEX (coordinates)

MbrContains(box,geo)

GeomFromText('LINESTRING(LatSW LonSW, LatNE LonNE)')

GeomFromText('LINESTRING(42.6650 -71.0076,42.9549 -70.6124)')

helpful details

← Stored function for haversine distance computation

SQL Reporting by time intervals →

6 comments for “Using MySQL’s geospatial extension for a location finder”

Rick
January 20, 2016 at 5:00 pm
http://www.plumislandmedia.net/mysql/haversine-mysql-nearest-loc/
Reply
- Ollie
  January 21, 2016 at 1:57 pm
  Reply
Nuno
March 12, 2014 at 8:18 pm
Reply
- Ollie
  March 13, 2014 at 8:13 am
  Reply
  - nic
    September 11, 2016 at 11:07 pm
  - Ollie
    September 21, 2016 at 11:52 am

What do you think? Let me know! Cancel reply