漏洞 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
重现步骤