全球城市数据表和json数据

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; CREATE TABLE IF NOT EXISTS `cities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `state_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=47577 ; INSERT INTO `cities` (`id`, `name`, `state_id`) VALUES (1, 'Bombuflat', 1), (2, 'Garacharma', 1), (3, 'Port Blair', 1), (4, 'Rangat', 1), (5, 'Addanki', 2), (6, 'Adivivaram', 2), (7, 'Adoni', 2), (8, 'Aganampudi', 2), (9, 'Ajjaram', 2), (10, 'Akividu', 2), (11, 'Akkarampalle', 2), (12, 'Akkayapalle', 2), (13, 'Akkireddipalem', 2), (14, 'Alampur', 2), (15, 'Amalapuram', 2), (16, 'Amudalavalasa', 2), (17, 'Amur', 2), (18, 'Anakapalle', 2), (19, 'Anantapur', 2), (20, 'Andole', 2), (21, 'Atmakur', 2), (22, 'Attili', 2), (23, 'Avanigadda', 2), (24, 'Badepalli', 2), (25, 'Badvel', 2), (26, 'Balapur', 2), (27, 'Bandarulanka', 2), (28, 'Banganapalle', 2), (29, 'Bapatla', 2), (30, 'Bapulapadu', 2), (31, 'Belampalli', 2), (32, 'Bestavaripeta', 2), (33, 'Betamcherla', 2), (34, 'Bhattiprolu', 2), (35, 'Bhimavaram', 2), (36, 'Bhimunipatnam', 2), (37, 'Bobbili', 2), (38, 'Bombuflat', 2), (39, 'Bommuru', 2), (40, 'Bugganipalle', 2), (41, 'Challapalle', 2), (42, 'Chandur', 2), (43, 'Chatakonda', 2), (44, 'Chemmumiahpet', 2), (45, 'Chidiga', 2), (46, 'Chilakaluripet', 2), (47, 'Chimakurthy', 2), (48, 'Chinagadila', 2), (49, 'Chinagantyada', 2), (50, 'Chinnachawk', 2), (51, 'Chintalavalasa', 2), (52, 'Chipurupalle', 2), (53, 'Chirala', 2), (54, 'Chittoor', 2), (55, 'Chodavaram', 2), (56, 'Choutuppal', 2), (57, 'Chunchupalle', 2), (58, 'Cuddapah', 2), (59, 'Cumbum', 2), (60, 'Darnakal', 2), (61, 'Dasnapur', 2), (62, 'Dauleshwaram', 2), (63, 'Dharmavaram', 2), (64, 'Dhone', 2), (65, 'Dommara Nandyal', 2), (66, 'Dowlaiswaram', 2), (67, 'East Godavari Dist.', 2), (68, 'Eddumailaram', 2), (69, 'Edulapuram', 2), (70, 'Ekambara kuppam', 2), (71, 'Eluru', 2), (72, 'Enikapadu', 2), (73, 'Fakirtakya', 2), (74, 'Farrukhnagar', 2), (75, 'Gaddiannaram', 2), (76, 'Gajapathinagaram', 2), (77, 'Gajularega', 2), (78, 'Gajuvaka', 2), (79, 'Gannavaram', 2), (80, 'Garacharma', 2), (81, 'Garimellapadu', 2), (82, 'Giddalur', 2), (83, 'Godavarikhani', 2), (84, 'Gopalapatnam', 2), (85, 'Gopalur', 2), (86, 'Gorrekunta', 2), (87, 'Gudivada', 2), (88, 'Gudur', 2), (89, 'Guntakal', 2), (90, 'Guntur', 2), (91, 'Guti', 2), (92, 'Hindupur', 2), (93, 'Hukumpeta', 2), (94, 'Ichchapuram', 2), (95, 'Isnapur', 2), (96, 'Jaggayyapeta', 2), (97, 'Jallaram Kamanpur', 2), (98, 'Jammalamadugu', 2), (99, 'Jangampalli', 2), (100, 'Jarjapupeta', 2), (101, 'Kadiri', 2), (102, 'Kaikalur', 2), (103, 'Kakinada', 2), (104, 'Kallur', 2), (105, 'Kalyandurg', 2), (106, 'Kamalapuram', 2), (107, 'Kamareddi', 2), (108, 'Kanapaka', 2), (109, 'Kanigiri', 2), (110, 'Kanithi', 2), (111, 'Kankipadu', 2), (112, 'Kantabamsuguda', 2), (113, 'Kanuru', 2), (114, 'Karnul', 2), (115, 'Katheru', 2), (116, 'Kavali', 2), (117, 'Kazipet', 2), (118, 'Khanapuram Haveli', 2), (119, 'Kodar', 2), (120, 'Kollapur', 2), (121, 'Kondapalem', 2), (122, 'Kondapalle', 2), (123, 'Kondukur', 2), (124, 'Kosgi', 2), (125, 'Kothavalasa', 2), (126, 'Kottapalli', 2), (127, 'Kovur', 2), (128, 'Kovurpalle', 2), (129, 'Kovvur', 2), (130, 'Krishna', 2), (131, 'Kuppam', 2), (132, 'Kurmannapalem', 2), (133, 'Kurnool', 2), (134, 'Lakshettipet', 2), (135, 'Lalbahadur Nagar', 2), (136, 'Machavaram', 2), (137, 'Macherla', 2), (138, 'Machilipatnam', 2), (139, 'Madanapalle', 2), (140, 'Madaram', 2), (141, 'Madhuravada', 2), (142, 'Madikonda', 2), (143, 'Madugule', 2), (144, 'Mahabubnagar', 2), (145, 'Mahbubabad', 2), (146, 'Malkajgiri', 2), (147, 'Mamilapalle', 2), (148, 'Mancheral', 2), (149, 'Mandapeta', 2), (150, 'Mandasa', 2), (151, 'Mangalagiri', 2), (152, 'Manthani', 2), (153, 'Markapur', 2), (154, 'Marturu', 2), (155, 'Metpalli', 2), (156, 'Mindi', 2), (157, 'Mirpet', 2), (158, 'Moragudi', 2), (159, 'Mothugudam', 2), (160, 'Nagari', 2), (161, 'Nagireddipalle', 2), (162, 'Nandigama', 2), (163, 'Nandikotkur', 2), (164, 'Nandyal', 2), (165, 'Narasannapeta', 2), (166, 'Narasapur', 2), (167, 'Narasaraopet', 2), (168, 'Narayanavanam', 2), (169, 'Narsapur', 2), (170, 'Narsingi', 2), (171, 'Narsipatnam', 2), (172, 'Naspur', 2), (173, 'Nathayyapalem', 2), (174, 'Nayudupeta', 2), (175, 'Nelimaria', 2), (176, 'Nellore', 2), (177, 'Nidadavole', 2), (178, 'Nuzvid', 2), (179, 'Omerkhan daira', 2), (180, 'Ongole', 2), (181, 'Osmania University', 2), (182, 'Pakala', 2), (183, 'Palakole', 2), (184, 'Palakurthi', 2), (185, 'Palasa', 2), (186, 'Palempalle', 2), (187, 'Palkonda', 2), (188, 'Palmaner', 2), (189, 'Pamur', 2), (190, 'Panjim', 2), (191, 'Papampeta', 2), (192, 'Parasamba', 2), (193, 'Parvatipuram', 2), (194, 'Patancheru', 2), (195, 'Payakaraopet', 2), (196, 'Pedagantyada', 2), (197, 'Pedana', 2), (198, 'Peddapuram', 2), (199, 'Pendurthi', 2), (200, 'Penugonda', 2), (201, 'Penukonda', 2), (202, 'Phirangipuram', 2), (203, 'Pithapuram', 2), (204, 'Ponnur', 2), (205, 'Port Blair', 2), (206, 'Pothinamallayyapalem', 2), (207, 'Prakasam', 2), (208, 'Prasadampadu', 2), (209, 'Prasantinilayam', 2), (210, 'Proddatur', 2), (211, 'Pulivendla', 2), (212, 'Punganuru', 2), (213, 'Puttur', 2), (214, 'Qutubullapur', 2), (215, 'Rajahmundry', 2), (216, 'Rajamahendri', 2), (217, 'Rajampet', 2), (218, 'Rajendranagar', 2), (219, 'Rajoli', 2), (220, 'Ramachandrapuram', 2), (221, 'Ramanayyapeta', 2), (222, 'Ramapuram', 2), (223, 'Ramarajupalli', 2), (224, 'Ramavarappadu', 2), (225, 'Rameswaram', 2), (226, 'Rampachodavaram', 2), (227, 'Ravulapalam', 2), (228, 'Rayachoti', 2), (229, 'Rayadrug', 2), (230, 'Razam', 2), (231, 'Razole', 2), (232, 'Renigunta', 2), (233, 'Repalle', 2), (234, 'Rishikonda', 2), (235, 'Salur', 2), (236, 'Samalkot', 2), (237, 'Sattenapalle', 2), (238, 'Seetharampuram', 2), (239, 'Serilungampalle', 2), (240, 'Shankarampet', 2), (241, 'Shar', 2), (242, 'Singarayakonda', 2), (243, 'Sirpur', 2), (244, 'Sirsilla', 2), (245, 'Sompeta', 2), (246, 'Sriharikota', 2), (247, 'Srikakulam', 2), (248, 'Srikalahasti', 2), (249, 'Sriramnagar', 2), (250, 'Sriramsagar', 2), (251, 'Srisailam', 2), (252, 'Srisailamgudem Devasthanam', 2), (253, 'Sulurpeta', 2), (254, 'Suriapet', 2), (255, 'Suryaraopet', 2), (256, 'Tadepalle', 2), (257, 'Tadepalligudem', 2), (258, 'Tadpatri', 2), (259, 'Tallapalle', 2), (260, 'Tanuku', 2), (261, 'Tekkali', 2), (262, 'Tenali', 2), (263, 'Tigalapahad', 2), (264, 'Tiruchanur', 2), (265, 'Tirumala', 2), (266, 'Tirupati', 2), (267, 'Tirvuru', 2), (268, 'Trimulgherry', 2), (269, 'Tuni', 2), (270, 'Turangi', 2), (271, 'Ukkayapalli', 2), (272, 'Ukkunagaram', 2), (273, 'Uppal Kalan', 2), (274, 'Upper Sileru', 2), (275, 'Uravakonda', 2), (276, 'Vadlapudi', 2), (277, 'Vaparala', 2), (278, 'Vemalwada', 2), (279, 'Venkatagiri', 2), (280, 'Venkatapuram', 2), (281, 'Vepagunta', 2), (282, 'Vetapalem', 2), (283, 'Vijayapuri', 2), (284, 'Vijayapuri South', 2), (285, 'Vijayawada', 2), (286, 'Vinukonda', 2), (287, 'Visakhapatnam', 2), (288, 'Vizianagaram', 2), (289, 'Vuyyuru', 2), (290, 'Wanparti', 2), (291, 'West Godavari Dist.', 2), (292, 'Yadagirigutta', 2), (293, 'Yarada', 2), (294, 'Yellamanchili', 2), (295, 'Yemmiganur', 2), (296, 'Yenamalakudru', 2), (297, 'Yendada', 2), (298, 'Yerraguntla', 2), (299, 'Along', 3), (300, 'Basar', 3), (301, 'Bondila', 3), (302, 'Changlang', 3), (303, 'Daporijo', 3), (304, 'Deomali', 3), (305, 'Itanagar', 3), (306, 'Jairampur', 3), (307, 'Khonsa', 3), (308, 'Naharlagun', 3), (309, 'Namsai', 3), (310, 'Pasighat', 3), (311, 'Roing', 3), (312, 'Seppa', 3), (313, 'Tawang', 3), (314, 'Tezu', 3), (315, 'Ziro', 3), (316, 'Abhayapuri', 4), (317, 'Ambikapur', 4), (318, 'Amguri', 4), (319, 'Anand Nagar', 4), (320, 'Badarpur', 4), (321, '