Skip to main content
Solved

FME insists on creating lines from point table

  • June 24, 2021
  • 8 replies
  • 75 views
rmcgregor

I have a table that has x and y coordinates. I am trying to write to an sde point feature class and it is failing. The error message is that 'line' features can't be put into a point feature class.

 

Each record has one x and one y value. The log says there are 2 coordinates (which is why it's trying to make a line), but I have no idea why its seeing 2 x values for any record.

 

I exported as lines and got the correct number of lines of 0 length. They actually are in the right place in GIS.

 

Light on details, but if anyone has hit this snag and recovered, I'd love to hear about it. There is NOTHING weird about this table. Sensitive data so I can't provide details.

 

Actually, it is only some records - an identifiable set - the other records will create points. I see nothing different about the records that fme wants to turn into lines.

 

Thank you,

Randy McGregor

Best answer by DanAtSafe

If you want to send points to SDE then skip the VertexCreator or else use the 'Replace with Point' option.

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.

8 replies

M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • June 24, 2021

@rmcgregor​ use feature caching to view the data just before it goes into the ArcSDE writer. Check the feature geometry and see what you have. Is it a iFMEPoint or iFMEline or something else...

rmcgregor
  • rmcgregor
  • Author
  • 24 replies
  • June 24, 2021

Thank you!

It seems to be making 3D lines. I see thm in the in the 3d viewer. They look like shafts. Not sure why? How do I check the iFMEPoint variable?

rmcgregor
  • rmcgregor
  • Author
  • 24 replies
  • June 24, 2021

The "good" records are visible in the 2d preview window. Something is 'telling' some records that they are 3d extrusions rather than points...

rmcgregor
  • rmcgregor
  • Author
  • 24 replies
  • June 24, 2021

Vertex creator is doing it. My instructions are to make a point using x_coord and y_coord values, one pair for each record. Very very strange.

DanAtSafe
Safer
Forum|alt.badge.img+19
  • DanAtSafeSafer
  • Safer
  • 345 replies
  • June 24, 2021

By default the VertexCreator will 'Add Point', not 'Replace with Point' . If the X & Y values entered are the same as the point already then it will create a line of 0 length with 2 identical vertices - even in 2D.

rmcgregor
  • rmcgregor
  • Author
  • 24 replies
  • June 24, 2021

Thanks. It should be adding a point. Sounds like it's trying do 'replace with point'?

DanAtSafe
Safer
Forum|alt.badge.img+19
  • DanAtSafeSafer
  • Safer
  • 345 replies
  • Best Answer
  • June 24, 2021

If you want to send points to SDE then skip the VertexCreator or else use the 'Replace with Point' option.

rmcgregor
  • rmcgregor
  • Author
  • 24 replies
  • June 25, 2021

If you want to send points to SDE then skip the VertexCreator or else use the 'Replace with Point' option.

That did it! I just unplugged vertex creator, and ALL records went into sde as point features just fine. I didn't know that was possible, and I don't know why vertex creator was making "3D" features with some records and not others.

Thank you very much,

Randy McGregor

Community Stats

32,070
Posts
121,771
Replies
39,697
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.