                                                                                                                    (1865, 1857, '0730', '430681', '汨罗市', '113.067251', '28.806881', 'district', 0),
                                                                                                                    (1866, 1857, '0730', '430682', '临湘市', '113.450423', '29.476849', 'district', 0),
                                                                                                                    (1867, 1804, '0736', '430700', '常德市', '111.698784', '29.031654', 'city', 0),
                                                                                                                    (1868, 1867, '0736', '430702', '武陵区', '111.683153', '29.055163', 'district', 0),
                                                                                                                    (1869, 1867, '0736', '430703', '鼎城区', '111.680783', '29.018593', 'district', 0),
                                                                                                                    (1870, 1867, '0736', '430721', '安乡县', '112.171131', '29.411309', 'district', 0),
                                                                                                                    (1871, 1867, '0736', '430722', '汉寿县', '111.970514', '28.906106', 'district', 0),
                                                                                                                    (1872, 1867, '0736', '430723', '澧县', '111.758702', '29.633236', 'district', 0),
                                                                                                                    (1873, 1867, '0736', '430724', '临澧县', '111.647517', '29.440793', 'district', 0),
                                                                                                                    (1874, 1867, '0736', '430725', '桃源县', '111.488925', '28.902503', 'district', 0),
                                                                                                                    (1875, 1867, '0736', '430726', '石门县', '111.380014', '29.584292', 'district', 0),
                                                                                                                    (1876, 1867, '0736', '430781', '津市市', '111.877499', '29.60548', 'district', 0),
                                                                                                                    (1877, 1804, '0744', '430800', '张家界市', '110.479148', '29.117013', 'city', 0),
                                                                                                                    (1878, 1877, '0744', '430802', '永定区', '110.537138', '29.119855', 'district', 0),
                                                                                                                    (1879, 1877, '0744', '430811', '武陵源区', '110.550433', '29.34573', 'district', 0),
                                                                                                                    (1880, 1877, '0744', '430821', '慈利县', '111.139775', '29.429999', 'district', 0),
                                                                                                                    (1881, 1877, '0744', '430822', '桑植县', '110.204652', '29.414111', 'district', 0),
                                                                                                                    (1882, 1804, '0737', '430900', '益阳市', '112.355129', '28.554349', 'city', 0),
                                                                                                                    (1883, 1882, '0737', '430902', '资阳区', '112.324272', '28.59111', 'district', 0),
                                                                                                                    (1884, 1882, '0737', '430903', '赫山区', '112.374145', '28.579494', 'district', 0),
                                                                                                                    (1885, 1882, '0737', '430921', '南县', '112.396337', '29.362275', 'district', 0),
                                                                                                                    (1886, 1882, '0737', '430922', '桃江县', '112.155822', '28.518084', 'district', 0),
                                                                                                                    (1887, 1882, '0737', '430923', '安化县', '111.212846', '28.374107', 'district', 0),
                                                                                                                    (1888, 1882, '0737', '430981', '沅江市', '112.355954', '28.847045', 'district', 0),
                                                                                                                    (1889, 1804, '0735', '431000', '郴州市', '113.014984', '25.770532', 'city', 0),
                                                                                                                    (1890, 1889, '0735', '431002', '北湖区', '113.011035', '25.784054', 'district', 0),
                                                                                                                    (1891, 1889, '0735', '431003', '苏仙区', '113.112105', '25.797013', 'district', 0),
                                                                                                                    (1892, 1889, '0735', '431021', '桂阳县', '112.734173', '25.754172', 'district', 0),
                                                                                                                    (1893, 1889, '0735', '431022', '宜章县', '112.948712', '25.399938', 'district', 0),
                                                                                                                    (1894, 1889, '0735', '431023', '永兴县', '113.116527', '26.12715', 'district', 0),
                                                                                                                    (1895, 1889, '0735', '431024', '嘉禾县', '112.36902', '25.587519', 'district', 0),
                                                                                                                    (1896, 1889, '0735', '431025', '临武县', '112.563456', '25.27556', 'district', 0),
                                                                                                                    (1897, 1889, '0735', '431026', '汝城县', '113.684727', '25.532816', 'district', 0),
                                                                                                                    (1898, 1889, '0735', '431027', '桂东县', '113.944614', '26.077616', 'district', 0),
                                                                                                                    (1899, 1889, '0735', '431028', '安仁县', '113.26932', '26.709061', 'district', 0),
                                                                                                                    (1900, 1889, '0735', '431081', '资兴市', '113.236146', '25.976243', 'district', 0),
                                                                                                                    (1901, 1804, '0746', '431100', '永州市', '111.613418', '26.419641', 'city', 0),
                                                                                                                    (1902, 1901, '0746', '431102', '零陵区', '111.631109', '26.221936', 'district', 0),
                                                                                                                    (1903, 1901, '0746', '431103', '冷水滩区', '111.592343', '26.46128', 'district', 0),
                                                                                                                    (1904, 1901, '0746', '431121', '祁阳县', '111.840657', '26.58012', 'district', 0),
                                                                                                                    (1905, 1901, '0746', '431122', '东安县', '111.316464', '26.392183', 'district', 0),
                                                                                                                    (1906, 1901, '0746', '431123', '双牌县', '111.659967', '25.961909', 'district', 0),
                                                                                                                    (1907, 1901, '0746', '431124', '道县', '111.600795', '25.526437', 'district', 0),
                                                                                                                    (1908, 1901, '0746', '431125', '江永县', '111.343911', '25.273539', 'district', 0),
                                                                                                                    (1909, 1901, '0746', '431126', '宁远县', '111.945844', '25.570888', 'district', 0),
                                                                                                                    (1910, 1901, '0746', '431127', '蓝山县', '112.196567', '25.369725', 'district', 0),
                                                                                                                    (1911, 1901, '0746', '431128', '新田县', '112.203287', '25.904305', 'district', 0),
                                                                                                                    (1912, 1901, '0746', '431129', '江华瑶族自治县', '111.579535', '25.185809', 'district', 0),
                                                                                                                    (1913, 1804, '0745', '431200', '怀化市', '110.001923', '27.569517', 'city', 0),
                                                                                                                    (1914, 1913, '0745', '431202', '鹤城区', '110.040315', '27.578926', 'district', 0),
                                                                                                                    (1915, 1913, '0745', '431221', '中方县', '109.944711', '27.440138', 'district', 0),
                                                                                                                    (1916, 1913, '0745', '431222', '沅陵县', '110.393844', '28.452686', 'district', 0),
                                                                                                                    (1917, 1913, '0745', '431223', '辰溪县', '110.183917', '28.006336', 'district', 0),
                                                                                                                    (1918, 1913, '0745', '431224', '溆浦县', '110.594879', '27.908267', 'district', 0),
                                                                                                                    (1919, 1913, '0745', '431225', '会同县', '109.735661', '26.887238', 'district', 0),
                                                                                                                    (1920, 1913, '0745', '431226', '麻阳苗族自治县', '109.81701', '27.857569', 'district', 0),
                                                                                                                    (1921, 1913, '0745', '431227', '新晃侗族自治县', '109.174932', '27.352673', 'district', 0),
                                                                                                                    (1922, 1913, '0745', '431228', '芷江侗族自治县', '109.684629', '27.443499', 'district', 0),
                                                                                                                    (1923, 1913, '0745', '431229', '靖州苗族侗族自治县', '109.696273', '26.575107', 'district', 0),
                                                                                                                    (1924, 1913, '0745', '431230', '通道侗族自治县', '109.784412', '26.158054', 'district', 0),
                                                                                                                    (1925, 1913, '0745', '431281', '洪江市', '109.836669', '27.208609', 'district', 0),
                                                                                                                    (1926, 1804, '0738', '431300', '娄底市', '111.994482', '27.70027', 'city', 0),
                                                                                                                    (1927, 1926, '0738', '431302', '娄星区', '112.001914', '27.729863', 'district', 0),
                                                                                                                    (1928, 1926, '0738', '431321', '双峰县', '112.175163', '27.457172', 'district', 0),
                                                                                                                    (1929, 1926, '0738', '431322', '新化县', '111.327412', '27.726514', 'district', 0),
                                                                                                                    (1930, 1926, '0738', '431381', '冷水江市', '111.434984', '27.686251', 'district', 0),
                                                                                                                    (1931, 1926, '0738', '431382', '涟源市', '111.664329', '27.692577', 'district', 0),
                                                                                                                    (1932, 1804, '0743', '433100', '湘西土家族苗族自治州', '109.738906', '28.31195', 'city', 0),
                                                                                                                    (1933, 1932, '0743', '433101', '吉首市', '109.698015', '28.262376', 'district', 0),
                                                                                                                    (1934, 1932, '0743', '433122', '泸溪县', '110.21961', '28.216641', 'district', 0);
INSERT INTO `sys_region` (`id`, `parent_id`, `citycode`, `adcode`, `name`, `lng`, `lat`, `level`, `sort_order`) VALUES
                                                                                                                    (1935, 1932, '0743', '433123', '凤凰县', '109.581083', '27.958081', 'district', 0),
                                                                                                                    (1936, 1932, '0743', '433124', '花垣县', '109.482078', '28.572029', 'district', 0),
                                                                                                                    (1937, 1932, '0743', '433125', '保靖县', '109.660559', '28.699878', 'district', 0),
                                                                                                                    (1938, 1932, '0743', '433126', '古丈县', '109.950728', '28.616935', 'district', 0),
                                                                                                                    (1939, 1932, '0743', '433127', '永顺县', '109.856933', '28.979955', 'district', 0),
                                                                                                                    (1940, 1932, '0743', '433130', '龙山县', '109.443938', '29.457663', 'district', 0),
                                                                                                                    (1941, 1, '0', '440000', '广东省', '113.26641', '23.132324', 'province', 9000),
                                                                                                                    (1942, 1941, '020', '440100', '广州市', '113.264385', '23.12911', 'city', 0),
                                                                                                                    (1943, 1942, '020', '440103', '荔湾区', '113.244258', '23.125863', 'district', 0),
                                                                                                                    (1944, 1942, '020', '440104', '越秀区', '113.266835', '23.128537', 'district', 0),
                                                                                                                    (1945, 1942, '020', '440105', '海珠区', '113.317443', '23.083788', 'district', 0),
                                                                                                                    (1946, 1942, '020', '440106', '天河区', '113.361575', '23.124807', 'district', 0),
                                                                                                                    (1947, 1942, '020', '440111', '白云区', '113.273238', '23.157367', 'district', 0),
                                                                                                                    (1948, 1942, '020', '440112', '黄埔区', '113.480541', '23.181706', 'district', 0),
                                                                                                                    (1949, 1942, '020', '440113', '番禺区', '113.384152', '22.937556', 'district', 0),
                                                                                                                    (1950, 1942, '020', '440114', '花都区', '113.220463', '23.403744', 'district', 0),
                                                                                                                    (1951, 1942, '020', '440115', '南沙区', '113.525165', '22.801624', 'district', 0),
                                                                                                                    (1952, 1942, '020', '440117', '从化区', '113.586679', '23.548748', 'district', 0),
                                                                                                                    (1953, 1942, '020', '440118', '增城区', '113.810627', '23.261465', 'district', 0),
                                                                                                                    (1954, 1941, '0751', '440200', '韶关市', '113.59762', '24.810879', 'city', 0),
                                                                                                                    (1955, 1954, '0751', '440203', '武江区', '113.587756', '24.792926', 'district', 0),
                                                                                                                    (1956, 1954, '0751', '440204', '浈江区', '113.611098', '24.804381', 'district', 0),
                                                                                                                    (1957, 1954, '0751', '440205', '曲江区', '113.604535', '24.682501', 'district', 0),
                                                                                                                    (1958, 1954, '0751', '440222', '始兴县', '114.061789', '24.952976', 'district', 0),
                                                                                                                    (1959, 1954, '0751', '440224', '仁化县', '113.749027', '25.085621', 'district', 0),
                                                                                                                    (1960, 1954, '0751', '440229', '翁源县', '114.130342', '24.350346', 'district', 0),
                                                                                                                    (1961, 1954, '0751', '440232', '乳源瑶族自治县', '113.275883', '24.776078', 'district', 0),
                                                                                                                    (1962, 1954, '0751', '440233', '新丰县', '114.206867', '24.05976', 'district', 0),
                                                                                                                    (1963, 1954, '0751', '440281', '乐昌市', '113.347545', '25.130602', 'district', 0),
                                                                                                                    (1964, 1954, '0751', '440282', '南雄市', '114.311982', '25.117753', 'district', 0),
                                                                                                                    (1965, 1941, '0755', '440300', '深圳市', '114.057939', '22.543527', 'city', 0),
                                                                                                                    (1966, 1965, '0755', '440303', '罗湖区', '114.131459', '22.548389', 'district', 0),
                                                                                                                    (1967, 1965, '0755', '440304', '福田区', '114.055072', '22.521521', 'district', 0),
                                                                                                                    (1968, 1965, '0755', '440305', '南山区', '113.930413', '22.533287', 'district', 0),
                                                                                                                    (1969, 1965, '0755', '440306', '宝安区', '113.883802', '22.554996', 'district', 0),
                                                                                                                    (1970, 1965, '0755', '440307', '龙岗区', '114.246899', '22.720974', 'district', 0),
                                                                                                                    (1971, 1965, '0755', '440308', '盐田区', '114.236739', '22.557001', 'district', 0),
                                                                                                                    (1972, 1965, '0755', '440309', '龙华区', '114.045422', '22.696667', 'district', 0),
                                                                                                                    (1973, 1965, '0755', '440310', '坪山区', '114.350584', '22.708881', 'district', 0),
                                                                                                                    (1974, 1941, '0756', '440400', '珠海市', '113.576677', '22.270978', 'city', 0),
                                                                                                                    (1975, 1974, '0756', '440402', '香洲区', '113.543784', '22.265811', 'district', 0),
                                                                                                                    (1976, 1974, '0756', '440403', '斗门区', '113.296467', '22.2092', 'district', 0),
                                                                                                                    (1977, 1974, '0756', '440404', '金湾区', '113.362656', '22.147471', 'district', 0),
                                                                                                                    (1978, 1941, '0754', '440500', '汕头市', '116.681972', '23.354091', 'city', 0),
                                                                                                                    (1979, 1978, '0754', '440507', '龙湖区', '116.716446', '23.372254', 'district', 0),
                                                                                                                    (1980, 1978, '0754', '440511', '金平区', '116.70345', '23.365556', 'district', 0),
                                                                                                                    (1981, 1978, '0754', '440512', '濠江区', '116.726973', '23.286079', 'district', 0),
                                                                                                                    (1982, 1978, '0754', '440513', '潮阳区', '116.601509', '23.265356', 'district', 0),
                                                                                                                    (1983, 1978, '0754', '440514', '潮南区', '116.439178', '23.23865', 'district', 0),
                                                                                                                    (1984, 1978, '0754', '440515', '澄海区', '116.755992', '23.466709', 'district', 0),
                                                                                                                    (1985, 1978, '0754', '440523', '南澳县', '117.023374', '23.421724', 'district', 0),
                                                                                                                    (1986, 1941, '0757', '440600', '佛山市', '113.121435', '23.021478', 'city', 0),
                                                                                                                    (1987, 1986, '0757', '440604', '禅城区', '113.122421', '23.009551', 'district', 0),
                                                                                                                    (1988, 1986, '0757', '440605', '南海区', '113.143441', '23.028956', 'district', 0),
                                                                                                                    (1989, 1986, '0757', '440606', '顺德区', '113.293359', '22.80524', 'district', 0),
                                                                                                                    (1990, 1986, '0757', '440607', '三水区', '112.896685', '23.155931', 'district', 0),
                                                                                                                    (1991, 1986, '0757', '440608', '高明区', '112.892585', '22.900139', 'district', 0),
                                                                                                                    (1992, 1941, '0750', '440700', '江门市', '113.081542', '22.57899', 'city', 0),
                                                                                                                    (1993, 1992, '0750', '440703', '蓬江区', '113.078521', '22.595149', 'district', 0),
                                                                                                                    (1994, 1992, '0750', '440704', '江海区', '113.111612', '22.560473', 'district', 0),
                                                                                                                    (1995, 1992, '0750', '440705', '新会区', '113.034187', '22.4583', 'district', 0),
                                                                                                                    (1996, 1992, '0750', '440781', '台山市', '112.794065', '22.251924', 'district', 0),
                                                                                                                    (1997, 1992, '0750', '440783', '开平市', '112.698545', '22.376395', 'district', 0),
                                                                                                                    (1998, 1992, '0750', '440784', '鹤山市', '112.964252', '22.76545', 'district', 0),
                                                                                                                    (1999, 1992, '0750', '440785', '恩平市', '112.305145', '22.183206', 'district', 0),
                                                                                                                    (2000, 1941, '0759', '440800', '湛江市', '110.356639', '21.270145', 'city', 0),
                                                                                                                    (2001, 2000, '0759', '440802', '赤坎区', '110.365899', '21.266119', 'district', 0),
                                                                                                                    (2002, 2000, '0759', '440803', '霞山区', '110.397656', '21.192457', 'district', 0),
                                                                                                                    (2003, 2000, '0759', '440804', '坡头区', '110.455332', '21.244721', 'district', 0),
                                                                                                                    (2004, 2000, '0759', '440811', '麻章区', '110.334387', '21.263442', 'district', 0),
                                                                                                                    (2005, 2000, '0759', '440823', '遂溪县', '110.250123', '21.377246', 'district', 0),
                                                                                                                    (2006, 2000, '0759', '440825', '徐闻县', '110.176749', '20.325489', 'district', 0),
                                                                                                                    (2007, 2000, '0759', '440881', '廉江市', '110.286208', '21.6097', 'district', 0),
                                                                                                                    (2008, 2000, '0759', '440882', '雷州市', '110.096586', '20.914178', 'district', 0),
                                                                                                                    (2009, 2000, '0759', '440883', '吴川市', '110.778411', '21.441808', 'district', 0),
                                                                                                                    (2010, 1941, '0668', '440900', '茂名市', '110.925439', '21.662991', 'city', 0),
                                                                                                                    (2011, 2010, '0668', '440902', '茂南区', '110.918026', '21.641337', 'district', 0),
                                                                                                                    (2012, 2010, '0668', '440904', '电白区', '111.013556', '21.514163', 'district', 0),
                                                                                                                    (2013, 2010, '0668', '440981', '高州市', '110.853299', '21.918203', 'district', 0),
                                                                                                                    (2014, 2010, '0668', '440982', '化州市', '110.639565', '21.66463', 'district', 0),
                                                                                                                    (2015, 2010, '0668', '440983', '信宜市', '110.947043', '22.354385', 'district', 0),
                                                                                                                    (2016, 1941, '0758', '441200', '肇庆市', '112.465091', '23.047191', 'city', 0),
                                                                                                                    (2017, 2016, '0758', '441202', '端州区', '112.484848', '23.052101', 'district', 0),
                                                                                                                    (2018, 2016, '0758', '441203', '鼎湖区', '112.567588', '23.158447', 'district', 0),
                                                                                                                    (2019, 2016, '0758', '441204', '高要区', '112.457981', '23.025305', 'district', 0),
                                                                                                                    (2020, 2016, '0758', '441223', '广宁县', '112.44069', '23.634675', 'district', 0),
                                                                                                                    (2021, 2016, '0758', '441224', '怀集县', '112.167742', '23.92035', 'district', 0),
                                                                                                                    (2022, 2016, '0758', '441225', '封开县', '111.512343', '23.424033', 'district', 0),
                                                                                                                    (2023, 2016, '0758', '441226', '德庆县', '111.785937', '23.143722', 'district', 0),
                                                                                                                    (2024, 2016, '0758', '441284', '四会市', '112.734103', '23.327001', 'district', 0),
                                                                                                                    (2025, 1941, '0752', '441300', '惠州市', '114.415612', '23.112381', 'city', 0),
                                                                                                                    (2026, 2025, '0752', '441302', '惠城区', '114.382474', '23.084137', 'district', 0),
                                                                                                                    (2027, 2025, '0752', '441303', '惠阳区', '114.456176', '22.789788', 'district', 0),
                                                                                                                    (2028, 2025, '0752', '441322', '博罗县', '114.289528', '23.172771', 'district', 0),
                                                                                                                    (2029, 2025, '0752', '441323', '惠东县', '114.719988', '22.985014', 'district', 0),
                                                                                                                    (2030, 2025, '0752', '441324', '龙门县', '114.254863', '23.727737', 'district', 0),
                                                                                                                    (2031, 1941, '0753', '441400', '梅州市', '116.122523', '24.288578', 'city', 0),
                                                                                                                    (2032, 2031, '0753', '441402', '梅江区', '116.116695', '24.31049', 'district', 0),
                                                                                                                    (2033, 2031, '0753', '441403', '梅县区', '116.081656', '24.265926', 'district', 0),
                                                                                                                    (2034, 2031, '0753', '441422', '大埔县', '116.695195', '24.347782', 'district', 0),
                                                                                                                    (2035, 2031, '0753', '441423', '丰顺县', '116.181691', '23.739343', 'district', 0),
                                                                                                                    (2036, 2031, '0753', '441424', '五华县', '115.775788', '23.932409', 'district', 0),
                                                                                                                    (2037, 2031, '0753', '441426', '平远县', '115.891638', '24.567261', 'district', 0),
                                                                                                                    (2038, 2031, '0753', '441427', '蕉岭县', '116.171355', '24.658699', 'district', 0),
                                                                                                                    (2039, 2031, '0753', '441481', '兴宁市', '115.731167', '24.136708', 'district', 0),
                                                                                                                    (2040, 1941, '0660', '441500', '汕尾市', '115.375431', '22.78705', 'city', 0),
                                                                                                                    (2041, 2040, '0660', '441502', '城区', '115.365058', '22.779207', 'district', 0),
                                                                                                                    (2042, 2040, '0660', '441521', '海丰县', '115.323436', '22.966585', 'district', 0),
                                                                                                                    (2043, 2040, '0660', '441523', '陆河县', '115.660143', '23.301616', 'district', 0),
                                                                                                                    (2044, 2040, '0660', '441581', '陆丰市', '115.652151', '22.919228', 'district', 0),
                                                                                                                    (2045, 1941, '0762', '441600', '河源市', '114.700961', '23.743686', 'city', 0),
                                                                                                                    (2046, 2045, '0762', '441602', '源城区', '114.702517', '23.733969', 'district', 0),
                                                                                                                    (2047, 2045, '0762', '441621', '紫金县', '115.184107', '23.635745', 'district', 0),
                                                                                                                    (2048, 2045, '0762', '441622', '龙川县', '115.259871', '24.100066', 'district', 0),
                                                                                                                    (2049, 2045, '0762', '441623', '连平县', '114.488556', '24.369583', 'district', 0),
                                                                                                                    (2050, 2045, '0762', '441624', '和平县', '114.938684', '24.44218', 'district', 0),
                                                                                                                    (2051, 2045, '0762', '441625', '东源县', '114.746344', '23.788189', 'district', 0),
                                                                                                                    (2052, 1941, '0662', '441700', '阳江市', '111.982589', '21.857887', 'city', 0),
                                                                                                                    (2053, 2052, '0662', '441702', '江城区', '111.955058', '21.861786', 'district', 0),
                                                                                                                    (2054, 2052, '0662', '441704', '阳东区', '112.006363', '21.868337', 'district', 0),
                                                                                                                    (2055, 2052, '0662', '441721', '阳西县', '111.61766', '21.752771', 'district', 0),
                                                                                                                    (2056, 2052, '0662', '441781', '阳春市', '111.791587', '22.17041', 'district', 0),
                                                                                                                    (2057, 1941, '0763', '441800', '清远市', '113.056042', '23.681774', 'city', 0),
                                                                                                                    (2058, 2057, '0763', '441802', '清城区', '113.062692', '23.697899', 'district', 0),
                                                                                                                    (2059, 2057, '0763', '441803', '清新区', '113.017747', '23.734677', 'district', 0),
                                                                                                                    (2060, 2057, '0763', '441821', '佛冈县', '113.531607', '23.879192', 'district', 0),
                                                                                                                    (2061, 2057, '0763', '441823', '阳山县', '112.641363', '24.465359', 'district', 0),
                                                                                                                    (2062, 2057, '0763', '441825', '连山壮族瑶族自治县', '112.093617', '24.570491', 'district', 0),
                                                                                                                    (2063, 2057, '0763', '441826', '连南瑶族自治县', '112.287012', '24.726017', 'district', 0),
                                                                                                                    (2064, 2057, '0763', '441881', '英德市', '113.401701', '24.206986', 'district', 0),
                                                                                                                    (2065, 2057, '0763', '441882', '连州市', '112.377361', '24.780966', 'district', 0),
                                                                                                                    (2066, 1941, '0769', '441900', '东莞市', '113.751799', '23.020673', 'city', 0),
                                                                                                                    (2067, 2066, '0769', '441900', '东莞市', '113.751799', '23.020673', 'district', 0),
                                                                                                                    (2068, 1941, '0760', '442000', '中山市', '113.39277', '22.517585', 'city', 0),
                                                                                                                    (2069, 2068, '0760', '442000', '中山市', '113.39277', '22.517585', 'district', 0),
                                                                                                                    (2070, 1941, '0768', '445100', '潮州市', '116.622444', '23.657262', 'city', 0),
                                                                                                                    (2071, 2070, '0768', '445102', '湘桥区', '116.628627', '23.674387', 'district', 0),
                                                                                                                    (2072, 2070, '0768', '445103', '潮安区', '116.678203', '23.462613', 'district', 0),
                                                                                                                    (2073, 2070, '0768', '445122', '饶平县', '117.0039', '23.663824', 'district', 0),
                                                                                                                    (2074, 1941, '0663', '445200', '揭阳市', '116.372708', '23.549701', 'city', 0),
                                                                                                                    (2075, 2074, '0663', '445202', '榕城区', '116.367012', '23.525382', 'district', 0),
                                                                                                                    (2076, 2074, '0663', '445203', '揭东区', '116.412015', '23.566126', 'district', 0),
                                                                                                                    (2077, 2074, '0663', '445222', '揭西县', '115.841837', '23.431294', 'district', 0),
                                                                                                                    (2078, 2074, '0663', '445224', '惠来县', '116.29515', '23.033266', 'district', 0),
                                                                                                                    (2079, 2074, '0663', '445281', '普宁市', '116.165777', '23.297493', 'district', 0),
                                                                                                                    (2080, 1941, '0766', '445300', '云浮市', '112.044491', '22.915094', 'city', 0),
                                                                                                                    (2081, 2080, '0766', '445302', '云城区', '112.043945', '22.92815', 'district', 0),
                                                                                                                    (2082, 2080, '0766', '445303', '云安区', '112.003208', '23.071019', 'district', 0),
                                                                                                                    (2083, 2080, '0766', '445321', '新兴县', '112.225334', '22.69569', 'district', 0),
                                                                                                                    (2084, 2080, '0766', '445322', '郁南县', '111.535285', '23.23456', 'district', 0),
                                                                                                                    (2085, 2080, '0766', '445381', '罗定市', '111.569892', '22.768285', 'district', 0),
                                                                                                                    (2086, 1941, '0', '442100', '东沙群岛', '116.887613', '20.617825', 'city', 0),
                                                                                                                    (2087, 2086, '0', '442100', '东沙群岛', '116.887613', '20.617825', 'district', 0),
                                                                                                                    (2088, 1, '0', '450000', '广西壮族自治区', '108.327546', '22.815478', 'province', 0),
                                                                                                                    (2089, 2088, '0771', '450100', '南宁市', '108.366543', '22.817002', 'city', 0),
                                                                                                                    (2090, 2089, '0771', '450102', '兴宁区', '108.368871', '22.854021', 'district', 0),
                                                                                                                    (2091, 2089, '0771', '450103', '青秀区', '108.494024', '22.785879', 'district', 0),
                                                                                                                    (2092, 2089, '0771', '450105', '江南区', '108.273133', '22.78136', 'district', 0),
                                                                                                                    (2093, 2089, '0771', '450107', '西乡塘区', '108.313494', '22.833928', 'district', 0),
                                                                                                                    (2094, 2089, '0771', '450108', '良庆区', '108.39301', '22.752997', 'district', 0),
                                                                                                                    (2095, 2089, '0771', '450109', '邕宁区', '108.487368', '22.75839', 'district', 0),
                                                                                                                    (2096, 2089, '0771', '450110', '武鸣区', '108.27467', '23.158595', 'district', 0),
                                                                                                                    (2097, 2089, '0771', '450123', '隆安县', '107.696153', '23.166028', 'district', 0),
                                                                                                                    (2098, 2089, '0771', '450124', '马山县', '108.177019', '23.708321', 'district', 0),
                                                                                                                    (2099, 2089, '0771', '450125', '上林县', '108.602846', '23.431908', 'district', 0),
                                                                                                                    (2100, 2089, '0771', '450126', '宾阳县', '108.810326', '23.217786', 'district', 0),
                                                                                                                    (2101, 2089, '0771', '450127', '横县', '109.261384', '22.679931', 'district', 0),
                                                                                                                    (2102, 2088, '0772', '450200', '柳州市', '109.428608', '24.326291', 'city', 0),
                                                                                                                    (2103, 2102, '0772', '450202', '城中区', '109.4273', '24.366', 'district', 0),
                                                                                                                    (2104, 2102, '0772', '450203', '鱼峰区', '109.452442', '24.318516', 'district', 0),
                                                                                                                    (2105, 2102, '0772', '450204', '柳南区', '109.385518', '24.336229', 'district', 0),
                                                                                                                    (2106, 2102, '0772', '450205', '柳北区', '109.402049', '24.362691', 'district', 0),
                                                                                                                    (2107, 2102, '0772', '450221', '柳江区', '109.32638', '24.254891', 'district', 0),
                                                                                                                    (2108, 2102, '0772', '450222', '柳城县', '109.24473', '24.651518', 'district', 0),
                                                                                                                    (2109, 2102, '0772', '450223', '鹿寨县', '109.750638', '24.472897', 'district', 0),
                                                                                                                    (2110, 2102, '0772', '450224', '融安县', '109.397538', '25.224549', 'district', 0),
                                                                                                                    (2111, 2102, '0772', '450225', '融水苗族自治县', '109.256334', '25.065934', 'district', 0),
                                                                                                                    (2112, 2102, '0772', '450226', '三江侗族自治县', '109.607675', '25.783198', 'district', 0),
                                                                                                                    (2113, 2088, '0773', '450300', '桂林市', '110.179953', '25.234479', 'city', 0),
                                                                                                                    (2114, 2113, '0773', '450302', '秀峰区', '110.264183', '25.273625', 'district', 0),
                                                                                                                    (2115, 2113, '0773', '450303', '叠彩区', '110.301723', '25.314', 'district', 0),
                                                                                                                    (2116, 2113, '0773', '450304', '象山区', '110.281082', '25.261686', 'district', 0),
                                                                                                                    (2117, 2113, '0773', '450305', '七星区', '110.317826', '25.252701', 'district', 0),
                                                                                                                    (2118, 2113, '0773', '450311', '雁山区', '110.28669', '25.101934', 'district', 0),
                                                                                                                    (2119, 2113, '0773', '450312', '临桂区', '110.212463', '25.238628', 'district', 0),
                                                                                                                    (2120, 2113, '0773', '450321', '阳朔县', '110.496593', '24.77848', 'district', 0),
                                                                                                                    (2121, 2113, '0773', '450323', '灵川县', '110.319897', '25.394781', 'district', 0),
                                                                                                                    (2122, 2113, '0773', '450324', '全州县', '111.072946', '25.928387', 'district', 0),
                                                                                                                    (2123, 2113, '0773', '450325', '兴安县', '110.67167', '25.611704', 'district', 0),
                                                                                                                    (2124, 2113, '0773', '450326', '永福县', '109.983076', '24.979855', 'district', 0),
                                                                                                                    (2125, 2113, '0773', '450327', '灌阳县', '111.160851', '25.489383', 'district', 0),
                                                                                                                    (2126, 2113, '0773', '450328', '龙胜各族自治县', '110.011238', '25.797931', 'district', 0),
                                                                                                                    (2127, 2113, '0773', '450329', '资源县', '110.6527', '26.042443', 'district', 0),
                                                                                                                    (2128, 2113, '0773', '450330', '平乐县', '110.643305', '24.633362', 'district', 0),
                                                                                                                    (2129, 2113, '0773', '450331', '荔浦县', '110.395104', '24.488342', 'district', 0),
                                                                                                                    (2130, 2113, '0773', '450332', '恭城瑶族自治县', '110.828409', '24.831682', 'district', 0),
                                                                                                                    (2131, 2088, '0774', '450400', '梧州市', '111.279115', '23.476962', 'city', 0),
                                                                                                                    (2132, 2131, '0774', '450403', '万秀区', '111.320518', '23.472991', 'district', 0),
                                                                                                                    (2133, 2131, '0774', '450405', '长洲区', '111.274673', '23.485944', 'district', 0),
                                                                                                                    (2134, 2131, '0774', '450406', '龙圩区', '111.246606', '23.404772', 'district', 0),
                                                                                                                    (2135, 2131, '0774', '450421', '苍梧县', '111.544007', '23.845097', 'district', 0),
                                                                                                                    (2136, 2131, '0774', '450422', '藤县', '110.914849', '23.374983', 'district', 0),
                                                                                                                    (2137, 2131, '0774', '450423', '蒙山县', '110.525003', '24.19357', 'district', 0),
                                                                                                                    (2138, 2131, '0774', '450481', '岑溪市', '110.994913', '22.91835', 'district', 0),
                                                                                                                    (2139, 2088, '0779', '450500', '北海市', '109.120161', '21.481291', 'city', 0),
                                                                                                                    (2140, 2139, '0779', '450502', '海城区', '109.117209', '21.475004', 'district', 0),
                                                                                                                    (2141, 2139, '0779', '450503', '银海区', '109.139862', '21.449308', 'district', 0),
                                                                                                                    (2142, 2139, '0779', '450512', '铁山港区', '109.42158', '21.529127', 'district', 0),
                                                                                                                    (2143, 2139, '0779', '450521', '合浦县', '109.207335', '21.660935', 'district', 0),
                                                                                                                    (2144, 2088, '0770', '450600', '防城港市', '108.353846', '21.68686', 'city', 0),
                                                                                                                    (2145, 2144, '0770', '450602', '港口区', '108.380143', '21.643383', 'district', 0),
                                                                                                                    (2146, 2144, '0770', '450603', '防城区', '108.353499', '21.769211', 'district', 0),
                                                                                                                    (2147, 2144, '0770', '450621', '上思县', '107.983627', '22.153671', 'district', 0),
                                                                                                                    (2148, 2144, '0770', '450681', '东兴市', '107.971828', '21.547821', 'district', 0),
                                                                                                                    (2149, 2088, '0777', '450700', '钦州市', '108.654146', '21.979933', 'city', 0),
                                                                                                                    (2150, 2149, '0777', '450702', '钦南区', '108.657209', '21.938859', 'district', 0),
                                                                                                                    (2151, 2149, '0777', '450703', '钦北区', '108.44911', '22.132761', 'district', 0),
                                                                                                                    (2152, 2149, '0777', '450721', '灵山县', '109.291006', '22.416536', 'district', 0),
                                                                                                                    (2153, 2149, '0777', '450722', '浦北县', '109.556953', '22.271651', 'district', 0),
                                                                                                                    (2154, 2088, '1755', '450800', '贵港市', '109.598926', '23.11153', 'city', 0),
                                                                                                                    (2155, 2154, '1755', '450802', '港北区', '109.57224', '23.11153', 'district', 0),
                                                                                                                    (2156, 2154, '1755', '450803', '港南区', '109.599556', '23.075573', 'district', 0),
                                                                                                                    (2157, 2154, '1755', '450804', '覃塘区', '109.452662', '23.127149', 'district', 0),
                                                                                                                    (2158, 2154, '1755', '450821', '平南县', '110.392311', '23.539264', 'district', 0),
                                                                                                                    (2159, 2154, '1755', '450881', '桂平市', '110.079379', '23.394325', 'district', 0),
                                                                                                                    (2160, 2088, '0775', '450900', '玉林市', '110.18122', '22.654032', 'city', 0),
                                                                                                                    (2161, 2160, '0775', '450902', '玉州区', '110.151153', '22.628087', 'district', 0),
                                                                                                                    (2162, 2160, '0775', '450903', '福绵区', '110.059439', '22.585556', 'district', 0),
                                                                                                                    (2163, 2160, '0775', '450921', '容县', '110.558074', '22.857839', 'district', 0),
                                                                                                                    (2164, 2160, '0775', '450922', '陆川县', '110.264052', '22.321048', 'district', 0),
                                                                                                                    (2165, 2160, '0775', '450923', '博白县', '109.975985', '22.273048', 'district', 0),
                                                                                                                    (2166, 2160, '0775', '450924', '兴业县', '109.875304', '22.736421', 'district', 0),
                                                                                                                    (2167, 2160, '0775', '450981', '北流市', '110.354214', '22.70831', 'district', 0),
                                                                                                                    (2168, 2088, '0776', '451000', '百色市', '106.618202', '23.90233', 'city', 0),
                                                                                                                    (2169, 2168, '0776', '451002', '右江区', '106.618225', '23.90097', 'district', 0),
                                                                                                                    (2170, 2168, '0776', '451021', '田阳县', '106.915496', '23.735692', 'district', 0),
                                                                                                                    (2171, 2168, '0776', '451022', '田东县', '107.12608', '23.597194', 'district', 0),
                                                                                                                    (2172, 2168, '0776', '451023', '平果县', '107.589809', '23.329376', 'district', 0),
                                                                                                                    (2173, 2168, '0776', '451024', '德保县', '106.615373', '23.32345', 'district', 0),
                                                                                                                    (2174, 2168, '0776', '451026', '那坡县', '105.83253', '23.387441', 'district', 0),
                                                                                                                    (2175, 2168, '0776', '451027', '凌云县', '106.56131', '24.347557', 'district', 0),
                                                                                                                    (2176, 2168, '0776', '451028', '乐业县', '106.556519', '24.776827', 'district', 0),
                                                                                                                    (2177, 2168, '0776', '451029', '田林县', '106.228538', '24.294487', 'district', 0),
                                                                                                                    (2178, 2168, '0776', '451030', '西林县', '105.093825', '24.489823', 'district', 0),
                                                                                                                    (2179, 2168, '0776', '451031', '隆林各族自治县', '105.34404', '24.770896', 'district', 0),
                                                                                                                    (2180, 2168, '0776', '451081', '靖西市', '106.417805', '23.134117', 'district', 0),
                                                                                                                    (2181, 2088, '1774', '451100', '贺州市', '111.566871', '24.403528', 'city', 0),
                                                                                                                    (2182, 2181, '1774', '451102', '八步区', '111.552095', '24.411805', 'district', 0),
                                                                                                                    (2183, 2181, '1774', '451103', '平桂区', '111.479923', '24.453845', 'district', 0),
                                                                                                                    (2184, 2181, '1774', '451121', '昭平县', '110.811325', '24.169385', 'district', 0),
                                                                                                                    (2185, 2181, '1774', '451122', '钟山县', '111.303009', '24.525957', 'district', 0),
                                                                                                                    (2186, 2181, '1774', '451123', '富川瑶族自治县', '111.27745', '24.814443', 'district', 0),
                                                                                                                    (2187, 2088, '0778', '451200', '河池市', '108.085261', '24.692931', 'city', 0),
                                                                                                                    (2188, 2187, '0778', '451202', '金城江区', '108.037276', '24.689703', 'district', 0),
                                                                                                                    (2189, 2187, '0778', '451221', '南丹县', '107.541244', '24.975631', 'district', 0),
                                                                                                                    (2190, 2187, '0778', '451222', '天峨县', '107.173802', '24.999108', 'district', 0),
                                                                                                                    (2191, 2187, '0778', '451223', '凤山县', '107.04219', '24.546876', 'district', 0),
                                                                                                                    (2192, 2187, '0778', '451224', '东兰县', '107.374293', '24.510842', 'district', 0),
                                                                                                                    (2193, 2187, '0778', '451225', '罗城仫佬族自治县', '108.904706', '24.777411', 'district', 0),
                                                                                                                    (2194, 2187, '0778', '451226', '环江毛南族自治县', '108.258028', '24.825664', 'district', 0),
                                                                                                                    (2195, 2187, '0778', '451227', '巴马瑶族自治县', '107.258588', '24.142298', 'district', 0),
                                                                                                                    (2196, 2187, '0778', '451228', '都安瑶族自治县', '108.105311', '23.932675', 'district', 0),
                                                                                                                    (2197, 2187, '0778', '451229', '大化瑶族自治县', '107.998149', '23.736457', 'district', 0),
                                                                                                                    (2198, 2187, '0778', '451281', '宜州市', '108.636414', '24.485214', 'district', 0),
                                                                                                                    (2199, 2088, '1772', '451300', '来宾市', '109.221465', '23.750306', 'city', 0),
                                                                                                                    (2200, 2199, '1772', '451302', '兴宾区', '109.183333', '23.72892', 'district', 0),
                                                                                                                    (2201, 2199, '1772', '451321', '忻城县', '108.665666', '24.066234', 'district', 0),
                                                                                                                    (2202, 2199, '1772', '451322', '象州县', '109.705065', '23.973793', 'district', 0),
                                                                                                                    (2203, 2199, '1772', '451323', '武宣县', '109.663206', '23.59411', 'district', 0),
                                                                                                                    (2204, 2199, '1772', '451324', '金秀瑶族自治县', '110.189462', '24.130374', 'district', 0),
                                                                                                                    (2205, 2199, '1772', '451381', '合山市', '108.886082', '23.806535', 'district', 0),
                                                                                                                    (2206, 2088, '1771', '451400', '崇左市', '107.365094', '22.377253', 'city', 0),
                                                                                                                    (2207, 2206, '1771', '451402', '江州区', '107.353437', '22.405325', 'district', 0),
                                                                                                                    (2208, 2206, '1771', '451421', '扶绥县', '107.904186', '22.635012', 'district', 0),
                                                                                                                    (2209, 2206, '1771', '451422', '宁明县', '107.076456', '22.140192', 'district', 0),
                                                                                                                    (2210, 2206, '1771', '451423', '龙州县', '106.854482', '22.342778', 'district', 0),
                                                                                                                    (2211, 2206, '1771', '451424', '大新县', '107.200654', '22.829287', 'district', 0),
                                                                                                                    (2212, 2206, '1771', '451425', '天等县', '107.143432', '23.081394', 'district', 0),
                                                                                                                    (2213, 2206, '1771', '451481', '凭祥市', '106.766293', '22.094484', 'district', 0),
                                                                                                                    (2214, 1, '0', '460000', '海南省', '110.349228', '20.017377', 'province', 0),
                                                                                                                    (2215, 2214, '0802', '469025', '白沙黎族自治县', '109.451484', '19.224823', 'city', 0),
                                                                                                                    (2216, 2215, '0802', '469025', '白沙黎族自治县', '109.451484', '19.224823', 'district', 0),
                                                                                                                    (2217, 2214, '0801', '469029', '保亭黎族苗族自治县', '109.70259', '18.63913', 'city', 0),
                                                                                                                    (2218, 2217, '0801', '469029', '保亭黎族苗族自治县', '109.70259', '18.63913', 'district', 0),
                                                                                                                    (2219, 2214, '0803', '469026', '昌江黎族自治县', '109.055739', '19.298184', 'city', 0),
                                                                                                                    (2220, 2219, '0803', '469026', '昌江黎族自治县', '109.055739', '19.298184', 'district', 0),
                                                                                                                    (2221, 2214, '0804', '469023', '澄迈县', '110.006754', '19.738521', 'city', 0),
                                                                                                                    (2222, 2221, '0804', '469023', '澄迈县', '110.006754', '19.738521', 'district', 0),
                                                                                                                    (2223, 2214, '0898', '460100', '海口市', '110.198286', '20.044412', 'city', 0),
                                                                                                                    (2224, 2223, '0898', '460105', '秀英区', '110.293603', '20.007494', 'district', 0),
                                                                                                                    (2225, 2223, '0898', '460106', '龙华区', '110.328492', '20.031006', 'district', 0),
                                                                                                                    (2226, 2223, '0898', '460107', '琼山区', '110.353972', '20.003169', 'district', 0),
                                                                                                                    (2227, 2223, '0898', '460108', '美兰区', '110.366358', '20.029083', 'district', 0),
                                                                                                                    (2228, 2214, '0899', '460200', '三亚市', '109.511772', '18.253135', 'city', 0),
                                                                                                                    (2229, 2228, '0899', '460202', '海棠区', '109.752569', '18.400106', 'district', 0),
                                                                                                                    (2230, 2228, '0899', '460203', '吉阳区', '109.578336', '18.281406', 'district', 0),
                                                                                                                    (2231, 2228, '0899', '460204', '天涯区', '109.452378', '18.298156', 'district', 0),
                                                                                                                    (2232, 2228, '0899', '460205', '崖州区', '109.171841', '18.357291', 'district', 0),
                                                                                                                    (2233, 2214, '2898', '460300', '三沙市', '112.338695', '16.831839', 'city', 0),
                                                                                                                    (2234, 2233, '1895', '460321', '西沙群岛', '111.792944', '16.204546', 'district', 0),
                                                                                                                    (2235, 2233, '1891', '460322', '南沙群岛', '116.749997', '11.471888', 'district', 0),
                                                                                                                    (2236, 2233, '2801', '460323', '中沙群岛的岛礁及其海域', '117.740071', '15.112855', 'district', 0),
                                                                                                                    (2237, 2214, '0805', '460400', '儋州市', '109.580811', '19.521134', 'city', 0),
                                                                                                                    (2238, 2237, '0805', '460400', '儋州市', '109.580811', '19.521134', 'district', 0),
                                                                                                                    (2239, 2214, '0806', '469021', '定安县', '110.359339', '19.681404', 'city', 0),
                                                                                                                    (2240, 2239, '0806', '469021', '定安县', '110.359339', '19.681404', 'district', 0),
                                                                                                                    (2241, 2214, '0807', '469007', '东方市', '108.651815', '19.095351', 'city', 0),
                                                                                                                    (2242, 2241, '0807', '469007', '东方市', '108.651815', '19.095351', 'district', 0),
                                                                                                                    (2243, 2214, '2802', '469027', '乐东黎族自治县', '109.173054', '18.750259', 'city', 0),
                                                                                                                    (2244, 2243, '2802', '469027', '乐东黎族自治县', '109.173054', '18.750259', 'district', 0),
                                                                                                                    (2245, 2214, '1896', '469024', '临高县', '109.690508', '19.912025', 'city', 0),
                                                                                                                    (2246, 2245, '1896', '469024', '临高县', '109.690508', '19.912025', 'district', 0),
                                                                                                                    (2247, 2214, '0809', '469028', '陵水黎族自治县', '110.037503', '18.506048', 'city', 0),
                                                                                                                    (2248, 2247, '0809', '469028', '陵水黎族自治县', '110.037503', '18.506048', 'district', 0),
                                                                                                                    (2249, 2214, '1894', '469002', '琼海市', '110.474497', '19.259134', 'city', 0),
                                                                                                                    (2250, 2249, '1894', '469002', '琼海市', '110.474497', '19.259134', 'district', 0),
                                                                                                                    (2251, 2214, '1899', '469030', '琼中黎族苗族自治县', '109.838389', '19.033369', 'city', 0),
                                                                                                                    (2252, 2251, '1899', '469030', '琼中黎族苗族自治县', '109.838389', '19.033369', 'district', 0),
                                                                                                                    (2253, 2214, '1892', '469022', '屯昌县', '110.103415', '19.351765', 'city', 0),
                                                                                                                    (2254, 2253, '1892', '469022', '屯昌县', '110.103415', '19.351765', 'district', 0),
                                                                                                                    (2255, 2214, '1898', '469006', '万宁市', '110.391073', '18.795143', 'city', 0),
                                                                                                                    (2256, 2255, '1898', '469006', '万宁市', '110.391073', '18.795143', 'district', 0),
                                                                                                                    (2257, 2214, '1893', '469005', '文昌市', '110.797717', '19.543422', 'city', 0),
                                                                                                                    (2258, 2257, '1893', '469005', '文昌市', '110.797717', '19.543422', 'district', 0),
                                                                                                                    (2259, 2214, '1897', '469001', '五指山市', '109.516925', '18.775146', 'city', 0),
                                                                                                                    (2260, 2259, '1897', '469001', '五指山市', '109.516925', '18.775146', 'district', 0),
                                                                                                                    (2261, 1, '023', '500000', '重庆市', '106.551643', '29.562849', 'province', 7000),
                                                                                                                    (2262, 2261, '023', '500100', '重庆市', '106.551643', '29.562849', 'city', 0),
                                                                                                                    (2263, 2262, '023', '500101', '万州区', '108.408661', '30.807667', 'district', 0),
                                                                                                                    (2264, 2262, '023', '500102', '涪陵区', '107.38977', '29.703022', 'district', 0),
                                                                                                                    (2265, 2262, '023', '500103', '渝中区', '106.568896', '29.552736', 'district', 0),
                                                                                                                    (2266, 2262, '023', '500104', '大渡口区', '106.482346', '29.484527', 'district', 0),
                                                                                                                    (2267, 2262, '023', '500105', '江北区', '106.574271', '29.606703', 'district', 0),
                                                                                                                    (2268, 2262, '023', '500106', '沙坪坝区', '106.456878', '29.541144', 'district', 0),
                                                                                                                    (2269, 2262, '023', '500107', '九龙坡区', '106.510676', '29.502272', 'district', 0),
                                                                                                                    (2270, 2262, '023', '500108', '南岸区', '106.644447', '29.50126', 'district', 0),
                                                                                                                    (2271, 2262, '023', '500109', '北碚区', '106.395612', '29.805107', 'district', 0),
                                                                                                                    (2272, 2262, '023', '500110', '綦江区', '106.651361', '29.028066', 'district', 0),
                                                                                                                    (2273, 2262, '023', '500111', '大足区', '105.721733', '29.707032', 'district', 0),
                                                                                                                    (2274, 2262, '023', '500112', '渝北区', '106.631187', '29.718142', 'district', 0),
                                                                                                                    (2275, 2262, '023', '500113', '巴南区', '106.540256', '29.402408', 'district', 0),
                                                                                                                    (2276, 2262, '023', '500114', '黔江区', '108.770677', '29.533609', 'district', 0),
                                                                                                                    (2277, 2262, '023', '500115', '长寿区', '107.080734', '29.857912', 'district', 0),
                                                                                                                    (2278, 2262, '023', '500116', '江津区', '106.259281', '29.290069', 'district', 0),
                                                                                                                    (2279, 2262, '023', '500117', '合川区', '106.27613', '29.972084', 'district', 0),
                                                                                                                    (2280, 2262, '023', '500118', '永川区', '105.927001', '29.356311', 'district', 0),
                                                                                                                    (2281, 2262, '023', '500119', '南川区', '107.099266', '29.15789', 'district', 0),
                                                                                                                    (2282, 2262, '023', '500120', '璧山区', '106.227305', '29.592024', 'district', 0),
                                                                                                                    (2283, 2262, '023', '500151', '铜梁区', '106.056404', '29.844811', 'district', 0),
                                                                                                                    (2284, 2262, '023', '500152', '潼南区', '105.840431', '30.190992', 'district', 0),
                                                                                                                    (2285, 2262, '023', '500153', '荣昌区', '105.594623', '29.405002', 'district', 0),
                                                                                                                    (2286, 2262, '023', '500154', '开州区', '108.393135', '31.160711', 'district', 0),
                                                                                                                    (2287, 2261, '023', '500200', '重庆郊县', '108.165537', '29.293902', 'city', 0),
                                                                                                                    (2288, 2287, '023', '500228', '梁平区', '107.769568', '30.654233', 'district', 0),
                                                                                                                    (2289, 2287, '023', '500229', '城口县', '108.664214', '31.947633', 'district', 0),
                                                                                                                    (2290, 2287, '023', '500230', '丰都县', '107.730894', '29.8635', 'district', 0),
                                                                                                                    (2291, 2287, '023', '500231', '垫江县', '107.33339', '30.327716', 'district', 0),
                                                                                                                    (2292, 2287, '023', '500232', '武隆区', '107.760025', '29.325601', 'district', 0),
                                                                                                                    (2293, 2287, '023', '500233', '忠县', '108.039002', '30.299559', 'district', 0),
                                                                                                                    (2294, 2287, '023', '500235', '云阳县', '108.697324', '30.930612', 'district', 0),
                                                                                                                    (2295, 2287, '023', '500236', '奉节县', '109.400403', '31.018363', 'district', 0),
                                                                                                                    (2296, 2287, '023', '500237', '巫山县', '109.879153', '31.074834', 'district', 0),
                                                                                                                    (2297, 2287, '023', '500238', '巫溪县', '109.570062', '31.398604', 'district', 0),
                                                                                                                    (2298, 2287, '023', '500240', '石柱土家族自治县', '108.114069', '29.999285', 'district', 0),
                                                                                                                    (2299, 2287, '023', '500241', '秀山土家族苗族自治县', '109.007094', '28.447997', 'district', 0),
                                                                                                                    (2300, 2287, '023', '500242', '酉阳土家族苗族自治县', '108.767747', '28.841244', 'district', 0),
                                                                                                                    (2301, 2287, '023', '500243', '彭水苗族土家族自治县', '108.165537', '29.293902', 'district', 0),
                                                                                                                    (2302, 1, '0', '510000', '四川省', '104.075809', '30.651239', 'province', 0),
                                                                                                                    (2303, 2302, '028', '510100', '成都市', '104.066794', '30.572893', 'city', 0),
                                                                                                                    (2304, 2303, '028', '510104', '锦江区', '104.117022', '30.598158', 'district', 0),
                                                                                                                    (2305, 2303, '028', '510105', '青羊区', '104.061442', '30.673914', 'district', 0),
                                                                                                                    (2306, 2303, '028', '510106', '金牛区', '104.052236', '30.691359', 'district', 0),
                                                                                                                    (2307, 2303, '028', '510107', '武侯区', '104.043235', '30.641907', 'district', 0),
                                                                                                                    (2308, 2303, '028', '510108', '成华区', '104.101515', '30.659966', 'district', 0),
                                                                                                                    (2309, 2303, '028', '510112', '龙泉驿区', '104.274632', '30.556506', 'district', 0),
                                                                                                                    (2310, 2303, '028', '510113', '青白江区', '104.250945', '30.878629', 'district', 0),
                                                                                                                    (2311, 2303, '028', '510114', '新都区', '104.158705', '30.823498', 'district', 0),
                                                                                                                    (2312, 2303, '028', '510115', '温江区', '103.856646', '30.682203', 'district', 0),
                                                                                                                    (2313, 2303, '028', '510116', '双流区', '103.923566', '30.574449', 'district', 0),
                                                                                                                    (2314, 2303, '028', '510121', '金堂县', '104.411976', '30.861979', 'district', 0),
                                                                                                                    (2315, 2303, '028', '510124', '郫都区', '103.901091', '30.795854', 'district', 0),
                                                                                                                    (2316, 2303, '028', '510129', '大邑县', '103.511865', '30.572268', 'district', 0),
                                                                                                                    (2317, 2303, '028', '510131', '蒲江县', '103.506498', '30.196788', 'district', 0),
                                                                                                                    (2318, 2303, '028', '510132', '新津县', '103.811286', '30.410346', 'district', 0),
                                                                                                                    (2319, 2303, '028', '510180', '简阳市', '104.54722', '30.411264', 'district', 0),
                                                                                                                    (2320, 2303, '028', '510181', '都江堰市', '103.647153', '30.988767', 'district', 0),
                                                                                                                    (2321, 2303, '028', '510182', '彭州市', '103.957983', '30.990212', 'district', 0),
                                                                                                                    (2322, 2303, '028', '510183', '邛崃市', '103.464207', '30.410324', 'district', 0),
                                                                                                                    (2323, 2303, '028', '510184', '崇州市', '103.673001', '30.630122', 'district', 0),
                                                                                                                    (2324, 2302, '0813', '510300', '自贡市', '104.778442', '29.33903', 'city', 0),
                                                                                                                    (2325, 2324, '0813', '510302', '自流井区', '104.777191', '29.337429', 'district', 0),
                                                                                                                    (2326, 2324, '0813', '510303', '贡井区', '104.715288', '29.345313', 'district', 0),
                                                                                                                    (2327, 2324, '0813', '510304', '大安区', '104.773994', '29.363702', 'district', 0),
                                                                                                                    (2328, 2324, '0813', '510311', '沿滩区', '104.874079', '29.272586', 'district', 0),
                                                                                                                    (2329, 2324, '0813', '510321', '荣县', '104.417493', '29.445479', 'district', 0),
                                                                                                                    (2330, 2324, '0813', '510322', '富顺县', '104.975048', '29.181429', 'district', 0),
                                                                                                                    (2331, 2302, '0812', '510400', '攀枝花市', '101.718637', '26.582347', 'city', 0),
                                                                                                                    (2332, 2331, '0812', '510402', '东区', '101.704109', '26.546491', 'district', 0),
                                                                                                                    (2333, 2331, '0812', '510403', '西区', '101.630619', '26.597781', 'district', 0),
                                                                                                                    (2334, 2331, '0812', '510411', '仁和区', '101.738528', '26.497765', 'district', 0),
                                                                                                                    (2335, 2331, '0812', '510421', '米易县', '102.112895', '26.897694', 'district', 0),
                                                                                                                    (2336, 2331, '0812', '510422', '盐边县', '101.855071', '26.683213', 'district', 0),
                                                                                                                    (2337, 2302, '0830', '510500', '泸州市', '105.442285', '28.871805', 'city', 0),
                                                                                                                    (2338, 2337, '0830', '510502', '江阳区', '105.434982', '28.87881', 'district', 0),
                                                                                                                    (2339, 2337, '0830', '510503', '纳溪区', '105.371505', '28.773134', 'district', 0),
                                                                                                                    (2340, 2337, '0830', '510504', '龙马潭区', '105.437751', '28.913257', 'district', 0),
                                                                                                                    (2341, 2337, '0830', '510521', '泸县', '105.381893', '29.151534', 'district', 0),
                                                                                                                    (2342, 2337, '0830', '510522', '合江县', '105.830986', '28.811164', 'district', 0),
                                                                                                                    (2343, 2337, '0830', '510524', '叙永县', '105.444765', '28.155801', 'district', 0),
                                                                                                                    (2344, 2337, '0830', '510525', '古蔺县', '105.812601', '28.038801', 'district', 0),
                                                                                                                    (2345, 2302, '0838', '510600', '德阳市', '104.397894', '31.126855', 'city', 0),
                                                                                                                    (2346, 2345, '0838', '510603', '旌阳区', '104.416966', '31.142633', 'district', 0),
                                                                                                                    (2347, 2345, '0838', '510623', '中江县', '104.678751', '31.03307', 'district', 0),
                                                                                                                    (2348, 2345, '0838', '510626', '罗江县', '104.510249', '31.317045', 'district', 0),
                                                                                                                    (2349, 2345, '0838', '510681', '广汉市', '104.282429', '30.977119', 'district', 0),
                                                                                                                    (2350, 2345, '0838', '510682', '什邡市', '104.167501', '31.12678', 'district', 0),
                                                                                                                    (2351, 2345, '0838', '510683', '绵竹市', '104.22075', '31.338077', 'district', 0),
                                                                                                                    (2352, 2302, '0816', '510700', '绵阳市', '104.679004', '31.467459', 'city', 0),
                                                                                                                    (2353, 2352, '0816', '510703', '涪城区', '104.756944', '31.455101', 'district', 0),
                                                                                                                    (2354, 2352, '0816', '510704', '游仙区', '104.766392', '31.473779', 'district', 0),
                                                                                                                    (2355, 2352, '0816', '510705', '安州区', '104.567187', '31.534886', 'district', 0),
                                                                                                                    (2356, 2352, '0816', '510722', '三台县', '105.094586', '31.095979', 'district', 0),
                                                                                                                    (2357, 2352, '0816', '510723', '盐亭县', '105.389453', '31.208362', 'district', 0),
                                                                                                                    (2358, 2352, '0816', '510725', '梓潼县', '105.170845', '31.642718', 'district', 0),
                                                                                                                    (2359, 2352, '0816', '510726', '北川羌族自治县', '104.46797', '31.617203', 'district', 0),
                                                                                                                    (2360, 2352, '0816', '510727', '平武县', '104.555583', '32.409675', 'district', 0),
                                                                                                                    (2361, 2352, '0816', '510781', '江油市', '104.745915', '31.778026', 'district', 0),
                                                                                                                    (2362, 2302, '0839', '510800', '广元市', '105.843357', '32.435435', 'city', 0),
                                                                                                                    (2363, 2362, '0839', '510802', '利州区', '105.845307', '32.433756', 'district', 0),
                                                                                                                    (2364, 2362, '0839', '510811', '昭化区', '105.962819', '32.323256', 'district', 0),
                                                                                                                    (2365, 2362, '0839', '510812', '朝天区', '105.882642', '32.651336', 'district', 0),
                                                                                                                    (2366, 2362, '0839', '510821', '旺苍县', '106.289983', '32.229058', 'district', 0),
                                                                                                                    (2367, 2362, '0839', '510822', '青川县', '105.238842', '32.575484', 'district', 0),
                                                                                                                    (2368, 2362, '0839', '510823', '剑阁县', '105.524766', '32.287722', 'district', 0),
                                                                                                                    (2369, 2362, '0839', '510824', '苍溪县', '105.934756', '31.731709', 'district', 0),
                                                                                                                    (2370, 2302, '0825', '510900', '遂宁市', '105.592803', '30.53292', 'city', 0),
                                                                                                                    (2371, 2370, '0825', '510903', '船山区', '105.568297', '30.525475', 'district', 0),
                                                                                                                    (2372, 2370, '0825', '510904', '安居区', '105.456342', '30.355379', 'district', 0),
                                                                                                                    (2373, 2370, '0825', '510921', '蓬溪县', '105.70757', '30.757575', 'district', 0),
                                                                                                                    (2374, 2370, '0825', '510922', '射洪县', '105.388412', '30.871131', 'district', 0),
                                                                                                                    (2375, 2370, '0825', '510923', '大英县', '105.236923', '30.594409', 'district', 0),
                                                                                                                    (2376, 2302, '1832', '511000', '内江市', '105.058432', '29.580228', 'city', 0),
                                                                                                                    (2377, 2376, '1832', '511002', '市中区', '105.067597', '29.587053', 'district', 0),
                                                                                                                    (2378, 2376, '1832', '511011', '东兴区', '105.075489', '29.592756', 'district', 0),
                                                                                                                    (2379, 2376, '1832', '511024', '威远县', '104.668879', '29.52744', 'district', 0),
                                                                                                                    (2380, 2376, '1832', '511025', '资中县', '104.851944', '29.764059', 'district', 0),
                                                                                                                    (2381, 2376, '1832', '511028', '隆昌县', '105.287612', '29.339476', 'district', 0),
                                                                                                                    (2382, 2302, '0833', '511100', '乐山市', '103.765678', '29.552115', 'city', 0),
                                                                                                                    (2383, 2382, '0833', '511102', '市中区', '103.761329', '29.555374', 'district', 0),
                                                                                                                    (2384, 2382, '0833', '511111', '沙湾区', '103.549991', '29.413091', 'district', 0),
                                                                                                                    (2385, 2382, '0833', '511112', '五通桥区', '103.818014', '29.406945', 'district', 0),
                                                                                                                    (2386, 2382, '0833', '511113', '金口河区', '103.07862', '29.244345', 'district', 0),
                                                                                                                    (2387, 2382, '0833', '511123', '犍为县', '103.949326', '29.20817', 'district', 0),
                                                                                                                    (2388, 2382, '0833', '511124', '井研县', '104.069726', '29.651287', 'district', 0),
                                                                                                                    (2389, 2382, '0833', '511126', '夹江县', '103.571656', '29.73763', 'district', 0),
                                                                                                                    (2390, 2382, '0833', '511129', '沐川县', '103.902334', '28.956647', 'district', 0),
                                                                                                                    (2391, 2382, '0833', '511132', '峨边彝族自治县', '103.262048', '29.230425', 'district', 0),
                                                                                                                    (2392, 2382, '0833', '511133', '马边彝族自治县', '103.546347', '28.83552', 'district', 0),
                                                                                                                    (2393, 2382, '0833', '511181', '峨眉山市', '103.484503', '29.601198', 'district', 0),
                                                                                                                    (2394, 2302, '0817', '511300', '南充市', '106.110698', '30.837793', 'city', 0),
                                                                                                                    (2395, 2394, '0817', '511302', '顺庆区', '106.09245', '30.796803', 'district', 0),
                                                                                                                    (2396, 2394, '0817', '511303', '高坪区', '106.118808', '30.781623', 'district', 0),
                                                                                                                    (2397, 2394, '0817', '511304', '嘉陵区', '106.071876', '30.758823', 'district', 0),
                                                                                                                    (2398, 2394, '0817', '511321', '南部县', '106.036584', '31.347467', 'district', 0),
                                                                                                                    (2399, 2394, '0817', '511322', '营山县', '106.565519', '31.076579', 'district', 0),
                                                                                                                    (2400, 2394, '0817', '511323', '蓬安县', '106.412136', '31.029091', 'district', 0),
                                                                                                                    (2401, 2394, '0817', '511324', '仪陇县', '106.303042', '31.271561', 'district', 0),
                                                                                                                    (2402, 2394, '0817', '511325', '西充县', '105.90087', '30.995683', 'district', 0),
                                                                                                                    (2403, 2394, '0817', '511381', '阆中市', '106.005046', '31.558356', 'district', 0),
                                                                                                                    (2404, 2302, '1833', '511400', '眉山市', '103.848403', '30.076994', 'city', 0),
                                                                                                                    (2405, 2404, '1833', '511402', '东坡区', '103.831863', '30.042308', 'district', 0),
                                                                                                                    (2406, 2404, '1833', '511403', '彭山区', '103.872949', '30.193056', 'district', 0),
                                                                                                                    (2407, 2404, '1833', '511421', '仁寿县', '104.133995', '29.995635', 'district', 0),
                                                                                                                    (2408, 2404, '1833', '511423', '洪雅县', '103.372863', '29.90489', 'district', 0),
                                                                                                                    (2409, 2404, '1833', '511424', '丹棱县', '103.512783', '30.01521', 'district', 0),
                                                                                                                    (2410, 2404, '1833', '511425', '青神县', '103.846688', '29.831357', 'district', 0),
                                                                                                                    (2411, 2302, '0831', '511500', '宜宾市', '104.642845', '28.752134', 'city', 0),
                                                                                                                    (2412, 2411, '0831', '511502', '翠屏区', '104.620009', '28.765689', 'district', 0),
                                                                                                                    (2413, 2411, '0831', '511503', '南溪区', '104.969152', '28.846382', 'district', 0),
                                                                                                                    (2414, 2411, '0831', '511521', '宜宾县', '104.533212', '28.690045', 'district', 0),
                                                                                                                    (2415, 2411, '0831', '511523', '江安县', '105.066879', '28.723855', 'district', 0),
                                                                                                                    (2416, 2411, '0831', '511524', '长宁县', '104.921174', '28.582169', 'district', 0),
                                                                                                                    (2417, 2411, '0831', '511525', '高县', '104.517748', '28.436166', 'district', 0),
                                                                                                                    (2418, 2411, '0831', '511526', '珙县', '104.709202', '28.43863', 'district', 0),
                                                                                                                    (2419, 2411, '0831', '511527', '筠连县', '104.512025', '28.167831', 'district', 0),
                                                                                                                    (2420, 2411, '0831', '511528', '兴文县', '105.236325', '28.303614', 'district', 0),
                                                                                                                    (2421, 2411, '0831', '511529', '屏山县', '104.345974', '28.828482', 'district', 0),
                                                                                                                    (2422, 2302, '0826', '511600', '广安市', '106.633088', '30.456224', 'city', 0),
                                                                                                                    (2423, 2422, '0826', '511602', '广安区', '106.641662', '30.473913', 'district', 0),
                                                                                                                    (2424, 2422, '0826', '511603', '前锋区', '106.886143', '30.495804', 'district', 0),
                                                                                                                    (2425, 2422, '0826', '511621', '岳池县', '106.440114', '30.537863', 'district', 0),
                                                                                                                    (2426, 2422, '0826', '511622', '武胜县', '106.295764', '30.348772', 'district', 0),
                                                                                                                    (2427, 2422, '0826', '511623', '邻水县', '106.93038', '30.334768', 'district', 0),
                                                                                                                    (2428, 2422, '0826', '511681', '华蓥市', '106.7831', '30.390188', 'district', 0),
                                                                                                                    (2429, 2302, '0818', '511700', '达州市', '107.467758', '31.209121', 'city', 0),
                                                                                                                    (2430, 2429, '0818', '511702', '通川区', '107.504928', '31.214715', 'district', 0),
                                                                                                                    (2431, 2429, '0818', '511703', '达川区', '107.511749', '31.196157', 'district', 0),
                                                                                                                    (2432, 2429, '0818', '511722', '宣汉县', '107.72719', '31.353835', 'district', 0),
                                                                                                                    (2433, 2429, '0818', '511723', '开江县', '107.868736', '31.082986', 'district', 0),
                                                                                                                    (2434, 2429, '0818', '511724', '大竹县', '107.204795', '30.73641', 'district', 0),
                                                                                                                    (2435, 2429, '0818', '511725', '渠县', '106.97303', '30.836618', 'district', 0),
                                                                                                                    (2436, 2429, '0818', '511781', '万源市', '108.034657', '32.081631', 'district', 0),
                                                                                                                    (2437, 2302, '0835', '511800', '雅安市', '103.042375', '30.010602', 'city', 0),
                                                                                                                    (2438, 2437, '0835', '511802', '雨城区', '103.033026', '30.005461', 'district', 0),
                                                                                                                    (2439, 2437, '0835', '511803', '名山区', '103.109184', '30.069954', 'district', 0),
                                                                                                                    (2440, 2437, '0835', '511822', '荥经县', '102.846737', '29.792931', 'district', 0),
                                                                                                                    (2441, 2437, '0835', '511823', '汉源县', '102.645467', '29.347192', 'district', 0),
                                                                                                                    (2442, 2437, '0835', '511824', '石棉县', '102.359462', '29.227874', 'district', 0),
                                                                                                                    (2443, 2437, '0835', '511825', '天全县', '102.758317', '30.066712', 'district', 0),
                                                                                                                    (2444, 2437, '0835', '511826', '芦山县', '102.932385', '30.142307', 'district', 0),
                                                                                                                    (2445, 2437, '0835', '511827', '宝兴县', '102.815403', '30.37641', 'district', 0),
                                                                                                                    (2446, 2302, '0827', '511900', '巴中市', '106.747477', '31.867903', 'city', 0),
                                                                                                                    (2447, 2446, '0827', '511902', '巴州区', '106.768878', '31.851478', 'district', 0),
                                                                                                                    (2448, 2446, '0827', '511903', '恩阳区', '106.654386', '31.787186', 'district', 0),
                                                                                                                    (2449, 2446, '0827', '511921', '通江县', '107.245033', '31.911705', 'district', 0),
                                                                                                                    (2450, 2446, '0827', '511922', '南江县', '106.828697', '32.346589', 'district', 0),
                                                                                                                    (2451, 2446, '0827', '511923', '平昌县', '107.104008', '31.560874', 'district', 0),
                                                                                                                    (2452, 2302, '0832', '512000', '资阳市', '104.627636', '30.128901', 'city', 0),
                                                                                                                    (2453, 2452, '0832', '512002', '雁江区', '104.677091', '30.108216', 'district', 0),
                                                                                                                    (2454, 2452, '0832', '512021', '安岳县', '105.35534', '30.103107', 'district', 0),
                                                                                                                    (2455, 2452, '0832', '512022', '乐至县', '105.02019', '30.276121', 'district', 0),
                                                                                                                    (2456, 2302, '0837', '513200', '阿坝藏族羌族自治州', '102.224653', '31.899413', 'city', 0),
                                                                                                                    (2457, 2456, '0837', '513201', '马尔康市', '102.20652', '31.905693', 'district', 0),
                                                                                                                    (2458, 2456, '0837', '513221', '汶川县', '103.590179', '31.476854', 'district', 0),
                                                                                                                    (2459, 2456, '0837', '513222', '理县', '103.164661', '31.435174', 'district', 0),
                                                                                                                    (2460, 2456, '0837', '513223', '茂县', '103.853363', '31.681547', 'district', 0),
                                                                                                                    (2461, 2456, '0837', '513224', '松潘县', '103.604698', '32.655325', 'district', 0),
                                                                                                                    (2462, 2456, '0837', '513225', '九寨沟县', '104.243841', '33.252056', 'district', 0),
                                                                                                                    (2463, 2456, '0837', '513226', '金川县', '102.063829', '31.476277', 'district', 0),
                                                                                                                    (2464, 2456, '0837', '513227', '小金县', '102.362984', '30.995823', 'district', 0),
                                                                                                                    (2465, 2456, '0837', '513228', '黑水县', '102.990108', '32.061895', 'district', 0),
                                                                                                                    (2466, 2456, '0837', '513230', '壤塘县', '100.978526', '32.265796', 'district', 0),
                                                                                                                    (2467, 2456, '0837', '513231', '阿坝县', '101.706655', '32.902459', 'district', 0),
                                                                                                                    (2468, 2456, '0837', '513232', '若尔盖县', '102.967826', '33.578159', 'district', 0),
                                                                                                                    (2469, 2456, '0837', '513233', '红原县', '102.544405', '32.790891', 'district', 0),
                                                                                                                    (2470, 2302, '0836', '513300', '甘孜藏族自治州', '101.96231', '30.04952', 'city', 0),
                                                                                                                    (2471, 2470, '0836', '513301', '康定市', '101.957146', '29.998435', 'district', 0),
                                                                                                                    (2472, 2470, '0836', '513322', '泸定县', '102.234617', '29.91416', 'district', 0),
                                                                                                                    (2473, 2470, '0836', '513323', '丹巴县', '101.890358', '30.878577', 'district', 0),
                                                                                                                    (2474, 2470, '0836', '513324', '九龙县', '101.507294', '29.000347', 'district', 0),
                                                                                                                    (2475, 2470, '0836', '513325', '雅江县', '101.014425', '30.031533', 'district', 0),
                                                                                                                    (2476, 2470, '0836', '513326', '道孚县', '101.125237', '30.979545', 'district', 0),
                                                                                                                    (2477, 2470, '0836', '513327', '炉霍县', '100.676372', '31.39179', 'district', 0),
                                                                                                                    (2478, 2470, '0836', '513328', '甘孜县', '99.99267', '31.622933', 'district', 0),
                                                                                                                    (2479, 2470, '0836', '513329', '新龙县', '100.311368', '30.939169', 'district', 0),
                                                                                                                    (2480, 2470, '0836', '513330', '德格县', '98.580914', '31.806118', 'district', 0),
                                                                                                                    (2481, 2470, '0836', '513331', '白玉县', '98.824182', '31.209913', 'district', 0),
                                                                                                                    (2482, 2470, '0836', '513332', '石渠县', '98.102914', '32.97896', 'district', 0),
                                                                                                                    (2483, 2470, '0836', '513333', '色达县', '100.332743', '32.268129', 'district', 0),
                                                                                                                    (2484, 2470, '0836', '513334', '理塘县', '100.269817', '29.996049', 'district', 0),
                                                                                                                    (2485, 2470, '0836', '513335', '巴塘县', '99.110712', '30.004677', 'district', 0),
                                                                                                                    (2486, 2470, '0836', '513336', '乡城县', '99.798435', '28.931172', 'district', 0),
                                                                                                                    (2487, 2470, '0836', '513337', '稻城县', '100.298403', '29.037007', 'district', 0),
                                                                                                                    (2488, 2470, '0836', '513338', '得荣县', '99.286335', '28.713036', 'district', 0),
                                                                                                                    (2489, 2302, '0834', '513400', '凉山彝族自治州', '102.267712', '27.88157', 'city', 0),
                                                                                                                    (2490, 2489, '0834', '513401', '西昌市', '102.264449', '27.894504', 'district', 0),
                                                                                                                    (2491, 2489, '0834', '513422', '木里藏族自治县', '101.280205', '27.928835', 'district', 0),
                                                                                                                    (2492, 2489, '0834', '513423', '盐源县', '101.509188', '27.422645', 'district', 0),
                                                                                                                    (2493, 2489, '0834', '513424', '德昌县', '102.17567', '27.402839', 'district', 0),
                                                                                                                    (2494, 2489, '0834', '513425', '会理县', '102.244683', '26.655026', 'district', 0),
                                                                                                                    (2495, 2489, '0834', '513426', '会东县', '102.57796', '26.634669', 'district', 0),
                                                                                                                    (2496, 2489, '0834', '513427', '宁南县', '102.751745', '27.061189', 'district', 0),
                                                                                                                    (2497, 2489, '0834', '513428', '普格县', '102.540901', '27.376413', 'district', 0),
                                                                                                                    (2498, 2489, '0834', '513429', '布拖县', '102.812061', '27.706061', 'district', 0),
                                                                                                                    (2499, 2489, '0834', '513430', '金阳县', '103.248772', '27.69686', 'district', 0),
                                                                                                                    (2500, 2489, '0834', '513431', '昭觉县', '102.840264', '28.015333', 'district', 0),
                                                                                                                    (2501, 2489, '0834', '513432', '喜德县', '102.412518', '28.306726', 'district', 0),
                                                                                                                    (2502, 2489, '0834', '513433', '冕宁县', '102.17701', '28.549656', 'district', 0),
                                                                                                                    (2503, 2489, '0834', '513434', '越西县', '102.50768', '28.639801', 'district', 0),
                                                                                                                    (2504, 2489, '0834', '513435', '甘洛县', '102.771504', '28.959157', 'district', 0),
                                                                                                                    (2505, 2489, '0834', '513436', '美姑县', '103.132179', '28.32864', 'district', 0),
                                                                                                                    (2506, 2489, '0834', '513437', '雷波县', '103.571696', '28.262682', 'district', 0),
                                                                                                                    (2507, 1, '0', '520000', '贵州省', '106.70546', '26.600055', 'province', 0),
                                                                                                                    (2508, 2507, '0851', '520100', '贵阳市', '106.630153', '26.647661', 'city', 0),
                                                                                                                    (2509, 2508, '0851', '520102', '南明区', '106.714374', '26.567944', 'district', 0),
                                                                                                                    (2510, 2508, '0851', '520103', '云岩区', '106.724494', '26.604688', 'district', 0),
                                                                                                                    (2511, 2508, '0851', '520111', '花溪区', '106.67026', '26.409817', 'district', 0),
                                                                                                                    (2512, 2508, '0851', '520112', '乌当区', '106.750625', '26.630845', 'district', 0),
                                                                                                                    (2513, 2508, '0851', '520113', '白云区', '106.623007', '26.678561', 'district', 0),
                                                                                                                    (2514, 2508, '0851', '520115', '观山湖区', '106.622453', '26.60145', 'district', 0),
                                                                                                                    (2515, 2508, '0851', '520121', '开阳县', '106.965089', '27.057764', 'district', 0),
                                                                                                                    (2516, 2508, '0851', '520122', '息烽县', '106.740407', '27.090479', 'district', 0),
                                                                                                                    (2517, 2508, '0851', '520123', '修文县', '106.592108', '26.838926', 'district', 0),
                                                                                                                    (2518, 2508, '0851', '520181', '清镇市', '106.470714', '26.556079', 'district', 0),
                                                                                                                    (2519, 2507, '0858', '520200', '六盘水市', '104.830458', '26.592707', 'city', 0),
                                                                                                                    (2520, 2519, '0858', '520201', '钟山区', '104.843555', '26.574979', 'district', 0),
                                                                                                                    (2521, 2519, '0858', '520203', '六枝特区', '105.476608', '26.213108', 'district', 0),
                                                                                                                    (2522, 2519, '0858', '520221', '水城县', '104.95783', '26.547904', 'district', 0),
                                                                                                                    (2523, 2519, '0858', '520222', '盘县', '104.471375', '25.709852', 'district', 0),
                                                                                                                    (2524, 2507, '0852', '520300', '遵义市', '106.927389', '27.725654', 'city', 0),
                                                                                                                    (2525, 2524, '0852', '520302', '红花岗区', '106.8937', '27.644754', 'district', 0),
                                                                                                                    (2526, 2524, '0852', '520303', '汇川区', '106.93427', '27.750125', 'district', 0),
                                                                                                                    (2527, 2524, '0852', '520304', '播州区', '106.829574', '27.536298', 'district', 0),
                                                                                                                    (2528, 2524, '0852', '520322', '桐梓县', '106.825198', '28.133311', 'district', 0),
                                                                                                                    (2529, 2524, '0852', '520323', '绥阳县', '107.191222', '27.946222', 'district', 0),
                                                                                                                    (2530, 2524, '0852', '520324', '正安县', '107.453945', '28.553285', 'district', 0),
                                                                                                                    (2531, 2524, '0852', '520325', '道真仡佬族苗族自治县', '107.613133', '28.862425', 'district', 0),
                                                                                                                    (2532, 2524, '0852', '520326', '务川仡佬族苗族自治县', '107.898956', '28.563086', 'district', 0),
                                                                                                                    (2533, 2524, '0852', '520327', '凤冈县', '107.716355', '27.954695', 'district', 0),
                                                                                                                    (2534, 2524, '0852', '520328', '湄潭县', '107.465407', '27.749055', 'district', 0),
                                                                                                                    (2535, 2524, '0852', '520329', '余庆县', '107.905197', '27.215491', 'district', 0),
                                                                                                                    (2536, 2524, '0852', '520330', '习水县', '106.197137', '28.33127', 'district', 0),
                                                                                                                    (2537, 2524, '0852', '520381', '赤水市', '105.697472', '28.590337', 'district', 0),
                                                                                                                    (2538, 2524, '0852', '520382', '仁怀市', '106.40109', '27.792514', 'district', 0),
                                                                                                                    (2539, 2507, '0853', '520400', '安顺市', '105.947594', '26.253088', 'city', 0),
                                                                                                                    (2540, 2539, '0853', '520402', '西秀区', '105.965116', '26.245315', 'district', 0),
                                                                                                                    (2541, 2539, '0853', '520403', '平坝区', '106.256412', '26.405715', 'district', 0),
                                                                                                                    (2542, 2539, '0853', '520422', '普定县', '105.743277', '26.301565', 'district', 0),
                                                                                                                    (2543, 2539, '0853', '520423', '镇宁布依族苗族自治县', '105.770283', '26.058086', 'district', 0),
                                                                                                                    (2544, 2539, '0853', '520424', '关岭布依族苗族自治县', '105.61933', '25.94361', 'district', 0),
                                                                                                                    (2545, 2539, '0853', '520425', '紫云苗族布依族自治县', '106.084441', '25.751047', 'district', 0),
                                                                                                                    (2546, 2507, '0857', '520500', '毕节市', '105.291702', '27.283908', 'city', 0),
                                                                                                                    (2547, 2546, '0857', '520502', '七星关区', '105.30474', '27.298458', 'district', 0),
                                                                                                                    (2548, 2546, '0857', '520521', '大方县', '105.613037', '27.141735', 'district', 0),
                                                                                                                    (2549, 2546, '0857', '520522', '黔西县', '106.033544', '27.007713', 'district', 0),
                                                                                                                    (2550, 2546, '0857', '520523', '金沙县', '106.220227', '27.459214', 'district', 0),
                                                                                                                    (2551, 2546, '0857', '520524', '织金县', '105.770542', '26.663449', 'district', 0),
                                                                                                                    (2552, 2546, '0857', '520525', '纳雍县', '105.382714', '26.777645', 'district', 0),
                                                                                                                    (2553, 2546, '0857', '520526', '威宁彝族回族苗族自治县', '104.253071', '26.873806', 'district', 0),
                                                                                                                    (2554, 2546, '0857', '520527', '赫章县', '104.727418', '27.123078', 'district', 0),
                                                                                                                    (2555, 2507, '0856', '520600', '铜仁市', '109.189598', '27.731514', 'city', 0),
                                                                                                                    (2556, 2555, '0856', '520602', '碧江区', '109.263998', '27.815927', 'district', 0),
                                                                                                                    (2557, 2555, '0856', '520603', '万山区', '109.213644', '27.517896', 'district', 0),
                                                                                                                    (2558, 2555, '0856', '520621', '江口县', '108.839557', '27.69965', 'district', 0),
                                                                                                                    (2559, 2555, '0856', '520622', '玉屏侗族自治县', '108.906411', '27.235813', 'district', 0),
                                                                                                                    (2560, 2555, '0856', '520623', '石阡县', '108.223612', '27.513829', 'district', 0),
                                                                                                                    (2561, 2555, '0856', '520624', '思南县', '108.253882', '27.93755', 'district', 0),
                                                                                                                    (2562, 2555, '0856', '520625', '印江土家族苗族自治县', '108.409751', '27.994246', 'district', 0),
                                                                                                                    (2563, 2555, '0856', '520626', '德江县', '108.119807', '28.263963', 'district', 0),
                                                                                                                    (2564, 2555, '0856', '520627', '沿河土家族自治县', '108.50387', '28.563927', 'district', 0),
                                                                                                                    (2565, 2555, '0856', '520628', '松桃苗族自治县', '109.202886', '28.154071', 'district', 0),
                                                                                                                    (2566, 2507, '0859', '522300', '黔西南布依族苗族自治州', '104.906397', '25.087856', 'city', 0),
                                                                                                                    (2567, 2566, '0859', '522301', '兴义市', '104.895467', '25.09204', 'district', 0),
                                                                                                                    (2568, 2566, '0859', '522322', '兴仁县', '105.186237', '25.435183', 'district', 0),
                                                                                                                    (2569, 2566, '0859', '522323', '普安县', '104.953062', '25.784135', 'district', 0);
INSERT INTO `sys_region` (`id`, `parent_id`, `citycode`, `adcode`, `name`, `lng`, `lat`, `level`, `sort_order`) VALUES
                                                                                                                    (2570, 2566, '0859', '522324', '晴隆县', '105.218991', '25.834783', 'district', 0),
                                                                                                                    (2571, 2566, '0859', '522325', '贞丰县', '105.649864', '25.38576', 'district', 0),
                                                                                                                    (2572, 2566, '0859', '522326', '望谟县', '106.099617', '25.178421', 'district', 0),
                                                                                                                    (2573, 2566, '0859', '522327', '册亨县', '105.811592', '24.983663', 'district', 0),
                                                                                                                    (2574, 2566, '0859', '522328', '安龙县', '105.442701', '25.099014', 'district', 0),
                                                                                                                    (2575, 2507, '0855', '522600', '黔东南苗族侗族自治州', '107.982874', '26.583457', 'city', 0),
                                                                                                                    (2576, 2575, '0855', '522601', '凯里市', '107.97754', '26.582963', 'district', 0),
                                                                                                                    (2577, 2575, '0855', '522622', '黄平县', '107.916411', '26.905396', 'district', 0),
                                                                                                                    (2578, 2575, '0855', '522623', '施秉县', '108.124379', '27.03292', 'district', 0),
                                                                                                                    (2579, 2575, '0855', '522624', '三穗县', '108.675267', '26.952967', 'district', 0),
                                                                                                                    (2580, 2575, '0855', '522625', '镇远县', '108.429534', '27.049497', 'district', 0),
                                                                                                                    (2581, 2575, '0855', '522626', '岑巩县', '108.81606', '27.173887', 'district', 0),
                                                                                                                    (2582, 2575, '0855', '522627', '天柱县', '109.207751', '26.909639', 'district', 0),
                                                                                                                    (2583, 2575, '0855', '522628', '锦屏县', '109.200534', '26.676233', 'district', 0),
                                                                                                                    (2584, 2575, '0855', '522629', '剑河县', '108.441501', '26.728274', 'district', 0),
                                                                                                                    (2585, 2575, '0855', '522630', '台江县', '108.321245', '26.667525', 'district', 0),
                                                                                                                    (2586, 2575, '0855', '522631', '黎平县', '109.136932', '26.230706', 'district', 0),
                                                                                                                    (2587, 2575, '0855', '522632', '榕江县', '108.52188', '25.931893', 'district', 0),
                                                                                                                    (2588, 2575, '0855', '522633', '从江县', '108.905329', '25.753009', 'district', 0),
                                                                                                                    (2589, 2575, '0855', '522634', '雷山县', '108.07754', '26.378442', 'district', 0),
                                                                                                                    (2590, 2575, '0855', '522635', '麻江县', '107.589359', '26.491105', 'district', 0),
                                                                                                                    (2591, 2575, '0855', '522636', '丹寨县', '107.788727', '26.19832', 'district', 0),
                                                                                                                    (2592, 2507, '0854', '522700', '黔南布依族苗族自治州', '107.522171', '26.253275', 'city', 0),
                                                                                                                    (2593, 2592, '0854', '522701', '都匀市', '107.518847', '26.259427', 'district', 0),
                                                                                                                    (2594, 2592, '0854', '522702', '福泉市', '107.520386', '26.686335', 'district', 0),
                                                                                                                    (2595, 2592, '0854', '522722', '荔波县', '107.898882', '25.423895', 'district', 0),
                                                                                                                    (2596, 2592, '0854', '522723', '贵定县', '107.232793', '26.557089', 'district', 0),
                                                                                                                    (2597, 2592, '0854', '522725', '瓮安县', '107.470942', '27.078441', 'district', 0),
                                                                                                                    (2598, 2592, '0854', '522726', '独山县', '107.545048', '25.822132', 'district', 0),
                                                                                                                    (2599, 2592, '0854', '522727', '平塘县', '107.322323', '25.822349', 'district', 0),
                                                                                                                    (2600, 2592, '0854', '522728', '罗甸县', '106.751589', '25.426173', 'district', 0),
                                                                                                                    (2601, 2592, '0854', '522729', '长顺县', '106.441805', '26.025626', 'district', 0),
                                                                                                                    (2602, 2592, '0854', '522730', '龙里县', '106.979524', '26.453154', 'district', 0),
                                                                                                                    (2603, 2592, '0854', '522731', '惠水县', '106.656442', '26.13278', 'district', 0),
                                                                                                                    (2604, 2592, '0854', '522732', '三都水族自治县', '107.869749', '25.983202', 'district', 0),
                                                                                                                    (2605, 1, '0', '530000', '云南省', '102.710002', '25.045806', 'province', 0),
                                                                                                                    (2606, 2605, '0871', '530100', '昆明市', '102.832891', '24.880095', 'city', 0),
                                                                                                                    (2607, 2606, '0871', '530102', '五华区', '102.707262', '25.043635', 'district', 0),
                                                                                                                    (2608, 2606, '0871', '530103', '盘龙区', '102.751941', '25.116465', 'district', 0),
                                                                                                                    (2609, 2606, '0871', '530111', '官渡区', '102.749026', '24.950231', 'district', 0),
                                                                                                                    (2610, 2606, '0871', '530112', '西山区', '102.664382', '25.038604', 'district', 0),
                                                                                                                    (2611, 2606, '0871', '530113', '东川区', '103.187824', '26.082873', 'district', 0),
                                                                                                                    (2612, 2606, '0871', '530114', '呈贡区', '102.821675', '24.885587', 'district', 0),
                                                                                                                    (2613, 2606, '0871', '530122', '晋宁区', '102.595412', '24.66974', 'district', 0),
                                                                                                                    (2614, 2606, '0871', '530124', '富民县', '102.4976', '25.221935', 'district', 0),
                                                                                                                    (2615, 2606, '0871', '530125', '宜良县', '103.141603', '24.919839', 'district', 0),
                                                                                                                    (2616, 2606, '0871', '530126', '石林彝族自治县', '103.290536', '24.771761', 'district', 0),
                                                                                                                    (2617, 2606, '0871', '530127', '嵩明县', '103.036908', '25.338643', 'district', 0),
                                                                                                                    (2618, 2606, '0871', '530128', '禄劝彝族苗族自治县', '102.471518', '25.551332', 'district', 0),
                                                                                                                    (2619, 2606, '0871', '530129', '寻甸回族彝族自治县', '103.256615', '25.558201', 'district', 0),
                                                                                                                    (2620, 2606, '0871', '530181', '安宁市', '102.478494', '24.919493', 'district', 0),
                                                                                                                    (2621, 2605, '0874', '530300', '曲靖市', '103.796167', '25.489999', 'city', 0),
                                                                                                                    (2622, 2621, '0874', '530302', '麒麟区', '103.80474', '25.495326', 'district', 0),
                                                                                                                    (2623, 2621, '0874', '530303', '沾益区', '103.822324', '25.600507', 'district', 0),
                                                                                                                    (2624, 2621, '0874', '530321', '马龙县', '103.578478', '25.42805', 'district', 0),
                                                                                                                    (2625, 2621, '0874', '530322', '陆良县', '103.666663', '25.030051', 'district', 0),
                                                                                                                    (2626, 2621, '0874', '530323', '师宗县', '103.985321', '24.822233', 'district', 0),
                                                                                                                    (2627, 2621, '0874', '530324', '罗平县', '104.308675', '24.884626', 'district', 0),
                                                                                                                    (2628, 2621, '0874', '530325', '富源县', '104.255014', '25.674238', 'district', 0),
                                                                                                                    (2629, 2621, '0874', '530326', '会泽县', '103.297386', '26.417345', 'district', 0),
                                                                                                                    (2630, 2621, '0874', '530381', '宣威市', '104.10455', '26.219735', 'district', 0),
                                                                                                                    (2631, 2605, '0877', '530400', '玉溪市', '102.527197', '24.347324', 'city', 0),
                                                                                                                    (2632, 2631, '0877', '530402', '红塔区', '102.540122', '24.341215', 'district', 0),
                                                                                                                    (2633, 2631, '0877', '530403', '江川区', '102.75344', '24.287485', 'district', 0),
                                                                                                                    (2634, 2631, '0877', '530422', '澄江县', '102.904629', '24.675689', 'district', 0),
                                                                                                                    (2635, 2631, '0877', '530423', '通海县', '102.725452', '24.111048', 'district', 0),
                                                                                                                    (2636, 2631, '0877', '530424', '华宁县', '102.928835', '24.19276', 'district', 0),
                                                                                                                    (2637, 2631, '0877', '530425', '易门县', '102.162531', '24.671651', 'district', 0),
                                                                                                                    (2638, 2631, '0877', '530426', '峨山彝族自治县', '102.405819', '24.168957', 'district', 0),
                                                                                                                    (2639, 2631, '0877', '530427', '新平彝族傣族自治县', '101.990157', '24.07005', 'district', 0),
                                                                                                                    (2640, 2631, '0877', '530428', '元江哈尼族彝族傣族自治县', '101.998103', '23.596503', 'district', 0),
                                                                                                                    (2641, 2605, '0875', '530500', '保山市', '99.161761', '25.112046', 'city', 0),
                                                                                                                    (2642, 2641, '0875', '530502', '隆阳区', '99.165607', '25.121154', 'district', 0),
                                                                                                                    (2643, 2641, '0875', '530521', '施甸县', '99.189221', '24.723064', 'district', 0),
                                                                                                                    (2644, 2641, '0875', '530523', '龙陵县', '98.689261', '24.586794', 'district', 0),
                                                                                                                    (2645, 2641, '0875', '530524', '昌宁县', '99.605142', '24.827839', 'district', 0),
                                                                                                                    (2646, 2641, '0875', '530581', '腾冲市', '98.490966', '25.020439', 'district', 0),
                                                                                                                    (2647, 2605, '0870', '530600', '昭通市', '103.717465', '27.338257', 'city', 0),
                                                                                                                    (2648, 2647, '0870', '530602', '昭阳区', '103.706539', '27.320075', 'district', 0),
                                                                                                                    (2649, 2647, '0870', '530621', '鲁甸县', '103.558042', '27.186659', 'district', 0),
                                                                                                                    (2650, 2647, '0870', '530622', '巧家县', '102.930164', '26.90846', 'district', 0),
                                                                                                                    (2651, 2647, '0870', '530623', '盐津县', '104.234441', '28.10871', 'district', 0),
                                                                                                                    (2652, 2647, '0870', '530624', '大关县', '103.891146', '27.747978', 'district', 0),
                                                                                                                    (2653, 2647, '0870', '530625', '永善县', '103.638067', '28.229112', 'district', 0),
                                                                                                                    (2654, 2647, '0870', '530626', '绥江县', '103.968978', '28.592099', 'district', 0),
                                                                                                                    (2655, 2647, '0870', '530627', '镇雄县', '104.87376', '27.441622', 'district', 0),
                                                                                                                    (2656, 2647, '0870', '530628', '彝良县', '104.048289', '27.625418', 'district', 0),
                                                                                                                    (2657, 2647, '0870', '530629', '威信县', '105.049027', '27.8469', 'district', 0),
                                                                                                                    (2658, 2647, '0870', '530630', '水富县', '104.41603', '28.62988', 'district', 0),
                                                                                                                    (2659, 2605, '0888', '530700', '丽江市', '100.22775', '26.855047', 'city', 0),
                                                                                                                    (2660, 2659, '0888', '530702', '古城区', '100.225784', '26.876927', 'district', 0),
                                                                                                                    (2661, 2659, '0888', '530721', '玉龙纳西族自治县', '100.236954', '26.821459', 'district', 0),
                                                                                                                    (2662, 2659, '0888', '530722', '永胜县', '100.750826', '26.684225', 'district', 0),
                                                                                                                    (2663, 2659, '0888', '530723', '华坪县', '101.266195', '26.629211', 'district', 0),
                                                                                                                    (2664, 2659, '0888', '530724', '宁蒗彝族自治县', '100.852001', '27.28207', 'district', 0),
                                                                                                                    (2665, 2605, '0879', '530800', '普洱市', '100.966156', '22.825155', 'city', 0),
                                                                                                                    (2666, 2665, '0879', '530802', '思茅区', '100.977256', '22.787115', 'district', 0),
                                                                                                                    (2667, 2665, '0879', '530821', '宁洱哈尼族彝族自治县', '101.045837', '23.048401', 'district', 0),
                                                                                                                    (2668, 2665, '0879', '530822', '墨江哈尼族自治县', '101.692461', '23.431894', 'district', 0),
                                                                                                                    (2669, 2665, '0879', '530823', '景东彝族自治县', '100.833877', '24.446731', 'district', 0),
                                                                                                                    (2670, 2665, '0879', '530824', '景谷傣族彝族自治县', '100.702871', '23.497028', 'district', 0),
                                                                                                                    (2671, 2665, '0879', '530825', '镇沅彝族哈尼族拉祜族自治县', '101.108595', '24.004441', 'district', 0),
                                                                                                                    (2672, 2665, '0879', '530826', '江城哈尼族彝族自治县', '101.86212', '22.585867', 'district', 0),
                                                                                                                    (2673, 2665, '0879', '530827', '孟连傣族拉祜族佤族自治县', '99.584157', '22.329099', 'district', 0),
                                                                                                                    (2674, 2665, '0879', '530828', '澜沧拉祜族自治县', '99.931975', '22.555904', 'district', 0),
                                                                                                                    (2675, 2665, '0879', '530829', '西盟佤族自治县', '99.590123', '22.644508', 'district', 0),
                                                                                                                    (2676, 2605, '0883', '530900', '临沧市', '100.08879', '23.883955', 'city', 0),
                                                                                                                    (2677, 2676, '0883', '530902', '临翔区', '100.082523', '23.895137', 'district', 0),
                                                                                                                    (2678, 2676, '0883', '530921', '凤庆县', '99.928459', '24.580424', 'district', 0),
                                                                                                                    (2679, 2676, '0883', '530922', '云县', '100.129354', '24.44422', 'district', 0),
                                                                                                                    (2680, 2676, '0883', '530923', '永德县', '99.259339', '24.018357', 'district', 0),
                                                                                                                    (2681, 2676, '0883', '530924', '镇康县', '98.825284', '23.762584', 'district', 0),
                                                                                                                    (2682, 2676, '0883', '530925', '双江拉祜族佤族布朗族傣族自治县', '99.827697', '23.473499', 'district', 0),
                                                                                                                    (2683, 2676, '0883', '530926', '耿马傣族佤族自治县', '99.397126', '23.538092', 'district', 0),
                                                                                                                    (2684, 2676, '0883', '530927', '沧源佤族自治县', '99.246196', '23.146712', 'district', 0),
                                                                                                                    (2685, 2605, '0878', '532300', '楚雄彝族自治州', '101.527992', '25.045513', 'city', 0),
                                                                                                                    (2686, 2685, '0878', '532301', '楚雄市', '101.545906', '25.032889', 'district', 0),
                                                                                                                    (2687, 2685, '0878', '532322', '双柏县', '101.641937', '24.688875', 'district', 0),
                                                                                                                    (2688, 2685, '0878', '532323', '牟定县', '101.546566', '25.313121', 'district', 0),
                                                                                                                    (2689, 2685, '0878', '532324', '南华县', '101.273577', '25.192293', 'district', 0),
                                                                                                                    (2690, 2685, '0878', '532325', '姚安县', '101.241728', '25.504173', 'district', 0),
                                                                                                                    (2691, 2685, '0878', '532326', '大姚县', '101.336617', '25.729513', 'district', 0),
                                                                                                                    (2692, 2685, '0878', '532327', '永仁县', '101.666132', '26.049464', 'district', 0),
                                                                                                                    (2693, 2685, '0878', '532328', '元谋县', '101.87452', '25.704338', 'district', 0),
                                                                                                                    (2694, 2685, '0878', '532329', '武定县', '102.404337', '25.530389', 'district', 0),
                                                                                                                    (2695, 2685, '0878', '532331', '禄丰县', '102.079027', '25.150111', 'district', 0),
                                                                                                                    (2696, 2605, '0873', '532500', '红河哈尼族彝族自治州', '103.374893', '23.363245', 'city', 0),
                                                                                                                    (2697, 2696, '0873', '532501', '个旧市', '103.160034', '23.359121', 'district', 0),
                                                                                                                    (2698, 2696, '0873', '532502', '开远市', '103.266624', '23.714523', 'district', 0),
                                                                                                                    (2699, 2696, '0873', '532503', '蒙自市', '103.364905', '23.396201', 'district', 0),
                                                                                                                    (2700, 2696, '0873', '532504', '弥勒市', '103.414874', '24.411912', 'district', 0),
                                                                                                                    (2701, 2696, '0873', '532523', '屏边苗族自治县', '103.687612', '22.983559', 'district', 0),
                                                                                                                    (2702, 2696, '0873', '532524', '建水县', '102.826557', '23.6347', 'district', 0),
                                                                                                                    (2703, 2696, '0873', '532525', '石屏县', '102.494983', '23.705936', 'district', 0),
                                                                                                                    (2704, 2696, '0873', '532527', '泸西县', '103.766196', '24.532025', 'district', 0),
                                                                                                                    (2705, 2696, '0873', '532528', '元阳县', '102.835223', '23.219932', 'district', 0),
                                                                                                                    (2706, 2696, '0873', '532529', '红河县', '102.4206', '23.369161', 'district', 0),
                                                                                                                    (2707, 2696, '0873', '532530', '金平苗族瑶族傣族自治县', '103.226448', '22.779543', 'district', 0),
                                                                                                                    (2708, 2696, '0873', '532531', '绿春县', '102.392463', '22.993717', 'district', 0),
                                                                                                                    (2709, 2696, '0873', '532532', '河口瑶族自治县', '103.93952', '22.529645', 'district', 0),
                                                                                                                    (2710, 2605, '0876', '532600', '文山壮族苗族自治州', '104.216248', '23.400733', 'city', 0),
                                                                                                                    (2711, 2710, '0876', '532601', '文山市', '104.232665', '23.386527', 'district', 0),
                                                                                                                    (2712, 2710, '0876', '532622', '砚山县', '104.337211', '23.605768', 'district', 0),
                                                                                                                    (2713, 2710, '0876', '532623', '西畴县', '104.672597', '23.437782', 'district', 0),
                                                                                                                    (2714, 2710, '0876', '532624', '麻栗坡县', '104.702799', '23.125714', 'district', 0),
                                                                                                                    (2715, 2710, '0876', '532625', '马关县', '104.394157', '23.012915', 'district', 0),
                                                                                                                    (2716, 2710, '0876', '532626', '丘北县', '104.166587', '24.051746', 'district', 0),
                                                                                                                    (2717, 2710, '0876', '532627', '广南县', '105.055107', '24.046386', 'district', 0),
                                                                                                                    (2718, 2710, '0876', '532628', '富宁县', '105.630999', '23.625283', 'district', 0),
                                                                                                                    (2719, 2605, '0691', '532800', '西双版纳傣族自治州', '100.796984', '22.009113', 'city', 0),
                                                                                                                    (2720, 2719, '0691', '532801', '景洪市', '100.799545', '22.011928', 'district', 0),
                                                                                                                    (2721, 2719, '0691', '532822', '勐海县', '100.452547', '21.957353', 'district', 0),
                                                                                                                    (2722, 2719, '0691', '532823', '勐腊县', '101.564635', '21.459233', 'district', 0),
                                                                                                                    (2723, 2605, '0872', '532900', '大理白族自治州', '100.267638', '25.606486', 'city', 0),
                                                                                                                    (2724, 2723, '0872', '532901', '大理市', '100.30127', '25.678068', 'district', 0),
                                                                                                                    (2725, 2723, '0872', '532922', '漾濞彝族自治县', '99.958015', '25.670148', 'district', 0),
                                                                                                                    (2726, 2723, '0872', '532923', '祥云县', '100.550945', '25.48385', 'district', 0),
                                                                                                                    (2727, 2723, '0872', '532924', '宾川县', '100.590473', '25.829828', 'district', 0),
                                                                                                                    (2728, 2723, '0872', '532925', '弥渡县', '100.49099', '25.343804', 'district', 0),
                                                                                                                    (2729, 2723, '0872', '532926', '南涧彝族自治县', '100.509035', '25.04351', 'district', 0),
                                                                                                                    (2730, 2723, '0872', '532927', '巍山彝族回族自治县', '100.307174', '25.227212', 'district', 0),
                                                                                                                    (2731, 2723, '0872', '532928', '永平县', '99.541236', '25.464681', 'district', 0),
                                                                                                                    (2732, 2723, '0872', '532929', '云龙县', '99.37112', '25.885595', 'district', 0),
                                                                                                                    (2733, 2723, '0872', '532930', '洱源县', '99.951053', '26.11116', 'district', 0),
                                                                                                                    (2734, 2723, '0872', '532931', '剑川县', '99.905559', '26.537033', 'district', 0),
                                                                                                                    (2735, 2723, '0872', '532932', '鹤庆县', '100.176498', '26.560231', 'district', 0),
                                                                                                                    (2736, 2605, '0692', '533100', '德宏傣族景颇族自治州', '98.584895', '24.433353', 'city', 0),
                                                                                                                    (2737, 2736, '0692', '533102', '瑞丽市', '97.85559', '24.017958', 'district', 0),
                                                                                                                    (2738, 2736, '0692', '533103', '芒市', '98.588086', '24.43369', 'district', 0),
                                                                                                                    (2739, 2736, '0692', '533122', '梁河县', '98.296657', '24.804232', 'district', 0),
                                                                                                                    (2740, 2736, '0692', '533123', '盈江县', '97.931936', '24.705164', 'district', 0),
                                                                                                                    (2741, 2736, '0692', '533124', '陇川县', '97.792104', '24.182965', 'district', 0),
                                                                                                                    (2742, 2605, '0886', '533300', '怒江傈僳族自治州', '98.8566', '25.817555', 'city', 0),
                                                                                                                    (2743, 2742, '0886', '533301', '泸水市', '98.857977', '25.822879', 'district', 0),
                                                                                                                    (2744, 2742, '0886', '533323', '福贡县', '98.869132', '26.901831', 'district', 0),
                                                                                                                    (2745, 2742, '0886', '533324', '贡山独龙族怒族自治县', '98.665964', '27.740999', 'district', 0),
                                                                                                                    (2746, 2742, '0886', '533325', '兰坪白族普米族自治县', '99.416677', '26.453571', 'district', 0),
                                                                                                                    (2747, 2605, '0887', '533400', '迪庆藏族自治州', '99.702583', '27.818807', 'city', 0),
                                                                                                                    (2748, 2747, '0887', '533401', '香格里拉市', '99.700904', '27.829578', 'district', 0),
                                                                                                                    (2749, 2747, '0887', '533422', '德钦县', '98.911559', '28.486163', 'district', 0),
                                                                                                                    (2750, 2747, '0887', '533423', '维西傈僳族自治县', '99.287173', '27.177161', 'district', 0),
                                                                                                                    (2751, 1, '0', '540000', '西藏自治区', '91.117525', '29.647535', 'province', 0),
                                                                                                                    (2752, 2751, '0891', '540100', '拉萨市', '91.172148', '29.652341', 'city', 0),
                                                                                                                    (2753, 2752, '0891', '540102', '城关区', '91.140552', '29.654838', 'district', 0),
                                                                                                                    (2754, 2752, '0891', '540103', '堆龙德庆区', '91.003339', '29.646063', 'district', 0),
                                                                                                                    (2755, 2752, '0891', '540121', '林周县', '91.265287', '29.893545', 'district', 0),
                                                                                                                    (2756, 2752, '0891', '540122', '当雄县', '91.101162', '30.473118', 'district', 0),
                                                                                                                    (2757, 2752, '0891', '540123', '尼木县', '90.164524', '29.431831', 'district', 0),
                                                                                                                    (2758, 2752, '0891', '540124', '曲水县', '90.743853', '29.353058', 'district', 0),
                                                                                                                    (2759, 2752, '0891', '540126', '达孜县', '91.349867', '29.66941', 'district', 0),
                                                                                                                    (2760, 2752, '0891', '540127', '墨竹工卡县', '91.730732', '29.834111', 'district', 0),
                                                                                                                    (2761, 2751, '0892', '540200', '日喀则市', '88.880583', '29.266869', 'city', 0),
                                                                                                                    (2762, 2761, '0892', '540202', '桑珠孜区', '88.898483', '29.24779', 'district', 0),
                                                                                                                    (2763, 2761, '0892', '540221', '南木林县', '89.099242', '29.68233', 'district', 0),
                                                                                                                    (2764, 2761, '0892', '540222', '江孜县', '89.605627', '28.911626', 'district', 0),
                                                                                                                    (2765, 2761, '0892', '540223', '定日县', '87.12612', '28.658743', 'district', 0),
                                                                                                                    (2766, 2761, '0892', '540224', '萨迦县', '88.021674', '28.899664', 'district', 0),
                                                                                                                    (2767, 2761, '0892', '540225', '拉孜县', '87.63704', '29.081659', 'district', 0),
                                                                                                                    (2768, 2761, '0892', '540226', '昂仁县', '87.236051', '29.294802', 'district', 0),
                                                                                                                    (2769, 2761, '0892', '540227', '谢通门县', '88.261664', '29.432476', 'district', 0),
                                                                                                                    (2770, 2761, '0892', '540228', '白朗县', '89.261977', '29.107688', 'district', 0),
                                                                                                                    (2771, 2761, '0892', '540229', '仁布县', '89.841983', '29.230933', 'district', 0),
                                                                                                                    (2772, 2761, '0892', '540230', '康马县', '89.681663', '28.555627', 'district', 0),
                                                                                                                    (2773, 2761, '0892', '540231', '定结县', '87.765872', '28.364159', 'district', 0),
                                                                                                                    (2774, 2761, '0892', '540232', '仲巴县', '84.03153', '29.770279', 'district', 0),
                                                                                                                    (2775, 2761, '0892', '540233', '亚东县', '88.907093', '27.484806', 'district', 0),
                                                                                                                    (2776, 2761, '0892', '540234', '吉隆县', '85.297534', '28.852393', 'district', 0),
                                                                                                                    (2777, 2761, '0892', '540235', '聂拉木县', '85.982237', '28.155186', 'district', 0),
                                                                                                                    (2778, 2761, '0892', '540236', '萨嘎县', '85.232941', '29.328818', 'district', 0),
                                                                                                                    (2779, 2761, '0892', '540237', '岗巴县', '88.520031', '28.274601', 'district', 0),
                                                                                                                    (2780, 2751, '0895', '540300', '昌都市', '97.17202', '31.140969', 'city', 0),
                                                                                                                    (2781, 2780, '0895', '540302', '卡若区', '97.196021', '31.112087', 'district', 0),
                                                                                                                    (2782, 2780, '0895', '540321', '江达县', '98.21843', '31.499202', 'district', 0),
                                                                                                                    (2783, 2780, '0895', '540322', '贡觉县', '98.27097', '30.860099', 'district', 0),
                                                                                                                    (2784, 2780, '0895', '540323', '类乌齐县', '96.600246', '31.211601', 'district', 0),
                                                                                                                    (2785, 2780, '0895', '540324', '丁青县', '95.619868', '31.409024', 'district', 0),
                                                                                                                    (2786, 2780, '0895', '540325', '察雅县', '97.568752', '30.653943', 'district', 0),
                                                                                                                    (2787, 2780, '0895', '540326', '八宿县', '96.917836', '30.053209', 'district', 0),
                                                                                                                    (2788, 2780, '0895', '540327', '左贡县', '97.841022', '29.671069', 'district', 0),
                                                                                                                    (2789, 2780, '0895', '540328', '芒康县', '98.593113', '29.679907', 'district', 0),
                                                                                                                    (2790, 2780, '0895', '540329', '洛隆县', '95.825197', '30.741845', 'district', 0),
                                                                                                                    (2791, 2780, '0895', '540330', '边坝县', '94.7078', '30.933652', 'district', 0),
                                                                                                                    (2792, 2751, '0894', '540400', '林芝市', '94.36149', '29.649128', 'city', 0),
                                                                                                                    (2793, 2792, '0894', '540402', '巴宜区', '94.361094', '29.636576', 'district', 0),
                                                                                                                    (2794, 2792, '0894', '540421', '工布江达县', '93.246077', '29.88528', 'district', 0),
                                                                                                                    (2795, 2792, '0894', '540422', '米林县', '94.213679', '29.213811', 'district', 0),
                                                                                                                    (2796, 2792, '0894', '540423', '墨脱县', '95.333197', '29.325298', 'district', 0),
                                                                                                                    (2797, 2792, '0894', '540424', '波密县', '95.767913', '29.859028', 'district', 0),
                                                                                                                    (2798, 2792, '0894', '540425', '察隅县', '97.466919', '28.66128', 'district', 0),
                                                                                                                    (2799, 2792, '0894', '540426', '朗县', '93.074702', '29.046337', 'district', 0),
                                                                                                                    (2800, 2751, '0893', '540500', '山南市', '91.773134', '29.237137', 'city', 0),
                                                                                                                    (2801, 2800, '0893', '540502', '乃东区', '91.761538', '29.224904', 'district', 0),
                                                                                                                    (2802, 2800, '0893', '540521', '扎囊县', '91.33725', '29.245113', 'district', 0),
                                                                                                                    (2803, 2800, '0893', '540522', '贡嘎县', '90.98414', '29.289455', 'district', 0),
                                                                                                                    (2804, 2800, '0893', '540523', '桑日县', '92.015818', '29.259189', 'district', 0),
                                                                                                                    (2805, 2800, '0893', '540524', '琼结县', '91.683881', '29.024625', 'district', 0),
                                                                                                                    (2806, 2800, '0893', '540525', '曲松县', '92.203738', '29.062826', 'district', 0),
                                                                                                                    (2807, 2800, '0893', '540526', '措美县', '91.433509', '28.438202', 'district', 0),
                                                                                                                    (2808, 2800, '0893', '540527', '洛扎县', '90.859992', '28.385713', 'district', 0),
                                                                                                                    (2809, 2800, '0893', '540528', '加查县', '92.593993', '29.14029', 'district', 0),
                                                                                                                    (2810, 2800, '0893', '540529', '隆子县', '92.463308', '28.408548', 'district', 0),
                                                                                                                    (2811, 2800, '0893', '540530', '错那县', '91.960132', '27.991707', 'district', 0),
                                                                                                                    (2812, 2800, '0893', '540531', '浪卡子县', '90.397977', '28.968031', 'district', 0),
                                                                                                                    (2813, 2751, '0896', '542400', '那曲地区', '92.052064', '31.476479', 'city', 0),
                                                                                                                    (2814, 2813, '0896', '542421', '那曲县', '92.0535', '31.469643', 'district', 0),
                                                                                                                    (2815, 2813, '0896', '542422', '嘉黎县', '93.232528', '30.640814', 'district', 0),
                                                                                                                    (2816, 2813, '0896', '542423', '比如县', '93.679639', '31.480249', 'district', 0),
                                                                                                                    (2817, 2813, '0896', '542424', '聂荣县', '92.303377', '32.10775', 'district', 0),
                                                                                                                    (2818, 2813, '0896', '542425', '安多县', '91.68233', '32.265176', 'district', 0),
                                                                                                                    (2819, 2813, '0896', '542426', '申扎县', '88.709852', '30.930505', 'district', 0),
                                                                                                                    (2820, 2813, '0896', '542427', '索县', '93.785516', '31.886671', 'district', 0),
                                                                                                                    (2821, 2813, '0896', '542428', '班戈县', '90.009957', '31.392411', 'district', 0),
                                                                                                                    (2822, 2813, '0896', '542429', '巴青县', '94.053438', '31.91847', 'district', 0),
                                                                                                                    (2823, 2813, '0896', '542430', '尼玛县', '87.236772', '31.784701', 'district', 0),
                                                                                                                    (2824, 2813, '0896', '542431', '双湖县', '88.837641', '33.188514', 'district', 0),
                                                                                                                    (2825, 2751, '0897', '542500', '阿里地区', '80.105804', '32.501111', 'city', 0),
                                                                                                                    (2826, 2825, '0897', '542521', '普兰县', '81.176237', '30.294402', 'district', 0),
                                                                                                                    (2827, 2825, '0897', '542522', '札达县', '79.802706', '31.479216', 'district', 0),
                                                                                                                    (2828, 2825, '0897', '542523', '噶尔县', '80.096419', '32.491488', 'district', 0),
                                                                                                                    (2829, 2825, '0897', '542524', '日土县', '79.732427', '33.381359', 'district', 0),
                                                                                                                    (2830, 2825, '0897', '542525', '革吉县', '81.145433', '32.387233', 'district', 0),
                                                                                                                    (2831, 2825, '0897', '542526', '改则县', '84.06259', '32.302713', 'district', 0),
                                                                                                                    (2832, 2825, '0897', '542527', '措勤县', '85.151455', '31.017312', 'district', 0),
                                                                                                                    (2833, 1, '0', '610000', '陕西省', '108.954347', '34.265502', 'province', 0),
                                                                                                                    (2834, 2833, '029', '610100', '西安市', '108.93977', '34.341574', 'city', 0),
                                                                                                                    (2835, 2834, '029', '610102', '新城区', '108.960716', '34.266447', 'district', 0),
                                                                                                                    (2836, 2834, '029', '610103', '碑林区', '108.94059', '34.256783', 'district', 0),
                                                                                                                    (2837, 2834, '029', '610104', '莲湖区', '108.943895', '34.265239', 'district', 0),
                                                                                                                    (2838, 2834, '029', '610111', '灞桥区', '109.064646', '34.272793', 'district', 0),
                                                                                                                    (2839, 2834, '029', '610112', '未央区', '108.946825', '34.29292', 'district', 0),
                                                                                                                    (2840, 2834, '029', '610113', '雁塔区', '108.944644', '34.214113', 'district', 0),
                                                                                                                    (2841, 2834, '029', '610114', '阎良区', '109.226124', '34.662232', 'district', 0),
                                                                                                                    (2842, 2834, '029', '610115', '临潼区', '109.214237', '34.367069', 'district', 0),
                                                                                                                    (2843, 2834, '029', '610116', '长安区', '108.907173', '34.158926', 'district', 0),
                                                                                                                    (2844, 2834, '029', '610117', '高陵区', '109.088297', '34.534829', 'district', 0),
                                                                                                                    (2845, 2834, '029', '610122', '蓝田县', '109.32345', '34.151298', 'district', 0),
                                                                                                                    (2846, 2834, '029', '610124', '周至县', '108.222162', '34.163669', 'district', 0),
                                                                                                                    (2847, 2834, '029', '610125', '鄠邑区', '108.604894', '34.109244', 'district', 0),
                                                                                                                    (2848, 2833, '0919', '610200', '铜川市', '108.945019', '34.897887', 'city', 0),
                                                                                                                    (2849, 2848, '0919', '610202', '王益区', '109.075578', '35.068964', 'district', 0),
                                                                                                                    (2850, 2848, '0919', '610203', '印台区', '109.099974', '35.114492', 'district', 0),
                                                                                                                    (2851, 2848, '0919', '610204', '耀州区', '108.980102', '34.909793', 'district', 0),
                                                                                                                    (2852, 2848, '0919', '610222', '宜君县', '109.116932', '35.398577', 'district', 0),
                                                                                                                    (2853, 2833, '0917', '610300', '宝鸡市', '107.237743', '34.363184', 'city', 0),
                                                                                                                    (2854, 2853, '0917', '610302', '渭滨区', '107.155344', '34.355068', 'district', 0),
                                                                                                                    (2855, 2853, '0917', '610303', '金台区', '107.146806', '34.376069', 'district', 0),
                                                                                                                    (2856, 2853, '0917', '610304', '陈仓区', '107.369987', '34.35147', 'district', 0),
                                                                                                                    (2857, 2853, '0917', '610322', '凤翔县', '107.400737', '34.521217', 'district', 0),
                                                                                                                    (2858, 2853, '0917', '610323', '岐山县', '107.621053', '34.443459', 'district', 0),
                                                                                                                    (2859, 2853, '0917', '610324', '扶风县', '107.900219', '34.37541', 'district', 0),
                                                                                                                    (2860, 2853, '0917', '610326', '眉县', '107.749766', '34.274246', 'district', 0),
                                                                                                                    (2861, 2853, '0917', '610327', '陇县', '106.864397', '34.89305', 'district', 0),
                                                                                                                    (2862, 2853, '0917', '610328', '千阳县', '107.132441', '34.642381', 'district', 0),
                                                                                                                    (2863, 2853, '0917', '610329', '麟游县', '107.793524', '34.677902', 'district', 0),
                                                                                                                    (2864, 2853, '0917', '610330', '凤县', '106.515803', '33.91091', 'district', 0),
                                                                                                                    (2865, 2853, '0917', '610331', '太白县', '107.319116', '34.058401', 'district', 0),
                                                                                                                    (2866, 2833, '0910', '610400', '咸阳市', '108.709136', '34.32987', 'city', 0),
                                                                                                                    (2867, 2866, '0910', '610402', '秦都区', '108.706272', '34.329567', 'district', 0),
                                                                                                                    (2868, 2866, '0910', '610403', '杨陵区', '108.084731', '34.272117', 'district', 0),
                                                                                                                    (2869, 2866, '0910', '610404', '渭城区', '108.737204', '34.36195', 'district', 0),
                                                                                                                    (2870, 2866, '0910', '610422', '三原县', '108.940509', '34.617381', 'district', 0),
                                                                                                                    (2871, 2866, '0910', '610423', '泾阳县', '108.842622', '34.527114', 'district', 0),
                                                                                                                    (2872, 2866, '0910', '610424', '乾县', '108.239473', '34.527551', 'district', 0),
                                                                                                                    (2873, 2866, '0910', '610425', '礼泉县', '108.425018', '34.481764', 'district', 0),
                                                                                                                    (2874, 2866, '0910', '610426', '永寿县', '108.142311', '34.691979', 'district', 0),
                                                                                                                    (2875, 2866, '0910', '610427', '彬县', '108.077658', '35.043911', 'district', 0),
                                                                                                                    (2876, 2866, '0910', '610428', '长武县', '107.798757', '35.205886', 'district', 0),
                                                                                                                    (2877, 2866, '0910', '610429', '旬邑县', '108.333986', '35.111978', 'district', 0),
                                                                                                                    (2878, 2866, '0910', '610430', '淳化县', '108.580681', '34.79925', 'district', 0),
                                                                                                                    (2879, 2866, '0910', '610431', '武功县', '108.200398', '34.260203', 'district', 0),
                                                                                                                    (2880, 2866, '0910', '610481', '兴平市', '108.490475', '34.29922', 'district', 0),
                                                                                                                    (2881, 2833, '0913', '610500', '渭南市', '109.471094', '34.52044', 'city', 0),
                                                                                                                    (2882, 2881, '0913', '610502', '临渭区', '109.510175', '34.499314', 'district', 0),
                                                                                                                    (2883, 2881, '0913', '610503', '华州区', '109.775247', '34.495915', 'district', 0),
                                                                                                                    (2884, 2881, '0913', '610522', '潼关县', '110.246349', '34.544296', 'district', 0),
                                                                                                                    (2885, 2881, '0913', '610523', '大荔县', '109.941734', '34.797259', 'district', 0),
                                                                                                                    (2886, 2881, '0913', '610524', '合阳县', '110.149453', '35.237988', 'district', 0),
                                                                                                                    (2887, 2881, '0913', '610525', '澄城县', '109.93235', '35.190245', 'district', 0),
                                                                                                                    (2888, 2881, '0913', '610526', '蒲城县', '109.586403', '34.955562', 'district', 0),
                                                                                                                    (2889, 2881, '0913', '610527', '白水县', '109.590671', '35.177451', 'district', 0),
                                                                                                                    (2890, 2881, '0913', '610528', '富平县', '109.18032', '34.751077', 'district', 0),
                                                                                                                    (2891, 2881, '0913', '610581', '韩城市', '110.442846', '35.476788', 'district', 0),
                                                                                                                    (2892, 2881, '0913', '610582', '华阴市', '110.092078', '34.566079', 'district', 0),
                                                                                                                    (2893, 2833, '0911', '610600', '延安市', '109.494112', '36.651381', 'city', 0),
                                                                                                                    (2894, 2893, '0911', '610602', '宝塔区', '109.48976', '36.585472', 'district', 0),
                                                                                                                    (2895, 2893, '0911', '610621', '延长县', '110.012334', '36.579313', 'district', 0),
                                                                                                                    (2896, 2893, '0911', '610622', '延川县', '110.193514', '36.878117', 'district', 0),
                                                                                                                    (2897, 2893, '0911', '610623', '子长县', '109.675264', '37.142535', 'district', 0),
                                                                                                                    (2898, 2893, '0911', '610624', '安塞区', '109.328842', '36.863853', 'district', 0),
                                                                                                                    (2899, 2893, '0911', '610625', '志丹县', '108.768432', '36.822194', 'district', 0),
                                                                                                                    (2900, 2893, '0911', '610626', '吴起县', '108.175933', '36.927215', 'district', 0),
                                                                                                                    (2901, 2893, '0911', '610627', '甘泉县', '109.351019', '36.276526', 'district', 0),
                                                                                                                    (2902, 2893, '0911', '610628', '富县', '109.379776', '35.987953', 'district', 0),
                                                                                                                    (2903, 2893, '0911', '610629', '洛川县', '109.432369', '35.761974', 'district', 0),
                                                                                                                    (2904, 2893, '0911', '610630', '宜川县', '110.168963', '36.050178', 'district', 0),
                                                                                                                    (2905, 2893, '0911', '610631', '黄龙县', '109.840314', '35.584743', 'district', 0),
                                                                                                                    (2906, 2893, '0911', '610632', '黄陵县', '109.262961', '35.579427', 'district', 0),
                                                                                                                    (2907, 2833, '0916', '610700', '汉中市', '107.02305', '33.067225', 'city', 0),
                                                                                                                    (2908, 2907, '0916', '610702', '汉台区', '107.031856', '33.067771', 'district', 0),
                                                                                                                    (2909, 2907, '0916', '610721', '南郑县', '106.93623', '32.999333', 'district', 0),
                                                                                                                    (2910, 2907, '0916', '610722', '城固县', '107.33393', '33.157131', 'district', 0),
                                                                                                                    (2911, 2907, '0916', '610723', '洋县', '107.545836', '33.222738', 'district', 0),
                                                                                                                    (2912, 2907, '0916', '610724', '西乡县', '107.766613', '32.983101', 'district', 0),
                                                                                                                    (2913, 2907, '0916', '610725', '勉县', '106.673221', '33.153553', 'district', 0),
                                                                                                                    (2914, 2907, '0916', '610726', '宁强县', '106.257171', '32.829694', 'district', 0),
                                                                                                                    (2915, 2907, '0916', '610727', '略阳县', '106.156718', '33.327281', 'district', 0),
                                                                                                                    (2916, 2907, '0916', '610728', '镇巴县', '107.895035', '32.536704', 'district', 0),
                                                                                                                    (2917, 2907, '0916', '610729', '留坝县', '106.920808', '33.617571', 'district', 0),
                                                                                                                    (2918, 2907, '0916', '610730', '佛坪县', '107.990538', '33.524359', 'district', 0),
                                                                                                                    (2919, 2833, '0912', '610800', '榆林市', '109.734474', '38.285369', 'city', 0),
                                                                                                                    (2920, 2919, '0912', '610802', '榆阳区', '109.721069', '38.277046', 'district', 0),
                                                                                                                    (2921, 2919, '0912', '610803', '横山区', '109.294346', '37.962208', 'district', 0),
                                                                                                                    (2922, 2919, '0912', '610821', '神木县', '110.498939', '38.842578', 'district', 0),
                                                                                                                    (2923, 2919, '0912', '610822', '府谷县', '111.067276', '39.028116', 'district', 0),
                                                                                                                    (2924, 2919, '0912', '610824', '靖边县', '108.793988', '37.599438', 'district', 0),
                                                                                                                    (2925, 2919, '0912', '610825', '定边县', '107.601267', '37.594612', 'district', 0),
                                                                                                                    (2926, 2919, '0912', '610826', '绥德县', '110.263362', '37.50294', 'district', 0),
                                                                                                                    (2927, 2919, '0912', '610827', '米脂县', '110.183754', '37.755416', 'district', 0),
                                                                                                                    (2928, 2919, '0912', '610828', '佳县', '110.491345', '38.01951', 'district', 0),
                                                                                                                    (2929, 2919, '0912', '610829', '吴堡县', '110.739673', '37.452067', 'district', 0),
                                                                                                                    (2930, 2919, '0912', '610830', '清涧县', '110.121209', '37.088878', 'district', 0),
                                                                                                                    (2931, 2919, '0912', '610831', '子洲县', '110.03525', '37.610683', 'district', 0),
                                                                                                                    (2932, 2833, '0915', '610900', '安康市', '109.029113', '32.68481', 'city', 0),
                                                                                                                    (2933, 2932, '0915', '610902', '汉滨区', '109.026836', '32.695172', 'district', 0),
                                                                                                                    (2934, 2932, '0915', '610921', '汉阴县', '108.508745', '32.893026', 'district', 0),
                                                                                                                    (2935, 2932, '0915', '610922', '石泉县', '108.247886', '33.038408', 'district', 0),
                                                                                                                    (2936, 2932, '0915', '610923', '宁陕县', '108.314283', '33.310527', 'district', 0),
                                                                                                                    (2937, 2932, '0915', '610924', '紫阳县', '108.534228', '32.520246', 'district', 0),
                                                                                                                    (2938, 2932, '0915', '610925', '岚皋县', '108.902049', '32.307001', 'district', 0),
                                                                                                                    (2939, 2932, '0915', '610926', '平利县', '109.361864', '32.388854', 'district', 0),
                                                                                                                    (2940, 2932, '0915', '610927', '镇坪县', '109.526873', '31.883672', 'district', 0),
                                                                                                                    (2941, 2932, '0915', '610928', '旬阳县', '109.361024', '32.832012', 'district', 0),
                                                                                                                    (2942, 2932, '0915', '610929', '白河县', '110.112629', '32.809026', 'district', 0),
                                                                                                                    (2943, 2833, '0914', '611000', '商洛市', '109.91857', '33.872726', 'city', 0),
                                                                                                                    (2944, 2943, '0914', '611002', '商州区', '109.941839', '33.862599', 'district', 0),
                                                                                                                    (2945, 2943, '0914', '611021', '洛南县', '110.148508', '34.090837', 'district', 0),
                                                                                                                    (2946, 2943, '0914', '611022', '丹凤县', '110.32733', '33.695783', 'district', 0),
                                                                                                                    (2947, 2943, '0914', '611023', '商南县', '110.881807', '33.530995', 'district', 0),
                                                                                                                    (2948, 2943, '0914', '611024', '山阳县', '109.882289', '33.532172', 'district', 0),
                                                                                                                    (2949, 2943, '0914', '611025', '镇安县', '109.152892', '33.423357', 'district', 0),
                                                                                                                    (2950, 2943, '0914', '611026', '柞水县', '109.114206', '33.68611', 'district', 0),
                                                                                                                    (2951, 1, '0', '620000', '甘肃省', '103.826447', '36.05956', 'province', 0),
                                                                                                                    (2952, 2951, '0931', '620100', '兰州市', '103.834303', '36.061089', 'city', 0),
                                                                                                                    (2953, 2952, '0931', '620102', '城关区', '103.825307', '36.057464', 'district', 0),
                                                                                                                    (2954, 2952, '0931', '620103', '七里河区', '103.785949', '36.066146', 'district', 0),
                                                                                                                    (2955, 2952, '0931', '620104', '西固区', '103.627951', '36.088552', 'district', 0),
                                                                                                                    (2956, 2952, '0931', '620105', '安宁区', '103.719054', '36.104579', 'district', 0),
                                                                                                                    (2957, 2952, '0931', '620111', '红古区', '102.859323', '36.345669', 'district', 0),
                                                                                                                    (2958, 2952, '0931', '620121', '永登县', '103.26038', '36.736513', 'district', 0),
                                                                                                                    (2959, 2952, '0931', '620122', '皋兰县', '103.947377', '36.332663', 'district', 0),
                                                                                                                    (2960, 2952, '0931', '620123', '榆中县', '104.112527', '35.843056', 'district', 0),
                                                                                                                    (2961, 2951, '1937', '620200', '嘉峪关市', '98.289419', '39.772554', 'city', 0),
                                                                                                                    (2962, 2961, '1937', '620200', '嘉峪关市', '98.289419', '39.772554', 'district', 0),
                                                                                                                    (2963, 2951, '0935', '620300', '金昌市', '102.188117', '38.520717', 'city', 0),
                                                                                                                    (2964, 2963, '0935', '620302', '金川区', '102.194015', '38.521087', 'district', 0),
                                                                                                                    (2965, 2963, '0935', '620321', '永昌县', '101.984458', '38.243434', 'district', 0),
                                                                                                                    (2966, 2951, '0943', '620400', '白银市', '104.138771', '36.545261', 'city', 0),
                                                                                                                    (2967, 2966, '0943', '620402', '白银区', '104.148556', '36.535398', 'district', 0),
                                                                                                                    (2968, 2966, '0943', '620403', '平川区', '104.825208', '36.728304', 'district', 0),
                                                                                                                    (2969, 2966, '0943', '620421', '靖远县', '104.676774', '36.571365', 'district', 0),
                                                                                                                    (2970, 2966, '0943', '620422', '会宁县', '105.053358', '35.692823', 'district', 0),
                                                                                                                    (2971, 2966, '0943', '620423', '景泰县', '104.063091', '37.183804', 'district', 0),
                                                                                                                    (2972, 2951, '0938', '620500', '天水市', '105.724979', '34.580885', 'city', 0),
                                                                                                                    (2973, 2972, '0938', '620502', '秦州区', '105.724215', '34.580888', 'district', 0),
                                                                                                                    (2974, 2972, '0938', '620503', '麦积区', '105.889556', '34.570384', 'district', 0),
                                                                                                                    (2975, 2972, '0938', '620521', '清水县', '106.137293', '34.749864', 'district', 0),
                                                                                                                    (2976, 2972, '0938', '620522', '秦安县', '105.674982', '34.858916', 'district', 0),
                                                                                                                    (2977, 2972, '0938', '620523', '甘谷县', '105.340747', '34.745486', 'district', 0),
                                                                                                                    (2978, 2972, '0938', '620524', '武山县', '104.890587', '34.72139', 'district', 0),
                                                                                                                    (2979, 2972, '0938', '620525', '张家川回族自治县', '106.204517', '34.988037', 'district', 0),
                                                                                                                    (2980, 2951, '1935', '620600', '武威市', '102.638201', '37.928267', 'city', 0),
                                                                                                                    (2981, 2980, '1935', '620602', '凉州区', '102.642184', '37.928224', 'district', 0),
                                                                                                                    (2982, 2980, '1935', '620621', '民勤县', '103.093791', '38.62435', 'district', 0),
                                                                                                                    (2983, 2980, '1935', '620622', '古浪县', '102.897533', '37.47012', 'district', 0),
                                                                                                                    (2984, 2980, '1935', '620623', '天祝藏族自治县', '103.141757', '36.97174', 'district', 0),
                                                                                                                    (2985, 2951, '0936', '620700', '张掖市', '100.449913', '38.925548', 'city', 0),
                                                                                                                    (2986, 2985, '0936', '620702', '甘州区', '100.415096', '38.944662', 'district', 0),
                                                                                                                    (2987, 2985, '0936', '620721', '肃南裕固族自治县', '99.615601', '38.836931', 'district', 0),
                                                                                                                    (2988, 2985, '0936', '620722', '民乐县', '100.812629', '38.430347', 'district', 0),
                                                                                                                    (2989, 2985, '0936', '620723', '临泽县', '100.164283', '39.152462', 'district', 0),
                                                                                                                    (2990, 2985, '0936', '620724', '高台县', '99.819519', '39.378311', 'district', 0),
                                                                                                                    (2991, 2985, '0936', '620725', '山丹县', '101.088529', '38.784505', 'district', 0),
                                                                                                                    (2992, 2951, '0933', '620800', '平凉市', '106.665061', '35.542606', 'city', 0),
                                                                                                                    (2993, 2992, '0933', '620802', '崆峒区', '106.674767', '35.542491', 'district', 0),
                                                                                                                    (2994, 2992, '0933', '620821', '泾川县', '107.36785', '35.332666', 'district', 0),
                                                                                                                    (2995, 2992, '0933', '620822', '灵台县', '107.595874', '35.070027', 'district', 0),
                                                                                                                    (2996, 2992, '0933', '620823', '崇信县', '107.025763', '35.305596', 'district', 0),
                                                                                                                    (2997, 2992, '0933', '620824', '华亭县', '106.653158', '35.218292', 'district', 0),
                                                                                                                    (2998, 2992, '0933', '620825', '庄浪县', '106.036686', '35.202385', 'district', 0),
                                                                                                                    (2999, 2992, '0933', '620826', '静宁县', '105.732556', '35.521976', 'district', 0),
                                                                                                                    (3000, 2951, '0937', '620900', '酒泉市', '98.493927', '39.732795', 'city', 0),
                                                                                                                    (3001, 3000, '0937', '620902', '肃州区', '98.507843', '39.744953', 'district', 0),
                                                                                                                    (3002, 3000, '0937', '620921', '金塔县', '98.901252', '39.983955', 'district', 0),
                                                                                                                    (3003, 3000, '0937', '620922', '瓜州县', '95.782318', '40.520538', 'district', 0),
                                                                                                                    (3004, 3000, '0937', '620923', '肃北蒙古族自治县', '94.876579', '39.51245', 'district', 0),
                                                                                                                    (3005, 3000, '0937', '620924', '阿克塞哈萨克族自治县', '94.340204', '39.633943', 'district', 0),
                                                                                                                    (3006, 3000, '0937', '620981', '玉门市', '97.045661', '40.292106', 'district', 0),
                                                                                                                    (3007, 3000, '0937', '620982', '敦煌市', '94.661941', '40.142089', 'district', 0),
                                                                                                                    (3008, 2951, '0934', '621000', '庆阳市', '107.643571', '35.70898', 'city', 0),
                                                                                                                    (3009, 3008, '0934', '621002', '西峰区', '107.651077', '35.730652', 'district', 0),
                                                                                                                    (3010, 3008, '0934', '621021', '庆城县', '107.881802', '36.016299', 'district', 0),
                                                                                                                    (3011, 3008, '0934', '621022', '环县', '107.308501', '36.568434', 'district', 0),
                                                                                                                    (3012, 3008, '0934', '621023', '华池县', '107.990062', '36.461306', 'district', 0),
                                                                                                                    (3013, 3008, '0934', '621024', '合水县', '108.019554', '35.819194', 'district', 0),
                                                                                                                    (3014, 3008, '0934', '621025', '正宁县', '108.359865', '35.49178', 'district', 0),
                                                                                                                    (3015, 3008, '0934', '621026', '宁县', '107.928371', '35.502176', 'district', 0),
                                                                                                                    (3016, 3008, '0934', '621027', '镇原县', '107.200832', '35.677462', 'district', 0),
                                                                                                                    (3017, 2951, '0932', '621100', '定西市', '104.592225', '35.606978', 'city', 0),
                                                                                                                    (3018, 3017, '0932', '621102', '安定区', '104.610668', '35.580629', 'district', 0),
                                                                                                                    (3019, 3017, '0932', '621121', '通渭县', '105.24206', '35.210831', 'district', 0),
                                                                                                                    (3020, 3017, '0932', '621122', '陇西县', '104.634983', '35.00394', 'district', 0),
                                                                                                                    (3021, 3017, '0932', '621123', '渭源县', '104.215467', '35.136755', 'district', 0),
                                                                                                                    (3022, 3017, '0932', '621124', '临洮县', '103.859565', '35.394988', 'district', 0),
                                                                                                                    (3023, 3017, '0932', '621125', '漳县', '104.471572', '34.848444', 'district', 0),
                                                                                                                    (3024, 3017, '0932', '621126', '岷县', '104.03688', '34.438075', 'district', 0),
                                                                                                                    (3025, 2951, '2935', '621200', '陇南市', '104.960851', '33.37068', 'city', 0),
                                                                                                                    (3026, 3025, '2935', '621202', '武都区', '104.926337', '33.392211', 'district', 0),
                                                                                                                    (3027, 3025, '2935', '621221', '成县', '105.742424', '33.75061', 'district', 0),
                                                                                                                    (3028, 3025, '2935', '621222', '文县', '104.683433', '32.943815', 'district', 0),
                                                                                                                    (3029, 3025, '2935', '621223', '宕昌县', '104.393385', '34.047261', 'district', 0),
                                                                                                                    (3030, 3025, '2935', '621224', '康县', '105.609169', '33.329136', 'district', 0),
                                                                                                                    (3031, 3025, '2935', '621225', '西和县', '105.298756', '34.014215', 'district', 0),
                                                                                                                    (3032, 3025, '2935', '621226', '礼县', '105.17864', '34.189345', 'district', 0),
                                                                                                                    (3033, 3025, '2935', '621227', '徽县', '106.08778', '33.768826', 'district', 0),
                                                                                                                    (3034, 3025, '2935', '621228', '两当县', '106.304966', '33.908917', 'district', 0),
                                                                                                                    (3035, 2951, '0930', '622900', '临夏回族自治州', '103.210655', '35.601352', 'city', 0),
                                                                                                                    (3036, 3035, '0930', '622901', '临夏市', '103.243021', '35.604376', 'district', 0),
                                                                                                                    (3037, 3035, '0930', '622921', '临夏县', '103.039826', '35.478722', 'district', 0),
                                                                                                                    (3038, 3035, '0930', '622922', '康乐县', '103.708354', '35.370505', 'district', 0),
                                                                                                                    (3039, 3035, '0930', '622923', '永靖县', '103.285853', '35.958306', 'district', 0),
                                                                                                                    (3040, 3035, '0930', '622924', '广河县', '103.575834', '35.488051', 'district', 0),
                                                                                                                    (3041, 3035, '0930', '622925', '和政县', '103.350997', '35.424603', 'district', 0),
                                                                                                                    (3042, 3035, '0930', '622926', '东乡族自治县', '103.389346', '35.663752', 'district', 0),
                                                                                                                    (3043, 3035, '0930', '622927', '积石山保安族东乡族撒拉族自治县', '102.875843', '35.71766', 'district', 0),
                                                                                                                    (3044, 2951, '0941', '623000', '甘南藏族自治州', '102.910995', '34.983409', 'city', 0),
                                                                                                                    (3045, 3044, '0941', '623001', '合作市', '102.910484', '35.000286', 'district', 0),
                                                                                                                    (3046, 3044, '0941', '623021', '临潭县', '103.353919', '34.692747', 'district', 0),
                                                                                                                    (3047, 3044, '0941', '623022', '卓尼县', '103.507109', '34.589588', 'district', 0),
                                                                                                                    (3048, 3044, '0941', '623023', '舟曲县', '104.251482', '33.793631', 'district', 0),
                                                                                                                    (3049, 3044, '0941', '623024', '迭部县', '103.221869', '34.055938', 'district', 0),
                                                                                                                    (3050, 3044, '0941', '623025', '玛曲县', '102.072698', '33.997712', 'district', 0),
                                                                                                                    (3051, 3044, '0941', '623026', '碌曲县', '102.487327', '34.590944', 'district', 0),
                                                                                                                    (3052, 3044, '0941', '623027', '夏河县', '102.521807', '35.202503', 'district', 0),
                                                                                                                    (3053, 1, '0', '630000', '青海省', '101.780268', '36.620939', 'province', 0),
                                                                                                                    (3054, 3053, '0971', '630100', '西宁市', '101.778223', '36.617134', 'city', 0),
                                                                                                                    (3055, 3054, '0971', '630102', '城东区', '101.803717', '36.599744', 'district', 0),
                                                                                                                    (3056, 3054, '0971', '630103', '城中区', '101.705298', '36.545652', 'district', 0),
                                                                                                                    (3057, 3054, '0971', '630104', '城西区', '101.765843', '36.628304', 'district', 0),
                                                                                                                    (3058, 3054, '0971', '630105', '城北区', '101.766228', '36.650038', 'district', 0),
                                                                                                                    (3059, 3054, '0971', '630121', '大通回族土族自治县', '101.685643', '36.926954', 'district', 0),
                                                                                                                    (3060, 3054, '0971', '630122', '湟中县', '101.571667', '36.500879', 'district', 0),
                                                                                                                    (3061, 3054, '0971', '630123', '湟源县', '101.256464', '36.682426', 'district', 0),
                                                                                                                    (3062, 3053, '0972', '630200', '海东市', '102.104287', '36.502039', 'city', 0),
                                                                                                                    (3063, 3062, '0972', '630202', '乐都区', '102.401724', '36.482058', 'district', 0),
                                                                                                                    (3064, 3062, '0972', '630203', '平安区', '102.108834', '36.500563', 'district', 0),
                                                                                                                    (3065, 3062, '0972', '630222', '民和回族土族自治县', '102.830892', '36.320321', 'district', 0),
                                                                                                                    (3066, 3062, '0972', '630223', '互助土族自治县', '101.959271', '36.844248', 'district', 0),
                                                                                                                    (3067, 3062, '0972', '630224', '化隆回族自治县', '102.264143', '36.094908', 'district', 0),
                                                                                                                    (3068, 3062, '0972', '630225', '循化撒拉族自治县', '102.489135', '35.851152', 'district', 0),
                                                                                                                    (3069, 3053, '0970', '632200', '海北藏族自治州', '100.900997', '36.954413', 'city', 0),
                                                                                                                    (3070, 3069, '0970', '632221', '门源回族自治县', '101.611539', '37.388746', 'district', 0),
                                                                                                                    (3071, 3069, '0970', '632222', '祁连县', '100.253211', '38.177112', 'district', 0),
                                                                                                                    (3072, 3069, '0970', '632223', '海晏县', '100.99426', '36.896359', 'district', 0),
                                                                                                                    (3073, 3069, '0970', '632224', '刚察县', '100.145833', '37.32547', 'district', 0),
                                                                                                                    (3074, 3053, '0973', '632300', '黄南藏族自治州', '102.015248', '35.519548', 'city', 0),
                                                                                                                    (3075, 3074, '0973', '632321', '同仁县', '102.018323', '35.516063', 'district', 0),
                                                                                                                    (3076, 3074, '0973', '632322', '尖扎县', '102.04014', '35.943156', 'district', 0),
                                                                                                                    (3077, 3074, '0973', '632323', '泽库县', '101.466689', '35.035313', 'district', 0),
                                                                                                                    (3078, 3074, '0973', '632324', '河南蒙古族自治县', '101.617503', '34.734568', 'district', 0),
                                                                                                                    (3079, 3053, '0974', '632500', '海南藏族自治州', '100.622692', '36.296529', 'city', 0),
                                                                                                                    (3080, 3079, '0974', '632521', '共和县', '100.620031', '36.284107', 'district', 0),
                                                                                                                    (3081, 3079, '0974', '632522', '同德县', '100.578051', '35.25479', 'district', 0),
                                                                                                                    (3082, 3079, '0974', '632523', '贵德县', '101.433391', '36.040166', 'district', 0),
                                                                                                                    (3083, 3079, '0974', '632524', '兴海县', '99.987965', '35.588612', 'district', 0),
                                                                                                                    (3084, 3079, '0974', '632525', '贵南县', '100.747503', '35.586714', 'district', 0),
                                                                                                                    (3085, 3053, '0975', '632600', '果洛藏族自治州', '100.244808', '34.471431', 'city', 0),
                                                                                                                    (3086, 3085, '0975', '632621', '玛沁县', '100.238888', '34.477433', 'district', 0),
                                                                                                                    (3087, 3085, '0975', '632622', '班玛县', '100.737138', '32.932723', 'district', 0),
                                                                                                                    (3088, 3085, '0975', '632623', '甘德县', '99.900923', '33.969216', 'district', 0),
                                                                                                                    (3089, 3085, '0975', '632624', '达日县', '99.651392', '33.74892', 'district', 0),
                                                                                                                    (3090, 3085, '0975', '632625', '久治县', '101.482831', '33.429471', 'district', 0),
                                                                                                                    (3091, 3085, '0975', '632626', '玛多县', '98.209206', '34.915946', 'district', 0),
                                                                                                                    (3092, 3053, '0976', '632700', '玉树藏族自治州', '97.091934', '33.011674', 'city', 0),
                                                                                                                    (3093, 3092, '0976', '632701', '玉树市', '97.008784', '32.993106', 'district', 0),
                                                                                                                    (3094, 3092, '0976', '632722', '杂多县', '95.300723', '32.893185', 'district', 0),
                                                                                                                    (3095, 3092, '0976', '632723', '称多县', '97.110831', '33.369218', 'district', 0),
                                                                                                                    (3096, 3092, '0976', '632724', '治多县', '95.61896', '33.844956', 'district', 0),
                                                                                                                    (3097, 3092, '0976', '632725', '囊谦县', '96.48943', '32.203432', 'district', 0),
                                                                                                                    (3098, 3092, '0976', '632726', '曲麻莱县', '95.797367', '34.126428', 'district', 0),
                                                                                                                    (3099, 3053, '0977', '632800', '海西蒙古族藏族自治州', '97.369751', '37.377139', 'city', 0),
                                                                                                                    (3100, 3099, '0977', '632801', '格尔木市', '94.928453', '36.406367', 'district', 0),
                                                                                                                    (3101, 3099, '0977', '632802', '德令哈市', '97.360984', '37.369436', 'district', 0),
                                                                                                                    (3102, 3099, '0977', '632821', '乌兰县', '98.480195', '36.929749', 'district', 0),
                                                                                                                    (3103, 3099, '0977', '632822', '都兰县', '98.095844', '36.302496', 'district', 0),
                                                                                                                    (3104, 3099, '0977', '632823', '天峻县', '99.022984', '37.300851', 'district', 0),
                                                                                                                    (3105, 3099, '0977', '632825', '海西蒙古族藏族自治州直辖', '95.356546', '37.853328', 'district', 0),
                                                                                                                    (3106, 1, '0', '640000', '宁夏回族自治区', '106.259126', '38.472641', 'province', 0),
                                                                                                                    (3107, 3106, '0951', '640100', '银川市', '106.230909', '38.487193', 'city', 0),
                                                                                                                    (3108, 3107, '0951', '640104', '兴庆区', '106.28865', '38.473609', 'district', 0),
                                                                                                                    (3109, 3107, '0951', '640105', '西夏区', '106.161106', '38.502605', 'district', 0),
                                                                                                                    (3110, 3107, '0951', '640106', '金凤区', '106.239679', '38.47436', 'district', 0),
                                                                                                                    (3111, 3107, '0951', '640121', '永宁县', '106.253145', '38.277372', 'district', 0),
                                                                                                                    (3112, 3107, '0951', '640122', '贺兰县', '106.349861', '38.554599', 'district', 0),
                                                                                                                    (3113, 3107, '0951', '640181', '灵武市', '106.340053', '38.102655', 'district', 0),
                                                                                                                    (3114, 3106, '0952', '640200', '石嘴山市', '106.383303', '38.983236', 'city', 0),
                                                                                                                    (3115, 3114, '0952', '640202', '大武口区', '106.367958', '39.01918', 'district', 0),
                                                                                                                    (3116, 3114, '0952', '640205', '惠农区', '106.781176', '39.239302', 'district', 0),
                                                                                                                    (3117, 3114, '0952', '640221', '平罗县', '106.523474', '38.913544', 'district', 0),
                                                                                                                    (3118, 3106, '0953', '640300', '吴忠市', '106.198913', '37.997428', 'city', 0),
                                                                                                                    (3119, 3118, '0953', '640302', '利通区', '106.212613', '37.98349', 'district', 0),
                                                                                                                    (3120, 3118, '0953', '640303', '红寺堡区', '106.062113', '37.425702', 'district', 0),
                                                                                                                    (3121, 3118, '0953', '640323', '盐池县', '107.407358', '37.783205', 'district', 0),
                                                                                                                    (3122, 3118, '0953', '640324', '同心县', '105.895309', '36.95449', 'district', 0),
                                                                                                                    (3123, 3118, '0953', '640381', '青铜峡市', '106.078817', '38.021302', 'district', 0),
                                                                                                                    (3124, 3106, '0954', '640400', '固原市', '106.24261', '36.015855', 'city', 0),
                                                                                                                    (3125, 3124, '0954', '640402', '原州区', '106.287781', '36.003739', 'district', 0),
                                                                                                                    (3126, 3124, '0954', '640422', '西吉县', '105.729085', '35.963912', 'district', 0),
                                                                                                                    (3127, 3124, '0954', '640423', '隆德县', '106.111595', '35.625914', 'district', 0),
                                                                                                                    (3128, 3124, '0954', '640424', '泾源县', '106.330646', '35.498159', 'district', 0),
                                                                                                                    (3129, 3124, '0954', '640425', '彭阳县', '106.631809', '35.858815', 'district', 0),
                                                                                                                    (3130, 3106, '1953', '640500', '中卫市', '105.196902', '37.499972', 'city', 0),
                                                                                                                    (3131, 3130, '1953', '640502', '沙坡头区', '105.173721', '37.516883', 'district', 0),
                                                                                                                    (3132, 3130, '1953', '640521', '中宁县', '105.685218', '37.491546', 'district', 0),
                                                                                                                    (3133, 3130, '1953', '640522', '海原县', '105.643487', '36.565033', 'district', 0),
                                                                                                                    (3134, 1, '0', '650000', '新疆维吾尔自治区', '87.627704', '43.793026', 'province', 0),
                                                                                                                    (3135, 3134, '1997', '659002', '阿拉尔市', '81.280527', '40.547653', 'city', 0),
                                                                                                                    (3136, 3135, '1997', '659002', '阿拉尔市', '81.280527', '40.547653', 'district', 0),
                                                                                                                    (3137, 3134, '1906', '659005', '北屯市', '87.837075', '47.332643', 'city', 0),
                                                                                                                    (3138, 3137, '1906', '659005', '北屯市', '87.837075', '47.332643', 'district', 0),
                                                                                                                    (3139, 3134, '1999', '659008', '可克达拉市', '81.044542', '43.944798', 'city', 0),
                                                                                                                    (3140, 3139, '1999', '659008', '可克达拉市', '81.044542', '43.944798', 'district', 0),
                                                                                                                    (3141, 3134, '1903', '659009', '昆玉市', '79.291083', '37.209642', 'city', 0),
                                                                                                                    (3142, 3141, '1903', '659009', '昆玉市', '79.291083', '37.209642', 'district', 0),
                                                                                                                    (3143, 3134, '0993', '659001', '石河子市', '86.080602', '44.306097', 'city', 0),
                                                                                                                    (3144, 3143, '0993', '659001', '石河子市', '86.080602', '44.306097', 'district', 0),
                                                                                                                    (3145, 3134, '1909', '659007', '双河市', '82.353656', '44.840524', 'city', 0),
                                                                                                                    (3146, 3145, '1909', '659007', '双河市', '82.353656', '44.840524', 'district', 0),
                                                                                                                    (3147, 3134, '0991', '650100', '乌鲁木齐市', '87.616848', '43.825592', 'city', 0),
                                                                                                                    (3148, 3147, '0991', '650102', '天山区', '87.631676', '43.794399', 'district', 0),
                                                                                                                    (3149, 3147, '0991', '650103', '沙依巴克区', '87.598195', '43.800939', 'district', 0),
                                                                                                                    (3150, 3147, '0991', '650104', '新市区', '87.569431', '43.855378', 'district', 0),
                                                                                                                    (3151, 3147, '0991', '650105', '水磨沟区', '87.642481', '43.832459', 'district', 0),
                                                                                                                    (3152, 3147, '0991', '650106', '头屯河区', '87.428141', '43.877664', 'district', 0),
                                                                                                                    (3153, 3147, '0991', '650107', '达坂城区', '88.311099', '43.363668', 'district', 0),
                                                                                                                    (3154, 3147, '0991', '650109', '米东区', '87.655935', '43.974784', 'district', 0),
                                                                                                                    (3155, 3147, '0991', '650121', '乌鲁木齐县', '87.409417', '43.47136', 'district', 0),
                                                                                                                    (3156, 3134, '0990', '650200', '克拉玛依市', '84.889207', '45.579888', 'city', 0),
                                                                                                                    (3157, 3156, '0990', '650202', '独山子区', '84.886974', '44.328095', 'district', 0),
                                                                                                                    (3158, 3156, '0990', '650203', '克拉玛依区', '84.867844', '45.602525', 'district', 0),
                                                                                                                    (3159, 3156, '0990', '650204', '白碱滩区', '85.131696', '45.687854', 'district', 0),
                                                                                                                    (3160, 3156, '0990', '650205', '乌尔禾区', '85.693742', '46.089148', 'district', 0),
                                                                                                                    (3161, 3134, '0995', '650400', '吐鲁番市', '89.189752', '42.951303', 'city', 0),
                                                                                                                    (3162, 3161, '0995', '650402', '高昌区', '89.185877', '42.942327', 'district', 0),
                                                                                                                    (3163, 3161, '0995', '650421', '鄯善县', '90.21333', '42.868744', 'district', 0),
                                                                                                                    (3164, 3161, '0995', '650422', '托克逊县', '88.653827', '42.792526', 'district', 0),
                                                                                                                    (3165, 3134, '0902', '650500', '哈密市', '93.515224', '42.819541', 'city', 0),
                                                                                                                    (3166, 3165, '0902', '650502', '伊州区', '93.514797', '42.827254', 'district', 0),
                                                                                                                    (3167, 3165, '0902', '650521', '巴里坤哈萨克自治县', '93.010383', '43.599929', 'district', 0),
                                                                                                                    (3168, 3165, '0902', '650522', '伊吾县', '94.697074', '43.254978', 'district', 0),
                                                                                                                    (3169, 3134, '0994', '652300', '昌吉回族自治州', '87.308224', '44.011182', 'city', 0),
                                                                                                                    (3170, 3169, '0994', '652301', '昌吉市', '87.267532', '44.014435', 'district', 0),
                                                                                                                    (3171, 3169, '0994', '652302', '阜康市', '87.952991', '44.164402', 'district', 0),
                                                                                                                    (3172, 3169, '0994', '652323', '呼图壁县', '86.871584', '44.179361', 'district', 0),
                                                                                                                    (3173, 3169, '0994', '652324', '玛纳斯县', '86.20368', '44.284722', 'district', 0),
                                                                                                                    (3174, 3169, '0994', '652325', '奇台县', '89.593967', '44.022066', 'district', 0),
                                                                                                                    (3175, 3169, '0994', '652327', '吉木萨尔县', '89.180437', '44.000497', 'district', 0),
                                                                                                                    (3176, 3169, '0994', '652328', '木垒哈萨克自治县', '90.286028', '43.834689', 'district', 0),
                                                                                                                    (3177, 3134, '0909', '652700', '博尔塔拉蒙古自治州', '82.066363', '44.906039', 'city', 0),
                                                                                                                    (3178, 3177, '0909', '652701', '博乐市', '82.051004', '44.853869', 'district', 0),
                                                                                                                    (3179, 3177, '0909', '652702', '阿拉山口市', '82.559396', '45.172227', 'district', 0),
                                                                                                                    (3180, 3177, '0909', '652722', '精河县', '82.890656', '44.599393', 'district', 0),
                                                                                                                    (3181, 3177, '0909', '652723', '温泉县', '81.024816', '44.968856', 'district', 0),
                                                                                                                    (3182, 3134, '0996', '652800', '巴音郭楞蒙古自治州', '86.145297', '41.764115', 'city', 0),
                                                                                                                    (3183, 3182, '0996', '652801', '库尔勒市', '86.174633', '41.725891', 'district', 0),
                                                                                                                    (3184, 3182, '0996', '652822', '轮台县', '84.252156', '41.777702', 'district', 0),
                                                                                                                    (3185, 3182, '0996', '652823', '尉犁县', '86.261321', '41.343933', 'district', 0),
                                                                                                                    (3186, 3182, '0996', '652824', '若羌县', '88.167152', '39.023241', 'district', 0),
                                                                                                                    (3187, 3182, '0996', '652825', '且末县', '85.529702', '38.145485', 'district', 0),
                                                                                                                    (3188, 3182, '0996', '652826', '焉耆回族自治县', '86.574067', '42.059759', 'district', 0),
                                                                                                                    (3189, 3182, '0996', '652827', '和静县', '86.384065', '42.323625', 'district', 0),
                                                                                                                    (3190, 3182, '0996', '652828', '和硕县', '86.876799', '42.284331', 'district', 0),
                                                                                                                    (3191, 3182, '0996', '652829', '博湖县', '86.631997', '41.980152', 'district', 0),
                                                                                                                    (3192, 3134, '0997', '652900', '阿克苏地区', '80.260605', '41.168779', 'city', 0),
                                                                                                                    (3193, 3192, '0997', '652901', '阿克苏市', '80.263387', '41.167548', 'district', 0),
                                                                                                                    (3194, 3192, '0997', '652922', '温宿县', '80.238959', '41.276688', 'district', 0),
                                                                                                                    (3195, 3192, '0997', '652923', '库车县', '82.987312', '41.714696', 'district', 0),
                                                                                                                    (3196, 3192, '0997', '652924', '沙雅县', '82.781818', '41.221666', 'district', 0),
                                                                                                                    (3197, 3192, '0997', '652925', '新和县', '82.618736', '41.551206', 'district', 0),
                                                                                                                    (3198, 3192, '0997', '652926', '拜城县', '81.85148', '41.795912', 'district', 0),
                                                                                                                    (3199, 3192, '0997', '652927', '乌什县', '79.224616', '41.222319', 'district', 0),
                                                                                                                    (3200, 3192, '0997', '652928', '阿瓦提县', '80.375053', '40.643647', 'district', 0),
                                                                                                                    (3201, 3192, '0997', '652929', '柯坪县', '79.054497', '40.501936', 'district', 0),
                                                                                                                    (3202, 3134, '0908', '653000', '克孜勒苏柯尔克孜自治州', '76.167819', '39.714526', 'city', 0),
                                                                                                                    (3203, 3202, '0908', '653001', '阿图什市', '76.1684', '39.71616', 'district', 0);
INSERT INTO `sys_region` (`id`, `parent_id`, `citycode`, `adcode`, `name`, `lng`, `lat`, `level`, `sort_order`) VALUES
                                                                                                                    (3204, 3202, '0908', '653022', '阿克陶县', '75.947396', '39.147785', 'district', 0),
                                                                                                                    (3205, 3202, '0908', '653023', '阿合奇县', '78.446253', '40.936936', 'district', 0),
                                                                                                                    (3206, 3202, '0908', '653024', '乌恰县', '75.259227', '39.71931', 'district', 0),
                                                                                                                    (3207, 3134, '0998', '653100', '喀什地区', '75.989741', '39.47046', 'city', 0),
                                                                                                                    (3208, 3207, '0998', '653101', '喀什市', '75.99379', '39.467685', 'district', 0),
                                                                                                                    (3209, 3207, '0998', '653121', '疏附县', '75.862813', '39.375043', 'district', 0),
                                                                                                                    (3210, 3207, '0998', '653122', '疏勒县', '76.048139', '39.401384', 'district', 0),
                                                                                                                    (3211, 3207, '0998', '653123', '英吉沙县', '76.175729', '38.930381', 'district', 0),
                                                                                                                    (3212, 3207, '0998', '653124', '泽普县', '77.259675', '38.18529', 'district', 0),
                                                                                                                    (3213, 3207, '0998', '653125', '莎车县', '77.245761', '38.41422', 'district', 0),
                                                                                                                    (3214, 3207, '0998', '653126', '叶城县', '77.413836', '37.882989', 'district', 0),
                                                                                                                    (3215, 3207, '0998', '653127', '麦盖提县', '77.610125', '38.898001', 'district', 0),
                                                                                                                    (3216, 3207, '0998', '653128', '岳普湖县', '76.8212', '39.2198', 'district', 0),
                                                                                                                    (3217, 3207, '0998', '653129', '伽师县', '76.723719', '39.488181', 'district', 0),
                                                                                                                    (3218, 3207, '0998', '653130', '巴楚县', '78.549296', '39.785155', 'district', 0),
                                                                                                                    (3219, 3207, '0998', '653131', '塔什库尔干塔吉克自治县', '75.229889', '37.772094', 'district', 0),
                                                                                                                    (3220, 3134, '0903', '653200', '和田地区', '79.922211', '37.114157', 'city', 0),
                                                                                                                    (3221, 3220, '0903', '653201', '和田市', '79.913534', '37.112148', 'district', 0),
                                                                                                                    (3222, 3220, '0903', '653221', '和田县', '79.81907', '37.120031', 'district', 0),
                                                                                                                    (3223, 3220, '0903', '653222', '墨玉县', '79.728683', '37.277143', 'district', 0),
                                                                                                                    (3224, 3220, '0903', '653223', '皮山县', '78.283669', '37.62145', 'district', 0),
                                                                                                                    (3225, 3220, '0903', '653224', '洛浦县', '80.188986', '37.073667', 'district', 0),
                                                                                                                    (3226, 3220, '0903', '653225', '策勒县', '80.806159', '36.998335', 'district', 0),
                                                                                                                    (3227, 3220, '0903', '653226', '于田县', '81.677418', '36.85708', 'district', 0),
                                                                                                                    (3228, 3220, '0903', '653227', '民丰县', '82.695861', '37.06408', 'district', 0),
                                                                                                                    (3229, 3134, '0999', '654000', '伊犁哈萨克自治州', '81.324136', '43.916823', 'city', 0),
                                                                                                                    (3230, 3229, '0999', '654002', '伊宁市', '81.27795', '43.908558', 'district', 0),
                                                                                                                    (3231, 3229, '0999', '654003', '奎屯市', '84.903267', '44.426529', 'district', 0),
                                                                                                                    (3232, 3229, '0999', '654004', '霍尔果斯市', '80.411271', '44.213941', 'district', 0),
                                                                                                                    (3233, 3229, '0999', '654021', '伊宁县', '81.52745', '43.977119', 'district', 0),
                                                                                                                    (3234, 3229, '0999', '654022', '察布查尔锡伯自治县', '81.151337', '43.840726', 'district', 0),
                                                                                                                    (3235, 3229, '0999', '654023', '霍城县', '80.87898', '44.055984', 'district', 0),
                                                                                                                    (3236, 3229, '0999', '654024', '巩留县', '82.231718', '43.482628', 'district', 0),
                                                                                                                    (3237, 3229, '0999', '654025', '新源县', '83.232848', '43.433896', 'district', 0),
                                                                                                                    (3238, 3229, '0999', '654026', '昭苏县', '81.130974', '43.157293', 'district', 0),
                                                                                                                    (3239, 3229, '0999', '654027', '特克斯县', '81.836206', '43.217183', 'district', 0),
                                                                                                                    (3240, 3229, '0999', '654028', '尼勒克县', '82.511809', '43.800247', 'district', 0),
                                                                                                                    (3241, 3134, '0901', '654200', '塔城地区', '82.980316', '46.745364', 'city', 0),
                                                                                                                    (3242, 3241, '0901', '654201', '塔城市', '82.986978', '46.751428', 'district', 0),
                                                                                                                    (3243, 3241, '0901', '654202', '乌苏市', '84.713396', '44.41881', 'district', 0),
                                                                                                                    (3244, 3241, '0901', '654221', '额敏县', '83.628303', '46.524673', 'district', 0),
                                                                                                                    (3245, 3241, '0901', '654223', '沙湾县', '85.619416', '44.326388', 'district', 0),
                                                                                                                    (3246, 3241, '0901', '654224', '托里县', '83.60695', '45.947638', 'district', 0),
                                                                                                                    (3247, 3241, '0901', '654225', '裕民县', '82.982667', '46.201104', 'district', 0),
                                                                                                                    (3248, 3241, '0901', '654226', '和布克赛尔蒙古自治县', '85.728328', '46.793235', 'district', 0),
                                                                                                                    (3249, 3134, '0906', '654300', '阿勒泰地区', '88.141253', '47.844924', 'city', 0),
                                                                                                                    (3250, 3249, '0906', '654301', '阿勒泰市', '88.131842', '47.827308', 'district', 0),
                                                                                                                    (3251, 3249, '0906', '654321', '布尔津县', '86.874923', '47.702163', 'district', 0),
                                                                                                                    (3252, 3249, '0906', '654322', '富蕴县', '89.525504', '46.994115', 'district', 0),
                                                                                                                    (3253, 3249, '0906', '654323', '福海县', '87.486703', '47.111918', 'district', 0),
                                                                                                                    (3254, 3249, '0906', '654324', '哈巴河县', '86.418621', '48.060846', 'district', 0),
                                                                                                                    (3255, 3249, '0906', '654325', '青河县', '90.37555', '46.679113', 'district', 0),
                                                                                                                    (3256, 3249, '0906', '654326', '吉木乃县', '85.874096', '47.443101', 'district', 0),
                                                                                                                    (3257, 3134, '1996', '659006', '铁门关市', '85.501217', '41.82725', 'city', 0),
                                                                                                                    (3258, 3257, '1996', '659006', '铁门关市', '85.501217', '41.82725', 'district', 0),
                                                                                                                    (3259, 3134, '1998', '659003', '图木舒克市', '79.073963', '39.868965', 'city', 0),
                                                                                                                    (3260, 3259, '1998', '659003', '图木舒克市', '79.073963', '39.868965', 'district', 0),
                                                                                                                    (3261, 3134, '1994', '659004', '五家渠市', '87.54324', '44.166756', 'city', 0),
                                                                                                                    (3262, 3261, '1994', '659004', '五家渠市', '87.54324', '44.166756', 'district', 0),
                                                                                                                    (3263, 850, '320589', '320589', '高新区', '120', '30', 'district', 0),
                                                                                                                    (3271, 1409, '0536', '370787', '高新区', '119', '36', 'district', 0);

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

--
-- 表的结构 `sys_sms`
--

DROP TABLE IF EXISTS `sys_sms`;
CREATE TABLE `sys_sms` (
                           `id` int(11) NOT NULL,
                           `template_id` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '短信模板ID',
                           `ip` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'ip地址',
                           `zone` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '发送类型',
                           `mobile` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '手机号',
                           `content` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '短信内容',
                           `params` varchar(512) DEFAULT NULL COMMENT '模板参数',
                           `error_msg` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '错误信息',
                           `error_state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '错误状态(无错:no=0,有错:yes=1)',
                           `send_state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '发送状态(已发送:done=1,未发送:none=0)',
                           `sended` int(11) DEFAULT '0' COMMENT '发送时间',
                           `begined` int(11) DEFAULT '0' COMMENT '定时发送时间',
                           `updated` int(11) DEFAULT '0',
                           `created` int(11) DEFAULT '0' COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='短信发送' ROW_FORMAT=COMPACT;

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

--
-- 表的结构 `sys_sms_info`
--

DROP TABLE IF EXISTS `sys_sms_info`;
CREATE TABLE `sys_sms_info` (
                                `id` int(10) UNSIGNED NOT NULL,
                                `is_open` char(1) DEFAULT '0' COMMENT '是否开启',
                                `use_type` char(1) DEFAULT '0',
                                `aliyun_json` text COMMENT '阿里云信息',
                                `yunpian_json` text,
                                `qcloud_json` text,
                                `smsget_json` text,
                                `created` int(11) DEFAULT '0',
                                `updated` int(11) DEFAULT '0',
                                `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='短信信息设置' ROW_FORMAT=COMPACT;

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

--
-- 表的结构 `sys_sms_template`
--

DROP TABLE IF EXISTS `sys_sms_template`;
CREATE TABLE `sys_sms_template` (
                                    `id` int(10) UNSIGNED NOT NULL,
                                    `name` varchar(32) DEFAULT NULL,
                                    `class_name` varchar(64) DEFAULT NULL,
                                    `template_id` varchar(32) DEFAULT NULL,
                                    `content` text,
                                    `state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '状态(激活:active=1,停用:none=0)',
                                    `created` int(11) DEFAULT '0',
                                    `updated` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='短信模板' ROW_FORMAT=COMPACT;

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

--
-- 表的结构 `sys_system`
--

DROP TABLE IF EXISTS `sys_system`;
CREATE TABLE `sys_system` (
                              `id` int(11) NOT NULL,
                              `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '属性名字',
                              `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '属性值',
                              `updated` int(11) DEFAULT NULL,
                              `created` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统设置' ROW_FORMAT=COMPACT;

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

--
-- 表的结构 `sys_upload_group`
--

DROP TABLE IF EXISTS `sys_upload_group`;
CREATE TABLE `sys_upload_group` (
                                    `id` int(10) UNSIGNED NOT NULL,
                                    `zone` varchar(32) DEFAULT NULL,
                                    `name` varchar(24) DEFAULT NULL COMMENT '名称',
                                    `is_default` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否可编辑(是:yes=1,否:no=0)',
                                    `created` int(11) DEFAULT '0',
                                    `updated` int(11) DEFAULT '0',
                                    `is_delete` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='图片库分组' ROW_FORMAT=COMPACT;

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

--
-- 表的结构 `sys_upload_image`
--

DROP TABLE IF EXISTS `sys_upload_image`;
CREATE TABLE `sys_upload_image` (
                                    `id` int(11) NOT NULL,
                                    `zone` varchar(32) DEFAULT NULL,
                                    `group_id` int(11) DEFAULT '0' COMMENT '分组id',
                                    `image` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
                                    `extension` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件扩展名',
                                    `size` int(11) NOT NULL DEFAULT '0' COMMENT '文件大小，字节',
                                    `created` int(11) NOT NULL DEFAULT '0',
                                    `updated` int(11) DEFAULT '0' COMMENT '更新日期',
                                    `is_delete` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户上传的文件' ROW_FORMAT=COMPACT;

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

--
-- 表的结构 `tool_app`
--

DROP TABLE IF EXISTS `tool_app`;
CREATE TABLE `tool_app` (
                            `id` int(10) NOT NULL,
                            `username` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
                            `password` varchar(128) COLLATE utf8mb4_general_ci DEFAULT NULL,
                            `app_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'appkey',
                            `title` varchar(128) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名字',
                            `mark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '说明',
                            `state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '状态(未启用:None=0,已激活:Enable=1,禁用:Disable=2)',
                            `created` int(10) DEFAULT '0',
                            `updated` int(10) DEFAULT '0',
                            `is_delete` char(1) COLLATE utf8mb4_general_ci DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='工具应用';

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

--
-- 表的结构 `tool_app_login`
--

DROP TABLE IF EXISTS `tool_app_login`;
CREATE TABLE `tool_app_login` (
                                  `id` int(10) UNSIGNED NOT NULL,
                                  `owner_id` int(11) DEFAULT '0',
                                  `ip` varchar(32) DEFAULT NULL,
                                  `ua` varchar(256) DEFAULT NULL,
                                  `ip_address` varchar(128) DEFAULT NULL,
                                  `created` int(11) DEFAULT '0',
                                  `updated` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='工具管理登陆日志';

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

--
-- 表的结构 `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
                        `id` bigint(20) UNSIGNED NOT NULL,
                        `agent_id` int(11) DEFAULT '0' COMMENT '所属代理',
                        `agent_level` int(10) DEFAULT '0' COMMENT '代理级别',
                        `email` varchar(128) DEFAULT NULL,
                        `username` varchar(32) DEFAULT NULL,
                        `mobile` varchar(24) DEFAULT NULL,
                        `avatar_image` varchar(512) DEFAULT NULL,
                        `password` varchar(128) DEFAULT NULL,
                        `temp_password` varchar(128) DEFAULT NULL COMMENT '临时密码',
                        `token` varchar(32) DEFAULT NULL,
                        `realname` varchar(24) DEFAULT NULL,
                        `nickname` varchar(32) DEFAULT NULL,
                        `auth_key` varchar(64) DEFAULT NULL,
                        `remark` varchar(512) DEFAULT NULL COMMENT '备注',
                        `notice` varchar(512) DEFAULT NULL COMMENT '用户重要提示',
                        `is_agent` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否开通代理(是:yes=1,否:no=0)',
                        `state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '状态(未验证:none=0,正常:active=1,冻结:freeze=2)',
                        `freezed` int(11) DEFAULT '0' COMMENT '冻结时间',
                        `freeze_reason` varchar(128) DEFAULT NULL COMMENT '冻结原因',
                        `freeze_admin_id` int(11) DEFAULT '0' COMMENT '冻结操作管理员ID',
                        `lasted` int(11) DEFAULT '0',
                        `created` int(11) DEFAULT '0',
                        `updated` int(11) DEFAULT '0',
                        `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户信息' ROW_FORMAT=COMPACT;

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

--
-- 表的结构 `user_agent_flow`
--

DROP TABLE IF EXISTS `user_agent_flow`;
CREATE TABLE `user_agent_flow` (
                                   `id` int(10) UNSIGNED NOT NULL,
                                   `zone` varchar(128) DEFAULT NULL,
                                   `zone_id` int(11) DEFAULT '0',
                                   `agent_id` int(11) DEFAULT '0',
                                   `user_id` int(11) DEFAULT '0',
                                   `level` int(11) DEFAULT '0',
                                   `rate` float(10,3) DEFAULT '0.000',
                                   `total_point` decimal(20,10) DEFAULT '0.0000000000' COMMENT '涉及总额',
                                   `price_point` decimal(20,10) DEFAULT '0.0000000000' COMMENT '金额',
                                   `remark` varchar(128) DEFAULT NULL COMMENT '标记',
                                   `created` int(11) DEFAULT '0',
                                   `updated` int(11) DEFAULT '0',
                                   `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户代理佣金明细';

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

--
-- 表的结构 `user_agent_invite`
--

DROP TABLE IF EXISTS `user_agent_invite`;
CREATE TABLE `user_agent_invite` (
                                     `id` int(11) NOT NULL,
                                     `agent_id` int(11) DEFAULT '0' COMMENT '代理id',
                                     `user_id` int(11) DEFAULT '0',
                                     `user_ip` varchar(32) DEFAULT NULL,
                                     `state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '状态(等待:wait=0,1:已完成:done=1)',
                                     `doned` int(11) DEFAULT '0',
                                     `created` int(11) DEFAULT '0',
                                     `updated` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户邀请信息';

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

--
-- 表的结构 `user_agent_map`
--

DROP TABLE IF EXISTS `user_agent_map`;
CREATE TABLE `user_agent_map` (
                                  `id` int(10) UNSIGNED NOT NULL,
                                  `agent_id` int(11) DEFAULT '0' COMMENT '代理id',
                                  `user_id` int(11) DEFAULT '0' COMMENT '下级用户ID',
                                  `level` int(11) DEFAULT '1' COMMENT '代理级别',
                                  `created` int(11) DEFAULT '0',
                                  `updated` int(11) DEFAULT '0',
                                  `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户代理信息';

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

--
-- 表的结构 `user_bank`
--

DROP TABLE IF EXISTS `user_bank`;
CREATE TABLE `user_bank` (
                             `id` int(10) UNSIGNED NOT NULL,
                             `user_id` int(11) DEFAULT '0',
                             `bank_name` varchar(64) DEFAULT NULL COMMENT '银行名称',
                             `bank_sub_name` varchar(64) DEFAULT NULL COMMENT '支行名称',
                             `bank_card_no` varchar(48) DEFAULT NULL COMMENT '银行卡号',
                             `region_id` int(11) DEFAULT '0',
                             `idcard` varchar(32) DEFAULT NULL COMMENT '身份证',
                             `mobile` varchar(24) DEFAULT NULL COMMENT '手机号',
                             `realname` varchar(32) DEFAULT NULL COMMENT '真实姓名',
                             `new_info` varchar(512) DEFAULT NULL COMMENT '修改信息',
                             `state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '状态(未填写:none=0,已填写:done=1,有修改:change=2)',
                             `created` int(11) DEFAULT '0',
                             `updated` int(11) DEFAULT '0',
                             `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='下分银行';

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

--
-- 表的结构 `user_email_verify`
--

DROP TABLE IF EXISTS `user_email_verify`;
CREATE TABLE `user_email_verify` (
                                     `id` int(10) UNSIGNED NOT NULL,
                                     `user_id` int(11) DEFAULT '0',
                                     `email` varchar(256) DEFAULT NULL,
                                     `action` char(1) DEFAULT '0' COMMENT '操作类型',
                                     `code` varchar(32) DEFAULT NULL COMMENT '验证码',
                                     `state` char(1) DEFAULT '0' COMMENT '状态(0:未验证,1:已验证)',
                                     `actived` int(11) DEFAULT '0' COMMENT '激活时间',
                                     `created` int(11) DEFAULT '0',
                                     `updated` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户邮件验证';

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

--
-- 表的结构 `user_fake`
--

DROP TABLE IF EXISTS `user_fake`;
CREATE TABLE `user_fake` (
                             `id` int(11) NOT NULL,
                             `user_id` int(11) DEFAULT '0',
                             `task_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
                             `task_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '操作类型(执行一次:once=0,循环执行:loop=1)',
                             `task_loop_index` int(11) NOT NULL DEFAULT '0' COMMENT '多次执行步数',
                             `created` int(11) DEFAULT '0',
                             `updated` int(11) DEFAULT '0',
                             `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='懂';

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

--
-- 表的结构 `user_flash`
--

DROP TABLE IF EXISTS `user_flash`;
CREATE TABLE `user_flash` (
                              `id` int(11) NOT NULL,
                              `user_id` int(11) DEFAULT '0',
                              `zone` varchar(128) DEFAULT NULL,
                              `zone_id` int(11) DEFAULT '0',
                              `message` varchar(512) DEFAULT NULL,
                              `is_view` char(1) DEFAULT '0',
                              `viewed` int(11) DEFAULT '0',
                              `created` int(11) DEFAULT '0',
                              `updated` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='flash信息';

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

--
-- 表的结构 `user_login`
--

DROP TABLE IF EXISTS `user_login`;
CREATE TABLE `user_login` (
                              `id` int(10) UNSIGNED NOT NULL,
                              `user_id` int(11) DEFAULT '0',
                              `ua` varchar(512) DEFAULT NULL,
                              `ip` varchar(32) DEFAULT NULL,
                              `address` varchar(64) DEFAULT NULL,
                              `created` int(11) DEFAULT '0',
                              `updated` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='登陆日志';

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

--
-- 表的结构 `user_note`
--

DROP TABLE IF EXISTS `user_note`;
CREATE TABLE `user_note` (
                             `id` int(11) NOT NULL,
                             `user_id` int(11) DEFAULT '0',
                             `admin_id` int(11) DEFAULT '0',
                             `title` varchar(512) DEFAULT NULL,
                             `content` text,
                             `is_top` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否置顶(是:yes=1,否:no=0)',
                             `is_highlight` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否高亮(是:yes=1,否:no=0)',
                             `real_sort` int(11) DEFAULT '0',
                             `sort_order` int(11) DEFAULT '0',
                             `begined` int(11) DEFAULT '0',
                             `created` int(11) DEFAULT '0',
                             `updated` int(11) DEFAULT '0',
                             `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户消息提示';

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

--
-- 表的结构 `user_note_read`
--

DROP TABLE IF EXISTS `user_note_read`;
CREATE TABLE `user_note_read` (
                                  `id` int(10) UNSIGNED NOT NULL,
                                  `user_id` int(11) DEFAULT '0',
                                  `note_id` int(11) DEFAULT '0',
                                  `created` int(11) DEFAULT '0',
                                  `updated` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户消息提示已读';

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

--
-- 表的结构 `user_oauth`
--

DROP TABLE IF EXISTS `user_oauth`;
CREATE TABLE `user_oauth` (
                              `id` int(10) UNSIGNED NOT NULL,
                              `user_id` int(11) DEFAULT '0',
                              `provider_id` varchar(12) DEFAULT NULL,
                              `open_id` varchar(64) DEFAULT NULL,
                              `sub_open_id` varchar(64) DEFAULT NULL,
                              `nickname` varchar(32) DEFAULT NULL,
                              `email` varchar(64) DEFAULT NULL,
                              `avatar_image` varchar(512) DEFAULT NULL,
                              `raw_info` varchar(1024) DEFAULT NULL,
                              `created` int(11) DEFAULT '0',
                              `updated` int(11) DEFAULT '0',
                              `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- 表的结构 `user_point_admin_charge`
--

DROP TABLE IF EXISTS `user_point_admin_charge`;
CREATE TABLE `user_point_admin_charge` (
                                           `id` int(10) UNSIGNED NOT NULL,
                                           `admin_id` int(11) DEFAULT '0',
                                           `user_id` int(11) DEFAULT NULL,
                                           `ip` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作人IP',
                                           `action_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '操作类型(增加:up=1,减少:down=2)',
                                           `point` decimal(20,10) DEFAULT '0.0000000000',
                                           `reason` varchar(512) DEFAULT NULL COMMENT '理由',
                                           `created` int(11) DEFAULT '0',
                                           `updated` int(11) DEFAULT '0',
                                           `is_delete` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='后台充值记录';

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

--
-- 表的结构 `user_point_charge`
--

DROP TABLE IF EXISTS `user_point_charge`;
CREATE TABLE `user_point_charge` (
                                     `id` int(10) UNSIGNED NOT NULL,
                                     `admin_id` int(11) DEFAULT '0',
                                     `user_id` int(11) DEFAULT '0',
                                     `point` decimal(20,10) DEFAULT '0.0000000000',
                                     `last_point` decimal(20,10) DEFAULT '0.0000000000' COMMENT '当时余额',
                                     `check_state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '审核状态(未审核:none=0,已审核:agree=1,驳回:reject=2,用户取消:cancel=3)',
                                     `agreed` int(11) DEFAULT '0' COMMENT '审核时间',
                                     `canceled` int(11) DEFAULT '0' COMMENT '取消时间',
                                     `rejected` int(11) DEFAULT '0' COMMENT '驳回时间',
                                     `doned` int(11) DEFAULT '0' COMMENT '完成时间',
                                     `created` int(11) DEFAULT '0',
                                     `updated` int(11) DEFAULT '0',
                                     `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='上分请求审核';

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

--
-- 表的结构 `user_point_flow`
--

DROP TABLE IF EXISTS `user_point_flow`;
CREATE TABLE `user_point_flow` (
                                   `id` int(10) UNSIGNED NOT NULL,
                                   `user_id` int(11) DEFAULT '0',
                                   `zone` varchar(256) DEFAULT NULL COMMENT '类型',
                                   `zone_id` int(11) DEFAULT '0' COMMENT '对应id',
                                   `point` decimal(20,10) DEFAULT '0.0000000000',
                                   `last_point` decimal(20,10) DEFAULT '0.0000000000',
                                   `action` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '操作类型(进:in=1,出:out=2)',
                                   `remark` varchar(128) DEFAULT NULL COMMENT '注释',
                                   `created` int(11) DEFAULT '0',
                                   `updated` int(11) DEFAULT '0',
                                   `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='流水';

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

--
-- 表的结构 `user_point_freeze`
--

DROP TABLE IF EXISTS `user_point_freeze`;
CREATE TABLE `user_point_freeze` (
                                     `id` int(11) NOT NULL,
                                     `user_id` int(11) DEFAULT '0',
                                     `zone` varchar(128) DEFAULT '0' COMMENT '类型',
                                     `zone_id` int(11) DEFAULT '0',
                                     `point` decimal(20,10) DEFAULT '0.0000000000' COMMENT '实时总金额',
                                     `freeze_point` decimal(20,10) DEFAULT '0.0000000000' COMMENT '原始冻结金额',
                                     `back_point` decimal(20,10) DEFAULT '0.0000000000' COMMENT '返回金额',
                                     `crash_point` decimal(20,10) DEFAULT '0.0000000000' COMMENT '销毁数量',
                                     `remark` varchar(128) DEFAULT NULL COMMENT '说明',
                                     `state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '状态(冻结中:freeze=1,已恢复:back=2,已销毁:crash=3)',
                                     `backed` int(11) DEFAULT '0' COMMENT '恢复时间',
                                     `crashed` int(11) DEFAULT '0' COMMENT '销毁时间',
                                     `created` int(11) DEFAULT '0',
                                     `updated` int(11) DEFAULT '0',
                                     `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='冻结金额';

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

--
-- 表的结构 `user_point_wallet`
--

DROP TABLE IF EXISTS `user_point_wallet`;
CREATE TABLE `user_point_wallet` (
                                     `id` int(10) UNSIGNED NOT NULL,
                                     `user_id` int(11) DEFAULT '0',
                                     `last_point` decimal(20,10) DEFAULT '0.0000000000',
                                     `freeze_point` decimal(20,10) DEFAULT '0.0000000000',
                                     `agen_point` decimal(20,10) NOT NULL DEFAULT '0.0000000000' COMMENT '代理收入',
                                     `history_point` decimal(20,10) DEFAULT '0.0000000000',
                                     `history_use_point` decimal(20,10) DEFAULT '0.0000000000',
                                     `created` int(11) DEFAULT '0',
                                     `updated` int(11) DEFAULT '0',
                                     `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户资金账户';

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

--
-- 表的结构 `user_point_withdraw`
--

DROP TABLE IF EXISTS `user_point_withdraw`;
CREATE TABLE `user_point_withdraw` (
                                       `id` int(11) NOT NULL,
                                       `admin_id` int(11) DEFAULT '0' COMMENT '审核管理员',
                                       `user_id` int(11) DEFAULT '0',
                                       `freeze_id` int(11) DEFAULT '0',
                                       `bank_name` varchar(64) DEFAULT NULL COMMENT '银行名',
                                       `bank_sub_name` varchar(64) DEFAULT NULL COMMENT '支行',
                                       `bank_card_no` varchar(32) DEFAULT NULL COMMENT '卡号',
                                       `bank_realname` varchar(32) DEFAULT NULL COMMENT '真是名称',
                                       `bank_mobile` varchar(24) DEFAULT NULL COMMENT '手机号',
                                       `bank_region_id` int(11) DEFAULT '0',
                                       `bank_idcard` varchar(32) DEFAULT NULL COMMENT '身份证',
                                       `point` decimal(20,10) DEFAULT '0.0000000000' COMMENT '提现金额',
                                       `reject_reason` text COMMENT '驳回原因',
                                       `check_state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '审核状态(未审核:none=0,已审核:agree=1,已驳回:reject=2,已取消:cancel=3)',
                                       `checked` int(11) DEFAULT '0',
                                       `doned` int(11) DEFAULT '0' COMMENT '完成时间',
                                       `created` int(11) DEFAULT '0',
                                       `updated` int(11) DEFAULT '0',
                                       `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户下分';

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

--
-- 表的结构 `user_rate_flow`
--

DROP TABLE IF EXISTS `user_rate_flow`;
CREATE TABLE `user_rate_flow` (
                                  `id` int(11) NOT NULL,
                                  `user_id` int(11) DEFAULT '0',
                                  `zone` varchar(128) DEFAULT NULL,
                                  `zone_id` int(11) DEFAULT '0',
                                  `rate` float(10,4) DEFAULT '0.0000',
                                  `point` decimal(20,10) DEFAULT '0.0000000000' COMMENT '金额',
                                  `remark` varchar(128) DEFAULT NULL COMMENT '说明',
                                  `created` int(11) DEFAULT '0',
                                  `updated` int(11) DEFAULT '0',
                                  `is_delete` char(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='手续费记录';

--
-- 转储表的索引
--



--
-- 表的索引 `sys_ad`
--
ALTER TABLE `sys_ad`
    ADD PRIMARY KEY (`id`),
    ADD KEY `position` (`position`);

--
-- 表的索引 `sys_admin`
--
ALTER TABLE `sys_admin`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `sys_admin_log`
--
ALTER TABLE `sys_admin_log`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `sys_admin_login`
--
ALTER TABLE `sys_admin_login`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `sys_admin_role`
--
ALTER TABLE `sys_admin_role`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `sys_admin_role_action`
--
ALTER TABLE `sys_admin_role_action`
    ADD PRIMARY KEY (`id`),
    ADD KEY `hash` (`hash`);

--
-- 表的索引 `sys_countries`
--
ALTER TABLE `sys_countries`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `sys_region`
--
ALTER TABLE `sys_region`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `sys_sms`
--
ALTER TABLE `sys_sms`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `sys_sms_info`
--
ALTER TABLE `sys_sms_info`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `sys_sms_template`
--
ALTER TABLE `sys_sms_template`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `sys_system`
--
ALTER TABLE `sys_system`
    ADD PRIMARY KEY (`id`),
    ADD KEY `name` (`name`);

--
-- 表的索引 `sys_upload_group`
--
ALTER TABLE `sys_upload_group`
    ADD PRIMARY KEY (`id`),
    ADD KEY `is_delete` (`is_delete`),
    ADD KEY `is_default` (`is_default`);

--
-- 表的索引 `sys_upload_image`
--
ALTER TABLE `sys_upload_image`
    ADD PRIMARY KEY (`id`,`extension`),
    ADD KEY `is_delete` (`is_delete`);

--
-- 表的索引 `tool_app`
--
ALTER TABLE `tool_app`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `tool_app_login`
--
ALTER TABLE `tool_app_login`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user`
--
ALTER TABLE `user`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_agent_flow`
--
ALTER TABLE `user_agent_flow`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_agent_invite`
--
ALTER TABLE `user_agent_invite`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_agent_map`
--
ALTER TABLE `user_agent_map`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_bank`
--
ALTER TABLE `user_bank`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_email_verify`
--
ALTER TABLE `user_email_verify`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_fake`
--
ALTER TABLE `user_fake`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_flash`
--
ALTER TABLE `user_flash`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_login`
--
ALTER TABLE `user_login`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_note`
--
ALTER TABLE `user_note`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_note_read`
--
ALTER TABLE `user_note_read`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_oauth`
--
ALTER TABLE `user_oauth`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_point_admin_charge`
--
ALTER TABLE `user_point_admin_charge`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_point_charge`
--
ALTER TABLE `user_point_charge`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_point_flow`
--
ALTER TABLE `user_point_flow`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_point_freeze`
--
ALTER TABLE `user_point_freeze`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_point_wallet`
--
ALTER TABLE `user_point_wallet`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_point_withdraw`
--
ALTER TABLE `user_point_withdraw`
    ADD PRIMARY KEY (`id`);

--
-- 表的索引 `user_rate_flow`
--
ALTER TABLE `user_rate_flow`
    ADD PRIMARY KEY (`id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `sys_ad`
--
ALTER TABLE `sys_ad`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `sys_admin`
--
ALTER TABLE `sys_admin`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `sys_admin_log`
--
ALTER TABLE `sys_admin_log`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `sys_admin_login`
--
ALTER TABLE `sys_admin_login`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `sys_admin_role`
--
ALTER TABLE `sys_admin_role`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `sys_admin_role_action`
--
ALTER TABLE `sys_admin_role_action`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `sys_countries`
--
ALTER TABLE `sys_countries`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=241;

--
-- 使用表AUTO_INCREMENT `sys_region`
--
ALTER TABLE `sys_region`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST, AUTO_INCREMENT=3272;

--
-- 使用表AUTO_INCREMENT `sys_sms`
--
ALTER TABLE `sys_sms`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `sys_sms_info`
--
ALTER TABLE `sys_sms_info`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `sys_sms_template`
--
ALTER TABLE `sys_sms_template`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `sys_system`
--
ALTER TABLE `sys_system`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `sys_upload_group`
--
ALTER TABLE `sys_upload_group`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `sys_upload_image`
--
ALTER TABLE `sys_upload_image`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `tool_app`
--
ALTER TABLE `tool_app`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `tool_app_login`
--
ALTER TABLE `tool_app_login`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user`
--
ALTER TABLE `user`
    MODIFY COLUMN `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_agent_flow`
--
ALTER TABLE `user_agent_flow`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_agent_invite`
--
ALTER TABLE `user_agent_invite`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_agent_map`
--
ALTER TABLE `user_agent_map`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_bank`
--
ALTER TABLE `user_bank`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_email_verify`
--
ALTER TABLE `user_email_verify`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_fake`
--
ALTER TABLE `user_fake`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_flash`
--
ALTER TABLE `user_flash`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_login`
--
ALTER TABLE `user_login`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_note`
--
ALTER TABLE `user_note`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_note_read`
--
ALTER TABLE `user_note_read`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_oauth`
--
ALTER TABLE `user_oauth`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_point_admin_charge`
--
ALTER TABLE `user_point_admin_charge`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_point_charge`
--
ALTER TABLE `user_point_charge`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_point_flow`
--
ALTER TABLE `user_point_flow`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_point_freeze`
--
ALTER TABLE `user_point_freeze`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_point_wallet`
--
ALTER TABLE `user_point_wallet`
    MODIFY COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_point_withdraw`
--
ALTER TABLE `user_point_withdraw`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

--
-- 使用表AUTO_INCREMENT `user_rate_flow`
--
ALTER TABLE `user_rate_flow`
    MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
