SQL Server 直接修改图形信息

 

arcgis 加载 sqlserver 格式图形，报错，用此方法可以修改图形

---查找绘图错误记录

SELECT SHAPE.STAsText() FROM [HOUSE] WHERE OBJECTID=5326

 

---修改绘图错误的记录

UPDATE [HOUSE] SET SHAPE= 
geometry::STGeomFromText('POLYGON((121.38400470555644 29.109614481698372, 121.384016775497 29.109639962684014,
 121.38394837916712 29.109670808087685, 121.3839443558536 29.109670808087685, 121.38393899143557 29.109638621579506,
 121.38400470555644 29.109614481698372))',4326)
WHERE OBJECTID=5326

--修正图形

UPDATE [HOUSE] SET SHAPE= SHAPE.MakeValid();

 

转载于:https://www.cnblogs.com/hl137510705/p/9574317.html