From 20ee2c92b1a96eef5e54cf2d420ef5b5f53a33a6 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sun, 7 Sep 2025 23:02:24 +0000 Subject: [PATCH] Give the unknown individuals a bccertainty and a sex --- conversion/clean.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) diff --git a/conversion/clean.sql b/conversion/clean.sql index c88772c..8759d4a 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -44,3 +44,25 @@ INSERT INTO people (person, name, description) , ('SF', 'SF', '') , ('ICG', 'ICG', '') , ('UNK', 'Unknown', 'The unknown person'); + +-- +-- Clean the unknown individuals +-- + +-- Clean up bccertainty +UPDATE biography + SET b_bgcertainty = 'U' + WHERE b_animid IN ('MGM', 'MGF', 'MGF2', 'MGF3', 'UNK'); + +-- Clean up sex +UPDATE biography + SET b_sex = 'M' + WHERE b_animid = 'MGM'; + +UPDATE biography + SET b_sex = 'F' + WHERE b_animid IN ('MGF', 'MGF2', 'MGF3'); + +UPDATE biography + SET b_sex = 'M' + WHERE b_animid = 'UNK'; -- 2.34.1