Yaml and template spring cleaning after 6 years and way too many properties

What I’m trying to do

After 6 years and a vault filled with 15,000 pages of too many subjects to name, I need to fix up my yaml. I have too many properties that I don’t need, too many inconsistencies, and it’s starting to affect how I search/use dataview and/or bases.

I need a base to list “all properties that are not empty” filtered by folder. Then I could have a quick view of all the properties, including those I hardly use and those I use a lot, and I could easily rename things directly in the base.

Things I have tried

Alas, there is no such option, nor is there a way that I could think of to list that many columns (all non-empty properties).

Of course I looked at the “properties” menu in the navigation pane, and that does a great job of displaying which properties are used how many times, but to change/merge/delete from that menu is way inefficient (one file at a time).

:red_question_mark: What do people do when its time for a good yaml (and therefore template) spring cleaning?