Hi, I have thousands of records in a mysql database. For each record I have three fields: name, latitude (named lat) and longitude (named lon). Is there a way to cluster the markers directly from a mysql query? Also, I need to have the number of markers in each cluster. I've done something like this, but it's not a good solution: SELECT COUNT(*) AS tot, AVG(lat) AS lat, AVG(lon) AS lon FROM table GROUP BY lat, lon ORDER BY tot DESC
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? Many thanks! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
