Skip to content

APERO Object Identification

Thomas Vandal edited this page Jun 14, 2021 · 5 revisions

APERO Object ID sheet

The APERO Object ID Google sheet (contact Thomas, Neil or Charles for the link) stores a list of objects analyzed with apero. To keep this document up to date with local databases containing SPIRou observations, a script is available (full_update.py). A requirements.txt file is also provided in this directory with all the packages required to run this script (conda-forge is required to install some of these packages with conda). It can thus be used to update the sheet with local information from any database, provided the user has write permission for the Google document.

Updating the Sheet

The full_update.py script reads local .fits headers and updates the information on the sheet, adding new objects as new rows, adding aliases for known objects, and updating RV/TEFF information. It goes through the following steps:

  • Identify duplicates based on object name.
  • Identify new objects and aliases with Gaia IDs from SIMBAD.
  • Cross-match remaining objects based on position to find a Gaia ID.
  • Verify the cross-match by comparing the object name with SIMBAD results for the ID found.
  • Add confirmed new objects and aliases to the Info tab.
  • Add uncertain new objects to a separate tabs Need Sorting

Objects that end up in "Neeed Sorting" can the be verified manually. Once the object has been confirmed and the information has been updated, it can be marked as CHECKED in the sheet. An automated script will then move this object to the "Info" sheet (as a new object or an alias). The script, remote_update.py, can be run by a user with editing permission and a proper gspread-pandas setup, but a periodic execution also takes place to ensure the sheet is up to date.

To run the *_update.py scripts, a gspread-pandas setup is needed. See the dedicated wiki page on working with Google sheets in Python.

Freezing objects

If users have a better TEFF or RV value than the CFHT header and want to prevent them from being modified, they should mark the object as MANUAL_EDIT=TRUE in the sheet. This will not freeze other columns.

Aliases

Aliases allow to group together names from the headers that represent the same objects. SIMBAD aliases are added by default. Users can add other aliases at the end, separating them with a pipe ("|") symbol. The automated scripts will sort the aliases, but will not erase them.

Clone this wiki locally