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.

25 comments:

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

    ReplyDelete
  2. thanks thanks lot.good luck

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

    ReplyDelete
  4. Thanks bro,
    was really helpful...

    SLIIT rocks :)

    ReplyDelete
  5. Hi This is very helpful to me

    Wish you all the best

    ReplyDelete
  6. 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
  7. Thank you very much. You save my time. Good luck!

    ReplyDelete
  8. Thanks bro

    SLIIT always teach lessons

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

    ReplyDelete
  10. send your database to info@osclass.org

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

    Thanks

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

    ReplyDelete
  12. Thanks a lot...
    sliit really rocks...

    ReplyDelete
  13. Really good and useful work !!

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

    ReplyDelete
  15. Thank you so much. It helped me lot.

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

    ReplyDelete
  17. Thanks for it,
    And, You missed one district, "Kilinochi"

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

    ReplyDelete
  18. 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