list of unique points with a count

[Cor Bosman]

Hi all, i hope im able to describe this well. For a google maps project im trying to do the following.. Get X results from all existing points on a map in such a way that clusters of points get added together to a count for that cluster and returned as 1 point. So lets say I want 100 results out of 10000 points, and those 100 results are spread out in such a way that 1 point by itself in southern africa is still returned (count 1), but 200 points in new york get 1 result with count 200. The count isnt even really necessary.

The goal would obviously be to allow for clustering of points at the global views. I can think of ways outside of SQL to sortof get similar results, but it would be interesting to see if this is possible through a direct SQL query.

Cor