3
votes
1answer
99 views

polygon from exterior points

How to convert points data to polygon, so as to form polygon from exterior point as shown above
3
votes
0answers
250 views

Finding poi using st_dwithin in postgis

I am not familiar with gis or writing sql, so my understanding in this field is lacking. I have a hundreds of lat/lng geographic coordinates stored in a single table called Places like this: ID | ...
0
votes
1answer
203 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.
7
votes
2answers
544 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
2k 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
394 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 ...