[an error occurred while processing this directive]

Column Constraints / Output Column Selection

The Column Constraints / Output Column Selection parameters allow you to refine your searches and to customize your output. The Gator interface includes a table called “COLUMN CONSTRAINTS/OUTPUT COLUMN SELECTION,” which lists the names and descriptions of all the columns in the Kepler Target Selection Catalog. This table includes all the functionality needed to customize your input and refine your searches. There are two views of the table, which are chosen by the Table Selection option in the table header. Clicking Standard displays a list of the most commonly queried columns, and clicking Long Form displays all columns in the catalog. The features described below apply to both the Standard View and to the Long Form.

Customizing the Query Output

Gator allows you to select which columns appear in the output table. A check mark in the column labeled Sel denotes those columns that will appear in the output table. Click the check box for a column to select or deselect it. To select all columns in the table, click the Select All Columns button just above the table. Click Clear All Selections to deselect all columns, and click Reset to return to the default selections. You may set constraints on columns even if you do not wish to see them in the output table.

Sexagesimal Output – Choose whether to format RA and Dec in the output table as sexagesimal (default) or decimal degrees. Select "No" from the pulldown menu to have your results output as decimal degrees.

How to Set Constraints

Gator provides a listing of the columns in the Kepler Target Selection Catalog. Constraints can be specified by entering values into the Low Limit and Up Limit textboxes.

Specifying Ranges

You must include the <, >, or = operators in the input boxes.
Enter the constraint with the syntax:
```
< operator>< value >
```
e.g. To search for data with a RA value between 299.5 and 300.0, enter >299.5 in the Low Limit textbox, and <300.0 in the Up Limit textbox. Use “>=” and “<=” if you wish to include the boundary values in the query.
Do not use SQL syntax.
You can include either a lower limit or an upper limit or both.
You can constrain values of catalog columns even if you do not wish these columns to appear in the output table, e.g. to create a list of the kic_kepler_ids of all stars with kic_teffs between 3,000 K and 5,000 K, deselect all columns, click the Sel column entry for kic_kepler_id, enter >3000 in the kic_teff Low Limit box, and <5000 in the Up Limit box.

Specifying Datatypes

Your constraints must be specified in the correct datatype. These datatypes are recorded in the last column in the table, “DBType.”
Numerical (Integer, Float, or Decimal)
Use the following formatting rules in supplying constraints:

Treat int and smallint datatypes as integers.
Treat decimals, float and smallfloat datatypes as floating point numbers.

Example constraints:

=2 (for integer)

=2.543 (for float or decimal)

Character strings must be enclosed in a pair of quotes; e.g. ="A", >="A" or <="A".

Query Form Control Buttons

Select All Columns button - Using this button will select all of the columns for output in the results table.
Clear All Selections button - Clicking this button will de-select all of the columns.
Reset button - Clicking the Reset button will reset all of the values back to their default state. Warning: This will also remove any entries in the Low Limit and Up Limit textboxes.

Table Selection Options

Table Form Selection - There may be two options available: Standard and Long. These options do not appear for every search.

Standard - This is a subset of the columns in the catalog, which includes important and commonly used columns. This is the default table form.
Long Form - This displays all columns in the catalog. The Long Form button will not appear if it has the same selection as Standard.

Value Type Selection

Sexagesimal Output - This option specifies to output any results as sexagesimal values. Select No from the pulldown menu to have your results output as degrees. The default value is to output results as sexagesimal.

Specifying Ranges

Each constraint in this section has a textbox for a minimum and maximum value. Minimum and maximum values should be expressed as follows:

> - Use > to search for an object with a value greater than the value you have specified.
> - Use > to search for an object with a value greater than or equal to the value you have specified.
= - Use = to specify that the results can only contain an object with a constraint equal to the number you specified.
< - Use < to search for an object with a value less than the value you have specified.
< - Use < to search for an object with a value less than or equal to the value you have specified.

Syntax

< comparison operator>< value >

Warning: SQL statements are not accepted.

Example

An example of a range is ra Low Limit ">299.5" and Up Limit "<300". This specifies to find sources that are a right ascension of greater than 299.5 degrees, but less than 300 degrees. You can find example searches here.

Characters

A character string must be enclosed in a pair of quotes. For example, in Low Limit or Up Limit text fields, type in one of the following:

="A"

>="A"

<="A"

Examples:

kic_tm_designation ="19445845+4507507",

This example returns one object: del Cyg.

In the long form:

kic_cq ="SCP"

This example returns all objects for which the kic_kepmag has SDSS filter photometry.

Numerical (Integer, Float, or Decimal)

Databases generally support a different range of datatypes than do the programming languages. Use the following formatting rules in supplying constraints:

Treat int and smallint datatypes as integers.
Treat float and smallfloat datatypes as floats.
Treat decimal datatypes as doubles.

Example constraints:

=2 (for integer)

=2.543 (for float or decimal)

Description of Constraints

You can find a full description of each of the column constraints here.

PREVIOUS START NEXT

[an error occurred while processing this directive]