Transcript Slide 1
By Jim Graham
May, 2008
1.
2.
3.
How GoogleEarth Works
Display Excel Data in GoogleEarth
Creating KML Files for GoogleEarth
Web Server
Local Computer
Internet
Satellite Images
Spreadsheet Files
GoogleEarth
KML Files
Created by Denver-based company, Keyhole
An application that runs on your computer
GIS Services for various layers
A system that you can add data to
Commercially owned
Common file formats:
◦ Word (*.doc)
◦ PowerPoint (*.ppt)
◦ Excel (*.xls)
Shapefiles
Coverages
GeoTIFF
Lots of others
Is KML a GIS format?
Small Graphics Markup Language (SGML)
HyperText Markup Language (HTML)
Extensible Markup Language (XML)
Based on XML
Very simple, flexible format
Can be create very complex files
Not an industry standard (could change at
any time, only works in GoogleEarth)
KML Documentation:
Or search on ‘KML’ into Google
http://code.google.com/apis/kml/docu
mentation/
Rasters (photos)
◦ Satellite
◦ Aerial
Vector Data
◦ Points
◦ Polylines/Paths
◦ Polygons
Add Placemark
Add Path to and from somewhere
Add Polygon around your school
Save As… KML files
KML is still very new
Shapefiles are the most common GIS vector
format
Converters are coming
Shapefiles are much more limited than KML
files (i.e. it’s easy to go from Shapefile to
KML, can be harder to go from KML to
Shapefile)
When should data be in a local file vs. on a
web server?
What are the possible futures for KML?
Web Server
Local Computer
Internet
Problem: Display spreadsheet data in
GoogleEarth
Solution:
◦ Use an Excel “Add-In” that converts data in
spreadsheets to a KML file
◦ Open the KML file in GoogleEarth
Actually Excel files that include “Macros”
Hidden in your “Add-In” folder
1.
2.
3.
4.
5.
Install WriteToKML Add-In to your system
Make WriteToKML available to Excel
Add a custom tool to Excel
Use the tool to save a KML file
Make more interesting descriptions
Discussion point: What type of data would
you collect to make this work?
The WriteToKML Add-In is limited
Does not support:
◦
◦
◦
◦
polygons and paths
Graphics
Icons
Lots of other features of KML
http://earth.google.com/kml/index.html
Simple text files without any formatting
Write in NotePad (TextEdit on the Mac), not
MS-Word or other “word-processor”
1.
2.
3.
4.
5.
6.
Search on “KML” in Google
Click on “KML Documentation Introduction”
Click on “KML Tutorial”
Scroll down to light blue boxes
Copy everything in the box into a new
NotePad file
Save as “text.kml”
What is the approximate coordinate?
What is the name?
What is the description?
Open GoogleEarth and Notepad
Steps:
◦
◦
◦
◦
◦
Edit in NotePad
Save to a file on the desktop
Double click on the file
Click “Yes” to reload and view the file
Repeat
Change name, description
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://earth.google.com/kml/2.2">
<Document>
<Placemark>
<name>Name of the Placemark</name>
<description> Description appears in the balloon
</description>
<Point>
<coordinates>102.595626,14.996729</coordinates>
</Point>
</Placemark>
</Document>
</kml>
Multiple points
◦ Add “Document” tags”
◦ Add another point, save, view
Some fun stuff
- Photos, paths, etc.
KML “Developer’s Guide”
KML Reference
How would you use this in your classroom?
What types of data would kids find cool to
put into GoogleEarth?
Web server/client architecture
Spatial Data File format: KML
Converting from Excel to KML
How to edit KML files