Module 5: Doing real research · Lesson 5.6 · about 20 min
Open archives: free data from the world's telescopes
Most telescope data become public after a year or less. Archives like Gaia, MAST, ESO, SIMBAD and NASA's exoplanet archive let anyone search by position and filter by brightness with a simple query language, ADQL.
Module 5 · about 20 minutes · read first: 5.5 FITS files and Python on your own laptop, Sky watching 2.2 Right ascension and declination: the sky’s latitude and longitude · maths: SQL and sky geometry. You’ll be able to name the main open archives, write a cone search in ADQL, and plan an archive-only project.
1. Why this matters
You don’t need a telescope to do research. Space missions and big observatories publish their data, usually after a short private period, and more papers now use archive data than new observations. With a laptop you can study a billion Gaia stars, years of TESS light curves or thousands of spectra.
2. Where the data live
- Gaia (ESA): positions, parallaxes, motions, brightnesses and colours for over a billion stars.
- MAST (NASA/STScI): Hubble, TESS, Kepler, JWST and more.
- ESO Science Archive: the Very Large Telescope and other ESO instruments.
- SIMBAD and VizieR (CDS, Strasbourg): what is known about named objects, and thousands of published catalogues.
- NASA Exoplanet Archive: every confirmed planet, with links to the papers.
- Radio archives, sunspot records (SILSO), and the AAVSO variable star database.
Most offer a web form and a TAP service you can query with ADQL from Python (astroquery) or a tool like TOPCAT.
Things to notice:
- Doubling the radius gives four times the area, so about four times as many rows.
- One magnitude fainter roughly doubles to triples the count: plan limits before downloading.
Find every Gaia star near the Orion Nebula:
SELECT source_id, ra, dec, phot_g_mean_mag FROM gaiadr3.gaia_source WHERE 1 = CONTAINS(POINT(ra, dec), CIRCLE(83.82, -5.39, 0.05)).AND parallax_over_error > 10 to keep only stars with good distances.Maths and principle
Angular separation between two sky positions (used by every cone search):
Cone area for a small radius : square degrees. The whole sky is 41,253 square degrees.
ADQL cone search (radius in degrees):
SELECT source_id, ra, dec, phot_g_mean_mag
FROM gaiadr3.gaia_source
WHERE 1 = CONTAINS(POINT(ra, dec), CIRCLE(83.82, -5.39, 0.05))
AND phot_g_mean_mag < 15
3. What it means physically
An archive is the shared memory of astronomy. Every photon a big telescope catches is stored with its calibration, so a question nobody asked in 2015 can be answered from 2015 data today. Because the data are public, anyone can check a published result, which is how science stays honest.
- cos θ = sin δ₁ sin δ₂ + cos δ₁ cos δ₂ cos(α₁ − α₂)
- Angle between two sky positions.
- π r²
- Area of a small cone in square degrees.
- 41,253 deg²
- Area of the whole sky.
- Physical meaning
- An archive is a public library of the sky: every observation, labelled with where and when it was taken. A cone search is asking the librarian for every book on one shelf; ADQL lets you add "only the ones published after 2015, under 300 pages".
“Only professional astronomers can use telescope data.” Gaia, Hubble, TESS, SDSS and many more release their data free to anyone. Students and amateurs regularly publish discoveries made from archives.
4. Worked example
A catalogue has on average 50,000 stars brighter than G = 15 per square degree near the Milky Way’s plane. How many will a 3 arcminute cone return?
5. Practice
More practice (answers below):
- Two stars are at the same Dec of 0° and RA 10.00° and 10.05°. How far apart are they?
- A query returns 2 million rows. Name two ways to cut it down.
- Which archive would you use for TESS light curves?
Answers
- 0.05° = 3 arcminutes (on the equator RA degrees equal sky degrees).
- A smaller radius, a brighter magnitude limit, or only the columns you need.
- MAST.
- Major archives: Gaia, MAST (Hubble, TESS, JWST), ESO, SIMBAD, NASA Exoplanet Archive.
- Cone search: everything within a radius of a sky position.
- ADQL is SQL with sky geometry functions like CONTAINS and CIRCLE.
- Expected count = area × density, a quick sanity check.
Try it with real numbers: check a catalogue star’s altitude tonight with the target altitude planner tool, convert coordinates with Sky coordinate converter, and fetch planet data in the planet data explorer.
New words: archive, proprietary period, cone search, ADQL, TAP, catalogue.
Check yourself
Sources
- IVOA ADQL Recommendation 2.1 (2023); archive names and access policies as published by ESA, NASA/STScI and ESO
Your ticks stay in this browser. Save them as a file on the course home.
Updated 2026-11-22. Numbers in the examples are made up to show the idea unless a source is given. Simulations run in your browser on made-up data; nothing you type is sent anywhere. Astronomy only: nothing here is astrology.