# Graciously donated to the public by Ĭity_accented varchar(30) NOT NULL default '', Sample data: # Cities of the world database UPDATE: I have removed the cities.zip from my sandbox. Thank you MaxMind for the generous contribution! With data like this a whole new class of applications becomes possible. In the end, modelling location data is tricky.
Questions like how we fill out the data to include these missing elements, how we maintain this data, how we structure it in respect to supporting only subsets of it for regions or groups of countries, these are all topics for discussion. It is different in nature than the zipcodes database due to the absence of zipcodes, which are used as primary keys in the Civicspace implementation. How we use this data is open for discussion. The city_accented column contains full city names including accents and special characters. I assume this is intended for search purposes. There are two variants of city, one with lowercase letters and only ASCII characters. In the sample below you will see the main characteristics of the data.
For those of you who have tried the location.module with the zipcodes database from CivicSpace, you will recognize how cool it is and how well this fits with that project and therefore Drupal. There are over 3,047,000 records in the database. The database contains locations by country, city, latitude and longitude. The company has agreed to release their cities of the world database under the GPL.
0 kommentar(er)
