SQL> @/home/hc0100/hadobs/Monitoring.operational/GUAN/release_1.5b1/bin/./../source/SQL/extract_month_summary.sql Enter year as YYYY : 2005 Enter month as MM : 02 GCOS Upper Air Network (GUAN) Performance. 02 2005 161 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 92 green 03808 CAMBORNE CORNWALL 50.218 -5.330 87 6 100 green 03953 VALENTIA OBSERV KERRY 51.933 -10.250 25 6 100 green 04018 KEFLAVIKURFLUGV ICELAND 63.966 -22.599 52 6 92 green 08495 GIBRALTAR, NORT GIBRALTAR 36.150 -5.350 3 6 100 green 08508 LAJES/SANTA RIT PORTUGAL 38.733 -27.067 113 6 92 green 10393 LINDENBERG GERMANY 52.216 14.116 104 6 92 green 17130 ANKARA/CENTRAL TURKEY 39.949 32.883 891 6 100 green 20674 OSTROV DIKSON RUSSIAN FE 73.500 80.399 47 2 92 green 22550 ARHANGEL SK RUSSIAN FE 64.616 40.500 4 6 100 green 23472 TURUHANSK RUSSIAN FE 65.783 87.933 38 2 100 green 24266 VERHOJANSK RUSSIAN FE 67.566 133.399 138 2 100 green 28698 OMSK RUSSIAN FE 54.933 73.399 122 2 100 green 30230 KIRENSK RUSSIAN FE 57.766 108.116 258 2 100 green 31088 OHOTSK RUSSIAN FE 59.366 143.199 6 2 92 green 32540 PETROPAVLOVSK- RUSSIAN FE 53.083 158.583 84 2 100 green 35121 ORENBURG RUSSIAN FE 51.683 55.099 117 2 92 green 41112 ABHA SAUDI ARAB 18.233 42.650 2093 2 100 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 92 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 100 green 47991 MINAMITORISHIMA JAPAN 24.300 153.967 9 2 100 green 48698 SINGAPORE/CHANG SINGAPORE 1.367 103.983 16 5 100 green 50527 HAILAR CHINA 49.217 119.750 611 2 100 green 51709 KASHI CHINA 39.467 75.983 1291 2 100 green 52681 MINQIN CHINA 38.633 103.083 1367 2 100 green 53068 ERENHOT CHINA 43.650 112.000 966 2 92 green 55299 NAGQU CHINA 31.483 92.067 4508 2 92 green 56778 KUNMING CHINA 25.017 102.683 1892 2 100 green 57461 YICHANG CHINA 30.700 111.300 134 2 100 green 60018 TENERIFE-GUIMAR SPAIN (CAN 28.317 -16.383 111 1 100 green 61641 DAKAR/YOFF SENEGAL 14.733 -17.500 24 1 92 green 68588 DURBAN (LOUIS B SOUTH AFRI -29.967 30.950 8 1 92 green 68816 CAPE TOWN (D.F. SOUTH AFRI -33.983 18.600 46 1 100 green 68906 GOUGH ISLAND TRISTAN DA -40.350 -9.883 54 1 100 green 70026 BARROW/W. POST ALASKA 71.300 -156.783 4 4 100 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 71816 GOOSE,NFLD. CANADA 53.317 -60.417 49 4 100 green 71836 MOOSONEE,ONT. CANADA 51.267 -80.650 10 4 100 green 71925 CAMBRIDGE BAY,N CANADA 69.100 -105.117 27 4 100 green 71934 FORT SMITH,N.W. CANADA 60.017 -111.950 205 4 100 green 72201 KEY WEST/INT.,F UNITED STA 24.550 -81.750 6 4 92 green 72250 BROWNSVILLE/INT UNITED STA 25.917 -97.417 7 4 100 green 72293 SAN DIEGO/MIRAM UNITED STA 32.850 -117.117 128 4 100 green 72597 MEDFORD/MEDFORD UNITED STA 42.367 -122.867 405 4 100 green 72776 GREAT FALLS/INT UNITED STA 47.483 -111.367 1115 4 100 green 78526 SAN JUAN/INT., PUERTO RIC 18.433 -66.000 19 4 100 green 85442 ANTOFAGASTA CHILE -23.433 -70.433 140 3 92 green 85586 SANTO DOMINGO CHILE -33.650 -71.617 75 3 92 green 85799 PUERTO MONTT CHILE -41.417 -73.083 90 3 92 green 85934 PUNTA ARENAS CHILE -53.000 -70.850 43 3 92 green 89002 GEORG VON NEUMA ANTARCTICA -70.617 -8.367 40 7 100 green 89022 HALLEY ANTARCTICA -75.500 -26.650 30 7 100 green 89512 NOVOLAZAREVSKAJ ANTARCTICA -70.767 11.833 140 7 92 green 89532 SYOWA ANTARCTICA -69.000 39.583 21 7 100 green 89564 MAWSON ANTARCTICA -67.600 62.867 16 7 92 green 89611 CASEY ANTARCTICA -66.283 110.517 42 7 92 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 100 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 100 green 91643 FUNAFUTI TUVALU -8.517 179.217 2 5 100 green 91765 PAGO PAGO/INT.A SAMOA & AM -14.333 -170.717 3 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 100 green 93844 INVERCARGILL AE NEW ZEALAN -46.700 168.550 4 5 100 green 93986 CHATHAM ISLAND NEW ZEALAN -43.950 -176.567 48 5 100 green 93997 RAOUL ISLAND, K NEW ZEALAN -29.250 -177.917 49 5 100 green 94120 DARWIN AIRPORT AUSTRALIA -12.400 130.867 30 5 100 green 94203 BROOME AIRPORT AUSTRALIA -17.950 122.217 9 5 100 green 94294 TOWNSVILLE AMO AUSTRALIA -19.250 146.750 9 5 100 green 94302 LEARMONTH AIRPO AUSTRALIA -22.233 114.083 6 5 100 green 94461 GILES AUSTRALIA -25.033 128.283 599 5 100 green 94510 CHARLEVILLE AIR AUSTRALIA -26.400 146.267 304 5 100 green 94610 BELMONT (PERTH AUSTRALIA -31.933 115.950 29 5 100 green 94659 WOOMERA AERODRO AUSTRALIA -31.133 136.817 167 5 100 green 94975 HOBART AIRPORT AUSTRALIA -42.833 147.483 27 5 100 green 94995 LORD HOWE ISLAN AUSTRALIA -31.533 159.067 6 5 100 green 94996 NORFOLK ISLAND AUSTRALIA -29.033 167.933 109 5 100 green 94998 MACQUARIE ISLAN AUSTRALIA -54.483 158.950 8 5 100 green 96315 BRUNEI AIRPORT BRUNEI DAR 4.933 114.933 15 5 100 green 96996 COCOS ISLAND AI COCOS ISLA -12.183 96.817 3 5 100 green 87 rows selected. 'UNRELIABLEGUANSTATIONSCLIMATTEMPREPORTRECEIVED:' ------------------------------------------------------ Unreliable GUAN stations CLIMAT TEMP report received: WMO ID Station Name Country Latitude Longitude Elev R Perf (%) Statu ------ --------------- ---------- -------- --------- ----- - -------- ----- 11035 WIEN/HOHE WARTE AUSTRIA 48.250 16.366 203 6 83 purpl 16245 PRATICA DI MARE ITALY 41.650 12.433 32 6 83 purpl 23921 IVDEL RUSSIAN FE 60.683 60.450 95 2 58 purpl 27459 NIZNIJ NOVGOROD RUSSIAN FE 56.267 44.000 157 6 58 purpl 29862 HAKASSKAJA RUSSIAN FE 53.767 91.317 256 6 58 purpl 33345 KYIV UKRAINE 50.399 30.566 166 6 8 purpl 47936 NAHA JAPAN 26.200 127.683 53 2 83 purpl 47971 CHICHIJIMA JAPAN 27.083 142.183 8 2 83 purpl 48455 BANGKOK THAILAND 13.733 100.567 20 2 67 purpl 60680 TAMANRASSET ALGERIA 22.783 5.517 1378 1 83 purpl 61052 NIAMEY-AERO NIGER 13.483 2.167 227 1 67 purpl 61901 BOTTOMS WOOD, S ST HELENA -15.933 -5.667 435 1 83 purpl 61976 SERGE-FROLOW (I OCEAN ISLA -15.883 54.517 13 1 67 purpl 61995 VACOAS(MAURITIU MAURITIUS -20.300 57.500 425 1 75 purpl 63985 SEYCHELLES INTE SEYCHELLES -4.917 54.517 4 1 67 purpl 64910 DOUALA OBS. CAMEROON 4.000 9.733 9 1 42 purpl 76654 MANZANILLO,COL. MEXICO 19.050 -104.333 3 4 17 purpl 78397 KINGSTON/NORMAN JAMAICA 17.933 -76.783 14 4 83 purpl 78583 BELIZE/PHILLIP BELIZE 17.533 -88.300 5 4 75 purpl 78762 JUAN SANTAMARIA COSTA RICA 10.000 -84.217 939 4 58 purpl 78988 HATO AIRPORT,CU CURACAO & 12.200 -68.967 67 4 75 purpl 82332 MANAUS (AEROPOR BRAZIL -3.150 -59.983 84 3 33 purpl 82397 FORTALEZA BRAZIL -3.767 -38.600 19 3 67 purpl 85469 ISLA DE PASCUA CHILE -27.150 -109.417 69 3 75 purpl 87576 EZEIZA AERO ARGENTINA -34.817 -58.533 20 3 75 purpl 87860 COMODORO RIVADA ARGENTINA -45.783 -67.500 46 3 17 purpl 88889 MOUNT PLEASANT, FALKLAND I -51.817 -58.450 73 3 83 purpl 89571 DAVIS ANTARCTICA -68.583 77.967 13 7 75 purpl 89592 MIRNYJ ANTARCTICA -66.550 93.017 30 7 83 purpl 91610 TARAWA KIRIBATI 1.350 172.917 4 5 67 purpl 91801 PENRHYN COOK ISLAN -9.000 -158.050 0 5 42 purpl 98223 LAOAG PHILIPPINE 18.183 120.533 5 5 50 purpl 32 rows selected. Reliable GUAN station, no report received: WMO ID Station Name Country Latitude Longitude Elev R Perf (%) Statu ------ --------------- ---------- -------- --------- ----- - -------- ----- 03005 LERWICK SHETLAND 60.140 -1.183 82 6 92 blue 71082 ALERT,N.W.T. CANADA 82.520 -62.283 66 4 92 blue Unreliable GUAN station, no report received: WMO ID Station Name Country Latitude Longitude Elev R Perf (%) Statu ------ --------------- ---------- -------- --------- ----- - -------- ----- 02836 SODANKYLA FINLAND 67.366 26.649 179 6 58 red 04270 NARSARSUAQ GREENLAND 61.167 -45.417 32 6 42 red 37789 YEREVAN/YEREVAN ARMENIA 40.133 44.467 1140 6 0 red 40745 MASHHAD IRAN 36.267 59.633 980 2 33 red 43599 GAN MALDIVES -.683 73.150 2 2 17 red 61902 ASCENSION ISLAN ASCENSION -7.967 -14.400 75 1 0 red 61996 MARTIN DE VIVIE OCEAN ISLA -37.800 77.533 29 1 42 red 61998 PORT-AUX-FRANCA OCEAN ISLA -49.350 70.250 30 1 42 red 62414 ASWAN EGYPT 23.967 32.783 194 1 50 red 63450 ADDIS ABABA-BOL ETHIOPIA 9.033 38.750 2354 1 83 red 63741 NAIROBI/DAGORET KENYA -1.300 36.750 1798 1 0 red 63894 DAR ES SALAAM A UNITED REP -6.867 39.200 55 1 0 red 65578 ABIDJAN COTE D'IVO 5.250 -3.933 8 1 0 red 67197 FORT-DAUPHIN MADAGASCAR -25.033 46.950 9 1 33 red 67774 HARARE (BELVEDE ZIMBABWE -17.833 31.017 1472 1 8 red 68110 WINDHOEK NAMIBIA -22.567 17.100 1700 1 0 red 68994 MARION ISLAND SOUTH AFRI -46.883 37.867 22 1 8 red 72451 DODGE CITY/MUN. UNITED STA 37.767 -99.967 790 4 0 red 72520 PITTSBURGH/GREA UNITED STA 40.500 -80.217 373 4 0 red 78016 BERMUDA NAVAL A BERMUDA 32.367 -64.683 6 4 0 red 78954 GRANTLEY ADAMS BARBADOS 13.067 -59.483 56 4 8 red 80222 BOGOTA/ELDORADO COLOMBIA 4.717 -74.150 2548 3 0 red 81405 CAYENNE/ROCHAMB FRENCH GUI 4.833 -52.367 9 3 0 red 82193 BELEM (AEROPORT BRAZIL -1.383 -48.483 16 3 58 red 83378 BRASILIA (AEROP BRAZIL -15.867 -47.933 1061 3 67 red 83780 SAO PAULO/CONGO BRAZIL -23.617 -46.650 803 3 0 red 84008 SAN CRISTOBAL ( ECUADOR -.433 -89.600 6 3 0 red 84628 LIMA-CALLAO/AER PERU -12.000 -77.117 13 3 58 red 87155 RESISTENCIA AER ARGENTINA -27.450 -59.050 52 3 75 red 89009 AMUNDSEN-SCOTT ANTARCTICA -90.000 .000 2835 7 33 red 89055 BASE MARAMBIO(C ANTARCTICA -64.233 -56.717 198 7 0 red 89642 DUMONT D URVILL ANTARCTICA -66.667 140.017 43 7 0 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 91925 ATUONA FRENCH POL -9.800 -139.033 52 5 75 red 91938 TAHITI-FAAA FRENCH POL -17.550 -149.617 2 5 75 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 0 red 40 rows selected. SQL> SPOOL OFF