I have made an aggregation of lines that I have saved in MS SQL. when I then make a STGeometryType () on the table I find that a GeometryCollection has been formed. I want to avoid this and instead save it as a MultiLineString. However, I do not find any settings where I can control this. (then I will do the same for points and spaces to completely avoid GeometryCollection.)
Solved
Aviod geometrycollection in MS SQL?
- Participant
Best answer by m_tengbrand
Now it's fixed, I had to run a deaggregate first, it was not the objects aggregated by fme that was the problem but the objects that were already multilines in SDE.
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.
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.
+21- Safer
Hi @m_tengbrand, the GeometryCoercer might be useful in this situation. You can change the geometry if needed using this transformer. Additionally, I would suggest looking at what you have set to the "Collection Type Handling" on the Writer feature type (under Advanced)
- Participant
- Best Answer
Now it's fixed, I had to run a deaggregate first, it was not the objects aggregated by fme that was the problem but the objects that were already multilines in SDE.