laptop and a wrench

漏洞

The Check Geometry tool returns an error, Error 000278.

ArcGIS Pro
漏洞 ID 编号 BUG-000162139
已提交October 17, 2023
上次修改时间May 28, 2025
适用范围ArcGIS Pro
找到的版本3.1.3
操作系统Windows Server
操作系统版本2022
状态Non-Reproducible

附加信息

Note reproduced. Esri check geometry tool ran okay. Tested via Pro 3.5 The SQL provided is not adequate to provide a repro without edits. No sequence was created. CREATE TABLE IF NOT EXISTS antragsgeom ( object_id integer NOT NULL, bemerkung_amt character varying(255) COLLATE pg_catalog."default", the_geom geometry(Polygon,25832) ); Data loaded. D:\Keep\data\BUG-000162139\CheckGeometry>"c:\Program Files\PostgreSQL"\16\bin\psql.exe -U map -d snoopynetpg1 -c "\copy antragsgeom (object_id, bemerkung_amt, the_geom) FROM 'TEST.CSV' ENCODING 'WIN1252'" Password for user map: COPY 20 PostGIS found invalid rows using their rules snoopynetpg1=> select object_id, st_isvaliddetail(the_geom) from antragsgeom; object_id | st_isvaliddetail -----------+------------------------------------------------------------------ 23394 | (t,,) 23413 | (t,,) 23414 | (t,,) 23415 | (t,,) 23395 | (t,,) 23396 | (t,,) 23397 | (t,,) 23398 | (t,,) 23399 | (t,,) 23400 | (t,,) 23401 | (t,,) 23402 | (t,,) 23403 | (t,,) 23404 | (t,,) 23405 | (f,Self-intersection,01010000004022A6EFB7661A41D51866AAB47F5441) 23406 | (f,Self-intersection,0101000000E202A987DF9319412C9BC6AEF8665441) 23407 | (t,,) 23408 | (t,,) 23409 | (t,,) 23412 | (t,,) (20 rows) We found errors okay using our rules: WARNING 003410: Shape has a structural error! (-151) A polygon outer shell does not completely enclose all donuts for the part at object_id: 23408 in C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom Check Geometry ===================== Tool Path Input Features C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom Output Table Validation Method ESRI Contains Geometry Errors PROBLEMS_FOUND ===================== Messages Start Time: Wednesday, May 7, 2025 2:08:09 PM WARNING 003410: Shape has a structural error! (-150) Polygon does not close properly at object_id: 23399 in C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom WARNING 003410: Shape has a structural error! (-150) Polygon does not close properly at object_id: 23400 in C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom WARNING 003410: Shape has a structural error! (-147) Two donuts or two outer shells overlap at object_id: 23401 in C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom WARNING 003410: Shape has a structural error! (-150) Polygon does not close properly at object_id: 23402 in C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom WARNING 003410: Shape has a structural error! (-150) Polygon does not close properly at object_id: 23403 in C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom WARNING 003410: Shape has a structural error! (-150) Polygon does not close properly at object_id: 23404 in C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom WARNING 003410: Geometry check successful, but the points of the shape are not in the expected order! at object_id: 23405 in C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom WARNING 003410: Shape has a structural error! (-150) Polygon does not close properly at object_id: 23406 in C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom WARNING 003410: Geometry check successful, but the points of the shape are not in the expected order! at object_id: 23407 in C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom WARNING 003410: Shape has a structural error! (-151) A polygon outer shell does not completely enclose all donuts for the part at object_id: 23408 in C:\Users\mich2581\Documents\ArcGIS\Projects\MyProject125\PostgreSQL-mdowney02-snoopynetst1(map).sde\snoopynetpg1.map.antragsgeom **** CHECK RESULTS SUMMARY ***************************************************************************************** FINISHED: 20 total feature(s) fetched. 10 shape(s) passed geometry check. 0 shape(s) could not be checked. 10 shape(s) have a geometry error. ************************************************************************************************************ Succeeded at Wednesday, May 7, 2025 2:08:10 PM (Elapsed Time: 0.74 seconds)

解决办法

Use SQL to identify the corrupted data:

  • select object_id, st_isvalid(the_geom) from sde.antragsgeom

重现步骤

漏洞 ID: BUG-000162139

软件:

  • ArcGIS Pro

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项