From 8c052324efaf76d35a16281d62676119241c492b Mon Sep 17 00:00:00 2001 From: Stevan Earl Date: Mon, 11 May 2026 18:35:25 +0000 Subject: [PATCH] Resolve problem #63 (cherry picked from commit d1211f4e90ee47da5bdf606656387790b358d391) --- conversion/clean.sql | 5 +++++ conversion/load_support.sql | 4 +++- 2 files changed, 8 insertions(+), 1 deletion(-) diff --git a/conversion/clean.sql b/conversion/clean.sql index 07858c7..bff86ab 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -524,3 +524,8 @@ UPDATE follow_arrival AND (follow_arrival.fa_type_of_nesting <> 2 -- in @ end, only AND follow_arrival.fa_type_of_nesting <> 3 -- in @ both AND follow.fol_flag_end_in_nest = 1))); + +-- Problem #63 There are follow_arrival rows with NULL fa_data_source values +UPDATE follow_arrival + SET fa_data_source = 'None' + WHERE follow_arrival.fa_data_source IS NULL ; diff --git a/conversion/load_support.sql b/conversion/load_support.sql index c0d7b52..d3c7a77 100644 --- a/conversion/load_support.sql +++ b/conversion/load_support.sql @@ -41,7 +41,9 @@ INSERT INTO arrival_sources (code, description) , ('Tiki_SS' , 'Tiki SS') , ('Brec' - , 'Juvenile arrival reconstructed from Brec notes.'); + , 'Juvenile arrival reconstructed from Brec notes.') + , ('None' + , 'Source is not documented.'); -- certainties -- From the MS Word chimp document -- 2.34.1