From d530b3947be0122f5c222c6276b6a9da449de272 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 13 May 2026 03:37:49 +0000 Subject: [PATCH] Fix for problem #65 --- conversion/clean.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/conversion/clean.sql b/conversion/clean.sql index bff86ab..2e78b94 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -529,3 +529,13 @@ UPDATE follow_arrival UPDATE follow_arrival SET fa_data_source = 'None' WHERE follow_arrival.fa_data_source IS NULL ; + + +-- Problem #65 +UPDATE aggression_event + SET ae_bad_observation_flag = NULL + WHERE ae_bad_observation_flag = ' '; + +UPDATE aggression_event + SET ae_bad_observation_flag = 'X' + WHERE ae_bad_observation_flag = 'YES'; -- 2.34.1