Tagged Questions

0
votes
1answer
91 views

How to find the POI (points of interest) Within a Given Radius?

I have a table with x,y coordinates with the_geom column. Now I need to find the nodes (Points Of Interest) present in a given radius. Kindly help me in knowing how to find it. Thanks.
6
votes
1answer
146 views

How to find the nearest city for a POI in a OpenStreetMap/PostGIS database?

I'm interested in finding additional data for the POIs in OSM database. Currently I can use the following SQL for getting the name+long+lat for all the POIs SELECT name, x(transform(way, ...
4
votes
2answers
574 views

How to find the nearest point from POI in PostGIS?

I have Point of Interest data in MySQL. This are the fields latitude,longitude,address,types in which I have stored the data. Now i want to import it into PostGIS Database. But does it required ...
6
votes
2answers
164 views

Find points of interest near a path?

Imagine a table of points of interest along with lat/long. The user identifies two of these points. I want to do the following: Calculate a great-circle path between these points Find all POIs that ...