MySQL select coordinates within range

by

You can use what is called the Haversine formula.

$sql = "SELECT *, ( 3959 * acos( cos( radians(" . $lat . ") ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(" . $lng . ") ) + sin( radians(" . $lat . ") ) * sin( radians( lat ) ) ) ) AS distance FROM your_table HAVING distance < 5";

Where $lat and $lng are the coordinates of your point, and lat/lng are your table columns. The above will list the locations within a 5 nm range. Replace 3959 by 6371 to change to kilometers.

This link could be useful: https://developers.google.com/maps/articles/phpsqlsearch_v3

Edit: I didn’t see you mentioned Java. This example is in PHP but the query is still what you need.

More Related Contents:

  1. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  2. Hours and seconds are lost when storing a date in the database [closed]
  3. Using threads to make database requests
  4. Using env variable in Spring Boot’s application.properties
  5. Java: Insert multiple rows into MySQL with PreparedStatement
  6. Handling MySQL datetimes and timestamps in Java
  7. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  8. How can I protect MySQL username and password from decompiling?
  9. Connect to remote MySQL database through SSH using Java
  10. How to connect Android with MySQL using Mysql JDBC driver [duplicate]
  11. Exception in thread “main” java.sql.SQLException: Access denied for user ”@’localhost’ (using password: NO)
  12. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  13. Can Hibernate work with MySQL’s “ON DUPLICATE KEY UPDATE” syntax?
  14. Spring, Hibernate, Blob lazy loading
  15. No Database selected when retrieving from mysql website
  16. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  17. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  18. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  19. SimpleDateFormatter.parse giving output in different format than specified
  20. Populate JFreechart TimeSeriesCollection from Mysql DB?
  21. How to correctly write UTF-8 strings into MySQL through JDBC interface
  22. Which is best data type for phone number in MySQL and what should Java type mapping for it be?
  23. Table ‘DBNAME.hibernate_sequence’ doesn’t exist
  24. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  25. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  26. How to setup Hibernate to read/write to different datasources?
  27. JDBC MySQL connection using Unix Socket
  28. Unable to get multiple Table entities through Stored procedure using hibernate
  29. JDBC connection error : unrecognized timezone [duplicate]
  30. Getting last record from mysql

Leave a Comment