全国五级地址库包含省市县镇村资源-CSDN下载

共2个文件

sql：1个

mdb：1个

MySQL

需积分: 50 134 浏览量 2019-03-12 17:08:54 上传评论收藏 11.15MB 7Z 举报

资源详情

资源评论

资源推荐

收起资源包目录

新建文件夹.7z （2个子文件）

新建文件夹

五级地址库.mdb 67.47MB

pcctv.sql 70.6MB

/* Navicat Premium Data Transfer Source Server : 云桌面数据库 Source Server Type : MySQL Source Server Version : 50625 Source Host : 172.16.102.234:3306 Source Schema : imis Target Server Type : MySQL Target Server Version : 50625 File Encoding : 65001 Date: 12/03/2019 17:00:25 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for pcctv -- ---------------------------- DROP TABLE IF EXISTS `pcctv`; CREATE TABLE `pcctv` ( `pid` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `id` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pcctvlevel` tinyint(4) NULL DEFAULT NULL, `pcctvname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `classification` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of pcctv -- ---------------------------- INSERT INTO `pcctv` VALUES (NULL, '000000000000', 0, '中华人民共和国', '000', NULL); INSERT INTO `pcctv` VALUES ('000000000000', '110000000000', 1, '北京市', '000', NULL); INSERT INTO `pcctv` VALUES ('110000000000', '110100000000', 2, '市辖区', '000', NULL); INSERT INTO `pcctv` VALUES ('110100000000', '110101000000', 3, '东城区', '000', NULL); INSERT INTO `pcctv` VALUES ('110101000000', '110101001000', 4, '东华门街道办事处', '000', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001001', 5, '多福巷社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001002', 5, '银闸社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001005', 5, '东厂社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001006', 5, '智德社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001007', 5, '南池子社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001008', 5, '黄图岗社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001009', 5, '灯市口社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001010', 5, '正义路社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001011', 5, '甘雨社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001013', 5, '台基厂社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001014', 5, '韶九社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101001000', '110101001015', 5, '王府井社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101000000', '110101002000', 4, '景山街道办事处', '000', NULL); INSERT INTO `pcctv` VALUES ('110101002000', '110101002001', 5, '隆福寺社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101002000', '110101002002', 5, '吉祥社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101002000', '110101002003', 5, '黄化门社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101002000', '110101002004', 5, '钟鼓社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101002000', '110101002005', 5, '魏家社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101002000', '110101002006', 5, '汪芝麻社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101002000', '110101002008', 5, '景山东街社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101002000', '110101002009', 5, '皇城根北街社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101000000', '110101003000', 4, '交道口街道办事处', '000', NULL); INSERT INTO `pcctv` VALUES ('110101003000', '110101003001', 5, '交东社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101003000', '110101003002', 5, '福祥社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101003000', '110101003003', 5, '大兴社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101003000', '110101003005', 5, '府学社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101003000', '110101003007', 5, '鼓楼苑社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101003000', '110101003008', 5, '菊儿社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101003000', '110101003009', 5, '南锣鼓巷社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101000000', '110101004000', 4, '安定门街道办事处', '000', NULL); INSERT INTO `pcctv` VALUES ('110101004000', '110101004001', 5, '交北头条社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101004000', '110101004002', 5, '北锣鼓巷社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101004000', '110101004003', 5, '国子监社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101004000', '110101004004', 5, '钟楼湾社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101004000', '110101004005', 5, '宝钞南社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101004000', '110101004006', 5, '五道营社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101004000', '110101004009', 5, '分司厅社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101004000', '110101004011', 5, '国旺社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101004000', '110101004012', 5, '花园社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101000000', '110101005000', 4, '北新桥街道办事处', '000', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005001', 5, '海运仓社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005002', 5, '北新仓社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005003', 5, '十二条社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005004', 5, '门楼社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005005', 5, '十三条社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005006', 5, '民安社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005007', 5, '板桥社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005008', 5, '九道湾社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005009', 5, '北官厅社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005010', 5, '青龙社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005011', 5, '小菊社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005012', 5, '藏经馆社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005013', 5, '炮局社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005014', 5, '草园社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005015', 5, '二条社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101005000', '110101005016', 5, '前永康社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101000000', '110101006000', 4, '东四街道办事处', '000', NULL); INSERT INTO `pcctv` VALUES ('110101006000', '110101006001', 5, '南门仓社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101006000', '110101006002', 5, '七条社区居委会', '111', NULL); INSERT INTO `pcctv` VALUES ('110101006000', '110101006003', 5, '二条社区居委会', '111