Re: Data sets over time

[Michael Sallman <msallman@pro-ns.net>]

Chris and all,

Yes it does. I have a table that contains the image information from the 
*.list files that are generated by Michael R.'s pipeline.

mysql> describe images;
+---------------+------------------------+------+-----+---------+----------------+
| Field         | Type                   | Null | Key | Default | Extra 
          |
+---------------+------------------------+------+-----+---------+----------------+
| id            | int(10) unsigned       |      | PRI | NULL    |
| fits_file     | tinytext               |      | MUL |         | 

| image_jd      | decimal(12,5) unsigned |      | MUL | 0.00000 |
| exposure      | decimal(5,1) unsigned  |      |     | 0.0     | 

| center_ra     | decimal(7,4) unsigned  |      |     | 0.0000  | 

| center_dec    | decimal(7,4)           |      |     | 0.0000  | 

| sky_val       | smallint(6)            |      |     | 0       | 

| sky_sig       | decimal(5,2)           |      |     | 0.00    | 

| fwhm          | decimal(4,2)           |      |     | 0.00    | 

| num_stars     | mediumint(9)           |      |     | 0       | 

| zeropoint     | decimal(5,3)           |      |     | 0.000   | 

| color_correct | decimal(5,3)           |      |     | 0.000   | 

| include       | tinyint(4)             |      |     | 0       | 

| camera        | enum('h','i','j')      |      |     | h       | 

| band          | enum('v','i')          |      |     | v       | 

| quality       | tinyint(4)             |      |     | 1       | 

+---------------+------------------------+------+-----+---------+----------------+

mysql> select count(*) from images;
+----------+
| count(*) |
+----------+
|   182268 |
+----------+

Mike

Chris Albertson wrote:
> Tom,
> 
> It was my understanding that the pipline carries data from the
> FITS headers into the product files and these files are read into
> the database.  I'm pretty sure that the data points are tracable
> to the FITS files in the database but I don't have access to the 
> database's table structure right now but is has to be in there
> 
> 
> 
>>At the present, all the data is in piles of CD cake boxes labeled by
>>month
>>and camera.  So there are about 50 cake boxes at the moment. 
>>2000-2500
>>CDs.  Growing by 3-6 cake boxes per month.  Over 200 CDs from
>>September so
>>far.  
>>
> 
> 
> =====
> Chris Albertson
>   Home:   310-376-1029  chrisalbertson90278@yahoo.com
>   Cell:   310-990-7550
>   Office: 310-336-5189  Christopher.J.Albertson@aero.org
>   KG6OMK
> 
> 
> 		
> _______________________________
> Do you Yahoo!?
> Declare Yourself - Register online to vote today!
> http://vote.yahoo.com
> 
>