城市和车牌号前缀对应关系表结构

 这是Oracle数据库的语法结构

CREATE TABLE "COD_CS_CPQZ" (
"ID" NUMBER(8) NOT NULL ,
"XZQHS" VARCHAR2(255 BYTE) NULL ,
"SMC" VARCHAR2(255 BYTE) NULL ,
"CPQZ1" VARCHAR2(255 BYTE) NULL ,
"DSMC" VARCHAR2(255 BYTE) NULL ,
"CPQZ2" VARCHAR2(255 BYTE) NULL ,
"XZQHDS" VARCHAR2(255 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;
COMMENT ON TABLE "COD_CS_CPQZ" IS '城市和车牌号对应关系表';
COMMENT ON COLUMN "COD_CS_CPQZ"."XZQHS" IS '行政区划省编码';
COMMENT ON COLUMN "COD_CS_CPQZ"."SMC" IS '省名称';
COMMENT ON COLUMN "COD_CS_CPQZ"."CPQZ1" IS '车牌号第一位';
COMMENT ON COLUMN "COD_CS_CPQZ"."DSMC" IS '市名称';
COMMENT ON COLUMN "COD_CS_CPQZ"."CPQZ2" IS '车牌号第二位';
COMMENT ON COLUMN "COD_CS_CPQZ"."XZQHDS" IS '市行政区划编码';

-- ----------------------------
-- Records of COD_CS_CPQZ
-- ----------------------------
INSERT INTO "COD_CS_CPQZ" VALUES ('185', '410000', '河南省', '豫', '济源市', 'U', '411800');
INSERT INTO "COD_CS_CPQZ" VALUES ('186', '420000', '湖北省', '鄂', '武汉市', 'A', '420100');
INSERT INTO "COD_CS_CPQZ" VALUES ('187', '420000', '湖北省', '鄂', '黄石市', 'B', '420200');
INSERT INTO "COD_CS_CPQZ" VALUES ('188', '420000', '湖北省', '鄂', '十堰市', 'C', '420300');
INSERT INTO "COD_CS_CPQZ" VALUES ('189', '420000', '湖北省', '鄂', '宜昌市', 'E', '420500');
INSERT INTO "COD_CS_CPQZ" VALUES ('190', '420000', '湖北省', '鄂', '襄阳市', 'F', '420600');
INSERT INTO "COD_CS_CPQZ" VALUES ('191', '420000', '湖北省', '鄂', '鄂州市', 'G', '420700');
INSERT INTO "COD_CS_CPQZ" VALUES ('192', '420000', '湖北省', '鄂', '荆门市', 'H', '420800');
INSERT INTO "COD_CS_CPQZ" VALUES ('193', '420000', '湖北省', '鄂', '孝感市', 'K', '420900');
INSERT INTO "COD_CS_CPQZ" VALUES ('194', '420000', '湖北省', '鄂', '荆州市', 'D', '421000');
INSERT INTO "COD_CS_CPQZ" VALUES ('195', '420000', '湖北省', '鄂', '黄冈市', 'J', '421100');
INSERT INTO "COD_CS_CPQZ" VALUES ('196', '420000', '湖北省', '鄂', '咸宁市', 'L', '421200');
INSERT INTO "COD_CS_CPQZ" VALUES ('197', '420000', '湖北省', '鄂', '随州市', 'S', '421300');
INSERT INTO "COD_CS_CPQZ" VALUES ('198', '420000', '湖北省', '鄂', '神农架区', 'P', '421400');
INSERT INTO "COD_CS_CPQZ" VALUES ('199', '420000', '湖北省', '鄂', '天门市', 'R', '421500');
INSERT INTO "COD_CS_CPQZ" VALUES ('200', '420000', '湖北省', '鄂', '潜江市', 'N', '421600');
INSERT INTO "COD_CS_CPQZ" VALUES ('201', '420000', '湖北省', '鄂', '仙桃市', 'M', '421700');
INSERT INTO "COD_CS_CPQZ" VALUES ('202', '420000', '湖北省', '鄂', '恩施州', 'Q', '422800');
INSERT INTO "COD_CS_CPQZ" VALUES ('203', '430000', '湖南省', '湘', '长沙市', 'A', '430100');
INSERT INTO "COD_CS_CPQZ" VALUES ('204', '430000', '湖南省', '湘', '株洲市', 'B', '430200');
INSERT INTO "COD_CS_CPQZ" VALUES ('205', '430000', '湖南省', '湘', '湘潭市', 'C', '430300');
INSERT INTO "COD_CS_CPQZ" VALUES ('206', '430000', '湖南省', '湘', '衡阳市', 'D', '430400');
INSERT INTO "COD_CS_CPQZ" VALUES ('207', '430000', '湖南省', '湘', '邵阳市', 'E', '430500');
INSERT INTO "COD_CS_CPQZ" VALUES ('208', '430000', '湖南省', '湘', '岳阳市', 'F', '430600');
INSERT INTO "COD_CS_CPQZ" VALUES ('209', '430000', '湖南省', '湘', '常德市', 'J', '430700');
INSERT INTO "COD_CS_CPQZ" VALUES ('210', '430000', '湖南省', '湘', '张家界市', 'G', '430800');
INSERT INTO "COD_CS_CPQZ" VALUES ('211', '430000', '湖南省', '湘', '益阳市', 'H', '430900');
INSERT INTO "COD_CS_CPQZ" VALUES ('212', '430000', '湖南省', '湘', '郴州市', 'L', '431000');
INSERT INTO "COD_CS_CPQZ" VALUES ('213', '430000', '湖南省', '湘', '永州市', 'M', '431100');
INSERT INTO "COD_CS_CPQZ" VALUES ('214', '430000', '湖南省', '湘', '怀化市', 'N', '431200');
INSERT INTO "COD_CS_CPQZ" VALUES ('215', '430000', '湖南省', '湘', '娄底市', 'K', '431300');
INSERT INTO "COD_CS_CPQZ" VALUES ('216', '430000', '湖南省', '湘', '湘西州', 'U', '433100');
INSERT INTO "COD_CS_CPQZ" VALUES ('217', '440000', '广东省', '粤', '广州市', 'A', '440100');
INSERT INTO "COD_CS_CPQZ" VALUES ('218', '440000', '广东省', '粤', '韶关市', 'F', '440200');
INSERT INTO "COD_CS_CPQZ" VALUES ('219', '440000', '广东省', '粤', '深圳市', 'B', '440300');
INSERT INTO "COD_CS_CPQZ" VALUES ('220', '440000', '广东省', '粤', '珠海市', 'C', '440400');
INSERT INTO "COD_CS_CPQZ" VALUES ('221', '440000', '广东省', '粤', '汕头市', 'D', '440500');
INSERT INTO "COD_CS_CPQZ" VALUES ('222', '440000', '广东省', '粤', '佛山市', 'E', '440600');
INSERT INTO "COD_CS_CPQZ" VALUES ('223', '440000', '广东省', '粤', '顺德市', 'X', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('225', '440000', '广东省', '粤', '江门市', 'J', '440700');
INSERT INTO "COD_CS_CPQZ" VALUES ('226', '440000', '广东省', '粤', '湛江市', 'G', '440800');
INSERT INTO "COD_CS_CPQZ" VALUES ('227', '440000', '广东省', '粤', '茂名市', 'K', '440900');
INSERT INTO "COD_CS_CPQZ" VALUES ('228', '440000', '广东省', '粤', '肇庆市', 'H', '441200');
INSERT INTO "COD_CS_CPQZ" VALUES ('229', '440000', '广东省', '粤', '惠州市', 'L', '441300');
INSERT INTO "COD_CS_CPQZ" VALUES ('230', '440000', '广东省', '粤', '梅州市', 'M', '441400');
INSERT INTO "COD_CS_CPQZ" VALUES ('231', '440000', '广东省', '粤', '汕尾市', 'N', '441500');
INSERT INTO "COD_CS_CPQZ" VALUES ('232', '440000', '广东省', '粤', '河源市', 'P', '441600');
INSERT INTO "COD_CS_CPQZ" VALUES ('233', '440000', '广东省', '粤', '阳江市', 'Q', '441700');
INSERT INTO "COD_CS_CPQZ" VALUES ('234', '440000', '广东省', '粤', '清远市', 'R', '441800');
INSERT INTO "COD_CS_CPQZ" VALUES ('235', '440000', '广东省', '粤', '东莞市', 'S', '441900');
INSERT INTO "COD_CS_CPQZ" VALUES ('236', '440000', '广东省', '粤', '中山市', 'T', '442000');
INSERT INTO "COD_CS_CPQZ" VALUES ('237', '440000', '广东省', '粤', '潮州市', 'U', '445100');
INSERT INTO "COD_CS_CPQZ" VALUES ('238', '440000', '广东省', '粤', '揭阳市', 'V', '445200');
INSERT INTO "COD_CS_CPQZ" VALUES ('239', '440000', '广东省', '粤', '云浮市', 'W', '445300');
INSERT INTO "COD_CS_CPQZ" VALUES ('241', '450000', '广西', '桂', '南宁市', 'A', '450100');
INSERT INTO "COD_CS_CPQZ" VALUES ('242', '450000', '广西', '桂', '柳州市', 'B', '450200');
INSERT INTO "COD_CS_CPQZ" VALUES ('243', '450000', '广西', '桂', '桂林市', 'C', '450300');
INSERT INTO "COD_CS_CPQZ" VALUES ('244', '450000', '广西', '桂', '梧州市', 'D', '450400');
INSERT INTO "COD_CS_CPQZ" VALUES ('245', '450000', '广西', '桂', '北海市', 'E', '450500');
INSERT INTO "COD_CS_CPQZ" VALUES ('246', '450000', '广西', '桂', '防城港市', 'P', '450600');
INSERT INTO "COD_CS_CPQZ" VALUES ('247', '450000', '广西', '桂', '钦州市', 'N', '450700');
INSERT INTO "COD_CS_CPQZ" VALUES ('248', '450000', '广西', '桂', '贵港市', 'R', '450800');
INSERT INTO "COD_CS_CPQZ" VALUES ('249', '450000', '广西', '桂', '玉林市', 'K', '450900');
INSERT INTO "COD_CS_CPQZ" VALUES ('250', '450000', '广西', '桂', '百色市', 'L', '451000');
INSERT INTO "COD_CS_CPQZ" VALUES ('251', '450000', '广西', '桂', '贺州市', 'J', '451100');
INSERT INTO "COD_CS_CPQZ" VALUES ('252', '450000', '广西', '桂', '河池市', 'M', '451200');
INSERT INTO "COD_CS_CPQZ" VALUES ('253', '450000', '广西', '桂', '来宾市', 'G', '451300');
INSERT INTO "COD_CS_CPQZ" VALUES ('254', '450000', '广西', '桂', '崇左市', 'F', '451400');
INSERT INTO "COD_CS_CPQZ" VALUES ('255', '460000', '海南省', '琼', '海口市', 'A', '460100');
INSERT INTO "COD_CS_CPQZ" VALUES ('256', '460000', '海南省', '琼', '三亚市', 'B', '460200');
INSERT INTO "COD_CS_CPQZ" VALUES ('257', '460000', '海南省', '琼', '洋浦开发区', 'E', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('258', '460000', '海南省', '琼', '五指山市', 'D', '460500');
INSERT INTO "COD_CS_CPQZ" VALUES ('259', '460000', '海南省', '琼', '琼海市', 'C', '460600');
INSERT INTO "COD_CS_CPQZ" VALUES ('260', '500000', '重庆市', '渝', '重庆市', 'A', '500100');
INSERT INTO "COD_CS_CPQZ" VALUES ('262', '500000', '重庆市', '渝', '永川区市', 'C', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('263', '500000', '重庆市', '渝', '万州区', 'F', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('264', '500000', '重庆市', '渝', '涪陵区', 'G', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('265', '500000', '重庆市', '渝', '黔江区', 'H', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('266', '510000', '四川省', '川', '成都市', 'A', '510100');
INSERT INTO "COD_CS_CPQZ" VALUES ('267', '510000', '四川省', '川', '自贡市', 'C', '510300');
INSERT INTO "COD_CS_CPQZ" VALUES ('268', '510000', '四川省', '川', '攀枝花市', 'D', '510400');
INSERT INTO "COD_CS_CPQZ" VALUES ('269', '510000', '四川省', '川', '泸州市', 'E', '510500');
INSERT INTO "COD_CS_CPQZ" VALUES ('270', '510000', '四川省', '川', '德阳市', 'F', '510600');
INSERT INTO "COD_CS_CPQZ" VALUES ('271', '510000', '四川省', '川', '绵阳市', 'B', '510700');
INSERT INTO "COD_CS_CPQZ" VALUES ('272', '510000', '四川省', '川', '广元市', 'H', '510800');
INSERT INTO "COD_CS_CPQZ" VALUES ('273', '510000', '四川省', '川', '遂宁市', 'J', '510900');
INSERT INTO "COD_CS_CPQZ" VALUES ('274', '510000', '四川省', '川', '内江市', 'K', '511000');
INSERT INTO "COD_CS_CPQZ" VALUES ('275', '510000', '四川省', '川', '乐山市', 'L', '511100');
INSERT INTO "COD_CS_CPQZ" VALUES ('276', '510000', '四川省', '川', '南充市', 'R', '511300');
INSERT INTO "COD_CS_CPQZ" VALUES ('277', '510000', '四川省', '川', '眉山市', 'Z', '511400');
INSERT INTO "COD_CS_CPQZ" VALUES ('278', '510000', '四川省', '川', '宜宾市', 'Q', '511500');
INSERT INTO "COD_CS_CPQZ" VALUES ('279', '510000', '四川省', '川', '广安市', 'X', '511600');
INSERT INTO "COD_CS_CPQZ" VALUES ('280', '510000', '四川省', '川', '达川市', 'S', '511700');
INSERT INTO "COD_CS_CPQZ" VALUES ('281', '510000', '四川省', '川', '雅安市', 'T', '511800');
INSERT INTO "COD_CS_CPQZ" VALUES ('282', '510000', '四川省', '川', '巴中市', 'Y', '511900');
INSERT INTO "COD_CS_CPQZ" VALUES ('283', '510000', '四川省', '川', '资阳市', 'M', '512000');
INSERT INTO "COD_CS_CPQZ" VALUES ('286', '510000', '四川省', '川', '阿坝州', 'U', '513200');
INSERT INTO "COD_CS_CPQZ" VALUES ('287', '510000', '四川省', '川', '甘孜州', 'V', '513300');
INSERT INTO "COD_CS_CPQZ" VALUES ('288', '510000', '四川省', '川', '凉山州', 'W', '513400');
INSERT INTO "COD_CS_CPQZ" VALUES ('289', '520000', '贵州省', '贵', '贵阳市', 'A', '520100');
INSERT INTO "COD_CS_CPQZ" VALUES ('290', '520000', '贵州省', '贵', '六盘水市', 'B', '520200');
INSERT INTO "COD_CS_CPQZ" VALUES ('291', '520000', '贵州省', '贵', '遵义市', 'C', '520300');
INSERT INTO "COD_CS_CPQZ" VALUES ('292', '520000', '贵州省', '贵', '安顺市', 'G', '520400');
INSERT INTO "COD_CS_CPQZ" VALUES ('293', '520000', '贵州省', '贵', '铜仁地区', 'D', '522200');
INSERT INTO "COD_CS_CPQZ" VALUES ('294', '520000', '贵州省', '贵', '黔西南州', 'E', '522300');
INSERT INTO "COD_CS_CPQZ" VALUES ('295', '520000', '贵州省', '贵', '毕节地区', 'F', '522400');
INSERT INTO "COD_CS_CPQZ" VALUES ('296', '520000', '贵州省', '贵', '黔东南州', 'H', '522600');
INSERT INTO "COD_CS_CPQZ" VALUES ('297', '520000', '贵州省', '贵', '黔南州', 'J', '522700');
INSERT INTO "COD_CS_CPQZ" VALUES ('298', '530000', '云南省', '云', '昆明市', 'A', '530100');
INSERT INTO "COD_CS_CPQZ" VALUES ('299', '530000', '云南省', '云', '普洱市', 'J', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('300', '530000', '云南省', '云', '曲靖市', 'D', '530300');
INSERT INTO "COD_CS_CPQZ" VALUES ('301', '530000', '云南省', '云', '玉溪市', 'F', '530400');
INSERT INTO "COD_CS_CPQZ" VALUES ('302', '530000', '云南省', '云', '保山市', 'M', '530500');
INSERT INTO "COD_CS_CPQZ" VALUES ('303', '530000', '云南省', '云', '昭通市', 'C', '530600');
INSERT INTO "COD_CS_CPQZ" VALUES ('304', '530000', '云南省', '云', '丽江市', 'P', '530700');
INSERT INTO "COD_CS_CPQZ" VALUES ('305', '530000', '云南省', '云', '临沧市', 'S', '530900');
INSERT INTO "COD_CS_CPQZ" VALUES ('306', '530000', '云南省', '云', '楚雄州', 'E', '532300');
INSERT INTO "COD_CS_CPQZ" VALUES ('307', '530000', '云南省', '云', '红河州', 'G', '532500');
INSERT INTO "COD_CS_CPQZ" VALUES ('308', '530000', '云南省', '云', '文山州', 'H', '532600');
INSERT INTO "COD_CS_CPQZ" VALUES ('309', '530000', '云南省', '云', '西双版纳州', 'K', '532800');
INSERT INTO "COD_CS_CPQZ" VALUES ('310', '530000', '云南省', '云', '大理州', 'L', '532900');
INSERT INTO "COD_CS_CPQZ" VALUES ('311', '530000', '云南省', '云', '德宏州', 'N', '533100');
INSERT INTO "COD_CS_CPQZ" VALUES ('312', '530000', '云南省', '云', '怒江州', 'Q', '533300');
INSERT INTO "COD_CS_CPQZ" VALUES ('313', '530000', '云南省', '云', '迪庆州', 'R', '533400');
INSERT INTO "COD_CS_CPQZ" VALUES ('314', '540000', '西藏', '藏', '拉萨市', 'A', '540100');
INSERT INTO "COD_CS_CPQZ" VALUES ('315', '540000', '西藏', '藏', '昌都地区', 'B', '542100');
INSERT INTO "COD_CS_CPQZ" VALUES ('316', '540000', '西藏', '藏', '山南地区', 'C', '542200');
INSERT INTO "COD_CS_CPQZ" VALUES ('317', '540000', '西藏', '藏', '日喀则地区', 'D', '542300');
INSERT INTO "COD_CS_CPQZ" VALUES ('318', '540000', '西藏', '藏', '那曲地区', 'E', '542400');
INSERT INTO "COD_CS_CPQZ" VALUES ('319', '540000', '西藏', '藏', '阿里地区', 'F', '542500');
INSERT INTO "COD_CS_CPQZ" VALUES ('320', '540000', '西藏', '藏', '林芝地区', 'G', '542600');
INSERT INTO "COD_CS_CPQZ" VALUES ('321', '610000', '陕西省', '陕', '西安市', 'A', '610100');
INSERT INTO "COD_CS_CPQZ" VALUES ('322', '610000', '陕西省', '陕', '铜川市', 'B', '610200');
INSERT INTO "COD_CS_CPQZ" VALUES ('323', '610000', '陕西省', '陕', '宝鸡市', 'C', '610300');
INSERT INTO "COD_CS_CPQZ" VALUES ('324', '610000', '陕西省', '陕', '咸阳市', 'D', '610400');
INSERT INTO "COD_CS_CPQZ" VALUES ('325', '610000', '陕西省', '陕', '渭南市', 'E', '610500');
INSERT INTO "COD_CS_CPQZ" VALUES ('326', '610000', '陕西省', '陕', '延安市', 'J', '610600');
INSERT INTO "COD_CS_CPQZ" VALUES ('327', '610000', '陕西省', '陕', '汉中市', 'F', '610700');
INSERT INTO "COD_CS_CPQZ" VALUES ('328', '610000', '陕西省', '陕', '榆林市', 'K', '610800');
INSERT INTO "COD_CS_CPQZ" VALUES ('329', '610000', '陕西省', '陕', '安康市', 'G', '610900');
INSERT INTO "COD_CS_CPQZ" VALUES ('330', '610000', '陕西省', '陕', '商洛市', 'H', '611000');
INSERT INTO "COD_CS_CPQZ" VALUES ('332', '620000', '甘肃省', '甘', '兰州市', 'A', '620100');
INSERT INTO "COD_CS_CPQZ" VALUES ('333', '620000', '甘肃省', '甘', '嘉峪关市', 'B', '620200');
INSERT INTO "COD_CS_CPQZ" VALUES ('334', '620000', '甘肃省', '甘', '金昌市', 'C', '620300');
INSERT INTO "COD_CS_CPQZ" VALUES ('335', '620000', '甘肃省', '甘', '白银市', 'D', '620400');
INSERT INTO "COD_CS_CPQZ" VALUES ('336', '620000', '甘肃省', '甘', '天水市', 'E', '620500');
INSERT INTO "COD_CS_CPQZ" VALUES ('337', '620000', '甘肃省', '甘', '武威市', 'H', '620600');
INSERT INTO "COD_CS_CPQZ" VALUES ('338', '620000', '甘肃省', '甘', '张掖市', 'G', '620700');
INSERT INTO "COD_CS_CPQZ" VALUES ('339', '620000', '甘肃省', '甘', '平凉市', 'L', '620800');
INSERT INTO "COD_CS_CPQZ" VALUES ('340', '620000', '甘肃省', '甘', '酒泉市', 'F', '620900');
INSERT INTO "COD_CS_CPQZ" VALUES ('341', '620000', '甘肃省', '甘', '庆阳市', 'M', '621000');
INSERT INTO "COD_CS_CPQZ" VALUES ('342', '620000', '甘肃省', '甘', '定西市', 'J', '621100');
INSERT INTO "COD_CS_CPQZ" VALUES ('343', '620000', '甘肃省', '甘', '陇南市', 'K', '621200');
INSERT INTO "COD_CS_CPQZ" VALUES ('344', '620000', '甘肃省', '甘', '临夏州', 'N', '622900');
INSERT INTO "COD_CS_CPQZ" VALUES ('345', '620000', '甘肃省', '甘', '甘南州', 'P', '623000');
INSERT INTO "COD_CS_CPQZ" VALUES ('346', '630000', '青海省', '青', '西宁市', 'A', '630100');
INSERT INTO "COD_CS_CPQZ" VALUES ('347', '630000', '青海省', '青', '海南州', 'H', '630300');
INSERT INTO "COD_CS_CPQZ" VALUES ('348', '630000', '青海省', '青', '海东地区', 'B', '632100');
INSERT INTO "COD_CS_CPQZ" VALUES ('349', '630000', '青海省', '青', '海北州', 'C', '632200');
INSERT INTO "COD_CS_CPQZ" VALUES ('350', '630000', '青海省', '青', '黄南州', 'D', '632300');
INSERT INTO "COD_CS_CPQZ" VALUES ('352', '630000', '青海省', '青', '果洛州', 'F', '632600');
INSERT INTO "COD_CS_CPQZ" VALUES ('353', '630000', '青海省', '青', '玉树州', 'G', '632700');
INSERT INTO "COD_CS_CPQZ" VALUES ('354', '640000', '宁夏', '宁', '银川市', 'A', '640100');
INSERT INTO "COD_CS_CPQZ" VALUES ('355', '640000', '宁夏', '宁', '石嘴山市', 'B', '640200');
INSERT INTO "COD_CS_CPQZ" VALUES ('356', '640000', '宁夏', '宁', '吴忠市', 'C', '640300');
INSERT INTO "COD_CS_CPQZ" VALUES ('357', '640000', '宁夏', '宁', '固原市', 'D', '640400');
INSERT INTO "COD_CS_CPQZ" VALUES ('358', '640000', '宁夏', '宁', '中卫市', 'E', '640500');
INSERT INTO "COD_CS_CPQZ" VALUES ('359', '650000', '新疆', '新', '克拉玛依', 'J', '650200');
INSERT INTO "COD_CS_CPQZ" VALUES ('360', '650000', '新疆', '新', '乌鲁木齐市', 'A', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('361', '650000', '新疆', '新', '奎屯', 'D', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('362', '650000', '新疆', '新', '吐鲁番', 'K', '652100');
INSERT INTO "COD_CS_CPQZ" VALUES ('363', '650000', '新疆', '新', '哈密', 'L', '652200');
INSERT INTO "COD_CS_CPQZ" VALUES ('364', '650000', '新疆', '新', '昌吉', 'B', '652300');
INSERT INTO "COD_CS_CPQZ" VALUES ('365', '650000', '新疆', '新', '博尔塔拉', 'E', '652700');
INSERT INTO "COD_CS_CPQZ" VALUES ('366', '650000', '新疆', '新', '巴音郭楞', 'M', '652800');
INSERT INTO "COD_CS_CPQZ" VALUES ('367', '650000', '新疆', '新', '阿克苏', 'N', '652900');
INSERT INTO "COD_CS_CPQZ" VALUES ('368', '650000', '新疆', '新', '克孜勒苏', 'P', '653000');
INSERT INTO "COD_CS_CPQZ" VALUES ('369', '650000', '新疆', '新', '喀什', 'Q', '653100');
INSERT INTO "COD_CS_CPQZ" VALUES ('370', '650000', '新疆', '新', '和田', 'R', '653200');
INSERT INTO "COD_CS_CPQZ" VALUES ('371', '650000', '新疆', '新', '伊犁', 'F', '654000');
INSERT INTO "COD_CS_CPQZ" VALUES ('372', '650000', '新疆', '新', '塔城', 'G', '654200');
INSERT INTO "COD_CS_CPQZ" VALUES ('373', '650000', '新疆', '新', '阿勒泰', 'H', '654300');
INSERT INTO "COD_CS_CPQZ" VALUES ('374', '650000', '新疆', '新', '自治区直辖县级行政单位', 'C', '659001');
INSERT INTO "COD_CS_CPQZ" VALUES ('375', '310000', '上海市', '沪', '上海市', 'A', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('376', '510000', '四川省', '川', '达州市', 'S', '513400');
INSERT INTO "COD_CS_CPQZ" VALUES ('377', '46000', '海南省', '琼', '三沙市', 'C', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('378', '46000', '海南省', '琼', '文昌市', 'C', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('379', '46000', '海南省', '琼', '万宁市', 'C', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('380', '46000', '海南省', '琼', '定安县', 'C', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('381', '46000', '海南省', '琼', '屯昌县', 'C', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('382', '46000', '海南省', '琼', '澄迈县', 'C', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('383', '46000', '海南省', '琼', '临高县', 'C', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('384', '46000', '海南省', '琼', '东方市', 'D', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('385', '46000', '海南省', '琼', '白沙县', 'D', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('386', '46000', '海南省', '琼', '昌江县', 'D', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('387', '46000', '海南省', '琼', '乐东县', 'D', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('388', '46000', '海南省', '琼', '陵水县', 'D', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('389', '46000', '海南省', '琼', '保亭县', 'D', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('390', '46000', '海南省', '琼', '琼中县', 'D', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('391', '46000', '海南省', '琼', '儋州市', 'F', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('11', '130000', '河北省', '冀', '石家庄市', 'A', '130100');
INSERT INTO "COD_CS_CPQZ" VALUES ('1', '110000', '北京市', '京', '北京市', 'A', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('7', '120000', '天津市', '津', '天津市', 'A', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('12', '130000', '河北省', '冀', '唐山市', 'B', '130200');
INSERT INTO "COD_CS_CPQZ" VALUES ('13', '130000', '河北省', '冀', '秦皇岛市', 'C', '130300');
INSERT INTO "COD_CS_CPQZ" VALUES ('14', '130000', '河北省', '冀', '邯郸市', 'D', '130400');
INSERT INTO "COD_CS_CPQZ" VALUES ('15', '130000', '河北省', '冀', '邢台市', 'E', '130500');
INSERT INTO "COD_CS_CPQZ" VALUES ('16', '130000', '河北省', '冀', '保定市', 'F', '130600');
INSERT INTO "COD_CS_CPQZ" VALUES ('17', '130000', '河北省', '冀', '张家口市', 'G', '130700');
INSERT INTO "COD_CS_CPQZ" VALUES ('18', '130000', '河北省', '冀', '承德市', 'H', '130800');
INSERT INTO "COD_CS_CPQZ" VALUES ('19', '130000', '河北省', '冀', '沧州市', 'J', '130900');
INSERT INTO "COD_CS_CPQZ" VALUES ('21', '130000', '河北省', '冀', '廊坊市', 'R', '131000');
INSERT INTO "COD_CS_CPQZ" VALUES ('22', '130000', '河北省', '冀', '衡水市', 'T', '131100');
INSERT INTO "COD_CS_CPQZ" VALUES ('23', '140000', '山西省', '晋', '太原市', 'A', '140100');
INSERT INTO "COD_CS_CPQZ" VALUES ('24', '140000', '山西省', '晋', '大同市', 'B', '140200');
INSERT INTO "COD_CS_CPQZ" VALUES ('25', '140000', '山西省', '晋', '阳泉市', 'C', '140300');
INSERT INTO "COD_CS_CPQZ" VALUES ('26', '140000', '山西省', '晋', '长治市', 'D', '140400');
INSERT INTO "COD_CS_CPQZ" VALUES ('27', '140000', '山西省', '晋', '晋城市', 'E', '140500');
INSERT INTO "COD_CS_CPQZ" VALUES ('28', '140000', '山西省', '晋', '朔州市', 'F', '140600');
INSERT INTO "COD_CS_CPQZ" VALUES ('29', '140000', '山西省', '晋', '雁北市', 'G', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('30', '140000', '山西省', '晋', '晋中市', 'K', '140700');
INSERT INTO "COD_CS_CPQZ" VALUES ('31', '140000', '山西省', '晋', '运城市', 'M', '140800');
INSERT INTO "COD_CS_CPQZ" VALUES ('32', '140000', '山西省', '晋', '忻州市', 'H', '140900');
INSERT INTO "COD_CS_CPQZ" VALUES ('33', '140000', '山西省', '晋', '临汾市', 'L', '141000');
INSERT INTO "COD_CS_CPQZ" VALUES ('34', '140000', '山西省', '晋', '吕梁市', 'J', '141100');
INSERT INTO "COD_CS_CPQZ" VALUES ('35', '150000', '内蒙古', '蒙', '呼和浩特市', 'A', '150100');
INSERT INTO "COD_CS_CPQZ" VALUES ('36', '150000', '内蒙古', '蒙', '包头市', 'B', '150200');
INSERT INTO "COD_CS_CPQZ" VALUES ('37', '150000', '内蒙古', '蒙', '乌海市', 'C', '150300');
INSERT INTO "COD_CS_CPQZ" VALUES ('38', '150000', '内蒙古', '蒙', '赤峰市', 'D', '150400');
INSERT INTO "COD_CS_CPQZ" VALUES ('39', '150000', '内蒙古', '蒙', '通辽市', 'G', '150500');
INSERT INTO "COD_CS_CPQZ" VALUES ('40', '150000', '内蒙古', '蒙', '鄂尔多斯市', 'K', '150600');
INSERT INTO "COD_CS_CPQZ" VALUES ('41', '150000', '内蒙古', '蒙', '呼伦贝尔市', 'E', '150700');
INSERT INTO "COD_CS_CPQZ" VALUES ('42', '150000', '内蒙古', '蒙', '巴彦淖尔市', 'L', '150800');
INSERT INTO "COD_CS_CPQZ" VALUES ('43', '150000', '内蒙古', '蒙', '乌兰察布市', 'J', '150900');
INSERT INTO "COD_CS_CPQZ" VALUES ('44', '150000', '内蒙古', '蒙', '兴安', 'F', '152200');
INSERT INTO "COD_CS_CPQZ" VALUES ('45', '150000', '内蒙古', '蒙', '锡林郭勒', 'H', '152500');
INSERT INTO "COD_CS_CPQZ" VALUES ('46', '150000', '内蒙古', '蒙', '阿拉善', 'M', '152900');
INSERT INTO "COD_CS_CPQZ" VALUES ('47', '210000', '辽宁省', '辽', '沈阳市', 'A', '210100');
INSERT INTO "COD_CS_CPQZ" VALUES ('48', '210000', '辽宁省', '辽', '大连市', 'B', '210200');
INSERT INTO "COD_CS_CPQZ" VALUES ('49', '210000', '辽宁省', '辽', '鞍山市', 'C', '210300');
INSERT INTO "COD_CS_CPQZ" VALUES ('50', '210000', '辽宁省', '辽', '抚顺市', 'D', '210400');
INSERT INTO "COD_CS_CPQZ" VALUES ('51', '210000', '辽宁省', '辽', '本溪市', 'E', '210500');
INSERT INTO "COD_CS_CPQZ" VALUES ('52', '210000', '辽宁省', '辽', '丹东市', 'F', '210600');
INSERT INTO "COD_CS_CPQZ" VALUES ('53', '210000', '辽宁省', '辽', '锦州市', 'G', '210700');
INSERT INTO "COD_CS_CPQZ" VALUES ('54', '210000', '辽宁省', '辽', '营口市', 'H', '210800');
INSERT INTO "COD_CS_CPQZ" VALUES ('55', '210000', '辽宁省', '辽', '阜新市', 'J', '210900');
INSERT INTO "COD_CS_CPQZ" VALUES ('56', '210000', '辽宁省', '辽', '辽阳市', 'K', '211000');
INSERT INTO "COD_CS_CPQZ" VALUES ('57', '210000', '辽宁省', '辽', '盘锦市', 'L', '211100');
INSERT INTO "COD_CS_CPQZ" VALUES ('58', '210000', '辽宁省', '辽', '铁岭市', 'M', '211200');
INSERT INTO "COD_CS_CPQZ" VALUES ('59', '210000', '辽宁省', '辽', '朝阳市', 'N', '211300');
INSERT INTO "COD_CS_CPQZ" VALUES ('60', '210000', '辽宁省', '辽', '葫芦岛市', 'P', '211400');
INSERT INTO "COD_CS_CPQZ" VALUES ('61', '220000', '吉林省', '吉', '长春市', 'A', '220100');
INSERT INTO "COD_CS_CPQZ" VALUES ('62', '220000', '吉林省', '吉', '吉林市', 'B', '220200');
INSERT INTO "COD_CS_CPQZ" VALUES ('63', '220000', '吉林省', '吉', '四平市', 'C', '220300');
INSERT INTO "COD_CS_CPQZ" VALUES ('64', '220000', '吉林省', '吉', '辽源市', 'D', '220400');
INSERT INTO "COD_CS_CPQZ" VALUES ('65', '220000', '吉林省', '吉', '通化市', 'E', '220500');
INSERT INTO "COD_CS_CPQZ" VALUES ('66', '220000', '吉林省', '吉', '白山市', 'F', '220600');
INSERT INTO "COD_CS_CPQZ" VALUES ('67', '220000', '吉林省', '吉', '松原市', 'J', '220700');
INSERT INTO "COD_CS_CPQZ" VALUES ('68', '220000', '吉林省', '吉', '白城市', 'G', '220800');
INSERT INTO "COD_CS_CPQZ" VALUES ('69', '220000', '吉林省', '吉', '延边州', 'H', '222400');
INSERT INTO "COD_CS_CPQZ" VALUES ('70', '230000', '黑龙江省', '黑', '哈尔滨市', 'A', '230100');
INSERT INTO "COD_CS_CPQZ" VALUES ('71', '230000', '黑龙江省', '黑', '齐齐哈尔市', 'B', '230200');
INSERT INTO "COD_CS_CPQZ" VALUES ('72', '230000', '黑龙江省', '黑', '鸡西市', 'G', '230300');
INSERT INTO "COD_CS_CPQZ" VALUES ('73', '230000', '黑龙江省', '黑', '鹤岗市', 'H', '230400');
INSERT INTO "COD_CS_CPQZ" VALUES ('74', '230000', '黑龙江省', '黑', '双鸭山市', 'J', '230500');
INSERT INTO "COD_CS_CPQZ" VALUES ('75', '230000', '黑龙江省', '黑', '大庆市', 'E', '230600');
INSERT INTO "COD_CS_CPQZ" VALUES ('76', '230000', '黑龙江省', '黑', '伊春市', 'F', '230700');
INSERT INTO "COD_CS_CPQZ" VALUES ('77', '230000', '黑龙江省', '黑', '佳木斯市', 'D', '230800');
INSERT INTO "COD_CS_CPQZ" VALUES ('78', '230000', '黑龙江省', '黑', '七台河市', 'K', '230900');
INSERT INTO "COD_CS_CPQZ" VALUES ('79', '230000', '黑龙江省', '黑', '牡丹江市', 'C', '231000');
INSERT INTO "COD_CS_CPQZ" VALUES ('80', '230000', '黑龙江省', '黑', '黑河市', 'N', '231100');
INSERT INTO "COD_CS_CPQZ" VALUES ('81', '230000', '黑龙江省', '黑', '绥化市', 'M', '231200');
INSERT INTO "COD_CS_CPQZ" VALUES ('82', '230000', '黑龙江省', '黑', '松花江市', 'L', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('83', '230000', '黑龙江省', '黑', '农恳市', 'R', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('84', '230000', '黑龙江省', '黑', '大兴安岭区', 'P', '232700');
INSERT INTO "COD_CS_CPQZ" VALUES ('86', '320000', '江苏省', '苏', '南京市', 'A', '320100');
INSERT INTO "COD_CS_CPQZ" VALUES ('87', '320000', '江苏省', '苏', '无锡市', 'B', '320200');
INSERT INTO "COD_CS_CPQZ" VALUES ('88', '320000', '江苏省', '苏', '徐州市', 'C', '320300');
INSERT INTO "COD_CS_CPQZ" VALUES ('89', '320000', '江苏省', '苏', '常州市', 'D', '320400');
INSERT INTO "COD_CS_CPQZ" VALUES ('90', '320000', '江苏省', '苏', '苏州市', 'E', '320500');
INSERT INTO "COD_CS_CPQZ" VALUES ('91', '320000', '江苏省', '苏', '南通市', 'F', '320600');
INSERT INTO "COD_CS_CPQZ" VALUES ('92', '320000', '江苏省', '苏', '连云港市', 'G', '320700');
INSERT INTO "COD_CS_CPQZ" VALUES ('93', '320000', '江苏省', '苏', '淮安市', 'H', '320800');
INSERT INTO "COD_CS_CPQZ" VALUES ('94', '320000', '江苏省', '苏', '盐城市', 'J', '320900');
INSERT INTO "COD_CS_CPQZ" VALUES ('95', '320000', '江苏省', '苏', '扬州市', 'K', '321000');
INSERT INTO "COD_CS_CPQZ" VALUES ('96', '320000', '江苏省', '苏', '镇江市', 'L', '321100');
INSERT INTO "COD_CS_CPQZ" VALUES ('97', '320000', '江苏省', '苏', '泰州市', 'M', '321200');
INSERT INTO "COD_CS_CPQZ" VALUES ('98', '320000', '江苏省', '苏', '宿迁市', 'N', '321300');
INSERT INTO "COD_CS_CPQZ" VALUES ('99', '330000', '浙江省', '浙', '杭州市', 'A', '330100');
INSERT INTO "COD_CS_CPQZ" VALUES ('100', '330000', '浙江省', '浙', '宁波市', 'B', '330200');
INSERT INTO "COD_CS_CPQZ" VALUES ('101', '330000', '浙江省', '浙', '温州市', 'C', '330300');
INSERT INTO "COD_CS_CPQZ" VALUES ('102', '330000', '浙江省', '浙', '嘉兴市', 'F', '330400');
INSERT INTO "COD_CS_CPQZ" VALUES ('103', '330000', '浙江省', '浙', '湖州市', 'E', '330500');
INSERT INTO "COD_CS_CPQZ" VALUES ('104', '330000', '浙江省', '浙', '绍兴市', 'D', '330600');
INSERT INTO "COD_CS_CPQZ" VALUES ('105', '330000', '浙江省', '浙', '金华市', 'G', '330700');
INSERT INTO "COD_CS_CPQZ" VALUES ('106', '330000', '浙江省', '浙', '衢州市', 'H', '330800');
INSERT INTO "COD_CS_CPQZ" VALUES ('107', '330000', '浙江省', '浙', '舟山市', 'L', '330900');
INSERT INTO "COD_CS_CPQZ" VALUES ('108', '330000', '浙江省', '浙', '台州市', 'J', '331000');
INSERT INTO "COD_CS_CPQZ" VALUES ('109', '330000', '浙江省', '浙', '丽水市', 'K', '331100');
INSERT INTO "COD_CS_CPQZ" VALUES ('110', '340000', '安徽省', '皖', '合肥市', 'A', '340100');
INSERT INTO "COD_CS_CPQZ" VALUES ('111', '340000', '安徽省', '皖', '芜湖市', 'B', '340200');
INSERT INTO "COD_CS_CPQZ" VALUES ('112', '340000', '安徽省', '皖', '蚌埠市', 'C', '340300');
INSERT INTO "COD_CS_CPQZ" VALUES ('113', '340000', '安徽省', '皖', '淮南市', 'D', '340400');
INSERT INTO "COD_CS_CPQZ" VALUES ('114', '340000', '安徽省', '皖', '马鞍山市', 'E', '340500');
INSERT INTO "COD_CS_CPQZ" VALUES ('115', '340000', '安徽省', '皖', '淮北市', 'F', '340600');
INSERT INTO "COD_CS_CPQZ" VALUES ('116', '340000', '安徽省', '皖', '铜陵市', 'G', '340700');
INSERT INTO "COD_CS_CPQZ" VALUES ('117', '340000', '安徽省', '皖', '安庆市', 'H', '340800');
INSERT INTO "COD_CS_CPQZ" VALUES ('118', '340000', '安徽省', '皖', '黄山市', 'J', '341000');
INSERT INTO "COD_CS_CPQZ" VALUES ('119', '340000', '安徽省', '皖', '滁州市', 'M', '341100');
INSERT INTO "COD_CS_CPQZ" VALUES ('120', '340000', '安徽省', '皖', '阜阳市', 'K', '341200');
INSERT INTO "COD_CS_CPQZ" VALUES ('121', '340000', '安徽省', '皖', '宿州市', 'L', '341300');
INSERT INTO "COD_CS_CPQZ" VALUES ('122', '340000', '安徽省', '皖', '巢湖市', 'Q', '341400');
INSERT INTO "COD_CS_CPQZ" VALUES ('123', '340000', '安徽省', '皖', '六安市', 'N', '341500');
INSERT INTO "COD_CS_CPQZ" VALUES ('124', '340000', '安徽省', '皖', '亳州市', 'S', '341600');
INSERT INTO "COD_CS_CPQZ" VALUES ('125', '340000', '安徽省', '皖', '池州市', 'R', '341700');
INSERT INTO "COD_CS_CPQZ" VALUES ('126', '340000', '安徽省', '皖', '宣城市', 'P', '341800');
INSERT INTO "COD_CS_CPQZ" VALUES ('127', '350000', '福建省', '闽', '福州市', 'A', '350100');
INSERT INTO "COD_CS_CPQZ" VALUES ('128', '350000', '福建省', '闽', '厦门市', 'D', '350200');
INSERT INTO "COD_CS_CPQZ" VALUES ('129', '350000', '福建省', '闽', '莆田市', 'B', '350300');
INSERT INTO "COD_CS_CPQZ" VALUES ('130', '350000', '福建省', '闽', '三明市', 'G', '350400');
INSERT INTO "COD_CS_CPQZ" VALUES ('131', '350000', '福建省', '闽', '泉州市', 'C', '350500');
INSERT INTO "COD_CS_CPQZ" VALUES ('132', '350000', '福建省', '闽', '漳州市', 'E', '350600');
INSERT INTO "COD_CS_CPQZ" VALUES ('133', '350000', '福建省', '闽', '南平市', 'H', '350700');
INSERT INTO "COD_CS_CPQZ" VALUES ('134', '350000', '福建省', '闽', '龙岩市', 'F', '350800');
INSERT INTO "COD_CS_CPQZ" VALUES ('135', '350000', '福建省', '闽', '宁德市', 'J', '350900');
INSERT INTO "COD_CS_CPQZ" VALUES ('136', '350000', '福建省', '闽', '省直系统', 'K', null);
INSERT INTO "COD_CS_CPQZ" VALUES ('137', '360000', '江西省', '赣', '南昌市', 'A', '360100');
INSERT INTO "COD_CS_CPQZ" VALUES ('138', '360000', '江西省', '赣', '南昌市市', 'M', '360100');
INSERT INTO "COD_CS_CPQZ" VALUES ('139', '360000', '江西省', '赣', '景德镇市', 'H', '360200');
INSERT INTO "COD_CS_CPQZ" VALUES ('140', '360000', '江西省', '赣', '萍乡市', 'J', '360300');
INSERT INTO "COD_CS_CPQZ" VALUES ('141', '360000', '江西省', '赣', '九江市', 'G', '360400');
INSERT INTO "COD_CS_CPQZ" VALUES ('142', '360000', '江西省', '赣', '新余市', 'K', '360500');
INSERT INTO "COD_CS_CPQZ" VALUES ('143', '360000', '江西省', '赣', '鹰潭市', 'L', '360600');
INSERT INTO "COD_CS_CPQZ" VALUES ('144', '360000', '江西省', '赣', '赣州市', 'B', '360700');
INSERT INTO "COD_CS_CPQZ" VALUES ('145', '360000', '江西省', '赣', '吉安市', 'D', '360800');
INSERT INTO "COD_CS_CPQZ" VALUES ('146', '360000', '江西省', '赣', '宜春市', 'C', '360900');
INSERT INTO "COD_CS_CPQZ" VALUES ('147', '360000', '江西省', '赣', '抚州市', 'F', '361000');
INSERT INTO "COD_CS_CPQZ" VALUES ('148', '360000', '江西省', '赣', '上饶市', 'E', '361100');
INSERT INTO "COD_CS_CPQZ" VALUES ('149', '370000', '山东省', '鲁', '济南市', 'A', '370100');
INSERT INTO "COD_CS_CPQZ" VALUES ('150', '370000', '山东省', '鲁', '青岛市', 'B', '370200');
INSERT INTO "COD_CS_CPQZ" VALUES ('152', '370000', '山东省', '鲁', '淄博市', 'C', '370300');
INSERT INTO "COD_CS_CPQZ" VALUES ('153', '370000', '山东省', '鲁', '枣庄市', 'D', '370400');
INSERT INTO "COD_CS_CPQZ" VALUES ('154', '370000', '山东省', '鲁', '东营市', 'E', '370500');
INSERT INTO "COD_CS_CPQZ" VALUES ('155', '370000', '山东省', '鲁', '烟台市', 'F', '370600');
INSERT INTO "COD_CS_CPQZ" VALUES ('156', '370000', '山东省', '鲁', '潍坊市', 'G', '370700');
INSERT INTO "COD_CS_CPQZ" VALUES ('157', '370000', '山东省', '鲁', '潍坊市市', 'V', '370700');
INSERT INTO "COD_CS_CPQZ" VALUES ('158', '370000', '山东省', '鲁', '济宁市', 'H', '370800');
INSERT INTO "COD_CS_CPQZ" VALUES ('159', '370000', '山东省', '鲁', '泰安市', 'J', '370900');
INSERT INTO "COD_CS_CPQZ" VALUES ('160', '370000', '山东省', '鲁', '威海市', 'K', '371000');
INSERT INTO "COD_CS_CPQZ" VALUES ('161', '370000', '山东省', '鲁', '日照市', 'L', '371100');
INSERT INTO "COD_CS_CPQZ" VALUES ('162', '370000', '山东省', '鲁', '莱芜市', 'S', '371200');
INSERT INTO "COD_CS_CPQZ" VALUES ('163', '370000', '山东省', '鲁', '临沂市', 'Q', '371300');
INSERT INTO "COD_CS_CPQZ" VALUES ('164', '370000', '山东省', '鲁', '德州市', 'N', '371400');
INSERT INTO "COD_CS_CPQZ" VALUES ('165', '370000', '山东省', '鲁', '聊城市', 'P', '371500');
INSERT INTO "COD_CS_CPQZ" VALUES ('166', '370000', '山东省', '鲁', '滨州市', 'M', '371600');
INSERT INTO "COD_CS_CPQZ" VALUES ('167', '370000', '山东省', '鲁', '菏泽市', 'R', '371700');
INSERT INTO "COD_CS_CPQZ" VALUES ('168', '410000', '河南省', '豫', '郑州市', 'A', '410100');
INSERT INTO "COD_CS_CPQZ" VALUES ('169', '410000', '河南省', '豫', '开封市', 'B', '410200');
INSERT INTO "COD_CS_CPQZ" VALUES ('170', '410000', '河南省', '豫', '洛阳市', 'C', '410300');
INSERT INTO "COD_CS_CPQZ" VALUES ('171', '410000', '河南省', '豫', '平顶山市', 'D', '410400');
INSERT INTO "COD_CS_CPQZ" VALUES ('172', '410000', '河南省', '豫', '安阳市', 'E', '410500');
INSERT INTO "COD_CS_CPQZ" VALUES ('173', '410000', '河南省', '豫', '鹤壁市', 'F', '410600');
INSERT INTO "COD_CS_CPQZ" VALUES ('174', '410000', '河南省', '豫', '新乡市', 'G', '410700');
INSERT INTO "COD_CS_CPQZ" VALUES ('175', '410000', '河南省', '豫', '焦作市', 'H', '410800');
INSERT INTO "COD_CS_CPQZ" VALUES ('176', '410000', '河南省', '豫', '濮阳市', 'J', '410900');
INSERT INTO "COD_CS_CPQZ" VALUES ('177', '410000', '河南省', '豫', '许昌市', 'K', '411000');
INSERT INTO "COD_CS_CPQZ" VALUES ('178', '410000', '河南省', '豫', '漯河市', 'L', '411100');
INSERT INTO "COD_CS_CPQZ" VALUES ('179', '410000', '河南省', '豫', '三门峡市', 'M', '411200');
INSERT INTO "COD_CS_CPQZ" VALUES ('180', '410000', '河南省', '豫', '南阳市', 'R', '411300');
INSERT INTO "COD_CS_CPQZ" VALUES ('181', '410000', '河南省', '豫', '商丘市', 'N', '411400');
INSERT INTO "COD_CS_CPQZ" VALUES ('182', '410000', '河南省', '豫', '信阳市', 'S', '411500');
INSERT INTO "COD_CS_CPQZ" VALUES ('183', '410000', '河南省', '豫', '周口市', 'P', '411600');
INSERT INTO "COD_CS_CPQZ" VALUES ('184', '410000', '河南省', '豫', '驻马店市', 'Q', '411700');

-- ----------------------------
-- Indexes structure for table COD_CS_CPQZ
-- ----------------------------

-- ----------------------------
-- Checks structure for table COD_CS_CPQZ
-- ----------------------------
ALTER TABLE "COD_CS_CPQZ" ADD CHECK ("ID" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table COD_CS_CPQZ
-- ----------------------------
ALTER TABLE "COD_CS_CPQZ" ADD PRIMARY KEY ("ID");