[postgis-users] recursive query

[Patricio Cifuentes Ithal]

hi...
add suplex query with extension....

example

WHERE SetSRID('BOX3D(".$ext[0]." ".$ext[1].",".$ext[2]."
".$ext[3].")'::box3d,-1) && the_geom ) as foo using unique gid using SRID=-1

only query result data viewer...

-- 

Patricio Cifuentes Ithal
Ingeniero en Informática

Informática
SIIGSA
(56-2) 204 60 22
----- Original Message ----- 
From: "Benedetto Porfidia" <benedetto.porfidia at apat.it>
To: <postgis-users at postgis.refractions.net>
Sent: Friday, May 05, 2006 5:50 AM
Subject: [postgis-users] recursive query


> Hi all,
> I have a table of about 300.000  points and I want to check if  the
> value of a field of each point is within the  range of avg +/- stddev of
> the nearest points in certain radius.
> I tried with buffers and within or contains operators, but I can't
> figure out the right query.
>
> Can anyone help with this?
>
> thanks very much
>
> Benedetto
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users