Purchase Solution

given a latitude and longitude, can return a search radius

Not what you're looking for?

Ask Custom Question

Looking for a calculation that given a latitude and longitude can return a search radius

Here is the issue: I have a table of zip codes with their corresponding longitude and latitude values. For any given zip code, I need all of the zip codes in a 10 mile search radius. How would I set up the calculations to perform such a task?

I set up a calculation to determine the distance between two points by using:
SQRT( ((69.17 * (@sLat - @pLat) )
* (69.17 * (@sLat - @pLat))
+ ( 57.56 * (@sLon - @pLon) )
* ( 57.56 * (@sLon - @pLon))))
The zip codes are in Southern California which is why the 57.56 value was used. I am not sure how to set up the radius calculation given only one set of latitude and longitude values.

Purchase this Solution

Solution Summary

The following posting helps calculate search radius.

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Probability Quiz

Some questions on probability

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.