User Specified Search Field

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.