title: SQL query to query nearby points of interest based on lat/long - SQLite
body: <p>Given a database that contains three fields:</p>
  
  <p>Latitude
  Longitude
  Proximity</p>
  
  <p>Where Lat and Long are GPS coordinates, and Proximity is (some unit - feet? Seconds? Minutes?)</p>
  
  <p>And given the user's current GPS lat/long...</p>
  
  <p>I want to write a SQL query that will retrieve all rows where the user is within "Proximity" of those rows.</p>
  
  <p>And the trick: This has to work in SQLite, which only supports fairly primitive data types. No cheating and relying on SQL Server (or some other product that provides better geospace functions).</p>
  
  <p>Any suggestions?</p>