Thursday, September 2, 2010

Sri Lanka District and City List Sql File

For a recent project I had to find all the Sri Lankan District and related Cities to populate in two drop downs. The list is not fully complete and Kilinochchi District is not in the list.
Districts - 24
Cities - 2044

Two tables, city table refer district table by did.

Download Sri Lankan District - City Sql file

You can easily import this sql file to mysql using phpmyadmin.
at
Labels: , , ,

25 comments:

  1. AnonymousMarch 30, 2011 at 9:08 PM

    this is very useful. thank you very much. good luck

    ReplyDelete
  2. AnonymousJune 20, 2011 at 12:35 AM

    thanks lot

    ReplyDelete
  3. AnonymousJune 20, 2011 at 12:36 AM

    thanks thanks lot.good luck

    ReplyDelete
  4. UnknownJuly 26, 2011 at 3:20 PM

    Thanxx machan... Really helpfull :)) Wish u all the best..!! :))

    ReplyDelete
  5. AnonymousJanuary 11, 2012 at 4:18 PM

    Thanks bro,
    was really helpful...

    SLIIT rocks :)

    ReplyDelete
  6. AnonymousMay 20, 2012 at 10:59 AM

    Hi This is very helpful to me

    Wish you all the best

    ReplyDelete
  7. Maduka JayalathJune 3, 2012 at 8:33 AM

    Thank you very much machan, Little suggestion, It would be nice if the Colombo comes like this,

    (12, 1, 'Colombo 01'),
    (13, 1, 'Colombo 02'),
    (14, 1, 'Colombo 03'),
    (15, 1, 'Colombo 04'),
    (16, 1, 'Colombo 05'),
    (17, 1, 'Colombo 06'),
    (18, 1, 'Colombo 07'),
    (19, 1, 'Colombo 08'),
    (20, 1, 'Colombo 09'),
    (21, 1, 'Colombo 10'),
    (22, 1, 'Colombo 11'),
    (23, 1, 'Colombo 12'),
    (24, 1, 'Colombo 13'),
    (25, 1, 'Colombo 14'),
    (26, 1, 'Colombo 15'),

    Also this link might be help you for future development, Maybe we can scrape data from there.

    http://www.fallingrain.com/world/CE/

    Keep up your good work, All the best!!

    ReplyDelete
  8. AnonymousJune 19, 2012 at 4:49 PM

    Thank you very much. You save my time. Good luck!

    ReplyDelete
  9. AdminOctober 1, 2012 at 8:35 PM

    Thanks bro

    SLIIT always teach lessons

    ReplyDelete
  10. SusiJNovember 28, 2012 at 11:13 AM

    Thanks! A great resource. Appreciate if you can make it a fully completed list.

    ReplyDelete
  11. anandaApril 16, 2013 at 12:59 AM

    send your database to info@osclass.org

    They will create a plugin for our country for use with os class script.

    Thanks

    ReplyDelete
  12. anandaApril 16, 2013 at 1:00 AM

    Dear friend, I have a partially created database like this. Can you complete it by merging with these details. 0714-394219 Ananda

    ReplyDelete
  13. AnonymousJuly 5, 2013 at 5:20 PM

    Nice.

    ReplyDelete
  14. AnonymousJune 22, 2014 at 5:13 PM

    Thanks a lot...
    sliit really rocks...

    ReplyDelete
  15. AnonymousJuly 17, 2014 at 4:11 PM

    Really good and useful work !!

    ReplyDelete
  16. Coding ExNovember 22, 2014 at 12:16 PM

    Ela bn thankz

    ReplyDelete
  17. Coding ExNovember 22, 2014 at 12:16 PM

    ela bn thankz

    ReplyDelete
  18. AnonymousNovember 22, 2014 at 12:17 PM

    Ela bn thankz

    ReplyDelete
  19. අමාAugust 26, 2015 at 9:32 PM

    Thank you machan

    ReplyDelete
  20. UnknownSeptember 24, 2015 at 9:02 PM

    Thank you very much, found it very useful, keep up your good work

    ReplyDelete
  21. AnonymousFebruary 14, 2016 at 11:09 AM

    thanks mate :)

    ReplyDelete
  22. Life PartnerFebruary 28, 2016 at 12:13 AM

    Thank you so much. It helped me lot.

    ReplyDelete
  23. AnonymousNovember 25, 2017 at 12:04 PM

    අම්මේ... උබට දහස් වාරයක් පිං මචං. තව පොඩ්ඩෙන් ඔක්කොම අතින් ගහන්න වෙනවා...

    ReplyDelete
  24. umairahmadhNovember 9, 2018 at 6:40 AM

    Thanks for it,
    And, You missed one district, "Kilinochi"

    (http://coins.lakdiva.org/d25/districts.html)

    ReplyDelete
  25. umairahmadhNovember 9, 2018 at 7:43 AM

    I have edited your details and added Provinces, added the missing Kilinochi District


    I have created a GitHub Repo, Feel free to contribute.
    Everyone, if you have any datasets related with Sri Lanka, feel free to share it with the following GitHub Repo
    https://github.com/umairahmadh/sriLankaSQL

    ReplyDelete

Subscribe to: Post Comments (Atom)