6 ms·
World.db - A Free Open World Database and Schema
- ig1 14y agoWhat's the advantage of this over the geonames database (CC-BY) which seems to be more comprehensive ?
- lucian1900 14y agoProbably licensing. This one's public domain. It is indeed extremely incomplete.
- aslakhellesoy 14y agoThe GeoNames geographical database is available for download free of charge under a creative commons attribution license. Is that too restrictive?
- ceejayoz 14y ago> Is that too restrictive? For someone who doesn't want to have a "credits" page in their app, sure.
- taybin 14y agoThis would be more interesting if it included the official country codes: http://en.wikipedia.org/wiki/Country_code http://en.wikipedia.org/wiki/Country_code
- thomasbk 14y agoBased on the fact that this database is free and public domain, apparently it's possible for such data to have a restrictive license. So, I'm wonder what the sources of this data are? Is it compiled from public resources from the governments listed, determined and measured by hand by visiting the countries (with a GPS device in hand :P), or something else? I couldn't find this information on github.
- jre 14y agoHow hard would it be to generate that kind of data from Wikipedia ?
- riffraff 14y agoyou'd still get CC-BY data from wikipedia, rather than public domain, I believe
- dhruvbird 14y agoNice - much needed!
- irfan 14y agoquite incomplete. why not ask github users to fork, contribute as fixtures & send pull request
- nik61 14y agoThere is a UN office in Berlin devoted to Geographical names. They issue a 179 page manual about the standardisation of such names, but it is unclear whether they produce lists that could be used as the definitive source for a database of this kind.
- lardissone 14y agoCountry names are incorrect. Totally inaccurate. See my issue report: https://github.com/geraldb/world.db/issues/1 https://github.com/geraldb/world.db/issues/1
- kephra 14y agoWhy is this a ruby project, and not just a plain files to create the tables, and insert the values? Also, please teach him something about database normalization. e.g. capital should not be a flag of cities, but a foreign key of regions and countries. Cities, Regions and countries should be combined into one table, with a foreign keys pointing up and down the chain, from world down to suburb level.
- vandershraaf 14y ago"please teach him something about database normalization"
- BoppreH 14y agoIf the Heroku app is up to date, there are only 62 countries and 126 cities and all names are in German. I think this should have been mentioned in the Github page.
- jorgebg 14y agoAgree, somehow incomplete info of the current status of the project. It can be ambitious and in an early stage but just say it!
- gulbrandr 14y agorelated: http://mledoze.github.com/countries/ http://mledoze.github.com/countries/
- coderholic 14y agoHere's a (django specific) alternative: https://github.com/coderholic/django-cities https://github.com/coderholic/django-cities
- ewheeler 14y agodoesn't include city names, but here is a python script that pulls up-to-date country names, codes, currencies, etc from standards bodies: https://github.com/ewheeler/current-countries-of-earth https://github.com/ewheeler/current-countries-of-earth
- of 14y agoShouldn't there be location info for each city? A long/lat field?