Query form for table RC3


You can use this form to generate a query against the data in this table. In the entry box for any field you can enter a Boolean expression indicating the value or values you require that field to match. For example, if you put = 45 in a box, then the corresponding field must equal 45 for a record to be selected. If you need help with the formulation of these expressions, try the Beginner's Guide to SQL Selection Expressions. You can also request basic stat functions min, max, sum, avg on any numeric column; however, obviously if you choose this option, you cannot print regular column values as well.

Selecting fields to print: By default the first three fields will be printed. Just deselect the Print button for fields you do not want in your output, or select it for those you wish to add.

Performance: Column names appearing in italics as well as bold, like this, indicate that this column is indexed in the database server for faster searching. If you can use criteria for these columns to narrow your search, your query will run much faster!

You can optionally generate a colour PostScript plot, plotting up to 10 Y values against 1 X value by using the X and Y select buttons. If you plot a column that you have not asked to print, that column will automatically be printed. If you choose an X that is not monotonically increasing in some sensible way, like time series, you probably want a scatterplot (correlation) rather than a line plot. You can choose the the plot type using the buttons below. If you want to know what the fields mean, check the data dictionary information for this table. You may also want to use the browser form for this table to see one record at a time.


Line Plot
Scatter Plot
FieldPrint?pltXPltYFuncMatch Value
sybid
RAH
RAM
RAS
DecD
DecM
DecS
Name
Type
LogD25
ME_LogD25
PosAngle
BTot
BTcode
ME_BT
B_VTot
ME_BVT
B_Ve
ME_BVe
m21
ME_m21
V21
ME_V21
GalLong
GalLat
AltName
RtypSrc
LumEst
LogR25
ME_LogR25
Ag
mB
ME_mB
U_BTot
ME_UBT
U_Be
ME_UBe
W20
ME_W20
Vopt
ME_Vopt
SGlong
SGlat
Desig
T_Hubble
ME_T
LogAe
ME_LogAe
Ai
mFIR
B_VoT
m_e
ME_me
W50
ME_W50
VGSR
RAH1950
RAM1950
RAS1950
DecD1950
DecM1950
DecS1950
PGCnum
LumCls
ME_LumCls
LogDo
A21_HIsa
BoT
U_Bot
m_25
ME_m25
HI
V3K
You may alternatively, if you are familiar with SQL expressions, compose your own selection expression (what would come after the where in the select statement):

Go back to main index.

webmaster@ucolick.org
A Service of the Computing Support Group
UCO/Lick Observatory
University of California
Santa Cruz, CA 95064
Tel: +1 408 459 2630
Fax: +1 408 454 9863