From 6980fb567350422b7601db2f34af8cfad1f09951 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 8 Sep 2025 15:14:11 +0000 Subject: [PATCH] Support converting MGM, MGF, MGF2, MGF3 --- conversion/clean.sql | 13 ++++++++++++- conversion/load_data.sql | 7 +++++-- 2 files changed, 17 insertions(+), 3 deletions(-) diff --git a/conversion/clean.sql b/conversion/clean.sql index 8759d4a..0010e14 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -49,9 +49,20 @@ INSERT INTO people (person, name, description) -- Clean the unknown individuals -- --- Clean up bccertainty +-- Clean up bccertainty, firstborn, birthdate, bdmin, bdmax, bddist, +-- entrydate, entrytype, departdate, departdateerror, departtype UPDATE biography SET b_bgcertainty = 'U' + , b_firstborn = 'U' + , b_birthdate = '1900-01-01' + , b_bdmin = '1900-01-01' + , b_bdmax = '2025-01-01' + , b_bddist = 'U' + , b_entrydate = '1900-01-01' + , b_entrytype = 'X' + , b_departdate = '2025-01-01' + , b_departdateerror = 0 + , b_departtype = 'X' WHERE b_animid IN ('MGM', 'MGF', 'MGF2', 'MGF3', 'UNK'); -- Clean up sex diff --git a/conversion/load_data.sql b/conversion/load_data.sql index a40cef7..4649283 100644 --- a/conversion/load_data.sql +++ b/conversion/load_data.sql @@ -54,14 +54,17 @@ INSERT INTO departtypes (departtype, description) VALUES ('D', 'Death') , ('E', 'Emigration') , ('P', 'Permanent disappearance') - , ('O', 'End of observation; Present in the most recent census'); + , ('O', 'End of observation; Present in the most recent census') + , ('X', 'Used for unknown individuals'); +show search_path; -- entrytypes INSERT INTO entrytypes (entrytype, description) VALUES ('B', 'Birth') , ('I', 'Immigration') , ('C', 'Start of confirmed AnimID') - , ('O', 'Initiation of close observation'); + , ('O', 'Initiation of close observation') + , ('X', 'Used for unknown individuals'); -- people -- Copied from clean.people, which we manually constructed. -- 2.34.1