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-<filter>-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.<idet_x>.<idet_y>')
  • stack_id is derived from SKYCELL: fits[1].dataskycell.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)