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.
+19- 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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.