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.

23 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. thank you very much

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

    ReplyDelete
  14. Really good and useful work !!

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

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

    ReplyDelete