[Babase] Please review a darting view
Niki Learn
nlearn at princeton.edu
Fri Jul 2 15:52:29 EDT 2010
Oops, sorry. Didn't notice it was a view. Yeah, I see that table too. What about standard error? Much more useful for most things (especially graphing) than standard deviation. Can we invent sql for standard error without dividing stdev() by sqrt(count())? (How come babase has two d's in stdev?)
-----Original Message-----
From: babase-bounces at eeblistserv.Princeton.EDU [mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Karl O. Pinc
Sent: Friday, July 02, 2010 3:41 PM
To: The Baboon Database Project
Subject: Re: [Babase] Please review a darting view
On 07/02/2010 12:25:52 PM, Niki Learn wrote:
> I see crownrumps.
That's the underlying table. CROWNRUMP_STATS
is a view and so shows up in a different place
in ppa.
>
> -----Original Message-----
> From: babase-bounces at eeblistserv.Princeton.EDU
> [mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Karl
> O.
> Pinc
> Sent: Friday, July 02, 2010 12:31 PM
> To: The Baboon Database Project
> Subject: Re: [Babase] Please review a darting view
>
> On 07/02/2010 11:22:40 AM, Susan Alberts wrote:
> > Sorry, I am not seeing this in test. Susan
>
> crownrump_stats? (There's no data.)
>
> Maybe to see it on the list you need to reload
> your browser page?
>
> > On Jul 2, 2010, at 12:09 PM, Karl O. Pinc wrote:
> >
> > > On 07/02/2010 09:24:02 AM, Susan Alberts wrote:
> > >> Karl,
> > >>
> > >> this looks fine to me–very clear and straightforward.
> > >
> > > Ok. The view is now in babase_test and can be tested there.
> > >
> > > This is also the last chance to change column names, or
> > > the table name. I'll pattern the rest of the views
> > > off these names. Some seemed a bit long but were the
> > > best I could come up with.
> > >
> > > FYI, I used the name CRsamps instead of something like
> > > CRcount because we've counts in the TICKS table and
> > > it seemed like it would get confusing.
> > >
> > >>
> > >> Susan
> > >> On Jul 2, 2010, at 1:08 AM, Karl O. Pinc wrote:
> > >>
> > >>> Hi,
> > >>>
> > >>> Here's CROWNRUMP_STATS, the view that summarizes
> > >>> multiple crown to rump measurements taken during
> > >>> a darting. Please review.
> > >>>
> > >>> CROWNRUMP_STATS (Darting Crown-To-Rump Statistics)
> > >>> http://papio.biology.duke.edu/babase_system_html/ch06s04.html
> > >>>
> > >>> Once we work the kinks out of this I'll whack out
> > >>> the rest of the "summary" views for darting.
> > >>>
> > >>>
> > >>> 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. Phone 919-660-7272, FAX 919-660-7293
> > >>
> > >>
> > >>
> > >>
> > >> _______________________________________________
> > >> Babase mailing list
> > >> Babase at www.eco.princeton.edu
> > >> http://www.eco.princeton.edu/mailman/listinfo/babase
> > >>
> > >>
> > >
> > >
> > >
> > >
> > > 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. Phone 919-660-7272, FAX 919-660-7293
> >
> >
> >
> >
> > _______________________________________________
> > Babase mailing list
> > Babase at www.eco.princeton.edu
> > http://www.eco.princeton.edu/mailman/listinfo/babase
> >
> >
>
>
>
>
> 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
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>
>
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
More information about the Babase
mailing list