[postgis-users] area

[Paul Ramsey]

select points.* from points where st_within(points.the_geom,
st_geomfromtext('POLYGON((12.4618864 41.8641930, 12.4953175
41.8963661, 12.5012827 41.9045753))',4326) );



2009/4/5 Grzegorz Meus <grzegorz.meus at amistad.pl>:
> hi,
>
> can you tell me how can i search geo points from geopoints database in
> defined area? how can i define area?
> i have points on my googlemaps map and i want search by area..
>
> For example:
> i have 3 markers:
> (41.8641930      12.4618864)
> (41.8963661      12.4953175)
> (41.9045753      12.5012827)
>
> they are creating triangle, i want find other objects in table placed inside
> this triangle.
>
> please help me!
> sorry for my language
>
> cheers
> iamx
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>