| Bug-ID-Nummer |
BUG-000162139 |
| Eingereicht | October 17, 2023 |
| Zuletzt geändert | May 28, 2025 |
| Gilt für | ArcGIS Pro |
| Gefunden in Version | 3.1.3 |
| Betriebssystem | Windows Server |
| Betriebssystemversion | 2022 |
| Status | Non-Reproducible
Dieses Problem konnte bei Tests durch das Entwicklungsteam nicht reproduziert werden. Problemen wird u. U. dieser Status zugewiesen, wenn sie nicht reproduziert werden können oder in einer Entwicklungsversion der Software nicht mehr relevant sind. Es wurde jedoch kein Fix zur Problembehebung installiert. Weitere Erläuterungen finden Sie ggf. im Abschnitt "Zusätzliche Informationen" des jeweiligen Problems.
|
Zusätzliche Informationen
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
Schritte zur Reproduzierung