Question

KML to CSV - no lat/lon

  • 20 June 2016
  • 1 reply
  • 6 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?


1 reply

Badge +2

Hi,

Use CoordinateExtractor transformer in between kml reader and csv writer.

Don't forget to place the XY attributes in writer

Reply