Android Question SqLite query to sort several lat & lon

rleiman

Well-Known Member
Licensed User
Longtime User
Hi Everyone,

I'm looking to sort several latitudes and longitudes with an SqLite query. Can you show me the correct query to sort these example latitudes and longitudes so I can use them in trip planning?

B4X: 
Lat                      Lon
--------------           ---------
51.6916667               11.3375
82.8298349               8.8282
41.2398458               10.8345
38.9834722               14.2352

Thanks.
 
Sort by date Sort by votes

rleiman

Well-Known Member
Licensed User
Longtime User
Ascending order with the first one closest to my location. I'm assuming I will need to use a B4A library to get the latitude and longitude closest to my location first. Can you also tell me what library I would need?
 
Upvote 0

klaus

Expert
Licensed User
Longtime User
Attached a small project calculating the distance of cities and sorting the closest to a given point in a given radius.
In reality, in the SQLite query I calculate the square of the distance because there is no square root function in SQLite.
The program uses the Table class and needs the ScrollView2D library.
 

Attachments

  • CityList.zip
    33.7 KB · Views: 389
Upvote 0

rleiman

Well-Known Member
Licensed User
Longtime User
Hi Klaus,

Thanks.

I don't see the attachment. How do I download it?
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
B4J Code Snippet [B4X] Calculate the bearing between two coordinates
Replies
2
Views
2K
emexes
E
  • Question
Android Question Converting Coordinates
Replies
13
Views
3K
Brian Dean
B
  • Question
Android Question Problem saving data quickly in SqLite
Replies
5
Views
3K
Erel
  • Article
Android Example Searching the nearest Coordinate in a Database
Replies
13
Views
9K
woodpecker
W
F
  • Question
Measurement of Distances
Replies
14
Views
11K
IslamQabel
I
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…