You may now search on any column in the mission database. Select the field you wish to search on and type in the qualification. NOTE that if you choose a field in BOTH the form and in the User Option field, then you may not get results or the result you expect.
In the table below is a list of all the column names available for search. Where reasonable a range or set of valid values is listed. Additional useful notes are included. If you click on the field name, a more detailed description of the data will be found. The column label is used in the search forms and search results. The column name needs to be specified for GET requests.
| Column Name | Column Label | Data Type | Valid Values | Notes | UCDs |
|---|---|---|---|---|---|
| pears_dataid | Data ID | char | Examples: n91182, s72449 | Uniquely identifies a dataset with field and id number; | ID_MAIN |
| pears_field | PEARS Field | char | N,S | PEARS Field: | ID_MAIN |
| pears_id | PEARS ID | long | 6004 to 140388 for south field; 24439 to 131789 for north field | PEARS ID number: | ID_MAIN |
| pears_ra | RA (J2000) | double | Range: 0 to 360 deg | Right Ascension (J2000) | POS_EQ_RA_MAIN |
| pears_dec | Dec (J2000) | double | Range: -90 to +90 deg | Declination (J2000) | POS_EQ_DEC_MAIN |
| pears_i_mag_auto | i Mag | float | Range: 14.76 to 26.0 | i magnitude | |
| pears_i_magerr_auto | i Mag Error | float | Range: 0.0 to 0.158 | i magnitude error | |
| pears_i_netsig_raw | i Net Sig Raw | float | Range: 10.1 to 14900.00 | The maximum cumulative signal-to-noise level calculated on the extracted 1D spectrum. | |
| pears_i_netsig_corrected | i Net Sig Corrected | float | Range: 10.1 to 14900.00 | The maximum cumulative signal-to-noise level calculated using the spectrum where contaminatin is caused by overlapping spectra has first been subtraccted from the spectrum of interest. |