Display data from paper

Select data type:

PAL97 - Search for H_2_O maser emission from high-latitude IRAS sources.

Short title: Palla et al. (1997)
Authors: Palla, F.Codella, C.Valdettaro, R.Baffa, C.
Journal: Astronomy and Astrophysics, v.327, p.755-757
Bibcode:

Target type: IRAS

Abstract

A high-sensitivity search for water maser emission at 22.2 GHz has been performed on a sample of 91 IRAS point sources at high-latitudes. The aim of the survey is to verify if these clouds are capable of star formation as indicated by the presence of water masers. The sample is based on the recent work of Magnani et al. (1995ApJS...96..159M) who have identified 192 infrared objects from the IRAS Faint Source Survey possibly associated with translucent clouds at galactic latitudes |b|>30�. These IRAS sources have far-infrared colours typical of young stellar objects and pre-main-sequence stars and thus provide a starting list for further studies about their actual nature. H_2_O maser emission is a good diagnostic of the presence of dense gas and of recent star formation. We did not find water maser emission at a level of 0.2-0.5Jy (3sigma) in any of the 91 objects. The negative result indicates that these high-latitude sources do not represent potential sites of star formation, consistent with the fact that most high-latitude molecular clouds do not appear gravitationally bound.

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

Detection table from Palla et al. (1997)

Export table to csv

Hide / Show individual components

Non-detection table from Palla et al. (1997)

Export table to csv

Hide / Show individual components

ID	Obs. RA	Obs. Dec	l	b	Group id	Source name	Other name	Line	Telescope	V_step	RMS	Beam	Detection	Class	Date
	(J2000)	(J2000)	(deg.)	(deg.)				H₂O		(km/s)	(Jy)	(arcsec)	Yes/No
1	00 05 26.2	-08 09 53.8	90.9376	-68.1313	G90.938-68.131	MCBB1	F00028-0826	22 GHz;	EFF	0.33	0.070	40	-H₂O		August and September 1995
2	00 44 42.5	+32 50 28.2	121.2997	-30.0093	G121.300-30.009	MCBB5	F00420+3234	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
3	01 38 42.7	+17 05 35.1	138.8107	-44.3163	G138.811-44.316	MCBB9	F01360+1650	22 GHz;	EFF	0.33	0.060	40	-H₂O	GALAXY	August and September 1995
4	01 41 43.6	+13 40 35.6	141.1428	-47.4092	G141.143-47.409	MCBB10	F01390+1325	22 GHz;	EFF	0.33	0.050	40	-H₂O	GALAXY	August and September 1995
5	02 18 30.2	-06 36 21.1	172.1036	-60.8683	G172.104-60.868	MCBB13	F02160-0650	22 GHz;	EFF	0.33	0.070	40	-H₂O	GALAXY	August and September 1995
6	02 20 57.5	+13 22 04	153.9532	-44.0458	G153.953-44.046	MCBB14	F02182+1308	22 GHz;	EFF	0.33	0.050	40	-H₂O	GALAXY	August and September 1995
7	02 34 28.7	+26 35 4.9	149.8481	-30.8464	G149.848-30.846	MCBB16	F02315+2621	22 GHz;	EFF	0.33	0.050	40	-H₂O	GALAXY	August and September 1995
8	02 41 40.6	-17 39 26.5	198.2826	-62.8910	G198.283-62.891	MCBB17	F02393-1752	22 GHz;	EFF	0.33	0.090	40	-H₂O	GALAXY	August and September 1995
9	02 46 34.5	+02 07 3.7	170.9980	-49.6973	G170.998-49.697	MCBB19	F02439+0154	22 GHz;	EFF	0.33	0.060	40	-H₂O	GALAXY	August and September 1995
10	02 58 20.6	-11 20 46.4	191.2323	-56.2955	G191.232-56.296	MCBB21	F02559-1132	22 GHz;	EFF	0.33	0.090	40	-H₂O	GALAXY	August and September 1995
11	03 01 1.5	+20 42 10.9	159.5342	-32.8023	G159.534-32.802	MBM12-1		22 GHz;	EFF	0.33	0.050	40	-H₂O		August and September 1995
12	03 30 23.6	+15 46 1.6	169.6561	-32.3248	G169.656-32.325	MCBB30	F03275+1535	22 GHz;	EFF	0.33	0.070	40	-H₂O	GALAXY	August and September 1995
13	03 42 39.4	-13 17 22.4	202.5629	-47.7565	G202.563-47.757	MCBB33	F03403-1326	22 GHz;	EFF	0.33	0.110	40	-H₂O	GALAXY	August and September 1995
14	03 51 24.4	-15 24 7.3	206.6928	-46.7108	G206.693-46.711	MCBB35	F03491-1533	22 GHz;	EFF	0.33	0.070	40	-H₂O	GALAXY	August and September 1995
15	03 56 29	-12 55 19.1	204.1929	-44.5635	G204.193-44.564	MCBB36	F03541-1303	22 GHz;	EFF	0.33	0.080	40	-H₂O	GALAXY	August and September 1995
16	04 12 15.2	-06 42 11.2	199.2347	-38.2413	G199.235-38.241	MCBB40	F04098-0649	22 GHz;	EFF	0.33	0.060	40	-H₂O	GALAXY	August and September 1995
17	04 13 44.2	-17 29 34.3	212.2575	-42.5421	G212.258-42.542	MCBB42	F04114-1737	22 GHz;	EFF	0.33	0.090	40	-H₂O	GALAXY	August and September 1995
18	04 27 38.2	-11 43 38.1	207.0814	-37.1762	G207.081-37.176	MCBB49	F04252-1150	22 GHz;	EFF	0.33	0.080	40	-H₂O	GALAXY	August and September 1995
19	04 36 45.7	-13 29 5.1	210.2230	-35.8829	G210.223-35.883	MBM20		22 GHz;	EFF	0.33	0.090	40	-H₂O		August and September 1995
20	04 46 24.4	-06 54 49.6	204.3709	-30.8863	G204.371-30.886	MCBB60	F04439-0700	22 GHz;	EFF	0.33	0.070	40	-H₂O	GALAXY	August and September 1995
21	04 52 53.5	-18 21 11	217.5211	-34.1448	G217.521-34.145	MCBB63	F04506-1826	22 GHz;	EFF	0.33	0.100	40	-H₂O	GALAXY	August and September 1995
22	05 06 54.4	-19 54 22.2	220.6354	-31.5897	G220.635-31.590	MCBB66	F05047-1958	22 GHz;	EFF	0.33	0.110	40	-H₂O	GALAXY	August and September 1995
23	08 08 26	+73 02 35	141.7618	31.4485	G141.762+31.448	MCBB76	F08027+7311	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
24	09 05 30.7	+51 24 44	166.9243	41.5251	G166.924+41.525	MCBB77	F09019+5136	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
25	10 05 28.3	+84 20 30.3	127.3161	31.2981	G127.316+31.298	MCBB78	F09572+8435	22 GHz;	EFF	0.33	0.050	40	-H₂O	GALAXY	August and September 1995
26	10 20 8.5	+01 27 41.8	241.7565	45.5943	G241.757+45.594	MCBB79	F10175+0142	22 GHz;	EFF	0.33	0.070	40	-H₂O	GALAXY	August and September 1995
27	10 31 57.6	-18 46 38.3	262.7390	32.9943	G262.739+32.994	MCBB80	F10295-1831	22 GHz;	EFF	0.33	0.080	40	-H₂O	GALAXY	August and September 1995
28	10 40 43.7	+59 34 8.8	148.4454	50.5877	G148.445+50.588	MCBB81	F10375+5949	22 GHz;	EFF	0.33	0.050	40	-H₂O	GALAXY	August and September 1995
29	11 08 53	+51 02 22.2	155.0418	59.2130	G155.042+59.213	MCBB82	F11060+5118	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
30	11 09 20.8	+71 42 23	133.6306	43.2382	G133.631+43.238	MCBB83	F11060+7158	22 GHz;	EFF	0.33	0.050	40	-H₂O	GALAXY	August and September 1995
31	12 58 36.2	+76 26 42.9	122.3785	40.6753	G122.378+40.675	MCBB85	F12572+7642	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
32	13 58 40.3	-16 08 24.9	325.5502	43.7590	G325.550+43.759	MCBB86	F13559-1553	22 GHz;	EFF	0.33	0.090	40	-H₂O	GALAXY	August and September 1995
33	14 13 8.6	-14 04 6.1	331.1520	44.2805	G331.152+44.280	MCBB87	F14104-1350	22 GHz;	EFF	0.33	0.080	40	-H₂O	GALAXY	August and September 1995
34	14 22 38.3	-06 19 36.7	339.6774	49.9248	G339.677+49.925	MCBB88	F14200-0605	22 GHz;	EFF	0.33	0.060	40	-H₂O	GALAXY	August and September 1995
35	15 12 21	-10 16 38.9	350.1477	39.3444	G350.148+39.344	MCBB89	F15096-1005	22 GHz;	EFF	0.33	0.070	40	-H₂O	GALAXY	August and September 1995
36	15 15 57.9	+04 20 58.3	5.9202	48.7051	G5.920+48.705	MCBB90	F15134+0432	22 GHz;	EFF	0.33	0.070	40	-H₂O	GALAXY	August and September 1995
37	15 16 40.1	-00 02 27.5	1.0649	45.7966	G1.065+45.797	MCBB91	F15141+0008	22 GHz;	EFF	0.33	0.080	40	-H₂O	GALAXY	August and September 1995
38	15 17 7.2	+81 21 4.5	116.7532	33.9516	G116.753+33.952	MCBB92	F15201+8131	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
39	16 13 33.3	+24 23 40	41.3144	44.7144	G41.314+44.714	MCBB93	F16114+2431	22 GHz;	EFF	0.33	0.180	40	-H₂O	GALAXY	August and September 1995
40	16 17 39.7	+65 04 11.6	97.2836	40.2962	G97.284+40.296	MCBB94	F16172+6511	22 GHz;	EFF	0.33	0.030	40	-H₂O	GALAXY	August and September 1995
41	16 43 53	+24 08 58	43.4831	37.9923	G43.483+37.992	MCBB95	F16417+2414	22 GHz;	EFF	0.33	0.100	40	-H₂O	EVOLVED	August and September 1995
42	16 47 51	+77 34 33.5	110.2255	32.9310	G110.226+32.931	MCBB96	F16501+7739	22 GHz;	EFF	0.33	0.120	40	-H₂O	GALAXY	August and September 1995
43	16 53 37.7	+30 26 6.8	51.8645	37.4659	G51.864+37.466	MCBB97	F16516+3030	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
44	16 58 27.4	+71 11 43.5	102.7594	34.5699	G102.759+34.570	MCBB98	F16590+7116	22 GHz;	EFF	0.33	0.110	40	-H₂O	GALAXY	August and September 1995
45	17 04 50.7	+34 49 0.4	57.8084	36.0191	G57.808+36.019	MCBB99	F17030+3453	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
46	17 33 18	+76 37 23.2	108.2226	30.8279	G108.223+30.828	MCBB100	F17353+7639	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
47	17 47 14.9	+64 15 52.8	93.7423	31.1702	G93.742+31.170	MCBB101	F17469+6416	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
48	17 49 35.8	+56 36 59.7	84.8282	30.7499	G84.828+30.750	MCBB102	F17487+5637	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
49	17 50 0.3	+53 59 21.1	81.7889	30.4930	G81.789+30.493	MCBB103	F17489+5400	22 GHz;	EFF	0.33	0.060	40	-H₂O	EVOLVED	August and September 1995
50	17 51 58.6	+64 21 36.5	93.8423	30.6561	G93.842+30.656	MCBB104	F17517+6422	22 GHz;	EFF	0.33	0.040	40	-H₂O	GALAXY	August and September 1995
51	17 53 26	+68 48 01	98.9895	30.3787	G98.990+30.379	MCBB105	F17537+6848	22 GHz;	EFF	0.33	0.070	40	-H₂O	GALAXY	August and September 1995
52	17 55 5.4	+65 19 54.3	94.9664	30.3166	G94.966+30.317	MCBB106	F17549+6520	22 GHz;	EFF	0.33	0.030	40	-H₂O	GALAXY	August and September 1995
53	17 55 38.4	+62 09 39	91.2955	30.2252	G91.296+30.225	MCBB107	F17551+6209	22 GHz;	EFF	0.33	0.050	40	-H₂O	GALAXY	August and September 1995
54	21 00 8.4	-13 20 52.1	35.0734	-34.4996	G35.073-34.500	MCBB113	F20573-1332	22 GHz;	EFF	0.33	0.080	40	-H₂O	GALAXY	August and September 1995
55	23 22 23.8	-02 13 46.1	78.5705	-57.2221	G78.583-57.224	MCBB123	F23198-0230	22 GHz;	EFF	0.33	0.060	40	-H₂O -OH	EVOLVED	August and September 1995
56	23 06 16.4	+15 35 11.5	88.9482	-40.2452	G88.948-40.245	MBM55		22 GHz;	EFF	0.33	0.040	40	-H₂O		August and September 1995
57	00 19 37	-04 40 6.9	102.8671	-66.2928	G102.867-66.293	MCBBb1	F00170-0456	22 GHz;	EFF	0.33	0.150	40	-H₂O	GALAXY	August and September 1995
58	00 54 36.6	-08 34 15.7	125.3946	-71.4276	G125.395-71.428	MCBBb2	F00520-0850	22 GHz;	EFF	0.33	0.150	40	-H₂O	GALAXY	August and September 1995
59	01 38 4.8	-11 31 50.8	160.2637	-70.9401	G160.264-70.940	MCBBb5	F01356-1147	22 GHz;	EFF	0.33	0.170	40	-H₂O	EVOLVED	August and September 1995
60	02 15 38.4	-15 10 14.2	185.7776	-67.0691	G185.778-67.069	MCBBb7	F02132-1524	22 GHz;	EFF	0.33	0.220	40	-H₂O	GALAXY	August and September 1995
61	02 56 39.2	+20 05 42.2	158.9292	-33.8810	G158.929-33.881	MCBBb9	F02538+1953	22 GHz;	EFF	0.33	0.120	40	-H₂O	SFR_MIXED	August and September 1995
62	02 58 11.8	+20 30 4.5	159.0173	-33.3420	G159.017-33.342	MCBBb10	F02553+2018	22 GHz;	EFF	0.33	0.150	40	-H₂O	EVOLVED	August and September 1995
63	04 34 49.8	-14 13 10.3	210.8240	-36.6073	G210.824-36.607	MCBBb19	F04325-1419	22 GHz;	EFF	0.33	0.250	40	-H₂O -CH₃OH I -CH₃OH II	SFR	August and September 1995
64	04 41 11.8	-12 03 23.3	209.1769	-34.3093	G209.177-34.309	MCBBb22	F04388-1209	22 GHz;	EFF	0.33	0.210	40	-H₂O	GALAXY	August and September 1995
65	08 24 42.8	+29 59 20.9	192.9942	32.2119	G192.994+32.212	MCBBb29	F08216+3009	22 GHz;	EFF	0.33	0.120	40	-H₂O	GALAXY	August and September 1995
66	08 42 15.1	+40 25 32.9	181.2632	37.6368	G181.263+37.637	MCBBb30	F08389+4036	22 GHz;	EFF	0.33	0.120	40	-H₂O	GALAXY	August and September 1995
67	08 52 46.4	+42 50 3.4	178.3576	39.7638	G178.358+39.764	MCBBb31	F08494+4301	22 GHz;	EFF	0.33	0.160	40	-H₂O	GALAXY	August and September 1995
68	10 50 39.3	+80 11 40.6	128.9692	35.4733	G128.969+35.473	MCBBb32	F10460+8027	22 GHz;	EFF	0.33	0.090	40	-H₂O	GALAXY	August and September 1995
69	11 36 33.9	+73 27 59	130.0600	42.6100	G130.060+42.610	MCBBb33	F11335+7344	22 GHz;	EFF	0.33	0.160	40	-H₂O	GALAXY	August and September 1995
70	11 56 18.1	+57 17 59.3	137.1054	58.2855	G137.105+58.285	MCBBb34	F11537+5734	22 GHz;	EFF	0.33	0.150	40	-H₂O	GALAXY	August and September 1995
71	15 23 47.5	+28 55 7.2	45.0803	56.4732	G45.080+56.473	MCBBb37	F15217+2905	22 GHz;	EFF	0.33	0.100	40	-H₂O	GALAXY	August and September 1995
72	15 28 38	+23 30 1.5	36.0157	54.4315	G36.016+54.432	MCBBb38	F15264+2340	22 GHz;	EFF	0.33	0.110	40	-H₂O	GALAXY	August and September 1995
73	15 46 53.5	+54 57 09	86.5363	47.8841	G86.536+47.884	MCBBb39	F15456+5506	22 GHz;	EFF	0.33	0.120	40	-H₂O	GALAXY	August and September 1995
74	15 56 40	+15 48 58.1	27.9619	45.7088	G27.962+45.709	MCBBb40	F15543+1557	22 GHz;	EFF	0.33	0.110	40	-H₂O	GALAXY	August and September 1995
75	16 09 48.6	+04 34 50.7	16.5208	37.6963	G16.521+37.696	MCBBb41	F16073+0442	22 GHz;	EFF	0.33	0.120	40	-H₂O	GALAXY	August and September 1995
76	16 11 25.1	+58 40 57.1	89.7113	43.3875	G89.711+43.387	MCBBb42	F16104+5858	22 GHz;	EFF	0.33	0.160	40	-H₂O	GALAXY	August and September 1995
77	16 17 9.6	+22 26 28.1	39.0123	43.3868	G39.012+43.387	MCBBb43	F16150+2233	22 GHz;	EFF	0.33	0.160	40	-H₂O	GALAXY	August and September 1995
78	16 26 19.5	+24 51 1.6	42.9476	42.0270	G42.948+42.027	MCBBb44	F16242+2457	22 GHz;	EFF	0.33	0.150	40	-H₂O	GALAXY	August and September 1995
79	16 36 14.5	+29 16 14.9	49.3707	40.9060	G49.371+40.906	MCBBb45	F16342+2922	22 GHz;	EFF	0.33	0.150	40	-H₂O	GALAXY	August and September 1995
80	16 44 36.3	+42 43 36	67.3251	40.7691	G67.326+40.769	MCBBb46	F16430+4249	22 GHz;	EFF	0.33	0.150	40	-H₂O -OH	EVOLVED	August and September 1995
81	16 53 16.8	+23 49 38	43.8756	35.8450	G43.876+35.845	MCBBb47	F16511+2354	22 GHz;	EFF	0.33	0.160	40	-H₂O	GALAXY	August and September 1995
82	16 59 32.3	+42 46 8.5	67.5364	38.0322	G67.536+38.032	MCBBb48	F16579+4250	22 GHz;	EFF	0.33	0.160	40	-H₂O	GALAXY	August and September 1995
83	17 05 49.3	+29 13 26.2	51.1681	34.6124	G51.168+34.612	MCBBb49	F17038+2917	22 GHz;	EFF	0.33	0.160	40	-H₂O	EVOLVED	August and September 1995
84	17 13 51.6	+57 29 54.9	85.9325	35.5967	G85.933+35.597	MCBBb50	F17130+5733	22 GHz;	EFF	0.33	0.150	40	-H₂O	GALAXY	August and September 1995
85	17 34 3.3	+40 37 57.4	65.9276	31.3780	G65.928+31.378	MCBBb51	F17324+4039	22 GHz;	EFF	0.33	0.170	40	-H₂O	GALAXY	August and September 1995
86	17 45 30.8	+49 18 02	76.2866	30.6870	G76.287+30.687	MCBBb52	F17442+4919	22 GHz;	EFF	0.33	0.150	40	-H₂O	GALAXY	August and September 1995
87	17 48 42.5	+53 02 42.4	80.6766	30.5978	G80.677+30.598	MCBBb53	F17476+5303	22 GHz;	EFF	0.33	0.160	40	-H₂O	GALAXY	August and September 1995
88	21 25 1.3	-04 37 19.8	48.0172	-35.9947	G48.017-35.995	MCBBb57	F21224-0450	22 GHz;	EFF	0.33	0.200	40	-H₂O	GALAXY	August and September 1995
89	21 27 46.6	-00 29 4.3	52.7648	-34.3985	G52.765-34.399	MCBBb58	F21252-0042	22 GHz;	EFF	0.33	0.180	40	-H₂O	GALAXY	August and September 1995
90	21 28 12.1	+02 32 27.9	55.8473	-32.7941	G55.847-32.794	MCBBb59	F21256+0219	22 GHz;	EFF	0.33	0.180	40	-H₂O	GALAXY	August and September 1995
91	22 41 41.7	-16 31 57.5	45.6112	-58.1948	G45.611-58.195	MCBBb62	F22390-1647	22 GHz;	EFF	0.33	0.260	40	-H₂O	GALAXY	August and September 1995

X

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(h2o_data_all.ra_hms) as ra_hms,MAX(h2o_data_all.dec_dms) as dec_dms,MAX(h2o_data_all.source_name) as source_name,MAX(h2o_data_all.ra) as ra,MAX(h2o_data_all.dec) as dec,MAX(h2o_data_all.l) as l,MAX(h2o_data_all.b) as b,MAX(h2o_data_all.grp) as grp,MAX(h2o_data_all.other_name) as other_name,MAX(h2o_data_all.other_desc) as other_desc,BOOL_OR(thermal) as thermal,MAX(h2o_data_all.line) as line,MAX(h2o_data_all.vrange) as vrange,MAX(h2o_data_all.vpeak) as vpeak,MAX(h2o_data_all.peak) as peak,MAX(h2o_data_all.fwhm) as fwhm,MAX(h2o_data_all.int) as int,MAX(h2o_data_all.rms) as rms,MAX(h2o_data_all.units) as units,MAX(h2o_data_all.units_rms) as units_rms,MAX(h2o_data_all.date_txt) as date_txt,MAX(h2o_data_all.telescope_ref) as telescope_ref,MAX(h2o_data_all.telescope_conf) as telescope_conf,MAX(h2o_data_all.v_step) as v_step,MAX(h2o_data_all.beam) as beam,MAX(h2o_data_all.beam_maj) as beam_maj,MAX(h2o_data_all.beam_min) as beam_min,MAX(h2o_data_all.beam_pa) as beam_pa,MAX(h2o_data_all.ref) as ref,MAX(h2o_data_all.list_ref) as list_ref,MAX(h2o_data_all.ascii) as ascii,MAX(h2o_data_all.url) as url,MAX(h2o_data_all.image) as image,MAX(h2o_data_all.image2) as image2,MAX(h2o_data_all.image3) as image3,MAX(h2o_data_all.descr) as descr,MAX(h2o_data_all.id) as id,BOOL_OR(mjy_flag) as mjy_flag,BOOL_OR(rms_mjy_flag) as rms_mjy_flag,MAX(h2o_data_all.dist) as dist,1 as dist_parallax,MAX(h2o_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 h2o_data_all  LEFT JOIN all_objects_withmet ON h2o_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 h2o_data_all.line=transitions."Line"  WHERE ref ilike 'PAL97' AND detected=true AND hide=false GROUP BY ref

select h2o_data_all.ra_hms,h2o_data_all.dec_dms,h2o_data_all.source_name,h2o_data_all.ra,h2o_data_all.dec,h2o_data_all.l,h2o_data_all.b,h2o_data_all.grp,h2o_data_all.other_name,h2o_data_all.other_desc,h2o_data_all.thermal,h2o_data_all.line,h2o_data_all.vrange,h2o_data_all.vpeak,h2o_data_all.peak,h2o_data_all.fwhm,h2o_data_all.int,h2o_data_all.rms,h2o_data_all.units,h2o_data_all.units_rms,h2o_data_all.date_txt,h2o_data_all.telescope_ref,h2o_data_all.telescope_conf,h2o_data_all.v_step,h2o_data_all.beam,h2o_data_all.beam_maj,h2o_data_all.beam_min,h2o_data_all.beam_pa,h2o_data_all.ref,h2o_data_all.list_ref,h2o_data_all.ascii,h2o_data_all.url,h2o_data_all.image,h2o_data_all.image2,h2o_data_all.image3,h2o_data_all.descr,h2o_data_all.id,h2o_data_all.mjy_flag,h2o_data_all.rms_mjy_flag,h2o_data_all.dist,h2o_data_all.dist_parallax,h2o_data_all.date_txt,line_det,type,simbad_types_cat FROM h2o_data_all   LEFT JOIN all_objects_withmet ON h2o_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 h2o_data_all.line=transitions."Line"  WHERE ref ilike 'PAL97' AND detected=true AND hide=false ORDER BY detected DESC,id