[postgis-devel] Window-based Clustering

Paul Ramsey pramsey at cleverelephant.ca
Fri Feb 24 11:09:43 PST 2023


The strategy thing starts to get messy because each strategy has its own parameterization. Some need a tolerance, some need a K, some need a minpoints, etc). In some ways just having a lot of function sigs is cleaner. Each gets its own docs page, can completely explain its parameters, and have relevant examples and results.

P

> On Feb 24, 2023, at 10:53 AM, Darafei Komяpa Praliaskouski <me at komzpa.net> wrote:
> 
> Yay!
> 
> The "Win" part is not very pretty though. Do you think we can get it into maybe something like ST_Cluster(geom, strategy:='intersecting/within/dbscan/kmeans/xmeans/...')? I believe set of other configuration options is not too wide between the methods. 
> 
> пт, 24 лют 2023, 22:41 карыстальнік Paul Ramsey <pramsey at cleverelephant.ca <mailto:pramsey at cleverelephant.ca>> напісаў:
> Martin and I have repeatedly said “it would be nice if all the clustering functionality was available as windowing functions”, and here I have finally gone and added that in. This adds ST_ClusterIntersectingWin and ST_ClusterWithinWin, as windowing analogues to  ST_ClusterIntersecting and ST_ClusterWithin
> 
> https://github.com/postgis/postgis/pull/721 <https://github.com/postgis/postgis/pull/721>
> 
> Unfortunately for backwards compatibility we can’t (I think) just yank and replace the existing functions in favour of the windowing ones, even though I think most people will vastly prefer windowing as an approach to cluster functionality.
> 
> P
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org <mailto:postgis-devel at lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/postgis-devel <https://lists.osgeo.org/mailman/listinfo/postgis-devel>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20230224/4cefcda1/attachment-0001.htm>


More information about the postgis-devel mailing list