superset icon indicating copy to clipboard operation
superset copied to clipboard

Incorrect Vietnam province name in Country map

Open tienhung2812 opened this issue 1 year ago • 1 comments

Screenshot

Screenshot 2024-10-15 at 16 51 23

Description

On Vietnam country map chart, there are a list of incorrect mapping ISO-code with the name

ISO 3166-2 Current name Correct Name
VN-39 Đông Nam Bộ Đồng Nai
VN-53 Đông Bắc Bắc Kạn
VN-66 Đồng Bằng Sông Hồng Hưng Yên

Source: https://en.wikipedia.org/wiki/ISO_3166-2:VN

Design input

tienhung2812 avatar Oct 15 '24 09:10 tienhung2812

Hey @tienhung2812, I'm here to help you with any bugs, questions, or contributions you have. Let's tackle this issue together!

To correct the incorrect Vietnam province names in the country map chart, you need to update the NAME_1 property in the GeoJSON data. For example, to change "Đông Nam Bộ" to "Đồng Nai", you would modify the relevant feature in the GeoJSON file. Similarly, update the other incorrect names as follows:

  1. Change "Đông Nam Bộ" to "Đồng Nai" for ISO code VN-39.
  2. Change "Đông Bắc" to "Bắc Kạn" for ISO code VN-53.
  3. Change "Đồng Bằng Sông Hồng" to "Hưng Yên" for ISO code VN-66.

You can automate this process using a Python script with GeoPandas:

import geopandas as gpd

# Load your GeoJSON file
vietnam = gpd.read_file('path_to_your_geojson_file')

# Function to replace names
def replace_name(gdf, old_name, new_name):
    gdf.loc[gdf['NAME_1'] == old_name, 'NAME_1'] = new_name

# Replace incorrect names
replace_name(vietnam, 'Đông Nam Bộ', 'Đồng Nai')
replace_name(vietnam, 'Đông Bắc', 'Bắc Kạn')
replace_name(vietnam, 'Đồng Bằng Sông Hồng', 'Hưng Yên')

# Save the updated GeoJSON
vietnam.to_file('path_to_updated_geojson_file', driver='GeoJSON')

This script will help ensure that all province names are correctly updated in your GeoJSON file [1][2].

To continue talking to Dosu, mention @dosu.

dosubot[bot] avatar Oct 15 '24 10:10 dosubot[bot]

I believe this is all resolved, and the issue should be closed now :) Thanks again for the contribution!

rusackas avatar Nov 05 '24 21:11 rusackas