Search
References
Objects
User-defined list
Download data
Statistics
Papers & Acknowledgement
Citation tool
☰
Display data from paper
Select data type:
OH
SZY04 - Polarimetric observations of OH masers in proto-planetary nebulae
Short title
: Szymczak & Gérard (2004)
Authors
: Szymczak, M. Gérard, E.
Journal
: Astronomy and Astrophysics, v.423, p.209-219 (2004)
Bibcode
:
2004A&A...423..209S
Abstract
The 1612 and 1667 MHz OH maser lines have been measured in all four Stokes parameters in 47 proto-planetary nebula (PPN) candidates. Out of 42 objects detected, 40 and 34 are 1612 and 1667 MHz emitters, respectively. The spectral extent of the 1667 MHz line overshoots that of the 1612 MHz line in about 80% of the targets. 52% and 26% of the 1612 and 1667 MHz sources, respectively, show linear polarization in at least some features. Circular polarization is more frequent, occurring in 78% and 32% of sources of the respective OH lines. The percentage polarization is usually small (<15%) reaching up to 50-80% in a few sources. Features of linearly polarized emission are usually weak (0.5-4 Jy) and narrow (0.3-0.5 km s
-1
). The strength of the magnetic field inferred from likely Zeeman pairs in two sources of a few mG is consistent with values reported elsewhere for those classes of objects. An upper limit of the electron density in the envelope of OH17.7-2.0 derived from the difference in the position angle of polarization vectors for the two OH lines is about 1 cm
-3
. Distinct profiles of polarization position angle at 1612 and 1667 MHz are seen in about one third of the sources and strongly suggest that the envelopes are permeated by structured magnetic fields. The geometry of the magnetic field is implicated as an important cause of the depolarization found in some PPN candidates. For the subset of targets which show axisymmetric shells in the optical or radio images we found a dominance of magnetic field components which are orthogonal to the long axis of the nebulae. This finding supports the hypothesis that such bipolar lobes are shaped by the magnetic field. Figures in Appendix are only available in electronic form at
http://www.edpsciences.org
eprintid: arXiv:astro-ph/0405316
Comments:
This work gives no velocities and no flux densities. vrad and vexp for IRAS 17253-2831 was taken from Zijlstra et al. (2001)
Download as
:
Table (CSV)
View as list of objects
Detection table from Szymczak & Gérard (2004)
Export table to csv
Hide
/
Show
individual components
Non-detection table from Szymczak & Gérard (2004)
Export table to csv
Hide
/
Show
individual components
ID
Obs. RA
Obs. Dec
l
b
Group id
Source name
Line
List
Detection
Class
Ref.
(J2000)
(J2000)
(deg.)
(deg.)
OH
Yes
/
No
1
06 55 32
-02 17 30
215.4382
-0.1342
G215.438-0.134
IRAS 06530-0213
1.612 GHz
;
ENG15
-H
2
O
-OH
EVOLVED
SZY04
2
06 55 32
-02 17 30
215.4382
-0.1342
G215.438-0.134
IRAS 06530-0213
1.667 GHz
;
ENG15
-H
2
O
-OH
EVOLVED
SZY04
3
07 35 41.1
+00 14 59
217.8013
9.9475
G217.801+9.947
IRAS 07331+0021
1.612 GHz
;
ENG15
+H
2
O
+OH
EVOLVED
SZY04
4
07 35 41.1
+00 14 59
217.8013
9.9475
G217.801+9.947
IRAS 07331+0021
1.667 GHz
;
ENG15
+H
2
O
+OH
EVOLVED
SZY04
5
07 42 17.1
-14 42 50
231.8355
4.2208
G231.835+4.220
IRAS 07399-1435
1.612 GHz
;
ENG15
+H
2
O
-CH
3
OH II
+OH
+SiO
EVOLVED
SZY04
6
07 42 17.1
-14 42 50
231.8355
4.2208
G231.835+4.220
IRAS 07399-1435
1.667 GHz
;
ENG15
+H
2
O
-CH
3
OH II
+OH
+SiO
EVOLVED
SZY04
7
08 02 40.5
-24 04 43
242.3641
3.5822
G242.364+3.582
IRAS 08005-2356
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH II
+OH
-SiO
EVOLVED
SZY04
8
08 02 40.5
-24 04 43
242.3641
3.5822
G242.364+3.582
IRAS 08005-2356
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH II
+OH
-SiO
EVOLVED
SZY04
9
16 37 40
-38 20 17
344.0737
5.8466
G344.074+5.847
IRAS 16342-3814
1.612 GHz
;
ENG15
+H
2
O
+OH
-SiO
EVOLVED
SZY04
10
16 37 40
-38 20 17
344.0737
5.8466
G344.074+5.847
IRAS 16342-3814
1.667 GHz
;
ENG15
+H
2
O
+OH
-SiO
EVOLVED
SZY04
11
16 59 8.1
-30 01 41
353.3668
7.7273
G353.367+7.727
IRAS 16559-2957
1.612 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
12
16 59 8.1
-30 01 41
353.3668
7.7273
G353.367+7.727
IRAS 16559-2957
1.667 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
13
17 11 23.1
-38 48 18
347.8596
0.4298
G347.860+0.430
IRAS 17079-3844
1.612 GHz
;
ENG15
+OH
EVOLVED
SZY04
14
17 11 23.1
-38 48 18
347.8596
0.4298
G347.860+0.430
IRAS 17079-3844
1.667 GHz
;
ENG15
+OH
EVOLVED
SZY04
15
17 13 44.8
-37 06 13
349.5093
1.0546
G349.509+1.055
IRAS 17103-3702
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH II
+OH
EVOLVED
SZY04
16
17 13 44.8
-37 06 13
349.5093
1.0546
G349.509+1.055
IRAS 17103-3702
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH II
+OH
EVOLVED
SZY04
17
17 18 29
-37 58 01
349.3517
-0.2112
G349.352-0.211
IRAS 17150-3754
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH II
+OH
EVOLVED
SZY04
18
17 18 29
-37 58 01
349.3517
-0.2112
G349.352-0.211
IRAS 17150-3754
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH II
+OH
EVOLVED
SZY04
19
17 18 20
-32 27 23
353.8437
2.9836
G353.844+2.984
IRAS 17150-3224
1.612 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
20
17 18 20
-32 27 23
353.8437
2.9836
G353.844+2.984
IRAS 17150-3224
1.667 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
21
17 26 28.6
-26 04 58
0.1239
5.1123
G0.124+5.112
IRAS 17233-2602
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH I
-CH
3
OH II
+OH
EVOLVED
SZY04
22
17 26 28.6
-26 04 58
0.1239
5.1123
G0.124+5.112
IRAS 17233-2602
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH I
-CH
3
OH II
+OH
EVOLVED
SZY04
23
17 28 33.2
-28 33 28
358.3114
3.3597
G358.311+3.361
IRAS 17253-2831
1.612 GHz
;
ENG15
+OH
EVOLVED
SZY04
24
17 28 33.2
-28 33 28
358.3114
3.3597
G358.311+3.361
IRAS 17253-2831
1.667 GHz
;
ENG15
+OH
EVOLVED
SZY04
25
17 38 1.2
-31 40 58
356.8016
-0.0575
G356.802-0.055
IRAS 17347-3139
1.612 GHz
;
ENG15
+H
2
O
+OH
SFR_MIXED
SZY04
26
17 38 1.2
-31 40 58
356.8016
-0.0575
G356.802-0.055
IRAS 17347-3139
1.667 GHz
;
ENG15
+H
2
O
+OH
SFR_MIXED
SZY04
27
17 40 20.6
-27 49 11
0.3396
1.5742
G0.344+1.566
IRAS 17371-2747
1.612 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
28
17 40 20.6
-27 49 11
0.3396
1.5742
G0.344+1.566
IRAS 17371-2747
1.667 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
29
17 40 40.7
-28 01 06
0.2104
1.4062
G0.210+1.406
IRAS 17375-2759
1.612 GHz
;
ENG15
+OH
EVOLVED
SZY04
30
17 40 40.7
-28 01 06
0.2104
1.4062
G0.210+1.406
IRAS 17375-2759
1.667 GHz
;
ENG15
+OH
EVOLVED
SZY04
31
17 40 44.3
-30 02 07
358.5066
0.3263
G358.507+0.326
IRAS 17375-3000
1.612 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
32
17 40 44.3
-30 02 07
358.5066
0.3263
G358.507+0.326
IRAS 17375-3000
1.667 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
33
17 41 52
-33 33 40
355.6405
-1.7416
G355.640-1.742
IRAS 17385-3332
1.612 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
34
17 41 52
-33 33 40
355.6405
-1.7416
G355.640-1.742
IRAS 17385-3332
1.667 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
35
17 42 32.1
-27 28 28
0.8894
1.3445
G0.892+1.342
IRAS 17393-2727
1.612 GHz
;
ENG15
+H
2
O
+OH
SZY04
36
17 42 32.1
-27 28 28
0.8894
1.3445
G0.892+1.342
IRAS 17393-2727
1.667 GHz
;
ENG15
+H
2
O
+OH
SZY04
37
17 42 34.7
-30 05 43
358.6660
-0.0435
G358.667-0.044
IRAS 17393-3004
1.612 GHz
;
ENG15
+H
2
O
+OH
EVOLVED
SZY04
38
17 42 34.7
-30 05 43
358.6660
-0.0435
G358.667-0.044
IRAS 17393-3004
1.667 GHz
;
ENG15
+H
2
O
+OH
EVOLVED
SZY04
39
17 43 37.1
-27 14 46
1.2101
1.2598
G1.212+1.257
IRAS 17404-2713
1.612 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
40
17 43 37.1
-27 14 46
1.2101
1.2598
G1.212+1.257
IRAS 17404-2713
1.667 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
41
17 45 14.1
-17 56 47
9.3641
5.7789
G9.364+5.779
IRAS 17423-1755
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH I
+OH
EVOLVED
SZY04
42
17 45 14.1
-17 56 47
9.3641
5.7789
G9.364+5.779
IRAS 17423-1755
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH I
+OH
EVOLVED
SZY04
43
17 46 15.8
-17 51 49
9.5617
5.6115
G9.562+5.612
IRAS 17433-1750
1.612 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
44
17 46 15.8
-17 51 49
9.5617
5.6115
G9.562+5.612
IRAS 17433-1750
1.667 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
45
17 44 54.8
+50 02 38
77.1324
30.8713
G77.132+30.871
IRAS 17436+5003
1.612 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
46
17 44 54.8
+50 02 38
77.1324
30.8713
G77.132+30.871
IRAS 17436+5003
1.667 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
47
17 47 35.2
-29 50 56
359.4424
-0.8400
G359.442-0.840
IRAS 17443-2949
1.612 GHz
;
ENG15
+H
2
O
+OH
SFR_MIXED
SZY04
48
17 47 35.2
-29 50 56
359.4424
-0.8400
G359.442-0.840
IRAS 17443-2949
1.667 GHz
;
ENG15
+H
2
O
+OH
SFR_MIXED
SZY04
49
17 54 43.2
-25 26 30
4.0375
0.0563
G4.038+0.056
IRAS 17516-2525
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH I
+OH
EVOLVED
SZY04
50
17 54 43.2
-25 26 30
4.0375
0.0563
G4.038+0.056
IRAS 17516-2525
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH I
+OH
EVOLVED
SZY04
51
18 01 13.5
-31 21 57
359.6133
-4.1388
G359.613-4.139
IRAS 17579-3121
1.612 GHz
;
ENG15
+OH
EVOLVED
SZY04
52
18 01 13.5
-31 21 57
359.6133
-4.1388
G359.613-4.139
IRAS 17579-3121
1.667 GHz
;
ENG15
+OH
EVOLVED
SZY04
53
18 04 45.7
-27 43 11
3.1759
-3.0238
G3.176-3.024
IRAS 18016-2743
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH I
+OH
-SiO
EVOLVED
SZY04
54
18 04 45.7
-27 43 11
3.1759
-3.0238
G3.176-3.024
IRAS 18016-2743
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH I
+OH
-SiO
EVOLVED
SZY04
55
18 06 03
-39 05 57
353.2673
-8.7244
G353.267-8.724
IRAS 18025-3906
1.612 GHz
;
ENG15
+OH
EVOLVED
SZY04
56
18 06 03
-39 05 57
353.2673
-8.7244
G353.267-8.724
IRAS 18025-3906
1.667 GHz
;
ENG15
+OH
EVOLVED
SZY04
57
18 08 16.3
-20 16 12
10.0756
-0.0948
G10.076-0.095
IRAS 18052-2016
1.612 GHz
;
ENG15
+H
2
O
+OH
EVOLVED
SZY04
58
18 08 16.3
-20 16 12
10.0756
-0.0948
G10.076-0.095
IRAS 18052-2016
1.667 GHz
;
ENG15
+H
2
O
+OH
EVOLVED
SZY04
59
18 10 5.8
-17 26 35
12.7581
0.8964
G12.758+0.896
IRAS 18071-1727
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH I
+OH
-SiO
EVOLVED
SZY04
60
18 10 5.8
-17 26 35
12.7581
0.8964
G12.758+0.896
IRAS 18071-1727
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH I
+OH
-SiO
EVOLVED
SZY04
61
18 12 3.3
-18 14 25
12.2841
0.1039
G12.284+0.104
IRAS 18091-1815
1.612 GHz
;
ENG15
+OH
EVOLVED
SZY04
62
18 12 3.3
-18 14 25
12.2841
0.1039
G12.284+0.104
IRAS 18091-1815
1.667 GHz
;
ENG15
+OH
EVOLVED
SZY04
63
18 11 30.5
+27 05 14
53.8347
20.1808
G53.835+20.180
IRAS 18095+2704
1.612 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
64
18 11 30.5
+27 05 14
53.8347
20.1808
G53.835+20.180
IRAS 18095+2704
1.667 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
65
18 13 32.1
-19 35 03
11.2729
-0.8480
G11.273-0.848
IRAS 18105-1935
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH I
+OH
EVOLVED
SZY04
66
18 13 32.1
-19 35 03
11.2729
-0.8480
G11.273-0.848
IRAS 18105-1935
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH I
+OH
EVOLVED
SZY04
67
18 16 26
-14 55 13
15.7017
0.7699
G15.701+0.770
IRAS 18135-1456
1.612 GHz
;
ENG15
+H
2
O
-CH
3
OH I
-CH
3
OH II
+OH
+SiO
EVOLVED
SZY04
68
18 16 26
-14 55 13
15.7017
0.7699
G15.701+0.770
IRAS 18135-1456
1.667 GHz
;
ENG15
+H
2
O
-CH
3
OH I
-CH
3
OH II
+OH
+SiO
EVOLVED
SZY04
69
18 29 29.2
-12 37 53
19.2102
-0.9546
G19.209-0.953
IRAS 18266-1239
1.612 GHz
;
ENG15
+H
2
O
+OH
+SiO
SFR_MIXED
SZY04
70
18 29 29.2
-12 37 53
19.2102
-0.9546
G19.209-0.953
IRAS 18266-1239
1.667 GHz
;
ENG15
+H
2
O
+OH
+SiO
SFR_MIXED
SZY04
71
18 30 30.8
-14 28 58
17.6841
-2.0328
G17.684-2.032
IRAS 18276-1431
1.612 GHz
;
ENG15
+H
2
O
+OH
+SiO
EVOLVED
SZY04
72
18 30 30.8
-14 28 58
17.6841
-2.0328
G17.684-2.032
IRAS 18276-1431
1.667 GHz
;
ENG15
+H
2
O
+OH
+SiO
EVOLVED
SZY04
73
18 47 40.7
-01 45 15
30.9422
0.0363
G30.944+0.035
IRAS 18450-0148
1.612 GHz
;
ENG15
+H
2
O
-CH
3
OH II
+OH
+SiO
SFR_MIXED
SZY04
74
18 47 40.7
-01 45 15
30.9422
0.0363
G30.944+0.035
IRAS 18450-0148
1.667 GHz
;
ENG15
+H
2
O
-CH
3
OH II
+OH
+SiO
SFR_MIXED
SZY04
75
18 51 46.8
-02 04 09
31.1292
-1.0194
G31.129-1.019
IRAS 18491-0207
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH II
+OH
EVOLVED
SZY04
76
18 51 46.8
-02 04 09
31.1292
-1.0194
G31.129-1.019
IRAS 18491-0207
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH II
+OH
EVOLVED
SZY04
77
19 02 6.3
+03 20 15
37.1183
-0.8476
G37.118-0.847
IRAS 18596+0315
1.612 GHz
;
ENG15
+H
2
O
-CH
3
OH I
-CH
3
OH II
+OH
+SiO
EVOLVED
SZY04
78
19 02 6.3
+03 20 15
37.1183
-0.8476
G37.118-0.847
IRAS 18596+0315
1.667 GHz
;
ENG15
+H
2
O
-CH
3
OH I
-CH
3
OH II
+OH
+SiO
EVOLVED
SZY04
79
19 09 7.2
+08 16 31
42.3057
-0.1291
G42.308-0.132
IRAS 19067+0811
1.612 GHz
;
ENG15
+H
2
O
+OH
+SiO
EVOLVED
SZY04
80
19 09 7.2
+08 16 31
42.3057
-0.1291
G42.308-0.132
IRAS 19067+0811
1.667 GHz
;
ENG15
+H
2
O
+OH
+SiO
EVOLVED
SZY04
81
19 13 58.6
+00 07 31
35.6196
-4.9558
G35.620-4.956
IRAS 19114+0002
1.612 GHz
;
ENG15
-H
2
O
+OH
-SiO
EVOLVED
SZY04
82
19 13 58.6
+00 07 31
35.6196
-4.9558
G35.620-4.956
IRAS 19114+0002
1.667 GHz
;
ENG15
-H
2
O
+OH
-SiO
EVOLVED
SZY04
83
19 14 59.4
+17 22 42
51.0416
2.8122
G51.042+2.812
IRAS 19127+1717
1.612 GHz
;
ENG15
-H
2
O
+OH
-SiO
EVOLVED
SZY04
84
19 14 59.4
+17 22 42
51.0416
2.8122
G51.042+2.812
IRAS 19127+1717
1.667 GHz
;
ENG15
-H
2
O
+OH
-SiO
EVOLVED
SZY04
85
19 24 21.9
+09 53 54
45.4969
-2.7023
G45.497-2.702
IRAS 19219+0947
1.612 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
86
19 24 21.9
+09 53 54
45.4969
-2.7023
G45.497-2.702
IRAS 19219+0947
1.667 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
87
19 27 43.6
+21 30 02
56.0949
2.0950
G56.096+2.094
IRAS 19255+2123
1.612 GHz
;
ENG15
+H
2
O
+OH
EVOLVED
SZY04
88
19 27 43.6
+21 30 02
56.0949
2.0950
G56.096+2.094
IRAS 19255+2123
1.667 GHz
;
ENG15
+H
2
O
+OH
EVOLVED
SZY04
89
19 36 18.5
+29 32 48
64.0952
4.2576
G64.096+4.257
IRAS 19343+2926
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH I
-CH
3
OH II
+OH
EVOLVED
SZY04
90
19 36 18.5
+29 32 48
64.0952
4.2576
G64.096+4.257
IRAS 19343+2926
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH I
-CH
3
OH II
+OH
EVOLVED
SZY04
91
22 05 30.5
+53 21 33
99.6338
-1.8356
G99.634-1.836
IRAS 22036+5306
1.612 GHz
;
ENG15
-H
2
O
-CH
3
OH II
+OH
EVOLVED
SZY04
92
22 05 30.5
+53 21 33
99.6338
-1.8356
G99.634-1.836
IRAS 22036+5306
1.667 GHz
;
ENG15
-H
2
O
-CH
3
OH II
+OH
EVOLVED
SZY04
93
23 34 22.6
+66 01 50
115.2068
4.3214
G115.207+4.321
IRAS 23321+6545
1.612 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
94
23 34 22.6
+66 01 50
115.2068
4.3214
G115.207+4.321
IRAS 23321+6545
1.667 GHz
;
ENG15
-H
2
O
+OH
EVOLVED
SZY04
Get selected data
X
DSS colored
2MASS colored
WISE colored
PACS color (70-160 um)
SPIRE color (250-500 um)
GLIMPSE 360
SDSS color
IRAC color I1,I2,I4
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 'SZY04' 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 'SZY04' AND detected=true AND hide=false ORDER BY detected DESC,id