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.