Analyze metadata field usage across CAFE collection

[Saixel]

Summary
Produce a report showing how often metadata fields are populated across CAFE datasets.
Results will inform which fields to prioritize, keep visible, or hide.

Decisions needed

• Target scope: which collections/subcollections?
• Which metadata blocks/fields to include (Citation, Geospatial, custom blocks, etc.)

Approach

• Prepare and use SQL (read-only) to count non-empty values per field and compute % coverage by dataset.

Next Steps

• Confirm scope (collections + blocks/fields).
• Adapt/validate SQL against a non-prod snapshot.
• Coordinate a low-impact window to run in prod (SELECTs only).
• Share CSVs + brief findings.