一级行政区经纬度
一级行政区（省级行政区）：34个（23个省、5个自治区、4个直辖市、2个特别行政区）
provinces = {
'吉林省': [125.326800, 43.896160], '黑龙江省': [126.662850, 45.742080],
'辽宁省': [123.429250, 41.835710], '内蒙古自治区': [111.765220, 40.817330],
'新疆维吾尔自治区': [87.627100, 43.793430], '青海省': [101.780110, 36.620870],
'北京市': [116.407170, 39.90
2023-01-28 01:09:12
121KB
1
中国各省市geo数据，包括json版本和原来的echarts地图构建里的js和json版本；
2022-11-12 18:28:49
12.99MB
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
1、根据最新版国家统计局省市区及代码数据生成对应Excel模板，设置省市区三级联动，先选择省再选地市再选区县，示例：
北京市_11 市辖区_1101 东城区_110101；
内蒙古自治区_15 包头市_1502 东河区_150202；
2、设置了数据有效性，强制校验数据正确性，并给出提示
3、省市区列表分别存放于三个sheet，可及时更新数据
4、初始化文件大小181Kb
5、主要用途，包括但不限于地区类模板导入，地区统计类报表等
6、制作不易，有疑问可沟通
2022-05-21 11:03:41
177KB
1