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

*** 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.

Freeform SQL Query

This form allows you to submit an SQL query to the WSA database (notes and tips).

Database release to use:  

Upload SQL query from file into this form:  
or enter
SQL statement:
Upload file to temp table #userTable:  
Format of upload file:     notes on using #userTable

ensure one of the file formats is selected below if you want to save your results.

Email Address: the results of long running queries will be sent by email.
Data Format:
HTML table summary (results are NOT saved to file)
ASCII FILE (downloadable with HTML table summary on-screen)
FITS FILE (downloadable with HTML table summary on-screen)
VOTable FILE (downloadable with HTML table summary on-screen)
  ( The number of rows written to the downloadable files is subject to an upper limit see data access )
File Compression:
(none) GZIP
HTML rows:
Number of rows written to HTML table summary (maximum 100)
Timeout (seconds):
your query will be halted after this time (max 10800)




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