You could add it to your database or do a lookup when the query is made (but that will take more time)
On Jan 7, 9:36 am, p00kie <[email protected]> wrote: > How do you propose filtering by country? > > Also, I'm sorry but I forgot to mention that all of my data points are > in coastal / oceanic areas. There are data points ranging from areas > like Chesapeake Bay in Maryland to the Baltic Sea. > > On Jan 7, 12:26 pm, Grok Lobster <[email protected]> wrote: > > > > > You could total the number of points returned by country and add a > > marker to the map for each country (with returned data) and then when > > the user clicks on a particular country, they get a display of the > > markers for that country. With the number of markers you are talking > > about, you may need to subdivide the countries as well. > > > On Jan 7, 8:38 am, p00kie <[email protected]> wrote: > > > > I am working with a large database with over 2 million points. I have > > > a system for user query to query the database with given constraints > > > and return a data set. > > > > The number of points returned is arbitrary as you can see. It can > > > obviously range from 0 to 2 million rows. Each row has a longitude and > > > latitude that I would like represented by a marker on my map - > > > allowing a clear visual representation of the data points across the > > > Earth. > > > > Now for a map that I am implementing, the current problem is the > > > larger number of rows returned, the slower and longer it takes for the > > > map. Sometimes this results in an unresponsive script. > > > > This leads me to decide on the implementation of a Marker Manager. So > > > at the initial zoom level, it will only show x number of points and as > > > you zoom in and pan around, it will continually show x number of > > > points. x is denoted by an a number which represents the ideal number > > > of points that will allow for a responsive and quick loading map. > > > > However, being that the number of rows returned from a user defined > > > query is arbitrary, there needs to be an algorithm that defines the > > > zoom level of a set of markers. Another constraint is that the markers > > > per zoom level need to be in a format in which at the maximum zoom > > > level, it is clearly obvious that there are points at varying > > > locations around the Earth. > > > > My question is if anyone has had any success coming up with an > > > intelligent algorithm to deal with this. Perhaps something to do with > > > the difference of degrees in latitude/longitude to establish "main" > > > markers (aka markers establishing the fact that there is something > > > going on at that location) for the maximum/lower zoom levels (1x, 2x). > > > Then a good way to filter out the other markers at the other zoom > > > levels. > > > > Cheers, > > > > Dan- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
