From stiening@cannon.astro.umass.edu Wed Jun 19 11:23:13 2002 Date: Tue, 18 Jun 2002 21:15:38 -0400 (EDT) From: Rae F. Stiening To: Roc Cutri Cc: Sherry Wheelock Subject: Check on use_src=1 sources in south pole field I think this looks like it should select round(decl,1) as decl,count(*) as rows,max(dist_edge_ew) as max_ew,round(avg(dist_edge_ew),1) as avg_ew,min(dist_edge_ew) as min_ew from south_pole_field where use_src=1 and decl < -84.1 group by round(decl,1); decl | rows | max_ew | avg_ew | min_ew -------+-------+--------+--------+-------- -90.0 | 32 | 251.9 | 235.1 | 202 -89.9 | 310 | 252.6 | 248.7 | 225.9 -89.8 | 637 | 252.6 | 246.8 | 209.6 -89.7 | 929 | 252.6 | 245.1 | 202.7 -89.6 | 1296 | 252.7 | 243.5 | 201.8 -89.5 | 1673 | 252.6 | 241.3 | 196.7 -89.4 | 1945 | 252.7 | 239.9 | 200.4 -89.3 | 2288 | 252.6 | 238.2 | 193.7 -89.2 | 2606 | 252.7 | 236.6 | 191.8 -89.1 | 2903 | 252.7 | 234.8 | 184.1 -89.0 | 3322 | 252.7 | 233.5 | 185.5 -88.9 | 3645 | 252.7 | 231.7 | 179.5 -88.8 | 3936 | 252.7 | 230.1 | 175.8 -88.7 | 4302 | 252.7 | 228.2 | 173.4 -88.6 | 4608 | 252.9 | 226.1 | 170.6 -88.5 | 5066 | 252.8 | 224.7 | 167.9 -88.4 | 5242 | 252.8 | 222.8 | 164.4 -88.3 | 5686 | 252.7 | 221.2 | 161.6 -88.2 | 5887 | 252.8 | 219.7 | 159.7 -88.1 | 6173 | 252.7 | 218.0 | 155.4 -88.0 | 6541 | 252.7 | 216.2 | 152.7 -87.9 | 7127 | 252.8 | 214.1 | 151.1 -87.8 | 7282 | 252.7 | 212.5 | 149.8 -87.7 | 7662 | 252.8 | 210.5 | 144.3 -87.6 | 8008 | 252.7 | 209.0 | 142.7 -87.5 | 8237 | 252.8 | 206.7 | 141 -87.4 | 8533 | 252.8 | 205.2 | 136.7 -87.3 | 9131 | 252.7 | 203.4 | 134.4 -87.2 | 9182 | 252.8 | 201.8 | 131.4 -87.1 | 9627 | 252.7 | 199.1 | 130.2 -87.0 | 9819 | 252.8 | 197.9 | 127.2 -86.9 | 10194 | 252.8 | 196.4 | 125.5 -86.8 | 10618 | 252.8 | 194.5 | 119.4 -86.7 | 11023 | 252.9 | 192.5 | 116.8 -86.6 | 11410 | 252.7 | 190.5 | 114.5 -86.5 | 11933 | 252.7 | 189.1 | 111 -86.4 | 11998 | 252.7 | 187.1 | 108.3 -86.3 | 12374 | 252.7 | 185.2 | 104.6 -86.2 | 12868 | 252.7 | 184.0 | 101.3 -86.1 | 13287 | 252.5 | 182.0 | 98.4 -86.0 | 13486 | 252.8 | 179.8 | 95.6 -85.9 | 14031 | 252.7 | 178.1 | 94.4 -85.8 | 14663 | 252.6 | 176.5 | 88.6 -85.7 | 15080 | 252.7 | 174.2 | 86.7 -85.6 | 15269 | 252.8 | 171.9 | 82.9 -85.5 | 15511 | 252.6 | 170.8 | 81.1 -85.4 | 15936 | 252.6 | 168.5 | 76.2 -85.3 | 16066 | 252.6 | 167.2 | 72.5 -85.2 | 16635 | 252.5 | 165.1 | 70.3 -85.1 | 16973 | 252.5 | 162.6 | 65.8 -85.0 | 17462 | 252.4 | 161.7 | 63.2 -84.9 | 17685 | 252.4 | 159.8 | 58.2 -84.8 | 18198 | 252.5 | 158.0 | 53.7 -84.7 | 18330 | 252.6 | 156.2 | 49.7 -84.6 | 18549 | 252.4 | 154.6 | 47.7 -84.5 | 19169 | 252.4 | 152.2 | 43