BIRT 3.7
Written by: Michael Williams
Featured Refcardz: Top Refcardz:
  1. Scrum
  2. Apache Maven 2
  3. Essential MySQL
  4. Node.js
  5. Groovy
  1. jQuery Selectors
  2. Ajax
  3. Java
  4. Spring Config.
  5. Java Concurrency
150+ Refcardz Available · Get them all

Link Details

Previous | Next

Surprise Me!
Link 130404 thumbnail
User 343783 avatar

By linde002
via php.linde002.nl
Published: Oct 31 2008 / 03:49

Finding geographical distances between two points in MySQL 5
For a project I’m working on I needed to find the distances between two points to be able to let users ask the application questions like: “How many points of type X (coworkers, jobs, gas stations, donutshops) are within a radius of point y (my home, my office, my previous donut shop). Or what is the nearest point x from point y. I solved this problem with a stored procedure.
Vote up
Vote down
  • 14
  • 0
  • 3127
  • 1
SaveShareSend Tags: , ,

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.