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 <[email protected]>: > 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
