Slightly corrupted view of polygon (multipolygon) from spatial MSSQL source

Question

The polygons journey: SHAPE -> FME (clipped) -> MSSQL Spatial

Viewing it in SQL Managment Studio (checking with STIsValid()):

Viewing it i ArcGIS PRO:

Converting GEOM.STAsText() in MS Mgmnt Studio and importing to layer i ArcGIS Pro using arcpy:

Has it to do with how ArcGIS Pro renders multipolygons from MSSQL, or is it that my data is corrupt?

MULTIPOLYGON_EPSG3006.txt

mssql_valid.png

filegeodb_arcgispro.png

corrupt_arcgispro.png

ArcPro Measure Tool.JPG

id2.png

id1.png

kjones_citi_1-1715298272324.png

PärÅman · Answer

Yes indeed, it seems that every polygon (inner and outer) is reversed. I'll try to correct it in the FME process step. Thank you!

DanPatterson · Answer

how are holes oriented in your *.txt file? arcpy expects outer-rings oriented clockwise, inner-rings(holes) oriented counterclockwise