Skip to main content
Solved

How can i extract the x and y from csv

  • May 22, 2020
  • 3 replies
  • 48 views

nath
Contributor
Forum|alt.badge.img+6
  • Contributor
  • 85 replies

Hi,

I think i have a simple question. I have a csv where the xy is in one attribute. See example (geo_xy) but i have to do an poinonarea but because i have no x and y seperate he doesn't do it. FME doesn't recognise the geometry. I have already tried to extract the x and y by using multiple tranformers. Even used stringextractors but the number of numbers of x and y is various so it's not flawless.

I am sure there is an easy way to do it but I cannot find it.

Can somebody help me?

Thx

Nathalie

 

Best answer by redgeographics

The GeometryReplacer set to OCG WKT should do the trick.

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.

3 replies

david_r
Celebrity
  • 8392 replies
  • May 22, 2020

The column looks like Well Known Text, try using the GeometryReplacer:

It will automatically convert the "geo_xy" attribute to a point geometry for you.


redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3700 replies
  • Best Answer
  • May 22, 2020

The GeometryReplacer set to OCG WKT should do the trick.


nath
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • 85 replies
  • May 22, 2020

Thx! It works, I never found this myself. Thank you both!