Skip to main content
Solved

FME insists on creating lines from point table

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.

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

8 replies

M
Forum|alt.badge.img+2

@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
  • 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
  • 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
  • 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+18
  • DanAtSafeSafer
  • Safer
  • 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
  • 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+18
  • DanAtSafeSafer
  • Safer
  • 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
  • June 25, 2021
DanAtSafe wrote:

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

Reply


Helpful Members This Week

Community Stats

30,985
Posts
117,433
Replies
38,764
Members

Latest FME

Terms & ConditionsCookie settings

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
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.