drop table if exists geo_town;
CREATE TABLE `geo_town` (`gt_id` mediumint(8) unsigned NOT NULL auto_increment,`gt_country` mediumint(8) unsigned default NULL,`gt_r1` mediumint(8) unsigned default NULL,`gt_r2` mediumint(8) unsigned default NULL,`gt_r3` mediumint(8) unsigned default NULL,`gt_lat` decimal(9,5) default NULL,`gt_long` decimal(9,5) default NULL,`gt_point` point NOT NULL,`gt_postal` varchar(10) NOT NULL,`gt_name` varchar(100) default NULL,PRIMARY KEY  (`gt_id`),KEY `gt_postal` (`gt_postal`),KEY `gt_country` (`gt_country`),SPATIAL KEY `sp_index` (`gt_point`(32)),FULLTEXT KEY `gt_name` (`gt_name`)) ENGINE=MyISAM AUTO_INCREMENT=594297 DEFAULT CHARSET=latin1 PACK_KEYS=1 CHECKSUM=1 AUTO_INCREMENT=594297;
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (10848183,13458212,14201712,1251377,1714059865.5014629364,876071782.0924690962,GeomFromText('POINT(91 173)'),'brisket','coda\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (16749108,2295798,1557771,10232784,1238201252.8241188526,724354589.4030263424,GeomFromText('POINT(14 230)'),'cyberneticist\'s','Biebel\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (2446080,5255405,15831751,6190611,1903031707.5577793121,1502586295.4883294106,GeomFromText('POINT(117 132)'),'segregated','Lenwood\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (9133618,6159988,13667623,5056662,1802054236.9891483784,316739602.7649696469,GeomFromText('POINT(23 151)'),'baking','dwarfism\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (7850645,15522762,7224543,8359581,891853001.9789488316,625965762.1390384436,GeomFromText('POINT(74 110)'),'sipper','youths');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (956341,9478077,6727847,4129221,541226283.6917614937,499991865.7507795691,GeomFromText('POINT(102 13)'),'achiest','dumbfound');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (3914280,10003749,8089784,16470991,177052182.8692172766,1730923453.4800758362,GeomFromText('POINT(126 13)'),'Clearasil\'s','Minnnie\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (11583675,14492410,5449377,16614354,190707509.4430916905,639502347.0312802792,GeomFromText('POINT(13 88)'),'stoppling','Elvina\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (14995088,5971089,2066856,13505954,1246472816.0095999241,461406013.7113144994,GeomFromText('POINT(152 200)'),'helldiver\'s','greyness');
delete from geo_town order by rand() limit 1;
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (9074076,12421494,9519743,15161275,1967050822.1344950199,1902980637.4494037628,GeomFromText('POINT(242 150)'),'Rayner','Gisser\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (8340854,34383,13049977,12696239,1931469523.1077268124,545811276.0107495785,GeomFromText('POINT(126 159)'),'septuplet','stipulating');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (4048681,13522971,5755148,7065265,1012418662.2913022041,1435341331.4360389709,GeomFromText('POINT(235 9)'),'achievement\'s','monopoles');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (14288396,9977129,5232753,1561071,31326148.4464339390,420680656.1316601634,GeomFromText('POINT(253 249)'),'Honduras','manganate\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (7553915,11214363,3219993,12833635,1609693190.0041973591,441134599.7487967610,GeomFromText('POINT(182 120)'),'consistories','hydrae');
delete from geo_town order by rand() limit 1;
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (6695872,6575567,14887497,15898521,75710995.7753476351,1960977162.2689507008,GeomFromText('POINT(73 187)'),'reechoes','assumings');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (621521,5564408,11689559,7501756,66185667.5884840339,346321743.4818016887,GeomFromText('POINT(4 17)'),'unimpressive','unsymmetrical');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (16490014,11638733,10154502,9219587,1901257880.7320475578,1877947733.5183267593,GeomFromText('POINT(59 11)'),'gnocchi','sonde\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (10646508,293887,13043720,13274994,2130388001.4572284222,1253198394.0544118881,GeomFromText('POINT(242 142)'),'Thetisa','Sadler');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (1512713,13679560,108831,15161196,1285192182.7001726627,1671417060.7912504673,GeomFromText('POINT(32 186)'),'Pauletta\'s','Li\'s');
delete from geo_town order by rand() limit 1;
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (15594881,14375430,8890993,10768473,590322514.2991908789,111524305.4589896351,GeomFromText('POINT(78 198)'),'Goodhen','gelding');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (12615674,3404201,11879232,2767595,205337177.4341520071,866020742.7866002321,GeomFromText('POINT(129 235)'),'ineligibles','restudy\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (11521815,428579,3320262,9304773,914655983.5909316540,618805145.0878802538,GeomFromText('POINT(99 182)'),'clodhopper\'s','sequential');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (2161386,404212,8274657,14846636,808990653.7547091246,182165326.5935499668,GeomFromText('POINT(109 114)'),'remonstrating','Jereme');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (11428697,1952100,7878906,14196086,442030872.5354737639,1400610751.9623906612,GeomFromText('POINT(119 197)'),'slowcoach\'s','garbageman');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (15378964,15519866,1747613,5337385,1301813608.8997604847,301912744.4633693099,GeomFromText('POINT(92 209)'),'queenly','windmill\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (9846810,13749916,3143405,6472269,580281152.5690851212,1222535861.7565448284,GeomFromText('POINT(69 128)'),'hearer','established');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (765493,15577803,2288856,11673347,1170679814.8285899162,66389668.5927411616,GeomFromText('POINT(162 210)'),'Carew\'s','crenulated');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (15960535,15838908,11130516,11822688,2004119776.3496985435,496424996.6646380424,GeomFromText('POINT(190 239)'),'disillusions','Carie');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (2385998,4366770,4559089,7079141,2134167789.0382230282,915279831.7804235220,GeomFromText('POINT(215 147)'),'palled','Adelheid\'s');
INSERT IGNORE INTO `test`.`geo_town`(`gt_country`,`gt_r1`,`gt_r2`,`gt_r3`,`gt_lat`,`gt_long`,`gt_point`,`gt_postal`,`gt_name`)VALUES (2702953,12079609,13814598,14950981,550912599.4596545696,2038766084.7189190388,GeomFromText('POINT(186 220)'),'Dominguez','Kalevala');
optimize table geo_town;
show warnings;