ETL-Astro: An Extract/Transform/Load Framework for Astronomical Catalogs

Yesterday, I released ETL-Astro, a set of Python programs that generate astronomical catalogs in a variety of formats from license friendly data source, allowing for incorporation in GPL-licensed products.

The programs can do the following:

  • Extract stars, up to a certain magnitude
  • Extract Messier, Caldwell, and Herschel 400 catalogs
  • Extract NGC and IC catalogs (requires a minor modification
  • Export in a variety of formats, currently: C/C++ headers, SQL

These tools were used to revamp the catalogs for the Smart Hand Controller (SHC) for OnStep.