postgis

#1

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

#2

iamx wrote:

Quote:

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!

If nobody here knows the answer, ask the PostGIS mailing list:

http://postgis.refractions.net/mailm.../postgis-users

Yours,
Laurenz Albe

#3

Quote:

If nobody here knows the answer, ask the PostGIS mailing list:

http://postgis.refractions.net/mailm.../postgis-users

Yours,
Laurenz Albe

Thanks, I will try

#4

On 2009-04-01, iamx wrote:

Quote:

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.

Make a polygon from them. After that ST_Intersects and ST_Intersection
are your friends.

Bernd

--
No time toulouse

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

postgis

comp.databases.postgresql comp.databases.postgresql

postgis - 04-01-2009 , 07:44 AM

Re: postgis - 04-02-2009 , 01:58 AM

Re: postgis - 04-06-2009 , 01:22 AM

Re: postgis - 04-16-2009 , 12:43 PM