.csv to Google Earth .kml


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users .csv to Google Earth .kml
# 1  
Old 11-17-2011
.csv to Google Earth .kml

Does anyone have an awk script that converts/translates an ascii .csv file to a Google Earth .kml file?

The .csv would typically look like:

X_Longitude_Coordinate,Y_Latitude_Coordinate,Elevation,Point_Number

Thank you,
Kenny.
# 2  
Old 11-17-2011
kml requires more "data" than just those three items, it has
placemark types - simple, extruded, floating
LookAt objects, and a lot of other stuff.

Download CSV to KML Converter 1.7 Free - Simple application for conversion of CSV files to KML format - Softpedia

(It's free & Windows)

That does conversions, but you may not get what you expect when you run it. Especially with the sparse dataset you have.
# 3  
Old 11-17-2011
Especially beware what hemisphere your coordinates are measured relative to. In North America we usually measure longitude west from zero. When I imported some data into a different map site, it expected the opposite, causing most of our server installations to appear in some giant lake near Mongolia.
# 4  
Old 11-17-2011
We had the same problem - generally GIS systems expect X,Y - longitude(X), latitude(Y)

Programmers seem to like Y,X when making those files. Geocachers and navigators in general love Lat-Long, too.

Some of our physical plant was under the Indian Ocean, I wonder if we ever got it back?
# 5  
Old 11-17-2011
Sounds like a glorious mess, hope you took a screenshot Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Filter a .kml file (xml) with data set from text file

I have a .kml file. So I want filter the .kml to get only the tags that have this numeric codes that they are in a text file 11951 11952 74014 11964 11965 11969 11970 11971 11972 60149 74018 74023 86378 11976 11980 11983 11984 11987 (5 Replies)
Discussion started by: pcoj33
5 Replies

2. Shell Programming and Scripting

Filter a .kml file (xml) to remove unwanted entries

Ok, i have a .kml file that that i want to trim down and get rid of the rubbish from. its formatted like so: <Placemark> <name><!]></name> <description><!</b><br/>Frequency: <b>2437</b><br/>Timestamp: <b>1304892397000</b><br/>Date: <b>2011-05-08... (11 Replies)
Discussion started by: Phear46
11 Replies

3. Solaris

Google Earth in Solaris

Hi Gurus of Unix, is posible to Install Google Earth in Solaris I download this packets : GoogleEarthLinux.bin I Change the permission chwmod +x GoogleEarthLinux.bin after that I do ./GoogleEarthLinux.bin andres@opensolaris:~/Downloads# sudo ./GoogleEarthLinux.bin Verifying archive... (1 Reply)
Discussion started by: andresguillen
1 Replies

4. Web Development

Helpful Tip: Forcing Google to www.google.com

Helpful Tip! Sometimes when we are in another country, Google redirects our request for www.google.com to: www.google.co.in or to: www.google.co.th If you want to force Google to go to the US site, use: www.google.com/webhp (1 Reply)
Discussion started by: Neo
1 Replies

5. UNIX for Dummies Questions & Answers

earth in daylight

is there a command that displays a picture of the earth that is currently in daylight? thanks, bianca (2 Replies)
Discussion started by: tonbia
2 Replies
Login or Register to Ask a Question