Ralph: I tried your solution. It's better than mine but not very accurate in placing the cluster markers. I guess that is due to the average latitude and longitude. Mika: Your script is excellent. I think that clustering by distance is the better idea, but I don't know if I can do all that math in a sql query. Anyway I'll try.
Thank you both! On 14 Nov, 18:17, "Barry Hunter" <[EMAIL PROTECTED]> wrote: > On Fri, Nov 14, 2008 at 4:17 PM, tizius <[EMAIL PROTECTED]> wrote: > > > I've seen that site. > > It is nice but I think he clusters the markers dividing map to > > squares. > > Yes - as does your query. (ok just very small squares!) > > > I'm trying to group the markers directly with a mysql query. > > You could do GROUP BY FLLOR(lat/10), FLOOR(lon /10) > > to get you 'squares' of 10th of a degree. > > You could vary the 10 dynamically to change the size of the squares > (depending on zoom level?) > > Otherwise you perhaps need to clarify what you mean. > > I seriouslly doubt you will be able to do anything like > this:http://googlemapsapi.martinpearman.co.uk/readarticle.php?article_id=1 > directly in the database. > > - at least without precalulations - assigning scores to points and > selecting the top X results with an extents... > > > > > On 14 Nov, 04:11, Ralph Ames <[EMAIL PROTECTED]> wrote: > >> >I've searched everywhere and I didn't succed in finding a query. > >> >Is it possible? And if it is, can someone provide an example query? > > >> Probablyhttp://maps.forum.nu/server_side_clusterer/ > > >> Ralph > > -- > Barry > > -www.nearby.org.uk-www.geograph.org.uk- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
