SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `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='地区码表';
-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('1', '110000', '北京市', '1', '010', '116.407394,39.904211', '-1');
INSERT INTO `area` VALUES ('2', '110100', '北京城区', '2', '010', '116.407394,39.904211', '1');
INSERT INTO `area` VALUES ('3', '110101', '东城区', '3', '010', '116.41649,39.928341', '2');
INSERT INTO `area` VALUES ('4', '110102', '西城区', '3', '010', '116.365873,39.912235', '2');
INSERT INTO `area` VALUES ('5', '110105', '朝阳区', '3', '010', '116.443205,39.921506', '2');
INSERT INTO `area` VALUES ('6', '110106', '丰台区', '3', '010', '116.287039,39.858421', '2');
INSERT INTO `area` VALUES ('7', '110107', '石景山区', '3', '010', '116.222933,39.906611', '2');
INSERT INTO `area` VALUES ('8', '110108', '海淀区', '3', '010', '116.298262,39.95993', '2');
INSERT INTO `area` VALUES ('9', '110109', '门头沟区', '3', '010', '116.101719,39.940338', '2');
INSERT INTO `area` VALUES ('10', '110111', '房山区', '3', '010', '116.143486,39.748823', '2');
INSERT INTO `area` VALUES ('11', '110112', '通州区', '3', '010', '116.656434,39.909946', '2');
INSERT INTO `area` VALUES ('12', '110113', '顺义区', '3', '010', '116.654642,40.130211', '2');
INSERT INTO `area` VALUES ('13', '110114', '昌平区', '3', '010', '116.231254,40.220804', '2');
INSERT INTO `area` VALUES ('14', '110115', '大兴区', '3', '010', '116.341483,39.726917', '2');
INSERT INTO `area` VALUES ('15', '110116', '怀柔区', '3', '010', '116.631931,40.316053', '2');
INSERT INTO `area` VALUES ('16', '110117', '平谷区', '3', '010', '117.121351,40.140595', '2');
INSERT INTO `area` VALUES ('17', '110118', '密云区', '3', '010', '116.843047,40.376894', '2');
INSERT INTO `area` VALUES ('18', '110119', '延庆区', '3', '010', '115.974981,40.456591', '2');
INSERT INTO `area` VALUES ('19', '120000', '天津市', '1', '022', '117.200983,39.084158', '-1');
INSERT INTO `area` VALUES ('20', '120100', '天津城区', '2', '022', '117.200983,39.084158', '19');
INSERT INTO `area` VALUES ('21', '120101', '和平区', '3', '022', '117.214699,39.117196', '20');
INSERT INTO `area` VALUES ('22', '120102', '河东区', '3', '022', '117.251584,39.128294', '20');
INSERT INTO `area` VALUES ('23', '120103', '河西区', '3', '022', '117.223371,39.109563', '20');
INSERT INTO `area` VALUES ('24', '120104', '南开区', '3', '022', '117.150738,39.138205', '20');
INSERT INTO `area` VALUES ('25', '120105', '河北区', '3', '022', '117.196648,39.147869', '20');
INSERT INTO `area` VALUES ('26', '120106', '红桥区', '3', '022', '117.151533,39.167345', '20');
INSERT INTO `area` VALUES ('27', '120110', '东丽区', '3', '022', '117.31362,39.086802', '20');
INSERT INTO `area` VALUES ('28', '120111', '西青区', '3', '022', '117.008826,39.141152', '20');
INSERT INTO `area` VALUES ('29', '120112', '津南区', '3', '022', '117.35726,38.937928', '20');
INSERT INTO `area` VALUES ('30', '120113', '北辰区', '3', '022', '117.135488,39.224791', '20');
INSERT INTO `area` VALUES ('31', '120114', '武清区', '3', '022', '117.044387,39.384119', '20');
INSERT INTO `area` VALUES ('32', '120115', '宝坻区', '3', '022', '117.309874,39.717564', '20');
INSERT INTO `area` VALUES ('33', '120116', '滨海新区', '3', '022', '117.698407,39.01727', '20');
INSERT INTO `area` VALUES ('34', '120117', '宁河区', '3', '022', '117.826724,39.330087', '20');
INSERT INTO `area` VALUES ('35', '120118', '静海区', '3', '022', '116.974232,38.94745', '20');
INSERT INTO `area` VALUES ('36', '120119', '蓟州区', '3', '022', '117.408296,40.045851', '20');
INSERT INTO `area` VALUES ('37', '130000', '河北省', '1', '[]', '114.530235,38.037433', '-1');
INSERT INTO `area` VALUES ('38', '130100', '石家庄市', '2', '0311', '114.514793,38.042228', '37');
INSERT INTO `area` VALUES ('39', '130102', '长安区', '3', '0311', '114.539395,38.036347', '38');
INSERT INTO `area` VALUES ('40', '130104', '桥西区', '3', '0311', '114.461088,38.004193', '38');
INSERT INTO `area` VALUES ('41', '130105', '新华区', '3', '0311', '114.463377,38.05095', '38');
INSERT INTO `area` VALUES ('42', '130107', '井陉矿区', '3', '0311', '114.062062,38.065151', '38');
INSERT INTO `area` VALUES ('43', '130108', '裕华区', '3', '0311', '114.531202,38.00643', '38');
INSERT INTO `area` VALUES ('44', '130109', '藁城区', '3', '0311', '114.847023,38.021453', '38');
INSERT INTO `area` VALUES ('45', '130110', '鹿泉区', '3', '0311', '114.313654,38.085953', '38');
INSERT INTO `area` VALUES ('46', '130111', '栾城区', '3', '0311', '114.648318,37.900199', '38');
INSERT INTO `area` VALUES ('47', '130121', '井陉县', '3', '0311', '114.145242,38.032118', '38');
INSERT INTO `area` VALUES ('48', '130123', '正定县', '3', '0311', '114.570941,38.146444', '38');
INSERT INTO `area` VALUES ('49', '130125', '行唐县', '3', '0311', '114.552714,38.438377', '38');
INSERT INTO `area` VALUES ('50', '130126', '灵寿县', '3', '0311', '114.382614,38.308665', '38');
INSERT INTO `area` VALUES ('51', '130127', '高邑县', '3', '0311', '114.611121,37.615534', '38');
INSERT INTO `area` VALUES ('52', '130128', '深泽县', '3', '0311', '115.20092,38.184033', '38');
INSERT INTO `area` VALUES ('53', '130129', '赞皇县', '3', '0311', '114.386111,37.665663', '38');
INSERT INTO `area` VALUES ('54', '130130', '无极县', '3', '0311', '114.97634,38.179192', '38');
INSERT INTO `area` VALUES ('55', '130131', '平山县', '3', '0311', '114.195918,38.247888', '38');
INSERT INTO `area` VALUES ('56', '130132', '元氏县', '3', '0311', '114.525409,37.766513', '38');
INSERT INTO `area` VALUES ('57', '130133', '赵县', '3', '0311', '114.776297,37.756578', '38');
INSERT INTO `area` VALUES ('58', '130181', '辛集市', '3', '0311', '115.217658,37.943121', '38');
INSERT INTO `area` VALUES ('59', '130183', '晋州市', '3', '0311', '115.044213,38.033671', '38');
INSERT INTO `area` VALUES ('60', '130184', '新乐市', '3', '0311', '114.683776,38.343319', '38');
INSERT INTO `area` VALUES ('61', '130200', '唐山市', '2', '0315', '118.180193,39.630867', '37');
INSERT INTO `area` VALUES ('62', '130202', '路南区', '3', '0315', '118.154354,39.625058', '61');
INSERT INTO `area` VALUES ('63', '130203', '路北区', '3', '0315', '118.200692,39.624437', '61');
INSERT INTO `area` VALUES ('64', '130204', '古冶区', '3', '0315', '118.447635,39.733578', '61');
INSERT INTO `area` VALUES ('65', '130205', '开平区', '3', '0315', '118.261841,39.671001', '61');
INSERT INTO `area` VALUES ('66', '130207', '丰南区', '3', '0315', '118.085169,39.576031', '61');
INSERT INTO `area` VALUES ('67', '130208', '丰润区', '3', '0315', '118.162215,39.832582', '61');
INSERT INTO `area` VALUES ('68', '130209', '曹妃甸区', '3', '0315', '118.460379,39.27307', '61');
INSERT INTO `area` VALUES ('69', '130223', '滦县', '3', '0315', '118.703598,39.740593', '61');
INSERT INTO `area` VALUES ('70', '130224', '滦南县', '3', '0315', '1
评论1