-- MySQL dump 10.13 Distrib 5.5.24, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: testdb -- ------------------------------------------------------ -- Server version 5.5.24-0ubuntu0.12.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `COUNTRY` -- DROP TABLE IF EXISTS `COUNTRY`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `COUNTRY` ( `countryId` int(11) NOT NULL DEFAULT '0', `regionId` int(11) NOT NULL, `iso` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `countryName` varchar(45) CHARACTER SET utf8 DEFAULT NULL, `lat` decimal(9,6) DEFAULT NULL, `lon` decimal(9,6) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `COUNTRY` -- LOCK TABLES `COUNTRY` WRITE; /*!40000 ALTER TABLE `COUNTRY` DISABLE KEYS */; INSERT INTO `COUNTRY` VALUES (1,10,'AF','Afghanistan',34.516700,69.133300),(2,2,'AO','Angola',-8.833330,13.333300),(3,11,'BF','Burkina Faso',12.333300,-1.666670),(4,8,'MM','Myanmar',19.750000,96.100000),(5,8,'KH','Cambodia',11.550000,104.917000),(6,2,'TD','Chad',12.100000,15.033300),(7,1,'CO','Colombia',4.650000,-74.050000),(8,2,'GA','Gabon',0.383333,9.450000),(9,13,'GB','United Kingdom',0.000000,51.500000),(10,11,'GM','Gambia',13.466700,-16.600000),(11,4,'KE','Kenya',-1.266670,36.800000),(12,8,'LA','Lao People\'s Democratic Republic',17.966700,102.600000),(13,11,'LR','Liberia',6.316670,-10.800000),(14,4,'MW','Malawi',-13.950000,33.700000),(15,4,'MZ','Mozambique',-25.969500,32.599700),(16,10,'PK','Pakistan',33.666700,73.166700),(17,1,'PE','Peru',-12.043300,-77.028300),(18,4,'RW','Rwanda',-1.950000,30.066700),(19,2,'ST','Sao Tome and Principe',0.336111,6.681390),(20,11,'SN','Senegal',14.666700,-17.416700),(21,11,'SL','Sierra Leone',8.516670,-13.250000),(22,9,'ZA','South Africa',-25.716700,28.283300),(23,7,'SD','Sudan',15.516700,32.583300),(24,8,'TH','Thailand',13.750000,100.483000),(25,4,'UG','Uganda',0.313611,32.581100),(26,8,'VN','Vietnam',21.033300,105.850000),(27,2,'CM','Cameroon',3.866670,11.516700),(28,11,'MR','Mauritania',18.150000,-15.966700),(29,11,'ML','Mali',12.650000,-8.000000),(30,11,'GH','Ghana',5.550000,-0.250000),(31,11,'NG','Nigeria',9.175830,7.167000),(32,2,'GQ','Equatorial Guinea',3.750000,8.783330),(33,2,'CD','Democratic Republic of Congo',-4.316670,15.316700),(34,2,'CF','Central African Republic',4.366670,18.583300),(35,4,'TZ','United Republic of Tanzania',-6.173060,35.741900),(36,4,'ET','Ethiopia',9.016670,38.733300),(37,11,'CI','Cote d Ivoire',6.850000,-5.300000),(38,7,'DZ','Algeria',36.700000,3.216670),(39,12,'AM','Armenia',40.183300,44.516700),(40,12,'AZ','Azerbaijan',40.366700,49.883300),(41,10,'BD','Bangladesh',23.700000,90.350000),(42,11,'BJ','Benin',6.466670,2.600000),(43,10,'BT','Bhutan',27.466700,89.641700),(44,1,'BO','Bolivia',-19.033300,-65.250000),(45,9,'BW','Botswana',-24.666700,25.916700),(46,1,'BR','Brazil',-15.750000,-47.950000),(47,4,'BI','Burundi',-3.500000,30.000000),(48,11,'CV','Cape Verde',14.916700,-23.516700),(49,5,'CN','China',39.913900,116.392000),(50,4,'KM','Comoros',-11.683300,43.266700),(51,2,'CG','Congo',-4.233330,15.233300),(52,4,'DJ','Djibouti',11.600000,43.166700),(53,1,'DO','Dominican Republic',19.000000,-70.666700),(54,1,'EC','Ecuador',-0.150000,-78.350000),(55,7,'EG','Egypt',30.033300,31.216700),(56,4,'ER','Eritrea',15.333300,38.916700),(57,1,'GF','French Guiana',4.922700,-52.326900),(58,13,'FR','France',2.338000,46.642000),(59,12,'GE','Georgia',41.716700,44.783300),(60,11,'GN','Guinea',9.516670,-13.700000),(61,11,'GW','Guinea-Bissau',11.866700,-15.600000),(62,1,'GY','Guyana',6.766670,-58.166700),(63,1,'HT','Haiti',18.533300,-72.333300),(64,10,'IN','India',28.566700,77.200000),(65,8,'ID','Indonesia',-6.175000,106.828000),(66,10,'IR','Iran',35.683300,51.416700),(67,12,'IQ','Iraq',33.333300,44.433300),(68,3,'KG','Kyrgyzstan',42.866700,74.600000),(69,4,'MG','Madagascar',-18.916700,47.516700),(70,8,'MY','Malaysia',3.133330,101.700000),(71,4,'YT','Mayotte',-12.780600,45.227800),(72,7,'MA','Morocco',34.033300,-6.850000),(73,9,'NA','Namibia',-22.550000,17.250000),(74,10,'NP','Nepal',27.700000,85.316700),(75,11,'NE','Niger',13.533300,2.083330),(76,13,'NL','Netherlands',4.478000,51.923000),(77,12,'OM','Oman',23.600000,58.550000),(78,6,'PG','Papua New Guinea',-9.500000,147.117000),(79,1,'PY','Paraguay',-25.266700,-57.666700),(80,8,'PH','Philippines',14.583300,121.000000),(81,12,'SA','Saudi Arabia',24.650000,46.766700),(82,6,'SB','Solomon Islands',-9.466670,159.817000),(83,4,'SO','Somalia',2.033330,45.350000),(84,10,'LK','Sri Lanka',6.900000,79.900000),(85,1,'SR','Suriname',5.833330,-55.166700),(86,9,'SZ','Swaziland',-26.316700,31.133300),(87,12,'SY','Syrian Arab Republic',33.500000,36.300000),(88,3,'TJ','Tajikistan',38.550000,68.800000),(89,8,'TL','Timor-Leste',-8.566670,125.567000),(90,11,'TG','Togo',6.116670,1.216670),(91,12,'TR','Turkey',39.916700,32.833300),(92,3,'TM','Turkmenistan',37.966700,58.333300),(93,6,'VU','Vanuatu',-17.750000,168.300000),(94,1,'VE','Venezuela',10.500000,-66.966700),(95,12,'YE','Yemen ',15.350000,44.200000),(96,4,'ZM','Zambia',-15.416700,28.283300),(97,4,'ZW','Zimbabwe',-17.833300,31.050000); /*!40000 ALTER TABLE `COUNTRY` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ch_sites` -- DROP TABLE IF EXISTS `ch_sites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ch_sites` ( `ch_sites_id` int(11) NOT NULL DEFAULT '0', `sid` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `Region` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `LookupAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `TestingDelay` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `SiteCode` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `Country` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `Anticoagulant` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `Locality` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `Longitude` decimal(20,17) DEFAULT NULL, `Latitude` decimal(20,17) DEFAULT NULL, `TransportAndStorageTemperature` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `District` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `Population` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ch_sites` -- LOCK TABLES `ch_sites` WRITE; /*!40000 ALTER TABLE `ch_sites` DISABLE KEYS */; INSERT INTO `ch_sites` VALUES (1,'RSRCF','KE-300',NULL,NULL,NULL,'KE',NULL,'Pingilikani',39.77300300000000000,-3.77472200000000000,NULL,'Kilifi','resident'),(2,'RGPFA','Bangkok',NULL,NULL,NULL,'TH',NULL,'Thung Phayathai',100.53143717447917000,13.75168457031250000,NULL,'Ratchathewi','resident'),(3,'KGJRP','Tak',NULL,NULL,NULL,'TH',NULL,'Mae la',98.36285502115880000,17.14535151089270000,NULL,'Tha Song Yang','resident'),(4,'KGJRP','Bangkok',NULL,NULL,NULL,'TH',NULL,'Thung PhayaThai',100.53143717447917000,13.75168457031250000,NULL,'Ratchathewi','resident'),(5,'MEFSC','Kintampo',NULL,NULL,'Ghana: Kintampo','GH',NULL,NULL,-1.72668009996414180,8.04715812206268300,NULL,NULL,'resident'),(6,'MEFSC','Bobo-Dioulasso',NULL,NULL,'Burkina Faso: Bobo-Dioula','BF',NULL,NULL,-4.29177093505859400,11.17810440063476600,NULL,NULL,'resident'),(7,'MEFSC','Kiwangwa',NULL,NULL,'Tanzania: Kiwangwa','TZ',NULL,NULL,38.58330154418945000,-6.36670017242431600,NULL,NULL,'resident'),(8,'MEFSC','Bagamoyo',NULL,NULL,'Tanzania: Bagamoyo','TZ',NULL,NULL,38.89960098266601600,-6.44577598571777300,NULL,NULL,'resident'),(9,'MEFSC',NULL,NULL,NULL,'Kenya: Eldoret','KE',NULL,NULL,35.26637268066406000,0.51523971557617190,NULL,'Eldoret','resident'),(10,'MEFSC',NULL,NULL,NULL,'Kenya: Kilifi','KE',NULL,NULL,39.85445404052734400,-3.61507034301757800,NULL,'Kilifi','resident'),(11,'MEFSC',NULL,NULL,NULL,'Kenya: Pinglikani','KE',NULL,NULL,39.78329849243164000,-3.78329992294311520,NULL,'Pingilikani','resident'),(12,'MEFSC','Ibadan',NULL,NULL,'Nigeria: Ibadan','NG',NULL,NULL,3.89527797698974600,7.37884092330932600,NULL,NULL,'resident'),(13,'MEFSC','Enugu',NULL,NULL,'Nigeria: Enugu','NG',NULL,NULL,7.49208021163940400,6.45053911209106450,NULL,NULL,'resident'),(14,'MEFSC','Jos',NULL,NULL,'Nigeria: Jos','NG',NULL,NULL,8.89338684082031200,9.92440032958984400,NULL,NULL,'resident'),(15,'MEFSC','Calabar',NULL,NULL,'Nigeria: Calabar','NG',NULL,NULL,8.31441497802734400,4.95729064941406250,NULL,NULL,'resident'),(16,'GPXJK',NULL,NULL,NULL,'bfnanoro','BF',NULL,NULL,-2.19137310981750500,12.68305206298828100,NULL,'Nanoro','resident'),(17,'GPXJK',NULL,NULL,NULL,'gafougam','GA',NULL,NULL,10.58401584625244100,-1.21685302257537840,NULL,'Fougamou','resident'),(18,'GPXJK',NULL,NULL,NULL,'galambar','GA',NULL,NULL,10.21175670623779300,-0.70590400695800780,NULL,'Lambarene','resident'),(19,'GPXJK',NULL,NULL,NULL,'ngakpap','NG',NULL,'Afokang',8.68330001831054700,9.46669960021972700,NULL,NULL,'resident'),(20,'GPXJK',NULL,NULL,NULL,'ngikot','NG',NULL,NULL,5.03330230712890600,8.28329849243164000,NULL,'Pamol','resident'),(21,'GPXJK',NULL,NULL,NULL,'rwmashes','RW',NULL,'Mashesha',29.92300033569336000,-2.00300002098083500,NULL,NULL,'resident'),(22,'GPXJK',NULL,NULL,NULL,'rwrukara','RW',NULL,NULL,29.83329963684082000,-1.68330001831054690,NULL,'Rukara','resident'),(23,'GPXJK',NULL,NULL,NULL,'ugjinja','UG',NULL,NULL,33.20307922363281000,0.43777465820312500,NULL,'Jinja','resident'),(24,'GPXJK',NULL,NULL,NULL,'ugtororo','UG',NULL,NULL,34.17296600341797000,0.70467799901962280,NULL,'Tororo','resident'),(25,'GPXJK',NULL,NULL,NULL,'ugmbarar','UG',NULL,NULL,30.64855194091797000,-0.60567474365234380,NULL,'Mbarara','resident'),(26,'GPXJK',NULL,NULL,NULL,'zmndola','ZM',NULL,NULL,28.63370323181152300,-12.96827411651611300,NULL,'Ndola','resident'),(27,'GPXJK',NULL,NULL,NULL,'mzmanhic','MZ',NULL,'Manhica',34.70000076293945000,-12.44999885559082000,NULL,NULL,'resident'),(28,'GPXJK',NULL,NULL,NULL,'mzmanhi2','MZ',NULL,'Manhica',34.70000076293945000,-12.44999885559082000,NULL,NULL,'resident'),(29,'HXXHM',NULL,NULL,NULL,'Fukayosi','TZ',NULL,'Fukayosi',38.50000000000000000,-6.33333000000000000,NULL,'Bagamoyo','resident'),(30,'HXXHM',NULL,NULL,NULL,'Yombo','TZ',NULL,'Yombo',38.84744262695312500,-6.58617019653320300,NULL,'Bagamoyo','resident'),(31,'GZQDA',NULL,NULL,NULL,'1','TZ',NULL,'Fukayosi',38.50000000000000000,-6.33333000000000000,NULL,'Bagamoyo','resident'),(32,'GZQDA',NULL,NULL,NULL,'2','TZ',NULL,'Yombo',38.84744262695312500,-6.58617019653320300,NULL,'Bagamoyo','resident'),(33,'PAYHM','Bissau',NULL,NULL,'Bandim','GW',NULL,'Bandim',-15.38329887390136700,11.33329963684082000,NULL,NULL,'resident'),(34,'QXXRG',NULL,NULL,NULL,'Mwanza','TZ',NULL,'Mwanza',32.89693832397461000,-2.52258992195129400,NULL,NULL,'resident'),(35,'RTFBM',NULL,NULL,NULL,'Jimma','ET',NULL,'Jimma',36.83844375610351600,7.67847776412963900,NULL,NULL,'resident'),(36,'SATNJ','Region du Sud-Comoe',NULL,NULL,NULL,'CI',NULL,NULL,-3.15545511245726600,5.61506795883177300,NULL,'Ayame','resident'),(37,'SATNJ','Region de la Vallee du Bandama',NULL,NULL,NULL,'CI',NULL,NULL,-4.41976928710937500,8.35662460327148400,NULL,'Dabakala','resident'),(38,'QZJGM',NULL,NULL,NULL,NULL,'KE',NULL,NULL,39.78329849243164000,-3.78329992294311520,NULL,'Pingilikani','resident'),(39,'BQSYZ',NULL,NULL,NULL,'KL','SN',NULL,'Kaolack',-16.09608650207519500,14.14322376251220700,NULL,NULL,'resident'),(40,'BQSYZ','Dakar',NULL,NULL,'GDW','SN',NULL,NULL,-17.43567657470703000,14.67281341552734400,NULL,'Pikine Guédiawaye','resident'),(41,'BQSYZ','Dakar',NULL,NULL,'DEGO','SN',NULL,NULL,-17.43567657470703000,14.67281341552734400,NULL,'Pikine Guédiawaye','resident'),(42,'ZYBXE','Zanzibar',NULL,NULL,NULL,'TZ',NULL,'Kivunge',39.28333282470703000,-5.88333320617675800,NULL,NULL,'resident'),(43,'ZYBXE',NULL,NULL,NULL,NULL,'TZ',NULL,'Pemba ',39.75416946411133000,-5.17125797271728500,NULL,NULL,'resident'),(44,'SYFQT',NULL,NULL,NULL,NULL,'TZ',NULL,'Fukayosi',38.66669845581055000,-6.40000009536743200,NULL,'Bagamoyo','resident'),(45,'GTEFH',NULL,NULL,NULL,NULL,'BD',NULL,NULL,91.99949026107788000,23.14705933681355500,NULL,'Khagrachari hill','resident'),(46,'RMNZA','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(47,'CDCMJ','Rakhine',NULL,NULL,'Rakhine','MM',NULL,NULL,94.13819885253906000,19.55950355529785000,NULL,NULL,'resident'),(48,'CDCMJ','Kachin',NULL,NULL,'Kachin','MM',NULL,NULL,97.80557250976562000,26.72757530212402300,NULL,NULL,'resident'),(49,'CDCMJ','Shan',NULL,NULL,'Shan','MM',NULL,NULL,98.45947265625000000,21.37124437061832800,NULL,NULL,'resident'),(50,'KDDBK','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(51,'APCQR',NULL,NULL,NULL,NULL,'ZM',NULL,'Maheba',25.92782355844974500,-12.35526813759528900,NULL,NULL,'resident'),(52,'KZBDT','Sikasso',NULL,NULL,NULL,'ML',NULL,NULL,-6.84387087821960450,11.39874758991850000,NULL,'Koumantou','resident'),(53,'YZBPN','Ibadan',NULL,NULL,NULL,'NG',NULL,NULL,3.89527797698974600,7.37884092330932600,NULL,NULL,'resident'),(54,'YZBPN','Enugu',NULL,NULL,NULL,'NG',NULL,NULL,7.49208021163940400,6.45053911209106450,NULL,NULL,'resident'),(55,'YZBPN','Jos',NULL,NULL,NULL,'NG',NULL,NULL,8.89338684082031200,9.92440032958984400,NULL,NULL,'resident'),(56,'YZBPN','Calabar',NULL,NULL,NULL,'NG',NULL,NULL,8.31441497802734400,4.95729064941406250,NULL,NULL,'resident'),(57,'YZBPN','Kintampo',NULL,NULL,NULL,'GH',NULL,NULL,-1.72667694091796880,8.04715728759765600,NULL,NULL,'resident'),(58,'YZBPN','Bobo-Dioulasso',NULL,NULL,NULL,'BF',NULL,NULL,-4.29177093505859400,11.17810440063476600,NULL,NULL,'resident'),(59,'YZBPN',NULL,NULL,NULL,NULL,'KE',NULL,NULL,35.26637268066406000,0.51523971557617190,NULL,'Eldoret','resident'),(60,'YZBPN',NULL,NULL,NULL,NULL,'KE',NULL,NULL,39.85445404052734400,-3.61507034301757800,NULL,'Kilifi','resident'),(61,'YZBPN',NULL,NULL,NULL,NULL,'KE',NULL,NULL,39.78329849243164000,-3.78329992294311520,NULL,'Pingilikani','resident'),(62,'YZBPN','Kiwangwa',NULL,NULL,NULL,'TZ',NULL,NULL,38.58330154418945000,-6.36670017242431600,NULL,NULL,'resident'),(63,'YZBPN','Bagamoyo',NULL,NULL,NULL,'TZ',NULL,NULL,38.89960098266601600,-6.44577598571777300,NULL,NULL,'resident'),(64,'PKGFP','Kindamba',NULL,NULL,NULL,'CG',NULL,NULL,14.54760700464248700,-3.72006163886841530,NULL,NULL,'resident'),(65,'DAABT','DOSSO',NULL,NULL,'+227','NE',NULL,'Gaya',3.53979396820066850,11.87269702541743800,NULL,NULL,'resident'),(66,'MSCTQ',NULL,NULL,NULL,NULL,'TD',NULL,NULL,17.76746280491352000,8.88794631449842100,NULL,'Koumra','resident'),(67,'UANQM',NULL,NULL,NULL,NULL,'PG',NULL,'Alexishafen',145.79737854003906000,-5.09369182586669900,NULL,'Madang','resident'),(68,'UANQM','East Sepik',NULL,NULL,NULL,'PG',NULL,'Kunjingini',143.25000000000000000,-4.33333301544189450,NULL,NULL,'resident'),(69,'RAJDQ',NULL,NULL,NULL,NULL,'PG',NULL,'Alexishafen',145.79737854003906000,-5.09369182586669900,NULL,'Madang','resident'),(70,'JZCKF','Kwa Zulu Natal',NULL,NULL,NULL,'ZA',NULL,'Ndumo',32.24626159667969500,-26.93213739262714000,NULL,NULL,'resident'),(71,'NRXTM','Mpumalanga',NULL,NULL,'MPM','ZA',NULL,NULL,29.87058258056639000,-26.30234495545900600,NULL,NULL,'resident'),(72,'NRXTM','KwaZulu Natal',NULL,NULL,NULL,'ZA',NULL,NULL,31.00000000000000000,-29.00000000000000000,NULL,NULL,'resident'),(73,'PEADD','Namaacha',NULL,NULL,NULL,'MZ',NULL,NULL,32.02706895768642400,-25.98499628102691000,NULL,NULL,'resident'),(74,'PEADD','Mpumalanga',NULL,NULL,NULL,'ZA',NULL,NULL,30.63619203865528000,-29.80639408235446000,NULL,NULL,'resident'),(75,'SQQDU',NULL,NULL,NULL,NULL,'KE',NULL,'Bondo',34.27640151977539000,-0.09441000223159790,NULL,NULL,'resident'),(76,'PCGTT','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(77,'BTQDX','Western Cape',NULL,NULL,NULL,'ZA',NULL,NULL,18.42198944091797000,-33.91909027099609400,NULL,'Cape Town',NULL),(78,'YEKAQ',NULL,NULL,NULL,NULL,'ZA',NULL,'Cape Town',18.42197036743164000,-33.91910171508789000,NULL,NULL,NULL),(79,'YFGYP',NULL,NULL,NULL,NULL,'MY',NULL,'Kota Bahru',102.24498748779297000,6.11804103851318400,NULL,NULL,'resident'),(80,'MSYTX',NULL,NULL,NULL,NULL,'TH',NULL,NULL,101.09999847412110000,15.22900009155273400,NULL,NULL,NULL),(81,'REAJS',NULL,NULL,NULL,NULL,'SN',NULL,'Keur Sosse',-16.07185077667236000,13.94944432344191000,NULL,'Kaolack ','resident'),(82,'EDUYA','Eastern Region',NULL,NULL,'J','AF',NULL,NULL,70.44699859619140000,34.41959146944941000,NULL,'Jalalabad','resident'),(83,'BSXFP','Nuba',NULL,NULL,'Sudan-Nuba','SD',NULL,NULL,30.15199966728687300,13.93300026655197100,NULL,'Limun','resident'),(84,'BKTSC','Shabunda',NULL,NULL,NULL,'CD',NULL,NULL,27.34242394566536000,-2.68548198044300100,NULL,NULL,'resident'),(85,'NXPPF',NULL,NULL,NULL,NULL,'LR',NULL,NULL,-7.71433286368846900,4.38570007681846600,NULL,'Harper','resident'),(86,'PRHNZ',NULL,NULL,NULL,NULL,'TD',NULL,NULL,15.37125505506992300,10.27389988303184500,NULL,'Bongor',NULL),(87,'JYDHH',NULL,NULL,NULL,NULL,'UG',NULL,NULL,32.38799974322319000,1.28200002014637000,NULL,'Bundi Bugyo','resident'),(88,'YGDSC','Mapel',NULL,NULL,NULL,'SD',NULL,NULL,30.22111892700195300,16.23966407775879000,NULL,'Bahr el-Ghazal','resident'),(89,'AQXZK',NULL,NULL,NULL,'Kuito Angola','AO',NULL,NULL,16.93912315368652300,-12.38035774230957000,NULL,'Kuito','resident'),(90,'GRDSS','Huambo',NULL,NULL,NULL,'AO',NULL,NULL,15.55987071990966800,-12.85127162933349600,NULL,'Caala','resident'),(91,'QRBRC','Katanga',NULL,NULL,NULL,'CD',NULL,NULL,28.06670017540455000,-7.38329932093620300,NULL,'Pweto','resident'),(92,'RZEKT','Nuba',NULL,NULL,'Nuba','SD',NULL,NULL,30.15199966728687300,13.93300026655197100,NULL,'Limun','resident'),(93,'DHNHD','Kailahun',NULL,NULL,NULL,'SL',NULL,NULL,-10.57847881317138700,8.27446079254150400,NULL,NULL,'resident'),(94,'QPZRQ','Kabala',NULL,NULL,NULL,'SL',NULL,NULL,-11.56470108032226600,9.58642768859863300,NULL,NULL,NULL),(95,'EXJHZ','Makeni',NULL,NULL,NULL,'SL',NULL,NULL,-12.05801010131836000,8.85002994537353500,NULL,NULL,NULL),(96,'AQTNA','Mattru',NULL,NULL,NULL,'SL',NULL,NULL,-11.38329908251762400,7.86669977009296400,NULL,NULL,'resident'),(97,'XCSAD','Mbarara',NULL,NULL,NULL,'UG',NULL,NULL,30.64855366945266700,-0.60567431151866910,NULL,NULL,NULL),(98,'SEFTB',NULL,NULL,NULL,NULL,'GN',NULL,NULL,-11.11000008881092000,10.75000002980232200,NULL,'Dabola','resident'),(99,'YYDSM','Allada',NULL,NULL,'A','BJ',NULL,NULL,2.15427207946777340,6.64571189880371100,NULL,NULL,'resident'),(100,'YYDSM','Sekou',NULL,NULL,'S','BJ',NULL,NULL,2.45000004768371600,6.59999990463256800,NULL,NULL,'resident'),(101,'BMSKT',NULL,NULL,NULL,'Ejeda','MG',NULL,'Ejeda',44.52246093750000000,-24.33922195434570300,NULL,NULL,'resident'),(102,'BMSKT',NULL,NULL,NULL,'Ihosy','MG',NULL,'Ihosy',46.12133026123047000,-22.40051269531250000,NULL,NULL,'resident'),(103,'BMSKT',NULL,NULL,NULL,'Maevatanana','MG',NULL,'Maevatanana',46.82856750488281000,-16.94788551330566400,NULL,NULL,'resident'),(104,'BMSKT',NULL,NULL,NULL,'Miandrivazo','MG',NULL,'Miandrivazo',45.45549774169922000,-19.52997589111328000,NULL,NULL,'resident'),(105,'BMSKT',NULL,NULL,NULL,NULL,'MG',NULL,'Tsiroanomandidy',46.04758071899414000,-18.77251625061035000,NULL,NULL,'resident'),(106,'BMSKT',NULL,NULL,NULL,'Moramanga','MG',NULL,'Moramanga',48.22183227539062500,-18.94768142700195300,NULL,NULL,'resident'),(107,'BMSKT',NULL,NULL,NULL,'Farafangana','MG',NULL,'Farafangana',47.82640457153320000,-22.82295417785644500,NULL,NULL,'resident'),(108,'BMSKT',NULL,NULL,NULL,'Andapa','MG',NULL,'Andapa',49.65238571166992000,-14.66481876373291000,NULL,NULL,'resident'),(109,'JHPFX',NULL,NULL,NULL,NULL,'KE',NULL,'Bondo',34.27640151977539000,-0.09441000223159790,NULL,NULL,'resident'),(110,'GBKPB','KE-800',NULL,NULL,'Asembo','KE',NULL,NULL,34.38330078125000000,-0.18330000340938568,NULL,'Asembo','resident'),(111,'JGGNM',NULL,NULL,NULL,NULL,'MZ',NULL,'Manhica',32.80904006958008000,-25.39916992187500000,NULL,NULL,'resident'),(112,'JGGNM',NULL,NULL,NULL,NULL,'KE',NULL,'Kilifi',39.84904861450195000,-3.62123990058898930,NULL,NULL,'resident'),(113,'JGGNM',NULL,NULL,NULL,NULL,'BF',NULL,'Nanoro',-2.19137310981750500,12.68305206298828100,NULL,NULL,'resident'),(114,'JGGNM',NULL,NULL,NULL,NULL,'UG',NULL,'Mbarara',30.66114997863769500,-0.60746997594833370,NULL,NULL,'resident'),(115,'JGGNM',NULL,NULL,NULL,NULL,'ZM',NULL,'Ndola',28.64142036437988300,-12.97325992584228500,NULL,NULL,'resident'),(116,'QXJGK',NULL,NULL,NULL,NULL,'TH',NULL,'Bangkok',100.50482940673828000,13.75335025787353500,NULL,NULL,'resident'),(117,'QXJGK',NULL,NULL,NULL,NULL,'TH',NULL,'Ratchaburi',99.81927490234375000,13.53633975982666000,NULL,NULL,'resident'),(118,'QXJGK','Tak',NULL,NULL,NULL,'TH',NULL,'Phop Phra',98.76334381103517000,16.40492829494708400,NULL,NULL,'resident'),(119,'QXJGK',NULL,NULL,NULL,NULL,'TH',NULL,'Mae Sot',98.56881713867188000,16.71491050720215000,NULL,NULL,'resident'),(120,'QXJGK',NULL,NULL,NULL,NULL,'TH',NULL,'Mae Ramat',98.51804351806640000,16.98261070251465000,NULL,NULL,'resident'),(121,'QXJGK',NULL,NULL,NULL,NULL,'LA',NULL,'Phalanxay',104.75375366210938000,16.56142997741699200,NULL,'Savannakhe','resident'),(122,'QXJGK',NULL,NULL,NULL,NULL,'LA',NULL,'Xepon',105.30000305175781000,17.04999923706054700,NULL,NULL,'resident'),(123,'QXJGK',NULL,NULL,NULL,NULL,'IN',NULL,'Guwahati',91.79019165039062000,26.13207054138183600,NULL,'Assam','resident'),(124,'QXJGK',NULL,NULL,NULL,NULL,'IN',NULL,'Goa',73.99080657958984000,15.35539054870605500,NULL,NULL,'resident'),(125,'QXJGK',NULL,NULL,NULL,NULL,'IN',NULL,'Mangalore',74.85346984863281000,12.89099979400634800,NULL,NULL,'resident'),(126,'HMPBZ',NULL,NULL,NULL,NULL,'SD',NULL,'Sinnar',34.32122421264648400,12.90797042846679700,NULL,NULL,'resident'),(127,'SUEGP',NULL,NULL,NULL,NULL,'BF',NULL,'Bobo-Dioulasso',-4.23027992248535200,11.16174983978271500,NULL,NULL,'resident'),(128,'GDNSU',NULL,NULL,NULL,NULL,'BJ',NULL,NULL,2.44008994102478030,6.35693120956420900,NULL,'Cotonou','resident'),(129,'RCBGY','Papua',NULL,NULL,NULL,'ID',NULL,'Timika',136.01266479492188000,-3.44211196899414060,NULL,'Tembagapura','resident'),(130,'FBDEZ',NULL,NULL,NULL,NULL,'GW',NULL,NULL,-15.38329887390136700,11.33329963684082000,NULL,'Bandim','resident'),(131,'TYKSC',NULL,NULL,NULL,NULL,'SN',NULL,NULL,-14.59899997711181600,14.89999961853027300,NULL,NULL,'resident'),(132,'TYKSC',NULL,NULL,NULL,NULL,'SN',NULL,NULL,-14.59899997711181600,14.89999961853027300,NULL,NULL,'resident'),(133,'TYKSC',NULL,NULL,NULL,NULL,'ML',NULL,NULL,-3.52600002288818360,17.35799980163574200,NULL,NULL,'resident'),(134,'TYKSC',NULL,NULL,NULL,NULL,'CM',NULL,NULL,12.72299957275390600,5.68499994277954100,NULL,NULL,'resident'),(135,'TYKSC',NULL,NULL,NULL,NULL,'MG',NULL,NULL,46.69800186157226600,-19.27199935913086000,NULL,NULL,'resident'),(136,'XEDNN',NULL,NULL,NULL,'Senegal','SN',NULL,'Darou Marnane',-15.88333320617675800,14.46666717529296900,NULL,'Touba','resident'),(137,'XEDNN',NULL,NULL,NULL,'Cote d\'Ivoire','CI',NULL,'Bocabo',-4.01669883728027300,5.41669988632202150,NULL,'Abobo','resident'),(138,'XEDNN',NULL,NULL,NULL,'Cameroon','CM',NULL,'Yaounde',11.51840972900390600,3.87036895751953120,NULL,NULL,'resident'),(139,'AJXCU',NULL,NULL,NULL,NULL,'SN',NULL,NULL,-14.59899997711181600,14.89999961853027300,NULL,NULL,'resident'),(140,'AJXCU',NULL,NULL,NULL,NULL,'CI',NULL,NULL,-5.55299997329711900,7.59899997711181600,NULL,NULL,'resident'),(141,'AJXCU',NULL,NULL,NULL,NULL,'CM',NULL,NULL,12.72299957275390600,5.68499994277954100,NULL,NULL,'resident'),(142,'RNZFN','Anonkoua- Koute',NULL,NULL,'CI','CI',NULL,'Bonoua',-3.58308124542236150,5.26922338626899000,NULL,NULL,'resident'),(143,'RNZFN',NULL,NULL,NULL,'SEN','SN',NULL,'Guediawaye',-17.39999961853027300,14.78333282470703100,NULL,NULL,'resident'),(144,'TETAJ',NULL,NULL,NULL,NULL,'LA',NULL,NULL,106.22746276855467000,16.68499904373189200,NULL,'Savannakhet','resident'),(145,'ZUMXA',NULL,NULL,NULL,NULL,'ET',NULL,'Jimma',36.83844375610351600,7.67847776412963900,NULL,NULL,'resident'),(146,'JAYEJ',NULL,NULL,NULL,NULL,'ET',NULL,'Oromiya',39.63499832153320000,8.62199974060058600,NULL,'Jimma','resident'),(147,'JZHND',NULL,NULL,NULL,NULL,'TZ',NULL,'Fukayosi',38.66669845581055000,-6.40000009536743200,NULL,'Bagamoyo','resident'),(148,'AMKUG',NULL,NULL,NULL,NULL,'BF',NULL,NULL,-1.74600005149841300,12.28499984741211000,NULL,NULL,NULL),(149,'HKNHR','Savannakhet',NULL,NULL,NULL,'LA',NULL,NULL,104.75048828125000000,16.56295013427734400,NULL,NULL,'resident'),(150,'ZRXBJ','Savannakhet',NULL,NULL,NULL,'LA',NULL,NULL,104.75048828125000000,16.56295013427734400,NULL,'Phalanxay','resident'),(151,'ZRXBJ','Savannakhet',NULL,NULL,NULL,'LA',NULL,NULL,104.75048828125000000,16.56295013427734400,NULL,'Sepone',NULL),(152,'ETXUR',NULL,NULL,NULL,'Madang','PG',NULL,'Alexishafen',145.79737854003906000,-5.09369182586669900,NULL,'Madang','resident'),(153,'ETXUR','East Sepik',NULL,NULL,'Maprik','PG',NULL,'Kunjingini',143.25000000000000000,-4.33333301544189450,NULL,NULL,'resident'),(154,'XYQAJ','TAK',NULL,NULL,'Mae La','TH',NULL,'Mae La',98.36285502115880000,17.14535151089270000,NULL,'Tha Song Yang','resident'),(155,'XYQAJ','TAK',NULL,NULL,'Mae Sot','TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(156,'SFEZE',NULL,NULL,NULL,'Chulaimbo Sub District hospital','KE',NULL,'Chulaimbo Sub District hospital',37.87799835205078000,0.51099997758865360,NULL,NULL,'resident'),(157,'PFJCR',NULL,NULL,NULL,NULL,'KE',NULL,'Chulaimbo Sub District hospital',37.87799835205078000,0.51099997758865360,NULL,NULL,'resident'),(158,'BSCRC','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(159,'BJUNF',NULL,NULL,NULL,NULL,'CD',NULL,'Kabalo',26.91275216639042000,-6.05363376438617700,NULL,NULL,'resident'),(160,'UBYYD','Eastern Sudan',NULL,NULL,'Gedaref State','SD',NULL,NULL,35.38469314575194600,14.03394727786268000,NULL,'Gedaref State','resident'),(161,'TDBGN',NULL,NULL,NULL,'Ejeda','MG',NULL,'Ejeda',44.52246093750000000,-24.33922195434570300,NULL,NULL,'resident'),(162,'TDBGN',NULL,NULL,NULL,'Ihosy','MG',NULL,'Ihosy',46.12133026123047000,-22.40051269531250000,NULL,NULL,'resident'),(163,'TDBGN',NULL,NULL,NULL,'Maevatanana','MG',NULL,'Maevatanana',46.82856750488281000,-16.94788551330566400,NULL,NULL,'resident'),(164,'TDBGN',NULL,NULL,NULL,'Miandrivazo','MG',NULL,'Miandrivazo',45.45549774169922000,-19.52997589111328000,NULL,NULL,'resident'),(165,'TDBGN',NULL,NULL,NULL,'Tsiroanomandidy','MG',NULL,'Tsiroanomandidy',46.04758071899414000,-18.77251625061035000,NULL,NULL,'resident'),(166,'TDBGN',NULL,NULL,NULL,'Moramanga','MG',NULL,'Moramanga',48.22183227539062500,-18.94768142700195300,NULL,NULL,'resident'),(167,'TDBGN',NULL,NULL,NULL,'Farafangana','MG',NULL,'Farafangana',47.82640457153320000,-22.82295417785644500,NULL,NULL,'resident'),(168,'TDBGN',NULL,NULL,NULL,'Andapa','MG',NULL,'Andapa',49.65238571166992000,-14.66481876373291000,NULL,NULL,'resident'),(169,'DSBTF','KE-800',NULL,NULL,'Asembo','KE',NULL,NULL,34.38330078125000000,-0.18330000340938568,NULL,'Asembo','resident'),(170,'SXGQP','Bissau',NULL,NULL,NULL,'GW',NULL,NULL,-15.62816047668457000,11.86711025238037100,NULL,NULL,'resident'),(171,'PZXFS',NULL,NULL,NULL,NULL,'GH',NULL,'Accra',-0.19897000491619110,5.58106994628906250,NULL,NULL,'resident'),(172,'DFTUS',NULL,NULL,NULL,NULL,'SN',NULL,'Pikine Guédiawaye',-14.59899997711181600,14.89999961853027300,NULL,NULL,'resident'),(173,'USGDC','Mae la',NULL,NULL,NULL,'TH',NULL,NULL,100.99491119384766000,15.86970908611233400,NULL,NULL,'resident'),(174,'UAZYB','Mae sot',NULL,NULL,NULL,'TH',NULL,NULL,98.54873657226567000,16.69956437466962000,NULL,NULL,NULL),(175,'RBKQB',NULL,NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae sot','resident'),(176,'CCEPC','Mbarara',NULL,NULL,NULL,'UG',NULL,NULL,30.64855366945266700,-0.60567431151866910,NULL,NULL,'resident'),(177,'ESUHR',NULL,NULL,NULL,NULL,'UG',NULL,'Kampala',32.38800048828125000,1.28199994564056400,NULL,NULL,NULL),(178,'MMZRT','KE-800',NULL,NULL,NULL,'KE',NULL,NULL,37.87799835205078000,0.51099997758865360,NULL,'Siaya','resident'),(179,'FSFKM',NULL,NULL,NULL,NULL,'TZ',NULL,'Mwanza',32.89693832397461000,-2.52258992195129400,NULL,NULL,'resident'),(180,'PADKN','Mbarara',NULL,NULL,NULL,'UG',NULL,NULL,30.64855366945266700,-0.60567431151866910,NULL,NULL,NULL),(181,'PCPRC','Eastern Sudan',NULL,NULL,'Gedaref','SD',NULL,NULL,35.38469314575194600,14.03394727786268000,NULL,'Gedaref State','resident'),(182,'PCPRC',NULL,NULL,NULL,'New Halfa','SD',NULL,'New Halfa',35.72779846191406000,15.35560035705566400,NULL,NULL,'resident'),(183,'ETFZC','Apac',NULL,NULL,NULL,'UG',NULL,NULL,32.53861236572265600,1.97555601596832280,NULL,NULL,'resident'),(184,'XDZPA',NULL,NULL,NULL,'Kilifi','KE',NULL,'Kilifi',39.85445404052734400,-3.61507034301757800,NULL,NULL,'resident'),(185,'KGHRT',NULL,NULL,NULL,'1','TZ',NULL,'Fukayosi',38.50000000000000000,-6.33333000000000000,NULL,'Bagamoyo','resident'),(186,'KGHRT',NULL,NULL,NULL,'2','TZ',NULL,'Yombo',38.84744262695312500,-6.58617019653320300,NULL,'Bagamoyo','resident'),(187,'XXFCZ',NULL,NULL,NULL,NULL,'TZ',NULL,NULL,38.91666700000000000,-6.76666700000000000,NULL,'Kibaha District',NULL),(188,'XGQRX','Kyenjojo',NULL,NULL,NULL,'UG',NULL,NULL,30.62138892710209000,0.63277803361415860,NULL,NULL,'resident'),(189,'HJNDX','Grand Gedeh County',NULL,NULL,NULL,'LR',NULL,'Grand Gedeh County',-8.08333301544189500,5.91666698455810550,NULL,NULL,'resident'),(190,'SAUSX','Bangkok',NULL,NULL,NULL,'TH',NULL,'Thung Phayathai',100.53143717447916000,13.75168457031250000,NULL,'Ratchathewi','resident'),(191,'SAUSX','Tak',NULL,NULL,NULL,'TH',NULL,'Mae La',98.36285502115880000,17.14535151089270000,NULL,'Tha Song Yang','traveller'),(192,'XEKED','KAOLACK',NULL,NULL,NULL,'SN',NULL,'NDOFANE',-16.38324737548829000,13.86666679382322800,NULL,NULL,'resident'),(193,'DBCXT',NULL,NULL,NULL,NULL,'UG',NULL,NULL,32.57484054565430000,0.32280400395393370,NULL,'Kampala','resident'),(194,'YQXBU',NULL,NULL,NULL,NULL,'UG',NULL,NULL,34.17296600341797000,0.70467799901962280,NULL,'Tororo','resident'),(195,'BXYJX','Acre',NULL,NULL,'Acre','BR',NULL,NULL,-68.48338317871092000,-9.52440600456216700,NULL,NULL,'resident'),(196,'MRGRH','Maela',NULL,NULL,'MLA','TH',NULL,'Maela',98.36440277099611000,17.14518329265549000,NULL,NULL,'resident'),(197,'MRGRH',NULL,NULL,NULL,'WPA','TH',NULL,'Wang Pha',98.52851104736330000,16.82997454630467000,NULL,'Tak','resident'),(198,'MRGRH',NULL,NULL,NULL,NULL,'TH',NULL,'MaeSot',98.55430182801739000,16.71021561959227600,NULL,NULL,'resident'),(199,'MRGRH',NULL,NULL,NULL,NULL,'TH',NULL,'Mae Kon Ken',98.58867714187144000,16.55149779731263500,NULL,NULL,'resident'),(200,'MRGRH',NULL,NULL,NULL,'MKT','TH',NULL,'Mawker Thai',98.66927337646486000,16.33048188957312000,NULL,NULL,'resident'),(201,'DXYHK',NULL,NULL,NULL,'Kilifi','KE',NULL,'Kilifi',39.85445404052734400,-3.61507034301757800,NULL,NULL,'resident'),(202,'YJXJA','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(203,'DMCYR','KE-600',NULL,NULL,'Kisii','KE',NULL,NULL,34.77436065673827000,-0.67550103608812150,NULL,'Kisii','resident'),(204,'JXPFB','Gaua',NULL,NULL,'Gaua','VU',NULL,NULL,167.49465942382810000,-14.27936077350499000,NULL,NULL,'resident'),(205,'JXPFB','Santo',NULL,NULL,'Santo','VU',NULL,NULL,166.91490173339844000,-15.36956785674245000,NULL,NULL,'resident'),(206,'JXPFB','Pentecost',NULL,NULL,'Pentecost','VU',NULL,NULL,168.18862915039062000,-15.74063396453857400,NULL,NULL,'resident'),(207,'JXPFB','Malakula',NULL,NULL,'Malakula','VU',NULL,NULL,167.49308776855470000,-16.23428916931152300,NULL,NULL,'resident'),(208,'ZFSQZ','Ratchburi Province',NULL,NULL,'Ratchburi','TH',NULL,NULL,99.81927490234375000,13.53633975982666000,NULL,NULL,'resident'),(209,'ZFSQZ','Tak Province',NULL,NULL,'Tak','TH',NULL,NULL,99.13114929199219000,16.87756729125976600,NULL,NULL,'resident'),(210,'ZFSQZ','Kanchanaburi Province',NULL,NULL,'Kanchanaburi','TH',NULL,NULL,99.53333282470703000,14.01666736602783200,NULL,NULL,'resident'),(211,'CNAEH','Kampot Province',NULL,NULL,'Kampot','KH',NULL,NULL,104.40000152587890000,10.85000038146972700,NULL,'Chum Kiri','resident'),(212,'DXHNK','Wewak',NULL,NULL,'Wewak','PG',NULL,NULL,143.62001037597656000,-3.56518554687500000,NULL,NULL,'resident'),(213,'KGJXQ','Rufiji',NULL,NULL,'Rufiji River Delta','TZ',NULL,NULL,38.48358917236328000,-7.87636089324951200,NULL,NULL,'resident'),(214,'CJCMZ',NULL,NULL,NULL,'Salima','MW',NULL,NULL,34.45848083496094000,-13.78073883056640600,NULL,'Salima','resident'),(215,'NGKRX',NULL,NULL,NULL,'Pointe-Noire','CG',NULL,NULL,11.86363792419433600,-4.77866983413696300,NULL,'Pointe-Noire','resident'),(216,'NGKRX','Brazzaville',NULL,NULL,'Brazzaville','CG',NULL,'Brazzaville',15.29490661621093800,-4.27432632446289100,NULL,NULL,'resident'),(217,'NGKRX','Gamboma ',NULL,NULL,'Gamboma','CG',NULL,NULL,15.85327529907226600,-1.88382601737976070,NULL,NULL,'resident'),(218,'YYHRH',NULL,NULL,NULL,'Winneba','GH',NULL,NULL,-0.62284088134765620,5.33871459960937500,NULL,'Winneba','resident'),(219,'CXHXA','Guadalcanal Island ',NULL,NULL,'Guadalcanal Island','SB',NULL,NULL,160.36553955078125000,-9.43700433949666700,NULL,'Tambunimane','resident'),(220,'BHYRH',NULL,NULL,NULL,NULL,'AO',NULL,NULL,16.93912315368652300,-12.38035774230957000,NULL,'Kuito','resident'),(221,'BHYRH',NULL,NULL,NULL,NULL,'AO',NULL,'Caala',15.55987071990966800,-12.85127162933349600,NULL,NULL,NULL),(222,'BYMYG',NULL,NULL,NULL,NULL,'ML',NULL,'Kenieroba',-8.33297538757324200,12.10687160491943400,NULL,NULL,NULL),(223,'ESGDS','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(224,'RNUTR','Madagascar',NULL,NULL,NULL,'MG',NULL,NULL,46.69799990952015000,-19.27199967205524400,NULL,NULL,NULL),(225,'MCKHJ','KE-300',NULL,NULL,NULL,'KE',NULL,NULL,39.68178939819336000,-2.56389188766479500,NULL,'Pingilikani',NULL),(226,'CFFZN','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(227,'GXNKY','North Bank Division',NULL,NULL,'Farafenni','GM',NULL,NULL,-15.49100026488304100,13.44000019133091000,NULL,'Farafenni',NULL),(228,'YNUPB','Gosson',NULL,NULL,NULL,'CI',NULL,NULL,-5.55299997329711900,7.59899997711181600,NULL,NULL,'resident'),(229,'YGNQS','Dakar',NULL,NULL,NULL,'SN',NULL,'GUÉDIAWAYE',-17.40000000000000000,14.78333333333330000,NULL,NULL,NULL),(230,'TRKFC','GAYA',NULL,NULL,NULL,'NE',NULL,NULL,3.53910994529724100,11.87707996368408200,NULL,NULL,'resident'),(231,'TRKFC','AGADES',NULL,NULL,NULL,'NE',NULL,NULL,7.98273897171020500,16.99429702758789000,NULL,NULL,'resident'),(232,'TRKFC','Tessaoua',NULL,NULL,NULL,'NE',NULL,NULL,7.99021720886230500,13.74883460998535200,NULL,NULL,'resident'),(233,'THQEK',NULL,NULL,NULL,NULL,'CI',NULL,NULL,-5.55299997329711900,7.59899997711181600,NULL,NULL,'resident'),(234,'EGYMA',NULL,NULL,NULL,NULL,'ML',NULL,'Sikasso',-5.60764694213866200,11.31497859705317000,NULL,NULL,'resident'),(235,'MCZHT',NULL,NULL,NULL,NULL,'UG',NULL,NULL,29.78972174227237700,-0.95749966800212860,NULL,'Kanungu','resident'),(236,'KRBXE','Rakhine',NULL,NULL,'dabhine','MM',NULL,'Dabhine',94.13819885253906000,19.55950355529785000,NULL,'Sittwe Township','resident'),(237,'KRBXE','Rakhine',NULL,NULL,'mingan','MM',NULL,'Mingan',94.13819588720798000,19.55950431525707200,NULL,'Sittwe Township','resident'),(238,'KJGJT',NULL,NULL,NULL,NULL,'BF',NULL,NULL,-0.35576599836349490,12.17718601226806600,NULL,'Koupela','resident'),(239,'SZRDK','Tak',NULL,NULL,NULL,'TH',NULL,'Mae La',98.36285502115886000,17.14535151089272300,NULL,'Tha Song Yang','resident'),(240,'PDKJM','Pursat',NULL,NULL,'Pursat','KH',NULL,NULL,103.55024719238281000,12.51119518280029300,NULL,NULL,'resident'),(241,'PDKJM','Ratanakiri',NULL,NULL,'Ratanakiri','KH',NULL,NULL,107.08226013183594000,13.92879962921142600,NULL,NULL,'resident'),(242,'EPDUY','Bangkok',NULL,NULL,'Bangkok','TH',NULL,'Thung Phayathai',100.53143717447917000,13.75168457031250000,NULL,'Ratchathewi','resident'),(243,'EPDUY','Tak',NULL,NULL,'Mae Sot','TH',NULL,'Mawker Thai',98.80808919270834000,16.47247517903645800,NULL,'Phop Phra','resident'),(244,'EPDUY','Tak',NULL,NULL,NULL,'TH',NULL,'Murachai',98.76094055175783000,16.40657501786282000,NULL,'Phop Phra','resident'),(245,'EPDUY','Tak',NULL,NULL,NULL,'TH',NULL,'Mae La',98.36285502115886000,17.14535150892723000,NULL,'Tha Song Yang','resident'),(246,'AJYER','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(247,'ACXFX','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(248,'MTZZP','Savannakhet',NULL,NULL,NULL,'LA',NULL,'Phalanxay Clinic',104.75048828125000000,16.56295013427734400,NULL,'Phalanxay',NULL),(249,'EUKMD',NULL,NULL,NULL,NULL,'UG',NULL,'Nagongera ',34.01466369628906000,0.77578002214431760,NULL,'Tororo','resident'),(250,'MYHXP','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(251,'GHYRA','Region du Centre',NULL,NULL,NULL,'BF',NULL,'Ouagadougou',-1.48333299160003700,12.08333301544189500,NULL,'Pissy','resident'),(252,'EYHNP','Xekong',NULL,NULL,NULL,'LA',NULL,NULL,107.06666564941406000,15.35000038146972600,NULL,NULL,NULL),(253,'YRRSK','Huambo',NULL,NULL,NULL,'AO',NULL,NULL,15.55987071990966800,-12.85127162933349600,NULL,'Caala','resident'),(254,'SRDFP','Sikasso',NULL,NULL,'ASB','ML',NULL,'Bougoula Hameau',-5.67270660400390600,11.31531524658203100,NULL,NULL,'resident'),(255,'DADPZ',NULL,NULL,NULL,NULL,'UG',NULL,NULL,34.17296600341797000,0.70467799901962280,NULL,'Tororo','resident'),(256,'JTXEY',NULL,NULL,NULL,NULL,'UG',NULL,NULL,32.57484054565430000,0.32280400395393370,NULL,'Kampala','resident'),(257,'GYECE',NULL,NULL,NULL,NULL,'UG',NULL,NULL,32.57484054565430000,0.32280400395393370,NULL,'Kampala',NULL),(258,'TZXHH',NULL,NULL,NULL,NULL,'GB',NULL,'London',-0.12714000046253204,51.50632095336914000,NULL,NULL,'traveller'),(259,'JGUAM','Bandim',NULL,NULL,NULL,'GW',NULL,NULL,-15.38329887390136700,11.33329963684082000,NULL,NULL,'resident'),(260,'PCRNU',NULL,NULL,NULL,NULL,'UG',NULL,NULL,32.57484054565430000,0.32280400395393370,NULL,'kampala','resident'),(261,'YGTAH',NULL,NULL,NULL,NULL,'UG',NULL,NULL,34.17296600341797000,0.70467799901962280,NULL,'Tororo','resident'),(262,'TDFKY','Apac',NULL,NULL,NULL,'UG',NULL,NULL,32.53861236572265600,1.97555601596832280,NULL,NULL,'resident'),(263,'QCKHC','Papua',NULL,NULL,NULL,'ID',NULL,NULL,136.01266466081142000,-3.44211168587207800,NULL,'Timika','resident'),(264,'JAGFN','Tak',NULL,NULL,NULL,'TH',NULL,'Shoklo',98.63771158854166000,16.76050008138020800,NULL,'Mae sot','resident'),(265,'JAGFN','Tak',NULL,NULL,NULL,'TH',NULL,'Maela',98.54636230468750000,16.83703409830729200,NULL,'Mae Sot','resident'),(266,'FXFTC',NULL,NULL,NULL,NULL,'UG',NULL,'Arua',30.89858436584472700,3.02415990829467770,NULL,NULL,'resident'),(267,'FNMDP','Kailahun',NULL,NULL,NULL,'SL',NULL,NULL,-10.57847881317138700,8.27446079254150400,NULL,NULL,'resident'),(268,'MSDDE',NULL,NULL,NULL,NULL,'TZ',NULL,'Fukayosi',34.85399991273880000,-6.30699992179870600,NULL,'Bagamoyo District',NULL),(269,'RZENT',NULL,NULL,NULL,NULL,'MZ',NULL,NULL,32.66754531860351600,-26.34109878540039000,NULL,'Bela Vista','resident'),(270,'NMMSB',NULL,NULL,NULL,NULL,'MZ',NULL,NULL,32.66754531860351600,-26.34109878540039000,NULL,'Bela Vista','resident'),(271,'RHXNJ',NULL,NULL,NULL,NULL,'MZ',NULL,NULL,32.01883697509765600,-25.97596740722656200,NULL,'Namaacha','resident'),(272,'QBPQM',NULL,NULL,NULL,NULL,'TH',NULL,NULL,99.13961029052734000,14.12007999420166000,NULL,'Wang Pha',NULL),(273,'FARTM',NULL,NULL,NULL,NULL,'KH',NULL,NULL,102.61302947998047000,12.84672641754150400,NULL,'Pailin','resident'),(274,'UNFDD',NULL,NULL,NULL,'Kolle','ML',NULL,'Kolle',-3.52600002288818360,17.35799980163574200,NULL,NULL,'resident'),(275,'UNFDD',NULL,NULL,NULL,'Faladie','ML',NULL,'Faladie',-8.34584045410156200,13.12833213806152300,NULL,NULL,'resident'),(276,'UNFDD',NULL,NULL,NULL,'Bandiagara','ML',NULL,'Bandiagara',-3.60534405708313000,14.34449386596679700,NULL,NULL,'resident'),(277,'UNFDD',NULL,NULL,NULL,'Pongonon','ML',NULL,NULL,-3.07483673095703120,14.06175613403320300,NULL,'Koro','resident'),(278,'RDBXS',NULL,NULL,NULL,NULL,'ML',NULL,'Kolle',-3.52600002288818360,17.35799980163574200,NULL,NULL,'resident'),(279,'RDBXS',NULL,NULL,NULL,NULL,'ML',NULL,'Faladie',-8.34584045410156200,13.12833213806152300,NULL,NULL,'resident'),(280,'RDBXS',NULL,NULL,NULL,NULL,'ML',NULL,'Bandiagara',-3.60534405708313000,14.34449386596679700,NULL,NULL,'resident'),(281,'RDBXS',NULL,NULL,NULL,NULL,'ML',NULL,NULL,-3.07483673095703120,14.06175613403320300,NULL,'Koro','resident'),(282,'RFRYE','Amudat',NULL,NULL,NULL,'UG',NULL,NULL,34.92723092436790500,1.94782890379428860,NULL,NULL,'resident'),(283,'RSBPS','Anonkoua-kouté',NULL,NULL,NULL,'CI',NULL,NULL,-4.05000019073486300,5.43330001831054700,NULL,NULL,'resident'),(284,'SDJZP','Anonkoua-kouté',NULL,NULL,NULL,'CI',NULL,NULL,-4.05000019073486300,5.43330001831054700,NULL,NULL,'resident'),(285,'SJDMX',NULL,NULL,'lt12h',NULL,'SN','ACD','Dakar',-17.43567623198032400,14.67281319200992500,'+4C',NULL,'resident'),(286,'FFFSQ',NULL,NULL,NULL,NULL,'TH',NULL,'Bangkok',100.50482940673828000,13.75335025787353500,NULL,NULL,'resident'),(287,'FFFSQ','Ratchaburi',NULL,NULL,NULL,'TH',NULL,NULL,99.34999847412110000,13.51666736602783200,NULL,'Suan Phung','resident'),(288,'JBGGS',NULL,NULL,NULL,NULL,'TH',NULL,'Bangkok',100.50482940673828000,13.75335025787353500,NULL,NULL,'resident'),(289,'MNJAK',NULL,NULL,NULL,NULL,'ZA',NULL,NULL,25.06300024688244000,-29.04600016772747000,NULL,'Lukekani',NULL),(290,'REQES','Battambang Province',NULL,NULL,NULL,'KH',NULL,NULL,103.22500000000000000,13.09510000000000000,NULL,NULL,NULL),(291,'UGGKH','Navrongo',NULL,NULL,'Navrongo','GH',NULL,NULL,-1.08461201190948490,10.88371181488037100,NULL,NULL,'resident'),(292,'UGGKH','Sunyani',NULL,NULL,'Sunyani','GH',NULL,NULL,-2.33644604682922360,7.33612203598022500,NULL,NULL,'resident'),(293,'UGGKH','Cape Coast',NULL,NULL,'Cape Coast','GH',NULL,NULL,-1.24723052978515620,5.10505676269531250,NULL,NULL,'resident'),(294,'UGGKH','Berekum',NULL,NULL,'Berekum','GH',NULL,NULL,-2.58311891555786130,7.44907188415527300,NULL,NULL,'resident'),(295,'JAGHH','Uige Province',NULL,NULL,'UigeTown','AO',NULL,'UigeTown',15.00010000000000000,-7.08423000000000000,NULL,NULL,'resident'),(296,'UHUBT','Morogoro',NULL,NULL,NULL,'TZ',NULL,'Kibaoni Health Centre',34.85399991273880000,-6.30699992179870600,NULL,'Kilombero','resident'),(297,'FJQNT',NULL,NULL,NULL,NULL,'UG',NULL,NULL,29.78972174227237700,-0.95749966800212860,NULL,'Kanungu','resident'),(298,'EKDTF',NULL,NULL,NULL,'Boane','MZ',NULL,NULL,32.32527780000000000,-26.04166670000000000,NULL,'Boanne','resident'),(299,'EKDTF',NULL,NULL,NULL,'Magude','MZ',NULL,NULL,32.64806000000000000,-25.02306000000000000,NULL,'Magude','resident'),(300,'EKDTF',NULL,NULL,NULL,'Namaacha','MZ',NULL,NULL,32.02560000000000000,-25.97030000000000000,NULL,'Namaacha','resident'),(301,'EKDTF',NULL,NULL,NULL,'Catuane','MZ',NULL,NULL,32.84444000000000000,-26.83630000000000000,NULL,'Catuane','resident'),(302,'TZDRS','KE-300',NULL,NULL,NULL,'KE',NULL,NULL,40.17342758178713000,-2.86841962698162000,NULL,NULL,'resident'),(303,'AYCTT','Bandarban',NULL,NULL,'Bandarban','BD',NULL,NULL,92.21669769287110000,22.20000076293945300,NULL,NULL,'resident'),(304,'NPCGQ','Kwa Zulu Natal',NULL,NULL,NULL,'ZA',NULL,'Ndumo',18.47601318359375000,-33.91372680664062500,NULL,NULL,'resident'),(305,'MHABC',NULL,NULL,NULL,'Boane','MZ',NULL,NULL,35.21670150756836000,-23.41670036315918000,NULL,'Boane','resident'),(306,'MHABC',NULL,NULL,NULL,'Magude','MZ',NULL,NULL,32.64806000000000000,-25.02306000000000000,NULL,'Magude','resident'),(307,'MHABC',NULL,NULL,NULL,'Namaacha','MZ',NULL,NULL,32.02560000000000000,-25.97030000000000000,NULL,'Namaacha','resident'),(308,'MHABC',NULL,NULL,NULL,'Catuane','MZ',NULL,NULL,32.84444000000000000,-26.83630000000000000,NULL,'Catuane','resident'),(309,'KXPEY',NULL,NULL,NULL,'Apac','UG',NULL,'Apac',32.53860000000000000,1.97556000000000000,NULL,'Apac',NULL),(310,'KXPEY',NULL,NULL,NULL,'Arua','UG',NULL,'Arua',30.93080000000000000,3.01917000000000000,NULL,'Arua',NULL),(311,'KXPEY',NULL,NULL,NULL,'Mubende','UG',NULL,'Mubende',31.16670000000000000,0.75000000000000000,NULL,'Mubende',NULL),(312,'KXPEY',NULL,NULL,NULL,'Kanungu','UG',NULL,'Kanungu',29.78970000000000000,-0.95750000000000000,NULL,'Kanungu',NULL),(313,'KXPEY',NULL,NULL,NULL,'Tororo','UG',NULL,'Tororo',34.18110000000000000,0.68472200000000000,NULL,'Tororo',NULL),(314,'KXPEY',NULL,NULL,NULL,'Jinja','UG',NULL,'Jinja',33.20420000000000000,0.42444400000000000,NULL,'Jinja',NULL),(315,'SJPNH','Chittagong Hill Tracts',NULL,'lt12h',NULL,'BD','heparin','Bandarban',90.05800008773804000,24.30899977684021000,'+4C','Bandarban',NULL),(316,'YPRHD','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(317,'ZHKTN',NULL,NULL,NULL,NULL,'LR',NULL,'Monrovia',-10.79715728759765600,6.30077362060546900,NULL,NULL,'resident'),(318,'RXSXX','Rotterdam',NULL,NULL,NULL,'NL',NULL,NULL,4.47844982147216800,51.92282867431640600,NULL,NULL,'traveller'),(319,'SFBSG','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(320,'JRBRK','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot',NULL),(321,'FMNNB','Tak',NULL,NULL,NULL,'TH',NULL,'Mae La',98.36285502115880000,17.14535151089270000,NULL,'Tha Song Yang','resident'),(322,'GMKEF','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(323,'XSGGK','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(324,'XSGGK','Tak',NULL,NULL,NULL,'TH',NULL,'Maela',98.54636230468750000,16.83703409830729200,NULL,'Mae Sot','resident'),(325,'GQBEK','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(326,'KUCMZ','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(327,'GKXGE','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(328,'EMJMA','Tak',NULL,NULL,NULL,'TH',NULL,'Mae la',98.36285502115886000,17.14535150892723000,NULL,'Tha Song Yang',NULL),(329,'EMJMA','Tak',NULL,NULL,NULL,'TH',NULL,'Mawker Thai',98.80808919270834000,16.47247517903645800,NULL,'Phop Phra',NULL),(330,'JUTXU','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(331,'TJRQU','Tak',NULL,NULL,NULL,'TH',NULL,NULL,98.56881713867188000,16.71491050720215000,NULL,'Mae-Sot','resident'),(332,'KCZNJ','Kachin',NULL,NULL,NULL,'MM',NULL,'Sinbo village',97.04222200000000000,24.77972200000000000,NULL,'Myitkyina township ',NULL),(333,'CHYCR',NULL,NULL,NULL,NULL,'BD',NULL,NULL,90.05799865722656000,24.30900001525879000,NULL,NULL,'resident'),(334,'XXNBR','Entire region',NULL,'12-48h',NULL,'GF','EDTA',NULL,-53.13400000333786000,4.11800019443035100,'+4C',NULL,NULL),(335,'RGDRP',NULL,NULL,NULL,NULL,'UG',NULL,NULL,34.17296600341797000,0.70467799901962280,NULL,'Tororo',NULL),(336,'EUUFC','Tanintharyi',NULL,NULL,NULL,'MM',NULL,NULL,98.91936492919922000,12.92146301269531200,NULL,'Dawei','resident'),(337,'QFPXT','Jinja',NULL,NULL,NULL,'UG',NULL,NULL,33.20307880640030000,0.43777272105216980,NULL,NULL,NULL),(338,'DPZDY',NULL,NULL,NULL,NULL,'TH',NULL,NULL,100.91670227050781000,18.04999923706054700,NULL,'Wang Pha',NULL),(339,'PDGZZ','Pailin',NULL,NULL,NULL,'KH',NULL,NULL,102.61302947998047000,12.84672641754150400,NULL,NULL,'resident'),(340,'TYEBG','Selangor',NULL,NULL,NULL,'MY',NULL,'Kajang',101.83078002929688000,3.13023996353149400,NULL,'Hulu Langat','resident'),(341,'TYEBG','Selangor',NULL,NULL,NULL,'MY',NULL,'Ampang',101.77515411376953000,3.15099406242370600,NULL,NULL,'resident'),(342,'TYEBG',NULL,NULL,NULL,NULL,'MY',NULL,NULL,103.34999847412110000,4.78329992294311500,NULL,'Serdang','resident'),(343,'TYEBG',NULL,NULL,NULL,NULL,'MY',NULL,NULL,101.69097137451172000,3.10462999343872070,NULL,'Kuala Lumpur','resident'),(344,'DRSRU',NULL,NULL,NULL,'Ziniare and Bousse','BF',NULL,NULL,-1.60000000000000000,12.60000000000000000,NULL,'Ziniaré and Boussé ','resident'),(345,'BFSYS',NULL,NULL,NULL,'Kilifi','KE',NULL,'Kilifi',39.85445404052734400,-3.61507034301757800,NULL,NULL,'resident'),(346,'EFNSJ',NULL,NULL,NULL,'Several','ZM',NULL,'Several',28.07000000000000000,-14.65000000000000000,NULL,NULL,'resident'),(347,'UTZZB','Southwest',NULL,NULL,'Rukungiri and Kabale','UG',NULL,NULL,30.00000000000000000,-1.26000000000000000,NULL,'Rukungiri and Kabale','resident'),(348,'UUCZG',NULL,NULL,NULL,'Kilombero and Ulanga','TZ',NULL,NULL,36.68000000000000000,-8.14000000000000000,NULL,'Kilombero and Ulanga','resident'),(349,'YJUXZ',NULL,NULL,NULL,'Gedaref','SD',NULL,'Gedaref',35.38000000000000000,14.04000000000000000,NULL,NULL,'resident'),(350,'QMJDM','KwaZulu-Natal',NULL,NULL,'Ingwavuma','ZA',NULL,'Ingwavuma',31.98000000000000000,-27.13000000000000000,NULL,NULL,'resident'),(351,'TMCZE',NULL,NULL,NULL,'Niakhar','SN',NULL,'Niakhar',-16.40000000000000000,14.48000000000000000,NULL,NULL,'resident'),(352,'BXAPK',NULL,NULL,NULL,'Abuja','NG',NULL,'Abuja',7.53000000000000000,9.08000000000000000,NULL,NULL,'resident'),(353,'ZSBZX','Kavango',NULL,NULL,'Kavango','NA',NULL,NULL,17.08000000000000000,-22.57000000000000000,NULL,NULL,'resident'),(354,'ZRMXD','Maputo Province',NULL,NULL,'Maputo','MZ',NULL,NULL,32.73000000000000000,-26.57000000000000000,NULL,NULL,'resident'),(355,'PMRZC','KE-800',NULL,NULL,'Bondo','KE',NULL,NULL,34.27000000000000000,0.24000000000000000,NULL,'Bondo','resident'),(356,'CMZMY','N’Zerekore',NULL,NULL,'Laine','GN',NULL,'Laine',-8.48000000000000000,8.08000000000000000,NULL,'Lola prefecture ',NULL),(357,'RCJJN',NULL,NULL,NULL,'Navrongo','GH',NULL,'Navrongo',-1.09000000000000000,10.90000000000000000,NULL,'Kassena-Nankana District','resident'),(358,'DEDSE',NULL,NULL,NULL,'Lambarene','GA',NULL,'Lambarene',10.21000000000000000,-0.71000000000000000,NULL,NULL,'resident'),(359,'RMTGP',NULL,NULL,NULL,'Humera','ET',NULL,'Humera',36.66000000000000000,14.32000000000000000,NULL,NULL,'resident'),(360,'UJAGF','South Kivu Province',NULL,NULL,'Shabunda','CD',NULL,'Shabunda',27.33000000000000000,-2.70000000000000000,NULL,NULL,'resident'),(361,'ZYTBB',NULL,NULL,NULL,'Kindamba','CG',NULL,'Kindamba',15.05000000000000000,-4.30000000000000000,NULL,'Kindamba','resident'),(362,'CXZEM',NULL,NULL,NULL,'Mutengene','CM',NULL,' Mutengene',9.31000000000000000,4.10000000000000000,NULL,NULL,'resident'),(363,'CXZEM',NULL,NULL,NULL,'Yaounde','CM',NULL,'Yaounde',11.51000000000000000,3.86000000000000000,NULL,NULL,'resident'),(364,'ZZSPY','Bahr el Ghazal',NULL,NULL,'Akuem','SD',NULL,'Akuem',29.93459170000000000,9.19141110000000000,NULL,'Yargot',NULL),(365,'KPEAT','Madhya Pradesh',NULL,NULL,'Jablapur and Maihar','IN',NULL,'Jablapur and Maihar',79.78271484375000000,24.60826776419512000,NULL,'Jabalpur and Satna',NULL),(366,'ZNBUC','Cordoba',NULL,NULL,'Tierralta/Puerto Libertador','CO',NULL,'Tierralta',-76.00633621215820000,8.65824493608043300,NULL,'Monteria',NULL),(367,'ZNBUC','Guaviare',NULL,NULL,'La Carpa','CO',NULL,'La Carpa',-72.97119140625000000,2.28455066023697000,NULL,'San Jose',NULL),(368,'ZNBUC','Vichada',NULL,NULL,'Casuarito','CO',NULL,'Casuarito',-67.63183593750000000,5.92204461988330500,NULL,NULL,NULL),(369,'AKUQT','Tanga',NULL,NULL,'Mkokola','TZ',NULL,'Mkokola',38.54165000000000000,-5.10989000000000000,NULL,'Korogwe',NULL),(370,'AKUQT','Tanga',NULL,NULL,'Kwamasimba','TZ',NULL,'Kwamasimba',38.43007000000000000,-5.11149000000000000,NULL,'Korogwe',NULL),(371,'PGBUJ','Grand Comore',NULL,NULL,'Grande Comore','KM',NULL,NULL,43.35997000000000000,-11.65158000000000000,NULL,NULL,NULL),(372,'PGBUJ','Mohéli',NULL,NULL,'Moheli','KM',NULL,NULL,43.74103200000000000,-12.31518000000000000,NULL,NULL,NULL),(373,'PGBUJ','Anjouan',NULL,NULL,'Anjouan','KM',NULL,NULL,44.37088000000000000,-12.22338000000000000,NULL,NULL,NULL),(374,'PGBUJ',NULL,NULL,NULL,'Central Eastern','MG',NULL,'Moramanga',48.22182800000000000,-18.94767000000000000,NULL,NULL,NULL),(375,'PGBUJ',NULL,NULL,NULL,'Central Western','MG',NULL,'Miandrivazo',45.45550200000000000,-19.52997000000000000,NULL,NULL,NULL),(376,'PGBUJ',NULL,NULL,NULL,'North Western','MG',NULL,'Mahajanga',46.31552100000000000,-15.71372000000000000,NULL,NULL,NULL),(377,'PGBUJ',NULL,NULL,NULL,'South Western','MG',NULL,'Ejeda',44.52246900000000000,-24.33922000000000000,NULL,NULL,NULL),(378,'PGBUJ',NULL,NULL,NULL,'South Eastern','MG',NULL,'Farafangana',47.83046000000000000,-22.82295000000000000,NULL,NULL,NULL),(379,'PGBUJ',NULL,NULL,NULL,'North Eastern','MG',NULL,'Antsiranana',49.29085900000000000,-12.28090000000000000,NULL,NULL,NULL),(380,'KGUJT',NULL,NULL,NULL,'BELA VISTA','MZ',NULL,'BELA VISTA',32.66750000000000000,-26.34110000000000000,NULL,'MATATUINE',NULL),(381,'KGUJT',NULL,NULL,NULL,'CHANGALANE','MZ',NULL,'CHANGALANE',32.19400000000000000,-26.28950000000000000,NULL,'NAMAACHA',NULL),(382,'KGUJT',NULL,NULL,NULL,'NAMAACHA','MZ',NULL,'NAMAACHA',32.01880000000000000,-25.97600000000000000,NULL,'NAMAACHA',NULL),(383,'KGUJT',NULL,NULL,NULL,'SALAMANGA','MZ',NULL,'SALAMANGA',32.65070000000000000,-26.48990000000000000,NULL,'MATATUINE',NULL),(384,'KGUJT',NULL,NULL,NULL,'PONTO DO OURO','MZ',NULL,'PONTO DO OURO',32.86720000000000000,-26.83470000000000000,NULL,'MATATUINE',NULL),(385,'KGUJT',NULL,NULL,NULL,'ZITUNDO','MZ',NULL,'ZITUNDO',32.82690000000000000,-26.75220000000000000,NULL,'MATATUINE',NULL),(386,'KGUJT',NULL,NULL,NULL,'MATOLA RIO','MZ',NULL,'MATOLA RIO',32.42760000000000000,-25.97860000000000000,NULL,'MATOLA',NULL),(387,'KGUJT',NULL,NULL,NULL,'MUSSUMBOLOCO','MZ',NULL,'MUSSUMBOLOCO',32.44527800000000000,-25.91138900000000000,NULL,'MATOLA',NULL),(388,'KGUJT',NULL,NULL,NULL,'BELULUANE 24','MZ',NULL,'BELULUANE 24',32.37080000000000000,-25.92950000000000000,NULL,'BOANE',NULL),(389,'KGUJT',NULL,NULL,NULL,'BELULUANE A','MZ',NULL,'BELULUANE A',32.37960000000000000,-25.90790000000000000,NULL,'BOANE',NULL),(390,'KGUJT',NULL,NULL,NULL,'MATOLA C','MZ',NULL,'MATOLA C',32.44820000000000000,-25.94980000000000000,NULL,'MATOLA',NULL),(391,'KGUJT',NULL,NULL,NULL,'BOANE SEDE','MZ',NULL,'BOANE SEDE',32.33040000000000000,-26.04320000000000000,NULL,'BOANE',NULL),(392,'KGUJT',NULL,NULL,NULL,'PICOCO','MZ',NULL,'PICOCO ',32.35044100000000000,-26.00658300000000000,NULL,'BOANE',NULL),(393,'KGUJT',NULL,NULL,NULL,'AGOSTINHO NETO','MZ',NULL,'AGOSTINHO NETO',32.67470000000000000,-25.73850000000000000,NULL,'MARRACUENE',NULL),(394,'KGUJT',NULL,NULL,NULL,'BOBOLE','MZ',NULL,'BOBOLE',32.67390000000000000,-25.60280000000000000,NULL,'MARRACUENE',NULL),(395,'KGUJT',NULL,NULL,NULL,'CORRUMANE','MZ',NULL,'CORRUMANE',35.34700012207031000,-17.90600013732910000,NULL,'MOAMBO',NULL),(396,'KGUJT',NULL,NULL,NULL,'MACHUBO','MZ',NULL,'MACHUBO',32.88750000000000000,-25.52080000000000000,NULL,'MARRACUENE',NULL),(397,'KGUJT',NULL,NULL,NULL,'MARRACUENE','MZ',NULL,'MARRACUENE',32.67470000000000000,-25.73850000000000000,NULL,'MARRACUENE',NULL),(398,'KGUJT',NULL,NULL,NULL,'MAVUNGUANA','MZ',NULL,'MAVUNGUANA',32.18900000000000000,-24.94400000000000000,NULL,'MOAMBO',NULL),(399,'KGUJT',NULL,NULL,NULL,'MOAMBA','MZ',NULL,'MOAMBO',32.25190000000000000,-25.59580000000000000,NULL,'MOAMBO',NULL),(400,'KGUJT',NULL,NULL,NULL,'RESSANO GARCIA','MZ',NULL,'RESSANO GARCIA',31.99940000000000000,-25.44500000000000000,NULL,'MOAMBO',NULL),(401,'KGUJT',NULL,NULL,NULL,'CHOBELA','MZ',NULL,'CHOBELA',32.69640000000000000,-25.00940000000000000,NULL,'MAGUDE',NULL),(402,'KGUJT',NULL,NULL,NULL,'MAGUDE','MZ',NULL,'MAGUDE',32.65280000000000000,-25.02550000000000000,NULL,'MAGUDE',NULL),(403,'KGUJT',NULL,NULL,NULL,'MAPULANGUENE','MZ',NULL,'MAPULANGUENE',32.09400000000000000,-24.48620000000000000,NULL,'MAGUDE',NULL),(404,'KGUJT',NULL,NULL,NULL,'MOTAZE','MZ',NULL,'MOTAZE',32.85960000000000000,-24.80440000000000000,NULL,'MAGUDE',NULL),(405,'HUNKC','Binh Phuoc & Dak Nong provinces',NULL,'12-48h',NULL,'VN','EDTA','Bu Dang, Dak Nhau, Bom Bo, Dak\'O & Dak Ru',106.99299621582031000,16.80299949645996000,'+4C','Bu Dang, Phuoc Long & Dak R\'Lap','traveller'),(406,'TFCBZ',NULL,NULL,'12-48h',NULL,'FR','ACD',NULL,2.33800005912780760,46.64199829101562500,'+4C',NULL,NULL),(407,'MGEXQ',NULL,NULL,NULL,NULL,'CO',NULL,'Quibdo',-77.20078222453594000,5.84577061235904700,NULL,'Choco',NULL),(408,'TZGCM','Simdega',NULL,NULL,NULL,'IN',NULL,NULL,84.70796003937721000,22.42778018116951000,NULL,'Jaldega','resident'),(409,'PPPGP',NULL,NULL,NULL,NULL,'UG',NULL,NULL,31.36000022292137000,0.58916732668876650,NULL,'Mubende','resident'),(410,'RHAAR',NULL,NULL,NULL,NULL,'UG',NULL,NULL,31.75361104309559000,3.62805582582950600,NULL,'Moyo',NULL),(411,'XQJPQ','Mae sot',NULL,NULL,NULL,'TH',NULL,NULL,98.54210000000000000,16.70330000000000000,NULL,NULL,NULL); /*!40000 ALTER TABLE `ch_sites` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `location` -- DROP TABLE IF EXISTS `location`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `location` ( `locationId` int(11) NOT NULL DEFAULT '0', `countryId` int(11) NOT NULL, `lat` decimal(20,17) NOT NULL, `lon` decimal(20,17) NOT NULL, `countryRegion` varchar(45) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `district` varchar(45) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `locality` varchar(45) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `location` -- LOCK TABLES `location` WRITE; /*!40000 ALTER TABLE `location` DISABLE KEYS */; /*!40000 ALTER TABLE `location` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `siteLocation` -- DROP TABLE IF EXISTS `siteLocation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `siteLocation` ( `siteId` int(11) NOT NULL, `locationId` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `siteLocation` -- LOCK TABLES `siteLocation` WRITE; /*!40000 ALTER TABLE `siteLocation` DISABLE KEYS */; /*!40000 ALTER TABLE `siteLocation` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'testdb' -- /*!50003 DROP PROCEDURE IF EXISTS `createLocations` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `createLocations`() BEGIN TRUNCATE TABLE siteLocation; SET FOREIGN_KEY_CHECKS=0; TRUNCATE TABLE location; SET FOREIGN_KEY_CHECKS=1; BEGIN DECLARE done INT DEFAULT FALSE; DECLARE siteId int(11); DECLARE Latitude1 varchar(255); DECLARE Lat1 DECIMAL(9,6); DECLARE MinLat DECIMAL(9,6); DECLARE MaxLat DECIMAL(9,6); DECLARE Longitude1 varchar(255); DECLARE Lon1 DECIMAL(9,6); DECLARE MinLon DECIMAL(9,6); DECLARE MaxLon DECIMAL(9,6); DECLARE Country1 varchar(255); DECLARE Region1 varchar(255); DECLARE locationId1 int(11); DECLARE cur1 CURSOR FOR select ch_sites_id, Latitude, Longitude,Region, Country FROM ch_sites LEFT JOIN siteLocation ON ch_sites.ch_sites_id = siteLocation.siteId WHERE siteLocation.locationId IS NULL; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE; OPEN cur1; read_loop: LOOP FETCH cur1 INTO siteId, Latitude1, Longitude1,Region1, Country1; IF done THEN LEAVE read_loop; END IF; SELECT CAST(Latitude1 AS DECIMAL(9,6)) INTO Lat1; SELECT CAST(Longitude1 AS DECIMAL(9,6)) INTO Lon1; SELECT LEAST(Lat1 - 0.01, Lat1 + 0.01) INTO minLat; SELECT GREATEST(Lat1 + 0.01, Lat1 - 0.01) INTO maxLat; SELECT LEAST(Lon1 - 0.01, Lon1 + 0.01) INTO minLon; SELECT GREATEST(Lon1 - 0.01, Lon1 + 0.01) INTO maxLon; SELECT locationId FROM `location` WHERE (lat > minLat AND lat < maxLat) AND (lon > minLon AND lon < maxLon) INTO locationId1; SET @matches = FOUND_ROWS(); IF @matches = 0 THEN INSERT INTO `location` (countryId, lat,lon) SELECT (select countryId from COUNTRY where iso = Country1 ), Lat1, Lon1; SELECT LAST_INSERT_ID() INTO locationId1; END IF; INSERT INTO `siteLocation` (`siteId`,`locationId`) VALUES(siteId,locationId1); SET done = FALSE; END LOOP; CLOSE cur1; END; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2012-07-09 15:24:15