wsa logo
2023-06-01
UHS DR2 public

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 GPS Stars

SELECT jAperMag3, hAperMag3, k_1AperMag3, jmhPnt, hmk_1Pnt
FROM gpsJHKsource
WHERE sourceID%10=0 and mergedClass=-1 and (priOrSec<=0 or priOrSec=frameSetID) and jppErrBits<256 and hppErrBits<256 and k_1ppErrBits<256 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


Note the introduction of random sampling based on sourceID (because of the large size of the GPS data set).



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