Create thematic maps for map.geo.admin.ch

using google fusion tables and KML Import function of map.geo.admin.ch

What you get: YOUR data shown as in this example

What you need

• tabular data (CSV,XLS) with at least one column with a location reference (eg canton name)
• reference file (KML,SHP etc) eg cantons.kml
• a google account

Prepare your THEMATIC data

Google Spreadsheet with an id (eg “code”)

​

Prepare your GEOREFERENCE data

Google FUSION table (import your SHP or KML file) with an identical id (“code”)

​

For your convenience we made the following reference table available for you (make a copy in google fusion)

• KantoneGeneralisiert (id is BFS Kantonsnummer)
• GemeindeGeneralisiert (id is BFS Gemeindenummer) ,
• PLZGeneralisiert (id is PLZ)

​

​

​

Import THEMATIC Data to fusion tables

in google drive:

- create-> fusion table

Select the THEMATIC spreadsheet

- import it, define a table name (eg Statistics)

- allow exports

​

Add the GEOREFERENCE to the THEMATIC fusion table

in the newly created fusion table (e.g statistics)

use the MERGE function

...select the georeference table...

use the matching id’s (eg code)

- View the merged table at the of the dialog

- change the name of the fusion table name “merge of “x” and “y” since it will be part of the pop up

Merged fusion table switch to “map of geometry” view

Define the COLOR of your data:

Result:

Define the POPUP info

Result: (Tipp using filter you can filter your data)

Export your data as KML...

Import the KML into map.geo.admin.ch

Share the KML to your users

A) Send it by mail and add the instruction on how to ad a local file: http://help.geo.admin.ch/?id=64

​

B) Save the KML on a webspace and embed the KML as URL as shown in http://help.geo.admin.ch/?id=64 and share the map as explained in http://help.geo.admin.ch/?id=52 : map.geo.admin.ch will load with your data

​

C) embed it in your website using the API as explained in http://api3.geo.admin.ch/examples/geoadmin_kml.html of our api3.geo.admin.ch documentation

Bugfixing

The kml generated by fusion table does sometimes not export correct color schemes.

in Fusion in Map.geo.admin.ch/google maps

Import kml into https://www.google.com/mymaps

1. https://www.google.com/mymaps
2. Create new map
3. Import the faulty KML

1

2 import KML

3

Correct KML I

Open individual Styles

Correct KML II

Style by data column

Choose column

Correct KML IIII

Set Color

Set transparency

For each polygon:

Export corrected KML

1. ​

2)

4)

3)