Suppose we have a handful of places identified by their latitude and longitude.
What I need to do is to run a circle function (x^2 + y^2 = z^2) and get all the places that are inside this circle. Is there any way to retrieve this data by running a math formula? If it isn't, is there any database out there specialized for this purpose?
I don't know the equation(s) off hand or how to work with lat and long for distances, but I'd imagine you have a center point of the circle in lat/long. Calculate the radius of the circle, then find points where the distance to the center point is less than that radius. I think most DB's with geo support have something in place for distance based queries. (At least I would hope so...)
j
stuff ;)
do you mean the cartesian transformations?
mssqltips.com/sqlservertip/4370/transforming-cart…
docs.mongodb.com/manual/geospatial-queries