red

花匠小妙招
2025-12-15 22:45

# Region 中华人民共和国行政区划（五级）：省级、地级、县级、乡级和村级 > 国内 [gitee https://gitee.com/red-jasmine/region](https://gitee.com/red-jasmine/region) ## 数据来源 - 国家统计局 - [数据源 - http://www.stats.gov.cn/sj/tjbz/tjyqhdmhcxhfdm/2022/index.html](http://www.stats.gov.cn/sj/tjbz/tjyqhdmhcxhfdm/2022/index.html) - [编码规范 - http://www.stats.gov.cn/sj/tjbz/gjtjbz/202302/t20230213_1902741.html](http://www.stats.gov.cn/sj/tjbz/gjtjbz/202302/t20230213_1902741.html) > 2022年度全国统计用区划代码和城乡划分代码更新维护的标准时点为2022年10月31。未包括我国台湾省、香港特别行政区和澳门特别行政区 ## 城市等级 | 级别 | Level | |:---------------:|:-----:| | 国家 | 0 | | 省、直辖市、自治区、特别行政区 | 1 | | 地级市、地区、自治州、盟 | 2 | | 县、县级市、区、旗 | 3 | | 乡镇街道 | 4 | | 村、社区、苏木 | 5 | ## 数据下载 | 数据 | CSV | SQL | |-------------------|-----------------------------------------------------|-----------------------------------------------------| | 省市区三级 | [regions_level3.csv](./dist/csv/regions_level3.csv) | [regions_level3.sql](./dist/sql/regions_level3.sql) | | 省市区+乡镇街道四级 | [regions_level4.csv](./dist/csv/regions_level4.csv) | [regions_level4.sql](./dist/sql/regions_level4.sql) | | | 省市区+乡镇街道 +社区、村五级 | [regions_level5.csv](./dist/csv/regions_level5.csv) | [regions_level5.sql](./dist/sql/regions_level5.sql) | | - sql ```sql # 数据表 CREATE TABLE `regions` ( `id` bigint unsigned NOT NULL, `parent_id` bigint unsigned NOT NULL COMMENT '父级ID', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称', `pinyin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '拼音', `pinyin_prefix` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '首字母', `level` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '等级', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB COMMENT='行政区划表'; ``` ## laravel ## 安装 Via Composer ``` bash $ composer require red-jasmine/region ``` ## Usage ### Command ```php # 爬取数据 php artisan regions:crawl-data # 优化数据 php artisan regions:optimize ```

The MIT License (MIT) Copyright (c) liushoukun <liushoukun66@gmail.com> Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.