{"id":373,"date":"2023-12-30T05:55:52","date_gmt":"2023-12-29T23:55:52","guid":{"rendered":"http:\/\/ebusinessgems.com\/blog\/?p=373"},"modified":"2023-12-30T05:55:52","modified_gmt":"2023-12-29T23:55:52","slug":"world-city-names-database-latitude-longitude","status":"publish","type":"post","link":"https:\/\/www.ebusinessgems.com\/blog\/geographical-database\/world-city-names-database-latitude-longitude\/","title":{"rendered":"World City Names Database with Latitude and Longitude"},"content":{"rendered":"

This is a comprehensive world cities database<\/a>. This database has World city names with latitude and longitude of all the cities and places of every country. This enormous collection has some 2.79 million cities and places of the planet earth. The size of the package is 43 megabyte zip file having 270 megabytes of SQL dumps when unzipped. The package contains readily executable SQL dump files to create and populate the world city database. However, any other data format is available on request.<\/p>\n

\n\"world<\/div>\n

The database has cities and places of 246 countries and 4500+ regions comprising a total of 2.79+ millions of entries. Hence the list is the largest and unique collection of its kind on the web. The data is ready to be published on your content web site or application.<\/p>\n

The dump files are splitted to manageable units. The file “world-city-database-regions.sql” should be run first in order to create the tables and all entries but the cities. All other scripts will create the entries in CITIES table and can be run in any sequence.<\/p>\n

Data Format:<\/strong>
\nThe package contains data as SQL dump files. SQL Dump files are script files that can be readily executed from a SQL query tool such as MySQL query browser. The script will create required tables and populate with the data. Additional format such as CSV file, TAB delimited text file, 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<\/p>\n

Tables and Columns:
\n<\/strong>The script will create 4 tables namely CONTINENTS, COUNTRIES, REGIONS and CITIES. Fields in each of the table are listed below:<\/p>\n

Fields in the Table CONTINENTS:<\/p>\n

There is a single field named [Continent] in this table. Actually the table contains name of the continents as well some mapping reference zones. The full list of the continents or zones is:
\nClick here to Download World Cities Database<\/a> with Latitude and Longitude.<\/p>\n

    \n
  1. Africa<\/li>\n
  2. Antarctic Region<\/li>\n
  3. Arctic Region<\/li>\n
  4. Asia<\/li>\n
  5. Central America and the Caribbean<\/li>\n
  6. Commonwealth of Independent States<\/li>\n
  7. Europe<\/li>\n
  8. Middle East<\/li>\n
  9. North America<\/li>\n
  10. Oceania<\/li>\n
  11. South America<\/li>\n
  12. South East Asia<\/li>\n
  13. World Others<\/li>\n<\/ol>\n

    Fields in the Table COUNTRIES:<\/p>\n

      \n
    1. ISO2<\/em>: Two character ISO country code<\/li>\n
    2. FIPS104<\/em>: Two character FIPS country code<\/li>\n
    3. ISO3<\/em>: Three character ISO country code<\/li>\n
    4. ISON<\/em>: Numeric ISO country code<\/li>\n
    5. TLD<\/em>: Top level Internet domain name for the country<\/li>\n
    6. Country<\/em>: Name of the country<\/li>\n
    7. Continent<\/em>: Continent or reference zone<\/li>\n
    8. Capital<\/em>: Capital of the country<\/li>\n
    9. NationalitySingular:<\/em> Nationality (singular form)<\/li>\n
    10. NationalityPlural:<\/em> Nationality (plural form)<\/li>\n
    11. Currency<\/em>: Currency of the country<\/li>\n
    12. CurrencyCode<\/em>: Three character currency code<\/li>\n
    13. Population<\/em>: Population of the country<\/li>\n<\/ol>\n

      Fields in the Table REGIONS:<\/p>\n

        \n
      1. ISO2<\/em>: Two character ISO country code<\/li>\n
      2. RC<\/em>: Two character region code<\/li>\n
      3. Region<\/em>: Name of the region of the country<\/li>\n<\/ol>\n

        Fields in the Table CITIES:<\/p>\n

          \n
        1. CityID<\/em>: City identification number<\/li>\n
        2. ISO2<\/em>: Two character ISO country code<\/li>\n
        3. RC<\/em>: Two character region code<\/li>\n
        4. City<\/em>: Name of the city<\/li>\n
        5. AccentCity<\/em>: Accented name of the city<\/li>\n
        6. Latitude<\/em>: Latitude of the city<\/li>\n
        7. Longitude:<\/em> Longitude of the city<\/li>\n<\/ol>\n

          The corresponding SQL command, for example, in the dump file to create CITIES table is:
          \n[download prod_url='”https:\/\/www.ebusinessgems.com\/catalog\/world-city-names-database-with-latitude-longitude-p-117.html” target=”_blank”‘ prod_title=’World City Names Database with Latitude and Longitude’]
          \nCREATE TABLE `Cities` (
          \n`CityID` INTEGER NOT NULL,
          \n`ISO2` VARCHAR(2),
          \n`RC` VARCHAR(2),
          \n`City` VARCHAR(100),
          \n`AccentCity` VARCHAR(100),
          \n`Latitude` DOUBLE NULL,
          \n`Longitude` DOUBLE NULL,
          \nPRIMARY KEY (`CityID`)
          \n) ENGINE=innodb DEFAULT CHARSET=utf8;
          \nData Example:<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/tfoot>\n<\/table>\n
          Table: Regions<\/strong><\/caption>\n
          ISO2<\/span><\/th>\nRC<\/span><\/th>\nRegion<\/span><\/th>\n<\/tr>\n<\/thead>\n
          US<\/span><\/td>\nNV<\/span><\/td>\nNevada<\/span><\/td>\n<\/tr>\n
          US<\/span><\/td>\nNY<\/span><\/td>\nNew York<\/span><\/td>\n<\/tr>\n
          US<\/span><\/td>\nOH<\/span><\/td>\nOhio<\/span><\/td>\n<\/tr>\n
          US<\/span><\/td>\nOK<\/span><\/td>\nOklahoma<\/span><\/td>\n<\/tr>\n
          US<\/span><\/td>\nOR<\/span><\/td>\nOregon<\/span><\/td>\n<\/tr>\n
          US<\/span><\/td>\nPA<\/span><\/td>\nPennsylvania<\/span><\/td>\n<\/tr>\n
          US<\/span><\/td>\nPR<\/span><\/td>\nPuerto Rico<\/span><\/td>\n<\/tr>\n
          US<\/span><\/td>\nPW<\/span><\/td>\nPalau<\/span><\/td>\n<\/tr>\n
          US<\/span><\/td>\nRI<\/span><\/td>\nRhode Island<\/span><\/td>\n<\/tr>\n
          US<\/span><\/td>\nSC<\/span><\/td>\nSouth Carolina<\/span><\/td>\n<\/tr>\n<\/tbody>\n
          \n\n\n\n\n\n\n\n\n\n\n<\/tfoot>\n<\/table>\n

          Keywords: <\/strong><\/p>\n

          city, database, latitude, longitude, world, cities, names, list, lat, long<\/p>\n

          Keyphrases:<\/strong><\/p>\n

          city database, latitude of the world, world latitude longitude, database city, city latitude longitude, cities latitude longitude, names of world cities, world city names, world city list, lat and long, long and lat, latitude and longitude<\/p>\n

          **********************************************************<\/p>\n

          World City Names Database with Latitude and Longitude<\/strong><\/p>\n

          **********************************************************<\/p>\n

          World City Names Database<\/a> with Latitude and Longitude is an eBuisnessGems Product<\/p>\n

          Copyright \u00a9 eBuisnessGems.com, al rights reserved<\/p>\n

          Unauthorized copying, distribution and use of this database product is strictly prohibited. You can purchase and download this product only from www.eBusinessGems.com. This product is for your personal use only and you can not resell or distribute it in its original form and content. However you may use this database in your own web site or application and sell the resulting product or service. If you find this product being sold and distributed by any other store, please immediately inform sales@eBusinessGems.com. Thank you.<\/p>\n","protected":false},"excerpt":{"rendered":"

          This is a comprehensive world cities database. This database has World city names with latitude and longitude of all the cities and places of every country. This enormous collection has some 2.79 million cities and places of the planet earth. The size of the package is 43 megabyte zip file having 270 megabytes of SQL Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[170],"tags":[176,171,175,174,180,182,172,181,177,179,178,173],"yoast_head":"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n

          Table: Cities<\/strong><\/caption>\n
          CityID<\/span><\/th>\nISO2<\/span><\/th>\nRC<\/span><\/th>\nCity<\/span><\/th>\nAccentCity<\/span><\/th>\nLatitude<\/span><\/th>\nLongitude<\/span><\/th>\n<\/tr>\n<\/thead>\n
          2639795<\/span><\/td>\nUS<\/span><\/td>\nPR<\/span><\/td>\ncolumbia<\/span><\/td>\nColumbia<\/span><\/td>\n18.0063889<\/span><\/td>\n-65.9069444<\/span><\/td>\n<\/tr>\n
          2639796<\/span><\/td>\nUS<\/span><\/td>\nPR<\/span><\/td>\ncombate<\/span><\/td>\nCombate<\/span><\/td>\n18.4316667<\/span><\/td>\n-66.4313889<\/span><\/td>\n<\/tr>\n
          2639797<\/span><\/td>\nUS<\/span><\/td>\nPR<\/span><\/td>\ncomerio<\/span><\/td>\nComerio<\/span><\/td>\n18.22<\/span><\/td>\n-66.2263889<\/span><\/td>\n<\/tr>\n
          2639798<\/span><\/td>\nUS<\/span><\/td>\nPR<\/span><\/td>\ncometa<\/span><\/td>\nCometa<\/span><\/td>\n18.1447222<\/span><\/td>\n-65.8291667<\/span><\/td>\n<\/tr>\n
          2639799<\/span><\/td>\nUS<\/span><\/td>\nPR<\/span><\/td>\ncomunas<\/span><\/td>\nComunas<\/span><\/td>\n18.0891667<\/span><\/td>\n-65.8441667<\/span><\/td>\n<\/tr>\n
          2639800<\/span><\/td>\nUS<\/span><\/td>\nPR<\/span><\/td>\nconcordia<\/span><\/td>\nConcordia<\/span><\/td>\n17.9816667<\/span><\/td>\n-66.0372222<\/span><\/td>\n<\/tr>\n
          2639801<\/span><\/td>\nUS<\/span><\/td>\nPR<\/span><\/td>\ncondado<\/span><\/td>\nCondado<\/span><\/td>\n18.4563889<\/span><\/td>\n-66.0711111<\/span><\/td>\n<\/tr>\n<\/tbody>\n