wsa logo
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

*** 2023-06-01 UHS DR2 public release *** (to use select UHSDR2 in database drop down list

Status: Not logged in.
Please reload this page if you have logged in and are not seeing the correct login status.

Default sets of attributes

In some of the data access methods a default list of table attributes is returned for a given table. The listings for the various survey(s) and tables are shown below.

You can append to the default set by adding extra parameters, separated by commas, after default e.g. enter default,htmID,cx,cy,cz in the attributes to select box. If you do not wish the default list to be returned enter your own comma separated list in place of default e.g enter htmID,cx,cy,cz

Attributes for a given table can be found in the schema browser. NOTE: The lists shown here reflect your login status shown at the top of the page.

An asterisk means the default list will contain all attributes for a given table e.g. lasSource.*, this is the fallback position when the schema for the database being used is not the most current. As tables can contain many atttributes you are encouraged to replace default with your own chosen list.

WSA UKIDSS default parameter listing

Commissioning programme

UKIDSS Large Area Survey, LAS

lasSource sourceID, framesetID, RA, Dec, mergedClass, priOrSec, YAperMag3, YAperMag3Err, J_1AperMag3, J_1AperMag3Err, J_2AperMag3, J_2AperMag3Err, HAperMag3, HAperMag3Err, KAperMag3, KAperMag3Err
lasDetection objID, multiframeID, filterID, RA, Dec, ell, pa, class, psfMag, hallMag,isoMag, petroMag, aperMag2, aperMag3

UKIDSS Galactic Plane Survey, GPS

gpsSource sourceID, framesetID, RA, Dec, mergedClass, priOrSec, JAperMag3, JAperMag3Err, HAperMag3, HAperMag3Err, K_1AperMag3, K_1AperMag3Err, K_2AperMag3, K_2AperMag3Err, H2AperMag3, H2AperMag3Err
gpsDetection objID, multiframeID, filterID, RA, Dec, ell, pa, class, psfMag, hallMag,isoMag, petroMag, aperMag2, aperMag3

UKIDSS Galactic Clusters Survey, GCS

gcsSource sourceID, framesetID, RA, Dec, mergedClass, priOrSec, ZAperMag3, ZAperMag3Err, YAperMag3, YAperMag3Err, JAperMag3, JAperMag3Err, HAperMag3, HAperMag3Err, K_1AperMag3, K_1AperMag3Err, K_2AperMag3, K_2AperMag3Err
gcsDetection objID, multiframeID, filterID, RA, Dec, ell, pa, class, psfMag, hallMag,isoMag, petroMag, aperMag2, aperMag3

UKIDSS Deep Extragalactic Survey, DXS

dxsSource sourceID, framesetID, RA, Dec, mergedClass, priOrSec, JAperMag3, JAperMag3Err, HAperMag3, HAperMag3Err, KAperMag3, KAperMag3Err
dxsDetectionobjID, multiframeID, filterID, RA, Dec, ell, pa, class, psfMag, hallMag,isoMag, petroMag, aperMag2, aperMag3

UKIDSS Ultra Deep Survey, UDS

udsSource sourceID, framesetID, RA, Dec, mergedClass, priOrSec, JAperMag3, JAperMag3Err, HAperMag3, HAperMag3Err, KAperMag3, KAperMag3Err
udsDetection objID, multiframeID, filterID, RA, Dec, ell, pa, class, psfMag, hallMag,isoMag, petroMag, aperMag2, aperMag3



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