Changes between Version 2 and Version 3 of ZoologyHints

Timestamp:

Aug 23, 2011, 3:17:24 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

ZoologyHints

@@ -36 +36 @@
 }}}
 
-
-
 This probably loads too much information.  You can turn off the text by going to Region -> Region Parameters -> Show Region Text
 
@@ -43 +41 @@
 
 You can do screen grabs with gimp, or by zooming in and going to File -> Save Image.  
+
+== Database containing detections features (see Action A-002) ==
+It's on neverland.
+{{{
+CREATE DATABASE Zoology;
+USE Zoology;
+
+CREATE TABLE DetectionFeatures (
+  id            INT NOT NULL PRIMARY KEY AUTO_INCREMENT
+  , stack_id    BIGINT(20) NOT NULL
+  , INDEX(stack_id)
+  , filter      CHAR(10) NOT NULL
+  , INDEX(filter)
+  , skycell_id  CHAR(64) NOT NULL
+  , INDEX(skycell_id)
+  , flags       BIGINT(64)
+  , flags2      BIGINT(64)
+  , x_psf       FLOAT
+  , y_psf       FLOAT
+  , idet        CHAR(64)
+  , cal_psf_mag FLOAT
+  , ra_psf      FLOAT
+  , dec_psf     FLOAT
+)
+}}}
+
+Files used to populate the database (fitsExtract.py is located in ~ipp/sch/zoology)
+{{{
+python ./fitsExtract.py /data/ipp009.0/heather/footprint-g-not-matched-psphot.fits columns=ra_psf,dec_psf,x_psf,y_psf,skycell,idet,flags,flags2,cal_psf_mag > populate.g.sql
+python ./fitsExtract.py /data/ipp009.0/heather/footprint-r-not-matched-psphot.fits columns=ra_psf,dec_psf,x_psf,y_psf,skycell,idet,flags,flags2,cal_psf_mag > populate.r.sql
+python ./fitsExtract.py /data/ipp009.0/heather/footprint-i-not-matched-psphot.fits columns=ra_psf,dec_psf,x_psf,y_psf,skycell,idet,flags,flags2,cal_psf_mag > populate.i.sql
+python ./fitsExtract.py /data/ipp009.0/heather/footprint-y-not-matched-psphot.fits columns=ra_psf,dec_psf,x_psf,y_psf,skycell,idet,flags,flags2,cal_psf_mag > populate.y.sql
+python ./fitsExtract.py /data/ipp009.0/heather/footprint-z-not-matched-psphot.fits columns=ra_psf,dec_psf,x_psf,y_psf,skycell,idet,flags,flags2,cal_psf_mag > populate.z.sql
+}}}
+
 
 == Division of labor ==