This repo is a proof of concept for a GAIA Web Service for Siril
There are two python scripts
This is a python script which parses the html page at https://cdn.gea.esac.esa.int/Gaia/gdr3/gaia_source/ to get a list of csv file urls. It then downloads each file and processes it to ignore any line that doesn't meet the following criteria :-
- has_xp_sampled = True OR has_xp_continuous = True
- phot_g_mean_mag <= 15
It does this with a worker pool (default size 8). Each worker downloads and processes a file, deleting the file after it's complete. The worker outputs csv lines to a queue. A separate thread watches the queue and writes the lines to the output file. This is much more efficient than locking the file for write on multiple threads. The output file can then be bulk loaded into Postgres. This script does not do this step (yet)
This is a python script which parses the html page at https://cdn.gea.esac.esa.int/Gaia/gdr3/Spectroscopy/xp_sampled_mean_spectrum/ to get a list of csv file urls. It then downloads each file and processes it to ignore comments, convert arrays to postgres format, and use the bulk loader to import into a Postgres temporary table. It then prunes this table to remove any lines that are not present in the star table as populated by the previous script and copies the remainder into the spectra table.
This is a PostgresQL database with pgSphere extension. This allows us to populate the astro data and create an index for the astro coordinates. This means we can then look up stars within a certain radius.
Specifies a schema for the PostgresQL database with pgSphere extension
This is an asynchronous FastAPI app that exposes 2 GET endpoints:-
- /star/<source_id>
- /stars?ra=&dec=&radius=&mag=
- /spectra/<source_id>
- /spectras?ra=&dec=&radius=&mag=
Run with /usr/bin/uvicorn main:app --host 0.0.0.0 --port 8000
This is a Python script which will create an offline binary file containing the star and flux data. The flux data is scaled per star and stored as a 16bit half-precision float.
This is based almost entirely on a KStars data tool and is designed to read the binary file and report on any issues