Mysql-街道邮编数据库 精确到街道完整库

/* Navicat MySQL Data Transfer Source Server : local_hliedu Source Server Version : 80014 Source Host : localhost:3306 Source Database : opsoft Target Server Type : MYSQL Target Server Version : 80014 File Encoding : 65001 Date: 2019-02-12 12:06:58 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for bs_street -- ---------------------------- DROP TABLE IF EXISTS `bs_street`; CREATE TABLE `bs_street` ( `STREET_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列', `STREET_CODE` varchar(40) NOT NULL COMMENT '街道代码', `AREA_CODE` varchar(40) DEFAULT NULL COMMENT '父级区代码', `STREET_NAME` varchar(50) NOT NULL COMMENT '街道名称', `SHORT_NAME` varchar(30) NOT NULL COMMENT '简称', `LNG` varchar(20) DEFAULT NULL COMMENT '经度', `LAT` varchar(20) DEFAULT NULL COMMENT '纬度', `SORT` int(6) DEFAULT NULL COMMENT '排序', `GMT_CREATE` datetime DEFAULT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime DEFAULT NULL COMMENT '修改时间', `MEMO` varchar(250) DEFAULT NULL COMMENT '备注', `DATA_STATE` int(11) DEFAULT NULL COMMENT '状态', `TENANT_CODE` varchar(32) DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`STREET_ID`), KEY `Index_1` (`STREET_CODE`,`TENANT_CODE`) ) ENGINE=InnoDB AUTO_INCREMENT=65536 DEFAULT CHARSET=utf8 COMMENT='街道设置'; -- ---------------------------- -- Records of bs_street -- ---------------------------- INSERT INTO `bs_street` VALUES ('1', '110101001', '110101', '东华门街道', '东华门街道', '116.409607', '39.917973', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('2', '110101002', '110101', '景山街道', '景山街道', '116.410049', '39.92688', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('3', '110101003', '110101', '交道口街道', '交道口街道', '116.405479', '39.9366', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('4', '110101004', '110101', '安定门街道', '安定门街道', '116.403862', '39.944294', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('5', '110101005', '110101', '北新桥街道', '北新桥街道', '116.424095', '39.942024', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('6', '110101006', '110101', '东四街道', '东四街道', '116.423729', '39.93026', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('7', '110101007', '110101', '朝阳门街道', '朝阳门街道', '116.428055', '39.9188', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('8', '110101008', '110101', '建国门街道', '建国门街道', '116.426224', '39.910351', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('9', '110101009', '110101', '东直门街道', '东直门街道', '116.440498', '39.934071', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('10', '110101010', '110101', '和平里街道', '和平里街道', '116.42347', '39.954552', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('11', '110101011', '110101', '前门街道', '前门街道', '116.40834', '39.898033', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('12', '110101012', '110101', '崇文门外街道', '崇文门外街道', '116.412598', '39.89743', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('13', '110101013', '110101', '东花市街道', '东花市街道', '116.429489', '39.899067', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('14', '110101014', '110101', '龙潭街道', '龙潭街道', '116.436722', '39.887169', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('15', '110101015', '110101', '体育馆路街道', '体育馆路街道', '116.418755', '39.917545', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('16', '110101016', '110101', '天坛街道', '天坛街道', '116.40004', '39.889736', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('17', '110101017', '110101', '永定门外街道', '永定门外街道', '116.401382', '39.866001', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('18', '110102001', '110102', '西长安街街道', '西长安街街道', '116.366791', '39.91531', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('19', '110102003', '110102', '新街口街道', '新街口街道', '116.370972', '39.943054', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('20', '110102007', '110102', '月坛街道', '月坛街道', '116.344398', '39.915092', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('21', '110102009', '110102', '展览路街道', '展览路街道', '116.366791', '39.91531', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('22', '110102010', '110102', '德胜街道', '德胜街道', '116.366791', '39.91531', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('23', '110102011', '110102', '金融街街道', '金融街街道', '116.366791', '39.91531', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('24', '110102012', '110102', '什刹海街道', '什刹海街道', '116.366791', '39.91531', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('25', '110102013', '110102', '大栅栏街道', '大栅栏街道', '116.39399', '39.893547', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('26', '110102014', '110102', '天桥街道', '天桥街道', '116.386925', '39.884876', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('27', '110102015', '110102', '椿树街道', '椿树街道', '116.375763', '39.899055', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('28', '110102016', '110102', '陶然亭街道', '陶然亭街道', '116.380646', '39.883484', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('29', '110102017', '110102', '广安门内街道', '广安门内街道', '116.362999', '39.889526', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('30', '110102018', '110102', '牛街街道', '牛街街道', '116.366791', '39.91531', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('31', '110102019', '110102', '白纸坊街道', '白纸坊街道', '116.363579', '39.877087', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('32', '110102020', '110102', '广安门外街道', '广安门外街道', '116.340057', '39.890453', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000'); INSERT INTO `bs_street` VALUES ('33', '110105001', '110105', '建外街道', '建外街道', '116.486412', '39.92149', '18'