Tag: cluster-analysis

Grouping the rows by similarities

algorithm cluster-analysis data-mining sql sql-server

I am working on SQL server. I have the following table: For each BIGroup I have a multiple VarianceName. For each VarianceName I have multiple PartNumbers. I am comparing every partnumber with the …

How to group latitude/longitude points that are ‘close’ to each other?

cluster-analysis database geolocation location sql

I have a database of user submitted latitude/longitude points and am trying to group ‘close’ points together. ‘Close’ is relative, but for now it seems to ~500 feet. At first it seemed I could just group by rows that have the same latitude/longitude for the first 3 decimal places (roughly a 300×300 box, understanding that it changes as you move