[postgis-users] area

Grzegorz Meus grzegorz.meus at amistad.pl
Mon Apr 6 22:47:57 PDT 2009


Thx!
I have another problem here: how can I define polygon from lot of 
points? (only from peripheral points)
cheers
> 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) );
>
>
>
>   
>> 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
>>     



More information about the postgis-users mailing list