Skip to main content
Solved

Hello, just started FME a few days ago. Have an Excel file with 3 columns containing geometry in WKT format. How do I translate into readable geometry? Example: POINT (2648.81837074121 433.2500) Thanks


larue
Contributor
Forum|alt.badge.img+8
  • Contributor
Hello, just started FME a few days ago. Have an Excel file with 3 columns containing geometry in WKT format. How do I translate into readable geometry? Example: POINT (2648.81837074121 433.2500) Thanks

Best answer by nielsgerrits

Not sure what you mean with "readable geometry", but you can use the GeometryReplacer to create a geometry from the attribute. Set it to OGC Well Known Text.

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

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • March 31, 2021

Not sure what you mean with "readable geometry", but you can use the GeometryReplacer to create a geometry from the attribute. Set it to OGC Well Known Text.


larue
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • March 31, 2021

Hi @nielsgerrits​ ,

Appreciate the reply. It worked! Would never have picked that transformer, so there must be some idiosyncrasies to learn.

Just to clarify about "readable geometry": When inspecting the data, it looked exactly like the .txt file version, which was able to display (read) geometry no problem. With the Excel file, I got "There is no geometry in this view". Not sure why.

At any rate, thanks for the help and looking forward to asking more advanced questions.

 

 


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