Databases
StackOverflow2013
Postsdbo
POSQlite Getting nearest locations (with latitude and longitude)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQlite Getting nearest locations (with latitude and longitude)
    primarykey
    data
    text
    <p>I have data with latitude and longitude stored in my SQLite database, and I want to get the nearest locations to the parameters I put in (ex. My current location - lat/lng, etc.).</p> <p>I know that this is possible in MySQL, and I've done quite some research that SQLite needs a custom external function for the Haversine formula (calculating distance on a sphere), but I haven't found anything that is written in Java and works.</p> <p>Also, if I want to add custom functions, I need the <code>org.sqlite</code> .jar (for <code>org.sqlite.Function</code>), and that adds unnecessary size to the app.</p> <p>The other side of this is, I need the Order by function from SQL, because displaying the distance alone isn't that much of a problem - I already did it in my custom SimpleCursorAdapter, but I can't sort the data, because I don't have the distance column in my database. That would mean updating the database every time the location changes and that's a waste of battery and performance. So if someone has any idea on sorting the cursor with a column that's not in the database, I'd be grateful too!</p> <p>I know there are tons of Android apps out there that use this function, but can someone please explain the magic.</p> <p>By the way, I found this alternative: <a href="https://stackoverflow.com/questions/3126830">Query to get records based on Radius in SQLite?</a></p> <p>It's suggesting to make 4 new columns for cos and sin values of lat and lng, but is there any other, not so redundant way?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USJure
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQlite Getting nearest locations (with latitude and longitude)
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSQlite Getting nearest locations (with latitude and longitude)
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSQlite Getting nearest locations (with latitude and longitude)
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODid you check if org.sqlite.Function works for you (even if the formula is not correct)?
      singulars
      1. POSQlite Getting nearest locations (with latitude and longitude)
      1. USThomas Mueller
    2. CONo, I found a (redundant) alternative (edited post) that sounds better than adding a 2,6MB .jar in the app. But I'm still searching for a better solution. Thanks!
      singulars
      1. POSQlite Getting nearest locations (with latitude and longitude)
      1. USJure
    3. COWhats the return distance unit type?
      singulars
      1. POSQlite Getting nearest locations (with latitude and longitude)
      1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload