qwerin / fusion-tables

Automatically exported from code.google.com/p/fusion-tables
0 stars 1 forks source link

Request to add "Europe" or "EU" as an Area for Intensity Maps #326

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What new feature would you like to see implemented? How will you use it?

I would like to request that "Europe" as an Area for Intensity Map 
Visualisations be implemented. At present, European Areas are limited to 
"Western", "Northern" and "Southern" Europe, limiting the ability to visualise 
tables encompassing data for the whole of Europe.

Perhaps you are well aware, as I am, this is not as straightforward it sounds. 
"Europe" has several definitions, from the 27 Member States of the European 
Union, to the 41 European Nations of the Council of Europe (from the Irish Sea 
in the West, to the Caspian Sea in the Middle East).

I am particularly interested in an Area visualisation incorporating the 27 EU 
Member States (but would accept a generic "Europe" showing adjacent nations). 
The European Union publishes many statistics related to its 500m citizens, and 
I believe other users would value being able to visualise "Europe"/the European 
Union as a whole.

A more universal solution, is to add zooming and panning features to the 
intensity map visualisation.

Kind regards.

----------------------------------------------------------------------
NOTE: Use this form to suggest new features for Google Fusion Tables
website or API.  For BUGS, please e-mail us at googletables-
feedback@google.com.

Your "star" vote on requests in this issue tracker helps the Fusion Tables team 
prioritize work on the most useful features.

By submitting this form you agree to the Google Terms of Service
(http://www.google.com/accounts/TOS) and the following additional term: In 
addition to the Content license you grant to Google in Section 11 of the Google 
Terms of Service, you agree that Google may, at its option, use your Content to 
provide support for, or to develop, correct or improve Google's current or 
future products and services, without any compensation to you.

Thanks for the suggestion!
----------------------------------------------------------------------

Original issue reported on code.google.com by pparr...@qcea.org on 24 Feb 2011 at 6:50

GoogleCodeExporter commented 9 years ago
Agreed - this issue has previously been forwarded to the Google Visualization 
team. Thanks!  -Rebecca

Original comment by rshap...@google.com on 25 Feb 2011 at 3:29

GoogleCodeExporter commented 9 years ago
Too bad it is not possible yet. It's a bit strange that we can't view Europe as 
an area.

Original comment by cont...@dannyoosterveer.nl on 19 Aug 2011 at 11:14

GoogleCodeExporter commented 9 years ago
Is this so complicated??? Alternative is to use the polygons map and color the 
polygons as a Map display. Please add Continental Europe, and Continental 
America just as you have done for 'All of Africa', if you could 'All of Asia' 
or 'All of Oceania' or any other more general partition would be very useful.. 
thanks!

Original comment by juanleon...@gmail.com on 26 Sep 2011 at 9:48

GoogleCodeExporter commented 9 years ago
Will comment again just in case someone ends up here looking for the 
solution... so they way around it is to get the embeddable code and extract the 
'source' link and change the location manually i.e. 

<iframe width="500px" height="300px" scrolling="no" frameborder="no" 
src="http://www.google.com/fusiontables/embedviz?gco_region=005&gco_dataMode=reg
ions&gco_chartArea=%7B%22top%22%3A%2230%22%7D&containerId=gviz_canvas&q=select+g
vizregion(col9)%2C+col10%2C+col9+from+979894+&qrs=where+gvizregion(col9)+%3E%3D+
&qre=+and+gvizregion(col9)+%3C%3D+&qe=+limit+3&viz=GVIZ&t=MAP&width=500&height=3
00"></iframe>

extract:
http://www.google.com/fusiontables/embedviz?gco_region=005&gco_dataMode=regions&
gco_chartArea=%7B%22top%22%3A%2230%22%7D&containerId=gviz_canvas&q=select+gvizre
gion(col9)%2C+col10%2C+col9+from+979894+&qrs=where+gvizregion(col9)+%3E%3D+&qre=
+and+gvizregion(col9)+%3C%3D+&qe=+limit+3&viz=GVIZ&t=MAP&width=500&height=300

Now change the location for Europe in the '_region=005' bit, in this case 005 
is for South America, the code for Europe is not mentioned but try 150 :D seems 
to work nice... 

Working exapmle:
http://www.google.com/fusiontables/embedviz?gco_region=150&gco_dataMode=regions&
gco_chartArea=%7B%22top%22%3A%2230%22%7D&containerId=gviz_canvas&q=select+gvizre
gion(col9)%2C+col10%2C+col9+from+979894+&qrs=where+gvizregion(col9)+%3E%3D+&qre=
+and+gvizregion(col9)+%3C%3D+&qe=+limit+3&viz=GVIZ&t=MAP&width=500&height=300

Yey! After trying some more codes I found that Oceania: '009' also works (I 
guess there are more codes don't have time to try them all EU and Oceania are 
the only ones that work presuming they have added them already.. enjoy... more 
codes: http://en.wikipedia.org/wiki/UN_M.49 )

Original comment by juanleon...@gmail.com on 26 Sep 2011 at 10:15

GoogleCodeExporter commented 9 years ago
I would prefer a Zoom function in the intensity map. But, so far, what I need 
is a map of Europe as a whole too.

Original comment by davidsot...@gmail.com on 3 Jul 2012 at 5:18

GoogleCodeExporter commented 9 years ago
Regarding the work-around mentioned in Comment 4, this is the table of codes 
you need: 
https://developers.google.com/chart/interactive/docs/gallery/geochart#Continent_
Hierarchy

-Rebecca

Original comment by rshap...@google.com on 3 Jul 2012 at 6:20

GoogleCodeExporter commented 9 years ago
It's nice that someone has come up with a work around, but for someone who is 
not a programmer, there needs to be an easy way to do it without having to 
build your own site.

Original comment by acnicolet on 31 Jul 2012 at 6:11