IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 1 and Version 2 of ZoologyDatabase


Ignore:
Timestamp:
Aug 25, 2011, 11:39:22 AM (15 years ago)
Author:
Serge CHASTEL
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ZoologyDatabase

    v1 v2  
    1 * Database is on ipp001, named Zoology
     1= Introduction =
     2 * Database is on ipp001, named Zoology
    23{{{
    34use Zoology;
    45}}}
     6 * Scripts are in /data/ipp001.0/zoology/bin (you have to "source bin/sourceMe.YOUR_SHELL" to make the Python scripts to work);
     7 * Fits files are in /data/ipp001.0/zoology/data (they come from Heather)
     8 * SQL queries which were generated from fits files by Python scripts are in /data/ipp001.0/zoology/sql
     9 * Dependencies: pyfits source is in /data/ipp001.0/zoology/external and installed in /data/ipp001.0/zoology/local
     10
     11= Table(s) =
     12
     13== Table DetectionFeatures ==
     14
     15 * All detections from footprint have been ingested into the DetectionFeatures table (ask Heather where she got them)
     16 * All fields from fits files data/footprint-<filter>-all-psphot.fits have been ingested
     17 * Six columns have been added:
     18   * id: primary key, no use.
     19   * idet_x, idet_y are first and second numeric values found in idet (i.e. 'skycell.<idet_x>.<idet_y>')
     20   * stack_id is derived from SKYCELL: fits[1].data['skycell'].split('/')[0]
     21   * filter is g, r, i, y, or z
     22   * unmatched is a boolean telling if the detection is a false positive (keys: (stack_id, idex_x, idet_y))
     23
     24= View(s) =