Skip to main content
Solved

How can i extract the x and y from csv


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

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.

View original
Did this help you find an answer to your question?

3 replies

david_r
Celebrity
  • 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+50
  • Celebrity
  • Best Answer
  • May 22, 2020

The GeometryReplacer set to OCG WKT should do the trick.


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

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


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