asp.net MVC4——省市三級聯動資料庫

資料庫設計

sql語句：

INSERT INTO sy_area VALUES('110000','0','北京市','','110000',0);
INSERT INTO sy_area VALUES('110100','110000','東城區','','110100',0);
INSERT INTO sy_area VALUES('110200','110000','西城區','','110200',0);
INSERT INTO sy_area VALUES('110500','110000','朝陽區','','110500',0);
INSERT INTO sy_area VALUES('110600','110000','丰台區','','110600',0);
INSERT INTO sy_area VALUES('110700','110000','石景山區','','110700',0);
INSERT INTO sy_area VALUES('110800','110000','海澱區','','110800',0);
INSERT INTO sy_area VALUES('110900','110000','門頭溝區','','110900',0);
INSERT INTO sy_area VALUES('111100','110000','房山區','','111100',0);
INSERT INTO sy_area VALUES('111200','110000','通州區','','111200',0);
INSERT INTO sy_area VALUES('111300','110000','順義區','','111300',0);
INSERT INTO sy_area VALUES('111400','110000','昌平區','','111400',0);
INSERT INTO sy_area VALUES('111500','110000','大興區','','111500',0);
INSERT INTO sy_area VALUES('111600','110000','懷柔區','','111600',0);
INSERT INTO sy_area VALUES('111700','110000','平谷區','','111700',0);
INSERT INTO sy_area VALUES('112800','110000','密雲縣','','112800',0);
INSERT INTO sy_area VALUES('112900','110000','延慶縣','','112900',0);
INSERT INTO sy_area VALUES('120000','0','天津市','','120000',0);
INSERT INTO sy_area VALUES('120100','120000','和平區','','120100',0);
INSERT INTO sy_area VALUES('120200','120000','河東區','','120200',0);
INSERT INTO sy_area VALUES('120300','120000','河西區','','120300',0);
INSERT INTO sy_area VALUES('120400','120000','南開區','','120400',0);
INSERT INTO sy_area VALUES('120500','120000','河北區','','120500',0);
INSERT INTO sy_area VALUES('120600','120000','紅橋區','','120600',0);
INSERT INTO sy_area VALUES('120900','120000','濱海新區','','120900',0);
INSERT INTO sy_area VALUES('121000','120000','東麗區','','121000',0);
INSERT INTO sy_area VALUES('121100','120000','西青區','','121100',0);
INSERT INTO sy_area VALUES('121200','120000','津南區','','121200',0);
INSERT INTO sy_area VALUES('121300','120000','北辰區','','121300',0);
INSERT INTO sy_area VALUES('121400','120000','武清區','','121400',0);
INSERT INTO sy_area VALUES('121500','120000','寶坻區','','121500',0);
INSERT INTO sy_area VALUES('122100','120000','寧河縣','','122100',0);
INSERT INTO sy_area VALUES('122300','120000','靜海縣','','122300',0);
INSERT INTO sy_area VALUES('122500','120000','薊縣','','122500',0);
INSERT INTO sy_area VALUES('130000','0','河北省','','130000',0);
INSERT INTO sy_area VALUES('130100','130000','石家莊市','','130100',0);
INSERT INTO sy_area VALUES('130101','130100','市轄區','','130101',0);
INSERT INTO sy_area VALUES('130102','130101','長安區','','130102',0);
INSERT INTO sy_area VALUES('130103','130101','橋東區','','130103',0);
INSERT INTO sy_area VALUES('130104','130101','橋西區','','130104',0);
INSERT INTO sy_area VALUES('130105','130101','新華區','','130105',0);
INSERT INTO sy_area VALUES('130107','130101','井陘礦區','','130107',0);
INSERT INTO sy_area VALUES('130108','130101','裕華區','','130108',0);
INSERT INTO sy_area VALUES('130121','130100','井陘縣','','130121',0);
INSERT INTO sy_area VALUES('130123','130100','正定縣','','130123',0);
INSERT INTO sy_area VALUES('130124','130100','欒城縣','','130124',0);
INSERT INTO sy_area VALUES('130125','130100','行唐縣','','130125',0);
INSERT INTO sy_area VALUES('130126','130100','靈壽縣','','130126',0);
INSERT INTO sy_area VALUES('130127','130100','高邑縣','','130127',0);
INSERT INTO sy_area VALUES('130128','130100','深澤縣','','130128',0);
INSERT INTO sy_area VALUES('130129','130100','贊皇縣','','130129',0);
INSERT INTO sy_area VALUES('130130','130100','無極縣','','130130',0);
INSERT INTO sy_area VALUES('130131','130100','平山縣','','130131',0);
INSERT INTO sy_area VALUES('130132','130100','元氏縣','','130132',0);
INSERT INTO sy_area VALUES('130133','130100','趙縣','','130133',0);
INSERT INTO sy_area VALUES('130181','130100','辛集市','','130181',0);
INSERT INTO sy_area VALUES('130182','130100','藁城市','','130182',0);
INSERT INTO sy_area VALUES('130183','130100','晉州市','','130183',0);
INSERT INTO sy_area VALUES('130184','130100','新樂市','','130184',0);
INSERT INTO sy_area VALUES('130185','130100','鹿泉市','','130185',0);
INSERT INTO sy_area VALUES('130200','130000','唐山市','','130200',0);
INSERT INTO sy_area VALUES('130201','130200','市轄區','','130201',0);
INSERT INTO sy_area VALUES('130202','130201','路南區','','130202',0);
INSERT INTO sy_area VALUES('130203','130201','路北區','','130203',0);
INSERT INTO sy_area VALUES('130204','130201','古冶區','','130204',0);
INSERT INTO sy_area VALUES('130205','130201','開平區','','130205',0);
INSERT INTO sy_area VALUES('130207','130201','丰南區','','130207',0);
INSERT INTO sy_area VALUES('130208','130201','豐潤區','','130208',0);
INSERT INTO sy_area VALUES('130223','130200','灤縣','','130223',0);
INSERT INTO sy_area VALUES('130224','130200','灤南縣','','130224',0);
INSERT INTO sy_area VALUES('130225','130200','樂亭縣','','130225',0);
INSERT INTO sy_area VALUES('130227','130200','遷西縣','','130227',0);
INSERT INTO sy_area VALUES('130229','130200','玉田縣','','130229',0);
INSERT INTO sy_area VALUES('130230','130200','唐海縣','','130230',0);
INSERT INTO sy_area VALUES('130281','130200','遵化市','','130281',0);
INSERT INTO sy_area VALUES('130283','130200','遷安市','','130283',0);
INSERT INTO sy_area VALUES('130300','130000','秦皇島市','','130300',0);
INSERT INTO sy_area VALUES('130301','130300','海港區','','130301',0);
INSERT INTO sy_area VALUES('130303','130300','山海關區','','130303',0);
INSERT INTO sy_area VALUES('130304','130300','北戴河區','','130304',0);
INSERT INTO sy_area VALUES('130321','130300','青龍滿族自治縣','','130321',0);
INSERT INTO sy_area VALUES('130322','130300','昌黎縣','','130322',0);
INSERT INTO sy_area VALUES('130323','130300','撫寧縣','','130323',0);
INSERT INTO sy_area VALUES('130324','130300','盧龍縣','','130324',0);
INSERT INTO sy_area VALUES('130400','130000','邯鄲市','','130400',0);
INSERT INTO sy_area VALUES('130401','130400','市轄區','','130401',0);
INSERT INTO sy_area VALUES('130402','130401','邯山區','','130402',0);
INSERT INTO sy_area VALUES('130403','130401','叢台區','','130403',0);
INSERT INTO sy_area VALUES('130404','130401','復興區','','130404',0);
INSERT INTO sy_area VALUES('130406','130401','峰峰礦區','','130406',0);
INSERT INTO sy_area VALUES('130421','130400','邯鄲縣','','130421',0);
INSERT INTO sy_area VALUES('130423','130400','臨漳縣','','130423',0);
INSERT INTO sy_area VALUES('130424','130400','成安縣','','130424',0);
INSERT INTO sy_area VALUES('130425','130400','大名縣','','130425',0);
INSERT INTO sy_area VALUES('130426','130400','涉縣','','130426',0);
INSERT INTO sy_area VALUES('130427','130400','磁縣','','130427',0);
INSERT INTO sy_area VALUES('130428','130400','肥鄉縣','','130428',0);
INSERT INTO sy_area VALUES('130429','130400','永年縣','','130429',0);
INSERT INTO sy_area VALUES('130430','130400','邱縣','','130430',0);
INSERT INTO sy_area VALUES('130431','130400','雞澤縣','','130431',0);
INSERT INTO sy_area VALUES('130432','130400','廣平縣','','130432',0);
INSERT INTO sy_area VALUES('130433','130400','館陶縣','','130433',0);
INSERT INTO sy_area VALUES('130434','130400','魏縣','','130434',0);
INSERT INTO sy_area VALUES('130435','130400','曲周縣','','130435',0);
INSERT INTO sy_area VALUES('130481','130400','武安市','','130481',0);
INSERT INTO sy_area VALUES('130500','130000','邢台市','','130500',0);
INSERT INTO sy_area VALUES('130501','130500','市轄區','','130501',0);
INSERT INTO sy_area VALUES('130502','130501','橋東區','','130502',0);
INSERT INTO sy_area VALUES('130503','130501','橋西區','','130503',0);
INSERT INTO sy_area VALUES('130521','130500','邢台縣','','130521',0);
INSERT INTO sy_area VALUES('130522','130500','臨城縣','','130522',0);
INSERT INTO sy_area VALUES('130523','130500','內丘縣','','130523',0);
INSERT INTO sy_area VALUES('130524','130500','柏鄉縣','','130524',0);
INSERT INTO sy_area VALUES('130525','130500','隆堯縣','','130525',0);
INSERT INTO sy_area VALUES('130526','130500','任縣','','130526',0);
INSERT INTO sy_area VALUES('130527','130500','南和縣','','130527',0);
INSERT INTO sy_area VALUES('130528','130500','寧晉縣','','130528',0);
INSERT INTO sy_area VALUES('130529','130529','巨鹿縣','','130529',0);
INSERT INTO sy_area VALUES('130530','130500','新河縣','','130530',0);
INSERT INTO sy_area VALUES('130531','130500','廣宗縣','','130531',0);
INSERT INTO sy_area VALUES('130532','130500','平鄉縣','','130532',0);
INSERT INTO sy_area VALUES('130533','130500','威縣','','130533',0);
INSERT INTO sy_area VALUES('130534','130500','清河縣','','130534',0);
INSERT INTO sy_area VALUES('130535','130500','臨西縣','','130535',0);
INSERT INTO sy_area VALUES('130581','130500','南宮市','','130581',0);
INSERT INTO sy_area VALUES('130582','130500','沙河市','','130582',0);
INSERT INTO sy_area VALUES('130600','130000','保定市','','130600',0);
INSERT INTO sy_area VALUES('130601','130600','新市區','','130601',0);
INSERT INTO sy_area VALUES('130603','130600','北市區','','130603',0);
INSERT INTO sy_area VALUES('130604','130600','南市區','','130604',0);
INSERT INTO sy_area VALUES('130621','130600','滿城縣','','130621',0);
INSERT INTO sy_area VALUES('130622','130600','清苑縣','','130622',0);
INSERT INTO sy_area VALUES('130623','130600','淶水縣','','130623',0);
INSERT INTO sy_area VALUES('130624','130600','阜平縣','','130624',0);
INSERT INTO sy_area VALUES('130625','130600','徐水縣','','130625',0);
INSERT INTO sy_area VALUES('130626','130600','定興縣','','130626',0);
INSERT INTO sy_area VALUES('130627','130600','唐縣','','130627',0);
INSERT INTO sy_area VALUES('130628','130600','高陽縣','','130628',0);
INSERT INTO sy_area VALUES('130629','130600','容城縣','','130629',0);
INSERT INTO sy_area VALUES('130630','130600','淶源縣','','130630',0);
INSERT INTO sy_area VALUES('130631','130600','望都縣','','130631',0);
INSERT INTO sy_area VALUES('130632','130600','安新縣','','130632',0);
INSERT INTO sy_area VALUES('130633','130600','易縣','','130633',0);
INSERT INTO sy_area VALUES('130634','130600','曲陽縣','','130634',0);
INSERT INTO sy_area VALUES('130635','130600','蠡縣','','130635',0);
INSERT INTO sy_area VALUES('130636','130600','順平縣','','130636',0);
INSERT INTO sy_area VALUES('130637','130600','博野縣','','130637',0);
INSERT INTO sy_area VALUES('130638','130600','雄縣','','130638',0);
INSERT INTO sy_area VALUES('130681','130600','涿州市','','130681',0);
INSERT INTO sy_area VALUES('130682','130600','定州市','','130682',0);
INSERT INTO sy_area VALUES('130683','130600','安國市','','130683',0);
INSERT INTO sy_area VALUES('130684','130600','高碑店市','','130684',0);
INSERT INTO sy_area VALUES('130685','130600','白溝新城縣','','130685',0);
INSERT INTO sy_area VALUES('130700','130000','張家口市','','130700',0);
INSERT INTO sy_area VALUES('130701','130700','市轄區','','130701',0);
INSERT INTO sy_area VALUES('130702','130701','橋東區','','130702',0);
INSERT INTO sy_area VALUES('130703','130701','橋西區','','130703',0);
INSERT INTO sy_area VALUES('130705','130701','宣化區','','130705',0);
INSERT INTO sy_area VALUES('130706','130701','下花園區','','130706',0);
INSERT INTO sy_area VALUES('130721','130700','宣化縣','','130721',0);
INSERT INTO sy_area VALUES('130722','130700','張北縣','','130722',0);
INSERT INTO sy_area VALUES('130723','130700','康保縣','','130723',0);
INSERT INTO sy_area VALUES('130724','130700','沽源縣','','130724',0);
INSERT INTO sy_area VALUES('130725','130700','尚義縣','','130725',0);
INSERT INTO sy_area VALUES('130726','130700','蔚縣','','130726',0);
INSERT INTO sy_area VALUES('130727','130700','陽原縣','','130727',0);
INSERT INTO sy_area VALUES('130728','130700','懷安縣','','130728',0);
INSERT INTO sy_area VALUES('130729','130700','萬全縣','','130729',0);
INSERT INTO sy_area VALUES('130730','130700','懷來縣','','130730',0);
INSERT INTO sy_area VALUES('130731','130700','涿鹿縣','','130731',0);
INSERT INTO sy_area VALUES('130732','130700','赤城縣','','130732',0);
INSERT INTO sy_area VALUES('130733','130700','崇禮縣','','130733',0);
INSERT INTO sy_area VALUES('130800','130000','承德市','','130800',0);
INSERT INTO sy_area VALUES('130801','130800','市轄區','','130801',0);
INSERT INTO sy_area VALUES('130802','130801','雙橋區','','130802',0);
INSERT INTO sy_area VALUES('130803','130801','雙灤區','','130803',0);
INSERT INTO sy_area VALUES('130804','130801','鷹手營子礦區','','130804',0);
INSERT INTO sy_area VALUES('130821','130800','承德縣','','130821',0);
INSERT INTO sy_area VALUES('130822','130800','興隆縣','','130822',0);
INSERT INTO sy_area VALUES('130823','130800','平泉縣','','130823',0);
INSERT INTO sy_area VALUES('130824','130800','灤平縣','','130824',0);
INSERT INTO sy_area VALUES('130825','130800','隆化縣','','130825',0);
INSERT INTO sy_area VALUES('130826','130800','豐寧滿族自治縣','','130826',0);
INSERT INTO sy_area VALUES('130827','130800','寬城滿族自治縣','','130827',0);
INSERT INTO sy_area VALUES('130828','130800','圍場滿族蒙古族自治縣','','130828',0);
INSERT INTO sy_area VALUES('130900','130000','滄州市','','130900',0);
INSERT INTO sy_area VALUES('130901','130900','市轄區','','130901',0);
INSERT INTO sy_area VALUES('130902','130901','新華區','','130902',0);
INSERT INTO sy_area VALUES('130903','130901','運河區','','130903',0);
INSERT INTO sy_area VALUES('130921','130900','滄縣','','130921',0);
INSERT INTO sy_area VALUES('130922','130900','青縣','','130922',0);
INSERT INTO sy_area VALUES('130923','130900','東光縣','','130923',0);
INSERT INTO sy_area VALUES('130924','130900','海興縣','','130924',0);
INSERT INTO sy_area VALUES('130925','130900','鹽山縣','','130925',0);
INSERT INTO sy_area VALUES('130926','130900','肅寧縣','','130926',0);
INSERT INTO sy_area VALUES('130927','130900','南皮縣','','130927',0);
INSERT INTO sy_area VALUES('130928','130900','吳橋縣','','130928',0);
INSERT INTO sy_area VALUES('130929','130900','獻縣','','130929',0);
INSERT INTO sy_area VALUES('130930','130900','孟村回族自治縣','','130930',0);
INSERT INTO sy_area VALUES('130981','130900','泊頭市','','130981',0);
INSERT INTO sy_area VALUES('130982','130900','任丘市','','130982',0);
INSERT INTO sy_area VALUES('130983','130900','黃驊市','','130983',0);
INSERT INTO sy_area VALUES('130984','130900','河間市','','130984',0);
INSERT INTO sy_area VALUES('131000','130000','廊坊市','','131000',0);
INSERT INTO sy_area VALUES('131001','131000','市轄區','','131001',0);
INSERT INTO sy_area VALUES('131002','131001','安次區','','131002',0);
INSERT INTO sy_area VALUES('131003','131001','廣陽區','','131003',0);
INSERT INTO sy_area VALUES('131022','131000','固安縣','','131022',0);
INSERT INTO sy_area VALUES('131023','131000','永清縣','','131023',0);
INSERT INTO sy_area VALUES('131024','131000','香河縣','','131024',0);
INSERT INTO sy_area VALUES('131025','131000','大城縣','','131025',0);
INSERT INTO sy_area VALUES('131026','131000','文安縣','','131026',0);
INSERT INTO sy_area VALUES('131028','131000','大廠回族自治縣','','131028',0);
INSERT INTO sy_area VALUES('131081','131000','霸州市','','131081',0);
INSERT INTO sy_area VALUES('131082','131000','三河市','','131082',0);
INSERT INTO sy_area VALUES('131100','130000','衡水市','','131100',0);
INSERT INTO sy_area VALUES('131101','131100','市轄區','','131101',0);
INSERT INTO sy_area VALUES('131102','131101','桃城區','','131102',0);
INSERT INTO sy_area VALUES('131121','131100','棗強縣','','131121',0);
INSERT INTO sy_area VALUES('131122','131100','武邑縣','','131122',0);
INSERT INTO sy_area VALUES('131123','131100','武強縣','','131123',0);
INSERT INTO sy_area VALUES('131124','131100','饒陽縣','','131124',0);
INSERT INTO sy_area VALUES('131125','131100','安平縣','','131125',0);
INSERT INTO sy_area VALUES('131126','131100','故城縣','','131126',0);
INSERT INTO sy_area VALUES('131127','131100','景縣','','131127',0);
INSERT INTO sy_area VALUES('131128','131100','阜城縣','','131128',0);
INSERT INTO sy_area VALUES('131181','131100','冀州市','','131181',0);
INSERT INTO sy_area VALUES('131182','131100','深州市','','131182',0);
INSERT INTO sy_area VALUES('140000','0','山西省','','140000',0);
INSERT INTO sy_area VALUES('140100','140000','太原市','','140100',0);
INSERT INTO sy_area VALUES('140101','140100','市轄區','','140101',0);
INSERT INTO sy_area VALUES('140105','140101','小店區','','140105',0);
INSERT INTO sy_area VALUES('140106','140101','迎澤區','','140106',0);
INSERT INTO sy_area VALUES('140107','140101','杏花嶺區','','140107',0);
INSERT INTO sy_area VALUES('140108','140101','尖草坪區','','140108',0);
INSERT INTO sy_area VALUES('140109','140101','萬柏林區','','140109',0);
INSERT INTO sy_area VALUES('140110','140101','晉源區','','140110',0);
INSERT INTO sy_area VALUES('140121','140100','清徐縣','','140121',0);
INSERT INTO sy_area VALUES('140122','140100','陽曲縣','','140122',0);
INSERT INTO sy_area VALUES('140123','140100','婁煩縣','','140123',0);
INSERT INTO sy_area VALUES('140181','140100','古交市','','140181',0);
INSERT INTO sy_area VALUES('140200','140000','大同市','','140200',0);
INSERT INTO sy_area VALUES('140201','140200','市轄區','','140201',0);
INSERT INTO sy_area VALUES('140202','140201','城區','','140202',0);
INSERT INTO sy_area VALUES('140203','140201','礦區','','140203',0);
INSERT INTO sy_area VALUES('140211','140201','南郊區','','140211',0);
INSERT INTO sy_area VALUES('140212','140201','新榮區','','140212',0);
INSERT INTO sy_area VALUES('140221','140200','陽高縣','','140221',0);
INSERT INTO sy_area VALUES('140222','140200','天鎮縣','','140222',0);
INSERT INTO sy_area VALUES('140223','140200','廣靈縣','','140223',0);
INSERT INTO sy_area VALUES('140224','140200','靈丘縣','','140224',0);
INSERT INTO sy_area VALUES('140225','140200','渾源縣','','140225',0);
INSERT INTO sy_area VALUES('140226','140200','左雲縣','','140226',0);
INSERT INTO sy_area VALUES('140227','140200','大同縣','','140227',0);
INSERT INTO sy_area VALUES('140300','140000','陽泉市','','140300',0);
INSERT INTO sy_area VALUES('140301','140300','市轄區','','140301',0);
INSERT INTO sy_area VALUES('140302','140301','城區','','140302',0);
INSERT INTO sy_area VALUES('140303','140301','礦區','','140303',0);
INSERT INTO sy_area VALUES('140311','140301','郊區','','140311',0);
INSERT INTO sy_area VALUES('140321','140300','平定縣','','140321',0);
INSERT INTO sy_area VALUES('140322','140300','盂縣','','140322',0);
INSERT INTO sy_area VALUES('140400','140000','長治市','','140400',0);
INSERT INTO sy_area VALUES('140401','140400','市轄區','','140401',0);
INSERT INTO sy_area VALUES('140402','140401','城區','','140402',0);
INSERT INTO sy_area VALUES('140411','140401','郊區','','140411',0);
INSERT INTO sy_area VALUES('140421','140400','長治縣','','140421',0);
INSERT INTO sy_area VALUES('140423','140400','襄垣縣','','140423',0);
INSERT INTO sy_area VALUES('140424','140400','屯留縣','','140424',0);
INSERT INTO sy_area VALUES('140425','140400','平順縣','','140425',0);
INSERT INTO sy_area VALUES('140426','140400','黎城縣','','140426',0);
INSERT INTO sy_area VALUES('140427','140400','壺關縣','','140427',0);
INSERT INTO sy_area VALUES('140428','140400','長子縣','','140428',0);
INSERT INTO sy_area VALUES('140429','140400','武鄉縣','','140429',0);
INSERT INTO sy_area VALUES('140430','140400','沁縣','','140430',0);
INSERT INTO sy_area VALUES('140431','140400','沁源縣','','140431',0);
INSERT INTO sy_area VALUES('140481','140400','潞城市','','140481',0);
INSERT INTO sy_area VALUES('140500','140000','晉城市','','140500',0);
INSERT INTO sy_area VALUES('140501','140500','市轄區','','140501',0);
INSERT INTO sy_area VALUES('140502','140501','城區','','140502',0);
INSERT INTO sy_area VALUES('140521','140500','沁水縣','','140521',0);
INSERT INTO sy_area VALUES('140522','140500','陽城縣','','140522',0);
INSERT INTO sy_area VALUES('140524','140500','陵川縣','','140524',0);
INSERT INTO sy_area VALUES('140525','140500','澤州縣','','140525',0);
INSERT INTO sy_area VALUES('140581','140500','高平市','','140581',0);
INSERT INTO sy_area VALUES('140600','140000','朔州市','','140600',0);
INSERT INTO sy_area VALUES('140601','140600','市轄區','','140601',0);
INSERT INTO sy_area VALUES('140602','140601','朔城區','','140602',0);
INSERT INTO sy_area VALUES('140603','140601','平魯區','','140603',0);
INSERT INTO sy_area VALUES('140621','140600','山陰縣','','140621',0);
INSERT INTO sy_area VALUES('140622','140600','應縣','','140622',0);
INSERT INTO sy_area VALUES('140623','140600','右玉縣','','140623',0);
INSERT INTO sy_area VALUES('140624','140600','懷仁縣','','140624',0);
INSERT INTO sy_area VALUES('140700','140000','晉中市','','140700',0);
INSERT INTO sy_area VALUES('140701','140700','市轄區','','140701',0);
INSERT INTO sy_area VALUES('140702','140701','榆次區','','140702',0);
INSERT INTO sy_area VALUES('140721','140700','榆社縣','','140721',0);
INSERT INTO sy_area VALUES('140722','140700','左權縣','','140722',0);
INSERT INTO sy_area VALUES('140723','140700','和順縣','','140723',0);
INSERT INTO sy_area VALUES('140724','140700','昔陽縣','','140724',0);
INSERT INTO sy_area VALUES('140725','140700','壽陽縣','','140725',0);
INSERT INTO sy_area VALUES('140726','140700','太谷縣','','140726',0);
INSERT INTO sy_area VALUES('140727','140700','祁縣','','140727',0);
INSERT INTO sy_area VALUES('140728','140700','平遙縣','','140728',0);
INSERT INTO sy_area VALUES('140729','140700','靈石縣','','140729',0);
INSERT INTO sy_area VALUES('140781','140700','介休市','','140781',0);
INSERT INTO sy_area VALUES('140800','140000','運城市','','140800',0);
INSERT INTO sy_area VALUES('140801','140800','市轄區','','140801',0);
INSERT INTO sy_area VALUES('140802','140801','鹽湖區','','140802',0);
INSERT INTO sy_area VALUES('140821','140800','臨猗縣','','140821',0);
INSERT INTO sy_area VALUES('140822','140800','萬榮縣','','140822',0);
INSERT INTO sy_area VALUES('140823','140800','聞喜縣','','140823',0);
INSERT INTO sy_area VALUES('140824','140800','稷山縣','','140824',0);
INSERT INTO sy_area VALUES('140825','140800','新絳縣','','140825',0);
INSERT INTO sy_area VALUES('140826','140800','絳縣','','140826',0);
INSERT INTO sy_area VALUES('140827','140800','垣曲縣','','140827',0);
INSERT INTO sy_area VALUES('140828','140800','夏縣','','140828',0);
INSERT INTO sy_area VALUES('140829','140800','平陸縣','','140829',0);
INSERT INTO sy_area VALUES('140830','140800','芮城縣','','140830',0);
INSERT INTO sy_area VALUES('140881','140800','永濟市','','140881',0);
INSERT INTO sy_area VALUES('140882','140800','河津市','','140882',0);
INSERT INTO sy_area VALUES('140900','140000','忻州市','','140900',0);
INSERT INTO sy_area VALUES('140901','140900','忻府區','','140901',0);
INSERT INTO sy_area VALUES('140921','140900','定襄縣','','140921',0);
INSERT INTO sy_area VALUES('140922','140900','五台縣','','140922',0);
INSERT INTO sy_area VALUES('140923','140900','代縣','','140923',0);
INSERT INTO sy_area VALUES('140924','140900','繁峙縣','','140924',0);
INSERT INTO sy_area VALUES('140925','140900','寧武縣','','140925',0);
INSERT INTO sy_area VALUES('140926','140900','靜樂縣','','140926',0);
INSERT INTO sy_area VALUES('140927','140900','神池縣','','140927',0);
INSERT INTO sy_area VALUES('140928','140900','五寨縣','','140928',0);
INSERT INTO sy_area VALUES('140929','140900','岢嵐縣','','140929',0);
INSERT INTO sy_area VALUES('140930','140900','河曲縣','','140930',0);
INSERT INTO sy_area VALUES('140931','140900','保德縣','','140931',0);
INSERT INTO sy_area VALUES('140932','140900','偏關縣','','140932',0);
INSERT INTO sy_area VALUES('140981','140900','原平市','','140981',0);
INSERT INTO sy_area VALUES('141000','140000','臨汾市','','141000',0);
INSERT INTO sy_area VALUES('141001','141000','市轄區','','141001',0);
INSERT INTO sy_area VALUES('141002','141000','堯都區','','141002',0);
INSERT INTO sy_area VALUES('141021','141000','曲沃縣','','141021',0);
INSERT INTO sy_area VALUES('141022','141000','翼城縣','','141022',0);
INSERT INTO sy_area VALUES('141023','141000','襄汾縣','','141023',0);
INSERT INTO sy_area VALUES('141024','141000','洪洞縣','','141024',0);
INSERT INTO sy_area VALUES('141025','141000','古縣','','141025',0);
INSERT INTO sy_area VALUES('141026','141000','安澤縣','','141026',0);
INSERT INTO sy_area VALUES('141027','141000','浮山縣','','141027',0);
INSERT INTO sy_area VALUES('141028','141000','吉縣','','141028',0);
INSERT INTO sy_area VALUES('141029','141000','鄉寧縣','','141029',0);
INSERT INTO sy_area VALUES('141030','141000','大寧縣','','141030',0);
INSERT INTO sy_area VALUES('141031','141000','隰縣','','141031',0);
INSERT INTO sy_area VALUES('141032','141000','永和縣','','141032',0);
INSERT INTO sy_area VALUES('141033','141000','蒲縣','','141033',0);
INSERT INTO sy_area VALUES('141034','141000','汾西縣','','141034',0);
INSERT INTO sy_area VALUES('141081','141000','侯馬市','','141081',0);
INSERT INTO sy_area VALUES('141082','141000','霍州市','','141082',0);
INSERT INTO sy_area VALUES('141100','140000','呂梁市','','141100',0);
INSERT INTO sy_area VALUES('141101','141100','市轄區','','141101',0);
INSERT INTO sy_area VALUES('141102','141101','離石區','','141102',0);
INSERT INTO sy_area VALUES('141121','141100','文水縣','','141121',0);
INSERT INTO sy_area VALUES('141122','141100','交城縣','','141122',0);
INSERT INTO sy_area VALUES('141123','141100','興縣','','141123',0);
INSERT INTO sy_area VALUES('141124','141100','臨縣','','141124',0);
INSERT INTO sy_area VALUES('141125','141100','柳林縣','','141125',0);
INSERT INTO sy_area VALUES('141126','141100','石樓縣','','141126',0);
INSERT INTO sy_area VALUES('141127','141100','嵐縣','','141127',0);
INSERT INTO sy_area VALUES('141128','141100','方山縣','','141128',0);
INSERT INTO sy_area VALUES('141129','141100','中陽縣','','141129',0);
INSERT INTO sy_area VALUES('141130','141100','交口縣','','141130',0);
INSERT INTO sy_area VALUES('141181','141100','孝義市','','141181',0);
INSERT INTO sy_area VALUES('141182','141100','汾陽市','','141182',0);
INSERT INTO sy_area VALUES('150000','0','內蒙古自治區','','150000',0);
INSERT INTO sy_area VALUES('150100','150000','呼和浩特市','','150100',0);
INSERT INTO sy_area VALUES('150101','150100','市轄區','','150101',0);
INSERT INTO sy_area VALUES('150102','150101','新城區','','150102',0);
INSERT INTO sy_area VALUES('150103','150101','回民區','','150103',0);
INSERT INTO sy_area VALUES('150104','150101','玉泉區','','150104',0);
INSERT INTO sy_area VALUES('150105','150101','賽罕區','','150105',0);
INSERT INTO sy_area VALUES('150121','150100','土默特左旗','','150121',0);
INSERT INTO sy_area VALUES('150122','150100','托克托縣','','150122',0);
INSERT INTO sy_area VALUES('150123','150100','和林格爾縣','','150123',0);
INSERT INTO sy_area VALUES('150124','150100','清水河縣','','150124',0);
INSERT INTO sy_area VALUES('150125','150100','武川縣','','150125',0);
INSERT INTO sy_area VALUES('150200','150000','包頭市','','150200',0);
INSERT INTO sy_area VALUES('150201','150200','市轄區','','150201',0);
INSERT INTO sy_area VALUES('150202','150201','東河區','','150202',0);
INSERT INTO sy_area VALUES('150203','150201','昆都侖區','','150203',0);
INSERT INTO sy_area VALUES('150204','150201','青山區','','150204',0);
INSERT INTO sy_area VALUES('150205','150201','石拐區','','150205',0);
INSERT INTO sy_area VALUES('150206','150201','白雲礦區','','150206',0);
INSERT INTO sy_area VALUES('150207','150201','九原區','','150207',0);
INSERT INTO sy_area VALUES('150221','150200','土默特右旗','','150221',0);
INSERT INTO sy_area VALUES('150222','150200','固陽縣','','150222',0);
INSERT INTO sy_area VALUES('150223','150200','達爾罕茂明安聯合旗','','150223',0);
INSERT INTO sy_area VALUES('150300','150000','烏海市','','150300',0);
INSERT INTO sy_area VALUES('150301','150300','市轄區','','150301',0);
INSERT INTO sy_area VALUES('150302','150301','海勃灣區','','150302',0);
INSERT INTO sy_area VALUES('150303','150301','海南區','','150303',0);
INSERT INTO sy_area VALUES('150304','150301','烏達區','','150304',0);
INSERT INTO sy_area VALUES('150400','150000','赤峰市','','150400',0);
INSERT INTO sy_area VALUES('150401','150400','市轄區','','150401',0);
INSERT INTO sy_area VALUES('150402','150401','紅山區','','150402',0);
INSERT INTO sy_area VALUES('150403','150401','元寶山區','','150403',0);
INSERT INTO sy_area VALUES('150404','150401','松山區','','150404',0);
INSERT INTO sy_area VALUES('150421','150400','阿魯科爾沁旗','','150421',0);
INSERT INTO sy_area VALUES('150422','150400','巴林左旗','','150422',0);
INSERT INTO sy_area VALUES('150423','150400','巴林右旗','','150423',0);
INSERT INTO sy_area VALUES('150424','150400','林西縣','','150424',0);
INSERT INTO sy_area VALUES('150425','150400','克什克騰旗','','150425',0);
INSERT INTO sy_area VALUES('150426','150400','翁牛特旗','','150426',0);
INSERT INTO sy_area VALUES('150428','150400','喀喇沁旗','','150428',0);
INSERT INTO sy_area VALUES('150429','150400','寧城縣','','150429',0);
INSERT INTO sy_area VALUES('150430','150400','敖漢旗','','150430',0);
INSERT INTO sy_area VALUES('150500','150000','通遼市','','150500',0);
INSERT INTO sy_area VALUES('150501','150500','市轄區','','150501',0);
INSERT INTO sy_area VALUES('150502','150501','科爾沁區','','150502',0);
INSERT INTO sy_area VALUES('150521','150500','科爾沁左翼中旗','','150521',0);
INSERT INTO sy_area VALUES('150522','150500','科爾沁左翼後旗','','150522',0);
INSERT INTO sy_area VALUES('150523','150500','開魯縣','','150523',0);
INSERT INTO sy_area VALUES('150524','150500','庫倫旗','','150524',0);
INSERT INTO sy_area VALUES('150525','150500','奈曼旗','','150525',0);
INSERT INTO sy_area VALUES('150526','150500','扎魯特旗','','150526',0);
INSERT INTO sy_area VALUES('150581','150500','霍林郭勒市','','150581',0);
INSERT INTO sy_area VALUES('150600','150000','鄂爾多斯市','','150600',0);
INSERT INTO sy_area VALUES('150602','150600','東勝區','','150602',0);
INSERT INTO sy_area VALUES('150621','150600','達拉特旗','','150621',0);
INSERT INTO sy_area VALUES('150622','150600','準格爾旗','','150622',0);
INSERT INTO sy_area VALUES('150623','150600','鄂托克前旗','','150623',0);
INSERT INTO sy_area VALUES('150624','150600','鄂托克旗','','150624',0);
INSERT INTO sy_area VALUES('150625','150600','杭錦旗','','150625',0);
INSERT INTO sy_area VALUES('150626','150600','烏審旗','','150626',0);
INSERT INTO sy_area VALUES('150627','150600','伊金霍洛旗','','150627',0);
INSERT INTO sy_area VALUES('150700','150000','呼倫貝爾市','','150700',0);
INSERT INTO sy_area VALUES('150701','150700','市轄區','','150701',0);
INSERT INTO sy_area VALUES('150702','150701','海拉爾區','','150702',0);
INSERT INTO sy_area VALUES('150721','150700','阿榮旗','','150721',0);
INSERT INTO sy_area VALUES('150723','150700','鄂倫春自治旗','','150723',0);
INSERT INTO sy_area VALUES('150724','150700','鄂溫克族自治旗','','150724',0);
INSERT INTO sy_area VALUES('150725','150700','陳巴爾虎旗','','150725',0);
INSERT INTO sy_area VALUES('150726','150700','新巴爾虎左旗','','150726',0);
INSERT INTO sy_area VALUES('150727','150700','新巴爾虎右旗','','150727',0);
INSERT INTO sy_area VALUES('150781','150700','滿洲里市','','150781',0);
INSERT INTO sy_area VALUES('150782','150700','牙克石市','','150782',0);
INSERT INTO sy_area VALUES('150783','150700','扎蘭屯市','','150783',0);
INSERT INTO sy_area VALUES('150784','150700','額爾古納市','','150784',0);
INSERT INTO sy_area VALUES('150785','150700','根河市','','150785',0);
INSERT INTO sy_area VALUES('150800','150000','巴彥淖爾市','','150800',0);
INSERT INTO sy_area VALUES('150801','150800','市轄區','','150801',0);
INSERT INTO sy_area VALUES('150802','150800','臨河區','','150802',0);
INSERT INTO sy_area VALUES('150821','150800','五原縣','','150821',0);
INSERT INTO sy_area VALUES('150822','150800','磴口縣','','150822',0);
INSERT INTO sy_area VALUES('150823','150800','烏拉特前旗','','150823',0);
INSERT INTO sy_area VALUES('150824','150800','烏拉特中旗','','150824',0);
INSERT INTO sy_area VALUES('150825','150800','烏拉特後旗','','150825',0);
INSERT INTO sy_area VALUES('150826','150800','杭錦後旗','','150826',0);
INSERT INTO sy_area VALUES('150900','150000','烏蘭察布市','','150900',0);
INSERT INTO sy_area VALUES('150901','150900','市轄區','','150901',0);
INSERT INTO sy_area VALUES('150902','150901','集寧區','','150902',0);
INSERT INTO sy_area VALUES('150921','150900','卓資縣','','150921',0);
INSERT INTO sy_area VALUES('150922','150900','化德縣','','150922',0);
INSERT INTO sy_area VALUES('150923','150900','商都縣','','150923',0);
INSERT INTO sy_area VALUES('150924','150900','興和縣','','150924',0);
INSERT INTO sy_area VALUES('150925','150900','涼城縣','','150925',0);
INSERT INTO sy_area VALUES('150926','150900','察哈爾右翼前旗','','150926',0);
INSERT INTO sy_area VALUES('150927','150900','察哈爾右翼中旗','','150927',0);
INSERT INTO sy_area VALUES('150928','150900','察哈爾右翼後旗','','150928',0);
INSERT INTO sy_area VALUES('150929','150900','四子王旗','','150929',0);
INSERT INTO sy_area VALUES('150981','150900','豐鎮市','','150981',0);
INSERT INTO sy_area VALUES('152200','150000','興安盟','','152200',0);
INSERT INTO sy_area VALUES('152201','152200','烏蘭浩特市','','152201',0);
INSERT INTO sy_area VALUES('152202','152200','阿爾山市','','152202',0);
INSERT INTO sy_area VALUES('152221','152200','科爾沁右翼前旗','','152221',0);
INSERT INTO sy_area VALUES('152222','152200','科爾沁右翼中旗','','152222',0);
INSERT INTO sy_area VALUES('152223','152200','扎賚特旗','','152223',0);
INSERT INTO sy_area VALUES('152224','152200','突泉縣','','152224',0);
INSERT INTO sy_area VALUES('152500','150000','錫林郭勒盟','','152500',0);
INSERT INTO sy_area VALUES('152501','152500','二連浩特市','','152501',0);
INSERT INTO sy_area VALUES('152502','152500','錫林浩特市','','152502',0);
INSERT INTO sy_area VALUES('152522','152500','阿巴嘎旗','','152522',0);
INSERT INTO sy_area VALUES('152523','152500','蘇尼特左旗','','152523',0);
INSERT INTO sy_area VALUES('152524','152500','蘇尼特右旗','','152524',0);
INSERT INTO sy_area VALUES('152525','152500','東烏珠穆沁旗','','152525',0);
INSERT INTO sy_area VALUES('152526','152500','西烏珠穆沁旗','','152526',0);
INSERT INTO sy_area VALUES('152527','152500','太僕寺旗','','152527',0);
INSERT INTO sy_area VALUES('152528','152500','鑲黃旗','','152528',0);
INSERT INTO sy_area VALUES('152529','152500','正鑲白旗','','152529',0);
INSERT INTO sy_area VALUES('152530','152500','正藍旗','','152530',0);
INSERT INTO sy_area VALUES('152531','152500','多倫縣','','152531',0);
INSERT INTO sy_area VALUES('152900','150000','阿拉善盟','','152900',0);
INSERT INTO sy_area VALUES('152921','152900','阿拉善左旗','','152921',0);
INSERT INTO sy_area VALUES('152922','152900','阿拉善右旗','','152922',0);
INSERT INTO sy_area VALUES('152923','152900','額濟納旗','','152923',0);
INSERT INTO sy_area VALUES('210000','0','遼寧省','','210000',0);
INSERT INTO sy_area VALUES('210100','210000','沈陽市','','210100',0);
INSERT INTO sy_area VALUES('210101','210100','市轄區','','210101',0);
INSERT INTO sy_area VALUES('210102','210101','和平區','','210102',0);
INSERT INTO sy_area VALUES('210103','210101','沈河區','','210103',0);
INSERT INTO sy_area VALUES('210104','210101','大東區','','210104',0);
INSERT INTO sy_area VALUES('210105','210101','皇姑區','','210105',0);
INSERT INTO sy_area VALUES('210106','210101','鐵西區','','210106',0);
INSERT INTO sy_area VALUES('210111','210101','蘇家屯區','','210111',0);
INSERT INTO sy_area VALUES('210112','210101','東陵區','','210112',0);
INSERT INTO sy_area VALUES('210113','210101','新城子區','','210113',0);
INSERT INTO sy_area VALUES('210114','210101','於洪區','','210114',0);
INSERT INTO sy_area VALUES('210122','210100','遼中縣','','210122',0);
INSERT INTO sy_area VALUES('210123','210100','康平縣','','210123',0);
INSERT INTO sy_area VALUES('210124','210100','法庫縣','','210124',0);
INSERT INTO sy_area VALUES('210181','210100','新民市','','210181',0);
INSERT INTO sy_area VALUES('210182','210100','沈北新區','','210182',0);
INSERT INTO sy_area VALUES('210200','210000','大連市','','210200',0);
INSERT INTO sy_area VALUES('210201','210200','市轄區','','210201',0);
INSERT INTO sy_area VALUES('210202','210201','中山區','','210202',0);
INSERT INTO sy_area VALUES('210203','210201','西崗區','','210203',0);
INSERT INTO sy_area VALUES('210204','210201','沙河口區','','210204',0);
INSERT INTO sy_area VALUES('210211','210201','甘井子區','','210211',0);
INSERT INTO sy_area VALUES('210212','210201','旅順口區','','210212',0);
INSERT INTO sy_area VALUES('210213','210201','金州區','','210213',0);
INSERT INTO sy_area VALUES('210224','210200','長海縣','','210224',0);
INSERT INTO sy_area VALUES('210281','210200','瓦房店市','','210281',0);
INSERT INTO sy_area VALUES('210282','210200','普蘭店市','','210282',0);
INSERT INTO sy_area VALUES('210283','210200','莊河市','','210283',0);
INSERT INTO sy_area VALUES('210300','210000','鞍山市','','210300',0);
INSERT INTO sy_area VALUES('210301','210300','市轄區','','210301',0);
INSERT INTO sy_area VALUES('210302','210301','鐵東區','','210302',0);
INSERT INTO sy_area VALUES('210303','210301','鐵西區','','210303',0);
INSERT INTO sy_area VALUES('210304','210301','立山區','','210304',0);
INSERT INTO sy_area VALUES('210311','210301','千山區','','210311',0);
INSERT INTO sy_area VALUES('210321','210300','台安縣','','210321',0);
INSERT INTO sy_area VALUES('210323','210300','岫岩滿族自治縣','','210323',0);
INSERT INTO sy_area VALUES('210381','210300','海城市','','210381',0);
INSERT INTO sy_area VALUES('210400','210000','撫順市','','210400',0);
INSERT INTO sy_area VALUES('210401','210400','市轄區','','210401',0);
INSERT INTO sy_area VALUES('210402','210401','新撫區','','210402',0);
INSERT INTO sy_area VALUES('210403','210401','東洲區','','210403',0);
INSERT INTO sy_area VALUES('210404','210401','望花區','','210404',0);
INSERT INTO sy_area VALUES('210411','210401','順城區','','210411',0);
INSERT INTO sy_area VALUES('210421','210400','撫順縣','','210421',0);
INSERT INTO sy_area VALUES('210422','210400','新賓滿族自治縣','','210422',0);
INSERT INTO sy_area VALUES('210423','210400','清原滿族自治縣','','210423',0);
INSERT INTO sy_area VALUES('210500','210000','本溪市','','210500',0);
INSERT INTO sy_area VALUES('210501','210500','市轄區','','210501',0);
INSERT INTO sy_area VALUES('210502','210501','平山區','','210502',0);
INSERT INTO sy_area VALUES('210503','210501','溪湖??','','210503',0);
INSERT INTO sy_area VALUES('210504','210501','明山區','','210504',0);
INSERT INTO sy_area VALUES('210505','210501','南芬區','','210505',0);
INSERT INTO sy_area VALUES('210521','210500','本溪滿族自治縣','','210521',0);
INSERT INTO sy_area VALUES('210522','210500','桓仁滿族自治縣','','210522',0);
INSERT INTO sy_area VALUES('210600','210000','丹東市','','210600',0);
INSERT INTO sy_area VALUES('210601','210600','市轄區','','210601',0);
INSERT INTO sy_area VALUES('210602','210601','元寶區','','210602',0);
INSERT INTO sy_area VALUES('210603','210601','振興區','','210603',0);
INSERT INTO sy_area VALUES('210604','210601','振安區','','210604',0);
INSERT INTO sy_area VALUES('210624','210600','寬甸滿族自治縣','','210624',0);
INSERT INTO sy_area VALUES('210681','210600','東港市','','210681',0);
INSERT INTO sy_area VALUES('210682','210600','鳳城市','','210682',0);
INSERT INTO sy_area VALUES('210700','210000','錦州市','','210700',0);
INSERT INTO sy_area VALUES('210701','210700','市轄區','','210701',0);
INSERT INTO sy_area VALUES('210702','210701','古塔區','','210702',0);
INSERT INTO sy_area VALUES('210703','210701','凌河區','','210703',0);
INSERT INTO sy_area VALUES('210711','210701','太和區','','210711',0);
INSERT INTO sy_area VALUES('210726','210700','黑山縣','','210726',0);
INSERT INTO sy_area VALUES('210727','210700','義縣','','210727',0);
INSERT INTO sy_area VALUES('210781','210700','凌海市','','210781',0);
INSERT INTO sy_area VALUES('210782','210700','北寧市','','210782',0);
INSERT INTO sy_area VALUES('210800','210000','營口市','','210800',0);
INSERT INTO sy_area VALUES('210801','210800','市轄區','','210801',0);
INSERT INTO sy_area VALUES('210802','210801','站前區','','210802',0);
INSERT INTO sy_area VALUES('210803','210801','西市區','','210803',0);
INSERT INTO sy_area VALUES('210804','210801','鮁魚圈區','','210804',0);
INSERT INTO sy_area VALUES('210811','210801','老邊區','','210811',0);
INSERT INTO sy_area VALUES('210881','210800','蓋州市','','210881',0);
INSERT INTO sy_area VALUES('210882','210800','大石橋市','','210882',0);
INSERT INTO sy_area VALUES('210900','210000','阜新市','','210900',0);
INSERT INTO sy_area VALUES('210901','210900','市轄區','','210901',0);
INSERT INTO sy_area VALUES('210902','210901','海州區','','210902',0);
INSERT INTO sy_area VALUES('210903','210901','新邱區','','210903',0);
INSERT INTO sy_area VALUES('210904','210901','太平區','','210904',0);
INSERT INTO sy_area VALUES('210905','210901','清河門區','','210905',0);
INSERT INTO sy_area VALUES('210911','210901','細河區','','210911',0);
INSERT INTO sy_area VALUES('210921','210900','阜新蒙古族自治縣','','210921',0);
INSERT INTO sy_area VALUES('210922','210900','彰武縣','','210922',0);
INSERT INTO sy_area VALUES('211000','210000','遼陽市','','211000',0);
INSERT INTO sy_area VALUES('211001','211000','市轄區','','211001',0);
INSERT INTO sy_area VALUES('211002','211001','白塔區','','211002',0);
INSERT INTO sy_area VALUES('211003','211001','文聖區','','211003',0);
INSERT INTO sy_area VALUES('211004','211001','巨集偉區','','211004',0);
INSERT INTO sy_area VALUES('211005','211001','弓長嶺區','','211005',0);
INSERT INTO sy_area VALUES('211011','211001','太子河區','','211011',0);
INSERT INTO sy_area VALUES('211021','211000','遼陽縣','','211021',0);
INSERT INTO sy_area VALUES('211081','211000','燈塔市','','211081',0);
INSERT INTO sy_area VALUES('211100','210000','盤錦市','','211100',0);
INSERT INTO sy_area VALUES('211101','211100','市轄區','','211101',0);
INSERT INTO sy_area VALUES('211102','211101','雙檯子區','','211102',0);
INSERT INTO sy_area VALUES('211103','211101','興隆台區','','211103',0);
INSERT INTO sy_area VALUES('211121','211100','大窪縣','','211121',0);
INSERT INTO sy_area VALUES('211122','211100','盤山縣','','211122',0);
INSERT INTO sy_area VALUES('211200','210000','鐵嶺市','','211200',0);
INSERT INTO sy_area VALUES('211201','211200','市轄區','','211201',0);
INSERT INTO sy_area VALUES('211202','211201','銀州區','','211202',0);
INSERT INTO sy_area VALUES('211204','211201','清河區','','211204',0);
INSERT INTO sy_area VALUES('211221','211200','鐵嶺縣','','211221',0);
INSERT INTO sy_area VALUES('211223','211200','西豐縣','','211223',0);
INSERT INTO sy_area VALUES('211224','211200','昌圖縣','','211224',0);
INSERT INTO sy_area VALUES('211281','211200','調兵山市','','211281',0);
INSERT INTO sy_area VALUES('211282','211200','開原市','','211282',0);
INSERT INTO sy_area VALUES('211300','210000','朝陽市','','211300',0);
INSERT INTO sy_area VALUES('211301','211300','市轄區','','211301',0);
INSERT INTO sy_area VALUES('211302','211301','雙塔區','','211302',0);
INSERT INTO sy_area VALUES('211303','211301','龍城區','','211303',0);
INSERT INTO sy_area VALUES('211321','211300','朝陽縣','','211321',0);
INSERT INTO sy_area VALUES('211322','211300','建平縣','','211322',0);
INSERT INTO sy_area VALUES('211381','211300','北票市','','211381',0);
INSERT INTO sy_area VALUES('211382','211300','凌源市','','211382',0);
INSERT INTO sy_area VALUES('211400','210000','葫蘆島市','','211400',0);
INSERT INTO sy_area VALUES('211401','211400','市轄區','','211401',0);
INSERT INTO sy_area VALUES('211402','211401','連山區','','211402',0);
INSERT INTO sy_area VALUES('211403','211401','龍港區','','211403',0);
INSERT INTO sy_area VALUES('211404','211401','南票區','','211404',0);
INSERT INTO sy_area VALUES('211421','211400','綏中縣','','211421',0);
INSERT INTO sy_area VALUES('211422','211400','建昌縣','','211422',0);
INSERT INTO sy_area VALUES('211481','211400','興城市','','211481',0);
INSERT INTO sy_area VALUES('220000','0','吉林省','','220000',0);
INSERT INTO sy_area VALUES('220100','220000','長春市','','220100',0);
INSERT INTO sy_area VALUES('220101','220100','市轄區','','220101',0);
INSERT INTO sy_area VALUES('220102','220101','南關區','','220102',0);
INSERT INTO sy_area VALUES('220103','220101','寬城區','','220103',0);
INSERT INTO sy_area VALUES('220104','220101','朝陽區','','220104',0);
INSERT INTO sy_area VALUES('220105','220101','二道區','','220105',0);
INSERT INTO sy_area VALUES('220106','220101','綠園區','','220106',0);
INSERT INTO sy_area VALUES('220112','220101','雙陽區','','220112',0);
INSERT INTO sy_area VALUES('220122','220100','農安縣','','220122',0);
INSERT INTO sy_area VALUES('220181','220100','九台市','','220181',0);
INSERT INTO sy_area VALUES('220182','220100','榆樹市','','220182',0);
INSERT INTO sy_area VALUES('220183','220100','德惠市','','220183',0);
INSERT INTO sy_area VALUES('220200','220000','吉林市','','220200',0);
INSERT INTO sy_area VALUES('220201','220200','市轄區','','220201',0);
INSERT INTO sy_area VALUES('220202','220201','昌邑區','','220202',0);
INSERT INTO sy_area VALUES('220203','220201','龍潭區','','220203',0);
INSERT INTO sy_area VALUES('220204','220201','船營區','','220204',0);
INSERT INTO sy_area VALUES('220211','220201','豐滿區','','220211',0);
INSERT INTO sy_area VALUES('220221','220200','永吉縣','','220221',0);
INSERT INTO sy_area VALUES('220281','220200','蛟河市','','220281',0);
INSERT INTO sy_area VALUES('220282','220200','樺甸市','','220282',0);
INSERT INTO sy_area VALUES('220283','220200','舒蘭市','','220283',0);
INSERT INTO sy_area VALUES('220284','220200','磐石市','','220284',0);
INSERT INTO sy_area VALUES('220300','220000','四平市','','220300',0);
INSERT INTO sy_area VALUES('220301','220300','市轄區','','220301',0);
INSERT INTO sy_area VALUES('220302','220301','鐵西區','','220302',0);
INSERT INTO sy_area VALUES('220303','220301','鐵東區','','220303',0);
INSERT INTO sy_area VALUES('220322','220300','梨樹縣','','220322',0);
INSERT INTO sy_area VALUES('220323','220300','伊通滿族自治縣','','220323',0);
INSERT INTO sy_area VALUES('220381','220300','公主嶺市','','220381',0);
INSERT INTO sy_area VALUES('220382','220300','雙遼市','','220382',0);
INSERT INTO sy_area VALUES('220400','220000','遼源市','','220400',0);
INSERT INTO sy_area VALUES('220401','220400','市轄區','','220401',0);
INSERT INTO sy_area VALUES('220402','220401','龍山區','','220402',0);
INSERT INTO sy_area VALUES('220403','220401','西安區','','220403',0);
INSERT INTO sy_area VALUES('220421','220400','東豐縣','','220421',0);
INSERT INTO sy_area VALUES('220422','220400','東遼縣','','220422',0);
INSERT INTO sy_area VALUES('220500','220000','通化市','','220500',0);
INSERT INTO sy_area VALUES('220501','220500','市轄區','','220501',0);
INSERT INTO sy_area VALUES('220502','220501','東昌區','','220502',0);
INSERT INTO sy_area VALUES('220503','220501','二道江區','','220503',0);
INSERT INTO sy_area VALUES('220521','220500','通化縣','','220521',0);
INSERT INTO sy_area VALUES('220523','220500','輝南縣','','220523',0);
INSERT INTO sy_area VALUES('220524','220500','柳河縣','','220524',0);
INSERT INTO sy_area VALUES('220581','220500','梅河口市','','220581',0);
INSERT INTO sy_area VALUES('220582','220500','集安市','','220582',0);
INSERT INTO sy_area VALUES('220600','220000','白山市','','220600',0);
INSERT INTO sy_area VALUES('220601','220600','市轄區','','220601',0);
INSERT INTO sy_area VALUES('220602','220601','八道江區','','220602',0);
INSERT INTO sy_area VALUES('220621','220600','撫松縣','','220621',0);
INSERT INTO sy_area VALUES('220622','220600','靖宇縣','','220622',0);
INSERT INTO sy_area VALUES('220623','220600','長白北韓族自治縣','','220623',0);
INSERT INTO sy_area VALUES('220625','220600','江源區','','220625',0);
INSERT INTO sy_area VALUES('220681','220600','臨江市','','220681',0);
INSERT INTO sy_area VALUES('220700','220000','松原市','','220700',0);
INSERT INTO sy_area VALUES('220701','220700','市轄區','','220701',0);
INSERT INTO sy_area VALUES('220702','220701','寧江區','','220702',0);
INSERT INTO sy_area VALUES('220722','220700','長嶺縣','','220722',0);
INSERT INTO sy_area VALUES('220723','220700','乾安縣','','220723',0);
INSERT INTO sy_area VALUES('220724','220700','扶餘市','','220724',0);
INSERT INTO sy_area VALUES('220800','220000','白城市','','220800',0);
INSERT INTO sy_area VALUES('220801','220800','市轄區','','220801',0);
INSERT INTO sy_area VALUES('220802','220800','洮北區','','220802',0);
INSERT INTO sy_area VALUES('220821','220800','鎮賚縣','','220821',0);
INSERT INTO sy_area VALUES('220822','220800','通榆縣','','220822',0);
INSERT INTO sy_area VALUES('220881','220800','洮南市','','220881',0);
INSERT INTO sy_area VALUES('220882','220800','大安市','','220882',0);
INSERT INTO sy_area VALUES('222400','220000','延邊北韓族自治州','','222400',0);
INSERT INTO sy_area VALUES('222401','222400','延吉市','','222401',0);
INSERT INTO sy_area VALUES('222402','222400','圖們市','','222402',0);
INSERT INTO sy_area VALUES('222403','222400','敦化市','','222403',0);
INSERT INTO sy_area VALUES('222404','222400','琿春市','','222404',0);
INSERT INTO sy_area VALUES('222405','222400','龍井市','','222405',0);
INSERT INTO sy_area VALUES('222406','222400','和龍市','','222406',0);
INSERT INTO sy_area VALUES('222424','222400','汪清縣','','222424',0);
INSERT INTO sy_area VALUES('222426','222400','安圖縣','','222426',0);
INSERT INTO sy_area VALUES('230000','0','黑龍江省','','230000',0);
INSERT INTO sy_area VALUES('230100','230000','哈爾濱市','','230100',0);
INSERT INTO sy_area VALUES('230101','230100','市轄區','','230101',0);
INSERT INTO sy_area VALUES('230102','230101','道里區','','230102',0);
INSERT INTO sy_area VALUES('230103','230101','南崗區','','230103',0);
INSERT INTO sy_area VALUES('230104','230101','道外區','','230104',0);
INSERT INTO sy_area VALUES('230106','230101','香坊區','','230106',0);
INSERT INTO sy_area VALUES('230107','230101','動力區','','230107',0);
INSERT INTO sy_area VALUES('230108','230101','平房區','','230108',0);
INSERT INTO sy_area VALUES('230109','230101','松北區','','230109',0);
INSERT INTO sy_area VALUES('230111','230101','呼蘭區','','230111',0);
INSERT INTO sy_area VALUES('230123','230100','依蘭縣','','230123',0);
INSERT INTO sy_area VALUES('230124','230100','方正縣','','230124',0);
INSERT INTO sy_area VALUES('230125','230100','賓縣','','230125',0);
INSERT INTO sy_area VALUES('230126','230100','巴彥縣','','230126',0);
INSERT INTO sy_area VALUES('230127','230100','木蘭縣','','230127',0);
INSERT INTO sy_area VALUES('230128','230100','通河縣','','230128',0);
INSERT INTO sy_area VALUES('230129','230100','延壽縣','','230129',0);
INSERT INTO sy_area VALUES('230181','230100','阿城市','','230181',0);
INSERT INTO sy_area VALUES('230182','230100','雙城市','','230182',0);
INSERT INTO sy_area VALUES('230183','230100','尚志市','','230183',0);
INSERT INTO sy_area VALUES('230184','230100','五常市','','230184',0);
INSERT INTO sy_area VALUES('230200','230000','齊齊哈爾市','','230200',0);
INSERT INTO sy_area VALUES('230201','230200','市轄區','','230201',0);
INSERT INTO sy_area VALUES('230202','230201','龍沙區','','230202',0);
INSERT INTO sy_area VALUES('230203','230201','建華區','','230203',0);
INSERT INTO sy_area VALUES('230204','230201','鐵鋒區','','230204',0);
INSERT INTO sy_area VALUES('230205','230201','昂昂溪區','','230205',0);
INSERT INTO sy_area VALUES('230206','230201','富拉爾基區','','230206',0);
INSERT INTO sy_area VALUES('230207','230201','碾子山區','','230207',0);
INSERT INTO sy_area VALUES('230208','230201','梅裡斯達斡爾族區','','230208',0);
INSERT INTO sy_area VALUES('230221','230200','龍江縣','','230221',0);
INSERT INTO sy_area VALUES('230223','230200','依安縣','','230223',0);
INSERT INTO sy_area VALUES('230224','230200','泰來縣','','230224',0);
INSERT INTO sy_area VALUES('230225','230200','甘南縣','','230225',0);
INSERT INTO sy_area VALUES('230227','230200','富裕縣','','230227',0);
INSERT INTO sy_area VALUES('230229','230200','克山縣','','230229',0);
INSERT INTO sy_area VALUES('230230','230200','克東縣','','230230',0);
INSERT INTO sy_area VALUES('230231','230200','拜泉縣','','230231',0);
INSERT INTO sy_area VALUES('230281','230200','訥河市','','230281',0);
INSERT INTO sy_area VALUES('230300','230000','雞西市','','230300',0);
INSERT INTO sy_area VALUES('230301','230300','市轄區','','230301',0);
INSERT INTO sy_area VALUES('230302','230301','雞冠區','','230302',0);
INSERT INTO sy_area VALUES('230303','230301','恆山區','','230303',0);
INSERT INTO sy_area VALUES('230304','230301','滴道區','','230304',0);
INSERT INTO sy_area VALUES('230305','230301','梨樹區','','230305',0);
INSERT INTO sy_area VALUES('230306','230301','城子河區','','230306',0);
INSERT INTO sy_area VALUES('230307','230301','麻山區','','230307',0);
INSERT INTO sy_area VALUES('230321','230300','雞東縣','','230321',0);
INSERT INTO sy_area VALUES('230381','230300','虎林市','','230381',0);
INSERT INTO sy_area VALUES('230382','230300','密山市','','230382',0);
INSERT INTO sy_area VALUES('230400','230000','鶴崗市','','230400',0);
INSERT INTO sy_area VALUES('230401','230400','市轄區','','230401',0);
INSERT INTO sy_area VALUES('230402','230401','向陽區','','230402',0);
INSERT INTO sy_area VALUES('230403','230401','工農區','','230403',0);
INSERT INTO sy_area VALUES('230404','230401','南山區','','230404',0);
INSERT INTO sy_area VALUES('230405','230401','興安區','','230405',0);
INSERT INTO sy_area VALUES('230406','230401','東山區','','230406',0);
INSERT INTO sy_area VALUES('230407','230401','興山區','','230407',0);
INSERT INTO sy_area VALUES('230421','230400','蘿北縣','','230421',0);
INSERT INTO sy_area VALUES('230422','230400','綏濱縣','','230422',0);
INSERT INTO sy_area VALUES('230500','230000','雙鴨山市','','230500',0);
INSERT INTO sy_area VALUES('230501','230500','市轄區','','230501',0);
INSERT INTO sy_area VALUES('230502','230501','尖山區','','230502',0);
INSERT INTO sy_area VALUES('230503','230501','嶺東區','','230503',0);
INSERT INTO sy_area VALUES('230505','230501','四方台區','','230505',0);
INSERT INTO sy_area VALUES('230506','230501','寶山區','','230506',0);
INSERT INTO sy_area VALUES('230521','230500','集賢縣','','230521',0);
INSERT INTO sy_area VALUES('230522','230500','友誼縣','','230522',0);
INSERT INTO sy_area VALUES('230523','230500','寶清縣','','230523',0);
INSERT INTO sy_area VALUES('230524','230500','饒河縣','','230524',0);
INSERT INTO sy_area VALUES('230600','230000','大慶市','','230600',0);
INSERT INTO sy_area VALUES('230601','230600','市轄區','','230601',0);
INSERT INTO sy_area VALUES('230602','230601','薩爾圖區','','230602',0);
INSERT INTO sy_area VALUES('230603','230601','龍鳳區','','230603',0);
INSERT INTO sy_area VALUES('230604','230601','讓胡路區','','230604',0);
INSERT INTO sy_area VALUES('230605','230601','紅崗區','','230605',0);
INSERT INTO sy_area VALUES('230606','230601','大同區','','230606',0);
INSERT INTO sy_area VALUES('230621','230600','肇州縣','','230621',0);
INSERT INTO sy_area VALUES('230622','230600','肇源縣','','230622',0);
INSERT INTO sy_area VALUES('230623','230600','林甸縣','','230623',0);
INSERT INTO sy_area VALUES('230624','230600','杜爾伯特蒙古族自治縣','','230624',0);
INSERT INTO sy_area VALUES('230700','230000','伊春市','','230700',0);
INSERT INTO sy_area VALUES('230701','230700','市轄區','','230701',0);
INSERT INTO sy_area VALUES('230702','230701','伊春區','','230702',0);
INSERT INTO sy_area VALUES('230703','230701','南岔區','','230703',0);
INSERT INTO sy_area VALUES('230704','230701','友好區','','230704',0);
INSERT INTO sy_area VALUES('230705','230701','西林區','','230705',0);
INSERT INTO sy_area VALUES('230706','230701','翠巒區','','230706',0);
INSERT INTO sy_area VALUES('230707','230701','新青區','','230707',0);
INSERT INTO sy_area VALUES('230708','230701','美溪區','','230708',0);
INSERT INTO sy_area VALUES('230709','230701','金山屯區','','230709',0);
INSERT INTO sy_area VALUES('230710','230701','五營區','','230710',0);
INSERT INTO sy_area VALUES('230711','230701','烏馬河區','','230711',0);
INSERT INTO sy_area VALUES('230712','230701','湯旺河區','','230712',0);
INSERT INTO sy_area VALUES('230713','230701','帶嶺區','','230713',0);
INSERT INTO sy_area VALUES('230714','230701','烏伊嶺區','','230714',0);
INSERT INTO sy_area VALUES('230715','230701','紅星區','','230715',0);
INSERT INTO sy_area VALUES('230716','230701','上甘嶺區','','230716',0);
INSERT INTO sy_area VALUES('230722','230700','嘉蔭縣','','230722',0);
INSERT INTO sy_area VALUES('230781','230700','鐵力市','','230781',0);
INSERT INTO sy_area VALUES('230800','230000','佳木斯市','','230800',0);
INSERT INTO sy_area VALUES('230801','230800','市轄區','','230801',0);
INSERT INTO sy_area VALUES('230803','230801','向陽區','','230803',0);
INSERT INTO sy_area VALUES('230804','230801','前進區','','230804',0);
INSERT INTO sy_area VALUES('230805','230801','東風區','','230805',0);
INSERT INTO sy_area VALUES('230811','230801','郊區','','230811',0);
INSERT INTO sy_area VALUES('230822','230800','樺南縣','','230822',0);
INSERT INTO sy_area VALUES('230826','230800','樺川縣','','230826',0);
INSERT INTO sy_area VALUES('230828','230800','湯原縣','','230828',0);
INSERT INTO sy_area VALUES('230833','230800','撫遠縣','','230833',0);
INSERT INTO sy_area VALUES('230881','230800','同江市','','230881',0);
INSERT INTO sy_area VALUES('230882','230800','富錦市','','2308