Archives of Photographic PLates for Astronomical USE

Archives of DR1

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 Archive
Hamburg Archives
Bamberg Archive
Queries to get the data used for the plots

Potsdam Archive  Archive ID Institute Location Instrument
Zeiss Triplet  1 AOP Potsdam Link to Archive page
Top
Hamburg Archive   Archive ID Institute Location Instrument
Lippert-Astrograph 101 HS Hamburg more
Grosser Schmidt-Spiegel (Hamburg) 102 HS Hamburg more
Top
Bamberg Archive  Archive ID Institute Location Instrument
Bamberg Southern Sky Patrol 201 RSB Bamberg link

Using the database to get the data:
 
With the query:

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

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

With the query:

SELECT plate_id,archive_id, fov1, fov2, raj2000, dej2000
FROM applause_dr1.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 Bamberg archive):

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

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