ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nilesh K <ngkha...@gmail.com>
Subject Re: Finding collocated data in ignite nodes
Date Wed, 27 Mar 2019 14:06:15 GMT
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/

Mime
View raw message