dr5hn / countries-states-cities-database

🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
https://dr5hn.github.io/countries-states-cities-database/
Open Data Commons Open Database License v1.0
7.38k stars 2.56k forks source link

Spain: missing cities #184

Closed Melchyore closed 3 years ago

Melchyore commented 3 years ago

Hello!

First of all, thanks for this wonderful database!

I was testing the demo and I noticed that many Spain's states are missing cities (e.g. Madrid Province & Barcelona Province).

Keep up the good work!

dr5hn commented 3 years ago

@Melchyore Thanks for reporting. 🎉

If you've got more examples, please post it here.

I will take a look at it soon.

Melchyore commented 3 years ago

@dr5hn I'm not sure but I think that many cities are children of states "Andalusia", "Aragon", "Castile-La Mancha".

In fact, there are duplicates (e.g. Community of Madrid and Madrid Province, the first one has cities but not the second). I think some states have endTime (not exist anymore) but are listed.

Some examples:

Spain has only 17 communities (states):

... but there're more than 17 in database and some are missing or have the wrong name.

Hope it helps!

dr5hn commented 3 years ago

@Melchyore This is very helpful.

Thanks. I will take a look at it soon.