geospatial
What is the best way to store geographic coordinate data in a database
I\'开发者_运维问答m building a mobile mapping application and I want to store GPS Track data, waypoints etc in a database (SQL CE 4.0). This means I only have access to basic datatypes (http://msdn.mi[详细]
2023-03-19 22:59 分类:问答What data types are supported in SQL CE 3.5 (Windows Phone Mango)
What dat开发者_如何学运维atypes are supported in SQL CE 3.5? Specifically can you use the Geography/Geometry types?Geospatial types are not supported.[详细]
2023-03-18 04:27 分类:问答Mongodb dynamic geo queries
Mongodb geo queries allows to query documents within some geometry (box, circle, polygon), but geomerty param is static.[详细]
2023-03-18 02:37 分类:问答Mysql within distance query
Options $lat = \'25.7742658\'; $lng = \'-80.1936589\'; $miles = 30; Query SELECT *, ( 3959 * acos( cos( radians($lat) )[详细]
2023-03-17 09:27 分类:问答How to workaround MongoDB's current limitation of just one geospatial index per collection?
Currently, MongoDB supports only one geospatial index pe开发者_如何学Pythonr collection. How can I workaround this manually?[详细]
2023-03-17 08:01 分类:问答SQL Distance Query without Trigonometry
I have an SQLite database, which does not support trig functions.I would like to sort a set of la开发者_运维问答t,lng pairs in my table by distance as compared to a second lat,lng pair.I\'m familiar w[详细]
2023-03-16 22:25 分类:问答Ms SQL geography.STDistance returns wrong distance
I\'m trying to query any locations within a specified distance from another location. The query is not the problem, but the distance returned by geography.STDistance is.[详细]
2023-03-16 02:48 分类:问答Left or Right Hand Side of a Polyline
Quite a tricky one this, as the title suggests I need to work our which side of a polyline a point is.[详细]
2023-03-15 21:39 分类:问答C# mysql 75 mile radius map covering the entire US
I have a database full of zipcodes and their lat/long.What i want to do is to be able to cover the entire US in 75 mile radius circles with as little overlap as possible.Any hints or tips?My intention[详细]
2023-03-15 02:00 分类:问答How can efficiently I detect location changes with noisy GPS data?
I\'m working on asset tracking application. I have devices that send update on GPS position every ~5 minutes.[详细]
2023-03-14 18:06 分类:问答