Please check regency and district about wilayah-administratif-indonesia HOT 5 CLOSED

Hi @ndro-agus

I've checked on CSV and MySQL dump:

• All regencies have name (CSV regencies.csv line 501-514 and MySQL dump line 637-650).
• All districts have its own regency (CSV districts.csv line 6956-7093 and MySQL dump line 7754-7893).

Did you see any errors while you were importing the dump?

from wilayah-administratif-indonesia.

no, there is no error, but some data is missing,
there are some district have regency id, but the id was not exists in regency table.

from wilayah-administratif-indonesia.

I can't reproduce the issue and the dump looks good to me.
Could you please get a list of districts that have a non-existing regency to here and the query to get the list?
If it is possible, could you try to reimport the database?

from wilayah-administratif-indonesia.

well, I have fetched data for the rest regency from Central Agency on Statistics (BPS) - MFD and MBS Update (http://mfdonline.bps.go.id/).

regency ID from 9419 to 9471,
Check DISTINCT regency ID from district, and compare with DISTINCT regency ID from regency.

you will see the differences.

from wilayah-administratif-indonesia.

Most probably, there was an issue while importing MySQL dump line 637-650, which contains the missing regency's name. Since it is not reproducible, I will close this issue. Feel free to re-open this issue if anyone faces missing regency's name issue again.

from wilayah-administratif-indonesia.