android - Populate ListView from SQLiteDate sorting by Distance from user -
i working on first app, , want make list pull venues database , sort them distance user positions. haven't done coding users position know there plenty of tutorials that, , can use fixed arbitrary point. what need calculating distance , using distances build list. making database scratch can use lat, long position or else, instance if addresses useful(i figured lat, long straight forward). i don't know begin not familiar sql know if there way query such thing. in terms of sorting it, database doesn't have distance column (yet, if recommend it) , need updated every time user moved. other thought convert cursor array , create distance variable way. i hope have described problem in enough detail , apologize not providing code. in advance recommending methods approach this.