Guam cities list with latitude and longitude in CSV format

Guam
Guam
CSV, SQL, XML, JSON

Last update : 04 October 2024.

Country
Guam
Capitale
Hagåtña
Number of cities
20
Download
Click here

This is the best list of 20 cities in the Guam available in 4 formats ( CSV, Json, SQL, XML ). We have cleaned up the Geoname database to leave only the towns, capitals and villages. All are all associated with regions and sub-regions (where available).

Each file contains the following data: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. See the FAQ below for a detailed explanation.

Here is an example of the data from the Guam file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
7873866Mongmong-Toto-Maite VillageGUMongmong-Toto-Maite13.46857144.78214436825Pacific/Guamseat of a first-order administrative division
4038794Yigo VillageYiguGUYigo13.53605144.8885514020539Pacific/Guamseat of a first-order administrative division
4043656Barrigada VillageBarigada,BarigådaGUBarrigada13.46913144.79901668875Pacific/Guamseat of a first-order administrative division
4043399Merizo VillageMaleso,Malesso,MericoGUMerizo13.26584144.66908752152Pacific/Guamseat of a first-order administrative division
7268049Mangilao VillageManguilao,ManguuaoGUMangilao13.44761144.801096215191Pacific/Guamseat of a first-order administrative division
4044012HagåtñaAgadna,Agana,Agana -1998,Agania,Aganija,Aganja,Agano,Agaña,Aguana,Akashi,Akashi - JP renamed WW2,Ankana,City of Ignacio de Agana,City of Saint Ignacio de Agana,Ciudad de San Ignacio de Agana,Hagadna,Hagatna,Hagåtña,Haqatna,Jagatna,Khagatna,San Ignacio de Agana *,Ville d’Agana,Vjoska Agan’ja,a jia ni ya,akatna,ha katya,hagania,hagasnya,hagatna,hagatnya,haghatnya,hegatn’ya,Αγκάνα,Вёска Аганья,Хагатна,Хагатња,Հագատնա,هاغاتنيا,هاگاتنا,هاگاتنیا,हेगात्न्या,அகாத்ன,ฮากาตญา,ჰაგატნა,ハガニア,阿加尼亚,하갓냐GUHagatna13.47567144.7488631051Pacific/Guamcapital of a political entity
4038554Santa Rita VillageSanta RitaGUSanta Rita13.38608144.67226667500Pacific/Guamseat of a first-order administrative division
4043525Agana Heights VillageAgana Heights,Hagatna Heights,TutuhanGUAgana Heights13.46559144.74795523940Pacific/Guamseat of a first-order administrative division
4043615Chalan Pago-Ordot VillageChalan Pagu,Chalan Pagu-Otdot,Chalan Pågu-OtdotGUChalan Pago-Ordot13.44741144.75902386822Pacific/Guamseat of a first-order administrative division
4038588Sinajana VillageSinahanna,SinajanaGUSinajana13.46334144.75406552853Pacific/Guamseat of a first-order administrative division
4043499Inarajan VillageInalahan,Inalajan,InalåhanGUInarajan13.27363144.7484533052Pacific/Guamseat of a first-order administrative division
4038473Piti VillagePetey,Piti Vilage,Piti VillageGUPiti13.46256144.6933131666Pacific/Guamseat of a first-order administrative division
4038647Talofofo VillagePre-WW2 Part of Inarajan,Talo’fo’fo,Talo`fo`foGUTalofofo13.35513144.75835903215Pacific/Guamseat of a first-order administrative division
4038809Yona VillageYo’ na,Yo`na,Yo’ ñaGUYona13.40974144.77697906484Pacific/Guamseat of a first-order administrative division
4043909Dededo VillageDediduGUDededo13.51777144.83919844943Pacific/Guamseat of a first-order administrative division
4043812Asan-Maina VillageAssanGUAsan13.47215144.7165432137Pacific/Guamseat of a first-order administrative division
4038659Tamuning-Tumon-Harmon VillageMaria Christina,TimonengGUTamuning13.48773144.781381319685Pacific/Guamseat of a first-order administrative division
7874008Hagåtña VillageAgana -1998,Akashi WW2GUHagatna13.47279144.7580241051Pacific/Guampopulated place
4038733Umatac VillageHumatak,Humåtak,San Antonio de Umatag,Umatag,Ville D’UmataGUUmatac13.29843144.663143903Pacific/Guamseat of a first-order administrative division
4043804Agat VillageHagat,HågatGUAgat13.383144.6600335656Pacific/Guamseat of a first-order administrative division

FaQ about Guam

Once you have placed your order, you can download the product straight away! You'll also immediately receive an order confirmation email in which you can download your product. Remember to check your spam.
Don't panic, just log back in to the site and click on "your account" in the menu. You'll be able to find all your orders and re-download them whenever you like.
Yes, of course, click here to retrieve an archive containing an extract of the 4 CSV, XML, JSON and SQL files for a country.
Absolutely! You can pay with paypal or stripe in total security.
  • Geoname_ID: This is a unique identifier for each place or geographical name in the Geoname database.
  • City: The name of the place, which can be a town, village or any other form of human settlement.
  • Alternate_Name: Other names or appellations that the place may have. These alternative names may be in different languages, dialects or even local names.
  • Country_Code: This is the ISO 3166-1 alpha-2 code for the country in which the place is located. For example, "US" for the United States, "FR" for France.
  • Region: This represents the first-order administrative division in which the location is situated. For example, this could be a state, province or territory.
  • Sub_region: This is a second-order administrative division, such as a county or district, within the region.
  • Latitude: The geographical latitude of the location, usually in decimal degrees.
  • Longitude: The geographical longitude of the location, also usually in decimal degrees.
  • Elevation: The elevation or altitude of the location in relation to sea level, usually measured in metres.
  • Population: The estimated number of inhabitants or population of the location.
  • Timezone: The time zone in which the location is located, in accordance with global time zone standards.
  • Fcode_Name: This is a code that categorises the type of location. For example, "PPL" could mean a populated place, while "PPLC" could be the capital of a political entity.
You will retrieve a .rar archive containing the country files in csv, sql, xml and json formats.
Yes, you'll be able to download the content you've purchased whenever you want, with no time limit.
Make sure your Internet connection is stable, as some files can be quite large and take a long time to download.
Unfortunately we don't offer files in excel format, but it's really very easy to convert a csv file into excel. There are a plethora of free online sites that allow you to do this, here are a few: click here to convert csv to excel

List of countries :

h2020-flow.eu

With the aim of delivering reliable information, based on quality sources such as Geoname, we, a team of passionate geographers, have created this site. To enable you to obtain databases at very competitive prices.