SQL Hacks > Number Crunching > Calculate the Distance Between GPS Locations - Pg. : Safari Books Online

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

SQL Hacks

Search

Contents

credits: Credits

Ch. 1. SQL Fundamentals

Ch. 2. Joins, Unions, and Views

Ch. 3. Text Handling

Ch. 4. Date Handling

Ch. 5. Number Crunching

Hack 24. Multiply Across a Result Set

Hack 25. Keep a Running Total

Hack 26. Include the Rows Your JOIN Forgot

Hack 27. Identify Overlapping Ranges

Hack 28. Avoid Dividing by Zero

Hack 29. Other Ways to COUNT

Hack 30. Calculate the Maximum of Two Fields

Hack 31. Disaggregate a COUNT

Hack 32. Cope with Rounding Errors

Hack 33. Get Values and Subtotals in One Shot

Hack 34. Calculate the Median

Hack 35. Tally Results into a Chart

Hack 36. Calculate the Distance Between GPS Locations

Hack 37. Reconcile Invoices and Remittances

Hack 38. Find Transposition Errors

Hack 39. Apply a Progressive Tax

Hack 40. Calculate Rank

Ch. 6. Online Applications

Ch. 7. Organizing Data

Ch. 8. Storing Small Amounts of Data

Ch. 9. Locking and Performance

Ch. 10. Reporting

Ch. 11. Users and Administration

Ch. 12. Wider Access

URL

Help

Hack 36. Calculate the Distance Between GPS Locations

If you have GPS coordinates you can calculate the distance between two points.

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial