WordPress Google Maps GPX Plugin
Fusion tables is a new (beta) service by google. You can create tables containing geo information and show them inside a map.
This fusion table, for example, contains geolocation information about nuclear power plants worldwide.
[map fusion="685286" address=Salzburg z=4]
ShortCode: address=Salzburg and z=4 gives us an european viewport.
Here we extend the ShortCode to get an entire view off all nukes. The plugin has calculated the viewport automatically. The table must contain selectable geo information, in this case it is the “Location” field.
[map fusion="685286; 'Location'"]
This query shows nukes located in germany only.
[map fusion="685286;Location;Country = 'Germany'"]
Query Fusion Tables using SQL syntax
Don’t be worry, the plugin will calculate the SQL query out of your ShortCode. Here is a short explanation of how it works.
fusion=”<table id>”
This gets the geo information from “<table id>”, will not center the map or calculating a viewport. The only condition is, the fusiontable must have a column that contains geo information like addresses, latitude-longitude values or kml data.
fusion=”<table id>;<column>”
This expands the query by a “column” containing geodata e.g. addresses, latitude-longitude values or kml data containing a coordinates tag. If the request will return geodata, the plugin tries to calculate a viewport.
fusion=”<table id>;<column>;<condition>”
Additional query condition to get a closer viewport e.g. “Country =’ Germany’”. This example will send the following SQL request using google fusion layer.
SELECT <field> FOM <table id> WHERE <condition>
How to get a Fusion Table?
There are several ways to get a Fusion Table to meet your needs. One is a search on “Google Fusion Tables”, here you’ll find thousands of public tables. On the other hand, to build your own FusionTable is really simple, all you need is a free Google account. After that, take the “create table (beta)” button, thats all.
Create a new table or upload spreadsheets, delimited text files (.csv, .tsv, or .txt), and Keyhole Markup Language files (.kml).
What else you should know
Fusion Table visibility option must be public or invisible.
There are some limitations on queries calculating a viewport.
A request can return max. 500 results.
A request on addresses delivers max. 10 value pairs.
You may visit the following resources: