Sri Lanka cities list with latitude and longitude in CSV format

Sri_Lanka
Sri Lanka
CSV, SQL, XML, JSON

Last update : 27 April 2024.

Country
Sri Lanka
Capitale
Colombo
Number of cities
17636
Download

This is the best list of 17636 cities in the Sri Lanka 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 Sri Lanka file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
7623794WattahenaLKSouthernGalle District6.305480.13540Asia/Colombopopulated place
1241749Kandane IhalaKandana Ihala,Kandane IhalaLKUvaBadulla District6.93881.08220Asia/Colombopopulated place
1231769PallegamaLKEastern ProvinceAmpara District7.4333381.250Asia/Colombopopulated place
1232252Pahala KanhidigamaLKNorth CentralAnuradhapura District8.454180.70430Asia/Colombopopulated place
1243578GalawewaGalawewa,Ihala GalawewaLKNorth WesternPuttalam District8.122380.10480Asia/Colombopopulated place
1233593NaullaLKUvaBadulla District6.737481.01670Asia/Colombopopulated place
1227519SuriyapaluwaSuripaluwa,SuriyapaluwaLKWesternGampaha District7.01679.96230Asia/Colombopopulated place
1249276ChalampanLKNorthern ProvinceMannar District8.9580.033330Asia/Colombopopulated place
1242717KadadoraLKSabaragamuwaKegalle District7.068580.24940Asia/Colombopopulated place
1249766BogambaraBogambaraLKCentralMatale District7.493280.66780Asia/Colombopopulated place
1245468GomiarawaLKSabaragamuwaRatnapura District6.6333380.80Asia/Colombopopulated place
1224610WagegodaWagegodaLKSouthernHambantota District6.048580.78170Asia/Colombopopulated place
1225374UriyankadduLKEastern ProvinceBatticaloa District8.1166781.433330Asia/Colombopopulated place
7556943PahudaleLKSouthernGalle District6.325980.25470Asia/Colombopopulated place
1241133KaruwalagaswewaLKNorth WesternKurunegala District7.634280.46040Asia/Colombopopulated place
7437698AmunawewaLKNorth WesternKurunegala District7.380979.93020Asia/Colombopopulated place
1250599BaduraliyaBaduraliya,BadureliyaLKWesternKalutara District6.508480.23290Asia/Colombopopulated place
1223456WeralugasmankadaLKSabaragamuwaRatnapura District6.702780.79180Asia/Colombopopulated place
7544473WalgampataLKSabaragamuwaKegalle District7.124480.21340Asia/Colombopopulated place
1245599GodagamaLKNorth WesternKurunegala District7.445780.39650Asia/Colombopopulated place
1245213GurulubeddaLKWesternKalutara District6.478580.25330Asia/Colombopopulated place
1231915PalatupanaLKSouthernHambantota District6.278781.39770Asia/Colombopopulated place
1249588BorawewaLKNorth WesternKurunegala District7.980.20Asia/Colombopopulated place
1247928DimbulwalaLKSabaragamuwaRatnapura District6.580980.590Asia/Colombopopulated place
1242597KadiheragamaLKNorth CentralAnuradhapura District8.046580.55250Asia/Colombopopulated place
1238475KukulnapeLKWesternGampaha District7.203680.07930Asia/Colombopopulated place
1236354MamunaiLKNorthern ProvinceJaffna District9.661680.35890Asia/Colombopopulated place
1232977NiralgamaLKSabaragamuwaRatnapura District6.63180.41490Asia/Colombopopulated place
1235705MawatupolaLKCentralKandy District7.133380.50830Asia/Colombopopulated place
1239034KottagalaLKUvaMoneragala District6.953381.40840Asia/Colombopopulated place
7439089AmpawilaLKSouthernGalle District6.009280.36190Asia/Colombopopulated place
1239978KitulgalaKitulgalaLKSabaragamuwaKegalle District6.996680.40680Asia/Colombopopulated place
1240449KetandolaLKSouthernGalle District6.078780.30320Asia/Colombopopulated place
1251409AmunugodaLKWesternGampaha District7.042679.97620Asia/Colombopopulated place
7435260ElpitikandaLKCentralKandy District7.215580.53170Asia/Colombopopulated place
1250108BebilepitiyaLKNorth WesternKurunegala District7.627980.48490Asia/Colombopopulated place
1231377PanakaduwaLKNorth WesternKurunegala District7.568580.19990Asia/Colombopopulated place
1224701WadattaWadatta,WadatteLKNorth WesternPuttalam District7.911479.93730Asia/Colombopopulated place
7439052HatangalaLKSouthernGalle District6.045280.31710Asia/Colombopopulated place
1235531MedamukalanaLKWesternKalutara District6.737380.13260Asia/Colombopopulated place
1228424SaintamaruthuLKEastern ProvinceAmpara District7.3833381.833330Asia/Colombopopulated place
1247662DombagahawattaLKNorth WesternPuttalam District7.296279.85750Asia/Colombopopulated place
1230603PelpitaLKWesternGampaha District6.993380.1110Asia/Colombopopulated place
1222873YatagamaLKWesternGampaha District7.174980.03150Asia/Colombopopulated place
1232928NivungamaNivungama,NiwungamaLKWesternColombo District6.777679.95270Asia/Colombopopulated place
1252097Alagalla PahalagamaAlagalla PahalagamaLKCentralKandy District7.309380.47270Asia/Colombopopulated place
1238313KubukwalaKubukwala,KumbukwalaLKSabaragamuwaRatnapura District6.683280.75260Asia/Colombopopulated place
7556785EtigiriyaLKWesternKalutara District6.523680.21470Asia/Colombopopulated place
1233600NatuwalaLKSouthernHambantota District6.134280.69460Asia/Colombopopulated place
1237163MahabadullagammanaLKUvaMoneragala District7.141981.19860Asia/Colombopopulated place
1236544MalaimuntalMalaimuntal,MalaimunthalLKEastern ProvinceTrincomalee District8.4333381.366670Asia/Colombopopulated place
7624590IhalagodaLKSouthernHambantota District6.250180.76910Asia/Colombopopulated place
1234142MutugallaMutugala,MutugallaLKNorth CentralPolonnaruwa District7.9666781.166670Asia/Colombopopulated place
1234885MiyanaulgodaMiyanaula,MiyanaulgodaLKSabaragamuwaRatnapura District6.582380.72790Asia/Colombopopulated place
1244642HatarabageHatarabage,UdagamaLKSabaragamuwaRatnapura District6.655280.75710Asia/Colombopopulated place
1236196ManikkampattiyaManikkampattiya,ManikkanpattiyaLKNorth CentralPolonnaruwa District7.9166781.050Asia/Colombopopulated place
1248652DangahawewaLKNorth WesternPuttalam District8.056880.12280Asia/Colombopopulated place
1222970YakgahaLKSouthernGalle District6.046980.2680Asia/Colombopopulated place
1227004TantiriyawaTantiriyawa,ThantirigamaLKNorth WesternKurunegala District7.8666780.20Asia/Colombopopulated place
1226894TheladiriyaTelandiriya,TheladiriyaLKSabaragamuwaRatnapura District6.597180.73830Asia/Colombopopulated place
1250603BaduluwelaLKUvaMoneragala District7.087881.43290Asia/Colombopopulated place
1239717KokkoluwaLKNorth WesternPuttalam District7.557179.840Asia/Colombopopulated place
1246276GallallaGallalla,GallellaLKSabaragamuwaRatnapura District6.708180.48210Asia/Colombopopulated place
1232253Pahalakande BavulanaPahalakande BavulanaLKCentralKandy District7.212680.73070Asia/Colombopopulated place
1230476PeriyakulamLKNorthern ProvinceVavuniya District9.072380.48230Asia/Colombopopulated place
1232115Pahala TammannewaLKNorth CentralAnuradhapura District8.5833380.70Asia/Colombopopulated place
7547058EllekandaLKSabaragamuwaRatnapura District6.634580.65190Asia/Colombopopulated place
1229970PolambegodaLKSabaragamuwaKegalle District7.194380.45290Asia/Colombopopulated place
1248561DaswattaLKSabaragamuwaKegalle District7.22580.43450Asia/Colombopopulated place
1228301SandanankuttigamaLKNorth CentralAnuradhapura District8.2666780.60Asia/Colombopopulated place
7624363DarmavijayagamaDarmavijayagama,UdagamaLKSouthernMatara District6.134980.59950Asia/Colombopopulated place
1227381TalakolawelaTalakolawelaLKCentralMatale District7.5833380.916670Asia/Colombopopulated place
1225173ValalaiValalaiLKNorthern Province9.8166780.116670Asia/Colombopopulated place
1237305MadulkeleMadulkele,Madulkele BazaarLKCentralKandy District7.397980.7310Asia/Colombopopulated place
1234749Moragane IhalaLKNorth WesternKurunegala District7.550180.14060Asia/Colombopopulated place
1228298SandarakkotuwaLKNorth WesternKurunegala District7.792580.00310Asia/Colombopopulated place
1225822UdubodagamaUdubodagama,UdugodagamaLKNorth WesternKurunegala District7.6833380.350Asia/Colombopopulated place
1251670AmbagahalandaLKNorth WesternKurunegala District7.646980.48630Asia/Colombopopulated place
1223914Weerakodiyana PahalaWeerakodiyana Pahala,Wirakodiyana PahalaLKNorth WesternKurunegala District7.541379.90610Asia/Colombopopulated place
7438756WandepitiyaLKSouthernGalle District6.093180.16280Asia/Colombopopulated place
1246492GalbodaGalboda,GalbodeLKCentralMatale District7.623680.72010Asia/Colombopopulated place
1245454GonadeniyagamaLKNorth CentralAnuradhapura District7.93880.52390Asia/Colombopopulated place
1223303WewaranawetiyaLKNorth WesternKurunegala District8.008680.16690Asia/Colombopopulated place
1227081ThammitaTammita,ThammitaLKNorth WesternKurunegala District7.442980.28730Asia/Colombopopulated place
1230493PeriyakarukkaponeLKNorth Western7.635879.79950Asia/Colombopopulated place
1241076KataragamaKataragama,Katirkramam,Katirkrāmam,katirkamam,Катарагама,கதிர்காமம்,කතරගමLKUvaMoneragala District6.413481.334620935Asia/Colombopopulated place
1244979HalpanwelaLKNorth WesternKurunegala District7.9580.283330Asia/Colombopopulated place
1251571AmbalanmullaAmbalammulla,AmbalanmullaLKWesternGampaha District7.114579.87690Asia/Colombopopulated place
1228975RamukkanaRambukkana,Rammukkana,RamukkanaLKWesternKalutara District6.707279.98230Asia/Colombopopulated place
1241642KandubodagamaLKNorth WesternKurunegala District7.7166780.40Asia/Colombopopulated place
7546849WerellapathanaLKSabaragamuwaRatnapura District6.745680.72820Asia/Colombopopulated place
1248416DekanduwalaDekanduwala,DekanduwelaLKNorth WesternKurunegala District7.7166780.383330Asia/Colombopopulated place
1251170AngodaLKNorth Central8.2333381.250Asia/Colombopopulated place
1229922PolikandiPolicandy,Polikandi,PolikandyLKNorthern ProvinceJaffna District9.8166780.183330Asia/Colombopopulated place
1224765VilattikkulamLKNorthern ProvinceMannar District8.980.350Asia/Colombopopulated place
1250047BelikolapugodaBelikolapagoda,BelikolapugodaLKSouthernGalle District6.007380.29370Asia/Colombopopulated place
1244366HenegedaraHanegedara,HenegedaraLKNorth WesternKurunegala District7.495880.07410Asia/Colombopopulated place
1229870PolwattagamaPolwatta,PolwattagamaLKCentralKandy District7.344580.48520Asia/Colombopopulated place
1245159HabaranaHabarana,HabaraneLKNorth CentralAnuradhapura District8.036380.74670Asia/Colombopopulated place
1226565ThuvarankerniThuvarankerni,TuvarankeniLKNorthern ProvinceMannar District8.979.966670Asia/Colombopopulated place

FaQ about Sri Lanka


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.