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

327
2
06-04-2021 03:02 AM
Labels (1)
PärÅman
New Contributor II

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

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

 

 

 

 

 

 

 

Viewing it i ArcGIS PRO:

corrupt_arcgispro.png

 

 

 

 

 

 

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

filegeodb_arcgispro.png

 

 

 

 

 

 

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

Tags (2)
0 Kudos
2 Replies
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
PärÅman
New Contributor II

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!

0 Kudos