| Numéro d’ID de bogue |
BUG-000162139 |
| Envoi | October 17, 2023 |
| Dernière modification | May 28, 2025 |
| S’applique à | ArcGIS Pro |
| Version trouvée | 3.1.3 |
| Système d’exploitation | Windows Server |
| Version du système d’exploitation | 2022 |
| Statut | Non-Reproducible
Ce problème n’a pas pu être reproduit au cours des tests réalisés par l’équipe de développement. Ce statut peut être attribué aux problèmes qui sont impossibles à reproduire ou qui ne sont plus d’actualité dans une version de développement du logiciel, alors qu’aucun correctif spécifique n’a été installé pour résoudre le problème. Pour d’autres explications, reportez-vous à la section Informations supplémentaires correspondant au problème.
|
Informations supplémentaires
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)
Solution de contournement
Use SQL to identify the corrupted data:
- select object_id, st_isvalid(the_geom) from sde.antragsgeom
Étapes pour reproduire