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

Rajesh Gupta rajeshgupta923 at gmail.com
Fri Feb 12 05:04:22 PST 2010


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 <
ibrahimsaricicek at gmail.com> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
Maj Rajesh Gupta
Mtech(IT)
IIT-Kharagpur
Mob: 9232020789
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100212/4527075f/attachment.html>


More information about the postgis-users mailing list