Drupal 7, GPS lat, lng closes value, is it possible? After multiple attempts to figure out how to find the closest gps point from the lat &amp; lng fields (field_data_field_lat &amp; field_data_field_lng) I would like to ask if such is possible? Is there any module that provides a solution with which it's able to create two fields for lat/lng and use them at views to find the closest one from an exposed filter?

I assume that there is no such ready made solution. In that case, I would like to write my custom sql statement for D7. Unfortunately, D7 doesn't support the D6 sql query functions and also the pager_query function.

Therefor I would like to write a statement that would bind the lat and lng fields and give back the nearest - closest gps points.
Similar, one field statement is written at: http://www.techfounder.net/2009/02/02/selecting-closest-values-in-mysql/ where the union and ABS is used. I've found the union option but didn't figured out how to make the comparison for both fields within the D7 db sql layer.

Thank you in advance.
Have a look at this article: Creating a Store Locator with PHP, MySQL &amp; Google Maps. Especially the section about "Finding locations nearby with MySQL" is hinting towards your solution.

As you can read in the mentioned  article, calculating the distance between 2 points given their lat/lon requires quite some math (Haversine formula). So, I guess that the performance optimization in the article you are referring to won't be possible. This because it will be hard to use an index to retrieve probable points.