PEARS Field Descriptions

You may submit queries using any of the fields listed below. The "Column label" is the name displayed on the search forms and in search results. The "Column name" is the actual column name in the table and needs to be specified in GET requests. (See the MAST Services web page for information on submitting GET requests.) If the "Column name" is in italics, it means the table is indexed on that field and queries with that field will run faster. Clicking on "Data Type" entries will display information on search options.

When using the "user-specified field" form element on a MAST search form, simply select the column "label" in the forms pulldown menu and type in the qualification in the adjacent box. If you specify constraints on the same column in more than one form element, they will all be included in the query and you may not get results you expect. Note the entries in the table below may be sorted by clicking on the column headings.

Catalog Description of PEARS Catalog Table
Last Update:

Column Name	Column Label	Description	Examples/Valid Values	Data Type
Column Name	Column Label	Description	Examples/Valid Values	Data Type
pears_dataid	Data ID	Uniquely identifies a dataset with field and id number;	Examples: n91182, s72449	lstring
pears_field	PEARS Field	PEARS Field:	N,S	ustring
pears_id	PEARS ID	PEARS ID number:	6004 to 140388 for south field; 24439 to 131789 for north field	integer
pears_ra	RA (J2000)	Right Ascension (J2000)	Range: 0 to 360 deg	ra
pears_dec	Dec (J2000)	Declination (J2000)	Range: -90 to +90 deg	dec
pears_i_mag_auto	i Mag	i magnitude	Range: 14.76 to 26.0	float
pears_i_magerr_auto	i Mag Error	i magnitude error	Range: 0.0 to 0.158	float
pears_i_netsig_raw	i Net Sig Raw	The maximum cumulative signal-to-noise level calculated on the extracted 1D spectrum.	Range: 10.1 to 14900.00	float
pears_i_netsig_corrected	i Net Sig Corrected	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.	Range: 10.1 to 14900.00	float