[postgis-users] using postgis with PHP and google maps

[ibrahim saricicek]

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..
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100212/0b321391/attachment.html>