--
-- 表的结构 `tp6_system_city`
--
DROP TABLE IF EXISTS `tp6_system_city`;
CREATE TABLE IF NOT EXISTS `tp6_system_city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`city_id` int(11) NOT NULL DEFAULT '0' COMMENT '城市id',
`level` int(11) NOT NULL DEFAULT '0' COMMENT '省市级别',
`parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '父级id',
`area_code` varchar(30) NOT NULL DEFAULT '' COMMENT '区号',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
`merger_name` varchar(255) NOT NULL DEFAULT '' COMMENT '合并名称',
`lng` varchar(50) NOT NULL DEFAULT '' COMMENT '经度',
`lat` varchar(50) NOT NULL DEFAULT '' COMMENT '纬度',
`is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否展示',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3971 DEFAULT CHARSET=utf8mb4 COMMENT='城市表';
--
-- 转存表中的数据 `tp6_system_city`
--
INSERT INTO `tp6_system_city` (`id`, `city_id`, `level`, `parent_id`, `area_code`, `name`, `merger_name`, `lng`, `lat`, `is_show`) VALUES
(1, 1, 0, 0, '110000000000', '北京市', '北京', '116.407526', '39.904030', 1),
(2, 7362, 0, 0, '120000000000', '天津市', '天津', '117.200983', '39.084158', 1),
(3, 13267, 0, 0, '130000000000', '河北省', '河北', '114.468664', '38.037057', 1),
(4, 67747, 0, 0, '140000000000', '山西省', '山西', '112.562398', '37.873531', 1),
(5, 99537, 0, 0, '150000000000', '内蒙古自治区', '内蒙古', '111.765617', '40.817498', 1),
(6, 115224, 0, 0, '210000000000', '辽宁省', '辽宁', '123.429440', '41.835441', 1),
(7, 133208, 0, 0, '220000000000', '吉林省', '吉林', '125.325990', '43.896536', 1),
(8, 145665, 0, 0, '230000000000', '黑龙江省', '黑龙江', '126.661669', '45.742347', 1),
(9, 161792, 0, 0, '310000000000', '上海市', '上海', '121.473701', '31.230416', 1),
(10, 167904, 0, 0, '320000000000', '江苏省', '江苏', '118.763232', '32.061707', 1),
(11, 191019, 0, 0, '330000000000', '浙江省', '浙江', '120.152791', '30.267446', 1),
(12, 224649, 0, 0, '340000000000', '安徽省', '安徽', '117.284922', '31.861184', 1),
(13, 244377, 0, 0, '350000000000', '福建省', '福建', '119.295144', '26.100779', 1),
(14, 262698, 0, 0, '360000000000', '江西省', '江西', '115.909228', '28.675696', 1),
(15, 285860, 0, 0, '370000000000', '山东省', '山东', '117.020359', '36.668530', 1),
(16, 367395, 0, 0, '410000000000', '河南省', '河南', '113.753602', '34.765515', 1),
(17, 420824, 0, 0, '420000000000', '湖北省', '湖北', '114.341861', '30.546498', 1),
(18, 452123, 0, 0, '430000000000', '湖南省', '湖南', '112.983810', '28.112444', 1),
(19, 483250, 0, 0, '440000000000', '广东省', '广东', '113.266530', '23.132191', 1),
(20, 511462, 0, 0, '450000000000', '广西壮族自治区', '广西', '108.327546', '22.815478', 1),
(21, 529344, 0, 0, '460000000000', '海南省', '海南', '110.349228', '20.017377', 1),
(22, 533328, 0, 0, '500000000000', '重庆市', '重庆', '106.551556', '29.563009', 1),
(23, 545532, 0, 0, '510000000000', '四川省', '四川', '104.075931', '30.651651', 1),
(24, 604131, 0, 0, '520000000000', '贵州省', '贵州', '106.707410', '26.598194', 1),
(25, 624372, 0, 0, '530000000000', '云南省', '云南', '102.710002', '25.045806', 1),
(26, 640332, 0, 0, '540000000000', '西藏自治区', '西藏', '91.117212', '29.646922', 1),
(27, 646578, 0, 0, '610000000000', '陕西省', '陕西', '108.954239', '34.265472', 1),
(28, 671119, 0, 0, '620000000000', '甘肃省', '甘肃', '103.826308', '36.059421', 1),
(29, 690094, 0, 0, '630000000000', '青海省', '青海', '101.780199', '36.620901', 1),
(30, 695259, 0, 0, '640000000000', '宁夏回族自治区', '宁夏', '106.258754', '38.471317', 1),
(31, 698440, 0, 0, '650000000000', '新疆维吾尔自治区', '新疆', '87.627704', '43.793026', 1),
(32, 714368, 0, 0, '0', '香港特别行政区', '香港', '114.173355', '22.320048', 1),
(33, 714390, 0, 0, '0', '澳门特别行政区', '澳门', '113.549090', '22.198951', 1),
(34, 714401, 0, 0, '0', '台湾', '台湾', '121.509062', '25.044332', 1),
(35, 2, 1, 1, '110100000000', '北京市', '北京', '116.407526', '39.904030', 1),
(36, 7363, 1, 7362, '120100000000', '天津市', '天津', '117.200983', '39.084158', 1),
(37, 13268, 1, 13267, '130100000000', '石家庄市', '河北,石家庄', '114.514859', '38.042306', 1),
(38, 18128, 1, 13267, '130200000000', '唐山市', '河北,唐山', '118.180193', '39.630867', 1),
(39, 24371, 1, 13267, '130300000000', '秦皇岛市', '河北,秦皇岛', '119.600492', '39.935385', 1),
(40, 26779, 1, 13267, '130400000000', '邯郸市', '河北,邯郸', '114.538961', '36.625657', 1),
(41, 32688, 1, 13267, '130500000000', '邢台市', '河北,邢台', '114.504844', '37.070589', 1),
(42, 38160, 1, 13267, '130600000000', '保定市', '河北,保定', '115.464806', '38.873891', 1),
(43, 44570, 1, 13267, '130700000000', '张家口市', '河北,张家口', '114.887543', '40.824418', 1),
(44, 49190, 1, 13267, '130800000000', '承德市', '河北,承德', '117.962410', '40.954071', 1),
(45, 52018, 1, 13267, '130900000000', '沧州市', '河北,沧州', '116.838834', '38.304477', 1),
(46, 58247, 1, 13267, '131000000000', '廊坊市', '河北,廊坊', '116.683752', '39.538047', 1),
(47, 61804, 1, 13267, '131100000000', '衡水市', '河北,衡水', '115.670177', '37.738920', 1),
(48, 66813, 1, 13267, '139000000000', '直辖县', '河北', '114.468664', '38.037057', 1),
(49, 67748, 1, 67747, '140100000000', '太原市', '山西,太原', '112.548879', '37.870590', 1),
(50, 69390, 1, 67747, '140200000000', '大同市', '山西,大同', '113.612440', '40.040295', 1),
(51, 71850, 1, 67747, '140300000000', '阳泉市', '山西,阳泉', '113.580519', '37.856971', 1),
(52, 72975, 1, 67747, '140400000000', '长治市', '山西,长治', '113.116255', '36.195386', 1),
(53, 76726, 1, 67747, '140500000000', '晋城市', '山西,晋城', '112.851831', '35.490701', 1),
(54, 79163, 1, 67747, '140600000000', '朔州市', '山西,朔州', '112.432825', '39.331595', 1),
(55, 81000, 1, 67747, '140700000000', '晋中市', '山西,晋中', '112.752694', '37.687024', 1),
(56, 84092, 1, 67747, '140800000000', '运城市', '山西,运城', '111.007528', '35.026412', 1),
(57, 87613, 1, 67747, '140900000000', '忻州市', '山西,忻州', '112.734174', '38.416663', 1),
(58, 92738, 1, 67747, '141000000000', '临汾市', '山西,临汾', '111.518976', '36.088005', 1),
(59, 96064, 1, 67747, '141100000000', '吕梁市', '山西,吕梁', '111.144319', '37.518314', 1),
(60, 99538, 1, 99537, '150100000000', '呼和浩特市', '内蒙古,呼和浩特', '111.749180', '40.842585', 1),
(61, 100904, 1, 99537, '150200000000', '包头市', '内蒙古,包头', '109.840347', '40.657449', 1),
(62, 101772, 1, 99537, '150300000000', '乌海市', '内蒙古,乌海', '106.794249', '39.655388', 1),
(63, 101884, 1, 99537, '150400000000', '赤峰市', '内蒙古,赤峰', '118.886856', '42.257817', 1),
(64, 104457, 1, 99537, '150500000000', '通辽市', '内蒙古,通辽', '122.243444', '43.652890', 1),
(65, 107065, 1, 99537, '150600000000', '鄂尔多斯市', '内蒙古,鄂尔多斯', '109.781327', '39.608266', 1),
(66, 108166, 1, 99537, '150700000000', '呼伦贝尔市', '内蒙古,呼伦贝尔', '119.765744', '49.211574', 1),
(67, 109847, 1, 99537, '150800000000', '巴彦淖尔市', '内蒙古,巴彦淖尔', '107.387657', '40.743213', 1),
(68, 110889, 1, 99537, '150900000000', '乌兰察布市', '内蒙古,乌兰察布', '113.132585', '40.994785', 1),
(69, 112552, 1, 99537, '152200000000', '兴安盟', '内蒙古,兴安', '122.067042', '46.077561', 1),
(70, 113777, 1, 99537, '152500000000', '锡林郭勒盟', '内蒙古,锡林郭勒', '116.048222', '43.933454', 1),
(71, 114940, 1, 99537, '152900000000', '阿拉善盟', '内蒙古,阿拉善', '105.728969', '38.851892', 1),
(72, 115225, 1, 115224, '210100000000', '�
- 1
- 2
- 3
- 4
前往页