/*
Navicat MySQL Data Transfer
Source Server : local
Source Server Version : 50136
Source Host : localhost:3306
Source Database : geoinfo
Target Server Type : MYSQL
Target Server Version : 50136
File Encoding : 65001
Date: 2011-03-24 16:36:44
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `city`
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
`ID` int(11) NOT NULL,
`Name` varchar(255) NOT NULL,
`Code` varchar(3) NOT NULL,
`ProvinceID` int(11) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES ('1', '市辖区', '01', '1');
INSERT INTO `city` VALUES ('2', '县', '02', '1');
INSERT INTO `city` VALUES ('3', '市辖区', '01', '2');
INSERT INTO `city` VALUES ('4', '市辖县', '02', '2');
INSERT INTO `city` VALUES ('5', '石家庄市', '01', '3');
INSERT INTO `city` VALUES ('6', '唐山市', '02', '3');
INSERT INTO `city` VALUES ('7', '秦皇岛市', '03', '3');
INSERT INTO `city` VALUES ('8', '邯郸市', '04', '3');
INSERT INTO `city` VALUES ('9', '邢台市', '05', '3');
INSERT INTO `city` VALUES ('10', '保定市', '06', '3');
INSERT INTO `city` VALUES ('11', '张家口市', '07', '3');
INSERT INTO `city` VALUES ('12', '承德市', '08', '3');
INSERT INTO `city` VALUES ('13', '沧州市', '09', '3');
INSERT INTO `city` VALUES ('14', '廊坊市', '10', '3');
INSERT INTO `city` VALUES ('15', '衡水市', '11', '3');
INSERT INTO `city` VALUES ('16', '太原市', '01', '4');
INSERT INTO `city` VALUES ('17', '大同市', '02', '4');
INSERT INTO `city` VALUES ('18', '阳泉市', '03', '4');
INSERT INTO `city` VALUES ('19', '长治市', '04', '4');
INSERT INTO `city` VALUES ('20', '晋城市', '05', '4');
INSERT INTO `city` VALUES ('21', '朔州市', '06', '4');
INSERT INTO `city` VALUES ('22', '晋中市', '07', '4');
INSERT INTO `city` VALUES ('23', '运城市', '08', '4');
INSERT INTO `city` VALUES ('24', '忻州市', '09', '4');
INSERT INTO `city` VALUES ('25', '临汾市', '10', '4');
INSERT INTO `city` VALUES ('26', '吕梁市', '11', '4');
INSERT INTO `city` VALUES ('27', '呼和浩特市', '01', '5');
INSERT INTO `city` VALUES ('28', '包头市', '02', '5');
INSERT INTO `city` VALUES ('29', '乌海市', '03', '5');
INSERT INTO `city` VALUES ('30', '赤峰市', '04', '5');
INSERT INTO `city` VALUES ('31', '通辽市', '05', '5');
INSERT INTO `city` VALUES ('32', '鄂尔多斯市', '06', '5');
INSERT INTO `city` VALUES ('33', '呼伦贝尔市', '07', '5');
INSERT INTO `city` VALUES ('34', '巴彦淖尔市', '08', '5');
INSERT INTO `city` VALUES ('35', '乌兰察布市', '09', '5');
INSERT INTO `city` VALUES ('36', '兴安盟', '22', '5');
INSERT INTO `city` VALUES ('37', '锡林郭勒盟', '25', '5');
INSERT INTO `city` VALUES ('38', '阿拉善盟', '29', '5');
INSERT INTO `city` VALUES ('39', '沈阳市', '01', '6');
INSERT INTO `city` VALUES ('40', '大连市', '02', '6');
INSERT INTO `city` VALUES ('41', '鞍山市', '03', '6');
INSERT INTO `city` VALUES ('42', '抚顺市', '04', '6');
INSERT INTO `city` VALUES ('43', '本溪市', '05', '6');
INSERT INTO `city` VALUES ('44', '丹东市', '06', '6');
INSERT INTO `city` VALUES ('45', '锦州市', '07', '6');
INSERT INTO `city` VALUES ('46', '营口市', '08', '6');
INSERT INTO `city` VALUES ('47', '阜新市', '09', '6');
INSERT INTO `city` VALUES ('48', '辽阳市', '10', '6');
INSERT INTO `city` VALUES ('49', '盘锦市', '11', '6');
INSERT INTO `city` VALUES ('50', '铁岭市', '12', '6');
INSERT INTO `city` VALUES ('51', '朝阳市', '13', '6');
INSERT INTO `city` VALUES ('52', '葫芦岛市', '14', '6');
INSERT INTO `city` VALUES ('53', '长春市', '01', '7');
INSERT INTO `city` VALUES ('54', '吉林市', '02', '7');
INSERT INTO `city` VALUES ('55', '四平市', '03', '7');
INSERT INTO `city` VALUES ('56', '辽源市', '04', '7');
INSERT INTO `city` VALUES ('57', '通化市', '05', '7');
INSERT INTO `city` VALUES ('58', '白山市', '06', '7');
INSERT INTO `city` VALUES ('59', '松原市', '07', '7');
INSERT INTO `city` VALUES ('60', '白城市', '08', '7');
INSERT INTO `city` VALUES ('61', '延边朝鲜族自治州', '24', '7');
INSERT INTO `city` VALUES ('62', '哈尔滨市', '01', '8');
INSERT INTO `city` VALUES ('63', '齐齐哈尔市', '02', '8');
INSERT INTO `city` VALUES ('64', '鸡西市', '03', '8');
INSERT INTO `city` VALUES ('65', '鹤岗市', '04', '8');
INSERT INTO `city` VALUES ('66', '双鸭山市', '05', '8');
INSERT INTO `city` VALUES ('67', '大庆市', '06', '8');
INSERT INTO `city` VALUES ('68', '伊春市', '07', '8');
INSERT INTO `city` VALUES ('69', '佳木斯市', '08', '8');
INSERT INTO `city` VALUES ('70', '七台河市', '09', '8');
INSERT INTO `city` VALUES ('71', '牡丹江市', '10', '8');
INSERT INTO `city` VALUES ('72', '黑河市', '11', '8');
INSERT INTO `city` VALUES ('73', '绥化市', '12', '8');
INSERT INTO `city` VALUES ('74', '大兴安岭地区', '27', '8');
INSERT INTO `city` VALUES ('75', '市辖区', '01', '9');
INSERT INTO `city` VALUES ('76', '县', '02', '9');
INSERT INTO `city` VALUES ('77', '南京市', '01', '10');
INSERT INTO `city` VALUES ('78', '无锡市', '02', '10');
INSERT INTO `city` VALUES ('79', '徐州市', '03', '10');
INSERT INTO `city` VALUES ('80', '常州市', '04', '10');
INSERT INTO `city` VALUES ('81', '苏州市', '05', '10');
INSERT INTO `city` VALUES ('82', '南通市', '06', '10');
INSERT INTO `city` VALUES ('83', '连云港市', '07', '10');
INSERT INTO `city` VALUES ('84', '淮安市', '08', '10');
INSERT INTO `city` VALUES ('85', '盐城市', '09', '10');
INSERT INTO `city` VALUES ('86', '扬州市', '10', '10');
INSERT INTO `city` VALUES ('87', '镇江市', '11', '10');
INSERT INTO `city` VALUES ('88', '泰州市', '12', '10');
INSERT INTO `city` VALUES ('89', '宿迁市', '13', '10');
INSERT INTO `city` VALUES ('90', '杭州市', '01', '11');
INSERT INTO `city` VALUES ('91', '宁波市', '02', '11');
INSERT INTO `city` VALUES ('92', '温州市', '03', '11');
INSERT INTO `city` VALUES ('93', '嘉兴市', '04', '11');
INSERT INTO `city` VALUES ('94', '湖州市', '05', '11');
INSERT INTO `city` VALUES ('95', '绍兴市', '06', '11');
INSERT INTO `city` VALUES ('96', '金华市', '07', '11');
INSERT INTO `city` VALUES ('97', '衢州市', '08', '11');
INSERT INTO `city` VALUES ('98', '舟山市', '09', '11');
INSERT INTO `city` VALUES ('99', '台州市', '10', '11');
INSERT INTO `city` VALUES ('100', '丽水市', '11', '11');
INSERT INTO `city` VALUES ('101', '合肥市', '01', '12');
INSERT INTO `city` VALUES ('102', '芜湖市', '02', '12');
INSERT INTO `city` VALUES ('103', '蚌埠市', '03', '12');
INSERT INTO `city` VALUES ('104', '淮南市', '04', '12');
INSERT INTO `city` VALUES ('105', '马鞍山市', '05', '12');
INSERT INTO `city` VALUES ('106', '淮北市', '06', '12');
INSERT INTO `city` VALUES ('107', '铜陵市', '07', '12');
INSERT INTO `city` VALUES ('108', '安庆市', '08', '12');
INSERT INTO `city` VALUES ('109', '黄山市', '10', '12');
INSERT INTO `city` VALUES ('110', '滁州市', '11', '12');
INSERT INTO `city` VALUES ('111', '阜阳市', '12', '12');
INSERT INTO `city` VALUES ('112', '宿州市', '13', '12');
INSERT INTO `city` VALUES ('113', '巢湖市', '14', '12');
INSERT INTO `city` VALUES ('114', '六安市', '15', '12');
INSERT INTO `city` VALUES ('115', '亳州市', '16', '12');
INSERT INTO `city` VALUES ('116', '池州市', '17', '12');
INSERT INTO `city` VALUES ('117', '宣城市', '18', '12');
INSERT INTO `city` VALUES ('118', '福州市', '01', '13');
INSERT INTO `city` VALUES ('119', '厦门市', '02', '13');
INSERT INTO `city` VALUES ('120', '莆田市', '03', '13');
INSERT INTO `city` VALUES