MySQL Forums
Forum List  »  GIS

list of unique points with a count
Posted by: Cor Bosman
Date: May 08, 2008 11:57AM

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.


Options: ReplyQuote

Written By
list of unique points with a count
May 08, 2008 11:57AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.