laptop and a wrench

Bug

The Check Geometry tool returns an error, Error 000278.

ArcGIS Pro
Bug ID Number BUG-000162139
SubmittedOctober 17, 2023
Last ModifiedMay 28, 2025
Applies toArcGIS Pro
Version found3.1.3
Operating SystemWindows Server
Operating System Version2022
StatusNon-Reproducible

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

Bug ID: BUG-000162139

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options