User contributions
Jump to navigation
Jump to search
- 19:41, 24 October 2025 diff hist +139 Conversion Data Issues →Solution: Reference problem #26 current
- 19:37, 24 October 2025 diff hist +403 Conversion Data Issues →Solution: Notes on which table is missing in-nest information.
- 23:18, 22 October 2025 diff hist +232 The Old Database →The follow_arrival.fa_type_of_cycle column cleanup: Resolve duplicate follow_arrival rows current
- 22:58, 22 October 2025 diff hist -3 Conversion Data Issues →Bad Data: Use "easy" schema, not "clean"
- 22:57, 22 October 2025 diff hist -3 Conversion Data Issues →Bad Data: Use "easy" schema, not "clean"
- 22:51, 22 October 2025 diff hist -10 Conversion Data Issues →Solution: Use word "focal"
- 22:51, 22 October 2025 diff hist +98 Conversion Data Issues →* (#27) Mismatch of end-in-nest on follow and follow_arrival: Add solution
- 22:50, 22 October 2025 diff hist +109 Conversion Data Issues →* (#26) Mismatch of start-in-nest on follow and follow_arrival: Add Solution
- 22:48, 22 October 2025 diff hist +628 The Old Database →The follow_arrival.fa_type_of_cycle column cleanup
- 18:52, 22 October 2025 diff hist +553 Conversion Data Issues (#55) There are community_membership rows that place an individual in a community before birth
- 18:44, 22 October 2025 diff hist +20 Conversion Data Issues →* (#14) 6 COMM_MEMBS rows place individuals in a community after their BIOGRAPHY.EndDate: Update query and count
- 18:32, 22 October 2025 diff hist 0 Conversion Data Issues →Problem: Update count
- 18:31, 22 October 2025 diff hist +122 Conversion Data Issues →Bad Data: Update query
- 18:19, 22 October 2025 diff hist +67 Conversion Data Issues →* (#13) 234 COMM_MEMBS rows place individuals in a community before their BIOGRAPHY.EntryDate: Change problem definition, only when not in birth group
- 21:39, 20 October 2025 diff hist -2 Conversion Data Issues →* (#51) There are follow_arrivals with invalid fa_data_source values: Resolved, per solution documented, arrived at at today's meeting
- 21:18, 20 October 2025 diff hist -15 Conversion Data Issues →Solution: Fix table
- 21:11, 20 October 2025 diff hist +210 The Old Database →The follow_arrival.fa_type_of_cycle column cleanup: How conversion problem #50 was solved
- 21:08, 20 October 2025 diff hist +69 Conversion Data Issues →* (#50) There are follow_arrivals where females have a cycle code of n/a: Resolve, based on meeting today
- 16:33, 20 October 2025 diff hist +45 Conversion Data Issues →* (#53) There are follow_arrivals where the arriving chimp does not exist: Add solution
- 16:20, 20 October 2025 diff hist +34 Conversion Data Issues →Solution: Use existing codes
- 15:53, 20 October 2025 diff hist +367 Conversion Data Issues →Solution: Note fix
- 15:49, 20 October 2025 diff hist +69 The Old Database →Notes On Data Clean Up and Other Data Transformation Steps: Make conversion data page easy to find
- 12:49, 15 October 2025 diff hist -48 Conversion Data Issues →Bad data: Use MGF codes, not macro names
- 01:18, 15 October 2025 diff hist +1 Conversion Data Issues →Bad Data: Fix markup
- 01:16, 15 October 2025 diff hist +1,310 Conversion Data Issues (#54) There are follow_arrivals where females that are too young have a cycle state code that is not <code>0</code>, <code>U</code>, or <code>MISS</code>
- 21:57, 14 October 2025 diff hist +974 Conversion Data Issues (#53) There are follow_arrivals where the arriving chimp does not exist
- 21:44, 14 October 2025 diff hist +109 Conversion Data Issues →* (#52) There are follow_arrivals that are almost duplicates: What are the rules?
- 23:55, 13 October 2025 diff hist +2,538 Conversion Data Issues (#52) There are follow_arrivals that are almost duplicates
- 20:41, 13 October 2025 diff hist +104 Conversion Data Issues →Bad data: "easy" not "tidy"
- 20:40, 13 October 2025 diff hist 0 Conversion Data Issues →Bad data: "easy" not "tidy"
- 20:39, 13 October 2025 diff hist -1 Conversion Data Issues →(#32) Some follows have an animid that is lower-case: "easy", not "tidy"
- 20:38, 13 October 2025 diff hist 0 Conversion Data Issues →Bad Data: "easy", not "tidy"
- 18:05, 12 October 2025 diff hist -1 Conversion Data Issues →Solution: fix limit number
- 18:04, 12 October 2025 diff hist +171 Conversion Data Issues →Solution: Note that a soft limit can work, temporarily
- 18:03, 12 October 2025 diff hist +342 Conversion Data Issues →* (#49) There are follow_arrivals where females that are too old have a cycle code of U: Add solution
- 18:01, 12 October 2025 diff hist +51 Conversion Data Issues →* (#49) There are follow_arrivals where females that are too old have a cycle code of U: Adjust number of problem rows and query based on new limit; fix query
- 17:46, 12 October 2025 diff hist +78 Conversion Data Issues →Problem: Note, test is against birthdate
- 17:45, 12 October 2025 diff hist +78 Conversion Data Issues →Problem: Note test is against birthdate
- 17:27, 12 October 2025 diff hist +214 Conversion Data Issues →* (#47) There are follow_arrivals where females that are too young have a cycle code of U
- 19:33, 11 October 2025 diff hist +2,015 N PostgreSQL Administration Killing processes current
- 18:59, 11 October 2025 diff hist +32 Administration Add link to PostgreSQL administration current
- 16:29, 10 October 2025 diff hist -2 Conversion Data Issues →Bad data: Use "tidy" schema
- 16:26, 10 October 2025 diff hist +1,255 Conversion Data Issues (#51) There are follow_arrivals with invalid fa_data_source values
- 19:03, 9 October 2025 diff hist +804 Conversion Data Issues (#50) There are follow_arrivals where females have a cycle code of <code>n/a</code>
- 15:38, 9 October 2025 diff hist +1,080 Conversion Data Issues (#49) There are follow_arrivals where females that are too old have a cycle code of <code>U</code>
- 15:07, 9 October 2025 diff hist -1 Conversion Data Issues →Problem: After, not before
- 15:07, 9 October 2025 diff hist +614 Conversion Data Issues select follow_arrival.*, biography.b_entrydate, biography.b_sex from clean.follow_arrival join clean.biography on (biography.b_animid = follow_arrival.fa_b_arr_animid) where biography.b_entrydate > follow_arrival.fa_fol_date order by biography.b_animid, follow_arrival.fa_fol_date;
- 14:51, 9 October 2025 diff hist +962 Conversion Data Issues (#47) There are follow_arrivals where females that are too young have a cycle code of <code>U</code>
- 14:16, 9 October 2025 diff hist +7 Conversion Data Issues →* (#46) There are follow_arrivals where non-females have a cycle code that is not n/a: reword heading
- 03:10, 9 October 2025 diff hist +1,259 Conversion Data Issues (#46) There are follow_arrivals where non-females have a cycle code that is not n/a