thanx ibrahim, I was following the tutorial "using PHP/PostgreSql with Google Maps" by mapperz, they have given an idea how to go about it, but it is very abstract and incomplete. Is there any tutorial of similar kind?
On Fri, Feb 12, 2010 at 1:03 PM, ibrahim saricicek < [email protected]> wrote: > 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 > > -- Maj Rajesh Gupta Mtech(IT) IIT-Kharagpur Mob: 9232020789
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
