全国城市 在一个表中 sqlserver 版，执行语句

CREATE TABLE [dbo].[region](
	[classid] [int] NOT NULL,
	[parentid] [int] NOT NULL DEFAULT ((0)),
	[region_name] [varchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[level] [int] NULL,
 CONSTRAINT [PK__Tab_region__52AE4273] PRIMARY KEY CLUSTERED 
(
	[classid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
go

insert into region values('1','0','中国',0)
insert into region values('110000','1','北京市',1)
insert into region values('110100','110000','北京市',2)
insert into region values('110101','110100','东城区',3)
insert into region values('110102','110100','西城区',3)
insert into region values('110103','110100','崇文区',3)
insert into region values('110104','110100','宣武区',3)
insert into region values('110105','110100','朝阳区',3)
insert into region values('110106','110100','丰台区',3)
insert into region values('110107','110100','石景山区',3)
insert into region values('110108','110100','海淀区',3)
insert into region values('110109','110100','门头沟区',3)
insert into region values('110111','110100','房山区',3)
insert into region values('110112','110100','通州区',3)
insert into region values('110113','110100','顺义区',3)
insert into region values('110114','110100','昌平区',3)
insert into region values('110115','110100','大兴区',3)
insert into region values('110116','110100','怀柔区',3)
insert into region values('110117','110100','平谷区',3)
insert into region values('110228','110100','密云县',3)
insert into region values('110229','110100','延庆县',3)
insert into region values('120000','1','天津市',1)
insert into region values('120100','120000','天津市',2)
insert into region values('120101','120100','和平区',3)
insert into region values('120102','120100','河东区',3)
insert into region values('120103','120100','河西区',3)
insert into region values('120104','120100','南开区',3)
insert into region values('120105','120100','河北区',3)
insert into region values('120106','120100','红桥区',3)
insert into region values('120107','120100','塘沽区',3)
insert into region values('120108','120100','汉沽区',3)
insert into region values('120109','120100','大港区',3)
insert into region values('120110','120100','东丽区',3)
insert into region values('120111','120100','西青区',3)
insert into region values('120112','120100','津南区',3)
insert into region values('120113','120100','北辰区',3)
insert into region values('120114','120100','武清区',3)
insert into region values('120115','120100','宝坻区',3)
insert into region values('120221','120100','宁河县',3)
insert into region values('120223','120100','静海县',3)
insert into region values('120225','120100','蓟　县',3)
insert into region values('130000','1','河北省',1)
insert into region values('130100','130000','石家庄市',2)
insert into region values('130102','130100','长安区',3)
insert into region values('130103','130100','桥东区',3)
insert into region values('130104','130100','桥西区',3)
insert into region values('130105','130100','新华区',3)
insert into region values('130107','130100','井陉矿区',3)
insert into region values('130108','130100','裕华区',3)
insert into region values('130121','130100','井陉县',3)
insert into region values('130123','130100','正定县',3)
insert into region values('130124','130100','栾城县',3)
insert into region values('130125','130100','行唐县',3)
insert into region values('130126','130100','灵寿县',3)
insert into region values('130127','130100','高邑县',3)
insert into region values('130128','130100','深泽县',3)
insert into region values('130129','130100','赞皇县',3)
insert into region values('130130','130100','无极县',3)
insert into region values('130131','130100','平山县',3)
insert into region values('130132','130100','元氏县',3)
insert into region values('130133','130100','赵　县',3)
insert into region values('130181','130100','辛集市',3)
insert into region values('130182','130100','藁城市',3)
insert into region values('130183','130100','晋州市',3)
insert into region values('130184','130100','新乐市',3)
insert into region values('130185','130100','鹿泉市',3)
insert into region values('130200','130000','唐山市',2)
insert into region values('130202','130200','路南区',3)
insert into region values('130203','130200','路北区',3)
insert into region values('130204','130200','古冶区',3)
insert into region values('130205','130200','开平区',3)
insert into region values('130207','130200','丰南区',3)
insert into region values('130208','130200','丰润区',3)
insert into region values('130223','130200','滦　县',3)
insert into region values('130224','130200','滦南县',3)
insert into region values('130225','130200','乐亭县',3)
insert into region values('130227','130200','迁西县',3)
insert into region values('130229','130200','玉田县',3)
insert into region values('130230','130200','唐海县',3)
insert into region values('130281','130200','遵化市',3)
insert into region values('130283','130200','迁安市',3)
insert into region values('130300','130000','秦皇岛市',2)
insert into region values('130302','130300','海港区',3)
insert into region values('130303','130300','山海关区',3)
insert into region values('130304','130300','北戴河区',3)
insert into region values('130321','130300','青龙满族自治县',3)
insert into region values('130322','130300','昌黎县',3)
insert into region values('130323','130300','抚宁县',3)
insert into region values('130324','130300','卢龙县',3)
insert into region values('130400','130000','邯郸市',2)
insert into region values('130402','130400','邯山区',3)
insert into region values('130403','130400','丛台区',3)
insert into region values('130404','130400','复兴区',3)
insert into region values('130406','130400','峰峰矿区',3)
insert into region values('130421','130400','邯郸县',3)
insert into region values('130423','130400','临漳县',3)
insert into region values('130424','130400','成安县',3)
insert into region values('130425','130400','大名县',3)
insert into region values('130426','130400','涉　县',3)
insert into region values('130427','130400','磁　县',3)
insert into region values('130428','130400','肥乡县',3)
insert into region values('130429','130400','永年县',3)
insert into region values('130430','130400','邱　县',3)
insert into region values('130431','130400','鸡泽县',3)
insert into region values('130432','130400','广平县',3)
insert into region values('130433','130400','馆陶县',3)
insert into region values('130434','130400','魏　县',3)
insert into region values('130435','130400','曲周县',3)
insert into region values('130481','130400','武安市',3)
insert into region values('130500','130000','邢台市',2)
insert into region values('130502','130500','桥东区',3)
insert into region values('130503','130500','桥西区',3)
insert into region values('130521','130500','邢台县',3)
insert into region values('130522','130500','临城县',3)
insert into region values('130523','130500','内丘县',3)
insert into region values('130524','130500','柏乡县',3)
insert into region values('130525','130500','隆尧县',3)
insert into region values('130526','130500','任　县',3)
insert into region values('130527','130500','南和县',3)
insert into region values('130528','130500','宁晋县',3)
insert into region values('130529','130500','巨鹿县',3)
insert into region values('130530','130500','新河县',3)
insert into region values('130531','130500','广宗县',3)
insert into region values('130532','130500','平乡县',3)
insert into region values('130533','130500','威　县',3)
insert into region values('130534','130500','清河县',3)
insert into region values('130535','130500','临西县',3)
insert into region values('130581','130500','南宫市',3)
insert into region values('130582','130500','沙河市',3)
insert into region values('130600','130000','保定市',2)
insert into region values('130602','130600','新市区',3)
insert into region values('130603','130600','北市区',3)
insert into region values('130604','130600','南市区',3)
insert into region values('130621','130600','满城县',3)
insert into region values('130622','130600','清苑县',3)
insert into region values('130623','130600','涞水县',3)
insert into region values('130624','130600','阜平县',3)
insert into region values('130625','130600','徐水县',3)
insert into region values('130626','130600','定兴县',3)
insert into region values('130627','130600','唐　县',3)
insert into region values('130628','130600','高阳县',3)
insert into region values('130629','130600','容城县',3)
insert into region values('130630','130600','涞源县',3)
insert into region values('130631','130600','望都县',3)
insert into region values('130632','130600','安新县',3)
insert into region values('130633','130600','易　县',3)
insert into region values('130634','130600','曲阳县',3)
insert into region values('130635','130600','蠡　县',3)
insert into region values('130636','130600','顺平县',3)
insert into region values('130637','130600','博野县',3)
insert into region values('130638','130600','雄　县',3)
insert into region values('130681','130600','涿州市',3)
insert into region values('130682','130600','定州市',3)
insert into region values('130683','130600','安国市',3)
insert into region values('130684','130600','高碑店市',3)
insert into region values('130700','130000','张家口市',2)
insert into region values('130702','130700','桥东区',3)
insert into region values('130703','130700','桥西区',3)
insert into region values('130705','130700','宣化区',3)
insert into region values('130706','130700','下花园区',3)
insert into region values('130721','130700','宣化县',3)
insert into region values('130722','130700','张北县',3)
insert into region values('130723','130700','康保县',3)
insert into region values('130724','130700','沽源县',3)
insert into region values('130725','130700','尚义县',3)
insert into region values('130726','130700','蔚　县',3)
insert into region values('130727','130700','阳原县',3)
insert into region values('130728','130700','怀安县',3)
insert into region values('130729','130700','万全县',3)
insert into region values('130730','130700','怀来县',3)
insert into region values('130731','130700','涿鹿县',3)
insert into region values('130732','130700','赤城县',3)
insert into region values('130733','130700','崇礼县',3)
insert into region values('130800','130000','承德市',2)
insert into region values('130802','130800','双桥区',3)
insert into region values('130803','130800','双滦区',3)
insert into region values('130804','130800','鹰手营子矿区',3)
insert into region values('130821','130800','承德县',3)
insert into region values('130822','130800','兴隆县',3)
insert into region values('130823','130800','平泉县',3)
insert into region values('130824','130800','滦平县',3)
insert into region values('130825','130800','隆化县',3)
insert into region values('130826','130800','丰宁满族自治县',3)
insert into region values('130827','130800','宽城满族自治县',3)
insert into region values('130828','130800','围场满族蒙古族自治县',3)
insert into region values('130900','130000','沧州市',2)
insert into region values('130902','130900','新华区',3)
insert into region values('130903','130900','运河区',3)
insert into region values('130921','130900','沧　县',3)
insert into region values('130922','130900','青　县',3)
insert into region values('130923','130900','东光县',3)
insert into region values('130924','130900','海兴县',3)
insert into region values('130925','130900','盐山县',3)
insert into region values('130926','130900','肃宁县',3)
insert into region values('130927','130900','南皮县',3)
insert into region values('130928','130900','吴桥县',3)
insert into region values('130929','130900','献　县',3)
insert into region values('130930','130900','孟村回族自治县',3)
insert into region values('130981','130900','泊头市',3)
insert into region values('130982','130900','任丘市',3)
insert into region values('130983','130900','黄骅市',3)
insert into region values('130984','130900','河间市',3)
insert into region values('131000','130000','廊坊市',2)
insert into region values('131002','131000','安次区',3)
insert into region values('131003','131000','广阳区',3)
insert into region values('131022','131000','固安县',3)
insert into region values('131023','131000','永清县',3)
insert into region values('131024','131000','香河县',3)
insert into region values('131025','131000','大城县',3)
insert into region values('131026','131000','文安县',3)
insert into region values('131028','131000','大厂回族自治县',3)
insert into region values('131081','131000','霸州市',3)
insert into region values('131082','131000','三河市',3)
insert into region values('131100','130000','衡水市',2)
insert into region values('131102','131100','桃城区',3)
insert into region values('131121','131100','枣强县',3)
insert into region values('131122','131100','武邑县',3)
insert into region values('131123','131100','武强县',3)
insert into region values('131124','131100','饶阳县',3)
insert into region values('131125','131100','安平县',3)
insert into region values('131126','131100','故城县',3)
insert into region values('131127','131100','景　县',3)
insert into region values('131128','131100','阜城县',3)
insert into region values('131181','131100','冀州市',3)
insert into region values('131182','131100','深州市',3)
insert into region values('140000','1','山西省',1)
insert into region values('140100','140000','太原市',2)
insert into region values('140105','140100','小店区',3)
insert into region values('140106','140100','迎泽区',3)
insert into region values('140107','140100','杏花岭区',3)
insert into region values('140108','140100','尖草坪区',3)
insert into region values('140109','140100','万柏林区',3)
insert into region values('140110','140100','晋源区',3)
insert into region values('140121','140100','清徐县',3)
insert into region values('140122','140100','阳曲县',3)
insert into region values('140123','140100','娄烦县',3)
insert into region values('140181','140100','古交市',3)
insert into region values('140200','140000','大同市',2)
insert into region values('140202','140200','城　区',3)
insert into region values('140203','140200','矿　区',3)
insert into region values('140211','140200','南郊区',3)
insert into region values('140212','140200','新荣区',3)
insert into region values('140221','140200','阳高县',3)
insert into region values('140222','140200','天镇县',3)
insert into region values('140223','140200','广灵县',3)
insert into region values('140224','140200','灵丘县',3)
insert into region values('140225','140200','浑源县',3)
insert into region values('140226','140200','左云县',3)
insert into region values('140227','140200','大同县',3)
insert into region values('140300','140000','阳泉市',2)
insert into region values('140302','140300','城　区',3)
insert into region values('140303','140300','矿　区',3)
insert into region values('140311','140300','郊　区',3)
insert into region values('140321','140300','平定县',3)
insert into region values('140322','140300','盂　县',3)
insert into region values('140400','140000','长治市',2)
insert into region values('140402','140400','城　区',3)
insert into region values('140411','140400','郊　区',3)
insert into region values('140421','140400','长治县',3)
insert into region values('140423','140400','襄垣县',3)
insert into region values('140424','140400','屯留县',3)
insert into region values('140425','140400','平顺县',3)
insert into region values('140426','140400','黎城县',3)
insert into region values('140427','140400','壶关县',3)
insert into region values('140428','140400','长子县',3)
insert into region values('140429','140400','武乡县',3)
insert into region values('140430','140400','沁　县',3)
insert into region values('140431','140400','沁源县',3)
insert into region values('140481','140400','潞城市',3)
insert into region values('140500','140000','晋城市',2)
insert into region values('140502','140500','城　区',3)
insert into region values('140521','140500','沁水县',3)
insert into region values('140522','140500','阳城县',3)
insert into region values('140524','140500','陵川县',3)
insert into region values('140525','140500','泽州县',3)
insert into region values('140581','140500','高平市',3)
insert into region values('140600','140000','朔州市',2)
insert into region values('140602','140600','朔城区',3)
insert into region values('140603','140600','平鲁区',3)
insert into region values('140621','140600','山阴县',3)
insert into region values('140622','140600','应　县',3)
insert into region values('140623','140600','右玉县',3)
insert into region values('140624','140600','怀仁县',3)
insert into region values('140700','140000','晋中市',2)
insert into region values('140702','140700','榆次区',3)
insert into region values('140721','140700','榆社县',3)
insert into region values('140722','140700','左权县',3)
insert into region values('140723','140700','和顺县',3)
insert into region values('140724','140700','昔阳县',3)
insert into region values('140725','140700','寿阳县',3)
insert into region values('140726','140700','太谷县',3)
insert into region values('140727','140700','祁　县',3)
insert into region values('140728','140700','平遥县',3)
insert into region values('140729','140700','灵石县',3)
insert into region values('140781','140700','介休市',3)
insert into region values('140800','140000','运城市',2)
insert into region values('140802','140800','盐湖区',3)
insert into region values('140821','140800','临猗县',3)
insert into region values('140822','140800','万荣县',3)
insert into region values('140823','140800','闻喜县',3)
insert into region values('140824','140800','稷山县',3)
insert into region values('140825','140800','新绛县',3)
insert into region values('140826','140800','绛　县',3)
insert into region values('140827','140800','垣曲县',3)
insert into region values('140828','140800','夏　县',3)
insert into region values('140829','140800','平陆县',3)
insert into region values('140830','140800','芮城县',3)
insert into region values('140881','140800','永济市',3)
insert into region values('140882','140800','河津市',3)
insert into region values('140900','140000','忻州市',2)
insert into region values('140902','140900','忻府区',3)
insert into region values('140921','140900','定襄县',3)
insert into region values('140922','140900','五台县',3)
insert into region values('140923','140900','代　县',3)
insert into region values('140924','140900','繁峙县',3)
insert into region values('140925','140900','宁武县',3)
insert into region values('140926','140900','静乐县',3)
insert into region values('140927','140900','神池县',3)
insert into region values('140928','140900','五寨县',3)
insert into region values('140929','140900','岢岚县',3)
insert into region values('140930','140900','河曲县',3)
insert into region values('140931','140900','保德县',3)
insert into region values('140932','140900','偏关县',3)
insert into region values('140981','140900','原平市',3)
insert into region values('141000','140000','临汾市',2)
insert into region values('141002','141000','尧都区',3)
insert into region values('141021','141000','曲沃县',3)
insert into region values('141022','141000','翼城县',3)
insert into region values('141023','141000','襄汾县',3)
insert into region values('141024','141000','洪洞县',3)
insert into region values('141025','141000','古　县',3)
insert into region values('141026','141000','安泽县',3)
insert into region values('141027','141000','浮山县',3)
insert into region values('141028','141000','吉　县',3)
insert into region values('141029','141000','乡宁县',3)
insert into region values('141030','141000','大宁县',3)
insert into region values('141031','141000','隰　县',3)
insert into region values('141032','141000','永和县',3)
insert into region values('141033','141000','蒲　县',3)
insert into region values('141034','141000','汾西县',3)
insert into region values('141081','141000','侯马市',3)
insert into region values('141082','141000','霍州市',3)
insert into region values('141100','140000','吕梁市',2)
insert into region values('141102','141100','离石区',3)
insert into region values('141121','141100','文水县',3)
insert into region values('141122','141100','交城县',3)
insert into region values('141123','141100','兴　县',3)
insert into region values('141124','141100','临　县',3)
insert into region values('141125','141100','柳林县',3)
insert into region values('141126','141100','石楼县',3)
insert into region values('141127','141100','岚　县',3)
insert into region values('141128','141100','方山县',3)
insert into region values('141129','141100','中阳县',3)
insert into region values('141130','141100','交口县',3)
insert into region values('141181','141100','孝义市',3)
insert into region values('141182','141100','汾阳市',3)
insert into region values('150000','1','内蒙古自治区',1)
insert into region values('150100','150000','呼和浩特市',2)
insert into region values('150102','150100','新城区',3)
insert into region values('150103','150100','回民区',3)
insert into region values('150104','150100','玉泉区',3)
insert into region values('150105','150100','赛罕区',3)
insert into region values('150121','150100','土默特左旗',3)
insert into region values('150122','150100','托克托县',3)
insert into region values('150123','150100','和林格尔县',3)
insert into region values('150124','150100','清水河县',3)
insert into region values('150125','150100','武川县',3)
insert into region values('150200','150000','包头市',2)
insert into region values('150202','150200','东河区',3)
insert into region values('150203','150200','昆都仑区',3)
insert into region values('150204','150200','青山区',3)
insert into region values('150205','150200','石拐区',3)
insert into region values('150206','150200','白云矿区',3)
insert into region values('150207','150200','九原区',3)
insert into region values('150221','150200','土默特右旗',3)
insert into region values('150222','150200','固阳县',3)
insert into region values('150223','150200','达尔罕茂明安联合旗',3)
insert into region values('150300','150000','乌海市',2)
insert into region values('150302','150300','海勃湾区',3)
insert into region values('150303','150300','海南区',3)
insert into region values('150304','150300','乌达区',3)
insert into region values('150400','150000','赤峰市',2)
insert into region values('150402','150400','红山区',3)
insert into region values('150403','150400','元宝山区',3)
insert into region values('150404','150400','松山区',3)
insert into region values('150421','150400','阿鲁科尔沁旗',3)
insert into region values('150422','150400','巴林左旗',3)
insert into region values('150423','150400','巴林右旗',3)
insert into region values('150424','150400','林西县',3)
insert into region values('150425','150400','克什克腾旗',3)
insert into region values('150426','150400','翁牛特旗',3)
insert into region values('150428','150400','喀喇沁旗',3)
insert into region values('150429','150400','宁城县',3)
insert into region values('150430','150400','敖汉旗',3)
insert into region values('150500','150000','通辽市',2)
insert into region values('150502','150500','科尔沁区',3)
insert into region values('150521','150500','科尔沁左翼中旗',3)
insert into region values('150522','150500','科尔沁左翼后旗',3)
insert into region values('150523','150500','开鲁县',3)
insert into region values('150524','150500','库伦旗',3)
insert into region values('150525','150500','奈曼旗',3)
insert into region values('150526','150500','扎鲁特旗',3)
insert into region values('150581','150500','霍林郭勒市',3)
insert into region values('150600','150000','鄂尔多斯市',2)
insert into region values('150602','150600','东胜区',3)
insert into region values('150621','150600','达拉特旗',3)
insert into region values('150622','150600','准格尔旗',3)
insert into region values('150623','150600','鄂托克前旗',3)
insert into region values('150624','150600','鄂托克旗',3)
insert into region values('150625','150600','杭锦旗',3)
insert into region values('150626','150600','乌审旗',3)
insert into region values('150627','150600','伊金霍洛旗',3)
insert into region values('150700','150000','呼伦贝尔市',2)
insert into region values('150702','150700','海拉尔区',3)
insert into region values('150721','150700','阿荣旗',3)
insert into region values('150722','150700','莫力达瓦达斡尔族自治旗',3)
insert into region values('150723','150700','鄂伦春自治旗',3)
insert into region values('150724','150700','鄂温克族自治旗',3)
insert into region values('150725','150700','陈巴尔虎旗',3)
insert into region values('150726','150700','新巴尔虎左旗',3)
insert into region values('150727','150700','新巴尔虎右旗',3)
insert into region values('150781','150700','满洲里市',3)
insert into region values('150782','150700','牙克石市',3)
insert into region values('150783','150700','扎兰屯市',3)
insert into region values('150784','150700','额尔古纳市',3)
insert into region values('150785','150700','根河市',3)
insert into region values('150800','150000','巴彦淖尔市',2)
insert into region values('150802','150800','临河区',3)
insert into region values('150821','150800','五原县',3)
insert into region values('150822','150800','磴口县',3)
insert into region values('150823','150800','乌拉特前旗',3)
insert into region values('150824','150800','乌拉特中旗',3)
insert into region values('150825','150800','乌拉特后旗',3)
insert into region values('150826','150800','杭锦后旗',3)
insert into region values('150900','150000','乌兰察布市',2)
insert into region values('150902','150900','集宁区',3)
insert into region values('150921','150900','卓资县',3)
insert into region values('150922','150900','化德县',3)
insert into region values('150923','150900','商都县',3)
insert into region values('150924','150900','兴和县',3)
insert into region values('150925','150900','凉城县',3)
insert into region values('150926','150900','察哈尔右翼前旗',3)
insert into region values('150927','150900','察哈尔右翼中旗',3)
insert into region values('150928','150900','察哈尔右翼后旗',3)
insert into region values('150929','150900','四子王旗',3)
insert into region values('150981','150900','丰镇市',3)
insert into region values('152200','150000','兴安盟',2)
insert into region values('152201','152200','乌兰浩特市',3)
insert into region values('152202','152200','阿尔山市',3)
insert into region values('152221','152200','科尔沁右翼前旗',3)
insert into region values('152222','152200','科尔沁右翼中旗',3)
insert into region values('152223','152200','扎赉特旗',3)
insert into region values('152224','152200','突泉县',3)
insert into region values('152500','150000','锡林郭勒盟',2)
insert into region values('152501','152500','二连浩特市',3)
insert into region values('152502','152500','锡林浩特市',3)
insert into region values('152522','152500','阿巴嘎旗',3)
insert into region values('152523','152500','苏尼特左旗',3)
insert into region values('152524','152500','苏尼特右旗',3)
insert into region values('152525','152500','东乌珠穆沁旗',3)
insert into region values('152526','152500','西乌珠穆沁旗',3)
insert into region values('152527','152500','太仆寺旗',3)
insert into region values('152528','152500','镶黄旗',3)
insert into region values('152529','152500','正镶白旗',3)
insert into region values('152530','152500','正蓝旗',3)
insert into region values('152531','152500','多伦县',3)
insert into region values('152900','150000','阿拉善盟',2)
insert into region values('152921','152900','阿拉善左旗',3)
insert into region values('152922','152900','阿拉善右旗',3)
insert into region values('152923','152900','额济纳旗',3)
insert into region values('210000','1','辽宁省',1)
insert into region values('210100','210000','沈阳市',2)
insert into region values('210102','210100','和平区',3)
insert into region values('210103','210100','沈河区',3)
insert into region values('210104','210100','大东区',3)
insert into region values('210105','210100','皇姑区',3)
insert into region values('210106','210100','铁西区',3)
insert into region values('210111','210100','苏家屯区',3)
insert into region values('210112','210100','东陵区',3)
insert into region values('210113','210100','新城子区',3)
insert into region values('210114','210100','于洪区',3)
insert into region values('210122','210100','辽中县',3)
insert into region values('210123','210100','康平县',3)
insert into region values('210124','210100','法库县',3)
insert into region values('210181','210100','新民市',3)
insert into region values('210200','210000','大连市',2)
insert into region values('210202','210200','中山区',3)
insert into region values('210203','210200','西岗区',3)
insert into region values('210204','210200','沙河口区',3)
insert into region values('210211','210200','甘井子区',3)
insert into region values('210212','210200','旅顺口区',3)
insert into region values('210213','210200','金州区',3)
insert into region values('210224','210200','长海县',3)
insert into region values('210281','210200','瓦房店市',3)
insert into region values('210282','210200','普兰店市',3)
insert into region values('210283','210200','庄河市',3)
insert into region values('210300','210000','鞍山市',2)
insert into region values('210302','210300','铁东区',3)
insert into region values('210303','210300','铁西区',3)
insert into region values('210304','210300','立山区',3)
insert into region values('210311','210300','千山区',3)
insert into region values('210321','210300','台安县',3)
insert into region values('210323','210300','岫岩满族自治县',3)
insert into region values('210381','210300','海城市',3)
insert into region values('210400','210000','抚顺市',2)
insert into region values('210402','210400','新抚区',3)
insert into region values('210403','210400','东洲区',3)
insert into region values('210404','210400','望花区',3)
insert into region values('210411','210400','顺城区',3)
insert into region values('210421','210400','抚顺县',3)
insert into region values('210422','210400','新宾满族自治县',3)
insert into region values('210423','210400','清原满族自治县',3)
insert into region values('210500','210000','本溪市',2)
insert into region values('210502','210500','平山区',3)
insert into region values('210503','210500','溪湖区',3)
insert into region values('210504','210500','明山区',3)
insert into region values('210505','210500','南芬区',3)
insert into region values('210521','210500','本溪满族自治县',3)
insert into region values('210522','210500','桓仁满族自治县',3)
insert into region values('210600','210000','丹东市',2)
insert into region values('210602','210600','元宝区',3)
insert into region values('210603','210600','振兴区',3)
insert into region values('210604','210600','振安区',3)
insert into region values('210624','210600','宽甸满族自治县',3)
insert into region values('210681','210600','东港市',3)
insert into region values('210682','210600','凤城市',3)
insert into region values('210700','210000','锦州市',2)
insert into region values('210702','210700','古塔区',3)
insert into region values('210703','210700','凌河区',3)
insert into region values('210711','210700','太和区',3)
insert into region values('210726','210700','黑山县',3)
insert into region values('210727','210700','义　县',3)
insert into region values('210781','210700','凌海市',3)
insert into region values('210782','210700','北宁市',3)
insert into region values('210800','210000','营口市',2)
insert into region values('210802','210800','站前区',3)
insert into region values('210803','210800','西市区',3)
insert into region values('210804','210800','鲅鱼圈区',3)
insert into region values('210811','210800','老边区',3)
insert into region values('210881','210800','盖州市',3)
insert into region values('210882','210800','大石桥市',3)
insert into region values('210900','210000','阜新市',2)
insert into region values('210902','210900','海州区',3)
insert into region values('210903','210900','新邱区',3)
insert into region values('210904','210900','太平区',3)
insert into region values('210905','210900','清河门区',3)
insert into region values('210911','210900','细河区',3)
insert into region values('210921','210900','阜新蒙古族自治县',3)
insert into region values('210922','210900','彰武县',3)
insert into region values('211000','210000','辽阳市',2)
insert into region values('211002','211000','白塔区',3)
insert into region values('211003','211000','文圣区',3)
insert into region values('211004','211000','宏伟区',3)
insert into region values('211005','211000','弓长岭区',3)
insert into region values('211011','211000','太子河区',3)
insert into region values('211021','211000','辽阳县',3)
insert into region values('211081','211000','灯塔市',3)
insert into region values('211100','210000','盘锦市',2)
insert into region values('211102','211100','双台子区',3)
insert into region values('211103','211100','兴隆台区',3)
insert into region values('211121','211100','大洼县',3)
insert into region values('211122','211100','盘山县',3)
insert into region values('211200','210000','铁岭市',2)
insert into region values('211202','211200','银州区',3)
insert into region values('211204','211200','清河区',3)
insert into region values('211221','211200','铁岭县',3)
insert into region values('211223','211200','西丰县',3)
insert into region values('211224','211200','昌图县',3)
insert into region values('211281','211200','调兵山市',3)
insert into region values('211282','211200','开原市',3)
insert into region values('211300','210000','朝阳市',2)
insert into region values('211302','211300','双塔区',3)
insert into region values('211303','211300','龙城区',3)
insert into region values('211321','211300','朝阳县',3)
insert into region values('211322','211300','建平县',3)
insert into region values('211324','211300','喀喇沁左翼蒙古族自治县',3)
insert into region values('211381','211300','北票市',3)
insert into region values('211382','211300','凌源市',3)
insert into region values('211400','210000','葫芦岛市',2)
insert into region values('211402','211400','连山区',3)
insert into region values('211403','211400','龙港区',3)
insert into region values('211404','211400','南票区',3)
insert into region values('211421','211400','绥中县',3)
insert into region values('211422','211400','建昌县',3)
insert into region values('211481','211400','兴城市',3)
insert into region values('220000','1','吉林省',1)
insert into region values('220100','220000','长春市',2)
insert into region values('220102','220100','南关区',3)
insert into region values('220103','220100','宽城区',3)
insert into region values('220104','220100','朝阳区',3)
insert into region values('220105','220100','二道区',3)
insert into region values('220106','220100','绿园区',3)
insert into region values('220112','220100','双阳区',3)
insert into region values('220122','220100','农安县',3)
insert into region values('220181','220100','九台市',3)
insert into region values('220182','220100','榆树市',3)
insert into region values('220183','220100','德惠市',3)
insert into region values('220200','220000','吉林市',2)
insert into region values('220202','220200','昌邑区',3)
insert into region values('220203','220200','龙潭区',3)
insert into region values('220204','220200','船营区',3)
insert into region values('220211','220200','丰满区',3)
insert into region values('220221','220200','永吉县',3)
insert into region values('220281','220200','蛟河市',3)
insert into region values('220282','220200','桦甸市',3)
insert into region values('220283','220200','舒兰市',3)
insert into region values('220284','220200','磐石市',3)
insert into region values('220300','220000','四平市',2)
insert into region values('220302','220300','铁西区',3)
insert into region values('220303','220300','铁东区',3)
insert into region values('220322','220300','梨树县',3)
insert into region values('220323','220300','伊通满族自治县',3)
insert into region values('220381','220300','公主岭市',3)
insert into region values('220382','220300','双辽市',3)
insert into region values('220400','220000','辽源市',2)
insert into region values('220402','220400','龙山区',3)
insert into region values('220403','220400','西安区',3)
insert into region values('220421','220400','东丰县',3)
insert into region values('220422','220400','东辽县',3)
insert into region values('220500','220000','通化市',2)
insert into region values('220502','220500','东昌区',3)
insert into region values('220503','220500','二道江区',3)
insert into region values('220521','220500','通化县',3)
insert into region values('220523','220500','辉南县',3)
insert into region values('220524','220500','柳河县',3)
insert into region values('220581','220500','梅河口市',3)
insert into region values('220582','220500','集安市',3)
insert into region values('220600','220000','白山市',2)
insert into region values('220602','220600','八道江区',3)
insert into region values('220621','220600','抚松县',3)
insert into region values('220622','220600','靖宇县',3)
insert into region values('220623','220600','长白朝鲜族自治县',3)
insert into region values('220625','220600','江源县',3)
insert into region values('220681','220600','临江市',3)
insert into region values('220700','220000','松原市',2)
insert into region values('220702','220700','宁江区',3)
insert into region values('220721','220700','前郭尔罗斯蒙古族自治县',3)
insert into region values('220722','220700','长岭县',3)
insert into region values('220723','220700','乾安县',3)
insert into region values('220724','220700','扶余县',3)
insert into region values('220800','220000','白城市',2)
insert into region values('220802','220800','洮北区',3)
insert into region values('220821','220800','镇赉县',3)
insert into region values('220822','220800','通榆县',3)
insert into region values('220881','220800','洮南市',3)
insert into region values('220882','220800','大安市',3)
insert into region values('222400','220000','延边朝鲜族自治州',2)
insert into region values('222401','222400','延吉市',3)
insert into region values('222402','222400','图们市',3)
insert into region values('222403','222400','敦化市',3)
insert into region values('222404','222400','珲春市',3)
insert into region values('222405','222400','龙井市',3)
insert into region values('222406','222400','和龙市',3)
insert into region values('222424','222400','汪清县',3)
insert into region values('222426','222400','安图县',3)
insert into region values('230000','1','黑龙江省',1)
insert into region values('230100','230000','哈尔滨市',2)
insert into region values('230102','230100','道里区',3)
insert into region values('230103','230100','南岗区',3)
insert into region values('230104','230100','道外区',3)
insert into region values('230106','230100','香坊区',3)
insert into region values('230107','230100','动力区',3)
insert into region values('230108','230100','平房区',3)
insert into region values('230109','230100','松北区',3)
insert into region values('230111','230100','呼兰区',3)
insert into region values('230123','230100','依兰县',3)
insert into region values('230124','230100','方正县',3)
insert into region values('230125','230100','宾　县',3)
insert into region values('230126','230100','巴彦县',3)
insert into region values('230127','230100','木兰县',3)
insert into region values('230128','230100','通河县',3)
insert into region values('230129','230100','延寿县',3)
insert into region values('230181','230100','阿城市',3)
insert into region values('230182','230100','双城市',3)
insert into region values('230183','230100','尚志市',3)
insert into region values('230184','230100','五常市',3)
insert into region values('230200','230000','齐齐哈尔市',2)
insert into region values('230202','230200','龙沙区',3)
insert into region values('230203','230200','建华区',3)
insert into region values('230204','230200','铁锋区',3)
insert into region values('230205','230200','昂昂溪区',3)
insert into region values('230206','230200','富拉尔基区',3)
insert into region values('230207','230200','碾子山区',3)
insert into region values('230208','230200','梅里斯达斡尔族区',3)
insert into region values('230221','230200','龙江县',3)
insert into region values('230223','230200','依安县',3)
insert into region values('230224','230200','泰来县',3)
insert into region values('230225','230200','甘南县',3)
insert into region values('230227','230200','富裕县',3)
insert into region values('230229','230200','克山县',3)
insert into region values('230230','230200','克东县',3)
insert into region values('230231','230200','拜泉县',3)
insert into region values('230281','230200','讷河市',3)
insert into region values('230300','230000','鸡西市',2)
insert into region values('230302','230300','鸡冠区',3)
insert into region values('230303','230300','恒山区',3)
insert into region values('230304','230300','滴道区',3)
insert into region values('230305','230300','梨树区',3)
insert into region values('230306','230300','城子河区',3)
insert into region values('230307','230300','麻山区',3)
insert into region values('230321','230300','鸡东县',3)
insert into region values('230381','230300','虎林市',3)
insert into region values('230382','230300','密山市',3)
insert into region values('230400','230000','鹤岗市',2)
insert into region values('230402','230400','向阳区',3)
insert into region values('230403','230400','工农区',3)
insert into region values('230404','230400','南山区',3)
insert into region values('230405','230400','兴安区',3)
insert into region values('230406','230400','东山区',3)
insert into region values('230407','230400','兴山区',3)
insert into region values('230421','230400','萝北县',3)
insert into region values('230422','230400','绥滨县',3)
insert into region values('230500','230000','双鸭山市',2)
insert into region values('230502','230500','尖山区',3)
insert into region values('230503','230500','岭东区',3)
insert into region values('230505','230500','四方台区',3)
insert into region values('230506','230500','宝山区',3)
insert into region values('230521','230500','集贤县',3)
insert into region values('230522','230500','友谊县',3)
insert into region values('230523','230500','宝清县',3)
insert into region values('230524','230500','饶河县',3)
insert into region values('230600','230000','大庆市',2)
insert into region values('230602','230600','萨尔图区',3)
insert into region values('230603','230600','龙凤区',3)
insert into region values('230604','230600','让胡路区',3)
insert into region values('230605','230600','红岗区',3)
insert into region values('230606','230600','大同区',3)
insert into region values('230621','230600','肇州县',3)
insert into region values('230622','230600','肇源县',3)
insert into region values('230623','230600','林甸县',3)
insert into region values('230624','230600','杜尔伯特蒙古族自治县',3)
insert into region values('230700','230000','伊春市',2)
insert into region values('230702','230700','伊春区',3)
insert into region values('230703','230700','南岔区',3)
insert into region values('230704','230700','友好区',3)
insert into region values('230705','230700','西林区',3)
insert into region values('230706','230700','翠峦区',3)
insert into region values('230707','230700','新青区',3)
insert into region values('230708','230700','美溪区',3)
insert into region values('230709','230700','金山屯区',3)
insert into region values('230710','230700','五营区',3)
insert into region values('230711','230700','乌马河区',3)
insert into region values('230712','230700','汤旺河区',3)
insert into region values('230713','230700','带岭区',3)
insert into region values('230714','230700','乌伊岭区',3)
insert into region values('230715','230700','红星区',3)
insert into region values('230716','230700','上甘岭区',3)
insert into region values('230722','230700','嘉荫县',3)
insert into region values('230781','230700','铁力市',3)
insert into region values('230800','230000','佳木斯市',2)
insert into region values('230802','230800','永红区',3)
insert into region values('230803','230800','向阳区',3)
insert into region values('230804','230800','前进区',3)
insert into region values('230805','230800','东风区',3)
insert into region values('230811','230800','郊　区',3)
insert into region values('230822','230800','桦南县',3)
insert into region values('230826','230800','桦川县',3)
insert into region values('230828','230800','汤原县',3)
insert into region values('230833','230800','抚远县',3)
insert into region values('230881','230800','同江市',3)
insert into region values('230882','230800','富锦市',3)
insert into region values('230900','230000','七台河市',2)
insert into region values('230902','230900','新兴区',3)
insert into region values('230903','230900','桃山区',3)
insert into region values('230904','230900','茄子河区',3)
insert into region values('230921','230900','勃利县',3)
insert into region values('231000','230000','牡丹江市',2)
insert into region values('231002','231000','东安区',3)
insert into region values('231003','231000','阳明区',3)
insert into region values('231004','231000','爱民区',3)
insert into region values('231005','231000','西安区',3)
insert into region values('231024','231000','东宁县',3)
insert into region values('231025','231000','林口县',3)
insert into region values('231081','231000','绥芬河市',3)
insert into region values('231083','231000','海林市',3)
insert into region values('231084','231000','宁安市',3)
insert into region values('231085','231000','穆棱市',3)
insert into region values('231100','230000','黑河市',2)
insert into region values('231102','231100','爱辉区',3)
insert into region values('231121','231100','嫩江县',3)
insert into region values('231123','231100','逊克县',3)
insert into region values('231124','231100','孙吴县',3)
insert into region values('231181','231100','北安市',3)
insert into region values('231182','231100','五大连池市',3)
insert into region values('231200','230000','绥化市',2)
insert into region values('231202','231200','北林区',3)
insert into region values('231221','231200','望奎县',3)
insert into region values('231222','231200','兰西县',3)
insert into region values('231223','231200','青冈县',3)
insert into region values('231224','231200','庆安县',3)
insert into region values('231225','231200','明水县',3)
insert into region values('231226','231200','绥棱县',3)
insert into region values('231281','231200','安达市',3)
insert into region values('231282','231200','肇东市',3)
insert into region values('231283','231200','海伦市',3)
insert into region values('232700','230000','大兴安岭地区',2)
insert into region values('232721','232700','呼玛县',3)
insert into region values('232722','232700','塔河县',3)
insert into region values('232723','232700','漠河县',3)
insert into region values('310000','1','上海市',1)
insert into region values('310100','310000','上海市',2)
insert into region values('310101','310100','黄浦区',3)
insert into region values('310103','310100','卢湾区',3)
insert into region values('310104','310100','徐汇区',3)
insert into region values('310105','310100','长宁区',3)
insert into region values('310106','310100','静安区',3)
insert into region values('310107','310100','普陀区',3)
insert into region values('310108','310100','闸北区',3)
insert into region values('310109','310100','虹口区',3)
insert into region values('310110','310100','杨浦区',3)
insert into region values('310112','310100','闵行区',3)
insert into region values('310113','310100','宝山区',3)
insert into region values('310114','310100','嘉定区',3)
insert into region values('310115','310100','浦东新区',3)
insert into region values('310116','310100','金山区',3)
insert into region values('310117','310100','松江区',3)
insert into region values('310118','310100','青浦区',3)
insert into region values('310119','310100','南汇区',3)
insert into region values('310120','310100','奉贤区',3)
insert into region values('310230','310200','崇明县',NULL)
insert into region values('320000','1','江苏省',1)
insert into region values('320100','320000','南京市',2)
insert into region values('320102','320100','玄武区',3)
insert into region values('320103','320100','白下区',3)
insert into region values('320104','320100','秦淮区',3)
insert into region values('320105','320100','建邺区',3)
insert into region values('320106','320100','鼓楼区',3)
insert into region values('320107','320100','下关区',3)
insert into region values('320111','320100','浦口区',3)
insert into region values('320113','320100','栖霞区',3)
insert into region values('320114','320100','雨花台区',3)
insert into region values('320115','320100','江宁区',3)
insert into region values('320116','320100','六合区',3)
insert into region values('320124','320100','溧水县',3)
insert into region values('320125','320100','高淳县',3)
insert into region values('320200','320000','无锡市',2)
insert into region values('320202','320200','崇安区',3)
insert into region values('320203','320200','南长区',3)
insert into region values('320204','320200','北塘区',3)
insert into region values('320205','320200','锡山区',3)
insert into region values('320206','320200','惠山区',3)
insert into region values('320211','320200','滨湖区',3)
insert into region values('320281','320200','江阴市',3)
insert into region values('320282','320200','宜兴市',3)
insert into region values('320300','320000','徐州市',2)
insert into region values('320302','320300','鼓楼区',3)
insert into region values('320303','320300','云龙区',3)
insert into region values('320304','320300','九里区',3)
insert into region values('320305','320300','贾汪区',3)
insert into region values('320311','320300','泉山区',3)
insert into region values('320321','320300','丰　县',3)
insert into region values('320322','320300','沛　县',3)
insert into region values('320323','320300','铜山县',3)
insert into region values('320324','320300','睢宁县',3)
insert into region values('320381','320300','新沂市',3)
insert into region values('320382','320300','邳州市',3)
insert into region values('320400','320000','常州市',2)
insert into region values('320402','320400','天宁区',3)
insert into region values('320404','320400','钟楼区',3)
insert into region values('320405','320400','戚墅堰区',3)
insert into region values('320411','320400','新北区',3)
insert into region values('320412','320400','武进区',3)
insert into region values('320481','320400','溧阳市',3)
insert into region values('320482','320400','金坛市',3)
insert into region values('320500','320000','苏州市',2)
insert into region values('320502','320500','沧浪区',3)
insert into region values('320503','320500','平江区',3)
insert into region values('320504','320500','金阊区',3)
insert into region values('320505','320500','虎丘区',3)
insert into region values('320506','320500','吴中区',3)
insert into region values('320507','320500','相城区',3)
insert into region values('320581','320500','常熟市',3)
insert into region values('320582','320500','张家港市',3)
insert into region values('320583','320500','昆山市',3)
insert into region values('320584','320500','吴江市',3)
insert into region values('320585','320500','太仓市',3)
insert into region values('320600','320000','南通市',2)
insert into region values('320602','320600','崇川区',3)
insert into region values('320611','320600','港闸区',3)
insert into region values('320621','320600','海安县',3)
insert into region values('320623','320600','如东县',3)
insert into region values('320681','320600','启东市',3)
insert into region values('320682','320600','如皋市',3)
insert into region values('320683','320600','通州市',3)
insert into region values('320684','320600','海门市',3)
insert into region values('320700','320000','连云港市',2)
insert into region values('320703','320700','连云区',3)
insert into region values('320705','320700','新浦区',3)
insert into region values('320706','320700','海州区',3)
insert into region values('320721','320700','赣榆县',3)
insert into region values('320722','320700','东海县',3)
insert into region values('320723','320700','灌云县',3)
insert into region values('320724','320700','灌南县',3)
insert into region values('320800','320000','淮安市',2)
insert into region values('320802','320800','清河区',3)
insert into region values('320803','320800','楚州区',3)
insert into region values('320804','320800','淮阴区',3)
insert into region values('320811','320800','清浦区',3)
insert into region values('320826','320800','涟水县',3)
insert into region values('320829','320800','洪泽县',3)
insert into region values('320830','320800','盱眙县',3)
insert into region values('320831','320800','金湖县',3)
insert into region values('320900','320000','盐城市',2)
insert into region values('320902','320900','亭湖区',3)
insert into region values('320903','320900','盐都区',3)
insert into region values('320921','320900','响水县',3)
insert into region values('320922','320900','滨海县',3)
insert into region values('320923','320900','阜宁县',3)
insert into region values('320924','320900','射阳县',3)
insert into region values('320925','320900','建湖县',3)
insert into region values('320981','320900','东台市',3)
insert into region values('320982','320900','大丰市',3)
insert into region values('321000','320000','扬州市',2)
insert into region values('321002','321000','广陵区',3)
insert into region values('321003','321000','邗江区',3)
insert into region values('321011','321000','郊　区',3)
insert into region values('321023','321000','宝应县',3)
insert into region values('321081','321000','仪征市',3)
insert into region values('321084','321000','高邮市',3)
insert into region values('321088','321000','江都市',3)
insert into region values('321100','320000','镇江市',2)
insert into region values('321102','321100','京口区',3)
insert into region values('321111','321100','润州区',3)
insert into region values('321112','321100','丹徒区',3)
insert into region values('321181','321100','丹阳市',3)
insert into region values('321182','321100','扬中市',3)
insert into region values('321183','321100','句容市',3)
insert into region values('321200','320000','泰州市',2)
insert into region values('321202','321200','海陵区',3)
insert into region values('321203','321200','高港区',3)
insert into region values('321281','321200','兴化市',3)
insert into region values('321282','321200','靖江市',3)
insert into region values('321283','321200','泰兴市',3)
insert into region values('321284','321200','姜堰市',3)
insert into region values('321300','320000','宿迁市',2)
insert into region values('321302','321300','宿城区',3)
insert into region values('321311','321300','宿豫区',3)
insert into region values('321322','321300','沭阳县',3)
insert into region values('321323','321300','泗阳县',3)
insert into region values('321324','321300','泗洪县',3)
insert into region values('330000','1','浙江省',1)
insert into region values('330100','330000','杭州市',2)
insert into region values('330102','330100','上城区',3)
insert into region values('330103','330100','下城区',3)
insert into region values('330104','330100','江干区',3)
insert into region values('330105','330100','拱墅区',3)
insert into region values('330106','330100','西湖区',3)
insert into region values('330108','330100','滨江区',3)
insert into region values('330109','330100','萧山区',3)
insert into region values('330110','330100','余杭区',3)
insert into region values('330122','330100','桐庐县',3)
insert into region values('330127','330100','淳安县',3)
insert into region values('330182','330100','建德市',3)
insert into region values('330183','330100','富阳市',3)
insert into region values('330185','330100','临安市',3)
insert into region values('330200','330000','宁波市',2)
insert into region values('330203','330200','海曙区',3)
insert into region values('330204','330200','江东区',3)
insert into region values('330205','330200','江北区',3)
insert into region values('330206','330200','北仑区',3)
insert into region values('330211','330200','镇海区',3)
insert into region values('330212','330200','鄞州区',3)
insert into region values('330225','330200','象山县',3)
insert into region values('330226','330200','宁海县',3)
insert into region values('330281','330200','余姚市',3)
insert into region values('330282','330200','慈溪市',3)
insert into region values('330283','330200','奉化市',3)
insert into region values('330300','330000','温州市',2)
insert into region values('330302','330300','鹿城区',3)
insert into region values('330303','330300','龙湾区',3)
insert into region values('330304','330300','瓯海区',3)
insert into region values('330322','330300','洞头县',3)
insert into region values('330324','330300','永嘉县',3)
insert into region values('330326','330300','平阳县',3)
insert into region values('330327','330300','苍南县',3)
insert into region values('330328','330300','文成县',3)
insert into region values('330329','330300','泰顺县',3)
insert into region values('330381','330300','瑞安市',3)
insert into region values('330382','330300','乐清市',3)
insert into region values('330400','330000','嘉兴市',2)
insert into region values('330402','330400','秀城区',3)
insert into region values('330411','330400','秀洲区',3)
insert into region values('330421','330400','嘉善县',3)
insert into region values('330424','330400','海盐县',3)
insert into region values('330481','330400','海宁市',3)
insert into region values('330482','330400','平湖市',3)
insert into region values('330483','330400','桐乡市',3)
insert into region values('330500','330000','湖州市',2)
insert into region values('330502','330500','吴兴区',3)
insert into region values('330503','330500','南浔区',3)
insert into region values('330521','330500','德清县',3)
insert into region values('330522','330500','长兴县',3)
insert into region values('330523','330500','安吉县',3)
insert into region values('330600','330000','绍兴市',2)
insert into region values('330602','330600','越城区',3)
insert into region values('330621','330600','绍兴县',3)
insert into region values('330624','330600','新昌县',3)
insert into region values('330681','330600','诸暨市',3)
insert into region values('330682','330600','上虞市',3)
insert into region values('330683','330600','嵊州市',3)
insert into region values('330700','330000','金华市',2)
insert into region values('330702','330700','婺城区',3)
insert into region values('330703','330700','金东区',3)
insert into region values('330723','330700','武义县',3)
insert into region values('330726','330700','浦江县',3)
insert into region values('330727','330700','磐安县',3)
insert into region values('330781','330700','兰溪市',3)
insert into region values('330782','330700','义乌市',3)
insert into region values('330783','330700','东阳市',3)
insert into region values('330784','330700','永康市',3)
insert into region values('330800','330000','衢州市',2)
insert into region values('330802','330800','柯城区',3)
insert into region values('330803','330800','衢江区',3)
insert into region values('330822','330800','常山县',3)
insert into region values('330824','330800','开化县',3)
insert into region values('330825','330800','龙游县',3)
insert into region values('330881','330800','江山市',3)
insert into region values('330900','330000','舟山市',2)
insert into region values('330902','330900','定海区',3)
insert into region values('330903','330900','普陀区',3)
insert into region values('330921','330900','岱山县',3)
insert into region values('330922','330900','嵊泗县',3)
insert into region values('331000','330000','台州市',2)
insert into region values('331002','331000','椒江区',3)
insert into region values('331003','331000','黄岩区',3)
insert into region values('331004','331000','路桥区',3)
insert into region values('331021','331000','玉环县',3)
insert into region values('331022','331000','三门县',3)
insert into region values('331023','331000','天台县',3)
insert into region values('331024','331000','仙居县',3)
insert into region values('331081','331000','温岭市',3)
insert into region values('331082','331000','临海市',3)
insert into region values('331100','330000','丽水市',2)
insert into region values('331102','331100','莲都区',3)
insert into region values('331121','331100','青田县',3)
insert into region values('331122','331100','缙云县',3)
insert into region values('331123','331100','遂昌县',3)
insert into region values('331124','331100','松阳县',3)
insert into region values('331125','331100','云和县',3)
insert into region values('331126','331100','庆元县',3)
insert into region values('331127','331100','景宁畲族自治县',3)
insert into region values('331181','331100','龙泉市',3)
insert into region values('340000','1','安徽省',1)
insert into region values('340100','340000','合肥市',2)
insert into region values('340102','340100','瑶海区',3)
insert into region values('340103','340100','庐阳区',3)
insert into region values('340104','340100','蜀山区',3)
insert into region values('340111','340100','包河区',3)
insert into region values('340121','340100','长丰县',3)
insert into region values('340122','340100','肥东县',3)
insert into region values('340123','340100','肥西县',3)
insert into region values('340200','340000','芜湖市',2)
insert into region values('340202','340200','镜湖区',3)
insert into region values('340203','340200','马塘区',3)
insert into region values('340204','340200','新芜区',3)
insert into region values('340207','340200','鸠江区',3)
insert into region values('340221','340200','芜湖县',3)
insert into region values('340222','340200','繁昌县',3)
insert into region values('340223','340200','南陵县',3)
insert into region values('340300','340000','蚌埠市',2)
insert into region values('340302','340300','龙子湖区',3)
insert into region values('340303','340300','蚌山区',3)
insert into region values('340304','340300','禹会区',3)
insert into region values('340311','340300','淮上区',3)
insert into region values('340321','340300','怀远县',3)
insert into region values('340322','340300','五河县',3)
insert into region values('340323','340300','固镇县',3)
insert into region values('340400','340000','淮南市',2)
insert into region values('340402','340400','大通区',3)
insert into region values('340403','340400','田家庵区',3)
insert into region values('340404','340400','谢家集区',3)
insert into region values('340405','340400','八公山区',3)
insert into region values('340406','340400','潘集区',3)
insert into region values('340421','340400','凤台县',3)
insert into region values('340500','340000','马鞍山市',2)
insert into region values('340502','340500','金家庄区',3)
insert into region values('340503','340500','花山区',3)
insert into region values('340504','340500','雨山区',3)
insert into region values('340521','340500','当涂县',3)
insert into region values('340600','340000','淮北市',2)
insert into region values('340602','340600','杜集区',3)
insert into region values('340603','340600','相山区',3)
insert into region values('340604','340600','烈山区',3)
insert into region values('340621','340600','濉溪县',3)
insert into region values('340700','340000','铜陵市',2)
insert into region values('340702','340700','铜官山区',3)
insert into region values('340703','340700','狮子山区',3)
insert into region values('340711','340700','郊　区',3)
insert into region values('340721','340700','铜陵县',3)
insert into region values('340800','340000','安庆市',2)
insert into region values('340802','340800','迎江区',3)
insert into region values('340803','340800','大观区',3)
insert into region values('340811','340800','郊　区',3)
insert into region values('340822','340800','怀宁县',3)
insert into region values('340823','340800','枞阳县',3)
insert into region values('340824','340800','潜山县',3)
insert into region values('340825','340800','太湖县',3)
insert into region values('340826','340800','宿松县',3)
insert into region values('340827','340800','望江县',3)
insert into region values('340828','340800','岳西县',3)
insert into region values('340881','340800','桐城市',3)
insert into region values('341000','340000','黄山市',2)
insert into region values('341002','341000','屯溪区',3)
insert into region values('341003','341000','黄山区',3)
insert into region values('341004','341000','徽州区',3)
insert into region values('341021','341000','歙　县',3)
insert into region values('341022','341000','休宁县',3)
insert into region values('341023','341000','黟　县',3)
insert into region values('341024','341000','祁门县',3)
insert into region values('341100','340000','滁州市',2)
insert into region values('341102','341100','琅琊区',3)
insert into region values('341103','341100','南谯区',3)
insert into region values('341122','341100','来安县',3)
insert into region values('341124','341100','全椒县',3)
insert into region values('341125','341100','定远县',3)
insert into region values('341126','341100','凤阳县',3)
insert into region values('341181','341100','天长市',3)
insert into region values('341182','341100','明光市',3)
insert into region values('341200','340000','阜阳市',2)
insert into region values('341202','341200','颍州区',3)
insert into region values('341203','341200','颍东区',3)
insert into region values('341204','341200','颍泉区',3)
insert into region values('341221','341200','临泉县',3)
insert into region values('341222','341200','太和县',3)
insert into region values('341225','341200','阜南县',3)
insert into region values('341226','341200','颍上县',3)
insert into region values('341282','341200','界首市',3)
insert into region values('341300','340000','宿州市',2)
insert into region values('341302','341300','墉桥区',3)
insert into region values('341321','341300','砀山县',3)
insert into region values('341322','341300','萧　县',3)
insert into region values('341323','341300','灵璧县',3)
insert into region values('341324','341300','泗　县',3)
insert into region values('341400','340000','巢湖市',2)
insert into region values('341402','341400','居巢区',3)
insert into region values('341421','341400','庐江县',3)
insert into region values('341422','341400','无为县',3)
insert into region values('341423','341400','含山县',3)
insert into region values('341424','341400','和　县',3)
insert into region values('341500','340000','六安市',2)
insert into region values('341502','341500','金安区',3)
insert into region values('341503','341500','裕安区',3)
insert into region values('341521','341500','寿　县',3)
insert into region values('341522','341500','霍邱县',3)
insert into region values('341523','341500','舒城县',3)
insert into region values('341524','341500','金寨县',3)
insert into region values('341525','341500','霍山县',3)
insert into region values('341600','340000','亳州市',2)
insert into region values('341602','341600','谯城区',3)
insert into region values('341621','341600','涡阳县',3)
insert into region values('341622','341600','蒙城县',3)
insert into region values('341623','341600','利辛县',3)
insert into region values('341700','340000','池州市',2)
insert into region values('341702','341700','贵池区',3)
insert into region values('341721','341700','东至县',3)
insert into region values('341722','341700','石台县',3)
insert into region values('341723','341700','青阳县',3)
insert into region values('341800','340000','宣城市',2)
insert into region values('341802','341800','宣州区',3)
insert into region values('341821','341800','郎溪县',3)
insert into region values('341822','341800','广德县',3)
insert into region values('341823','341800','泾　县',3)
insert into region values('341824','341800','绩溪县',3)
insert into region values('341825','341800','旌德县',3)
insert into region values('341881','341800','宁国市',3)
insert into region values('350000','1','福建省',1)
insert into region values('350100','350000','福州市',2)
insert into region values('350102','350100','鼓楼区',3)
insert into region values('350103','350100','台江区',3)
insert into region values('350104','350100','仓山区',3)
insert into region values('350105','350100','马尾区',3)
insert into region values('350111','350100','晋安区',3)
insert into region values('350121','350100','闽侯县',3)
insert into region values('350122','350100','连江县',3)
insert into region values('350123','350100','罗源县',3)
insert into region values('350124','350100','闽清县',3)
insert into region values('350125','350100','永泰县',3)
insert into region values('350128','350100','平潭县',3)
insert into region values('350181','350100','福清市',3)
insert into region values('350182','350100','长乐市',3)
insert into region values('350200','350000','厦门市',2)
insert into region values('350203','350200','思明区',3)
insert into region values('350205','350200','海沧区',3)
insert into region values('350206','350200','湖里区',3)
insert into region values('350211','350200','集美区',3)
insert into region values('350212','350200','同安区',3)
insert into region values('350213','350200','翔安区',3)
insert into region values('350300','350000','莆田市',2)
insert into region values('350302','350300','城厢区',3)
insert into region values('350303','350300','涵江区',3)
insert into region values('350304','350300','荔城区',3)
insert into region values('350305','350300','秀屿区',3)
insert into region values('350322','350300','仙游县',3)
insert into region values('350400','350000','三明市',2)
insert into region values('350402','350400','梅列区',3)
insert into region values('350403','350400','三元区',3)
insert into region values('350421','350400','明溪县',3)
insert into region values('350423','350400','清流县',3)
insert into region values('350424','350400','宁化县',3)
insert into region values('350425','350400','大田县',3)
insert into region values('350426','350400','尤溪县',3)
insert into region values('350427','350400','沙　县',3)
insert into region values('350428','350400','将乐县',3)
insert into region values('350429','350400','泰宁县',3)
insert into region values('350430','350400','建宁县',3)
insert into region values('350481','350400','永安市',3)
insert into region values('350500','350000','泉州市',2)
insert into region values('350502','350500','鲤城区',3)
insert into region values('350503','350500','丰泽区',3)
insert into region values('350504','350500','洛江区',3)
insert into region values('350505','350500','泉港区',3)
insert into region values('350521','350500','惠安县',3)
insert into region values('350524','350500','安溪县',3)
insert into region values('350525','350500','永春县',3)
insert into region values('350526','350500','德化县',3)
insert into region values('350527','350500','金门县',3)
insert into region values('350581','350500','石狮市',3)
insert into region values('350582','350500','晋江市',3)
insert into region values('350583','350500','南安市',3)
insert into region values('350600','350000','漳州市',2)
insert into region values('350602','350600','芗城区',3)
insert into region values('350603','350600','龙文区',3)
insert into region values('350622','350600','云霄县',3)
insert into region values('350623','350600','漳浦县',3)
insert into region values('350624','350600','诏安县',3)
insert into region values('350625','350600','长泰县',3)
insert into region values('350626','350600','东山县',3)
insert into region values('350627','350600','南靖县',3)
insert into region values('350628','350600','平和县',3)
insert into region values('350629','350600','华安县',3)
insert into region values('350681','350600','龙海市',3)
insert into region values('350700','350000','南平市',2)
insert into region values('350702','350700','延平区',3)
insert into region values('350721','350700','顺昌县',3)
insert into region values('350722','350700','浦城县',3)
insert into region values('350723','350700','光泽县',3)
insert into region values('350724','350700','松溪县',3)
insert into region values('350725','350700','政和县',3)
insert into region values('350781','350700','邵武市',3)
insert into region values('350782','350700','武夷山市',3)
insert into region values('350783','350700','建瓯市',3)
insert into region values('350784','350700','建阳市',3)
insert into region values('350800','350000','龙岩市',2)
insert into region values('350802','350800','新罗区',3)
insert into region values('350821','350800','长汀县',3)
insert into region values('350822','350800','永定县',3)
insert into region values('350823','350800','上杭县',3)
insert into region values('350824','350800','武平县',3)
insert into region values('350825','350800','连城县',3)
insert into region values('350881','350800','漳平市',3)
insert into region values('350900','350000','宁德市',2)
insert into region values('350902','350900','蕉城区',3)
insert into region values('350921','350900','霞浦县',3)
insert into region values('350922','350900','古田县',3)
insert into region values('350923','350900','屏南县',3)
insert into region values('350924','350900','寿宁县',3)
insert into region values('350925','350900','周宁县',3)
insert into region values('350926','350900','柘荣县',3)
insert into region values('350981','350900','福安市',3)
insert into region values('350982','350900','福鼎市',3)
insert into region values('360000','1','江西省',1)
insert into region values('360100','360000','南昌市',2)
insert into region values('360102','360100','东湖区',3)
insert into region values('360103','360100','西湖区',3)
insert into region values('360104','360100','青云谱区',3)
insert into region values('360105','360100','湾里区',3)
insert into region values('360111','360100','青山湖区',3)
insert into region values('360121','360100','南昌县',3)
insert into region values('360122','360100','新建县',3)
insert into region values('360123','360100','安义县',3)
insert into region values('360124','360100','进贤县',3)
insert into region values('360200','360000','景德镇市',2)
insert into region values('360202','360200','昌江区',3)
insert into region values('360203','360200','珠山区',3)
insert into region values('360222','360200','浮梁县',3)
insert into region values('360281','360200','乐平市',3)
insert into region values('360300','360000','萍乡市',2)
insert into region values('360302','360300','安源区',3)
insert into region values('360313','360300','湘东区',3)
insert into region values('360321','360300','莲花县',3)
insert into region values('360322','360300','上栗县',3)
insert into region values('360323','360300','芦溪县',3)
insert into region values('360400','360000','九江市',2)
insert into region values('360402','360400','庐山区',3)
insert into region values('360403','360400','浔阳区',3)
insert into region values('360421','360400','九江县',3)
insert into region values('360423','360400','武宁县',3)
insert into region values('360424','360400','修水县',3)
insert into region values('360425','360400','永修县',3)
insert into region values('360426','360400','德安县',3)
insert into region values('360427','360400','星子县',3)
insert into region values('360428','360400','都昌县',3)
insert into region values('360429','360400','湖口县',3)
insert into region values('360430','360400','彭泽县',3)
insert into region values('360481','360400','瑞昌市',3)
insert into region values('360500','360000','新余市',2)
insert into region values('360502','360500','渝水区',3)
insert into region values('360521','360500','分宜县',3)
insert into region values('360600','360000','鹰潭市',2)
insert into region values('360602','360600','月湖区',3)
insert into region values('360622','360600','余江县',3)
insert into region values('360681','360600','贵溪市',3)
insert into region values('360700','360000','赣州市',2)
insert into region values('360702','360700','章贡区',3)
insert into region values('360721','360700','赣　县',3)
insert into region values('360722','360700','信丰县',3)
insert into region values('360723','360700','大余县',3)
insert into region values('360724','360700','上犹县',3)
insert into region values('360725','360700','崇义县',3)
insert into region values('360726','360700','安远县',3)
insert into region values('360727','360700','龙南县',3)
insert into region values('360728','360700','定南县',3)
insert into region values('360729','360700','全南县',3)
insert into region values('360730','360700','宁都县',3)
insert into region values('360731','360700','于都县',3)
insert into region values('360732','360700','兴国县',3)
insert into region values('360733','360700','会昌县',3)
insert into region values('360734','360700','寻乌县',3)
insert into region values('360735','360700','石城县',3)
insert into region values('360781','360700','瑞金市',3)
insert into region values('360782','360700','南康市',3)
insert into region values('360800','360000','吉安市',2)
insert into region values('360802','360800','吉州区',3)
insert into region values('360803','360800','青原区',3)
insert into region values('360821','360800','吉安县',3)
insert into region values('360822','360800','吉水县',3)
insert into region values('360823','360800','峡江县',3)
insert into region values('360824','360800','新干县',3)
insert into region values('360825','360800','永丰县',3)
insert into region values('360826','360800','泰和县',3)
insert into region values('360827','360800','遂川县',3)
insert into region values('360828','360800','万安县',3)
insert into region values('360829','360800','安福县',3)
insert into region values('360830','360800','永新县',3)
insert into region values('360881','360800','井冈山市',3)
insert into region values('360900','360000','宜春市',2)
insert into region values('360902','360900','袁州区',3)
insert into region values('360921','360900','奉新县',3)
insert into region values('360922','360900','万载县',3)
insert into region values('360923','360900','上高县',3)
insert into region values('360924','360900','宜丰县',3)
insert into region values('360925','360900','靖安县',3)
insert into region values('360926','360900','铜鼓县',3)
insert into region values('360981','360900','丰城市',3)
insert into region values('360982','360900','樟树市',3)
insert into region values('360983','360900','高安市',3)
insert into region values('361000','360000','抚州市',2)
insert into region values('361002','361000','临川区',3)
insert into region values('361021','361000','南城县',3)
insert into region values('361022','361000','黎川县',3)
insert into region values('361023','361000','南丰县',3)
insert into region values('361024','361000','崇仁县',3)
insert into region values('361025','361000','乐安县',3)
insert into region values('361026','361000','宜黄县',3)
insert into region values('361027','361000','金溪县',3)
insert into region values('361028','361000','资溪县',3)
insert into region values('361029','361000','东乡县',3)
insert into region values('361030','361000','广昌县',3)
insert into region values('361100','360000','上饶市',2)
insert into region values('361102','361100','信州区',3)
insert into region values('361121','361100','上饶县',3)
insert into region values('361122','361100','广丰县',3)
insert into region values('361123','361100','玉山县',3)
insert into region values('361124','361100','铅山县',3)
insert into region values('361125','361100','横峰县',3)
insert into region values('361126','361100','弋阳县',3)
insert into region values('361127','361100','余干县',3)
insert into region values('361128','361100','鄱阳县',3)
insert into region values('361129','361100','万年县',3)
insert into region values('361130','361100','婺源县',3)
insert into region values('361181','361100','德兴市',3)
insert into region values('370000','1','山东省',1)
insert into region values('370100','370000','济南市',2)
insert into region values('370102','370100','历下区',3)
insert into region values('370103','370100','市中区',3)
insert into region values('370104','370100','槐荫区',3)
insert into region values('370105','370100','天桥区',3)
insert into region values('370112','370100','历城区',3)
insert into region values('370113','370100','长清区',3)
insert into region values('370124','370100','平阴县',3)
insert into region values('370125','370100','济阳县',3)
insert into region values('370126','370100','商河县',3)
insert into region values('370181','370100','章丘市',3)
insert into region values('370200','370000','青岛市',2)
insert into region values('370202','370200','市南区',3)
insert into region values('370203','370200','市北区',3)
insert into region values('370205','370200','四方区',3)
insert into region values('370211','370200','黄岛区',3)
insert into region values('370212','370200','崂山区',3)
insert into region values('370213','370200','李沧区',3)
insert into region values('370214','370200','城阳区',3)
insert into region values('370281','370200','胶州市',3)
insert into region values('370282','370200','即墨市',3)
insert into region values('370283','370200','平度市',3)
insert into region values('370284','370200','胶南市',3)
insert into region values('370285','370200','莱西市',3)
insert into region values('370300','370000','淄博市',2)
insert into region values('370302','370300','淄川区',3)
insert into region values('370303','370300','张店区',3)
insert into region values('370304','370300','博山区',3)
insert into region values('370305','370300','临淄区',3)
insert into region values('370306','370300','周村区',3)
insert into region values('370321','370300','桓台县',3)
insert into region values('370322','370300','高青县',3)
insert into region values('370323','370300','沂源县',3)
insert into region values('370400','370000','枣庄市',2)
insert into region values('370402','370400','市中区',3)
insert into region values('370403','370400','薛城区',3)
insert into region values('370404','370400','峄城区',3)
insert into region values('370405','370400','台儿庄区',3)
insert into region values('370406','370400','山亭区',3)
insert into region values('370481','370400','滕州市',3)
insert into region values('370500','370000','东营市',2)
insert into region values('370502','370500','东营区',3)
insert into region values('370503','370500','河口区',3)
insert into region values('370521','370500','垦利县',3)
insert into region values('370522','370500','利津县',3)
insert into region values('370523','370500','广饶县',3)
insert into region values('370600','370000','烟台市',2)
insert into region values('370602','370600','芝罘区',3)
insert into region values('370611','370600','福山区',3)
insert into region values('370612','370600','牟平区',3)
insert into region values('370613','370600','莱山区',3)
insert into region values('370634','370600','长岛县',3)
insert into region values('370681','370600','龙口市',3)
insert into region values('370682','370600','莱阳市',3)
insert into region values('370683','370600','莱州市',3)
insert into region values('370684','370600','蓬莱市',3)
insert into region values('370685','370600','招远市',3)
insert into region values('370686','370600','栖霞市',3)
insert into region values('370687','370600','海阳市',3)
insert into region values('370700','370000','潍坊市',2)
insert into region values('370702','370700','潍城区',3)
insert into region values('370703','370700','寒亭区',3)
insert into region values('370704','370700','坊子区',3)
insert into region values('370705','370700','奎文区',3)
insert into region values('370724','370700','临朐县',3)
insert into region values('370725','370700','昌乐县',3)
insert into region values('370781','370700','青州市',3)
insert into region values('370782','370700','诸城市',3)
insert into region values('370783','370700','寿光市',3)
insert into region values('370784','370700','安丘市',3)
insert into region values('370785','370700','高密市',3)
insert into region values('370786','370700','昌邑市',3)
insert into region values('370800','370000','济宁市',2)
insert into region values('370802','370800','市中区',3)
insert into region values('370811','370800','任城区',3)
insert into region values('370826','370800','微山县',3)
insert into region values('370827','370800','鱼台县',3)
insert into region values('370828','370800','金乡县',3)
insert into region values('370829','370800','嘉祥县',3)
insert into region values('370830','370800','汶上县',3)
insert into region values('370831','370800','泗水县',3)
insert into region values('370832','370800','梁山县',3)
insert into region values('370881','370800','曲阜市',3)
insert into region values('370882','370800','兖州市',3)
insert into region values('370883','370800','邹城市',3)
insert into region values('370900','370000','泰安市',2)
insert into region values('370902','370900','泰山区',3)
insert into region values('370903','370900','岱岳区',3)
insert into region values('370921','370900','宁阳县',3)
insert into region values('370923','370900','东平县',3)
insert into region values('370982','370900','新泰市',3)
insert into region values('370983','370900','肥城市',3)
insert into region values('371000','370000','威海市',2)
insert into region values('371002','371000','环翠区',3)
insert into region values('371081','371000','文登市',3)
insert into region values('371082','371000','荣成市',3)
insert into region values('371083','371000','乳山市',3)
insert into region values('371100','370000','日照市',2)
insert into region values('371102','371100','东港区',3)
insert into region values('371103','371100','岚山区',3)
insert into region values('371121','371100','五莲县',3)
insert into region values('371122','371100','莒　县',3)
insert into region values('371200','370000','莱芜市',2)
insert into region values('371202','371200','莱城区',3)
insert into region values('371203','371200','钢城区',3)
insert into region values('371300','370000','临沂市',2)
insert into region values('371302','371300','兰山区',3)
insert into region values('371311','371300','罗庄区',3)
insert into region values('371312','371300','河东区',3)
insert into region values('371321','371300','沂南县',3)
insert into region values('371322','371300','郯城县',3)
insert into region values('371323','371300','沂水县',3)
insert into region values('371324','371300','苍山县',3)
insert into region values('371325','371300','费　县',3)
insert into region values('371326','371300','平邑县',3)
insert into region values('371327','371300','莒南县',3)
insert into region values('371328','371300','蒙阴县',3)
insert into region values('371329','371300','临沭县',3)
insert into region values('371400','370000','德州市',2)
insert into region values('371402','371400','德城区',3)
insert into region values('371421','371400','陵　县',3)
insert into region values('371422','371400','宁津县',3)
insert into region values('371423','371400','庆云县',3)
insert into region values('371424','371400','临邑县',3)
insert into region values('371425','371400','齐河县',3)
insert into region values('371426','371400','平原县',3)
insert into region values('371427','371400','夏津县',3)
insert into region values('371428','371400','武城县',3)
insert into region values('371481','371400','乐陵市',3)
insert into region values('371482','371400','禹城市',3)
insert into region values('371500','370000','聊城市',2)
insert into region values('371502','371500','东昌府区',3)
insert into region values('371521','371500','阳谷县',3)
insert into region values('371522','371500','莘　县',3)
insert into region values('371523','371500','茌平县',3)
insert into region values('371524','371500','东阿县',3)
insert into region values('371525','371500','冠　县',3)
insert into region values('371526','371500','高唐县',3)
insert into region values('371581','371500','临清市',3)
insert into region values('371600','370000','滨州市',2)
insert into region values('371602','371600','滨城区',3)
insert into region values('371621','371600','惠民县',3)
insert into region values('371622','371600','阳信县',3)
insert into region values('371623','371600','无棣县',3)
insert into region values('371624','371600','沾化县',3)
insert into region values('371625','371600','博兴县',3)
insert into region values('371626','371600','邹平县',3)
insert into region values('371700','370000','荷泽市',2)
insert into region values('371702','371700','牡丹区',3)
insert into region values('371721','371700','曹　县',3)
insert into region values('371722','371700','单　县',3)
insert into region values('371723','371700','成武县',3)
insert into region values('371724','371700','巨野县',3)
insert into region values('371725','371700','郓城县',3)
insert into region values('371726','371700','鄄城县',3)
insert into region values('371727','371700','定陶县',3)
insert into region values('371728','371700','东明县',3)
insert into region values('410000','1','河南省',1)
insert into region values('410100','410000','郑州市',2)
insert into region values('410102','410100','中原区',3)
insert into region values('410103','410100','二七区',3)
insert into region values('410104','410100','管城回族区',3)
insert into region values('410105','410100','金水区',3)
insert into region values('410106','410100','上街区',3)
insert into region values('410108','410100','邙山区',3)
insert into region values('410122','410100','中牟县',3)
insert into region values('410181','410100','巩义市',3)
insert into region values('410182','410100','荥阳市',3)
insert into region values('410183','410100','新密市',3)
insert into region values('410184','410100','新郑市',3)
insert into region values('410185','410100','登封市',3)
insert into region values('410200','410000','开封市',2)
insert into region values('410202','410200','龙亭区',3)
insert into region values('410203','410200','顺河回族区',3)
insert into region values('410204','410200','鼓楼区',3)
insert into region values('410205','410200','南关区',3)
insert into region values('410211','410200','郊　区',3)
insert into region values('410221','410200','杞　县',3)
insert into region values('410222','410200','通许县',3)
insert into region values('410223','410200','尉氏县',3)
insert into region values('410224','410200','开封县',3)
insert into region values('410225','410200','兰考县',3)
insert into region values('410300','410000','洛阳市',2)
insert into region values('410302','410300','老城区',3)
insert into region values('410303','410300','西工区',3)
insert into region values('410304','410300','廛河回族区',3)
insert into region values('410305','410300','涧西区',3)
insert into region values('410306','410300','吉利区',3)
insert into region values('410307','410300','洛龙区',3)
insert into region values('410322','410300','孟津县',3)
insert into region values('410323','410300','新安县',3)
insert into region values('410324','410300','栾川县',3)
insert into region values('410325','410300','嵩　县',3)
insert into region values('410326','410300','汝阳县',3)
insert into region values('410327','410300','宜阳县',3)
insert into region values('410328','410300','洛宁县',3)
insert into region values('410329','410300','伊川县',3)
insert into region values('410381','410300','偃师市',3)
insert into region values('410400','410000','平顶山市',2)
insert into region values('410402','410400','新华区',3)
insert into region values('410403','410400','卫东区',3)
insert into region values('410404','410400','石龙区',3)
insert into region values('410411','410400','湛河区',3)
insert into region values('410421','410400','宝丰县',3)
insert into region values('410422','410400','叶　县',3)
insert into region values('410423','410400','鲁山县',3)
insert into region values('410425','410400','郏　县',3)
insert into region values('410481','410400','舞钢市',3)
insert into region values('410482','410400','汝州市',3)
insert into region values('410500','410000','安阳市',2)
insert into region values('410502','410500','文峰区',3)
insert into region values('410503','410500','北关区',3)
insert into region values('410505','410500','殷都区',3)
insert into region values('410506','410500','龙安区',3)
insert into region values('410522','410500','安阳县',3)
insert into region values('410523','410500','汤阴县',3)
insert into region values('410526','410500','滑　县',3)
insert into region values('410527','410500','内黄县',3)
insert into region values('410581','410500','林州市',3)
insert into region values('410600','410000','鹤壁市',2)
insert into region values('410602','410600','鹤山区',3)
insert into region values('410603','410600','山城区',3)
insert into region values('410611','410600','淇滨区',3)
insert into region values('410621','410600','浚　县',3)
insert into region values('410622','410600','淇　县',3)
insert into region values('410700','410000','新乡市',2)
insert into region values('410702','410700','红旗区',3)
insert into region values('410703','410700','卫滨区',3)
insert into region values('410704','410700','凤泉区',3)
insert into region values('410711','410700','牧野区',3)
insert into region values('410721','410700','新乡县',3)
insert into region values('410724','410700','获嘉县',3)
insert into region values('410725','410700','原阳县',3)
insert into region values('410726','410700','延津县',3)
insert into region values('410727','410700','封丘县',3)
insert into region values('410728','410700','长垣县',3)
insert into region values('410781','410700','卫辉市',3)
insert into region values('410782','410700','辉县市',3)
insert into region values('410800','410000','焦作市',2)
insert into region values('410802','410800','解放区',3)
insert into region values('410803','410800','中站区',3)
insert into region values('410804','410800','马村区',3)
insert into region values('410811','410800','山阳区',3)
insert into region values('410821','410800','修武县',3)
insert into region values('410822','410800','博爱县',3)
insert into region values('410823','410800','武陟县',3)
insert into region values('410825','410800','温　县',3)
insert into region values('410881','410800','济源市',3)
insert into region values('410882','410800','沁阳市',3)
insert into region values('410883','410800','孟州市',3)
insert into region values('410900','410000','濮阳市',2)
insert into region values('410902','410900','华龙区',3)
insert into region values('410922','410900','清丰县',3)
insert into region values('410923','410900','南乐县',3)
insert into region values('410926','410900','范　县',3)
insert into region values('410927','410900','台前县',3)
insert into region values('410928','410900','濮阳县',3)
insert into region values('411000','410000','许昌市',2)
insert into region values('411002','411000','魏都区',3)
insert into region values('411023','411000','许昌县',3)
insert into region values('411024','411000','鄢陵县',3)
insert into region values('411025','411000','襄城县',3)
insert into region values('411081','411000','禹州市',3)
insert into region values('411082','411000','长葛市',3)
insert into region values('411100','410000','漯河市',2)
insert into region values('411102','411100','源汇区',3)
insert into region values('411103','411100','郾城区',3)
insert into region values('411104','411100','召陵区',3)
insert into region values('411121','411100','舞阳县',3)
insert into region values('411122','411100','临颍县',3)
insert into region values('411200','410000','三门峡市',2)
insert into region values('411202','411200','湖滨区',3)
insert into region values('411221','411200','渑池县',3)
insert into region values('411222','411200','陕　县',3)
insert into region values('411224','411200','卢氏县',3)
insert into region values('411281','411200','义马市',3)
insert into region values('411282','411200','灵宝市',3)
insert into region values('411300','410000','南阳市',2)
insert into region values('411302','411300','宛城区',3)
insert into region values('411303','411300','卧龙区',3)
insert into region values('411321','411300','南召县',3)
insert into region values('411322','411300','方城县',3)
insert into region values('411323','411300','西峡县',3)
insert into region values('411324','411300','镇平县',3)
insert into region values('411325','411300','内乡县',3)
insert into region values('411326','411300','淅川县',3)
insert into region values('411327','411300','社旗县',3)
insert into region values('411328','411300','唐河县',3)
insert into region values('411329','411300','新野县',3)
insert into region values('411330','411300','桐柏县',3)
insert into region values('411381','411300','邓州市',3)
insert into region values('411400','410000','商丘市',2)
insert into region values('411402','411400','梁园区',3)
insert into region values('411403','411400','睢阳区',3)
insert into region values('411421','411400','民权县',3)
insert into region values('411422','411400','睢　县',3)
insert into region values('411423','411400','宁陵县',3)
insert into region values('411424','411400','柘城县',3)
insert into region values('411425','411400','虞城县',3)
insert into region values('411426','411400','夏邑县',3)
insert into region values('411481','411400','永城市',3)
insert into region values('411500','410000','信阳市',2)
insert into region values('411502','411500','师河区',3)
insert into region values('411503','411500','平桥区',3)
insert into region values('411521','411500','罗山县',3)
insert into region values('411522','411500','光山县',3)
insert into region values('411523','411500','新　县',3)
insert into region values('411524','411500','商城县',3)
insert into region values('411525','411500','固始县',3)
insert into region values('411526','411500','潢川县',3)
insert into region values('411527','411500','淮滨县',3)
insert into region values('411528','411500','息　县',3)
insert into region values('411600','410000','周口市',2)
insert into region values('411602','411600','川汇区',3)
insert into region values('411621','411600','扶沟县',3)
insert into region values('411622','411600','西华县',3)
insert into region values('411623','411600','商水县',3)
insert into region values('411624','411600','沈丘县',3)
insert into region values('411625','411600','郸城县',3)
insert into region values('411626','411600','淮阳县',3)
insert into region values('411627','411600','太康县',3)
insert into region values('411628','411600','鹿邑县',3)
insert into region values('411681','411600','项城市',3)
insert into region values('411700','410000','驻马店市',2)
insert into region values('411702','411700','驿城区',3)
insert into region values('411721','411700','西平县',3)
insert into region values('411722','411700','上蔡县',3)
insert into region values('411723','411700','平舆县',3)
insert into region values('411724','411700','正阳县',3)
insert into region values('411725','411700','确山县',3)
insert into region values('411726','411700','泌阳县',3)
insert into region values('411727','411700','汝南县',3)
insert into region values('411728','411700','遂平县',3)
insert into region values('411729','411700','新蔡县',3)
insert into region values('420000','1','湖北省',1)
insert into region values('420100','420000','武汉市',2)
insert into region values('420102','420100','江岸区',3)
insert into region values('420103','420100','江汉区',3)
insert into region values('420104','420100','乔口区',3)
insert into region values('420105','420100','汉阳区',3)
insert into region values('420106','420100','武昌区',3)
insert into region values('420107','420100','青山区',3)
insert into region values('420111','420100','洪山区',3)
insert into region values('420112','420100','东西湖区',3)
insert into region values('420113','420100','汉南区',3)
insert into region values('420114','420100','蔡甸区',3)
insert into region values('420115','420100','江夏区',3)
insert into region values('420116','420100','黄陂区',3)
insert into region values('420117','420100','新洲区',3)
insert into region values('420200','420000','黄石市',2)
insert into region values('420202','420200','黄石港区',3)
insert into region values('420203','420200','西塞山区',3)
insert into region values('420204','420200','下陆区',3)
insert into region values('420205','420200','铁山区',3)
insert into region values('420222','420200','阳新县',3)
insert into region values('420281','420200','大冶市',3)
insert into region values('420300','420000','十堰市',2)
insert into region values('420302','420300','茅箭区',3)
insert into region values('420303','420300','张湾区',3)
insert into region values('420321','420300','郧　县',3)
insert into region values('420322','420300','郧西县',3)
insert into region values('420323','420300','竹山县',3)
insert into region values('420324','420300','竹溪县',3)
insert into region values('420325','420300','房　县',3)
insert into region values('420381','420300','丹江口市',3)
insert into region values('420500','420000','宜昌市',2)
insert into region values('420502','420500','西陵区',3)
insert into region values('420503','420500','伍家岗区',3)
insert into region values('420504','420500','点军区',3)
insert into region values('420505','420500','猇亭区',3)
insert into region values('420506','420500','夷陵区',3)
insert into region values('420525','420500','远安县',3)
insert into region values('420526','420500','兴山县',3)
insert into region values('420527','420500','秭归县',3)
insert into region values('420528','420500','长阳土家族自治县',3)
insert into region values('420529','420500','五峰土家族自治县',3)
insert into region values('420581','420500','宜都市',3)
insert into region values('420582','420500','当阳市',3)
insert into region values('420583','420500','枝江市',3)
insert into region values('420600','420000','襄樊市',2)
insert into region values('420602','420600','襄城区',3)
insert into region values('420606','420600','樊城区',3)
insert into region values('420607','420600','襄阳区',3)
insert into region values('420624','420600','南漳县',3)
insert into region values('420625','420600','谷城县',3)
insert into region values('420626','420600','保康县',3)
insert into region values('420682','420600','老河口市',3)
insert into region values('420683','420600','枣阳市',3)
insert into region values('420684','420600','宜城市',3)
insert into region values('420700','420000','鄂州市',2)
insert into region values('420702','420700','梁子湖区',3)
insert into region values('420703','420700','华容区',3)
insert into region values('420704','420700','鄂城区',3)
insert into region values('420800','420000','荆门市',2)
insert into region values('420802','420800','东宝区',3)
insert into region values('420804','420800','掇刀区',3)
insert into region values('420821','420800','京山县',3)
insert into region values('420822','420800','沙洋县',3)
insert into region values('420881','420800','钟祥市',3)
insert into region values('420900','420000','孝感市',2)
insert into region values('420902','420900','孝南区',3)
insert into region values('420921','420900','孝昌县',3)
insert into region values('420922','420900','大悟县',3)
insert into region values('420923','420900','云梦县',3)
insert into region values('420981','420900','应城市',3)
insert into region values('420982','420900','安陆市',3)
insert into region values('420984','420900','汉川市',3)
insert into region values('421000','420000','荆州市',2)
insert into region values('421002','421000','沙市区',3)
insert into region values('421003','421000','荆州区',3)
insert into region values('421022','421000','公安县',3)
insert into region values('421023','421000','监利县',3)
insert into region values('421024','421000','江陵县',3)
insert into region values('421081','421000','石首市',3)
insert into region values('421083','421000','洪湖市',3)
insert into region values('421087','421000','松滋市',3)
insert into region values('421100','420000','黄冈市',2)
insert into region values('421102','421100','黄州区',3)
insert into region values('421121','421100','团风县',3)
insert into region values('421122','421100','红安县',3)
insert into region values('421123','421100','罗田县',3)
insert into region values('421124','421100','英山县',3)
insert into region values('421125','421100','浠水县',3)
insert into region values('421126','421100','蕲春县',3)
insert into region values('421127','421100','黄梅县',3)
insert into region values('421181','421100','麻城市',3)
insert into region values('421182','421100','武穴市',3)
insert into region values('421200','420000','咸宁市',2)
insert into region values('421202','421200','咸安区',3)
insert into region values('421221','421200','嘉鱼县',3)
insert into region values('421222','421200','通城县',3)
insert into region values('421223','421200','崇阳县',3)
insert into region values('421224','421200','通山县',3)
insert into region values('421281','421200','赤壁市',3)
insert into region values('421300','420000','随州市',2)
insert into region values('421302','421300','曾都区',3)
insert into region values('421381','421300','广水市',3)
insert into region values('422800','420000','恩施土家族苗族自治州',2)
insert into region values('422801','422800','恩施市',3)
insert into region values('422802','422800','利川市',3)
insert into region values('422822','422800','建始县',3)
insert into region values('422823','422800','巴东县',3)
insert into region values('422825','422800','宣恩县',3)
insert into region values('422826','422800','咸丰县',3)
insert into region values('422827','422800','来凤县',3)
insert into region values('422828','422800','鹤峰县',3)
insert into region values('429000','420000','省直辖行政单位',2)
insert into region values('429004','429000','仙桃市',3)
insert into region values('429005','429000','潜江市',3)
insert into region values('429006','429000','天门市',3)
insert into region values('429021','429000','神农架林区',3)
insert into region values('430000','1','湖南省',1)
insert into region values('430100','430000','长沙市',2)
insert into region values('430102','430100','芙蓉区',3)
insert into region values('430103','430100','天心区',3)
insert into region values('430104','430100','岳麓区',3)
insert into region values('430105','430100','开福区',3)
insert into region values('430111','430100','雨花区',3)
insert into region values('430121','430100','长沙县',3)
insert into region values('430122','430100','望城县',3)
insert into region values('430124','430100','宁乡县',3)
insert into region values('430181','430100','浏阳市',3)
insert into region values('430200','430000','株洲市',2)
insert into region values('430202','430200','荷塘区',3)
insert into region values('430203','430200','芦淞区',3)
insert into region values('430204','430200','石峰区',3)
insert into region values('430211','430200','天元区',3)
insert into region values('430221','430200','株洲县',3)
insert into region values('430223','430200','攸　县',3)
insert into region values('430224','430200','茶陵县',3)
insert into region values('430225','430200','炎陵县',3)
insert into region values('430281','430200','醴陵市',3)
insert into region values('430300','430000','湘潭市',2)
insert into region values('430302','430300','雨湖区',3)
insert into region values('430304','430300','岳塘区',3)
insert into region values('430321','430300','湘潭县',3)
insert into region values('430381','430300','湘乡市',3)
insert into region values('430382','430300','韶山市',3)
insert into region values('430400','430000','衡阳市',2)
insert into region values('430405','430400','珠晖区',3)
insert into region values('430406','430400','雁峰区',3)
insert into region values('430407','430400','石鼓区',3)
insert into region values('430408','430400','蒸湘区',3)
insert into region values('430412','430400','南岳区',3)
insert into region values('430421','430400','衡阳县',3)
insert into region values('430422','430400','衡南县',3)
insert into region values('430423','430400','衡山县',3)
insert into region values('430424','430400','衡东县',3)
insert into region values('430426','430400','祁东县',3)
insert into region values('430481','430400','耒阳市',3)
insert into region values('430482','430400','常宁市',3)
insert into region values('430500','430000','邵阳市',2)
insert into region values('430502','430500','双清区',3)
insert into region values('430503','430500','大祥区',3)
insert into region values('430511','430500','北塔区',3)
insert into region values('430521','430500','邵东县',3)
insert into region values('430522','430500','新邵县',3)
insert into region values('430523','430500','邵阳县',3)
insert into region values('430524','430500','隆回县',3)
insert into region values('430525','430500','洞口县',3)
insert into region values('430527','430500','绥宁县',3)
insert into region values('430528','430500','新宁县',3)
insert into region values('430529','430500','城步苗族自治县',3)
insert into region values('430581','430500','武冈市',3)
insert into region values('430600','430000','岳阳市',2)
insert into region values('430602','430600','岳阳楼区',3)
insert into region values('430603','430600','云溪区',3)
insert into region values('430611','430600','君山区',3)
insert into region values('430621','430600','岳阳县',3)
insert into region values('430623','430600','华容县',3)
insert into region values('430624','430600','湘阴县',3)
insert into region values('430626','430600','平江县',3)
insert into region values('430681','430600','汨罗市',3)
insert into region values('430682','430600','临湘市',3)
insert into region values('430700','430000','常德市',2)
insert into region values('430702','430700','武陵区',3)
insert into region values('430703','430700','鼎城区',3)
insert into region values('430721','430700','安乡县',3)
insert into region values('430722','430700','汉寿县',3)
insert into region values('430723','430700','澧　县',3)
insert into region values('430724','430700','临澧县',3)
insert into region values('430725','430700','桃源县',3)
insert into region values('430726','430700','石门县',3)
insert into region values('430781','430700','津市市',3)
insert into region values('430800','430000','张家界市',2)
insert into region values('430802','430800','永定区',3)
insert into region values('430811','430800','武陵源区',3)
insert into region values('430821','430800','慈利县',3)
insert into region values('430822','430800','桑植县',3)
insert into region values('430900','430000','益阳市',2)
insert into region values('430902','430900','资阳区',3)
insert into region values('430903','430900','赫山区',3)
insert into region values('430921','430900','南　县',3)
insert into region values('430922','430900','桃江县',3)
insert into region values('430923','430900','安化县',3)
insert into region values('430981','430900','沅江市',3)
insert into region values('431000','430000','郴州市',2)
insert into region values('431002','431000','北湖区',3)
insert into region values('431003','431000','苏仙区',3)
insert into region values('431021','431000','桂阳县',3)
insert into region values('431022','431000','宜章县',3)
insert into region values('431023','431000','永兴县',3)
insert into region values('431024','431000','嘉禾县',3)
insert into region values('431025','431000','临武县',3)
insert into region values('431026','431000','汝城县',3)
insert into region values('431027','431000','桂东县',3)
insert into region values('431028','431000','安仁县',3)
insert into region values('431081','431000','资兴市',3)
insert into region values('431100','430000','永州市',2)
insert into region values('431102','431100','芝山区',3)
insert into region values('431103','431100','冷水滩区',3)
insert into region values('431121','431100','祁阳县',3)
insert into region values('431122','431100','东安县',3)
insert into region values('431123','431100','双牌县',3)
insert into region values('431124','431100','道　县',3)
insert into region values('431125','431100','江永县',3)
insert into region values('431126','431100','宁远县',3)
insert into region values('431127','431100','蓝山县',3)
insert into region values('431128','431100','新田县',3)
insert into region values('431129','431100','江华瑶族自治县',3)
insert into region values('431200','430000','怀化市',2)
insert into region values('431202','431200','鹤城区',3)
insert into region values('431221','431200','中方县',3)
insert into region values('431222','431200','沅陵县',3)
insert into region values('431223','431200','辰溪县',3)
insert into region values('431224','431200','溆浦县',3)
insert into region values('431225','431200','会同县',3)
insert into region values('431226','431200','麻阳苗族自治县',3)
insert into region values('431227','431200','新晃侗族自治县',3)
insert into region values('431228','431200','芷江侗族自治县',3)
insert into region values('431229','431200','靖州苗族侗族自治县',3)
insert into region values('431230','431200','通道侗族自治县',3)
insert into region values('431281','431200','洪江市',3)
insert into region values('431300','430000','娄底市',2)
insert into region values('431302','431300','娄星区',3)
insert into region values('431321','431300','双峰县',3)
insert into region values('431322','431300','新化县',3)
insert into region values('431381','431300','冷水江市',3)
insert into region values('431382','431300','涟源市',3)
insert into region values('433100','430000','湘西土家族苗族自治州',2)
insert into region values('433101','433100','吉首市',3)
insert into region values('433122','433100','泸溪县',3)
insert into region values('433123','433100','凤凰县',3)
insert into region values('433124','433100','花垣县',3)
insert into region values('433125','433100','保靖县',3)
insert into region values('433126','433100','古丈县',3)
insert into region values('433127','433100','永顺县',3)
insert into region values('433130','433100','龙山县',3)
insert into region values('440000','1','广东省',1)
insert into region values('440100','440000','广州市',2)
insert into region values('440102','440100','东山区',3)
insert into region values('440103','440100','荔湾区',3)
insert into region values('440104','440100','越秀区',3)
insert into region values('440105','440100','海珠区',3)
insert into region values('440106','440100','天河区',3)
insert into region values('440107','440100','芳村区',3)
insert into region values('440111','440100','白云区',3)
insert into region values('440112','440100','黄埔区',3)
insert into region values('440113','440100','番禺区',3)
insert into region values('440114','440100','花都区',3)
insert into region values('440183','440100','增城市',3)
insert into region values('440184','440100','从化市',3)
insert into region values('440200','440000','韶关市',2)
insert into region values('440203','440200','武江区',3)
insert into region values('440204','440200','浈江区',3)
insert into region values('440205','440200','曲江区',3)
insert into region values('440222','440200','始兴县',3)
insert into region values('440224','440200','仁化县',3)
insert into region values('440229','440200','翁源县',3)
insert into region values('440232','440200','乳源瑶族自治县',3)
insert into region values('440233','440200','新丰县',3)
insert into region values('440281','440200','乐昌市',3)
insert into region values('440282','440200','南雄市',3)
insert into region values('440300','440000','深圳市',2)
insert into region values('440303','440300','罗湖区',3)
insert into region values('440304','440300','福田区',3)
insert into region values('440305','440300','南山区',3)
insert into region values('440306','440300','宝安区',3)
insert into region values('440307','440300','龙岗区',3)
insert into region values('440308','440300','盐田区',3)
insert into region values('440400','440000','珠海市',2)
insert into region values('440402','440400','香洲区',3)
insert into region values('440403','440400','斗门区',3)
insert into region values('440404','440400','金湾区',3)
insert into region values('440500','440000','汕头市',2)
insert into region values('440507','440500','龙湖区',3)
insert into region values('440511','440500','金平区',3)
insert into region values('440512','440500','濠江区',3)
insert into region values('440513','440500','潮阳区',3)
insert into region values('440514','440500','潮南区',3)
insert into region values('440515','440500','澄海区',3)
insert into region values('440523','440500','南澳县',3)
insert into region values('440600','440000','佛山市',2)
insert into region values('440604','440600','禅城区',3)
insert into region values('440605','440600','南海区',3)
insert into region values('440606','440600','顺德区',3)
insert into region values('440607','440600','三水区',3)
insert into region values('440608','440600','高明区',3)
insert into region values('440700','440000','江门市',2)
insert into region values('440703','440700','蓬江区',3)
insert into region values('440704','440700','江海区',3)
insert into region values('440705','440700','新会区',3)
insert into region values('440781','440700','台山市',3)
insert into region values('440783','440700','开平市',3)
insert into region values('440784','440700','鹤山市',3)
insert into region values('440785','440700','恩平市',3)
insert into region values('440800','440000','湛江市',2)
insert into region values('440802','440800','赤坎区',3)
insert into region values('440803','440800','霞山区',3)
insert into region values('440804','440800','坡头区',3)
insert into region values('440811','440800','麻章区',3)
insert into region values('440823','440800','遂溪县',3)
insert into region values('440825','440800','徐闻县',3)
insert into region values('440881','440800','廉江市',3)
insert into region values('440882','440800','雷州市',3)
insert into region values('440883','440800','吴川市',3)
insert into region values('440900','440000','茂名市',2)
insert into region values('440902','440900','茂南区',3)
insert into region values('440903','440900','茂港区',3)
insert into region values('440923','440900','电白县',3)
insert into region values('440981','440900','高州市',3)
insert into region values('440982','440900','化州市',3)
insert into region values('440983','440900','信宜市',3)
insert into region values('441200','440000','肇庆市',2)
insert into region values('441202','441200','端州区',3)
insert into region values('441203','441200','鼎湖区',3)
insert into region values('441223','441200','广宁县',3)
insert into region values('441224','441200','怀集县',3)
insert into region values('441225','441200','封开县',3)
insert into region values('441226','441200','德庆县',3)
insert into region values('441283','441200','高要市',3)
insert into region values('441284','441200','四会市',3)
insert into region values('441300','440000','惠州市',2)
insert into region values('441302','441300','惠城区',3)
insert into region values('441303','441300','惠阳区',3)
insert into region values('441322','441300','博罗县',3)
insert into region values('441323','441300','惠东县',3)
insert into region values('441324','441300','龙门县',3)
insert into region values('441400','440000','梅州市',2)
insert into region values('441402','441400','梅江区',3)
insert into region values('441421','441400','梅　县',3)
insert into region values('441422','441400','大埔县',3)
insert into region values('441423','441400','丰顺县',3)
insert into region values('441424','441400','五华县',3)
insert into region values('441426','441400','平远县',3)
insert into region values('441427','441400','蕉岭县',3)
insert into region values('441481','441400','兴宁市',3)
insert into region values('441500','440000','汕尾市',2)
insert into region values('441502','441500','城　区',3)
insert into region values('441521','441500','海丰县',3)
insert into region values('441523','441500','陆河县',3)
insert into region values('441581','441500','陆丰市',3)
insert into region values('441600','440000','河源市',2)
insert into region values('441602','441600','源城区',3)
insert into region values('441621','441600','紫金县',3)
insert into region values('441622','441600','龙川县',3)
insert into region values('441623','441600','连平县',3)
insert into region values('441624','441600','和平县',3)
insert into region values('441625','441600','东源县',3)
insert into region values('441700','440000','阳江市',2)
insert into region values('441702','441700','江城区',3)
insert into region values('441721','441700','阳西县',3)
insert into region values('441723','441700','阳东县',3)
insert into region values('441781','441700','阳春市',3)
insert into region values('441800','440000','清远市',2)
insert into region values('441802','441800','清城区',3)
insert into region values('441821','441800','佛冈县',3)
insert into region values('441823','441800','阳山县',3)
insert into region values('441825','441800','连山壮族瑶族自治县',3)
insert into region values('441826','441800','连南瑶族自治县',3)
insert into region values('441827','441800','清新县',3)
insert into region values('441881','441800','英德市',3)
insert into region values('441882','441800','连州市',3)
insert into region values('441900','440000','东莞市',2)
insert into region values('442000','440000','中山市',2)
insert into region values('445100','440000','潮州市',2)
insert into region values('445102','445100','湘桥区',3)
insert into region values('445121','445100','潮安县',3)
insert into region values('445122','445100','饶平县',3)
insert into region values('445200','440000','揭阳市',2)
insert into region values('445202','445200','榕城区',3)
insert into region values('445221','445200','揭东县',3)
insert into region values('445222','445200','揭西县',3)
insert into region values('445224','445200','惠来县',3)
insert into region values('445281','445200','普宁市',3)
insert into region values('445300','440000','云浮市',2)
insert into region values('445302','445300','云城区',3)
insert into region values('445321','445300','新兴县',3)
insert into region values('445322','445300','郁南县',3)
insert into region values('445323','445300','云安县',3)
insert into region values('445381','445300','罗定市',3)
insert into region values('450000','1','广西壮族自治区',1)
insert into region values('450100','450000','南宁市',2)
insert into region values('450102','450100','兴宁区',3)
insert into region values('450103','450100','青秀区',3)
insert into region values('450105','450100','江南区',3)
insert into region values('450107','450100','西乡塘区',3)
insert into region values('450108','450100','良庆区',3)
insert into region values('450109','450100','邕宁区',3)
insert into region values('450122','450100','武鸣县',3)
insert into region values('450123','450100','隆安县',3)
insert into region values('450124','450100','马山县',3)
insert into region values('450125','450100','上林县',3)
insert into region values('450126','450100','宾阳县',3)
insert into region values('450127','450100','横　县',3)
insert into region values('450200','450000','柳州市',2)
insert into region values('450202','450200','城中区',3)
insert into region values('450203','450200','鱼峰区',3)
insert into region values('450204','450200','柳南区',3)
insert into region values('450205','450200','柳北区',3)
insert into region values('450221','450200','柳江县',3)
insert into region values('450222','450200','柳城县',3)
insert into region values('450223','450200','鹿寨县',3)
insert into region values('450224','450200','融安县',3)
insert into region values('450225','450200','融水苗族自治县',3)
insert into region values('450226','450200','三江侗族自治县',3)
insert into region values('450300','450000','桂林市',2)
insert into region values('450302','450300','秀峰区',3)
insert into region values('450303','450300','叠彩区',3)
insert into region values('450304','450300','象山区',3)
insert into region values('450305','450300','七星区',3)
insert into region values('450311','450300','雁山区',3)
insert into region values('450321','450300','阳朔县',3)
insert into region values('450322','450300','临桂县',3)
insert into region values('450323','450300','灵川县',3)
insert into region values('450324','450300','全州县',3)
insert into region values('450325','450300','兴安县',3)
insert into region values('450326','450300','永福县',3)
insert into region values('450327','450300','灌阳县',3)
insert into region values('450328','450300','龙胜各族自治县',3)
insert into region values('450329','450300','资源县',3)
insert into region values('450330','450300','平乐县',3)
insert into region values('450331','450300','荔蒲县',3)
insert into region values('450332','450300','恭城瑶族自治县',3)
insert into region values('450400','450000','梧州市',2)
insert into region values('450403','450400','万秀区',3)
insert into region values('450404','450400','蝶山区',3)
insert into region values('450405','450400','长洲区',3)
insert into region values('450421','450400','苍梧县',3)
insert into region values('450422','450400','藤　县',3)
insert into region values('450423','450400','蒙山县',3)
insert into region values('450481','450400','岑溪市',3)
insert into region values('450500','450000','北海市',2)
insert into region values('450502','450500','海城区',3)
insert into region values('450503','450500','银海区',3)
insert into region values('450512','450500','铁山港区',3)
insert into region values('450521','450500','合浦县',3)
insert into region values('450600','450000','防城港市',2)
insert into region values('450602','450600','港口区',3)
insert into region values('450603','450600','防城区',3)
insert into region values('450621','450600','上思县',3)
insert into region values('450681','450600','东兴市',3)
insert into region values('450700','450000','钦州市',2)
insert into region values('450702','450700','钦南区',3)
insert into region values('450703','450700','钦北区',3)
insert into region values('450721','450700','灵山县',3)
insert into region values('450722','450700','浦北县',3)
insert into region values('450800','450000','贵港市',2)
insert into region values('450802','450800','港北区',3)
insert into region values('450803','450800','港南区',3)
insert into region values('450804','450800','覃塘区',3)
insert into region values('450821','450800','平南县',3)
insert into region values('450881','450800','桂平市',3)
insert into region values('450900','450000','玉林市',2)
insert into region values('450902','450900','玉州区',3)
insert into region values('450921','450900','容　县',3)
insert into region values('450922','450900','陆川县',3)
insert into region values('450923','450900','博白县',3)
insert into region values('450924','450900','兴业县',3)
insert into region values('450981','450900','北流市',3)
insert into region values('451000','450000','百色市',2)
insert into region values('451002','451000','右江区',3)
insert into region values('451021','451000','田阳县',3)
insert into region values('451022','451000','田东县',3)
insert into region values('451023','451000','平果县',3)
insert into region values('451024','451000','德保县',3)
insert into region values('451025','451000','靖西县',3)
insert into region values('451026','451000','那坡县',3)
insert into region values('451027','451000','凌云县',3)
insert into region values('451028','451000','乐业县',3)
insert into region values('451029','451000','田林县',3)
insert into region values('451030','451000','西林县',3)
insert into region values('451031','451000','隆林各族自治县',3)
insert into region values('451100','450000','贺州市',2)
insert into region values('451102','451100','八步区',3)
insert into region values('451121','451100','昭平县',3)
insert into region values('451122','451100','钟山县',3)
insert into region values('451123','451100','富川瑶族自治县',3)
insert into region values('451200','450000','河池市',2)
insert into region values('451202','451200','金城江区',3)
insert into region values('451221','451200','南丹县',3)
insert into region values('451222','451200','天峨县',3)
insert into region values('451223','451200','凤山县',3)
insert into region values('451224','451200','东兰县',3)
insert into region values('451225','451200','罗城仫佬族自治县',3)
insert into region values('451226','451200','环江毛南族自治县',3)
insert into region values('451227','451200','巴马瑶族自治县',3)
insert into region values('451228','451200','都安瑶族自治县',3)
insert into region values('451229','451200','大化瑶族自治县',3)
insert into region values('451281','451200','宜州市',3)
insert into region values('451300','450000','来宾市',2)
insert into region values('451302','451300','兴宾区',3)
insert into region values('451321','451300','忻城县',3)
insert into region values('451322','451300','象州县',3)
insert into region values('451323','451300','武宣县',3)
insert into region values('451324','451300','金秀瑶族自治县',3)
insert into region values('451381','451300','合山市',3)
insert into region values('451400','450000','崇左市',2)
insert into region values('451402','451400','江洲区',3)
insert into region values('451421','451400','扶绥县',3)
insert into region values('451422','451400','宁明县',3)
insert into region values('451423','451400','龙州县',3)
insert into region values('451424','451400','大新县',3)
insert into region values('451425','451400','天等县',3)
insert into region values('451481','451400','凭祥市',3)
insert into region values('460000','1','海南省',1)
insert into region values('460100','460000','海口市',2)
insert into region values('460105','460100','秀英区',3)
insert into region values('460106','460100','龙华区',3)
insert into region values('460107','460100','琼山区',3)
insert into region values('460108','460100','美兰区',3)
insert into region values('460200','460000','三亚市',2)
insert into region values('469000','460000','省直辖县级行政单位',2)
insert into region values('469001','469000','五指山市',3)
insert into region values('469002','469000','琼海市',3)
insert into region values('469003','469000','儋州市',3)
insert into region values('469005','469000','文昌市',3)
insert into region values('469006','469000','万宁市',3)
insert into region values('469007','469000','东方市',3)
insert into region values('469025','469000','定安县',3)
insert into region values('469026','469000','屯昌县',3)
insert into region values('469027','469000','澄迈县',3)
insert into region values('469028','469000','临高县',3)
insert into region values('469030','469000','白沙黎族自治县',3)
insert into region values('469031','469000','昌江黎族自治县',3)
insert into region values('469033','469000','乐东黎族自治县',3)
insert into region values('469034','469000','陵水黎族自治县',3)
insert into region values('469035','469000','保亭黎族苗族自治县',3)
insert into region values('469036','469000','琼中黎族苗族自治县',3)
insert into region values('469037','469000','西沙群岛',3)
insert into region values('469038','469000','南沙群岛',3)
insert into region values('469039','469000','中沙群岛的岛礁及其海域',3)
insert into region values('500000','1','重庆市',1)
insert into region values('500100','500000','重庆市',2)
insert into region values('500101','500100','万州区',3)
insert into region values('500102','500100','涪陵区',3)
insert into region values('500103','500100','渝中区',3)
insert into region values('500104','500100','大渡口区',3)
insert into region values('500105','500100','江北区',3)
insert into region values('500106','500100','沙坪坝区',3)
insert into region values('500107','500100','九龙坡区',3)
insert into region values('500108','500100','南岸区',3)
insert into region values('500109','500100','北碚区',3)
insert into region values('500110','500100','万盛区',3)
insert into region values('500111','500100','双桥区',3)
insert into region values('500112','500100','渝北区',3)
insert into region values('500113','500100','巴南区',3)
insert into region values('500114','500100','黔江区',3)
insert into region values('500115','500100','长寿区',3)
insert into region values('500222','500100','綦江县',3)
insert into region values('500223','500100','潼南县',3)
insert into region values('500224','500100','铜梁县',3)
insert into region values('500225','500100','大足县',3)
insert into region values('500226','500100','荣昌县',3)
insert into region values('500227','500100','璧山县',3)
insert into region values('500228','500100','梁平县',3)
insert into region values('500229','500100','城口县',3)
insert into region values('500230','500100','丰都县',3)
insert into region values('500231','500100','垫江县',3)
insert into region values('500232','500100','武隆县',3)
insert into region values('500233','500100','忠　县',3)
insert into region values('500234','500100','开　县',3)
insert into region values('500235','500100','云阳县',3)
insert into region values('500236','500100','奉节县',3)
insert into region values('500237','500100','巫山县',3)
insert into region values('500238','500100','巫溪县',3)
insert into region values('500240','500100','石柱土家族自治县',3)
insert into region values('500241','500100','秀山土家族苗族自治县',3)
insert into region values('500242','500100','酉阳土家族苗族自治县',3)
insert into region values('500243','500100','彭水苗族土家族自治县',3)
insert into region values('500381','500100','江津市',3)
insert into region values('500382','500100','合川市',3)
insert into region values('500383','500100','永川市',3)
insert into region values('500384','500100','南川市',3)
insert into region values('510000','1','四川省',1)
insert into region values('510100','510000','成都市',2)
insert into region values('510104','510100','锦江区',3)
insert into region values('510105','510100','青羊区',3)
insert into region values('510106','510100','金牛区',3)
insert into region values('510107','510100','武侯区',3)
insert into region values('510108','510100','成华区',3)
insert into region values('510112','510100','龙泉驿区',3)
insert into region values('510113','510100','青白江区',3)
insert into region values('510114','510100','新都区',3)
insert into region values('510115','510100','温江区',3)
insert into region values('510121','510100','金堂县',3)
insert into region values('510122','510100','双流县',3)
insert into region values('510124','510100','郫　县',3)
insert into region values('510129','510100','大邑县',3)
insert into region values('510131','510100','蒲江县',3)
insert into region values('510132','510100','新津县',3)
insert into region values('510181','510100','都江堰市',3)
insert into region values('510182','510100','彭州市',3)
insert into region values('510183','510100','邛崃市',3)
insert into region values('510184','510100','崇州市',3)
insert into region values('510300','510000','自贡市',2)
insert into region values('510302','510300','自流井区',3)
insert into region values('510303','510300','贡井区',3)
insert into region values('510304','510300','大安区',3)
insert into region values('510311','510300','沿滩区',3)
insert into region values('510321','510300','荣　县',3)
insert into region values('510322','510300','富顺县',3)
insert into region values('510400','510000','攀枝花市',2)
insert into region values('510402','510400','东　区',3)
insert into region values('510403','510400','西　区',3)
insert into region values('510411','510400','仁和区',3)
insert into region values('510421','510400','米易县',3)
insert into region values('510422','510400','盐边县',3)
insert into region values('510500','510000','泸州市',2)
insert into region values('510502','510500','江阳区',3)
insert into region values('510503','510500','纳溪区',3)
insert into region values('510504','510500','龙马潭区',3)
insert into region values('510521','510500','泸　县',3)
insert into region values('510522','510500','合江县',3)
insert into region values('510524','510500','叙永县',3)
insert into region values('510525','510500','古蔺县',3)
insert into region values('510600','510000','德阳市',2)
insert into region values('510603','510600','旌阳区',3)
insert into region values('510623','510600','中江县',3)
insert into region values('510626','510600','罗江县',3)
insert into region values('510681','510600','广汉市',3)
insert into region values('510682','510600','什邡市',3)
insert into region values('510683','510600','绵竹市',3)
insert into region values('510700','510000','绵阳市',2)
insert into region values('510703','510700','涪城区',3)
insert into region values('510704','510700','游仙区',3)
insert into region values('510722','510700','三台县',3)
insert into region values('510723','510700','盐亭县',3)
insert into region values('510724','510700','安　县',3)
insert into region values('510725','510700','梓潼县',3)
insert into region values('510726','510700','北川羌族自治县',3)
insert into region values('510727','510700','平武县',3)
insert into region values('510781','510700','江油市',3)
insert into region values('510800','510000','广元市',2)
insert into region values('510802','510800','市中区',3)
insert into region values('510811','510800','元坝区',3)
insert into region values('510812','510800','朝天区',3)
insert into region values('510821','510800','旺苍县',3)
insert into region values('510822','510800','青川县',3)
insert into region values('510823','510800','剑阁县',3)
insert into region values('510824','510800','苍溪县',3)
insert into region values('510900','510000','遂宁市',2)
insert into region values('510903','510900','船山区',3)
insert into region values('510904','510900','安居区',3)
insert into region values('510921','510900','蓬溪县',3)
insert into region values('510922','510900','射洪县',3)
insert into region values('510923','510900','大英县',3)
insert into region values('511000','510000','内江市',2)
insert into region values('511002','511000','市中区',3)
insert into region values('511011','511000','东兴区',3)
insert into region values('511024','511000','威远县',3)
insert into region values('511025','511000','资中县',3)
insert into region values('511028','511000','隆昌县',3)
insert into region values('511100','510000','乐山市',2)
insert into region values('511102','511100','市中区',3)
insert into region values('511111','511100','沙湾区',3)
insert into region values('511112','511100','五通桥区',3)
insert into region values('511113','511100','金口河区',3)
insert into region values('511123','511100','犍为县',3)
insert into region values('511124','511100','井研县',3)
insert into region values('511126','511100','夹江县',3)
insert into region values('511129','511100','沐川县',3)
insert into region values('511132','511100','峨边彝族自治县',3)
insert into region values('511133','511100','马边彝族自治县',3)
insert into region values('511181','511100','峨眉山市',3)
insert into region values('511300','510000','南充市',2)
insert into region values('511302','511300','顺庆区',3)
insert into region values('511303','511300','高坪区',3)
insert into region values('511304','511300','嘉陵区',3)
insert into region values('511321','511300','南部县',3)
insert into region values('511322','511300','营山县',3)
insert into region values('511323','511300','蓬安县',3)
insert into region values('511324','511300','仪陇县',3)
insert into region values('511325','511300','西充县',3)
insert into region values('511381','511300','阆中市',3)
insert into region values('511400','510000','眉山市',2)
insert into region values('511402','511400','东坡区',3)
insert into region values('511421','511400','仁寿县',3)
insert into region values('511422','511400','彭山县',3)
insert into region values('511423','511400','洪雅县',3)
insert into region values('511424','511400','丹棱县',3)
insert into region values('511425','511400','青神县',3)
insert into region values('511500','510000','宜宾市',2)
insert into region values('511502','511500','翠屏区',3)
insert into region values('511521','511500','宜宾县',3)
insert into region values('511522','511500','南溪县',3)
insert into region values('511523','511500','江安县',3)
insert into region values('511524','511500','长宁县',3)
insert into region values('511525','511500','高　县',3)
insert into region values('511526','511500','珙　县',3)
insert into region values('511527','511500','筠连县',3)
insert into region values('511528','511500','兴文县',3)
insert into region values('511529','511500','屏山县',3)
insert into region values('511600','510000','广安市',2)
insert into region values('511602','511600','广安区',3)
insert into region values('511621','511600','岳池县',3)
insert into region values('511622','511600','武胜县',3)
insert into region values('511623','511600','邻水县',3)
insert into region values('511681','511600','华莹市',3)
insert into region values('511700','510000','达州市',2)
insert into region values('511702','511700','通川区',3)
insert into region values('511721','511700','达　县',3)
insert into region values('511722','511700','宣汉县',3)
insert into region values('511723','511700','开江县',3)
insert into region values('511724','511700','大竹县',3)
insert into region values('511725','511700','渠　县',3)
insert into region values('511781','511700','万源市',3)
insert into region values('511800','510000','雅安市',2)
insert into region values('511802','511800','雨城区',3)
insert into region values('511821','511800','名山县',3)
insert into region values('511822','511800','荥经县',3)
insert into region values('511823','511800','汉源县',3)
insert into region values('511824','511800','石棉县',3)
insert into region values('511825','511800','天全县',3)
insert into region values('511826','511800','芦山县',3)
insert into region values('511827','511800','宝兴县',3)
insert into region values('511900','510000','巴中市',2)
insert into region values('511902','511900','巴州区',3)
insert into region values('511921','511900','通江县',3)
insert into region values('511922','511900','南江县',3)
insert into region values('511923','511900','平昌县',3)
insert into region values('512000','510000','资阳市',2)
insert into region values('512002','512000','雁江区',3)
insert into region values('512021','512000','安岳县',3)
insert into region values('512022','512000','乐至县',3)
insert into region values('512081','512000','简阳市',3)
insert into region values('513200','510000','阿坝藏族羌族自治州',2)
insert into region values('513221','513200','汶川县',3)
insert into region values('513222','513200','理　县',3)
insert into region values('513223','513200','茂　县',3)
insert into region values('513224','513200','松潘县',3)
insert into region values('513225','513200','九寨沟县',3)
insert into region values('513226','513200','金川县',3)
insert into region values('513227','513200','小金县',3)
insert into region values('513228','513200','黑水县',3)
insert into region values('513229','513200','马尔康县',3)
insert into region values('513230','513200','壤塘县',3)
insert into region values('513231','513200','阿坝县',3)
insert into region values('513232','513200','若尔盖县',3)
insert into region values('513233','513200','红原县',3)
insert into region values('513300','510000','甘孜藏族自治州',2)
insert into region values('513321','513300','康定县',3)
insert into region values('513322','513300','泸定县',3)
insert into region values('513323','513300','丹巴县',3)
insert into region values('513324','513300','九龙县',3)
insert into region values('513325','513300','雅江县',3)
insert into region values('513326','513300','道孚县',3)
insert into region values('513327','513300','炉霍县',3)
insert into region values('513328','513300','甘孜县',3)
insert into region values('513329','513300','新龙县',3)
insert into region values('513330','513300','德格县',3)
insert into region values('513331','513300','白玉县',3)
insert into region values('513332','513300','石渠县',3)
insert into region values('513333','513300','色达县',3)
insert into region values('513334','513300','理塘县',3)
insert into region values('513335','513300','巴塘县',3)
insert into region values('513336','513300','乡城县',3)
insert into region values('513337','513300','稻城县',3)
insert into region values('513338','513300','得荣县',3)
insert into region values('513400','510000','凉山彝族自治州',2)
insert into region values('513401','513400','西昌市',3)
insert into region values('513422','513400','木里藏族自治县',3)
insert into region values('513423','513400','盐源县',3)
insert into region values('513424','513400','德昌县',3)
insert into region values('513425','513400','会理县',3)
insert into region values('513426','513400','会东县',3)
insert into region values('513427','513400','宁南县',3)
insert into region values('513428','513400','普格县',3)
insert into region values('513429','513400','布拖县',3)
insert into region values('513430','513400','金阳县',3)
insert into region values('513431','513400','昭觉县',3)
insert into region values('513432','513400','喜德县',3)
insert into region values('513433','513400','冕宁县',3)
insert into region values('513434','513400','越西县',3)
insert into region values('513435','513400','甘洛县',3)
insert into region values('513436','513400','美姑县',3)
insert into region values('513437','513400','雷波县',3)
insert into region values('520000','1','贵州省',1)
insert into region values('520100','520000','贵阳市',2)
insert into region values('520102','520100','南明区',3)
insert into region values('520103','520100','云岩区',3)
insert into region values('520111','520100','花溪区',3)
insert into region values('520112','520100','乌当区',3)
insert into region values('520113','520100','白云区',3)
insert into region values('520114','520100','小河区',3)
insert into region values('520121','520100','开阳县',3)
insert into region values('520122','520100','息烽县',3)
insert into region values('520123','520100','修文县',3)
insert into region values('520181','520100','清镇市',3)
insert into region values('520200','520000','六盘水市',2)
insert into region values('520201','520200','钟山区',3)
insert into region values('520203','520200','六枝特区',3)
insert into region values('520221','520200','水城县',3)
insert into region values('520222','520200','盘　县',3)
insert into region values('520300','520000','遵义市',2)
insert into region values('520302','520300','红花岗区',3)
insert into region values('520303','520300','汇川区',3)
insert into region values('520321','520300','遵义县',3)
insert into region values('520322','520300','桐梓县',3)
insert into region values('520323','520300','绥阳县',3)
insert into region values('520324','520300','正安县',3)
insert into region values('520325','520300','道真仡佬族苗族自治县',3)
insert into region values('520326','520300','务川仡佬族苗族自治县',3)
insert into region values('520327','520300','凤冈县',3)
insert into region values('520328','520300','湄潭县',3)
insert into region values('520329','520300','余庆县',3)
insert into region values('520330','520300','习水县',3)
insert into region values('520381','520300','赤水市',3)
insert into region values('520382','520300','仁怀市',3)
insert into region values('520400','520000','安顺市',2)
insert into region values('520402','520400','西秀区',3)
insert into region values('520421','520400','平坝县',3)
insert into region values('520422','520400','普定县',3)
insert into region values('520423','520400','镇宁布依族苗族自治县',3)
insert into region values('520424','520400','关岭布依族苗族自治县',3)
insert into region values('520425','520400','紫云苗族布依族自治县',3)
insert into region values('522200','520000','铜仁地区',2)
insert into region values('522201','522200','铜仁市',3)
insert into region values('522222','522200','江口县',3)
insert into region values('522223','522200','玉屏侗族自治县',3)
insert into region values('522224','522200','石阡县',3)
insert into region values('522225','522200','思南县',3)
insert into region values('522226','522200','印江土家族苗族自治县',3)
insert into region values('522227','522200','德江县',3)
insert into region values('522228','522200','沿河土家族自治县',3)
insert into region values('522229','522200','松桃苗族自治县',3)
insert into region values('522230','522200','万山特区',3)
insert into region values('522300','520000','黔西南布依族苗族自治州',2)
insert into region values('522301','522300','兴义市',3)
insert into region values('522322','522300','兴仁县',3)
insert into region values('522323','522300','普安县',3)
insert into region values('522324','522300','晴隆县',3)
insert into region values('522325','522300','贞丰县',3)
insert into region values('522326','522300','望谟县',3)
insert into region values('522327','522300','册亨县',3)
insert into region values('522328','522300','安龙县',3)
insert into region values('522400','520000','毕节地区',2)
insert into region values('522401','522400','毕节市',3)
insert into region values('522422','522400','大方县',3)
insert into region values('522423','522400','黔西县',3)
insert into region values('522424','522400','金沙县',3)
insert into region values('522425','522400','织金县',3)
insert into region values('522426','522400','纳雍县',3)
insert into region values('522427','522400','威宁彝族回族苗族自治县',3)
insert into region values('522428','522400','赫章县',3)
insert into region values('522600','520000','黔东南苗族侗族自治州',2)
insert into region values('522601','522600','凯里市',3)
insert into region values('522622','522600','黄平县',3)
insert into region values('522623','522600','施秉县',3)
insert into region values('522624','522600','三穗县',3)
insert into region values('522625','522600','镇远县',3)
insert into region values('522626','522600','岑巩县',3)
insert into region values('522627','522600','天柱县',3)
insert into region values('522628','522600','锦屏县',3)
insert into region values('522629','522600','剑河县',3)
insert into region values('522630','522600','台江县',3)
insert into region values('522631','522600','黎平县',3)
insert into region values('522632','522600','榕江县',3)
insert into region values('522633','522600','从江县',3)
insert into region values('522634','522600','雷山县',3)
insert into region values('522635','522600','麻江县',3)
insert into region values('522636','522600','丹寨县',3)
insert into region values('522700','520000','黔南布依族苗族自治州',2)
insert into region values('522701','522700','都匀市',3)
insert into region values('522702','522700','福泉市',3)
insert into region values('522722','522700','荔波县',3)
insert into region values('522723','522700','贵定县',3)
insert into region values('522725','522700','瓮安县',3)
insert into region values('522726','522700','独山县',3)
insert into region values('522727','522700','平塘县',3)
insert into region values('522728','522700','罗甸县',3)
insert into region values('522729','522700','长顺县',3)
insert into region values('522730','522700','龙里县',3)
insert into region values('522731','522700','惠水县',3)
insert into region values('522732','522700','三都水族自治县',3)
insert into region values('530000','1','云南省',1)
insert into region values('530100','530000','昆明市',2)
insert into region values('530102','530100','五华区',3)
insert into region values('530103','530100','盘龙区',3)
insert into region values('530111','530100','官渡区',3)
insert into region values('530112','530100','西山区',3)
insert into region values('530113','530100','东川区',3)
insert into region values('530121','530100','呈贡县',3)
insert into region values('530122','530100','晋宁县',3)
insert into region values('530124','530100','富民县',3)
insert into region values('530125','530100','宜良县',3)
insert into region values('530126','530100','石林彝族自治县',3)
insert into region values('530127','530100','嵩明县',3)
insert into region values('530128','530100','禄劝彝族苗族自治县',3)
insert into region values('530129','530100','寻甸回族彝族自治县',3)
insert into region values('530181','530100','安宁市',3)
insert into region values('530300','530000','曲靖市',2)
insert into region values('530302','530300','麒麟区',3)
insert into region values('530321','530300','马龙县',3)
insert into region values('530322','530300','陆良县',3)
insert into region values('530323','530300','师宗县',3)
insert into region values('530324','530300','罗平县',3)
insert into region values('530325','530300','富源县',3)
insert into region values('530326','530300','会泽县',3)
insert into region values('530328','530300','沾益县',3)
insert into region values('530381','530300','宣威市',3)
insert into region values('530400','530000','玉溪市',2)
insert into region values('530402','530400','红塔区',3)
insert into region values('530421','530400','江川县',3)
insert into region values('530422','530400','澄江县',3)
insert into region values('530423','530400','通海县',3)
insert into region values('530424','530400','华宁县',3)
insert into region values('530425','530400','易门县',3)
insert into region values('530426','530400','峨山彝族自治县',3)
insert into region values('530427','530400','新平彝族傣族自治县',3)
insert into region values('530428','530400','元江哈尼族彝族傣族自治县',3)
insert into region values('530500','530000','保山市',2)
insert into region values('530502','530500','隆阳区',3)
insert into region values('530521','530500','施甸县',3)
insert into region values('530522','530500','腾冲县',3)
insert into region values('530523','530500','龙陵县',3)
insert into region values('530524','530500','昌宁县',3)
insert into region values('530600','530000','昭通市',2)
insert into region values('530602','530600','昭阳区',3)
insert into region values('530621','530600','鲁甸县',3)
insert into region values('530622','530600','巧家县',3)
insert into region values('530623','530600','盐津县',3)
insert into region values('530624','530600','大关县',3)
insert into region values('530625','530600','永善县',3)
insert into region values('530626','530600','绥江县',3)
insert into region values('530627','530600','镇雄县',3)
insert into region values('530628','530600','彝良县',3)
insert into region values('530629','530600','威信县',3)
insert into region values('530630','530600','水富县',3)
insert into region values('530700','530000','丽江市',2)
insert into region values('530702','530700','古城区',3)
insert into region values('530721','530700','玉龙纳西族自治县',3)
insert into region values('530722','530700','永胜县',3)
insert into region values('530723','530700','华坪县',3)
insert into region values('530724','530700','宁蒗彝族自治县',3)
insert into region values('530800','530000','思茅市',2)
insert into region values('530802','530800','翠云区',3)
insert into region values('530821','530800','普洱哈尼族彝族自治县',3)
insert into region values('530822','530800','墨江哈尼族自治县',3)
insert into region values('530823','530800','景东彝族自治县',3)
insert into region values('530824','530800','景谷傣族彝族自治县',3)
insert into region values('530825','530800','镇沅彝族哈尼族拉祜族自治县',3)
insert into region values('530826','530800','江城哈尼族彝族自治县',3)
insert into region values('530827','530800','孟连傣族拉祜族佤族自治县',3)
insert into region values('530828','530800','澜沧拉祜族自治县',3)
insert into region values('530829','530800','西盟佤族自治县',3)
insert into region values('530900','530000','临沧市',2)
insert into region values('530902','530900','临翔区',3)
insert into region values('530921','530900','凤庆县',3)
insert into region values('530922','530900','云　县',3)
insert into region values('530923','530900','永德县',3)
insert into region values('530924','530900','镇康县',3)
insert into region values('530925','530900','双江拉祜族佤族布朗族傣族自治县',3)
insert into region values('530926','530900','耿马傣族佤族自治县',3)
insert into region values('530927','530900','沧源佤族自治县',3)
insert into region values('532300','530000','楚雄彝族自治州',2)
insert into region values('532301','532300','楚雄市',3)
insert into region values('532322','532300','双柏县',3)
insert into region values('532323','532300','牟定县',3)
insert into region values('532324','532300','南华县',3)
insert into region values('532325','532300','姚安县',3)
insert into region values('532326','532300','大姚县',3)
insert into region values('532327','532300','永仁县',3)
insert into region values('532328','532300','元谋县',3)
insert into region values('532329','532300','武定县',3)
insert into region values('532331','532300','禄丰县',3)
insert into region values('532500','530000','红河哈尼族彝族自治州',2)
insert into region values('532501','532500','个旧市',3)
insert into region values('532502','532500','开远市',3)
insert into region values('532522','532500','蒙自县',3)
insert into region values('532523','532500','屏边苗族自治县',3)
insert into region values('532524','532500','建水县',3)
insert into region values('532525','532500','石屏县',3)
insert into region values('532526','532500','弥勒县',3)
insert into region values('532527','532500','泸西县',3)
insert into region values('532528','532500','元阳县',3)
insert into region values('532529','532500','红河县',3)
insert into region values('532530','532500','金平苗族瑶族傣族自治县',3)
insert into region values('532531','532500','绿春县',3)
insert into region values('532532','532500','河口瑶族自治县',3)
insert into region values('532600','530000','文山壮族苗族自治州',2)
insert into region values('532621','532600','文山县',3)
insert into region values('532622','532600','砚山县',3)
insert into region values('532623','532600','西畴县',3)
insert into region values('532624','532600','麻栗坡县',3)
insert into region values('532625','532600','马关县',3)
insert into region values('532626','532600','丘北县',3)
insert into region values('532627','532600','广南县',3)
insert into region values('532628','532600','富宁县',3)
insert into region values('532800','530000','西双版纳傣族自治州',2)
insert into region values('532801','532800','景洪市',3)
insert into region values('532822','532800','勐海县',3)
insert into region values('532823','532800','勐腊县',3)
insert into region values('532900','530000','大理白族自治州',2)
insert into region values('532901','532900','大理市',3)
insert into region values('532922','532900','漾濞彝族自治县',3)
insert into region values('532923','532900','祥云县',3)
insert into region values('532924','532900','宾川县',3)
insert into region values('532925','532900','弥渡县',3)
insert into region values('532926','532900','南涧彝族自治县',3)
insert into region values('532927','532900','巍山彝族回族自治县',3)
insert into region values('532928','532900','永平县',3)
insert into region values('532929','532900','云龙县',3)
insert into region values('532930','532900','洱源县',3)
insert into region values('532931','532900','剑川县',3)
insert into region values('532932','532900','鹤庆县',3)
insert into region values('533100','530000','德宏傣族景颇族自治州',2)
insert into region values('533102','533100','瑞丽市',3)
insert into region values('533103','533100','潞西市',3)
insert into region values('533122','533100','梁河县',3)
insert into region values('533123','533100','盈江县',3)
insert into region values('533124','533100','陇川县',3)
insert into region values('533300','530000','怒江傈僳族自治州',2)
insert into region values('533321','533300','泸水县',3)
insert into region values('533323','533300','福贡县',3)
insert into region values('533324','533300','贡山独龙族怒族自治县',3)
insert into region values('533325','533300','兰坪白族普米族自治县',3)
insert into region values('533400','530000','迪庆藏族自治州',2)
insert into region values('533421','533400','香格里拉县',3)
insert into region values('533422','533400','德钦县',3)
insert into region values('533423','533400','维西傈僳族自治县',3)
insert into region values('540000','1','西藏自治区',1)
insert into region values('540100','540000','拉萨市',2)
insert into region values('540102','540100','城关区',3)
insert into region values('540121','540100','林周县',3)
insert into region values('540122','540100','当雄县',3)
insert into region values('540123','540100','尼木县',3)
insert into region values('540124','540100','曲水县',3)
insert into region values('540125','540100','堆龙德庆县',3)
insert into region values('540126','540100','达孜县',3)
insert into region values('540127','540100','墨竹工卡县',3)
insert into region values('542100','540000','昌都地区',2)
insert into region values('542121','542100','昌都县',3)
insert into region values('542122','542100','江达县',3)
insert into region values('542123','542100','贡觉县',3)
insert into region values('542124','542100','类乌齐县',3)
insert into region values('542125','542100','丁青县',3)
insert into region values('542126','542100','察雅县',3)
insert into region values('542127','542100','八宿县',3)
insert into region values('542128','542100','左贡县',3)
insert into region values('542129','542100','芒康县',3)
insert into region values('542132','542100','洛隆县',3)
insert into region values('542133','542100','边坝县',3)
insert into region values('542200','540000','山南地区',2)
insert into region values('542221','542200','乃东县',3)
insert into region values('542222','542200','扎囊县',3)
insert into region values('542223','542200','贡嘎县',3)
insert into region values('542224','542200','桑日县',3)
insert into region values('542225','542200','琼结县',3)
insert into region values('542226','542200','曲松县',3)
insert into region values('542227','542200','措美县',3)
insert into region values('542228','542200','洛扎县',3)
insert into region values('542229','542200','加查县',3)
insert into region values('542231','542200','隆子县',3)
insert into region values('542232','542200','错那县',3)
insert into region values('542233','542200','浪卡子县',3)
insert into region values('542300','540000','日喀则地区',2)
insert into region values('542301','542300','日喀则市',3)
insert into region values('542322','542300','南木林县',3)
insert into region values('542323','542300','江孜县',3)
insert into region values('542324','542300','定日县',3)
insert into region values('542325','542300','萨迦县',3)
insert into region values('542326','542300','拉孜县',3)
insert into region values('542327','542300','昂仁县',3)
insert into region values('542328','542300','谢通门县',3)
insert into region values('542329','542300','白朗县',3)
insert into region values('542330','542300','仁布县',3)
insert into region values('542331','542300','康马县',3)
insert into region values('542332','542300','定结县',3)
insert into region values('542333','542300','仲巴县',3)
insert into region values('542334','542300','亚东县',3)
insert into region values('542335','542300','吉隆县',3)
insert into region values('542336','542300','聂拉木县',3)
insert into region values('542337','542300','萨嘎县',3)
insert into region values('542338','542300','岗巴县',3)
insert into region values('542400','540000','那曲地区',2)
insert into region values('542421','542400','那曲县',3)
insert into region values('542422','542400','嘉黎县',3)
insert into region values('542423','542400','比如县',3)
insert into region values('542424','542400','聂荣县',3)
insert into region values('542425','542400','安多县',3)
insert into region values('542426','542400','申扎县',3)
insert into region values('542427','542400','索　县',3)
insert into region values('542428','542400','班戈县',3)
insert into region values('542429','542400','巴青县',3)
insert into region values('542430','542400','尼玛县',3)
insert into region values('542500','540000','阿里地区',2)
insert into region values('542521','542500','普兰县',3)
insert into region values('542522','542500','札达县',3)
insert into region values('542523','542500','噶尔县',3)
insert into region values('542524','542500','日土县',3)
insert into region values('542525','542500','革吉县',3)
insert into region values('542526','542500','改则县',3)
insert into region values('542527','542500','措勤县',3)
insert into region values('542600','540000','林芝地区',2)
insert into region values('542621','542600','林芝县',3)
insert into region values('542622','542600','工布江达县',3)
insert into region values('542623','542600','米林县',3)
insert into region values('542624','542600','墨脱县',3)
insert into region values('542625','542600','波密县',3)
insert into region values('542626','542600','察隅县',3)
insert into region values('542627','542600','朗　县',3)
insert into region values('610000','1','陕西省',1)
insert into region values('610100','610000','西安市',2)
insert into region values('610102','610100','新城区',3)
insert into region values('610103','610100','碑林区',3)
insert into region values('610104','610100','莲湖区',3)
insert into region values('610111','610100','灞桥区',3)
insert into region values('610112','610100','未央区',3)
insert into region values('610113','610100','雁塔区',3)
insert into region values('610114','610100','阎良区',3)
insert into region values('610115','610100','临潼区',3)
insert into region values('610116','610100','长安区',3)
insert into region values('610122','610100','蓝田县',3)
insert into region values('610124','610100','周至县',3)
insert into region values('610125','610100','户　县',3)
insert into region values('610126','610100','高陵县',3)
insert into region values('610200','610000','铜川市',2)
insert into region values('610202','610200','王益区',3)
insert into region values('610203','610200','印台区',3)
insert into region values('610204','610200','耀州区',3)
insert into region values('610222','610200','宜君县',3)
insert into region values('610300','610000','宝鸡市',2)
insert into region values('610302','610300','渭滨区',3)
insert into region values('610303','610300','金台区',3)
insert into region values('610304','610300','陈仓区',3)
insert into region values('610322','610300','凤翔县',3)
insert into region values('610323','610300','岐山县',3)
insert into region values('610324','610300','扶风县',3)
insert into region values('610326','610300','眉　县',3)
insert into region values('610327','610300','陇　县',3)
insert into region values('610328','610300','千阳县',3)
insert into region values('610329','610300','麟游县',3)
insert into region values('610330','610300','凤　县',3)
insert into region values('610331','610300','太白县',3)
insert into region values('610400','610000','咸阳市',2)
insert into region values('610402','610400','秦都区',3)
insert into region values('610403','610400','杨凌区',3)
insert into region values('610404','610400','渭城区',3)
insert into region values('610422','610400','三原县',3)
insert into region values('610423','610400','泾阳县',3)
insert into region values('610424','610400','乾　县',3)
insert into region values('610425','610400','礼泉县',3)
insert into region values('610426','610400','永寿县',3)
insert into region values('610427','610400','彬　县',3)
insert into region values('610428','610400','长武县',3)
insert into region values('610429','610400','旬邑县',3)
insert into region values('610430','610400','淳化县',3)
insert into region values('610431','610400','武功县',3)
insert into region values('610481','610400','兴平市',3)
insert into region values('610500','610000','渭南市',2)
insert into region values('610502','610500','临渭区',3)
insert into region values('610521','610500','华　县',3)
insert into region values('610522','610500','潼关县',3)
insert into region values('610523','610500','大荔县',3)
insert into region values('610524','610500','合阳县',3)
insert into region values('610525','610500','澄城县',3)
insert into region values('610526','610500','蒲城县',3)
insert into region values('610527','610500','白水县',3)
insert into region values('610528','610500','富平县',3)
insert into region values('610581','610500','韩城市',3)
insert into region values('610582','610500','华阴市',3)
insert into region values('610600','610000','延安市',2)
insert into region values('610602','610600','宝塔区',3)
insert into region values('610621','610600','延长县',3)
insert into region values('610622','610600','延川县',3)
insert into region values('610623','610600','子长县',3)
insert into region values('610624','610600','安塞县',3)
insert into region values('610625','610600','志丹县',3)
insert into region values('610626','610600','吴旗县',3)
insert into region values('610627','610600','甘泉县',3)
insert into region values('610628','610600','富　县',3)
insert into region values('610629','610600','洛川县',3)
insert into region values('610630','610600','宜川县',3)
insert into region values('610631','610600','黄龙县',3)
insert into region values('610632','610600','黄陵县',3)
insert into region values('610700','610000','汉中市',2)
insert into region values('610702','610700','汉台区',3)
insert into region values('610721','610700','南郑县',3)
insert into region values('610722','610700','城固县',3)
insert into region values('610723','610700','洋　县',3)
insert into region values('610724','610700','西乡县',3)
insert into region values('610725','610700','勉　县',3)
insert into region values('610726','610700','宁强县',3)
insert into region values('610727','610700','略阳县',3)
insert into region values('610728','610700','镇巴县',3)
insert into region values('610729','610700','留坝县',3)
insert into region values('610730','610700','佛坪县',3)
insert into region values('610800','610000','榆林市',2)
insert into region values('610802','610800','榆阳区',3)
insert into region values('610821','610800','神木县',3)
insert into region values('610822','610800','府谷县',3)
insert into region values('610823','610800','横山县',3)
insert into region values('610824','610800','靖边县',3)
insert into region values('610825','610800','定边县',3)
insert into region values('610826','610800','绥德县',3)
insert into region values('610827','610800','米脂县',3)
insert into region values('610828','610800','佳　县',3)
insert into region values('610829','610800','吴堡县',3)
insert into region values('610830','610800','清涧县',3)
insert into region values('610831','610800','子洲县',3)
insert into region values('610900','610000','安康市',2)
insert into region values('610902','610900','汉滨区',3)
insert into region values('610921','610900','汉阴县',3)
insert into region values('610922','610900','石泉县',3)
insert into region values('610923','610900','宁陕县',3)
insert into region values('610924','610900','紫阳县',3)
insert into region values('610925','610900','岚皋县',3)
insert into region values('610926','610900','平利县',3)
insert into region values('610927','610900','镇坪县',3)
insert into region values('610928','610900','旬阳县',3)
insert into region values('610929','610900','白河县',3)
insert into region values('611000','610000','商洛市',2)
insert into region values('611002','611000','商州区',3)
insert into region values('611021','611000','洛南县',3)
insert into region values('611022','611000','丹凤县',3)
insert into region values('611023','611000','商南县',3)
insert into region values('611024','611000','山阳县',3)
insert into region values('611025','611000','镇安县',3)
insert into region values('611026','611000','柞水县',3)
insert into region values('620000','1','甘肃省',1)
insert into region values('620100','620000','兰州市',2)
insert into region values('620102','620100','城关区',3)
insert into region values('620103','620100','七里河区',3)
insert into region values('620104','620100','西固区',3)
insert into region values('620105','620100','安宁区',3)
insert into region values('620111','620100','红古区',3)
insert into region values('620121','620100','永登县',3)
insert into region values('620122','620100','皋兰县',3)
insert into region values('620123','620100','榆中县',3)
insert into region values('620200','620000','嘉峪关市',2)
insert into region values('620300','620000','金昌市',2)
insert into region values('620302','620300','金川区',3)
insert into region values('620321','620300','永昌县',3)
insert into region values('620400','620000','白银市',2)
insert into region values('620402','620400','白银区',3)
insert into region values('620403','620400','平川区',3)
insert into region values('620421','620400','靖远县',3)
insert into region values('620422','620400','会宁县',3)
insert into region values('620423','620400','景泰县',3)
insert into region values('620500','620000','天水市',2)
insert into region values('620502','620500','秦城区',3)
insert into region values('620503','620500','北道区',3)
insert into region values('620521','620500','清水县',3)
insert into region values('620522','620500','秦安县',3)
insert into region values('620523','620500','甘谷县',3)
insert into region values('620524','620500','武山县',3)
insert into region values('620525','620500','张家川回族自治县',3)
insert into region values('620600','620000','武威市',2)
insert into region values('620602','620600','凉州区',3)
insert into region values('620621','620600','民勤县',3)
insert into region values('620622','620600','古浪县',3)
insert into region values('620623','620600','天祝藏族自治县',3)
insert into region values('620700','620000','张掖市',2)
insert into region values('620702','620700','甘州区',3)
insert into region values('620721','620700','肃南裕固族自治县',3)
insert into region values('620722','620700','民乐县',3)
insert into region values('620723','620700','临泽县',3)
insert into region values('620724','620700','高台县',3)
insert into region values('620725','620700','山丹县',3)
insert into region values('620800','620000','平凉市',2)
insert into region values('620802','620800','崆峒区',3)
insert into region values('620821','620800','泾川县',3)
insert into region values('620822','620800','灵台县',3)
insert into region values('620823','620800','崇信县',3)
insert into region values('620824','620800','华亭县',3)
insert into region values('620825','620800','庄浪县',3)
insert into region values('620826','620800','静宁县',3)
insert into region values('620900','620000','酒泉市',2)
insert into region values('620902','620900','肃州区',3)
insert into region values('620921','620900','金塔县',3)
insert into region values('620922','620900','安西县',3)
insert into region values('620923','620900','肃北蒙古族自治县',3)
insert into region values('620924','620900','阿克塞哈萨克族自治县',3)
insert into region values('620981','620900','玉门市',3)
insert into region values('620982','620900','敦煌市',3)
insert into region values('621000','620000','庆阳市',2)
insert into region values('621002','621000','西峰区',3)
insert into region values('621021','621000','庆城县',3)
insert into region values('621022','621000','环　县',3)
insert into region values('621023','621000','华池县',3)
insert into region values('621024','621000','合水县',3)
insert into region values('621025','621000','正宁县',3)
insert into region values('621026','621000','宁　县',3)
insert into region values('621027','621000','镇原县',3)
insert into region values('621100','620000','定西市',2)
insert into region values('621102','621100','安定区',3)
insert into region values('621121','621100','通渭县',3)
insert into region values('621122','621100','陇西县',3)
insert into region values('621123','621100','渭源县',3)
insert into region values('621124','621100','临洮县',3)
insert into region values('621125','621100','漳　县',3)
insert into region values('621126','621100','岷　县',3)
insert into region values('621200','620000','陇南市',2)
insert into region values('621202','621200','武都区',3)
insert into region values('621221','621200','成　县',3)
insert into region values('621222','621200','文　县',3)
insert into region values('621223','621200','宕昌县',3)
insert into region values('621224','621200','康　县',3)
insert into region values('621225','621200','西和县',3)
insert into region values('621226','621200','礼　县',3)
insert into region values('621227','621200','徽　县',3)
insert into region values('621228','621200','两当县',3)
insert into region values('622900','620000','临夏回族自治州',2)
insert into region values('622901','622900','临夏市',3)
insert into region values('622921','622900','临夏县',3)
insert into region values('622922','622900','康乐县',3)
insert into region values('622923','622900','永靖县',3)
insert into region values('622924','622900','广河县',3)
insert into region values('622925','622900','和政县',3)
insert into region values('622926','622900','东乡族自治县',3)
insert into region values('622927','622900','积石山保安族东乡族撒拉族自治县',3)
insert into region values('623000','620000','甘南藏族自治州',2)
insert into region values('623001','623000','合作市',3)
insert into region values('623021','623000','临潭县',3)
insert into region values('623022','623000','卓尼县',3)
insert into region values('623023','623000','舟曲县',3)
insert into region values('623024','623000','迭部县',3)
insert into region values('623025','623000','玛曲县',3)
insert into region values('623026','623000','碌曲县',3)
insert into region values('623027','623000','夏河县',3)
insert into region values('630000','1','青海省',1)
insert into region values('630100','630000','西宁市',2)
insert into region values('630102','630100','城东区',3)
insert into region values('630103','630100','城中区',3)
insert into region values('630104','630100','城西区',3)
insert into region values('630105','630100','城北区',3)
insert into region values('630121','630100','大通回族土族自治县',3)
insert into region values('630122','630100','湟中县',3)
insert into region values('630123','630100','湟源县',3)
insert into region values('632100','630000','海东地区',2)
insert into region values('632121','632100','平安县',3)
insert into region values('632122','632100','民和回族土族自治县',3)
insert into region values('632123','632100','乐都县',3)
insert into region values('632126','632100','互助土族自治县',3)
insert into region values('632127','632100','化隆回族自治县',3)
insert into region values('632128','632100','循化撒拉族自治县',3)
insert into region values('632200','630000','海北藏族自治州',2)
insert into region values('632221','632200','门源回族自治县',3)
insert into region values('632222','632200','祁连县',3)
insert into region values('632223','632200','海晏县',3)
insert into region values('632224','632200','刚察县',3)
insert into region values('632300','630000','黄南藏族自治州',2)
insert into region values('632321','632300','同仁县',3)
insert into region values('632322','632300','尖扎县',3)
insert into region values('632323','632300','泽库县',3)
insert into region values('632324','632300','河南蒙古族自治县',3)
insert into region values('632500','630000','海南藏族自治州',2)
insert into region values('632521','632500','共和县',3)
insert into region values('632522','632500','同德县',3)
insert into region values('632523','632500','贵德县',3)
insert into region values('632524','632500','兴海县',3)
insert into region values('632525','632500','贵南县',3)
insert into region values('632600','630000','果洛藏族自治州',2)
insert into region values('632621','632600','玛沁县',3)
insert into region values('632622','632600','班玛县',3)
insert into region values('632623','632600','甘德县',3)
insert into region values('632624','632600','达日县',3)
insert into region values('632625','632600','久治县',3)
insert into region values('632626','632600','玛多县',3)
insert into region values('632700','630000','玉树藏族自治州',2)
insert into region values('632721','632700','玉树县',3)
insert into region values('632722','632700','杂多县',3)
insert into region values('632723','632700','称多县',3)
insert into region values('632724','632700','治多县',3)
insert into region values('632725','632700','囊谦县',3)
insert into region values('632726','632700','曲麻莱县',3)
insert into region values('632800','630000','海西蒙古族藏族自治州',2)
insert into region values('632801','632800','格尔木市',3)
insert into region values('632802','632800','德令哈市',3)
insert into region values('632821','632800','乌兰县',3)
insert into region values('632822','632800','都兰县',3)
insert into region values('632823','632800','天峻县',3)
insert into region values('640000','1','宁夏回族自治区',1)
insert into region values('640100','640000','银川市',2)
insert into region values('640104','640100','兴庆区',3)
insert into region values('640105','640100','西夏区',3)
insert into region values('640106','640100','金凤区',3)
insert into region values('640121','640100','永宁县',3)
insert into region values('640122','640100','贺兰县',3)
insert into region values('640181','640100','灵武市',3)
insert into region values('640200','640000','石嘴山市',2)
insert into region values('640202','640200','大武口区',3)
insert into region values('640205','640200','惠农区',3)
insert into region values('640221','640200','平罗县',3)
insert into region values('640300','640000','吴忠市',2)
insert into region values('640302','640300','利通区',3)
insert into region values('640323','640300','盐池县',3)
insert into region values('640324','640300','同心县',3)
insert into region values('640381','640300','青铜峡市',3)
insert into region values('640400','640000','固原市',2)
insert into region values('640402','640400','原州区',3)
insert into region values('640422','640400','西吉县',3)
insert into region values('640423','640400','隆德县',3)
insert into region values('640424','640400','泾源县',3)
insert into region values('640425','640400','彭阳县',3)
insert into region values('640500','640000','中卫市',2)
insert into region values('640502','640500','沙坡头区',3)
insert into region values('640521','640500','中宁县',3)
insert into region values('640522','640500','海原县',3)
insert into region values('650000','1','新疆维吾尔自治区',1)
insert into region values('650100','650000','乌鲁木齐市',2)
insert into region values('650102','650100','天山区',3)
insert into region values('650103','650100','沙依巴克区',3)
insert into region values('650104','650100','新市区',3)
insert into region values('650105','650100','水磨沟区',3)
insert into region values('650106','650100','头屯河区',3)
insert into region values('650107','650100','达坂城区',3)
insert into region values('650108','650100','东山区',3)
insert into region values('650121','650100','乌鲁木齐县',3)
insert into region values('650200','650000','克拉玛依市',2)
insert into region values('650202','650200','独山子区',3)
insert into region values('650203','650200','克拉玛依区',3)
insert into region values('650204','650200','白碱滩区',3)
insert into region values('650205','650200','乌尔禾区',3)
insert into region values('652100','650000','吐鲁番地区',2)
insert into region values('652101','652100','吐鲁番市',3)
insert into region values('652122','652100','鄯善县',3)
insert into region values('652123','652100','托克逊县',3)
insert into region values('652200','650000','哈密地区',2)
insert into region values('652201','652200','哈密市',3)
insert into region values('652222','652200','巴里坤哈萨克自治县',3)
insert into region values('652223','652200','伊吾县',3)
insert into region values('652300','650000','昌吉回族自治州',2)
insert into region values('652301','652300','昌吉市',3)
insert into region values('652302','652300','阜康市',3)
insert into region values('652303','652300','米泉市',3)
insert into region values('652323','652300','呼图壁县',3)
insert into region values('652324','652300','玛纳斯县',3)
insert into region values('652325','652300','奇台县',3)
insert into region values('652327','652300','吉木萨尔县',3)
insert into region values('652328','652300','木垒哈萨克自治县',3)
insert into region values('652700','650000','博尔塔拉蒙古自治州',2)
insert into region values('652701','652700','博乐市',3)
insert into region values('652722','652700','精河县',3)
insert into region values('652723','652700','温泉县',3)
insert into region values('652800','650000','巴音郭楞蒙古自治州',2)
insert into region values('652801','652800','库尔勒市',3)
insert into region values('652822','652800','轮台县',3)
insert into region values('652823','652800','尉犁县',3)
insert into region values('652824','652800','若羌县',3)
insert into region values('652825','652800','且末县',3)
insert into region values('652826','652800','焉耆回族自治县',3)
insert into region values('652827','652800','和静县',3)
insert into region values('652828','652800','和硕县',3)
insert into region values('652829','652800','博湖县',3)
insert into region values('652900','650000','阿克苏地区',2)
insert into region values('652901','652900','阿克苏市',3)
insert into region values('652922','652900','温宿县',3)
insert into region values('652923','652900','库车县',3)
insert into region values('652924','652900','沙雅县',3)
insert into region values('652925','652900','新和县',3)
insert into region values('652926','652900','拜城县',3)
insert into region values('652927','652900','乌什县',3)
insert into region values('652928','652900','阿瓦提县',3)
insert into region values('652929','652900','柯坪县',3)
insert into region values('653000','650000','克孜勒苏柯尔克孜自治州',2)
insert into region values('653001','653000','阿图什市',3)
insert into region values('653022','653000','阿克陶县',3)
insert into region values('653023','653000','阿合奇县',3)
insert into region values('653024','653000','乌恰县',3)
insert into region values('653100','650000','喀什地区',2)
insert into region values('653101','653100','喀什市',3)
insert into region values('653121','653100','疏附县',3)
insert into region values('653122','653100','疏勒县',3)
insert into region values('653123','653100','英吉沙县',3)
insert into region values('653124','653100','泽普县',3)
insert into region values('653125','653100','莎车县',3)
insert into region values('653126','653100','叶城县',3)
insert into region values('653127','653100','麦盖提县',3)
insert into region values('653128','653100','岳普湖县',3)
insert into region values('653129','653100','伽师县',3)
insert into region values('653130','653100','巴楚县',3)
insert into region values('653131','653100','塔什库尔干塔吉克自治县',3)
insert into region values('653200','650000','和田地区',2)
insert into region values('653201','653200','和田市',3)
insert into region values('653221','653200','和田县',3)
insert into region values('653222','653200','墨玉县',3)
insert into region values('653223','653200','皮山县',3)
insert into region values('653224','653200','洛浦县',3)
insert into region values('653225','653200','策勒县',3)
insert into region values('653226','653200','于田县',3)
insert into region values('653227','653200','民丰县',3)
insert into region values('654000','650000','伊犁哈萨克自治州',2)
insert into region values('654002','654000','伊宁市',3)
insert into region values('654003','654000','奎屯市',3)
insert into region values('654021','654000','伊宁县',3)
insert into region values('654022','654000','察布查尔锡伯自治县',3)
insert into region values('654023','654000','霍城县',3)
insert into region values('654024','654000','巩留县',3)
insert into region values('654025','654000','新源县',3)
insert into region values('654026','654000','昭苏县',3)
insert into region values('654027','654000','特克斯县',3)
insert into region values('654028','654000','尼勒克县',3)
insert into region values('654200','650000','塔城地区',2)
insert into region values('654201','654200','塔城市',3)
insert into region values('654202','654200','乌苏市',3)
insert into region values('654221','654200','额敏县',3)
insert into region values('654223','654200','沙湾县',3)
insert into region values('654224','654200','托里县',3)
insert into region values('654225','654200','裕民县',3)
insert into region values('654226','654200','和布克赛尔蒙古自治县',3)
insert into region values('654300','650000','阿勒泰地区',2)
insert into region values('654301','654300','阿勒泰市',3)
insert into region values('654321','654300','布尔津县',3)
insert into region values('654322','654300','富蕴县',3)
insert into region values('654323','654300','福海县',3)
insert into region values('654324','654300','哈巴河县',3)
insert into region values('654325','654300','青河县',3)
insert into region values('654326','654300','吉木乃县',3)
insert into region values('659000','650000','省直辖行政单位',2)
insert into region values('659001','659000','石河子市',3)
insert into region values('659002','659000','阿拉尔市',3)
insert into region values('659003','659000','图木舒克市',3)
insert into region values('659004','659000','五家渠市',3)
insert into region values('710000','1','台湾省',1)
insert into region values('810000','1','香港特别行政区',1)
insert into region values('820000','1','澳门特别行政区',1)