Timeline for Spatial clustering with PostGIS?
Current License: CC BY-SA 4.0
25 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 10, 2019 at 1:15 | history | edited | Mike T | CC BY-SA 4.0 |
edited body
|
| Dec 10, 2019 at 1:08 | history | edited | Mike T | CC BY-SA 4.0 |
rewrite kmeans section to make it modern
|
| Dec 9, 2019 at 20:34 | comment | added | Mike T | @Luffydude you need to revise your installation steps, and if you had issues, make a new question to address it. | |
| Dec 9, 2019 at 16:43 | comment | added | Luffydude | I got ERROR: function kmeans(double precision[], integer) does not exist | |
| Mar 3, 2017 at 15:31 | comment | added | Nicolas Boisteault | I answered to my question here : gis.stackexchange.com/a/230719/20843 I forgot to say thanks Mike! | |
| Mar 3, 2017 at 14:26 | comment | added | Nicolas Boisteault | @Mike T How do you visualize GeometryCollection datatype in QGIS? | |
| Apr 26, 2016 at 20:57 | comment | added | Mike T | @maxd no. Given A = πr², then r=√(A/π). | |
| Mar 12, 2016 at 6:46 | vote | accept | drnextgis | ||
| Feb 2, 2016 at 5:05 | history | edited | Mike T | CC BY-SA 3.0 |
show example of ST_ClusterWithin
|
| Mar 28, 2015 at 22:34 | comment | added | Mike T | @Sanjayr it's possible, but very difficult to do, requiring non-free compilers and expertise on how to use them. It's much simpler to do with Linux, even a VM running on Windows. | |
| Mar 27, 2015 at 11:26 | comment | added | GIS Data Butcher | How to install kmeans module in postgres in window 7 machine. | |
| Dec 11, 2014 at 22:50 | comment | added | Mike T | @andi many, many different ways. I normally use QGIS. | |
| Dec 11, 2014 at 22:45 | comment | added | andilabs | how do you visualize it? | |
| S Oct 19, 2013 at 19:26 | history | suggested | EoghanM | CC BY-SA 3.0 |
Blind bump of version number based on latest stable here: http://pgxn.org/dist/kmeans/
|
| Oct 19, 2013 at 9:04 | review | Suggested edits | |||
| S Oct 19, 2013 at 19:26 | |||||
| Aug 26, 2012 at 21:26 | comment | added | djq | Version 1.1.0 is now available: api.pgxn.org/dist/kmeans/1.1.0/kmeans-1.1.0.zip | |
| Jul 10, 2011 at 15:09 | comment | added | djq | For kmeans clustering you need to specify the number of clusters in advance; I'm curious if there are alternative algorithms where the number of clusters is not required though. | |
| Jul 10, 2011 at 10:28 | history | edited | Mike T | CC BY-SA 3.0 |
use environment variable, rather than edit Makefile
|
| Jul 5, 2011 at 4:57 | vote | accept | drnextgis | ||
| Mar 12, 2016 at 6:46 | |||||
| Jul 5, 2011 at 4:57 | vote | accept | drnextgis | ||
| Jul 5, 2011 at 4:57 | |||||
| Jul 4, 2011 at 11:20 | comment | added | wildpeaks | (ah you replied at the same time I deleted the previous comment to reformulate it, sorry) | |
| Jul 4, 2011 at 11:19 | comment | added | wildpeaks | Great, these modifications will help for the installation :-) However I fear I can't really use that extension in the end because (if I understood correctly), it needs an hardcoded magic number of clusters, which is fine with static data precause you can fine-tune it in advance but wouldn't fit me for clustering arbitrary (due to various filters) data sets, e.g. the large gap in the 10-points cluster on the last image. However this will help other people too because (afaik), this is the only existing SQL example (except the one liners on the extension's homepage) for that extension. | |
| Jul 4, 2011 at 10:41 | history | bounty ended | wildpeaks | ||
| Jul 4, 2011 at 10:02 | history | edited | Mike T | CC BY-SA 3.0 |
add minimum bounding circle
|
| Jul 4, 2011 at 9:36 | history | answered | Mike T | CC BY-SA 3.0 |