Attached SQL file is missing, So I am adding content in post directly :
CREATE TABLE Country (
country_id INT(10),
country_name CHAR(30),
Continent CHAR(30),
PRIMARY KEY (country_id)
) WITH "template=partitioned, backups=1";
CREATE TABLE City (
city_id INT(15),
country_name CHAR(30),
city_name CHAR(50),
Dist CHAR(20),
PRIMARY KEY (city_id,country_name)
) WITH "template=partitioned, backups=1, affinityKey=country_name";
insert into Country values('101','Russia','Russia');
insert into Country values('102','India','Asia');
insert into Country values('103','United States','America');
insert into City
values('12554105','Russia','CITY_00000000012554105','SNZa');
insert into City values('20467','Russia','CITY_00000003720467','SN');
insert into City values('10498','Russia','CITY_00000003710498','SNZa');
insert into City values('13617','Russia','CITY_00000003713617','SNZb');
insert into City values('13628','Russia','CITY_00000003713628','SNZd');
insert into City values('10502','Russia','CITY_00000004610502','SN');
insert into City values('703166','Russia','CITY_000000046703166','1');
insert into City values('13656','Russia','CITY_00000007313656','SN');
insert into City values('10507','Russia','CITY_00000007310507','SNZa');
insert into City values('13620','Russia','CITY_00000007313620','SNZc');
insert into City values('13629','Russia','CITY_00000007313629','SNZe');
insert into City values('10508','Russia','CITY_00000009110508','SN');
insert into City values('47403','Russia','CITY_00000009147403','1');
insert into City values('16774','Russia','CITY_00000011616774','SN');
insert into City values('16773','Russia','CITY_00000012516773','SN');
insert into City values('16778','Russia','CITY_00000014316778','SN');
insert into City values('16779','Russia','CITY_00000016116779','SN');
insert into City values('734192','Russia','CITY_000000161734192','1');
insert into City values('699080','Russia','CITY_000000161699080','01Za');
insert into City values('16781','Russia','CITY_00000017016781','SN');
insert into City values('16780','Russia','CITY_00000018916780','SN');
insert into City values('16802','Russia','CITY_00000019816802','SN');
insert into City values('16803','Russia','CITY_00000020416803','SN');
insert into City values('457688','Russia','CITY_000000204457688','1');
insert into City values('16806','Russia','CITY_00000021316806','SN');
insert into City values('16809','Russia','CITY_00000023116809','SN');
insert into City values('16815','Russia','CITY_00000024016815','SN');
insert into City values('6957','Russia','CITY_0000053886957','SN');
insert into City values('6747','Russia','CITY_0000053886747','SNZa');
insert into City values('21048','Russia','CITY_00000538821048','SNZj');
insert into City values('21058','Russia','CITY_00000538821058','01Za');
insert into City values('21068','Russia','CITY_00000545821068','SN');
insert into City values('6749','Russia','CITY_0000054586749','SNZa');
insert into City values('6780','Russia','CITY_0000054586780','SNZb');
insert into City values('113520','Russia','CITY_000005467113520','SN');
insert into City values('6750','Russia','CITY_0000054676750','SNZa');
insert into City values('6820','Russia','CITY_0000054676820','SNZb');
insert into City values('21066','Russia','CITY_00000546721066','SNZc');
insert into City values('6751','Russia','CITY_0000054766751','SNZa');
insert into City values('6821','Russia','CITY_0000054766821','SNAb');
insert into City values('113679','Russia','CITY_000005485113679','SN');
insert into City values('6822','Russia','CITY_0000054856822','SNAb');
insert into City values('6916','Russia','CITY_0000054856916','SNAc');
insert into City values('21064','Russia','CITY_00000548521064','SNAd');
insert into City values('23992','Russia','CITY_00000548523992','SNAe');
insert into City values('223623','Russia','CITY_000005485223623','1');
insert into City values('113562','Russia','CITY_000005494113562','SN');
insert into City values('6823','Russia','CITY_0000054946823','SNAb');
insert into City values('6840','Russia','CITY_0000054946840','SNAc');
insert into City values('21070','Russia','CITY_00000549421070','SNAd');
insert into City values('21859','Russia','CITY_00000549421859','SNAe');
insert into City values('50388','Russia','CITY_00000549450388','SNAf');
insert into City values('122190','Russia','CITY_000005494122190','1');
insert into City values('114520','Russia','CITY_000005494114520','01Aa');
insert into City values('118632','Russia','CITY_000005494118632','01Ab');
insert into City values('121228','Russia','CITY_000005494121228','01Ac');
insert into City values('125075','Russia','CITY_000005494125075','2');
insert into City values('7774147','Russia','CITY_0000054947774147','3');
insert into City values('7764624','Russia','CITY_0000054947764624','03Aa');
insert into City values('8002672','Russia','CITY_0000054948002672','4');
insert into City values('8153942','Russia','CITY_0000054948153942','5');
insert into City values('21857','Russia','CITY_00000576821857','SN');
insert into City values('6837','Russia','CITY_0000057686837','SNAc');
insert into City values('21071','Russia','CITY_00000576821071','SNAd');
insert into City values('8153946','Russia','CITY_0000057688153946','1');
insert into City values('8153949','Russia','CITY_0000057688153949','2');
insert into City values('50701','Russia','CITY_00000578650701','SN');
insert into City values('6825','Russia','CITY_0000057866825','SNAb');
insert into City values('6936','Russia','CITY_0000057866936','SNAc');
insert into City values('21062','Russia','CITY_00000578621062','SNAd');
insert into City values('21854','Russia','CITY_00000578621854','SNBe');
insert into City values('49691','Russia','CITY_00000578649691','SNBf');
insert into City values('50368','Russia','CITY_00000578650368','SNBg');
insert into City values('50673','Russia','CITY_00000578650673','SNBh');
insert into City values('1189982','Russia','CITY_0000057861189982','1');
insert into City values('50699','Russia','CITY_00000579550699','SN');
insert into City values('6826','Russia','CITY_0000057956826','SNBb');
insert into City values('6941','Russia','CITY_0000057956941','SNBc');
insert into City values('21060','Russia','CITY_00000579521060','SNBd');
insert into City values('21855','Russia','CITY_00000579521855','SNBe');
insert into City values('49690','Russia','CITY_00000579549690','SNBf');
insert into City values('50369','Russia','CITY_00000579550369','SNBg');
insert into City values('50484','Russia','CITY_00000579550484','SNBh');
insert into City values('50675','Russia','CITY_00000579550675','SNBi');
insert into City values('1190096','Russia','CITY_0000057951190096','1');
insert into City values('113616','Russia','CITY_000005810113616','SN');
insert into City values('6949','Russia','CITY_0000058106949','SNBd');
insert into City values('21043','Russia','CITY_00000581021043','SNBe');
insert into City values('105484','Russia','CITY_000005865105484','SN');
insert into City values('6951','Russia','CITY_0000058656951','SNBc');
insert into City values('21046','Russia','CITY_00000586521046','SNCd');
insert into City values('24635','Russia','CITY_00000586524635','SNCe');
insert into City values('46650','Russia','CITY_00000586546650','SNCf');
insert into City values('9590616','Russia','CITY_0000058659590616','1');
insert into City values('21084','Russia','CITY_00000608621084','SN');
insert into City values('21082','Russia','CITY_00000609521082','SN');
insert into City values('7397166','Russia','CITY_0000060957397166','1');
insert into City values('21371','Russia','CITY_00000615621371','SNCd');
insert into City values('21373','Russia','CITY_00000617421373','SNCd');
insert into City values('24237','Russia','CITY_00000617424237','SNCe');
insert into City values('24660','Russia','CITY_00000617424660','SNCf');
insert into City values('21703','Russia','CITY_00000619221703','SN');
insert into City values('21734','Russia','CITY_00000620821734','SN');
insert into City values('6816','Russia','CITY_0000062086816','SNCb');
insert into City values('7020','Russia','CITY_0000062087020','SNCc');
insert into City values('21041','Russia','CITY_00000620821041','SNCd');
insert into City values('6065581','Russia','CITY_0000062086065581','1');
insert into City values('21088','Russia','CITY_00000624421088','SN');
insert into City values('987784','Russia','CITY_000006262987784','SN');
insert into City values('21080','Russia','CITY_00000626221080','SNCf');
insert into City values('21811','Russia','CITY_00000626221811','SNCg');
insert into City values('989894','Russia','CITY_000006262989894','1');
insert into City values('7011','Russia','CITY_0000063057011','SN');
insert into City values('21898','Russia','CITY_00000652721898','SN');
insert into City values('6946','Russia','CITY_0000065276946','SNCc');
insert into City values('21858','Russia','CITY_00000652721858','SNCe');
insert into City values('24637','Russia','CITY_00000653624637','SN');
insert into City values('21092','Russia','CITY_00000653621092','SNCc');
insert into City values('21093','Russia','CITY_00000655421093','SNCc');
insert into City values('21372','Russia','CITY_00000656321372','SNCc');
insert into City values('39367','Russia','CITY_00000656339367','SNCf');
insert into City values('21086','Russia','CITY_00000663321086','SN');
insert into City values('6852','Russia','CITY_0000067496852','SNCa');
insert into City values('7109','Russia','CITY_0000068557109','SNCb');
insert into City values('7041','Russia','CITY_0000078637041','SN');
insert into City values('42730','Russia','CITY_00000786342730','01Ca');
insert into City values('6995','Russia','CITY_0000080846995','SN');
insert into City values('13553','Russia','CITY_00000808413553','1');
insert into City values('19104','Russia','CITY_00000808419104','2');
insert into City values('13586','Russia','CITY_00000809313586','SN');
insert into City values('7132','Russia','CITY_0000080937132','SNCb');
insert into City values('7671','Russia','CITY_0000080937671','SNCd');
insert into City values('19058','Russia','CITY_00000809319058','1');
insert into City values('13589','Russia','CITY_00000810913589','SN');
insert into City values('6997','Russia','CITY_0000081096997','SNCa');
insert into City values('19110','Russia','CITY_00000810919110','1');
insert into City values('6998','Russia','CITY_0000081186998','SN');
insert into City values('6999','Russia','CITY_0000081276999','SN');
insert into City values('7000','Russia','CITY_0000081367000','SN');
insert into City values('13607','Russia','CITY_00000814513607','SN');
insert into City values('13588','Russia','CITY_00000814513588','SNCb');
insert into City values('19088','Russia','CITY_00000814519088','1');
insert into City values('7002','Russia','CITY_0000081547002','SN');
insert into City values('7003','Russia','CITY_0000081637003','SN');
insert into City values('7004','Russia','CITY_0000081727004','SN');
insert into City values('13559','Russia','CITY_00000817213559','1');
insert into City values('13610','Russia','CITY_00000817213610','2');
insert into City values('13587','Russia','CITY_00000817213587','02Ca');
insert into City values('7005','Russia','CITY_0000081817005','SN');
insert into City values('7006','Russia','CITY_0000081907006','SN');
insert into City values('7007','Russia','CITY_0000082067007','SN');
insert into City values('13571','Russia','CITY_00000821513571','SN');
insert into City values('7008','Russia','CITY_0000082157008','SNCa');
insert into City values('7009','Russia','CITY_0000082247009','SN');
insert into City values('7056','Russia','CITY_0000082607056','SNCc');
insert into City values('13572','Russia','CITY_00000827913572','SN');
insert into City values('7024','Russia','CITY_0000082797024','SNCa');
insert into City values('7084','Russia','CITY_0000082797084','SNCb');
insert into City values('13581','Russia','CITY_00000827913581','1');
insert into City values('13579','Russia','CITY_00000827913579','01Cb');
insert into City values('33875','Russia','CITY_00000827933875','2');
insert into City values('7042','Russia','CITY_0000082977042','SN');
insert into City values('7078','Russia','CITY_0000083127078','SN');
insert into City values('13582','Russia','CITY_00000831213582','1');
insert into City values('33874','Russia','CITY_00000831233874','2');
insert into City values('7043','Russia','CITY_0000083217043','SNCb');
insert into City values('7044','Russia','CITY_0000083307044','SN');
insert into City values('7030','Russia','CITY_0000083497030','SN');
insert into City values('13550','Russia','CITY_00000834913550','1');
insert into City values('7529','Russia','CITY_0000083497529','01Ca');
insert into City values('13551','Russia','CITY_00000834913551','2');
insert into City values('7104','Russia','CITY_0000083677104','SN');
insert into City values('7040','Russia','CITY_0000083677040','SNCb');
insert into City values('7045','Russia','CITY_0000083767045','SN');
insert into City values('303450','Russia','CITY_000008385303450','SN');
insert into City values('7034','Russia','CITY_0000083857034','SNCa');
insert into City values('7046','Russia','CITY_0000083857046','SNCb');
insert into City values('7072','Russia','CITY_0000083857072','SNEc');
insert into City values('7442','Russia','CITY_0000083947442','SN');
insert into City values('7115','Russia','CITY_0000083947115','SNEb');
insert into City values('7698','Russia','CITY_0000084197698','SN');
insert into City values('7037','Russia','CITY_0000084197037','SNEa');
insert into City values('19113','Russia','CITY_00000844619113','SN');
insert into City values('7039','Russia','CITY_0000084467039','SNEa');
insert into City values('7425','Russia','CITY_0000084467425','SNEb');
insert into City values('7049','Russia','CITY_0000084827049','SN');
insert into City values('7139','Russia','CITY_0000084917139','SN');
insert into City values('7051','Russia','CITY_0000084917051','SNEa');
insert into City values('13548','Russia','CITY_00000849113548','1');
insert into City values('7527','Russia','CITY_0000084917527','01Ea');
insert into City values('7052','Russia','CITY_0000085077052','SN');
insert into City values('7053','Russia','CITY_0000085167053','SN');
insert into City values('7447','Russia','CITY_0000085347447','SN');
insert into City values('7057','Russia','CITY_0000085347057','SNEa');
insert into City values('7537','Russia','CITY_0000085347537','1');
insert into City values('7592','Russia','CITY_0000085347592','2');
insert into City values('7580','Russia','CITY_0000085347580','02Ea');
insert into City values('7647','Russia','CITY_0000085347647','3');
insert into City values('13557','Russia','CITY_00000854313557','SN');
insert into City values('7211','Russia','CITY_0000085437211','SNEc');
insert into City values('13568','Russia','CITY_00000854313568','1');
insert into City values('7137','Russia','CITY_0000087927137','SNEb');
insert into City values('21111','Russia','CITY_00000879221111','SNEc');
insert into City values('21925','Russia','CITY_00000879221925','SNEd');
insert into City values('21947','Russia','CITY_00000879221947','SNEe');
insert into City values('1311335','Russia','CITY_0000088531311335','SNEb');
insert into City values('7144','Russia','CITY_0000090477144','SNEa');
insert into City values('21103','Russia','CITY_00000904721103','SNEb');
insert into City values('7147','Russia','CITY_0000090837147','SNEa');
insert into City values('21116','Russia','CITY_00000908321116','SNEb');
insert into City values('21944','Russia','CITY_00000908321944','SNEc');
insert into City values('7206','Russia','CITY_0000090927206','SN');
insert into City values('7148','Russia','CITY_0000090927148','SNEa');
insert into City values('7205','Russia','CITY_0000091177205','SN');
insert into City values('7150','Russia','CITY_0000091177150','SNEa');
insert into City values('7156','Russia','CITY_0000091357156','SNEa');
insert into City values('7154','Russia','CITY_0000091447154','SN');
insert into City values('7163','Russia','CITY_0000092327163','SNEa');
insert into City values('21101','Russia','CITY_00000923221101','SNEb');
insert into City values('7165','Russia','CITY_0000092507165','SNEa');
insert into City values('7196','Russia','CITY_0000092697196','SNEb');
insert into City values('21114','Russia','CITY_00000926921114','SNEc');
insert into City values('21917','Russia','CITY_00000926921917','SNEd');
insert into City values('7167','Russia','CITY_0000092787167','SN');
insert into City values('7168','Russia','CITY_0000092877168','SNEa');
insert into City values('7169','Russia','CITY_0000092967169','SNEa');
insert into City values('7204','Russia','CITY_0000093027204','SN');
insert into City values('7170','Russia','CITY_0000093027170','SNEa');
insert into City values('7747','Russia','CITY_0000093397747','SN');
insert into City values('7173','Russia','CITY_0000093397173','SNZa');
insert into City values('30141','Russia','CITY_00000933930141','1');
insert into City values('7740','Russia','CITY_0000093757740','SNZc');
insert into City values('7180','Russia','CITY_0000094097180','SN');
insert into City values('7181','Russia','CITY_0000094187181','SN');
insert into City values('7182','Russia','CITY_0000094277182','SN');
insert into City values('7186','Russia','CITY_0000094727186','SN');
insert into City values('7187','Russia','CITY_0000094817187','SN');
insert into City values('7188','Russia','CITY_0000094907188','SN');
insert into City values('7197','Russia','CITY_0000095517197','SNZa');
insert into City values('7208','Russia','CITY_0000095977208','SN');
insert into City values('7213','Russia','CITY_0000096307213','SNZa');
insert into City values('21105','Russia','CITY_00000963021105','SNZb');
insert into City values('7216','Russia','CITY_0000096677216','SNZa');
insert into City values('21107','Russia','CITY_00000966721107','SNZb');
insert into City values('7502','Russia','CITY_0000096947502','SN');
insert into City values('7219','Russia','CITY_0000096947219','SNZa');
insert into City values('7220','Russia','CITY_0000097197220','SNZa');
insert into City values('21118','Russia','CITY_00000971921118','SNZb');
insert into City values('24083','Russia','CITY_00000971924083','SNZc');
insert into City values('7238','Russia','CITY_0000098987238','SNZa');
insert into City values('21133','Russia','CITY_00000989821133','SNZb');
insert into City values('24402','Russia','CITY_00000992224402','SN');
insert into City values('7242','Russia','CITY_0000099227242','SNZa');
insert into City values('21110','Russia','CITY_00000992221110','SNZb');
insert into City values('21940','Russia','CITY_00000992221940','SNZc');
insert into City values('44586','Russia','CITY_00000996844586','SN');
insert into City values('7246','Russia','CITY_0000099687246','SNZa');
insert into City values('21430','Russia','CITY_00000996821430','SNZb');
insert into City values('5910180','Russia','CITY_0000099685910180','1');
insert into City values('44576','Russia','CITY_00001000744576','SN');
insert into City values('7255','Russia','CITY_0000100077255','SNZa');
insert into City values('21431','Russia','CITY_00001000721431','SNZb');
insert into City values('22702','Russia','CITY_00001000722702','SNZc');
insert into City values('23545','Russia','CITY_00001000723545','SNZd');
insert into City values('7742','Russia','CITY_0000100257742','SN');
insert into City values('7261','Russia','CITY_0000100257261','SNZa');
insert into City values('7266','Russia','CITY_0000101047266','SN');
insert into City values('9018','Russia','CITY_0000101049018','1');
insert into City values('9137','Russia','CITY_0000101049137','2');
insert into City values('7271','Russia','CITY_0000101597271','SNZa');
insert into City values('7273','Russia','CITY_0000101777273','SNZa');
insert into City values('7300','Russia','CITY_0000104057300','SN');
insert into City values('7301','Russia','CITY_0000104147301','SN');
insert into City values('7659','Russia','CITY_0000105027659','1');
insert into City values('8546','Russia','CITY_0000105028546','2');
insert into City values('7321','Russia','CITY_0000105757321','SN');
insert into City values('20518','Russia','CITY_00001057520518','1');
insert into City values('13157','Russia','CITY_00001057513157','01Za');
insert into City values('20569','Russia','CITY_00001057520569','2');
insert into City values('24653','Russia','CITY_00001059324653','SN');
insert into City values('21595','Russia','CITY_00001059321595','SNZf');
insert into City values('22690','Russia','CITY_00001061822690','SN');
insert into City values('7350','Russia','CITY_0000106187350','SNZb');
insert into City values('21433','Russia','CITY_00001061821433','SNZc');
insert into City values('46953','Russia','CITY_00001061846953','1');
insert into City values('45551','Russia','CITY_00001061845551','01Za');
insert into City values('46828','Russia','CITY_00001061846828','01Zb');
insert into City values('46832','Russia','CITY_00001061846832','01Zc');
insert into City values('978719','Russia','CITY_000010618978719','2');
insert into City values('1087603','Russia','CITY_0000106181087603','3');
insert into City values('2739779','Russia','CITY_0000106182739779','4');
insert into City values('5708024','Russia','CITY_0000106185708024','5');
insert into City values('5708057','Russia','CITY_0000106185708057','6');
insert into City values('5708101','Russia','CITY_0000106185708101','7');
insert into City values('7339','Russia','CITY_0000106727339','SNZa');
insert into City values('7343','Russia','CITY_0000107247343','SN');
insert into City values('7352','Russia','CITY_0000107517352','SN');
insert into City values('7345','Russia','CITY_0000107517345','SNZa');
insert into City values('7353','Russia','CITY_0000108037353','SNZa');
insert into City values('21435','Russia','CITY_00001080321435','SNZb');
insert into City values('7365','Russia','CITY_0000109197365','SNZa');
insert into City values('360214','Russia','CITY_000010937360214','SN');
insert into City values('1879683','Russia','CITY_0000109371879683','1');
insert into City values('7368','Russia','CITY_0000109467368','SNZa');
insert into City values('721432','Russia','CITY_000010955721432','SNZb');
insert into City values('360223','Russia','CITY_000010964360223','SN');
insert into City values('7371','Russia','CITY_0000109737371','SN');
insert into City values('1879671','Russia','CITY_0000109731879671','1');
insert into City values('1879622','Russia','CITY_0000109731879622','01Za');
insert into City values('14400','Russia','CITY_00001099114400','SN');
insert into City values('14403','Russia','CITY_00001099114403','1');
insert into City values('14497','Russia','CITY_00001099114497','2');
insert into City values('7376','Russia','CITY_0000110247376','SN');
insert into City values('18170','Russia','CITY_00001102418170','1');
insert into City values('8091','Russia','CITY_0000110428091','SNZb');
insert into City values('8438','Russia','CITY_0000110428438','SNZe');
insert into City values('8525','Russia','CITY_0000110428525','SNZf');
insert into City values('21627','Russia','CITY_00001104221627','SNZg');
insert into City values('7389','Russia','CITY_0000111947389','SN');
insert into City values('20884','Russia','CITY_00001119420884','1');
insert into City values('23881','Russia','CITY_00001119423881','2');
insert into City values('23340','Russia','CITY_00001119423340','02Za');
insert into City values('7394','Russia','CITY_0000112287394','SNZa');
insert into City values('21438','Russia','CITY_00001122821438','SNZb');
insert into City values('7396','Russia','CITY_0000112557396','SN');
insert into City values('23924','Russia','CITY_00001125523924','1');
insert into City values('20886','Russia','CITY_00001125520886','01Za');
insert into City values('23337','Russia','CITY_00001125523337','01Zb');
insert into City values('2280111','Russia','CITY_0000112552280111','2');
insert into City values('21441','Russia','CITY_00001126421441','SN');
insert into City values('7397','Russia','CITY_0000112647397','SNZa');
insert into City values('7398','Russia','CITY_0000112737398','SN');
insert into City values('23923','Russia','CITY_00001127323923','1');
insert into City values('20888','Russia','CITY_00001127320888','01Za');
insert into City values('23336','Russia','CITY_00001127323336','01Zb');
insert into City values('7400','Russia','CITY_0000112917400','SN');
insert into City values('20880','Russia','CITY_00001129120880','1');
insert into City values('20893','Russia','CITY_00001129120893','2');
insert into City values('23339','Russia','CITY_00001129123339','3');
insert into City values('2926114','Russia','CITY_0000112912926114','4');
insert into City values('4673798','Russia','CITY_0000112914673798','5');
insert into City values('7402','Russia','CITY_0000113167402','SN');
insert into City values('20891','Russia','CITY_00001131620891','01Za');
insert into City values('23322','Russia','CITY_00001131623322','01Zb');
insert into City values('152495','Russia','CITY_000011316152495','01Zc');
insert into City values('23502','Russia','CITY_00001134323502','SN');
insert into City values('7426','Russia','CITY_0000113437426','SNZb');
insert into City values('21502','Russia','CITY_00001134321502','SNZc');
insert into City values('22742','Russia','CITY_00001134322742','SNZd');
insert into City values('7413','Russia','CITY_0000113987413','SNZa');
insert into City values('7423','Russia','CITY_0000114957423','SNZa');
insert into City values('21492','Russia','CITY_00001160821492','SN');
insert into City values('7453','Russia','CITY_0000116087453','SNZa');
insert into City values('1683111','Russia','CITY_0000116081683111','1');
insert into City values('5708022','Russia','CITY_0000116085708022','2');
insert into City values('5708103','Russia','CITY_0000116085708103','3');
insert into City values('6868077','Russia','CITY_0000116086868077','4');
insert into City values('24652','Russia','CITY_00001162624652','SN');
insert into City values('7464','Russia','CITY_0000116267464','SNZa');
insert into City values('21505','Russia','CITY_00001162621505','SNZb');
insert into City values('7466','Russia','CITY_0000116447466','SNZa');
insert into City values('21509','Russia','CITY_00001164421509','SNZb');
insert into City values('7542','Russia','CITY_0000116717542','SN');
insert into City values('7509','Russia','CITY_0000116717509','SNZb');
insert into City values('7530','Russia','CITY_0000116717530','SNZc');
insert into City values('7884','Russia','CITY_0000116717884','1');
insert into City values('8202','Russia','CITY_0000116718202','2');
insert into City values('8369','Russia','CITY_0000116718369','3');
insert into City values('8536','Russia','CITY_0000116718536','4');
insert into City values('8020','Russia','CITY_0000116808020','SNZb');
insert into City values('7478','Russia','CITY_0000117697478','SNZa');
insert into City values('45288','Russia','CITY_00001177845288','SN');
insert into City values('7479','Russia','CITY_0000117787479','SNZa');
insert into City values('21511','Russia','CITY_00001181121511','SN');
insert into City values('7515','Russia','CITY_0000118117515','SNZb');
insert into City values('46937','Russia','CITY_00001181146937','1');
insert into City values('6008866','Russia','CITY_0000118116008866','02Za');
insert into City values('6013938','Russia','CITY_0000118116013938','02Zb');
insert into City values('6057917','Russia','CITY_0000118116057917','02Zc');
insert into City values('7531','Russia','CITY_0000119187531','SN');
insert into City values('7511','Russia','CITY_0000119187511','SNZa');
insert into City values('7520','Russia','CITY_0000119367520','SNZa');
insert into City values('7521','Russia','CITY_0000119457521','SNZa');
insert into City values('7532','Russia','CITY_0000119637532','SN');
insert into City values('7523','Russia','CITY_0000119637523','SNZa');
insert into City values('7525','Russia','CITY_0000119727525','SN');
insert into City values('7552','Russia','CITY_0000119727552','1');
insert into City values('7882','Russia','CITY_0000119727882','2');
insert into City values('7907','Russia','CITY_0000119727907','3');
insert into City values('8357','Russia','CITY_0000119728357','4');
insert into City values('7526','Russia','CITY_0000119817526','SN');
insert into City values('8169','Russia','CITY_0000119818169','1');
insert into City values('7528','Russia','CITY_0000119907528','SN');
insert into City values('21514','Russia','CITY_00001204121514','SN');
insert into City values('7751','Russia','CITY_0000120417751','SNZb');
insert into City values('46941','Russia','CITY_00001204146941','1');
insert into City values('7548','Russia','CITY_0000120507548','SN');
insert into City values('7564','Russia','CITY_0000121577564','SN');
insert into City values('7894','Russia','CITY_0000124587894','SNZc');
insert into City values('7896','Russia','CITY_0000125377896','SNZb');
insert into City values('7956','Russia','CITY_0000125647956','SNZb');
insert into City values('7941','Russia','CITY_0000125917941','SNZb');
insert into City values('7942','Russia','CITY_0000126077942','SNZb');
insert into City values('7968','Russia','CITY_0000126167968','SNZb');
insert into City values('7736','Russia','CITY_0000126987736','SN');
insert into City values('122085','Russia','CITY_000012704122085','SN');
insert into City values('7738','Russia','CITY_0000127047738','SNZa');
insert into City values('9316','Russia','CITY_0000127049316','SNZb');
insert into City values('122095','Russia','CITY_000012731122095','SN');
insert into City values('7748','Russia','CITY_0000127317748','SNZa');
insert into City values('7749','Russia','CITY_0000127407749','SN');
insert into City values('21535','Russia','CITY_00001276821535','SN');
insert into City values('7753','Russia','CITY_0000127687753','SNZa');
insert into City values('7757','Russia','CITY_0000127957757','SN');
insert into City values('730092','Russia','CITY_000012795730092','01Za');
insert into City values('7759','Russia','CITY_0000128107759','SN');
insert into City values('7760','Russia','CITY_0000128297760','SN');
insert into City values('21539','Russia','CITY_00001284721539','SN');
insert into City values('7762','Russia','CITY_0000128477762','SNZa');
insert into City values('21621','Russia','CITY_00001300421621','SN');
insert into City values('7774','Russia','CITY_0000130047774','SNZa');
insert into City values('8253','Russia','CITY_0000130048253','SNZb');
insert into City values('5943619','Russia','CITY_0000130045943619','01Za');
insert into City values('7777','Russia','CITY_0000130407777','SN');
insert into City values('739681','Russia','CITY_000013040739681','01Za');
insert into City values('21542','Russia','CITY_00001336921542','SN');
insert into City values('7809','Russia','CITY_0000133697809','SNZa');
insert into City values('5707563','Russia','CITY_0000133695707563','1');
insert into City values('5667447','Russia','CITY_0000133695667447','01Za');
insert into City values('5708105','Russia','CITY_0000133695708105','2');
insert into City values('7810','Russia','CITY_0000133787810','SNZa');
insert into City values('21545','Russia','CITY_00001348421545','SN');
insert into City values('7836','Russia','CITY_0000134847836','SNZa');
insert into City values('7838','Russia','CITY_0000135097838','SN');
insert into City values('24659','Russia','CITY_00001351824659','SN');
insert into City values('7839','Russia','CITY_0000135187839','SNZa');
insert into City values('21548','Russia','CITY_00001351821548','SNZb');
insert into City values('22938','Russia','CITY_00001351822938','SNZc');
insert into City values('10823731','Russia','CITY_00001351810823731','1');
insert into City values('21551','Russia','CITY_00001355421551','SN');
insert into City values('7843','Russia','CITY_0000135547843','SNZa');
insert into City values('21554','Russia','CITY_00001358121554','SN');
insert into City values('7845','Russia','CITY_0000135817845','SNZa');
insert into City values('7849','Russia','CITY_0000136157849','SNZa');
insert into City values('21557','Russia','CITY_00001362421557','SN');
insert into City values('7850','Russia','CITY_0000136247850','SNZa');
insert into City values('22875','Russia','CITY_00001364222875','SN');
insert into City values('7852','Russia','CITY_0000136427852','SNZa');
insert into City values('21559','Russia','CITY_00001364221559','SNZb');
insert into City values('7859','Russia','CITY_0000137037859','SN');
insert into City values('733853','Russia','CITY_000013703733853','01Za');
insert into City values('7861','Russia','CITY_0000137217861','SN');
insert into City values('733809','Russia','CITY_000013721733809','01Za');
insert into City values('7863','Russia','CITY_0000137497863','SN');
insert into City values('7865','Russia','CITY_0000137677865','SN');
insert into City values('733748','Russia','CITY_000013767733748','01Za');
insert into City values('7866','Russia','CITY_0000137767866','SN');
insert into City values('733758','Russia','CITY_000013776733758','01Za');
insert into City values('7868','Russia','CITY_0000137857868','SN');
insert into City values('643516','Russia','CITY_000013785643516','01Za');
insert into City values('21563','Russia','CITY_00001382821563','SN');
insert into City values('7872','Russia','CITY_0000138287872','SNZa');
insert into City values('21565','Russia','CITY_00001389121565','SN');
insert into City values('7885','Russia','CITY_0000138917885','SNZa');
insert into City values('7895','Russia','CITY_0000139437895','SNZa');
insert into City values('21567','Russia','CITY_00001394321567','SNZb');
insert into City values('7947','Russia','CITY_0000139707947','SN');
insert into City values('7899','Russia','CITY_0000139707899','SNZa');
insert into City values('202846','Russia','CITY_000013970202846','1');
insert into City values('266065','Russia','CITY_000013970266065','2');
insert into City values('21570','Russia','CITY_00001398921570','SN');
insert into City values('7900','Russia','CITY_0000139897900','SNZa');
insert into City values('3297517','Russia','CITY_0000139893297517','1');
insert into City values('5708020','Russia','CITY_0000139895708020','2');
insert into City values('5708109','Russia','CITY_0000139895708109','3');
insert into City values('7905','Russia','CITY_0000140037905','SNZa');
insert into City values('21572','Russia','CITY_00001400321572','SNZb');
insert into City values('7909','Russia','CITY_0000140307909','SNZa');
insert into City values('21574','Russia','CITY_00001403021574','SNZb');
insert into City values('7912','Russia','CITY_0000140587912','SNZa');
insert into City values('7916','Russia','CITY_0000140857916','SNZa');
insert into City values('21576','Russia','CITY_00001408521576','SNZb');
insert into City values('7949','Russia','CITY_0000140947949','SN');
insert into City values('7917','Russia','CITY_0000140947917','SNZa');
insert into City values('202831','Russia','CITY_000014094202831','1');
insert into City values('23847','Russia','CITY_00001417323847','SN');
insert into City values('7946','Russia','CITY_0000141737946','SNZb');
insert into City values('21578','Russia','CITY_00001417321578','SNZc');
insert into City values('7950','Russia','CITY_0000142347950','SN');
insert into City values('7938','Russia','CITY_0000142347938','SNZa');
insert into City values('51438','Russia','CITY_00001423451438','1');
insert into City values('202840','Russia','CITY_000014234202840','2');
insert into City values('7986','Russia','CITY_0000142527986','SNZb');
insert into City values('7951','Russia','CITY_0000142617951','SN');
insert into City values('7944','Russia','CITY_0000142617944','SNZa');
insert into City values('24188','Russia','CITY_00001430424188','SN');
insert into City values('7954','Russia','CITY_0000143047954','SNZa');
insert into City values('21581','Russia','CITY_00001430421581','SNZb');
insert into City values('23851','Russia','CITY_00001434023851','SN');
insert into City values('7958','Russia','CITY_0000143407958','SNZa');
insert into City values('11221','India','CITY_00000006411221','SN');
insert into City values('32417','India','CITY_00000006432417','1');
insert into City values('101980','India','CITY_000000064101980','2');
insert into City values('498384','India','CITY_000000064498384','3');
insert into City values('1022956','India','CITY_0000000641022956','4');
insert into City values('113710','India','CITY_000006572113710','SN');
insert into City values('157284','India','CITY_000006572157284','1');
insert into City values('131894','India','CITY_000006572131894','01Zc');
insert into City values('223692','India','CITY_000006572223692','2');
insert into City values('360361','India','CITY_000006572360361','3');
insert into City values('1113393','India','CITY_0000065721113393','4');
insert into City values('1837552','India','CITY_0000065721837552','5');
insert into City values('2248350','India','CITY_0000065722248350','6');
insert into City values('7843924','India','CITY_0000065727843924','7');
insert into City values('6904400','India','CITY_0000065726904400','07Za');
insert into City values('7742941','India','CITY_0000065727742941','07Zc');
insert into City values('7742942','India','CITY_0000065727742942','07Zd');
insert into City values('7764627','India','CITY_0000065727764627','07Ze');
insert into City values('8153945','India','CITY_0000065728153945','8');
insert into City values('9590618','India','CITY_0000065729590618','9');
insert into City values('989911','India','CITY_000006943989911','SN');
insert into City values('988217','India','CITY_000006943988217','SNZn');
insert into City values('5710668','India','CITY_0000069435710668','1');
insert into City values('5710673','India','CITY_0000069435710673','2');
insert into City values('5712306','India','CITY_0000069435712306','3');
insert into City values('5721339','India','CITY_0000069435721339','4');
insert into City values('5727239','India','CITY_0000069435727239','5');
insert into City values('6621857','India','CITY_0000069436621857','6');
insert into City values('6869244','India','CITY_0000069436869244','07Za');
insert into City values('7081','India','CITY_0000084737081','SN');
insert into City values('42728','India','CITY_00000847342728','01Za');
insert into City values('21805','India','CITY_00000873821805','SNZe');
insert into City values('19225','India','CITY_00000905619225','SN');
insert into City values('7324','India','CITY_0000090567324','SNZd');
insert into City values('7615','India','CITY_0000090567615','SNZh');
insert into City values('34016','India','CITY_00000905634016','1');
insert into City values('34198','India','CITY_00000905634198','2');
insert into City values('34140','India','CITY_00000932034140','SN');
insert into City values('7312','India','CITY_0000093207312','SNZd');
insert into City values('7333','India','CITY_0000093207333','SNZe');
insert into City values('19231','India','CITY_00000939319231','SN');
insert into City values('7330','India','CITY_0000093937330','SNZc');
insert into City values('7331','India','CITY_0000093937331','SNZd');
insert into City values('33884','India','CITY_00000939333884','1');
insert into City values('33871','India','CITY_00000939333871','01Za');
insert into City values('13611','India','CITY_00001044113611','SN');
insert into City values('7320','India','CITY_0000104417320','SNZc');
insert into City values('7503','India','CITY_0000104417503','SNZd');
insert into City values('19219','India','CITY_00001044119219','1');
insert into City values('34006','India','CITY_00001044134006','2');
insert into City values('8128','India','CITY_0000105488128','SNZb');
insert into City values('11126','India','CITY_00001054811126','SNZc');
insert into City values('11437','India','CITY_00001054811437','SNZd');
insert into City values('20840','India','CITY_00001054820840','SNZe');
insert into City values('21135','India','CITY_00001054821135','SNZf');
insert into City values('21927','India','CITY_00001054821927','SNZg');
insert into City values('21948','India','CITY_00001054821948','SNZh');
insert into City values('24111','India','CITY_00001054824111','SNZi');
insert into City values('24401','India','CITY_00001054824401','SNZj');
insert into City values('69256','India','CITY_00001054869256','SNZk');
insert into City values('69797','India','CITY_00001054869797','SNZl');
insert into City values('69819','India','CITY_00001054869819','SNZm');
insert into City values('34197','India','CITY_00001062734197','SN');
insert into City values('7939','India','CITY_0000107977939','SN');
insert into City values('2066221','India','CITY_0000107972066221','1');
insert into City values('7550','India','CITY_0000119097550','SN');
insert into City values('7510','India','CITY_0000119097510','SNZa');
insert into City values('7524','India','CITY_0000119097524','SNZb');
insert into City values('7543','India','CITY_0000119097543','SNZc');
insert into City values('7551','India','CITY_0000119097551','1');
insert into City values('7898','India','CITY_0000119097898','2');
insert into City values('7883','India','CITY_0000119097883','02Za');
insert into City values('10821','India','CITY_00001190910821','3');
insert into City values('7920','India','CITY_0000119097920','03Za');
insert into City values('7927','India','CITY_0000119097927','03Zb');
insert into City values('10697','India','CITY_00001190910697','03Zc');
insert into City values('122196','India','CITY_000012713122196','SN');
insert into City values('7739','India','CITY_0000127137739','SNZa');
insert into City values('9303','India','CITY_0000127139303','SNZc');
insert into City values('122118','India','CITY_000012713122118','SNZd');
insert into City values('7864','India','CITY_0000137587864','SN');
insert into City values('7869','India','CITY_0000137947869','SN');
insert into City values('8177','India','CITY_0000141828177','SN');
insert into City values('8212','India','CITY_0000141828212','1');
insert into City values('8222','India','CITY_0000141828222','2');
insert into City values('8349','India','CITY_0000141828349','3');
insert into City values('8355','India','CITY_0000141828355','4');
insert into City values('8391','India','CITY_0000141828391','5');
insert into City values('8492','India','CITY_0000141828492','6');
insert into City values('8517','India','CITY_0000141828517','7');
insert into City values('8534','India','CITY_0000141828534','8');
insert into City values('7952','India','CITY_0000142077952','SN');
insert into City values('51502','India','CITY_00001420751502','1');
insert into City values('202865','India','CITY_000014207202865','2');
insert into City values('266066','India','CITY_000014207266066','3');
insert into City values('8460','India','CITY_0000145088460','SN');
insert into City values('739864','India','CITY_000014508739864','01Za');
insert into City values('45519','India','CITY_00001472045519','SN');
insert into City values('45302','India','CITY_00001472045302','SNZaa');
insert into City values('45214','India','CITY_00001472045214','SNZz');
insert into City values('48804','India','CITY_00001472048804','1');
insert into City values('46968','India','CITY_00001472046968','01Zb');
insert into City values('978683','India','CITY_000014720978683','2');
insert into City values('978632','India','CITY_000014720978632','02Zb');
insert into City values('5460781','India','CITY_0000147205460781','3');
insert into City values('5708031','India','CITY_0000147205708031','4');
insert into City values('5672178','India','CITY_0000147205672178','04Za');
insert into City values('5708064','India','CITY_0000147205708064','5');
insert into City values('5712309','India','CITY_0000147205712309','6');
insert into City values('5712311','India','CITY_0000147205712311','7');
insert into City values('5723959','India','CITY_0000147205723959','8');
insert into City values('5723962','India','CITY_0000147205723962','9');
insert into City values('5910185','India','CITY_0000147205910185','10Za');
insert into City values('5916481','India','CITY_0000147205916481','10Zb');
insert into City values('5930898','India','CITY_0000147205930898','10Zc');
insert into City values('5941638','India','CITY_0000147205941638','10Zf');
insert into City values('5967494','India','CITY_0000147205967494','10Zg');
insert into City values('6043059','India','CITY_0000147206043059','10Zk');
insert into City values('6057918','India','CITY_0000147206057918','10Zl');
insert into City values('6065579','India','CITY_0000147206065579','10Zm');
insert into City values('6865565','India','CITY_0000147206865565','10Zo');
insert into City values('8054','India','CITY_0000150938054','SN');
insert into City values('8149','India','CITY_0000150938149','1');
insert into City values('8090','India','CITY_0000153588090','SN');
insert into City values('8194','India','CITY_0000153588194','1');
insert into City values('8344','India','CITY_0000153588344','2');
insert into City values('8772','India','CITY_0000153588772','3');
insert into City values('9986','India','CITY_0000153589986','4');
insert into City values('10007','India','CITY_00001535810007','5');
insert into City values('10583','India','CITY_00001535810583','6');
insert into City values('10676','India','CITY_00001535810676','07Za');
insert into City values('8156','India','CITY_0000157838156','SN');
insert into City values('8213','India','CITY_0000160298213','SN');
insert into City values('17089','India','CITY_00001602917089','02Za');
insert into City values('8394','India','CITY_0000165518394','SN');
insert into City values('8585','India','CITY_0000165518585','1');
insert into City values('10008','India','CITY_00001655110008','2');
insert into City values('10022','India','CITY_00001655110022','3');
insert into City values('10596','India','CITY_00001655110596','4');
insert into City values('8507','India','CITY_0000167468507','SN');
insert into City values('21765','India','CITY_00001711621765','SN');
insert into City values('38543','India','CITY_00001711638543','1');
insert into City values('8739','India','CITY_0000174268739','SNZa');
insert into City values('8743','India','CITY_0000174448743','SNZa');
insert into City values('9006','India','CITY_0000184079006','SN');
insert into City values('9443','India','CITY_0000196009443','SN');
insert into City values('9471','India','CITY_0000196009471','1');
insert into City values('10283','India','CITY_00001960010283','2');
insert into City values('10275','India','CITY_00002290510275','SNZc');
insert into City values('10545','India','CITY_00002310810545','SN');
insert into City values('10299','India','CITY_00002310810299','SNZa');
insert into City values('108587','India','CITY_000023108108587','1');
insert into City values('108638','India','CITY_000023108108638','2');
insert into City values('108991','India','CITY_000023108108991','3');
insert into City values('10349','India','CITY_00002339310349','SN');
insert into City values('10533','India','CITY_00002339310533','1');
insert into City values('10479','India','CITY_00002414310479','SNZa');
insert into City values('13688','India','CITY_00002414313688','SNZc');
insert into City values('20570','India','CITY_00002414320570','SNZf');
insert into City values('21423','India','CITY_00002414321423','SNZg');
insert into City values('178039','India','CITY_000024143178039','SNZm');
insert into City values('191663','India','CITY_000024143191663','SNZn');
insert into City values('246276','India','CITY_000024684246276','SN');
insert into City values('10567','India','CITY_00002468410567','SNZa');
insert into City values('13642','India','CITY_00002468413642','SNZd');
insert into City values('20164','India','CITY_00002468420164','SNZh');
insert into City values('29524','India','CITY_00002468429524','SNZj');
insert into City values('48002','India','CITY_00002468448002','SNZl');
insert into City values('176820','India','CITY_000024684176820','SNZm');
insert into City values('10708','India','CITY_00002512410708','SN');
insert into City values('10865','India','CITY_00002576210865','SNZb');
insert into City values('13456','India','CITY_00002750213456','SN');
insert into City values('11432','India','CITY_00002750211432','SNZb');
insert into City values('11467','India','CITY_00002750211467','SNZc');
insert into City values('11506','India','CITY_00002750211506','SNZd');
insert into City values('11580','India','CITY_00002750211580','SNZe');
insert into City values('11634','India','CITY_00002750211634','SNZf');
insert into City values('12466','India','CITY_00002750212466','SNZg');
insert into City values('12515','India','CITY_00002750212515','SNZh');
insert into City values('12538','India','CITY_00002750212538','SNZi');
insert into City values('12753','India','CITY_00002750212753','SNZj');
insert into City values('12958','India','CITY_00002750212958','SNZk');
insert into City values('13063','India','CITY_00002750213063','SNZl');
insert into City values('13440','India','CITY_00002750213440','SNZm');
insert into City values('19046','India','CITY_00002750219046','1');
insert into City values('11299','India','CITY_00002756611299','SNZa');
insert into City values('11716','India','CITY_00002833411716','SNZc');
insert into City values('1287343','India','CITY_0000283341287343','SNZd');
insert into City values('12179','India','CITY_00002851012179','SN');
insert into City values('1402692','India','CITY_0000285101402692','1');
insert into City values('1410130','India','CITY_0000285101410130','2');
insert into City values('12014','India','CITY_00002898112014','SN');
insert into City values('11533','India','CITY_00002898111533','SNZa');
insert into City values('2353852','India','CITY_0000290692353852','SNZo');
insert into City values('432330','India','CITY_000029236432330','SN');
insert into City values('200312','India','CITY_000029236200312','SNZg');
insert into City values('667956','India','CITY_000029236667956','1');
insert into City values('2500684','India','CITY_0000292362500684','02Zb');
insert into City values('13478','India','CITY_00002929013478','SN');
insert into City values('13077','India','CITY_00002929013077','SNZk');
insert into City values('13450','India','CITY_00002929013450','SNZl');
insert into City values('14821','India','CITY_00002929014821','1');
insert into City values('19060','India','CITY_00002929019060','2');
insert into City values('12180','India','CITY_00002931512180','SN');
insert into City values('2027657','India','CITY_0000293152027657','1');
insert into City values('2760482','India','CITY_0000293152760482','2');
insert into City values('2813435','India','CITY_0000293152813435','3');
insert into City values('6479108','India','CITY_0000293156479108','4');
insert into City values('10948004','India','CITY_00002931510948004','5');
insert into City values('10992424','India','CITY_00002931510992424','6');
insert into City values('10992421','India','CITY_00002931510992421','06Za');
insert into City values('42894','India','CITY_00002936042894','SN');
insert into City values('23335','India','CITY_00002936023335','SNZg');
insert into City values('23464','India','CITY_00002936023464','SNZh');
insert into City values('23935','India','CITY_00002936023935','SNZi');
insert into City values('45641','India','CITY_00002936045641','1');
insert into City values('45733','India','CITY_00002936045733','02Za');
insert into City values('42902','India','CITY_00002939742902','SN');
insert into City values('23321','India','CITY_00002939723321','SNZf');
insert into City values('23463','India','CITY_00002939723463','SNZg');
insert into City values('23479','India','CITY_00002939723479','SNZh');
insert into City values('23936','India','CITY_00002939723936','SNZi');
insert into City values('45643','India','CITY_00002939745643','1');
insert into City values('45734','India','CITY_00002939745734','02Za');
insert into City values('12041','India','CITY_00002989212041','SN');
insert into City values('11720','India','CITY_00002989211720','SNZa');
insert into City values('12164','India','CITY_00003034812164','SN');
insert into City values('1404304','India','CITY_0000303481404304','1');
insert into City values('1410362','India','CITY_0000303481410362','2');
insert into City values('10832862','India','CITY_00003034810832862','3');
insert into City values('11023406','India','CITY_00003034811023406','4');
insert into City values('21478','India','CITY_00003035721478','SN');
insert into City values('11811','India','CITY_00003035711811','SNZa');
insert into City values('12166','India','CITY_00003049012166','SN');
insert into City values('2027629','India','CITY_0000304902027629','1');
insert into City values('2418908','India','CITY_0000304902418908','2');
insert into City values('2760711','India','CITY_0000304902760711','3');
insert into City values('3606258','India','CITY_0000304903606258','4');
insert into City values('11023403','India','CITY_00003049011023403','5');
insert into City values('11037609','India','CITY_00003049011037609','6');
insert into City values('11047721','India','CITY_00003049011047721','7');
insert into City values('11047722','India','CITY_00003049011047722','8');
insert into City values('11945','India','CITY_00003099511945','SN');
insert into City values('12165','India','CITY_00003099512165','1');
insert into City values('11970','India','CITY_00003107311970','SNZb');
insert into City values('12162','India','CITY_00003133812162','SN');
insert into City values('11996','India','CITY_00003133811996','SNZa');
insert into City values('10832863','India','CITY_00003133810832863','01Za');
insert into City values('20516','India','CITY_00003152320516','SN');
insert into City values('12040','India','CITY_00003152312040','SNZa');
insert into City values('13686','India','CITY_00003152313686','SNZc');
insert into City values('20171','India','CITY_00003152320171','SNZf');
insert into City values('175535','India','CITY_000031523175535','01Za');
insert into City values('12181','India','CITY_00003206312181','SN');
insert into City values('12182','India','CITY_00003207212182','SN');
insert into City values('10832866','India','CITY_00003207210832866','1');
insert into City values('30298','India','CITY_00003230030298','SN');
insert into City values('12758','India','CITY_00003230012758','SNZb');
insert into City values('28357','India','CITY_00003230028357','SNZc');
insert into City values('30297','India','CITY_00003236430297','SN');
insert into City values('12759','India','CITY_00003236412759','SNZb');
insert into City values('6695542','India','CITY_0000323646695542','1');
insert into City values('30300','India','CITY_00003247030300','SN');
insert into City values('12760','India','CITY_00003247012760','SNZb');
insert into City values('28350','India','CITY_00003247028350','SNZc');
insert into City values('6694405','India','CITY_0000324706694405','1');
insert into City values('8868465','India','CITY_0000324708868465','2');
insert into City values('30283','India','CITY_00003260130283','SN');
insert into City values('12761','India','CITY_00003260112761','SNZb');
insert into City values('12393','India','CITY_00003262912393','SN');
insert into City values('26171','India','CITY_00003262926171','1');
insert into City values('27957','India','CITY_00003262927957','2');
insert into City values('116878','India','CITY_000032629116878','3');
insert into City values('592111','India','CITY_000032629592111','4');
insert into City values('592382','India','CITY_000032629592382','5');
insert into City values('1654508','India','CITY_0000326291654508','6');
insert into City values('2964255','India','CITY_0000326292964255','7');
insert into City values('5803679','India','CITY_0000326295803679','8');
insert into City values('33361','India','CITY_00003270833361','SN');
insert into City values('12762','India','CITY_00003270812762','SNZb');
insert into City values('28362','India','CITY_00003270828362','SNZc');
insert into City values('30281','India','CITY_00003270830281','SNZd');
insert into City values('210483','India','CITY_000032708210483','1');
insert into City values('304235','India','CITY_000032708304235','2');
insert into City values('33363','India','CITY_00003275333363','SN');
insert into City values('12763','India','CITY_00003275312763','SNZb');
insert into City values('28361','India','CITY_00003275328361','SNZc');
insert into City values('28384','India','CITY_00003275328384','SNZd');
insert into City values('30285','India','CITY_00003275330285','SNZe');
insert into City values('210484','India','CITY_000032753210484','1');
insert into City values('278852','India','CITY_000032753278852','2');
insert into City values('30276','India','CITY_00003281430276','SN');
insert into City values('12764','India','CITY_00003281412764','SNZb');
insert into City values('28394','India','CITY_00003286928394','SN');
insert into City values('12765','India','CITY_00003286912765 ','SNZb');
insert into City values('87745','India','CITY_00003286987745','1');
insert into City values('210571','India','CITY_000032869210571','2');
insert into City values('33372','India','CITY_00003296633372','SN');
insert into City values('12766','India','CITY_00003296612766','SNZb');
insert into City values('28395','India','CITY_00003296628395','SNZc');
insert into City values('21069','United
States','CITY_00000722521069','SNZc');
insert into City values('21067','United
States','CITY_00000725221067','SNZc');
insert into City values('21059','United
States','CITY_00000726121059','SNZd');
insert into City values('223633','United
States','CITY_000007368223633','SNZd');
insert into City values('21072','United
States','CITY_00000752621072','SNZc');
insert into City values('21063','United
States','CITY_00000753521063','SNZc');
insert into City values('21061','United
States','CITY_00000759921061','SNZd');
insert into City values('21045','United
States','CITY_00000763221045','SNZc');
insert into City values('21047','United
States','CITY_00000765021047','SNZb');
insert into City values('304105','United
States','CITY_000008552304105','2');
insert into City values('10292','United States','CITY_00000857010292','SN');
insert into City values('10296','United States','CITY_00000857010296','1');
insert into City values('13558','United States','CITY_00000857013558','2');
insert into City values('13570','United States','CITY_00000857013570','3');
insert into City values('7080','United States','CITY_0000086597080','SN');
insert into City values('13573','United States','CITY_00000865913573','1');
insert into City values('13583','United States','CITY_00000865913583','2');
insert into City values('30133','United States','CITY_00000865930133','3');
insert into City values('33878','United States','CITY_00000865933878','4');
insert into City values('7089','United States','CITY_0000086687089','SN');
insert into City values('30128','United States','CITY_00000866830128','1');
insert into City values('7101','United States','CITY_0000087107101','SN');
insert into City values('19237','United States','CITY_00000871019237','1');
insert into City values('20185','United
States','CITY_00000871020185','02Za');
insert into City values('7105','United States','CITY_0000087477105','SN');
insert into City values('13608','United States','CITY_00000874713608','1');
insert into City values('13609','United States','CITY_00000874713609','2');
insert into City values('19167','United States','CITY_00000874719167','3');
insert into City values('7107','United States','CITY_0000087567107','SN');
insert into City values('30130','United States','CITY_00000875630130','1');
insert into City values('7108','United States','CITY_0000087657108','SN');
insert into City values('19238','United States','CITY_00000876519238','1');
insert into City values('7110','United States','CITY_0000087747110','SN');
insert into City values('13560','United States','CITY_00000877413560','1');
insert into City values('19170','United States','CITY_00000877419170','2');
insert into City values('7113','United States','CITY_0000088087113','SN');
insert into City values('22918','United States','CITY_00000880822918','1');
insert into City values('7504','United States','CITY_0000088267504','SN');
insert into City values('23019','United States','CITY_00000882623019','1');
insert into City values('23020','United States','CITY_00000882623020','2');
insert into City values('7116','United States','CITY_0000088357116','SN');
insert into City values('13552','United States','CITY_00000883513552','1');
insert into City values('7117','United States','CITY_0000088447117','SN');
insert into City values('30123','United States','CITY_00000884430123','1');
insert into City values('13584','United States','CITY_00000886213584','SN');
insert into City values('13585','United States','CITY_00000886213585','1');
insert into City values('30134','United States','CITY_00000886230134','2');
insert into City values('7120','United States','CITY_0000088717120','SN');
insert into City values('30124','United States','CITY_00000887130124','1');
insert into City values('8098','United States','CITY_0000088808098','SN');
insert into City values('23022','United States','CITY_00000888023022','1');
insert into City values('30116','United States','CITY_00000888030116','3');
insert into City values('7122','United States','CITY_0000088997122','SN');
insert into City values('22921','United States','CITY_00000889922921','1');
insert into City values('8057','United States','CITY_0000089058057','SN');
insert into City values('23021','United States','CITY_00000890523021','1');
insert into City values('7124','United States','CITY_0000089147124','SN');
insert into City values('19236','United States','CITY_00000891419236','1');
insert into City values('7719','United States','CITY_0000089237719','SN');
insert into City values('30120','United States','CITY_00000892330120','3');
insert into City values('7140','United States','CITY_0000089327140','SN');
insert into City values('7141','United States','CITY_0000089327141','1');
insert into City values('13549','United States','CITY_00000893213549','2');
insert into City values('7517','United States','CITY_0000089507517','SN');
insert into City values('7541','United States','CITY_0000089507541','1');
insert into City values('7593','United States','CITY_0000089507593','2');
insert into City values('13556','United States','CITY_00000895013556','3');
insert into City values('7129','United States','CITY_0000089697129','SN');
insert into City values('13554','United States','CITY_00000896913554','1');
insert into City values('19149','United States','CITY_00000896919149','2');
insert into City values('19168','United States','CITY_00000897819168','SN');
insert into City values('19169','United States','CITY_00000897819169','2');
insert into City values('19116','United States','CITY_00000898719116','SN');
insert into City values('19117','United States','CITY_00000898719117','1');
insert into City values('7135','United States','CITY_0000089967135','SN');
insert into City values('30113','United States','CITY_00000899630113','2');
insert into City values('19176','United States','CITY_00000900119176','SN');
insert into City values('19180','United States','CITY_00000900119180','1');
insert into City values('7207','United States','CITY_0000095607207','SNZb');
insert into City values('30136','United States','CITY_00000972830136','1');
insert into City values('30137','United States','CITY_00001001630137','1');
insert into City values('30138','United States','CITY_00001004330138','1');
insert into City values('7269','United States','CITY_0000101137269','SN');
insert into City values('9161','United States','CITY_0000101139161','1');
insert into City values('130660','United
States','CITY_000010113130660','2');
insert into City values('34167','United States','CITY_00001043234167','1');
insert into City values('7322','United States','CITY_0000105847322','SN');
insert into City values('7327','United States','CITY_0000105847327','1');
insert into City values('7328','United States','CITY_0000105847328','2');
insert into City values('7377','United States','CITY_0000109287377','SNZb');
insert into City values('7375','United States','CITY_0000110157375','SN');
insert into City values('14405','United States','CITY_00001101514405','1');
insert into City values('14498','United States','CITY_00001101514498','2');
insert into City values('7380','United States','CITY_0000110517380','SN');
insert into City values('18173','United States','CITY_00001105118173','1');
insert into City values('18183','United States','CITY_00001105118183','2');
insert into City values('7414','United States','CITY_0000114047414','SNZa');
insert into City values('7424','United States','CITY_0000115017424','SNZa');
insert into City values('6868080','United
States','CITY_0000115296868080','SNZc');
insert into City values('7545','United States','CITY_0000120327545','SN');
insert into City values('7886','United States','CITY_0000120327886','1');
insert into City values('7549','United States','CITY_0000120697549','SN');
insert into City values('7658','United States','CITY_0000124037658','SN');
insert into City values('7687','United States','CITY_0000124677687','SN');
insert into City values('7691','United States','CITY_0000124947691','SN');
insert into City values('7694','United States','CITY_0000125007694','SN');
insert into City values('7696','United States','CITY_0000125197696','SN');
insert into City values('7699','United States','CITY_0000125287699','SN');
insert into City values('7704','United States','CITY_0000125467704','SN');
insert into City values('7707','United States','CITY_0000125557707','SN');
insert into City values('7709','United States','CITY_0000125737709','SN');
insert into City values('7710','United States','CITY_0000125827710','SN');
insert into City values('7731','United States','CITY_0000126707731','SN');
insert into City values('22917','United States','CITY_00001267022917','1');
insert into City values('6868081','United
States','CITY_0000142896868081','SNZd');
insert into City values('122148','United
States','CITY_000014331122148','SN');
insert into City values('7982','United States','CITY_0000145267982','SN');
insert into City values('7989','United States','CITY_0000145807989','SN');
insert into City values('7995','United States','CITY_0000146327995','SN');
insert into City values('202944','United
States','CITY_000014632202944','1');
insert into City values('266067','United
States','CITY_000014632266067','2');
insert into City values('8001','United States','CITY_0000146878001','SN');
insert into City values('11844','United States','CITY_00001468711844','1');
insert into City values('202958','United
States','CITY_000014687202958','2');
insert into City values('8003','United States','CITY_0000147028003','SN');
insert into City values('40285','United States','CITY_00001470240285','1');
insert into City values('51444','United States','CITY_00001470251444','2');
insert into City values('202969','United
States','CITY_000014702202969','3');
insert into City values('122225','United
States','CITY_000014739122225','1');
insert into City values('8013','United States','CITY_0000147848013','SN');
insert into City values('51508','United States','CITY_00001478451508','1');
insert into City values('204081','United
States','CITY_000014784204081','2');
insert into City values('8121','United States','CITY_0000148548121','SN');
insert into City values('739882','United
States','CITY_000014854739882','01Za');
insert into City values('8688','United States','CITY_0000151818688','SNZb');
insert into City values('8690','United States','CITY_0000151908690','SNZb');
insert into City values('8689','United States','CITY_0000152068689','SNZb');
insert into City values('8692','United States','CITY_0000152158692','SNZb');
insert into City values('9208','United States','CITY_0000155079208','SN');
insert into City values('9666','United States','CITY_0000155079666','1');
insert into City values('9667','United States','CITY_0000155079667','2');
insert into City values('9668','United States','CITY_0000155079668','3');
insert into City values('1059913','United
States','CITY_0000155071059913','4');
insert into City values('3774117','United
States','CITY_0000155073774117','5');
insert into City values('8765368','United
States','CITY_0000155078765368','6');
insert into City values('8185','United States','CITY_0000159698185','SN');
insert into City values('8221','United States','CITY_0000159698221','1');
insert into City values('8224','United States','CITY_0000159698224','2');
insert into City values('8351','United States','CITY_0000159698351','3');
insert into City values('8352','United States','CITY_0000159698352','4');
insert into City values('8358','United States','CITY_0000159698358','5');
insert into City values('8416','United States','CITY_0000159698416','6');
insert into City values('8431','United States','CITY_0000159698431','7');
insert into City values('8509','United States','CITY_0000159698509','8');
insert into City values('8519','United States','CITY_0000159698519','9');
insert into City values('8257','United States','CITY_0000161718257','SN');
insert into City values('560241','United
States','CITY_000016171560241','01Zd');
insert into City values('1378533','United
States','CITY_0000167731378533','5');
insert into City values('1489455','United
States','CITY_0000167731489455','6');
insert into City values('1633832','United
States','CITY_0000167731633832','7');
insert into City values('1678805','United
States','CITY_0000167731678805','8');
insert into City values('1788137','United
States','CITY_0000167731788137','9');
insert into City values('2026359','United
States','CITY_0000167732026359','10');
insert into City values('2749858','United
States','CITY_0000167732749858','11');
insert into City values('10312994','United
States','CITY_00001677310312994','12');
insert into City values('10312986','United
States','CITY_00001677310312986','12Za');
insert into City values('10312989','United
States','CITY_00001677310312989','12Zb');
insert into City values('16772','United States','CITY_00001678216772','SN');
insert into City values('16874','United States','CITY_00001678216874','1');
insert into City values('18279','United States','CITY_00001678218279','2');
insert into City values('18280','United States','CITY_00001678218280','3');
insert into City values('18459','United States','CITY_00001678218459','4');
insert into City values('21504','United States','CITY_00001678221504','5');
insert into City values('21785','United States','CITY_00001678221785','6');
insert into City values('1828357','United
States','CITY_0000167821828357','9');
insert into City values('2060302','United
States','CITY_0000167822060302','10');
insert into City values('3126785','United
States','CITY_0000167823126785','11');
insert into City values('21484','United States','CITY_00001714321484','SN');
insert into City values('21486','United States','CITY_00001714321486','1');
insert into City values('21487','United States','CITY_00001714321487','2');
insert into City values('21489','United States','CITY_00001714321489','3');
insert into City values('21490','United States','CITY_00001714321490','4');
insert into City values('131677','United
States','CITY_000017143131677','5');
insert into City values('9285','United States','CITY_0000189209285','SN');
insert into City values('9347','United States','CITY_0000191969347','SN');
insert into City values('9892','United States','CITY_0000212169892','SN');
insert into City values('10046','United States','CITY_00002184510046','SN');
insert into City values('10324','United States','CITY_00002184510324','1');
insert into City values('10336','United States','CITY_00002184510336','2');
insert into City values('10374','United States','CITY_00002184510374','3');
insert into City values('10540','United States','CITY_00002184510540','4');
insert into City values('110420','United
States','CITY_000021845110420','5');
insert into City values('8677601','United
States','CITY_0000218458677601','6');
insert into City values('10058','United States','CITY_00002199710058','SN');
insert into City values('10467','United States','CITY_00002199710467','1');
insert into City values('10598','United States','CITY_00002199710598','2');
insert into City values('10188','United States','CITY_00002265910188','SN');
insert into City values('10210','United States','CITY_00002270110210','SN');
insert into City values('10216','United States','CITY_00002273810216','SN');
insert into City values('10218','United States','CITY_00002275610218','SN');
Thanks,
Nilesh
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
