search

vincentmorneau / oracle-geo-data

https://demo.insum.ca/ords/f?p=131
MIT License
22 stars 3 forks source link

Australian states/cities #3

Closed tschf closed 7 years ago

tschf commented 7 years ago

Was just taking a look to see if my city was in there, and nope. In fact, if I go to the source site: http://www.iamrohit.in/countries-states-and-cities-database-of-world-in-mysql/, they have not one city for "New South Wales".

In fact, the states they have listed are completely busted (as in most of them are cities)

image

vincentmorneau commented 7 years ago

Good to know. I tried to find a legit source but none are free. I may search for a better one later and update this repo.

tschf commented 7 years ago

I did a quick search before posting this, and there seem to be a couple of recommendations for geonames. It looks like the data comes in TSV, and is a single file for each country - so probably need some scripts to rework the model.

http://www.geonames.org/export/

(looks like its licensed under CCv3)

vincentmorneau commented 7 years ago

fixed in https://github.com/vincentmorneau/oracle-countries-states-cities/commit/4ef3f9cfcf06d4cd27733da1a66e9ae9dbdc8baf