Re: Printing

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

Peter,

I can dump a list of all the images out of the database here.

Here's what there is for each image:

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       |
+---------------+------------------------+------+-----+---------+----------------+
16 rows in set (0.02 sec)

Let me know if you want any/all of the info.

Mike

Peter Stewart wrote:
> Sorry Tom,
> I must have missed something. Does Doug have a database or list or somthing?
>  
>  
>  
> Regards,
>  
> Peter Stewart
> Application Manager
> Information Services - Herston
>  
> 3636 6253
>  
> 0412 355 666
> 
>  >>> <droege@snapmail.us> Friday, December 03, 2004 10:53:31 am >>>
> Peter,
> 
> I think that Doug Welch has done this in order to make his data base work.
> Since he has written code that lets you request all images with a
> particular star in them, he must have read all the images and made a table
> of their center position from the fits header?
> 
> Tom Droege
> 
> 
>  > Hi All
>  > I know I should be able to find this information somewhere on the list or
>  > on the web site, but I'm a little time poor at this moment, so I'm taking
>  > the easy route.....
>  >
>  > I've been looking at some of the fits images on Tom's network, and am
>  > wondering if there is a location that has a list of the images with the
>  > coords of the center of image?
>  >
>  > The answer is probably right in front of me, but as always invisable
>  > unless you are not looking for it.
>  >
>  > Many Thanks,
>  >
>  > Peter
>  >