#15 CSV to KML conversion - invalid coordinates

closed
nobody
None
5
2010-12-21
2010-01-23
No

Not sure if this post is referring to the same problem in "Invalid KML file when csv file is in UTF8 - ID: 2889445". Anyways, i hope to provide some clarity here ..

while converting the below csv:
UTC-Timestamp Remark Longitude Latitude HorizontalAccuracy VerticalAccuracy Elevation Speed Heading
2009-12-09T10:05:14.120Z my place 75.930531 11.837122 0.839999974 2.5 606 0.6km/h 164.8718262

i get the KML
<Placemark>
<name><![CDATA[75.930531]]></name>
<description><![CDATA[11.837122]]></description>
<Point>
<coordinates>2009-12-09T10:05:14.120Z,my place,0</coordinates>
</Point>
</Placemark>

where the coordinates are wrong.

Please help to correct this; if any clarification is required please contact sandeep.karun@gmail

Discussion

  • Choon-Chern Lim (Mike)

    I believe your csv data is not arranged correctly, it should be like this:-

    "-122.347627","47.621248","Experience Music Project","325 5th Ave N<BR>Seattle, WA 98109<BR>(206) 770-2702"
    "-122.397187","47.667631","Hiram M Chittenden Locks","3015 Northwest 54th St<BR>Seattle, WA 98107<BR>(206) 783-7059"

     
  • Choon-Chern Lim (Mike)

    • status: open --> closed
     

Log in to post a comment.