Hi;
dont know how you'll get the coordinates of a path from google maps, but if
you get you should use;
select
st_dwithin((GeomFromText('LINESTRING(x1,y1,...xn,yn)',4326),(your_poi.the_geom),0.001))
limit 5
or
select
st_intersects(st_buffer((GeomFromText('LINESTRING(x1,y1,...xn,yn)',4326),0.001),
(your_poi.the_geom))) limit 5
'LINESTRING(x1,y1,...xn,yn)' = path from google maps,
4326= Wgs84 projection
0.001= radius of buffer in degrees
limit 5 = number of your pois in buffer
regards..
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
