[Babase] Males with Matgrp 9, not in grp 9 at birth
Susan Alberts
alberts at duke.edu
Sat Dec 26 22:25:38 EST 2009
>
> Maybe what's left are the males that really were in the
> study groups when real censuses started?
The condition that Lacey was trying to fix was one in which the male
had matgrp = 9 but was in study group since his _birth_. That
condition isn't logically possible. The males you list below don't
have that condition (at least not all of them do, I did not check them
all).
For instance, one of the males you pulled out below, DAR, is in matgrp
9 from birth until he immigrates into Alto's. This is correct now. In
other words, Lacey's fix worked on this male. I'm not sure what the
query you did was but maybe if Lacey just double checks to confirm she
has corrected it, then you and she can take it from there.
Susan
>
> babase=> select distinct sname from census where status = 'B' order by
> sname;
> sname
> -------
> ALY
> BAR
> BJX
> COW
> DAR
> DUT
> HAR
> IBI
> IVA
> KUS
> LIP
> MAX
> MWA
> NGU
> PET
> PIG
> RAD
> SEK
> SIN
> SLK
> STB
> TUL
> WYM
> (23 rows)
>
>
> babase=> select census.grp, census.sname, biograph.matgrp, count(*)
> from census, biograph where census.status = 'B' and biograph.sname =
> census.sname group by census.grp, census.sname, biograph.matgrp order
> by census.grp, census.sname;
> grp | sname | matgrp | count
> ------+-------+--------+-------
> 1.00 | BJX | 9.00 | 4
> 1.00 | COW | 9.00 | 210
> 1.00 | DUT | 9.00 | 1486
> 1.00 | IVA | 9.00 | 329
> 1.00 | MAX | 9.00 | 2023
> 1.00 | PET | 9.00 | 2639
> 1.00 | SIN | 9.00 | 471
> 1.00 | STB | 9.00 | 1564
> 2.00 | ALY | 9.00 | 515
> 2.00 | BAR | 9.00 | 664
> 2.00 | HAR | 9.00 | 810
> 2.00 | LIP | 9.00 | 98
> 2.00 | SEK | 9.00 | 232
> 2.00 | SLK | 9.00 | 1902
> 2.00 | WYM | 9.00 | 222
> 3.00 | NGU | 9.00 | 1853
> 3.00 | RAD | 9.00 | 3078
> 3.00 | TUL | 9.00 | 1494
> 4.00 | IBI | 9.00 | 570
> 4.00 | KUS | 4.00 | 3413
> 4.00 | MWA | 9.00 | 4019
> 4.00 | PIG | 9.00 | 121
> 6.00 | DAR | 9.00 | 1
> 9.00 | DAR | 9.00 | 3638
> 9.00 | IBI | 9.00 | 3267
> (25 rows)
>
> A lot seem to match the pattern shown below....
>
> babase=> select * from census where census.sname = 'BJX' order by
> census.date;
> cenid | date | sname | grp | status | cen
> ---------+------------+-------+-------+--------+-----
> 2024695 | 1971-07-31 | BJX | 1.00 | A | t
> 2024694 | 1971-08-01 | BJX | 1.00 | C | t
> 147562 | 1971-08-02 | BJX | 1.00 | B | f
> 147635 | 1971-08-03 | BJX | 1.00 | B | f
> 147708 | 1971-08-04 | BJX | 1.00 | B | f
> 147781 | 1971-08-05 | BJX | 1.00 | B | f
> 147924 | 1971-08-06 | BJX | 99.00 | S | f
> 147997 | 1971-08-07 | BJX | 99.00 | S | f
> 148070 | 1971-08-08 | BJX | 99.00 | S | f
> 148143 | 1971-08-09 | BJX | 99.00 | S | f
> 148216 | 1971-08-10 | BJX | 99.00 | S | f
> 148289 | 1971-08-11 | BJX | 99.00 | S | f
> ...
>
> While you're cleaning up arn't the 'S' rows with
> a group of 99.00 redundant and able to be eliminated?
>
>
> Karl <kop at meme.com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
--------------------------------------------------------
Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC
27708, 919-660-7272 (Ph), 919-660-7293 (Fax)
More information about the Babase
mailing list