全国最全行政区sql

INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110000, '北京', 0, '北京', NULL, NULL, NULL, '116.405289', '39.904987', 1, 'tr_0', 1); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110100, '北京市', 110000, '北京', NULL, NULL, NULL, '116.405289', '39.904987', 2, 'tr_0 tr_110000', 1); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110101, '东城区', 110100, '东城', NULL, NULL, NULL, '116.418755', '39.917545', 3, 'tr_0 tr_110000 tr_110100', 3); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110102, '西城区', 110100, '西城', NULL, NULL, NULL, '116.366791', '39.91531', 3, 'tr_0 tr_110000 tr_110100', 15); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110105, '朝阳区', 110100, '朝阳', NULL, NULL, NULL, '116.486412', '39.92149', 3, 'tr_0 tr_110000 tr_110100', 2); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110106, '丰台区', 110100, '丰台', NULL, NULL, NULL, '116.286964', '39.863644', 3, 'tr_0 tr_110000 tr_110100', 6); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110107, '石景山区', 110100, '石景山', NULL, NULL, NULL, '116.195442', '39.9146', 3, 'tr_0 tr_110000 tr_110100', 12); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110108, '海淀区', 110100, '海淀', NULL, NULL, NULL, '116.310318', '39.956074', 3, 'tr_0 tr_110000 tr_110100', 7); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110109, '门头沟区', 110100, '门头沟', NULL, NULL, NULL, '116.105377', '39.937183', 3, 'tr_0 tr_110000 tr_110100', 9); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110111, '房山区', 110100, '房山', NULL, NULL, NULL, '116.13916', '39.735535', 3, 'tr_0 tr_110000 tr_110100', 5); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110112, '通州区', 110100, '通州', NULL, NULL, NULL, '116.6586', '39.902485', 3, 'tr_0 tr_110000 tr_110100', 14); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110113, '顺义区', 110100, '顺义', NULL, NULL, NULL, '116.653526', '40.128937', 3, 'tr_0 tr_110000 tr_110100', 13); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110114, '昌平区', 110100, '昌平', NULL, NULL, NULL, '116.235909', '40.218086', 3, 'tr_0 tr_110000 tr_110100', 1); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110115, '大兴区', 110100, '大兴', NULL, NULL, NULL, '116.338036', '39.728909', 3, 'tr_0 tr_110000 tr_110100', 4); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110116, '怀柔区', 110100, '怀柔', NULL, NULL, NULL, '116.637123', '40.324272', 3, 'tr_0 tr_110000 tr_110100', 8); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110117, '平谷区', 110100, '平谷', NULL, NULL, NULL, '117.112335', '40.144783', 3, 'tr_0 tr_110000 tr_110100', 11); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110228, '密云县', 110100, '密云', NULL, NULL, NULL, '116.843353', '40.377361', 3, 'tr_0 tr_110000 tr_110100', 10); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (110229, '延庆县', 110100, '延庆', NULL, NULL, NULL, '115.985008', '40.465324', 3, 'tr_0 tr_110000 tr_110100', 16); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120000, '天津', 0, '天津', NULL, NULL, NULL, '117.190186', '39.125595', 1, 'tr_0', 2); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120100, '天津市', 120000, '天津', NULL, NULL, NULL, '117.190186', '39.125595', 2, 'tr_0 tr_120000', 1); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120101, '和平区', 120100, '和平', NULL, NULL, NULL, '117.195908', '39.118328', 3, 'tr_0 tr_120000 tr_120100', 7); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120102, '河东区', 120100, '河东', NULL, NULL, NULL, '117.22657', '39.122124', 3, 'tr_0 tr_120000 tr_120100', 6); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120103, '河西区', 120100, '河西', NULL, NULL, NULL, '117.217537', '39.101898', 3, 'tr_0 tr_120000 tr_120100', 8); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120104, '南开区', 120100, '南开', NULL, NULL, NULL, '117.164146', '39.120476', 3, 'tr_0 tr_120000 tr_120100', 13); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120105, '河北区', 120100, '河北', NULL, NULL, NULL, '117.201569', '39.156631', 3, 'tr_0 tr_120000 tr_120100', 5); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120106, '红桥区', 120100, '红桥', NULL, NULL, NULL, '117.1633', '39.175068', 3, 'tr_0 tr_120000 tr_120100', 9); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120110, '东丽区', 120100, '东丽', NULL, NULL, NULL, '117.313965', '39.087765', 3, 'tr_0 tr_120000 tr_120100', 4); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120111, '西青区', 120100, '西青', NULL, NULL, NULL, '117.012245', '39.139446', 3, 'tr_0 tr_120000 tr_120100', 16); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120112, '津南区', 120100, '津南', NULL, NULL, NULL, '117.382545', '38.989578', 3, 'tr_0 tr_120000 tr_120100', 11); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120113, '北辰区', 120100, '北辰', NULL, NULL, NULL, '117.134819', '39.225555', 3, 'tr_0 tr_120000 tr_120100', 2); INSERT INTO `` (`id`, `areaname`, `parentid`, `shortname`, `areacode`, `zipcode`, `pinyin`, `lng`, `lat`, `level`, `position`, `sort`) VALUES (120114, '武清区', 120100, '�