search

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.43k stars 2.57k forks source link

Wrong + Missing Cities in || Argentina > Buenos Aires Province > Cities #367

Open andy-soft opened 2 years ago

andy-soft commented 2 years ago

Hi there, I am searching and building GEO-GIS information and saw this database, downloaded it , all OK But when searched for a simple Municipality in my country, WOW! not found

you should revise there is a District inside Buenos Aires Province, called CABA, (Ciudad Autónoma de Buenos Aires) Autonomous City of Buenos Aires, and there inside are sub-district or neighborhoods (called Barrios) you listed them wrongly as province-cities in Buenos Aires

Buenos Aires has 196 Municipalities, which are lacking and inside them there are several cities, for example I live in = Municipio of Vicente Lopez => City = Olivos

I can provide you with a database of this districts if you wish to contribute on the site! You can get them from GeoNames also (another free database) far bigger than yours! (but also VERY buggy)

ANOTHER QUESTION ¿What is STATE-CODE and where is state-Id listed or normalized?

as well as country_id

cheers

braaar commented 2 years ago

This project includes only three levels of geographical information: Country, state and city.

Obviously each country separates itself into organizational or historical units in many different ways, and it's not possible to fit every country into the same mold in a flawless way. I am not aware of any plans to add new categories to this project, as the scope would probably easily get out of hand in relation to the amount of contributors. I would say adding more subdivisions and categories is something that could become a thing in the future if the project continues to mature and gain popularity, but I have no idea of that view is shared by the maintainers.

As for your technical questions, I am trying to work out some of the answers to them in this issue #364

dr5hn commented 2 years ago

@andy-soft Thanks for reporting. 🎉

I only understood that Argentina requires 4 levels of geographical information. I didn't clearly understand the actual issue of Buenos Aires, can you please reframe and elaborate it to me?

At the moment, I would like to keep only 3 levels of information and discard the 4th level of information.

@braaar For some of the countries, the 4th level is also mixed on the 3rd level. and hence My future plan is to add a type column to the city to justify the type of city more clearly to the audience.

To answer your another question:

Let me know if I misunderstood anything.

EDIT: I think this issue also says the same. #354 Please confirm.

andy-soft commented 2 years ago

Buenos Aires is a Province, inside this Province there are Municipalities (like Districts) and inside those Districts there are Cities (mostly one of the cities has the same name of the municipality,, specially if there are no further subdivisions) The thing is wrong because you used as cities the subdivisions of the Autonomous City of Buenos Aires called CABA (before a political change this was named Capital Federal) which is itself a Municipality of Buenos Aires Province, hence the problem. Buenos Aires Province has more than 180 Municipalities, and most of them have many cities inside.(up to 30) I can provide you the official data for this subdivisions you must search inside indec.gov.ar this link https://www.indec.gob.ar/indec/web/Nivel4-Tema-1-39-121

best regards.

I can also provide you a MySQL / csv dump of this data

On Sat, Jan 22, 2022 at 7:07 AM Darshan Gada @.***> wrote:

@andy-soft https://github.com/andy-soft Thanks for reporting. 🎉

I only understood that Argentina requires 4 levels of geographical information. I didn't clearly understand the actual issue of Buenos Aires, can you please reframe and elaborate it to me?

At the moment, I would like to keep only 3 levels of information and discard the 4th level of information.

@braaar https://github.com/braaar For some of the countries, the 4th level is also mixed on the 3rd level. and hence My future plan is to add a type column to the city to justify the type of city more clearly to the audience.

To answer your another question:

  • State code is 3166-2 standard codes supplied by Officials. Data Source: https://www.iso.org/obp/ui/#iso:code:3166:AR
  • State ID's are just a unique identifier for each state added by MySQL Database. Can be found in states.sql
  • Country ID again can be found in country.sql.

Let me know if I misunderstood anything.

— Reply to this email directly, view it on GitHub https://github.com/dr5hn/countries-states-cities-database/issues/367#issuecomment-1019154313, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADII64NY3RQNSD77FVYFKVLUXJ6WXANCNFSM5MNLYR6A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you were mentioned.Message ID: @.***>

dr5hn commented 2 years ago

@andy-soft

It would be great if you can please provide a CSV dump.

LeoDoldan7 commented 1 year ago

I'd advise against adding a fourth level here.

There are a lot of districts missing here, but they fit into a three-level structure.

Examples:

You can see a full, official, poorly formatted list, here. You can probably extract them programmatically using querySelectorAll.

A quick Google search didn't offer any official ISO nomenclature at the City level for Argentina, although I don't discard it exists. Being Argentinian myself, the list offered above covers the most common use cases I see personally and professionally.

Agustin-Mediotti commented 1 year ago

As @LeandroDoldan says, there is no need to add a fouth level.

I already moved the cities in this contribution. But I am not sure if I could add those missing districts manually.