| Bug ID Number |
BUG-000162139 |
| Submitted | October 17, 2023 |
| Last Modified | May 28, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 3.1.3 |
| Operating System | Windows Server |
| Operating System Version | 2022 |
| Status | Non-Reproducible
This issue was not reproducible when tested by the development team. Issues may be given this status when they cannot be reproduced or are no longer relevant in a development version of the software, but a specific fix was not installed to address the issue. The issue's Additional Information section may contain further explanation.
|
Additional Information
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)
Workaround
Use SQL to identify the corrupted data:
- select object_id, st_isvalid(the_geom) from sde.antragsgeom
Steps to Reproduce