saada logo

 
  SAADA OVERVIEW
Home  
News  
Tutos and Links  
Download  
  Tutorial
Getting started  
Doing More  
SaadaQL  
The Web Interface  
VO Publishing  
Tips & Troubelshooting  
  COMMUNITY
Mailing List  
Saada Sites  
How to Contact us ?  
  DEVELOPER CORNER
Contributors  
Next Step  
Old Releases  
Inside Saada  
Using UWS  

 

SourceForge.net Logo


HOME ART > Tutorial > SaadaQL
WhereAttributeSaada



 Some native attributes are copied from the input products to populate collections attributes. These collections attributes allow users to select data over the whole SaadaDB in one query.

 The WhereAttributeSaada clause expresses constrains on collection attributes with one SQL-like Where statement.

WhereAttributeSaada{ namenaada = 'titan'  }

 Collection attribute are listed below.

Attribute Type Description IMAGE SPECTRUM ENTRY TABLE MISC FLATFILE
oidsaada bigint Internal object ID X X X X X X
oidproduct bigint Not used yet X X X X X X
contentsignature text MD5 signature X X X X X X
namesaada text Data name X X X X X X
date_load bigint system dependant X X X X X X
access_right char Not used yet X X X X X X
loaded boolean Internal use X X X X X X
pos_ra_csa double Ascension X X X
pos_dec_csa double Declination X X X
sky_pixel_csa bigint QBox# X X X
pos_x_csa double Cartesian coords. X X X
pos_y_csa double Cartesian coords. X X X
pos_z_csa double Cartesian coords. X X X
error_maj_csa double Error Maj axis X X X
error_min_csa double Error Min axis X X X
error_angle_csa double Error ellipse angle X X X
crpix1_csa double WCS ref pixel X
crpix2_csa double WCS ref pixel X
ctype1_csa text WCS projection X
ctype2_csa text WCS projection X
cd1_1_csa double WCS proj matrix ele. X
cd1_2_csa double WCS proj matrix ele. X
cd2_1_csa double WCS proj matrix ele. X
cd2_2_csa double WCS proj matrix ele. X
crota_csa double WCS rotation angle X
crval1_csa double WCS ref position X
crval2_csa double WCS ref position X
product_url_csa text Data file name X X X X X
size_alpha_csa double Image size (deg) X
size_delta_csa double Image size (deg) X
shape_csa text Image shape (not used) X
naxis1 integer Image size (pixel) X
naxis2 integer Image size (pixel) X
oidtable bigint Table header ID X
nb_rows_csa integer Number of rows X
x_min double Converted dispersion range X
x_max double Converted dispersion range X
x_type integer Dispersion type (E, wl..) X
x_unit text SaadaDB disp. unit X
x_org_min double Original dispersion range X
x_org_max double Original dispersion range X
x_org_unit text Origina ; disp. unit X
user defined attr. any definde at SaadaDB creation time X X X X X
last update 2008-05-13