README

越南行政区划数据库

数据直接来源于越南国家统计局.

最后更新：2022/04/11

1. 安装

1.1 使用composer安装包

composer require kjmtrue/vietnam-zone

1.2 复制迁移文件

php artisan vendor:publish --provider="Kjmtrue\VietnamZone\ServiceProvider"

1.3 如有必要，编辑迁移文件

打开以下迁移文件，并根据您的需求进行修改。

database/migrations/2020_01_01_000001_create_provinces_table.php
database/migrations/2020_01_01_000002_create_districts_table.php
database/migrations/2020_01_01_000003_create_wards_table.php

2. 运行迁移

php artisan migrate

3. 导入数据

php artisan vietnamzone:import

注意

• 数据最后更新：2022/04/11
• 要更新最新数据，请在运行php artisan vietnamzone:import命令之前，按照第5部分的说明进行操作。

4. 使用

$provinces = \Kjmtrue\VietnamZone\Models\Province::get();
$districts = \Kjmtrue\VietnamZone\Models\District::whereProvinceId(50)->get();
$wards = \Kjmtrue\VietnamZone\Models\Ward::whereDistrictId(552)->get();

5. 下载数据文件

数据来源于越南国家统计局.

将来，当有权机关重新安排行政区划时，您需要在将数据导入项目之前，下载最新的数据文件。

请按照以下步骤操作

• 访问：https://danhmuchanhchinh.gso.gov.vn/（此URL可能被GSOVN更改）
• 找到“导出Excel”按钮
• 勾选“区县乡镇”复选框
• 点击“导出Excel”按钮，并下载xls文件
• 将下载的文件重命名为vnzone.xls并复制到项目的storage目录
• 在步骤3中运行php artisan vietnamzone:import命令

待办事项

• 更新数据
• 直接从国家统计局网站下载文件

截图

select * from provinces

+----+------------------------+--------+---------------------+---------------------+
| id | name                   | gso_id | created_at          | updated_at          |
+----+------------------------+--------+---------------------+---------------------+
|  1 | Thành phố Hà Nội       | 01     | 2020-06-16 17:22:30 | 2020-06-16 17:22:30 |
|  2 | Tỉnh Hà Giang          | 02     | 2020-06-16 17:22:30 | 2020-06-16 17:22:30 |
|  3 | Tỉnh Cao Bằng          | 04     | 2020-06-16 17:22:30 | 2020-06-16 17:22:30 |
|  4 | Tỉnh Bắc Kạn           | 06     | 2020-06-16 17:22:30 | 2020-06-16 17:22:30 |
|  5 | Tỉnh Tuyên Quang       | 08     | 2020-06-16 17:22:30 | 2020-06-16 17:22:30 |
+----+------------------------+--------+---------------------+---------------------+

select * from districts

+----+-------------------+--------+-------------+---------------------+---------------------+
| id | name              | gso_id | province_id | created_at          | updated_at          |
+----+-------------------+--------+-------------+---------------------+---------------------+
|  1 | Quận Ba Đình      | 001    |           1 | 2020-06-16 17:22:30 | 2020-06-16 17:22:30 |
|  2 | Quận Hoàn Kiếm    | 002    |           1 | 2020-06-16 17:22:30 | 2020-06-16 17:22:30 |
|  3 | Quận Tây Hồ       | 003    |           1 | 2020-06-16 17:22:30 | 2020-06-16 17:22:30 |
|  4 | Quận Long Biên    | 004    |           1 | 2020-06-16 17:22:30 | 2020-06-16 17:22:30 |
|  5 | Quận Cầu Giấy     | 005    |           1 | 2020-06-16 17:22:30 | 2020-06-16 17:22:30 |
+----+-------------------+--------+-------------+---------------------+---------------------+

select * from wards

+----+--------------------------+--------+-------------+---------------------+---------------------+
| id | name                     | gso_id | district_id | created_at          | updated_at          |
+----+--------------------------+--------+-------------+---------------------+---------------------+
|  1 | Phường Phúc Xá           | 00001  |           1 | 2020-06-16 17:30:13 | 2020-06-16 17:30:13 |
|  2 | Phường Trúc Bạch         | 00004  |           1 | 2020-06-16 17:30:13 | 2020-06-16 17:30:13 |
|  3 | Phường Vĩnh Phúc         | 00006  |           1 | 2020-06-16 17:30:13 | 2020-06-16 17:30:13 |
|  4 | Phường Cống Vị           | 00007  |           1 | 2020-06-16 17:30:13 | 2020-06-16 17:30:13 |
|  5 | Phường Liễu Giai         | 00008  |           1 | 2020-06-16 17:30:13 | 2020-06-16 17:30:13 |
+----+--------------------------+--------+-------------+---------------------+---------------------+