全国省市区带拼音经纬度的数据库sql

原文链接：http://www.cnblogs.com/jiqing9006/p/5849874.html

/*
Navicat MySQL Data Transfer

Source Server         : 246
Source Server Version : 50617
Source Host           : 192.168.1.246:3306
Source Database       : storehelper

Target Server Type    : MYSQL
Target Server Version : 50617
File Encoding         : 65001

Date: 2016-09-07 16:07:57
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for sh_area
-- ----------------------------
DROP TABLE IF EXISTS `sh_area`;
CREATE TABLE `sh_area` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT ‘ID‘,
  `pid` int(11) DEFAULT NULL COMMENT ‘父id‘,
  `shortname` varchar(100) DEFAULT NULL COMMENT ‘简称‘,
  `name` varchar(100) DEFAULT NULL COMMENT ‘名称‘,
  `merger_name` varchar(255) DEFAULT NULL COMMENT ‘全称‘,
  `level` tinyint(4) DEFAULT NULL COMMENT ‘层级 0 1 2 省市区县‘,
  `pinyin` varchar(100) DEFAULT NULL COMMENT ‘拼音‘,
  `code` varchar(100) DEFAULT NULL COMMENT ‘长途区号‘,
  `zip_code` varchar(100) DEFAULT NULL COMMENT ‘邮编‘,
  `first` varchar(50) DEFAULT NULL COMMENT ‘首字母‘,
  `lng` varchar(100) DEFAULT NULL COMMENT ‘经度‘,
  `lat` varchar(100) DEFAULT NULL COMMENT ‘纬度‘,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3750 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sh_area
-- ----------------------------
INSERT INTO `sh_area` VALUES (‘1‘, ‘0‘, ‘北京‘, ‘北京‘, ‘中国,北京‘, ‘1‘, ‘beijing‘, ‘‘, ‘‘, ‘B‘, ‘116.405285‘, ‘39.904989‘);
INSERT INTO `sh_area` VALUES (‘2‘, ‘1‘, ‘北京‘, ‘北京市‘, ‘中国,北京,北京市‘, ‘2‘, ‘beijing‘, ‘010‘, ‘100000‘, ‘B‘, ‘116.405285‘, ‘39.904989‘);
INSERT INTO `sh_area` VALUES (‘3‘, ‘2‘, ‘东城‘, ‘东城区‘, ‘中国,北京,北京市,东城区‘, ‘3‘, ‘dongcheng‘, ‘010‘, ‘100010‘, ‘D‘, ‘116.41005‘, ‘39.93157‘);
INSERT INTO `sh_area` VALUES (‘4‘, ‘2‘, ‘西城‘, ‘西城区‘, ‘中国,北京,北京市,西城区‘, ‘3‘, ‘xicheng‘, ‘010‘, ‘100032‘, ‘X‘, ‘116.36003‘, ‘39.9305‘);
INSERT INTO `sh_area` VALUES (‘5‘, ‘2‘, ‘朝阳‘, ‘朝阳区‘, ‘中国,北京,北京市,朝阳区‘, ‘3‘, ‘chaoyang‘, ‘010‘, ‘100020‘, ‘C‘, ‘116.48548‘, ‘39.9484‘);
INSERT INTO `sh_area` VALUES (‘6‘, ‘2‘, ‘丰台‘, ‘丰台区‘, ‘中国,北京,北京市,丰台区‘, ‘3‘, ‘fengtai‘, ‘010‘, ‘100071‘, ‘F‘, ‘116.28625‘, ‘39.8585‘);
INSERT INTO `sh_area` VALUES (‘7‘, ‘2‘, ‘石景山‘, ‘石景山区‘, ‘中国,北京,北京市,石景山区‘, ‘3‘, ‘shijingshan‘, ‘010‘, ‘100043‘, ‘S‘, ‘116.2229‘, ‘39.90564‘);
INSERT INTO `sh_area` VALUES (‘8‘, ‘2‘, ‘海淀‘, ‘海淀区‘, ‘中国,北京,北京市,海淀区‘, ‘3‘, ‘haidian‘, ‘010‘, ‘100089‘, ‘H‘, ‘116.29812‘, ‘39.95931‘);
INSERT INTO `sh_area` VALUES (‘9‘, ‘2‘, ‘门头沟‘, ‘门头沟区‘, ‘中国,北京,北京市,门头沟区‘, ‘3‘, ‘mentougou‘, ‘010‘, ‘102300‘, ‘M‘, ‘116.10137‘, ‘39.94043‘);
INSERT INTO `sh_area` VALUES (‘10‘, ‘2‘, ‘房山‘, ‘房山区‘, ‘中国,北京,北京市,房山区‘, ‘3‘, ‘fangshan‘, ‘010‘, ‘102488‘, ‘F‘, ‘116.14257‘, ‘39.74786‘);
INSERT INTO `sh_area` VALUES (‘11‘, ‘2‘, ‘通州‘, ‘通州区‘, ‘中国,北京,北京市,通州区‘, ‘3‘, ‘tongzhou‘, ‘010‘, ‘101149‘, ‘T‘, ‘116.65716‘, ‘39.90966‘);
INSERT INTO `sh_area` VALUES (‘12‘, ‘2‘, ‘顺义‘, ‘顺义区‘, ‘中国,北京,北京市,顺义区‘, ‘3‘, ‘shunyi‘, ‘010‘, ‘101300‘, ‘S‘, ‘116.65417‘, ‘40.1302‘);
INSERT INTO `sh_area` VALUES (‘13‘, ‘2‘, ‘昌平‘, ‘昌平区‘, ‘中国,北京,北京市,昌平区‘, ‘3‘, ‘changping‘, ‘010‘, ‘102200‘, ‘C‘, ‘116.2312‘, ‘40.22072‘);
INSERT INTO `sh_area` VALUES (‘14‘, ‘2‘, ‘大兴‘, ‘大兴区‘, ‘中国,北京,北京市,大兴区‘, ‘3‘, ‘daxing‘, ‘010‘, ‘102600‘, ‘D‘, ‘116.34149‘, ‘39.72668‘);
INSERT INTO `sh_area` VALUES (‘15‘, ‘2‘, ‘怀柔‘, ‘怀柔区‘, ‘中国,北京,北京市,怀柔区‘, ‘3‘, ‘huairou‘, ‘010‘, ‘101400‘, ‘H‘, ‘116.63168‘, ‘40.31602‘);
INSERT INTO `sh_area` VALUES (‘16‘, ‘2‘, ‘平谷‘, ‘平谷区‘, ‘中国,北京,北京市,平谷区‘, ‘3‘, ‘pinggu‘, ‘010‘, ‘101200‘, ‘P‘, ‘117.12133‘, ‘40.14056‘);
INSERT INTO `sh_area` VALUES (‘17‘, ‘2‘, ‘密云‘, ‘密云县‘, ‘中国,北京,北京市,密云县‘, ‘3‘, ‘miyun‘, ‘010‘, ‘101500‘, ‘M‘, ‘116.84295‘, ‘40.37618‘);
INSERT INTO `sh_area` VALUES (‘18‘, ‘2‘, ‘延庆‘, ‘延庆县‘, ‘中国,北京,北京市,延庆县‘, ‘3‘, ‘yanqing‘, ‘010‘, ‘102100‘, ‘Y‘, ‘115.97494‘, ‘40.45672‘);
INSERT INTO `sh_area` VALUES (‘19‘, ‘0‘, ‘天津‘, ‘天津‘, ‘中国,天津‘, ‘1‘, ‘tianjin‘, ‘‘, ‘‘, ‘T‘, ‘117.190182‘, ‘39.125596‘);
INSERT INTO `sh_area` VALUES (‘20‘, ‘19‘, ‘天津‘, ‘天津市‘, ‘中国,天津,天津市‘, ‘2‘, ‘tianjin‘, ‘022‘, ‘300000‘, ‘T‘, ‘117.190182‘, ‘39.125596‘);
INSERT INTO `sh_area` VALUES (‘21‘, ‘20‘, ‘和平‘, ‘和平区‘, ‘中国,天津,天津市,和平区‘, ‘3‘, ‘heping‘, ‘022‘, ‘300041‘, ‘H‘, ‘117.21456‘, ‘39.11718‘);
INSERT INTO `sh_area` VALUES (‘22‘, ‘20‘, ‘河东‘, ‘河东区‘, ‘中国,天津,天津市,河东区‘, ‘3‘, ‘hedong‘, ‘022‘, ‘300171‘, ‘H‘, ‘117.22562‘, ‘39.12318‘);
INSERT INTO `sh_area` VALUES (‘23‘, ‘20‘, ‘河西‘, ‘河西区‘, ‘中国,天津,天津市,河西区‘, ‘3‘, ‘hexi‘, ‘022‘, ‘300202‘, ‘H‘, ‘117.22327‘, ‘39.10959‘);
INSERT INTO `sh_area` VALUES (‘24‘, ‘20‘, ‘南开‘, ‘南开区‘, ‘中国,天津,天津市,南开区‘, ‘3‘, ‘nankai‘, ‘022‘, ‘300110‘, ‘N‘, ‘117.15074‘, ‘39.13821‘);
INSERT INTO `sh_area` VALUES (‘25‘, ‘20‘, ‘河北‘, ‘河北区‘, ‘中国,天津,天津市,河北区‘, ‘3‘, ‘hebei‘, ‘022‘, ‘300143‘, ‘H‘, ‘117.19697‘, ‘39.14816‘);
INSERT INTO `sh_area` VALUES (‘26‘, ‘20‘, ‘红桥‘, ‘红桥区‘, ‘中国,天津,天津市,红桥区‘, ‘3‘, ‘hongqiao‘, ‘022‘, ‘300131‘, ‘H‘, ‘117.15145‘, ‘39.16715‘);
INSERT INTO `sh_area` VALUES (‘27‘, ‘20‘, ‘东丽‘, ‘东丽区‘, ‘中国,天津,天津市,东丽区‘, ‘3‘, ‘dongli‘, ‘022‘, ‘300300‘, ‘D‘, ‘117.31436‘, ‘39.0863‘);
INSERT INTO `sh_area` VALUES (‘28‘, ‘20‘, ‘西青‘, ‘西青区‘, ‘中国,天津,天津市,西青区‘, ‘3‘, ‘xiqing‘, ‘022‘, ‘300380‘, ‘X‘, ‘117.00927‘, ‘39.14123‘);
INSERT INTO `sh_area` VALUES (‘29‘, ‘20‘, ‘津南‘, ‘津南区‘, ‘中国,天津,天津市,津南区‘, ‘3‘, ‘jinnan‘, ‘022‘, ‘300350‘, ‘J‘, ‘117.38537‘, ‘38.99139‘);
INSERT INTO `sh_area` VALUES (‘30‘, ‘20‘, ‘北辰‘, ‘北辰区‘, ‘中国,天津,天津市,北辰区‘, ‘3‘, ‘beichen‘, ‘022‘, ‘300400‘, ‘B‘, ‘117.13217‘, ‘39.22131‘);
INSERT INTO `sh_area` VALUES (‘31‘, ‘20‘, ‘武清‘, ‘武清区‘, ‘中国,天津,天津市,武清区‘, ‘3‘, ‘wuqing‘, ‘022‘, ‘301700‘, ‘W‘, ‘117.04443‘, ‘39.38415‘);
INSERT INTO `sh_area` VALUES (‘32‘, ‘20‘, ‘宝坻‘, ‘宝坻区‘, ‘中国,天津,天津市,宝坻区‘, ‘3‘, ‘baodi‘, ‘022‘, ‘301800‘, ‘B‘, ‘117.3103‘, ‘39.71761‘);
INSERT INTO `sh_area` VALUES (‘33‘, ‘20‘, ‘滨海新区‘, ‘滨海新区‘, ‘中国,天津,天津市,滨海新区‘, ‘3‘, ‘binhaixinqu‘, ‘022‘, ‘300451‘, ‘B‘, ‘117.70162‘, ‘39.02668‘);
INSERT INTO `sh_area` VALUES (‘34‘, ‘20‘, ‘宁河‘, ‘宁河县‘, ‘中国,天津,天津市,宁河县‘, ‘3‘, ‘ninghe‘, ‘022‘, ‘301500‘, ‘N‘, ‘117.8255‘, ‘39.33048‘);
INSERT INTO `sh_area` VALUES (‘35‘, ‘20‘, ‘静海‘, ‘静海县‘, ‘中国,天津,天津市,静海县‘, ‘3‘, ‘jinghai‘, ‘022‘, ‘301600‘, ‘J‘, ‘116.97436‘, ‘38.94582‘);
INSERT INTO `sh_area` VALUES (‘36‘, ‘20‘, ‘蓟县‘, ‘蓟县‘, ‘中国,天津,天津市,蓟县‘, ‘3‘, ‘jixian‘, ‘022‘, ‘301900‘, ‘J‘, ‘117.40799‘, ‘40.04567‘);
INSERT INTO `sh_area` VALUES (‘37‘, ‘0‘, ‘河北‘, ‘河北省‘, ‘中国,河北省‘, ‘1‘, ‘hebei‘, ‘‘, ‘‘, ‘H‘, ‘114.502461‘, ‘38.045474‘);
INSERT INTO `sh_area` VALUES (‘38‘, ‘37‘, ‘石家庄‘, ‘石家庄市‘, ‘中国,河北省,石家庄市‘, ‘2‘, ‘shijiazhuang‘, ‘0311‘, ‘050011‘, ‘S‘, ‘114.502461‘, ‘38.045474‘);
INSERT INTO `sh_area` VALUES (‘39‘, ‘38‘, ‘长安‘, ‘长安区‘, ‘中国,河北省,石家庄市,长安区‘, ‘3‘, ‘chang\‘an‘, ‘0311‘, ‘050011‘, ‘C‘, ‘114.53906‘, ‘38.03665‘);
INSERT INTO `sh_area` VALUES (‘40‘, ‘38‘, ‘桥西‘, ‘桥西区‘, ‘中国,河北省,石家庄市,桥西区‘, ‘3‘, ‘qiaoxi‘, ‘0311‘, ‘050091‘, ‘Q‘, ‘114.46977‘, ‘38.03221‘);
INSERT INTO `sh_area` VALUES (‘41‘, ‘38‘, ‘新华‘, ‘新华区‘, ‘中国,河北省,石家庄市,新华区‘, ‘3‘, ‘xinhua‘, ‘0311‘, ‘050051‘, ‘X‘, ‘114.46326‘, ‘38.05088‘);
INSERT INTO `sh_area` VALUES (‘42‘, ‘38‘, ‘井陉矿区‘, ‘井陉矿区‘, ‘中国,河北省,石家庄市,井陉矿区‘, ‘3‘, ‘jingxingkuangqu‘, ‘0311‘, ‘050100‘, ‘J‘, ‘114.06518‘, ‘38.06705‘);
INSERT INTO `sh_area` VALUES (‘43‘, ‘38‘, ‘裕华‘, ‘裕华区‘, ‘中国,河北省,石家庄市,裕华区‘, ‘3‘, ‘yuhua‘, ‘0311‘, ‘050031‘, ‘Y‘, ‘114.53115‘, ‘38.00604‘);
INSERT INTO `sh_area` VALUES (‘44‘, ‘38‘, ‘藁城‘, ‘藁城区‘, ‘中国,河北省,石家庄市,藁城区‘, ‘3‘, ‘gaocheng‘, ‘0311‘, ‘052160‘, null, ‘114.84671‘, ‘38.02162‘);
INSERT INTO `sh_area` VALUES (‘45‘, ‘38‘, ‘鹿泉‘, ‘鹿泉区‘, ‘中国,河北省,石家庄市,鹿泉区‘, ‘3‘, ‘luquan‘, ‘0311‘, ‘050200‘, ‘L‘, ‘114.31347‘, ‘38.08782‘);
INSERT INTO `sh_area` VALUES (‘46‘, ‘38‘, ‘栾城‘, ‘栾城区‘, ‘中国,河北省,石家庄市,栾城区‘, ‘3‘, ‘luancheng‘, ‘0311‘, ‘051430‘, null, ‘114.64834‘, ‘37.90022‘);
INSERT INTO `sh_area` VALUES (‘47‘, ‘38‘, ‘井陉‘, ‘井陉县‘, ‘中国,河北省,石家庄市,井陉县‘, ‘3‘, ‘jingxing‘, ‘0311‘, ‘050300‘, ‘J‘, ‘114.14257‘, ‘38.03688‘);
INSERT INTO `sh_area` VALUES (‘48‘, ‘38‘, ‘正定‘, ‘正定县‘, ‘中国,河北省,石家庄市,正定县‘, ‘3‘, ‘zhengding‘, ‘0311‘, ‘050800‘, ‘Z‘, ‘114.57296‘, ‘38.14445‘);
INSERT INTO `sh_area` VALUES (‘49‘, ‘38‘, ‘行唐‘, ‘行唐县‘, ‘中国,河北省,石家庄市,行唐县‘, ‘3‘, ‘xingtang‘, ‘0311‘, ‘050600‘, ‘X‘, ‘114.55316‘, ‘38.43654‘);
INSERT INTO `sh_area` VALUES (‘50‘, ‘38‘, ‘灵寿‘, ‘灵寿县‘, ‘中国,河北省,石家庄市,灵寿县‘, ‘3‘, ‘lingshou‘, ‘0311‘, ‘050500‘, ‘L‘, ‘114.38259‘, ‘38.30845‘);
INSERT INTO `sh_area` VALUES (‘51‘, ‘38‘, ‘高邑‘, ‘高邑县‘, ‘中国,河北省,石家庄市,高邑县‘, ‘3‘, ‘gaoyi‘, ‘0311‘, ‘051330‘, ‘G‘, ‘114.61142‘, ‘37.61556‘);
INSERT INTO `sh_area` VALUES (‘52‘, ‘38‘, ‘深泽‘, ‘深泽县‘, ‘中国,河北省,石家庄市,深泽县‘, ‘3‘, ‘shenze‘, ‘0311‘, ‘052560‘, ‘S‘, ‘115.20358‘, ‘38.18353‘);
INSERT INTO `sh_area` VALUES (‘53‘, ‘38‘, ‘赞皇‘, ‘赞皇县‘, ‘中国,河北省,石家庄市,赞皇县‘, ‘3‘, ‘zanhuang‘, ‘0311‘, ‘051230‘, ‘Z‘, ‘114.38775‘, ‘37.66135‘);
INSERT INTO `sh_area` VALUES (‘54‘, ‘38‘, ‘无极‘, ‘无极县‘, ‘中国,河北省,石家庄市,无极县‘, ‘3‘, ‘wuji‘, ‘0311‘, ‘052460‘, ‘W‘, ‘114.97509‘, ‘38.17653‘);
INSERT INTO `sh_area` VALUES (‘55‘, ‘38‘, ‘平山‘, ‘平山县‘, ‘中国,河北省,石家庄市,平山县‘, ‘3‘, ‘pingshan‘, ‘0311‘, ‘050400‘, ‘P‘, ‘114.186‘, ‘38.25994‘);
INSERT INTO `sh_area` VALUES (‘56‘, ‘38‘, ‘元氏‘, ‘元氏县‘, ‘中国,河北省,石家庄市,元氏县‘, ‘3‘, ‘yuanshi‘, ‘0311‘, ‘051130‘, ‘Y‘, ‘114.52539‘, ‘37.76668‘);
INSERT INTO `sh_area` VALUES (‘57‘, ‘38‘, ‘赵县‘, ‘赵县‘, ‘中国,河北省,石家庄市,赵县‘, ‘3‘, ‘zhaoxian‘, ‘0311‘, ‘051530‘, ‘Z‘, ‘114.77612‘, ‘37.75628‘);
INSERT INTO `sh_area` VALUES (‘58‘, ‘38‘, ‘辛集‘, ‘辛集市‘, ‘中国,河北省,石家庄市,辛集市‘, ‘3‘, ‘xinji‘, ‘0311‘, ‘052360‘, ‘X‘, ‘115.20626‘, ‘37.94079‘);
INSERT INTO `sh_area` VALUES (‘59‘, ‘38‘, ‘晋州‘, ‘晋州市‘, ‘中国,河北省,石家庄市,晋州市‘, ‘3‘, ‘jinzhou‘, ‘0311‘, ‘052260‘, ‘J‘, ‘115.04348‘, ‘38.03135‘);
INSERT INTO `sh_area` VALUES (‘60‘, ‘38‘, ‘新乐‘, ‘新乐市‘, ‘中国,河北省,石家庄市,新乐市‘, ‘3‘, ‘xinle‘, ‘0311‘, ‘050700‘, ‘X‘, ‘114.68985‘, ‘38.34417‘);
INSERT INTO `sh_area` VALUES (‘61‘, ‘37‘, ‘唐山‘, ‘唐山市‘, ‘中国,河北省,唐山市‘, ‘2‘, ‘tangshan‘, ‘0315‘, ‘063000‘, ‘T‘, ‘118.175393‘, ‘39.635113‘);
INSERT INTO `sh_area` VALUES (‘62‘, ‘61‘, ‘路南‘, ‘路南区‘, ‘中国,河北省,唐山市,路南区‘, ‘3‘, ‘lunan‘, ‘0315‘, ‘063000‘, ‘L‘, ‘118.15431‘, ‘39.62505‘);
INSERT INTO `sh_area` VALUES (‘63‘, ‘61‘, ‘路北‘, ‘路北区‘, ‘中国,河北省,唐山市,路北区‘, ‘3‘, ‘lubei‘, ‘0315‘, ‘063000‘, ‘L‘, ‘118.20079‘, ‘39.62436‘);
INSERT INTO `sh_area` VALUES (‘64‘, ‘61‘, ‘古冶‘, ‘古冶区‘, ‘中国,河北省,唐山市,古冶区‘, ‘3‘, ‘guye‘, ‘0315‘, ‘063100‘, ‘G‘, ‘118.45803‘, ‘39.71993‘);
INSERT INTO `sh_area` VALUES (‘65‘, ‘61‘, ‘开平‘, ‘开平区‘, ‘中国,河北省,唐山市,开平区‘, ‘3‘, ‘kaiping‘, ‘0315‘, ‘063021‘, ‘K‘, ‘118.26171‘, ‘39.67128‘);
INSERT INTO `sh_area` VALUES (‘66‘, ‘61‘, ‘丰南‘, ‘丰南区‘, ‘中国,河北省,唐山市,丰南区‘, ‘3‘, ‘fengnan‘, ‘0315‘, ‘063300‘, ‘F‘, ‘118.11282‘, ‘39.56483‘);
INSERT INTO `sh_area` VALUES (‘67‘, ‘61‘, ‘丰润‘, ‘丰润区‘, ‘中国,河北省,唐山市,丰润区‘, ‘3‘, ‘fengrun‘, ‘0315‘, ‘064000‘, ‘F‘, ‘118.12976‘, ‘39.8244‘);
INSERT INTO `sh_area` VALUES (‘68‘, ‘61‘, ‘曹妃甸‘, ‘曹妃甸区‘, ‘中国,河北省,唐山市,曹妃甸区‘, ‘3‘, ‘caofeidian‘, ‘0315‘, ‘063200‘, ‘C‘, ‘118.460379‘, ‘39.273070‘);
INSERT INTO `sh_area` VALUES (‘69‘, ‘61‘, ‘滦县‘, ‘滦县‘, ‘中国,河北省,唐山市,滦县‘, ‘3‘, ‘luanxian‘, ‘0315‘, ‘063700‘, ‘L‘, ‘118.70346‘, ‘39.74056‘);
INSERT INTO `sh_area` VALUES (‘70‘, ‘61‘, ‘滦南‘, ‘滦南县‘, ‘中国,河北省,唐山市,滦南县‘, ‘3‘, ‘luannan‘, ‘0315‘, ‘063500‘, ‘L‘, ‘118.6741‘, ‘39.5039‘);
INSERT INTO `sh_area` VALUES (‘71‘, ‘61‘, ‘乐亭‘, ‘乐亭县‘, ‘中国,河北省,唐山市,乐亭县‘, ‘3‘, ‘laoting‘, ‘0315‘, ‘063600‘, ‘L‘, ‘118.9125‘, ‘39.42561‘);
INSERT INTO `sh_area` VALUES (‘72‘, ‘61‘, ‘迁西‘, ‘迁西县‘, ‘中国,河北省,唐山市,迁西县‘, ‘3‘, ‘qianxi‘, ‘0315‘, ‘064300‘, ‘Q‘, ‘118.31616‘, ‘40.14587‘);
INSERT INTO `sh_area` VALUES (‘73‘, ‘61‘, ‘玉田‘, ‘玉田县‘, ‘中国,河北省,唐山市,玉田县‘, ‘3‘, ‘yutian‘, ‘0315‘, ‘064100‘, ‘Y‘, ‘117.7388‘, ‘39.90049‘);
INSERT INTO `sh_area` VALUES (‘74‘, ‘61‘, ‘遵化‘, ‘遵化市‘, ‘中国,河北省,唐山市,遵化市‘, ‘3‘, ‘zunhua‘, ‘0315‘, ‘064200‘, ‘Z‘, ‘117.96444‘, ‘40.18741‘);
INSERT INTO `sh_area` VALUES (‘75‘, ‘61‘, ‘迁安‘, ‘迁安市‘, ‘中国,河北省,唐山市,迁安市‘, ‘3‘, ‘qian\‘an‘, ‘0315‘, ‘064400‘, ‘Q‘, ‘118.70068‘, ‘39.99833‘);
INSERT INTO `sh_area` VALUES (‘76‘, ‘37‘, ‘秦皇岛‘, ‘秦皇岛市‘, ‘中国,河北省,秦皇岛市‘, ‘2‘, ‘qinhuangdao‘, ‘0335‘, ‘066000‘, ‘Q‘, ‘119.586579‘, ‘39.942531‘);
INSERT INTO `sh_area` VALUES (‘77‘, ‘76‘, ‘海港‘, ‘海港区‘, ‘中国,河北省,秦皇岛市,海港区‘, ‘3‘, ‘haigang‘, ‘0335‘, ‘066000‘, ‘H‘, ‘119.61046‘, ‘39.9345‘);
INSERT INTO `sh_area` VALUES (‘78‘, ‘76‘, ‘山海关‘, ‘山海关区‘, ‘中国,河北省,秦皇岛市,山海关区‘, ‘3‘, ‘shanhaiguan‘, ‘0335‘, ‘066200‘, ‘S‘, ‘119.77563‘, ‘39.97869‘);
INSERT INTO `sh_area` VALUES (‘79‘, ‘76‘, ‘北戴河‘, ‘北戴河区‘, ‘中国,河北省,秦皇岛市,北戴河区‘, ‘3‘, ‘beidaihe‘, ‘0335‘, ‘066100‘, ‘B‘, ‘119.48388‘, ‘39.83408‘);
INSERT INTO `sh_area` VALUES (‘80‘, ‘76‘, ‘青龙‘, ‘青龙满族自治县‘, ‘中国,河北省,秦皇岛市,青龙满族自治县‘, ‘3‘, ‘qinglong‘, ‘0335‘, ‘066500‘, ‘Q‘, ‘118.95242‘, ‘40.40743‘);
INSERT INTO `sh_area` VALUES (‘81‘, ‘76‘, ‘昌黎‘, ‘昌黎县‘, ‘中国,河北省,秦皇岛市,昌黎县‘, ‘3‘, ‘changli‘, ‘0335‘, ‘066600‘, ‘C‘, ‘119.16595‘, ‘39.70884‘);
INSERT INTO `sh_area` VALUES (‘82‘, ‘76‘, ‘抚宁‘, ‘抚宁县‘, ‘中国,河北省,秦皇岛市,抚宁县‘, ‘3‘, ‘funing‘, ‘0335‘, ‘066300‘, ‘F‘, ‘119.24487‘, ‘39.87538‘);
INSERT INTO `sh_area` VALUES (‘83‘, ‘76‘, ‘卢龙‘, ‘卢龙县‘, ‘中国,河北省,秦皇岛市,卢龙县‘, ‘3‘, ‘lulong‘, ‘0335‘, ‘066400‘, ‘L‘, ‘118.89288‘, ‘39.89176‘);
INSERT INTO `sh_area` VALUES (‘84‘, ‘37‘, ‘邯郸‘, ‘邯郸市‘, ‘中国,河北省,邯郸市‘, ‘2‘, ‘handan‘, ‘0310‘, ‘056002‘, ‘H‘, ‘114.490686‘, ‘36.612273‘);
INSERT INTO `sh_area` VALUES (‘85‘, ‘84‘, ‘邯山‘, ‘邯山区‘, ‘中国,河北省,邯郸市,邯山区‘, ‘3‘, ‘hanshan‘, ‘0310‘, ‘056001‘, ‘H‘, ‘114.48375‘, ‘36.60006‘);
INSERT INTO `sh_area` VALUES (‘86‘, ‘84‘, ‘丛台‘, ‘丛台区‘, ‘中国,河北省,邯郸市,丛台区‘, ‘3‘, ‘congtai‘, ‘0310‘, ‘056002‘, ‘C‘, ‘114.49343‘, ‘36.61847‘);
INSERT INTO `sh_area` VALUES (‘87‘, ‘84‘, ‘复兴‘, ‘复兴区‘, ‘中国,河北省,邯郸市,复兴区‘, ‘3‘, ‘fuxing‘, ‘0310‘, ‘056003‘, ‘F‘, ‘114.45928‘, ‘36.61134‘);
INSERT INTO `sh_area` VALUES (‘88‘, ‘84‘, ‘峰峰矿区‘, ‘峰峰矿区‘, ‘中国,河北省,邯郸市,峰峰矿区‘, ‘3‘, ‘fengfengkuangqu‘, ‘0310‘, ‘056200‘, ‘F‘, ‘114.21148‘, ‘36.41937‘);
INSERT INTO `sh_area` VALUES (‘89‘, ‘84‘, ‘邯郸‘, ‘邯郸县‘, ‘中国,河北省,邯郸市,邯郸县‘, ‘3‘, ‘handan‘, ‘0310‘, ‘056101‘, ‘H‘, ‘114.53103‘, ‘36.59385‘);
INSERT INTO `sh_area` VALUES (‘90‘, ‘84‘, ‘临漳‘, ‘临漳县‘, ‘中国,河北省,邯郸市,临漳县‘, ‘3‘, ‘linzhang‘, ‘0310‘, ‘056600‘, ‘L‘, ‘114.6195‘, ‘36.33461‘);
INSERT INTO `sh_area` VALUES (‘91‘, ‘84‘, ‘成安‘, ‘成安县‘, ‘中国,河北省,邯郸市,成安县‘, ‘3‘, ‘cheng\‘an‘, ‘0310‘, ‘056700‘, ‘C‘, ‘114.66995‘, ‘36.44411‘);
INSERT INTO `sh_area` VALUES (‘92‘, ‘84‘, ‘大名‘, ‘大名县‘, ‘中国,河北省,邯郸市,大名县‘, ‘3‘, ‘daming‘, ‘0310‘, ‘056900‘, ‘D‘, ‘115.15362‘, ‘36.27994‘);
INSERT INTO `sh_area` VALUES (‘93‘, ‘84‘, ‘涉县‘, ‘涉县‘, ‘中国,河北省,邯郸市,涉县‘, ‘3‘, ‘shexian‘, ‘0310‘, ‘056400‘, ‘S‘, ‘113.69183‘, ‘36.58072‘);
INSERT INTO `sh_area` VALUES (‘94‘, ‘84‘, ‘磁县‘, ‘磁县‘, ‘中国,河北省,邯郸市,磁县‘, ‘3‘, ‘cixian‘, ‘0310‘, ‘056500‘, ‘C‘, ‘114.37387‘, ‘36.37392‘);
INSERT INTO `sh_area` VALUES (‘95‘, ‘84‘, ‘肥乡‘, ‘肥乡县‘, ‘中国,河北省,邯郸市,肥乡县‘, ‘3‘, ‘feixiang‘, ‘0310‘, ‘057550‘, ‘F‘, ‘114.79998‘, ‘36.54807‘);
INSERT INTO `sh_area` VALUES (‘96‘, ‘84‘, ‘永年‘, ‘永年县‘, ‘中国,河北省,邯郸市,永年县‘, ‘3‘, ‘yongnian‘, ‘0310‘, ‘057150‘, ‘Y‘, ‘114.48925‘, ‘36.78356‘);
INSERT INTO `sh_area` VALUES (‘97‘, ‘84‘, ‘邱县‘, ‘邱县‘, ‘中国,河北省,邯郸市,邱县‘, ‘3‘, ‘qiuxian‘, ‘0310‘, ‘057450‘, ‘Q‘, ‘115.17407‘, ‘36.82082‘);
INSERT INTO `sh_area` VALUES (‘98‘, ‘84‘, ‘鸡泽‘, ‘鸡泽县‘, ‘中国,河北省,邯郸市,鸡泽县‘, ‘3‘, ‘jize‘, ‘0310‘, ‘057350‘, ‘J‘, ‘114.8742‘, ‘36.92374‘);
INSERT INTO `sh_area` VALUES (‘99‘, ‘84‘, ‘广平‘, ‘广平县‘, ‘中国,河北省,邯郸市,广平县‘, ‘3‘, ‘guangping‘, ‘0310‘, ‘057650‘, ‘G‘, ‘114.94653‘, ‘36.48046‘);
INSERT INTO `sh_area` VALUES (‘100‘, ‘84‘, ‘馆陶‘, ‘馆陶县‘, ‘中国,河北省,邯郸市,馆陶县‘, ‘3‘, ‘guantao‘, ‘0310‘, ‘057750‘, ‘G‘, ‘115.29913‘, ‘36.53719‘);
INSERT INTO `sh_area` VALUES (‘101‘, ‘84‘, ‘魏县‘, ‘魏县‘, ‘中国,河北省,邯郸市,魏县‘, ‘3‘, ‘weixian‘, ‘0310‘, ‘056800‘, ‘W‘, ‘114.93518‘, ‘36.36171‘);
INSERT INTO `sh_area` VALUES (‘102‘, ‘84‘, ‘曲周‘, ‘曲周县‘, ‘中国,河北省,邯郸市,曲周县‘, ‘3‘, ‘quzhou‘, ‘0310‘, ‘057250‘, ‘Q‘, ‘114.95196‘, ‘36.77671‘);
INSERT INTO `sh_area` VALUES (‘103‘, ‘84‘, ‘武安‘, ‘武安市‘, ‘中国,河北省,邯郸市,武安市‘, ‘3‘, ‘wu\‘an‘, ‘0310‘, ‘056300‘, ‘W‘, ‘114.20153‘, ‘36.69281‘);
INSERT INTO `sh_area` VALUES (‘104‘, ‘37‘, ‘邢台‘, ‘邢台市‘, ‘中国,河北省,邢台市‘, ‘2‘, ‘xingtai‘, ‘0319‘, ‘054001‘, ‘X‘, ‘114.508851‘, ‘37.0682‘);
INSERT INTO `sh_area` VALUES (‘105‘, ‘104‘, ‘桥东‘, ‘桥东区‘, ‘中国,河北省,邢台市,桥东区‘, ‘3‘, ‘qiaodong‘, ‘0319‘, ‘054001‘, ‘Q‘, ‘114.50725‘, ‘37.06801‘);
INSERT INTO `sh_area` VALUES (‘106‘, ‘104‘, ‘桥西‘, ‘桥西区‘, ‘中国,河北省,邢台市,桥西区‘, ‘3‘, ‘qiaoxi‘, ‘0319‘, ‘054000‘, ‘Q‘, ‘114.46803‘, ‘37.05984‘);
INSERT INTO `sh_area` VALUES (‘107‘, ‘104‘, ‘邢台‘, ‘邢台县‘, ‘中国,河北省,邢台市,邢台县‘, ‘3‘, ‘xingtai‘, ‘0319‘, ‘054001‘, ‘X‘, ‘114.56575‘, ‘37.0456‘);
INSERT INTO `sh_area` VALUES (‘108‘, ‘104‘, ‘临城‘, ‘临城县‘, ‘中国,河北省,邢台市,临城县‘, ‘3‘, ‘lincheng‘, ‘0319‘, ‘054300‘, ‘L‘, ‘114.50387‘, ‘37.43977‘);
INSERT INTO `sh_area` VALUES (‘109‘, ‘104‘, ‘内丘‘, ‘内丘县‘, ‘中国,河北省,邢台市,内丘县‘, ‘3‘, ‘neiqiu‘, ‘0319‘, ‘054200‘, ‘N‘, ‘114.51212‘, ‘37.28671‘);
INSERT INTO `sh_area` VALUES (‘110‘, ‘104‘, ‘柏乡‘, ‘柏乡县‘, ‘中国,河北省,邢台市,柏乡县‘, ‘3‘, ‘baixiang‘, ‘0319‘, ‘055450‘, ‘B‘, ‘114.69332‘, ‘37.48242‘);
INSERT INTO `sh_area` VALUES (‘111‘, ‘104‘, ‘隆尧‘, ‘隆尧县‘, ‘中国,河北省,邢台市,隆尧县‘, ‘3‘, ‘longyao‘, ‘0319‘, ‘055350‘, ‘L‘, ‘114.77615‘, ‘37.35351‘);
INSERT INTO `sh_area` VALUES (‘112‘, ‘104‘, ‘任县‘, ‘任县‘, ‘中国,河北省,邢台市,任县‘, ‘3‘, ‘renxian‘, ‘0319‘, ‘055150‘, ‘R‘, ‘114.6842‘, ‘37.12575‘);
INSERT INTO `sh_area` VALUES (‘113‘, ‘104‘, ‘南和‘, ‘南和县‘, ‘中国,河北省,邢台市,南和县‘, ‘3‘, ‘nanhe‘, ‘0319‘, ‘054400‘, ‘N‘, ‘114.68371‘, ‘37.00488‘);
INSERT INTO `sh_area` VALUES (‘114‘, ‘104‘, ‘宁晋‘, ‘宁晋县‘, ‘中国,河北省,邢台市,宁晋县‘, ‘3‘, ‘ningjin‘, ‘0319‘, ‘055550‘, ‘N‘, ‘114.92117‘, ‘37.61696‘);
INSERT INTO `sh_area` VALUES (‘115‘, ‘104‘, ‘巨鹿‘, ‘巨鹿县‘, ‘中国,河北省,邢台市,巨鹿县‘, ‘3‘, ‘julu‘, ‘0319‘, ‘055250‘, ‘J‘, ‘115.03524‘, ‘37.21801‘);
INSERT INTO `sh_area` VALUES (‘116‘, ‘104‘, ‘新河‘, ‘新河县‘, ‘中国,河北省,邢台市,新河县‘, ‘3‘, ‘xinhe‘, ‘0319‘, ‘055650‘, ‘X‘, ‘115.24987‘, ‘37.52718‘);
INSERT INTO `sh_area` VALUES (‘117‘, ‘104‘, ‘广宗‘, ‘广宗县‘, ‘中国,河北省,邢台市,广宗县‘, ‘3‘, ‘guangzong‘, ‘0319‘, ‘054600‘, ‘G‘, ‘115.14254‘, ‘37.0746‘);
INSERT INTO `sh_area` VALUES (‘118‘, ‘104‘, ‘平乡‘, ‘平乡县‘, ‘中国,河北省,邢台市,平乡县‘, ‘3‘, ‘pingxiang‘, ‘0319‘, ‘054500‘, ‘P‘, ‘115.03002‘, ‘37.06317‘);
INSERT INTO `sh_area` VALUES (‘119‘, ‘104‘, ‘威县‘, ‘威县‘, ‘中国,河北省,邢台市,威县‘, ‘3‘, ‘weixian‘, ‘0319‘, ‘054700‘, ‘W‘, ‘115.2637‘, ‘36.9768‘);
INSERT INTO `sh_area` VALUES (‘120‘, ‘104‘, ‘清河‘, ‘清河县‘, ‘中国,河北省,邢台市,清河县‘, ‘3‘, ‘qinghe‘, ‘0319‘, ‘054800‘, ‘Q‘, ‘115.66479‘, ‘37.07122‘);
INSERT INTO `sh_area` VALUES (‘121‘, ‘104‘, ‘临西‘, ‘临西县‘, ‘中国,河北省,邢台市,临西县‘, ‘3‘, ‘linxi‘, ‘0319‘, ‘054900‘, ‘L‘, ‘115.50097‘, ‘36.87078‘);
INSERT INTO `sh_area` VALUES (‘122‘, ‘104‘, ‘南宫‘, ‘南宫市‘, ‘中国,河北省,邢台市,南宫市‘, ‘3‘, ‘nangong‘, ‘0319‘, ‘055750‘, ‘N‘, ‘115.39068‘, ‘37.35799‘);
INSERT INTO `sh_area` VALUES (‘123‘, ‘104‘, ‘沙河‘, ‘沙河市‘, ‘中国,河北省,邢台市,沙河市‘, ‘3‘, ‘shahe‘, ‘0319‘, ‘054100‘, ‘S‘, ‘114.4981‘, ‘36.8577‘);
INSERT INTO `sh_area` VALUES (‘124‘, ‘37‘, ‘保定‘, ‘保定市‘, ‘中国,河北省,保定市‘, ‘2‘, ‘baoding‘, ‘0312‘, ‘071052‘, ‘B‘, ‘115.482331‘, ‘38.867657‘);
INSERT INTO `sh_area` VALUES (‘125‘, ‘124‘, ‘新市‘, ‘新市区‘, ‘中国,河北省,保定市,新市区‘, ‘3‘, ‘xinshi‘, ‘0312‘, ‘071051‘, ‘X‘, ‘115.4587‘, ‘38.87751‘);
INSERT INTO `sh_area` VALUES (‘126‘, ‘124‘, ‘北市‘, ‘北市区‘, ‘中国,河北省,保定市,北市区‘, ‘3‘, ‘beishi‘, ‘0312‘, ‘071000‘, ‘B‘, ‘115.49715‘, ‘38.88322‘);
INSERT INTO `sh_area` VALUES (‘127‘, ‘124‘, ‘南市‘, ‘南市区‘, ‘中国,河北省,保定市,南市区‘, ‘3‘, ‘nanshi‘, ‘0312‘, ‘071001‘, ‘N‘, ‘115.52859‘, ‘38.85455‘);
INSERT INTO `sh_area` VALUES (‘128‘, ‘124‘, ‘满城‘, ‘满城县‘, ‘中国,河北省,保定市,满城县‘, ‘3‘, ‘mancheng‘, ‘0312‘, ‘072150‘, ‘M‘, ‘115.32296‘, ‘38.94972‘);
INSERT INTO `sh_area` VALUES (‘129‘, ‘124‘, ‘清苑‘, ‘清苑县‘, ‘中国,河北省,保定市,清苑县‘, ‘3‘, ‘qingyuan‘, ‘0312‘, ‘071100‘, ‘Q‘, ‘115.49267‘, ‘38.76709‘);
INSERT INTO `sh_area` VALUES (‘130‘, ‘124‘, ‘涞水‘, ‘涞水县‘, ‘中国,河北省,保定市,涞水县‘, ‘3‘, ‘laishui‘, ‘0312‘, ‘074100‘, null, ‘115.71517‘, ‘39.39404‘);
INSERT INTO `sh_area` VALUES (‘131‘, ‘124‘, ‘阜平‘, ‘阜平县‘, ‘中国,河北省,保定市,阜平县‘, ‘3‘, ‘fuping‘, ‘0312‘, ‘073200‘, ‘F‘, ‘114.19683‘, ‘38.84763‘);
INSERT INTO `sh_area` VALUES (‘132‘, ‘124‘, ‘徐水‘, ‘徐水县‘, ‘中国,河北省,保定市,徐水县‘, ‘3‘, ‘xushui‘, ‘0312‘, ‘072550‘, ‘X‘, ‘115.65829‘, ‘39.02099‘);
INSERT INTO `sh_area` VALUES (‘133‘, ‘124‘, ‘定兴‘, ‘定兴县‘, ‘中国,河北省,保定市,定兴县‘, ‘3‘, ‘dingxing‘, ‘0312‘, ‘072650‘, ‘D‘, ‘115.80786‘, ‘39.26312‘);
INSERT INTO `sh_area` VALUES (‘134‘, ‘124‘, ‘唐县‘, ‘唐县‘, ‘中国,河北省,保定市,唐县‘, ‘3‘, ‘tangxian‘, ‘0312‘, ‘072350‘, ‘T‘, ‘114.98516‘, ‘38.74513‘);
INSERT INTO `sh_area` VALUES (‘135‘, ‘124‘, ‘高阳‘, ‘高阳县‘, ‘中国,河北省,保定市,高阳县‘, ‘3‘, ‘gaoyang‘, ‘0312‘, ‘071500‘, ‘G‘, ‘115.7788‘, ‘38.70003‘);
INSERT INTO `sh_area` VALUES (‘136‘, ‘124‘, ‘容城‘, ‘容城县‘, ‘中国,河北省,保定市,容城县‘, ‘3‘, ‘rongcheng‘, ‘0312‘, ‘071700‘, ‘R‘, ‘115.87158‘, ‘39.0535‘);
INSERT INTO `sh_area` VALUES (‘137‘, ‘124‘, ‘涞源‘, ‘涞源县‘, ‘中国,河北省,保定市,涞源县‘, ‘3‘, ‘laiyuan‘, ‘0312‘, ‘074300‘, null, ‘114.69128‘, ‘39.35388‘);
INSERT INTO `sh_area` VALUES (‘138‘, ‘124‘, ‘望都‘, ‘望都县‘, ‘中国,河北省,保定市,望都县‘, ‘3‘, ‘wangdu‘, ‘0312‘, ‘072450‘, ‘W‘, ‘115.1567‘, ‘38.70996‘);
INSERT INTO `sh_area` VALUES (‘139‘, ‘124‘, ‘安新‘, ‘安新县‘, ‘中国,河北省,保定市,安新县‘, ‘3‘, ‘anxin‘, ‘0312‘, ‘071600‘, ‘A‘, ‘115.93557‘, ‘38.93532‘);
INSERT INTO `sh_area` VALUES (‘140‘, ‘124‘, ‘易县‘, ‘易县‘, ‘中国,河北省,保定市,易县‘, ‘3‘, ‘yixian‘, ‘0312‘, ‘074200‘, ‘Y‘, ‘115.4981‘, ‘39.34885‘);
INSERT INTO `sh_area` VALUES (‘141‘, ‘124‘, ‘曲阳‘, ‘曲阳县‘, ‘中国,河北省,保定市,曲阳县‘, ‘3‘, ‘quyang‘, ‘0312‘, ‘073100‘, ‘Q‘, ‘114.70123‘, ‘38.62154‘);
INSERT INTO `sh_area` VALUES (‘142‘, ‘124‘, ‘蠡县‘, ‘蠡县‘, ‘中国,河北省,保定市,蠡县‘, ‘3‘, ‘lixian‘, ‘0312‘, ‘071400‘, null, ‘115.57717‘, ‘38.48974‘);
INSERT INTO `sh_area` VALUES (‘143‘, ‘124‘, ‘顺平‘, ‘顺平县‘, ‘中国,河北省,保定市,顺平县‘, ‘3‘, ‘shunping‘, ‘0312‘, ‘072250‘, ‘S‘, ‘115.1347‘, ‘38.83854‘);
INSERT INTO `sh_area` VALUES (‘144‘, ‘124‘, ‘博野‘, ‘博野县‘, ‘中国,河北省,保定市,博野县‘, ‘3‘, ‘boye‘, ‘0312‘, ‘071300‘, ‘B‘, ‘115.47033‘, ‘38.4564‘);
INSERT INTO `sh_area` VALUES (‘145‘, ‘124‘, ‘雄县‘, ‘雄县‘, ‘中国,河北省,保定市,雄县‘, ‘3‘, ‘xiongxian‘, ‘0312‘, ‘071800‘, ‘X‘, ‘116.10873‘, ‘38.99442‘);
INSERT INTO `sh_area` VALUES (‘146‘, ‘124‘, ‘涿州‘, ‘涿州市‘, ‘中国,河北省,保定市,涿州市‘, ‘3‘, ‘zhuozhou‘, ‘0312‘, ‘072750‘, null, ‘115.98062‘, ‘39.48622‘);
INSERT INTO `sh_area` VALUES (‘147‘, ‘124‘, ‘定州‘, ‘定州市‘, ‘中国,河北省,保定市,定州市‘, ‘3‘, ‘dingzhou‘, ‘0312‘, ‘073000‘, ‘D‘, ‘114.9902‘, ‘38.51623‘);
INSERT INTO `sh_area` VALUES (‘148‘, ‘124‘, ‘安国‘, ‘安国市‘, ‘中国,河北省,保定市,安国市‘, ‘3‘, ‘anguo‘, ‘0312‘, ‘071200‘, ‘A‘, ‘115.32321‘, ‘38.41391‘);
INSERT INTO `sh_area` VALUES (‘149‘, ‘124‘, ‘高碑店‘, ‘高碑店市‘, ‘中国,河北省,保定市,高碑店市‘, ‘3‘, ‘gaobeidian‘, ‘0312‘, ‘074000‘, ‘G‘, ‘115.87368‘, ‘39.32655‘);
INSERT INTO `sh_area` VALUES (‘150‘, ‘37‘, ‘张家口‘, ‘张家口市‘, ‘中国,河北省,张家口市‘, ‘2‘, ‘zhangjiakou‘, ‘0313‘, ‘075000‘, ‘Z‘, ‘114.884091‘, ‘40.811901‘);
INSERT INTO `sh_area` VALUES (‘151‘, ‘150‘, ‘桥东‘, ‘桥东区‘, ‘中国,河北省,张家口市,桥东区‘, ‘3‘, ‘qiaodong‘, ‘0313‘, ‘075000‘, ‘Q‘, ‘114.8943‘, ‘40.78844‘);
INSERT INTO `sh_area` VALUES (‘152‘, ‘150‘, ‘桥西‘, ‘桥西区‘, ‘中国,河北省,张家口市,桥西区‘, ‘3‘, ‘qiaoxi‘, ‘0313‘, ‘075061‘, ‘Q‘, ‘114.86962‘, ‘40.81945‘);
INSERT INTO `sh_area` VALUES (‘153‘, ‘150‘, ‘宣化‘, ‘宣化区‘, ‘中国,河北省,张家口市,宣化区‘, ‘3‘, ‘xuanhua‘, ‘0313‘, ‘075100‘, ‘X‘, ‘115.06543‘, ‘40.60957‘);
INSERT INTO `sh_area` VALUES (‘154‘, ‘150‘, ‘下花园‘, ‘下花园区‘, ‘中国,河北省,张家口市,下花园区‘, ‘3‘, ‘xiahuayuan‘, ‘0313‘, ‘075300‘, ‘X‘, ‘115.28744‘, ‘40.50236‘);
INSERT INTO `sh_area` VALUES (‘155‘, ‘150‘, ‘宣化‘, ‘宣化县‘, ‘中国,河北省,张家口市,宣化县‘, ‘3‘, ‘xuanhua‘, ‘0313‘, ‘075100‘, ‘X‘, ‘115.15497‘, ‘40.56618‘);
INSERT INTO `sh_area` VALUES (‘156‘, ‘150‘, ‘张北‘, ‘张北县‘, ‘中国,河北省,张家口市,张北县‘, ‘3‘, ‘zhangbei‘, ‘0313‘, ‘076450‘, ‘Z‘, ‘114.71432‘, ‘41.15977‘);
INSERT INTO `sh_area` VALUES (‘157‘, ‘150‘, ‘康保‘, ‘康保县‘, ‘中国,河北省,张家口市,康保县‘, ‘3‘, ‘kangbao‘, ‘0313‘, ‘076650‘, ‘K‘, ‘114.60031‘, ‘41.85225‘);
INSERT INTO `sh_area` VALUES (‘158‘, ‘150‘, ‘沽源‘, ‘沽源县‘, ‘中国,河北省,张家口市,沽源县‘, ‘3‘, ‘guyuan‘, ‘0313‘, ‘076550‘, ‘G‘, ‘115.68859‘, ‘41.66959‘);
INSERT INTO `sh_area` VALUES (‘159‘, ‘150‘, ‘尚义‘, ‘尚义县‘, ‘中国,河北省,张家口市,尚义县‘, ‘3‘, ‘shangyi‘, ‘0313‘, ‘076750‘, ‘S‘, ‘113.97134‘, ‘41.07782‘);
INSERT INTO `sh_area` VALUES (‘160‘, ‘150‘, ‘蔚县‘, ‘蔚县‘, ‘中国,河北省,张家口市,蔚县‘, ‘3‘, ‘yuxian‘, ‘0313‘, ‘075700‘, ‘W‘, ‘114.58892‘, ‘39.84067‘);
INSERT INTO `sh_area` VALUES (‘161‘, ‘150‘, ‘阳原‘, ‘阳原县‘, ‘中国,河北省,张家口市,阳原县‘, ‘3‘, ‘yangyuan‘, ‘0313‘, ‘075800‘, ‘Y‘, ‘114.15051‘, ‘40.10361‘);
INSERT INTO `sh_area` VALUES (‘162‘, ‘150‘, ‘怀安‘, ‘怀安县‘, ‘中国,河北省,张家口市,怀安县‘, ‘3‘, ‘huai\‘an‘, ‘0313‘, ‘076150‘, ‘H‘, ‘114.38559‘, ‘40.67425‘);
INSERT INTO `sh_area` VALUES (‘163‘, ‘150‘, ‘万全‘, ‘万全县‘, ‘中国,河北省,张家口市,万全县‘, ‘3‘, ‘wanquan‘, ‘0313‘, ‘076250‘, ‘W‘, ‘114.7405‘, ‘40.76694‘);
INSERT INTO `sh_area` VALUES (‘164‘, ‘150‘, ‘怀来‘, ‘怀来县‘, ‘中国,河北省,张家口市,怀来县‘, ‘3‘, ‘huailai‘, ‘0313‘, ‘075400‘, ‘H‘, ‘115.51773‘, ‘40.41536‘);
INSERT INTO `sh_area` VALUES (‘165‘, ‘150‘, ‘涿鹿‘, ‘涿鹿县‘, ‘中国,河北省,张家口市,涿鹿县‘, ‘3‘, ‘zhuolu‘, ‘0313‘, ‘075600‘, null, ‘115.22403‘, ‘40.37636‘);
INSERT INTO `sh_area` VALUES (‘166‘, ‘150‘, ‘赤城‘, ‘赤城县‘, ‘中国,河北省,张家口市,赤城县‘, ‘3‘, ‘chicheng‘, ‘0313‘, ‘075500‘, ‘C‘, ‘115.83187‘, ‘40.91438‘);
INSERT INTO `sh_area` VALUES (‘167‘, ‘150‘, ‘崇礼‘, ‘崇礼县‘, ‘中国,河北省,张家口市,崇礼县‘, ‘3‘, ‘chongli‘, ‘0313‘, ‘076350‘, ‘C‘, ‘115.27993‘, ‘40.97519‘);
INSERT INTO `sh_area` VALUES (‘168‘, ‘37‘, ‘承德‘, ‘承德市‘, ‘中国,河北省,承德市‘, ‘2‘, ‘chengde‘, ‘0314‘, ‘067000‘, ‘C‘, ‘117.939152‘, ‘40.976204‘);
INSERT INTO `sh_area` VALUES (‘169‘, ‘168‘, ‘双桥‘, ‘双桥区‘, ‘中国,河北省,承德市,双桥区‘, ‘3‘, ‘shuangqiao‘, ‘0314‘, ‘067000‘, ‘S‘, ‘117.9432‘, ‘40.97466‘);
INSERT INTO `sh_area` VALUES (‘170‘, ‘168‘, ‘双滦‘, ‘双滦区‘, ‘中国,河北省,承德市,双滦区‘, ‘3‘, ‘shuangluan‘, ‘0314‘, ‘067001‘, ‘S‘, ‘117.74487‘, ‘40.95375‘);
INSERT INTO `sh_area` VALUES (‘171‘, ‘168‘, ‘鹰手营子矿区‘, ‘鹰手营子矿区‘, ‘中国,河北省,承德市,鹰手营子矿区‘, ‘3‘, ‘yingshouyingzikuangqu‘, ‘0314‘, ‘067200‘, ‘Y‘, ‘117.65985‘, ‘40.54744‘);
INSERT INTO `sh_area` VALUES (‘172‘, ‘168‘, ‘承德‘, ‘承德县‘, ‘中国,河北省,承德市,承德县‘, ‘3‘, ‘chengde‘, ‘0314‘, ‘067400‘, ‘C‘, ‘118.17639‘, ‘40.76985‘);
INSERT INTO `sh_area` VALUES (‘173‘, ‘168‘, ‘兴隆‘, ‘兴隆县‘, ‘中国,河北省,承德市,兴隆县‘, ‘3‘, ‘xinglong‘, ‘0314‘, ‘067300‘, ‘X‘, ‘117.50073‘, ‘40.41709‘);
INSERT INTO `sh_area` VALUES (‘174‘, ‘168‘, ‘平泉‘, ‘平泉县‘, ‘中国,河北省,承德市,平泉县‘, ‘3‘, ‘pingquan‘, ‘0314‘, ‘067500‘, ‘P‘, ‘118.70196‘, ‘41.01839‘);
INSERT INTO `sh_area` VALUES (‘175‘, ‘168‘, ‘滦平‘, ‘滦平县‘, ‘中国,河北省,承德市,滦平县‘, ‘3‘, ‘luanping‘, ‘0314‘, ‘068250‘, ‘L‘, ‘117.33276‘, ‘40.94148‘);
INSERT INTO `sh_area` VALUES (‘176‘, ‘168‘, ‘隆化‘, ‘隆化县‘, ‘中国,河北省,承德市,隆化县‘, ‘3‘, ‘longhua‘, ‘0314‘, ‘068150‘, ‘L‘, ‘117.7297‘, ‘41.31412‘);
INSERT INTO `sh_area` VALUES (‘177‘, ‘168‘, ‘丰宁‘, ‘丰宁满族自治县‘, ‘中国,河北省,承德市,丰宁满族自治县‘, ‘3‘, ‘fengning‘, ‘0314‘, ‘068350‘, ‘F‘, ‘116.6492‘, ‘41.20481‘);
INSERT INTO `sh_area` VALUES (‘178‘, ‘168‘, ‘宽城‘, ‘宽城满族自治县‘, ‘中国,河北省,承德市,宽城满族自治县‘, ‘3‘, ‘kuancheng‘, ‘0314‘, ‘067600‘, ‘K‘, ‘118.49176‘, ‘40.60829‘);
INSERT INTO `sh_area` VALUES (‘179‘, ‘168‘, ‘围场‘, ‘围场满族蒙古族自治县‘, ‘中国,河北省,承德市,围场满族蒙古族自治县‘, ‘3‘, ‘weichang‘, ‘0314‘, ‘068450‘, ‘W‘, ‘117.7601‘, ‘41.94368‘);
INSERT INTO `sh_area` VALUES (‘180‘, ‘37‘, ‘沧州‘, ‘沧州市‘, ‘中国,河北省,沧州市‘, ‘2‘, ‘cangzhou‘, ‘0317‘, ‘061001‘, ‘C‘, ‘116.857461‘, ‘38.310582‘);
INSERT INTO `sh_area` VALUES (‘181‘, ‘180‘, ‘新华‘, ‘新华区‘, ‘中国,河北省,沧州市,新华区‘, ‘3‘, ‘xinhua‘, ‘0317‘, ‘061000‘, ‘X‘, ‘116.86643‘, ‘38.31438‘);
INSERT INTO `sh_area` VALUES (‘182‘, ‘180‘, ‘运河‘, ‘运河区‘, ‘中国,河北省,沧州市,运河区‘, ‘3‘, ‘yunhe‘, ‘0317‘, ‘061001‘, ‘Y‘, ‘116.85706‘, ‘38.31352‘);
INSERT INTO `sh_area` VALUES (‘183‘, ‘180‘, ‘沧县‘, ‘沧县‘, ‘中国,河北省,沧州市,沧县‘, ‘3‘, ‘cangxian‘, ‘0317‘, ‘061000‘, ‘C‘, ‘116.87817‘, ‘38.29361‘);
INSERT INTO `sh_area` VALUES (‘184‘, ‘180‘, ‘青县‘, ‘青县‘, ‘中国,河北省,沧州市,青县‘, ‘3‘, ‘qingxian‘, ‘0317‘, ‘062650‘, ‘Q‘, ‘116.80316‘, ‘38.58345‘);
INSERT INTO `sh_area` VALUES (‘185‘, ‘180‘, ‘东光‘, ‘东光县‘, ‘中国,河北省,沧州市,东光县‘, ‘3‘, ‘dongguang‘, ‘0317‘, ‘061600‘, ‘D‘, ‘116.53668‘, ‘37.8857‘);
INSERT INTO `sh_area` VALUES (‘186‘, ‘180‘, ‘海兴‘, ‘海兴县‘, ‘中国,河北省,沧州市,海兴县‘, ‘3‘, ‘haixing‘, ‘0317‘, ‘061200‘, ‘H‘, ‘117.49758‘, ‘38.13958‘);
INSERT INTO `sh_area` VALUES (‘187‘, ‘180‘, ‘盐山‘, ‘盐山县‘, ‘中国,河北省,沧州市,盐山县‘, ‘3‘, ‘yanshan‘, ‘0317‘, ‘061300‘, ‘Y‘, ‘117.23092‘, ‘38.05647‘);
INSERT INTO `sh_area` VALUES (‘188‘, ‘180‘, ‘肃宁‘, ‘肃宁县‘, ‘中国,河北省,沧州市,肃宁县‘, ‘3‘, ‘suning‘, ‘0317‘, ‘062350‘, ‘S‘, ‘115.82971‘, ‘38.42272‘);
INSERT INTO `sh_area` VALUES (‘189‘, ‘180‘, ‘南皮‘, ‘南皮县‘, ‘中国,河北省,沧州市,南皮县‘, ‘3‘, ‘nanpi‘, ‘0317‘, ‘061500‘, ‘N‘, ‘116.70224‘, ‘38.04109‘);
INSERT INTO `sh_area` VALUES (‘190‘, ‘180‘, ‘吴桥‘, ‘吴桥县‘, ‘中国,河北省,沧州市,吴桥县‘, ‘3‘, ‘wuqiao‘, ‘0317‘, ‘061800‘, ‘W‘, ‘116.3847‘, ‘37.62546‘);
INSERT INTO `sh_area` VALUES (‘191‘, ‘180‘, ‘献县‘, ‘献县‘, ‘中国,河北省,沧州市,献县‘, ‘3‘, ‘xianxian‘, ‘0317‘, ‘062250‘, ‘X‘, ‘116.12695‘, ‘38.19228‘);
INSERT INTO `sh_area` VALUES (‘192‘, ‘180‘, ‘孟村‘, ‘孟村回族自治县‘, ‘中国,河北省,沧州市,孟村回族自治县‘, ‘3‘, ‘mengcun‘, ‘0317‘, ‘061400‘, ‘M‘, ‘117.10412‘, ‘38.05338‘);
INSERT INTO `sh_area` VALUES (‘193‘, ‘180‘, ‘泊头‘, ‘泊头市‘, ‘中国,河北省,沧州市,泊头市‘, ‘3‘, ‘botou‘, ‘0317‘, ‘062150‘, ‘B‘, ‘116.57824‘, ‘38.08359‘);
INSERT INTO `sh_area` VALUES (‘194‘, ‘180‘, ‘任丘‘, ‘任丘市‘, ‘中国,河北省,沧州市,任丘市‘, ‘3‘, ‘renqiu‘, ‘0317‘, ‘062550‘, ‘R‘, ‘116.1033‘, ‘38.71124‘);
INSERT INTO `sh_area` VALUES (‘195‘, ‘180‘, ‘黄骅‘, ‘黄骅市‘, ‘中国,河北省,沧州市,黄骅市‘, ‘3‘, ‘huanghua‘, ‘0317‘, ‘061100‘, ‘H‘, ‘117.33883‘, ‘38.3706‘);
INSERT INTO `sh_area` VALUES (‘196‘, ‘180‘, ‘河间‘, ‘河间市‘, ‘中国,河北省,沧州市,河间市‘, ‘3‘, ‘hejian‘, ‘0317‘, ‘062450‘, ‘H‘, ‘116.0993‘, ‘38.44549‘);
INSERT INTO `sh_area` VALUES (‘197‘, ‘37‘, ‘廊坊‘, ‘廊坊市‘, ‘中国,河北省,廊坊市‘, ‘2‘, ‘langfang‘, ‘0316‘, ‘065000‘, ‘L‘, ‘116.713873‘, ‘39.529244‘);
INSERT INTO `sh_area` VALUES (‘198‘, ‘197‘, ‘安次‘, ‘安次区‘, ‘中国,河北省,廊坊市,安次区‘, ‘3‘, ‘anci‘, ‘0316‘, ‘065000‘, ‘A‘, ‘116.70308‘, ‘39.52057‘);
INSERT INTO `sh_area` VALUES (‘199‘, ‘197‘, ‘广阳‘, ‘广阳区‘, ‘中国,河北省,廊坊市,广阳区‘, ‘3‘, ‘guangyang‘, ‘0316‘, ‘065000‘, ‘G‘, ‘116.71069‘, ‘39.52278‘);
INSERT INTO `sh_area` VALUES (‘200‘, ‘197‘, ‘固安‘, ‘固安县‘, ‘中国,河北省,廊坊市,固安县‘, ‘3‘, ‘gu\‘an‘, ‘0316‘, ‘065500‘, ‘G‘, ‘116.29916‘, ‘39.43833‘);
INSERT INTO `sh_area` VALUES (‘201‘, ‘197‘, ‘永清‘, ‘永清县‘, ‘中国,河北省,廊坊市,永清县‘, ‘3‘, ‘yongqing‘, ‘0316‘, ‘065600‘, ‘Y‘, ‘116.50091‘, ‘39.32069‘);
INSERT INTO `sh_area` VALUES (‘202‘, ‘197‘, ‘香河‘, ‘香河县‘, ‘中国,河北省,廊坊市,香河县‘, ‘3‘, ‘xianghe‘, ‘0316‘, ‘065400‘, ‘X‘, ‘117.00634‘, ‘39.76133‘);
INSERT INTO `sh_area` VALUES (‘203‘, ‘197‘, ‘大城‘, ‘大城县‘, ‘中国,河北省,廊坊市,大城县‘, ‘3‘, ‘daicheng‘, ‘0316‘, ‘065900‘, ‘D‘, ‘116.65353‘, ‘38.70534‘);
INSERT INTO `sh_area` VALUES (‘204‘, ‘197‘, ‘文安‘, ‘文安县‘, ‘中国,河北省,廊坊市,文安县‘, ‘3‘, ‘wen\‘an‘, ‘0316‘, ‘065800‘, ‘W‘, ‘116.45846‘, ‘38.87325‘);
INSERT INTO `sh_area` VALUES (‘205‘, ‘197‘, ‘大厂‘, ‘大厂回族自治县‘, ‘中国,河北省,廊坊市,大厂回族自治县‘, ‘3‘, ‘dachang‘, ‘0316‘, ‘065300‘, ‘D‘, ‘116.98916‘, ‘39.88649‘);
INSERT INTO `sh_area` VALUES (‘206‘, ‘197‘, ‘霸州‘, ‘霸州市‘, ‘中国,河北省,廊坊市,霸州市‘, ‘3‘, ‘bazhou‘, ‘0316‘, ‘065700‘, ‘B‘, ‘116.39154‘, ‘39.12569‘);
INSERT INTO `sh_area` VALUES (‘207‘, ‘197‘, ‘三河‘, ‘三河市‘, ‘中国,河北省,廊坊市,三河市‘, ‘3‘, ‘sanhe‘, ‘0316‘, ‘065200‘, ‘S‘, ‘117.07229‘, ‘39.98358‘);
INSERT INTO `sh_area` VALUES (‘208‘, ‘37‘, ‘衡水‘, ‘衡水市‘, ‘中国,河北省,衡水市‘, ‘2‘, ‘hengshui‘, ‘0318‘, ‘053000‘, ‘H‘, ‘115.665993‘, ‘37.735097‘);
INSERT INTO `sh_area` VALUES (‘209‘, ‘208‘, ‘桃城‘, ‘桃城区‘, ‘中国,河北省,衡水市,桃城区‘, ‘3‘, ‘taocheng‘, ‘0318‘, ‘053000‘, ‘T‘, ‘115.67529‘, ‘37.73499‘);
INSERT INTO `sh_area` VALUES (‘210‘, ‘208‘, ‘枣强‘, ‘枣强县‘, ‘中国,河北省,衡水市,枣强县‘, ‘3‘, ‘zaoqiang‘, ‘0318‘, ‘053100‘, ‘Z‘, ‘115.72576‘, ‘37.51027‘);
INSERT INTO `sh_area` VALUES (‘211‘, ‘208‘, ‘武邑‘, ‘武邑县‘, ‘中国,河北省,衡水市,武邑县‘, ‘3‘, ‘wuyi‘, ‘0318‘, ‘053400‘, ‘W‘, ‘115.88748‘, ‘37.80181‘);
INSERT INTO `sh_area` VALUES (‘212‘, ‘208‘, ‘武强‘, ‘武强县‘, ‘中国,河北省,衡水市,武强县‘, ‘3‘, ‘wuqiang‘, ‘0318‘, ‘053300‘, ‘W‘, ‘115.98226‘, ‘38.04138‘);
INSERT INTO `sh_area` VALUES (‘213‘, ‘208‘, ‘饶阳‘, ‘饶阳县‘, ‘中国,河北省,衡水市,饶阳县‘, ‘3‘, ‘raoyang‘, ‘0318‘, ‘053900‘, ‘R‘, ‘115.72558‘, ‘38.23529‘);
INSERT INTO `sh_area` VALUES (‘214‘, ‘208‘, ‘安平‘, ‘安平县‘, ‘中国,河北省,衡水市,安平县‘, ‘3‘, ‘anping‘, ‘0318‘, ‘053600‘, ‘A‘, ‘115.51876‘, ‘38.23388‘);
INSERT INTO `sh_area` VALUES (‘215‘, ‘208‘, ‘故城‘, ‘故城县‘, ‘中国,河北省,衡水市,故城县‘, ‘3‘, ‘gucheng‘, ‘0318‘, ‘053800‘, ‘G‘, ‘115.97076‘, ‘37.34773‘);
INSERT INTO `sh_area` VALUES (‘216‘, ‘208‘, ‘景县‘, ‘景县‘, ‘中国,河北省,衡水市,景县‘, ‘3‘, ‘jingxian‘, ‘0318‘, ‘053500‘, ‘J‘, ‘116.26904‘, ‘37.6926‘);
INSERT INTO `sh_area` VALUES (‘217‘, ‘208‘, ‘阜城‘, ‘阜城县‘, ‘中国,河北省,衡水市,阜城县‘, ‘3‘, ‘fucheng‘, ‘0318‘, ‘053700‘, ‘F‘, ‘116.14431‘, ‘37.86881‘);
INSERT INTO `sh_area` VALUES (‘218‘, ‘208‘, ‘冀州‘, ‘冀州市‘, ‘中国,河北省,衡水市,冀州市‘, ‘3‘, ‘jizhou‘, ‘0318‘, ‘053200‘, ‘J‘, ‘115.57934‘, ‘37.55082‘);
INSERT INTO `sh_area` VALUES (‘219‘, ‘208‘, ‘深州‘, ‘深州市‘, ‘中国,河北省,衡水市,深州市‘, ‘3‘, ‘shenzhou‘, ‘0318‘, ‘053800‘, ‘S‘, ‘115.55993‘, ‘38.00109‘);
INSERT INTO `sh_area` VALUES (‘220‘, ‘0‘, ‘山西‘, ‘山西省‘, ‘中国,山西省‘, ‘1‘, ‘shanxi‘, ‘‘, ‘‘, ‘S‘, ‘112.549248‘, ‘37.857014‘);
INSERT INTO `sh_area` VALUES (‘221‘, ‘220‘, ‘太原‘, ‘太原市‘, ‘中国,山西省,太原市‘, ‘2‘, ‘taiyuan‘, ‘0351‘, ‘030082‘, ‘T‘, ‘112.549248‘, ‘37.857014‘);
INSERT INTO `sh_area` VALUES (‘222‘, ‘221‘, ‘小店‘, ‘小店区‘, ‘中国,山西省,太原市,小店区‘, ‘3‘, ‘xiaodian‘, ‘0351‘, ‘030032‘, ‘X‘, ‘112.56878‘, ‘37.73565‘);
INSERT INTO `sh_area` VALUES (‘223‘, ‘221‘, ‘迎泽‘, ‘迎泽区‘, ‘中国,山西省,太原市,迎泽区‘, ‘3‘, ‘yingze‘, ‘0351‘, ‘030002‘, ‘Y‘, ‘112.56338‘, ‘37.86326‘);
INSERT INTO `sh_area` VALUES (‘224‘, ‘221‘, ‘杏花岭‘, ‘杏花岭区‘, ‘中国,山西省,太原市,杏花岭区‘, ‘3‘, ‘xinghualing‘, ‘0351‘, ‘030009‘, ‘X‘, ‘112.56237‘, ‘37.88429‘);
INSERT INTO `sh_area` VALUES (‘225‘, ‘221‘, ‘尖草坪‘, ‘尖草坪区‘, ‘中国,山西省,太原市,尖草坪区‘, ‘3‘, ‘jiancaoping‘, ‘0351‘, ‘030023‘, ‘J‘, ‘112.48709‘, ‘37.94193‘);
INSERT INTO `sh_area` VALUES (‘226‘, ‘221‘, ‘万柏林‘, ‘万柏林区‘, ‘中国,山西省,太原市,万柏林区‘, ‘3‘, ‘wanbailin‘, ‘0351‘, ‘030024‘, ‘W‘, ‘112.51553‘, ‘37.85923‘);
INSERT INTO `sh_area` VALUES (‘227‘, ‘221‘, ‘晋源‘, ‘晋源区‘, ‘中国,山西省,太原市,晋源区‘, ‘3‘, ‘jinyuan‘, ‘0351‘, ‘030025‘, ‘J‘, ‘112.47985‘, ‘37.72479‘);
INSERT INTO `sh_area` VALUES (‘228‘, ‘221‘, ‘清徐‘, ‘清徐县‘, ‘中国,山西省,太原市,清徐县‘, ‘3‘, ‘qingxu‘, ‘0351‘, ‘030400‘, ‘Q‘, ‘112.35888‘, ‘37.60758‘);
INSERT INTO `sh_area` VALUES (‘229‘, ‘221‘, ‘阳曲‘, ‘阳曲县‘, ‘中国,山西省,太原市,阳曲县‘, ‘3‘, ‘yangqu‘, ‘0351‘, ‘030100‘, ‘Y‘, ‘112.67861‘, ‘38.05989‘);
INSERT INTO `sh_area` VALUES (‘230‘, ‘221‘, ‘娄烦‘, ‘娄烦县‘, ‘中国,山西省,太原市,娄烦县‘, ‘3‘, ‘loufan‘, ‘0351‘, ‘030300‘, ‘L‘, ‘111.79473‘, ‘38.06689‘);
INSERT INTO `sh_area` VALUES (‘231‘, ‘221‘, ‘古交‘, ‘古交市‘, ‘中国,山西省,太原市,古交市‘, ‘3‘, ‘gujiao‘, ‘0351‘, ‘030200‘, ‘G‘, ‘112.16918‘, ‘37.90983‘);
INSERT INTO `sh_area` VALUES (‘232‘, ‘220‘, ‘大同‘, ‘大同市‘, ‘中国,山西省,大同市‘, ‘2‘, ‘datong‘, ‘0352‘, ‘037008‘, ‘D‘, ‘113.295259‘, ‘40.09031‘);
INSERT INTO `sh_area` VALUES (‘233‘, ‘232‘, ‘城区‘, ‘城区‘, ‘中国,山西省,大同市,城区‘, ‘3‘, ‘chengqu‘, ‘0352‘, ‘037008‘, ‘C‘, ‘113.298‘, ‘40.07566‘);
INSERT INTO `sh_area` VALUES (‘234‘, ‘232‘, ‘矿区‘, ‘矿区‘, ‘中国,山西省,大同市,矿区‘, ‘3‘, ‘kuangqu‘, ‘0352‘, ‘037003‘, ‘K‘, ‘113.1772‘, ‘40.03685‘);
INSERT INTO `sh_area` VALUES (‘235‘, ‘232‘, ‘南郊‘, ‘南郊区‘, ‘中国,山西省,大同市,南郊区‘, ‘3‘, ‘nanjiao‘, ‘0352‘, ‘037001‘, ‘N‘, ‘113.14947‘, ‘40.00539‘);
INSERT INTO `sh_area` VALUES (‘236‘, ‘232‘, ‘新荣‘, ‘新荣区‘, ‘中国,山西省,大同市,新荣区‘, ‘3‘, ‘xinrong‘, ‘0352‘, ‘037002‘, ‘X‘, ‘113.13504‘, ‘40.25618‘);
INSERT INTO `sh_area` VALUES (‘237‘, ‘232‘, ‘阳高‘, ‘阳高县‘, ‘中国,山西省,大同市,阳高县‘, ‘3‘, ‘yanggao‘, ‘0352‘, ‘038100‘, ‘Y‘, ‘113.75012‘, ‘40.36256‘);
INSERT INTO `sh_area` VALUES (‘238‘, ‘232‘, ‘天镇‘, ‘天镇县‘, ‘中国,山西省,大同市,天镇县‘, ‘3‘, ‘tianzhen‘, ‘0352‘, ‘038200‘, ‘T‘, ‘114.0931‘, ‘40.42299‘);
INSERT INTO `sh_area` VALUES (‘239‘, ‘232‘, ‘广灵‘, ‘广灵县‘, ‘中国,山西省,大同市,广灵县‘, ‘3‘, ‘guangling‘, ‘0352‘, ‘037500‘, ‘G‘, ‘114.28204‘, ‘39.76082‘);
INSERT INTO `sh_area` VALUES (‘240‘, ‘232‘, ‘灵丘‘, ‘灵丘县‘, ‘中国,山西省,大同市,灵丘县‘, ‘3‘, ‘lingqiu‘, ‘0352‘, ‘034400‘, ‘L‘, ‘114.23672‘, ‘39.44043‘);
INSERT INTO `sh_area` VALUES (‘241‘, ‘232‘, ‘浑源‘, ‘浑源县‘, ‘中国,山西省,大同市,浑源县‘, ‘3‘, ‘hunyuan‘, ‘0352‘, ‘037400‘, ‘H‘, ‘113.69552‘, ‘39.69962‘);
INSERT INTO `sh_area` VALUES (‘242‘, ‘232‘, ‘左云‘, ‘左云县‘, ‘中国,山西省,大同市,左云县‘, ‘3‘, ‘zuoyun‘, ‘0352‘, ‘037100‘, ‘Z‘, ‘112.70266‘, ‘40.01336‘);
INSERT INTO `sh_area` VALUES (‘243‘, ‘232‘, ‘大同‘, ‘大同县‘, ‘中国,山西省,大同市,大同县‘, ‘3‘, ‘datong‘, ‘0352‘, ‘037300‘, ‘D‘, ‘113.61212‘, ‘40.04012‘);
INSERT INTO `sh_area` VALUES (‘244‘, ‘220‘, ‘阳泉‘, ‘阳泉市‘, ‘中国,山西省,阳泉市‘, ‘2‘, ‘yangquan‘, ‘0353‘, ‘045000‘, ‘Y‘, ‘113.583285‘, ‘37.861188‘);
INSERT INTO `sh_area` VALUES (‘245‘, ‘244‘, ‘城区‘, ‘城区‘, ‘中国,山西省,阳泉市,城区‘, ‘3‘, ‘chengqu‘, ‘0353‘, ‘045000‘, ‘C‘, ‘113.60069‘, ‘37.8474‘);
INSERT INTO `sh_area` VALUES (‘246‘, ‘244‘, ‘矿区‘, ‘矿区‘, ‘中国,山西省,阳泉市,矿区‘, ‘3‘, ‘kuangqu‘, ‘0353‘, ‘045000‘, ‘K‘, ‘113.55677‘, ‘37.86895‘);
INSERT INTO `sh_area` VALUES (‘247‘, ‘244‘, ‘郊区‘, ‘郊区‘, ‘中国,山西省,阳泉市,郊区‘, ‘3‘, ‘jiaoqu‘, ‘0353‘, ‘045011‘, ‘J‘, ‘113.58539‘, ‘37.94139‘);
INSERT INTO `sh_area` VALUES (‘248‘, ‘244‘, ‘平定‘, ‘平定县‘, ‘中国,山西省,阳泉市,平定县‘, ‘3‘, ‘pingding‘, ‘0353‘, ‘045200‘, ‘P‘, ‘113.65789‘, ‘37.78601‘);
INSERT INTO `sh_area` VALUES (‘249‘, ‘244‘, ‘盂县‘, ‘盂县‘, ‘中国,山西省,阳泉市,盂县‘, ‘3‘, ‘yuxian‘, ‘0353‘, ‘045100‘, ‘Y‘, ‘113.41235‘, ‘38.08579‘);
INSERT INTO `sh_area` VALUES (‘250‘, ‘220‘, ‘长治‘, ‘长治市‘, ‘中国,山西省,长治市‘, ‘2‘, ‘changzhi‘, ‘0355‘, ‘046000‘, ‘C‘, ‘113.113556‘, ‘36.191112‘);
INSERT INTO `sh_area` VALUES (‘251‘, ‘250‘, ‘城区‘, ‘城区‘, ‘中国,山西省,长治市,城区‘, ‘3‘, ‘chengqu‘, ‘0355‘, ‘046011‘, ‘C‘, ‘113.12308‘, ‘36.20351‘);
INSERT INTO `sh_area` VALUES (‘252‘, ‘250‘, ‘郊区‘, ‘郊区‘, ‘中国,山西省,长治市,郊区‘, ‘3‘, ‘jiaoqu‘, ‘0355‘, ‘046011‘, ‘J‘, ‘113.12653‘, ‘36.19918‘);
INSERT INTO `sh_area` VALUES (‘253‘, ‘250‘, ‘长治‘, ‘长治县‘, ‘中国,山西省,长治市,长治县‘, ‘3‘, ‘changzhi‘, ‘0355‘, ‘047100‘, ‘C‘, ‘113.04791‘, ‘36.04722‘);
INSERT INTO `sh_area` VALUES (‘254‘, ‘250‘, ‘襄垣‘, ‘襄垣县‘, ‘中国,山西省,长治市,襄垣县‘, ‘3‘, ‘xiangyuan‘, ‘0355‘, ‘046200‘, ‘X‘, ‘113.05157‘, ‘36.53527‘);
INSERT INTO `sh_area` VALUES (‘255‘, ‘250‘, ‘屯留‘, ‘屯留县‘, ‘中国,山西省,长治市,屯留县‘, ‘3‘, ‘tunliu‘, ‘0355‘, ‘046100‘, ‘T‘, ‘112.89196‘, ‘36.31579‘);
INSERT INTO `sh_area` VALUES (‘256‘, ‘250‘, ‘平顺‘, ‘平顺县‘, ‘中国,山西省,长治市,平顺县‘, ‘3‘, ‘pingshun‘, ‘0355‘, ‘047400‘, ‘P‘, ‘113.43603‘, ‘36.20005‘);
INSERT INTO `sh_area` VALUES (‘257‘, ‘250‘, ‘黎城‘, ‘黎城县‘, ‘中国,山西省,长治市,黎城县‘, ‘3‘, ‘licheng‘, ‘0355‘, ‘047600‘, ‘L‘, ‘113.38766‘, ‘36.50301‘);
INSERT INTO `sh_area` VALUES (‘258‘, ‘250‘, ‘壶关‘, ‘壶关县‘, ‘中国,山西省,长治市,壶关县‘, ‘3‘, ‘huguan‘, ‘0355‘, ‘047300‘, ‘H‘, ‘113.207‘, ‘36.11301‘);
INSERT INTO `sh_area` VALUES (‘259‘, ‘250‘, ‘长子‘, ‘长子县‘, ‘中国,山西省,长治市,长子县‘, ‘3‘, ‘zhangzi‘, ‘0355‘, ‘046600‘, ‘C‘, ‘112.87731‘, ‘36.12125‘);
INSERT INTO `sh_area` VALUES (‘260‘, ‘250‘, ‘武乡‘, ‘武乡县‘, ‘中国,山西省,长治市,武乡县‘, ‘3‘, ‘wuxiang‘, ‘0355‘, ‘046300‘, ‘W‘, ‘112.86343‘, ‘36.83687‘);
INSERT INTO `sh_area` VALUES (‘261‘, ‘250‘, ‘沁县‘, ‘沁县‘, ‘中国,山西省,长治市,沁县‘, ‘3‘, ‘qinxian‘, ‘0355‘, ‘046400‘, ‘Q‘, ‘112.69863‘, ‘36.75628‘);
INSERT INTO `sh_area` VALUES (‘262‘, ‘250‘, ‘沁源‘, ‘沁源县‘, ‘中国,山西省,长治市,沁源县‘, ‘3‘, ‘qinyuan‘, ‘0355‘, ‘046500‘, ‘Q‘, ‘112.33758‘, ‘36.50008‘);
INSERT INTO `sh_area` VALUES (‘263‘, ‘250‘, ‘潞城‘, ‘潞城市‘, ‘中国,山西省,长治市,潞城市‘, ‘3‘, ‘lucheng‘, ‘0355‘, ‘047500‘, ‘L‘, ‘113.22888‘, ‘36.33414‘);
INSERT INTO `sh_area` VALUES (‘264‘, ‘220‘, ‘晋城‘, ‘晋城市‘, ‘中国,山西省,晋城市‘, ‘2‘, ‘jincheng‘, ‘0356‘, ‘048000‘, ‘J‘, ‘112.851274‘, ‘35.497553‘);
INSERT INTO `sh_area` VALUES (‘265‘, ‘264‘, ‘城区‘, ‘城区‘, ‘中国,山西省,晋城市,城区‘, ‘3‘, ‘chengqu‘, ‘0356‘, ‘048000‘, ‘C‘, ‘112.85319‘, ‘35.50175‘);
INSERT INTO `sh_area` VALUES (‘266‘, ‘264‘, ‘沁水‘, ‘沁水县‘, ‘中国,山西省,晋城市,沁水县‘, ‘3‘, ‘qinshui‘, ‘0356‘, ‘048200‘, ‘Q‘, ‘112.1871‘, ‘35.69102‘);
INSERT INTO `sh_area` VALUES (‘267‘, ‘264‘, ‘阳城‘, ‘阳城县‘, ‘中国,山西省,晋城市,阳城县‘, ‘3‘, ‘yangcheng‘, ‘0356‘, ‘048100‘, ‘Y‘, ‘112.41485‘, ‘35.48614‘);
INSERT INTO `sh_area` VALUES (‘268‘, ‘264‘, ‘陵川‘, ‘陵川县‘, ‘中国,山西省,晋城市,陵川县‘, ‘3‘, ‘lingchuan‘, ‘0356‘, ‘048300‘, ‘L‘, ‘113.2806‘, ‘35.77532‘);
INSERT INTO `sh_area` VALUES (‘269‘, ‘264‘, ‘泽州‘, ‘泽州县‘, ‘中国,山西省,晋城市,泽州县‘, ‘3‘, ‘zezhou‘, ‘0356‘, ‘048012‘, ‘Z‘, ‘112.83947‘, ‘35.50789‘);
INSERT INTO `sh_area` VALUES (‘270‘, ‘264‘, ‘高平‘, ‘高平市‘, ‘中国,山西省,晋城市,高平市‘, ‘3‘, ‘gaoping‘, ‘0356‘, ‘048400‘, ‘G‘, ‘112.92288‘, ‘35.79705‘);
INSERT INTO `sh_area` VALUES (‘271‘, ‘220‘, ‘朔州‘, ‘朔州市‘, ‘中国,山西省,朔州市‘, ‘2‘, ‘shuozhou‘, ‘0349‘, ‘038500‘, ‘S‘, ‘112.433387‘, ‘39.331261‘);
INSERT INTO `sh_area` VALUES (‘272‘, ‘271‘, ‘朔城‘, ‘朔城区‘, ‘中国,山西省,朔州市,朔城区‘, ‘3‘, ‘shuocheng‘, ‘0349‘, ‘036000‘, ‘S‘, ‘112.43189‘, ‘39.31982‘);
INSERT INTO `sh_area` VALUES (‘273‘, ‘271‘, ‘平鲁‘, ‘平鲁区‘, ‘中国,山西省,朔州市,平鲁区‘, ‘3‘, ‘pinglu‘, ‘0349‘, ‘038600‘, ‘P‘, ‘112.28833‘, ‘39.51155‘);
INSERT INTO `sh_area` VALUES (‘274‘, ‘271‘, ‘山阴‘, ‘山阴县‘, ‘中国,山西省,朔州市,山阴县‘, ‘3‘, ‘shanyin‘, ‘0349‘, ‘036900‘, ‘S‘, ‘112.81662‘, ‘39.52697‘);
INSERT INTO `sh_area` VALUES (‘275‘, ‘271‘, ‘应县‘, ‘应县‘, ‘中国,山西省,朔州市,应县‘, ‘3‘, ‘yingxian‘, ‘0349‘, ‘037600‘, ‘Y‘, ‘113.19052‘, ‘39.55279‘);
INSERT INTO `sh_area` VALUES (‘276‘, ‘271‘, ‘右玉‘, ‘右玉县‘, ‘中国,山西省,朔州市,右玉县‘, ‘3‘, ‘youyu‘, ‘0349‘, ‘037200‘, ‘Y‘, ‘112.46902‘, ‘39.99011‘);
INSERT INTO `sh_area` VALUES (‘277‘, ‘271‘, ‘怀仁‘, ‘怀仁县‘, ‘中国,山西省,朔州市,怀仁县‘, ‘3‘, ‘huairen‘, ‘0349‘, ‘038300‘, ‘H‘, ‘113.10009‘, ‘39.82806‘);
INSERT INTO `sh_area` VALUES (‘278‘, ‘220‘, ‘晋中‘, ‘晋中市‘, ‘中国,山西省,晋中市‘, ‘2‘, ‘jinzhong‘, ‘0354‘, ‘030600‘, ‘J‘, ‘112.736465‘, ‘37.696495‘);
INSERT INTO `sh_area` VALUES (‘279‘, ‘278‘, ‘榆次‘, ‘榆次区‘, ‘中国,山西省,晋中市,榆次区‘, ‘3‘, ‘yuci‘, ‘0354‘, ‘030600‘, ‘Y‘, ‘112.70788‘, ‘37.6978‘);
INSERT INTO `sh_area` VALUES (‘280‘, ‘278‘, ‘榆社‘, ‘榆社县‘, ‘中国,山西省,晋中市,榆社县‘, ‘3‘, ‘yushe‘, ‘0354‘, ‘031800‘, ‘Y‘, ‘112.97558‘, ‘37.0721‘);
INSERT INTO `sh_area` VALUES (‘281‘, ‘278‘, ‘左权‘, ‘左权县‘, ‘中国,山西省,晋中市,左权县‘, ‘3‘, ‘zuoquan‘, ‘0354‘, ‘032600‘, ‘Z‘, ‘113.37918‘, ‘37.08235‘);
INSERT INTO `sh_area` VALUES (‘282‘, ‘278‘, ‘和顺‘, ‘和顺县‘, ‘中国,山西省,晋中市,和顺县‘, ‘3‘, ‘heshun‘, ‘0354‘, ‘032700‘, ‘H‘, ‘113.56988‘, ‘37.32963‘);
INSERT INTO `sh_area` VALUES (‘283‘, ‘278‘, ‘昔阳‘, ‘昔阳县‘, ‘中国,山西省,晋中市,昔阳县‘, ‘3‘, ‘xiyang‘, ‘0354‘, ‘045300‘, ‘X‘, ‘113.70517‘, ‘37.61863‘);
INSERT INTO `sh_area` VALUES (‘284‘, ‘278‘, ‘寿阳‘, ‘寿阳县‘, ‘中国,山西省,晋中市,寿阳县‘, ‘3‘, ‘shouyang‘, ‘0354‘, ‘045400‘, ‘S‘, ‘113.17495‘, ‘37.88899‘);
INSERT INTO `sh_area` VALUES (‘285‘, ‘278‘, ‘太谷‘, ‘太谷县‘, ‘中国,山西省,晋中市,太谷县‘, ‘3‘, ‘taigu‘, ‘0354‘, ‘030800‘, ‘T‘, ‘112.55246‘, ‘37.42161‘);
INSERT INTO `sh_area` VALUES (‘286‘, ‘278‘, ‘祁县‘, ‘祁县‘, ‘中国,山西省,晋中市,祁县‘, ‘3‘, ‘qixian‘, ‘0354‘, ‘030900‘, ‘Q‘, ‘112.33358‘, ‘37.3579‘);
INSERT INTO `sh_area` VALUES (‘287‘, ‘278‘, ‘平遥‘, ‘平遥县‘, ‘中国,山西省,晋中市,平遥县‘, ‘3‘, ‘pingyao‘, ‘0354‘, ‘031100‘, ‘P‘, ‘112.17553‘, ‘37.1892‘);
INSERT INTO `sh_area` VALUES (‘288‘, ‘278‘, ‘灵石‘, ‘灵石县‘, ‘中国,山西省,晋中市,灵石县‘, ‘3‘, ‘lingshi‘, ‘0354‘, ‘031300‘, ‘L‘, ‘111.7774‘, ‘36.84814‘);
INSERT INTO `sh_area` VALUES (‘289‘, ‘278‘, ‘介休‘, ‘介休市‘, ‘中国,山西省,晋中市,介休市‘, ‘3‘, ‘jiexiu‘, ‘0354‘, ‘032000‘, ‘J‘, ‘111.91824‘, ‘37.02771‘);
INSERT INTO `sh_area` VALUES (‘290‘, ‘220‘, ‘运城‘, ‘运城市‘, ‘中国,山西省,运城市‘, ‘2‘, ‘yuncheng‘, ‘0359‘, ‘044000‘, ‘Y‘, ‘111.003957‘, ‘35.022778‘);
INSERT INTO `sh_area` VALUES (‘291‘, ‘290‘, ‘盐湖‘, ‘盐湖区‘, ‘中国,山西省,运城市,盐湖区‘, ‘3‘, ‘yanhu‘, ‘0359‘, ‘044000‘, ‘Y‘, ‘110.99827‘, ‘35.0151‘);
INSERT INTO `sh_area` VALUES (‘292‘, ‘290‘, ‘临猗‘, ‘临猗县‘, ‘中国,山西省,运城市,临猗县‘, ‘3‘, ‘linyi‘, ‘0359‘, ‘044100‘, ‘L‘, ‘110.77432‘, ‘35.14455‘);
INSERT INTO `sh_area` VALUES (‘293‘, ‘290‘, ‘万荣‘, ‘万荣县‘, ‘中国,山西省,运城市,万荣县‘, ‘3‘, ‘wanrong‘, ‘0359‘, ‘044200‘, ‘W‘, ‘110.83657‘, ‘35.41556‘);
INSERT INTO `sh