云南省区、县、市行政区划矢量图（含区县名称及所属州市名称）
2022-11-02 17:51:14
495KB
1
省市、区、县、镇、乡5级联动sql文件；
共74w多条记录，表结构清晰：
CREATE TABLE `position_province` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`province_id` int(11) unsigned NOT NULL COMMENT '省份id、省份编号',
`province_name` char(32) NOT NULL COMMENT '省份名称',
PRIMARY KEY (`id`),
UNIQUE KEY `provice_id` (`province_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='省份数据库';
CREATE TABLE `position_city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`province_id` int(10) unsigned NOT NULL COMMENT '地级市id',
`city_id` bigint(20) unsigned NOT NULL COMMENT '县级市id',
`city_name` char(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `city_id` (`city_id`),
KEY `province_id` (`province_id`),
CONSTRAINT `position_city_ibfk_1` FOREIGN KEY (`province_id`) REFERENCES `position_province` (`province_id`) ON DELETE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=utf8 COMMENT='县级市数据库';
CREATE TABLE `position_country` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '地级市主键ID',
`city_id` bigint(20) unsigned NOT NULL COMMENT '地级市id',
`country_id` bigint(20) unsigned NOT NULL COMMENT '县级id',
`country_name` char(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `county_id` (`country_id`),
KEY `city_id` (`city_id`),
CONSTRAINT `position_country_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `position_city` (`city_id`) ON DELETE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2857 DEFAULT CHARSET=utf8 COMMENT='地区市数据库';
CREATE TABLE `position_town` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`country_id` bigint(20) unsigned NOT NULL COMMENT '县级市id',
`town_id` bigint(20) unsigned NOT NULL COMMENT '镇id',
`town_name` char(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `town_id` (`town_id`),
KEY `country_id` (`country_id`) USING BTREE,
CONSTRAINT `position_town_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `position_country` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=43855 DEFAULT CHARSET=utf8 COMMENT='镇数据库';
CREATE TABLE `position_village` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`town_id` bigint(20) unsigned NOT NULL COMMENT '镇id',
`village_id` bigint(20) unsigned NOT NULL COMMENT '村id--唯一',
`village_name` char(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `village_id` (`village_id`),
KEY `town_id` (`town_id`),
CONSTRAINT `position_village_ibfk_1` FOREIGN KEY (`town_id`) REFERENCES `position_town` (`town_id`) ON DELETE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=693338 DEFAULT CHARSET=utf8 COMMENT='省市县镇村数据';
2022-10-26 22:53:56
68.74MB
1
全国行政区划数据库，
包括xls文件
CREATE TABLE `base_net_area` (
`ID` int(11) NOT NULL,
`PARENT_ID` int(11) NOT NULL DEFAULT '0' COMMENT '父级ID',
`NAME` varchar(50) NOT NULL COMMENT '名称',
`SHORT_NAME` varchar(50) NOT NULL COMMENT '简称',
`LONGITUDE` float NOT NULL DEFAULT '0' COMMENT '经度',
`LATITUDE` float NOT NULL DEFAULT '0' COMMENT '纬度',
`LEVEL` int(1) NOT NULL COMMENT '等级(1省/直辖市,2地级市,3区县,4镇/街道)',
`SORT` int(3) NOT NULL DEFAULT '1' COMMENT '排序',
`STATUS` int(1) NOT NULL DEFAULT '0' COMMENT '状态(0禁用/1启用)',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
2022-09-20 10:38:43
3.03MB
1
mongodb行政区围栏,有索引.可根据当前的定位点查询所在区域，达到围栏的效果 。未加索引查询要5s，加了索引后查询速度只要0.01秒，我从网上找的资料，但是原来不可以加索引，我修改了，这个能加索引，希望帮到大家。我设置0积分下载，资源应该免费提供，鬼脑壳csdn总是搞名堂
2022-08-18 14:03:57
9.92MB
1