This is a complete Europe Cities Database with Latitude and Longitude containing 617,000+ cities and places of European cities. The size of the package is 9 megabyte zip file having 58 megabytes of SQL dumps when unzipped. The package contains readily executable SQL dump files to create and populate the Europe city database. Any other data format is available on request. The data is ready to be published on your content web site or application.

Data Format: The package contains data as SQL dump file. SQL Dump file is a script file that can be readily executed from a SQL query tool such as MySQL query browser. The script will create required tables and populate with cities data.

You can request a comma delimited text (CSV) file or TAB delimited text file free of charge for this package. These text files can be readily imported in Microsoft Access or MS Excel. Although Excel 2003 has limitation regarding number of records in one worksheet (65,535) you can split the CSV or TAB text files into several parts and import into excel worksheets. However, Excel 2007 or 2010 is able to import the text file in one go.

Additional format such as Microsoft Excel or Microsoft Access database is available on request. A small fee for data conversion may be applicable. Please send your request to sales@ebusinessgems.com

Fields in the Table CITIES: 1) CityID: City identification number 2) ISO2: Two character ISO country code 3) RC: Two character region code 4) City: Name of the city 5) AccentCity: Accented name of the city 6) Latitude: Latitude of the city 7) Longitude: Longitude of the city

Key phrases: city database, europe latitude longitude, database city, city latitude longitude, cities latitude longitude, names of us cities, uk city names, uk city list, lat and long, long and lat, latitude and longitude, europe latitude longitude.

Linux, WinOther, WinVista, WinXP, Not Applicable

SQL dump can be run directly in MySQL query browser or similar tool to insert the data in database.

city, database, latitude, longitude, europe, cities, names, list, lat, long, uk cities, german cities, norway cities, french cities, dutch cities

Data Transformation, Asset Management, web, soft, learn SQL, .DBF file Repair, online database, viewer, metadata management, Oracle, document generator, sas data dictionary, cdbf, SQL queries, dbview, employee hr database, DBF corrupted Repair, database designer, Asset Tracking, hierarchical, shareware, command line, spss, php, DBF Repair