Re: CADC table requirements.

From: JJ Kavelaars <jjk_at_hia-iha.nrc-cnrc.gc.ca>
Date: Thu, 17 May 2007 13:48:41 -0700

Hi Fred,

To complete the interface for the T0004 retrieval I need you to send
me the contents of the Auto_status and Auto_file tables used for T0004.

We are using the Auto_file table to determine which exposures went
into each of the stacks. We need that information so we can derive
the minimum and maximum date for the exposures that are in the stack
along with the median IQ, min/max IQ, total actual exposure time and
the number of input images for each stack.

Future development: Providence information [like the input images]
should, somehow, be included in the headers of the STACKs so that
users who retrieve the images have access to that content without
have to return to the query pages.

Thanks,

JJ

On 2-May-07, at 5:13 PM, JJ Kavelaars wrote:

>
> On 2-May-07, at 4:52 PM, Frederic Magnard wrote:
>
>>
>> Hi JJ,
>>
>> On Tue, 1 May 2007, JJ Kavelaars wrote:
>>> For the T0003 release we based our db query system on information
>>> gathered
>>> from 2 of your MySQL tables, Auto_file and Auto_status, and to
>>> some extent
>>> also the table Applications
>>>
>>> Can you provide CSV dumps of those 2 tables so that we can ingest
>>> them into
>>> our db System and create the T0004 release tables?
>>
>> No problem to provide you those dumps, but I do not remember we
>> provided
>> them for T0003, did we ? The information about the stacks will not be
>> up-to-date as the stacking process is still going on, is it still
>> OK ?
>>
>> Do you need the whole tables, or just a few columns ?
>
> We have the entire table for T0003. At this point just mirroring
> the structure of T0003 into T0004 is the most straight-forward.
>
> I realize the tables will not be complete [since the stacks are
> being made]. Just send what is current and I will build the
> release from that.
>
> thanks,
>
> JJ
>
>
Received on Thu May 17 2007 - 10:49:23 HST