madurapa/sri-lanka-provinces-districts-cities

Download Sri Lanka Provinces Districts Cities Postal Codes Database

sri-lanka-provinces-districts-cities's Issues

Hanguranketha does not belong to Kandy.

Hanguranketa town and Marymount colony do not belong to the Kandy district. Update them as towns in the Nuwara-Eliya District.
reference:
https://en.wikipedia.org/wiki/Hanguranketha
http://www.dinamina.lk/2017/07/05/%E0%B6%B4%E0%B7%8A%E2%80%8D%E0%B6%BB%E0%B7%8F%E0%B6%AF%E0%B7%9A%E0%B7%81%E0%B7%93%E0%B6%BA/36842?page=7

The name Gunnepana should be changed to "ගුන්නෑපාන" when writing in Sinhala.
The name Kolabissa should be changed to "කොළඹිස්ස" when writing in Sinhala.
The name Rantebe should be changed to "රන්ටැඹේ" when writing in Sinhala.

Incomplete city table

City table is incomplete. Please check

wrong charset of the province table

charset of the province table should be utf8

CREATE TABLE IF NOT EXISTS provinces(idint(11) NOT NULL AUTO_INCREMENT,name_envarchar(45) NOT NULL,name_sivarchar(45) DEFAULT NULL,name_ta varchar(45) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

Translation Effort For Sinhala And Tamil

Hey all,

We've been working on a project for some time, building a memorial for those who lost their lives to COVID-19.
As the site is localized to all 3 languages, we have translated some city data to Sinhala & Tamil. Currently, we're just translating whatever cities we have used in our project.

I initially dump'd the data of your great project into JSON from MySQL as that was easy for me to handle.
The translation is done over Google Sheets and dumped automatically to this JSON file.

I'd love for these changes to hit upstream as well. Thanks!

Incorrect district id for city "Akurana"

sri-lanka-provinces-districts-cities/cities.sql

Line 1061 in 2a31a14

(1032, 14, 'Akurana', 'අකුරණ', NULL, NULL, NULL, NULL, '20850', 7.637034, 80.023362),

the above record "Akurana" city is part of Kandy district, hence the district code should be 2.