GEO Source Code

Following is the list of Pakistan States & Cities List in SQL Format. Will be useful for you in your web applications.

Code: Select all

-- ----------------------------------------------------------------------------

CREATE TABLE tblStates
(
  stateId int(11) NOT NULL,
  countryId int(11),
  name varchar(100),
 
  PRIMARY KEY(stateId)
);

INSERT INTO tblStates VALUES (1,'Azad Kashmir');
INSERT INTO tblStates VALUES (2,'Balochistan');
INSERT INTO tblStates VALUES (3,'NWFP');
INSERT INTO tblStates VALUES (4,'Punjab');
INSERT INTO tblStates VALUES (5,'Sindh');

-- ----------------------------------------------------------------------------

CREATE TABLE tblCities
(
  cityId int(11) NOT NULL AUTO_INCREMENT,
  stateId int(11),
  name varchar(100),
 
  PRIMARY KEY (cityId)
);

INSERT INTO tblCities VALUES (1, 1, 'Bagh');
INSERT INTO tblCities VALUES (2, 1, 'Bhimber');
INSERT INTO tblCities VALUES (3, 1, 'Dhungi');
INSERT INTO tblCities VALUES (4, 1, 'Kotli');
INSERT INTO tblCities VALUES (5, 1, 'Mirpur');
INSERT INTO tblCities VALUES (6, 1, 'Muzaffarabad');
INSERT INTO tblCities VALUES (7, 1, 'Plandri');
INSERT INTO tblCities VALUES (8, 1, 'Rawalakot');
INSERT INTO tblCities VALUES (9, 1, 'Pounch');

INSERT INTO tblCities VALUES (10, 2, 'Amir Chah');
INSERT INTO tblCities VALUES (11, 2, 'Bazdar');
INSERT INTO tblCities VALUES (12, 2, 'Bela');
INSERT INTO tblCities VALUES (13, 2, 'Bellpat');
INSERT INTO tblCities VALUES (14, 2, 'Bagh');
INSERT INTO tblCities VALUES (15, 2, 'Burj');
INSERT INTO tblCities VALUES (16, 2, 'Chagai');
INSERT INTO tblCities VALUES (17, 2, 'Chah Sandan');
INSERT INTO tblCities VALUES (18, 2, 'Chakku');
INSERT INTO tblCities VALUES (19, 2, 'Chaman');
INSERT INTO tblCities VALUES (20, 2, 'Chhatr');
INSERT INTO tblCities VALUES (21, 2, 'Dalbandin');
INSERT INTO tblCities VALUES (22, 2, 'Dera Bugti');
INSERT INTO tblCities VALUES (23, 2, 'Dhana Sar');
INSERT INTO tblCities VALUES (24, 2, 'Diwana');
INSERT INTO tblCities VALUES (25, 2, 'Duki');
INSERT INTO tblCities VALUES (26, 2, 'Dushi');
INSERT INTO tblCities VALUES (27, 2, 'Duzab');
INSERT INTO tblCities VALUES (28, 2, 'Gajar');
INSERT INTO tblCities VALUES (29, 2, 'Gandava');
INSERT INTO tblCities VALUES (30, 2, 'Garhi Khairo');
INSERT INTO tblCities VALUES (31, 2, 'Garruck');
INSERT INTO tblCities VALUES (32, 2, 'Ghazluna');
INSERT INTO tblCities VALUES (33, 2, 'Girdan');
INSERT INTO tblCities VALUES (34, 2, 'Gulistan');
INSERT INTO tblCities VALUES (35, 2, 'Gwadar');
INSERT INTO tblCities VALUES (36, 2, 'Gwash');
INSERT INTO tblCities VALUES (37, 2, 'Hab Chauki');
INSERT INTO tblCities VALUES (38, 2, 'Hameedabad');
INSERT INTO tblCities VALUES (39, 2, 'Harnai');
INSERT INTO tblCities VALUES (40, 2, 'Hinglaj');
INSERT INTO tblCities VALUES (41, 2, 'Hoshab');
INSERT INTO tblCities VALUES (42, 2, 'Ispikan');
INSERT INTO tblCities VALUES (43, 2, 'Jhal');
INSERT INTO tblCities VALUES (44, 2, 'Jhal Jhao');
INSERT INTO tblCities VALUES (45, 2, 'Jhatpat');
INSERT INTO tblCities VALUES (46, 2, 'Jiwani');
INSERT INTO tblCities VALUES (47, 2, 'Kalandi');
INSERT INTO tblCities VALUES (48, 2, 'Kalat');
INSERT INTO tblCities VALUES (49, 2, 'Kamararod');
INSERT INTO tblCities VALUES (50, 2, 'Kanak');
INSERT INTO tblCities VALUES (51, 2, 'Kandi');
INSERT INTO tblCities VALUES (52, 2, 'Kanpur');
INSERT INTO tblCities VALUES (53, 2, 'Kapip');
INSERT INTO tblCities VALUES (54, 2, 'Kappar');
INSERT INTO tblCities VALUES (55, 2, 'Karodi');
INSERT INTO tblCities VALUES (56, 2, 'Katuri');
INSERT INTO tblCities VALUES (57, 2, 'Kharan');
INSERT INTO tblCities VALUES (58, 2, 'Khuzdar');
INSERT INTO tblCities VALUES (59, 2, 'Kikki');
INSERT INTO tblCities VALUES (60, 2, 'Kohan');
INSERT INTO tblCities VALUES (61, 2, 'Kohlu');
INSERT INTO tblCities VALUES (62, 2, 'Korak');
INSERT INTO tblCities VALUES (63, 2, 'Lahri');
INSERT INTO tblCities VALUES (64, 2, 'Lasbela');
INSERT INTO tblCities VALUES (65, 2, 'Liari');
INSERT INTO tblCities VALUES (66, 2, 'Loralai');
INSERT INTO tblCities VALUES (67, 2, 'Mach');
INSERT INTO tblCities VALUES (68, 2, 'Mand');
INSERT INTO tblCities VALUES (69, 2, 'Manguchar');
INSERT INTO tblCities VALUES (70, 2, 'Mashki Chah');
INSERT INTO tblCities VALUES (71, 2, 'Maslti');
INSERT INTO tblCities VALUES (72, 2, 'Mastung');
INSERT INTO tblCities VALUES (73, 2, 'Mekhtar');
INSERT INTO tblCities VALUES (74, 2, 'Merui');
INSERT INTO tblCities VALUES (75, 2, 'Mianez');
INSERT INTO tblCities VALUES (76, 2, 'Murgha Kibzai');
INSERT INTO tblCities VALUES (77, 2, 'Musa Khel Bazar');
INSERT INTO tblCities VALUES (78, 2, 'Nagha Kalat');
INSERT INTO tblCities VALUES (79, 2, 'Nal');
INSERT INTO tblCities VALUES (80, 2, 'Nasirabad');
INSERT INTO tblCities VALUES (81, 2, 'Nauroz Kalat');
INSERT INTO tblCities VALUES (82, 2, 'Nur Gamma');
INSERT INTO tblCities VALUES (83, 2, 'Nushki');
INSERT INTO tblCities VALUES (84, 2, 'Nuttal');
INSERT INTO tblCities VALUES (85, 2, 'Ormara');
INSERT INTO tblCities VALUES (86, 2, 'Palantuk');
INSERT INTO tblCities VALUES (87, 2, 'Panjgur');
INSERT INTO tblCities VALUES (88, 2, 'Pasni');
INSERT INTO tblCities VALUES (89, 2, 'Piharak');
INSERT INTO tblCities VALUES (90, 2, 'Pishin');
INSERT INTO tblCities VALUES (91, 2, 'Qamruddin Karez');
INSERT INTO tblCities VALUES (92, 2, 'Qila Abdullah');
INSERT INTO tblCities VALUES (93, 2, 'Qila Ladgasht');
INSERT INTO tblCities VALUES (94, 2, 'Qila Safed');
INSERT INTO tblCities VALUES (95, 2, 'Qila Saifullah');
INSERT INTO tblCities VALUES (96, 2, 'Quetta');
INSERT INTO tblCities VALUES (97, 2, 'Rakhni');
INSERT INTO tblCities VALUES (98, 2, 'Robat Thana');
INSERT INTO tblCities VALUES (99, 2, 'Rodkhan');
INSERT INTO tblCities VALUES (100, 2, 'Saindak');
INSERT INTO tblCities VALUES (101, 2, 'Sanjawi');
INSERT INTO tblCities VALUES (102, 2, 'Saruna');
INSERT INTO tblCities VALUES (103, 2, 'Shabaz Kalat');
INSERT INTO tblCities VALUES (104, 2, 'Shahpur');
INSERT INTO tblCities VALUES (105, 2, 'Sharam Jogizai');
INSERT INTO tblCities VALUES (106, 2, 'Shingar');
INSERT INTO tblCities VALUES (107, 2, 'Shorap');
INSERT INTO tblCities VALUES (108, 2, 'Sibi');
INSERT INTO tblCities VALUES (109, 2, 'Sonmiani');
INSERT INTO tblCities VALUES (110, 2, 'Spezand');
INSERT INTO tblCities VALUES (111, 2, 'Spintangi');
INSERT INTO tblCities VALUES (112, 2, 'Sui');
INSERT INTO tblCities VALUES (113, 2, 'Suntsar');
INSERT INTO tblCities VALUES (114, 2, 'Surab');
INSERT INTO tblCities VALUES (115, 2, 'Thalo');
INSERT INTO tblCities VALUES (116, 2, 'Tump');
INSERT INTO tblCities VALUES (117, 2, 'Turbat');
INSERT INTO tblCities VALUES (118, 2, 'Umarao');
INSERT INTO tblCities VALUES (119, 2, 'Uthal');
INSERT INTO tblCities VALUES (120, 2, 'Vitakri');
INSERT INTO tblCities VALUES (121, 2, 'Wadh');
INSERT INTO tblCities VALUES (122, 2, 'Washap');
INSERT INTO tblCities VALUES (123, 2, 'Wasjuk');
INSERT INTO tblCities VALUES (124, 2, 'Yakmach');
INSERT INTO tblCities VALUES (125, 2, 'Zhob');

INSERT INTO tblCities VALUES (126, 3, 'Abbottabad');
INSERT INTO tblCities VALUES (127, 3, 'Ayubia');
INSERT INTO tblCities VALUES (128, 3, 'Adezai');
INSERT INTO tblCities VALUES (129, 3, 'Banda Daud Shah');
INSERT INTO tblCities VALUES (130, 3, 'Bannu');
INSERT INTO tblCities VALUES (131, 3, 'Batagram');
INSERT INTO tblCities VALUES (132, 3, 'Birote');
INSERT INTO tblCities VALUES (133, 3, 'Buner');
INSERT INTO tblCities VALUES (134, 3, 'Chakdara');
INSERT INTO tblCities VALUES (135, 3, 'Charsadda');
INSERT INTO tblCities VALUES (136, 3, 'Chitral');
INSERT INTO tblCities VALUES (137, 3, 'Dargai');
INSERT INTO tblCities VALUES (138, 3, 'Darya Khan');
INSERT INTO tblCities VALUES (139, 3, 'Dera Ismail Khan');
INSERT INTO tblCities VALUES (140, 3, 'Drosh');
INSERT INTO tblCities VALUES (141, 3, 'Hangu');
INSERT INTO tblCities VALUES (142, 3, 'Haripur');
INSERT INTO tblCities VALUES (143, 3, 'Kalam');
INSERT INTO tblCities VALUES (144, 3, 'Karak');
INSERT INTO tblCities VALUES (145, 3, 'Khanaspur');
INSERT INTO tblCities VALUES (146, 3, 'Kohat');
INSERT INTO tblCities VALUES (147, 3, 'Kohistan');
INSERT INTO tblCities VALUES (148, 3, 'Lakki Marwat');
INSERT INTO tblCities VALUES (149, 3, 'Latamber');
INSERT INTO tblCities VALUES (150, 3, 'Lower Dir');
INSERT INTO tblCities VALUES (151, 3, 'Madyan');
INSERT INTO tblCities VALUES (152, 3, 'Malakand');
INSERT INTO tblCities VALUES (153, 3, 'Mansehra');
INSERT INTO tblCities VALUES (154, 3, 'Mardan');
INSERT INTO tblCities VALUES (155, 3, 'Mastuj');
INSERT INTO tblCities VALUES (156, 3, 'Mongora');
INSERT INTO tblCities VALUES (157, 3, 'Nowshera');
INSERT INTO tblCities VALUES (158, 3, 'Paharpur');
INSERT INTO tblCities VALUES (159, 3, 'Peshawar');
INSERT INTO tblCities VALUES (160, 3, 'Saidu Sharif');
INSERT INTO tblCities VALUES (161, 3, 'Shangla');
INSERT INTO tblCities VALUES (162, 3, 'Swabi');
INSERT INTO tblCities VALUES (163, 3, 'Swat');
INSERT INTO tblCities VALUES (164, 3, 'Tangi');
INSERT INTO tblCities VALUES (165, 3, 'Tank');
INSERT INTO tblCities VALUES (166, 3, 'Tordher');
INSERT INTO tblCities VALUES (167, 3, 'Upper Dir');

INSERT INTO tblCities VALUES (168, 4, 'Attock');
INSERT INTO tblCities VALUES (169, 4, 'Bhalwal');
INSERT INTO tblCities VALUES (170, 4, 'Bahawalnagar');
INSERT INTO tblCities VALUES (171, 4, 'Bahawalpur');
INSERT INTO tblCities VALUES (172, 4, 'Bhakkar');
INSERT INTO tblCities VALUES (173, 4, 'Burewala');
INSERT INTO tblCities VALUES (174, 4, 'Chailianwala');
INSERT INTO tblCities VALUES (175, 4, 'Chakwal');
INSERT INTO tblCities VALUES (176, 4, 'Chichawatni');
INSERT INTO tblCities VALUES (177, 4, 'Chiniot');
INSERT INTO tblCities VALUES (178, 4, 'Daska');
INSERT INTO tblCities VALUES (179, 4, 'Darya Khan');
INSERT INTO tblCities VALUES (180, 4, 'Dera Ghazi Khan');
INSERT INTO tblCities VALUES (181, 4, 'Dina');
INSERT INTO tblCities VALUES (182, 4, 'Dinga');
INSERT INTO tblCities VALUES (183, 4, 'Faisalabad');
INSERT INTO tblCities VALUES (184, 4, 'Fateh Jang');
INSERT INTO tblCities VALUES (185, 4, 'Ghakhar Mandi');
INSERT INTO tblCities VALUES (186, 4, 'Gujranwala');
INSERT INTO tblCities VALUES (187, 4, 'Gujrat');
INSERT INTO tblCities VALUES (188, 4, 'Gujar Khan');
INSERT INTO tblCities VALUES (189, 4, 'Hafizabad');
INSERT INTO tblCities VALUES (190, 4, 'Hasilpur');
INSERT INTO tblCities VALUES (191, 4, 'Haveli Lakha');
INSERT INTO tblCities VALUES (192, 4, 'Islamabad');
INSERT INTO tblCities VALUES (193, 4, 'Jampur');
INSERT INTO tblCities VALUES (194, 4, 'Jhang');
INSERT INTO tblCities VALUES (195, 4, 'Jhelum');
INSERT INTO tblCities VALUES (196, 4, 'Kasur');
INSERT INTO tblCities VALUES (197, 4, 'Kamalia');
INSERT INTO tblCities VALUES (198, 4, 'Kamokey');
INSERT INTO tblCities VALUES (199, 4, 'Khanewal');
INSERT INTO tblCities VALUES (200, 4, 'Khushab');
INSERT INTO tblCities VALUES (201, 4, 'Jauharabad');
INSERT INTO tblCities VALUES (202, 4, 'Lahore');
INSERT INTO tblCities VALUES (203, 4, 'Layyah');
INSERT INTO tblCities VALUES (204, 4, 'Leiah');
INSERT INTO tblCities VALUES (205, 4, 'Lodhran');
INSERT INTO tblCities VALUES (206, 4, 'Mandi Bahauddin');
INSERT INTO tblCities VALUES (207, 4, 'Mian Channu');
INSERT INTO tblCities VALUES (208, 4, 'Mianwali');
INSERT INTO tblCities VALUES (209, 4, 'Multan');
INSERT INTO tblCities VALUES (210, 4, 'Muridke');
INSERT INTO tblCities VALUES (211, 4, 'Muzaffar Garh');
INSERT INTO tblCities VALUES (212, 4, 'Okara');
INSERT INTO tblCities VALUES (213, 4, 'Renala Khurd');
INSERT INTO tblCities VALUES (214, 4, 'Rajan Pur');
INSERT INTO tblCities VALUES (215, 4, 'Pirmahal');
INSERT INTO tblCities VALUES (216, 4, 'Rabwah');
INSERT INTO tblCities VALUES (217, 4, 'Rahim Yar Khan');
INSERT INTO tblCities VALUES (218, 4, 'Rawalpindi');
INSERT INTO tblCities VALUES (219, 4, 'Sadiqabad');
INSERT INTO tblCities VALUES (220, 4, 'Safdar Abad - (Dhaban Singh)');
INSERT INTO tblCities VALUES (221, 4, 'Sahiwal');
INSERT INTO tblCities VALUES (222, 4, 'Sargodha');
INSERT INTO tblCities VALUES (223, 4, 'Shakargarh');
INSERT INTO tblCities VALUES (224, 4, 'Sheikhupura');
INSERT INTO tblCities VALUES (225, 4, 'Sialkot');
INSERT INTO tblCities VALUES (226, 4, 'Sohawa');
INSERT INTO tblCities VALUES (227, 4, 'Sooianwala');
INSERT INTO tblCities VALUES (228, 4, 'Sundar (city)');
INSERT INTO tblCities VALUES (229, 4, 'Toba Tek Singh');
INSERT INTO tblCities VALUES (230, 4, 'Vehari');
INSERT INTO tblCities VALUES (231, 4, 'Wah Cantt');
INSERT INTO tblCities VALUES (232, 4, 'Wazirabad');
INSERT INTO tblCities VALUES (233, 4, 'kharian');

INSERT INTO tblCities VALUES (234, 5, 'Ghanian');
INSERT INTO tblCities VALUES (235, 5, 'Ali Bandar');
INSERT INTO tblCities VALUES (236, 5, 'Baden');
INSERT INTO tblCities VALUES (237, 5, 'Chachro');
INSERT INTO tblCities VALUES (238, 5, 'Dadu');
INSERT INTO tblCities VALUES (239, 5, 'Digri');
INSERT INTO tblCities VALUES (240, 5, 'Diplo');
INSERT INTO tblCities VALUES (241, 5, 'Dokri');
INSERT INTO tblCities VALUES (242, 5, 'Gadra');
INSERT INTO tblCities VALUES (243, 5, 'Ghauspur');
INSERT INTO tblCities VALUES (244, 5, 'Ghotki');
INSERT INTO tblCities VALUES (245, 5, 'Hala');
INSERT INTO tblCities VALUES (246, 5, 'Hyderabad');
INSERT INTO tblCities VALUES (247, 5, 'Islamkot');
INSERT INTO tblCities VALUES (248, 5, 'Jacobabad');
INSERT INTO tblCities VALUES (249, 5, 'Jamesabad');
INSERT INTO tblCities VALUES (250, 5, 'Jamshoro');
INSERT INTO tblCities VALUES (251, 5, 'Janghar');
INSERT INTO tblCities VALUES (252, 5, 'Jati (Mughalbhin)');
INSERT INTO tblCities VALUES (253, 5, 'Jhudo');
INSERT INTO tblCities VALUES (254, 5, 'Jungshahi');
INSERT INTO tblCities VALUES (255, 5, 'Kandiaro');
INSERT INTO tblCities VALUES (256, 5, 'Karachi');
INSERT INTO tblCities VALUES (257, 5, 'Kashmor');
INSERT INTO tblCities VALUES (258, 5, 'Keti Bandar');
INSERT INTO tblCities VALUES (259, 5, 'Khairpur');
INSERT INTO tblCities VALUES (260, 5, 'Khora');
INSERT INTO tblCities VALUES (261, 5, 'Klupro');
INSERT INTO tblCities VALUES (262, 5, 'Khokhropur');
INSERT INTO tblCities VALUES (263, 5, 'Korangi');
INSERT INTO tblCities VALUES (264, 5, 'Kotri');
INSERT INTO tblCities VALUES (265, 5, 'Kot Sarae');
INSERT INTO tblCities VALUES (266, 5, 'Larkana');
INSERT INTO tblCities VALUES (267, 5, 'Lund');
INSERT INTO tblCities VALUES (268, 5, 'Mathi');
INSERT INTO tblCities VALUES (269, 5, 'Matiari');
INSERT INTO tblCities VALUES (270, 5, 'Mehar');
INSERT INTO tblCities VALUES (271, 5, 'Mirpur Batoro');
INSERT INTO tblCities VALUES (272, 5, 'Mirpur Khas');
INSERT INTO tblCities VALUES (273, 5, 'Mirpur Sakro');
INSERT INTO tblCities VALUES (274, 5, 'Mithi');
INSERT INTO tblCities VALUES (275, 5, 'Mithani');
INSERT INTO tblCities VALUES (276, 5, 'Moro');
INSERT INTO tblCities VALUES (277, 5, 'Nagar Parkar');
INSERT INTO tblCities VALUES (278, 5, 'Naushara');
INSERT INTO tblCities VALUES (279, 5, 'Nawabshah');
INSERT INTO tblCities VALUES (280, 5, 'Nazimabad');
INSERT INTO tblCities VALUES (281, 5, 'Naokot');
INSERT INTO tblCities VALUES (282, 5, 'Pokran');
INSERT INTO tblCities VALUES (283, 5, 'Qambar');
INSERT INTO tblCities VALUES (284, 5, 'Qazi Ahmad');
INSERT INTO tblCities VALUES (285, 5, 'Ranipur');
INSERT INTO tblCities VALUES (286, 5, 'Ratodero');
INSERT INTO tblCities VALUES (287, 5, 'Rohri');
INSERT INTO tblCities VALUES (288, 5, 'Sakrand');
INSERT INTO tblCities VALUES (289, 5, 'Shadadkhot');
INSERT INTO tblCities VALUES (290, 5, 'Shahbandar');
INSERT INTO tblCities VALUES (291, 5, 'Shahdadpur');
INSERT INTO tblCities VALUES (292, 5, 'Shahpur Chakar');
INSERT INTO tblCities VALUES (293, 5, 'Shikarpur');
INSERT INTO tblCities VALUES (294, 5, 'Sujawal');
INSERT INTO tblCities VALUES (295, 5, 'Sukkur');
INSERT INTO tblCities VALUES (296, 5, 'Tando Adam');
INSERT INTO tblCities VALUES (297, 5, 'Tando Bago');
INSERT INTO tblCities VALUES (298, 5, 'Tar Ahamd Rind');
INSERT INTO tblCities VALUES (299, 5, 'Thatta');
INSERT INTO tblCities VALUES (300, 5, 'Tujal');
INSERT INTO tblCities VALUES (301, 5, 'Umarkot');
INSERT INTO tblCities VALUES (302, 5, 'Veirwaro');
INSERT INTO tblCities VALUES (303, 5, 'Pendoo');
INSERT INTO tblCities VALUES (304, 5, 'Warah');
INSERT INTO tblCities VALUES (305, 5, 'Kamber');

-- ----------------------------------------------------------------------------