Skip to main content
Question

KML to CSV - no lat/lon

  • June 20, 2016
  • 1 reply
  • 10 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

pratap
Contributor
Forum|alt.badge.img+11
  • 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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings