Multiple Items With Same Location Fix - "Spidering" of Overlapping Markers

[GoogleCodeExporter]

Currently if there are multiple items with the same location, only one blip and 
result will show, and the others are disregarded. 

Unfortunately, the only workaround I've found is to add latitude and longitude 
data with slightly different values.

I think the blip should be able to incorporate multiple entries with a scroll 
feature.

Original issue reported on code.google.com by testdvlp...@gmail.com on 30 Oct 2010 at 2:01

[GoogleCodeExporter]

9 votes from prior feature tracker: 
"If 2 rows have the same location, only one placemark is visible, which means 
the data for one of the rows is hidden. Try to create a solution that will 
display all the data for that location."

"A way to indicate multiple records that share the exact same lat/long (instead 
of having them stacked on top of each other)--perhaps multiple markers that fan 
out or some numeric indicator?"

Original comment by rshap...@google.com on 6 Nov 2010 at 12:33

• Changed state: Accepted

[GoogleCodeExporter]

This is a bit of bookkeeping for all our feature requests - please excuse the 
extra email. 

Original comment by rshap...@google.com on 13 Jan 2011 at 9:21

• Changed state: Acknowledged

[GoogleCodeExporter]

Issue 327 has been merged into this issue.

Original comment by kbris...@google.com on 24 Feb 2011 at 10:22

[GoogleCodeExporter]

A tabbed infowindow could be good for this.

Original comment by mercy.re...@gmail.com on 24 Feb 2011 at 10:40

[GoogleCodeExporter]

Also would like markers stacked one on the other to be moved randomly in some 
tiny direction maybe? And have the ability to turn this on or off.

Original comment by kat...@gmail.com on 12 Apr 2011 at 4:31

[GoogleCodeExporter]

Issue 434 has been merged into this issue.

Original comment by rshap...@google.com on 18 Apr 2011 at 10:35

[GoogleCodeExporter]

it'll be cool if this application allows as an option to automatically slighly 
vary the location so that the same location is shown multiple times

Original comment by nestor.a...@fanucfa.com on 12 May 2011 at 8:08

[GoogleCodeExporter]

What happens with KML Layers with the same data?

Original comment by Jeremiah...@gmail.com on 17 May 2011 at 2:17

[GoogleCodeExporter]

@Jeremiah...@gmail.com, KML loads points onto the map in the client browser, so 
you can use various js clustering methods available. But for large numbers of 
points, loading is dreadfully slow. FusionTables is a fix for speed, since the 
points are baked into the map tiles, but then you lose clustering.

Original comment by baynatur...@gmail.com on 17 May 2011 at 4:10

[GoogleCodeExporter]

Stacked Markers on the same location would work for me, but disregarding the 
rest is really quite awkward.

But thanks for what we have so far.

Original comment by galloma...@gmail.com on 8 Jul 2011 at 8:21

[GoogleCodeExporter]

Same problem here for me. I need to show contact history as a sequence of 
events for the same location. It is important to be able to show how issues 
that first arose are being dealt with. I had already thought of slightly 
varying the coordinates, so that each entry becomes in fact a different point 
feature, and this could work if I up the resolution to house & street 
addresses, instead of towns & villages.

Alternatively, if the "bucket" feature could be set to relent and post 
different styles of markers for different entries of the same location, that 
could also work. Perhaps the differentiation could be teased apart based on 
date & time stamp of individual entries for the same location? Thinking out 
loud.

Original comment by thegitk...@gmail.com on 12 Jul 2011 at 3:49

[GoogleCodeExporter]

I've seen, (I think on Batchgeo.com maps), that when the bubble pops up there 
is a next link on the bottom right so I can click through each item w/in that 
location.

This would be very handy as all the items in my 5000+ table are listed by town 
and state, no specific address.
Thanks!

Original comment by albin...@windsorone.com on 20 Jul 2011 at 7:40

[GoogleCodeExporter]

Thanks for providing this feature.

Original comment by tvk66...@gmail.com on 22 Jul 2011 at 4:16

[GoogleCodeExporter]

Issue 689 has been merged into this issue.

Original comment by rshap...@google.com on 3 Aug 2011 at 3:23

[GoogleCodeExporter]

Original comment by rshap...@google.com on 12 Aug 2011 at 11:30

• Added labels: Tag-Geo

[GoogleCodeExporter]

I really like the way batchgeo.com manages this and would like to see something 
similar without having to resort to a third party.

Original comment by shso...@gmail.com on 17 Aug 2011 at 5:39

[GoogleCodeExporter]

I really like the way batchgeo.com manages this and would like to see something 
similar without having to resort to a third party.

Original comment by shso...@gmail.com on 17 Aug 2011 at 6:19

[GoogleCodeExporter]

5518 records for 41 locations...can't make it work in Fusion Maps. Data happens 
more than one time at the same place quite often for most of the world, 4'th 
dimensional (over time) data such as sightings of something (esp for 
naturalists and government officials) etc. FT is a great product, esp 
considering the spatial data query architecture it has built into it, but it 
only seems to handle single event data. I'd like to see more robust data 
handling put in place so that we can use our multiple event/same location 
datasets with it. 

Original comment by lash.e...@gmail.com on 21 Aug 2011 at 6:50

[GoogleCodeExporter]

Same problem. Trying to use Fusion Tables, but overlapping points don't show.

Original comment by gabe.eco...@gmail.com on 23 Aug 2011 at 5:07

[GoogleCodeExporter]

Issue 759 has been merged into this issue.

Original comment by rshap...@google.com on 25 Aug 2011 at 2:14

[GoogleCodeExporter]

below

Reported by sid.mur...@gmail.com, Dec 13, 2010
 What new feature would you like to see implemented? How will you use it?

Allow fusion tables/mapping to have a clustering option.

example:
http://loxcel.com/sbux.html 

 Comment 1 by lookiwas...@gmail.com, Dec 25, 2010it would be awesome if a simple function to decide how to do the clustering could be provided.

 Comment 2 by project member rshap...@google.com, Jan 18, 2011Hi - Is this request distinct from the following two requests about the heat map feature?  

http://code.google.com/p/fusion-tables/issues/detail?id=85
http://code.google.com/p/fusion-tables/issues/detail?id=68

If so, please add more details about what you have in mind. Thanks!

-Rebecca

 Status: Please-Clarify

Comment 3 by lookiwas...@gmail.com, Jan 25, 2011Apologies I did not see this 
before. About my comment (#1) I am not very sure it match in the other two 
request. Although it is true that the request looks very similar I was looking 
forward to implement marker-clustering in a way that:
- markers do not overlap in the map
- marker icons changes the icon depending on how many other markers are being 
hidden (under the marker that represents them)
- markers are tile-able. As the markers do not overlap (point 1), putting 2 
markers together will give the illusion that there are many.

The current implementation of google does not respect point 1. Using the bucket 
option could helps implement the other 2 points.

I can send a file if you want to show this working.

Back to the other request:
85 - I think they want to see numbers, not only colors
68 - or it makes no sense to me (density of colors represent number of markers 
in an area) or I am missing something and I dont understand the request (maybe 
a marker has some "intensity" value attached to it and it is used for the 
average that computes the color. In this case, a line showing the contour of 
the markers could "fix" the issue/request).

Sorry if I cannot be of more help but I have not worked much with heat-maps.

Thanks!

 Comment 4 by project member rshap...@google.com, Jan 25, 2011Thanks for the additional details!

 Status: Acknowledged

Comment 5 by project member kbris...@google.com, Feb 22, 2011 Issue 323  has 
been merged into this issue.

 Comment 6 by project member rshap...@google.com, Mar 17, 2011 Issue 372  has been merged into this issue.

 Comment 7 by project member rshap...@google.com, Mar 29, 2011 Issue 391  has been merged into this issue.

 Comment 8 by project member rshap...@google.com, Mar 29, 2011 Issue 392  has been merged into this issue.

 Comment 9 by kat...@gmail.com, Apr 12, 2011Would be good to have the option to cluster the markers via a checkbox option similar to heatmapping

 Comment 10 by project member rshap...@google.com, Apr 26, 2011 Issue 452  has been merged into this issue.

 Comment 11 by project member rshap...@google.com, Apr 28, 2011 Issue 454  has been merged into this issue.

 Comment 12 by scouts.N...@gmail.com, May 3, 2011I would love to know if anyone knows anything about how to cluster in google fusion!?!?!!?!?

 Comment 13 by gla...@gmail.com, Jul 14, 2011Such a feature would greatly improve my quality of life at the moment. 

 Comment 14 by robinkr...@gmail.com, Jul 14, 2011This isn't a perfect solution and requires more work than Fusion Tables, but previous commenters might want to check out MarkerClusterer for Gmaps v3. I'm using it along with Fusion Tables $.get queries (returning JSONP objects) to handle adding markers to the map.

Check it out:
http://google-maps-utility-library-v3.googlecode.com/svn/trunk/markerclusterer/d
ocs/reference.html

I ended up adapting this example to my needs:
http://google-maps-utility-library-v3.googlecode.com/svn/trunk/markerclusterer/e
xamples/speed_test_example.html

All this said, I would love to see clustering built into Fusion Tables! Queries 
+ MarkerClusterer are much more work.

 Comment 15 by gla...@gmail.com, Jul 27, 2011Robin: would it be possible for you to give us a link to a functioning example that uses a $.Get query with Fusion tables to add markers to a Google Map? I have been struggling with this for a while and I can't seem to find the problem. 

Thanks!

 Comment 16 by robinkr...@gmail.com, Aug 10, 2011Sorry about the delay. At least it gave me time to flesh out a full blogpost with sample code! Check it out:

http://www.reddmetrics.com/2011/08/10/fusion-tables-javascript-query-maps.html

 Comment 17 by lookiwas...@gmail.com, Aug 10, 2011Sorry if this is an stupid comment (have not read the post fully), but should
not it be recommended to use spatial_condition if you are working with maps?

From the documentation:

http://code.google.com/apis/fusiontables/docs/developers_reference.html

The example they provide:

SELECT 'Store Name', Pharmacy, Address FROM 292905 WHERE
ST_INTERSECTS(Address, RECTANGLE(LATLNG(37.0242,-122.2806),
LATLNG(37.5242,-121.6806))) ORDER BY Hours

 Comment 18 by robinkr...@gmail.com, Aug 10, 2011It's definitely not a stupid comment - you point out a hole in my post. It just didn't occur to me - I already have the coordinates stored in the table, and I haven't needed a spatial query.

The main point of my post was to show how to run the query with Javascript, and 
then show how to handle the  results programmatically. I sometimes forget that 
not everyone will have coordinates stored in their table.

 Comment 19 by project member rshap...@google.com, Aug 12, 2011(No comment was entered for this change.)

 Labels: Tag-Geo

Delete comment
Comment 20 by prblock-...@yahoo.co.uk, Today (3 minutes ago)Hi I am a novice 
with maps and know nothing about JScript/KML etc.   Basically I am a volunteer 
in a local History Centre and want to plot the 6000+ images they have on a map. 
 I have a Fusiion table with postcoded and geocoded data and links to 
thumbnails and it works very well for single plots BUT where I have several 
images of the same building/scene, but taken at different times, I only get one 
marker and only one set of fields in the pop up.  Ideally I would like the pop 
up to indicate the number of images for the plot and the ability to move 
between them.  I can do this in batchgeo.com 
(http://batchgeo.com/map/352fd85c79c2f003d99f8e925540bfb6) but they limit the 
number of plots to 2500 and the History Centre can't afford to pay for their 
Pro service. So I would really like Fusion to be enhanced as soon as possile.  

Original comment by webmas...@epsomandewellhistoryexplorer.org.uk on 1 Sep 2011 at 5:08

[GoogleCodeExporter]

Original comment by rshap...@google.com on 12 Sep 2011 at 10:18

• Added labels: Component-Geo
• Removed labels: Tag-Geo

[GoogleCodeExporter]

Issue 891 has been merged into this issue.

Original comment by rshap...@google.com on 12 Oct 2011 at 12:45

[GoogleCodeExporter]

I'm plotting the town of birth of various historical figures in 19th century 
France. Paris, for instance, shows up as a single dot rather than the 600 
instances for which I have data. So a cluster feature is urgently required for 
me too! 

Original comment by alistermill on 30 Oct 2011 at 4:15

[GoogleCodeExporter]

I'm not sure if my request is the same as what everyone else is requesting. I 
think it would be nice to be able to see multiple items under the same 
locality. 
1) Google Earth does this by having multiple lines  pop out of the same 
location, and each line has a clickable marker
2) Arctos Berkeley mapper does this by having "<-- Record x of y -->" somewhere 
in the pop-up, and have <-- link to previous data point with the same locality 
while --> link to the next data point with the same locality

Original comment by lily...@gmail.com on 21 Nov 2011 at 11:04

[GoogleCodeExporter]

I try to show the destinations of our science missions, and many of them have 
the same destination. I need to show in this case, several markers on the same 
location (such as a city for example). A slight shift points would be a plus or 
if a single point, when you click it, several window opens for the different 
missions.

Original comment by pier...@gmail.com on 7 Dec 2011 at 4:26

[GoogleCodeExporter]

For what it's worth, padmapper.com (which is powered by googlemaps) does a 
pretty good job of fanning multiple points when you click a cluster.

Original comment by james.la...@gmail.com on 11 Jan 2012 at 9:57

[GoogleCodeExporter]

Polygons!
And yet another use case: when the same overlapping polygons are shown on map, 
there's just one result per click. Ideally there would be as many results as 
the "drill down" cick matches all occurences.

Original comment by rafro...@gmail.com on 6 Mar 2012 at 6:33

[GoogleCodeExporter]

Original comment by rshap...@google.com on 30 Mar 2012 at 12:42

• Changed title: Multiple Items With Same Location Fix - "Spidering" of Overlapping Markers

[GoogleCodeExporter]

While mapping high schools and colleges by city and state I only get one 
location mapped. Having each rows displayed as a map location would be ideal.

Original comment by mike.av...@gmail.com on 12 Apr 2012 at 11:30

[GoogleCodeExporter]

I found a quick way to update the lat and or long to display the different item 
next to each other using google refine (as it is the most recommended 
workaround that does not involved using the API). I've documented the process 
here: 
http://googlerefine.blogspot.ca/2012/04/fusion-table-map-multiple-to-item-with.h
tml

Hope this will help the community.

Original comment by Martin.M...@gmail.com on 13 Apr 2012 at 12:54

[GoogleCodeExporter]

I certainly want a way to click on a location (say a house) then select from a 
list to get the data I want.  For example the HOUSE might have a 
Mom/Dad/Daughter/Son all living at the same place.  I would imagine a popup 
list. Select a person to get the traditional information balloon about that 
person.

Original comment by pstop...@gmail.com on 13 Apr 2012 at 9:29

[GoogleCodeExporter]

Issue 1099 has been merged into this issue.

Original comment by rshap...@google.com on 11 May 2012 at 11:16

[GoogleCodeExporter]

I am recording the occurrence of plant species in Tuscany, Italy, with Fusion 
Tables. As more than one species occurs at a given location, the markers 
overlap and users may access only the top one. I would love to have a 
"spidering" effect on mouseclick or on mouseover, to make users aware of each 
overlapping occurrence.
For the moment, I have manually altered the coordinates of overlapping points, 
so to stagger their markers by a few meters; but besides being awkward, this 
solution is visually inadequate, because staggering is visible only if the 
scale is set to high values, with consequent loss of the general picture.
With spidering markers, users would be able to appreciate overlapping records 
at low scale, while still maintaining the ability to view the general picture.
Thank you for your attention,
GB

Original comment by gibed...@gmail.com on 5 Jun 2012 at 6:40

[GoogleCodeExporter]

It would be great if some of the features from Batchgeo.com were available in 
Google. Such as a legend without the user creating one themself and markers 
stacked on top of one another so they user can manually move them aside.

Original comment by elin...@gmail.com on 29 Sep 2012 at 9:15

[GoogleCodeExporter]

in addition to the cluster idea, zeemaps also has a feature where you can plot 
the point on the map manually, by simply clicking on the map the general 
location that the pin belongs.  

Our location data consists of zip codes (not exact addresses) - so if we could 
click on the map based on the zip code boundaries, that would solve our issue 
faster!

Original comment by k.bach.m...@gmail.com on 2 Oct 2012 at 5:54

[GoogleCodeExporter]

I was trying to make a map that showed radio stations in a particular market 
(city, town etc...). I really wanted the info window to display a list of all 
the stations from one location and the solutions being described here using 
closely clustered markers didn't really cut it. Having to zoom in and click on 
each individual marker was very awkward and defeated my 'info at a glance' 
utility. Then I stumbled on this post about embedding iframes in info windows 
using an event listener: 
https://groups.google.com/forum/?fromgroups=#!topic/fusion-tables-users-group/E1
2ovRgDhYU

Using that I realized I could make a filtered card view with a custom layout, 
publish it as an iframe, then set it up so the original filter variable could 
be replaced using a variable from the script. The result was exactly what I 
needed. A simple list of all the stations in an info window using one location 
marker. This might not be suitable for everyone but it is a decent solution for 
anyone just looking to create a simple list of multiple items from one  marker.

google.maps.event.addListener(layer,'click',function(e) {
    var mrkt = e.row['MARKET'].value;

    e.infoWindowHtml = "<iframe width='225' height='300' scrolling='no' frameborder='no' src='https://www.google.com/fusiontables/embedviz?viz=CARD&q=select+*+from+(MY_MAP_ID)+where+col3+%3D+'" + mrkt + "'+order+by+col3+asc&tmplt=3&cpr=2'>" + "</iframe>";

Original comment by devin.te...@gmail.com on 18 Jan 2013 at 4:36

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Here is the above in action: http://targetbroadcast.com/map_stations_test10.html
Since many of these locations only have one station listed, try clicking on a 
larger city like Toronto, Edmonton, Montreal.

Original comment by devin.te...@gmail.com on 18 Jan 2013 at 5:23

[GoogleCodeExporter]

Devin:   that's super-cool and creative!  I love it. Thanks for posting it 
here.   -Rebecca

Original comment by rshap...@google.com on 19 Jan 2013 at 1:53

[GoogleCodeExporter]

That is very creative! It doesn't work for my purposes, however- because the 
table we are using is constantly being added to/edited, and not static, we 
can't use your embedding trick. We are keeping track of people and their 
interests, and where they live, so we need to be able to see every data point 
on the map, street by street, house by house, person by person! Sometimes 
people live in the same house, so even those data points would need to be 
differentiated for our purposes. Hoping a solution for this is possible!

Original comment by ka...@starfirecouncil.org on 27 Mar 2013 at 2:09

[GoogleCodeExporter]

Issue 1142 has been merged into this issue.

Original comment by rmcch...@google.com on 21 May 2013 at 10:27

[GoogleCodeExporter]

It looks like this issue has been being explored for a while, I just found out 
about this yesterday and it's really a deal breaker that I can't have more than 
one entry for the same location. I am tracking an invasive fish and it is very 
important to see each individual entry. It could possible be a bigger marker 
when zoomed out and separate into a cluster when you close in on it? If this 
were figured out it would make a huge impact on my research and the non-profit 
organization I work with.

Kitty

Original comment by badkitty...@gmail.com on 7 Jul 2013 at 2:26

[GoogleCodeExporter]

Fusion tables would be perfect for plotting where people are in a census, 
except that Fusion tables only plots one instance of a location and ignores any 
other instances in the same location.  So if there are 10 individuals all 
living in the same location, then only one family appears on the map.  

Original comment by Cliff.Gi...@gmail.com on 7 Jul 2013 at 10:36

[GoogleCodeExporter]

You'd need to access data points using the Maps API as opposed to just adding a 
Fusion Table layer, but I've been using MarkerClusterPlus in some projects. 
It's worked great to address some of the issues mentioned above.

Repo: https://github.com/mahnunchik/markerclustererplus
Example: http://projects.scpr.org/static/maps/finding-peace-and-quiet/

Chris K. 

Original comment by Christop...@gmail.com on 8 Jul 2013 at 6:29

[GoogleCodeExporter]

I need to represent multiple entries involving the same location.  Perhaps a 
color intensity indicator would be helpful for this.  

Original comment by kerrygro...@gmail.com on 26 Sep 2013 at 12:51

[GoogleCodeExporter]

Issue 1310 has been merged into this issue.

Original comment by rmcch...@google.com on 27 Sep 2013 at 10:38

[GoogleCodeExporter]

This is my single biggest frustration with Fusion tables - I'm trying to map 
completed projects chronologically but the lack of multiple entries makes each 
location look identical regardless of the fact that there may be 1 or 100 
projects there.  Either the spidering or tabbing ideas would work for my 
purposes.

Original comment by aurodat...@gmail.com on 20 Nov 2013 at 5:58

[GoogleCodeExporter]

I want to visualize many actors on a map. The location for them is a "full 
adress" with street name, number, zip-code etc., e.g. Landhausplatz 1, 3109 St. 
Pölten. Unfortunately many public institutions have this adress. I saw, that 
only one of them is shown on the map, also if I zoom in. What can I do in this 
case?

Original comment by s.p...@mecca-consulting.at on 21 Nov 2013 at 2:11

[GoogleCodeExporter]

I now have tried to use lat lon instead of full adresses. Only if I slightly 
change the values (e.g. the fourth decimal point), the points are shown on the 
map. Do you know a possibility how to geocode a large number (>200) of adresses 
for lat lon and then automatically slightly change the values?

Original comment by s.p...@mecca-consulting.at on 22 Nov 2013 at 10:22