- -- 一、以前项目中须要全国的省市区数据,在网上找了不少,发现数据要么不全,要么就是过期了。
- -- 二、而后发现高德地图有这类的api能够无偿使用。
- -- 三、高德地图‘行政区域查询’API: http://lbs.amap.com/api/webservice/guide/api/district/
- -- --------------------------------------------------------
- -- 服务器版本: 5.7.9-log - MySQL Community Server (GPL)
- -- --------------------------------------------------------
- CREATE TABLE IF NOT EXISTS `T_Area` (
- `areaId` int(20) NOT NULL AUTO_INCREMENT COMMENT '地区Id',
- `areaCode` varchar(50) NOT NULL COMMENT '地区编码',
- `areaName` varchar(20) NOT NULL COMMENT '地区名',
- `level` tinyint(4) DEFAULT '-1' COMMENT '地区级别(1:省份province,2:市city,3:区县district,4:街道street)',
- `cityCode` varchar(50) DEFAULT NULL COMMENT '城市编码',
- `center` varchar(50) DEFAULT NULL COMMENT '城市中心点(即:经纬度坐标)',
- `parentId` int(20) DEFAULT '-1' COMMENT '地区父节点',
- PRIMARY KEY (`areaId`),
- KEY `areaCode` (`areaCode`),
- KEY `parentId` (`parentId`),
- KEY `level` (`level`),
- KEY `areaName` (`areaName`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3260 DEFAULT CHARSET=utf8 COMMENT='地区码表';
- -- 正在导出表数据:~3,256 rows (大约)
- INSERT INTO `T_Area` (`areaId`, `areaCode`, `areaName`, `level`, `cityCode`, `center`, `parentId`) VALUES
- (1, '110000', '北京市', 1, '010', '116.407394,39.904211', -1),
- (2, '110100', '北京城区', 2, '010', '116.407394,39.904211', 1),
- (3, '110101', '东城区', 3, '010', '116.41649,39.928341', 2),
- (4, '110102', '西城区', 3, '010', '116.365873,39.912235', 2),
- (5, '110105', '朝阳区', 3, '010', '116.443205,39.921506', 2),
- (6, '110106', '丰台区', 3, '010', '116.287039,39.858421', 2),
- (7, '110107', '石景山区', 3, '010', '116.222933,39.906611', 2),
- (8, '110108', '海淀区', 3, '010', '116.298262,39.95993', 2),
- (9, '110109', '门头沟区', 3, '010', '116.101719,39.940338', 2),
- (10, '110111', '房山区', 3, '010', '116.143486,39.748823', 2),
- (11, '110112', '通州区', 3, '010', '116.656434,39.909946', 2),
- (12, '110113', '顺义区', 3, '010', '116.654642,40.130211', 2),
- (13, '110114', '昌平区', 3, '010', '116.231254,40.220804', 2),
- (14, '110115', '大兴区', 3, '010', '116.341483,39.726917', 2),
- (15, '110116', '怀柔区', 3, '010', '116.631931,40.316053', 2),
- (16, '110117', '平谷区', 3, '010', '117.121351,40.140595', 2),
- (17, '110118', '密云区', 3, '010', '116.843047,40.376894', 2),
- (18, '110119', '延庆区', 3, '010', '115.974981,40.456591', 2),
- (19, '120000', '天津市', 1, '022', '117.200983,39.084158', -1),
- (20, '120100', '天津城区', 2, '022', '117.200983,39.084158', 19),
- (21, '120101', '和平区', 3, '022', '117.214699,39.117196', 20),
- (22, '120102', '河东区', 3, '022', '117.251584,39.128294', 20),
- (23, '120103', '河西区', 3, '022', '117.223371,39.109563', 20),
- (24, '120104', '南开区', 3, '022', '117.150738,39.138205', 20),
- (25, '120105', '河北区', 3, '022', '117.196648,39.147869', 20),
- (26, '120106', '红桥区', 3, '022', '117.151533,39.167345', 20),
- (27, '120110', '东丽区', 3, '022', '117.31362,39.086802', 20),
- (28, '120111', '西青区', 3, '022', '117.008826,39.141152', 20),
- (29, '120112', '津南区', 3, '022', '117.35726,38.937928', 20),
- (30, '120113', '北辰区', 3, '022', '117.135488,39.224791', 20),
- (31, '120114', '武清区', 3, '022', '117.044387,39.384119', 20),
- (32, '120115', '宝坻区', 3, '022', '117.309874,39.717564', 20),
- (33, '120116', '滨海新区', 3, '022', '117.698407,39.01727', 20),
- (34, '120117', '宁河区', 3, '022', '117.826724,39.330087', 20),
- (35, '120118', '静海区', 3, '022', '116.974232,38.94745', 20),
- (36, '120119', '蓟州区', 3, '022', '117.408296,40.045851', 20),
- (37, '130000', '河北省', 1, '[]', '114.530235,38.037433', -1),
- (38, '130100', '石家庄市', 2, '0311', '114.514793,38.042228', 37),
- (39, '130102', '长安区', 3, '0311', '114.539395,38.036347', 38),
- (40, '130104', '桥西区', 3, '0311', '114.461088,38.004193', 38),
- (41, '130105', '新华区', 3, '0311', '114.463377,38.05095', 38),
- (42, '130107', '井陉矿区', 3, '0311', '114.062062,38.065151', 38),
- (43, '130108', '裕华区', 3, '0311', '114.531202,38.00643', 38),
- (44, '130109', '藁城区', 3, '0311', '114.847023,38.021453', 38),
- (45, '130110', '鹿泉区', 3, '0311', '114.313654,38.085953', 38),
- (46, '130111', '栾城区', 3, '0311', '114.648318,37.900199', 38),
- (47, '130121', '井陉县', 3, '0311', '114.145242,38.032118', 38),
- (48, '130123', '正定县', 3, '0311', '114.570941,38.146444', 38),
- (49, '130125', '行唐县', 3, '0311', '114.552714,38.438377', 38),
- (50, '130126', '灵寿县', 3, '0311', '114.382614,38.308665', 38),
- (51, '130127', '高邑县', 3, '0311', '114.611121,37.615534', 38),
- (52, '130128', '深泽县', 3, '0311', '115.20092,38.184033', 38),
- (53, '130129', '赞皇县', 3, '0311', '114.386111,37.665663', 38),
- (54, '130130', '无极县', 3, '0311', '114.97634,38.179192', 38),
- (55, '130131', '平山县', 3, '0311', '114.195918,38.247888', 38),
- (56, '130132', '元氏县', 3, '0311', '114.525409,37.766513', 38),
- (57, '130133', '赵县', 3, '0311', '114.776297,37.756578', 38),
- (58, '130181', '辛集市', 3, '0311', '115.217658,37.943121', 38),
- (59, '130183', '晋州市', 3, '0311', '115.044213,38.033671', 38),
- (60, '130184', '新乐市', 3, '0311', '114.683776,38.343319', 38),
- (61, '130200', '唐山市', 2, '0315', '118.180193,39.630867', 37),
- (62, '130202', '路南区', 3, '0315', '118.154354,39.625058', 61),
- (63, '130203', '路北区', 3, '0315', '118.200692,39.624437', 61),
- (64, '130204', '古冶区', 3, '0315', '118.447635,39.733578', 61),
- (65, '130205', '开平区', 3, '0315', '118.261841,39.671001', 61),
- (66, '130207', '丰南区', 3, '0315', '118.085169,39.576031', 61),
- (67, '130208', '丰润区', 3, '0315', '118.162215,39.832582', 61),
- (68, '130209', '曹妃甸区', 3, '0315', '118.460379,39.27307', 61),
- (69, '130223', '滦县', 3, '0315', '118.703598,39.740593', 61),
- (70, '130224', '滦南县', 3, '0315', '118.682379,39.518996', 61),
- (71, '130225', '乐亭县', 3, '0315', '118.912571,39.425608', 61),
- (72, '130227', '迁西县', 3, '0315', '118.314715,40.1415', 61),
- (73, '130229', '玉田县', 3, '0315', '117.738658,39.900401', 61),
- (74, '130281', '遵化市', 3, '0315', '117.965892,40.189201', 61),
- (75, '130283', '迁安市', 3, '0315', '118.701144,39.999174', 61),
- (76, '130300', '秦皇岛市', 2, '0335', '119.518197,39.888701', 37),
- (77, '130302', '海港区', 3, '0335', '119.564962,39.94756', 76),
- (78, '130303', '山海关区', 3, '0335', '119.775799,39.978848', 76),
- (79, '130304', '北戴河区', 3, '0335', '119.484522,39.834596', 76),
- (80, '130306', '抚宁区', 3, '0335', '119.244847,39.876253', 76),
- (81, '130321', '青龙满族自治县', 3, '0335', '118.949684,40.407578', 76),
- (82, '130322', '昌黎县', 3, '0335', '119.199551,39.700911', 76),
- (83, '130324', '卢龙县', 3, '0335', '118.892986,39.891946', 76),
- (84, '130400', '邯郸市', 2, '0310', '114.538959,36.625594', 37),
- (85, '130402', '邯山区', 3, '0310', '114.531002,36.594313', 84),
- (86, '130403', '丛台区', 3, '0310', '114.492896,36.636409', 84),
- (87, '130404', '复兴区', 3, '0310', '114.462061,36.639033', 84),
- (88, '130406', '峰峰矿区', 3, '0310', '114.212802,36.419739', 84),
- (89, '130423', '临漳县', 3, '0310', '114.619536,36.335025', 84),
- (90, '130424', '成安县', 3, '0310', '114.670032,36.444317', 84),
- (91, '130425', '大名县', 3, '0310', '115.147814,36.285616', 84),
- (92, '130426', '涉县', 3, '0310', '113.6914,36.584994', 84),
- (93, '130427', '磁县', 3, '0310', '114.373946,36.374011', 84),
- (94, '130407', '肥乡区', 3, '0310', '114.800166,36.548131', 84),
- (95, '130408', '永年区', 3, '0310', '114.543832,36.743966', 84),
- (96, '130430', '邱县', 3, '0310', '115.200589,36.811148', 84),
- (97, '130431', '鸡泽县', 3, '0310', '114.889376,36.91034', 84),
- (98, '130432', '广平县', 3, '0310', '114.948606,36.483484', 84),
- (99, '130433', '馆陶县', 3, '0310', '115.282467,36.547556', 84),
- (100, '130434', '魏县', 3, '0310', '114.93892,36.359868', 84),
- (101, '130435', '曲周县', 3, '0310', '114.957504,36.76607', 84),
- (102, '130481', '武安市', 3, '0310', '114.203697,36.696506', 84),
- (103, '130500', '邢台市', 2, '0319', '114.504677,37.070834', 37),
- (104, '130502', '桥东区', 3, '0319', '114.507058,37.071287', 103),
- (105, '130503', '桥西区', 3, '0319', '114.468601,37.059827', 103),
- (106, '130521', '邢台县', 3, '0319', '114.561132,37.05073', 103),
- (107, '130522', '临城县', 3, '0319', '114.498761,37.444498', 103),
- (108, '130523', '内丘县', 3, '0319', '114.512128,37.286669', 103),
- (109, '130524', '柏乡县', 3, '0319', '114.693425,37.482422', 103),
- (110, '130525', '隆尧县', 3, '0319', '114.770419,37.350172', 103),
- (111, '130526', '任县', 3, '0319', '114.671936,37.120982', 103),
- (112, '130527', '南和县', 3, '0319', '114.683863,37.005017', 103),
- (113, '130528', '宁晋县', 3, '0319', '114.93992,37.624564', 103),
- (114, '130529', '巨鹿县', 3, '0319', '115.037477,37.221112', 103),
- (115, '130530', '新河县', 3, '0319', '115.250907,37.520862', 103),
- (116, '130531', '广宗县', 3, '0319', '115.142626,37.074661', 103),
- (117, '130532', '平乡县', 3, '0319', '115.030075,37.063148', 103),
- (118, '130533', '威县', 3, '0319', '115.266703,36.975478', 103),
- (119, '130534', '清河县', 3, '0319', '115.667208,37.039991', 103),
- (120, '130535', '临西县', 3, '0319', '115.501048,36.870811', 103),
- (121, '130581', '南宫市', 3, '0319', '115.408747,37.359264', 103),
- (122, '130582', '沙河市', 3, '0319', '114.503339,36.854929', 103),
- (123, '130600', '保定市', 2, '0312', '115.464589,38.874434', 37),
- (124, '130602', '竞秀区', 3, '0312', '115.45877,38.877449', 123),
- (125, '130606', '莲池区', 3, '0312', '115.497097,38.883582', 123),
- (126, '130607', '满城区', 3, '0312', '115.322334,38.949119', 123),
- (127, '130608', '清苑区', 3, '0312', '115.489959,38.765148', 123),
- (128, '130609', '徐水区', 3, '0312', '115.655774,39.018736', 123),
- (129, '130623', '涞水县', 3, '0312', '115.713904,39.394316', 123),
- (130, '130624', '阜平县', 3, '0312', '114.195104,38.849152', 123),
- (131, '130626', '定兴县', 3, '0312', '115.808296,39.263145', 123),
- (132, '130627', '唐县', 3, '0312', '114.982972,38.748203', 123),
- (133, '130628', '高阳县', 3, '0312', '115.778965,38.700088', 123),
- (134, '130629', '容城县', 3, '0312', '115.861657,39.042784', 123),
- (135, '130630', '涞源县', 3, '0312', '114.694283,39.360247', 123),
- (136, '130631', '望都县', 3, '0312', '115.155128,38.695842', 123),
- (137, '130632', '安新县', 3, '0312', '115.935603,38.935369', 123),
- (138, '130633', '易县', 3, '0312', '115.497457,39.349393', 123),
- (139, '130634', '曲阳县', 3, '0312', '114.745008,38.622248', 123),
- (140, '130635', '蠡县', 3, '0312', '115.583854,38.488055', 123),
- (141, '130636', '顺平县', 3, '0312', '115.13547,38.837487', 123),
- (142, '130637', '博野县', 3, '0312', '115.46438,38.457364', 123),
- (143, '130638', '雄县', 3, '0312', '116.10865,38.99455', 123),
- (144, '130681', '涿州市', 3, '0312', '115.974422,39.485282', 123),
- (145, '130682', '定州市', 3, '0312', '114.990392,38.516461', 123),
- (146, '130683', '安国市', 3, '0312', '115.326646,38.418439', 123),
- (147, '130684', '高碑店市', 3, '0312', '115.873886,39.326839', 123),
- (148, '130700', '张家口市', 2, '0313', '114.886252,40.768493', 37),
- (149, '130702', '桥东区', 3, '0313', '114.894189,40.788434', 148),
- (150, '130703', '桥西区', 3, '0313', '114.869657,40.819581', 148),
- (151, '130705', '宣化区', 3, '0313', '115.099494,40.608793', 148),
- (152, '130706', '下花园区', 3, '0313', '115.287352,40.502652', 148),
- (153, '130708', '万全区', 3, '0313', '114.740557,40.766965', 148),
- (154, '130709', '崇礼区', 3, '0313', '115.282668,40.974675', 148),
- (155, '130722', '张北县', 3, '0313', '114.720077,41.158596', 148),
- (156, '130723', '康保县', 3, '0313', '114.600404,41.852368', 148),
- (157, '130724', '沽源县', 3, '0313', '115.688692,41.669668', 148),
- (158, '130725', '尚义县', 3, '0313', '113.969618,41.076226', 148),
- (159, '130726', '蔚县', 3, '0313', '114.588903,39.840842', 148),
- (160, '130727', '阳原县', 3, '0313', '114.150348,40.104663', 148),
- (161, '130728', '怀安县', 3, '0313', '114.385791,40.674193', 148),
- (162, '130730', '怀来县', 3, '0313', '115.517861,40.415343', 148),
- (163, '130731', '涿鹿县', 3, '0313', '115.205345,40.379562', 148),
- (164, '130732', '赤城县', 3, '0313', '115.831498,40.912921', 148),
- (165, '130800', '承德市', 2, '0314', '117.962749,40.952942', 37),
- (166, '130802', '双桥区', 3, '0314', '117.943466,40.974643', 165),
- (167, '130803', '双滦区', 3, '0314', '117.799888,40.959236', 165),
- (168, '130804', '鹰手营子矿区', 3, '0314', '117.659499,40.546361', 165),
- (169, '130821', '承德县', 3, '0314', '118.173824,40.768238', 165),
- (170, '130822', '兴隆县', 3, '0314', '117.500558,40.417358', 165),
- (171, '130881', '平泉市', 3, '0314', '118.701951,41.018405', 165),
- (172, '130824', '滦平县', 3, '0314', '117.332801,40.941482', 165),
- (173, '130825', '隆化县', 3, '0314', '117.738937,41.313791', 165),
- (174, '130826', '丰宁满族自治县', 3, '0314', '116.646051,41.209069', 165),
- (175, '130827', '宽城满族自治县', 3, '0314', '118.485313,40.611391', 165),
- (176, '130828', '围场满族蒙古族自治县', 3, '0314', '117.760159,41.938529', 165),
- (177, '130900', '沧州市', 2, '0317', '116.838834,38.304477', 37),
- (178, '130902', '新华区', 3, '0317', '116.866284,38.314416', 177),
- (179, '130903', '运河区', 3, '0317', '116.843673,38.283749', 177),
- (180, '130921', '沧县', 3, '0317', '117.007478,38.219856', 177),
- (181, '130922', '青县', 3, '0317', '116.804305,38.583021', 177),
- (182, '130923', '东光县', 3, '0317', '116.537067,37.888248', 177),
- (183, '130924', '海兴县', 3, '0317', '117.497651,38.143169', 177),
- (184, '130925', '盐山县', 3, '0317', '117.230602,38.058087', 177),
- (185, '130926', '肃宁县', 3, '0317', '115.829758,38.422801', 177),
- (186, '130927', '南皮县', 3, '0317', '116.708347,38.038421', 177),
- (187, '130928', '吴桥县', 3, '0317', '116.391508,37.627661', 177),
- (188, '130929', '献县', 3, '0317', '116.122725,38.190185', 177),
- (189, '130930', '孟村回族自治县', 3, '0317', '117.104298,38.053409', 177),
- (190, '130981', '泊头市', 3, '0317', '116.578367,38.083437', 177),
- (191, '130982', '任丘市', 3, '0317', '116.082917,38.683591', 177),
- (192, '130983', '黄骅市', 3, '0317', '117.329949,38.371402', 177),
- (193, '130984', '河间市', 3, '0317', '116.099517,38.446624', 177),
- (194, '131000', '廊坊市', 2, '0316', '116.683752,39.538047', 37),
- (195, '131002', '安次区', 3, '0316', '116.694544,39.502569', 194),
- (196, '131003', '广阳区', 3, '0316', '116.71069,39.522786', 194),
- (197, '131022', '固安县', 3, '0316', '116.298657,39.438214', 194),
- (198, '131023', '永清县', 3, '0316', '116.50568,39.330689', 194),
- (199, '131024', '香河县', 3, '0316', '117.006093,39.761424', 194),
- (200, '131025', '大城县', 3, '0316', '116.653793,38.705449', 194),
- (201, '131026', '文安县', 3, '0316', '116.457898,38.87292', 194),
- (202, '131028', '大厂回族自治县', 3, '0316', '116.989574,39.886547', 194),
- (203, '131081', '霸州市', 3, '0316', '116.391484,39.125744', 194),
- (204, '131082', '三河市', 3, '0316', '117.078294,39.982718', 194),
- (205, '131100', '衡水市', 2, '0318', '115.670177,37.73892', 37),
- (206, '131102', '桃城区', 3, '0318', '115.67545,37.735465', 205),
- (207, '131103', '冀州区', 3, '0318', '115.579308,37.550856', 205),
- (208, '131121', '枣强县', 3, '0318', '115.724259,37.513417', 205),
- (209, '131122', '武邑县', 3, '0318', '115.887531,37.801665', 205),
- (210, '131123', '武强县', 3, '0318', '115.982461,38.041368', 205),
- (211, '131124', '饶阳县', 3, '0318', '115.725833,38.235892', 205),
- (212, '131125', '安平县', 3, '0318', '115.519278,38.234501', 205),
- (213, '131126', '故城县', 3, '0318', '115.965874,37.347409', 205),
- (214, '131127', '景县', 3, '0318', '116.270648,37.69229', 205),
- (215, '131128', '阜城县', 3, '0318', '116.175262,37.862505', 205),
- (216, '131182', '深州市', 3, '0318', '115.559574,38.001535', 205),
- (217, '140000', '山西省', 1, '[]', '112.562678,37.873499', -1),
- (218, '140100', '太原市', 2, '0351', '112.548879,37.87059', 217),
- (219, '140105', '小店区', 3, '0351', '112.565659,37.736525', 218),
- (220, '140106', '迎泽区', 3, '0351', '112.5634,37.863451', 218),
- (221, '140107', '杏花岭区', 3, '0351', '112.570604,37.893955', 218),
- (222, '140108', '尖草坪区', 3, '0351', '112.486691,37.940387', 218),
- (223, '140109', '万柏林区', 3, '0351', '112.515937,37.85958', 218),
- (224, '140110', '晋源区', 3, '0351', '112.47794,37.715193', 218),
- (225, '140121', '清徐县', 3, '0351', '112.358667,37.607443', 218),
- (226, '140122', '阳曲县', 3, '0351', '112.672952,38.058488', 218),
- (227, '140123', '娄烦县', 3, '0351', '111.797083,38.067932', 218),
- (228, '140181', '古交市', 3, '0351', '112.175853,37.907129', 218),
- (229, '140200', '大同市', 2, '0352', '113.300129,40.076763', 217),
- (230, '140202', '城区', 3, '0352', '113.298026,40.075666', 229),
- (231, '140203', '矿区', 3, '0352', '113.177206,40.036858', 229),
- (232, '140211', '南郊区', 3, '0352', '113.149693,40.005404', 229),
- (233, '140212', '新荣区', 3, '0352', '113.140004,40.255866', 229),
- (234, '140221', '阳高县', 3, '0352', '113.748944,40.361059', 229),
- (235, '140222', '天镇县', 3, '0352', '114.090867,40.420237', 229),
- (236, '140223', '广灵县', 3, '0352', '114.282758,39.760281', 229),
- (237, '140224', '灵丘县', 3, '0352', '114.23435,39.442406', 229),
- (238, '140225', '浑源县', 3, '0352', '113.699475,39.693406', 229),
- (239, '140226', '左云县', 3, '0352', '112.703008,40.013442', 229),
- (240, '140227', '大同县', 3, '0352', '113.61244,40.040294', 229),
- (241, '140300', '阳泉市', 2, '0353', '113.580519,37.856971', 217),
- (242, '140302', '城区', 3, '0353', '113.600669,37.847436', 241),
- (243, '140303', '矿区', 3, '0353', '113.555279,37.868494', 241),
- (244, '140311', '郊区', 3, '0353', '113.594163,37.944679', 241),
- (245, '140321', '平定县', 3, '0353', '113.630107,37.804988', 241),
- (246, '140322', '盂县', 3, '0353', '113.41233,38.085619', 241),
- (247, '140400', '长治市', 2, '0355', '113.116404,36.195409', 217),
- (248, '140402', '城区', 3, '0355', '113.123088,36.20353', 247),
- (249, '140411', '郊区', 3, '0355', '113.101211,36.218388', 247),
- (250, '140421', '长治县', 3, '0355', '113.051407,36.052858', 247),
- (251, '140423', '襄垣县', 3, '0355', '113.051491,36.535817', 247),
- (252, '140424', '屯留县', 3, '0355', '112.891998,36.315663', 247),
- (253, '140425', '平顺县', 3, '0355', '113.435961,36.200179', 247),
- (254, '140426', '黎城县', 3, '0355', '113.387155,36.502328', 247),
- (255, '140427', '壶关县', 3, '0355', '113.207049,36.115448', 247),
- (256, '140428', '长子县', 3, '0355', '112.8779,36.122334', 247),
- (257, '140429', '武乡县', 3, '0355', '112.864561,36.837625', 247),
- (258, '140430', '沁县', 3, '0355', '112.699226,36.756063', 247),
- (259, '140431', '沁源县', 3, '0355', '112.337446,36.5002', 247),
- (260, '140481', '潞城市', 3, '0355', '113.228852,36.334104', 247),
- (261, '140500', '晋城市', 2, '0356', '112.851486,35.490684', 217),
- (262, '140502', '城区', 3, '0356', '112.853555,35.501571', 261),
- (263, '140521', '沁水县', 3, '0356', '112.186738,35.690141', 261),
- (264, '140522', '阳城县', 3, '0356', '112.414738,35.486029', 261),
- (265, '140524', '陵川县', 3, '0356', '113.280688,35.775685', 261),
- (266, '140525', '泽州县', 3, '0356', '112.899137,35.617221', 261),
- (267, '140581', '高平市', 3, '0356', '112.92392,35.797997', 261),
- (268, '140600', '朔州市', 2, '0349', '112.432991,39.331855', 217),
- (269, '140602', '朔城区', 3, '0349', '112.432312,39.319519', 268),
- (270, '140603', '平鲁区', 3, '0349', '112.28833,39.512155', 268),
- (271, '140621', '山阴县', 3, '0349', '112.816413,39.527893', 268),
- (272, '140622', '应县', 3, '0349', '113.191098,39.554247', 268),
- (273, '140623', '右玉县', 3, '0349', '112.466989,39.989063', 268),
- (274, '140624', '怀仁县', 3, '0349', '113.131717,39.821627', 268),
- (275, '140700', '晋中市', 2, '0354', '112.752652,37.687357', 217),
- (276, '140702', '榆次区', 3, '0354', '112.708224,37.697794', 275),
- (277, '140721', '榆社县', 3, '0354', '112.975209,37.070916', 275),
- (278, '140722', '左权县', 3, '0354', '113.379403,37.082943', 275),
- (279, '140723', '和顺县', 3, '0354', '113.570415,37.32957', 275),
- (280, '140724', '昔阳县', 3, '0354', '113.706977,37.61253', 275),
- (281, '140725', '寿阳县', 3, '0354', '113.176373,37.895191', 275),
- (282, '140726', '太谷县', 3, '0354', '112.551305,37.421307', 275),
- (283, '140727', '祁县', 3, '0354', '112.335542,37.357869', 275),
- (284, '140728', '平遥县', 3, '0354', '112.176136,37.189421', 275),
- (285, '140729', '灵石县', 3, '0354', '111.77864,36.847927', 275),
- (286, '140781', '介休市', 3, '0354', '111.916711,37.026944', 275),
- (287, '140800', '运城市', 2, '0359', '111.00746,35.026516', 217),
- (288, '140802', '盐湖区', 3, '0359', '110.998272,35.015101', 287),
- (289, '140821', '临猗县', 3, '0359', '110.774547,35.144277', 287),
- (290, '140822', '万荣县', 3, '0359', '110.838024,35.415253', 287),
- (291, '140823', '闻喜县', 3, '0359', '111.22472,35.356644', 287),
- (292, '140824', '稷山县', 3, '0359', '110.983333,35.604025', 287),
- (293, '140825', '新绛县', 3, '0359', '111.224734,35.616251', 287),
- (294, '140826', '绛县', 3, '0359', '111.568236,35.49119', 287),
- (295, '140827', '垣曲县', 3, '0359', '111.670108,35.297369', 287),
- (296, '140828', '夏县', 3, '0359', '111.220456,35.141363', 287),
- (297, '140829', '平陆县', 3, '0359', '111.194133,34.82926', 287),
- (298, '140830', '芮城县', 3, '0359', '110.694369,34.693579', 287),
- (299, '140881', '永济市', 3, '0359', '110.447543,34.8671', 287),
- (300, '140882', '河津市', 3, '0359', '110.712063,35.596383', 287),
- (301, '140900', '忻州市', 2, '0350', '112.734174,38.416663', 217),
- (302, '140902', '忻府区', 3, '0350', '112.746046,38.404242', 301),
- (303, '140921', '定襄县', 3, '0350', '112.957237,38.473506', 301),
- (304, '140922', '五台县', 3, '0350', '113.255309,38.728315', 301),
- (305, '140923', '代县', 3, '0350', '112.960282,39.066917', 301),
- (306, '140924', '繁峙县', 3, '0350', '113.265563,39.188811', 301),
- (307, '140925', '宁武县', 3, '0350', '112.304722,39.001524', 301),
- (308, '140926', '静乐县', 3, '0350', '111.939498,38.359306', 301),
- (309, '140927', '神池县', 3, '0350', '112.211296,39.090552', 301),
- (310, '140928', '五寨县', 3, '0350', '111.846904,38.910726', 301),
- (311, '140929', '岢岚县', 3, '0350', '111.57285,38.70418', 301),
- (312, '140930', '河曲县', 3, '0350', '111.138472,39.384482', 301),
- (313, '140931', '保德县', 3, '0350', '111.086564,39.022487', 301),
- (314, '140932', '偏关县', 3, '0350', '111.508831,39.436306', 301),
- (315, '140981', '原平市', 3, '0350', '112.711058,38.731402', 301),
- (316, '141000', '临汾市', 2, '0357', '111.518975,36.088005', 217),
- (317, '141002', '尧都区', 3, '0357', '111.579554,36.07884', 316),
- (318, '141021', '曲沃县', 3, '0357', '111.47586,35.641086', 316),
- (319, '141022', '翼城县', 3, '0357', '111.718951,35.738576', 316),
- (320, '141023', '襄汾县', 3, '0357', '111.441725,35.876293', 316),
- (321, '141024', '洪洞县', 3, '0357', '111.674965,36.253747', 316),
- (322, '141025', '古县', 3, '0357', '111.920465,36.266914', 316),
- (323, '141026', '安泽县', 3, '0357', '112.250144,36.147787', 316),
- (324, '141027', '浮山县', 3, '0357', '111.848883,35.968124', 316),
- (325, '141028', '吉县', 3, '0357', '110.681763,36.098188', 316),
- (326, '141029', '乡宁县', 3, '0357', '110.847021,35.970389', 316),
- (327, '141030', '大宁县', 3, '0357', '110.75291,36.465102', 316),
- (328, '141031', '隰县', 3, '0357', '110.940637,36.69333', 316),
- (329, '141032', '永和县', 3, '0357', '110.632006,36.759507', 316),
- (330, '141033', '蒲县', 3, '0357', '111.096439,36.411826', 316),
- (331, '141034', '汾西县', 3, '0357', '111.56395,36.652854', 316),
- (332, '141081', '侯马市', 3, '0357', '111.372002,35.619105', 316),
- (333, '141082', '霍州市', 3, '0357', '111.755398,36.56893', 316),
- (334, '141100', '吕梁市', 2, '0358', '111.144699,37.519126', 217),
- (335, '141102', '离石区', 3, '0358', '111.150695,37.51786', 334),
- (336, '141121', '文水县', 3, '0358', '112.028866,37.438101', 334),
- (337, '141122', '交城县', 3, '0358', '112.156064,37.551963', 334),
- (338, '141123', '兴县', 3, '0358', '111.127667,38.462389', 334),
- (339, '141124', '临县', 3, '0358', '110.992093,37.950758', 334),
- (340, '141125', '柳林县', 3, '0358', '110.889007,37.429772', 334),
- (341, '141126', '石楼县', 3, '0358', '110.834634,36.99857', 334),
- (342, '141127', '岚县', 3, '0358', '111.671917,38.279299', 334),
- (343, '141128', '方山县', 3, '0358', '111.244098,37.894631', 334),
- (344, '141129', '中阳县', 3, '0358', '111.179657,37.357058', 334),
- (345, '141130', '交口县', 3, '0358', '111.181151,36.982186', 334),
- (346, '141181', '孝义市', 3, '0358', '111.778818,37.146294', 334),
- (347, '141182', '汾阳市', 3, '0358', '111.770477,37.261756', 334),
- (348, '150000', '内蒙古自治区', 1, '[]', '111.76629,40.81739', -1),
- (349, '150100', '呼和浩特市', 2, '0471', '111.749995,40.842356', 348),
- (350, '150102', '新城区', 3, '0471', '111.665544,40.858289', 349),
- (351, '150103', '回民区', 3, '0471', '111.623692,40.808608', 349),
- (352, '150104', '玉泉区', 3, '0471', '111.673881,40.753655', 349),
- (353, '150105', '赛罕区', 3, '0471', '111.701355,40.792667', 349),
- (354, '150121', '土默特左旗', 3, '0471', '111.163902,40.729572', 349),
- (355, '150122', '托克托县', 3, '0471', '111.194312,40.277431', 349),
- (356, '150123', '和林格尔县', 3, '0471', '111.821843,40.378787', 349),
- (357, '150124', '清水河县', 3, '0471', '111.647609,39.921095', 349),
- (358, '150125', '武川县', 3, '0471', '111.451303,41.096471', 349),
- (359, '150200', '包头市', 2, '0472', '109.953504,40.621157', 348),
- (360, '150202', '东河区', 3, '0472', '110.044106,40.576319', 359),
- (361, '150203', '昆都仑区', 3, '0472', '109.837707,40.642578', 359),
- (362, '150204', '青山区', 3, '0472', '109.901572,40.643246', 359),
- (363, '150205', '石拐区', 3, '0472', '110.060254,40.681748', 359),
- (364, '150206', '白云鄂博矿区', 3, '0472', '109.973803,41.769511', 359),
- (365, '150207', '九原区', 3, '0472', '109.967449,40.610561', 359),
- (366, '150221', '土默特右旗', 3, '0472', '110.524262,40.569426', 359),
- (367, '150222', '固阳县', 3, '0472', '110.060514,41.034105', 359),
- (368, '150223', '达尔罕茂明安联合旗', 3, '0472', '110.432626,41.698992', 359),
- (369, '150300', '乌海市', 2, '0473', '106.794216,39.655248', 348),
- (370, '150302', '海勃湾区', 3, '0473', '106.822778,39.691156', 369),
- (371, '150303', '海南区', 3, '0473', '106.891424,39.441364', 369),
- (372, '150304', '乌达区', 3, '0473', '106.726099,39.505925', 369),
- (373, '150400', '赤峰市', 2, '0476', '118.88694,42.257843', 348),
- (374, '150402', '红山区', 3, '0476', '118.953854,42.296588', 373),
- (375, '150403', '元宝山区', 3, '0476', '119.288611,42.038902', 373),
- (376, '150404', '松山区', 3, '0476', '118.916208,42.299798', 373),
- (377, '150421', '阿鲁科尔沁旗', 3, '0476', '120.0657,43.872298', 373),
- (378, '150422', '巴林左旗', 3, '0476', '119.362931,43.960889', 373),
- (379, '150423', '巴林右旗', 3, '0476', '118.66518,43.534414', 373),
- (380, '150424', '林西县', 3, '0476', '118.05545,43.61812', 373),
- (381, '150425', '克什克腾旗', 3, '0476', '117.545797,43.264988', 373),
- (382, '150426', '翁牛特旗', 3, '0476', '119.00658,42.936188', 373),
- (383, '150428', '喀喇沁旗', 3, '0476', '118.701937,41.927363', 373),
- (384, '150429', '宁城县', 3, '0476', '119.318876,41.601375', 373),
- (385, '150430', '敖汉旗', 3, '0476', '119.921603,42.290781', 373),
- (386, '150500', '通辽市', 2, '0475', '122.243444,43.652889', 348),
- (387, '150502', '科尔沁区', 3, '0475', '122.255671,43.623078', 386),
- (388, '150521', '科尔沁左翼中旗', 3, '0475', '123.312264,44.126625', 386),
- (389, '150522', '科尔沁左翼后旗', 3, '0475', '122.35677,42.935105', 386),
- (390, '150523', '开鲁县', 3, '0475', '121.319308,43.601244', 386),
- (391, '150524', '库伦旗', 3, '0475', '121.8107,42.735656', 386),
- (392, '150525', '奈曼旗', 3, '0475', '120.658282,42.867226', 386),
- (393, '150526', '扎鲁特旗', 3, '0475', '120.911676,44.556389', 386),
- (394, '150581', '霍林郭勒市', 3, '0475', '119.68187,45.533962', 386),
- (395, '150600', '鄂尔多斯市', 2, '0477', '109.781327,39.608266', 348),
- (396, '150602', '东胜区', 3, '0477', '109.963333,39.822593', 395),
- (397, '150603', '康巴什区', 3, '0477', '109.790076,39.607472', 395),
- (398, '150621', '达拉特旗', 3, '0477', '110.033833,40.412438', 395),
- (399, '150622', '准格尔旗', 3, '0477', '111.240171,39.864361', 395),
- (400, '150623', '鄂托克前旗', 3, '0477', '107.477514,38.182362', 395),
- (401, '150624', '鄂托克旗', 3, '0477', '107.97616,39.08965', 395),
- (402, '150625', '杭锦旗', 3, '0477', '108.736208,39.833309', 395),
- (403, '150626', '乌审旗', 3, '0477', '108.817607,38.604136', 395),
- (404, '150627', '伊金霍洛旗', 3, '0477', '109.74774,39.564659', 395),
- (405, '150700', '呼伦贝尔市', 2, '0470', '119.765558,49.211576', 348),
- (406, '150702', '海拉尔区', 3, '0470', '119.736176,49.212188', 405),
- (407, '150703', '扎赉诺尔区', 3, '0470', '117.670248,49.510375', 405),
- (408, '150721', '阿荣旗', 3, '0470', '123.459049,48.126584', 405),
- (409, '150722', '莫力达瓦达斡尔族自治旗', 3, '0470', '124.519023,48.477728', 405),
- (410, '150723', '鄂伦春自治旗', 3, '0470', '123.726201,50.591842', 405),
- (411, '150724', '鄂温克族自治旗', 3, '0470', '119.755239,49.146592', 405),
- (412, '150725', '陈巴尔虎旗', 3, '0470', '119.424026,49.328916', 405),
- (413, '150726', '新巴尔虎左旗', 3, '0470', '118.269819,48.218241', 405),
- (414, '150727', '新巴尔虎右旗', 3, '0470', '116.82369,48.672101', 405),
- (415, '150781', '满洲里市', 3, '0470', '117.378529,49.597841', 405),
- (416, '150782', '牙克石市', 3, '0470', '120.711775,49.285629', 405),
- (417, '150783', '扎兰屯市', 3, '0470', '122.737467,48.013733', 405),
- (418, '150784', '额尔古纳市', 3, '0470', '120.180506,50.243102', 405),
- (419, '150785', '根河市', 3, '0470', '121.520388,50.780344', 405),
- (420, '150800', '巴彦淖尔市', 2, '0478', '107.387657,40.743213', 348),
- (421, '150802', '临河区', 3, '0478', '107.363918,40.751187', 420),
- (422, '150821', '五原县', 3, '0478', '108.267561,41.088421', 420),
- (423, '150822', '磴口县', 3, '0478', '107.008248,40.330523', 420),
- (424, '150823', '乌拉特前旗', 3, '0478', '108.652114,40.737018', 420),
- (425, '150824', '乌拉特中旗', 3, '0478', '108.513645,41.587732', 420),
- (426, '150825', '乌拉特后旗', 3, '0478', '107.074621,41.084282', 420),
- (427, '150826', '杭锦后旗', 3, '0478', '107.151245,40.88602', 420),
- (428, '150900', '乌兰察布市', 2, '0474', '113.132584,40.994785', 348),
- (429, '150902', '集宁区', 3, '0474', '113.116453,41.034134', 428),
- (430, '150921', '卓资县', 3, '0474', '112.577528,40.894691', 428),
- (431, '150922', '化德县', 3, '0474', '114.010437,41.90456', 428),
- (432, '150923', '商都县', 3, '0474', '113.577816,41.562113', 428),
- (433, '150924', '兴和县', 3, '0474', '113.834173,40.872301', 428),
- (434, '150925', '凉城县', 3, '0474', '112.503971,40.531555', 428),
- (435, '150926', '察哈尔右翼前旗', 3, '0474', '113.214733,40.785631', 428),
- (436, '150927', '察哈尔右翼中旗', 3, '0474', '112.635577,41.277462', 428),
- (437, '150928', '察哈尔右翼后旗', 3, '0474', '113.191035,41.436069', 428),
- (438, '150929', '四子王旗', 3, '0474', '111.706617,41.533462', 428),
- (439, '150981', '丰镇市', 3, '0474', '113.109892,40.436983', 428),
- (440, '152200', '兴安盟', 2, '0482', '122.037657,46.082462', 348),
- (441, '152201', '乌兰浩特市', 3, '0482', '122.093123,46.072731', 440),
- (442, '152202', '阿尔山市', 3, '0482', '119.943575,47.17744', 440),
- (443, '152221', '科尔沁右翼前旗', 3, '0482', '121.952621,46.079833', 440),
- (444, '152222', '科尔沁右翼中旗', 3, '0482', '121.47653,45.060837', 440),
- (445, '152223', '扎赉特旗', 3, '0482', '122.899656,46.723237', 440),
- (446, '152224', '突泉县', 3, '0482', '121.593799,45.38193', 440),
- (447, '152500', '锡林郭勒盟', 2, '0479', '116.048222,43.933454', 348),
- (448, '152501', '二连浩特市', 3, '0479', '111.951002,43.6437', 447),
- (449, '152502', '锡林浩特市', 3, '0479', '116.086029,43.933403', 447),
- (450, '152522', '阿巴嘎旗', 3, '0479', '114.950248,44.022995', 447),
- (451, '152523', '苏尼特左旗', 3, '0479', '113.667248,43.85988', 447),
- (452, '152524', '苏尼特右旗', 3, '0479', '112.641783,42.742892', 447),
- (453, '152525', '东乌珠穆沁旗', 3, '0479', '116.974494,45.498221', 447),
- (454, '152526', '西乌珠穆沁旗', 3, '0479', '117.608911,44.587882', 447),
- (455, '152527', '太仆寺旗', 3, '0479', '115.282986,41.877135', 447),
- (456, '152528', '镶黄旗', 3, '0479', '113.847287,42.232371', 447),
- (457, '152529', '正镶白旗', 3, '0479', '115.029848,42.28747', 447),
- (458, '152530', '正蓝旗', 3, '0479', '115.99247,42.241638', 447),
- (459, '152531', '多伦县', 3, '0479', '116.485555,42.203591', 447),
- (460, '152900', '阿拉善盟', 2, '0483', '105.728957,38.851921', 348),
- (461, '152921', '阿拉善左旗', 3, '0483', '105.666275,38.833389', 460),
- (462, '152922', '阿拉善右旗', 3, '0483', '101.666917,39.216185', 460),
- (463, '152923', '额济纳旗', 3, '0483', '101.055731,41.95455', 460),
- (464, '210000', '辽宁省', 1, '[]', '123.431382,41.836175', -1),
- (465, '210100', '沈阳市', 2, '024', '123.465035,41.677284', 464),
- (466, '210102', '和平区', 3, '024', '123.420368,41.789833', 465),
- (467, '210103', '沈河区', 3, '024', '123.458691,41.796177', 465),
- (468, '210104', '大东区', 3, '024', '123.469948,41.805137', 465),
- (469, '210105', '皇姑区', 3, '024', '123.442378,41.824516', 465),
- (470, '210106', '铁西区', 3, '024', '123.333968,41.820807', 465),
- (471, '210111', '苏家屯区', 3, '024', '123.344062,41.664757', 465),
- (472, '210112', '浑南区', 3, '024', '123.449714,41.714914', 465),
- (473, '210113', '沈北新区', 3, '024', '123.583196,41.912487', 465),
- (474, '210114', '于洪区', 3, '024', '123.308119,41.793721', 465),
- (475, '210115', '辽中区', 3, '024', '122.765409,41.516826', 465),
- (476, '210123', '康平县', 3, '024', '123.343699,42.72793', 465),
- (477, '210124', '法库县', 3, '024', '123.440294,42.50108', 465),
- (478, '210181', '新民市', 3, '024', '122.836723,41.985186', 465),
- (479, '210200', '大连市', 2, '0411', '121.614848,38.914086', 464),
- (480, '210202', '中山区', 3, '0411', '121.644926,38.918574', 479),
- (481, '210203', '西岗区', 3, '0411', '121.612324,38.914687', 479),
- (482, '210204', '沙河口区', 3, '0411', '121.594297,38.904788', 479),
- (483, '210211', '甘井子区', 3, '0411', '121.525466,38.953343', 479),
- (484, '210212', '旅顺口区', 3, '0411', '121.261953,38.851705', 479),
- (485, '210213', '金州区', 3, '0411', '121.782655,39.050001', 479),
- (486, '210214', '普兰店区', 3, '0411', '121.938269,39.392095', 479),
- (487, '210224', '长海县', 3, '0411', '122.588494,39.272728', 479),
- (488, '210281', '瓦房店市', 3, '0411', '121.979543,39.626897', 479),
- (489, '210283', '庄河市', 3, '0411', '122.967424,39.680843', 479),
- (490, '210300', '鞍山市', 2, '0412', '122.994329,41.108647', 464),
- (491, '210302', '铁东区', 3, '0412', '122.991052,41.089933', 490),
- (492, '210303', '铁西区', 3, '0412', '122.969629,41.119884', 490),
- (493, '210304', '立山区', 3, '0412', '123.029091,41.150401', 490),
- (494, '210311', '千山区', 3, '0412', '122.944751,41.068901', 490),
- (495, '210321', '台安县', 3, '0412', '122.436196,41.412767', 490),
- (496, '210323', '岫岩满族自治县', 3, '0412', '123.280935,40.29088', 490),
- (497, '210381', '海城市', 3, '0412', '122.685217,40.882377', 490),
- (498, '210400', '抚顺市', 2, '0413', '123.957208,41.880872', 464),
- (499, '210402', '新抚区', 3, '0413', '123.912872,41.862026', 498),
- (500, '210403', '东洲区', 3, '0413', '124.038685,41.853191', 498),
- (501, '210404', '望花区', 3, '0413', '123.784225,41.853641', 498),
- (502, '210411', '顺城区', 3, '0413', '123.945075,41.883235', 498),
- (503, '210421', '抚顺县', 3, '0413', '124.097978,41.922644', 498),
- (504, '210422', '新宾满族自治县', 3, '0413', '125.039978,41.734256', 498),
- (505, '210423', '清原满族自治县', 3, '0413', '124.924083,42.100538', 498),
- (506, '210500', '本溪市', 2, '0414', '123.685142,41.486981', 464),
- (507, '210502', '平山区', 3, '0414', '123.769088,41.299587', 506),
- (508, '210503', '溪湖区', 3, '0414', '123.767646,41.329219', 506),
- (509, '210504', '明山区', 3, '0414', '123.817214,41.308719', 506),
- (510, '210505', '南芬区', 3, '0414', '123.744802,41.100445', 506),
- (511, '210521', '本溪满族自治县', 3, '0414', '124.120635,41.302009', 506),
- (512, '210522', '桓仁满族自治县', 3, '0414', '125.361007,41.267127', 506),
- (513, '210600', '丹东市', 2, '0415', '124.35445,40.000787', 464),
- (514, '210602', '元宝区', 3, '0415', '124.395661,40.136434', 513),
- (515, '210603', '振兴区', 3, '0415', '124.383237,40.129944', 513),
- (516, '210604', '振安区', 3, '0415', '124.470034,40.201553', 513),
- (517, '210624', '宽甸满族自治县', 3, '0415', '124.783659,40.731316', 513),
- (518, '210681', '东港市', 3, '0415', '124.152705,39.863008', 513),
- (519, '210682', '凤城市', 3, '0415', '124.066919,40.452297', 513),
- (520, '210700', '锦州市', 2, '0416', '121.126846,41.095685', 464),
- (521, '210702', '古塔区', 3, '0416', '121.128279,41.117245', 520),
- (522, '210703', '凌河区', 3, '0416', '121.150877,41.114989', 520),
- (523, '210711', '太和区', 3, '0416', '121.103892,41.109147', 520),
- (524, '210726', '黑山县', 3, '0416', '122.126292,41.653593', 520),
- (525, '210727', '义县', 3, '0416', '121.23908,41.533086', 520),
- (526, '210781', '凌海市', 3, '0416', '121.35549,41.160567', 520),
- (527, '210782', '北镇市', 3, '0416', '121.777395,41.58844', 520),
- (528, '210800', '营口市', 2, '0417', '122.219458,40.625364', 464),
- (529, '210802', '站前区', 3, '0417', '122.259033,40.672563', 528),
- (530, '210803', '西市区', 3, '0417', '122.206419,40.666213', 528),
- (531, '210804', '鲅鱼圈区', 3, '0417', '122.121521,40.226661', 528),
- (532, '210811', '老边区', 3, '0417', '122.380087,40.680191', 528),
- (533, '210881', '盖州市', 3, '0417', '122.349012,40.40074', 528),
- (534, '210882', '大石桥市', 3, '0417', '122.509006,40.644482', 528),
- (535, '210900', '阜新市', 2, '0418', '121.670273,42.021602', 464),
- (536, '210902', '海州区', 3, '0418', '121.657638,42.011162', 535),
- (537, '210903', '新邱区', 3, '0418', '121.792535,42.087632', 535),
- (538, '210904', '太平区', 3, '0418', '121.678604,42.010669', 535),
- (539, '210905', '清河门区', 3, '0418', '121.416105,41.7831', 535),
- (540, '210911', '细河区', 3, '0418', '121.68054,42.025494', 535),
- (541, '210921', '阜新蒙古族自治县', 3, '0418', '121.757901,42.065175', 535),
- (542, '210922', '彰武县', 3, '0418', '122.538793,42.386543', 535),
- (543, '211000', '辽阳市', 2, '0419', '123.236974,41.267794', 464),
- (544, '211002', '白塔区', 3, '0419', '123.174325,41.270347', 543),
- (545, '211003', '文圣区', 3, '0419', '123.231408,41.283754', 543),
- (546, '211004', '宏伟区', 3, '0419', '123.196672,41.217649', 543),
- (547, '211005', '弓长岭区', 3, '0419', '123.419803,41.151847', 543),
- (548, '211011', '太子河区', 3, '0419', '123.18144,41.295023', 543),
- (549, '211021', '辽阳县', 3, '0419', '123.105694,41.205329', 543),
- (550, '211081', '灯塔市', 3, '0419', '123.339312,41.426372', 543),
- (551, '211100', '盘锦市', 2, '0427', '122.170584,40.719847', 464),
- (552, '211102', '双台子区', 3, '0427', '122.039787,41.19965', 551),
- (553, '211103', '兴隆台区', 3, '0427', '122.070769,41.119898', 551),
- (554, '211104', '大洼区', 3, '0427', '122.082574,41.002279', 551),
- (555, '211122', '盘山县', 3, '0427', '121.996411,41.242639', 551),
- (556, '211200', '铁岭市', 2, '0410', '123.726035,42.223828', 464),
- (557, '211202', '银州区', 3, '0410', '123.842305,42.286129', 556),
- (558, '211204', '清河区', 3, '0410', '124.159191,42.546565', 556),
- (559, '211221', '铁岭县', 3, '0410', '123.728933,42.223395', 556),
- (560, '211223', '西丰县', 3, '0410', '124.727392,42.73803', 556),
- (561, '211224', '昌图县', 3, '0410', '124.111099,42.785791', 556),
- (562, '211281', '调兵山市', 3, '0410', '123.567117,42.467521', 556),
- (563, '211282', '开原市', 3, '0410', '124.038268,42.546307', 556),
- (564, '211300', '朝阳市', 2, '0421', '120.450879,41.573762', 464),
- (565, '211302', '双塔区', 3, '0421', '120.453744,41.565627', 564),
- (566, '211303', '龙城区', 3, '0421', '120.413376,41.576749', 564),
- (567, '211321', '朝阳县', 3, '0421', '120.389754,41.497825', 564),
- (568, '211322', '建平县', 3, '0421', '119.64328,41.403128', 564),
- (569, '211324', '喀喇沁左翼蒙古族自治县', 3, '0421', '119.741223,41.12815', 564),
- (570, '211381', '北票市', 3, '0421', '120.77073,41.800683', 564),
- (571, '211382', '凌源市', 3, '0421', '119.401574,41.245445', 564),
- (572, '211400', '葫芦岛市', 2, '0429', '120.836939,40.71104', 464),
- (573, '211402', '连山区', 3, '0429', '120.869231,40.774461', 572),
- (574, '211403', '龙港区', 3, '0429', '120.893786,40.735519', 572),
- (575, '211404', '南票区', 3, '0429', '120.749727,41.107107', 572),
- (576, '211421', '绥中县', 3, '0429', '120.344311,40.32558', 572),
- (577, '211422', '建昌县', 3, '0429', '119.837124,40.824367', 572),
- (578, '211481', '兴城市', 3, '0429', '120.756479,40.609731', 572),
- (579, '220000', '吉林省', 1, '[]', '125.32568,43.897016', -1),
- (580, '220100', '长春市', 2, '0431', '125.323513,43.817251', 579),
- (581, '220102', '南关区', 3, '0431', '125.350173,43.863989', 580),
- (582, '220103', '宽城区', 3, '0431', '125.326581,43.943612', 580),
- (583, '220104', '朝阳区', 3, '0431', '125.288254,43.833762', 580),
- (584, '220105', '二道区', 3, '0431', '125.374327,43.865577', 580),
- (585, '220106', '绿园区', 3, '0431', '125.256135,43.880975', 580),
- (586, '220112', '双阳区', 3, '0431', '125.664662,43.525311', 580),
- (587, '220113', '九台区', 3, '0431', '125.839573,44.151742', 580),
- (588, '220122', '农安县', 3, '0431', '125.184887,44.432763', 580),
- (589, '220182', '榆树市', 3, '0431', '126.533187,44.840318', 580),
- (590, '220183', '德惠市', 3, '0431', '125.728755,44.522056', 580),
- (591, '220200', '吉林市', 2, '0432', '126.549572,43.837883', 579),
- (592, '220202', '昌邑区', 3, '0432', '126.574709,43.881818', 591),
- (593, '220203', '龙潭区', 3, '0432', '126.562197,43.910802', 591),
- (594, '220204', '船营区', 3, '0432', '126.540966,43.833445', 591),
- (595, '220211', '丰满区', 3, '0432', '126.562274,43.821601', 591),
- (596, '220221', '永吉县', 3, '0432', '126.497741,43.672582', 591),
- (597, '220281', '蛟河市', 3, '0432', '127.344229,43.724007', 591),
- (598, '220282', '桦甸市', 3, '0432', '126.746309,42.972096', 591),
- (599, '220283', '舒兰市', 3, '0432', '126.965607,44.406105', 591),
- (600, '220284', '磐石市', 3, '0432', '126.060427,42.946285', 591),
- (601, '220300', '四平市', 2, '0434', '124.350398,43.166419', 579),
- (602, '220302', '铁西区', 3, '0434', '124.345722,43.146155', 601),
- (603, '220303', '铁东区', 3, '0434', '124.409591,43.162105', 601),
- (604, '220322', '梨树县', 3, '0434', '124.33539,43.30706', 601),
- (605, '220323', '伊通满族自治县', 3, '0434', '125.305393,43.345754', 601),
- (606, '220381', '公主岭市', 3, '0434', '124.822929,43.504676', 601),
- (607, '220382', '双辽市', 3, '0434', '123.502723,43.518302', 601),
- (608, '220400', '辽源市', 2, '0437', '125.14366,42.887766', 579),
- (609, '220402', '龙山区', 3, '0437', '125.136627,42.90158', 608),
- (610, '220403', '西安区', 3, '0437', '125.149281,42.927324', 608),
- (611, '220421', '东丰县', 3, '0437', '125.531021,42.677371', 608),
- (612, '220422', '东辽县', 3, '0437', '124.991424,42.92625', 608),
- (613, '220500', '通化市', 2, '0435', '125.939697,41.728401', 579),
- (614, '220502', '东昌区', 3, '0435', '125.927101,41.702859', 613),
- (615, '220503', '二道江区', 3, '0435', '126.042678,41.774044', 613),
- (616, '220521', '通化县', 3, '0435', '125.759259,41.679808', 613),
- (617, '220523', '辉南县', 3, '0435', '126.046783,42.684921', 613),
- (618, '220524', '柳河县', 3, '0435', '125.744735,42.284605', 613),
- (619, '220581', '梅河口市', 3, '0435', '125.710859,42.539253', 613),
- (620, '220582', '集安市', 3, '0435', '126.19403,41.125307', 613),
- (621, '220600', '白山市', 2, '0439', '126.41473,41.943972', 579),
- (622, '220602', '浑江区', 3, '0439', '126.416093,41.945409', 621),
- (623, '220605', '江源区', 3, '0439', '126.591178,42.056747', 621),
- (624, '220621', '抚松县', 3, '0439', '127.449763,42.221207', 621),
- (625, '220622', '靖宇县', 3, '0439', '126.813583,42.388896', 621),
- (626, '220623', '长白朝鲜族自治县', 3, '0439', '128.200789,41.420018', 621),
- (627, '220681', '临江市', 3, '0439', '126.918087,41.811979', 621),
- (628, '220700', '松原市', 2, '0438', '124.825042,45.141548', 579),
- (629, '220702', '宁江区', 3, '0438', '124.86562,45.209915', 628),
- (630, '220721', '前郭尔罗斯蒙古族自治县', 3, '0438', '124.823417,45.118061', 628),
- (631, '220722', '长岭县', 3, '0438', '123.967483,44.275895', 628),
- (632, '220723', '乾安县', 3, '0438', '124.041139,45.003773', 628),
- (633, '220781', '扶余市', 3, '0438', '126.049803,44.9892', 628),
- (634, '220800', '白城市', 2, '0436', '122.838714,45.619884', 579),
- (635, '220802', '洮北区', 3, '0436', '122.851029,45.621716', 634),
- (636, '220821', '镇赉县', 3, '0436', '123.199607,45.84835', 634),
- (637, '220822', '通榆县', 3, '0436', '123.088238,44.81291', 634),
- (638, '220881', '洮南市', 3, '0436', '122.798579,45.356807', 634),
- (639, '220882', '大安市', 3, '0436', '124.292626,45.506996', 634),
- (640, '222400', '延边朝鲜族自治州', 2, '1433', '129.471868,42.909408', 579),
- (641, '222401', '延吉市', 3, '1433', '129.508804,42.89125', 640),
- (642, '222402', '图们市', 3, '1433', '129.84371,42.968044', 640),
- (643, '222403', '敦化市', 3, '1433', '128.232131,43.372642', 640),
- (644, '222404', '珲春市', 3, '1433', '130.366036,42.862821', 640),
- (645, '222405', '龙井市', 3, '1433', '129.427066,42.76631', 640),
- (646, '222406', '和龙市', 3, '1433', '129.010106,42.546675', 640),
- (647, '222424', '汪清县', 3, '1433', '129.771607,43.312522', 640),
- (648, '222426', '安图县', 3, '1433', '128.899772,43.11195', 640),
- (649, '230000', '黑龙江省', 1, '[]', '126.661665,45.742366', -1),
- (650, '230100', '哈尔滨市', 2, '0451', '126.534967,45.803775', 649),
- (651, '230102', '道里区', 3, '0451', '126.616973,45.75577', 650),
- (652, '230103', '南岗区', 3, '0451', '126.668784,45.760174', 650),
- (653, '230104', '道外区', 3, '0451', '126.64939,45.792057', 650),
- (654, '230108', '平房区', 3, '0451', '126.637611,45.597911', 650),
- (655, '230109', '松北区', 3, '0451', '126.516914,45.794504', 650),
- (656, '230110', '香坊区', 3, '0451', '126.662593,45.707716', 650),
- (657, '230111', '呼兰区', 3, '0451', '126.587905,45.889457', 650),
- (658, '230112', '阿城区', 3, '0451', '126.958098,45.548669', 650),
- (659, '230113', '双城区', 3, '0451', '126.312624,45.383218', 650),
- (660, '230123', '依兰县', 3, '0451', '129.567877,46.325419', 650),
- (661, '230124', '方正县', 3, '0451', '128.829536,45.851694', 650),
- (662, '230125', '宾县', 3, '0451', '127.466634,45.745917', 650),
- (663, '230126', '巴彦县', 3, '0451', '127.403781,46.086549', 650),
- (664, '230127', '木兰县', 3, '0451', '128.043466,45.950582', 650),
- (665, '230128', '通河县', 3, '0451', '128.746124,45.990205', 650),
- (666, '230129', '延寿县', 3, '0451', '128.331643,45.451897', 650),
- (667, '230183', '尚志市', 3, '0451', '128.009894,45.209586', 650),
- (668, '230184', '五常市', 3, '0451', '127.167618,44.931991', 650),
- (669, '230200', '齐齐哈尔市', 2, '0452', '123.918186,47.354348', 649),
- (670, '230202', '龙沙区', 3, '0452', '123.957531,47.317308', 669),
- (671, '230203', '建华区', 3, '0452', '123.955464,47.354364', 669),
- (672, '230204', '铁锋区', 3, '0452', '123.978293,47.340517', 669),
- (673, '230205', '昂昂溪区', 3, '0452', '123.8224,47.15516', 669),
- (674, '230206', '富拉尔基区', 3, '0452', '123.629189,47.208843', 669),
- (675, '230207', '碾子山区', 3, '0452', '122.887775,47.516872', 669),
- (676, '230208', '梅里斯达斡尔族区', 3, '0452', '123.75291,47.309537', 669),
- (677, '230221', '龙江县', 3, '0452', '123.205323,47.338665', 669),
- (678, '230223', '依安县', 3, '0452', '125.306278,47.893548', 669),
- (679, '230224', '泰来县', 3, '0452', '123.416631,46.393694', 669),
- (680, '230225', '甘南县', 3, '0452', '123.507429,47.922405', 669),
- (681, '230227', '富裕县', 3, '0452', '124.473793,47.774347', 669),
- (682, '230229', '克山县', 3, '0452', '125.875705,48.037031', 669),
- (683, '230230', '克东县', 3, '0452', '126.24872,48.04206', 669),
- (684, '230231', '拜泉县', 3, '0452', '126.100213,47.595851', 669),
- (685, '230281', '讷河市', 3, '0452', '124.88287,48.466592', 669),
- (686, '230300', '鸡西市', 2, '0467', '130.969333,45.295075', 649),
- (687, '230302', '鸡冠区', 3, '0467', '130.981185,45.304355', 686),
- (688, '230303', '恒山区', 3, '0467', '130.904963,45.210668', 686),
- (689, '230304', '滴道区', 3, '0467', '130.843613,45.348763', 686),
- (690, '230305', '梨树区', 3, '0467', '130.69699,45.092046', 686),
- (691, '230306', '城子河区', 3, '0467', '131.011304,45.33697', 686),
- (692, '230307', '麻山区', 3, '0467', '130.478187,45.212088', 686),
- (693, '230321', '鸡东县', 3, '0467', '131.124079,45.260412', 686),
- (694, '230381', '虎林市', 3, '0467', '132.93721,45.762685', 686),
- (695, '230382', '密山市', 3, '0467', '131.846635,45.529774', 686),
- (696, '230400', '鹤岗市', 2, '0468', '130.297943,47.350189', 649),
- (697, '230402', '向阳区', 3, '0468', '130.294235,47.342468', 696),
- (698, '230403', '工农区', 3, '0468', '130.274684,47.31878', 696),
- (699, '230404', '南山区', 3, '0468', '130.286788,47.315174', 696),
- (700, '230405', '兴安区', 3, '0468', '130.239245,47.252849', 696),
- (701, '230406', '东山区', 3, '0468', '130.317002,47.338537', 696),
- (702, '230407', '兴山区', 3, '0468', '130.303481,47.357702', 696),
- (703, '230421', '萝北县', 3, '0468', '130.85155,47.576444', 696),
- (704, '230422', '绥滨县', 3, '0468', '131.852759,47.289115', 696),
- (705, '230500', '双鸭山市', 2, '0469', '131.141195,46.676418', 649),
- (706, '230502', '尖山区', 3, '0469', '131.158415,46.64635', 705),
- (707, '230503', '岭东区', 3, '0469', '131.164723,46.592721', 705),
- (708, '230505', '四方台区', 3, '0469', '131.337592,46.597264', 705),
- (709, '230506', '宝山区', 3, '0469', '131.401589,46.577167', 705),
- (710, '230521', '集贤县', 3, '0469', '131.141311,46.728412', 705),
- (711, '230522', '友谊县', 3, '0469', '131.808063,46.767299', 705),
- (712, '230523', '宝清县', 3, '0469', '132.196853,46.327457', 705),
- (713, '230524', '饶河县', 3, '0469', '134.013872,46.798163', 705),
- (714, '230600', '大庆市', 2, '0459', '125.103784,46.589309', 649),
- (715, '230602', '萨尔图区', 3, '0459', '125.135591,46.629092', 714),
- (716, '230603', '龙凤区', 3, '0459', '125.135326,46.562247', 714),
- (717, '230604', '让胡路区', 3, '0459', '124.870596,46.652357', 714),
- (718, '230605', '红岗区', 3, '0459', '124.891039,46.398418', 714),
- (719, '230606', '大同区', 3, '0459', '124.812364,46.039827', 714),
- (720, '230621', '肇州县', 3, '0459', '125.268643,45.699066', 714),
- (721, '230622', '肇源县', 3, '0459', '125.078223,45.51932', 714),
- (722, '230623', '林甸县', 3, '0459', '124.863603,47.171717', 714),
- (723, '230624', '杜尔伯特蒙古族自治县', 3, '0459', '124.442572,46.862817', 714),
- (724, '230700', '伊春市', 2, '0458', '128.841125,47.727535', 649),
- (725, '230702', '伊春区', 3, '0458', '128.907257,47.728237', 724),
- (726, '230703', '南岔区', 3, '0458', '129.283467,47.138034', 724),
- (727, '230704', '友好区', 3, '0458', '128.836291,47.841032', 724),
- (728, '230705', '西林区', 3, '0458', '129.312851,47.480735', 724),
- (729, '230706', '翠峦区', 3, '0458', '128.669754,47.726394', 724),
- (730, '230707', '新青区', 3, '0458', '129.533599,48.290455', 724),
- (731, '230708', '美溪区', 3, '0458', '129.129314,47.63509', 724),
- (732, '230709', '金山屯区', 3, '0458', '129.429117,47.413074', 724),
- (733, '230710', '五营区', 3, '0458', '129.245343,48.10791', 724),
- (734, '230711', '乌马河区', 3, '0458', '128.799477,47.727687', 724),
- (735, '230712', '汤旺河区', 3, '0458', '129.571108,48.454651', 724),
- (736, '230713', '带岭区', 3, '0458', '129.020888,47.028379', 724),
- (737, '230714', '乌伊岭区', 3, '0458', '129.43792,48.590322', 724),
- (738, '230715', '红星区', 3, '0458', '129.390983,48.239431', 724),
- (739, '230716', '上甘岭区', 3, '0458', '129.02426,47.974707', 724),
- (740, '230722', '嘉荫县', 3, '0458', '130.403134,48.888972', 724),
- (741, '230781', '铁力市', 3, '0458', '128.032424,46.986633', 724),
- (742, '230800', '佳木斯市', 2, '0454', '130.318878,46.799777', 649),
- (743, '230803', '向阳区', 3, '0454', '130.365346,46.80779', 742),
- (744, '230804', '前进区', 3, '0454', '130.375062,46.814102', 742),
- (745, '230805', '东风区', 3, '0454', '130.403664,46.822571', 742),
- (746, '230811', '郊区', 3, '0454', '130.327194,46.810085', 742),
- (747, '230822', '桦南县', 3, '0454', '130.553343,46.239184', 742),
- (748, '230826', '桦川县', 3, '0454', '130.71908,47.023001', 742),
- (749, '230828', '汤原县', 3, '0454', '129.905072,46.730706', 742),
- (750, '230881', '同江市', 3, '0454', '132.510919,47.642707', 742),
- (751, '230882', '富锦市', 3, '0454', '132.037686,47.250107', 742),
- (752, '230883', '抚远市', 3, '0454', '134.307884,48.364687', 742),
- (753, '230900', '七台河市', 2, '0464', '131.003082,45.771396', 649),
- (754, '230902', '新兴区', 3, '0464', '130.932143,45.81593', 753),
- (755, '230903', '桃山区', 3, '0464', '131.020202,45.765705', 753),
- (756, '230904', '茄子河区', 3, '0464', '131.068075,45.785215', 753),
- (757, '230921', '勃利县', 3, '0464', '130.59217,45.755063', 753),
- (758, '231000', '牡丹江市', 2, '0453', '129.633168,44.551653', 649),
- (759, '231002', '东安区', 3, '0453', '129.626641,44.58136', 758),
- (760, '231003', '阳明区', 3, '0453', '129.635615,44.596104', 758),
- (761, '231004', '爱民区', 3, '0453', '129.591537,44.596042', 758),
- (762, '231005', '西安区', 3, '0453', '129.616058,44.577625', 758),
- (763, '231025', '林口县', 3, '0453', '130.284033,45.278046', 758),
- (764, '231081', '绥芬河市', 3, '0453', '131.152545,44.412308', 758),
- (765, '231083', '海林市', 3, '0453', '129.380481,44.594213', 758),
- (766, '231084', '宁安市', 3, '0453', '129.482851,44.34072', 758),
- (767, '231085', '穆棱市', 3, '0453', '130.524436,44.918813', 758),
- (768, '231086', '东宁市', 3, '0453', '131.122915,44.087585', 758),
- (769, '231100', '黑河市', 2, '0456', '127.528293,50.245129', 649),
- (770, '231102', '爱辉区', 3, '0456', '127.50045,50.252105', 769),
- (771, '231121', '嫩江县', 3, '0456', '125.221192,49.185766', 769),
- (772, '231123', '逊克县', 3, '0456', '128.478749,49.564252', 769),
- (773, '231124', '孙吴县', 3, '0456', '127.336303,49.425647', 769),
- (774, '231181', '北安市', 3, '0456', '126.490864,48.241365', 769),
- (775, '231182', '五大连池市', 3, '0456', '126.205516,48.517257', 769),
- (776, '231200', '绥化市', 2, '0455', '126.968887,46.653845', 649),
- (777, '231202', '北林区', 3, '0455', '126.985504,46.6375', 776),
- (778, '231221', '望奎县', 3, '0455', '126.486075,46.832719', 776),
- (779, '231222', '兰西县', 3, '0455', '126.288117,46.25245', 776),
- (780, '231223', '青冈县', 3, '0455', '126.099195,46.70391', 776),
- (781, '231224', '庆安县', 3, '0455', '127.507824,46.880102', 776),
- (782, '231225', '明水县', 3, '0455', '125.906301,47.173426', 776),
- (783, '231226', '绥棱县', 3, '0455', '127.114832,47.236015', 776),
- (784, '231281', '安达市', 3, '0455', '125.346156,46.419633', 776),
- (785, '231282', '肇东市', 3, '0455', '125.961814,46.051126', 776),
- (786, '231283', '海伦市', 3, '0455', '126.930106,47.45117', 776),
- (787, '232700', '大兴安岭地区', 2, '0457', '124.711526,52.335262', 649),
- (788, '232701', '加格达奇区', 3, '0457', '124.139595,50.408735', 787),
- (789, '232721', '呼玛县', 3, '0457', '126.652396,51.726091', 787),
- (790, '232722', '塔河县', 3, '0457', '124.709996,52.334456', 787),
- (791, '232723', '漠河县', 3, '0457', '122.538591,52.972272', 787),
- (792, '310000', '上海市', 1, '021', '121.473662,31.230372', -1),
- (793, '310100', '上海城区', 2, '021', '121.473662,31.230372', 792),
- (794, '310101', '黄浦区', 3, '021', '121.484428,31.231739', 793),
- (795, '310104', '徐汇区', 3, '021', '121.436128,31.188464', 793),
- (796, '310105', '长宁区', 3, '021', '121.424622,31.220372', 793),
- (797, '310106', '静安区', 3, '021', '121.447453,31.227906', 793),
- (798, '310107', '普陀区', 3, '021', '121.395514,31.249603', 793),
- (799, '310109', '虹口区', 3, '021', '121.505133,31.2646', 793),
全国省市区信息,mysql数据库记录
2019年12月05日
阅读数:1052
这篇文章主要向大家介绍全国省市区信息,mysql数据库记录,主要内容包括基础应用、实用技巧、原理机制等方面,希望对大家有所帮助。