Here’s my own solution, based on the idea in ask Dr. Math. I’d be happy to see your feedback. Disclaimer first. This solution is correct for spheres. Earth isn’t a sphere, and the coordinates system (WGS 84) doesn’t assume it’s a sphere. So this is just an approximation, and I can’t really estimate is error. … Read more
with an embedded document, regardless of the name of the field in the embedded document, the first field should contain the longitude value and the second field should contain the latitude value. For example: db.zips2.insert( { _id: 1, city: “b”, loc: { x: -73.974, y: 40.764 } } ) db.zips2.insert( { _id: 2, city: “b”, … Read more
I had the same problem on a Windows Server 2012 machine. It had an SqlServerSpatial110.dll file in \Windows\System32, but no SqlServerSpatial.dll. The solution was installing the Microsoft System CLR Types for SQL Server 2008 R2 on the machine. http://www.microsoft.com/en-us/download/details.aspx?id=26728 Click Download Check off one of these depending on your processor architecture: 1033\x64\SQLSysClrTypes.msi 1033\x86\SQLSysClrTypes.msi 1033\IA64\SQLSysClrTypes.msi Click … Read more
Here is a java program which uses a function that will return true if a latitude/longitude is found inside of a polygon defined by a list of lat/longs, with demonstration for the state of florida. I’m not sure if it deals with the fact that the lat/long GPS system is not an x/y coordinate plane. … Read more
Haversine and Vincenty are two algorithms for solving different problems. Haversine computes the great circle distance on a sphere while Vincenty computes the shortest (geodesic) distance on the surface of an ellipsoid of revolution. So the answer to your question can be broken into 2 parts: Do you want to compute the distance on a … Read more
OpenStreetMap is, of course, the obvious answer. There are various APIs for managing the data in the database, and there are various APIs for getting maps onto your webpages, such as OpenLayers, Mapstraction, or Staticmaps.
In order to use mongodb $near queries with km bounds, you need to convert the radius value to km. By default mongodb $near accepts $maxDistance as radius. Convert distance by 111.12 (one degree is approximately 111.12 kilometers) when using km, or leave distance as it is on using degree to your question what do I … Read more
The canonical way is this: fieldName:[* TO *] Using a ” on the left side as Paige Cook suggested will probably work too but I don’t trust it as much as I do the above. And since this is to a Location field, you will probably have to do this against one of the two … Read more