| Número de ID do Erro |
BUG-000162139 |
| Enviado | October 17, 2023 |
| Última Modificação | May 28, 2025 |
| Aplica-se à | ArcGIS Pro |
| Versão encontrada | 3.1.3 |
| Sistema Operacional | Windows Server |
| Versão do Sistema Operacional | 2022 |
| Status | Non-Reproducible
Esse problema não foi reproduzível quando testado pela equipe de desenvolvimento. Os problemas podem receber esse status quando não podem ser reproduzidos ou não são mais relevantes em uma versão de desenvolvimento do software, mas uma correção específica não foi instalada para resolver o problema. A seção Informações Adicionais do problema pode conter mais explicações.
|
Informações Adicionais
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)
Solução Provisória
Use SQL to identify the corrupted data:
- select object_id, st_isvalid(the_geom) from sde.antragsgeom
Etapas para Reproduzir