title: How to group latitude/longitude points that are 'close' to each other?
body: <p>I have a database of user submitted latitude/longitude points and am trying to group 'close' points together. 'Close' is relative, but for now it seems to ~500 feet.</p>
  
  <p>At first it seemed I could just group by rows that have the same latitude/longitude for the first 3 decimal places (roughly a 300x300 box, understanding that it changes as you move away from the equator). </p>
  
  <p>However, that method seems to be quite lacking. 'Closeness' can't be significantly different than the distance each decimal place represents. It doesn't take into account that two locations may have different digits in the 3rd (or any) decimal place, but still be within the distance that place represents (<code>33.1239</code> and <code>33.1240</code>).</p>
  
  <p>I've also mulled over the situation where Point A, and Point C are both 'close' to Point B (but not each other) - should they be grouped together? If so, what happens when Point D is 'close' to point C (and no other points) - should it be grouped as well. Certainly I have to determine the desired behavior, but how would either be implemented?</p>
  
  <p><strong>Can anyone point me in the right direction as to how this can be done and what different methods/approaches can be used?</strong></p>
  
  <p>I feel a bit like I'm missing something obvious.</p>
  
  <p>Currently the data is an a MySQL database, use by a PHP application; however, I'm open to other storage methods if they're a key part in accomplishing this. here. </p>