Sharing:
To let others view this map you need to share it using the “Share” button on the right of the screen there is a share button; click it. You'll see that this table is set to private, so you will have to change it to Unlisted or Public in order to have it viewed in your website.
If all of the addresses were not translated to a map location:
Click the Visualize menu and select "Table"; you'll see the rows that were not translated are still highlighted in yellow. Click the globe icon next to the address and you'll be able to manually search for and select a matching location.
Note: In our example the data from the first two columns latitude and longitude has been used for plotting so the location column is highlighted yellow.
Configure the InfoWindow
Change how the content is displayed in the InfoWindow.
1. Click on Configure info window.
2. Select Custom in the drop-down menu next to Info Window Template:.
3. In the text area under Custom Html, you can enter any HTML and inline CSS to format the InfoWindows. Data from the table can be included by entering the column name surrounded by curly brackets.
4. Click Save.
Embedding Your Map into a Webpage
1. First, change the visibility of the table to Unlisted or Public to embed in a web page. To change the visibility of the table:
3. Copy the HTML code in the text area that is displayed.
Displaying images
Fusion Tables doesn't store images.To display images, enter the URL pointing to the location of the image on the Internet in a cell in Fusion Tables.
To see image thumbnails in the Table:
1. Click the Edit menu and select Modify columns
2. Click the column name that contains the URL to the images.
3. On the right, click the Format menu and select a format.
4. Click Save.
Filtering and aggregating data:
To filter your data:
1. Click the "options" link above the table or visualization. You see three tabs: Filter, Aggregate, and Create view.
2. Click Filter.
3. Give a condition.You can give more than one conditions by clicking on "Add Condition", each of which is an "AND" condition.
4. Click Apply.
Except for "contains case insensitive," filters are case-sensitive and match exactly on capitalization. Only the rows that match the criteria are shown.
To aggregate your data:
1. Check one or more columns to compute aggregates for: max, min, average, sum.
2. Choose which column to group by.
You also need to select aggregates to compute. Aggregation operators only work on numeric columns. A count of the number of rows in each group always appears in the result, so there is no need to specify it explicitly.
Using the "matches" filter:
"Matches" is based on SQL's LIKE, and therefore provides some basic pattern matching functionality. Use the underscore _ for a one-character wildcard, and % for a wildcard that matches any number of characters.
Displaying video
Just like images we can display videos.Fusion Tables doesn't store videos. Host the video on YouTube and use the appropriate embed code.
To have videos display in the table view in Fusion Tables:
1. get the "old embed code" for the video. Embed code that starts with "<iframe..." will not work; it needs to start with "<object...".
2. Paste the code into the table cell in Fusion Tables.
3. Under the Edit menu, select Modify Columns.
4. Select the column with the video embed code, and make sure it is type Text.
5. Under Format, select "8 line image".
6. Click Save.
To let others view this map you need to share it using the “Share” button on the right of the screen there is a share button; click it. You'll see that this table is set to private, so you will have to change it to Unlisted or Public in order to have it viewed in your website.
If all of the addresses were not translated to a map location:
Click the Visualize menu and select "Table"; you'll see the rows that were not translated are still highlighted in yellow. Click the globe icon next to the address and you'll be able to manually search for and select a matching location.
Note: In our example the data from the first two columns latitude and longitude has been used for plotting so the location column is highlighted yellow.
Configure the InfoWindow
Change how the content is displayed in the InfoWindow.
1. Click on Configure info window.
2. Select Custom in the drop-down menu next to Info Window Template:.
3. In the text area under Custom Html, you can enter any HTML and inline CSS to format the InfoWindows. Data from the table can be included by entering the column name surrounded by curly brackets.
4. Click Save.
Embedding Your Map into a Webpage
1. First, change the visibility of the table to Unlisted or Public to embed in a web page. To change the visibility of the table:
- Click the Share button in the top right corner.
- Select the radio button next to Unlisted or Public.
- The visibility will be updated immediately on selection.
3. Copy the HTML code in the text area that is displayed.
Displaying images
Fusion Tables doesn't store images.To display images, enter the URL pointing to the location of the image on the Internet in a cell in Fusion Tables.
To see image thumbnails in the Table:
1. Click the Edit menu and select Modify columns
2. Click the column name that contains the URL to the images.
3. On the right, click the Format menu and select a format.
4. Click Save.
Filtering and aggregating data:
To filter your data:
1. Click the "options" link above the table or visualization. You see three tabs: Filter, Aggregate, and Create view.
2. Click Filter.
3. Give a condition.You can give more than one conditions by clicking on "Add Condition", each of which is an "AND" condition.
4. Click Apply.
Except for "contains case insensitive," filters are case-sensitive and match exactly on capitalization. Only the rows that match the criteria are shown.
To aggregate your data:
1. Check one or more columns to compute aggregates for: max, min, average, sum.
2. Choose which column to group by.
You also need to select aggregates to compute. Aggregation operators only work on numeric columns. A count of the number of rows in each group always appears in the result, so there is no need to specify it explicitly.
Using the "matches" filter:
"Matches" is based on SQL's LIKE, and therefore provides some basic pattern matching functionality. Use the underscore _ for a one-character wildcard, and % for a wildcard that matches any number of characters.
Displaying video
Just like images we can display videos.Fusion Tables doesn't store videos. Host the video on YouTube and use the appropriate embed code.
To have videos display in the table view in Fusion Tables:
1. get the "old embed code" for the video. Embed code that starts with "<iframe..." will not work; it needs to start with "<object...".
2. Paste the code into the table cell in Fusion Tables.
3. Under the Edit menu, select Modify Columns.
4. Select the column with the video embed code, and make sure it is type Text.
5. Under Format, select "8 line image".
6. Click Save.
No comments:
Post a Comment