I take the silence as an evidence that there is no declarative solution to this challenge :->. I think I have to write a stored procedure.
Yours, S. 2011/2/13 Stefan Keller <[email protected]>: > Hi > > Given a table of peaks with the fields id, name, elevation, geom I'd > like to write a query which returns to me only those (randomly > selected) peaks - i.e. peak buffers say with radius 5 kilometers - > which dont 'overlap'. This is motivated by a visualization use case > where label names should'nt overlap because of lack of visual space - > as well as because of low network capacity between db and client! > > Any ideas on how to solve this with a declarative SQL query? > > The only promising approach I found so far was is to define a subquery > with ranked buffers and then to select some out of these... > > -S. > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
