有關"縣及以上行政區劃代碼"的sql語句。數據來源：http://www.stats.gov.cn/tjbz/xzqhdm/t20130118_402867249.htm。國家統計局於2013年01月18日發公佈。

gistfile1.sql

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