Start a new topic

Delete duplicate, mistaken, redundant Cemeteries, Photos, Records, etc. - database cleanup?

When I'm bored, I often enjoy browsing for data that needs cleaning up or removal.

Could a single thread be used as a starting point (or can you suggest a better method) for continuing requests for cleanup issues?

That is, not explicitly a 'ticket' to be actioned and closed; rather a discussion, ongoing?

For example - locations to delete or suggested revisions:
https://billiongraves.com/cemetery/Ceremation-Ground/211696 <-- noted for deletion
https://billiongraves.com/site-map?country=United+Kingdom&state=Cymru <-- Cymru is just the Welsh name for Wales
https://billiongraves.com/site-map?country=DELETE+-+DUPLICATE
https://billiongraves.com/site-map?country=DELETE+
https://billiongraves.com/site-map?country=The+Bahamas <-- to align with standards, remove "The"?
https://billiongraves.com/site-map?country=The+Gambia <-- to align with standards, remove "The"?
https://billiongraves.com/site-map?country=Republic+of+the+Congo <-- to align standards, remove "Republic of the" (many countries have 'Republic of' in their name, but are not shown here.

https://billiongraves.com/site-map?country= <-- used for missing country - but maybe could be first in the list vs. last, so more people would notice it?  

I also have recently noticed that one transcriber doing a lot of my recent photos, likely has a stuck space bar on their computer, so several hundred transcribed names show as "Smith , John" or "Smith, John " or " Smith, John" or similar.  Does not seem to affect the search functions on BG, but potentially could impact external searches of BG data,
Depending on your dbase format, a simple SQL query (or even a manual filter) could quickly eliminate the redundant spaces.  Is your dbase guru up to the task?
Example: https://billiongraves.com/site-map?cemetery_id=148041&page=0 <-- search for " ," - currently 189 on this page alone.

Login or Signup to post a comment