wsa logo
Downtime
4-6th Oct 2024

WSA Home
Start Here
Data Overview
Known Issues
the Surveys
* Coverage Maps
Schema browser
Data access
Login
Archive Listing
GetImage
ColourImage
MultiGetImage
Region
Menu query
Freeform SQL
CrossID
Analysis services
SQL Cookbook
Q&A
Glossary
Release History
non-Survey
Gallery
Publications
Monitor
Downtime
Links
wsa logo bottom
IFA     ROE
Home | Overview | Browser | Access | Login | Cookbook | nonSurvey 
 
  WSA logo

SQL Query for Contour Plots of GCS Stars

SELECT zAperMag3, yAperMag3, jAperMag3, hAperMag3, k_1AperMag3, zmyPnt, ymjPnt, jmhPnt, hmk_1Pnt
FROM gcsSource
WHERE mergedClass=-1 AND (priOrSec<=0 OR priOrSec=frameSetID) AND zppErrBits<256 AND yppErrBits<256 AND jppErrBits<256 AND hppErrBits<256 AND k_1ppErrBits<256 AND zXi BETWEEN -1.0 AND +1.0 AND zEta BETWEEN -1.0 AND +1.0 AND yXi BETWEEN -1.0 AND +1.0 AND yEta BETWEEN -1.0 AND +1.0 AND jXi BETWEEN -1.0 AND +1.0 AND jEta BETWEEN -1.0 AND +1.0 AND hXi BETWEEN -1.0 AND +1.0 AND hEta BETWEEN -1.0 AND +1.0 AND k_1Xi BETWEEN -1.0 AND +1.0 AND k_1Eta BETWEEN -1.0 AND +1.0


For the Z-J vs Z plot, the colour Z-J (not listed in gcsSource) was derived from the observed magnitudes. Since default values might compensate each other and their difference result zero, another query filtered out non-measured magnitudes. Such a query was submitted separately from the above one, so that the existence of default values in the Z or J bands did not place restrictions on other colour-colour and colour-magnitude plots.

SELECT zAperMag3, (zAperMag3-jAperMag3) as zmjPnt
FROM gcsSource
WHERE mergedClass=-1 AND (priOrSec<=0 OR priOrSec=frameSetID) AND zppErrBits<256 AND jppErrBits<256 AND zXi BETWEEN -1.0 AND +1.0 AND zEta BETWEEN -1.0 AND +1.0 AND jXi BETWEEN -1.0 AND +1.0 AND jEta BETWEEN -1.0 AND +1.0 AND zAperMag3>-9999.9 AND jAperMag3>-9999.9



Home | Overview | Browser | Access | Login | Cookbook | nonSurvey
Listing | Region | MenuQuery | FreeSQL
Links | Credits

WFAU, Institute for Astronomy,
Royal Observatory, Blackford Hill
Edinburgh, EH9 3HJ, UK

wsa-support@roe.ac.uk
23/4/2015