St_Laurent_spectacles_sur_la_Main
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFG
1
Spreadsheet Mapper v2.0Created by Google Earth OutreachVersion Vars, <Document> tags and Upgrade Message
2
3
<!-- version of this template, URL of message board -->
4
ver. 2.0Can't connect >>unable to check for latest version - try again later2.0
5
http://spreadsheets.google.com/pub?key=p-zIWuNNsnGLFf9VDAs-XZQ&output=txt&time1=4235347&
6
News: unable to check messages - try again later
7
8
Quick Instructions
9
10
1.Click the "File" button, choose "Rename" to give this spreadsheet an appropriate name.
11
2.Complete the "Basic Information" form below.
12
3.Follow the steps in the "Publish and Preview" section below.
13
4.Choose which balloon template(s) you like, or create your own on the "Template 1-6" sheets.
14
5.Go to your chosen template sheet(s) and replace/modify sample data with your information.
15
6.Create your placemarks on the "PlacemarkDATA" sheet (erase sample data first)
16
7.To see changes: "Re-publish" the spreadsheet and refresh the network link in Google Earth
17
18
Editing Rules:
19
ONLY edit white cells!
20
When editing, deleting, cutting, copy or pasting cells, make sure that you ONLY make changes in the white cells.
21
22
Detailed Instructions & Videos:
23
Control-click this cell to see the tutorial for this spreadsheet.
24
Control-click to see a 5 min video demo of how this spreadsheet works.
25
26
Basic Information
27
<Document id="spreadsheet_to_kml">
28
Author's Information:This info is embedded into your KML and helps search engines index your KML layer.<!-- Atom Feed information -->
29
Name/OrganizationLuc GauvreauYour organization name or the author's name<atom:author><atom:name>Luc Gauvreau</atom:name></atom:author>
30
Website URL:http://cheminsverslinconnu.blogspot.ca/URL/Link to your organization's website. <atom:link href="http://cheminsverslinconnu.blogspot.ca/" />
31
<atom:generator url="https://spreadsheets.google.com/pub?key=0AnsH41xIGs6xdHlsRVZxN0h6YUJiTFlSR0RDdHVSNmc&amp;hl=fr&amp;single=true&amp;gid=0&amp;output=html&amp;output=txt&amp;gid=1&amp;range=kml_output" version="">Google Earth Outreach - Spreadsheet Mapper 2.0 - http://earth.google.com/outreach/tutorial_mapper.html</atom:generator>
32
33
About your KML Document:<!-- Document tags -->
34
Name:Les nuits de la "Main"Name of the top-level folder for this KML (short & sweet).<name><![CDATA[Les nuits de la "Main"]]></name>
35
Snippet: (optional)(Cents ans de spectacles (1891-1991) / André-G. Bourassa et Jean-Marc LarueShort blurb under project name in 'My Places' (optional). Plain Text only.<Snippet><![CDATA[(Cents ans de spectacles (1891-1991) / André-G. Bourassa et Jean-Marc Larue]]></Snippet>
36
Description:Commerces de la rue Saint-Laurent (Montréal, Québec)Short description of your project (recommended). HTML OK.<description><![CDATA[Commerces de la rue Saint-Laurent (Montréal, Québec)]]></description>
37
On by default?yes(Yes/ No): Should all placemarks be visible when loaded?<visibility>1</visibility>
38
Open by default?Yes(Yes / No): Should top-level folder be open/expanded when loaded?<open>1</open>
39
40
41
Google Maps Compatibility
<!-- Backwards compatibility with Google Maps and Earth < 4.2?
42
Compatible with Maps and old versions of Earth?Yes(Yes / No)TRUE
43
- If yes: your placemarks will work in Maps & all version of Google Earth (3.0 - current), but will make a larger KML file.
- If no: Will make a much smaller KML that will work in Earth 4.2+ only. Warning messages are given to Google Maps and older versions of Google Earth.
- You can customize these messages in the "Advanced/Optional Settings" below.
end comment -->
44
45
Advanced / Optional Settings:
46
47
Document IDAssign an id value to your KML <Document> tag if you want to link to it via advanced Fly-to-Feature hyperlinks using balloonFlyTo; etc.
48
Document IDspreadsheet_to_kml
49
50
<!-- LookAt tags -->
51
Custom "LookAt" view: (optional)Set a custom view for this KML project. Otherwise Google Earth flies to a default view of all placemarks when the file is loaded.
52
53
54
55
56
57
58
59
Custom KML: (optional)Normally left blank. Used to add custom KML code for advanced add-ons. Inserted into KML after before the placemarks. <!-- Custom KML -->
60
Custom KML:(warning: no error-checking on this line... you must enter valid KML)
61
62
63
Upgrade Messages: (optional)<!-- HTML Upgrade message for Earth versions < 4.1 -->
64
Compatibility Mode is ENABLED:
The following messages only apply when it is disabled.
65
Google Earth 4.0 - 4.1:<h2>{Document_Name}</h2>
<p>Google Earth 4.2 or greater <br />
is required to view this KML.</p>
<p>Please upgrade to
the latest version, available here:</p>
<p><a href="http://earth.google.com">http://earth.google.com</a></p>
Google Maps Compatibility Mode is ENABLED.

This upgrade messages won't be used in your placemarks because Google Maps and all version of Google Earth can view this layer.
<h2>Les nuits de la "Main"</h2>
<p>Google Earth 4.2 or greater <br />
is required to view this KML.</p>
<p>Please upgrade to
the latest version, available here:</p>
<p><a href="http://earth.google.com">http://earth.google.com</a></p>
66
Google Maps &
Google Earth 3.0:
Google Earth 4.2+ is required to view this KML.<br /><br />
If you are already using Google Earth 4.2, please note that this placemark's balloon description cannot be edited using the placemark's property window as this KML uses advanced <BalloonStyle> and <ExtendedData> techniques. See <a href="http://code.google.com/apis/kml/documentation/extendeddata.html#balloonStyle">this link</a> for more information.<br /><br />
<p>Please install the latest version of Google Earth to view this KML. You can find it here:</p>
<p><a href="http://earth.google.com">http://earth.google.com</a></p>
Google Maps Compatibility Mode is ENABLED. This upgrade messages won't be used.
67
68
<< To access advanced/optional settings, unhide rows 46 - 67.
69
70
71
Publish and View
72
73
Publish spreadsheet:
74
1.Click the "Share" button (upper right), then choose the "Publish as a web page" button. Click the "Publish Now" (or the "Re-publish document" button).
75
2.Paste published URL here:https://spreadsheets.google.com/pub?key=0AnsH41xIGs6xdHlsRVZxN0h6YUJiTFlSR0RDdHVSNmc&hl=fr&single=true&gid=0&output=html
76
e.g.,http://spreadsheets.google.com/pub?key=abcdefghijklmnopqrstuvwxyz
77
78
79
View Placemarks in Google Earth:
80
3.Copy this
Network Link KML:
<NetworkLink><atom:author><atom:name>Luc Gauvreau</atom:name></atom:author><atom:link href="http://cheminsverslinconnu.blogspot.ca/" /><atom:generator url="https://spreadsheets.google.com/pub?key=0AnsH41xIGs6xdHlsRVZxN0h6YUJiTFlSR0RDdHVSNmc&amp;hl=fr&amp;single=true&amp;gid=0&amp;output=html&amp;output=txt&amp;gid=1&amp;range=kml_output" version="">Google Earth Outreach - Spreadsheet Mapper 2.0 - http://earth.google.com/outreach/tutorial_mapper.html</atom:generator><name><![CDATA[Link to - <a href='https://spreadsheets.google.com/ccc?key=0AnsH41xIGs6xdHlsRVZxN0h6YUJiTFlSR0RDdHVSNmc&hl=fr&single=true&gid=0'>Spreadsheet</a>]]></name><open>1</open><flyToView>1</flyToView><Link><href>https://spreadsheets.google.com/pub?key=0AnsH41xIGs6xdHlsRVZxN0h6YUJiTFlSR0RDdHVSNmc&amp;hl=fr&amp;single=true&amp;gid=0&amp;output=txt&amp;gid=0&amp;range=kml_output</href></Link></NetworkLink>single click to select, then copy
(don't double click to edit the cell's formula)
81
4.Select "My Places" in the "Places" panel of Google Earth and paste the Network Link KML from above.
Sample placemarks will load from this spreadsheet under the folder "Les nuits de la "Main"".
Choose which balloon template(s) you want to use, or create your own by modifying the "Template 1-6" sheets.
82
83
84
View Placemarks in Google Maps:
85
Link to Google MapsControl-Click this cell to view in Google MapsDisplays the your placemarks in Google Maps. In case of error, try reloading the link - connection to the spreadsheet is sometimes too slow, and Google Maps will timeout.
86
87
88
89
Create Placemarks
90
1.Go to your chosen template(s) sheet(s), and enter your own information under the "static" variable section. Optionally, edit the "style" variable section.
91
2.Go to the "PlacemarkData" sheet. Give each placemark a name, location, and specify the number of the template it should use.
92
3.Enter each piece of balloon information in the appropriate columns, according to which template that placemark is using.
Enter a template number into cell H10 on the "PlacemarkData" sheet to get a column header guide for that template.
93
94
95
96
Re-publish & Refresh to view changes
97
If you edit your data or change the spreadsheet, follow the steps below to view the changes in Google Earth:
98
1.Go to the "Share" button above, choose "Publish as a web page" and click the "Re-publish document" button.
99
2.In Google Earth, right-click on the Network Link (named "Link to - Spreadsheet) and choose "Refresh".
- A fresh copy of the KML with your changes will be fetched.
- A second refresh is sometimes required to see all changes.
100
Loading...
 
 
 
start here
PlacemarkData
Template1
Template2
Template3
Template4
Template5
Template6
kml