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