Archives of Photographic PLates for Astronomical USE

Archives of DR2

Plots of the observation fields from the included archives.
 
Only included are fields that have also successfully been processed by astrometry.net.
The field of view is plotted to scale.
Potsdam Archives
Hamburg Archives
Bamberg Archives
Tartu Archives
Queries to get the data used for the plots

Potsdam Archive  Archive ID Institute Location Instrument
Zeiss Triplet  1 AOP Potsdam more
Carte du Ciel  2, not processed, FoV from Lit. AOP Potsdam more
Top
Hamburg Archive   Archive ID Institute Location Instrument
Lippert-Astrograph 101 HS Hamburg more
Grosser Schmidt-Spiegel 102 HS Hamburg more
1m-Spiegelteleskop (Hamburg) 103 HS Hamburg more
Hamburger Schmidt-Spiegel 104 HS Calar Alto more
Top
Bamberg Archive  Archive ID Institute Location Instrument
Bamberg Southern Sky Patrol 201 RSB Bamberg more
Metcalf Telescope (South Africa) 202 RSB Bamberg more
Top
Tartu Archive  Archive ID Institute Location Instrument
Tartu Old Observatory 301 TO Tartu link


Using the database to get the data:
 

With the query:

SELECT archive_id,count(archive_id)
FROM applause_dr2.plates
GROUP BY archive_id

you get the number of the plates per archive we processed in DR2.

With the query:

SELECT plate_id, fov1, fov2, raj2000, dej2000
FROM applause_dr2.solution
WHERE NOT( raj2000 IS NULL or dej2000 IS NULL)
order by archive_id, plate_id

you get the field of view and center coordinates for the observation on the plate, ordered by archive.

If you want the data from only one archive (here Tartu archive):

SELECT plate_id, fov1, fov2, raj2000, dej2000
FROM applause_dr2.solution
WHERE NOT( raj2000 IS NULL or dej2000 IS NULL)
AND archive_id = 301
order by archive_id, plate_id

This gives you the data set we used for plotting the diagrams.