Home > mailing lists

extent within given distance - Mailing list pgsql-general

From	User Map
Subject	extent within given distance
Date	May 16, 2008 09:31:12
Msg-id	124102.21643.qm@web45704.mail.sp1.yahoo.com Whole thread Raw
List	pgsql-general

Tree view

hi,

Is there any way to calculate the extent(geom) on basis of the given distance from a point, such as the point is in the middle. I have tried the Distance(geom,geom)<50, for calculating extent, but it is very slow in processing. My data SRID is 27700, and so the units are meters, i want to extract the geom in the specified meters.

any help will be appriciated.

thanks

pgsql-general by date:

From: Richard Huxton
Date: 16 May 2008, 09:17:21
Subject: Re: recommended way of separating data from indexes

From: "Linsong GUO"
Date: 16 May 2008, 11:35:04
Subject: Re: psql proxy

extent within given distance - Mailing list pgsql-general

Previous

Next