SQL> @/home/hc0100/hadobs/Monitoring.operational/GUAN/release_1.3b1/bin/./../source/SQL/extract_month_summary.sql Enter year as YYYY : 2004 Enter month as MM : 02 GCOS Upper Air Network (GUAN) Performance. 02 2004 152 rows updated. 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 04270 NARSARSUAQ GREENLAND 61.167 -45.417 32 6 73 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 11035 WIEN/HOHE WARTE AUSTRIA 48.250 16.366 203 6 93 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 35121 ORENBURG RUSSIAN FE 51.683 55.099 117 2 73 green 41112 ABHA SAUDI ARAB 18.233 42.650 2093 2 85 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 47971 CHICHIJIMA JAPAN 27.083 142.183 8 2 98 green 47991 MINAMITORISHIMA JAPAN 24.300 153.967 9 2 83 green 48698 SINGAPORE/CHANG SINGAPORE 1.367 103.983 16 5 100 green 50527 HAILAR CHINA 49.217 119.750 611 2 60 green 51709 KASHI CHINA 39.467 75.983 1291 2 47 green 52681 MINQIN CHINA 38.633 103.083 0 2 32 green 53068 ERENHOT CHINA 43.650 112.000 966 2 47 green 55299 NAGQU CHINA 31.483 92.067 4508 2 30 green 56778 KUNMING CHINA 25.017 102.683 1892 2 68 green 57461 YICHANG CHINA 30.700 111.300 134 2 43 green 60018 TENERIFE-GUIMAR SPAIN (CAN 28.317 -16.383 111 1 27 green 60680 TAMANRASSET ALGERIA 22.783 5.517 1378 1 68 green 61052 NIAMEY-AERO NIGER 13.483 2.167 227 1 78 green 61641 DAKAR/YOFF SENEGAL 14.733 -17.500 24 1 90 green 61976 SERGE-FROLOW (I OCEAN ISLA -15.883 54.517 13 1 63 green 61995 VACOAS(MAURITIU MAURITIUS -20.300 57.500 425 1 23 green 61996 MARTIN DE VIVIE OCEAN ISLA -37.800 77.533 29 1 48 green 61998 PORT-AUX-FRANCA OCEAN ISLA -49.350 70.250 30 1 97 green 62414 ASWAN EGYPT 23.967 32.783 194 1 95 green 63450 ADDIS ABABA-BOL ETHIOPIA 9.033 38.750 2354 1 32 green 63985 SEYCHELLES INTE SEYCHELLES -4.917 54.517 4 1 72 green 64910 DOUALA OBS. CAMEROON 4.000 9.733 9 1 35 green 67774 HARARE (BELVEDE ZIMBABWE -17.833 31.017 1472 1 15 green 68906 GOUGH ISLAND TRISTAN DA -40.350 -9.883 0 1 78 green 68994 MARION ISLAND SOUTH AFRI -46.883 37.867 0 1 95 green 70026 BARROW/W. POST ALASKA 71.300 -156.783 4 4 62 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 72201 KEY WEST/INT.,F UNITED STA 24.550 -81.750 6 4 62 green 72261 DEL RIO/INT., T UNITED STA 29.367 -100.917 313 4 62 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 93 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 78583 BELIZE/PHILLIP BELIZE 17.533 -88.300 5 4 52 green 82193 BELEM (AEROPORT BRAZIL -1.383 -48.483 16 3 87 green 82397 FORTALEZA BRAZIL -3.767 -38.600 19 3 87 green 83378 BRASILIA (AEROP BRAZIL -15.867 -47.933 1061 3 77 green 85442 ANTOFAGASTA CHILE -23.433 -70.433 0 3 82 green 85586 SANTO DOMINGO CHILE -33.650 -71.617 75 3 68 green 85799 PUERTO MONTT CHILE -41.417 -73.083 0 3 78 green 85934 PUNTA ARENAS CHILE -53.000 -70.850 0 3 87 green 87576 EZEIZA AERO ARGENTINA -34.817 -58.533 20 3 93 green 88889 MOUNT PLEASANT, FALKLAND I -51.817 -58.450 73 3 73 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 98 green 91592 NOUMEA (NLLE-CA NEW CALEDO -22.267 166.450 72 5 98 green 91643 FUNAFUTI TUVALU -8.517 179.217 2 5 60 green 91765 PAGO PAGO/INT.A SAMOA & AM -14.333 -170.717 3 5 88 green 91925 ATUONA FRENCH POL -9.800 -139.033 52 5 95 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 96315 BRUNEI AIRPORT BRUNEI DAR 4.933 114.933 15 5 88 green 96996 COCOS ISLAND AI COCOS ISLA -12.183 96.817 3 5 95 green 111 rows selected. Reliable GUAN station, no report received: WMO ID Station Name Country Latitude Longitude Elev R Perf (%) Statu ------ --------------- ---------- -------- --------- ----- - -------- ----- 48455 BANGKOK THAILAND 13.733 100.567 20 2 93 blue 68588 DURBAN (LOUIS B SOUTH AFRI -29.967 30.950 0 1 93 blue 68816 CAPE TOWN (D.F. SOUTH AFRI -33.983 18.600 0 1 95 blue 71082 ALERT,N.W.T. CANADA 82.500 -62.333 66 4 90 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 61901 BOTTOMS WOOD, S ST HELENA -15.933 -5.667 435 1 68 red 61902 ASCENSION ISLAN ASCENSION -7.967 -14.400 75 1 0 red 63741 NAIROBI/DAGORET KENYA -1.300 36.750 1798 1 20 red 65578 ABIDJAN COTE D'IVO 5.250 -3.933 8 1 12 red 67197 FORT-DAUPHIN MADAGASCAR -25.033 46.950 9 1 15 red 68110 WINDHOEK NAMIBIA -22.567 17.100 1700 1 0 red 71816 GOOSE,NFLD. CANADA 53.317 -60.417 49 4 88 red 71836 MOOSONEE,ONT. CANADA 51.267 -80.650 10 4 88 red 71934 FORT SMITH,N.W. CANADA 60.017 -111.950 205 4 88 red 76654 MANZANILLO,COL. MEXICO 19.050 -104.333 0 4 13 red 78016 BERMUDA NAVAL A BERMUDA 32.367 -64.683 6 4 0 red 78397 KINGSTON/NORMAN JAMAICA 17.933 -76.783 14 4 45 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 68 red 81405 CAYENNE/ROCHAMB FRENCH GUI 4.833 -52.367 9 3 2 red 82332 MANAUS (AEROPOR BRAZIL -3.150 -59.983 84 3 88 red 83780 SAO PAULO/CONGO BRAZIL -23.617 -46.650 803 3 32 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 85469 ISLA DE PASCUA CHILE -27.150 -109.417 0 3 12 red 87860 COMODORO RIVADA ARGENTINA -45.783 -67.500 46 3 27 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 73 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 37 rows selected. Reliable non-GUAN station, CLIMAT TEMP report received: WMO ID Station Name Country Latitude Longitude Elev R Perf (%) Statu ------ --------------- ---------- -------- --------- ----- - -------- ----- 01028 BJORNOYA NORWAY 74.516 19.016 16 6 98 black 01152 BODO VI NORWAY 67.266 14.366 13 6 97 black 01241 ORLAND III NORWAY 63.699 9.599 7 6 97 black 01661 OWS MIKE NORTH ATLA 65.930 2.343 0 97 black 02185 LULEA/KALLAX SWEDEN 65.550 22.133 34 6 100 black 02365 SUNDVALL-HARNLS SWEDEN 62.533 17.450 6 6 100 black 02527 GOTEBORG/LANDVE SWEDEN 57.667 12.300 155 6 97 black 02935 JYVASKYLA FINLAND 62.399 25.683 141 6 92 black 06610 PAYERNE SWITZERLAN 46.817 6.950 491 6 92 black 07145 TRAPPES FRANCE 48.766 2.016 168 6 95 black 07180 NANCY/ESSEY FRANCE 48.683 6.216 225 6 98 black 07510 BORDEAUX/MERIGN FRANCE 44.833 -.699 49 6 93 black 07761 AJACCIO FRANCE 41.916 8.799 6 6 95 black 08001 LA CORUNA SPAIN 43.366 -8.416 58 6 97 black 08023 SANTANDER SPAIN 43.467 -3.817 65 6 95 black 08160 ZARAGOZA/AEROPU SPAIN 41.667 -1.017 258 6 90 black 08430 MURCIA SPAIN 38.000 -1.167 62 6 97 black 10035 SCHLESWIG GERMANY 54.533 9.549 47 6 100 black 10184 GREIFSWALD GERMANY 54.099 13.399 2 6 100 black 10238 BERGEN GERMANY 52.817 9.933 70 6 97 black 10393 LINDENBERG GERMANY 52.216 14.116 98 6 100 black 10410 ESSEN GERMANY 51.399 6.966 153 6 97 black 10548 MEININGEN GERMANY 50.566 10.383 450 6 100 black 10868 MUENCHEN- OBERS GERMANY 48.250 11.550 489 6 100 black 11520 PRAHA-LIBUS CZECH REPU 50.016 14.449 304 6 100 black 11952 POPRAD/GANOVCE SLOVAKIA 49.050 20.533 706 6 98 black 12120 LEBA POLAND 54.750 17.533 2 6 97 black 12374 LEGIONOWO POLAND 52.400 20.967 96 6 93 black 12425 WROCLAW I POLAND 51.133 16.983 116 6 95 black 12843 BUDAPEST/LORINC HUNGARY 47.433 19.183 138 6 98 black 12982 SZEGED HUNGARY 46.250 20.099 82 6 97 black 15420 BUCURESTI/IMH ROMANIA 44.500 26.133 91 6 98 black 15614 SOFIA (OBSERV.) BULGARIA 42.649 23.383 586 6 93 black 16080 MILANO/LINATE ITALY 45.433 9.283 107 6 100 black 16320 BRINDISI ITALY 40.649 17.949 15 6 92 black 17030 SAMSUN TURKEY 41.283 36.333 4 6 93 black 17062 ISTANBUL/GOZTEP TURKEY 40.966 29.083 33 6 98 black 17220 IZMIR TURKEY 38.433 27.166 25 6 98 black 17240 ISPARTA TURKEY 37.750 30.549 997 6 95 black 17280 DIYARBAKIR TURKEY 37.883 40.183 686 6 97 black 17351 ADANA/BOLGE TURKEY 37.033 35.217 28 6 93 black 17607 ATHALASSA CYPRUS 35.150 33.400 161 6 98 black 22113 MURMANSK RUSSIAN FE 68.983 33.116 121 6 100 black 23330 SALEHARD RUSSIAN FE 66.533 66.666 16 2 92 black 23804 SYKTYVKAR RUSSIAN FE 61.666 50.849 116 2 97 black 24125 OLENEK RUSSIAN FE 68.500 112.433 220 2 93 black 24507 TURA RUSSIAN FE 64.266 100.233 168 2 90 black 24959 JAKUTSK RUSSIAN FE 62.083 129.750 103 2 100 black 26063 ST PETERBURG (V RUSSIAN FE 59.949 30.699 78 6 100 black 27612 MOSKVA (DOLGOPR RUSSIAN FE 55.750 37.949 200 6 100 black 28445 VERHNEE DUBROVO RUSSIAN FE 56.733 61.067 290 6 100 black 29572 EMEL JANOVO RUSSIAN FE 56.183 92.617 206 6 98 black 30758 CITA RUSSIAN FE 52.016 113.333 685 2 100 black 31004 ALDAN RUSSIAN FE 58.616 125.366 682 2 98 black 31736 HABAROVSK RUSSIAN FE 48.533 135.233 72 6 90 black 31977 VLADIVOSTOK (SA RUSSIAN FE 43.267 132.050 82 6 100 black 32150 JUZNO-SAHALINSK RUSSIAN FE 46.916 142.733 31 2 97 black 40179 BET DAGAN ISRAEL 32.000 34.817 35 6 98 black 40375 TABUK SAUDI ARAB 28.367 36.600 768 2 93 black 40394 HAIL SAUDI ARAB 27.433 41.683 1015 2 93 black 40437 KING KHALED INT SAUDI ARAB 24.933 46.717 612 2 93 black 40848 SHIRAZ IRAN 29.533 52.583 1491 2 95 black 41024 JEDDAH (KING AB SAUDI ARAB 21.700 39.183 17 2 93 black 42027 SRINAGAR INDIA 34.083 74.833 1587 2 100 black 42182 NEW DELHI/ SAFD INDIA 28.583 77.200 216 2 93 black 42339 JODHPUR INDIA 26.300 73.017 224 2 97 black 42369 LUCKNOW/AMAUSI INDIA 26.750 80.883 128 2 98 black 42410 GAUHATI INDIA 26.100 91.583 54 2 98 black 42809 CALCUTTA/DUM DU INDIA 22.650 88.450 6 2 98 black 42867 NAGPUR SONEGAON INDIA 21.100 79.050 310 2 92 black 42971 BHUBANESWAR INDIA 20.250 85.833 46 2 90 black 43003 BOMBAY / SANTAC INDIA 19.117 72.850 14 2 95 black 43128 HYDERABAD AIRPO INDIA 17.450 78.467 545 2 92 black 43150 CWC VISHAKHAPAT INDIA 17.700 83.300 66 2 92 black 43279 MADRAS/MINAMBAK INDIA 13.000 80.183 16 2 98 black 43333 PORT BLAIR INDIA 11.667 92.717 79 2 95 black 43353 COCHIN/WILLINGD INDIA 9.950 76.267 3 2 95 black 43371 THIRUVANANTHAPU INDIA 8.483 76.950 64 2 90 black 47122 OSAN AB REPUBLIC O 37.100 127.033 12 2 100 black 47158 KWANGJU AB REPUBLIC O 35.117 126.817 13 2 100 black 47185 CHEJU UPPER/RAD REPUBLIC O 33.283 126.167 73 2 100 black 47401 WAKKANAI JAPAN 45.417 141.683 11 2 97 black 47420 NEMURO JAPAN 43.333 145.583 39 2 100 black 47582 AKITA JAPAN 39.717 140.100 7 2 100 black 47590 SENDAI JAPAN 38.267 140.900 43 2 100 black 47600 WAJIMA JAPAN 37.383 136.900 14 2 100 black 47678 HACHIJOJIMA JAPAN 33.100 139.783 80 2 93 black 47744 YONAGO JAPAN 35.433 133.350 8 2 100 black 47778 SHIONOMISAKI JAPAN 33.450 135.767 75 2 100 black 47807 FUKUOKA JAPAN 33.583 130.383 14 2 100 black 47909 NAZE JAPAN 28.383 129.500 7 2 100 black 47918 ISHIGAKIJIMA JAPAN 24.333 124.167 7 2 100 black 47945 MINAMIDAITOJIMA JAPAN 25.833 131.233 15 2 100 black 48601 PENANG/BAYAN LE MALAYSIA 5.300 100.267 4 5 100 black 48615 KOTA BHARU MALAYSIA 6.167 102.283 5 5 100 black 48650 SEPANG MALAYSIA 2.717 101.700 16 5 93 black 62306 MERSA MATRUH EGYPT 31.333 27.217 28 1 93 black 62337 EL ARISH EGYPT 31.083 33.817 32 1 97 black 62378 HELWAN EGYPT 29.867 31.333 141 1 93 black 68538 DE AAR SOUTH AFRI -30.650 24.017 1200 1 92 black 70133 KOTZEBUE, RALPH ALASKA 66.867 -162.633 5 4 100 black 70200 NOME ALASKA 64.500 -165.433 7 4 100 black 70219 BETHEL/BETHEL A ALASKA 60.783 -161.800 46 4 97 black 70231 MCGRATH ALASKA 62.967 -155.617 103 4 97 black 70261 FAIRBANKS/INT. ALASKA 64.817 -147.867 138 4 100 black 70273 ANCHORAGE/INT. ALASKA 61.167 -150.017 40 4 100 black 70316 COLD BAY ALASKA 55.200 -162.717 31 4 98 black 70326 KING SALMON ALASKA 58.683 -156.650 15 4 100 black 70361 YAKUTAT ALASKA 59.517 -139.667 9 4 100 black 72202 MIAMI, FL UNITED STA 25.750 -80.383 5 4 98 black 72208 CHARLESTON/MUN. UNITED STA 32.900 -80.033 15 4 98 black 72233 SLIDELL/MUN. LA UNITED STA 30.333 -89.817 8 4 100 black 72248 SHREVEPORT/REG. UNITED STA 32.467 -94.317 79 4 100 black 72250 BROWNSVILLE/INT UNITED STA 25.917 -97.417 7 4 100 black 72251 CORPUS CHRISTI/ UNITED STA 27.767 -97.500 13 4 100 black 72305 NEWPORT, NC. UNITED STA 34.783 -76.883 11 4 98 black 72327 NASHVILLE/ METR UNITED STA 36.117 -86.683 180 4 98 black 72357 NORMAN/MAX WEST UNITED STA 35.217 -97.450 357 4 98 black 72364 SANTA TERESA, N UNITED STA 31.867 -106.700 1252 4 100 black 72426 WILMINGTON, OH. UNITED STA 39.417 -83.817 317 4 100 black 72440 SPRINGFIELD/MUN UNITED STA 37.233 -93.383 387 4 98 black 72476 GRAND JUNCTION/ UNITED STA 39.117 -108.533 1475 4 100 black 72493 OAKLAND/METROP. UNITED STA 37.733 -122.217 3 4 100 black 72528 BUFFALO/GREATER UNITED STA 42.933 -78.733 215 4 93 black 72562 NORTH PLATTE/LE UNITED STA 41.133 -100.683 849 4 100 black 72582 ELKO, NV. UNITED STA 40.867 -115.733 1608 4 100 black 72649 CHANHAUSSEN, MN UNITED STA 44.850 -93.567 287 4 98 black 72662 RAPID CITY/REG. UNITED STA 44.050 -103.067 966 4 100 black 72712 CARIBOU/MUN.,ME UNITED STA 46.867 -68.017 190 4 100 black 72747 INT.FALLS/FALLS UNITED STA 48.567 -93.383 361 4 97 black 72776 GREAT FALLS, MT UNITED STA 47.467 -111.383 1131 4 97 black 72786 SPOKANE, WA. UNITED STA 47.683 -117.633 728 4 97 black 72797 QUILLAYUTE,WA. UNITED STA 47.950 -124.550 62 4 95 black 74494 CHATHAM, MA. UNITED STA 41.667 -69.967 16 4 98 black 83362 CUIABA (AEROPOR BRAZIL -15.650 -56.100 187 3 92 black 83746 RIO DE JANEIRO/ BRAZIL -22.817 -43.250 6 3 93 black 83971 PORTO ALEGRE/SA BRAZIL -30.000 -51.183 3 3 93 black 87344 CORDOBA AERO ARGENTINA -31.317 -64.217 474 3 90 black 91348 PONAPE, CAROLIN PACIFIC IS 6.967 158.217 46 5 95 black 91366 KWAJALEIN/BUCHO PACIFIC IS 8.733 167.733 8 5 97 black 91680 NANDI FIJI -17.750 177.450 18 5 97 black 91948 RIKITEA FRENCH POL -23.133 -134.967 89 5 97 black 91954 TUBUAI FRENCH POL -23.350 -149.483 3 5 100 black 93112 WHENUAPAI NEW ZEALAN -36.783 174.633 27 5 97 black 94150 GOVE AIRPORT AUSTRALIA -12.267 136.817 54 5 98 black 94299 WILLIS ISLAND AUSTRALIA -16.300 149.983 9 5 98 black 94312 PORT HEDLAND PA AUSTRALIA -20.100 119.567 10 5 98 black 94326 ALICE SPRINGS A AUSTRALIA -23.800 133.883 547 5 98 black 94332 MT ISA AIRPORT AUSTRALIA -20.667 139.483 344 5 97 black 94374 ROCKHAMPTON AIR AUSTRALIA -23.383 150.467 14 5 98 black 94403 GERALDTON AIRPO AUSTRALIA -28.783 114.700 34 5 98 black 94430 MEEKATHARRA AIR AUSTRALIA -26.600 118.533 518 5 98 black 94578 BRISBANE AIRPOR AUSTRALIA -27.383 153.100 5 5 98 black 94637 KALGOORLIE BOUL AUSTRALIA -30.783 121.450 370 5 98 black 94638 ESPERANCE AUSTRALIA -33.817 121.883 26 5 98 black 94647 EUCLA AMO AUSTRALIA -31.683 128.900 102 5 95 black 94672 ADELAIDE AIRPOR AUSTRALIA -34.933 138.517 4 5 97 black 94711 COBAR AUSTRALIA -31.483 145.817 265 5 97 black 94776 WILLIAMTOWN AER AUSTRALIA -32.783 151.817 8 5 97 black 94802 ALBANY AIRPORT AUSTRALIA -34.933 117.800 69 5 98 black 94821 MOUNT GAMBIER A AUSTRALIA -37.733 140.783 69 5 98 black 94910 WAGGA AIRPORT AUSTRALIA -35.150 147.450 213 5 98 black 95527 MOREE MO AUSTRALIA -29.483 149.833 214 5 98 black 96413 KUCHING SABAH & SA 1.483 110.333 27 5 100 black 96441 BINTULU SABAH & SA 3.200 113.033 5 5 100 black 96481 TAWAU SABAH & SA 4.267 117.883 20 5 100 black 166 rows selected. SQL> SPOOL OFF