/*
Navicat Premium Data Transfer
Source Server : bole dev
Source Server Type : MySQL
Source Server Version : 50728
Source Host : 192.168.10.33:3306
Source Schema : jm_bole_basedata
Target Server Type : MySQL
Target Server Version : 50728
File Encoding : 65001
Date: 19/08/2020 16:33:53
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for district
-- ----------------------------
DROP TABLE IF EXISTS `district`;
CREATE TABLE `district` (
`id` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区划代码',
`pid` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级区划代码',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
`pinyin` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称拼音',
`sname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
`code` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行政区划代码(街道无区划代码)',
`longitude` decimal(10, 7) NULL DEFAULT NULL COMMENT '经度',
`latitude` decimal(10, 7) NULL DEFAULT NULL COMMENT '维度',
`long_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全路径',
`level` int(11) NULL DEFAULT NULL COMMENT '等级(0:国家 1:省份 2:城市 3:区县 4:乡镇街道)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'bole标准地址库' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of district
-- ----------------------------
INSERT INTO `district` VALUES ('100000000000', '0', '中华人民共和国', '', '中国', '100000', 116.3683244, 39.9150850, '中华人民共和国', 0);
INSERT INTO `district` VALUES ('110000000000', '100000000000', '北京市', 'bei jing shi', '北京', '110000', 116.4052850, 39.9049890, '北京市', 1);
INSERT INTO `district` VALUES ('110100000000', '110000000000', '北京市', 'bei jing shi', '北京', '110100', 116.4052850, 39.9049890, '北京市,北京市', 2);
INSERT INTO `district` VALUES ('110101000000', '110100000000', '东城区', 'dong cheng qu', '东城', '110101', 116.4187570, 39.9175440, '北京市,北京市,东城区', 3);
INSERT INTO `district` VALUES ('110101001000', '110101000000', '东华门街道', 'dong hua men jie dao', '东华门', '110101', 116.4170000, 39.9237000, '北京市,北京市,东城区,东华门街道', 4);
INSERT INTO `district` VALUES ('110101002000', '110101000000', '景山街道', 'jing shan jie dao', '景山', '110101', 116.3980000, 39.9326000, '北京市,北京市,东城区,景山街道', 4);
INSERT INTO `district` VALUES ('110101003000', '110101000000', '交道口街道', 'jiao dao kou jie dao', '交道口', '110101', 116.3990000, 39.9410000, '北京市,北京市,东城区,交道口街道', 4);
INSERT INTO `district` VALUES ('110101004000', '110101000000', '安定门街道', 'an ding men jie dao', '安定门', '110101', 116.4160000, 39.9454000, '北京市,北京市,东城区,安定门街道', 4);
INSERT INTO `district` VALUES ('110101005000', '110101000000', '北新桥街道', 'bei xin qiao jie dao', '北新桥', '110101', 116.4160000, 39.9430000, '北京市,北京市,东城区,北新桥街道', 4);
INSERT INTO `district` VALUES ('110101006000', '110101000000', '东四街道', 'dong si jie dao', '东四', '110101', 116.4330000, 39.9339000, '北京市,北京市,东城区,东四街道', 4);
INSERT INTO `district` VALUES ('110101007000', '110101000000', '朝阳门街道', 'chao yang men jie dao', '朝阳门', '110101', 116.4190000, 39.9255000, '北京市,北京市,东城区,朝阳门街道', 4);
INSERT INTO `district` VALUES ('110101008000', '110101000000', '建国门街道', 'jian guo men jie dao', '建国门', '110101', 116.4240000, 39.9180000, '北京市,北京市,东城区,建国门街道', 4);
INSERT INTO `district` VALUES ('110101009000', '110101000000', '东直门街道', 'dong zhi men jie dao', '东直门', '110101', 116.4360000, 39.9508000, '北京市,北京市,东城区,东直门街道', 4);
INSERT INTO `district` VALUES ('110101010000', '110101000000', '和平里街道', 'he ping li jie dao', '和平里', '110101', 116.4250000, 39.9622000, '北京市,北京市,东城区,和平里街道', 4);
INSERT INTO `district` VALUES ('110101011000', '110101000000', '前门街道', 'qian men jie dao', '前门', '110101', 116.4110000, 39.8989000, '北京市,北京市,东城区,前门街道', 4);
INSERT INTO `district` VALUES ('110101012000', '110101000000', '崇文门外街道', 'chong wen men wai jie dao', '崇文门外', '110101', 116.4100000, 39.8983000, '北京市,北京市,东城区,崇文门外街道', 4);
INSERT INTO `district` VALUES ('110101013000', '110101000000', '东花市街道', 'dong hua shi jie dao', '东花市', '110101', 116.4350000, 39.9014000, '北京市,北京市,东城区,东花市街道', 4);
INSERT INTO `district` VALUES ('110101014000', '110101000000', '龙潭街道', 'long tan jie dao', '龙潭', '110101', 116.4280000, 39.8935000, '北京市,北京市,东城区,龙潭街道', 4);
INSERT INTO `district` VALUES ('110101015000', '110101000000', '体育馆路街道', 'ti yu guan lu jie dao', '体育馆路', '110101', 116.4180000, 39.8931000, '北京市,北京市,东城区,体育馆路街道', 4);
INSERT INTO `district` VALUES ('110101016000', '110101000000', '天坛街道', 'tian tan jie dao', '天坛', '110101', 116.3990000, 39.8767000, '北京市,北京市,东城区,天坛街道', 4);
INSERT INTO `district` VALUES ('110101017000', '110101000000', '永定门外街道', 'yong ding men wai jie dao', '永定门外', '110101', 116.3920000, 39.8718000, '北京市,北京市,东城区,永定门外街道', 4);
INSERT INTO `district` VALUES ('110102000000', '110100000000', '西城区', 'xi cheng qu', '西城', '110102', 116.3667940, 39.9153090, '北京市,北京市,西城区', 3);
INSERT INTO `district` VALUES ('110102001000', '110102000000', '西长安街街道', 'xi chang an jie jie dao', '西长安街', '110102', 116.3730000, 39.9224000, '北京市,北京市,西城区,西长安街街道', 4);
INSERT INTO `district` VALUES ('110102003000', '110102000000', '新街口街道', 'xin jie kou jie dao', '新街口', '110102', 116.3680000, 39.9476000, '北京市,北京市,西城区,新街口街道', 4);
INSERT INTO `district` VALUES ('110102007000', '110102000000', '月坛街道', 'yue tan jie dao', '月坛', '110102', 116.3500000, 39.9184000, '北京市,北京市,西城区,月坛街道', 4);
INSERT INTO `district` VALUES ('110102009000', '110102000000', '展览路街道', 'zhan lan lu jie dao', '展览路', '110102', 116.3500000, 39.9429000, '北京市,北京市,西城区,展览路街道', 4);
INSERT INTO `district` VALUES ('110102010000', '110102000000', '德胜街道', 'de sheng jie dao', '德胜', '110102', 116.3940000, 39.9559000, '北京市,北京市,西城区,德胜街道', 4);
INSERT INTO `district` VALUES ('110102011000', '110102000000', '金融街街道', 'jin rong jie jie dao', '金融街', '110102', 116.3730000, 39.9037000, '北京市,北京市,西城区,金融街街道', 4);
INSERT INTO `district` VALUES ('110102012000', '110102000000', '什刹海街道', 'shen cha hai jie dao', '什刹海', '110102', 116.3940000, 39.9425000, '北京市,北京市,西城区,什刹海街道', 4);
INSERT INTO `district` VALUES ('110102013000', '110102000000', '大栅栏街道', 'da zha lan jie dao', '大栅栏', '110102', 116.3960000, 39.9002000, '北京市,北京市,西城区,大栅栏街道', 4);
INSERT INTO `district` VALUES ('110102014000', '110102000000', '天桥街道', 'tian qiao jie dao', '天桥', '110102', 116.3980000, 39.8912000, '北京市,北京市,西城区,天桥�
最新版全国四级地址库,包含省市区街道四级,包括港澳台相关数据
5星 · 超过95%的资源 需积分: 49 69 浏览量
2020-08-19
16:35:32
上传
评论 1
收藏 4.14MB ZIP 举报
搬砖赚钱养家
- 粉丝: 17
- 资源: 16