SQL> @/home/hc0100/hadobs/Monitoring.operational/GUAN/release_1.4b1/bin/./../source/SQL/extract_month_summary.sql Enter year as YYYY : 2004 Enter month as MM : 04 GCOS Upper Air Network (GUAN) Performance. 04 2004 152 rows updated. Reliable GUAN stations CLIMAT TEMP report received: WMO ID Station Name Country Latitude Longitude Elev R Perf (%) Statu ------ --------------- ---------- -------- --------- ----- - -------- ----- 01001 JAN MAYEN NORWAY 70.933 -8.666 10 6 100 green 02836 SODANKYLA FINLAND 67.366 26.649 179 6 92 green 03005 LERWICK UK 60.140 -1.184 82 6 100 green 03808 CAMBORNE UK 50.218 -5.330 87 6 98 green 03953 VALENTIA OBSERV EIRE 51.933 -10.250 9 6 100 green 04018 KEFLAVIKURFLUGV ICELAND 63.966 -22.599 52 6 100 green 08495 GIBRALTAR, NORT GIBRALTAR 36.150 -5.350 3 6 98 green 08508 LAJES/SANTA RIT PORTUGAL 38.733 -27.067 113 6 98 green 10739 STUTTGART/ SCHN GERMANY 48.833 9.199 315 6 98 green 16245 PRATICA DI MARE ITALY 41.650 12.433 32 6 95 green 17130 ANKARA/CENTRAL TURKEY 39.949 32.883 891 6 98 green 20674 OSTROV DIKSON RUSSIAN FE 73.500 80.399 47 2 100 green 22550 ARHANGEL SK RUSSIAN FE 64.616 40.500 4 6 100 green 23472 TURUHANSK RUSSIAN FE 65.783 87.933 38 2 95 green 24266 VERHOJANSK RUSSIAN FE 67.566 133.399 138 2 90 green 28698 OMSK RUSSIAN FE 54.933 73.399 90 2 100 green 30230 KIRENSK RUSSIAN FE 57.766 108.116 258 2 97 green 32540 PETROPAVLOVSK- RUSSIAN FE 53.083 158.583 84 2 97 green 34731 ROSTOV-NA-DONU RUSSIAN FE 47.250 39.816 78 6 98 green 41217 ABU DHABI INTER UNITED ARA 24.433 54.650 27 2 100 green 45004 KINGS PARK HONG KONG 22.317 114.167 66 2 100 green 47138 POHANG REPUBLIC O 36.033 129.383 6 2 100 green 47412 SAPPORO JAPAN 43.050 141.333 19 2 100 green 47646 TATENO JAPAN 36.050 140.133 31 2 100 green 47827 KAGOSHIMA/YOSHI JAPAN 31.633 130.600 283 2 98 green 47936 NAHA JAPAN 26.200 127.683 53 2 97 green 48698 SINGAPORE/CHANG SINGAPORE 1.367 103.983 16 5 100 green 61641 DAKAR/YOFF SENEGAL 14.733 -17.500 24 1 90 green 62414 ASWAN EGYPT 23.967 32.783 194 1 95 green 68588 DURBAN (LOUIS B SOUTH AFRI -29.967 30.950 0 1 92 green 68816 CAPE TOWN (D.F. SOUTH AFRI -33.983 18.600 0 1 93 green 70308 ST PAUL ALASKA 57.150 -170.217 9 4 100 green 70398 ANNETTE ISLAND ALASKA 55.033 -131.567 34 4 100 green 71082 ALERT,N.W.T. CANADA 82.500 -62.333 66 4 90 green 72293 SAN DIEGO/MIRAM UNITED STA 32.850 -117.117 128 4 100 green 72403 WASHINGTON/DULL UNITED STA 38.950 -77.450 98 4 95 green 72597 MEDFORD/MEDFORD UNITED STA 42.367 -122.867 405 4 100 green 72764 BISMARCK/MUN.,N UNITED STA 46.767 -100.750 506 4 100 green 78526 SAN JUAN/INT., PUERTO RIC 18.433 -66.000 19 4 98 green 87576 EZEIZA AERO ARGENTINA -34.817 -58.533 20 3 93 green 89002 GEORG VON NEUMA ANTARCTICA -70.617 -8.367 40 7 97 green 89022 HALLEY ANTARCTICA -75.500 -26.650 30 7 95 green 89512 NOVOLAZAREVSKAJ ANTARCTICA -70.767 11.833 0 7 100 green 89532 SYOWA ANTARCTICA -69.000 39.583 21 7 100 green 89564 MAWSON ANTARCTICA -67.600 62.867 16 7 98 green 89571 DAVIS ANTARCTICA -68.583 77.967 13 7 98 green 89592 MIRNYJ ANTARCTICA -66.550 93.017 30 7 100 green 89611 CASEY ANTARCTICA -66.283 110.517 42 7 98 green 91285 HILO/GEN. LYMAN PACIFIC IS 19.717 -155.067 11 5 100 green 91334 TRUK, CAROLINE PACIFIC IS 7.467 151.850 2 5 100 green 91376 MAJURO/MARSHALL PACIFIC IS 7.083 171.383 3 5 97 green 91408 KOROR, PALAU IS PACIFIC IS 7.333 134.483 33 5 100 green 91592 NOUMEA (NLLE-CA NEW CALEDO -22.267 166.450 72 5 98 green 91765 PAGO PAGO/INT.A SAMOA & AM -14.333 -170.717 3 5 90 green 91925 ATUONA FRENCH POL -9.800 -139.033 52 5 97 green 91938 TAHITI-FAAA FRENCH POL -17.550 -149.617 2 5 100 green 91958 RAPA FRENCH POL -27.617 -144.333 2 5 100 green 93417 PARAPARAUMU AER NEW ZEALAN -40.900 174.983 12 5 97 green 93844 INVERCARGILL AE NEW ZEALAN -46.700 168.550 4 5 97 green 93986 CHATHAM ISLAND NEW ZEALAN -43.950 -176.567 48 5 97 green 93997 RAOUL ISLAND, K NEW ZEALAN -29.250 -177.917 49 5 97 green 94120 DARWIN AIRPORT AUSTRALIA -12.400 130.867 30 5 98 green 94203 BROOME AIRPORT AUSTRALIA -17.950 122.217 9 5 98 green 94294 TOWNSVILLE AMO AUSTRALIA -19.250 146.750 9 5 98 green 94302 LEARMONTH AIRPO AUSTRALIA -22.233 114.083 6 5 98 green 94461 GILES AUSTRALIA -25.033 128.283 599 5 98 green 94510 CHARLEVILLE AIR AUSTRALIA -26.400 146.267 304 5 98 green 94610 BELMONT (PERTH AUSTRALIA -31.933 115.950 29 5 98 green 94659 WOOMERA AERODRO AUSTRALIA -31.133 136.817 167 5 98 green 94975 HOBART AIRPORT AUSTRALIA -42.833 147.483 27 5 98 green 94995 LORD HOWE ISLAN AUSTRALIA -31.533 159.067 6 5 98 green 94996 NORFOLK ISLAND AUSTRALIA -29.033 167.933 109 5 97 green 94998 MACQUARIE ISLAN AUSTRALIA -54.483 158.950 8 5 98 green 96996 COCOS ISLAND AI COCOS ISLA -12.183 96.817 3 5 95 green 74 rows selected. 'UNRELIABLEGUANSTATIONSCLIMATTEMPREPORTRECEIVED:' ------------------------------------------------------ Unreliable GUAN stations CLIMAT TEMP report received: WMO ID Station Name Country Latitude Longitude Elev R Perf (%) Statu ------ --------------- ---------- -------- --------- ----- - -------- ----- 04270 NARSARSUAQ GREENLAND 61.167 -45.417 32 6 73 purpl 35121 ORENBURG RUSSIAN FE 51.683 55.099 117 2 73 purpl 41112 ABHA SAUDI ARAB 18.233 42.650 2093 2 88 purpl 47991 MINAMITORISHIMA JAPAN 24.300 153.967 9 2 83 purpl 50527 HAILAR CHINA 49.217 119.750 611 2 63 purpl 51709 KASHI CHINA 39.467 75.983 1291 2 50 purpl 52681 MINQIN CHINA 38.633 103.083 0 2 35 purpl 53068 ERENHOT CHINA 43.650 112.000 966 2 50 purpl 55299 NAGQU CHINA 31.483 92.067 4508 2 33 purpl 56778 KUNMING CHINA 25.017 102.683 1892 2 68 purpl 57461 YICHANG CHINA 30.700 111.300 134 2 47 purpl 60018 TENERIFE-GUIMAR SPAIN (CAN 28.317 -16.383 111 1 30 purpl 61901 BOTTOMS WOOD, S ST HELENA -15.933 -5.667 435 1 68 purpl 61996 MARTIN DE VIVIE OCEAN ISLA -37.800 77.533 29 1 50 purpl 63450 ADDIS ABABA-BOL ETHIOPIA 9.033 38.750 2354 1 30 purpl 63985 SEYCHELLES INTE SEYCHELLES -4.917 54.517 4 1 72 purpl 67197 FORT-DAUPHIN MADAGASCAR -25.033 46.950 9 1 18 purpl 68906 GOUGH ISLAND TRISTAN DA -40.350 -9.883 0 1 77 purpl 70026 BARROW/W. POST ALASKA 71.300 -156.783 4 4 65 purpl 71816 GOOSE,NFLD. CANADA 53.317 -60.417 49 4 88 purpl 71836 MOOSONEE,ONT. CANADA 51.267 -80.650 10 4 88 purpl 71934 FORT SMITH,N.W. CANADA 60.017 -111.950 205 4 88 purpl 72201 KEY WEST/INT.,F UNITED STA 24.550 -81.750 6 4 65 purpl 72261 DEL RIO/INT., T UNITED STA 29.367 -100.917 313 4 65 purpl 78397 KINGSTON/NORMAN JAMAICA 17.933 -76.783 14 4 48 purpl 78583 BELIZE/PHILLIP BELIZE 17.533 -88.300 5 4 55 purpl 82193 BELEM (AEROPORT BRAZIL -1.383 -48.483 16 3 87 purpl 82332 MANAUS (AEROPOR BRAZIL -3.150 -59.983 84 3 87 purpl 82397 FORTALEZA BRAZIL -3.767 -38.600 19 3 87 purpl 83378 BRASILIA (AEROP BRAZIL -15.867 -47.933 1061 3 78 purpl 85442 ANTOFAGASTA CHILE -23.433 -70.433 0 3 85 purpl 85469 ISLA DE PASCUA CHILE -27.150 -109.417 0 3 15 purpl 85586 SANTO DOMINGO CHILE -33.650 -71.617 75 3 72 purpl 85799 PUERTO MONTT CHILE -41.417 -73.083 0 3 78 purpl 85934 PUNTA ARENAS CHILE -53.000 -70.850 0 3 87 purpl 88889 MOUNT PLEASANT, FALKLAND I -51.817 -58.450 73 3 73 purpl 91643 FUNAFUTI TUVALU -8.517 179.217 2 5 60 purpl 96315 BRUNEI AIRPORT BRUNEI DAR 4.933 114.933 15 5 88 purpl 38 rows selected. Reliable GUAN station, no report received: WMO ID Station Name Country Latitude Longitude Elev R Perf (%) Statu ------ --------------- ---------- -------- --------- ----- - -------- ----- 11035 WIEN/HOHE WARTE AUSTRIA 48.250 16.366 203 6 92 blue 47971 CHICHIJIMA JAPAN 27.083 142.183 8 2 95 blue 48455 BANGKOK THAILAND 13.733 100.567 20 2 92 blue 61998 PORT-AUX-FRANCA OCEAN ISLA -49.350 70.250 30 1 95 blue 68994 MARION ISLAND SOUTH AFRI -46.883 37.867 0 1 92 blue Unreliable GUAN station, no report received: WMO ID Station Name Country Latitude Longitude Elev R Perf (%) Statu ------ --------------- ---------- -------- --------- ----- - -------- ----- 21982 OSTROV VRANGELJ RUSSIAN FE 70.983 -178.483 5 2 0 red 33345 KYIV UKRAINE 50.399 30.566 166 6 0 red 37789 YEREVAN/ZVARTNO ARMENIA 40.133 44.467 907 6 0 red 60680 TAMANRASSET ALGERIA 22.783 5.517 1378 1 67 red 61052 NIAMEY-AERO NIGER 13.483 2.167 227 1 78 red 61902 ASCENSION ISLAN ASCENSION -7.967 -14.400 75 1 0 red 61976 SERGE-FROLOW (I OCEAN ISLA -15.883 54.517 13 1 62 red 61995 VACOAS(MAURITIU MAURITIUS -20.300 57.500 425 1 22 red 63741 NAIROBI/DAGORET KENYA -1.300 36.750 1798 1 20 red 64910 DOUALA OBS. CAMEROON 4.000 9.733 9 1 32 red 65578 ABIDJAN COTE D'IVO 5.250 -3.933 8 1 8 red 67774 HARARE (BELVEDE ZIMBABWE -17.833 31.017 1472 1 12 red 68110 WINDHOEK NAMIBIA -22.567 17.100 1700 1 0 red 76654 MANZANILLO,COL. MEXICO 19.050 -104.333 0 4 12 red 78016 BERMUDA NAVAL A BERMUDA 32.367 -64.683 6 4 0 red 78762 JUAN SANTAMARIA COSTA RICA 10.000 -84.217 939 4 37 red 78954 GRANTLEY ADAMS BARBADOS 13.067 -59.483 56 4 42 red 80222 BOGOTA/ELDORADO COLOMBIA 4.717 -74.150 2548 3 65 red 81405 CAYENNE/ROCHAMB FRENCH GUI 4.833 -52.367 9 3 2 red 83780 SAO PAULO/CONGO BRAZIL -23.617 -46.650 803 3 28 red 84008 SAN CRISTOBAL ( ECUADOR -.433 -89.600 6 3 0 red 84628 LIMA-CALLAO/AER PERU -12.000 -77.117 13 3 23 red 87860 COMODORO RIVADA ARGENTINA -45.783 -67.500 46 3 23 red 89009 AMUNDSEN-SCOTT ANTARCTICA -90.000 .000 2835 7 20 red 89055 BASE MARAMBIO(C ANTARCTICA -64.233 -56.717 198 7 3 red 89642 DUMONT D URVILL ANTARCTICA -66.667 140.017 43 7 70 red 89664 MCMURDO ANTARCTICA -77.850 166.667 24 7 0 red 91212 NWSO AGANA, GUA PACIFIC IS 13.483 144.800 82 5 0 red 91517 HONIARA SOLOMON IS -9.417 159.967 55 5 0 red 91557 BAUERFIELD (EFA VANUATU -17.700 168.300 20 5 0 red 91610 TARAWA KIRIBATI 1.350 172.917 4 5 0 red 91801 PENRHYN COOK ISLAN -9.000 -158.050 0 5 0 red 92035 PORT MORESBY M. PAPUA NEW -9.433 147.217 47 5 0 red 96935 SURABAYA/JUANDA INDONESIA -7.367 112.767 3 5 2 red 98223 LAOAG PHILIPPINE 18.183 120.533 5 5 18 red 35 rows selected. SQL> SPOOL OFF