Google
Official Google Earth Download Site

Google Earth Community System Reliability: HIGH
You are not logged in. [Login] Entrance · Main Index · Search · Active Topics
New user · Who's Online · FAQ · KML Reference · GE Guide · Help Group

Earth >> Dynamic Data Layers
Previous topic Previous   View all topics Index   Next topic Next   Threaded Mode Threaded  

Jump to first unread post. Pages: 1
Valery35
Master Craftsman


Reged: 09/02/05
Posts: 2272
Loc: Russia, Perm, Sun
KML from Google spreadsheets. Revolution?
      #725524 - 12/20/06 07:54 AM

View in Google Earth (3969 downloads)

KML = Cell based Google spreadsheets
Path calculator.

Source
http://spreadsheets.google.com/pub?key=phRmoRD2Q-V_mFA-Tckq7dw

GMaps
http://www.google.com/maps?f=q&hl=en&q=h...e=UTF8&z=5&om=1

Enjoy!


--------------------
Applications | Blog | Geoblog(ru) | Spreadsheets | Photos | Pict'Earth | Eastgeology (ru)

Edited by Valery35 (12/20/06 11:18 AM)

Post Extras: Print Post   Remind Me!   Report this Post  
Valery35
Master Craftsman


Reged: 09/02/05
Posts: 2272
Loc: Russia, Perm, Sun
Re: KML from Google spreadsheets. Revolution? [Re: Valery35]
      #725734 - 12/20/06 11:25 AM

View in Google Earth (281 downloads)

Cities grid

Source
http://spreadsheets.google.com/pub?key=phRmoRD2Q-V8RJKy4zds5ZA

GMaps
http://www.google.com/maps?f=q&hl=en...mp;ll=43.452919,-96.855469&spn=25.367277,59.765625&om=1

--------------------
Applications | Blog | Geoblog(ru) | Spreadsheets | Photos | Pict'Earth | Eastgeology (ru)

Post Extras: Print Post   Remind Me!   Report this Post  
Valery35
Master Craftsman


Reged: 09/02/05
Posts: 2272
Loc: Russia, Perm, Sun
Re: KML from Google spreadsheets. Revolution? [Re: Valery35]
      #725739 - 12/20/06 11:29 AM

View in Google Earth (235 downloads)

Best BBS

Source
http://spreadsheets.google.com/pub?key=phRmoRD2Q-V_xfdNEQhbRKQ

--------------------
Applications | Blog | Geoblog(ru) | Spreadsheets | Photos | Pict'Earth | Eastgeology (ru)

Post Extras: Print Post   Remind Me!   Report this Post  
Valery35
Master Craftsman


Reged: 09/02/05
Posts: 2272
Loc: Russia, Perm, Sun
How to make KML from Google spreadsheets? [Re: Valery35]
      #725771 - 12/20/06 12:01 PM

1. Read manual by Gerardo64 (thanks!)
http://bbs.keyhole.com/ubb/showthreaded.php/Cat/0/Number/550183
See Editgrid solution.

2. Prepare need dataset in spreadsheets and assembly all KML file in cell A1.
I use Cell A1 as standard for fast change of datasets.

3. Publish current spreadsheets and see link.
We see near http://spreadsheets.google.com/pub?key=phRmoRD2Q-V_mFA-Tckq7dw

4. Create Network link, open Properties by right click and insert into field Link generated string
( for path calculator it is http://spreadsheets.google.com/pub?key=phRmoRD2Q-V_mFA-Tckq7dw )

5. Add to string "&output=txt&range=a1"
a1 it is cell with generated KML file

6. Check the network Link, add need description and public this. Enjoy.

7. Open http://www.google.com/maps and insert into field Search Maps string Link from Network Link. Press Enter and see results.

8. Press "Link to this page" and see http link. Copy result from http string to need place. Press link and check results. Enjoy two

9. Add source "published" link or place embed spreadsheets in a web page.

10. Check and clean my bad English, prepare best manual, public in BBS.

Thanks.

PS: Generation KML from Google spreadsheets is very fast!
Nice!


--------------------
Applications | Blog | Geoblog(ru) | Spreadsheets | Photos | Pict'Earth | Eastgeology (ru)

Post Extras: Print Post   Remind Me!   Report this Post  
Valery35
Master Craftsman


Reged: 09/02/05
Posts: 2272
Loc: Russia, Perm, Sun
KML from Google spreadsheets. Place in blog. [Re: Valery35]
      #726183 - 12/20/06 08:44 PM

Path calculator in blog
http://gisplanet.blogspot.com/2006/12/kml-from-google-spreadsheets.html

1. Press Publish > More publishing options...
2. Select "HTML embed in a web page"
3. Press "Generate URL"
4. Copy-Paste result into HTML of post.

--------------------
Applications | Blog | Geoblog(ru) | Spreadsheets | Photos | Pict'Earth | Eastgeology (ru)

Post Extras: Print Post   Remind Me!   Report this Post  
Valery35
Master Craftsman


Reged: 09/02/05
Posts: 2272
Loc: Russia, Perm, Sun
Re: KML from Google spreadsheets. Revolution? [Re: Valery35]
      #730620 - 12/25/06 05:57 AM

Example of publication in Google Pages.
http://spreadsheetsgis.googlepages.com/pathcalculator2

Current way



--------------------
Applications | Blog | Geoblog(ru) | Spreadsheets | Photos | Pict'Earth | Eastgeology (ru)

Edited by Valery35 (12/25/06 06:07 AM)

Post Extras: Print Post   Remind Me!   Report this Post  
Pages: 1


Previous topic Previous   View all topics Index   Next topic Next   Threaded Mode Threaded  


Extra information
0 registered and 2 anonymous users are browsing this forum.

Moderator:  Hill, Jumble, Kempster, mcshea98, jeffryv, dulce, esterrett, NormB, Frank_McVey, BeadieJay, TheLedge, Cyclonic, no_stranger, LuciaM, tekgergedan, Noisette, danescombe, Michal_Drewniak, mutex, marinerfan, Delta102, bebop, MarkAubin 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 5874

Rate this topic

Jump to

earth.google.com    bbs.keyhole.com

*
UBB.threads™ 6.5.1.1