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