/*
Navicat MySQL Data Transfer
Source Server : dct
Source Server Version : 50522
Source Host : 127.0.0.1:3306
Source Database : n10
Target Server Type : MYSQL
Target Server Version : 50522
File Encoding : 65001
Date: 2020-06-21 09:01:50
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for city
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
`id` bigint(20) NOT NULL COMMENT '区划代码',
`name` varchar(50) DEFAULT NULL COMMENT '名称',
`pid` bigint(20) DEFAULT NULL COMMENT '父级区划代码',
`province_code` bigint(20) DEFAULT NULL COMMENT '省代码',
`city_code` bigint(20) DEFAULT NULL COMMENT '市代码',
`area_code` bigint(20) DEFAULT NULL COMMENT '区代码',
`street_code` bigint(20) DEFAULT NULL COMMENT '街道代码',
`committee_code` bigint(20) DEFAULT NULL COMMENT '居委/社区',
`short_name` varchar(50) DEFAULT NULL COMMENT '简称',
`city_no` varchar(10) DEFAULT NULL COMMENT '区号',
`lng` varchar(20) DEFAULT NULL COMMENT '经度',
`lat` varchar(20) DEFAULT NULL COMMENT '纬度',
`sort` int(11) DEFAULT NULL COMMENT '排序',
`level` int(4) DEFAULT NULL COMMENT '级别: 0-国家 ,1-省, 2-市, 3-区/县, 4-街/镇, 5-社区/居委',
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='2019版全国5级信息表';
-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES ('0', '中国', null, null, null, null, null, null, '中国', null, '', '', '0', '0');
INSERT INTO `city` VALUES ('11', '北京', '0', '11', null, null, null, null, '北京市', '010', '39.904030', '116.407526', '1', '1');
INSERT INTO `city` VALUES ('12', '天津', '0', '12', null, null, null, null, '天津市', '022', '39.084158', '117.200983', '2', '1');
INSERT INTO `city` VALUES ('13', '河北省', '0', '13', null, null, null, null, '河北省', null, '38.037057', '114.468664', '3', '1');
INSERT INTO `city` VALUES ('14', '山西省', '0', '14', null, null, null, null, '山西省', null, '37.873531', '112.562398', '4', '1');
INSERT INTO `city` VALUES ('15', '内蒙古自治区', '0', '15', null, null, null, null, '内蒙古自治区', null, '40.817498', '111.765617', '5', '1');
INSERT INTO `city` VALUES ('21', '辽宁省', '0', '21', null, null, null, null, '辽宁省', null, '41.835441', '123.429440', '6', '1');
INSERT INTO `city` VALUES ('22', '吉林省', '0', '22', null, null, null, null, '吉林省', null, '43.896536', '125.325990', '7', '1');
INSERT INTO `city` VALUES ('23', '黑龙江省', '0', '23', null, null, null, null, '黑龙江省', null, '45.742347', '126.661669', '8', '1');
INSERT INTO `city` VALUES ('31', '上海', '0', '31', null, null, null, null, '上海', '021', '121.473658', '31.230378', '9', '0');
INSERT INTO `city` VALUES ('32', '江苏省', '0', '32', null, null, null, null, '江苏省', null, '32.061707', '118.763232', '10', '1');
INSERT INTO `city` VALUES ('33', '浙江省', '0', '33', null, null, null, null, '浙江省', null, '30.267446', '120.152791', '11', '1');
INSERT INTO `city` VALUES ('34', '安徽省', '0', '34', null, null, null, null, '安徽省', null, '31.861184', '117.284922', '12', '1');
INSERT INTO `city` VALUES ('35', '福建省', '0', '35', null, null, null, null, '福建省', null, '26.100779', '119.295144', '13', '1');
INSERT INTO `city` VALUES ('36', '江西省', '0', '36', null, null, null, null, '江西省', null, '28.675696', '115.909228', '14', '1');
INSERT INTO `city` VALUES ('37', '山东省', '0', '37', null, null, null, null, '山东省', null, '36.668530', '117.020359', '15', '1');
INSERT INTO `city` VALUES ('41', '河南省', '0', '41', null, null, null, null, '河南省', null, '34.765515', '113.753602', '16', '1');
INSERT INTO `city` VALUES ('42', '湖北省', '0', '42', null, null, null, null, '湖北省', null, '30.546498', '114.341861', '17', '1');
INSERT INTO `city` VALUES ('43', '湖南省', '0', '43', null, null, null, null, '湖南省', null, '28.112444', '112.983810', '18', '1');
INSERT INTO `city` VALUES ('44', '广东省', '0', '44', null, null, null, null, '广东省', null, '23.132191', '113.266530', '19', '1');
INSERT INTO `city` VALUES ('45', '广西壮族自治区', '0', '45', null, null, null, null, '广西壮族自治区', null, '22.815478', '108.327546', '20', '1');
INSERT INTO `city` VALUES ('46', '海南省', '0', '46', null, null, null, null, '海南省', null, '20.017377', '110.349228', '21', '1');
INSERT INTO `city` VALUES ('50', '重庆市', '0', '50', null, null, null, null, '重庆市', null, '29.563009', '106.551556', '22', '1');
INSERT INTO `city` VALUES ('51', '四川省', '0', '51', null, null, null, null, '四川省', null, '30.651651', '104.075931', '23', '1');
INSERT INTO `city` VALUES ('52', '贵州省', '0', '52', null, null, null, null, '贵州省', null, '26.598194', '106.707410', '24', '1');
INSERT INTO `city` VALUES ('53', '云南省', '0', '53', null, null, null, null, '云南省', null, '25.045806', '102.710002', '25', '1');
INSERT INTO `city` VALUES ('54', '西藏自治区', '0', '54', null, null, null, null, '西藏自治区', null, '29.646922', '91.117212', '26', '1');
INSERT INTO `city` VALUES ('61', '陕西省', '0', '61', null, null, null, null, '陕西省', null, '34.265472', '108.954239', '27', '1');
INSERT INTO `city` VALUES ('62', '甘肃省', '0', '62', null, null, null, null, '甘肃省', null, '36.059421', '103.826308', '28', '1');
INSERT INTO `city` VALUES ('63', '青海省', '0', '63', null, null, null, null, '青海省', null, '36.620901', '101.780199', '29', '1');
INSERT INTO `city` VALUES ('64', '宁夏回族自治区', '0', '64', null, null, null, null, '宁夏回族自治区', null, '38.471317', '106.258754', '30', '1');
INSERT INTO `city` VALUES ('65', '新疆维吾尔自治区', '0', '65', null, null, null, null, '新疆维吾尔自治区', null, '43.793026', '87.627704', '31', '1');
INSERT INTO `city` VALUES ('110100000000', '市辖区', '11', '11', '110100000000', null, null, null, '市辖区', '010', '39.904987', '116.405281', '1', '2');
INSERT INTO `city` VALUES ('110101000000', '东城区', '110100000000', '11', '110100000000', '110101000000', null, null, '东城区', '010', '121.528438', '31.214148', '1', '3');
INSERT INTO `city` VALUES ('110101001000', '东华门街道', '110101000000', '11', '110100000000', '110101000000', '110101001000', null, '东华门街道', '010', '121.528438', '31.214148', '1', '4');
INSERT INTO `city` VALUES ('110101001001', '多福巷社区居委会', '110101001000', '11', '110100000000', '110101000000', '110101001000', '110101001001', '多福巷社区居委会', '010', '121.528438', '31.214148', '1', '5');
INSERT INTO `city` VALUES ('110101001002', '银闸社区居委会', '110101001000', '11', '110100000000', '110101000000', '110101001000', '110101001002', '银闸社区居委会', '010', '121.528438', '31.214148', '2', '5');
INSERT INTO `city` VALUES ('110101001005', '东厂社区居委会', '110101001000', '11', '110100000000', '110101000000', '110101001000', '110101001005', '东厂社区居委会', '010', '121.528438', '31.214148', '3', '5');
INSERT INTO `city` VALUES ('110101001006', '智德社区居委会', '110101001000', '11', '110100000000', '110101000000', '110101001000', '110101001006', '智德社区居委会', '010', '121.528438', '31.214148', '4', '5');
INSERT INTO `city` VALUES ('110101001007', '南池子社区居委会', '110101001000', '11', '110100000000', '110101000000', '110101001000', '110101001007', '南池子社区居委会', '010', '121.528438', '31.214148', '5', '5');
INSERT INTO `city` VALUES ('110101001008', '黄图岗社区居委会', '110101001000', '11', '110100000000', '110101000000', '110101001000', '110101001008', '黄图岗社区居委会', '010', '121.528438',
- 1
- 2
- 3
前往页