(not work related!) I am working on a GPS mapping application for use with my hobby.
The GPS produces output in longitude and Latitude – I would then like to run this against a place name table in order to find out the nearest town (I will then go on the work out distance and bearing to this town)
However I am having trouble finding the nearest value in my PlaceName table
[PlaceNames]. [Latitudes]
19.065925
19.107649
19.204109
19.445961
19.449831
If my GPS Latitude is 19.120000 I want to select the second row as the nearest value but if the GPS Latitude is 19.180000 then I want to select the third row.
Any suggestion on the select statement ??
The GPS produces output in longitude and Latitude – I would then like to run this against a place name table in order to find out the nearest town (I will then go on the work out distance and bearing to this town)
However I am having trouble finding the nearest value in my PlaceName table
[PlaceNames]. [Latitudes]
19.065925
19.107649
19.204109
19.445961
19.449831
If my GPS Latitude is 19.120000 I want to select the second row as the nearest value but if the GPS Latitude is 19.180000 then I want to select the third row.
Any suggestion on the select statement ??
Comment