fusion table

8/12/2019 Fusion Table

1/18

Google Fusion tip sheets May 2012.

The tip sheets are created by Tommy Kaas for Kaas & Mulvad

Kaas & Mulvad conducts training in Google Fusion.

[email protected]

www.kaasogmulvad.dk

Twitter: @tbkaas

Danish version: http://www.kaasogmulvad.dk/unv/fusion/KM-GF-DK.pdf

Few examples of different types of Google Fusion maps:

Wikileaks coverage in Guardian:

http://www.guardian.co.uk/world/datablog/interactive/2010/oct/23/wikileaks-iraq-deaths-map

Age distribution in Danish municipalities use of Google pie charts in the info windows:

http://www.google.com/fusiontables/DataSource?snapid=S269204PnI7

Same type of map but slightly more advanced pie charts and legends in the info window:

http://bit.ly/yBKG8O

Example of two maps combined with the help of tableslayerbuilder:http://kaasogmulvad.dk/unv/fusion/layerbuildertest.htm

Example of a map with an integrated legend:

http://bit.ly/IEdNE0

Example of a map where table tags are used in the info window etc.:

http://bit.ly/yGWJ8J

And a very advanced example of Fusion Tables maps from Chicago Tribune:

http://media.apps.chicagotribune.com/chicago-census/index.html
mailto:[email protected]://www.kaasogmulvad.dk/http://www.kaasogmulvad.dk/http://www.kaasogmulvad.dk/unv/fusion/KM-GF-DK.pdfhttp://www.kaasogmulvad.dk/unv/fusion/KM-GF-DK.pdfhttp://www.kaasogmulvad.dk/unv/fusion/KM-GF-DK.pdfhttp://www.guardian.co.uk/world/datablog/interactive/2010/oct/23/wikileaks-iraq-deaths-maphttp://www.guardian.co.uk/world/datablog/interactive/2010/oct/23/wikileaks-iraq-deaths-maphttp://www.google.com/fusiontables/DataSource?snapid=S269204PnI7http://bit.ly/yBKG8Ohttp://bit.ly/yBKG8Ohttp://kaasogmulvad.dk/unv/fusion/layerbuildertest.htmhttp://bit.ly/IEdNE0http://bit.ly/yGWJ8Jhttp://bit.ly/yGWJ8Jhttp://media.apps.chicagotribune.com/chicago-census/index.htmlhttp://media.apps.chicagotribune.com/chicago-census/index.htmlhttp://media.apps.chicagotribune.com/chicago-census/index.htmlhttp://bit.ly/yGWJ8Jhttp://bit.ly/IEdNE0http://kaasogmulvad.dk/unv/fusion/layerbuildertest.htmhttp://bit.ly/yBKG8Ohttp://www.google.com/fusiontables/DataSource?snapid=S269204PnI7http://www.guardian.co.uk/world/datablog/interactive/2010/oct/23/wikileaks-iraq-deaths-maphttp://www.kaasogmulvad.dk/unv/fusion/KM-GF-DK.pdfhttp://www.kaasogmulvad.dk/mailto:[email protected]


2/18

Kaas & Mulvad | 03-05-12 | Google Fusion| Import of data

MEMO

1

What Why How

Google Fusion Tables is Googles answer to database-tables in thecloud. You can upload tables to Fusion and merge them with othertable-data. You can visualize data and embed the result on awebsite.

www.google.com/fusiontables

Who canuseGoogleFusion

You must have a Google-account. Ordinary Google Fusion mapsare free to use. If you build advanced maps (with use of API) youwill have to pay, if you have more than 25.000 pageviews in 90consecutive days.If youre below that, its free too.

Upload atable

You can upload from Google Spreadsheet or directly from yourown computer. You can upload tables from a number of differentfile formats (including excel and csv) (max 100 MB).Theres a limitright now on max 400.000 cells in a fusion-table.Make the analysis of data beforeuploading, so youre sure ofwhat you want to display in Google Fusion.

Editcolumns

Normally its necessary to modify columns to be sure GoogleFusion uses them in the right way. It can be text, numbers, dates,locations. Location is the format for geocoding in Google Fusion,meaning this is what Google use to display dots or areas on amap.

Change formats under Edit

Chooserightformat

Google can easily read an address as a location. Then write theaddress in one single cell with a comma, as:

When address-data is imported, chooseGeocode under File.

If you already have latitude and longitude in the data, you canhave them in 2 columns or write them in one field with a comma,as:

This is a result of the geocodingenof the address:

Sharetable

To make visualizations visible you need to share. Choose shareand decide the level of visibility. If you want to make a map tosend or embed on a web site you need to make it accessible.

1
http://www.google.com/fusiontableshttp://www.google.com/fusiontableshttp://www.google.com/fusiontables


3/18

Kaas & Mulvad | 03-05-12 | Google Fusion| Import of data

MEMO

2

MakeView

The uploaded table is the basic. If you only want to give othersaccess to part of the table, you can do it under File and CreateView.

(If you find a public table, you can create a view of this table andmake your own vixualizations.)

Remove the acceptancefor the fields, you dont want to share andhide the view under a new name. You can choose to share thisnew view and not the original table as described above.

ExportfromFusion

Under Fileyou can chooseExport from here you can save asa csv-fil. If you find a public table on the web, you may be able toexport the data.

Createoverview

When you upload tables you will be able to see the headlines infusion and in Google Docs. You will also be able to see other infoon the content. You can delete a table by clicking the x. If youwant to change then open the table and click onModify table info. Be sure to name tables so it is easy by the name to identify thecontent.

Seetablesfromotherpeople

You can search and find public tables in the Fusion Tables publictable search:

http://www.google.com/fusiontables or

http://www.google.com/fusiontables/search

2
http://www.google.com/fusiontableshttp://www.google.com/fusiontableshttp://www.google.com/fusiontableshttp://www.google.com/fusiontables/searchhttp://www.google.com/fusiontables/searchhttp://www.google.com/fusiontables/searchhttp://www.google.com/fusiontables/searchhttp://www.google.com/fusiontables/searchhttp://www.google.com/fusiontableshttp://www.google.com/fusiontables


4/18


5/18

Kaas & Mulvad | 30-04-2012 | Internet | Google | Create maps from data in Google Fusion Tables

MEMO

2

We want to change the info window.We dont need coordinates, andwe may want a text which explans that the number is a population.Itseasy to fix.

Configure

infowindow

Automatic is the default showing of all content. If you want to decide what should be visible,choose Custom. Well do that now:

You can write your own text, and you can use information from the dataset. For example if you wantto insert the name of the municipality, just write {kommunenavn} the name of the field. And if youwant to insert the population, just write {2010} the header row of the population field. The curlybraces are necessary if fusion is to understand that we refer to fields from the dataset.In the column at the left we are reminded of the names of the header rows its easy to forget When you doubleclick on a name, it will jump into the box at the right.I only write
when I want a new line.

When you are done, youll save and close this window.And you must now click on the map andcheck if everything is satisfactory.

In this case it looks good. The text appears on two lines, because I insertedthe code for linebreaks
. Else all text would have appeared on onesingle, long line.

Size The info window has a fixed size, but its possible to write a code that willchange the size of the window. For example:

4


6/18


MEMO

3

The lines has to be the first and the last line in the box. Change the numbers

and youll change the size of the info window (in pixel) Design Use common html code to change the design. For example:

This text will be boldbold This text will be italicitalic

Insertpictures

This code will get and in the info window show a picture file:You can choose to replace parts of this address with a reference {} to a filedin the table where the name of the picture may be placed.

Insert links To insert link in the info window:

Click this textA blue link will appear:Click this text which will lead to the site.

Or we can in the construction of the link write a reference to a field in thetable.This is useful if you for example have a company ID as one of the fields, andyou want to create a link in the info window which makes a live query in adatabase (or perhaps a query in Google).

Another idea: If you have a field with the lat, long coordinates, you could inthe info window create a link which gives acces to Google Street View.

Changeicons

Default we get red circles on the map. But we can change this.Under Configure styles just above the map its possible to change allicons to another type. Or we can let a value in the dataset reflect the colors.

Its alts possible to write the name of the icon the specific address shouldappear as. We have a list of icons to choose from.

(Click on the icon to read its name.This name should be written in thedataset).http://www.google.com/fusiontables/DataSource?snapid=99003

If we use this solution, we mustchoose Column under Configure stylesog tell Fusion which column contains the name of the icons.

5
http://www.google.com/fusiontables/DataSource?snapid=99003http://www.google.com/fusiontables/DataSource?snapid=99003


7/18


MEMO

4

Embed You can choose to distribute the map link to others, but maybe you want toshow the map as a part of another site. In that case you need theembeddable link.Click this (just above the map):

Copy the entire code:

You can paste this code, if you perhaps write a blog entry etc.The two first numbers controls the size of the map on you blog page.Remember, that your own page or cms can give some limitation and youmust change and adjust the code until the layout and design is satisfactory.

Full screenmap

If you want to show the map as a full screen without any kind of menues,you can still use the embeddable link, but take only the part I have showedin italic in the example below this text:

You can change thecentre of the map (thelat,long) and the zoomlevel (the number afterz=)

6


8/18

Kaas & Mulvad | 1.5.12 | Internet | Google | Create maps based on polygons in Google Fusion

MEMO

1

Hvad Hvorfor Hvordan

Understandpolygons Unlike points, a polygon is an area on a map - typically a postaldistrict, a municipality, region or even a country. Different types ofmap applications define polygons in different ways. In Google Fusiona polygon is built up as a kml file.The kml file is a file made up of a large number of points - eachdefined by a longitude and a latitude. The points is in fact a very longrow, which together form the outline of the polygon. There may beseveral separate polygons that together are grouped together into asingle polygon - for example, a municipality that has one or moreislands.Therefore do not be surprised that a table with municipal polygonsmay have more rows than the total number of municipalities.

In the Fusion-table youllfind the polygon in onesingle field. It will typicallylook like this:

Get accessto polygons

You can be lucky that someone has already imported the requiredpolygons to Google Fusion and made the result public. You can trysearching for the polygons in the search box.

Find the search field here:google.com/fusiontables

Get accessto polygonsvia shapefiles

You can find the polygons on the web. National authorities may ormay not have created polygons for regions, municipalities, postcodesetc. Very often they will appear as "shape files"Shape File is a vector data format developed by the company ESRI.

If an authority uses the map application ArcView, they work withshape files. These are easy to convert to kml and Google Fusion.Just ask authorities whether they will share their shape files withyou.

Example from Denmark:Free shapefiles from theauthoritites:

http://www.kms.dk/Produktkatalog/DAGI/

onvertshape files

There are several places you can convert shape files to kml - a sitewhich is easy to use is shpescape.com. You make sure that yourshape file (which is actually a folder with several files) is located in afolder that is zipped. Upload it at shpescape.com. You give the sitepermission to access your Google Fusion account. And the convertedfile will appear in your list of Google documents when it is ready.Be aware that it may take some time. Sometimes there is a queue,and if it is a very big shape file you work with, it can also take sometime to get it converted.

http://www.shpescape.com

Its necessary to pressGrant access if theconversion is going towork:

Othersources

Do you work with maps of foreign countries, this site is a good sourcefor free shape files. For each country youll typically find two to fourdifferent administrative boundaries.(Counties, municipalities etc)

http://www.diva-gis.org/gdata

Find theresult

When the shape file is imported, shpescape.com will show a link youcan click and you are automatically transported to your own list ofGoogle documents, where a table with all data from the polygonsnow can be found.

7
http://www.kms.dk/Produktkatalog/DAGI/http://www.kms.dk/Produktkatalog/DAGI/http://www.shpescape.com/http://www.shpescape.com/http://www.diva-gis.org/gdatahttp://www.diva-gis.org/gdatahttp://www.diva-gis.org/gdatahttp://www.diva-gis.org/gdatahttp://www.diva-gis.org/gdatahttp://www.shpescape.com/http://www.kms.dk/Produktkatalog/DAGI/http://www.kms.dk/Produktkatalog/DAGI/


9/18

Kaas & Mulvad | 1.5.12 | Internet | Google | Create maps based on polygons in Google Fusion

MEMO

2

Usepolygons

Polygonfiles can be visualized itself as a map, but its notthatinteresting until you combine the map with values. One of the fieldsin the polygon table typically contains a code it could be an ID ofthe county, municipality etc.

The dataset you want to visualize must contain the same ID so youcan merge the two datasets.

ombinedatatablewith polygontable

Remember the name (or copy the link) of the polygon table. Typicallyyou will have the data table open and press Merge.

In the window at the left hand side, you will see the fields of thetable you have open at the moment. At the right you can see thefields of the polygon table you want to merge into the data table.Its now very important thatyou with the mouse choose which ID thetwo tables have in common. In this example (Danish municipalities)the common field is an ID. The ID will be the zipper which willmerge the two tables securely together. Through Select subset Ican choose exactly which fields which will go into the new table Imabout to create.Ill give the new table a name and press Mergetables.

8


10/18

Kaas & Mulvad | 1.5.12 | Internet | Google | Edit the design of polygon maps in Google Fusion

MEMO

1

What Why How

Morepossibilitites In the case of polygons, one can select to color them in various ways.The color of the area may reflect a property / quality - eg victory toleft wing or right wing politicians.It may also be that the color should reflect a value in a subset of data- the more bankruptcies, the darker colors.

Find yourangle

Regardless of what the possibilities are, it's important what you wantto visualize what the journalistic angle?

Kend dinedata

Before the visualization you should study your data carefully. Whichfield in the dataset do you want to use when coloring the map? Whatis the highest / lowest value in the column? Are all the valuesclustered within a narrow range, or are they spread much? It mayhave some bearing on how the intervals will look like.

Visualize thedata

Press Configure styles and start. A dialogue box will appear:

Rember to click underPolygons or nothing will happen.Do you want to color the map, then start withFill color. You have four choices:

hoose themethod

Fixedgives one color for all polygons.Columnis useful if thedataset in one specific column has a colorcode eg #FF0000 whichgives a red color."Buckets" is the way to go if you need intervals. (Remember to setthe lowest and highest value - default is 0 - 100) and you can chooseexactly the color you fancy."Gradient" colors the map - from light to dark - in 8 colors. Againplease remember to fill in the highest and lowest values from yourdataset.Under "Buckets", you can also easily create a smooth color gamut -and it is only under "Buckets" that one can determine the size of theintervals. It may be important if you want to create a legend for yourmap.

Youll find many lists withhexadecimal color codeson the web for examplethis:http://www.december.com/html/spec/colorsafe.html

Legend andexplanation

Unfortunately there is no way to make a legend in the simple type offusion maps, we work with here. A relatively easy solution may be tocreate a small picture with colored boxes and explanation, and thenpaste it above or below the map with a little explanation. See theexample on the right. Se the map live: http://bit.ly/yGWJ8J

There are also other more advanced options to create a legend by abit of programming. See this example:http://www.kaasogmulvad.dk/unv/fusion/dropdown/aeldre.html

9
http://www.december.com/html/spec/colorsafe.htmlhttp://www.december.com/html/spec/colorsafe.htmlhttp://www.december.com/html/spec/colorsafe.htmlhttp://bit.ly/yGWJ8Jhttp://bit.ly/yGWJ8Jhttp://bit.ly/yGWJ8Jhttp://www.kaasogmulvad.dk/unv/fusion/dropdown/aeldre.htmlhttp://www.kaasogmulvad.dk/unv/fusion/dropdown/aeldre.htmlhttp://www.kaasogmulvad.dk/unv/fusion/dropdown/aeldre.htmlhttp://bit.ly/yGWJ8Jhttp://www.december.com/html/spec/colorsafe.htmlhttp://www.december.com/html/spec/colorsafe.html


11/18

Kaas & Mulvad | 30-04-2012 | Internet | Google | Combine maps in TablesLayer Wizard

HUSKESEDDEL

1

Hvad Hvorfor Hvordan

Maps can becombined Sometimes we want to combine maps.Perhaps maps with several typesof icon markers. Or perhaps a map with polygons and a map with icons.Perhaps we would like one map with two different types of infowindows. Or we need a way to let the users search the content of themap.To achieve all this we use the free tool: Fusion Tables Layer Builder.

http://bit.ly/Jsxsoz

An examle:

Limitation

Possibilities

This map was built in Fusion TablesLayer Builder. I have combined twolayers (two maps).

Its possible to combine max 5 layersinto one in this wizard.The information windows will be those designed in each map. You willhave to finish the design of each map in Google Fusion.The wizard cantchange the design of the maps.

If you for instance need more than one type of information windows in a

map, you can divide the points/polygons in several fusion tables andseveral maps. In each map you can design the information windows andlater combine the maps into one map in the wizard.

Preparations Finish the maps. You will be able to change them later. Find the NumericID for each map. Find them underFile and About.

Choose theorder of thelayers

The order can matter. If you want to combine a polygon maps with amap with icons, start with the polygons. In that way the polygons will beplaced underneath the icons. You dont want the polygons to be placedon the top of the icons, as it would be difficult to see color differencesthat way.

The first layer Under Your table idyou write the ID for the first map. If the dropdownmenu nearLocation Columnis grey, pressPut Layer on Map.Choose the Location field in your data. If it is a polygon layer it typicallywill be the field with the KML. If its a map with icons, it will be the fieldGoogle already geocoded. In this map the headline of the field isgeometry.

10
http://bit.ly/Jsxsozhttp://bit.ly/Jsxsozhttp://bit.ly/Jsxsoz


12/18


HUSKESEDDEL

2

When Location Column is chosen, press once againPut layer on map,before the map is visible underPreview.

Two types ofsearches

If the users shall be able to search the content of the map, you have twopossibilities. Text or Select-based search. Text-based search is a free textsearch in a field you specify. Select-based search will give you adropdown menu where you can choose.

When Text-based is chosen, you will specify the column to query and thetext which will be visible in front of the search field.

Example ofselect basedsearch

In this example we choose select-based search. In the field with theheader Resultat in the data, we have three types of Results:

The dropdown below the map will look like this:

11


13/18


HUSKESEDDEL

3

Add anotherlayer

Press Add Layer to add a new layer this will be combined with thefirst. Fill the fields in the same way as you just did with the first.You can combine max 5 layers this way.

Adjust the sizeand layout

Under Edit map you can adjust the size of the map.Use your mouse tocontrol the exactly appearance of the map. Remember to press UpdateMap. The code in the bottom of the page will reflect the changes youdo.

.

Adjust thelayout anddesign

You can adjust a few more things when using this wizard. Which detailsfrom the map do you want visible and should the map be more grey or more colorful.

Press:

To see how the maplooks after yourchanges.

Copy the code In the bottom of the page the code changes reflecting your changes.When you are done, highlight the code and copy it.You can just paste it in a text file, give it a name with the file extension.htm og view it in a browser.Do you want to embed the map in a web site, youll have to do this intwo steps: First make the map. Secondly use iframes in you own site tocreate the hole where you want to view the map.

Example of a map:http://kaasogmulvad.dk/unv/fusion/layerbuildertest.htm

The same map embedded in a site:http://www.kaasogmulvad.dk/nicar12/eksempel-pa-embedded-kort/

The iframe code, we have used in this example, looks like this:

12
http://kaasogmulvad.dk/unv/fusion/layerbuildertest.htmhttp://kaasogmulvad.dk/unv/fusion/layerbuildertest.htmhttp://www.kaasogmulvad.dk/nicar12/eksempel-pa-embedded-kort/http://www.kaasogmulvad.dk/nicar12/eksempel-pa-embedded-kort/http://www.kaasogmulvad.dk/nicar12/eksempel-pa-embedded-kort/http://kaasogmulvad.dk/unv/fusion/layerbuildertest.htm


14/18

Kaas & Mulvad | 5.5.1203-05-12 | Google Fusion| Import of data with latitude and longitude

EXERCISE

1

What Why How

Prepare a file forupload Download the data via the link on the right.Check the content of the file. It is all beneficiaries of farmsubsidy on the island Fyn in Denmark. (3934 records)

Save it on your computer (and make sure you remember where).

http://bit.ly/IoRoYh (Excel spreadsheet)

http://bit.ly/KWC1vw (csv)

Upload the file as atable to GoogleFusion

Give the table a good name. Check field types. Make sure, thatGoogle Fusion understand that lat/long are locations and will beused when the beneficiaries are placed on the map.

www.google.com/fusiontables

Visualize the dataas a map

Lets see what the map looks like.

The design of themap

How do you want the map to appear? Think about which iconsto use and which colors.

You can perhaps give the icons colors, which reflects thenumber in the amountEuroSubsidy column in the dataset.Perhaps:From 0 5000 white5000 10.000 yellow10.000 50.000 orange50.000 100.000 red100.000 200.000 blue200.000 300.000 black

Configure styles

The design of theinfo window

How do you want the info window to appear? Which story doyou want the users to read about each of the beneficiaries?

Configure info window

Get embed code ClickShare- chooseUnlistedand then get the embed-code.Save that in a text file in your project folder.If you have a map you want to show to the rest of the class,please invite [email protected]

13
http://bit.ly/IoRoYhhttp://bit.ly/IoRoYhhttp://bit.ly/KWC1vwhttp://bit.ly/KWC1vwhttp://www.google.com/fusiontableshttp://www.google.com/fusiontablesmailto:[email protected]:[email protected]:[email protected]:[email protected]://www.google.com/fusiontableshttp://bit.ly/KWC1vwhttp://bit.ly/IoRoYh


15/18

Kaas & Mulvad | 5.5.1203-05-12 | Google Fusion| Import of data geocode addresses

EXERCISE

1

What Why How

Download andstudy data Download the Excel-file via the link.Open the document and check the content. The list is the 100largest beneficiaries of farm subsidies in Denmark.

Does it have all the necessary information we need to put it onthe map? Is it structured the right way?

Save it on your computer (and make sure you remember where).

http://bit.ly/IoPVm0 (Excel spreadsheet)

http://bit.ly/IHKqm8 (csv)

Prefare the file forupload to Google

Fusion

If we want Fusion to geocode addresses, we need to merge the complete address into one singlecolumn before upload.

Open your spreadsheet, add another column and use a formula to gather the total address for eachrow.You can for example use this technique:

Change formulas tovalues

Its a good idea to change the formulas you just created. We just want text instead. Do like this: 1) Highlight the column with the formulas.

2) Copy the highlighted area3) Right click in the highlighted area choose Paste special 4) Remember to choose Values in the dialogue box

Upload to GoogleFusion

Give it a good name. Check field types. Check locations.

Geocode theaddresses

Either under files and gecode or just click on visualize and map

Check the result ofthe geocoding

How difficult will it be to fix?

Check the map Look at the map, check some of the beneficiaries. Does it lookright? Are they placed correct?

If necessary Makecorrections byhand

Look at the data in table view. Do you see addresses,highlighted with yellow color? If you do and want to correctthem: Click on the globe symbol at the right hand side of theaddress. Decide where you want the icon to be placed on themap.

Configure infowindow

Work to get a nice view in the info window. Decide what youwant your users to see.

Configure styles Think and work to get the right levels and colors.

14
http://bit.ly/IoPVm0http://bit.ly/IoPVm0http://bit.ly/IHKqm8http://bit.ly/IHKqm8http://bit.ly/IHKqm8http://bit.ly/IoPVm0


16/18

Kaas & Mulvad | 5.5.1203-05-12 | Google Fusion| Info window with links to live queries in external databases

EXERCISE

1

What Why How

Open the fusiontable we created inthe first session

We created a map with >3000 beneficiaries on the Danishisland Fyn. Open it.Notice that every recipient has a so called CVR number(column A in the data set). A CVR number is the general Idnumber for business entities in Denmark.

If you dont haveyour own dataset uploaded, you can use this:http://bit.ly/IrtRHG

If you open this, you have tocreate your own view and openthis.

Create a link toquery in the Infowindow

We want to create a link in the info window we want to takethe CVR id and query the number in the database at cvr.dk.Check with a CVR from the dataset.

Put the number in the search field and check the URL:http://www.cvr.dk/Site/Forms/PublicService/DisplayCo

mpany.aspx?cvrnr=25952642

Use this info and construct a link that will take any CVR numberand build a working URL.

uild a similar linkthat creates aGoogle search forany beneficiary

Try a simple query in Google maybe your own name. Checkhow Googles URL is constructed.

Use that knowledge and construct a link, you can show in theinfo window and which lead to a search for the name of thebeneficiary in Google.

15
http://bit.ly/IrtRHGhttp://www.cvr.dk/Site/Forms/PublicService/DisplayCompany.aspx?cvrnr=25952642http://www.cvr.dk/Site/Forms/PublicService/DisplayCompany.aspx?cvrnr=25952642http://www.cvr.dk/Site/Forms/PublicService/DisplayCompany.aspx?cvrnr=25952642http://www.cvr.dk/Site/Forms/PublicService/DisplayCompany.aspx?cvrnr=25952642http://bit.ly/IrtRHG


17/18

Kaas & Mulvad | 5.5.1203-05-12 | Google Fusion| Create a map with polygons Farm subsidies in Denmark

EXERCISE

1

What Why How

Prepare a file forupload Download the data which for each of the 98 municipalities inDenmark has the ID, the name of the municipality and theamount of Farm subsidies received by beneficiaries with anpostal address somewhere in the municipality.

http://bit.ly/IJNQVr (Excel spreadsheet)

Upload the file as atable to Googleusion

Upload it check the import. Does it look ok? docs.google.com

ind the polygontemplate

Search for a public fusion table, called danske kommuner Open it and check, that the column with the ID in both tableshave the same datatype (check in Edit - Modify columns)

www.google.com/fusiontables/

Merge the tablesinto one

Copy the url of the polygon table.Open your own data table in fusion.Merge into a new table save under a new name.Make sure that the common key (the municipality ID) arechosen in both tables.

Visualize the dataas a map

Open your new merged result and visualize it as a map. Colorthe municipalities to reflect the amount received.Think about how the map best communicates the story andyour angle.

Configure styles

The design of theinfo window

If you have time work with the content of the info window. Configure info window

Share Share with [email protected] then I will be able toshow your map for the class.

16
http://bit.ly/IJNQVrhttp://bit.ly/IJNQVrhttp://www.google.com/fusiontableshttp://www.google.com/fusiontableshttp://www.google.com/fusiontables/http://www.google.com/fusiontables/mailto:[email protected]:[email protected]:[email protected]:[email protected]://www.google.com/fusiontables/http://www.google.com/fusiontableshttp://bit.ly/IJNQVr


18/18

Kaas & Mulvad | 5.5.1203-05-12 | Google Fusion| Combine two maps into one with the layerbuilder wizard

EXERCISE

1

What Why How

The exercise If you have followed the previous sessions you should now haveat least two Google fusion maps:1) A map with icons all beneficiaries on the Danish island Fyn2) A map with polygons showing Danish municipalitiesThe exercise is to combine the maps into one single map,showing both municipalites and icons.

If you dont have your own maps,you can use these instead:Icons: http://bit.ly/IrtRHG

Polygons: http://bit.ly/JYdwxY

If you do this, you must createyour own views of the tables andfind the IDs of those views anduse them the exercise.

Open the

tablelayerbuilderwizard

Use the instruction in the memo and combine the two maps. The wizard:

http://bit.ly/Jsxsoz

reate a map When you are done, designing the new map , copy the code inthe lower part of the page to a simple text file Notepad orsimilar and save it under the name map.htm on yourcomputer.If you use mac you might have to use get an application likeTextWrangler or similar.

TextWrangler:http://bit.ly/J18cad

heck the map Open your map in a browser and check it design andfunctionality.

Experiment If you have time, try some more try the search boxes.Or find public tables and combine them. (Then you might haveto create your own wiews first)

Share Share with [email protected] then I will be able toshow your map to the class.

17
http://bit.ly/IrtRHGhttp://bit.ly/IrtRHGhttp://bit.ly/JYdwxYhttp://bit.ly/JYdwxYhttp://bit.ly/Jsxsozhttp://bit.ly/Jsxsozhttp://bit.ly/J18cadhttp://bit.ly/J18cadmailto:[email protected]:[email protected]:[email protected]:[email protected]://bit.ly/J18cadhttp://bit.ly/Jsxsozhttp://bit.ly/JYdwxYhttp://bit.ly/IrtRHG

fusion table

Documents