title: Get the shortest distance from a point
body: <p>I have this table in sqlite</p>
  
  <pre><code>Locations
  ID
  Lat ( latitude)
  Lon ( longitude) 
  Type
  Name
  City
  </code></pre>
  
  <p>I have for example 100 records
  what I need is to get (using my own coordinates) the nearest point in my table.</p>
  
  <p>What I did is to get the shortest distance between my current point and each one in the table, and return the shortest one, but I am searching for a better solution </p>
  
  <p>Thanks</p>