杭州地区，街道sql，用于项目的地址查询

最新推荐文章于 2023-03-13 16:03:57 发布

lvbu89757

最新推荐文章于 2023-03-13 16:03:57 发布

阅读量603

点赞数

CC 4.0 BY-SA版权

分类专栏： django图书馆项目后端实现流程 django项目后端流程

本文链接：https://blog.youkuaiyun.com/lvbu89757/article/details/95219769

这篇博客提供了杭州各个区县街道的SQL插入语句，包括上城区、下城区、江干区等多个区域的街道信息，方便进行地址查询相关项目的开发。

INSERT INTO areas VALUES (‘330102’, ‘上城区’, NULL);
INSERT INTO areas VALUES (‘330103’, ‘下城区’, NULL);
INSERT INTO areas VALUES (‘330104’, ‘江干区’, NULL);
INSERT INTO areas VALUES (‘330105’, ‘拱墅区’, NULL);
INSERT INTO areas VALUES (‘330106’, ‘西湖区’, NULL);
INSERT INTO areas VALUES (‘330108’, ‘滨江区’, NULL);
INSERT INTO areas VALUES (‘330109’, ‘萧山区’, NULL);
INSERT INTO areas VALUES (‘330110’, ‘余杭区’, NULL);
INSERT INTO areas VALUES (‘330122’, ‘桐庐县’, NULL);
INSERT INTO areas VALUES (‘330127’, ‘淳安县’, NULL);
INSERT INTO areas VALUES (‘330182’, ‘建德市’, NULL);
INSERT INTO areas VALUES (‘330183’, ‘富阳市’, NULL);
INSERT INTO areas VALUES (‘330185’, ‘临安市’, NULL);
INSERT INTO areas VALUES (‘330102001’, ‘清波街道’, ‘330102’);
INSERT INTO areas VALUES (‘330102003’, ‘湖滨街道’, ‘330102’);
INSERT INTO areas VALUES (‘330102004’, ‘小营街道’, ‘330102’);
INSERT INTO areas VALUES (‘330102008’, ‘南星街道’, ‘330102’);
INSERT INTO areas VALUES (‘330102009’, ‘紫阳街道’, ‘330102’);
INSERT INTO areas VALUES (‘330102010’, ‘望江街道’, ‘330102’);
INSERT INTO areas VALUES (‘330103001’, ‘长庆街道’, ‘330103’);
INSERT INTO areas VALUES (‘330103002’, ‘武林街道’, ‘330103’);
INSERT INTO areas VALUES (‘330103003’, ‘天水街道’, ‘330103’);
INSERT INTO areas VALUES (‘330103005’, ‘潮鸣街道’, ‘330103’);
INSERT INTO areas VALUES ( ‘330103006’, ‘朝晖街道’, ‘330103’);
INSERT INTO areas VALUES ( ‘330103007’, ‘文晖街道’, ‘330103’);
INSERT INTO areas VALUES ( ‘330103008’, ‘东新街道’, ‘330103’);
INSERT INTO areas VALUES ( ‘330103009’, ‘石桥街道’, ‘330103’);
INSERT INTO areas VALUES ( ‘330104005’, ‘凯旋街道’, ‘330104’);
INSERT INTO areas VALUES ( ‘330104006’, ‘采荷街道’, ‘330104’);
INSERT INTO areas VALUES ( ‘330104007’, ‘闸弄口街道’, ‘330104’);
INSERT INTO areas VALUES ( ‘330104008’, ‘四季青街道’, ‘330104’);
INSERT INTO areas VALUES ( ‘330104009’, ‘白杨街道’, ‘330104’);
INSERT INTO areas VALUES ( ‘330104010’, ‘下沙街道’, ‘330104’);
INSERT INTO areas VALUES ( ‘330104102’, ‘彭埠镇’, ‘330104’);
INSERT INTO areas VALUES ( ‘330104103’, ‘笕桥镇’, ‘330104’);
INSERT INTO areas VALUES ( ‘330104104’, ‘丁桥镇’, ‘330104’);
INSERT INTO areas VALUES ( ‘330104105’, ‘九堡镇’, ‘330104’);
INSERT INTO areas VALUES ( ‘330105001’, ‘米市巷街道’, ‘330105’);
INSERT INTO areas VALUES ( ‘330105002’, ‘湖墅街道’, ‘330105’);
INSERT INTO areas VALUES ( ‘330105003’, ‘小河街道’, ‘330105’);
INSERT INTO areas VALUES ( ‘330105004’, ‘和睦街道’, ‘330105’);
INSERT INTO areas VALUES ( ‘330105005’, ‘拱宸桥街道’, ‘330105’);
INSERT INTO areas VALUES ( ‘330105007’, ‘大关街道’, ‘330105’);
INSERT INTO areas VALUES ( ‘330105008’, ‘上塘街道’