http://snippets.dzone.com/posts Mon, 06 Oct 2008 15:46:46 GMT DZone Snippets: parse code http://snippets.dzone.com/posts/show/1765 # Parses a GoogleEarth KML file and writes the pertinent data to a CSV file <br /> <br />#<?xml version="1.0" encoding="UTF-8"?> <br /># <kml xmlns="http://earth.google.com/kml/2.0"> <br /># <Folder> <br /># <name>Folder Name</name> <br /># <open>1</open> <br /># <ScreenOverlay> <br /># ... Screen Overlays <br /># </ScreenOverlay> <br /># <Document> <br /># <name>Document Name</name> <br /># <open>1</open> <br /># <Schema parent="Placemark" name="S_Parcel_centroids_SSSS"> <br /># ... Schema Def ... <br /># </Schema> <br /># <Style id="khStyle722"> <br /># ... Style Info ... <br /># </Style> <br /># <Folder id="layer 0"> <br /># <name>FolderName</name> <br /># <Location> <br /># <name>Location name 1</name> <br /># <description><![CDATA[...Description text...]]></description> <br /># <styleUrl>#khStyle16037</styleUrl> <br /># <Point> <br /># <altitudeMode>relativeToGround</altitudeMode> <br /># <coordinates>-81.85829063169155,29.12257052899974,100</coordinates> <br /># </Point> <br /># <Column1>Column 1 data</Column1> <br /># <Column2>Column 2 data</Column2> <br /># </Location> <br /># <Location> <br /># <name>Location name 2</name> <br /># <description><![CDATA[...Description text...]]></description> <br /># <styleUrl>#khStyle16037</styleUrl> <br /># <Point> <br /># <altitudeMode>relativeToGround</altitudeMode> <br /># <coordinates>-81.85829063169155,29.12257052899974,100</coordinates> <br /># </Point> <br /># <Column1>Column 1 data</Column1> <br /># <Column2>Column 2 data</Column2> <br /># </Location> <br /># <br /># ... More Locations ... <br /># </Folder> <br /># </Document> <br /># </Folder> <br /># </kml> <br /> <br /> <br /><code> <br />require "rexml/document" <br />include REXML <br />kmlroot = (Document.new File.new "data.kml").root <br />nodes = kmlroot.elements.to_a("//Location") <br /> <br />begin <br /> f = File.open("data.csv", "w") <br /> f << "id,column1,column2,latitude,longitude"\n" <br /> id = 1 <br /> nodes.each { |node| <br /> column1 = node.elements["column1"].text <br /> column2 = node.elements["column2"].text <br /> coords = node.elements["Point"].elements["coordinates"].text.split(",") <br /> f << [id, column1, column2, coords[1], coords[0] ].join(",") << "\n" <br /> id += 1 <br /> } <br />ensure <br /> f.close <br />end <br /></code> Sat, 25 Mar 2006 18:56:47 GMT http://snippets.dzone.com/posts/show/1765 ajturner (Andrew Turner)