Latest Contributions by Bud

‎04-26-2024

In an SQL query, I wrote a custom function that uses ST_INTERSECTS() to check if each feature can be used in a spatial SQL operation. If there is an error, then the function returns "error" to the query's resultset. That let me flag the problem row. Stack Overflow: Find row with problem shape (SDE.ST_GEOMETRY spatial type) with function check_shape(anno_shape sde.st_geometry, boundary_shape sde.st_geometry) return varchar2 is v_test_result varchar2(10); begin select sde.st_intersects (boundary_shape, anno_shape) into v_test_result from dual; return 'no error'; exception when others then return 'error'; end; select anno.objectid, anno.shape as anno_shape, check_shape(anno.shape, boundary.shape) as check_shape from city.boundary boundary cross join infrastr.gcsm_hc_anno anno where check_shape(anno.shape, boundary.shape) = 'error' Bud_0-1714196319314.png Related: ST_GEOMETRY SQL function to find problem annotation shapes I'm troubleshooting the problem feature with Esri Support: Esri Case #03605230 - ...(Catalog copy/paste shape integrity error)

‎04-26-2024

Thanks @Robert_LeClair! Your note about ST_INTERSECTION() gave me an idea about finding the problem row. In an SQL query, I wrote a custom function that uses ST_INTERSECTS() to check if each feature can be used in a spatial SQL operation. If there is an error, then the function returns "error" to the query's resultset. That let me flag the problem row. Stack Overflow: Find row with problem shape (SDE.ST_GEOMETRY spatial type) with function check_shape(anno_shape sde.st_geometry, boundary_shape sde.st_geometry) return varchar2 is v_test_result varchar2(10); begin select sde.st_intersects (boundary_shape, anno_shape) into v_test_result from dual; return 'no error'; exception when others then return 'error'; end; select anno.objectid, anno.shape as anno_shape, check_shape(anno.shape, boundary.shape) as check_shape from city.boundary boundary cross join infrastr.gcsm_hc_anno anno where check_shape(anno.shape, boundary.shape) = 'error' Bud_1-1714192115425.png Related: ST_GEOMETRY SQL function to find problem annotation shapes

‎04-26-2024

Background: GP tool to export one feature at a time and log problem features in an error table Esri Case #03605230 - ...Catalog copy/paste shape integrity error Esri Support: There is definitely a way to loop over features using Model Builder. In this case, you can use the Feature Selection Iterator: https://pro.arcgis.com/en/pro-app/2.9/tool-reference/modelbuilder-toolbox/iterate-feature-selection.htm By default, this selects each record in the attribute table and you can use the ObjectID value to output a specific feature class name: Bud_0-1714162650264.png In the example above, I connected my beaverriver feature class to the Iterate Feature Selection tool. From each selected feature, I am exporting it to a new feature class with a new name "beaverriver_ExportFeatures_%Value%". The %Value% tag takes the ObjectID value from the iterator and inserts it into the output feature class name. The result is as follows: Bud_1-1714162668656.png Hopefully this will give you an error at a specific record(s).

‎04-26-2024

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 eGDB: What geoprocessing tools can be used to export a feature class? (enterprise geodatabase to file geodatabase) Feature Classe to Feature Class Copy Features Copy (idea: Use the Copy GP tool to copy data to a different workspace) Any others? Use Case: I have an issue with an annotation FC. In some versions of Pro, I get a "shape integrity error" when I open the attribute table and navigate to the last row. When I copy/paste the FC to an EGDB or FDGB via Catalog, I get a "shape integrity error". If I export using Feature Class to Feature Class or Copy Features (or Append to an existing FC), only 72 of 800 features get exported. But no error is thrown. I'm looking for a GP tool that will throw an error when I export the FC, to help find the broken shapes.

‎04-26-2024

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB: I want to copy an annotation FC (and all it's related FCs) to a file geodatabase. I want to do this in a model, not via copy/paste in Catalog. Copy (Data Management) Any data dependent on the input is also copied. For example, copying a feature class or table that is part of a relationship class also copies the relationship class. The same applies to a feature class that has feature-linked annotation, domains, subtypes, and indices—all are copied along with the feature class. Copying geometric networks, network datasets, and topologies also copies the participating feature classes. It looks like the Copy tool can't copy to a different workspace, unlike copy/paste in Catalog. Bud_0-1714160839219.png ERROR 000979 Cannot copy between different workspaces. Could the Copy tool be enhanced so that data can be copied to a different workspace? For what it's worth, the documentation doesn't mention this limitation. https://pro.arcgis.com/en/pro-app/2.9/tool-reference/data-management/copy.htm Use case: Esri Case #03605230 - ...Catalog copy/paste shape integrity error GP tool to export one feature at a time and log problem features in an error table

‎04-26-2024

When running geoprocessing tools, we sometimes get errors. There are lots of possible reasons for errors, but one of them is the tool got stuck on a specific feature. It would help if the GP tool indicated what row it got stuck on, such as including the ObjectID in the error text. Related: GP tool to export one feature at a time and log problem features in an error table

‎04-25-2024

@clt_cabq It's just for one-off editing tasks. It is similar to copying a feature from one FC to a different FC. I wouldn't want to use a Python script for that.

‎04-25-2024

In the attribute table of a standalone table, I want to copy a row and paste it into a different table (identical fields). I’m aware of the append tool. I’m looking for more efficient copy/paste functionality that’s suitable for fast-paced edits. Not to be confused with duplicating a row within the same standalone table: https://community.esri.com/t5/arcgis-pro-ideas/ability-to-edit-standalone-tables-in-arcmap-just/idc-p/1266729/highlight/true#M23727

‎04-25-2024

Could you create a query layer or database view, and do this in the SQL? Use ORDER BY to sort on the required field. Do this in an subquery (inner query). Exclude the OBJECTID column from the SELECT clause. In an outer query, generate a fake OBJECTID column using a mechanism like Oracle’s ROWNUM pseudocolum, or your database’s equivalent. Use the fake OBJECTID as the unique ID in the query layer or database view in Pro. Maybe Pro would sort on the fake OBJECTID column in the popup, which is the sort order you wanted: sorting on your other field.

‎04-25-2024

If you submit an idea for this, I’d vote for it.

‎04-25-2024

As of ArcGIS Pro 3.1, it's possible to duplicate a record in a standalone table using the duplicate context-menu option in the attribute table. Bud_1-1714049376250.png Implemented Idea: Ability to edit standalone tables in ArcMap just as easily as feature classes Copy and paste a non-spatial record in the same table (make a duplicate a record) Copy and Paste Selected Table Rows in Standalone File Geodatabase Table

‎04-24-2024

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB; SDE.ST_GEOEMTRY: I have an issue with an annotation FC: In 2.9.12, I get a "shape integrity error" when I open the attribute table and navigate to the last row. But I don't have that problem in 2.9.5. When I copy/paste the FC to an EGDB or FDGB via Catalog, I get a "shape integrity error". If I export using Feature Class to Feature Class, only 72 of 800 features get exported. Same problem with the Append tool in a blank annotation FC. If I exclude row 73 via a selection, then 357 rows of 799 get exported; still, not all features get exported. I haven't had any luck trying to exclude additional rows in the 355-360 range. Still, only ~355 rows get exported. The Repair Geometry tool doesn't support SDE.ST_GEOEMTRY. Esri Case #03605230 - What is CopyMultiple? (Catalog copy/paste shape integrity error) It seems like some rows are broken and preventing GP tools from working properly. I think it would help to have a GP tool that would export the features one-by-one to a FC. If the tool comes across an error, it could log the issue for each feature in a separate error table, and then move on to the next feature. That would be more useful than the behaviour in other GP tools that produce a generic error (no indication of what rows are the problem) or only exporting a subset of the rows. I don't have the skills to do this in Python. I got the idea from this Oracle PL/SQL function: Find problem XML values by catching XMLTABLE() errors in custom function

‎04-24-2024

Related: Catalog Pane — Load option in annotation FC context menu

‎04-24-2024

ArcGIS Pro 2.9.5; file geodatabase: When I right-click an empty annotation FC in the Catalog Pane, I don't see a Load/Append option: Bud_0-1713989419115.png Could that functionality be added to allow us to easily load features from an existing annotation FC? Related: Catalog Pane — Context menu option to export annotation FC Esri Case #03605230 - What is CopyMultiple? (Catalog copy/paste shape integrity error) Find & repair problem ST_GEOMETRY rows — "Shape integrity error"

‎04-22-2024

For what it's worth, this is the format coordinates are in when I'm copying them to the Go To XY tool in Pro: Lat: 44.72332° N Lon: 77.54425° W Bud_2-1713819977933.png Or: 44.723320, -77.544250 Bud_3-1713819996135.png

My Ideas

Latest Contributions by Bud

Re: Find & repair problem ST_GEOMETRY rows — "Shape integrity error"

Re: List of GP tools that export a FC

Re: List of GP tools that export a FC

List of GP tools that export a FC

Use the Copy GP tool to copy data to a different workspace

When GP tool throws an error, indicate what row/ObjectID the tool got stuck on

Re: Copy standalone table row to a different table

Copy standalone table row to a different table

Re: Popups: Sort related records?

Re: Popups: Sort related records?

Re: Copy a row in a GDB Table to same GDB Table

GP tool to export one feature at a time and log problem features in an error table

Re: Catalog Pane — Context menu option to export annotation FC

Catalog Pane — Load option in annotation FC context menu

Re: Go To XY Lat-Lon Pair Input Box

Integrate ArcGIS Data Pipelines in ArcGIS Enterpri...

Send configurable email notifications from ArcGIS ...

Re: How reliable are ArcGIS Online webhooks?

How reliable are ArcGIS Online webhooks?

Sharepoint List Connector

GIS Jobs

Roads and Highways User Group (RHUG)

Local Government Solutions Users

Mapping and Charting Enterprise Databases

ArcGIS Arcade