Display data from paper

Reference: [SC2005]

Download as: Table (CSV)
View as list of objects

Detection table from SC2005

Hide / Show individual components

ID	Obs. RA	Obs. Dec	l	b	Group id	Source name	Other name	Frequency	V_peak	F_peak	List	Detection	Class	Dist. (parallax)	Ref.
	(J2000)	(J2000)	(deg.)	(deg.)				(MHz)	(km/s)	(Jy)		Yes/No		(kpc)
1	02 25 40.8	+62 05 54.4	133.7150	1.2160	G133.715+1.215	W3-IRS5	IRAS02219+6152	4765	-39.0	0.609	QIA14	+H₂O -CH₃OH I +CH₃OH II +OH	SFR		SC2005
2	02 27 3.7	+61 52 24.6	133.9471	1.0641	G133.949+1.064	W3(OH)	IRAS02232+6138	4765	-45.0	72.218	QIA14	+H₂O +CH₃OH I +CH₃OH II +OH	SFR		SC2005
3	06 07 47.8	-06 22 56.6	213.7049	-12.5970	G213.705-12.597	MonR2	S252-A3	4765	10.6	7.722	QIA14	+H₂O +CH₃OH I +CH₃OH II +OH	SFR_MIXED		SC2005
4	19 10 10.9	+09 05 17.6	43.1481	0.0131	G43.167+0.011	W49SW		4765	8.6	0.637	QIA14	+H₂O +CH₃OH I +CH₃OH II +OH	SFR_MIXED		SC2005
5	19 10 13.5	+09 06 13.9	43.1669	0.0109	G43.167+0.011	W49N	IRAS19078+0901	4765	2.3	0.354	QIA14	+H₂O +CH₃OH I +CH₃OH II +OH	SFR_MIXED		SC2005
6	19 23 43.9	+14 30 34.1	49.4897	-0.3876	G49.488-0.387	W51		4765	57.5	0.151	QIA14	+H₂O +CH₃OH I +CH₃OH II +OH -SiO	SFR		SC2005
7	20 01 45.7	+33 32 45	70.2932	1.6004	G70.293+1.600	IRAS19598+3324	K3-50	4765	-20.3	1.535	QIA14	+H₂O +CH₃OH I -CH₃OH II +OH -SiO	SFR		SC2005
8	20 39 0.4	+42 24 37.2	81.7444	0.5909	G81.767+0.596	DR21(OH)N		4765	5.0	2.083	QIA14	+H₂O +CH₃OH I +CH₃OH II +OH	SFR		SC2005
9	21 43 1.4	+54 56 17.7	98.0358	1.4460	G98.035+1.446	IRAS21413+5442		4765	-62.1	0.480	QIA14	+H₂O +CH₃OH I +CH₃OH II +OH	SFR		SC2005
10	23 13 45.4	+61 28 9.7	111.5420	0.7767	G111.542+0.769	NGC7538-IRS1		4765	-59.0	0.492	QIA14	+H₂O +CH₃OH I +CH₃OH II +OH	SFR		SC2005

DSS colored	2MASS colored	WISE colored
SDSS color	IRAC color I1,I2,I4	GLIMPSE 360
PACS color (70-160 um)	SPIRE color (250-500 um)	NVSS (1.4GHz)
ATLASGAL 870 um	ATLASGAL 870 um + Planck	Bolocam 1.1 mm
UKIDSS K Download UKIDSS K FITS	2MASS K Download 2MASS K FITS

select MAX(oh_data_all.ra_hms) as ra_hms,MAX(oh_data_all.dec_dms) as dec_dms,MAX(oh_data_all.source_name) as source_name,MAX(oh_data_all.ra) as ra,MAX(oh_data_all.dec) as dec,MAX(oh_data_all.l) as l,MAX(oh_data_all.b) as b,MAX(oh_data_all.grp) as grp,MAX(oh_data_all.other_name) as other_name,MAX(oh_data_all.other_desc) as other_desc,BOOL_OR(thermal) as thermal,MAX(oh_data_all.freq) as freq,MAX(oh_data_all.vrange) as vrange,MAX(oh_data_all.vpeak) as vpeak,MAX(oh_data_all.peak) as peak,MAX(oh_data_all.fwhm) as fwhm,MAX(oh_data_all.int) as int,MAX(oh_data_all.rms) as rms,MAX(oh_data_all.units) as units,MAX(oh_data_all.units_rms) as units_rms,MAX(oh_data_all.date_txt) as date_txt,MAX(oh_data_all.telescope_ref) as telescope_ref,MAX(oh_data_all.telescope_conf) as telescope_conf,MAX(oh_data_all.v_step) as v_step,MAX(oh_data_all.beam) as beam,MAX(oh_data_all.beam_maj) as beam_maj,MAX(oh_data_all.beam_min) as beam_min,MAX(oh_data_all.beam_pa) as beam_pa,MAX(oh_data_all.ref) as ref,MAX(oh_data_all.list_ref) as list_ref,MAX(oh_data_all.ascii) as ascii,MAX(oh_data_all.url) as url,MAX(oh_data_all.image) as image,MAX(oh_data_all.image2) as image2,MAX(oh_data_all.image3) as image3,MAX(oh_data_all.descr) as descr,MAX(oh_data_all.id) as id,BOOL_OR(mjy_flag) as mjy_flag,BOOL_OR(rms_mjy_flag) as rms_mjy_flag,MAX(oh_data_all.dist) as dist,1 as dist_parallax,MAX(oh_data_all.date_txt) as date_txt,MAX(line_det) as line_det,MAX(type) as type,MAX(simbad_types_cat) as simbad_types_cat FROM oh_data_all  LEFT JOIN all_objects_withmet ON oh_data_all.grp=all_objects_withmet.group_name LEFT JOIN object_categories ON all_objects_withmet.group_name = object_categories.group_name_cat AND object_categories.tbl_cat = 'all_objects_withmet' LEFT JOIN transitions ON oh_data_all.line=transitions."Line"  WHERE ref ilike 'SC2005' AND detected=true AND hide=false GROUP BY ref

select oh_data_all.ra_hms,oh_data_all.dec_dms,oh_data_all.source_name,oh_data_all.ra,oh_data_all.dec,oh_data_all.l,oh_data_all.b,oh_data_all.grp,oh_data_all.other_name,oh_data_all.other_desc,oh_data_all.thermal,oh_data_all.freq,oh_data_all.vrange,oh_data_all.vpeak,oh_data_all.peak,oh_data_all.fwhm,oh_data_all.int,oh_data_all.rms,oh_data_all.units,oh_data_all.units_rms,oh_data_all.date_txt,oh_data_all.telescope_ref,oh_data_all.telescope_conf,oh_data_all.v_step,oh_data_all.beam,oh_data_all.beam_maj,oh_data_all.beam_min,oh_data_all.beam_pa,oh_data_all.ref,oh_data_all.list_ref,oh_data_all.ascii,oh_data_all.url,oh_data_all.image,oh_data_all.image2,oh_data_all.image3,oh_data_all.descr,oh_data_all.id,oh_data_all.mjy_flag,oh_data_all.rms_mjy_flag,oh_data_all.dist,oh_data_all.dist_parallax,oh_data_all.date_txt,line_det,type,simbad_types_cat FROM oh_data_all   LEFT JOIN all_objects_withmet ON oh_data_all.grp=all_objects_withmet.group_name LEFT JOIN object_categories ON all_objects_withmet.group_name = object_categories.group_name_cat AND object_categories.tbl_cat = 'all_objects_withmet' LEFT JOIN transitions ON oh_data_all.line=transitions."Line"  WHERE ref ilike 'SC2005' AND detected=true AND hide=false ORDER BY detected DESC,id

Display data from paper

Reference: [SC2005]

View as list of objects

Detection table from SC2005