Latest Contributions by Bud

@JesseWickizer In your screenshot, if the annotation FC is feature-linked, then why is the Related feature class name field blank?

Thanks @JesseWickizer. I don't see the Annotation section in the Properties > Source of an annotation feature class in 2.9.12: So maybe that's new functionality that's been added in a later version.

Another idea could be to grey-out the non-editable area (the area that's outside of the projection).

I think the problem is an annotation feature class. The annotation FC gets automatically copied with the main point FC due to a relationship class. The reason I think the problem is the annotation FC: I can add the annotation FC to a map without errors. And the annotations show up in the map if I zoom in. However, when I open the attribute table and navigate to the last row, I get an error: Failed to load data. Error: Shape integrity error I haven't determined the cause of that error yet.

ArcGIS Pro 2.9.12; File Geodatabase: I have a feature-linked annotation FC. When I create new annotation features for existing lines, I need to manually populate the annotation's Feature ID field in order to link the annotation feature to the line feature. Idea: Instead of manually entering the Feature ID, click the existing line to automatically create a linked annotation. Video:

ArcGIS Pro 2.9.12; Oracle 18c 10.7.1 EGDB: As far as I can tell, there isn't a way to determine in the Catalog properties if an annotation feature class is feature-linked or not. Could that functionality be added? If I understand correctly, the presence of a relationship class doesn't necessarily indicate that the annotation is feature-linked.

ArcGIS Pro 2.9.12; File Geodatabase (and Oracle 18c 10.7.1 EGDB): I've created an annotation FC using the Create Feature Class wizard in Catalog: The annotation FC is shown as SHAPE = Polygon in the attribute table. Idea: Show the SHAPE as Annotation, not Polygon. I think that would be more intuitive. Related: Annotation shown as SHAPE=Polygon in attribute table

ArcGIS Pro 2.9.12; file geodatabase: I have a line FC and a feature-linked annotation FC. When I create a line, an annotation feature gets automatically created, which is expected. But the annotation feature's STATUS field is 'Unplaced'; an annotation is not displayed in the map. How can I place an unplaced annotation in ArcGIS Pro? Video:

ArcGIS Pro 2.9.12; File Geodatabase (and Oracle 18c 10.7.1 EGDB): I've created a feature-linked annotation FC using the Create Feature Class wizard in Catalog: Why is the annotation FC shown as SHAPE = Polygon in the attribute table? I would have expected the SHAPE to be Annotation, not Polygon.

I found Route Event Layers were extremely slow in some versions of Pro, like 2.9.12. Removing the geoprocessing history from the FC metadata helped a lot, but it was still slow compared to other versions, so it was clearly a bug. Route Event Layers — Slow performance in ArcGIS Pro 2.9.12, but not in 2.6.8 Maybe upgrading to a newer version of Pro would help.

I don't like your join: FROM FCS.FCS_LICENSES, FCS.FCS_ESTABLISHMENTS, FCS.FCS_LICENSE_OWNERS, FCS.FCS_LOCATIONS, FCS.FCS_CITIES, FCS.FCS_ZIP_CODES It looks like you're doing a CROSS JOIN/cartesian product, and then narrowing down the results in the WHERE clause. The commas in you SQL are basically CROSS JOINs. Comma-separated join (cross join) You should be using a LEFT [OUTER] JOIN or an [INNER] join. https://oracle-base.com/articles/misc/sql-for-beginners-joins If you're rusty with SQL, you could mock up the query in MS Access using the graphical query builder, then grab the auto-generated SQL and convert it to Oracle SQL for the query layer in Pro. (To bring the data into Acess for testing, you could either export the data from Pro and import into an access database. Or set up an ODBC connection and dynamically connect to the Oracle data in Access.)

Most query layer issues are caused by duplicate IDs or nulls in the unique ID column. Especially when the error is something like the one you mentioned: "failed to retrieve a page of rows." I suggest running the query in a SQL client like SQL Developer or Toad, and checking for duplicate IDs or nulls in the unique ID column there. The reason I suggest using a SQL client for that check, not ArcGIS Pro, is that Pro automatically excludes duplicate rows, which is misleading and not helpful when troubleshooting issues like this. If you are having trouble finding a truly unique id column in your data for the query layer, use Oracle's ROWNUM pseudo column: SELECT CAST(ROWNUM AS INT) AS UNIQUE_ID, Related: Record counts - publishing from ArcGIS Pro vs ArcGIS Desktop (ArcMap) Also, ArcGIS Pro 2.0.7 is beyond ancient. I don't envy you. I thought my organization's 2.6.8 environment was bad. Newer versions are slightly better at handling query layer result sets.

ArcGIS Pro 2.9.12; Oracle 18c 10.7.1 EGDB; SDE.ST_GEOMETRY: I'm troubleshooting an issue where I can't copy/paste a point FC via Catalog within the same enterprise geodatabase. Copying to a file geodatabase or a mobile geodatabase doesn't work either. But copying to a personal geodatabase in ArcMap does work. Find & repair problem ST_GEOMETRY rows — "Shape integrity error" I get this error: Copy Failed Message [Error]: ERROR 000260: Shape integrity error Failed to execute (CopyMultiple). That error message mentions something called "CopyMultiple". Is CopyMultiple a geoprocessing tool? I don't see any geoprocessing tools listed in the Geoprocessing Pane in Pro with that name.

For my notes: This issue also applies to ArcGIS Pro 2.9.12. ... View more

For my notes: This issue also applies to ArcGIS Pro 2.9.12.

ArcGIS Pro 2.9.12; Oracle 18c 10.7.1 EGDB; SDE.ST_GEOMETRY: When I make table design changes to a EGDB FC, I have a workflow where I make a backup to a FGDB. In the Catalog Pane, I copy the EGDB FC and paste it into an FGDB. The benefit of copying/pasting via Catalog is that all GDB functionality gets preserved in the copy, including domains, an entire feature dataset, etc.. It's an easy way to back up a FC (or FD) and everything that comes with it, compared to using GP tools that are clunkier to use and strip out some GDB functionality. That workflow generally goes smoothly. But there are cases where I want to exclude some rows from the copy FC. For example, I have an issue where I can't copy a line EDGB FC to a FGDB. I get an error: Copy Failed Message [Error]: ERROR 000260: Shape integrity error Failed to execute (CopyMultiple). (My current workaround is to copy to a personal GDB via ArcMap, then from the PGDB to the FGDB. I don't get the error that way. But that workaround won't be possible when I lose ArcMap; using an intermediary mobile geodatabase instead of a PGDB doesn't seem to work.) I have that issue in ArcMap 10.7.1, Pro 2.6.8 and 2.9.12. Find & repair problem ST_GEOMETRY rows — "Shape integrity error" I don't know what the problem is in that FC. And I can't check or fix the FC using ArcGIS Pro functionality because the Repair Geometry geoprocessing tool doesn't support SDE.ST_GEOMETRY. So, I want to try excluding some rows when copying the FC. Such as WHERE SHAPE IS NOT NULL. I was hoping there would be a SQL expression section in the Paste Special dialog. But there doesn't seem to be anything like that. Hint: There is a bug in 2.9.12 where an FGDB's right-click menu doesn't show the Paste Special option. Use CTRL+ALT+V as a workaround. Resolved by at least 3.2.2. Idea: When copying/pasting via the Catalog Pane, filter rows via an SQL expression in the Paste Special dialog.

My Ideas

Latest Contributions by Bud

Re: Catalog FC Properties — Indicate if annotation is feature-linked

Re: Catalog FC Properties — Indicate if annotation is feature-linked

Re: Show the extents of a projected FC in the map — Where can I draw features? (coordinates are out of bounds)

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

Link new annotation to existing feature by clicking on feature

Catalog FC Properties — Indicate if annotation is feature-linked

Attribute Table — Show annotation SHAPE as Annotation, not Polygon

Place unplaced annotation (feature-linked)

Annotation shown as SHAPE=Polygon in attribute table

Re: Extremely long wait when importing an .mxd into ArcGIS Pro...

Re: Edit Query Layer SQL Select Statement Question

Re: Edit Query Layer SQL Select Statement Question

What is CopyMultiple? (Catalog copy/paste shape integrity error)

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

Catalog Pane > Copy/paste item — Filter rows via SQL expression in Paste Special dialog

Rearrange root items in Catalog Pane

Provide sample public Experience Builder map

Select and delete multiple georeferencing control ...

Layer with alias in Contents Pane — Show table nam...

Reduce ArcGIS Pro network traffic

Roads and Highways User Group (RHUG)

GIS Jobs

Mapping and Charting Enterprise Databases