Autori: Verka Jovanović, Vladimir Lazović, Nikola Minić,
Objavljeno: SYNTHESIS 2015, International Scientific Conference of IT and Business-Related Research, april 2015, str. 624-628.
Sažetak: The paper presents the creation of SQL queries using mathematical functions that provide the distance between the two points in the shortest time possible and at a highest level of accuracy. The research shows that one of the three most commonly used formulae demonstrated the highest level of accuracy. Haversin formula, which has showed satisfactory accuracy, has been converted into a SQL query where the query execution time was tested. In order to get the information about the location as quickly as possible, the query was expanded with a request to search for the locations within the predefined radius starting from the given coordinates. The aim of this research was to use the results obtained for the purpose of modern mobile phone applications development.
Ključne reči: Vincenty’s formulae, great circle formula, haversine formula, geolocation, location determination
Literatura:
Holdener III, A. T. (2011). HTML5 Geolocation. O’Reilly Media, Inc.
Sinnott, R. W. (1984). Virtues of the Haversine. Sky and Telescope, 68(2), 159.
Steinhaus, H. (1999). Mathematical Snapshots 3rd ed. New York: Dover Recreational Math.
Veness, C. (2014). Vincenty solutions of geodesics on the ellipsoid. Retrieved October 15, 2014, from http://www.movable-type.co.uk/scripts/latlong-vincenty.html
Vincenty, T. (1975). Direct and Inverse Solutions of Geodesics on the Ellipsoid with application of nested equations. Survey Review, 23(176), 88-93.
Weisstein, E. W. (2010). Great Circle. (MathWorld – A Wolfram Web Resource) Retrieved October 15, 2014, from http://mathworld.wolfram.com/GreatCircle.html
Rad se može preuzeti sa ove adrese.
Objavljeno: SYNTHESIS 2015, International Scientific Conference of IT and Business-Related Research, april 2015, str. 624-628.
Sažetak: The paper presents the creation of SQL queries using mathematical functions that provide the distance between the two points in the shortest time possible and at a highest level of accuracy. The research shows that one of the three most commonly used formulae demonstrated the highest level of accuracy. Haversin formula, which has showed satisfactory accuracy, has been converted into a SQL query where the query execution time was tested. In order to get the information about the location as quickly as possible, the query was expanded with a request to search for the locations within the predefined radius starting from the given coordinates. The aim of this research was to use the results obtained for the purpose of modern mobile phone applications development.
Ključne reči: Vincenty’s formulae, great circle formula, haversine formula, geolocation, location determination
Literatura:
Holdener III, A. T. (2011). HTML5 Geolocation. O’Reilly Media, Inc.
Sinnott, R. W. (1984). Virtues of the Haversine. Sky and Telescope, 68(2), 159.
Steinhaus, H. (1999). Mathematical Snapshots 3rd ed. New York: Dover Recreational Math.
Veness, C. (2014). Vincenty solutions of geodesics on the ellipsoid. Retrieved October 15, 2014, from http://www.movable-type.co.uk/scripts/latlong-vincenty.html
Vincenty, T. (1975). Direct and Inverse Solutions of Geodesics on the Ellipsoid with application of nested equations. Survey Review, 23(176), 88-93.
Weisstein, E. W. (2010). Great Circle. (MathWorld – A Wolfram Web Resource) Retrieved October 15, 2014, from http://mathworld.wolfram.com/GreatCircle.html
Rad se može preuzeti sa ove adrese.
Нема коментара:
Постави коментар