Download Tables of All Public Observations

KOA provides ASCII tables, updated weekly on Wednesday, which contain records of all public science and calibration data for each instrument (except GUIDER which does not have public data yet.)

These tables may be useful for researchers who have large lists of search positions, who expect to download large volumes of data, or who prefer to perform filtering/searching using their own tools or scripts.

The tables are made available in two ASCII formats: in Comma Separated Values (CSV) format, which may be imported into Microsoft Excel, and as IPAC table format, which is a column-delimited and self-describing format.

The tables include a subset of the full attributes (keywords) of each instrument.

Column descriptions are unique to each instrument, and summarized in the documentation links included.

There are two methods where the tables can be used for direct download:

• Use the contents of the fileurl column: Contains the URL for directly downloading individual KOAID files for all instruments.
• Use the IPAC formatted table to download Level 0 (raw) for all instruments and Level 1 data for: HIRES, LWS, NIRC2, NIRSPEC, and OSIRIS with PyKOA. While the IPAC tables can be used with PyKOA for downloading data, given that the IPAC tables contain all public data, they are not meant to be used as-is given the volume of data.
  Level 0 (raw) data: Edit the IPAC formatted table file to include all the header lines and all the columns and only the rows with data you are interested in. Do not try to download all the rows at once, but create a file for a few nights at a time. Here is a HIRES example where a table has been created called "your_hires_table.tbl' from the downloaded IPAC table to download the level 0 (raw) data:

  from pykoa.koa import Koa
  Koa.download ('./your_hires_table.tbl', 'ipac', 'dnload_dir_hires_lev0')

  Level 1 data: Edit the IPAC formatted table to include all the header lines and the columns and only those rows where koaimtyp = 'object' files for data you are interested in. Do not try to download all the rows at once, but create a file for few nights at a time. Here is a HIRES example where a table has been created called "your_hires_table.tbl' from the downloaded IPAC table to download the level 0 (raw) and level 1 data for the koaimtype = 'object' files:

  from pykoa.koa import Koa
  Koa.download ('./your_hires_table.tbl', 'ipac', 'dnload_dir_hires_lev1', lev1file=1)