vietnamese-provinces-database
Comprehensive SQL and GIS datasets for Vietnamese administrative units, including provinces, districts, wards, postal codes, and geospatial boundaries.
What is vietnamese-provinces-database?
Comprehensive SQL and GIS datasets for Vietnamese administrative units, including provinces, districts, wards, postal codes, and geospatial boundaries.
Overview of vietnamese-provinces-database
What it is
This repository provides comprehensive SQL and GIS datasets for Vietnamese administrative units, including provinces, districts, wards, postal codes, and geospatial boundaries. The data is updated as of the most recent effective decree: 388/NQ-UBTVQH16. It includes all 34 Vietnamese provinces and associated sub-divisions. The dataset is not associated with the General Statistics Office of Vietnam or the Vietnamese government; it is created based on the API province data provided by that office.
Key features
- Includes all 34 Vietnamese provinces, districts, wards, and sub-divisions.
- Provides SQL datasets for PostgreSQL/PostGIS, MySQL/MariaDB, Microsoft SQL Server, and Oracle.
- Provides NoSQL datasets for JSON, MongoDB, Redis, and Elasticsearch.
- Includes an add-on GIS dataset (GeoJSON) and a postal code dataset.
- Adds additional tables: administrative_regions (8 geographical regions) and administrative_units (types like municipality, province, ward, commune, special administrative region).
- Generates English names and code names (slugs) for provinces and wards.
- Data is versioned and tracks government decrees from v1.0.0 to v5.2.0.
Use cases
This dataset can be used for applications that need Vietnamese administrative unit data, including provinces, districts, wards, postal codes, and geospatial boundaries. It is suitable for building location-based services, administrative management systems, GIS applications, and any software requiring up-to-date Vietnamese administrative divisions.
Getting started
Create a database (if applicable):sqlCREATE DATABASE vietnamese_administrative_units;Then execute the following scripts in order:1. CreateTable_vn_units.sql – creates the database schema.2. ImportData_vn_units.sql – imports the dataset.Choose the scripts from the corresponding database directory (e.g., postgresql/, mysql/, sqlserver/, oracle/).
License and pricing
License: MIT. Pricing: open source (free).
Based on the project's public README and repository metadata.