2MASS Catalog Server Kit

Information about table columns

Page Index:
HOME / Install Huge Catalogs / Install Small Catalogs / Information about table columns / Hard Drive Copy Service

Index of Current Page:
2MASS PSC / WISE / USNO-B1.0 / GSC-2.3.2 / UCAC3 / PPMXL / Tycho-2 / AKARI IRC PSC / AKARI FIS BSC / IRAS PSC

Symbol for Database Index

P	Primary Key
S	Single Column Index
Cn	Composite Index
Un	Unique Constraint

Note

VARCHAR(n)* means that the column is defined as VARCHAR, but the length of string is always n.

2MASS PSC

Number of rows: 470,992,970.

#	name	type	null	index	unit	description
1	objid	INT4		P		Primary key (unique identifier) for the 2MASS Kit database. Do not refer this ID in your literatures.
2	designation	VARCHAR(17)*				Sexagesimal, equatorial position-based source name in the form: hhmmssss+ddmmsss[ABC...].
3	ra	FLOAT8			deg	J2000 right ascension.
4	dec	FLOAT8			deg	J2000 declination.
5	err_maj	FLOAT4			arcsec	Semi-major axis length of the one sigma position uncertainty ellipse.
6	err_min	FLOAT4			arcsec	Semi-minor axis length of the one sigma position uncertainty ellipse.
7	err_ang	INT2			deg	Position angle on the sky of the semi-major axis of the position uncertainty ellipse (East of North).
8	j_m	FLOAT4	Y	S	mag	Default J-band magnitude, or if the source is not detected in the J-band, the 95% confidence upper limit derived from a 4" radius aperture measurement taken at the position of the source on the Atlas Image.
9	j_cmsig	FLOAT4	Y		mag	Corrected photometric uncertainty for the default J-band magnitude. If rd_flg[1]="2", this is the measurement error from the profile-fitting procedure, corrected to be consistent with observed repeatability statistics.
10	j_msigcom	FLOAT4	Y		mag	Combined, or total photometric uncertainty for the default J-band magnitude.
11	j_snr	FLOAT4	Y		mag	J-band "scan" signal-to-noise ratio..
12	h_m	FLOAT4	Y	S	mag	Default H-band magnitude, or if the source is not detected in the H-band, the 95% confidence upper limit derived from a 4" radius aperture measurement taken at the position of the source on the Atlas Image.
13	h_cmsig	FLOAT4	Y		mag	Corrected photometric uncertainty for the default H-band magnitude. If rd_flg[1]="2", this is the measurement error from the profile-fitting procedure, corrected to be consistent with observed repeatability statistics.
14	h_msigcom	FLOAT4	Y		mag	Combined, or total photometric uncertainty for the default H-band magnitude.
15	h_snr	FLOAT4	Y		mag	H-band "scan" signal-to-noise ratio..
16	k_m	FLOAT4	Y	S	mag	Default Ks-band magnitude, or if the source is not detected in the Ks-band, the 95% confidence upper limit derived from a 4" radius aperture measurement taken at the position of the source on the Atlas Image.
17	k_cmsig	FLOAT4	Y		mag	Corrected photometric uncertainty for the default Ks-band magnitude. If rd_flg[1]="2", this is the measurement error from the profile-fitting procedure, corrected to be consistent with observed repeatability statistics.
18	k_msigcom	FLOAT4	Y		mag	Combined, or total photometric uncertainty for the default Ks-band magnitude.
19	k_snr	FLOAT4	Y		mag	Ks-band "scan" signal-to-noise ratio..
20	ph_qual	VARCHAR(3)*				Photometric quality flag.
21	rd_flg	VARCHAR(3)*				Read flag.
22	bl_flg	VARCHAR(3)*				Blend flag.
23	cc_flg	VARCHAR(3)*				Contamination and confusion flag.
24	ndet	VARCHAR(6)*				Frame detection statistics.
25	prox	FLOAT4			arcsec	Proximity. The distance between this source and its nearest neighbor in the PSC.
26	pxpa	INT2	Y		deg	The position angle on the sky of the vector from the source to the nearest neighbor in the PSC, in degrees East of North.
27	pxcntr	INT4				The pts_key value of the nearest source in the PSC.
28	gal_contam	INT2				Extended source "contamination" flag.
29	mp_flg	INT2				Minor Planet Flag. Indicates if this source is associated with the predicted position of a known minor planet, comet, planet or planetary satellite.
30	pts_key	INT4				A unique identification number for the PSC source.
31	hemis	VARCHAR(1)*				Hemisphere code for the 2MASS Observatory from which this source was observed.
32	date	DATE				The observation reference date for this source expressed in ISO standard format.
33	scan	INT2				The nightly scan number in which the source was detected.
34	glon	FLOAT4			deg	Galactic longitude.
35	glat	FLOAT4			deg	Galactic latitude.
36	x_scan	FLOAT4			arcsec	Mean cross-scan focal plane position of the source in the Universal scan (U-scan) coordinate system.
37	jdate	FLOAT8			day	The Julian Date of the source measurement accurate to +30 seconds.
38	j_psfchi	FLOAT4	Y			Reduced chi-squared goodness-of-fit value for the J-band profile-fit photometry made on the 1.3 s "Read_2" exposures.
39	h_psfchi	FLOAT4	Y			Reduced chi-squared goodness-of-fit value for the H-band profile-fit photometry made on the 1.3 s "Read_2" exposures.
40	k_psfchi	FLOAT4	Y			Reduced chi-squared goodness-of-fit value for the Ks-band profile-fit photometry made on the 1.3 s "Read_2" exposures.
41	j_m_stdap	FLOAT4	Y		mag	J-band "standard" aperture magnitude.
42	j_msig_stdap	FLOAT4	Y		mag	Uncertainty in the J-band standard aperture magnitude.
43	h_m_stdap	FLOAT4	Y		mag	H-band "standard" aperture magnitude.
44	h_msig_stdap	FLOAT4	Y		mag	Uncertainty in the H-band standard aperture magnitude.
45	k_m_stdap	FLOAT4	Y		mag	Ks-band "standard" aperture magnitude.
46	k_msig_stdap	FLOAT4	Y		mag	Uncertainty in the Ks-band standard aperture magnitude.
47	dist_edge_ns	INT2			arcsec	The distance from the source to the nearest North or South scan edge.
48	dist_edge_ew	INT2			arcsec	The distance from the source to the nearest East or West scan edge.
49	dist_edge_flg	VARCHAR(2)*				Two character flag that specifies to which scan edges a source lies closest, and to which edges the dist_edge_ns and dist_edge_ew values refer.
50	dup_src	INT2				Duplicate source flag.
51	use_src	INT2				Use source flag.
52	a	VARCHAR(1)*				Catalog identifier of an optical source from either the Tycho 2 or USNO-A2.0 catalog that falls within ~5" of the 2MASS source position.
53	dist_opt	FLOAT4	Y		arcsec	Distance separating 2MASS source position and associated optical source within 5".
54	phi_opt	INT2	Y		deg	Position angle on the sky of the vector from the the associated optical source to the 2MASS source position, in degrees East of North.
55	b_m_opt	FLOAT4	Y		mag	Blue magnitude of associated optical source.
56	vr_m_opt	FLOAT4	Y		mag	Visual or red magnitude of the associated optical source.
57	nopt_mchs	INT2				The number of USNO-A2.0 or Tycho 2 optical sources found within a 5" radius of the 2MASS position.
58	ext_key	INT4	Y			Unique identification number of the record in the XSC that corresponds to this point source.
59	scan_key	INT4				Unique identification number of the record in the Scan Information Table (NOT YET AVAILABLE) that corresponds to the survey scan in which this source was detected.
60	coadd_key	INT4				Unique identification number of the record in the Atlas Image Data Table (NOT YET AVAILABLE) that corresponds to Image in which the position of this source falls.
61	coadd	INT2				Sequence number of the Atlas Image in which the position of this source falls.
62	cx	FLOAT8				Unit vector for (ra,dec).
63	cy	FLOAT8				Unit vector for (ra,dec).
64	cz	FLOAT8				Unit vector for (ra,dec).

WISE All-Sky Release Catalog

Number of rows: 563,921,584.

NOTE: columns w1frtr - w4frtr do not exist in this table, since cells in those columns are always 0.0.

#	name	type	null	index	unit	description
1	objid	INT4		P		Primary key (unique identifier) for the 2MASS Kit database. Do not refer this ID in your literatures.
2	designation	VARCHAR(19)*				Unique WISE source designation.
3	ra	FLOAT8			deg	Right ascension (J2000).
4	dec	FLOAT8			deg	Declination (J2000).
5	e_ra	FLOAT4	Y		arcsec	Uncertainty in RA.
6	e_dec	FLOAT4	Y		arcsec	Uncertainty in DEC.
7	e_radec	FLOAT4	Y		arcsec	Uncertainty cross-term.
8	glon	FLOAT8			deg	Galactic longitude.
9	glat	FLOAT8			deg	Galactic latitude.
10	elon	FLOAT8			deg	Ecliptic longitude.
11	elat	FLOAT8			deg	Ecliptic latitude.
12	wx	FLOAT8			pix	x-pixel coordinate, all bands.
13	wy	FLOAT8			pix	y-pixel coordinate, all bands.
14	cntr	INT8				Unique entry counter (key) number.
15	source_id	VARCHAR(20)*				Unique source ID (coadd ID and source number).
16	coadd_id	VARCHAR(13)*				Coadd ID.
17	src	INT4				Source number in coadd.
18	w1_mpro	FLOAT4	Y	S	mag	Instrumental profile-fit photometry magnitude, band 1.
19	w1_sigmpro	FLOAT4	Y		mag	Instrumental profile-fit photometry flux uncertainty in mag units, band 1.
20	w1_snr	FLOAT4	Y			Instrumental profile-fit photometry S/N ratio, band 1.
21	w1_rchi2	FLOAT8	Y			Instrumental profile-fit photometry reduced chi^2, band 1.
22	w2_mpro	FLOAT4	Y	S	mag	Instrumental profile-fit photometry magnitude, band 2.
23	w2_sigmpro	FLOAT4	Y		mag	Instrumental profile-fit photometry flux uncertainty in mag units, band 2.
24	w2_snr	FLOAT4	Y			Instrumental profile-fit photometry S/N ratio, band 2.
25	w2_rchi2	FLOAT8	Y			Instrumental profile-fit photometry reduced chi^2, band 2.
26	w3_mpro	FLOAT4	Y	S	mag	Instrumental profile-fit photometry magnitude, band 3.
27	w3_sigmpro	FLOAT4	Y		mag	Instrumental profile-fit photometry flux uncertainty in mag units, band 3.
28	w3_snr	FLOAT4	Y			Instrumental profile-fit photometry S/N ratio, band 3.
29	w3_rchi2	FLOAT8	Y			Instrumental profile-fit photometry reduced chi^2, band 3.
30	w4_mpro	FLOAT4	Y	S	mag	Instrumental profile-fit photometry magnitude, band 4.
31	w4_sigmpro	FLOAT4	Y		mag	Instrumental profile-fit photometry flux uncertainty in mag units, band 4.
32	w4_snr	FLOAT4	Y			Instrumental profile-fit photometry S/N ratio, band 4.
33	w4_rchi2	FLOAT8	Y			Instrumental profile-fit photometry reduced chi^2, band 4.
34	rchi2	FLOAT8				Instrumental profile-fit photometry reduced chi squared, total.
35	nb	INT2				Number of blend components used in each fit.
36	na	INT2				Active deblend flag (=1 if actively deblended).
37	w1_sat	FLOAT4	Y			Fraction of pixels affected by saturation, band 1.
38	w2_sat	FLOAT4	Y			Fraction of pixels affected by saturation, band 2.
39	w3_sat	FLOAT4	Y			Fraction of pixels affected by saturation, band 3.
40	w4_sat	FLOAT4	Y			Fraction of pixels affected by saturation, band 4.
41	satnum	VARCHAR(4)*				Minimum sample at which saturation occurs in frame stack, 1 char per band.
42	cc_flags	VARCHAR(4)*				Prioritized artifacts affecting the source in each band.
43	ext_flg	INT2				Probability that source morphology is not consistent with single PSF.
44	var_flg	VARCHAR(4)*				Probability that flux varied in any band greater than amount expected from unc.s.
45	ph_qual	VARCHAR(4)*				Photometric quality of each band (A=highest, U=upper limit).
46	det_bit	INT2				Bit-encoded integer indicating detection for each band.
47	moon_lev	VARCHAR(4)*				Level of moon contamination in coadd (ceiling(#frmmoon/#frames*10)), 1 per band.
48	w1_nm	INT2	Y			Number of profile-fit flux measurements for source with SNR >= 3, band 1.
49	w1_m	INT2	Y			Number of profile-fit flux measurements for source, band 1.
50	w2_nm	INT2	Y			Number of profile-fit flux measurements for source with SNR >= 3, band 2.
51	w2_m	INT2	Y			Number of profile-fit flux measurements for source, band 2.
52	w3_nm	INT2	Y			Number of profile-fit flux measurements for source with SNR >= 3, band 3.
53	w3_m	INT2	Y			Number of profile-fit flux measurements for source, band 3.
54	w4_nm	INT2	Y			Number of profile-fit flux measurements for source with SNR >= 3, band 4.
55	w4_m	INT2	Y			Number of profile-fit flux measurements for source, band 4.
56	w1_cov	FLOAT4	Y			Mean coverage depth, band 1.
57	w2_cov	FLOAT4	Y			Mean coverage depth, band 2.
58	w3_cov	FLOAT4	Y			Mean coverage depth, band 3.
59	w4_cov	FLOAT4	Y			Mean coverage depth, band 4.
60	w1_cc_map	INT2				Contamination and confusion bit array for the source in band 1.
61	w1_cc_map_str	VARCHAR(4)	Y			Contamination and confusion character array for the source in band 1.
62	w2_cc_map	INT2				Contamination and confusion bit array for the source in band 2.
63	w2_cc_map_str	VARCHAR(4)	Y			Contamination and confusion character array for the source in band 2.
64	w3_cc_map	INT2				Contamination and confusion bit array for the source in band 3.
65	w3_cc_map_str	VARCHAR(4)	Y			Contamination and confusion character array for the source in band 3.
66	w4_cc_map	INT2				Contamination and confusion bit array for the source in band 4.
67	w4_cc_map_str	VARCHAR(4)	Y			Contamination and confusion character array for the source in band 4.
68	w1_flux	FLOAT8	Y		dn	Profile-fit photometry raw flux, band 1.
69	w1_sigflux	FLOAT8	Y		dn	Profile-fit photometry raw flux uncertainty, band 1.
70	w1_sky	FLOAT8	Y		dn	Sky background value, band 1.
71	w1_sigsk	FLOAT4	Y		dn	Sky background value uncertainty, band 1.
72	w1_conf	FLOAT4	Y		dn	Sky confusion based on the uncertainty images, band 1.
73	w2_flux	FLOAT8	Y		dn	Profile-fit photometry raw flux, band 2.
74	w2_sigflux	FLOAT8	Y		dn	Profile-fit photometry raw flux uncertainty, band 2.
75	w2_sky	FLOAT8	Y		dn	Sky background value, band 2.
76	w2_sigsk	FLOAT4	Y		dn	Sky background value uncertainty, band 2.
77	w2_conf	FLOAT4	Y		dn	Sky confusion based on the uncertainty images, band 2.
78	w3_flux	FLOAT8	Y		dn	Profile-fit photometry raw flux, band 3.
79	w3_sigflux	FLOAT8	Y		dn	Profile-fit photometry raw flux uncertainty, band 3.
80	w3_sky	FLOAT8	Y		dn	Sky background value, band 3.
81	w3_sigsk	FLOAT4	Y		dn	Sky background value uncertainty, band 3.
82	w3_conf	FLOAT4	Y		dn	Sky confusion based on the uncertainty images, band 3.
83	w4_flux	FLOAT8	Y		dn	Profile-fit photometry raw flux, band 4.
84	w4_sigflux	FLOAT8	Y		dn	Profile-fit photometry raw flux uncertainty, band 4.
85	w4_sky	FLOAT8	Y		dn	Sky background value, band 4.
86	w4_sigsk	FLOAT4	Y		dn	Sky background value uncertainty, band 4.
87	w4_conf	FLOAT4	Y		dn	Sky confusion based on the uncertainty images, band 4.
88	w1_mag	FLOAT4	Y		mag	Instrumental standard aperture mag w/ aperture correction applied, band 1.
89	w1_sigm	FLOAT4	Y		mag	Instrumental standard aperture mag uncertainty, band 1.
90	w1_flg	INT2	Y			Instrumental standard aperture flag, band 1.
91	w1_mcor	FLOAT4	Y		mag	Instrumental aperture correction, band 1, std ap.
92	w2_mag	FLOAT4	Y		mag	Instrumental standard aperture mag w/ aperture correction applied, band 2.
93	w2_sigm	FLOAT4	Y		mag	Instrumental standard aperture mag uncertainty, band 2.
94	w2_flg	INT2	Y			Instrumental standard aperture flag, band 2.
95	w2_mcor	FLOAT4	Y		mag	Instrumental aperture correction, band 2, std ap.
96	w3_mag	FLOAT4	Y		mag	Instrumental standard aperture mag w/ aperture correction applied, band 3.
97	w3_sigm	FLOAT4	Y		mag	Instrumental standard aperture mag uncertainty, band 3.
98	w3_flg	INT2	Y			Instrumental standard aperture flag, band 3.
99	w3_mcor	FLOAT4	Y		mag	Instrumental aperture correction, band 3, std ap.
100	w4_mag	FLOAT4	Y		mag	Instrumental standard aperture mag w/ aperture correction applied, band 4.
101	w4_sigm	FLOAT4	Y		mag	Instrumental standard aperture mag uncertainty, band 4.
102	w4_flg	INT2	Y			Instrumental standard aperture flag, band 4.
103	w4_mcor	FLOAT4	Y		mag	Instrumental aperture correction, band 4, std ap.
104	w1_mag_1	FLOAT4	Y		mag	Aperture 1 instrumental aperture mag, band 1.
105	w1_sigm_1	FLOAT4	Y		mag	Aperture 1 instrumental aperture mag uncertainty, band 1.
106	w1_flg_1	INT2	Y			Aperture 1 instrumental aperture flag, band 1.
107	w2_mag_1	FLOAT4	Y		mag	Aperture 1 instrumental aperture mag, band 2.
108	w2_sigm_1	FLOAT4	Y		mag	Aperture 1 instrumental aperture mag uncertainty, band 2.
109	w2_flg_1	INT2	Y			Aperture 1 instrumental aperture flag, band 2.
110	w3_mag_1	FLOAT4	Y		mag	Aperture 1 instrumental aperture mag, band 3.
111	w3_sigm_1	FLOAT4	Y		mag	Aperture 1 instrumental aperture mag uncertainty, band 3.
112	w3_flg_1	INT2	Y			Aperture 1 instrumental aperture flag, band 3.
113	w4_mag_1	FLOAT4	Y		mag	Aperture 1 instrumental aperture mag, band 4.
114	w4_sigm_1	FLOAT4	Y		mag	Aperture 1 instrumental aperture mag uncertainty, band 4.
115	w4_flg_1	INT2	Y			Aperture 1 instrumental aperture flag, band 4.
116	w1_mag_2	FLOAT4	Y		mag	Aperture 2.
117	w1_sigm_2	FLOAT4	Y		mag
118	w1_flg_2	INT2	Y
119	w2_mag_2	FLOAT4	Y		mag
120	w2_sigm_2	FLOAT4	Y		mag
121	w2_flg_2	INT2	Y
122	w3_mag_2	FLOAT4	Y		mag
123	w3_sigm_2	FLOAT4	Y		mag
124	w3_flg_2	INT2	Y
125	w4_mag_2	FLOAT4	Y		mag
126	w4_sigm_2	FLOAT4	Y		mag
127	w4_flg_2	INT2	Y
128	w1_mag_3	FLOAT4	Y		mag	Aperture 3.
129	w1_sigm_3	FLOAT4	Y		mag
130	w1_flg_3	INT2	Y
131	w2_mag_3	FLOAT4	Y		mag
132	w2_sigm_3	FLOAT4	Y		mag
133	w2_flg_3	INT2	Y
134	w3_mag_3	FLOAT4	Y		mag
135	w3_sigm_3	FLOAT4	Y		mag
136	w3_flg_3	INT2	Y
137	w4_mag_3	FLOAT4	Y		mag
138	w4_sigm_3	FLOAT4	Y		mag
139	w4_flg_3	INT2	Y
140	w1_mag_4	FLOAT4	Y		mag	Aperture 4.
141	w1_sigm_4	FLOAT4	Y		mag
142	w1_flg_4	INT2	Y
143	w2_mag_4	FLOAT4	Y		mag
144	w2_sigm_4	FLOAT4	Y		mag
145	w2_flg_4	INT2	Y
146	w3_mag_4	FLOAT4	Y		mag
147	w3_sigm_4	FLOAT4	Y		mag
148	w3_flg_4	INT2	Y
149	w4_mag_4	FLOAT4	Y		mag
150	w4_sigm_4	FLOAT4	Y		mag
151	w4_flg_4	INT2	Y
152	w1_mag_5	FLOAT4	Y		mag	Aperture 5.
153	w1_sigm_5	FLOAT4	Y		mag
154	w1_flg_5	INT2	Y
155	w2_mag_5	FLOAT4	Y		mag
156	w2_sigm_5	FLOAT4	Y		mag
157	w2_flg_5	INT2	Y
158	w3_mag_5	FLOAT4	Y		mag
159	w3_sigm_5	FLOAT4	Y		mag
160	w3_flg_5	INT2	Y
161	w4_mag_5	FLOAT4	Y		mag
162	w4_sigm_5	FLOAT4	Y		mag
163	w4_flg_5	INT2	Y
164	w1_mag_6	FLOAT4	Y		mag	Aperture 6.
165	w1_sigm_6	FLOAT4	Y		mag
166	w1_flg_6	INT2	Y
167	w2_mag_6	FLOAT4	Y		mag
168	w2_sigm_6	FLOAT4	Y		mag
169	w2_flg_6	INT2	Y
170	w3_mag_6	FLOAT4	Y		mag
171	w3_sigm_6	FLOAT4	Y		mag
172	w3_flg_6	INT2	Y
173	w4_mag_6	FLOAT4	Y		mag
174	w4_sigm_6	FLOAT4	Y		mag
175	w4_flg_6	INT2	Y
176	w1_mag_7	FLOAT4	Y		mag	Aperture 7.
177	w1_sigm_7	FLOAT4	Y		mag
178	w1_flg_7	INT2	Y
179	w2_mag_7	FLOAT4	Y		mag
180	w2_sigm_7	FLOAT4	Y		mag
181	w2_flg_7	INT2	Y
182	w3_mag_7	FLOAT4	Y		mag
183	w3_sigm_7	FLOAT4	Y		mag
184	w3_flg_7	INT2	Y
185	w4_mag_7	FLOAT4	Y		mag
186	w4_sigm_7	FLOAT4	Y		mag
187	w4_flg_7	INT2	Y
188	w1_mag_8	FLOAT4	Y		mag	Aperture 8.
189	w1_sigm_8	FLOAT4	Y		mag
190	w1_flg_8	INT2	Y
191	w2_mag_8	FLOAT4	Y		mag
192	w2_sigm_8	FLOAT4	Y		mag
193	w2_flg_8	INT2	Y
194	w3_mag_8	FLOAT4	Y		mag
195	w3_sigm_8	FLOAT4	Y		mag
196	w3_flg_8	INT2	Y
197	w4_mag_8	FLOAT4	Y		mag
198	w4_sigm_8	FLOAT4	Y		mag
199	w4_flg_8	INT2	Y
200	w1_magp	FLOAT4	Y		mag	Profile-fit repeatability mag -- inverse-variance weighted mean mag, band 1.
201	w1_sigp1	FLOAT4	Y		mag	Standard deviation of population of profile-fit repeatability mag, band 1.
202	w1_sigp2	FLOAT4	Y		mag	Standard deviation of the mean of profile-fit repeatability mag, band 1.
203	w1_dmag	FLOAT4	Y		mag	Difference between maximum and minimum mag, band 1.
204	w1_ndf	INT2				Number degrees of freedom in variability chi^2, band 1.
205	w1_mlq	INT2	Y			-log10(Q), where Q = 1 - P(chi^2), band 1.
206	w1_mjdmin	FLOAT8	Y			Minimum modified Julian Date of frame extractions, band 1.
207	w1_mjdmax	FLOAT8	Y			Maximum modified Julian Date of frame extractions, band 1.
208	w1_mjdmean	FLOAT8	Y			Mean modified Julian Date of frame extractions, band 1.
209	w2_magp	FLOAT4	Y		mag	Profile-fit repeatability mag -- inverse-variance weighted mean mag, band 2.
210	w2_sigp1	FLOAT4	Y		mag	Standard deviation of population of profile-fit repeatability mag, band 2.
211	w2_sigp2	FLOAT4	Y		mag	Standard deviation of the mean of profile-fit repeatability mag, band 2.
212	w2_dmag	FLOAT4	Y		mag	Difference between maximum and minimum mag, band 2.
213	w2_ndf	INT2				Number degrees of freedom in variability chi^2, band 2.
214	w2_mlq	INT2	Y			-log10(Q), where Q = 1 - P(chi^2), band 2.
215	w2_mjdmin	FLOAT8	Y			Minimum modified Julian Date of frame extractions, band 2.
216	w2_mjdmax	FLOAT8	Y			Maximum modified Julian Date of frame extractions, band 2.
217	w2_mjdmean	FLOAT8	Y			Mean modified Julian Date of frame extractions, band 2.
218	w3_magp	FLOAT4	Y		mag	Profile-fit repeatability mag -- inverse-variance weighted mean mag, band 3.
219	w3_sigp1	FLOAT4	Y		mag	Standard deviation of population of profile-fit repeatability mag, band 3.
220	w3_sigp2	FLOAT4	Y		mag	Standard deviation of the mean of profile-fit repeatability mag, band 3.
221	w3_dmag	FLOAT4	Y		mag	Difference between maximum and minimum mag, band 3.
222	w3_ndf	INT2				Number degrees of freedom in variability chi^2, band 3.
223	w3_mlq	INT2	Y			-log10(Q), where Q = 1 - P(chi^2), band 3.
224	w3_mjdmin	FLOAT8	Y			Minimum modified Julian Date of frame extractions, band 3.
225	w3_mjdmax	FLOAT8	Y			Maximum modified Julian Date of frame extractions, band 3.
226	w3_mjdmean	FLOAT8	Y			Mean modified Julian Date of frame extractions, band 3.
227	w4_magp	FLOAT4	Y		mag	Profile-fit repeatability mag -- inverse-variance weighted mean mag, band 4.
228	w4_sigp1	FLOAT4	Y		mag	Standard deviation of population of profile-fit repeatability mag, band 4.
229	w4_sigp2	FLOAT4	Y		mag	Standard deviation of the mean of profile-fit repeatability mag, band 4.
230	w4_dmag	FLOAT4	Y		mag	Difference between maximum and minimum mag, band 4.
231	w4_ndf	INT2				Number degrees of freedom in variability chi^2, band 4.
232	w4_mlq	INT2	Y			-log10(Q), where Q = 1 - P(chi^2), band 4.
233	w4_mjdmin	FLOAT8	Y			Minimum modified Julian Date of frame extractions, band 4.
234	w4_mjdmax	FLOAT8	Y			Maximum modified Julian Date of frame extractions, band 4.
235	w4_mjdmean	FLOAT8	Y			Mean modified Julian Date of frame extractions, band 4.
236	rho12	INT2	Y		%	band 1 - band 2 correlation coefficient.
237	rho23	INT2	Y		%	band 2 - band 3 correlation coefficient.
238	rho34	INT2	Y		%	band 3 - band 4 correlation coefficient.
239	q12	INT2	Y			-log10(1 - P(rho12)), given no real correlation.
240	q23	INT2	Y			-log10(1 - P(rho23)), given no real correlation.
241	q34	INT2	Y			-log10(1 - P(rho34)), given no real correlation.
242	xscprox	FLOAT4	Y		arcsec	Distance between source center and XSC galaxy.
243	w1_rsemi	FLOAT4	Y		arcsec	Semi-major axis of galaxy from XSC, band 1.
244	w1_ba	FLOAT4	Y			Axis ratio of galaxy from XSC, band 1.
245	w1_pa	FLOAT4	Y		deg	Position angle (E of N) of galaxy from XSC, band 1.
246	w1_gmag	FLOAT4	Y		mag	Elliptical aperture mag of extracted galaxy, band 1.
247	w1_gerr	FLOAT4	Y		mag	Elliptical aperture mag uncertainty of extracted galaxy, band 1.
248	w1_gflg	INT2	Y			Elliptical aperture flag of extracted galaxy, band 1.
249	w2_rsemi	FLOAT4	Y		arcsec	Semi-major axis of galaxy from XSC, band 2.
250	w2_ba	FLOAT4	Y			Axis ratio of galaxy from XSC, band 2.
251	w2_pa	FLOAT4	Y		deg	Position angle (E of N) of galaxy from XSC, band 2.
252	w2_gmag	FLOAT4	Y		mag	Elliptical aperture mag of extracted galaxy, band 2.
253	w2_gerr	FLOAT4	Y		mag	Elliptical aperture mag uncertainty of extracted galaxy, band 2.
254	w2_gflg	INT2	Y			Elliptical aperture flag of extracted galaxy, band 2.
255	w3_rsemi	FLOAT4	Y		arcsec	Semi-major axis of galaxy from XSC, band 3.
256	w3_ba	FLOAT4	Y			Axis ratio of galaxy from XSC, band 3.
257	w3_pa	FLOAT4	Y		deg	Position angle (E of N) of galaxy from XSC, band 3.
258	w3_gmag	FLOAT4	Y		mag	Elliptical aperture mag of extracted galaxy, band 3.
259	w3_gerr	FLOAT4	Y		mag	Elliptical aperture mag uncertainty of extracted galaxy, band 3.
260	w3_gflg	INT2	Y			Elliptical aperture flag of extracted galaxy, band 3.
261	w4_rsemi	FLOAT4	Y		arcsec	Semi-major axis of galaxy from XSC, band 4.
262	w4_ba	FLOAT4	Y			Axis ratio of galaxy from XSC, band 4.
263	w4_pa	FLOAT4	Y		deg	Position angle (E of N) of galaxy from XSC, band 4.
264	w4_gmag	FLOAT4	Y		mag	Elliptical aperture mag of extracted galaxy, band 4.
265	w4_gerr	FLOAT4	Y		mag	Elliptical aperture mag uncertainty of extracted galaxy, band 4.
266	w4_gflg	INT2	Y			Elliptical aperture flag of extracted galaxy, band 4.
267	tmass_key	INT4	Y			Closest associated 2MASS All-Sky Release PSC key.
268	r_2mass	FLOAT4	Y		arcsec	Radial offset between WISE src and associated 2MASS src.
269	pa_2mass	FLOAT4	Y		deg	Position angle (E of N) of vector from WISE src to associated 2MASS src.
270	n_2mass	INT2				Number of 2MASS All-Sky PSC entries found within search radius of WISE src.
271	j_m_2mass	FLOAT4	Y		mag	J magnitude entry of the associated 2MASS All-Sky PSC source.
272	j_msig_2mass	FLOAT4	Y		mag	J photometric uncertainty of the associated 2MASS All-Sky PSC source.
273	h_m_2mass	FLOAT4	Y		mag	H magnitude entry of the associated 2MASS All-Sky PSC source.
274	h_msig_2mass	FLOAT4	Y		mag	H photometric uncertainty of the associated 2MASS All-Sky PSC source.
275	k_m_2mass	FLOAT4	Y		mag	Ks magnitude entry of the associated 2MASS All-Sky PSC source.
276	k_msig_2mass	FLOAT4	Y		mag	Ks photometric uncertainty of the associated 2MASS All-Sky PSC source.
277	best_use_cntr	INT8				cntr of source to use from 'best' duplicate resolution group for this source.
278	ngrp	INT2				Number of duplicate resolution groups in which this source resides.
279	spt_ind	INT4				Spatial (x,y,z) index key.
280	cx	FLOAT8				Unit vector for (ra,dec).
281	cy	FLOAT8				Unit vector for (ra,dec)..
282	cz	FLOAT8				Unit vector for (ra,dec)..

USNO-B1.0 Catalog

Number of rows: 1,045,175,762.

#	name	type	null	index	unit	description
1	objid	INT8		P		Primary key (unique identifier) for the 2MASS Kit database. Do not refer this ID in your literatures.
2	usnob1_id	VARCHAR(12)*				Designation of the object.
3	tycho2_id	VARCHAR(12)*	Y			Designation in the Tycho-2 Catalog.
4	ra	FLOAT8			deg	Right Ascension at Eq=J2000, Ep=J2000.
5	dec	FLOAT8			deg	Declination at Eq=J2000, Ep=J2000.
6	e_ra	INT2	Y		mas	Mean error on ra*cos(dec) at epoch.
7	e_dec	INT2	Y		mas	Mean error on dec at Epoch.
8	epoch	FLOAT4	Y		yr	Mean epoch of observation.
9	pm_ra	INT2			mas/yr	Proper motion in Right Ascension (relative to YS4.0).
10	pm_dec	INT2			mas/yr	Proper motion in Declination (relative to YS4.0).
11	e_pm_ra	INT2	Y		mas/yr	Mean error on pm_ra.
12	e_pm_dec	INT2	Y		mas/yr	Mean error on pm_dec.
13	pm_prob	INT2	Y		0.1	Total Proper Motion probability.
14	e_fit_ra	FLOAT4	Y		arcsec	Mean error on Right Ascension fit.
15	e_fit_dec	FLOAT4	Y		arcsec	Mean error on Declination fit.
16	ndet	INT2				Number of detections.
17	flags	VARCHAR(3)*				Flags on object.
18	b1_mag	FLOAT4	Y	S	mag	First blue magnitude.
19	b1_cal	INT2	Y			Source of photometric calibration.
20	b1_survey	INT2	Y			Survey number.
21	b1_field	INT2	Y			Field number in survey.
22	b1_class	INT2	Y			Star-galaxy separation.
23	b1_xi	FLOAT4	Y		arcsec	Residual in X direction.
24	b1_eta	FLOAT4	Y		arcsec	Residual in Y direction.
25	r1_mag	FLOAT4	Y	S	mag	First red magnitude.
26	r1_cal	INT2	Y			Source of photometric calibration.
27	r1_survey	INT2	Y			Survey number.
28	r1_field	INT2	Y			Field number in survey.
29	r1_class	INT2	Y			Star-galaxy separation.
30	r1_xi	FLOAT4	Y		arcsec	Residual in X direction.
31	r1_eta	FLOAT4	Y		arcsec	Residual in Y direction.
32	b2_mag	FLOAT4	Y	S	mag	Second blue magnitude.
33	b2_cal	INT2	Y			Source of photometric calibration.
34	b2_survey	INT2	Y			Survey number.
35	b2_field	INT2	Y			Field number in survey.
36	b2_class	INT2	Y			Star-galaxy separation.
37	b2_xi	FLOAT4	Y		arcsec	Residual in X direction.
38	b2_eta	FLOAT4	Y		arcsec	Residual in Y direction.
39	r2_mag	FLOAT4	Y	S	mag	Second red magnitude.
40	r2_cal	INT2	Y			Source of photometric calibration.
41	r2_survey	INT2	Y			Survey number.
42	r2_field	INT2	Y			Field number in survey.
43	r2_class	INT2	Y			Star-galaxy separation.
44	r2_xi	FLOAT4	Y		arcsec	Residual in X direction.
45	r2_eta	FLOAT4	Y		arcsec	Residual in Y direction.
46	i_mag	FLOAT4	Y	S	mag	Infrared (N) magnitude.
47	i_cal	INT2	Y			Source of photometric calibration.
48	i_survey	INT2	Y			Survey number.
49	i_field	INT2	Y			Field number in survey.
50	i_class	INT2	Y			Star-galaxy separation.
51	i_xi	FLOAT4	Y		arcsec	Residual in X direction.
52	i_eta	FLOAT4	Y		arcsec	Residual in Y direction.
53	cx	FLOAT8				Unit vector for (ra,dec).
54	cy	FLOAT8				Unit vector for (ra,dec).
55	cz	FLOAT8				Unit vector for (ra,dec).

GSC-2.3.2

Number of rows: 945,592,683.

#	name	type	null	index	unit	description
1	objid	INT8		P		Primary key (unique identifier) for the 2MASS Kit database. Do not refer this ID in your literatures.
2	gsc23_id	VARCHAR(10)*				GSC2 name for HST ops.
3	gsc1_id	VARCHAR(10)*				GSC1 name.
4	ra	FLOAT8			deg	RA (J2000).
5	dec	FLOAT8			deg	Dec (J2000).
6	e_ra	FLOAT4			arcsec	RA error.
7	e_dec	FLOAT4			arcsec	Dec error.
8	epoch	FLOAT4			year	Epoch of position.
9	fpg_mag	FLOAT4	Y	S	mag	IIIaF magnitude.
10	e_fpg_mag	FLOAT4	Y		mag	Mag error of fpg_mag.
11	code_fpg_mag	INT2	Y			Bandpass code.
12	jpg_mag	FLOAT4	Y	S	mag	IIIaJ magnitude.
13	e_jpg_mag	FLOAT4	Y		mag	Mag error of jpg_mag.
14	code_jpg_mag	INT2	Y			Bandpass code.
15	v_mag	FLOAT4	Y	S	mag	'V' band magnitude.
16	e_v_mag	FLOAT4	Y		mag	Mag error of v_mag.
17	code_v_mag	INT2	Y			Bandpass code.
18	npg_mag	FLOAT4	Y	S	mag	IV-N magnitude.
19	e_npg_mag	FLOAT4	Y		mag	Mag error of npg_mag.
20	code_npg_mag	INT2	Y			Bandpass code.
21	u_mag	FLOAT4	Y	S	mag	'U' magnitude.
22	e_u_mag	FLOAT4	Y		mag	Mag error of u_mag.
23	code_u_mag	INT2	Y			Bandpass code.
24	b_mag	FLOAT4	Y	S	mag	'B' magnitude.
25	e_b_mag	FLOAT4	Y		mag	Mag error of b_mag.
26	code_b_mag	INT2	Y			Bandpass code.
27	class	INT2				Classification code.
28	sz_obj	FLOAT4	Y		pixels	Object size (semi-major axis).
29	ecc_obj	FLOAT4	Y			Object eccentricity.
30	pa_obj	FLOAT4	Y		deg	Object Position Angle.
31	status	INT4				Object flags.
32	m_flag	INT2				Flag for known multiple.
33	htm6	VARCHAR(8)*				HTM-6 designation.
34	cx	FLOAT8				Unit vector for (ra,dec).
35	cy	FLOAT8				Unit vector for (ra,dec).
36	cz	FLOAT8				Unit vector for (ra,dec).

UCAC3

Number of rows: 100,766,420.

#	name	type	null	index	unit	description
1	objid	INT8		P		Primary key (unique identifier) for the 2MASS Kit database. Do not refer this ID in your literatures.
2	ucac3_id	VARCHAR(10)*				Unique identifier of UCAC3.
3	ra	FLOAT8			deg	Right Ascension at epoch J2000.0 (ICRS).
4	dec	FLOAT8			deg	Declination at epoch J2000.0 (ICRS).
5	e_ra	INT2			mas	s.e. at central epoch in ra (*cos dec).
6	e_dec	INT2			mas	s.e. at central epoch in dec.
7	ep_ra	FLOAT4			yr	Central epoch for mean ra.
8	ep_dec	FLOAT4			yr	Central epoch for mean dec.
9	pm_ra	FLOAT4	Y		mas/yr	Proper motion in ra*cos(dec).
10	pm_dec	FLOAT4	Y		mas/yr	Proper motion in dec.
11	e_pm_ra	FLOAT4	Y		mas/yr	s.e. of pm_ra * cos dec.
12	e_pm_dec	FLOAT4	Y		mas/yr	s.e. of pm_dec.
13	fit_mag	FLOAT4	Y	S	mag	UCAC fit model magnitude.
14	ap_mag	FLOAT4	Y	S	mag	UCAC aperture magnitude.
15	e_ap_mag	FLOAT4	Y		mag	UCAC error on magnitude (larger of sc.mod).
16	obj_type	INT2				Object type.
17	ds_flag	INT2				Double star flag.
18	n_obs	INT2				Total # of CCD images of this star.
19	n_uobs	INT2				# of CCD images used for this star.
20	n_pos	INT2				Total numb. catalogs (epochs) initial match.
21	n_upos	INT2				# catalogs (epochs) used for proper motions.
22	id_2mass	INT4	Y			2MASS pts_key star identifier.
23	j_mag	FLOAT4	Y	S	mag	2MASS J magnitude.
24	e_j_mag	FLOAT4	Y		mag	2MASS error photom.
25	q_j_mag	FLOAT4	Y			2MASS cc_flg*10 + phot.qual.flag.
26	h_mag	FLOAT4	Y	S	mag	2MASS H magnitude.
27	e_h_mag	FLOAT4	Y		mag	2MASS error photom.
28	q_h_mag	FLOAT4	Y			2MASS cc_flg*10 + phot.qual.flag.
29	k_mag	FLOAT4	Y	S	mag	2MASS K_s magnitude.
30	e_k_mag	FLOAT4	Y		mag	2MASS error photom.
31	q_k_mag	FLOAT4	Y			2MASS cc_flg*10 + phot.qual.flag.
32	class_sc	INT2	Y			SuperCosmos star/galaxy classif./quality flag.
33	b_mag	FLOAT4	Y	S	mag	SuperCosmos Bmag.
34	q_b_mag	INT2	Y			SuperCosmos quality flag Bmag.
35	r2_mag	FLOAT4	Y	S	mag	SuperCosmos R2mag.
36	q_r2_mag	INT2	Y			SuperCosmos quality flag R2mag.
37	i_mag	FLOAT4	Y	S	mag	SuperCosmos Imag.
38	q_i_mag	INT2	Y			SuperCosmos quality flag Imag.
39	cat_flags	VARCHAR(10)*				mmf flag for 10 major catalogs matched.
40	spm_g_flag	INT2				Yale SPM object type (g-flag).
41	spm_c_flag	INT2				Yale SPM input cat. (c-flag).
42	leda_match	INT2				LEDA galaxy match flag.
43	x2m_match	INT2				2MASS extend.source flag.
44	mpos_num	INT4				MPOS star number; identifies HPM stars.
45	cx	FLOAT8				Unit vector for (ra,dec).
46	cy	FLOAT8				Unit vector for (ra,dec).
47	cz	FLOAT8				Unit vector for (ra,dec).

PPMXL Catalog

Number of rows: 910,468,710.

#	name	type	null	index	unit	description
1	objid	INT8		P		Primary key (unique identifier) for the 2MASS Kit database. Do not refer this ID in your literatures.
2	ppmxl_id	INT8				Identifier of PPMXL catalog.
3	ra	FLOAT8			deg	Right Ascension J2000.0, epoch 2000.0.
4	dec	FLOAT8			deg	Declination J2000.0, epoch 2000.0.
5	e_ra	INT2			mas	Mean error in ra*cos(dec) at mean epoch.
6	e_dec	INT2			mas	Mean error in dec at mean epoch.
7	ep_ra	FLOAT4				Mean Epoch (ra).
8	ep_dec	FLOAT4				Mean Epoch (dec).
9	pm_ra	FLOAT4			mas/yr	Proper Motion in ra*cos(dec).
10	pm_dec	FLOAT4			mas/yr	Proper Motion in dec.
11	e_pm_ra	FLOAT4			mas/yr	Mean error in pm_ra*cos(dec).
12	e_pm_dec	FLOAT4			mas/yr	Mean error in pm_dec.
13	j_mag	FLOAT4	Y	S	mag	J magnitude from 2MASS.
14	e_j_mag	FLOAT4	Y		mag	J total magnitude uncertainty.
15	h_mag	FLOAT4	Y	S	mag	H magnitude from 2MASS.
16	e_h_mag	FLOAT4	Y		mag	H total magnitude uncertainty.
17	k_mag	FLOAT4	Y	S	mag	Ks magnitude from 2MASS.
18	e_k_mag	FLOAT4	Y		mag	Ks total magnitude uncertainty.
19	b1_mag	FLOAT4	Y	S	mag	B mag from USNO-B, first epoch.
20	b2_mag	FLOAT4	Y	S	mag	B mag from USNO-B, second epoch.
21	r1_mag	FLOAT4	Y	S	mag	R mag from USNO-B, first epoch.
22	r2_mag	FLOAT4	Y	S	mag	R mag from USNO-B, second epoch.
23	i_mag	FLOAT4	Y	S	mag	I mag from USNO-B.
24	usnob1_flags	VARCHAR(5)*				Surveys used for USNO-B magnitudes.
25	n_uobs	INT2				Number of observations used.
26	flags	INT2				Flags.
27	cx	FLOAT8				Unit vector for (ra,dec).
28	cy	FLOAT8				Unit vector for (ra,dec).
29	cz	FLOAT8				Unit vector for (ra,dec).

Tycho-2 Catalogue

Number of rows: 2,539,913.

#	name	type	null	index	unit	description
1	objid	INT4		P		Primary key (unique identifier) for the 2MASS Kit database. Do not refer this ID in your literatures.
2	tycho2_id	VARCHAR(12)*		U		Identifier for Tycho-2 Catalogue.
3	p_flag	VARCHAR(1)*		S		Mean position flag.
4	ra_m	FLOAT8	Y	S	deg	Mean Right Ascension, ICRS, epoch J2000.
5	dec_m	FLOAT8	Y	S	deg	Mean Declination, ICRS, at epoch J2000.
6	e_ra_m	INT2	Y		mas	s.e. RA*cos(Dec),at mean epoch.
7	e_dec_m	INT2	Y		mas	s.e. of Dec at mean epoch.
8	ep_ra_m	FLOAT4	Y		yr	Mean epoch of RA.
9	ep_dec_m	FLOAT4	Y		yr	Mean epoch of Dec.
10	pm_ra	FLOAT4	Y		mas/yr	Proper motion in RA*cos(Dec).
11	pm_dec	FLOAT4	Y		mas/yr	Proper motion in Dec.
12	e_pm_ra	FLOAT4	Y		mas/yr	s.e. of proper motion in RA*cos(Dec).
13	e_pm_dec	FLOAT4	Y		mas/yr	s.e. of proper motion in Dec.
14	n_upos	INT2	Y			Number of positions used.
15	q_ra_m	FLOAT4	Y			Goodness of fit for ra_m.
16	q_dec_m	FLOAT4	Y			Goodness of fit for dec_m.
17	q_pm_ra	FLOAT4	Y			Goodness of fit for pm_ra.
18	q_pm_dec	FLOAT4	Y			Goodness of fit for pm_dec.
19	bt_mag	FLOAT4	Y	S	mag	Tycho-2 BT magnitude.
20	e_bt_mag	FLOAT4	Y		mag	s.e. of BT.
21	vt_mag	FLOAT4	Y	S	mag	Tycho-2 VT magnitude.
22	e_vt_mag	FLOAT4	Y			s.e. of VT.
23	prox	INT2				Proximity indicator.
24	tycho1_flag	VARCHAR(1)*				Tycho-1 star.
25	hip_id	INT4	Y			Hipparcos number.
26	ccdm_hip	VARCHAR(13)	Y			CCDM component identifier for HIP stars.
27	ra	FLOAT8		S	deg	Observed Tycho-2 Right Ascension, ICRS.
28	dec	FLOAT8		S	deg	Observed Tycho-2 Declination, ICRS.
29	e_ra	FLOAT4			mas	s.e. RA*cos(Dec), of observed Tycho-2 RA.
30	e_dec	FLOAT4			mas	s.e. of observed Tycho-2 Dec.
31	ep_ra	FLOAT4			yr	Epoch of ra.
32	ep_dec	FLOAT4			yr	Epoch of dec.
33	t_flag	VARCHAR(1)*		S		Type of Tycho-2 solution.
34	corr	FLOAT4				Correlation (ra,dec).
35	cx_m	FLOAT8	Y	C1		Unit vector for (ra_m,dec_m).
36	cy_m	FLOAT8	Y	C1		Unit vector for (ra_m,dec_m).
37	cz_m	FLOAT8	Y	C1		Unit vector for (ra_m,dec_m).
38	cx	FLOAT8		C2		Unit vector for (ra,dec).
39	cy	FLOAT8		C2		Unit vector for (ra,dec).
40	cz	FLOAT8		C2		Unit vector for (ra,dec).

AKARI IRC PSC v1

Number of rows: 870,973.

#	name	type	null	index	unit	description
1	objid	INT4		P		Primary key (unique identifier) for the 2MASS Kit database. Do not refer this ID in your literatures.
2	objName	VARCHAR(14)*		U		Source name from its J2000 coordinates, following the IAU Recommendations for Nomenclature (2006). The format is HHMMSSS+/-DDMMSS, e.g., 0123456+765432 for a source at (01h23m45.6s, +76d54m32s). The source must be referred to in the literatures by its full name: AKARI-IRC-V1 J0123456+765432, where V1 refers to the version code.
3	ra	FLOAT8		S	deg	J2000 Right Ascension of the source position.
4	dec	FLOAT8		S	deg	J2000 Declination of the source position.
5	posErrMj	FLOAT4			arcsec	One-sigma error of the source position expressed by an ellipse with Major and Minor axes [arcsec], and Position Angle [deg; East from North]. If only two events are available, posErrMj is calculated from the distance of the two events and PosErrMi is set to the same as PosErrMj.
6	posErrMi	FLOAT4			arcsec	See description of posErrMj.
7	posErrPA	FLOAT4			deg	See description of posErrMj.
8	flux_09	FLOAT4	Y	S	Jy	Flux density of the source in S9W in Jansky.
9	flux_18	FLOAT4	Y	S	Jy	Flux density of the source in L18W in Jansky.
10	fErr_09	FLOAT4	Y		Jy	Flux error in S9W.
11	fErr_18	FLOAT4	Y		Jy	Flux error in L18W.
12	fQual_09	INT2		S		Flux density quality flag for S9W. 3 when flux is valid and 0 when flux is not available.
13	fQual_18	INT2		S		Flux density quality flag for L18W. 3 when flux is valid and 0 when flux is not available.
14	flags_09	INT2	Y			Bit flags of data quality for S9W: 1(LSB): not month confirmed: This means that the period between the first detection and the last detection is shorter than a month. 2: saturated (not used in this version) 4: use SAA (not used in this version) 8(MSB): use edge events: If the number of events is too small, we use the event data near the edge of the image strip. In this case, this flag warn you of underestimation of the flux.
15	flags_18	INT2	Y			Bit flags of data quality for L18W. The value definition is the same as that of flags_09.
16	nScanC_09	INT2				Number of scans on which the source is detected. Normally, nScanC is less or equal to nScanP. In some exceptional case, resultant position of the source drops out from the image stripe boundary and nScanC is larger than nScanP.
17	nScanC_18	INT2				Number of scans on which the source is detected. The value definition is the same as that of nScanC_09.
18	nScanP_09	INT2				The number of times the source position has been scanned during the survey.
19	nScanP_18	INT2				The number of times the source position has been scanned during the survey.
20	mConf_09	INT2	Y			1 is month confirmed and 0 is not. Inverted value of LSB of flags_09
21	mConf_18	INT2	Y			1 is month confirmed and 0 is not. Inverted value of LSB of flags_18
22	nDens_09	INT2	Y			The number of sources in 45 arcsec radius.
23	nDens_18	INT2	Y			The number of sources in 45 arcsec radius.
24	extended_09	INT2	Y			The flag indicates that the source is possibly more extended than the point spread function. This is "TRUE" when meanAB > 15.6 [arcsec].
25	extended_18	INT2	Y			The flag indicates that the source is possibly more extended than the point spread function. This is "TRUE" when meanAB > 15.6 [arcsec].
26	meanAB_09	FLOAT4	Y			The average of radius along major and minor axes of images, i.e. (< a > + < b >)/2 where < a > and < b > are the mean semi-major and semi-minor axis lengths of images estimated by SExtractor.
27	meanAB_18	FLOAT4	Y			The average of radius along major and minor axes of images, i.e. (< a > + < b >)/2 where < a > and < b > are the mean semi-major and semi-minor axis lengths of images estimated by SExtractor.
28	nDataPos	INT2				Number of events used to calculate the mean coordinates. If the source has more than two available S9W events, the position is estimated from S9W events only, else the position is estimated from L18W events, i.e. nDataPos = nScanC09 for nScanC09 ≥ 2 nDataPos = nScanC18 for nScanC09 < 2
29	nData_09	INT2				Number of events that contribute to the flux measurements in the two bands. Normally, events near the edge of the image strip are excluded from the measurements. Note that if only 0 or 1 event are available, the flux is computed also from edge events.
30	nData_18	INT2				Number of events that contribute to the flux measurements in the two bands. The value definition is the same as that of nData_09.
31	cx	FLOAT8		C1		Unit vector for (ra,dec)
32	cy	FLOAT8		C1		Unit vector for (ra,dec)
33	cz	FLOAT8		C1		Unit vector for (ra,dec)

AKARI FIS BSC v1

Number of rows: 427,071.

#	name	type	null	index	unit	description
1	objid	INT4		P		Primary key (unique identifier) for the 2MASS Kit database. Do not refer this ID in your literatures.
2	objName	VARCHAR(14)*		U		Source identifier from its J2000 coordinates, following the IAU Recommendations for Nomenclature (2006). The format is HHMMSSS+/-DDMMSS, e.g., 0123456+765432 for a source at (01h23m45.6s, +76d54m32s). The source must be referred to in the literatures by its full name; AKARI-FIS-V1 J0123456+765432.
3	ra	FLOAT8		S	deg	J2000 Right Ascension of the source position.
4	dec	FLOAT8		S	deg	J2000 Declination of the source position.
5	posErrMj	FLOAT4			arcsec	One-sigma error of the source position expressed by an ellipse with Major and Minor axes in arcsec, and Position Angle in degees measured from North to East. In the currently version we give the same value (6.0 arcsec) for all the sources both in the major and minor axis (thus polar-angle is 0.0) based on the statistical analysis in Section 5.5 of the Release Note .
6	posErrMi	FLOAT4			arcsec	See description of posErrMj.
7	posErrPA	FLOAT4			deg	See description of posErrMj.
8	flux_65	FLOAT4	Y	S	Jy	Flux density of the source in the four FIS bands in Jansky. In the catalogue the four FIS bands are indicated by their central wavelength as 65, 90, 140 and 160. Values are given even for the unconfirmed sources as much as possible, though such the data are not guaranteed. If it is not possible to measure the source flux, `NULL' is set.
9	flux_90	FLOAT4	Y	S	Jy	See description of flux_65.
10	flux_140	FLOAT4	Y	S	Jy	See description of flux_65.
11	flux_160	FLOAT4	Y	S	Jy	See description of flux_65.
12	fErr_65	FLOAT4	Y		Jy	Flux uncertainty of the source flux in Jansky. It is evaluated as the standard deviation of the fluxes measured on the individual scans divided by the root square of the number of measurements (presented in nScanC_65). The error thus only includes relative uncertainty at the measurements. Details of the flux uncertainty are discussed in Section 5.3 of the Release Note . When it is not possible to calculate the standard deviation, `NULL' is set to this column.
13	fErr_90	FLOAT4	Y		Jy	Flux uncertainty of the source flux in Jansky. The value definition is the same as that of fErr_65.
14	fErr_140	FLOAT4	Y		Jy	Flux uncertainty of the source flux in Jansky. The value definition is the same as that of fErr_65.
15	fErr_160	FLOAT4	Y		Jy	Flux uncertainty of the source flux in Jansky. The value definition is the same as that of fErr_65.
16	fQual_65	INT2		S		Four level flux quality indicator: 3: High quality (the source is confirmed and flux is reliable) 2: The source is confirmed but flux is not reliable (see flags_65) 1: The source is not confirmed 0: Not observed (no scan data available)
17	fQual_90	INT2		S		Four level flux quality indicator. The value definition is the same as that of fQual_65.
18	fQual_140	INT2		S		Four level flux quality indicator. The value definition is the same as that of fQual_65.
19	fQual_160	INT2		S		Four level flux quality indicator. The value definition is the same as that of fQual_65.
20	flags_65	INT2	Y			A 16-bit flag per band indicating various data condition. In version 1 catalogue three bits are used. The first bit (bit0) is used to indicate the CDS sampling mode. The second bit (bit1) warns the flux of the band is less than a half of the detection limit, and is not reliable. The fourth bit (bit3) tells that the source is possibly false detection due to `side-lobe' effects (see, Section 7.7 of the Release Note). The third bit (bit2) was previously indicated an anomaly which does not exist in the current version, and thus is kept unused. Sources with bit1 or bit3 = 1 have fQual_65 = 2 or less. Other bits are reserved for the future implementation. USB ------------- bit ----- LSB ... 7 6 5 4 3 2 1 0 decimal \| \| \| \| \| \| \| \| reserved ------------------------- 128 -+ \| \| \| \| \| \| \| reserved -------------------------- 64 ----+ \| \| \| \| \| \| reserved -------------------------- 32 -------+ \| \| \| \| \| reserved -------------------------- 16 ----------+ \| \| \| \| 1: possibly `side-lobe' detection--- 8 -------------+ \| \| \| not used --------------------------- 4 ----------------+ \| \| 1: Flux too low--------------------- 2 -------------------+ \| 0: Normal mode, 1: CDS mode -------- 1 ----------------------+ `NULL' is set in case of no measurement (fQual_65 = 0).
21	flags_90	INT2	Y			A 16-bit flag per band indicating various data condition. The value definition is the same as that of flags_65.
22	flags_140	INT2	Y			A 16-bit flag per band indicating various data condition. The value definition is the same as that of flags_65.
23	flags_160	INT2	Y			A 16-bit flag per band indicating various data condition. The value definition is the same as that of flags_65.
24	nScanC_65	INT2				Number of scans on which the source is properly detected with logEvidence larger than the threshold.
25	nScanC_90	INT2				Number of scans on which the source is properly detected with logEvidence larger than the threshold.
26	nScanC_140	INT2				Number of scans on which the source is properly detected with logEvidence larger than the threshold.
27	nScanC_160	INT2				Number of scans on which the source is properly detected with logEvidence larger than the threshold.
28	nScanP_65	INT2				Total number of scans that passed on the source (that possibly observed the source)
29	nScanP_90	INT2				Total number of scans that passed on the source (that possibly observed the source)
30	nScanP_140	INT2				Total number of scans that passed on the source (that possibly observed the source)
31	nScanP_160	INT2				Total number of scans that passed on the source (that possibly observed the source)
32	mConf_65	INT2	Y			The month confirmation flags are prepared per band. The value is 1 when the source is observed in the scans separated more than one months (usually an object is visible at every 6 months). This information is independent to hours confirmation and can be 1 even if the source is not confirmed (fQual_65 = 1). Because of the visibility constraint of the AKARI Survey, some sky regions were observed by scans only within a month. This flag is `NULL' for fQual_65 = 0 sources.
33	mConf_90	INT2	Y			The month confirmation flags are prepared per band. The value definition is the same as that of mConf_65.
34	mConf_140	INT2	Y			The month confirmation flags are prepared per band. The value definition is the same as that of mConf_65.
35	mConf_160	INT2	Y			The month confirmation flags are prepared per band. The value definition is the same as that of mConf_65.
36	nDens	INT2				Number of sources in the catalogue within the distance of 5 arcmin from the source. This value is intended to be an indicator of crowdedness of the sky region. Since the source extraction program is tuned so that a unique source is found within 48 arcsec radius, the 5 arcmin radius corresponds to approximately 40 beams.
37	cx	FLOAT8		C1		Unit vector for (ra,dec)
38	cy	FLOAT8		C1		Unit vector for (ra,dec)
39	cz	FLOAT8		C1		Unit vector for (ra,dec)

IRAS PSC v2.1

Number of rows: 245,889.

#	name	type	null	index	unit	description
1	objid	INT4		P		Primary key (unique identifier) for the 2MASS Kit database. Do not refer this ID in your literatures.
2	pscname	VARCHAR(11)		U		IRAS source name.
3	ra	FLOAT8		S	deg	RA equinox J2000.0, epoch B1983.5.
4	dec	FLOAT8		S	deg	Dec equinox J2000.0, epoch B1983.5.
5	semimajor	INT2			arcsec	95% confidence error ellipse semimajor axis.
6	semiminor	INT2			arcsec	95% confidence error ellipse semiminor axis.
7	posang	INT2			deg	Uncertainty ellipse position angle.
8	nhcon	INT2				Number of times observed.
9	fnu_12	FLOAT8		S	Jy	Average non-color corrected flux density, 12um.
10	fnu_25	FLOAT8		S	Jy	Average non-color corrected flux density, 25um.
11	fnu_60	FLOAT8		S	Jy	Average non-color corrected flux density, 60um.
12	fnu_100	FLOAT8		S	Jy	Average non-color corrected flux density, 100u.
13	fqual_12	INT2		S		Flux density quality, 12um.
14	fqual_25	INT2		S		Flux density quality, 25um.
15	fqual_60	INT2		S		Flux density quality, 60um.
16	fqual_100	INT2		S		Flux density quality, 100um.
17	nlrs	INT2				Number of significant LRS spectra.
18	lrschar	VARCHAR(2)*	Y			Characterization of averaged LRS spectrum.
19	relunc_12	INT2				Percent relative flux den. uncertainty, 12um.
20	relunc_25	INT2				Percent relative flux den. uncertainty, 25um.
21	relunc_60	INT2				Percent relative flux den. uncertainty, 60um.
22	relunc_100	INT2				Percent relative flux den. uncertainty, 100um.
23	tsnr_12	INT4				10x minimum signal-to-noise ratio, 12um.
24	tsnr_25	INT4				10x minimum signal-to-noise ratio, 25um.
25	tsnr_60	INT4				10x minimum signal-to-noise ratio, 60um.
26	tsnr_100	INT4				10x minimum signal-to-noise ratio, 100um.
27	cc_12	VARCHAR(2)	Y			Point source correlation coefficient, 12um.
28	cc_25	VARCHAR(2)	Y			Point source correlation coefficient, 25um.
29	cc_60	VARCHAR(2)	Y			Point source correlation coefficient, 60um.
30	cc_100	VARCHAR(2)	Y			Point source correlation coefficient, 100um.
31	var	INT2	Y			Percent likelihood of variability.
32	disc	VARCHAR(1)*				Discrepant fluxes flag, 1 per band, hex encode.
33	confuse	VARCHAR(1)*				Confusion flags, 1 per band, hex encoded.
34	pnearh	INT2				Number of nearby hours-confirmed point sources.
35	pnearw	INT2				Number of nearby weeks-confirmed point sources.
36	ses1_12	INT2				Nearby seconds-confirmed small ext. src., 12um.
37	ses1_25	INT2				Nearby seconds-confirmed small ext. src., 25um.
38	ses1_60	INT2				Nearby seconds-confirmed small ext. src., 60um.
39	ses1_100	INT2				Nearby seconds-confirmed small ext. src., 100u.
40	ses2_12	INT2				Nearby weeks-confirmed small ext. src., 12um.
41	ses2_25	INT2				Nearby weeks-confirmed small ext. src., 25um.
42	ses2_60	INT2				Nearby weeks-confirmed small ext. src., 60um.
43	ses2_100	INT2				Nearby weeks-confirmed small ext. src., 100um.
44	hsdflag	VARCHAR(1)*				High source density bin flag, hex encoded.
45	cirr1	INT2				Number of nearby 100 micron only WSDB sources.
46	cirr2	INT2				100 micron sky brightness ratio to flux den.
47	cirr3	INT2			MJy/sr	Total 100 micron sky surface brightness.
48	nid	INT2				Number of positional associations.
49	idtype	INT2				Type of object.
50	mhcon	INT2	Y			Possible number of HCONs.
51	fcor_12	INT2	Y			Flux correction factor applied (times 1000).
52	fcor_25	INT2	Y			Flux correction factor applied (times 1000).
53	fcor_60	INT2	Y			Flux correction factor applied (times 1000).
54	fcor_100	INT2	Y			Flux correction factor applied (times 1000).
55	rat_12_25	FLOAT8	Y			fnu_12 / fnu_25.
56	err_12_25	FLOAT8	Y			% uncertainty in rat_12_25, -1=upperlim, -2=lowerlim.
57	rat_25_60	FLOAT8	Y			fnu_25 / fnu_60.
58	err_25_60	FLOAT8	Y			% uncertainty in rat_25_60, -1=upperlim, -2=lowerlim.
59	rat_60_100	FLOAT8	Y			fnu_60 / fnu_100.
60	err_60_100	FLOAT8	Y			% uncertainty in rat_60_100, -1=upperlim, -2=lowerlim.
61	cx	FLOAT8		C1		Unit vector for (ra,dec).
62	cy	FLOAT8		C1		Unit vector for (ra,dec).
63	cz	FLOAT8		C1		Unit vector for (ra,dec).