Skip to main content
Question

KML to CSV - no lat/lon

  • June 20, 2016
  • 1 reply
  • 18 views

Hi, I want to convert KML containing placemarks to CSV, e.g.:

<Placemark>

<styleUrl>#msn_placemark_circle122</styleUrl>

<ExtendedData>

<SchemaData schemaUrl="#S_mdm_centroids_BB_SSDDSII">

<SimpleData name="MDM_ID">DE-BB-304102</SimpleData>

<SimpleData name="MDM_NAME">Walsleben</SimpleData>

<SimpleData name="MDM_lat">52.9507</SimpleData>

<SimpleData name="MDM_long">12.66</SimpleData>

<SimpleData name="MDM_Direction">SE</SimpleData>

<SimpleData name="MDM_CAPACITY">11</SimpleData>

<SimpleData name="Import_Type">1</SimpleData>

</SchemaData>

</ExtendedData>

<Point> <coordinates>12.66021255820746,52.95028030420562,0</coordinates> </Point>

</Placemark>

The output contains all SimpleData but not the actual point coordinates. I have tried workbench and quick translator (MacOSX). What am I doing wrong?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

pratap
Contributor
Forum|alt.badge.img+12
  • Contributor
  • June 20, 2016

Hi,

Use CoordinateExtractor transformer in between kml reader and csv writer.

Don't forget to place the XY attributes in writer