Skip to main content

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?

Hi,

Use CoordinateExtractor transformer in between kml reader and csv writer.

Don't forget to place the XY attributes in writer


Reply