-- phpMyAdmin SQL Dump
-- version 2.11.9.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 06. Januar 2009 um 14:48
-- Server Version: 5.0.67
-- PHP-Version: 5.2.6

SET FOREIGN_KEY_CHECKS=0;

SET AUTOCOMMIT=0;
START TRANSACTION;

--
-- Datenbank: `db_afu`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tbl_dxcc`
--
-- Erzeugt am: 31. Dezember 2008 um 15:24
--

DROP TABLE IF EXISTS `tbl_dxcc`;
CREATE TABLE IF NOT EXISTS `tbl_dxcc` (
  `dx_id` int(11) NOT NULL auto_increment,
  `dx_praefix` varchar(10) binary NOT NULL,
  `dx_land` varchar(50) binary NOT NULL,
  `dx_kont` varchar(5) binary NOT NULL,
  `itu_z` tinyint(4) NOT NULL,
  `cq_z` tinyint(4) NOT NULL,
  `utc_offset` varchar(3) binary NOT NULL,
  `dx_lat` varchar(4) binary NOT NULL,
  `dx_long` varchar(4) binary NOT NULL,
  `status` char(1) binary default NULL,
  PRIMARY KEY  (`dx_id`)
) TYPE=InnoDB  AUTO_INCREMENT=395 ;

--
-- Daten für Tabelle `tbl_dxcc`
--

INSERT DELAYED IGNORE INTO `tbl_dxcc` (`dx_id`, `dx_praefix`, `dx_land`, `dx_kont`, `itu_z`, `cq_z`, `utc_offset`, `dx_lat`, `dx_long`, `status`) VALUES
(1, '1A', 'Malta', 'Eu', 28, 15, '1', '42N', '13E', 'A'),
(2, '1M(del)', 'Minerva Reef', 'Oc', 62, 32, '-12', '24S', '179W', 'I'),
(3, '1S', 'Spratly Is', 'As', 50, 26, '7', '9N', '112E', 'A'),
(4, '3A', 'Monaco', 'Eu', 27, 14, '1', '44N', '8E', 'A'),
(5, '3B6', 'Agalega & St Brandon', 'Af', 53, 39, '4', '10S', '57E', 'A'),
(6, '3B8', 'Mauritius', 'Af', 53, 39, '4', '20S', '58E', 'A'),
(7, '3B9', 'Rodriguez Is', 'Af', 53, 39, '4', '20S', '63E', 'A'),
(8, '3C', 'Equatorial Guinea', 'Af', 47, 36, '-1', '4N', '9E', 'A'),
(9, '3C0', 'Pagalu', 'Af', 52, 36, '-1', '1S', '6E', 'A'),
(10, '3D2', 'Conway Reef', 'Oc', 56, 32, '12', '22S', '175E', 'A'),
(11, '3D2', 'Fiji', 'Oc', 56, 32, '12', '18S', '178E', 'A'),
(12, '3D2', 'Rotuma', 'Oc', 56, 32, '12', '13S', '177E', 'A'),
(13, '3DA', 'Swaziland', 'Af', 57, 38, '2', '26S', '31E', 'A'),
(14, '3V', 'Tunisia', 'Af', 37, 33, '1', '37N', '10E', 'A'),
(15, '3W', 'Vietnam', 'As', 49, 26, '7', '11N', '107E', 'A'),
(16, '3X', 'Guinea', 'Af', 46, 35, '0', '10N', '14W', 'A'),
(17, '3Y', 'Bouvet', 'Af', 67, 38, '0', '54S', '3E', 'A'),
(18, '3Y', 'Peter I', 'An', 72, 12, '-6', '69S', '91W', 'A'),
(19, '4J', 'Azerbaijan', 'As', 29, 21, '4', '40N', '50E', 'A'),
(20, '4L', 'Georgia', 'As', 29, 21, '4', '42N', '45E', 'A'),
(21, '4S', 'Sri Lanka', 'As', 41, 22, '+5.', '7N', '80E', 'A'),
(22, '4U', 'ITU Geneva', 'Eu', 28, 14, '1', '46N', '6E', 'A'),
(23, '4U', 'UN HQ', 'NA', 8, 5, '-5', '41N', '74W', 'A'),
(24, '4W', 'East Timor (UNTAET)', 'Oc', 54, 28, '8', '9S', '126E', 'A'),
(25, '4W(del)', 'Yemen Arab Rep', 'As', 39, 21, '3', '15N', '44E', 'I'),
(26, '4X', 'Israel', 'As', 39, 20, '2', '32N', '35E', 'A'),
(27, '5A', 'Libya', 'Af', 38, 34, '2', '33N', '13E', 'A'),
(28, '5B', 'Cyprus', 'As', 39, 20, '3', '35N', '33E', 'A'),
(29, '5H', 'Tanzania', 'Af', 53, 37, '3', '7S', '39E', 'A'),
(30, '5N', 'Nigeria', 'Af', 46, 35, '1', '6N', '3E', 'A'),
(31, '5R', 'Madagascar', 'Af', 53, 39, '3', '19S', '48E', 'A'),
(32, '5T', 'Mauritania', 'Af', 46, 35, '-1', '18N', '16W', 'A'),
(33, '5U', 'Niger', 'Af', 46, 35, '1', '14N', '2W', 'A'),
(34, '5V', 'Togo', 'Af', 46, 35, '0', '6N', '1E', 'A'),
(35, '5W', 'Samoa', 'Oc', 62, 32, '-11', '14S', '172W', 'A'),
(36, '5X', 'Uganda', 'Af', 48, 37, '3', '0N', '33E', 'A'),
(37, '5Z', 'Kenya', 'Af', 48, 37, '3', '2S', '37E', 'A'),
(38, '6W', 'Senegal', 'Af', 46, 35, '0', '15N', '18W', 'A'),
(39, '6Y', 'Jamaica', 'NA', 11, 8, '-5', '18N', '77W', 'A'),
(40, '7O', 'Yemen', 'As', 39, 21, '3', '13N', '45E', 'A'),
(41, '7O(del)', 'PDR Yemen', 'As', 39, 21, '3', '13N', '45E', 'I'),
(42, '7P', 'Lesotho', 'Af', 57, 38, '2', '29S', '27E', 'A'),
(43, '7Q', 'Malawi', 'Af', 53, 37, '2', '14S', '34E', 'A'),
(44, '7X', 'Algeria', 'Af', 37, 33, '0', '37N', '3E', 'A'),
(45, '8P', 'Barbados', 'NA', 11, 8, '-4', '13N', '60W', 'A'),
(46, '8Q', 'Maldives', 'As, A', 41, 22, '5', '4N', '73E', 'A'),
(47, '8R', 'Guyana', 'SA', 12, 9, '-3.', '6N', '58W', 'A'),
(48, '8Z4(del)', 'S Arabia/Iraq NZ', 'As', 39, 21, '3', '29N', '46E', 'I'),
(49, '8Z5(del)', 'Kuwait/S Arabia NZ', 'As', 39, 21, '3', '29N', '48E', 'I'),
(50, '9A', 'Croatia', 'Eu', 28, 15, '1', '46N', '16E', 'A'),
(51, '9G', 'Ghana', 'Af', 46, 35, '0', '5N', '0W', 'A'),
(52, '9H', 'Malta', 'Eu', 28, 15, '1', '36N', '15E', 'A'),
(53, '9J', 'Zambia', 'Af', 53, 36, '2', '15S', '28E', 'A'),
(54, '9K', 'Kuwait', 'As', 39, 21, '3', '29N', '48E', 'A'),
(55, '9L', 'Sierra Leone', 'Af', 46, 35, '0', '9N', '13W', 'A'),
(56, '9M2', 'Malaysia', 'As', 54, 28, '+7.', '3N', '102E', 'A'),
(57, '9M6', 'East Malaysia', 'Oc', 54, 28, '8', '2N', '110E', 'A'),
(58, '9N', 'Nepal', 'As', 42, 22, '+5.', '28N', '85E', 'A'),
(59, '9Q', 'Dem Rep Congo (Zaire)', 'Af', 52, 36, '1', '4S', '15E', 'A'),
(60, '9S4(del)', 'Saar', 'Eu', 28, 14, '1', '49N', '7E', 'I'),
(61, '9U', 'Burundi', 'Af', 52, 36, '3', '3S', '29E', 'A'),
(62, '9U5(del)', 'Ruanda-Urundi', 'Af', 52, 36, '3', '3S', '30E', 'I'),
(63, '9V', 'Singapore', 'As', 54, 28, '+7.', '1N', '104E', 'A'),
(64, '9X', 'Rwanda', 'Af', 52, 36, '3', '2S', '30E', 'A'),
(65, '9Y', 'Trinidad & Tobago', 'SA', 11, 9, '-4', '11N', '62W', 'A'),
(66, 'A1(del)', 'Abu Ail, Jabal at Tair', 'As', 39, 21, '2', '14N', '43E', 'I'),
(67, 'A2', 'Botswana', 'Af', 57, 38, '2', '25S', '26E', 'A'),
(68, 'A3', 'Tonga', 'Oc', 62, 32, '13', '21S', '175W', 'A'),
(69, 'A4', 'Oman', 'As', 39, 21, '4', '24N', '59E', 'A'),
(70, 'A5', 'Bhutan', 'As', 41, 22, '+5.', '28N', '90E', 'A'),
(71, 'A6', 'United Arab Emirates', 'As', 39, 21, '4', '24N', '54E', 'A'),
(72, 'A7', 'Qatar', 'As', 39, 21, '4', '25N', '52E', 'A'),
(73, 'A9', 'Bahrain', 'As', 39, 21, '4', '26N', '51E', 'A'),
(74, 'AC3(del)', 'Sikkim', 'As', 41, 22, '+5.', '27N', '89E', 'I'),
(75, 'AC4(del)', 'Tibet', 'As', 41, 23, '6', '30N', '92E', 'I'),
(76, 'AP', 'Pakistan', 'As', 41, 21, '5', '34N', '73E', 'A'),
(77, 'BS7', 'Scarborough Reef', 'As', 50, 27, '8', '15N', '118E', 'A'),
(78, 'BV', 'Taiwan', 'As', 44, 24, '8', '25N', '122E', 'A'),
(79, 'BV9', 'Pratas Is', 'As', 44, 24, '8', '21N', '116E', 'A'),
(80, 'BY', 'China', 'As', 33, 23, '8', '40N', '116E', 'A'),
(81, 'C2', 'Nauru', 'Oc', 65, 31, '+11', '1S', '167E', 'A'),
(82, 'C3', 'Andorra', 'Eu', 27, 14, '1', '43N', '2E', 'A'),
(83, 'C5', 'Gambia', 'Af', 46, 35, '0', '13N', '17W', 'A'),
(84, 'C6', 'Bahamas', 'NA', 11, 8, '-5', '25N', '77W', 'A'),
(85, 'C9', 'Mozambique', 'Af', 53, 37, '2', '26S', '33E', 'A'),
(86, 'C9(del)', 'Manchuria', 'As', 33, 24, '+8.', '46N', '127E', 'I'),
(87, 'CE', 'Chile', 'SA', 14, 12, '-4', '33S', '71W', 'A'),
(88, 'CE0X', 'San Felix', 'SA', 14, 12, '-5', '26S', '80W', 'A'),
(89, 'CE0Y', 'Easter Is', 'SA', 63, 12, '-7', '27S', '109W', 'A'),
(90, 'CE0Z', 'Juan Fernandez', 'SA', 14, 12, '-4', '34S', '79W', 'A'),
(91, 'CE9', 'Antarctica', 'An', 67, 12, '0', '90S', '0W', 'A'),
(92, 'CN', 'Morocco', 'Af', 37, 33, '0', '34N', '7W', 'A'),
(93, 'CN2(del)', 'Tangier', 'Af', 37, 33, '0', '36N', '8W', 'I'),
(94, 'CO', 'Cuba', 'NA', 11, 8, '-5', '23N', '82W', 'A'),
(95, 'CP', 'Bolivia', 'SA', 12, 10, '-4', '17S', '68W', 'A'),
(96, 'CR8(del)', 'Damao, Diu', 'As', 41, 22, '+5.', '21N', '71E', 'I'),
(97, 'CR8(del)', 'Goa', 'As', 41, 22, '+5.', '16N', '74E', 'I'),
(98, 'CR8(del)', 'Portuguese Timor', 'Oc', 54, 28, '8', '9S', '126E', 'I'),
(99, 'CT', 'Portugal', 'Eu', 37, 14, '0', '39N', '9W', 'A'),
(100, 'CT3', 'Madeira Is', 'Af', 36, 33, '-1', '33N', '17W', 'A'),
(101, 'CU', 'Azores', 'Eu', 36, 14, '-1', '38N', '26W', 'A'),
(102, 'CX', 'Uruguay', 'SA', 14, 13, '-3', '35S', '56W', 'A'),
(103, 'CY0', 'Sable Is', 'NA', 9, 5, '-5', '44N', '60W', 'A'),
(104, 'CY9', 'St Paul Is', 'NA', 9, 5, '-5', '47N', '60W', 'A'),
(105, 'D2', 'Angola', 'Af', 52, 36, '1', '9S', '13E', 'A'),
(106, 'D4', 'Cape Verde', 'Af', 46, 35, '-2', '15N', '23W', 'A'),
(107, 'D6', 'Comoros', 'Af', 53, 39, '3', '12S', '43E', 'A'),
(108, 'DL', 'Germany', 'Eu', 28, 14, '1', '53N', '13E', 'A'),
(109, 'DL(del)', 'Germany', 'Eu', 28, 14, '1', '52N', '7E', 'I'),
(110, 'DU', 'Philippines', 'Oc', 50, 27, '8', '15N', '121E', 'A'),
(111, 'E3', 'Eritrea', 'Af', 48, 37, '3', '15N', '39E', 'A'),
(112, 'E4', 'Palestine', 'As', 39, 20, '2', '32N', '34E', 'A'),
(113, 'EA', 'Spain', 'Eu', 37, 14, '1', '40N', '4W', 'A'),
(114, 'EA6', 'Balearic Is', 'Eu', 37, 14, '1', '38N', '3E', 'A'),
(115, 'EA8', 'Canary Is', 'Af', 36, 33, '0', '28N', '15W', 'A'),
(116, 'EA9', 'Ceuta & Melilla', 'Af', 37, 33, '1', '36N', '5W', 'A'),
(117, 'EA9(del)', 'Ifni', 'Af', 37, 33, '0', '29N', '10W', 'I'),
(118, 'EI', 'Ireland', 'Eu', 27, 14, '0', '53N', '6W', 'A'),
(119, 'EK', 'Armenia', 'As', 29, 21, '4', '40N', '45E', 'A'),
(120, 'EL', 'Liberia', 'Af', 46, 35, '-0.', '6N', '11W', 'A'),
(121, 'EP', 'Iran', 'As', 40, 21, '+3.', '36N', '51E', 'A'),
(122, 'ER', 'Moldova', 'Eu', 29, 16, '3', '47N', '29E', 'A'),
(123, 'ES', 'Estonia', 'Eu', 29, 15, '2', '59N', '25E', 'A'),
(124, 'ET', 'Ethiopia', 'Af', 48, 37, '3', '9N', '39E', 'A'),
(125, 'EV', 'Belarus', 'Eu', 29, 16, '2', '54N', '28E', 'A'),
(126, 'EX', 'Kyrgyzstan', 'As', 30, 17, '6', '43N', '75E', 'A'),
(127, 'EY', 'Tajikistan', 'As', 30, 17, '6', '39N', '69E', 'A'),
(128, 'EZ', 'Turkmenistan', 'As', 30, 17, '5', '38N', '58E', 'A'),
(129, 'F', 'France', 'Eu', 27, 14, '1', '49N', '2E', 'A'),
(130, 'FF(del)', 'French W Africa', 'Af', 46, 35, '0', '15N', '18W', 'I'),
(131, 'FG', 'Guadeloupe', 'NA', 11, 8, '-4', '16N', '62W', 'A'),
(132, 'FH', 'Mayotte', 'Af', 53, 39, '3', '13S', '45E', 'A'),
(133, 'FH(del)', 'Comoros', 'Af', 53, 39, '3', '12S', '43E', 'I'),
(134, 'FI8(del)', 'Fr Indo China', 'As', 49, 26, '7', '11N', '107E', 'I'),
(135, 'FK', 'Chesterfield Is', 'Oc', 55, 30, '11', '20S', '158E', 'A'),
(136, 'FK', 'New Caledonia', 'Oc', 56, 32, '11', '22S', '167E', 'A'),
(137, 'FM', 'Martinique', 'NA', 11, 8, '-4', '15N', '61W', 'A'),
(138, 'FN8(del)', 'French India', 'As', 41, 22, '+5.', '12N', '80E', 'I'),
(139, 'FO', 'French Polynesia', 'Oc', 63, 32, '-10', '18S', '150W', 'A'),
(140, 'FO0', 'Austral Is', 'Oc', 63, 32, '-10', '23S', '149W', 'A'),
(141, 'FO0', 'Clipperton Is', 'NA', 10, 7, '-7', '10N', '109W', 'A'),
(142, 'FO0', 'Marquesas Is', 'Oc', 63, 31, '-10', '9S', '140W', 'A'),
(143, 'FP', 'St Pierre & Miquelon', 'NA', 9, 5, '-4', '47N', '56W', 'A'),
(144, 'FQ8(del)', 'Fr Equatorial Africa', 'Af', 47, 36, '1', '5N', '18E', 'I'),
(145, 'FR', 'Reunion', 'Af', 53, 39, '4', '21S', '55E', 'A'),
(146, 'FR/G', 'Glorioso Is', 'Af', 53, 39, '3', '12S', '47E', 'A'),
(147, 'FR/J', 'Juan de Nova, Europa', 'Af', 53, 39, '3', '17S', '43E', 'A'),
(148, 'FR/T', 'Tromelin', 'Af', 53, 39, '4', '16S', '54E', 'A'),
(149, 'FS', 'St Martin', 'NA', 11, 8, '-4', '18N', '63W', 'A'),
(150, 'FT_W', 'Crozet', 'Af', 68, 39, '3', '46S', '52E', 'A'),
(151, 'FT_X', 'Kerguelen Is', 'Af', 68, 39, '5', '50S', '70E', 'A'),
(152, 'FT_Z', 'Amsterdam & St Paul Is', 'Af', 68, 39, '5', '38S', '78E', 'A'),
(153, 'FW', 'Wallis & Futuna Is', 'Oc', 62, 32, '-10', '14S', '172W', 'A'),
(154, 'FY', 'French Guiana', 'SA', 12, 9, '-4', '5N', '52W', 'A'),
(155, 'G', 'England', 'Eu', 27, 14, '0', '52N', '0W', 'A'),
(156, 'GD', 'Isle of Man', 'Eu', 27, 14, '0', '54N', '4W', 'A'),
(157, 'GI', 'No Ireland', 'Eu', 27, 14, '0', '55N', '6W', 'A'),
(158, 'GJ', 'Jersey', 'Eu', 27, 14, '0', '49N', '2W', 'A'),
(159, 'GM', 'Scotland', 'Eu', 27, 14, '0', '57N', '2W', 'A'),
(160, 'GU', 'Guernsey', 'Eu', 27, 14, '0', '49N', '3W', 'A'),
(161, 'GW', 'Wales', 'Eu', 27, 14, '0', '52N', '3W', 'A'),
(162, 'H4', 'Solomon Is', 'Oc', 51, 28, '11', '9S', '160E', 'A'),
(163, 'H40', 'Temotu', 'Oc', 51, 28, '11', '11S', '166E', 'A'),
(164, 'HA', 'Hungary', 'Eu', 28, 15, '1', '48N', '19E', 'A'),
(165, 'HB', 'Switzerland', 'Eu', 28, 14, '1', '47N', '7E', 'A'),
(166, 'HB0', 'Liechtenstein', 'Eu', 28, 14, '1', '47N', '10E', 'A'),
(167, 'HC', 'Ecuador', 'SA', 12, 10, '-5', '0N', '79W', 'A'),
(168, 'HC8', 'Galapagos Is', 'SA', 12, 10, '-6', '1S', '90W', 'A'),
(169, 'HH', 'Haiti', 'NA', 11, 8, '-5', '19N', '72W', 'A'),
(170, 'HI', 'Dominican Rep', 'NA', 11, 8, '-5', '18N', '70W', 'A'),
(171, 'HK', 'Colombia', 'SA', 12, 9, '-5', '5N', '74W', 'A'),
(172, 'HK0', 'Malpelo Is', 'SA', 12, 9, '-5', '4N', '82W', 'A'),
(173, 'HK0', 'San Andres & Providencia', 'NA', 11, 7, '-6', '13N', '82W', 'A'),
(174, 'HK0(del)', 'Bajo Nuevo', 'NA', 11, 8, '-5', '16N', '79W', 'I'),
(175, 'HK0(del)', 'Serrana Bnk, Roncador Cay', 'NA', 11, 7, '-5', '14N', '80W', 'I'),
(176, 'HL', 'So Korea', 'As', 44, 25, '9', '38N', '127E', 'A'),
(177, 'HP', 'Panama', 'NA', 11, 7, '-5', '9N', '80W', 'A'),
(178, 'HR', 'Honduras', 'NA', 11, 7, '-6', '14N', '87W', 'A'),
(179, 'HS', 'Thailand', 'As', 49, 26, '7', '14N', '101E', 'A'),
(180, 'HV', 'Vatican', 'Eu', 28, 15, '1', '42N', '13E', 'A'),
(181, 'HZ', 'Saudi Arabia', 'As', 39, 21, '3', '25N', '47E', 'A'),
(182, 'I', 'Italy', 'Eu, A', 28, 15, '1', '42N', '12E', 'A'),
(183, 'I1(del)', 'Trieste', 'Eu', 28, 15, '1', '46N', '14E', 'I'),
(184, 'I5(del)', 'Ital Somaliland', 'Af', 48, 37, '3', '2N', '46E', 'I'),
(185, 'IS', 'Sardinia', 'Eu', 28, 15, '1', '39N', '9E', 'A'),
(186, 'J2', 'Djibouti', 'Af', 48, 37, '3', '12N', '43E', 'A'),
(187, 'J3', 'Grenada', 'NA', 11, 8, '-4', '12N', '62W', 'A'),
(188, 'J5', 'Guinea-Bissau', 'Af', 46, 35, '-1', '12N', '16W', 'A'),
(189, 'J6', 'St Lucia', 'NA', 11, 8, '-4', '14N', '61W', 'A'),
(190, 'J7', 'Dominica', 'NA', 11, 8, '-4', '15N', '61W', 'A'),
(191, 'J8', 'St Vincent', 'NA', 11, 8, '-4', '13N', '61W', 'A'),
(192, 'JA', 'Japan', 'As', 45, 25, '9', '36N', '140E', 'A'),
(193, 'JD', 'Minami Torishima', 'Oc', 45, 27, '10', '24N', '154E', 'A'),
(194, 'JD', 'Ogasawara', 'As', 45, 27, '10', '28N', '142E', 'A'),
(195, 'JD1(del)', 'Okino Tori-shima', 'As', 45, 27, '10', '30N', '140E', 'I'),
(196, 'JT', 'Mongolia', 'As', 32, 23, '+7.', '48N', '107E', 'A'),
(197, 'JW', 'Svalbard', 'Eu', 18, 40, '1', '78N', '16E', 'A'),
(198, 'JX', 'Jan Mayen', 'Eu', 18, 40, '-1', '71N', '9W', 'A'),
(199, 'JY', 'Jordan', 'As', 39, 20, '2', '32N', '36E', 'A'),
(200, 'JZ0(del)', 'Neth New Guinea', 'Oc', 51, 28, '10', '10S', '147E', 'I'),
(201, 'K', 'United States', 'NA', 6, 3, '-5', '39N', '77W', 'A'),
(202, 'KG4', 'Guantanamo Bay', 'NA', 11, 8, '-5', '20N', '75W', 'A'),
(203, 'KH0', 'Mariana Is', 'Oc', 64, 27, '10', '15N', '146E', 'A'),
(204, 'KH1', 'Baker & Howland Is', 'Oc', 61, 31, '-12', '0N', '176W', 'A'),
(205, 'KH2', 'Guam', 'Oc', 64, 27, '10', '13N', '145E', 'A'),
(206, 'KH3', 'Johnston Is', 'Oc', 61, 31, '-11', '17N', '170W', 'A'),
(207, 'KH4', 'Midway Is', 'Oc', 61, 31, '-11', '28N', '177W', 'A'),
(208, 'KH5', 'Palmyra, Jarvis Is', 'Oc', 61, 31, '-11', '6N', '162W', 'A'),
(209, 'KH5K', 'Kingman Reef', 'Oc', 61, 31, '-11', '6N', '162W', 'A'),
(210, 'KH6', 'Hawaii', 'Oc', 61, 31, '-10', '21N', '158W', 'A'),
(211, 'KH7K', 'Kure Is', 'Oc', 61, 31, '-11', '29N', '178W', 'A'),
(212, 'KH8', 'Am Samoa', 'Oc', 62, 32, '-11', '14S', '171W', 'A'),
(213, 'KH9', 'Wake Is', 'Oc', 65, 31, '12', '19N', '167E', 'A'),
(214, 'KL', 'Alaska', 'NA', 1, 1, '-8', '58N', '134W', 'A'),
(215, 'KP1', 'Navassa Is', 'NA', 11, 8, '-5', '18N', '75W', 'A'),
(216, 'KP2', 'Virgin Is', 'NA', 11, 8, '-4', '18N', '65W', 'A'),
(217, 'KP4', 'Puerto Rico', 'NA', 11, 8, '-4', '18N', '66W', 'A'),
(218, 'KP5', 'Desecheo Is', 'NA', 11, 8, '-4', '18N', '68W', 'A'),
(219, 'KR6(del)', 'Okinawa (Ryukyu)', 'As', 45, 25, '8', '26N', '128E', 'I'),
(220, 'KS4(del)', 'Swan Is', 'NA', 11, 7, '-6', '17N', '84W', 'I'),
(221, 'KZ5(del)', 'Canal Zone', 'NA', 11, 7, '-5', '9N', '80W', 'I'),
(222, 'LA', 'Norway', 'Eu', 18, 14, '1', '60N', '11E', 'A'),
(223, 'LU', 'Argentina', 'SA', 14, 13, '-3', '35S', '58W', 'A'),
(224, 'LX', 'Luxembourg', 'Eu', 27, 14, '1', '50N', '6E', 'A'),
(225, 'LY', 'Lithuania', 'Eu', 29, 15, '2', '55N', '25E', 'A'),
(226, 'LZ', 'Bulgaria', 'Eu', 28, 20, '2', '43N', '23E', 'A'),
(227, 'OA', 'Peru', 'SA', 12, 10, '-5', '12S', '78W', 'A'),
(228, 'OD', 'Lebanon', 'As', 39, 20, '2', '34N', '36E', 'A'),
(229, 'OE', 'Austria', 'Eu', 28, 15, '1', '48N', '16E', 'A'),
(230, 'OH', 'Finland', 'Eu', 18, 15, '2', '60N', '25E', 'A'),
(231, 'OH0', 'Aland Is', 'Eu', 18, 15, '2', '60N', '20E', 'A'),
(232, 'OJ0', 'Market Reef', 'Eu', 18, 15, '2', '60N', '19E', 'A'),
(233, 'OK', 'Czech Republic', 'Eu', 28, 15, '1', '50N', '15E', 'A'),
(234, 'OK(del)', 'Czechoslovakia', 'Eu', 28, 15, '1', '50N', '15E', 'I'),
(235, 'OM', 'Slovakia', 'Eu', 28, 15, '1', '48N', '17E', 'A'),
(236, 'ON', 'Belgium', 'Eu', 27, 14, '1', '51N', '4E', 'A'),
(237, 'OX', 'Greenland', 'NA', 5, 40, '-3', '64N', '52W', 'A'),
(238, 'OY', 'Faroe Is', 'Eu', 18, 14, '0', '62N', '7W', 'A'),
(239, 'OZ', 'Denmark', 'Eu', 18, 14, '1', '56N', '13E', 'A'),
(240, 'P2', 'Papua New Guinea', 'Oc', 51, 28, '10', '10S', '147E', 'A'),
(241, 'P2(del)', 'Papua Terr', 'Oc', 51, 28, '10', '10S', '147E', 'I'),
(242, 'P2(del)', 'Terr New Guinea', 'Oc', 51, 28, '10', '10S', '147E', 'I'),
(243, 'P4', 'Aruba', 'SA', 11, 9, '-4', '13N', '70W', 'A'),
(244, 'P5', 'No Korea', 'As', 44, 25, '9', '39N', '126E', 'A'),
(245, 'PA', 'Netherlands', 'Eu', 27, 14, '1', '52N', '5E', 'A'),
(246, 'PJ2', 'Neth Antilles', 'SA', 11, 9, '-4', '12N', '69W', 'A'),
(247, 'PJ5', 'St Maarten, Saba, St Eus', 'NA', 11, 8, '-4', '18N', '63W', 'A'),
(248, 'PK1(del)', 'Java', 'Oc', 54, 28, '+7.', '6S', '107E', 'I'),
(249, 'PK4(del)', 'Sumatra', 'Oc', 54, 28, '7', '1S', '100E', 'I'),
(250, 'PK5(del)', 'Netherlands Borneo', 'Oc', 54, 28, '8', '3S', '115E', 'I'),
(251, 'PK6(del)', 'Celebe & Molucca Is', 'Oc', 54, 28, '8', '5S', '119E', 'I'),
(252, 'PY', 'Brazil', 'SA', 12, 11, '-3', '16S', '48W', 'A'),
(253, 'PY0F', 'Fernando de Noronha', 'SA', 13, 11, '-2', '4S', '32W', 'A'),
(254, 'PY0P', 'St Peter & St Paul Rocks', 'SA', 13, 11, '-2', '1N', '29W', 'A'),
(255, 'PY0T', 'Trindade & Martin Vaz Is', 'SA', 15, 11, '-2', '21S', '29W', 'A'),
(256, 'PZ', 'Surinam', 'SA', 12, 9, '-3.', '6N', '55W', 'A'),
(257, 'R1FJ', 'Franz Josef Land', 'Eu', 75, 40, '3', '81N', '48E', 'A'),
(258, 'R1MV', 'Malyj Vysotskij Is', 'Eu', 29, 16, '3', '61N', '29E', 'A'),
(259, 'S0', 'Western Sahara', 'Af', 37, 33, '0', '27N', '13W', 'A'),
(260, 'S2', 'Bangladesh', 'As', 41, 22, '6', '24N', '90E', 'A'),
(261, 'S5', 'Slovenia', 'Eu', 28, 15, '1', '46N', '15E', 'A'),
(262, 'S7', 'Seychelles', 'Af', 53, 39, '4', '5S', '55E', 'A'),
(263, 'S9', 'Sao Tome & Principe', 'Af', 47, 36, '0', '0N', '7E', 'A'),
(264, 'SM', 'Sweden', 'Eu', 18, 14, '1', '59N', '18E', 'A'),
(265, 'SP', 'Poland', 'Eu', 28, 15, '1', '52N', '21E', 'A'),
(266, 'ST', 'Sudan', 'Af', 48, 34, '2', '16N', '33E', 'A'),
(267, 'ST0(del)', 'Southern Sudan', 'Af', 48, 34, '2', '5N', '32E', 'I'),
(268, 'SU', 'Egypt', 'Af, A', 38, 34, '2', '31N', '31E', 'A'),
(269, 'SV', 'Greece', 'Eu', 28, 20, '2', '38N', '24E', 'A'),
(270, 'SV5', 'Dodecanese', 'Eu', 28, 20, '2', '36N', '28E', 'A'),
(271, 'SV9', 'Crete', 'Eu', 28, 20, '2', '36N', '24E', 'A'),
(272, 'SY2', 'Mt Athos', 'Eu', 28, 20, '2', '40N', '24E', 'A'),
(273, 'T2', 'Tuvalu', 'Oc', 65, 31, '12', '9S', '179E', 'A'),
(274, 'T30', 'West Kiribati', 'Oc', 65, 31, '12', '1S', '173E', 'A'),
(275, 'T31', 'Central Kiribati', 'Oc', 62, 31, '12', '4S', '171W', 'A'),
(276, 'T32', 'East Kiribati', 'Oc', 61, 31, '12', '2N', '158W', 'A'),
(277, 'T33', 'Banaba', 'Oc', 65, 31, '+11', '1S', '170E', 'A'),
(278, 'T5', 'Somalia', 'Af', 48, 37, '3', '2N', '46E', 'A'),
(279, 'T7', 'San Marino', 'Eu', 28, 15, '1', '44N', '12E', 'A'),
(280, 'T8', 'Palau', 'Oc', 64, 27, '10', '7N', '134E', 'A'),
(281, 'T9', 'Bosnia-Hercegovina', 'Eu', 28, 15, '1', '44N', '18E', 'A'),
(282, 'TA', 'Turkey', 'As, E', 39, 20, '2', '40N', '33E', 'A'),
(283, 'TF', 'Iceland', 'Eu', 17, 40, '0', '64N', '22W', 'A'),
(284, 'TG', 'Guatemala', 'NA', 11, 7, '-6', '16N', '92W', 'A'),
(285, 'TI', 'Costa Rica', 'NA', 11, 7, '-6', '10N', '84W', 'A'),
(286, 'TI9', 'Cocos Is', 'NA', 11, 7, '-6', '6N', '87W', 'A'),
(287, 'TJ', 'Cameroon', 'Af', 47, 36, '1', '4N', '12E', 'A'),
(288, 'TK', 'Corsica', 'Eu', 28, 15, '1', '42N', '9E', 'A'),
(289, 'TL', 'Central African Rep', 'Af', 47, 36, '1', '5N', '19E', 'A'),
(290, 'TN', 'Congo', 'Af', 52, 36, '1', '4S', '15E', 'A'),
(291, 'TR', 'Gabon', 'Af', 52, 36, '1', '1N', '10E', 'A'),
(292, 'TT', 'Chad', 'Af', 47, 36, '1', '12N', '15E', 'A'),
(293, 'TU', 'Ivory Coast', 'Af', 46, 35, '0', '7N', '5W', 'A'),
(294, 'TY', 'Benin', 'Af', 46, 35, '0', '6N', '3E', 'A'),
(295, 'TZ', 'Mali', 'Af', 46, 35, '0', '13N', '8W', 'A'),
(296, 'UA', 'Russia', 'Eu', 19, 16, '3', '56N', '37E', 'A'),
(297, 'UA2', 'Kaliningrad', 'Eu', 29, 15, '2', '55N', '21E', 'A'),
(298, 'UA9', 'Russia (Asiatic)', 'As', 20, 16, '7', '52N', '104E', 'A'),
(299, 'UK', 'Uzbekistan', 'As', 30, 17, '6', '41N', '69E', 'A'),
(300, 'UN', 'Kazakhstan', 'As', 29, 17, '+5.', '43N', '77E', 'A'),
(301, 'UN1(del)', 'Karelo-Finnish Rep', 'Eu', 19, 16, '3', '64N', '32E', 'I'),
(302, 'UR', 'Ukraine', 'Eu', 29, 16, '2', '50N', '30E', 'A'),
(303, 'V2', 'Antigua, Barbuda', 'NA', 11, 8, '-4', '17N', '62W', 'A'),
(304, 'V3', 'Belize', 'NA', 11, 7, '-5.', '17N', '89W', 'A'),
(305, 'V4', 'St Kitts, Nevis', 'NA', 11, 8, '-4', '17N', '63W', 'A'),
(306, 'V5', 'Namibia', 'Af', 57, 38, '2', '22S', '17E', 'A'),
(307, 'V6', 'Micronesia', 'Oc', 65, 27, '11', '7N', '158E', 'A'),
(308, 'V7', 'Marshall Is', 'Oc', 65, 31, '12', '7N', '171E', 'A'),
(309, 'V8', 'Brunei', 'Oc', 54, 28, '8', '5N', '115E', 'A'),
(310, 'VE', 'Canada', 'NA', 2, 1, '-5', '45N', '76W', 'A'),
(311, 'VK', 'Australia', 'Oc', 55, 29, '10', '35S', '149E', 'A'),
(312, 'VK0', 'Heard Is', 'Af', 68, 39, '5', '53S', '73E', 'A'),
(313, 'VK0', 'Macquarie Is', 'Oc', 60, 30, '11', '54S', '159E', 'A'),
(314, 'VK9C', 'Cocos-Keeling Is', 'Oc', 54, 29, '+6.', '12S', '97E', 'A'),
(315, 'VK9L', 'Lord Howe Is', 'Oc', 60, 30, '10', '31S', '159E', 'A'),
(316, 'VK9M', 'Mellish Reef', 'Oc', 55, 30, '10', '17S', '156E', 'A'),
(317, 'VK9N', 'Norfolk Is', 'Oc', 60, 32, '+11', '29S', '168E', 'A'),
(318, 'VK9W', 'Willis Is', 'Oc', 55, 30, '10', '16S', '150E', 'A'),
(319, 'VK9X', 'Christmas Is', 'Oc', 54, 29, '7', '10S', '106E', 'A'),
(320, 'VO(del)', 'Newfoundland, Labrador', 'NA', 9, 2, '-3.', '48N', '53W', 'I'),
(321, 'VP2E', 'Anguilla', 'NA', 11, 8, '-4', '18N', '63W', 'A'),
(322, 'VP2M', 'Montserrat', 'NA', 11, 8, '-4', '17N', '62W', 'A'),
(323, 'VP2V', 'Br Virgin Is', 'NA', 11, 8, '-4', '18N', '65W', 'A'),
(324, 'VP5', 'Turks & Caicos Is', 'NA', 11, 8, '-5', '22N', '71W', 'A'),
(325, 'VP6', 'Pitcairn Is', 'Oc', 63, 32, '-8.', '25S', '128W', 'A'),
(326, 'VP6', 'Ducie Is', 'Oc', 63, 32, '-8.', '25S', '125W', 'A'),
(327, 'VP8', 'Falkland Is', 'SA', 16, 13, '-4', '52S', '58W', 'A'),
(328, 'VP8', 'So Georgia Is', 'SA', 73, 13, '-1.', '54S', '37W', 'A'),
(329, 'VP8', 'So Orkney Is', 'SA', 73, 13, '-3', '61S', '45W', 'A'),
(330, 'VP8', 'So Sandwich Is', 'SA', 73, 13, '-3', '59S', '27W', 'A'),
(331, 'VP8', 'So Shetland Is', 'SA', 73, 13, '-4', '62S', '58W', 'A'),
(332, 'VP9', 'Bermuda', 'NA', 11, 5, '-4', '32N', '65W', 'A'),
(333, 'VQ1(del)', 'Zanzibar', 'Af', 53, 37, '3', '7S', '39E', 'I'),
(334, 'VQ6(del)', 'British Somaliland', 'Af', 48, 37, '3', '2N', '46E', 'I'),
(335, 'VQ9', 'Chagos', 'Af', 41, 39, '5', '7S', '72E', 'A'),
(336, 'VQ9(del)', 'Aldabra', 'Af', 53, 39, '4', '9S', '46E', 'I'),
(337, 'VQ9(del)', 'Desroches', 'Af', 53, 39, '4', '6S', '55E', 'I'),
(338, 'VQ9(del)', 'Farquhar', 'Af', 53, 39, '4', '10S', '51E', 'I'),
(339, 'VR2', 'Hong Kong', 'As', 44, 24, '8', '22N', '114E', 'A'),
(340, 'VS2(del)', 'Malaya', 'As', 54, 28, '+7.', '3N', '102E', 'I'),
(341, 'VS4(del)', 'Sarawak', 'Oc', 54, 28, '8', '2N', '110E', 'I'),
(342, 'VS9H(del)', 'Kuria Muria Is', 'As', 39, 21, '4', '18N', '56E', 'I'),
(343, 'VS9K(del)', 'Kamaran Is', 'As', 39, 21, '3', '15N', '43E', 'I'),
(344, 'VU', 'India', 'As', 41, 22, '+5.', '29N', '77E', 'A'),
(345, 'VU4', 'Andaman & Nicobar Is', 'As', 49, 26, '+5.', '12N', '93E', 'A'),
(346, 'VU7', 'Lakshadweep Is', 'As', 41, 22, '+5.', '11N', '73E', 'A'),
(347, 'XE', 'Mexico', 'NA', 10, 6, '-6', '20N', '99W', 'A'),
(348, 'XF4', 'Revilla Gigedo', 'NA', 10, 6, '-7', '18N', '113W', 'A'),
(349, 'XT', 'Burkina Faso', 'Af', 46, 35, '0', '12N', '2W', 'A'),
(350, 'XU', 'Cambodia', 'As', 49, 26, '8', '12N', '105E', 'A'),
(351, 'XW', 'Laos', 'As', 49, 26, '7', '20N', '102E', 'A'),
(352, 'XX9', 'Macao', 'As', 44, 24, '8', '22N', '114E', 'A'),
(353, 'XZ', 'Myanmar (Burma)', 'As', 49, 26, '+6.', '17N', '96E', 'A'),
(354, 'Y2(del)', 'East Germany', 'Eu', 28, 14, '1', '53N', '13E', 'I'),
(355, 'YA', 'Afghanistan', 'As', 40, 21, '+4.', '35N', '69E', 'A'),
(356, 'YB', 'Indonesia', 'Oc', 51, 28, '+7.', '6S', '107E', 'A'),
(357, 'YI', 'Iraq', 'As', 39, 21, '3', '32N', '45E', 'A'),
(358, 'YJ', 'Vanuatu', 'Oc', 56, 32, '11', '18S', '168E', 'A'),
(359, 'YK', 'Syria', 'As', 39, 20, '2', '34N', '36E', 'A'),
(360, 'YL', 'Latvia', 'Eu', 29, 15, '2', '57N', '24E', 'A'),
(361, 'YN', 'Nicaragua', 'NA', 11, 7, '-6', '12N', '87W', 'A'),
(362, 'YO', 'Romania', 'Eu', 28, 20, '2', '45N', '26E', 'A'),
(363, 'YS', 'El Salvador', 'NA', 11, 7, '-6', '14N', '89W', 'A'),
(364, 'YU', 'Serbia & Montenegro', 'Eu', 28, 15, '1', '45N', '21E', 'A'),
(365, 'YV', 'Venezuela', 'SA', 12, 9, '-4', '10N', '67W', 'A'),
(366, 'YV0', 'Aves Is', 'NA', 11, 8, '-4', '16N', '64W', 'A'),
(367, 'Z2', 'Zimbabwe', 'Af', 53, 38, '2', '18S', '31E', 'A'),
(368, 'Z3', 'Macedonia', 'Eu', 28, 15, '1', '42N', '22E', 'A'),
(369, 'ZA', 'Albania', 'Eu', 28, 15, '1', '41N', '20E', 'A'),
(370, 'ZB', 'Gibraltar', 'Eu', 37, 14, '1', '37N', '5W', 'A'),
(371, 'ZC', 'Cyprus SBA', 'As', 39, 20, '2', '35N', '33E', 'A'),
(372, 'ZC5(del)', 'Br No Borneo', 'Oc', 54, 28, '8', '6N', '116E', 'I'),
(373, 'ZC6(del)', 'Palestine', 'As', 39, 20, '2', '32N', '35E', 'I'),
(374, 'ZD4(del)', 'Gold Coast, Togoland', 'Af', 46, 35, '0', '5N', '0W', 'I'),
(375, 'ZD7', 'St Helena', 'Af', 66, 36, '0', '16S', '6W', 'A'),
(376, 'ZD8', 'Ascension Is', 'Af', 66, 36, '0', '8S', '14W', 'A'),
(377, 'ZD9', 'Tristan da Cunha & Gough Is', 'Af', 66, 38, '0', '37S', '12W', 'A'),
(378, 'ZF', 'Cayman Is', 'NA', 11, 8, '-5', '19N', '81W', 'A'),
(379, 'ZK1', 'No Cook Is', 'Oc', 62, 32, '-10', '10S', '161W', 'A'),
(380, 'ZK1', 'So Cook Is', 'Oc', 63, 32, '-10', '22S', '158W', 'A'),
(381, 'ZK2', 'Niue', 'Oc', 62, 32, '-11', '19S', '170W', 'A'),
(382, 'ZK3', 'Tokelau Is', 'Oc', 62, 31, '-11', '9S', '171W', 'A'),
(383, 'ZL', 'New Zealand', 'Oc', 60, 32, '12', '41S', '175E', 'A'),
(384, 'ZL7', 'Chatham Is', 'Oc', 60, 32, '+12', '44S', '177W', 'A'),
(385, 'ZL8', 'Kermadec Is', 'Oc', 60, 32, '12', '29S', '178W', 'A'),
(386, 'ZL9', 'Auckland, Campbell Is', 'Oc', 60, 32, '12', '51S', '166E', 'A'),
(387, 'ZP', 'Paraguay', 'SA', 14, 11, '-4', '26S', '57W', 'A'),
(388, 'ZS', 'So Africa', 'Af', 57, 38, '2', '26S', '28E', 'A'),
(389, 'ZS0(del)', 'Penguin Is', 'Af', 57, 38, '2', '27S', '15E', 'I'),
(390, 'ZS8', 'Pr Edward & Marion Is', 'Af', 57, 38, '3', '47S', '38E', 'A'),
(391, 'ZS9(del)', 'Walvis Bay', 'Af', 57, 38, '2', '23S', '15E', 'I'),
(392, '(nv)(nv)(d', 'Blenheim Reef', 'Af', 41, 39, '5', '7S', '72E', 'A'),
(393, '(nv)(nv)(d', 'Geyser Reef', 'Af', 53, 39, '3', '12S', '46E', 'A');

SET FOREIGN_KEY_CHECKS=1;

COMMIT;