idea Allow metadata editing to create tables in Usage section in ArcGIS Pro Ideas

Allow metadata editing to create tables in Usage section

DuncanHornby — Thu, 19 Jan 2023 16:29:47 GMT

Historically ArcMap\ArcCatalog provided a great interface for recording metadata and ArcGIS Pro continues this tradition. ArcGIS Pro provides a toolbar for simple formatting when providing content in the Usage section.

Toolbar offering simple formatting choices.

Often when I am entering text into the Usage section I feel that what I want to show is best shown in a simple table format. It would be great if this toolbar could include an "insert table" button allowing me populate the Usage section information formatted into a simple table. I don't think it needs to be the bewildering choice of formatting that MS Word offers up, just a bare bone table something like this:

Bare bones table

Metadata — Track list of data dependencies

Bud — Mon, 23 Jan 2023 21:10:38 GMT

Merged from a separate idea.

I want to track all dependencies my organization has on a given FC — via a list of dependencies in the FC metadata.

For example, track these columns in a "table"/grid in a section in the metadata:

Dependency Name
Date (automatically populated)
Entered By (automatically populated)

In this case, I consider a "dependency" to be something that is hardcoded to domain values in a column of the FC. Examples of dependencies include:

ArcGIS Pro maps: definition queries, symbology, labels, display queries, other?
Web Maps: AGOL and Portal; Field Maps app
Integrations and data translation tables
Database views and .SQL files
Layer files
Names of GIS initiatives that are built on the FC
ODBC queries in MS Access and Excel
More

Use Case:

A stakeholder requested the following: “In layer x, can we split TYPE=CROSSWALK into two separate domain values: CROSSWALK and TRAIL CROSSING OVER ROAD?”

My answer was essentially: “No, there are too many dependencies (known and unknown).”

All existing references to CROSSWALK would need to be updated/split out into CROSSWALK and TRAIL CROSSING OVER ROAD. That would be too difficult to implement. Unfortunately, we've created an unmaintainable monster of dependencies. So we can't justify the work involved to make the change at this time.

With that said, it doesn't need to be that way. If we had a centralized list of dependencies that users could easily find and update, then we wouldn't be in this predicament. We'd be able to refer to the dependency list and update all hardcoded mechanisms as needed, reducing risk and making the request more manageable.

Re: Metadata — Create a list of data dependencies

KoryKramer — Thu, 19 Jan 2023 15:00:05 GMT

@Bud I understand that you're asking for more than seeing where a domain is used, but for that use case specifically, have you used the Domain Usage functionality: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/create-modify-and-delete-domains.htm#ESRI_SECTION1_09CF28B04D4547849DD3A0C15381D558 Maybe that would help.

As for the larger idea, there are similar existing ideas here:

What maps are associated with this shapefile/geodatabase?

ArcGIS Pro: Catalog View See All "Associated Maps" in Layouts

Pro Feature Request: Project-Level Data Connections Report

It seems that your idea potentially fits into these other requests. Could you please review those ideas and let us know if they get at what you're asking for? If not, what specifically makes your idea distinct? Thank you!

Re: Metadata — Create a list of data dependencies

Bud — Thu, 19 Jan 2023 16:06:19 GMT

Thanks Kory.

I basically want to add a spreadsheet-like table/grid as a section in the metadata. And manually enter a list of dependencies into it. It would be ideal if there could be editor tracking of sorts within the list -- for each entry, automatically enter the date and user.

It could be thought of as a sort of dependency log or a FC usage log.

I figure, metadata would be an ideal place to store such information. If a user has access to the FC, then they'd have access to the metadata too, rather than needing to hunt down a spreadsheet on the network somewhere (and deal with file locks and privileges). In other words, metadata is the perfect place to inform users how and where a FC is used -- aka a list of dependencies.

Re: Metadata — Create a list of data dependencies

Bud — Thu, 19 Jan 2023 15:44:57 GMT

(edited)

@KoryKramer I mocked up an example:

Re: Metadata — Track list of data dependencies

KoryKramer — Thu, 19 Jan 2023 16:31:19 GMT

@Bud like what is being requested here? https://community.esri.com/t5/arcgis-pro-ideas/allow-metadata-editing-to-create-tables-in-usage/idi-p/1242238

Re: Metadata — Track list of data dependencies

Bud — Thu, 19 Jan 2023 16:35:38 GMT

@KoryKramer Yes, I believe so, but with the addition of automatic editor tracking.

It needs to be easy to use. I.e., easy to add rows and columns.

Re: Allow metadata editing to create tables in Usage section

AmeliaBradshaw — Mon, 23 Jan 2023 21:11:47 GMT

Hello @Bud ,

I have merged your idea with this idea, mentioned by you and Kory above. Your idea text and the comments are now attached here, but please add a kudo to this idea to make sure your vote is counted.

Thank you!

Amelia