Administratives-China(Street)-0.sql

/*
 *   _____                                ______
 *  /_   /  ____  ____  ____  _________  / __/ /_
 *    / /  / __ \/ __ \/ __ \/ ___/ __ \/ /_/ __/
 *   / /__/ /_/ / / / / /_/ /\_ \/ /_/ / __/ /_
 *  /____/\____/_/ /_/\__  /____/\____/_/  \__/
 *                   /____/
 *
 * Authors:
 *   钟峰(Popeye Zhong) <zongsoft@qq.com>
 *
 * Copyright (C) 2015-2019 Zongsoft Studio. All rights reserved.
 *
 * MIT License
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:

 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.

 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 */

/*
 * 《2015年统计用区划代码和城乡划分代码（截止2015年09月30日）》 即（街道、社区、镇、乡/村）行政区划信息
 * 数据来源：中华人民共和国国家统计局（http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2015/index.html）
 * 数据范围：北京市(11)、天津市(12)、上海市(31)、重庆市(50)。
 */

/* 北京市 */

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 01, 001, '东华门街道'),
	(11, 01, 01, 002, '景山街道'),
	(11, 01, 01, 003, '交道口街道'),
	(11, 01, 01, 004, '安定门街道'),
	(11, 01, 01, 005, '北新桥街道'),
	(11, 01, 01, 006, '东四街道'),
	(11, 01, 01, 007, '朝阳门街道'),
	(11, 01, 01, 008, '建国门街道'),
	(11, 01, 01, 009, '东直门街道'),
	(11, 01, 01, 010, '和平里街道'),
	(11, 01, 01, 011, '前门街道'),
	(11, 01, 01, 012, '崇文门外街道'),
	(11, 01, 01, 013, '东花市街道'),
	(11, 01, 01, 014, '龙潭街道'),
	(11, 01, 01, 015, '体育馆路街道'),
	(11, 01, 01, 016, '天坛街道'),
	(11, 01, 01, 017, '永定门外街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 02, 001, '西长安街街道'),
	(11, 01, 02, 003, '新街口街道'),
	(11, 01, 02, 007, '月坛街道'),
	(11, 01, 02, 009, '展览路街道'),
	(11, 01, 02, 010, '德胜街道'),
	(11, 01, 02, 011, '金融街街道'),
	(11, 01, 02, 012, '什刹海街道'),
	(11, 01, 02, 013, '大栅栏街道'),
	(11, 01, 02, 014, '天桥街道'),
	(11, 01, 02, 015, '椿树街道'),
	(11, 01, 02, 016, '陶然亭街道'),
	(11, 01, 02, 017, '广安门内街道'),
	(11, 01, 02, 018, '牛街街道'),
	(11, 01, 02, 019, '白纸坊街道'),
	(11, 01, 02, 020, '广安门外街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 05, 001, '建外街道'),
	(11, 01, 05, 002, '朝外街道'),
	(11, 01, 05, 003, '呼家楼街道'),
	(11, 01, 05, 004, '三里屯街道'),
	(11, 01, 05, 005, '左家庄街道'),
	(11, 01, 05, 006, '香河园街道'),
	(11, 01, 05, 007, '和平街街道'),
	(11, 01, 05, 008, '安贞街道'),
	(11, 01, 05, 009, '亚运村街道'),
	(11, 01, 05, 010, '小关街道'),
	(11, 01, 05, 011, '酒仙桥街道'),
	(11, 01, 05, 012, '麦子店街道'),
	(11, 01, 05, 013, '团结湖街道'),
	(11, 01, 05, 014, '六里屯街道'),
	(11, 01, 05, 015, '八里庄街道'),
	(11, 01, 05, 016, '双井街道'),
	(11, 01, 05, 017, '劲松街道'),
	(11, 01, 05, 018, '潘家园街道'),
	(11, 01, 05, 019, '垡头街道'),
	(11, 01, 05, 021, '南磨房地区'),
	(11, 01, 05, 022, '高碑店地区'),
	(11, 01, 05, 023, '将台地区'),
	(11, 01, 05, 024, '太阳宫地区'),
	(11, 01, 05, 025, '大屯街道'),
	(11, 01, 05, 026, '望京街道'),
	(11, 01, 05, 027, '小红门地区'),
	(11, 01, 05, 028, '十八里店地区'),
	(11, 01, 05, 029, '平房地区'),
	(11, 01, 05, 030, '东风地区'),
	(11, 01, 05, 031, '奥运村街道'),
	(11, 01, 05, 032, '来广营地区'),
	(11, 01, 05, 033, '常营地区'),
	(11, 01, 05, 034, '三间房地区'),
	(11, 01, 05, 035, '管庄地区'),
	(11, 01, 05, 036, '金盏地区'),
	(11, 01, 05, 037, '孙河地区'),
	(11, 01, 05, 038, '崔各庄地区'),
	(11, 01, 05, 039, '东坝地区'),
	(11, 01, 05, 040, '黑庄户地区'),
	(11, 01, 05, 041, '豆各庄地区'),
	(11, 01, 05, 042, '王四营地区'),
	(11, 01, 05, 043, '东湖街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 06, 001, '右安门街道'),
	(11, 01, 06, 002, '太平桥街道'),
	(11, 01, 06, 003, '西罗园街道'),
	(11, 01, 06, 004, '大红门街道'),
	(11, 01, 06, 005, '南苑街道'),
	(11, 01, 06, 006, '东高地街道'),
	(11, 01, 06, 007, '东铁匠营街道'),
	(11, 01, 06, 008, '卢沟桥街道'),
	(11, 01, 06, 009, '丰台街道'),
	(11, 01, 06, 010, '新村街道'),
	(11, 01, 06, 011, '长辛店街道'),
	(11, 01, 06, 012, '云岗街道'),
	(11, 01, 06, 013, '方庄地区'),
	(11, 01, 06, 014, '宛平城地区'),
	(11, 01, 06, 015, '马家堡街道'),
	(11, 01, 06, 016, '和义街道'),
	(11, 01, 06, 017, '卢沟桥地区'),
	(11, 01, 06, 018, '花乡地区'),
	(11, 01, 06, 019, '南苑地区'),
	(11, 01, 06, 100, '长辛店镇'),
	(11, 01, 06, 101, '王佐镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 07, 001, '八宝山街道'),
	(11, 01, 07, 002, '老山街道'),
	(11, 01, 07, 003, '八角街道'),
	(11, 01, 07, 004, '古城街道'),
	(11, 01, 07, 005, '苹果园街道'),
	(11, 01, 07, 006, '金顶街街道'),
	(11, 01, 07, 009, '广宁街道'),
	(11, 01, 07, 010, '五里坨街道'),
	(11, 01, 07, 011, '鲁谷街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 08, 001, '万寿路街道'),
	(11, 01, 08, 002, '永定路街道'),
	(11, 01, 08, 003, '羊坊店街道'),
	(11, 01, 08, 004, '甘家口街道'),
	(11, 01, 08, 005, '八里庄街道'),
	(11, 01, 08, 006, '紫竹院街道'),
	(11, 01, 08, 007, '北下关街道'),
	(11, 01, 08, 008, '北太平庄街道'),
	(11, 01, 08, 010, '学院路街道'),
	(11, 01, 08, 011, '中关村街道'),
	(11, 01, 08, 012, '海淀街道'),
	(11, 01, 08, 013, '青龙桥街道'),
	(11, 01, 08, 014, '清华园街道'),
	(11, 01, 08, 015, '燕园街道'),
	(11, 01, 08, 016, '香山街道'),
	(11, 01, 08, 017, '清河街道'),
	(11, 01, 08, 018, '花园路街道'),
	(11, 01, 08, 019, '西三旗街道'),
	(11, 01, 08, 020, '马连洼街道'),
	(11, 01, 08, 021, '田村路街道'),
	(11, 01, 08, 022, '上地街道'),
	(11, 01, 08, 023, '万柳地区'),
	(11, 01, 08, 024, '东升地区'),
	(11, 01, 08, 025, '曙光街道'),
	(11, 01, 08, 026, '温泉地区'),
	(11, 01, 08, 027, '四季青地区'),
	(11, 01, 08, 028, '西北旺地区'),
	(11, 01, 08, 029, '苏家坨地区'),
	(11, 01, 08, 030, '上庄地区');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 09, 001, '大峪街道'),
	(11, 01, 09, 002, '城子街道'),
	(11, 01, 09, 003, '东辛房街道'),
	(11, 01, 09, 004, '大台街道'),
	(11, 01, 09, 005, '王平地区'),
	(11, 01, 09, 006, '永定地区'),
	(11, 01, 09, 007, '龙泉地区'),
	(11, 01, 09, 101, '潭柘寺镇'),
	(11, 01, 09, 104, '军庄镇'),
	(11, 01, 09, 105, '雁翅镇'),
	(11, 01, 09, 106, '斋堂镇'),
	(11, 01, 09, 107, '清水镇'),
	(11, 01, 09, 108, '妙峰山镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 11, 001, '城关街道'),
	(11, 01, 11, 002, '新镇街道'),
	(11, 01, 11, 004, '向阳街道'),
	(11, 01, 11, 005, '东风街道'),
	(11, 01, 11, 006, '迎风街道'),
	(11, 01, 11, 007, '星城街道'),
	(11, 01, 11, 008, '良乡地区'),
	(11, 01, 11, 009, '周口店地区'),
	(11, 01, 11, 010, '琉璃河地区'),
	(11, 01, 11, 011, '拱辰街道'),
	(11, 01, 11, 012, '西潞街道'),
	(11, 01, 11, 101, '阎村镇'),
	(11, 01, 11, 103, '窦店镇'),
	(11, 01, 11, 104, '石楼镇'),
	(11, 01, 11, 105, '长阳镇'),
	(11, 01, 11, 107, '河北镇'),
	(11, 01, 11, 108, '长沟镇'),
	(11, 01, 11, 109, '大石窝镇'),
	(11, 01, 11, 110, '张坊镇'),
	(11, 01, 11, 111, '十渡镇'),
	(11, 01, 11, 112, '青龙湖镇'),
	(11, 01, 11, 115, '韩村河镇'),
	(11, 01, 11, 208, '霞云岭乡'),
	(11, 01, 11, 209, '南窖乡'),
	(11, 01, 11, 210, '佛子庄乡'),
	(11, 01, 11, 211, '大安山乡'),
	(11, 01, 11, 212, '史家营乡'),
	(11, 01, 11, 213, '蒲洼乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 12, 001, '中仓街道'),
	(11, 01, 12, 002, '新华街道'),
	(11, 01, 12, 003, '北苑街道'),
	(11, 01, 12, 004, '玉桥街道'),
	(11, 01, 12, 005, '永顺地区'),
	(11, 01, 12, 006, '梨园地区'),
	(11, 01, 12, 104, '宋庄镇'),
	(11, 01, 12, 105, '张家湾镇'),
	(11, 01, 12, 106, '漷县镇'),
	(11, 01, 12, 109, '马驹桥镇'),
	(11, 01, 12, 110, '西集镇'),
	(11, 01, 12, 114, '台湖镇'),
	(11, 01, 12, 117, '永乐店镇'),
	(11, 01, 12, 119, '潞城镇'),
	(11, 01, 12, 209, '于家务回族乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 13, 001, '胜利街道'),
	(11, 01, 13, 002, '光明街道'),
	(11, 01, 13, 003, '仁和地区'),
	(11, 01, 13, 004, '后沙峪地区'),
	(11, 01, 13, 005, '天竺地区'),
	(11, 01, 13, 006, '杨镇地区'),
	(11, 01, 13, 007, '牛栏山地区'),
	(11, 01, 13, 008, '南法信地区'),
	(11, 01, 13, 009, '马坡地区'),
	(11, 01, 13, 010, '石园街道'),
	(11, 01, 13, 011, '空港街道'),
	(11, 01, 13, 012, '双丰街道'),
	(11, 01, 13, 013, '旺泉街道'),
	(11, 01, 13, 101, '高丽营镇'),
	(11, 01, 13, 104, '李桥镇'),
	(11, 01, 13, 105, '李遂镇'),
	(11, 01, 13, 106, '南彩镇'),
	(11, 01, 13, 108, '北务镇'),
	(11, 01, 13, 109, '大孙各庄镇'),
	(11, 01, 13, 110, '张镇'),
	(11, 01, 13, 111, '龙湾屯镇'),
	(11, 01, 13, 112, '木林镇'),
	(11, 01, 13, 113, '北小营镇'),
	(11, 01, 13, 115, '北石槽镇'),
	(11, 01, 13, 116, '赵全营镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 14, 001, '城北街道'),
	(11, 01, 14, 002, '南口地区'),
	(11, 01, 14, 003, '马池口地区'),
	(11, 01, 14, 004, '沙河地区'),
	(11, 01, 14, 005, '城南街道'),
	(11, 01, 14, 007, '东小口地区'),
	(11, 01, 14, 008, '天通苑北街道'),
	(11, 01, 14, 009, '天通苑南街道'),
	(11, 01, 14, 010, '霍营街道'),
	(11, 01, 14, 011, '回龙观街道'),
	(11, 01, 14, 012, '龙泽园街道'),
	(11, 01, 14, 013, '史各庄街道'),
	(11, 01, 14, 104, '阳坊镇'),
	(11, 01, 14, 110, '小汤山镇'),
	(11, 01, 14, 111, '南邵镇'),
	(11, 01, 14, 112, '崔村镇'),
	(11, 01, 14, 113, '百善镇'),
	(11, 01, 14, 115, '北七家镇'),
	(11, 01, 14, 116, '兴寿镇'),
	(11, 01, 14, 118, '流村镇'),
	(11, 01, 14, 119, '十三陵镇'),
	(11, 01, 14, 120, '延寿镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 15, 001, '兴丰街道'),
	(11, 01, 15, 002, '林校路街道'),
	(11, 01, 15, 003, '清源街道'),
	(11, 01, 15, 004, '亦庄地区'),
	(11, 01, 15, 005, '黄村地区'),
	(11, 01, 15, 006, '旧宫地区'),
	(11, 01, 15, 007, '西红门地区'),
	(11, 01, 15, 008, '瀛海地区'),
	(11, 01, 15, 009, '观音寺街道'),
	(11, 01, 15, 010, '天宫院街道'),
	(11, 01, 15, 011, '高米店街道'),
	(11, 01, 15, 012, '荣华街道'),
	(11, 01, 15, 013, '博兴街道'),
	(11, 01, 15, 103, '青云店镇'),
	(11, 01, 15, 104, '采育镇'),
	(11, 01, 15, 105, '安定镇'),
	(11, 01, 15, 106, '礼贤镇'),
	(11, 01, 15, 107, '榆垡镇'),
	(11, 01, 15, 108, '庞各庄镇'),
	(11, 01, 15, 109, '北臧村镇'),
	(11, 01, 15, 110, '魏善庄镇'),
	(11, 01, 15, 111, '长子营镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 16, 001, '泉河街道'),
	(11, 01, 16, 002, '龙山街道'),
	(11, 01, 16, 003, '怀柔地区'),
	(11, 01, 16, 004, '雁栖地区'),
	(11, 01, 16, 005, '庙城地区'),
	(11, 01, 16, 102, '北房镇'),
	(11, 01, 16, 103, '杨宋镇'),
	(11, 01, 16, 105, '桥梓镇'),
	(11, 01, 16, 106, '怀北镇'),
	(11, 01, 16, 107, '汤河口镇'),
	(11, 01, 16, 108, '渤海镇'),
	(11, 01, 16, 109, '九渡河镇'),
	(11, 01, 16, 110, '琉璃庙镇'),
	(11, 01, 16, 111, '宝山镇'),
	(11, 01, 16, 211, '长哨营满族乡'),
	(11, 01, 16, 213, '喇叭沟门满族乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 01, 17, 001, '滨河街道'),
	(11, 01, 17, 002, '兴谷街道'),
	(11, 01, 17, 003, '渔阳地区'),
	(11, 01, 17, 004, '峪口地区'),
	(11, 01, 17, 005, '马坊地区'),
	(11, 01, 17, 006, '金海湖地区'),
	(11, 01, 17, 101, '东高村镇'),
	(11, 01, 17, 102, '山东庄镇'),
	(11, 01, 17, 104, '南独乐河镇'),
	(11, 01, 17, 105, '大华山镇'),
	(11, 01, 17, 106, '夏各庄镇'),
	(11, 01, 17, 108, '马昌营镇'),
	(11, 01, 17, 110, '王辛庄镇'),
	(11, 01, 17, 111, '大兴庄镇'),
	(11, 01, 17, 112, '刘家店镇'),
	(11, 01, 17, 114, '镇罗营镇'),
	(11, 01, 17, 213, '黄松峪乡'),
	(11, 01, 17, 214, '熊儿寨乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 02, 28, 001, '鼓楼街道'),
	(11, 02, 28, 002, '果园街道'),
	(11, 02, 28, 003, '檀营地区'),
	(11, 02, 28, 100, '密云镇'),
	(11, 02, 28, 101, '溪翁庄镇'),
	(11, 02, 28, 102, '西田各庄镇'),
	(11, 02, 28, 103, '十里堡镇'),
	(11, 02, 28, 104, '河南寨镇'),
	(11, 02, 28, 105, '巨各庄镇'),
	(11, 02, 28, 106, '穆家峪镇'),
	(11, 02, 28, 107, '太师屯镇'),
	(11, 02, 28, 108, '高岭镇'),
	(11, 02, 28, 109, '不老屯镇'),
	(11, 02, 28, 110, '冯家峪镇'),
	(11, 02, 28, 111, '古北口镇'),
	(11, 02, 28, 112, '大城子镇'),
	(11, 02, 28, 113, '东邵渠镇'),
	(11, 02, 28, 114, '北庄镇'),
	(11, 02, 28, 115, '新城子镇'),
	(11, 02, 28, 116, '石城镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(11, 02, 29, 001, '百泉街道'),
	(11, 02, 29, 002, '香水园街道'),
	(11, 02, 29, 003, '儒林街道'),
	(11, 02, 29, 100, '延庆镇'),
	(11, 02, 29, 101, '康庄镇'),
	(11, 02, 29, 102, '八达岭镇'),
	(11, 02, 29, 103, '永宁镇'),
	(11, 02, 29, 104, '旧县镇'),
	(11, 02, 29, 105, '张山营镇'),
	(11, 02, 29, 106, '四海镇'),
	(11, 02, 29, 107, '千家店镇'),
	(11, 02, 29, 108, '沈家营镇'),
	(11, 02, 29, 109, '大榆树镇'),
	(11, 02, 29, 110, '井庄镇'),
	(11, 02, 29, 207, '大庄科乡'),
	(11, 02, 29, 209, '刘斌堡乡'),
	(11, 02, 29, 210, '香营乡'),
	(11, 02, 29, 214, '珍珠泉乡');

/* 天津市 */

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 01, 001, '劝业场街道'),
	(12, 01, 01, 002, '小白楼街道'),
	(12, 01, 01, 003, '五大道街道'),
	(12, 01, 01, 004, '新兴街道'),
	(12, 01, 01, 005, '南营门街道'),
	(12, 01, 01, 006, '南市街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 02, 001, '大王庄街道'),
	(12, 01, 02, 002, '大直沽街道'),
	(12, 01, 02, 003, '中山门街道'),
	(12, 01, 02, 004, '富民路街道'),
	(12, 01, 02, 005, '二号桥街道'),
	(12, 01, 02, 006, '春华街道'),
	(12, 01, 02, 007, '唐家口街道'),
	(12, 01, 02, 008, '向阳楼街道'),
	(12, 01, 02, 009, '常州道街道'),
	(12, 01, 02, 010, '上杭路街道'),
	(12, 01, 02, 011, '东新街道'),
	(12, 01, 02, 012, '鲁山道街道'),
	(12, 01, 02, 013, '天津铁厂街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 03, 001, '大营门街道'),
	(12, 01, 03, 002, '下瓦房街道'),
	(12, 01, 03, 003, '桃园街道'),
	(12, 01, 03, 004, '挂甲寺街道'),
	(12, 01, 03, 005, '马场街道'),
	(12, 01, 03, 006, '越秀路街道'),
	(12, 01, 03, 007, '友谊路街道'),
	(12, 01, 03, 008, '天塔街道'),
	(12, 01, 03, 009, '尖山街道'),
	(12, 01, 03, 010, '陈塘庄街道'),
	(12, 01, 03, 011, '柳林街道'),
	(12, 01, 03, 012, '东海街道'),
	(12, 01, 03, 013, '梅江街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 04, 001, '长虹街道'),
	(12, 01, 04, 002, '鼓楼街道'),
	(12, 01, 04, 003, '兴南街道'),
	(12, 01, 04, 004, '广开街道'),
	(12, 01, 04, 005, '万兴街道'),
	(12, 01, 04, 006, '学府街道'),
	(12, 01, 04, 007, '向阳路街道'),
	(12, 01, 04, 008, '嘉陵道街道'),
	(12, 01, 04, 009, '王顶堤街道'),
	(12, 01, 04, 010, '水上公园街道'),
	(12, 01, 04, 011, '体育中心街道'),
	(12, 01, 04, 012, '华苑街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 05, 001, '光复道街道'),
	(12, 01, 05, 002, '望海楼街道'),
	(12, 01, 05, 003, '鸿顺里街道'),
	(12, 01, 05, 004, '新开河街道'),
	(12, 01, 05, 005, '铁东路街道'),
	(12, 01, 05, 006, '建昌道街道'),
	(12, 01, 05, 007, '宁园街道'),
	(12, 01, 05, 008, '王串场街道'),
	(12, 01, 05, 009, '江都路街道'),
	(12, 01, 05, 010, '月牙河街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 06, 001, '西于庄街道'),
	(12, 01, 06, 002, '双环村街道'),
	(12, 01, 06, 003, '咸阳北路街道'),
	(12, 01, 06, 004, '丁字沽街道'),
	(12, 01, 06, 005, '西沽街道'),
	(12, 01, 06, 006, '三条石街道'),
	(12, 01, 06, 008, '邵公庄街道'),
	(12, 01, 06, 009, '芥园街道'),
	(12, 01, 06, 010, '铃铛阁街道'),
	(12, 01, 06, 011, '大胡同街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 10, 001, '张贵庄街道'),
	(12, 01, 10, 002, '丰年村街道'),
	(12, 01, 10, 003, '万新街道'),
	(12, 01, 10, 004, '无瑕街道'),
	(12, 01, 10, 005, '新立街道'),
	(12, 01, 10, 006, '华明街道'),
	(12, 01, 10, 007, '金钟街道'),
	(12, 01, 10, 008, '军粮城街道'),
	(12, 01, 10, 009, '金桥街道'),
	(12, 01, 10, 010, '华新街道'),
	(12, 01, 10, 011, '东丽湖街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 11, 001, '西营门街道'),
	(12, 01, 11, 002, '李七庄街道'),
	(12, 01, 11, 100, '中北镇'),
	(12, 01, 11, 101, '杨柳青镇'),
	(12, 01, 11, 102, '辛口镇'),
	(12, 01, 11, 103, '张家窝镇'),
	(12, 01, 11, 104, '精武镇'),
	(12, 01, 11, 105, '大寺镇'),
	(12, 01, 11, 106, '王稳庄镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 12, 001, '双港新家园街道'),
	(12, 01, 12, 100, '咸水沽镇'),
	(12, 01, 12, 101, '葛沽镇'),
	(12, 01, 12, 102, '小站镇'),
	(12, 01, 12, 103, '双港镇'),
	(12, 01, 12, 104, '辛庄镇'),
	(12, 01, 12, 106, '双桥河镇'),
	(12, 01, 12, 107, '八里台镇'),
	(12, 01, 12, 108, '北闸口镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 13, 001, '果园新村街道'),
	(12, 01, 13, 002, '集贤里街道'),
	(12, 01, 13, 003, '普东街道'),
	(12, 01, 13, 004, '瑞景街道'),
	(12, 01, 13, 005, '佳荣里街道'),
	(12, 01, 13, 006, '青源街道'),
	(12, 01, 13, 007, '广源街道'),
	(12, 01, 13, 100, '天穆镇'),
	(12, 01, 13, 101, '北仓镇'),
	(12, 01, 13, 102, '双街镇'),
	(12, 01, 13, 103, '双口镇'),
	(12, 01, 13, 104, '青光镇'),
	(12, 01, 13, 106, '宜兴埠镇'),
	(12, 01, 13, 107, '小淀镇'),
	(12, 01, 13, 108, '大张庄镇'),
	(12, 01, 13, 111, '西堤头镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 14, 001, '杨村街道'),
	(12, 01, 14, 002, '下朱庄街道'),
	(12, 01, 14, 003, '东蒲洼街道'),
	(12, 01, 14, 004, '黄庄街道'),
	(12, 01, 14, 005, '徐官屯街道'),
	(12, 01, 14, 006, '运河西街道'),
	(12, 01, 14, 101, '梅厂镇'),
	(12, 01, 14, 102, '大碱厂镇'),
	(12, 01, 14, 103, '崔黄口镇'),
	(12, 01, 14, 104, '大良镇'),
	(12, 01, 14, 105, '下伍旗镇'),
	(12, 01, 14, 106, '南蔡村镇'),
	(12, 01, 14, 107, '大孟庄镇'),
	(12, 01, 14, 108, '泗村店镇'),
	(12, 01, 14, 109, '河西务镇'),
	(12, 01, 14, 110, '城关镇'),
	(12, 01, 14, 111, '东马圈镇'),
	(12, 01, 14, 112, '黄花店镇'),
	(12, 01, 14, 113, '石各庄镇'),
	(12, 01, 14, 114, '王庆坨镇'),
	(12, 01, 14, 115, '汊沽港镇'),
	(12, 01, 14, 116, '河北屯镇'),
	(12, 01, 14, 117, '上马台镇'),
	(12, 01, 14, 118, '大王古庄镇'),
	(12, 01, 14, 119, '陈咀镇'),
	(12, 01, 14, 120, '豆张庄镇'),
	(12, 01, 14, 121, '曹子里镇'),
	(12, 01, 14, 122, '大黄堡镇'),
	(12, 01, 14, 123, '高村镇'),
	(12, 01, 14, 124, '白古屯镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 15, 001, '海滨街道'),
	(12, 01, 15, 002, '宝平街道'),
	(12, 01, 15, 003, '钰华街道'),
	(12, 01, 15, 004, '大白街道'),
	(12, 01, 15, 005, '口东街道'),
	(12, 01, 15, 006, '周良街道'),
	(12, 01, 15, 007, '潮阳街道'),
	(12, 01, 15, 008, '朝霞街道'),
	(12, 01, 15, 101, '大口屯镇'),
	(12, 01, 15, 103, '王卜庄镇'),
	(12, 01, 15, 104, '方家庄镇'),
	(12, 01, 15, 105, '林亭口镇'),
	(12, 01, 15, 106, '八门城镇'),
	(12, 01, 15, 107, '大钟庄镇'),
	(12, 01, 15, 108, '新安镇'),
	(12, 01, 15, 111, '霍各庄镇'),
	(12, 01, 15, 113, '新开口镇'),
	(12, 01, 15, 115, '大唐庄镇'),
	(12, 01, 15, 119, '牛道口镇'),
	(12, 01, 15, 120, '史各庄镇'),
	(12, 01, 15, 121, '郝各庄镇'),
	(12, 01, 15, 123, '牛家牌镇'),
	(12, 01, 15, 124, '尔王庄镇'),
	(12, 01, 15, 125, '黄庄镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 16, 001, '塘沽街道'),
	(12, 01, 16, 005, '杭州道街道'),
	(12, 01, 16, 006, '新河街道'),
	(12, 01, 16, 007, '大沽街道'),
	(12, 01, 16, 008, '新北街道'),
	(12, 01, 16, 009, '北塘街道'),
	(12, 01, 16, 011, '胡家园街道'),
	(12, 01, 16, 031, '汉沽街道'),
	(12, 01, 16, 032, '寨上街道'),
	(12, 01, 16, 033, '茶淀街道'),
	(12, 01, 16, 051, '大港街道'),
	(12, 01, 16, 053, '古林街道'),
	(12, 01, 16, 054, '海滨街道'),
	(12, 01, 16, 100, '新城镇'),
	(12, 01, 16, 135, '杨家泊镇'),
	(12, 01, 16, 156, '太平镇'),
	(12, 01, 16, 157, '小王庄镇'),
	(12, 01, 16, 158, '中塘镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 17, 100, '芦台镇'),
	(12, 01, 17, 102, '宁河镇'),
	(12, 01, 17, 103, '苗庄镇'),
	(12, 01, 17, 104, '丰台镇'),
	(12, 01, 17, 105, '岳龙镇'),
	(12, 01, 17, 106, '板桥镇'),
	(12, 01, 17, 107, '潘庄镇'),
	(12, 01, 17, 109, '造甲城镇'),
	(12, 01, 17, 110, '七里海镇'),
	(12, 01, 17, 111, '大北涧沽镇'),
	(12, 01, 17, 112, '东棘坨镇'),
	(12, 01, 17, 204, '北淮淀乡'),
	(12, 01, 17, 205, '俵口乡'),
	(12, 01, 17, 206, '廉庄子乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 01, 18, 100, '静海镇'),
	(12, 01, 18, 101, '唐官屯镇'),
	(12, 01, 18, 102, '独流镇'),
	(12, 01, 18, 103, '王口镇'),
	(12, 01, 18, 104, '台头镇'),
	(12, 01, 18, 105, '子牙镇'),
	(12, 01, 18, 106, '陈官屯镇'),
	(12, 01, 18, 107, '中旺镇'),
	(12, 01, 18, 108, '大邱庄镇'),
	(12, 01, 18, 109, '蔡公庄镇'),
	(12, 01, 18, 110, '梁头镇'),
	(12, 01, 18, 111, '团泊镇'),
	(12, 01, 18, 112, '双塘镇'),
	(12, 01, 18, 113, '大丰堆镇'),
	(12, 01, 18, 114, '沿庄镇'),
	(12, 01, 18, 115, '西翟庄镇'),
	(12, 01, 18, 200, '良王庄乡'),
	(12, 01, 18, 201, '杨成庄乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(12, 02, 25, 001, '文昌街道'),
	(12, 02, 25, 100, '渔阳镇'),
	(12, 02, 25, 101, '洇溜镇'),
	(12, 02, 25, 102, '官庄镇'),
	(12, 02, 25, 103, '马伸桥镇'),
	(12, 02, 25, 104, '下营镇'),
	(12, 02, 25, 105, '邦均镇'),
	(12, 02, 25, 106, '别山镇'),
	(12, 02, 25, 108, '尤古庄镇'),
	(12, 02, 25, 109, '上仓镇'),
	(12, 02, 25, 111, '下仓镇'),
	(12, 02, 25, 112, '罗庄子镇'),
	(12, 02, 25, 113, '白涧镇'),
	(12, 02, 25, 114, '五百户镇'),
	(12, 02, 25, 115, '侯家营镇'),
	(12, 02, 25, 116, '桑梓镇'),
	(12, 02, 25, 117, '东施古镇'),
	(12, 02, 25, 118, '下窝头镇'),
	(12, 02, 25, 119, '杨津庄镇'),
	(12, 02, 25, 120, '出头岭镇'),
	(12, 02, 25, 121, '西龙虎峪镇'),
	(12, 02, 25, 122, '穿芳峪镇'),
	(12, 02, 25, 123, '东二营镇'),
	(12, 02, 25, 124, '许家台镇'),
	(12, 02, 25, 125, '礼明庄镇'),
	(12, 02, 25, 126, '东赵各庄镇'),
	(12, 02, 25, 203, '孙各庄乡');


/* 上海市 */

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 01, 002, '南京东路街道'),
	(31, 01, 01, 013, '外滩街道'),
	(31, 01, 01, 015, '半淞园路街道'),
	(31, 01, 01, 017, '小东门街道'),
	(31, 01, 01, 018, '豫园街道'),
	(31, 01, 01, 019, '老西门街道'),
	(31, 01, 01, 020, '五里桥街道'),
	(31, 01, 01, 021, '打浦桥街道'),
	(31, 01, 01, 022, '淮海中路街道'),
	(31, 01, 01, 023, '瑞金二路街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 04, 003, '天平路街道'),
	(31, 01, 04, 004, '湖南路街道'),
	(31, 01, 04, 007, '斜土路街道'),
	(31, 01, 04, 008, '枫林路街道'),
	(31, 01, 04, 010, '长桥街道'),
	(31, 01, 04, 011, '田林街道'),
	(31, 01, 04, 012, '虹梅路街道'),
	(31, 01, 04, 013, '康健新村街道'),
	(31, 01, 04, 014, '徐家汇街道'),
	(31, 01, 04, 015, '凌云路街道'),
	(31, 01, 04, 016, '龙华街道'),
	(31, 01, 04, 017, '漕河泾街道'),
	(31, 01, 04, 103, '华泾镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 05, 001, '华阳路街道'),
	(31, 01, 05, 002, '江苏路街道'),
	(31, 01, 05, 004, '新华路街道'),
	(31, 01, 05, 005, '周家桥街道'),
	(31, 01, 05, 006, '天山路街道'),
	(31, 01, 05, 008, '仙霞新村街道'),
	(31, 01, 05, 009, '虹桥街道'),
	(31, 01, 05, 010, '程家桥街道'),
	(31, 01, 05, 011, '北新泾街道'),
	(31, 01, 05, 102, '新泾镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 06, 006, '江宁路街道'),
	(31, 01, 06, 011, '石门二路街道'),
	(31, 01, 06, 012, '南京西路街道'),
	(31, 01, 06, 013, '静安寺街道'),
	(31, 01, 06, 014, '曹家渡街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 07, 005, '曹杨新村街道'),
	(31, 01, 07, 014, '长风新村街道'),
	(31, 01, 07, 015, '长寿路街道'),
	(31, 01, 07, 016, '甘泉路街道'),
	(31, 01, 07, 017, '石泉路街道'),
	(31, 01, 07, 020, '宜川路街道'),
	(31, 01, 07, 021, '万里街道'),
	(31, 01, 07, 022, '真如镇街道'),
	(31, 01, 07, 102, '长征镇'),
	(31, 01, 07, 103, '桃浦镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 08, 001, '天目西路街道'),
	(31, 01, 08, 006, '北站街道'),
	(31, 01, 08, 007, '宝山路街道'),
	(31, 01, 08, 012, '共和新路街道'),
	(31, 01, 08, 013, '大宁路街道'),
	(31, 01, 08, 014, '彭浦新村街道'),
	(31, 01, 08, 015, '临汾路街道'),
	(31, 01, 08, 016, '芷江西路街道'),
	(31, 01, 08, 101, '彭浦镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 09, 009, '欧阳路街道'),
	(31, 01, 09, 010, '曲阳路街道'),
	(31, 01, 09, 011, '广中路街道'),
	(31, 01, 09, 014, '嘉兴路街道'),
	(31, 01, 09, 016, '凉城新村街道'),
	(31, 01, 09, 017, '四川北路街道'),
	(31, 01, 09, 018, '提篮桥街道'),
	(31, 01, 09, 019, '江湾镇街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 10, 001, '定海路街道'),
	(31, 01, 10, 006, '平凉路街道'),
	(31, 01, 10, 008, '江浦路街道'),
	(31, 01, 10, 009, '四平路街道'),
	(31, 01, 10, 012, '控江路街道'),
	(31, 01, 10, 013, '长白新村街道'),
	(31, 01, 10, 015, '延吉新村街道'),
	(31, 01, 10, 016, '殷行街道'),
	(31, 01, 10, 018, '大桥街道'),
	(31, 01, 10, 019, '五角场街道'),
	(31, 01, 10, 020, '新江湾城街道'),
	(31, 01, 10, 101, '五角场镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 12, 001, '江川路街道'),
	(31, 01, 12, 006, '古美街道'),
	(31, 01, 12, 008, '新虹街道'),
	(31, 01, 12, 009, '浦锦街道'),
	(31, 01, 12, 101, '莘庄镇'),
	(31, 01, 12, 102, '七宝镇'),
	(31, 01, 12, 103, '颛桥镇'),
	(31, 01, 12, 106, '华漕镇'),
	(31, 01, 12, 107, '虹桥镇'),
	(31, 01, 12, 108, '梅陇镇'),
	(31, 01, 12, 110, '吴泾镇'),
	(31, 01, 12, 112, '马桥镇'),
	(31, 01, 12, 114, '浦江镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 13, 003, '友谊路街道'),
	(31, 01, 13, 007, '吴淞街道'),
	(31, 01, 13, 008, '张庙街道'),
	(31, 01, 13, 101, '罗店镇'),
	(31, 01, 13, 102, '大场镇'),
	(31, 01, 13, 103, '杨行镇'),
	(31, 01, 13, 104, '月浦镇'),
	(31, 01, 13, 106, '罗泾镇'),
	(31, 01, 13, 109, '顾村镇'),
	(31, 01, 13, 111, '高境镇'),
	(31, 01, 13, 112, '庙行镇'),
	(31, 01, 13, 113, '淞南镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 14, 001, '新成路街道'),
	(31, 01, 14, 002, '真新街道'),
	(31, 01, 14, 003, '菊园新区管委会'),
	(31, 01, 14, 004, '嘉定镇街道'),
	(31, 01, 14, 102, '南翔镇'),
	(31, 01, 14, 103, '安亭镇'),
	(31, 01, 14, 106, '马陆镇'),
	(31, 01, 14, 109, '徐行镇'),
	(31, 01, 14, 111, '华亭镇'),
	(31, 01, 14, 114, '外冈镇'),
	(31, 01, 14, 118, '江桥镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 15, 004, '潍坊新村街道'),
	(31, 01, 15, 005, '陆家嘴街道'),
	(31, 01, 15, 007, '周家渡街道'),
	(31, 01, 15, 008, '塘桥街道'),
	(31, 01, 15, 009, '上钢新村街道'),
	(31, 01, 15, 010, '南码头路街道'),
	(31, 01, 15, 011, '沪东新村街道'),
	(31, 01, 15, 012, '金杨新村街道'),
	(31, 01, 15, 013, '洋泾街道'),
	(31, 01, 15, 014, '浦兴路街道'),
	(31, 01, 15, 015, '东明路街道'),
	(31, 01, 15, 016, '花木街道'),
	(31, 01, 15, 103, '川沙新镇'),
	(31, 01, 15, 104, '高桥镇'),
	(31, 01, 15, 105, '北蔡镇'),
	(31, 01, 15, 110, '合庆镇'),
	(31, 01, 15, 114, '唐镇'),
	(31, 01, 15, 117, '曹路镇'),
	(31, 01, 15, 120, '金桥镇'),
	(31, 01, 15, 121, '高行镇'),
	(31, 01, 15, 123, '高东镇'),
	(31, 01, 15, 125, '张江镇'),
	(31, 01, 15, 130, '三林镇'),
	(31, 01, 15, 131, '惠南镇'),
	(31, 01, 15, 132, '周浦镇'),
	(31, 01, 15, 133, '新场镇'),
	(31, 01, 15, 134, '大团镇'),
	(31, 01, 15, 136, '康桥镇'),
	(31, 01, 15, 137, '航头镇'),
	(31, 01, 15, 139, '祝桥镇'),
	(31, 01, 15, 140, '泥城镇'),
	(31, 01, 15, 141, '宣桥镇'),
	(31, 01, 15, 142, '书院镇'),
	(31, 01, 15, 143, '万祥镇'),
	(31, 01, 15, 144, '老港镇'),
	(31, 01, 15, 145, '南汇新城镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 16, 001, '石化街道'),
	(31, 01, 16, 101, '朱泾镇'),
	(31, 01, 16, 102, '枫泾镇'),
	(31, 01, 16, 103, '张堰镇'),
	(31, 01, 16, 104, '亭林镇'),
	(31, 01, 16, 105, '吕巷镇'),
	(31, 01, 16, 107, '廊下镇'),
	(31, 01, 16, 109, '金山卫镇'),
	(31, 01, 16, 112, '漕泾镇'),
	(31, 01, 16, 113, '山阳镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 17, 001, '岳阳街道'),
	(31, 01, 17, 002, '永丰街道'),
	(31, 01, 17, 003, '方松街道'),
	(31, 01, 17, 004, '中山街道'),
	(31, 01, 17, 005, '广富林街道'),
	(31, 01, 17, 006, '九里亭街道'),
	(31, 01, 17, 102, '泗泾镇'),
	(31, 01, 17, 103, '佘山镇'),
	(31, 01, 17, 104, '车墩镇'),
	(31, 01, 17, 105, '新桥镇'),
	(31, 01, 17, 106, '洞泾镇'),
	(31, 01, 17, 107, '九亭镇'),
	(31, 01, 17, 109, '泖港镇'),
	(31, 01, 17, 116, '石湖荡镇'),
	(31, 01, 17, 117, '新浜镇'),
	(31, 01, 17, 120, '叶榭镇'),
	(31, 01, 17, 121, '小昆山镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 18, 001, '夏阳街道'),
	(31, 01, 18, 002, '盈浦街道'),
	(31, 01, 18, 003, '香花桥街道'),
	(31, 01, 18, 102, '朱家角镇'),
	(31, 01, 18, 103, '练塘镇'),
	(31, 01, 18, 104, '金泽镇'),
	(31, 01, 18, 105, '赵巷镇'),
	(31, 01, 18, 106, '徐泾镇'),
	(31, 01, 18, 107, '华新镇'),
	(31, 01, 18, 109, '重固镇'),
	(31, 01, 18, 110, '白鹤镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 01, 20, 101, '南桥镇'),
	(31, 01, 20, 102, '奉城镇'),
	(31, 01, 20, 104, '庄行镇'),
	(31, 01, 20, 106, '金汇镇'),
	(31, 01, 20, 109, '四团镇'),
	(31, 01, 20, 111, '青村镇'),
	(31, 01, 20, 118, '柘林镇'),
	(31, 01, 20, 123, '海湾镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(31, 02, 30, 101, '城桥镇'),
	(31, 02, 30, 102, '堡镇'),
	(31, 02, 30, 103, '新河镇'),
	(31, 02, 30, 104, '庙镇'),
	(31, 02, 30, 106, '竖新镇'),
	(31, 02, 30, 107, '向化镇'),
	(31, 02, 30, 109, '三星镇'),
	(31, 02, 30, 113, '港沿镇'),
	(31, 02, 30, 114, '中兴镇'),
	(31, 02, 30, 115, '陈家镇'),
	(31, 02, 30, 116, '绿华镇'),
	(31, 02, 30, 118, '港西镇'),
	(31, 02, 30, 119, '建设镇'),
	(31, 02, 30, 121, '新海镇'),
	(31, 02, 30, 122, '东平镇'),
	(31, 02, 30, 123, '长兴镇'),
	(31, 02, 30, 201, '新村乡'),
	(31, 02, 30, 203, '横沙乡');

/* 重庆市 */

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 01, 001, '高笋塘街道'),
	(50, 01, 01, 017, '太白街道'),
	(50, 01, 01, 018, '牌楼街道'),
	(50, 01, 01, 019, '双河口街道'),
	(50, 01, 01, 020, '龙都街道'),
	(50, 01, 01, 021, '周家坝街道'),
	(50, 01, 01, 022, '沙河街道'),
	(50, 01, 01, 023, '钟鼓楼街道'),
	(50, 01, 01, 024, '百安坝街道'),
	(50, 01, 01, 025, '五桥街道'),
	(50, 01, 01, 026, '陈家坝街道'),
	(50, 01, 01, 109, '小周镇'),
	(50, 01, 01, 110, '大周镇'),
	(50, 01, 01, 123, '新乡镇'),
	(50, 01, 01, 132, '孙家镇'),
	(50, 01, 01, 134, '高峰镇'),
	(50, 01, 01, 135, '龙沙镇'),
	(50, 01, 01, 136, '响水镇'),
	(50, 01, 01, 137, '武陵镇'),
	(50, 01, 01, 138, '瀼渡镇'),
	(50, 01, 01, 139, '甘宁镇'),
	(50, 01, 01, 140, '天城镇'),
	(50, 01, 01, 141, '熊家镇'),
	(50, 01, 01, 142, '高梁镇'),
	(50, 01, 01, 143, '李河镇'),
	(50, 01, 01, 144, '分水镇'),
	(50, 01, 01, 145, '余家镇'),
	(50, 01, 01, 146, '后山镇'),
	(50, 01, 01, 147, '弹子镇'),
	(50, 01, 01, 148, '长岭镇'),
	(50, 01, 01, 149, '新田镇'),
	(50, 01, 01, 150, '白羊镇'),
	(50, 01, 01, 151, '龙驹镇'),
	(50, 01, 01, 152, '走马镇'),
	(50, 01, 01, 153, '罗田镇'),
	(50, 01, 01, 154, '太龙镇'),
	(50, 01, 01, 155, '长滩镇'),
	(50, 01, 01, 156, '太安镇'),
	(50, 01, 01, 157, '白土镇'),
	(50, 01, 01, 158, '郭村镇'),
	(50, 01, 01, 201, '柱山乡'),
	(50, 01, 01, 212, '铁峰乡'),
	(50, 01, 01, 225, '溪口乡'),
	(50, 01, 01, 226, '长坪乡'),
	(50, 01, 01, 227, '燕山乡'),
	(50, 01, 01, 234, '梨树乡'),
	(50, 01, 01, 237, '普子乡'),
	(50, 01, 01, 238, '地宝土家族乡'),
	(50, 01, 01, 239, '恒合土家族乡'),
	(50, 01, 01, 244, '黄柏乡'),
	(50, 01, 01, 245, '九池乡'),
	(50, 01, 01, 247, '茨竹乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 02, 006, '敦仁街道'),
	(50, 01, 02, 007, '崇义街道'),
	(50, 01, 02, 008, '荔枝街道'),
	(50, 01, 02, 009, '江北街道'),
	(50, 01, 02, 010, '江东街道'),
	(50, 01, 02, 011, '李渡街道'),
	(50, 01, 02, 012, '龙桥街道'),
	(50, 01, 02, 013, '白涛街道'),
	(50, 01, 02, 103, '南沱镇'),
	(50, 01, 02, 107, '青羊镇'),
	(50, 01, 02, 118, '百胜镇'),
	(50, 01, 02, 119, '珍溪镇'),
	(50, 01, 02, 120, '清溪镇'),
	(50, 01, 02, 121, '焦石镇'),
	(50, 01, 02, 122, '马武镇'),
	(50, 01, 02, 123, '龙潭镇'),
	(50, 01, 02, 124, '蔺市镇'),
	(50, 01, 02, 125, '新妙镇'),
	(50, 01, 02, 126, '石沱镇'),
	(50, 01, 02, 127, '义和镇'),
	(50, 01, 02, 204, '罗云乡'),
	(50, 01, 02, 206, '大木乡'),
	(50, 01, 02, 208, '武陵山乡'),
	(50, 01, 02, 216, '大顺乡'),
	(50, 01, 02, 217, '增福乡'),
	(50, 01, 02, 222, '同乐乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 03, 001, '七星岗街道'),
	(50, 01, 03, 003, '解放碑街道'),
	(50, 01, 03, 004, '两路口街道'),
	(50, 01, 03, 005, '上清寺街道'),
	(50, 01, 03, 007, '菜园坝街道'),
	(50, 01, 03, 008, '南纪门街道'),
	(50, 01, 03, 010, '朝天门街道'),
	(50, 01, 03, 011, '大溪沟街道'),
	(50, 01, 03, 012, '大坪街道'),
	(50, 01, 03, 013, '化龙桥街道'),
	(50, 01, 03, 014, '石油路街道');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 04, 001, '新山村街道'),
	(50, 01, 04, 002, '跃进村街道'),
	(50, 01, 04, 003, '九宫庙街道'),
	(50, 01, 04, 004, '茄子溪街道'),
	(50, 01, 04, 005, '春晖路街道'),
	(50, 01, 04, 101, '八桥镇'),
	(50, 01, 04, 102, '建胜镇'),
	(50, 01, 04, 103, '跳磴镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 05, 001, '华新街街道'),
	(50, 01, 05, 002, '江北城街道'),
	(50, 01, 05, 003, '石马河街道'),
	(50, 01, 05, 004, '大石坝街道'),
	(50, 01, 05, 005, '寸滩街道'),
	(50, 01, 05, 006, '观音桥街道'),
	(50, 01, 05, 007, '五里店街道'),
	(50, 01, 05, 008, '郭家沱街道'),
	(50, 01, 05, 009, '铁山坪街道'),
	(50, 01, 05, 100, '鱼嘴镇'),
	(50, 01, 05, 101, '复盛镇'),
	(50, 01, 05, 102, '五宝镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 06, 001, '小龙坎街道'),
	(50, 01, 06, 002, '沙坪坝街道'),
	(50, 01, 06, 003, '渝碚路街道'),
	(50, 01, 06, 004, '磁器口街道'),
	(50, 01, 06, 005, '童家桥街道'),
	(50, 01, 06, 006, '石井坡街道'),
	(50, 01, 06, 007, '双碑街道'),
	(50, 01, 06, 008, '井口街道'),
	(50, 01, 06, 009, '歌乐山街道'),
	(50, 01, 06, 010, '山洞街道'),
	(50, 01, 06, 011, '新桥街道'),
	(50, 01, 06, 012, '天星桥街道'),
	(50, 01, 06, 013, '土湾街道'),
	(50, 01, 06, 014, '覃家岗街道'),
	(50, 01, 06, 015, '陈家桥街道'),
	(50, 01, 06, 016, '虎溪街道'),
	(50, 01, 06, 017, '西永街道'),
	(50, 01, 06, 018, '联芳街道'),
	(50, 01, 06, 102, '井口镇'),
	(50, 01, 06, 103, '歌乐山镇'),
	(50, 01, 06, 104, '青木关镇'),
	(50, 01, 06, 105, '凤凰镇'),
	(50, 01, 06, 106, '回龙坝镇'),
	(50, 01, 06, 108, '曾家镇'),
	(50, 01, 06, 111, '土主镇'),
	(50, 01, 06, 112, '中梁镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 07, 001, '杨家坪街道'),
	(50, 01, 07, 002, '黄桷坪街道'),
	(50, 01, 07, 003, '谢家湾街道'),
	(50, 01, 07, 004, '石坪桥街道'),
	(50, 01, 07, 005, '石桥铺街道'),
	(50, 01, 07, 006, '中梁山街道'),
	(50, 01, 07, 007, '渝州路街道'),
	(50, 01, 07, 008, '二郎街道'),
	(50, 01, 07, 100, '九龙镇'),
	(50, 01, 07, 102, '华岩镇'),
	(50, 01, 07, 103, '含谷镇'),
	(50, 01, 07, 104, '金凤镇'),
	(50, 01, 07, 105, '白市驿镇'),
	(50, 01, 07, 106, '走马镇'),
	(50, 01, 07, 107, '石板镇'),
	(50, 01, 07, 108, '巴福镇'),
	(50, 01, 07, 109, '陶家镇'),
	(50, 01, 07, 110, '西彭镇'),
	(50, 01, 07, 111, '铜罐驿镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 08, 001, '铜元局街道'),
	(50, 01, 08, 002, '花园路街道'),
	(50, 01, 08, 003, '南坪街道'),
	(50, 01, 08, 004, '海棠溪街道'),
	(50, 01, 08, 005, '龙门浩街道'),
	(50, 01, 08, 006, '弹子石街道'),
	(50, 01, 08, 007, '南山街道'),
	(50, 01, 08, 008, '天文街道'),
	(50, 01, 08, 101, '南坪镇'),
	(50, 01, 08, 102, '涂山镇'),
	(50, 01, 08, 103, '鸡冠石镇'),
	(50, 01, 08, 105, '峡口镇'),
	(50, 01, 08, 106, '长生桥镇'),
	(50, 01, 08, 107, '迎龙镇'),
	(50, 01, 08, 108, '广阳镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 09, 001, '天生街道'),
	(50, 01, 09, 002, '朝阳街道'),
	(50, 01, 09, 003, '北温泉街道'),
	(50, 01, 09, 004, '东阳街道'),
	(50, 01, 09, 005, '龙凤桥街道'),
	(50, 01, 09, 101, '歇马镇'),
	(50, 01, 09, 102, '澄江镇'),
	(50, 01, 09, 103, '蔡家岗镇'),
	(50, 01, 09, 104, '童家溪镇'),
	(50, 01, 09, 105, '天府镇'),
	(50, 01, 09, 108, '施家梁镇'),
	(50, 01, 09, 109, '水土镇'),
	(50, 01, 09, 110, '静观镇'),
	(50, 01, 09, 111, '柳荫镇'),
	(50, 01, 09, 112, '复兴镇'),
	(50, 01, 09, 113, '三圣镇'),
	(50, 01, 09, 116, '金刀峡镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 10, 001, '古南街道'),
	(50, 01, 10, 002, '文龙街道'),
	(50, 01, 10, 003, '三江街道'),
	(50, 01, 10, 004, '万盛街道'),
	(50, 01, 10, 005, '东林街道'),
	(50, 01, 10, 100, '万东镇'),
	(50, 01, 10, 101, '南桐镇'),
	(50, 01, 10, 102, '青年镇'),
	(50, 01, 10, 103, '关坝镇'),
	(50, 01, 10, 104, '丛林镇'),
	(50, 01, 10, 105, '石林镇'),
	(50, 01, 10, 106, '金桥镇'),
	(50, 01, 10, 107, '黑山镇'),
	(50, 01, 10, 108, '石角镇'),
	(50, 01, 10, 109, '东溪镇'),
	(50, 01, 10, 110, '赶水镇'),
	(50, 01, 10, 111, '打通镇'),
	(50, 01, 10, 112, '石壕镇'),
	(50, 01, 10, 113, '永新镇'),
	(50, 01, 10, 114, '三角镇'),
	(50, 01, 10, 115, '隆盛镇'),
	(50, 01, 10, 116, '郭扶镇'),
	(50, 01, 10, 117, '篆塘镇'),
	(50, 01, 10, 118, '丁山镇'),
	(50, 01, 10, 119, '安稳镇'),
	(50, 01, 10, 120, '扶欢镇'),
	(50, 01, 10, 121, '永城镇'),
	(50, 01, 10, 122, '新盛镇'),
	(50, 01, 10, 123, '中峰镇'),
	(50, 01, 10, 124, '横山镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 11, 001, '龙岗街道'),
	(50, 01, 11, 002, '棠香街道'),
	(50, 01, 11, 003, '龙滩子街道'),
	(50, 01, 11, 004, '双路街道'),
	(50, 01, 11, 005, '通桥街道'),
	(50, 01, 11, 006, '智凤街道'),
	(50, 01, 11, 100, '龙水镇'),
	(50, 01, 11, 102, '宝顶镇'),
	(50, 01, 11, 103, '中敖镇'),
	(50, 01, 11, 104, '三驱镇'),
	(50, 01, 11, 105, '宝兴镇'),
	(50, 01, 11, 106, '玉龙镇'),
	(50, 01, 11, 107, '石马镇'),
	(50, 01, 11, 108, '拾万镇'),
	(50, 01, 11, 109, '回龙镇'),
	(50, 01, 11, 110, '金山镇'),
	(50, 01, 11, 111, '万古镇'),
	(50, 01, 11, 112, '国梁镇'),
	(50, 01, 11, 113, '雍溪镇'),
	(50, 01, 11, 114, '珠溪镇'),
	(50, 01, 11, 115, '龙石镇'),
	(50, 01, 11, 116, '邮亭镇'),
	(50, 01, 11, 117, '铁山镇'),
	(50, 01, 11, 118, '高升镇'),
	(50, 01, 11, 119, '季家镇'),
	(50, 01, 11, 120, '古龙镇'),
	(50, 01, 11, 121, '高坪镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 12, 002, '双龙湖街道'),
	(50, 01, 12, 004, '回兴街道'),
	(50, 01, 12, 007, '鸳鸯街道'),
	(50, 01, 12, 008, '翠云街道'),
	(50, 01, 12, 009, '人和街道'),
	(50, 01, 12, 010, '天宫殿街道'),
	(50, 01, 12, 011, '龙溪街道'),
	(50, 01, 12, 012, '龙山街道'),
	(50, 01, 12, 013, '龙塔街道'),
	(50, 01, 12, 014, '大竹林街道'),
	(50, 01, 12, 015, '悦来街道'),
	(50, 01, 12, 016, '两路街道'),
	(50, 01, 12, 017, '双凤桥街道'),
	(50, 01, 12, 018, '王家街道'),
	(50, 01, 12, 019, '礼嘉街道'),
	(50, 01, 12, 020, '宝圣湖街道'),
	(50, 01, 12, 021, '金山街道'),
	(50, 01, 12, 022, '康美街道'),
	(50, 01, 12, 023, '仙桃街道'),
	(50, 01, 12, 129, '玉峰山镇'),
	(50, 01, 12, 131, '龙兴镇'),
	(50, 01, 12, 133, '统景镇'),
	(50, 01, 12, 135, '大湾镇'),
	(50, 01, 12, 138, '兴隆镇'),
	(50, 01, 12, 139, '木耳镇'),
	(50, 01, 12, 140, '茨竹镇'),
	(50, 01, 12, 141, '古路镇'),
	(50, 01, 12, 142, '石船镇'),
	(50, 01, 12, 143, '大盛镇'),
	(50, 01, 12, 144, '洛碛镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 13, 003, '龙洲湾街道'),
	(50, 01, 13, 004, '鱼洞街道'),
	(50, 01, 13, 005, '花溪街道'),
	(50, 01, 13, 006, '李家沱街道'),
	(50, 01, 13, 007, '南泉街道'),
	(50, 01, 13, 008, '一品街道'),
	(50, 01, 13, 009, '南彭街道'),
	(50, 01, 13, 010, '惠民街道'),
	(50, 01, 13, 103, '界石镇'),
	(50, 01, 13, 107, '安澜镇'),
	(50, 01, 13, 108, '跳石镇'),
	(50, 01, 13, 109, '木洞镇'),
	(50, 01, 13, 110, '双河口镇'),
	(50, 01, 13, 111, '麻柳嘴镇'),
	(50, 01, 13, 112, '丰盛镇'),
	(50, 01, 13, 113, '二圣镇'),
	(50, 01, 13, 114, '东泉镇'),
	(50, 01, 13, 115, '姜家镇'),
	(50, 01, 13, 116, '天星寺镇'),
	(50, 01, 13, 117, '接龙镇'),
	(50, 01, 13, 118, '石滩镇'),
	(50, 01, 13, 119, '石龙镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 14, 001, '城东街道'),
	(50, 01, 14, 002, '城南街道'),
	(50, 01, 14, 003, '城西街道'),
	(50, 01, 14, 004, '正阳街道'),
	(50, 01, 14, 005, '舟白街道'),
	(50, 01, 14, 006, '冯家街道'),
	(50, 01, 14, 105, '阿蓬江镇'),
	(50, 01, 14, 106, '石会镇'),
	(50, 01, 14, 107, '黑溪镇'),
	(50, 01, 14, 108, '黄溪镇'),
	(50, 01, 14, 109, '黎水镇'),
	(50, 01, 14, 110, '金溪镇'),
	(50, 01, 14, 111, '马喇镇'),
	(50, 01, 14, 112, '濯水镇'),
	(50, 01, 14, 113, '石家镇'),
	(50, 01, 14, 114, '鹅池镇'),
	(50, 01, 14, 117, '小南海镇'),
	(50, 01, 14, 119, '邻鄂镇'),
	(50, 01, 14, 215, '中塘乡'),
	(50, 01, 14, 216, '蓬东乡'),
	(50, 01, 14, 217, '沙坝乡'),
	(50, 01, 14, 218, '白石乡'),
	(50, 01, 14, 219, '杉岭乡'),
	(50, 01, 14, 220, '太极乡'),
	(50, 01, 14, 221, '水田乡'),
	(50, 01, 14, 222, '白土乡'),
	(50, 01, 14, 223, '金洞乡'),
	(50, 01, 14, 224, '五里乡'),
	(50, 01, 14, 225, '水市乡'),
	(50, 01, 14, 226, '新华乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 15, 001, '凤城街道'),
	(50, 01, 15, 002, '晏家街道'),
	(50, 01, 15, 003, '江南街道'),
	(50, 01, 15, 004, '渡舟街道'),
	(50, 01, 15, 005, '新市街道'),
	(50, 01, 15, 006, '八颗街道'),
	(50, 01, 15, 123, '邻封镇'),
	(50, 01, 15, 124, '但渡镇'),
	(50, 01, 15, 125, '云集镇'),
	(50, 01, 15, 126, '长寿湖镇'),
	(50, 01, 15, 127, '双龙镇'),
	(50, 01, 15, 128, '龙河镇'),
	(50, 01, 15, 129, '石堰镇'),
	(50, 01, 15, 130, '云台镇'),
	(50, 01, 15, 131, '海棠镇'),
	(50, 01, 15, 132, '葛兰镇'),
	(50, 01, 15, 136, '洪湖镇'),
	(50, 01, 15, 137, '万顺镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 16, 001, '几江街道'),
	(50, 01, 16, 002, '德感街道'),
	(50, 01, 16, 004, '双福街道'),
	(50, 01, 16, 005, '鼎山街道'),
	(50, 01, 16, 101, '油溪镇'),
	(50, 01, 16, 102, '吴滩镇'),
	(50, 01, 16, 103, '石门镇'),
	(50, 01, 16, 104, '朱杨镇'),
	(50, 01, 16, 105, '石蟆镇'),
	(50, 01, 16, 106, '永兴镇'),
	(50, 01, 16, 107, '塘河镇'),
	(50, 01, 16, 108, '白沙镇'),
	(50, 01, 16, 109, '龙华镇'),
	(50, 01, 16, 110, '李市镇'),
	(50, 01, 16, 111, '慈云镇'),
	(50, 01, 16, 112, '蔡家镇'),
	(50, 01, 16, 113, '中山镇'),
	(50, 01, 16, 114, '嘉平镇'),
	(50, 01, 16, 115, '柏林镇'),
	(50, 01, 16, 116, '先锋镇'),
	(50, 01, 16, 117, '珞璜镇'),
	(50, 01, 16, 118, '贾嗣镇'),
	(50, 01, 16, 119, '夏坝镇'),
	(50, 01, 16, 120, '西湖镇'),
	(50, 01, 16, 121, '杜市镇'),
	(50, 01, 16, 122, '广兴镇'),
	(50, 01, 16, 123, '四面山镇'),
	(50, 01, 16, 124, '支坪镇'),
	(50, 01, 16, 125, '四屏镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 17, 001, '合阳城街道'),
	(50, 01, 17, 002, '钓鱼城街道'),
	(50, 01, 17, 003, '南津街街道'),
	(50, 01, 17, 004, '盐井街道'),
	(50, 01, 17, 005, '草街街道'),
	(50, 01, 17, 006, '云门街道'),
	(50, 01, 17, 007, '大石街道'),
	(50, 01, 17, 100, '沙鱼镇'),
	(50, 01, 17, 101, '官渡镇'),
	(50, 01, 17, 102, '涞滩镇'),
	(50, 01, 17, 103, '肖家镇'),
	(50, 01, 17, 104, '古楼镇'),
	(50, 01, 17, 105, '三庙镇'),
	(50, 01, 17, 106, '二郎镇'),
	(50, 01, 17, 107, '龙凤镇'),
	(50, 01, 17, 108, '隆兴镇'),
	(50, 01, 17, 109, '铜溪镇'),
	(50, 01, 17, 112, '双凤镇'),
	(50, 01, 17, 113, '狮滩镇'),
	(50, 01, 17, 114, '清平镇'),
	(50, 01, 17, 115, '土场镇'),
	(50, 01, 17, 116, '小沔镇'),
	(50, 01, 17, 117, '三汇镇'),
	(50, 01, 17, 118, '香龙镇'),
	(50, 01, 17, 120, '钱塘镇'),
	(50, 01, 17, 121, '龙市镇'),
	(50, 01, 17, 123, '燕窝镇'),
	(50, 01, 17, 124, '太和镇'),
	(50, 01, 17, 125, '渭沱镇'),
	(50, 01, 17, 126, '双槐镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 18, 001, '中山路街道'),
	(50, 01, 18, 002, '胜利路街道'),
	(50, 01, 18, 003, '南大街街道'),
	(50, 01, 18, 004, '茶山竹海街道'),
	(50, 01, 18, 005, '大安街道'),
	(50, 01, 18, 006, '陈食街道'),
	(50, 01, 18, 007, '卫星湖街道'),
	(50, 01, 18, 100, '青峰镇'),
	(50, 01, 18, 102, '金龙镇'),
	(50, 01, 18, 104, '临江镇'),
	(50, 01, 18, 106, '何埂镇'),
	(50, 01, 18, 107, '松溉镇'),
	(50, 01, 18, 108, '仙龙镇'),
	(50, 01, 18, 109, '吉安镇'),
	(50, 01, 18, 110, '五间镇'),
	(50, 01, 18, 111, '来苏镇'),
	(50, 01, 18, 112, '宝峰镇'),
	(50, 01, 18, 113, '双石镇'),
	(50, 01, 18, 114, '红炉镇'),
	(50, 01, 18, 115, '永荣镇'),
	(50, 01, 18, 116, '三教镇'),
	(50, 01, 18, 117, '板桥镇'),
	(50, 01, 18, 118, '朱沱镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 19, 001, '东城街道'),
	(50, 01, 19, 002, '南城街道'),
	(50, 01, 19, 003, '西城街道'),
	(50, 01, 19, 100, '三泉镇'),
	(50, 01, 19, 101, '南平镇'),
	(50, 01, 19, 102, '神童镇'),
	(50, 01, 19, 103, '鸣玉镇'),
	(50, 01, 19, 104, '大观镇'),
	(50, 01, 19, 105, '兴隆镇'),
	(50, 01, 19, 106, '太平场镇'),
	(50, 01, 19, 107, '白沙镇'),
	(50, 01, 19, 108, '水江镇'),
	(50, 01, 19, 109, '石墙镇'),
	(50, 01, 19, 110, '金山镇'),
	(50, 01, 19, 111, '头渡镇'),
	(50, 01, 19, 112, '大有镇'),
	(50, 01, 19, 113, '合溪镇'),
	(50, 01, 19, 114, '黎香湖镇'),
	(50, 01, 19, 115, '山王坪镇'),
	(50, 01, 19, 116, '木凉镇'),
	(50, 01, 19, 117, '楠竹山镇'),
	(50, 01, 19, 118, '石溪镇'),
	(50, 01, 19, 200, '石莲乡'),
	(50, 01, 19, 202, '河图乡'),
	(50, 01, 19, 204, '乾丰乡'),
	(50, 01, 19, 205, '骑龙乡'),
	(50, 01, 19, 207, '中桥乡'),
	(50, 01, 19, 209, '德隆乡'),
	(50, 01, 19, 210, '庆元乡'),
	(50, 01, 19, 211, '古花乡'),
	(50, 01, 19, 212, '峰岩乡'),
	(50, 01, 19, 213, '民主乡'),
	(50, 01, 19, 214, '冷水关乡'),
	(50, 01, 19, 216, '福寿乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 20, 001, '璧城街道'),
	(50, 01, 20, 002, '璧泉街道'),
	(50, 01, 20, 003, '青杠街道'),
	(50, 01, 20, 004, '来凤街道'),
	(50, 01, 20, 005, '丁家街道'),
	(50, 01, 20, 006, '大路街道'),
	(50, 01, 20, 100, '八塘镇'),
	(50, 01, 20, 101, '七塘镇'),
	(50, 01, 20, 102, '河边镇'),
	(50, 01, 20, 103, '福禄镇'),
	(50, 01, 20, 104, '大兴镇'),
	(50, 01, 20, 105, '正兴镇'),
	(50, 01, 20, 106, '广普镇'),
	(50, 01, 20, 107, '三合镇'),
	(50, 01, 20, 108, '健龙镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 51, 001, '巴川街道'),
	(50, 01, 51, 002, '东城街道'),
	(50, 01, 51, 003, '南城街道'),
	(50, 01, 51, 004, '蒲吕街道'),
	(50, 01, 51, 005, '旧县街道'),
	(50, 01, 51, 101, '土桥镇'),
	(50, 01, 51, 103, '二坪镇'),
	(50, 01, 51, 104, '水口镇'),
	(50, 01, 51, 105, '安居镇'),
	(50, 01, 51, 106, '白羊镇'),
	(50, 01, 51, 107, '平滩镇'),
	(50, 01, 51, 108, '小林镇'),
	(50, 01, 51, 109, '双山镇'),
	(50, 01, 51, 110, '虎峰镇'),
	(50, 01, 51, 111, '石鱼镇'),
	(50, 01, 51, 112, '福果镇'),
	(50, 01, 51, 113, '庆隆镇'),
	(50, 01, 51, 114, '少云镇'),
	(50, 01, 51, 115, '维新镇'),
	(50, 01, 51, 116, '高楼镇'),
	(50, 01, 51, 117, '大庙镇'),
	(50, 01, 51, 118, '围龙镇'),
	(50, 01, 51, 119, '华兴镇'),
	(50, 01, 51, 120, '永嘉镇'),
	(50, 01, 51, 121, '安溪镇'),
	(50, 01, 51, 122, '西河镇'),
	(50, 01, 51, 123, '侣俸镇'),
	(50, 01, 51, 124, '太平镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 52, 001, '桂林街道'),
	(50, 01, 52, 002, '梓潼街道'),
	(50, 01, 52, 101, '上和镇'),
	(50, 01, 52, 102, '龙形镇'),
	(50, 01, 52, 103, '古溪镇'),
	(50, 01, 52, 104, '宝龙镇'),
	(50, 01, 52, 107, '玉溪镇'),
	(50, 01, 52, 108, '米心镇'),
	(50, 01, 52, 109, '群力镇'),
	(50, 01, 52, 110, '双江镇'),
	(50, 01, 52, 112, '花岩镇'),
	(50, 01, 52, 113, '柏梓镇'),
	(50, 01, 52, 114, '崇龛镇'),
	(50, 01, 52, 115, '塘坝镇'),
	(50, 01, 52, 116, '新胜镇'),
	(50, 01, 52, 117, '太安镇'),
	(50, 01, 52, 119, '小渡镇'),
	(50, 01, 52, 120, '卧佛镇'),
	(50, 01, 52, 121, '五桂镇'),
	(50, 01, 52, 122, '田家镇'),
	(50, 01, 52, 123, '别口镇'),
	(50, 01, 52, 124, '寿桥镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 01, 53, 001, '昌元街道'),
	(50, 01, 53, 002, '昌州街道'),
	(50, 01, 53, 003, '广顺街道'),
	(50, 01, 53, 004, '双河街道'),
	(50, 01, 53, 005, '安富街道'),
	(50, 01, 53, 006, '峰高街道'),
	(50, 01, 53, 100, '荣隆镇'),
	(50, 01, 53, 101, '仁义镇'),
	(50, 01, 53, 102, '盘龙镇'),
	(50, 01, 53, 103, '吴家镇'),
	(50, 01, 53, 104, '直升镇'),
	(50, 01, 53, 105, '万灵镇'),
	(50, 01, 53, 106, '清升镇'),
	(50, 01, 53, 107, '清江镇'),
	(50, 01, 53, 108, '古昌镇'),
	(50, 01, 53, 109, '河包镇'),
	(50, 01, 53, 110, '观胜镇'),
	(50, 01, 53, 111, '铜鼓镇'),
	(50, 01, 53, 112, '清流镇'),
	(50, 01, 53, 113, '远觉镇'),
	(50, 01, 53, 114, '龙集镇');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 28, 001, '梁平县梁山街道'),
	(50, 02, 28, 002, '梁平县双桂街道'),
	(50, 02, 28, 101, '仁贤镇'),
	(50, 02, 28, 102, '礼让镇'),
	(50, 02, 28, 103, '云龙镇'),
	(50, 02, 28, 104, '屏锦镇'),
	(50, 02, 28, 106, '袁驿镇'),
	(50, 02, 28, 107, '新盛镇'),
	(50, 02, 28, 108, '福禄镇'),
	(50, 02, 28, 109, '金带镇'),
	(50, 02, 28, 110, '聚奎镇'),
	(50, 02, 28, 111, '明达镇'),
	(50, 02, 28, 112, '荫平镇'),
	(50, 02, 28, 113, '和林镇'),
	(50, 02, 28, 114, '回龙镇'),
	(50, 02, 28, 115, '碧山镇'),
	(50, 02, 28, 116, '虎城镇'),
	(50, 02, 28, 117, '七星镇'),
	(50, 02, 28, 118, '龙门镇'),
	(50, 02, 28, 119, '文化镇'),
	(50, 02, 28, 120, '合兴镇'),
	(50, 02, 28, 121, '石安镇'),
	(50, 02, 28, 122, '柏家镇'),
	(50, 02, 28, 123, '大观镇'),
	(50, 02, 28, 124, '竹山镇'),
	(50, 02, 28, 125, '蟠龙镇'),
	(50, 02, 28, 200, '安胜乡'),
	(50, 02, 28, 201, '铁门乡'),
	(50, 02, 28, 202, '龙胜乡'),
	(50, 02, 28, 203, '复平乡'),
	(50, 02, 28, 205, '紫照乡'),
	(50, 02, 28, 206, '城北乡'),
	(50, 02, 28, 207, '曲水乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 29, 001, '葛城街道'),
	(50, 02, 29, 002, '复兴街道'),
	(50, 02, 29, 102, '巴山镇'),
	(50, 02, 29, 103, '坪坝镇'),
	(50, 02, 29, 104, '庙坝镇'),
	(50, 02, 29, 105, '明通镇'),
	(50, 02, 29, 106, '修齐镇'),
	(50, 02, 29, 107, '高观镇'),
	(50, 02, 29, 108, '高燕镇'),
	(50, 02, 29, 109, '东安镇'),
	(50, 02, 29, 110, '咸宜镇'),
	(50, 02, 29, 111, '高楠镇'),
	(50, 02, 29, 201, '龙田乡'),
	(50, 02, 29, 202, '北屏乡'),
	(50, 02, 29, 205, '左岚乡'),
	(50, 02, 29, 208, '沿河乡'),
	(50, 02, 29, 210, '双河乡'),
	(50, 02, 29, 211, '蓼子乡'),
	(50, 02, 29, 212, '鸡鸣乡'),
	(50, 02, 29, 214, '周溪乡'),
	(50, 02, 29, 216, '明中乡'),
	(50, 02, 29, 217, '治平乡'),
	(50, 02, 29, 219, '岚天乡'),
	(50, 02, 29, 220, '厚坪乡'),
	(50, 02, 29, 221, '河鱼乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 30, 001, '三合街道'),
	(50, 02, 30, 002, '名山街道'),
	(50, 02, 30, 101, '虎威镇'),
	(50, 02, 30, 102, '社坛镇'),
	(50, 02, 30, 103, '三元镇'),
	(50, 02, 30, 104, '许明寺镇'),
	(50, 02, 30, 105, '董家镇'),
	(50, 02, 30, 106, '树人镇'),
	(50, 02, 30, 107, '十直镇'),
	(50, 02, 30, 109, '高家镇'),
	(50, 02, 30, 110, '兴义镇'),
	(50, 02, 30, 111, '双路镇'),
	(50, 02, 30, 112, '江池镇'),
	(50, 02, 30, 113, '龙河镇'),
	(50, 02, 30, 114, '武平镇'),
	(50, 02, 30, 115, '包鸾镇'),
	(50, 02, 30, 116, '湛普镇'),
	(50, 02, 30, 118, '南天湖镇'),
	(50, 02, 30, 119, '保合镇'),
	(50, 02, 30, 120, '兴龙镇'),
	(50, 02, 30, 121, '仁沙镇'),
	(50, 02, 30, 122, '龙孔镇'),
	(50, 02, 30, 123, '暨龙镇'),
	(50, 02, 30, 124, '双龙镇'),
	(50, 02, 30, 125, '仙女湖镇'),
	(50, 02, 30, 202, '青龙乡'),
	(50, 02, 30, 206, '太平坝乡'),
	(50, 02, 30, 207, '都督乡'),
	(50, 02, 30, 209, '栗子乡'),
	(50, 02, 30, 210, '三建乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 31, 001, '桂溪街道'),
	(50, 02, 31, 002, '桂阳街道'),
	(50, 02, 31, 101, '新民镇'),
	(50, 02, 31, 102, '沙坪镇'),
	(50, 02, 31, 103, '周嘉镇'),
	(50, 02, 31, 104, '普顺镇'),
	(50, 02, 31, 105, '永安镇'),
	(50, 02, 31, 106, '高安镇'),
	(50, 02, 31, 107, '高峰镇'),
	(50, 02, 31, 108, '五洞镇'),
	(50, 02, 31, 109, '澄溪镇'),
	(50, 02, 31, 110, '太平镇'),
	(50, 02, 31, 111, '鹤游镇'),
	(50, 02, 31, 112, '坪山镇'),
	(50, 02, 31, 113, '砚台镇'),
	(50, 02, 31, 114, '曹回镇'),
	(50, 02, 31, 115, '杠家镇'),
	(50, 02, 31, 116, '包家镇'),
	(50, 02, 31, 117, '白家镇'),
	(50, 02, 31, 118, '永平镇'),
	(50, 02, 31, 119, '三溪镇'),
	(50, 02, 31, 120, '裴兴镇'),
	(50, 02, 31, 121, '黄沙镇'),
	(50, 02, 31, 122, '长龙镇'),
	(50, 02, 31, 202, '沙河乡'),
	(50, 02, 31, 204, '大石乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 32, 100, '巷口镇'),
	(50, 02, 32, 101, '火炉镇'),
	(50, 02, 32, 102, '白马镇'),
	(50, 02, 32, 103, '鸭江镇'),
	(50, 02, 32, 104, '长坝镇'),
	(50, 02, 32, 105, '江口镇'),
	(50, 02, 32, 106, '平桥镇'),
	(50, 02, 32, 107, '羊角镇'),
	(50, 02, 32, 108, '仙女山镇'),
	(50, 02, 32, 109, '桐梓镇'),
	(50, 02, 32, 110, '土坎镇'),
	(50, 02, 32, 111, '和顺镇'),
	(50, 02, 32, 200, '凤来乡'),
	(50, 02, 32, 202, '庙垭乡'),
	(50, 02, 32, 203, '石桥苗族土家族乡'),
	(50, 02, 32, 204, '双河乡'),
	(50, 02, 32, 205, '黄莺乡'),
	(50, 02, 32, 206, '沧沟乡'),
	(50, 02, 32, 207, '文复苗族土家族乡'),
	(50, 02, 32, 208, '土地乡'),
	(50, 02, 32, 209, '白云乡'),
	(50, 02, 32, 210, '后坪苗族土家族乡'),
	(50, 02, 32, 211, '浩口苗族仡佬族乡'),
	(50, 02, 32, 212, '接龙乡'),
	(50, 02, 32, 213, '赵家乡'),
	(50, 02, 32, 214, '铁矿乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 33, 001, '忠州街道'),
	(50, 02, 33, 002, '白公街道'),
	(50, 02, 33, 101, '新生镇'),
	(50, 02, 33, 102, '任家镇'),
	(50, 02, 33, 103, '乌杨镇'),
	(50, 02, 33, 104, '洋渡镇'),
	(50, 02, 33, 105, '东溪镇'),
	(50, 02, 33, 106, '复兴镇'),
	(50, 02, 33, 107, '石宝镇'),
	(50, 02, 33, 108, '汝溪镇'),
	(50, 02, 33, 109, '野鹤镇'),
	(50, 02, 33, 110, '官坝镇'),
	(50, 02, 33, 111, '石黄镇'),
	(50, 02, 33, 112, '马灌镇'),
	(50, 02, 33, 113, '金鸡镇'),
	(50, 02, 33, 114, '新立镇'),
	(50, 02, 33, 115, '双桂镇'),
	(50, 02, 33, 116, '拔山镇'),
	(50, 02, 33, 117, '花桥镇'),
	(50, 02, 33, 118, '永丰镇'),
	(50, 02, 33, 119, '三汇镇'),
	(50, 02, 33, 120, '白石镇'),
	(50, 02, 33, 122, '黄金镇'),
	(50, 02, 33, 201, '善广乡'),
	(50, 02, 33, 203, '石子乡'),
	(50, 02, 33, 204, '磨子土家族乡'),
	(50, 02, 33, 206, '涂井乡'),
	(50, 02, 33, 208, '金声乡'),
	(50, 02, 33, 210, '兴峰乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 34, 002, '镇东街道'),
	(50, 02, 34, 003, '丰乐街道'),
	(50, 02, 34, 004, '白鹤街道'),
	(50, 02, 34, 005, '汉丰街道'),
	(50, 02, 34, 006, '文峰街道'),
	(50, 02, 34, 007, '云枫街道'),
	(50, 02, 34, 008, '赵家街道'),
	(50, 02, 34, 103, '郭家镇'),
	(50, 02, 34, 106, '温泉镇'),
	(50, 02, 34, 107, '铁桥镇'),
	(50, 02, 34, 112, '南雅镇'),
	(50, 02, 34, 114, '和谦镇'),
	(50, 02, 34, 116, '镇安镇'),
	(50, 02, 34, 118, '竹溪镇'),
	(50, 02, 34, 119, '渠口镇'),
	(50, 02, 34, 120, '厚坝镇'),
	(50, 02, 34, 122, '高桥镇'),
	(50, 02, 34, 127, '义和镇'),
	(50, 02, 34, 128, '大进镇'),
	(50, 02, 34, 129, '长沙镇'),
	(50, 02, 34, 130, '临江镇'),
	(50, 02, 34, 132, '敦好镇'),
	(50, 02, 34, 133, '中和镇'),
	(50, 02, 34, 134, '岳溪镇'),
	(50, 02, 34, 135, '南门镇'),
	(50, 02, 34, 136, '河堰镇'),
	(50, 02, 34, 137, '九龙山镇'),
	(50, 02, 34, 138, '白桥镇'),
	(50, 02, 34, 139, '天和镇'),
	(50, 02, 34, 140, '金峰镇'),
	(50, 02, 34, 141, '谭家镇'),
	(50, 02, 34, 142, '巫山镇'),
	(50, 02, 34, 143, '大德镇'),
	(50, 02, 34, 202, '白泉乡'),
	(50, 02, 34, 203, '关面乡'),
	(50, 02, 34, 204, '满月乡'),
	(50, 02, 34, 211, '五通乡'),
	(50, 02, 34, 215, '麻柳乡'),
	(50, 02, 34, 216, '紫水乡'),
	(50, 02, 34, 225, '三汇口乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 35, 001, '双江街道'),
	(50, 02, 35, 002, '青龙街道'),
	(50, 02, 35, 003, '人和街道'),
	(50, 02, 35, 004, '盘龙街道'),
	(50, 02, 35, 105, '龙角镇'),
	(50, 02, 35, 107, '故陵镇'),
	(50, 02, 35, 108, '红狮镇'),
	(50, 02, 35, 115, '路阳镇'),
	(50, 02, 35, 116, '农坝镇'),
	(50, 02, 35, 118, '渠马镇'),
	(50, 02, 35, 121, '黄石镇'),
	(50, 02, 35, 122, '巴阳镇'),
	(50, 02, 35, 123, '沙市镇'),
	(50, 02, 35, 124, '鱼泉镇'),
	(50, 02, 35, 125, '凤鸣镇'),
	(50, 02, 35, 127, '宝坪镇'),
	(50, 02, 35, 128, '南溪镇'),
	(50, 02, 35, 129, '双土镇'),
	(50, 02, 35, 130, '桑坪镇'),
	(50, 02, 35, 131, '江口镇'),
	(50, 02, 35, 132, '高阳镇'),
	(50, 02, 35, 133, '平安镇'),
	(50, 02, 35, 135, '云阳镇'),
	(50, 02, 35, 136, '云安镇'),
	(50, 02, 35, 137, '栖霞镇'),
	(50, 02, 35, 138, '双龙镇'),
	(50, 02, 35, 139, '泥溪镇'),
	(50, 02, 35, 140, '票草镇'),
	(50, 02, 35, 141, '养鹿镇'),
	(50, 02, 35, 142, '水口镇'),
	(50, 02, 35, 143, '堰坪镇'),
	(50, 02, 35, 144, '龙洞镇'),
	(50, 02, 35, 145, '后叶镇'),
	(50, 02, 35, 208, '外郎乡'),
	(50, 02, 35, 210, '耀灵乡'),
	(50, 02, 35, 215, '新津乡'),
	(50, 02, 35, 216, '普安乡'),
	(50, 02, 35, 218, '洞鹿乡'),
	(50, 02, 35, 219, '石门乡'),
	(50, 02, 35, 220, '大阳乡'),
	(50, 02, 35, 239, '上坝乡'),
	(50, 02, 35, 242, '清水土家族自治乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 36, 001, '永安街道'),
	(50, 02, 36, 002, '鱼复街道'),
	(50, 02, 36, 003, '夔门街道'),
	(50, 02, 36, 117, '白帝镇'),
	(50, 02, 36, 118, '草堂镇'),
	(50, 02, 36, 119, '汾河镇'),
	(50, 02, 36, 120, '康乐镇'),
	(50, 02, 36, 121, '大树镇'),
	(50, 02, 36, 122, '竹园镇'),
	(50, 02, 36, 123, '公平镇'),
	(50, 02, 36, 124, '朱衣镇'),
	(50, 02, 36, 125, '甲高镇'),
	(50, 02, 36, 126, '羊市镇'),
	(50, 02, 36, 127, '吐祥镇'),
	(50, 02, 36, 128, '兴隆镇'),
	(50, 02, 36, 129, '青龙镇'),
	(50, 02, 36, 130, '新民镇'),
	(50, 02, 36, 131, '永乐镇'),
	(50, 02, 36, 132, '安坪镇'),
	(50, 02, 36, 133, '五马镇'),
	(50, 02, 36, 134, '青莲镇'),
	(50, 02, 36, 215, '岩湾乡'),
	(50, 02, 36, 216, '平安乡'),
	(50, 02, 36, 217, '红土乡'),
	(50, 02, 36, 219, '石岗乡'),
	(50, 02, 36, 220, '康坪乡'),
	(50, 02, 36, 222, '太和土家族乡'),
	(50, 02, 36, 224, '鹤峰乡'),
	(50, 02, 36, 225, '冯坪乡'),
	(50, 02, 36, 226, '长安土家族乡'),
	(50, 02, 36, 227, '龙桥土家族乡'),
	(50, 02, 36, 228, '云雾土家族乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 37, 001, '高唐街道'),
	(50, 02, 37, 002, '龙门街道'),
	(50, 02, 37, 101, '庙宇镇'),
	(50, 02, 37, 102, '大昌镇'),
	(50, 02, 37, 103, '福田镇'),
	(50, 02, 37, 104, '龙溪镇'),
	(50, 02, 37, 105, '双龙镇'),
	(50, 02, 37, 106, '官阳镇'),
	(50, 02, 37, 107, '骡坪镇'),
	(50, 02, 37, 108, '抱龙镇'),
	(50, 02, 37, 109, '官渡镇'),
	(50, 02, 37, 110, '铜鼓镇'),
	(50, 02, 37, 111, '巫峡镇'),
	(50, 02, 37, 200, '红椿乡'),
	(50, 02, 37, 207, '两坪乡'),
	(50, 02, 37, 208, '曲尺乡'),
	(50, 02, 37, 210, '建坪乡'),
	(50, 02, 37, 211, '大溪乡'),
	(50, 02, 37, 214, '金坪乡'),
	(50, 02, 37, 216, '平河乡'),
	(50, 02, 37, 219, '当阳乡'),
	(50, 02, 37, 222, '竹贤乡'),
	(50, 02, 37, 225, '三溪乡'),
	(50, 02, 37, 227, '培石乡'),
	(50, 02, 37, 229, '笃坪乡'),
	(50, 02, 37, 231, '邓家乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 38, 001, '宁河街道'),
	(50, 02, 38, 002, '柏杨街道'),
	(50, 02, 38, 100, '城厢镇'),
	(50, 02, 38, 101, '凤凰镇'),
	(50, 02, 38, 102, '宁厂镇'),
	(50, 02, 38, 103, '上磺镇'),
	(50, 02, 38, 104, '古路镇'),
	(50, 02, 38, 105, '文峰镇'),
	(50, 02, 38, 106, '徐家镇'),
	(50, 02, 38, 107, '白鹿镇'),
	(50, 02, 38, 108, '尖山镇'),
	(50, 02, 38, 109, '下堡镇'),
	(50, 02, 38, 110, '峰灵镇'),
	(50, 02, 38, 111, '塘坊镇'),
	(50, 02, 38, 112, '朝阳镇'),
	(50, 02, 38, 113, '田坝镇'),
	(50, 02, 38, 114, '通城镇'),
	(50, 02, 38, 204, '胜利乡'),
	(50, 02, 38, 205, '菱角乡'),
	(50, 02, 38, 207, '大河乡'),
	(50, 02, 38, 208, '天星乡'),
	(50, 02, 38, 210, '长桂乡'),
	(50, 02, 38, 212, '蒲莲乡'),
	(50, 02, 38, 226, '鱼鳞乡'),
	(50, 02, 38, 227, '乌龙乡'),
	(50, 02, 38, 234, '中岗乡'),
	(50, 02, 38, 237, '花台乡'),
	(50, 02, 38, 239, '兰英乡'),
	(50, 02, 38, 240, '双阳乡'),
	(50, 02, 38, 242, '中梁乡'),
	(50, 02, 38, 243, '天元乡'),
	(50, 02, 38, 245, '土城乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 40, 100, '南宾镇'),
	(50, 02, 40, 101, '西沱镇'),
	(50, 02, 40, 102, '下路镇'),
	(50, 02, 40, 103, '悦崃镇'),
	(50, 02, 40, 104, '临溪镇'),
	(50, 02, 40, 105, '黄水镇'),
	(50, 02, 40, 106, '马武镇'),
	(50, 02, 40, 107, '沙子镇'),
	(50, 02, 40, 108, '王场镇'),
	(50, 02, 40, 109, '沿溪镇'),
	(50, 02, 40, 110, '龙沙镇'),
	(50, 02, 40, 111, '鱼池镇'),
	(50, 02, 40, 112, '三河镇'),
	(50, 02, 40, 113, '大歇镇'),
	(50, 02, 40, 114, '桥头镇'),
	(50, 02, 40, 115, '万朝镇'),
	(50, 02, 40, 116, '冷水镇'),
	(50, 02, 40, 117, '黄鹤镇'),
	(50, 02, 40, 203, '黎场乡'),
	(50, 02, 40, 204, '三星乡'),
	(50, 02, 40, 205, '六塘乡'),
	(50, 02, 40, 207, '三益乡'),
	(50, 02, 40, 208, '王家乡'),
	(50, 02, 40, 209, '河嘴乡'),
	(50, 02, 40, 210, '石家乡'),
	(50, 02, 40, 212, '枫木乡'),
	(50, 02, 40, 213, '中益乡'),
	(50, 02, 40, 214, '洗新乡'),
	(50, 02, 40, 216, '龙潭乡'),
	(50, 02, 40, 217, '新乐乡'),
	(50, 02, 40, 218, '金铃乡'),
	(50, 02, 40, 219, '金竹乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 41, 001, '中和街道'),
	(50, 02, 41, 002, '乌杨街道'),
	(50, 02, 41, 003, '平凯街道'),
	(50, 02, 41, 102, '清溪场镇'),
	(50, 02, 41, 103, '隘口镇'),
	(50, 02, 41, 104, '溶溪镇'),
	(50, 02, 41, 105, '官庄镇'),
	(50, 02, 41, 106, '龙池镇'),
	(50, 02, 41, 107, '石堤镇'),
	(50, 02, 41, 108, '峨溶镇'),
	(50, 02, 41, 109, '洪安镇'),
	(50, 02, 41, 110, '雅江镇'),
	(50, 02, 41, 111, '石耶镇'),
	(50, 02, 41, 112, '梅江镇'),
	(50, 02, 41, 113, '兰桥镇'),
	(50, 02, 41, 114, '膏田镇'),
	(50, 02, 41, 115, '溪口镇'),
	(50, 02, 41, 116, '妙泉镇'),
	(50, 02, 41, 117, '宋农镇'),
	(50, 02, 41, 118, '里仁镇'),
	(50, 02, 41, 119, '钟灵镇'),
	(50, 02, 41, 201, '孝溪乡'),
	(50, 02, 41, 207, '海洋乡'),
	(50, 02, 41, 208, '大溪乡'),
	(50, 02, 41, 211, '涌洞乡'),
	(50, 02, 41, 214, '中平乡'),
	(50, 02, 41, 215, '岑溪乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 42, 001, '桃花源街道'),
	(50, 02, 42, 002, '钟多街道'),
	(50, 02, 42, 101, '龙潭镇'),
	(50, 02, 42, 102, '麻旺镇'),
	(50, 02, 42, 103, '酉酬镇'),
	(50, 02, 42, 104, '大溪镇'),
	(50, 02, 42, 105, '兴隆镇'),
	(50, 02, 42, 106, '黑水镇'),
	(50, 02, 42, 107, '丁市镇'),
	(50, 02, 42, 108, '龚滩镇'),
	(50, 02, 42, 109, '李溪镇'),
	(50, 02, 42, 110, '泔溪镇'),
	(50, 02, 42, 111, '酉水河镇'),
	(50, 02, 42, 112, '苍岭镇'),
	(50, 02, 42, 113, '小河镇'),
	(50, 02, 42, 114, '板溪镇'),
	(50, 02, 42, 200, '涂市乡'),
	(50, 02, 42, 202, '铜鼓乡'),
	(50, 02, 42, 204, '可大乡'),
	(50, 02, 42, 205, '偏柏乡'),
	(50, 02, 42, 206, '五福乡'),
	(50, 02, 42, 207, '木叶乡'),
	(50, 02, 42, 208, '毛坝乡'),
	(50, 02, 42, 209, '花田乡'),
	(50, 02, 42, 210, '后坪乡'),
	(50, 02, 42, 211, '天馆乡'),
	(50, 02, 42, 212, '宜居乡'),
	(50, 02, 42, 213, '万木乡'),
	(50, 02, 42, 214, '两罾乡'),
	(50, 02, 42, 215, '板桥乡'),
	(50, 02, 42, 216, '官清乡'),
	(50, 02, 42, 217, '南腰界乡'),
	(50, 02, 42, 218, '车田乡'),
	(50, 02, 42, 219, '腴地乡'),
	(50, 02, 42, 220, '清泉乡'),
	(50, 02, 42, 221, '庙溪乡'),
	(50, 02, 42, 222, '浪坪乡'),
	(50, 02, 42, 223, '双泉乡'),
	(50, 02, 42, 224, '楠木乡');

INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
	(50, 02, 43, 001, '汉葭街道'),
	(50, 02, 43, 002, '绍庆街道'),
	(50, 02, 43, 003, '靛水街道'),
	(50, 02, 43, 101, '保家镇'),
	(50, 02, 43, 102, '郁山镇'),
	(50, 02, 43, 103, '高谷镇'),
	(50, 02, 43, 104, '桑柘镇'),
	(50, 02, 43, 105, '鹿角镇'),
	(50, 02, 43, 106, '黄家镇'),
	(50, 02, 43, 107, '普子镇'),
	(50, 02, 43, 108, '龙射镇'),
	(50, 02, 43, 109, '连湖镇'),
	(50, 02, 43, 110, '万足镇'),
	(50, 02, 43, 111, '平安镇'),
	(50, 02, 43, 112, '长生镇'),
	(50, 02, 43, 113, '新田镇'),
	(50, 02, 43, 114, '鞍子镇'),
	(50, 02, 43, 115, '太原镇'),
	(50, 02, 43, 116, '龙溪镇'),
	(50, 02, 43, 117, '梅子垭镇'),
	(50, 02, 43, 118, '大同镇'),
	(50, 02, 43, 201, '岩东乡'),
	(50, 02, 43, 202, '鹿鸣乡'),
	(50, 02, 43, 204, '棣棠乡'),
	(50, 02, 43, 206, '三义乡'),
	(50, 02, 43, 207, '联合乡'),
	(50, 02, 43, 208, '石柳乡'),
	(50, 02, 43, 210, '走马乡'),
	(50, 02, 43, 211, '芦塘乡'),
	(50, 02, 43, 213, '乔梓乡'),
	(50, 02, 43, 217, '诸佛乡'),
	(50, 02, 43, 219, '桐楼乡'),
	(50, 02, 43, 222, '善感乡'),
	(50, 02, 43, 223, '双龙乡'),
	(50, 02, 43, 224, '石盘乡'),
	(50, 02, 43, 225, '大垭乡'),
	(50, 02, 43, 226, '润溪乡'),
	(50, 02, 43, 227, '朗溪乡'),
	(50, 02, 43, 228, '龙塘乡');