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 > DEVELOPER CORNER > Old Releases > Saada 1.4.2 > TUTORIAL > Using your SaadaDB > SaadaQL
The WhereAttributeSaada clause



 Some native attributes are copied from the input products to populate collections attributes (see datamoded). 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.

  • example :

    WhereAttributeSaada{ " namenaada = 'titan' " }

Collection attributes are listed in the table below.

Collection Attribute

IMAGE2D

SPECTRUM

TABLE

ENTRY

oidsaada

Unique Saada Object Identifier.

X

X

X

X

namesaada

Instance Name . Can be empty

X

X

X

X

date_load

Loading time in seconds (system dependant)

X

X

X

X

pos_ra_csa

Ascension (In the global coordinate system defined at SaadaDB creation time)

X

X

X

pos_dec_csa

Declination (In the global coordinate system defined at SaadaDB creation time)

X

X

X

error_ra_csa
Error on ascension (in deg)
X
error_dec_csa
Error on declination (in deg)
X
oid_table
Unique Saada Object Identifier of the table from the entry comes from
X
nb_rows_csa
Number of table rows
X
name_class_entry_csa
Saada class name of the related entries
X
sky_pixel_csa

HTM sky pixel

X

X

X

crpix1/2_csa
WCS
X
ctype1/2_csa
WCS (not affected for spectra)
X
X
cd1/2_1/2_csa
WCS (not affected for spectra)
X
X
crota_csa
WCS (not affected for spectra)
X
X
crval1/2_csa
WCS (not affected for spectra)
X
X
product_url_csa
Product filename
X
X
X
x_min_max.
spectral ranged expressed in global units (defined at database creation time)
   
X
x_unit.
global spectral range unit (defined at database creation time)
   
X
x_org_min_max.
spectral ranged expressed in native units (as read witin the product)
   
X
x_org_unit.
native product spectral range unit (as read in the prodct)
   
X
User defined Coll. Attr.
Users defined attributes (see tutorial)
X
X
X
X
last update 2007-03-03