Solved

Aviod geometrycollection in MS SQL?

  • 5 December 2017
  • 2 replies
  • 5 views

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

icon

Best answer by m_tengbrand 7 December 2017, 09:31

View original

2 replies

Userlevel 4
Badge +13

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)

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