1
vote
1answer
33 views

What options are there for geolocation-aware SQL databses?

I need to implement an SQL database that can make queries using geo-location based logic. e.g. select rows within 500m of coordinate x, y What options are available to do this with sqlite, mySQL, ...
-1
votes
0answers
45 views

Determine the Closest road to a GPS point [duplicate]

Possible Duplicate: Calculate distance of point from an arc/polyline I have been trying to find the road to which a GPS point is closest to. I have a postGIS database which i loaded with ...
4
votes
4answers
3k views

Calculate distance of point from an arc/polyline

Using Postgres/PostGIS, I am trying to query the database for the closest arc to a particular GPS point. Each Arc is made up of two nodes that are GPS points on a map. Is there a way I could query ...