地区areaList.js

这篇博客介绍了如何在项目中引入并使用areaList.js文件,提供了简单的引用步骤。
摘要由CSDN通过智能技术生成

使用时直接引入

import areaList from '@/assets/js/areaList.js';

在这里插入图片描述

areaList.js

export default {
  province_list: {
    110000: '北京市',
    120000: '天津市',
    130000: '河北省',
    140000: '山西省',
    150000: '内蒙古自治区',
    210000: '辽宁省',
    220000: '吉林省',
    230000: '黑龙江省',
    310000: '上海市',
    320000: '江苏省',
    330000: '浙江省',
    340000: '安徽省',
    350000: '福建省',
    360000: '江西省',
    370000: '山东省',
    410000: '河南省',
    420000: '湖北省',
    430000: '湖南省',
    440000: '广东省',
    450000: '广西壮族自治区',
    460000: '海南省',
    500000: '重庆市',
    510000: '四川省',
    520000: '贵州省',
    530000: '云南省',
    540000: '西藏自治区',
    610000: '陕西省',
    620000: '甘肃省',
    630000: '青海省',
    640000: '宁夏回族自治区',
    650000: '新疆维吾尔自治区',
    710000: '台湾省',
    810000: '香港特别行政区',
    820000: '澳门特别行政区',
    900000: '海外',
  },
  city_list: {
    110100: '北京市',
    120100: '天津市',
    130100: '石家庄市',
    130200: '唐山市',
    130300: '秦皇岛市',
    130400: '邯郸市',
    130500: '邢台市',
    130600: '保定市',
    130700: '张家口市',
    130800: '承德市',
    130900: '沧州市',
    131000: '廊坊市',
    131100: '衡水市',
    140100: '太原市',
    140200: '大同市',
    140300: '阳泉市',
    140400: '长治市',
    140500: '晋城市',
    140600: '朔州市',
    140700: '晋中市',
    140800: '运城市',
    140900: '忻州市',
    141000: '临汾市',
    141100: '吕梁市',
    150100: '呼和浩特市',
    150200: '包头市',
    150300: '乌海市',
    150400: '赤峰市',
    150500: '通辽市',
    150600: '鄂尔多斯市',
    150700: '呼伦贝尔市',
    150800: '巴彦淖尔市',
    150900: '乌兰察布市',
    152200: '兴安盟',
    152500: '锡林郭勒盟',
    152900: '阿拉善盟',
    210100: '沈阳市',
    210200: '大连市',
    210300: '鞍山市',
    210400: '抚顺市',
    210500: '本溪市',
    210600: '丹东市',
    210700: '锦州市',
    210800: '营口市',
    210900: '阜新市',
    211000: '辽阳市',
    211100: '盘锦市',
    211200: '铁岭市',
    211300: '朝阳市',
    211400: '葫芦岛市',
    220100: '长春市',
    220200: '吉林市',
    220300: '四平市',
    220400: '辽源市',
    220500: '通化市',
    220600: '白山市',
    220700: '松原市',
    220800: '白城市',
    222400: '延边朝鲜族自治州',
    230100: '哈尔滨市',
    230200: '齐齐哈尔市',
    230300: '鸡西市',
    230400: '鹤岗市',
    230500: '双鸭山市',
    230600: '大庆市',
    230700: '伊春市',
    230800: '佳木斯市',
    230900: '七台河市',
    231000: '牡丹江市',
    231100: '黑河市',
    231200: '绥化市',
    232700: '大兴安岭地区',
    310100: '上海市',
    320100: '南京市',
    320200: '无锡市',
    320300: '徐州市',
    320400: '常州市',
    320500: '苏州市',
    320600: '南通市',
    320700: '连云港市',
    320800: '淮安市',
    320900: '盐城市',
    321000: '扬州市',
    321100: '镇江市',
    321200: '泰州市',
    321300: '宿迁市',
    330100: '杭州市',
    330200: '宁波市',
    330300: '温州市',
    330400: '嘉兴市',
    330500: '湖州市',
    330600: '绍兴市',
    330700: '金华市',
    330800: '衢州市',
    330900: '舟山市',
    331000: '台州市',
    331100: '丽水市',
    340100: '合肥市',
    340200: '芜湖市',
    340300: '蚌埠市',
    340400: '淮南市',
    340500: '马鞍山市',
    340600: '淮北市',
    340700: '铜陵市',
    340800: '安庆市',
    341000: '黄山市',
    341100: '滁州市',
    341200: '阜阳市',
    341300: '宿州市',
    341500: '六安市',
    341600: '亳州市',
    341700: '池州市',
    341800: '宣城市',
    350100: '福州市',
    350200: '厦门市',
    350300: '莆田市',
    350400: '三明市',
    350500: '泉州市',
    350600: '漳州市',
    350700: '南平市',
    350800: '龙岩市',
    350900: '宁德市',
    360100: '南昌市',
    360200: '景德镇市',
    360300: '萍乡市',
    360400: '九江市',
    360500: '新余市',
    360600: '鹰潭市',
    360700: '赣州市',
    360800: '吉安市',
    360900: '宜春市',
    361000: '抚州市',
    361100: '上饶市',
    370100: '济南市',
    370200: '青岛市',
    370300: '淄博市',
    370400: '枣庄市',
    370500: '东营市',
    370600: '烟台市',
    370700: '潍坊市',
    370800: '济宁市',
    370900: '泰安市',
    371000: '威海市',
    371100: '日照市',
    371300: '临沂市',
    371400: '德州市',
    371500: '聊城市',
    371600: '滨州市',
    371700: '菏泽市',
    410100: '郑州市',
    410200: '开封市',
    410300: '洛阳市',
    410400: '平顶山市',
    410500: '安阳市',
    410600: '鹤壁市',
    410700: '新乡市',
    410800: '焦作市',
    410900: '濮阳市',
    411000: '许昌市',
    411100: '漯河市',
    411200: '三门峡市',
    411300: '南阳市',
    411400: '商丘市',
    411500: '信阳市',
    411600: '周口市',
    411700: '驻马店市',
    419000: '省直辖县',
    420100: '武汉市',
    420200: '黄石市',
    420300: '十堰市',
    420500: '宜昌市',
    420600: '襄阳市',
    420700: '鄂州市',
    420800: '荆门市',
    420900: '孝感市',
    421000: '荆州市',
    421100: '黄冈市',
    421200: '咸宁市',
    421300: '随州市',
    422800: '恩施土家族苗族自治州',
    429000: '省直辖县',
    430100: '长沙市',
    430200: '株洲市',
    430300: '湘潭市',
    430400: '衡阳市',
    430500: '邵阳市',
    430600: '岳阳市',
    430700: '常德市',
    430800: '张家界市',
    430900: '益阳市',
    431000: '郴州市',
    431100: '永州市',
    431200: '怀化市',
    431300: '娄底市',
    433100: '湘西土家族苗族自治州',
    440100: '广州市',
    440200: '韶关市',
    440300: '深圳市',
    440400: '珠海市',
    440500: '汕头市',
    440600: '佛山市',
    440700: '江门市',
    440800: '湛江市',
    440900: '茂名市',
    441200: '肇庆市',
    441300: '惠州市',
    441400: '梅州市',
    441500: '汕尾市',
    441600: '河源市',
    441700: '阳江市',
    441800: '清远市',
    441900: '东莞市',
    442000: '中山市',
    445100: '潮州市',
    445200: '揭阳市',
    445300: '云浮市',
    450100: '南宁市',
    450200: '柳州市',
    450300: '桂林市',
    450400: '梧州市',
    450500: '北海市',
    450600: '防城港市',
    450700: '钦州市',
    450800: '贵港市',
    450900: '玉林市',
    451000: '百色市',
    451100: '贺州市',
    451200: '河池市',
    451300: '来宾市',
    451400: '崇左市',
    460100: '海口市',
    460200: '三亚市',
    460300: '三沙市',
    460400: '儋州市',
    469000: '省直辖县',
    500100: '重庆市',
    500200: '县',
    510100: '成都市',
    510300: '自贡市',
    510400: '攀枝花市',
    510500: '泸州市',
    510600: '德阳市',
    510700: '绵阳市',
    510800: '广元市',
    510900: '遂宁市',
    511000: '内江市',
    511100: '乐山市',
    511300: '南充市',
    511400: '眉山市',
    511500: '宜宾市',
    511600: '广安市',
    511700: '达州市',
    511800: '雅安市',
    511900: '巴中市',
    512000: '资阳市',
    513200: '阿坝藏族羌族自治州',
    513300: '甘孜藏族自治州',
    513400: '凉山彝族自治州',
    520100: '贵阳市',
    520200: '六盘水市',
    520300: '遵义市',
    520400: '安顺市',
    520500: '毕节市',
    520600: '铜仁市',
    522300: '黔西南布依族苗族自治州',
    522600: '黔东南苗族侗族自治州',
    522700: '黔南布依族苗族自治州',
    530100: '昆明市',
    530300: '曲靖市',
    530400: '玉溪市',
    530500: '保山市',
    530600: '昭通市',
    530700: '丽江市',
    530800: '普洱市',
    530900: '临沧市',
    532300: '楚雄彝族自治州',
    532500: '红河哈尼族彝族自治州',
    532600: '文山壮族苗族自治州',
    532800: '西双版纳傣族自治州',
    532900: '大理白族自治州',
    533100: '德宏傣族景颇族自治州',
    533300: '怒江傈僳族自治州',
    533400: '迪庆藏族自治州',
    540100: '拉萨市',
    540200: '日喀则市',
    540300: '昌都市',
    540400: '林芝市',
    540500: '山南市',
    540600: '那曲市',
    542500: '阿里地区',
    610100: '西安市',
    610200: '铜川市',
    610300: '宝鸡市',
    610400: '咸阳市',
    610500: '渭南市',
    610600: '延安市',
    610700: '汉中市',
    610800: '榆林市',
    610900: '安康市',
    611000: '商洛市',
    620100: '兰州市',
    620200: '嘉峪关市',
    620300: '金昌市',
    620400: '白银市',
    620500: '天水市',
    620600: '武威市',
    620700: '张掖市',
    620800: '平凉市',
    620900: '酒泉市',
    621000: '庆阳市',
    621100: '定西市',
    621200: '陇南市',
    622900: '临夏回族自治州',
    623000: '甘南藏族自治州',
    630100: '西宁市',
    630200: '海东市',
    632200: '海北藏族自治州',
    632300: '黄南藏族自治州',
    632500: '海南藏族自治州',
    632600: '果洛藏族自治州',
    632700: '玉树藏族自治州',
    632800: '海西蒙古族藏族自治州',
    640100: '银川市',
    640200: '石嘴山市',
    640300: '吴忠市',
    640400: '固原市',
    640500: '中卫市',
    650100: '乌鲁木齐市',
    650200: '克拉玛依市',
    650400: '吐鲁番市',
    650500: '哈密市',
    652300: '昌吉回族自治州',
    652700: '博尔塔拉蒙古自治州',
    652800: '巴音郭楞蒙古自治州',
    652900: '阿克苏地区',
    653000: '克孜勒苏柯尔克孜自治州',
    653100: '喀什地区',
    653200: '和田地区',
    654000: '伊犁哈萨克自治州',
    654200: '塔城地区',
    654300: '阿勒泰地区',
    659000: '自治区直辖县级行政区划',
    710100: '台北市',
    710200: '高雄市',
    710300: '台南市',
    710400: '台中市',
    710500: '金门县',
    710600: '南投县',
    710700: '基隆市',
    710800: '新竹市',
    710900: '嘉义市',
    711100: '新北市',
    711200: '宜兰县',
    711300: '新竹县',
    711400: '桃园县',
    711500: '苗栗县',
    711700: '彰化县',
    711900: '嘉义县',
    712100: '云林县',
    712400: '屏东县',
    712500: '台东县',
    712600: '花莲县',
    712700: '澎湖县',
    712800: '连江县',
    810100: '香港岛',
    810200: '九龙',
    810300: '新界',
    820100: '澳门半岛',
    820200: '离岛',
    900400: '阿富汗',
    900800: '阿尔巴尼亚',
    901000: '南极洲',
    901200: '阿尔及利亚',
    901600: '美属萨摩亚',
    902000: '安道尔',
    902400: '安哥拉',
    902800: '安提瓜和巴布达',
    903100: '阿塞拜疆',
    903200: '阿根廷',
    903600: '澳大利亚',
    904000: '奥地利',
    904400: '巴哈马',
    904800: '巴林',
    905000: '孟加拉',
    905100: '亚美尼亚',
    905200: '巴巴多斯',
    905600: '比利时',
    906000: '百慕大',
    906400: '不丹',
    906800: '玻利维亚',
    907000: '波黑',
    907200: '博茨瓦纳',
    907400: '布韦岛',
    907600: '巴西',
    908400: '伯利兹',
    908600: '英属印度洋领地',
    909000: '所罗门群岛',
    909200: '英属维尔京群岛',
    909600: '文莱',
    910000: '保加利亚',
    910400: '缅甸',
    910800: '布隆迪',
    911200: '白俄罗斯',
    911600: '柬埔寨',
    912000: '喀麦隆',
    912400: '加拿大',
    913200: '佛得角',
    913600: '开曼群岛',
    914000: '中非',
    914400: '斯里兰卡',
    914800: '乍得',
    915200: '智利',
    916200: '圣诞岛',
    916600: '科科斯群岛',
    917000: '哥伦比亚',
    917400: '科摩罗',
    917500: '马约特',
    917800: '刚果(布)',
    918000: '刚果(金)',
    918400: '库克群岛',
    918800: '哥斯达黎加',
    919100: '克罗地亚',
    919200: '古巴',
    919600: '塞浦路斯',
    920300: '捷克',
    920400: '贝宁',
    920800: '丹麦',
    921200: '多米尼克',
    921400: '多米尼加',
    921800: '厄瓜多尔',
    922200: '萨尔瓦多',
    922600: '赤道几内亚',
    923100: '埃塞俄比亚',
    923200: '厄立特里亚',
    923300: '爱沙尼亚',
    923400: '法罗群岛',
    923800: '马尔维纳斯群岛( 福克兰)',
    923900: '南乔治亚岛和南桑威奇群岛',
    924200: '斐济群岛',
    924600: '芬兰',
    924800: '奥兰群岛',
    925000: '法国',
    925400: '法属圭亚那',
    925800: '法属波利尼西亚',
    926000: '法属南部领地',
    926200: '吉布提',
    926600: '加蓬',
    926800: '格鲁吉亚',
    927000: '冈比亚',
    927500: '巴勒斯坦',
    927600: '德国',
    928800: '加纳',
    929200: '直布罗陀',
    929600: '基里巴斯',
    930000: '希腊',
    930400: '格陵兰',
    930800: '格林纳达',
    931200: '瓜德罗普',
    931600: '关岛',
    932000: '危地马拉',
    932400: '几内亚',
    932800: '圭亚那',
    933200: '海地',
    933400: '赫德岛和麦克唐纳群岛',
    933600: '梵蒂冈',
    934000: '洪都拉斯',
    934800: '匈牙利',
    935200: '冰岛',
    935600: '印度',
    936000: '印尼',
    936400: '伊朗',
    936800: '伊拉克',
    937200: '爱尔兰',
    937600: '以色列',
    938000: '意大利',
    938400: '科特迪瓦',
    938800: '牙买加',
    939200: '日本',
    939800: '哈萨克斯坦',
    940000: '约旦',
    940400: '肯尼亚',
    940800: '朝鲜 北朝鲜',
    941000: '韩国',
    941400: '科威特',
    941700: '吉尔吉斯斯坦',
    941800: '老挝',
    942200: '黎巴嫩',
    942600: '莱索托',
    942800: '拉脱维亚',
    943000: '利比里亚',
    943400: '利比亚',
    943800: '列支敦士登',
    944000: '立陶宛',
    944200: '卢森堡',
    945000: '马达加斯加',
    945400: '马拉维',
    945800: '马来西亚',
    946200: '马尔代夫',
    946600: '马里',
    947000: '马耳他',
    947400: '马提尼克',
    947800: '毛里塔尼亚',
    948000: '毛里求斯',
    948400: '墨西哥',
    949200: '摩纳哥',
    949600: '蒙古国',
    949800: '摩尔多瓦',
    949900: '黑山',
    950000: '蒙塞拉特岛',
    950400: '摩洛哥',
    950800: '莫桑比克',
    951200: '阿曼',
    951600: '纳米比亚',
    952000: '瑙鲁',
    952400: '尼泊尔',
    952800: '荷兰',
    953300: '阿鲁巴',
    953500: '荷兰加勒比区',
    954000: '新喀里多尼亚',
    954800: '瓦努阿图',
    955400: '新西兰',
    955800: '尼加拉瓜',
    956200: '尼日尔',
    956600: '尼日利亚',
    957000: '纽埃',
    957400: '诺福克岛',
    957800: '挪威',
    958000: '北马里亚纳群岛',
    958100: '美国本土外小岛屿',
    958300: '密克罗尼西亚联邦',
    958400: '马绍尔群岛',
    958500: '帕劳',
    958600: '巴基斯坦',
    959100: '巴拿马',
    959800: '巴布亚新几内亚',
    960000: '巴拉圭',
    960400: '秘鲁',
    960800: '菲律宾',
    961200: '皮特凯恩群岛',
    961600: '波兰',
    962000: '葡萄牙',
    962400: '几内亚比绍',
    962600: '东帝汶',
    963000: '波多黎各',
    963400: '卡塔尔',
    963800: '留尼汪',
    964200: '罗马尼亚',
    964300: '俄罗斯',
    964600: '卢旺达',
    965200: '圣巴泰勒米岛',
    965400: '圣赫勒拿',
    965900: '圣基茨和尼维斯',
    966000: '安圭拉',
    966200: '圣卢西亚',
    966300: '法属圣马丁',
    966600: '圣皮埃尔和密克隆',
    967000: '圣文森特和格林纳丁斯',
    967400: '圣马力诺',
    967800: '圣多美和普林西比',
    968200: '沙特阿拉伯',
    968600: '塞内加尔',
    968800: '塞尔维亚',
    969000: '塞舌尔',
    969400: '塞拉利昂',
    970200: '新加坡',
    970300: '斯洛伐克',
    970400: '越南',
    970500: '斯洛文尼亚',
    970600: '索马里',
    971000: '南非',
    971600: '津巴布韦',
    972400: '西班牙',
    972800: '南苏丹',
    972900: '苏丹',
    973200: '西撒哈拉',
    974000: '苏里南',
    974400: '斯瓦尔巴群岛和 扬马延岛',
    974800: '斯威士兰',
    975200: '瑞典',
    975600: '瑞士',
    976000: '叙利亚',
    976200: '塔吉克斯坦',
    976400: '泰国',
    976800: '多哥',
    977200: '托克劳',
    977600: '汤加',
    978000: '特立尼达和多巴哥',
    978400: '阿联酋',
    978800: '突尼斯',
    979200: '土耳其',
    979500: '土库曼斯坦',
    979600: '特克斯和凯科斯群岛',
    979800: '图瓦卢',
    980000: '乌干达',
    980400: '乌克兰',
    980700: '马其顿',
    981800: '埃及',
    982600: '英国',
    983100: '根西岛',
    983200: '泽西岛',
    983300: '马恩岛',
    983400: '坦桑尼亚',
    984000: '美国',
    985000: '美属维尔京群岛',
    985400: '布基纳法索',
    985800: '乌拉圭',
    986000: '乌兹别克斯坦',
    986200: '委内瑞拉',
    987600: '瓦利斯和富图纳',
    988200: '萨摩亚',
    988700: '也门',
    989400: '赞比亚',
  },
  county_list: {
    110101: '东城区',
    110102: '西城区',
    110105: '朝阳区',
    110106: '丰台区',
    110107: '石景山区',
    110108: '海淀区',
    110109: '门头沟区',
    110111: '房山区',
    110112: '通州区',
    110113: '顺义区',
    110114: '昌平区',
    110115: '大兴区',
    110116: '怀柔区',
    110117: '平谷区',
    110118: '密云区',
    110119: '延庆区',
    120101: '和平区',
    120102: '河东区',
    120103: '河西区',
    120104: '南开区',
    120105: '河北区',
    120106: '红桥区',
    120110: '东丽区',
    120111: '西青区',
    120112: '津南区',
    120113: '北辰区',
    120114: '武清区',
    120115: '宝坻区',
    120116: '滨海新区',
    120117: '宁河区',
    120118: '静海区',
    120119: '蓟州区',
    130102: '长安区',
    130104: '桥西区',
    130105: '新华区',
    130107: '井陉矿区',
    130108: '裕华区',
    130109: '藁城区',
    130110: '鹿泉区',
    130111: '栾城区',
    130121: '井陉县',
    130123: '正定县',
    130125: '行唐县',
    130126: '灵寿县',
    130127: '高邑县',
    130128: '深泽县',
    130129: '赞皇县',
    130130: '无极县',
    130131: '平山县',
    130132: '元氏县',
    130133: '赵县',
    130181: '辛集市',
    130183: '晋州市',
    130184: '新乐市',
    130202: '路南区',
    130203: '路北区',
    130204: '古冶区',
    130205: '开平区',
    130207: '丰南区',
    130208: '丰润区',
    130209: '曹妃甸区',
    130224: '滦南县',
    130225: '乐亭县',
    130227: '迁西县',
    130229: '玉田县',
    130281: '遵化市',
    130283: '迁安市',
    130284: '滦州市',
    130302: '海港区',
    130303: '山海关区',
    130304: '北戴河区',
    130306: '抚宁区',
    130321: '青龙满族自治县',
    130322: '昌黎县',
    130324: '卢龙县',
    130390: '经济技术开发区',
    130402: '邯山区',
    130403: '丛台区',
    130404: '复兴区',
    130406: '峰峰矿区',
    130407: '肥乡区',
    130408: '永年区',
    130423: '临漳县',
    130424: '成安县',
    130425: '大名县',
    130426: '涉县',
    130427: '磁县',
    130430: '邱县',
    130431: '鸡泽县',
    130432: '广平县',
    130433: '馆陶县',
    130434: '魏县',
    130435: '曲周县',
    130481: '武安市',
    130502: '桥东区',
    130503: '桥西区',
    130521: '邢台县',
    130522: '临城县',
    130523: '内丘县',
    130524: '柏乡县',
    130525: '隆尧县',
    130526: '任县',
    130527: '南和县',
    130528: '宁晋县',
    130529: '巨鹿县',
    130530: '新河县',
    130531: '广宗县',
    130532: '平乡县',
    130533: '威县',
    130534: '清河县',
    130535: '临西县',
    130581: '南宫市',
    130582: '沙河市',
    130602: '竞秀区',
    130606: '莲池区',
    130607: '满城区',
    130608: '清苑区',
    130609: '徐水区',
    130623: '涞水县',
    130624: '阜平县',
    130626: '定兴县',
    130627: '唐县',
    130628: '高阳县',
    130629: '容城县',
    130630: '涞源县',
    130631: '望都县',
    130632: '安新县',
    130633: '易县',
    130634: '曲阳县',
    130635: '蠡县',
    130636: '顺平县',
    130637: '博野县',
    130638: '雄县',
    130681: '涿州市',
    130682: '定州市',
    130683: '安国市',
    130684: '高碑店市',
    130702: '桥东区',
    130703: '桥西区',
    130705: '宣化区',
    130706: '下花园区',
    130708: '万全区',
    1307
  • 4
    点赞
  • 4
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
中国各省市区代码名称(三级)excel文档,共有3441条数据。已有上下级父子关系,可以直接导入数据库使用。 部分代码如下: CREATE TABLE [dbo].[tb_City]( [RecNo] [int] NOT NULL, [Code] [varchar](50) NULL, [Name] [nvarchar](50) NULL, [ParentNo] [int] NULL, CONSTRAINT [PK_tb_City] PRIMARY KEY CLUSTERED ( [RecNo] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (1, N'110000', N'北京市', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (2, N'110101', N'东城区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (3, N'110102', N'西城区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (4, N'110105', N'朝阳区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (5, N'110106', N'丰台区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (6, N'110107', N'石景山区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (7, N'110108', N'海淀区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (8, N'110109', N'门头沟区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (9, N'110111', N'房山区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (10, N'110112', N'通州区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (11, N'110113', N'顺义区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (12, N'110114', N'昌平区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (13, N'110115', N'大兴区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (14, N'110116', N'怀柔区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (15, N'110117', N'平谷区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (16, N'110118', N'密云区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (17, N'110119', N'延庆区', 1) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (18, N'120000', N'天津市', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (19, N'120101', N'和平区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (20, N'120102', N'河东区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (21, N'120103', N'河西区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (22, N'120104', N'南开区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (23, N'120105', N'河北区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (24, N'120106', N'红桥区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (25, N'120110', N'东丽区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (26, N'120111', N'西青区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (27, N'120112', N'津南区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (28, N'120113', N'北辰区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (29, N'120114', N'武清区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (30, N'120115', N'宝坻区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (31, N'120116', N'滨海新区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (32, N'120117', N'宁河区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (33, N'120118', N'静海区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (34, N'120119', N'蓟州区', 18) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (35, N'130000', N'河北省', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (36, N'130100', N'石家庄市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (37, N'130102', N'长安区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (38, N'130104', N'桥西区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (39, N'130105', N'新华区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (40, N'130107', N'井陉矿区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (41, N'130108', N'裕华区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (42, N'130109', N'藁城区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (43, N'130110', N'鹿泉区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (44, N'130111', N'栾城区', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (45, N'130121', N'井陉县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (46, N'130123', N'正定县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (47, N'130125', N'行唐县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (48, N'130126', N'灵寿县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (49, N'130127', N'高邑县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (50, N'130128', N'深泽县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (51, N'130129', N'赞皇县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (52, N'130130', N'无极县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (53, N'130131', N'平山县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (54, N'130132', N'元氏县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (55, N'130133', N'赵县', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (56, N'130181', N'辛集市', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (57, N'130183', N'晋州市', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (58, N'130184', N'新乐市', 36) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (59, N'130200', N'唐山市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (60, N'130202', N'路南区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (61, N'130203', N'路北区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (62, N'130204', N'古冶区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (63, N'130205', N'开平区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (64, N'130207', N'丰南区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (65, N'130208', N'丰润区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (66, N'130209', N'曹妃甸区', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (67, N'130223', N'滦县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (68, N'130224', N'滦南县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (69, N'130225', N'乐亭县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (70, N'130227', N'迁西县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (71, N'130229', N'玉田县', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (72, N'130281', N'遵化市', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (73, N'130283', N'迁安市', 59) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (74, N'130300', N'秦皇岛市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (75, N'130302', N'海港区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (76, N'130303', N'山海关区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (77, N'130304', N'北戴河区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (78, N'130306', N'抚宁区', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (79, N'130321', N'青龙满族自治县', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (80, N'130322', N'昌黎县', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (81, N'130324', N'卢龙县', 74) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (82, N'130400', N'邯郸市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (83, N'130402', N'邯山区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (84, N'130403', N'丛台区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (85, N'130404', N'复兴区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (86, N'130406', N'峰峰矿区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (87, N'130407', N'肥乡区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (88, N'130408', N'永年区', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (89, N'130423', N'临漳县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (90, N'130424', N'成安县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (91, N'130425', N'大名县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (92, N'130426', N'涉县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (93, N'130427', N'磁县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (94, N'130430', N'邱县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (95, N'130431', N'鸡泽县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (96, N'130432', N'广平县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (97, N'130433', N'馆陶县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (98, N'130434', N'魏县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (99, N'130435', N'曲周县', 82) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (100, N'130481', N'武安市', 82) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (101, N'130500', N'邢台市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (102, N'130502', N'桥东区', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (103, N'130503', N'桥西区', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (104, N'130521', N'邢台县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (105, N'130522', N'临城县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (106, N'130523', N'内丘县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (107, N'130524', N'柏乡县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (108, N'130525', N'隆尧县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (109, N'130526', N'任县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (110, N'130527', N'南和县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (111, N'130528', N'宁晋县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (112, N'130529', N'巨鹿县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (113, N'130530', N'新河县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (114, N'130531', N'广宗县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (115, N'130532', N'平乡县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (116, N'130533', N'威县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (117, N'130534', N'清河县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (118, N'130535', N'临西县', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (119, N'130581', N'南宫市', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (120, N'130582', N'沙河市', 101) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (121, N'130600', N'保定市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (122, N'130602', N'竞秀区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (123, N'130606', N'莲池区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (124, N'130607', N'满城区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (125, N'130608', N'清苑区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (126, N'130609', N'徐水区', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (127, N'130623', N'涞水县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (128, N'130624', N'阜平县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (129, N'130626', N'定兴县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (130, N'130627', N'唐县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (131, N'130628', N'高阳县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (132, N'130629', N'容城县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (133, N'130630', N'涞源县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (134, N'130631', N'望都县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (135, N'130632', N'安新县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (136, N'130633', N'易县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (137, N'130634', N'曲阳县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (138, N'130635', N'蠡县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (139, N'130636', N'顺平县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (140, N'130637', N'博野县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (141, N'130638', N'雄县', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (142, N'130681', N'涿州市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (143, N'130682', N'定州市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (144, N'130683', N'安国市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (145, N'130684', N'高碑店市', 121) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (146, N'130700', N'张家口市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (147, N'130702', N'桥东区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (148, N'130703', N'桥西区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (149, N'130705', N'宣化区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (150, N'130706', N'下花园区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (151, N'130708', N'万全区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (152, N'130709', N'崇礼区', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (153, N'130722', N'张北县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (154, N'130723', N'康保县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (155, N'130724', N'沽源县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (156, N'130725', N'尚义县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (157, N'130726', N'蔚县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (158, N'130727', N'阳原县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (159, N'130728', N'怀安县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (160, N'130730', N'怀来县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (161, N'130731', N'涿鹿县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (162, N'130732', N'赤城县', 146) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (163, N'130800', N'承德市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (164, N'130802', N'双桥区', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (165, N'130803', N'双滦区', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (166, N'130804', N'鹰手营子矿区', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (167, N'130821', N'承德县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (168, N'130822', N'兴隆县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (169, N'130824', N'滦平县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (170, N'130825', N'隆化县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (171, N'130826', N'丰宁满族自治县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (172, N'130827', N'宽城满族自治县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (173, N'130828', N'围场满族蒙古族自治县', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (174, N'130881', N'平泉市', 163) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (175, N'130900', N'沧州市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (176, N'130902', N'新华区', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (177, N'130903', N'运河区', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (178, N'130921', N'沧县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (179, N'130922', N'青县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (180, N'130923', N'东光县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (181, N'130924', N'海兴县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (182, N'130925', N'盐山县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (183, N'130926', N'肃宁县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (184, N'130927', N'南皮县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (185, N'130928', N'吴桥县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (186, N'130929', N'献县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (187, N'130930', N'孟村回族自治县', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (188, N'130981', N'泊头市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (189, N'130982', N'任丘市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (190, N'130983', N'黄骅市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (191, N'130984', N'河间市', 175) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (192, N'131000', N'廊坊市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (193, N'131002', N'安次区', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (194, N'131003', N'广阳区', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (195, N'131022', N'固安县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (196, N'131023', N'永清县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (197, N'131024', N'香河县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (198, N'131025', N'大城县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (199, N'131026', N'文安县', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (200, N'131028', N'大厂回族自治县', 192) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (201, N'131081', N'霸州市', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (202, N'131082', N'三河市', 192) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (203, N'131100', N'衡水市', 35) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (204, N'131102', N'桃城区', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (205, N'131103', N'冀州区', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (206, N'131121', N'枣强县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (207, N'131122', N'武邑县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (208, N'131123', N'武强县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (209, N'131124', N'饶阳县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (210, N'131125', N'安平县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (211, N'131126', N'故城县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (212, N'131127', N'景县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (213, N'131128', N'阜城县', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (214, N'131182', N'深州市', 203) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (215, N'140000', N'山西省', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (216, N'140100', N'太原市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (217, N'140105', N'小店区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (218, N'140106', N'迎泽区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (219, N'140107', N'杏花岭区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (220, N'140108', N'尖草坪区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (221, N'140109', N'万柏林区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (222, N'140110', N'晋源区', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (223, N'140121', N'清徐县', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (224, N'140122', N'阳曲县', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (225, N'140123', N'娄烦县', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (226, N'140181', N'古交市', 216) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (227, N'140200', N'大同市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (228, N'140202', N'城区', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (229, N'140203', N'矿区', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (230, N'140211', N'南郊区', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (231, N'140212', N'新荣区', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (232, N'140221', N'阳高县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (233, N'140222', N'天镇县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (234, N'140223', N'广灵县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (235, N'140224', N'灵丘县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (236, N'140225', N'浑源县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (237, N'140226', N'左云县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (238, N'140227', N'大同县', 227) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (239, N'140300', N'阳泉市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (240, N'140302', N'城区', 239) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (241, N'140303', N'矿区', 239) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (242, N'140311', N'郊区', 239) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (243, N'140321', N'平定县', 239) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (244, N'140322', N'盂县', 239) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (245, N'140400', N'长治市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (246, N'140402', N'城区', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (247, N'140411', N'郊区', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (248, N'140421', N'长治县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (249, N'140423', N'襄垣县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (250, N'140424', N'屯留县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (251, N'140425', N'平顺县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (252, N'140426', N'黎城县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (253, N'140427', N'壶关县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (254, N'140428', N'长子县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (255, N'140429', N'武乡县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (256, N'140430', N'沁县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (257, N'140431', N'沁源县', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (258, N'140481', N'潞城市', 245) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (259, N'140500', N'晋城市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (260, N'140502', N'城区', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (261, N'140521', N'沁水县', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (262, N'140522', N'阳城县', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (263, N'140524', N'陵川县', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (264, N'140525', N'泽州县', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (265, N'140581', N'高平市', 259) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (266, N'140600', N'朔州市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (267, N'140602', N'朔城区', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (268, N'140603', N'平鲁区', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (269, N'140621', N'山阴县', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (270, N'140622', N'应县', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (271, N'140623', N'右玉县', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (272, N'140624', N'怀仁县', 266) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (273, N'140700', N'晋中市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (274, N'140702', N'榆次区', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (275, N'140721', N'榆社县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (276, N'140722', N'左权县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (277, N'140723', N'和顺县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (278, N'140724', N'昔阳县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (279, N'140725', N'寿阳县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (280, N'140726', N'太谷县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (281, N'140727', N'祁县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (282, N'140728', N'平遥县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (283, N'140729', N'灵石县', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (284, N'140781', N'介休市', 273) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (285, N'140800', N'运城市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (286, N'140802', N'盐湖区', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (287, N'140821', N'临猗县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (288, N'140822', N'万荣县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (289, N'140823', N'闻喜县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (290, N'140824', N'稷山县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (291, N'140825', N'新绛县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (292, N'140826', N'绛县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (293, N'140827', N'垣曲县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (294, N'140828', N'夏县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (295, N'140829', N'平陆县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (296, N'140830', N'芮城县', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (297, N'140881', N'永济市', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (298, N'140882', N'河津市', 285) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (299, N'140900', N'忻州市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (300, N'140902', N'忻府区', 299) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (301, N'140921', N'定襄县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (302, N'140922', N'五台县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (303, N'140923', N'代县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (304, N'140924', N'繁峙县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (305, N'140925', N'宁武县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (306, N'140926', N'静乐县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (307, N'140927', N'神池县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (308, N'140928', N'五寨县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (309, N'140929', N'岢岚县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (310, N'140930', N'河曲县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (311, N'140931', N'保德县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (312, N'140932', N'偏关县', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (313, N'140981', N'原平市', 299) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (314, N'141000', N'临汾市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (315, N'141002', N'尧都区', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (316, N'141021', N'曲沃县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (317, N'141022', N'翼城县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (318, N'141023', N'襄汾县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (319, N'141024', N'洪洞县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (320, N'141025', N'古县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (321, N'141026', N'安泽县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (322, N'141027', N'浮山县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (323, N'141028', N'吉县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (324, N'141029', N'乡宁县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (325, N'141030', N'大宁县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (326, N'141031', N'隰县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (327, N'141032', N'永和县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (328, N'141033', N'蒲县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (329, N'141034', N'汾西县', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (330, N'141081', N'侯马市', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (331, N'141082', N'霍州市', 314) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (332, N'141100', N'吕梁市', 215) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (333, N'141102', N'离石区', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (334, N'141121', N'文水县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (335, N'141122', N'交城县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (336, N'141123', N'兴县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (337, N'141124', N'临县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (338, N'141125', N'柳林县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (339, N'141126', N'石楼县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (340, N'141127', N'岚县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (341, N'141128', N'方山县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (342, N'141129', N'中阳县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (343, N'141130', N'交口县', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (344, N'141181', N'孝义市', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (345, N'141182', N'汾阳市', 332) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (346, N'150000', N'内蒙古自治区', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (347, N'150100', N'呼和浩特市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (348, N'150102', N'新城区', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (349, N'150103', N'回民区', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (350, N'150104', N'玉泉区', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (351, N'150105', N'赛罕区', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (352, N'150121', N'土默特左旗', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (353, N'150122', N'托克托县', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (354, N'150123', N'和林格尔县', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (355, N'150124', N'清水河县', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (356, N'150125', N'武川县', 347) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (357, N'150200', N'包头市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (358, N'150202', N'东河区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (359, N'150203', N'昆都仑区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (360, N'150204', N'青山区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (361, N'150205', N'石拐区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (362, N'150206', N'白云鄂博矿区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (363, N'150207', N'九原区', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (364, N'150221', N'土默特右旗', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (365, N'150222', N'固阳县', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (366, N'150223', N'达尔罕茂明安联合旗', 357) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (367, N'150300', N'乌海市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (368, N'150302', N'海勃湾区', 367) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (369, N'150303', N'海南区', 367) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (370, N'150304', N'乌达区', 367) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (371, N'150400', N'赤峰市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (372, N'150402', N'红山区', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (373, N'150403', N'元宝山区', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (374, N'150404', N'松山区', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (375, N'150421', N'阿鲁科尔沁旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (376, N'150422', N'巴林左旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (377, N'150423', N'巴林右旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (378, N'150424', N'林西县', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (379, N'150425', N'克什克腾旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (380, N'150426', N'翁牛特旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (381, N'150428', N'喀喇沁旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (382, N'150429', N'宁城县', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (383, N'150430', N'敖汉旗', 371) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (384, N'150500', N'通辽市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (385, N'150502', N'科尔沁区', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (386, N'150521', N'科尔沁左翼中旗', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (387, N'150522', N'科尔沁左翼后旗', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (388, N'150523', N'开鲁县', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (389, N'150524', N'库伦旗', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (390, N'150525', N'奈曼旗', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (391, N'150526', N'扎鲁特旗', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (392, N'150581', N'霍林郭勒市', 384) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (393, N'150600', N'鄂尔多斯市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (394, N'150602', N'东胜区', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (395, N'150603', N'康巴什区', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (396, N'150621', N'达拉特旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (397, N'150622', N'准格尔旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (398, N'150623', N'鄂托克前旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (399, N'150624', N'鄂托克旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (400, N'150625', N'杭锦旗', 393) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (401, N'150626', N'乌审旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (402, N'150627', N'伊金霍洛旗', 393) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (403, N'150700', N'呼伦贝尔市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (404, N'150702', N'海拉尔区', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (405, N'150703', N'扎赉诺尔区', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (406, N'150721', N'阿荣旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (407, N'150722', N'莫力达瓦达斡尔族自治旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (408, N'150723', N'鄂伦春自治旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (409, N'150724', N'鄂温克族自治旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (410, N'150725', N'陈巴尔虎旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (411, N'150726', N'新巴尔虎左旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (412, N'150727', N'新巴尔虎右旗', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (413, N'150781', N'满洲里市', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (414, N'150782', N'牙克石市', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (415, N'150783', N'扎兰屯市', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (416, N'150784', N'额尔古纳市', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (417, N'150785', N'根河市', 403) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (418, N'150800', N'巴彦淖尔市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (419, N'150802', N'临河区', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (420, N'150821', N'五原县', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (421, N'150822', N'磴口县', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (422, N'150823', N'乌拉特前旗', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (423, N'150824', N'乌拉特中旗', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (424, N'150825', N'乌拉特后旗', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (425, N'150826', N'杭锦后旗', 418) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (426, N'150900', N'乌兰察布市', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (427, N'150902', N'集宁区', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (428, N'150921', N'卓资县', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (429, N'150922', N'化德县', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (430, N'150923', N'商都县', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (431, N'150924', N'兴和县', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (432, N'150925', N'凉城县', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (433, N'150926', N'察哈尔右翼前旗', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (434, N'150927', N'察哈尔右翼中旗', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (435, N'150928', N'察哈尔右翼后旗', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (436, N'150929', N'四子王旗', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (437, N'150981', N'丰镇市', 426) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (438, N'152200', N'兴安盟', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (439, N'152201', N'乌兰浩特市', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (440, N'152202', N'阿尔山市', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (441, N'152221', N'科尔沁右翼前旗', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (442, N'152222', N'科尔沁右翼中旗', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (443, N'152223', N'扎赉特旗', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (444, N'152224', N'突泉县', 438) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (445, N'152500', N'锡林郭勒盟', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (446, N'152501', N'二连浩特市', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (447, N'152502', N'锡林浩特市', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (448, N'152522', N'阿巴嘎旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (449, N'152523', N'苏尼特左旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (450, N'152524', N'苏尼特右旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (451, N'152525', N'东乌珠穆沁旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (452, N'152526', N'西乌珠穆沁旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (453, N'152527', N'太仆寺旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (454, N'152528', N'镶黄旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (455, N'152529', N'正镶白旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (456, N'152530', N'正蓝旗', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (457, N'152531', N'多伦县', 445) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (458, N'152900', N'阿拉善盟', 346) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (459, N'152921', N'阿拉善左旗', 458) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (460, N'152922', N'阿拉善右旗', 458) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (461, N'152923', N'额济纳旗', 458) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (462, N'210000', N'辽宁省', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (463, N'210100', N'沈阳市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (464, N'210102', N'和平区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (465, N'210103', N'沈河区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (466, N'210104', N'大东区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (467, N'210105', N'皇姑区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (468, N'210106', N'铁西区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (469, N'210111', N'苏家屯区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (470, N'210112', N'浑南区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (471, N'210113', N'沈北新区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (472, N'210114', N'于洪区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (473, N'210115', N'辽中区', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (474, N'210123', N'康平县', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (475, N'210124', N'法库县', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (476, N'210181', N'新民市', 463) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (477, N'210200', N'大连市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (478, N'210202', N'中山区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (479, N'210203', N'西岗区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (480, N'210204', N'沙河口区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (481, N'210211', N'甘井子区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (482, N'210212', N'旅顺口区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (483, N'210213', N'金州区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (484, N'210214', N'普兰店区', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (485, N'210224', N'长海县', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (486, N'210281', N'瓦房店市', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (487, N'210283', N'庄河市', 477) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (488, N'210300', N'鞍山市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (489, N'210302', N'铁东区', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (490, N'210303', N'铁西区', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (491, N'210304', N'立山区', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (492, N'210311', N'千山区', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (493, N'210321', N'台安县', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (494, N'210323', N'岫岩满族自治县', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (495, N'210381', N'海城市', 488) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (496, N'210400', N'抚顺市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (497, N'210402', N'新抚区', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (498, N'210403', N'东洲区', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (499, N'210404', N'望花区', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (500, N'210411', N'顺城区', 496) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (501, N'210421', N'抚顺县', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (502, N'210422', N'新宾满族自治县', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (503, N'210423', N'清原满族自治县', 496) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (504, N'210500', N'本溪市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (505, N'210502', N'平山区', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (506, N'210503', N'溪湖区', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (507, N'210504', N'明山区', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (508, N'210505', N'南芬区', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (509, N'210521', N'本溪满族自治县', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (510, N'210522', N'桓仁满族自治县', 504) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (511, N'210600', N'丹东市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (512, N'210602', N'元宝区', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (513, N'210603', N'振兴区', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (514, N'210604', N'振安区', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (515, N'210624', N'宽甸满族自治县', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (516, N'210681', N'东港市', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (517, N'210682', N'凤城市', 511) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (518, N'210700', N'锦州市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (519, N'210702', N'古塔区', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (520, N'210703', N'凌河区', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (521, N'210711', N'太和区', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (522, N'210726', N'黑山县', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (523, N'210727', N'义县', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (524, N'210781', N'凌海市', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (525, N'210782', N'北镇市', 518) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (526, N'210800', N'营口市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (527, N'210802', N'站前区', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (528, N'210803', N'西市区', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (529, N'210804', N'鲅鱼圈区', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (530, N'210811', N'老边区', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (531, N'210881', N'盖州市', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (532, N'210882', N'大石桥市', 526) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (533, N'210900', N'阜新市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (534, N'210902', N'海州区', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (535, N'210903', N'新邱区', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (536, N'210904', N'太平区', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (537, N'210905', N'清河门区', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (538, N'210911', N'细河区', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (539, N'210921', N'阜新蒙古族自治县', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (540, N'210922', N'彰武县', 533) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (541, N'211000', N'辽阳市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (542, N'211002', N'白塔区', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (543, N'211003', N'文圣区', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (544, N'211004', N'宏伟区', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (545, N'211005', N'弓长岭区', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (546, N'211011', N'太子河区', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (547, N'211021', N'辽阳县', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (548, N'211081', N'灯塔市', 541) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (549, N'211100', N'盘锦市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (550, N'211102', N'双台子区', 549) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (551, N'211103', N'兴隆台区', 549) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (552, N'211104', N'大洼区', 549) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (553, N'211122', N'盘山县', 549) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (554, N'211200', N'铁岭市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (555, N'211202', N'银州区', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (556, N'211204', N'清河区', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (557, N'211221', N'铁岭县', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (558, N'211223', N'西丰县', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (559, N'211224', N'昌图县', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (560, N'211281', N'调兵山市', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (561, N'211282', N'开原市', 554) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (562, N'211300', N'朝阳市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (563, N'211302', N'双塔区', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (564, N'211303', N'龙城区', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (565, N'211321', N'朝阳县', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (566, N'211322', N'建平县', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (567, N'211324', N'喀喇沁左翼蒙古族自治县', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (568, N'211381', N'北票市', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (569, N'211382', N'凌源市', 562) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (570, N'211400', N'葫芦岛市', 462) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (571, N'211402', N'连山区', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (572, N'211403', N'龙港区', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (573, N'211404', N'南票区', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (574, N'211421', N'绥中县', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (575, N'211422', N'建昌县', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (576, N'211481', N'兴城市', 570) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (577, N'220000', N'吉林省', 0) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (578, N'220100', N'长春市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (579, N'220102', N'南关区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (580, N'220103', N'宽城区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (581, N'220104', N'朝阳区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (582, N'220105', N'二道区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (583, N'220106', N'绿园区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (584, N'220112', N'双阳区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (585, N'220113', N'九台区', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (586, N'220122', N'农安县', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (587, N'220182', N'榆树市', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (588, N'220183', N'德惠市', 578) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (589, N'220200', N'吉林市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (590, N'220202', N'昌邑区', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (591, N'220203', N'龙潭区', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (592, N'220204', N'船营区', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (593, N'220211', N'丰满区', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (594, N'220221', N'永吉县', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (595, N'220281', N'蛟河市', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (596, N'220282', N'桦甸市', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (597, N'220283', N'舒兰市', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (598, N'220284', N'磐石市', 589) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (599, N'220300', N'四平市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (600, N'220302', N'铁西区', 599) GO INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (601, N'220303', N'铁东区', 599) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (602, N'220322', N'梨树县', 599) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (603, N'220323', N'伊通满族自治县', 599) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (604, N'220381', N'公主岭市', 599) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (605, N'220382', N'双辽市', 599) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (606, N'220400', N'辽源市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (607, N'220402', N'龙山区', 606) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (608, N'220403', N'西安区', 606) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (609, N'220421', N'东丰县', 606) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (610, N'220422', N'东辽县', 606) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (611, N'220500', N'通化市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (612, N'220502', N'东昌区', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (613, N'220503', N'二道江区', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (614, N'220521', N'通化县', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (615, N'220523', N'辉南县', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (616, N'220524', N'柳河县', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (617, N'220581', N'梅河口市', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (618, N'220582', N'集安市', 611) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (619, N'220600', N'白山市', 577) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (620, N'220602', N'浑江区', 619) INSERT [dbo].[tb_City] ([RecNo], [Code], [Name], [ParentNo]) VALUES (621, N'220605', N'江源区', 619) INSERT [dbo
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值