mysql省市区表，带区号、拼音、经纬度（完整版.6）

mysql省市区表（完整版），带区号、拼音、经纬度。

由于篇幅过长只能分开
表数据示例六

INSERT INTO `hup_region` VALUES (3434, 3416, '佳里', '佳里区', '中国,台湾省,台南市,佳里区', 3, 'jiali', '06', '722', 'J', '120.177211', '23.165121');
INSERT INTO `hup_region` VALUES (3435, 3416, '学甲', '学甲区', '中国,台湾省,台南市,学甲区', 3, 'xuejia', '06', '726', 'X', '120.180255', '23.232348');
INSERT INTO `hup_region` VALUES (3436, 3416, '西港', '西港区', '中国,台湾省,台南市,西港区', 3, 'xigang', '06', '723', 'X', '120.203618', '23.123057');
INSERT INTO `hup_region` VALUES (3437, 3416, '七股', '七股区', '中国,台湾省,台南市,七股区', 3, 'qigu', '06', '724', 'Q', '120.140003', '23.140545');
INSERT INTO `hup_region` VALUES (3438, 3416, '将军', '将军区', '中国,台湾省,台南市,将军区', 3, 'jiangjun', '06', '725', 'J', '120.156871', '23.199543');
INSERT INTO `hup_region` VALUES (3439, 3416, '北门', '北门区', '中国,台湾省,台南市,北门区', 3, 'beimen', '06', '727', 'B', '120.125821', '23.267148');
INSERT INTO `hup_region` VALUES (3440, 3416, '新化', '新化区', '中国,台湾省,台南市,新化区', 3, 'xinhua', '06', '712', 'X', '120.310807', '23.038533');
INSERT INTO `hup_region` VALUES (3441, 3416, '善化', '善化区', '中国,台湾省,台南市,善化区', 3, 'shanhua', '06', '741', 'S', '120.296895', '23.132261');
INSERT INTO `hup_region` VALUES (3442, 3416, '新市', '新市区', '中国,台湾省,台南市,新市区', 3, 'xinshi', '06', '744', 'X', '120.295138', '23.07897');
INSERT INTO `hup_region` VALUES (3443, 3416, '安定', '安定区', '中国,台湾省,台南市,安定区', 3, 'anding', '06', '745', 'A', '120.237083', '23.121498');
INSERT INTO `hup_region` VALUES (3444, 3416, '山上', '山上区', '中国,台湾省,台南市,山上区', 3, 'shanshang', '06', '743', 'S', '120.352908', '23.103223');
INSERT INTO `hup_region` VALUES (3445, 3416, '玉井', '玉井区', '中国,台湾省,台南市,玉井区', 3, 'yujing', '06', '714', 'Y', '120.460110', '23.123859');
INSERT INTO `hup_region` VALUES (3446, 3416, '楠西', '楠西区', '中国,台湾省,台南市,楠西区', 3, 'nanxi', '06', '715', NULL, '120.485396', '23.173454');
INSERT INTO `hup_region` VALUES (3447, 3416, '南化', '南化区', '中国,台湾省,台南市,南化区', 3, 'nanhua', '06', '716', 'N', '120.477116', '23.042614');
INSERT INTO `hup_region` VALUES (3448, 3416, '左镇', '左镇区', '中国,台湾省,台南市,左镇区', 3, 'zuozhen', '06', '713', 'Z', '120.407309', '23.057955');
INSERT INTO `hup_region` VALUES (3449, 3416, '仁德', '仁德区', '中国,台湾省,台南市,仁德区', 3, 'rende', '06', '717', 'R', '120.251520', '22.972212');
INSERT INTO `hup_region` VALUES (3450, 3416, '归仁', '归仁区', '中国,台湾省,台南市,归仁区', 3, 'guiren', '06', '711', 'G', '120.293791', '22.967081');
INSERT INTO `hup_region` VALUES (3451, 3416, '关庙', '关庙区', '中国,台湾省,台南市,关庙区', 3, 'guanmiao', '06', '718', 'G', '120.327689', '22.962949');
INSERT INTO `hup_region` VALUES (3452, 3416, '龙崎', '龙崎区', '中国,台湾省,台南市,龙崎区', 3, 'longqi', '06', '719', 'L', '120.360824', '22.965681');
INSERT INTO `hup_region` VALUES (3453, 3416, '永康', '永康区', '中国,台湾省,台南市,永康区', 3, 'yongkang', '06', '710', 'Y', '120.257069', '23.026061');
INSERT INTO `hup_region` VALUES (3454, 3325, '新竹', '新竹市', '中国,台湾省,新竹市', 2, 'hsinchu', '03', '3', 'X', '120.968798', '24.806738');
INSERT INTO `hup_region` VALUES (3455, 3454, '东区', '东区', '中国,台湾省,新竹市,东区', 3, 'dongqu', '03', '300', 'D', '120.970239', '24.801337');
INSERT INTO `hup_region` VALUES (3456, 3454, '北区', '北区', '中国,台湾省,新竹市,北区', 3, 'beiqu', '03', '', 'B', '120.682410', '24.166040');
INSERT INTO `hup_region` VALUES (3457, 3454, '香山', '香山区', '中国,台湾省,新竹市,香山区', 3, 'xiangshan', '03', '', 'X', '120.956679', '24.768933');
INSERT INTO `hup_region` VALUES (3458, 3325, '嘉义', '嘉义市', '中国,台湾省,嘉义市', 2, 'chiayi', '05', '6', 'J', '120.452538', '23.481568');
INSERT INTO `hup_region` VALUES (3459, 3458, '东区', '东区', '中国,台湾省,嘉义市,东区', 3, 'dongqu', '05', '600', 'D', '120.458009', '23.486213');
INSERT INTO `hup_region` VALUES (3460, 3458, '西区', '西区', '中国,台湾省,嘉义市,西区', 3, 'xiqu', '05', '600', 'X', '120.437493', '23.473029');
INSERT INTO `hup_region` VALUES (3461, 3325, '新北', '新北市', '中国,台湾省,新北市', 2, 'newtaipei', '02', '2', 'X', '121.465746', '25.012366');
INSERT INTO `hup_region` VALUES (3462, 3461, '板桥', '板桥区', '中国,台湾省,新北市,板桥区', 3, 'banqiao', '02', '220', 'B', '121.459084', '25.009578');
INSERT INTO `hup_region` VALUES (3463, 3461, '三重', '三重区', '中国,台湾省,新北市,三重区', 3, 'sanzhong', '02', '241', 'S', '121.488102', '25.061486');
INSERT INTO `hup_region` VALUES (3464, 3461, '中和', '中和区', '中国,台湾省,新北市,中和区', 3, 'zhonghe', '02', '235', 'Z', '121.498980', '24.999397');
INSERT INTO `hup_region` VALUES (3465, 3461, '永和', '永和区', '中国,台湾省,新北市,永和区', 3, 'yonghe', '02', '234', 'Y', '121.513660', '25.007802');
INSERT INTO `hup_region` VALUES (3466, 3461, '新庄', '新庄区', '中国,台湾省,新北市,新庄区', 3, 'xinzhuang', '02', '242', 'X', '121.450413', '25.035947');
INSERT INTO `hup_region` VALUES (3467, 3461, '新店', '新店区', '中国,台湾省,新北市,新店区', 3, 'xindian', '02', '231', 'X', '121.541750', '24.967558');
INSERT INTO `hup_region` VALUES (3468, 3461, '树林', '树林区', '中国,台湾省,新北市,树林区', 3, 'shulin', '02', '238', 'S', '121.420533', '24.990706');
INSERT INTO `hup_region` VALUES (3469, 3461, '莺歌', '莺歌区', '中国,台湾省,新北市,莺歌区', 3, 'yingge', '02', '239', NULL, '121.354573', '24.955413');
INSERT INTO `hup_region` VALUES (3470, 3461, '三峡', '三峡区', '中国,台湾省,新北市,三峡区', 3, 'sanxia', '02', '237', 'S', '121.368905', '24.934339');
INSERT INTO `hup_region` VALUES (3471, 3461, '淡水', '淡水区', '中国,台湾省,新北市,淡水区', 3, 'danshui', '02', '251', 'D', '121.440915', '25.169452');
INSERT INTO `hup_region` VALUES (3472, 3461, '汐止', '汐止区', '中国,台湾省,新北市,汐止区', 3, 'xizhi', '02', '221', 'X', '121.629470', '25.062999');
INSERT INTO `hup_region` VALUES (3473, 3461, '瑞芳', '瑞芳区', '中国,台湾省,新北市,瑞芳区', 3, 'ruifang', '02', '224', 'R', '121.810061', '25.108895');
INSERT INTO `hup_region` VALUES (3474, 3461, '土城', '土城区', '中国,台湾省,新北市,土城区', 3, 'tucheng', '02', '236', 'T', '121.443348', '24.972201');
INSERT INTO `hup_region` VALUES (3475, 3461, '芦洲', '芦洲区', '中国,台湾省,新北市,芦洲区', 3, 'luzhou', '02', '247', 'L', '121.473700', '25.084923');
INSERT INTO `hup_region` VALUES (3476, 3461, '五股', '五股区', '中国,台湾省,新北市,五股区', 3, 'wugu', '02', '248', 'W', '121.438156', '25.082743');
INSERT INTO `hup_region` VALUES (3477, 3461, '泰山', '泰山区', '中国,台湾省,新北市,泰山区', 3, 'taishan', '02', '243', 'T', '121.430811', '25.058864');
INSERT INTO `hup_region` VALUES (3478, 3461, '林口', '林口区', '中国,台湾省,新北市,林口区', 3, 'linkou', '02', '244', 'L', '121.391602', '25.077531');
INSERT INTO `hup_region` VALUES (3479, 3461, '深坑', '深坑区', '中国,台湾省,新北市,深坑区', 3, 'shenkeng', '02', '222', 'S', '121.615670', '25.002329');
INSERT INTO `hup_region` VALUES (3480, 3461, '石碇', '石碇区', '中国,台湾省,新北市,石碇区', 3, 'shiding', '02', '223', 'S', '121.658567', '24.991679');
INSERT INTO `hup_region` VALUES (3481, 3461, '坪林', '坪林区', '中国,台湾省,新北市,坪林区', 3, 'pinglin', '02', '232', 'P', '121.711185', '24.937388');
INSERT INTO `hup_region` VALUES (3482, 3461, '三芝', '三芝区', '中国,台湾省,新北市,三芝区', 3, 'sanzhi', '02', '252', 'S', '121.500866', '25.258047');
INSERT INTO `hup_region` VALUES (3483, 3461, '石门', '石门区', '中国,台湾省,新北市,石门区', 3, 'shimen', '02', '253', 'S', '121.568491', '25.290412');
INSERT INTO `hup_region` VALUES (3484, 3461, '八里', '八里区', '中国,台湾省,新北市,八里区', 3, 'bali', '02', '249', 'B', '121.398227', '25.146680');
INSERT INTO `hup_region` VALUES (3485, 3461, '平溪', '平溪区', '中国,台湾省,新北市,平溪区', 3, 'pingxi', '02', '226', 'P', '121.738255', '25.025725');
INSERT INTO `hup_region` VALUES (3486, 3461, '双溪', '双溪区', '中国,台湾省,新北市,双溪区', 3, 'shuangxi', '02', '227', 'S', '121.865676', '25.033409');
INSERT INTO `hup_region` VALUES (3487, 3461, '贡寮', '贡寮区', '中国,台湾省,新北市,贡寮区', 3, 'gongliao', '02', '228', 'G', '121.908185', '25.022388');
INSERT INTO `hup_region` VALUES (3488, 3461, '金山', '金山区', '中国,台湾省,新北市,金山区', 3, 'jinshan', '02', '208', 'J', '121.636427', '25.221883');
INSERT INTO `hup_region` VALUES (3489, 3461, '万里', '万里区', '中国,台湾省,新北市,万里区', 3, 'wanli', '02', '207', 'W', '121.688687', '25.181234');
INSERT INTO `hup_region` VALUES (3490, 3461, '乌来', '乌来区', '中国,台湾省,新北市,乌来区', 3, 'wulai', '02', '233', 'W', '121.550531', '24.865296');
INSERT INTO `hup_region` VALUES (3491, 3325, '宜兰', '宜兰县', '中国,台湾省,宜兰县', 2, 'yilan', '03', '2', 'Y', '121.500000', '24.600000');
INSERT INTO `hup_region` VALUES (3492, 3491, '宜兰', '宜兰市', '中国,台湾省,宜兰县,宜兰市', 3, 'yilan', '03', '260', 'Y', '121.753476', '24.751682');
INSERT INTO `hup_region` VALUES (3493, 3491, '罗东', '罗东镇', '中国,台湾省,宜兰县,罗东镇', 3, 'luodong', '03', '265', 'L', '121.766919', '24.677033');
INSERT INTO `hup_region` VALUES (3494, 3491, '苏澳', '苏澳镇', '中国,台湾省,宜兰县,苏澳镇', 3, 'suao', '03', '270', 'S', '121.842656', '24.594622');
INSERT INTO `hup_region` VALUES (3495, 3491, '头城', '头城镇', '中国,台湾省,宜兰县,头城镇', 3, 'toucheng', '03', '261', 'T', '121.823307', '24.859217');
INSERT INTO `hup_region` VALUES (3496, 3491, '礁溪', '礁溪乡', '中国,台湾省,宜兰县,礁溪乡', 3, 'jiaoxi', '03', '262', 'J', '121.766680', '24.822345');
INSERT INTO `hup_region` VALUES (3497, 3491, '壮围', '壮围乡', '中国,台湾省,宜兰县,壮围乡', 3, 'zhuangwei', '03', '263', 'Z', '121.781619', '24.744949');
INSERT INTO `hup_region` VALUES (3498, 3491, '员山', '员山乡', '中国,台湾省,宜兰县,员山乡', 3, 'yuanshan', '03', '264', 'Y', '121.721733', '24.741771');
INSERT INTO `hup_region` VALUES (3499, 3491, '冬山', '冬山乡', '中国,台湾省,宜兰县,冬山乡', 3, 'dongshan', '03', '269', 'D', '121.792280', '24.634514');
INSERT INTO `hup_region` VALUES (3500, 3491, '五结', '五结乡', '中国,台湾省,宜兰县,五结乡', 3, 'wujie', '03', '268', 'W', '121.798297', '24.684640');
INSERT INTO `hup_region` VALUES (3501, 3491, '三星', '三星乡', '中国,台湾省,宜兰县,三星乡', 3, 'sanxing', '03', '266', 'S', '121.003418', '23.775291');
INSERT INTO `hup_region` VALUES (3502, 3491, '大同', '大同乡', '中国,台湾省,宜兰县,大同乡', 3, 'datong', '03', '267', 'D', '121.605557', '24.675997');
INSERT INTO `hup_region` VALUES (3503, 3491, '南澳', '南澳乡', '中国,台湾省,宜兰县,南澳乡', 3, 'nanao', '03', '272', 'N', '121.799810', '24.465393');
INSERT INTO `hup_region` VALUES (3504, 3325, '桃园', '桃园县', '中国,台湾省,桃园县', 2, 'taoyuan', '03', '3', 'T', '121.083000', '25.000000');
INSERT INTO `hup_region` VALUES (3505, 3504, '桃园', '桃园市', '中国,台湾省,桃园县,桃园市', 3, 'taoyuan', '03', '330', 'T', '121.301337', '24.993777');
INSERT INTO `hup_region` VALUES (3506, 3504, '中坜', '中坜市', '中国,台湾省,桃园县,中坜市', 3, 'zhongli', '03', '320', 'Z', '121.224926', '24.965353');
INSERT INTO `hup_region` VALUES (3507, 3504, '平镇', '平镇市', '中国,台湾省,桃园县,平镇市', 3, 'pingzhen', '03', '324', 'P', '121.218359', '24.945752');
INSERT INTO `hup_region` VALUES (3508, 3504, '八德', '八德市', '中国,台湾省,桃园县,八德市', 3, 'bade', '03', '334', 'B', '121.284655', '24.928651');
INSERT INTO `hup_region` VALUES (3509, 3504, '杨梅', '杨梅市', '中国,台湾省,桃园县,杨梅市', 3, 'yangmei', '03', '326', 'Y', '121.145873', '24.907575');
INSERT INTO `hup_region` VALUES (3510, 3504, '芦竹', '芦竹市', '中国,台湾省,桃园县,芦竹市', 3, 'luzhu', '03', '338', 'L', '121.292064', '25.045392');
INSERT INTO `hup_region` VALUES (3511, 3504, '大溪', '大溪镇', '中国,台湾省,桃园县,大溪镇', 3, 'daxi', '03', '335', 'D', '121.286962', '24.880584');
INSERT INTO `hup_region` VALUES (3512, 3504, '大园', '大园乡', '中国,台湾省,桃园县,大园乡', 3, 'dayuan', '03', '337', 'D', '121.196292', '25.064471');
INSERT INTO `hup_region` VALUES (3513, 3504, '龟山', '龟山乡', '中国,台湾省,桃园县,龟山乡', 3, 'guishan', '03', '333', 'G', '121.337767', '24.992517');
INSERT INTO `hup_region` VALUES (3514, 3504, '龙潭', '龙潭乡', '中国,台湾省,桃园县,龙潭乡', 3, 'longtan', '03', '325', 'L', '121.216392', '24.863851');
INSERT INTO `hup_region` VALUES (3515, 3504, '新屋', '新屋乡', '中国,台湾省,桃园县,新屋乡', 3, 'xinwu', '03', '327', 'X', '121.105801', '24.972203');
INSERT INTO `hup_region` VALUES (3516, 3504, '观音', '观音乡', '中国,台湾省,桃园县,观音乡', 3, 'guanyin', '03', '328', 'G', '121.077519', '25.033303');
INSERT INTO `hup_region` VALUES (3517, 3504, '复兴', '复兴乡', '中国,台湾省,桃园县,复兴乡', 3, 'fuxing', '03', '336', 'F', '121.352613', '24.820908');
INSERT INTO `hup_region` VALUES (3518, 3325, '新竹', '新竹县', '中国,台湾省,新竹县', 2, 'hsinchu', '03', '3', 'X', '121.160000', '24.600000');
INSERT INTO `hup_region` VALUES (3519, 3518, '竹北', '竹北市', '中国,台湾省,新竹县,竹北市', 3, 'zhubei', '03', '302', 'Z', '121.004317', '24.839652');
INSERT INTO `hup_region` VALUES (3520, 3518, '竹东', '竹东镇', '中国,台湾省,新竹县,竹东镇', 3, 'zhudong', '03', '310', 'Z', '121.086418', '24.733601');
INSERT INTO `hup_region` VALUES (3521, 3518, '新埔', '新埔镇', '中国,台湾省,新竹县,新埔镇', 3, 'xinpu', '03', '305', 'X', '121.072804', '24.824820');
INSERT INTO `hup_region` VALUES (3522, 3518, '关西', '关西镇', '中国,台湾省,新竹县,关西镇', 3, 'guanxi', '03', '306', 'G', '121.177301', '24.788842');
INSERT INTO `hup_region` VALUES (3523, 3518, '湖口', '湖口乡', '中国,台湾省,新竹县,湖口乡', 3, 'hukou', '03', '303', 'H', '121.043691', '24.903943');
INSERT INTO `hup_region` VALUES (3524, 3518, '新丰', '新丰乡', '中国,台湾省,新竹县,新丰乡', 3, 'xinfeng', '03', '304', 'X', '120.983006', '24.899600');
INSERT INTO `hup_region` VALUES (3525, 3518, '芎林', '芎林乡', '中国,台湾省,新竹县,芎林乡', 3, 'xionglin', '03', '307', NULL, '121.076924', '24.774436');
INSERT INTO `hup_region` VALUES (3526, 3518, '横山', '横山乡', '中国,台湾省,新竹县,横山乡', 3, 'hengshan', '03', '312', 'H', '121.116244', '24.720807');
INSERT INTO `hup_region` VALUES (3527, 3518, '北埔', '北埔乡', '中国,台湾省,新竹县,北埔乡', 3, 'beipu', '03', '314', 'B', '121.053156', '24.697126');
INSERT INTO `hup_region` VALUES (3528, 3518, '宝山', '宝山乡', '中国,台湾省,新竹县,宝山乡', 3, 'baoshan', '03', '308', 'B', '120.985752', '24.760975');
INSERT INTO `hup_region` VALUES (3529, 3518, '峨眉', '峨眉乡', '中国,台湾省,新竹县,峨眉乡', 3, 'emei', '03', '315', 'E', '121.015291', '24.686127');
INSERT INTO `hup_region` VALUES (3530, 3518, '尖石', '尖石乡', '中国,台湾省,新竹县,尖石乡', 3, 'jianshi', '03', '313', 'J', '121.197802', '24.704360');
INSERT INTO `hup_region` VALUES (3531, 3518, '五峰', '五峰乡', '中国,台湾省,新竹县,五峰乡', 3, 'wufeng', '03', '311', 'W', '121.003418', '23.775291');
INSERT INTO `hup_region` VALUES (3532, 3325, '苗栗', '苗栗县', '中国,台湾省,苗栗县', 2, 'miaoli', '037', '3', 'M', '120.750000', '24.500000');
INSERT INTO `hup_region` VALUES (3533, 3532, '苗栗', '苗栗市', '中国,台湾省,苗栗县,苗栗市', 3, 'miaoli', '037', '360', 'M', '120.818869', '24.561472');
INSERT INTO `hup_region` VALUES (3534, 3532, '苑里', '苑里镇', '中国,台湾省,苗栗县,苑里镇', 3, 'yuanli', '037', '358', 'Y', '120.648907', '24.441750');
INSERT INTO `hup_region` VALUES (3535, 3532, '通霄', '通霄镇', '中国,台湾省,苗栗县,通霄镇', 3, 'tongxiao', '037', '357', 'T', '120.676700', '24.489087');
INSERT INTO `hup_region` VALUES (3536, 3532, '竹南', '竹南镇', '中国,台湾省,苗栗县,竹南镇', 3, 'zhunan', '037', '350', 'Z', '120.872641', '24.685513');
INSERT INTO `hup_region` VALUES (3537, 3532, '头份', '头份镇', '中国,台湾省,苗栗县,头份镇', 3, 'toufen', '037', '351', 'T', '120.895188', '24.687993');
INSERT INTO `hup_region` VALUES (3538, 3532, '后龙', '后龙镇', '中国,台湾省,苗栗县,后龙镇', 3, 'houlong', '037', '356', 'H', '120.786480', '24.612617');
INSERT INTO `hup_region` VALUES (3539, 3532, '卓兰', '卓兰镇', '中国,台湾省,苗栗县,卓兰镇', 3, 'zhuolan', '037', '369', 'Z', '120.823441', '24.309509');
INSERT INTO `hup_region` VALUES (3540, 3532, '大湖', '大湖乡', '中国,台湾省,苗栗县,大湖乡', 3, 'dahu', '037', '364', 'D', '120.863641', '24.422547');
INSERT INTO `hup_region` VALUES (3541, 3532, '公馆', '公馆乡', '中国,台湾省,苗栗县,公馆乡', 3, 'gongguan', '037', '363', 'G', '120.822983', '24.499108');
INSERT INTO `hup_region` VALUES (3542, 3532, '铜锣', '铜锣乡', '中国,台湾省,苗栗县,铜锣乡', 3, 'tongluo', '037', '366', 'T', '121.003418', '23.775291');
INSERT INTO `hup_region` VALUES (3543, 3532, '南庄', '南庄乡', '中国,台湾省,苗栗县,南庄乡', 3, 'nanzhuang', '037', '353', 'N', '120.994957', '24.596835');
INSERT INTO `hup_region` VALUES (3544, 3532, '头屋', '头屋乡', '中国,台湾省,苗栗县,头屋乡', 3, 'touwu', '037', '362', 'T', '120.846616', '24.574249');
INSERT INTO `hup_region` VALUES (3545, 3532, '三义', '三义乡', '中国,台湾省,苗栗县,三义乡', 3, 'sanyi', '037', '367', 'S', '120.742340', '24.350270');
INSERT INTO `hup_region` VALUES (3546, 3532, '西湖', '西湖乡', '中国,台湾省,苗栗县,西湖乡', 3, 'xihu', '037', '368', 'X', '121.003418', '23.775291');
INSERT INTO `hup_region` VALUES (3547, 3532, '造桥', '造桥乡', '中国,台湾省,苗栗县,造桥乡', 3, 'zaoqiao', '037', '361', 'Z', '120.862399', '24.637537');
INSERT INTO `hup_region` VALUES (3548, 3532, '三湾', '三湾乡', '中国,台湾省,苗栗县,三湾乡', 3, 'sanwan', '037', '352', 'S', '120.951484', '24.651051');
INSERT INTO `hup_region` VALUES (3549, 3532, '狮潭', '狮潭乡', '中国,台湾省,苗栗县,狮潭乡', 3, 'shitan', '037', '354', 'S', '120.918024', '24.540004');
INSERT INTO `hup_region` VALUES (3550, 3532, '泰安', '泰安乡', '中国,台湾省,苗栗县,泰安乡', 3, 'tai\'an', '037', '365', 'T', '120.904441', '24.442600');
INSERT INTO `hup_region` VALUES (3551, 3325, '彰化', '彰化县', '中国,台湾省,彰化县', 2, 'changhua', '04', '5', 'Z', '120.416000', '24.000000');
INSERT INTO `hup_region` VALUES (3552, 3551, '彰化市', '彰化市', '中国,台湾省,彰化县,彰化市', 3, 'zhanghuashi', '04', '500', 'Z', '120.542294', '24.080911');
INSERT INTO `hup_region` VALUES (3553, 3551, '鹿港', '鹿港镇', '中国,台湾省,彰化县,鹿港镇', 3, 'lugang', '04', '505', 'L', '120.435392', '24.056937');
INSERT INTO `hup_region` VALUES (3554, 3551, '和美', '和美镇', '中国,台湾省,彰化县,和美镇', 3, 'hemei', '04', '508', 'H', '120.500265', '24.110904');
INSERT INTO `hup_region` VALUES (3555, 3551, '线西', '线西乡', '中国,台湾省,彰化县,线西乡', 3, 'xianxi', '04', '507', 'X', '120.465921', '24.128653');
INSERT INTO `hup_region` VALUES (3556, 3551, '伸港', '伸港乡', '中国,台湾省,彰化县,伸港乡', 3, 'shengang', '04', '509', 'S', '120.484224', '24.146081');
INSERT INTO `hup_region` VALUES (3557, 3551, '福兴', '福兴乡', '中国,台湾省,彰化县,福兴乡', 3, 'fuxing', '04', '506', 'F', '120.443682', '24.047883');
INSERT INTO `hup_region` VALUES (3558, 3551, '秀水', '秀水乡', '中国,台湾省,彰化县,秀水乡', 3, 'xiushui', '04', '504', 'X', '120.502658', '24.035267');
INSERT INTO `hup_region` VALUES (3559, 3551, '花坛', '花坛乡', '中国,台湾省,彰化县,花坛乡', 3, 'huatan', '04', '503', 'H', '120.538403', '24.029399');
INSERT INTO `hup_region` VALUES (3560, 3551, '芬园', '芬园乡', '中国,台湾省,彰化县,芬园乡', 3, 'fenyuan', '04', '502', 'F', '120.629024', '24.013658');
INSERT INTO `hup_region` VALUES (3561, 3551, '员林', '员林镇', '中国,台湾省,彰化县,员林镇', 3, 'yuanlin', '04', '510', 'Y', '120.574625', '23.958999');
INSERT INTO `hup_region` VALUES (3562, 3551, '溪湖', '溪湖镇', '中国,台湾省,彰化县,溪湖镇', 3, 'xihu', '04', '514', 'X', '120.479144', '23.962315');
INSERT INTO `hup_region` VALUES (3563, 3551, '田中', '田中镇', '中国,台湾省,彰化县,田中镇', 3, 'tianzhong', '04', '520', 'T', '120.580629', '23.861718');
INSERT INTO `hup_region` VALUES (3564, 3551, '大村', '大村乡', '中国,台湾省,彰化县,大村乡', 3, 'dacun', '04', '515', 'D', '120.540713', '23.993726');
INSERT INTO `hup_region` VALUES (3565, 3551, '埔盐', '埔盐乡', '中国,台湾省,彰化县,埔盐乡', 3, 'puyan', '04', '516', 'P', '120.464044', '24.000346');
INSERT INTO `hup_region` VALUES (3566, 3551, '埔心', '埔心乡', '中国,台湾省,彰化县,埔心乡', 3, 'puxin', '04', '513', 'P', '120.543568', '23.953019');
INSERT INTO `hup_region` VALUES (3567, 3551, '永靖', '永靖乡', '中国,台湾省,彰化县,永靖乡', 3, 'yongjing', '04', '512', 'Y', '120.547775', '23.924703');
INSERT INTO `hup_region` VALUES (3568, 3551, '社头', '社头乡', '中国,台湾省,彰化县,社头乡', 3, 'shetou', '04', '511', 'S', '120.582681', '23.896686');
INSERT INTO `hup_region` VALUES (3569, 3551, '二水', '二水乡', '中国,台湾省,彰化县,二水乡', 3, 'ershui', '04', '530', 'E', '120.618788', '23.806995');
INSERT INTO `hup_region` VALUES (3570, 3551, '北斗', '北斗镇', '中国,台湾省,彰化县,北斗镇', 3, 'beidou', '04', '521', 'B', '120.520449', '23.870911');
INSERT INTO `hup_region` VALUES (3571, 3551, '二林', '二林镇', '中国,台湾省,彰化县,二林镇', 3, 'erlin', '04', '526', 'E', '120.374468', '23.899751');
INSERT INTO `hup_region` VALUES (3572, 3551, '田尾', '田尾乡', '中国,台湾省,彰化县,田尾乡', 3, 'tianwei', '04', '522', 'T', '120.524717', '23.890735');
INSERT INTO `hup_region` VALUES (3573, 3551, '埤头', '埤头乡', '中国,台湾省,彰化县,埤头乡', 3, 'pitou', '04', '523', NULL, '120.462599', '23.891324');
INSERT INTO `hup_region` VALUES (3574, 3551, '芳苑', '芳苑乡', '中国,台湾省,彰化县,芳苑乡', 3, 'fangyuan', '04', '528', 'F', '120.320329', '23.924222');
INSERT INTO `hup_region` VALUES (3575, 3551, '大城', '大城乡', '中国,台湾省,彰化县,大城乡', 3, 'dacheng', '04', '527', 'D', '120.320934', '23.852382');
INSERT INTO `hup_region` VALUES (3576, 3551, '竹塘', '竹塘乡', '中国,台湾省,彰化县,竹塘乡', 3, 'zhutang', '04', '525', 'Z', '120.427499', '23.860112');
INSERT INTO `hup_region` VALUES (3577, 3551, '溪州', '溪州乡', '中国,台湾省,彰化县,溪州乡', 3, 'xizhou', '04', '524', 'X', '120.498706', '23.851229');
INSERT INTO `hup_region` VALUES (3578, 3325, '南投', '南投县', '中国,台湾省,南投县', 2, 'nantou', '049', '5', 'N', '120.830000', '23.830000');
INSERT INTO `hup_region` VALUES (3579, 3578, '南投市', '南投市', '中国,台湾省,南投县,南投市', 3, 'nantoushi', '049', '540', 'N', '120.683706', '23.909956');
INSERT INTO `hup_region` VALUES (3580, 3578, '埔里', '埔里镇', '中国,台湾省,南投县,埔里镇', 3, 'puli', '049', '545', 'P', '120.964648', '23.964789');
INSERT INTO `hup_region` VALUES (3581, 3578, '草屯', '草屯镇', '中国,台湾省,南投县,草屯镇', 3, 'caotun', '049', '542', 'C', '120.680343', '23.973947');
INSERT INTO `hup_region` VALUES (3582, 3578, '竹山', '竹山镇', '中国,台湾省,南投县,竹山镇', 3, 'zhushan', '049', '557', 'Z', '120.672007', '23.757655');
INSERT INTO `hup_region` VALUES (3583, 3578, '集集', '集集镇', '中国,台湾省,南投县,集集镇', 3, 'jiji', '049', '552', 'J', '120.783673', '23.829013');
INSERT INTO `hup_region` VALUES (3584, 3578, '名间', '名间乡', '中国,台湾省,南投县,名间乡', 3, 'mingjian', '049', '551', 'M', '120.702797', '23.838427');
INSERT INTO `hup_region` VALUES (3585, 3578, '鹿谷', '鹿谷乡', '中国,台湾省,南投县,鹿谷乡', 3, 'lugu', '049', '558', 'L', '120.752796', '23.744471');
INSERT INTO `hup_region` VALUES (3586, 3578, '中寮', '中寮乡', '中国,台湾省,南投县,中寮乡', 3, 'zhongliao', '049', '541', 'Z', '120.766654', '23.878935');
INSERT INTO `hup_region` VALUES (3587, 3578, '鱼池', '鱼池乡', '中国,台湾省,南投县,鱼池乡', 3, 'yuchi', '049', '555', 'Y', '120.936060', '23.896356');
INSERT INTO `hup_region` VALUES (3588, 3578, '国姓', '国姓乡', '中国,台湾省,南投县,国姓乡', 3, 'guoxing', '049', '544', 'G', '120.858541', '24.042298');
INSERT INTO `hup_region` VALUES (3589, 3578, '水里', '水里乡', '中国,台湾省,南投县,水里乡', 3, 'shuili', '049', '553', 'S', '120.855912', '23.812086');
INSERT INTO `hup_region` VALUES (3590, 3578, '信义', '信义乡', '中国,台湾省,南投县,信义乡', 3, 'xinyi', '049', '556', 'X', '120.855257', '23.699922');
INSERT INTO `hup_region` VALUES (3591, 3578, '仁爱', '仁爱乡', '中国,台湾省,南投县,仁爱乡', 3, 'renai', '049', '546', 'R', '121.133543', '24.024429');
INSERT INTO `hup_region` VALUES (3592, 3325, '云林', '云林县', '中国,台湾省,云林县', 2, 'yunlin', '05', '6', 'Y', '120.250000', '23.750000');
INSERT INTO `hup_region` VALUES (3593, 3592, '斗六', '斗六市', '中国,台湾省,云林县,斗六市', 3, 'douliu', '05', '640', 'D', '120.527360', '23.697651');
INSERT INTO `hup_region` VALUES (3594, 3592, '斗南', '斗南镇', '中国,台湾省,云林县,斗南镇', 3, 'dounan', '05', '630', 'D', '120.479075', '23.679731');
INSERT INTO `hup_region` VALUES (3595, 3592, '虎尾', '虎尾镇', '中国,台湾省,云林县,虎尾镇', 3, 'huwei', '05', '632', 'H', '120.445339', '23.708182');
INSERT INTO `hup_region` VALUES (3596, 3592, '西螺', '西螺镇', '中国,台湾省,云林县,西螺镇', 3, 'xiluo', '05', '648', 'X', '120.466010', '23.797984');
INSERT INTO `hup_region` VALUES (3597, 3592, '土库', '土库镇', '中国,台湾省,云林县,土库镇', 3, 'tuku', '05', '633', 'T', '120.392572', '23.677822');
INSERT INTO `hup_region` VALUES (3598, 3592, '北港', '北港镇', '中国,台湾省,云林县,北港镇', 3, 'beigang', '05', '651', 'B', '120.302393', '23.575525');
INSERT INTO `hup_region` VALUES (3599, 3592, '古坑', '古坑乡', '中国,台湾省,云林县,古坑乡', 3, 'gukeng', '05', '646', 'G', '120.562043', '23.642568');
INSERT INTO `hup_region` VALUES (3600, 3592, '大埤', '大埤乡', '中国,台湾省,云林县,大埤乡', 3, 'dapi', '05', '631', 'D', '120.430516', '23.645908');
INSERT INTO `hup_region` VALUES (3601, 3592, '莿桐', '莿桐乡', '中国,台湾省,云林县,莿桐乡', 3, 'citong', '05', '647', NULL, '120.502374', '23.760784');
INSERT INTO `hup_region` VALUES (3602, 3592, '林内', '林内乡', '中国,台湾省,云林县,林内乡', 3, 'linna', '05', '643', 'L', '120.611365', '23.758712');
INSERT INTO `hup_region` VALUES (3603, 3592, '二仑', '二仑乡', '中国,台湾省,云林县,二仑乡', 3, 'erlun', '05', '649', 'E', '120.415077', '23.771273');
INSERT INTO `hup_region` VALUES (3604, 3592, '仑背', '仑背乡', '中国,台湾省,云林县,仑背乡', 3, 'lunbei', '05', '637', 'L', '120.353895', '23.758840');
INSERT INTO `hup_region` VALUES (3605, 3592, '麦寮', '麦寮乡', '中国,台湾省,云林县,麦寮乡', 3, 'mailiao', '05', '638', 'M', '120.252043', '23.753841');
INSERT INTO `hup_region` VALUES (3606, 3592, '东势', '东势乡', '中国,台湾省,云林县,东势乡', 3, 'dongshi', '05', '635', 'D', '120.252672', '23.674679');
INSERT INTO `hup_region` VALUES (3607, 3592, '褒忠', '褒忠乡', '中国,台湾省,云林县,褒忠乡', 3, 'baozhong', '05', '634', 'B', '120.310488', '23.694245');
INSERT INTO `hup_region` VALUES (3608, 3592, '台西', '台西乡', '中国,台湾省,云林县,台西乡', 3, 'taixi', '05', '636', 'T', '120.196141', '23.702819');
INSERT INTO `hup_region` VALUES (3609, 3592, '元长', '元长乡', '中国,台湾省,云林县,元长乡', 3, 'yuanchang', '05', '655', 'Y', '120.315124', '23.649458');
INSERT INTO `hup_region` VALUES (3610, 3592, '四湖', '四湖乡', '中国,台湾省,云林县,四湖乡', 3, 'sihu', '05', '654', 'S', '120.225741', '23.637740');
INSERT INTO `hup_region` VALUES (3611, 3592, '口湖', '口湖乡', '中国,台湾省,云林县,口湖乡', 3, 'kouhu', '05', '653', 'K', '120.185370', '23.582406');
INSERT INTO `hup_region` VALUES (3612, 3592, '水林', '水林乡', '中国,台湾省,云林县,水林乡', 3, 'shuilin', '05', '652', 'S', '120.245948', '23.572634');
INSERT INTO `hup_region` VALUES (3613, 3325, '嘉义', '嘉义县', '中国,台湾省,嘉义县', 2, 'chiayi', '05', '6', 'J', '120.300000', '23.500000');
INSERT INTO `hup_region` VALUES (3614, 3613, '太保', '太保市', '中国,台湾省,嘉义县,太保市', 3, 'taibao', '05', '612', 'T', '120.332876', '23.459647');
INSERT INTO `hup_region` VALUES (3615, 3613, '朴子', '朴子市', '中国,台湾省,嘉义县,朴子市', 3, 'puzi', '05', '613', 'P', '120.247014', '23.464961');
INSERT INTO `hup_region` VALUES (3616, 3613, '布袋', '布袋镇', '中国,台湾省,嘉义县,布袋镇', 3, 'budai', '05', '625', 'B', '120.166936', '23.377979');
INSERT INTO `hup_region` VALUES (3617, 3613, '大林', '大林镇', '中国,台湾省,嘉义县,大林镇', 3, 'dalin', '05', '622', 'D', '120.471336', '23.603815');
INSERT INTO `hup_region` VALUES (3618, 3613, '民雄', '民雄乡', '中国,台湾省,嘉义县,民雄乡', 3, 'minxiong', '05', '621', 'M', '120.428577', '23.551456');
INSERT INTO `hup_region` VALUES (3619, 3613, '溪口', '溪口乡', '中国,台湾省,嘉义县,溪口乡', 3, 'xikou', '05', '623', 'X', '120.393822', '23.602223');
INSERT INTO `hup_region` VALUES (3620, 3613, '新港', '新港乡', '中国,台湾省,嘉义县,新港乡', 3, 'xingang', '05', '616', 'X', '120.347647', '23.551806');
INSERT INTO `hup_region` VALUES (3621, 3613, '六脚', '六脚乡', '中国,台湾省,嘉义县,六脚乡', 3, 'liujiao', '05', '615', 'L', '120.291083', '23.493942');
INSERT INTO `hup_region` VALUES (3622, 3613, '东石', '东石乡', '中国,台湾省,嘉义县,东石乡', 3, 'dongshi', '05', '614', 'D', '120.153822', '23.459235');
INSERT INTO `hup_region` VALUES (3623, 3613, '义竹', '义竹乡', '中国,台湾省,嘉义县,义竹乡', 3, 'yizhu', '05', '624', 'Y', '120.243423', '23.336277');
INSERT INTO `hup_region` VALUES (3624, 3613, '鹿草', '鹿草乡', '中国,台湾省,嘉义县,鹿草乡', 3, 'lucao', '05', '611', 'L', '120.308370', '23.410784');
INSERT INTO `hup_region` VALUES (3625, 3613, '水上', '水上乡', '中国,台湾省,嘉义县,水上乡', 3, 'shuishang', '05', '608', 'S', '120.397936', '23.428104');
INSERT INTO `hup_region` VALUES (3626, 3613, '中埔', '中埔乡', '中国,台湾省,嘉义县,中埔乡', 3, 'zhongpu', '05', '606', 'Z', '120.522948', '23.425148');
INSERT INTO `hup_region` VALUES (3627, 3613, '竹崎', '竹崎乡', '中国,台湾省,嘉义县,竹崎乡', 3, 'zhuqi', '05', '604', 'Z', '120.551466', '23.523184');
INSERT INTO `hup_region` VALUES (3628, 3613, '梅山', '梅山乡', '中国,台湾省,嘉义县,梅山乡', 3, 'meishan', '05', '603', 'M', '120.557192', '23.584915');
INSERT INTO `hup_region` VALUES (3629, 3613, '番路', '番路乡', '中国,台湾省,嘉义县,番路乡', 3, 'fanlu', '05', '602', 'F', '120.555043', '23.465222');
INSERT INTO `hup_region` VALUES (3630, 3613, '大埔', '大埔乡', '中国,台湾省,嘉义县,大埔乡', 3, 'dapu', '05', '607', 'D', '120.593795', '23.296715');
INSERT INTO `hup_region` VALUES (3631, 3613, '阿里山', '阿里山乡', '中国,台湾省,嘉义县,阿里山乡', 3, 'alishan', '05', '605', 'A', '120.732520', '23.467950');
INSERT INTO `hup_region` VALUES (3632, 3325, '屏东', '屏东县', '中国,台湾省,屏东县', 2, 'pingtung', '08', '9', 'P', '120.487928', '22.682802');
INSERT INTO `hup_region` VALUES (3633, 3632, '屏东', '屏东市', '中国,台湾省,屏东县,屏东市', 3, 'pingdong', '08', '900', 'P', '120.488465', '22.669723');
INSERT INTO `hup_region` VALUES (3634, 3632, '潮州', '潮州镇', '中国,台湾省,屏东县,潮州镇', 3, 'chaozhou', '08', '920', 'C', '120.542854', '22.550536');
INSERT INTO `hup_region` VALUES (3635, 3632, '东港', '东港镇', '中国,台湾省,屏东县,东港镇', 3, 'donggang', '08', '928', 'D', '120.454489', '22.466626');
INSERT INTO `hup_region` VALUES (3636, 3632, '恒春', '恒春镇', '中国,台湾省,屏东县,恒春镇', 3, 'hengchun', '08', '946', 'H', '120.745451', '22.002373');
INSERT INTO `hup_region` VALUES (3637, 3632, '万丹', '万丹乡', '中国,台湾省,屏东县,万丹乡', 3, 'wandan', '08', '913', 'W', '120.484533', '22.589839');
INSERT INTO `hup_region` VALUES (3638, 3632, '长治', '长治乡', '中国,台湾省,屏东县,长治乡', 3, 'changzhi', '08', '908', 'C', '120.527614', '22.677062');
INSERT INTO `hup_region` VALUES (3639, 3632, '麟洛', '麟洛乡', '中国,台湾省,屏东县,麟洛乡', 3, 'linluo', '08', '909', NULL, '120.527283', '22.650604');
INSERT INTO `hup_region` VALUES (3640, 3632, '九如', '九如乡', '中国,台湾省,屏东县,九如乡', 3, 'jiuru', '08', '904', 'J', '120.490142', '22.739778');
INSERT INTO `hup_region` VALUES (3641, 3632, '里港', '里港乡', '中国,台湾省,屏东县,里港乡', 3, 'ligang', '08', '905', 'L', '120.494490', '22.779220');
INSERT INTO `hup_region` VALUES (3642, 3632, '盐埔', '盐埔乡', '中国,台湾省,屏东县,盐埔乡', 3, 'yanpu', '08', '907', 'Y', '120.572849', '22.754783');
INSERT INTO `hup_region` VALUES (3643, 3632, '高树', '高树乡', '中国,台湾省,屏东县,高树乡', 3, 'gaoshu', '08', '906', 'G', '120.600214', '22.826789');
INSERT INTO `hup_region` VALUES (3644, 3632, '万峦', '万峦乡', '中国,台湾省,屏东县,万峦乡', 3, 'wanluan', '08', '923', 'W', '120.566477', '22.571965');
INSERT INTO `hup_region` VALUES (3645, 3632, '内埔', '内埔乡', '中国,台湾省,屏东县,内埔乡', 3, 'napu', '08', '912', 'N', '120.566865', '22.611967');
INSERT INTO `hup_region` VALUES (3646, 3632, '竹田', '竹田乡', '中国,台湾省,屏东县,竹田乡', 3, 'zhutian', '08', '911', 'Z', '120.544038', '22.584678');
INSERT INTO `hup_region` VALUES (3647, 3632, '新埤', '新埤乡', '中国,台湾省,屏东县,新埤乡', 3, 'xinpi', '08', '925', 'X', '120.549546', '22.469976');
INSERT INTO `hup_region` VALUES (3648, 3632, '枋寮', '枋寮乡', '中国,台湾省,屏东县,枋寮乡', 3, 'fangliao', '08', '940', NULL, '120.593438', '22.365560');
INSERT INTO `hup_region` VALUES (3649, 3632, '新园', '新园乡', '中国,台湾省,屏东县,新园乡', 3, 'xinyuan', '08', '932', 'X', '120.461739', '22.543952');
INSERT INTO `hup_region` VALUES (3650, 3632, '崁顶', '崁顶乡', '中国,台湾省,屏东县,崁顶乡', 3, 'kanding', '08', '924', NULL, '120.514571', '22.514795');
INSERT INTO `hup_region` VALUES (3651, 3632, '林边', '林边乡', '中国,台湾省,屏东县,林边乡', 3, 'linbian', '08', '927', 'L', '120.515091', '22.434015');
INSERT INTO `hup_region` VALUES (3652, 3632, '南州', '南州乡', '中国,台湾省,屏东县,南州乡', 3, 'nanzhou', '08', '926', 'N', '120.509808', '22.490192');
INSERT INTO `hup_region` VALUES (3653, 3632, '佳冬', '佳冬乡', '中国,台湾省,屏东县,佳冬乡', 3, 'jiadong', '08', '931', 'J', '120.551544', '22.417653');
INSERT INTO `hup_region` VALUES (3654, 3632, '琉球', '琉球乡', '中国,台湾省,屏东县,琉球乡', 3, 'liuqiu', '08', '929', 'L', '120.369020', '22.342366');
INSERT INTO `hup_region` VALUES (3655, 3632, '车城', '车城乡', '中国,台湾省,屏东县,车城乡', 3, 'checheng', '08', '944', 'C', '120.710979', '22.072077');
INSERT INTO `hup_region` VALUES (3656, 3632, '满州', '满州乡', '中国,台湾省,屏东县,满州乡', 3, 'manzhou', '08', '947', 'M', '120.838843', '22.020853');
INSERT INTO `hup_region` VALUES (3657, 3632, '枋山', '枋山乡', '中国,台湾省,屏东县,枋山乡', 3, 'fangshan', '08', '941', NULL, '120.656356', '22.260338');
INSERT INTO `hup_region` VALUES (3658, 3632, '三地门', '三地门乡', '中国,台湾省,屏东县,三地门乡', 3, 'sandimen', '08', '901', 'S', '120.654486', '22.713877');
INSERT INTO `hup_region` VALUES (3659, 3632, '雾台', '雾台乡', '中国,台湾省,屏东县,雾台乡', 3, 'wutai', '08', '902', 'W', '120.732318', '22.744877');
INSERT INTO `hup_region` VALUES (3660, 3632, '玛家', '玛家乡', '中国,台湾省,屏东县,玛家乡', 3, 'majia', '08', '903', 'M', '120.644130', '22.706718');
INSERT INTO `hup_region` VALUES (3661, 3632, '泰武', '泰武乡', '中国,台湾省,屏东县,泰武乡', 3, 'taiwu', '08', '921', 'T', '120.632856', '22.591819');
INSERT INTO `hup_region` VALUES (3662, 3632, '来义', '来义乡', '中国,台湾省,屏东县,来义乡', 3, 'laiyi', '08', '922', 'L', '120.633601', '22.525866');
INSERT INTO `hup_region` VALUES (3663, 3632, '春日', '春日乡', '中国,台湾省,屏东县,春日乡', 3, 'chunri', '08', '942', 'C', '120.628793', '22.370672');
INSERT INTO `hup_region` VALUES (3664, 3632, '狮子', '狮子乡', '中国,台湾省,屏东县,狮子乡', 3, 'shizi', '08', '943', 'S', '120.704617', '22.201917');
INSERT INTO `hup_region` VALUES (3665, 3632, '牡丹', '牡丹乡', '中国,台湾省,屏东县,牡丹乡', 3, 'mudan', '08', '945', 'M', '120.770108', '22.125687');
INSERT INTO `hup_region` VALUES (3666, 3325, '台东', '台东县', '中国,台湾省,台东县', 2, 'taitung', '089', '9', 'T', '120.916000', '23.000000');
INSERT INTO `hup_region` VALUES (3667, 3666, '台东', '台东市', '中国,台湾省,台东县,台东市', 3, 'taidong', '089', '950', 'T', '121.145654', '22.756045');
INSERT INTO `hup_region` VALUES (3668, 3666, '成功', '成功镇', '中国,台湾省,台东县,成功镇', 3, 'chenggong', '089', '961', 'C', '121.379571', '23.100223');
INSERT INTO `hup_region` VALUES (3669, 3666, '关山', '关山镇', '中国,台湾省,台东县,关山镇', 3, 'guanshan', '089', '956', 'G', '121.163134', '23.047450');
INSERT INTO `hup_region` VALUES (3670, 3666, '卑南', '卑南乡', '中国,台湾省,台东县,卑南乡', 3, 'beinan', '089', '954', 'B', '121.083503', '22.786039');
INSERT INTO `hup_region` VALUES (3671, 3666, '鹿野', '鹿野乡', '中国,台湾省,台东县,鹿野乡', 3, 'luye', '089', '955', 'L', '121.135982', '22.913951');
INSERT INTO `hup_region` VALUES (3672, 3666, '池上', '池上乡', '中国,台湾省,台东县,池上乡', 3, 'chishang', '089', '958', 'C', '121.215139', '23.122393');
INSERT INTO `hup_region` VALUES (3673, 3666, '东河', '东河乡', '中国,台湾省,台东县,东河乡', 3, 'donghe', '089', '959', 'D', '121.300334', '22.969934');
INSERT INTO `hup_region` VALUES (3674, 3666, '长滨', '长滨乡', '中国,台湾省,台东县,长滨乡', 3, 'changbin', '089', '962', 'C', '121.451522', '23.315041');
INSERT INTO `hup_region` VALUES (3675, 3666, '太麻里', '太麻里乡', '中国,台湾省,台东县,太麻里乡', 3, 'taimali', '089', '963', 'T', '121.007394', '22.615383');
INSERT INTO `hup_region` VALUES (3676, 3666, '大武', '大武乡', '中国,台湾省,台东县,大武乡', 3, 'dawu', '089', '965', 'D', '120.889938', '22.339919');
INSERT INTO `hup_region` VALUES (3677, 3666, '绿岛', '绿岛乡', '中国,台湾省,台东县,绿岛乡', 3, 'lvdao', '089', '951', 'L', '121.492596', '22.661676');
INSERT INTO `hup_region` VALUES (3678, 3666, '海端', '海端乡', '中国,台湾省,台东县,海端乡', 3, 'haiduan', '089', '957', 'H', '121.172008', '23.101074');
INSERT INTO `hup_region` VALUES (3679, 3666, '延平', '延平乡', '中国,台湾省,台东县,延平乡', 3, 'yanping', '089', '953', 'Y', '121.084499', '22.902358');
INSERT INTO `hup_region` VALUES (3680, 3666, '金峰', '金峰乡', '中国,台湾省,台东县,金峰乡', 3, 'jinfeng', '089', '964', 'J', '120.971292', '22.595511');
INSERT INTO `hup_region` VALUES (3681, 3666, '达仁', '达仁乡', '中国,台湾省,台东县,达仁乡', 3, 'daren', '089', '966', 'D', '120.884131', '22.294869');
INSERT INTO `hup_region` VALUES (3682, 3666, '兰屿', '兰屿乡', '中国,台湾省,台东县,兰屿乡', 3, 'lanyu', '089', '952', 'L', '121.532473', '22.056736');
INSERT INTO `hup_region` VALUES (3683, 3325, '花莲', '花莲县', '中国,台湾省,花莲县', 2, 'hualien', '03', '9', 'H', '121.300000', '23.830000');
INSERT INTO `hup_region` VALUES (3684, 3683, '花莲', '花莲市', '中国,台湾省,花莲县,花莲市', 3, 'hualian', '03', '970', 'H', '121.606810', '23.982074');
INSERT INTO `hup_region` VALUES (3685, 3683, '凤林', '凤林镇', '中国,台湾省,花莲县,凤林镇', 3, 'fenglin', '03', '975', 'F', '121.451687', '23.744648');
INSERT INTO `hup_region` VALUES (3686, 3683, '玉里', '玉里镇', '中国,台湾省,花莲县,玉里镇', 3, 'yuli', '03', '981', 'Y', '121.316445', '23.336509');
INSERT INTO `hup_region` VALUES (3687, 3683, '新城', '新城乡', '中国,台湾省,花莲县,新城乡', 3, 'xincheng', '03', '971', 'X', '121.640512', '24.128133');
INSERT INTO `hup_region` VALUES (3688, 3683, '吉安', '吉安乡', '中国,台湾省,花莲县,吉安乡', 3, 'ji\'an', '03', '973', 'J', '121.568005', '23.961635');
INSERT INTO `hup_region` VALUES (3689, 3683, '寿丰', '寿丰乡', '中国,台湾省,花莲县,寿丰乡', 3, 'shoufeng', '03', '974', 'S', '121.508955', '23.870680');
INSERT INTO `hup_region` VALUES (3690, 3683, '光复', '光复乡', '中国,台湾省,花莲县,光复乡', 3, 'guangfu', '03', '976', 'G', '121.423496', '23.669084');
INSERT INTO `hup_region` VALUES (3691, 3683, '丰滨', '丰滨乡', '中国,台湾省,花莲县,丰滨乡', 3, 'fengbin', '03', '977', 'F', '121.518639', '23.597080');
INSERT INTO `hup_region` VALUES (3692, 3683, '瑞穗', '瑞穗乡', '中国,台湾省,花莲县,瑞穗乡', 3, 'ruisui', '03', '978', 'R', '121.375992', '23.496817');
INSERT INTO `hup_region` VALUES (3693, 3683, '富里', '富里乡', '中国,台湾省,花莲县,富里乡', 3, 'fuli', '03', '983', 'F', '121.250124', '23.179984');
INSERT INTO `hup_region` VALUES (3694, 3683, '秀林', '秀林乡', '中国,台湾省,花莲县,秀林乡', 3, 'xiulin', '03', '972', 'X', '121.620381', '24.116642');
INSERT INTO `hup_region` VALUES (3695, 3683, '万荣', '万荣乡', '中国,台湾省,花莲县,万荣乡', 3, 'wanrong', '03', '979', 'W', '121.407493', '23.715346');
INSERT INTO `hup_region` VALUES (3696, 3683, '卓溪', '卓溪乡', '中国,台湾省,花莲县,卓溪乡', 3, 'zhuoxi', '03', '982', 'Z', '121.303422', '23.346369');
INSERT INTO `hup_region` VALUES (3697, 3325, '澎湖', '澎湖县', '中国,台湾省,澎湖县', 2, 'penghu', '06', '8', 'P', '119.566417', '23.569733');
INSERT INTO `hup_region` VALUES (3698, 3697, '马公', '马公市', '中国,台湾省,澎湖县,马公市', 3, 'magong', '06', '880', 'M', '119.566499', '23.565845');
INSERT INTO `hup_region` VALUES (3699, 3697, '湖西', '湖西乡', '中国,台湾省,澎湖县,湖西乡', 3, 'huxi', '06', '885', 'H', '119.659666', '23.583358');
INSERT INTO `hup_region` VALUES (3700, 3697, '白沙', '白沙乡', '中国,台湾省,澎湖县,白沙乡', 3, 'baisha', '06', '884', 'B', '119.597919', '23.666060');
INSERT INTO `hup_region` VALUES (3701, 3697, '西屿', '西屿乡', '中国,台湾省,澎湖县,西屿乡', 3, 'xiyu', '06', '881', 'X', '119.506974', '23.600836');
INSERT INTO `hup_region` VALUES (3702, 3697, '望安', '望安乡', '中国,台湾省,澎湖县,望安乡', 3, 'wang\'an', '06', '882', 'W', '119.500538', '23.357531');
INSERT INTO `hup_region` VALUES (3703, 3697, '七美', '七美乡', '中国,台湾省,澎湖县,七美乡', 3, 'qimei', '06', '883', 'Q', '119.423929', '23.206018');
INSERT INTO `hup_region` VALUES (3704, 3325, '金门', '金门县', '中国,台湾省,金门县', 2, 'jinmen', '082', '8', 'J', '118.317089', '24.432706');
INSERT INTO `hup_region` VALUES (3705, 3704, '金城', '金城镇', '中国,台湾省,金门县,金城镇', 3, 'jincheng', '082', '893', 'J', '118.316667', '24.416667');
INSERT INTO `hup_region` VALUES (3706, 3704, '金湖', '金湖镇', '中国,台湾省,金门县,金湖镇', 3, 'jinhu', '082', '891', 'J', '118.419743', '24.438633');
INSERT INTO `hup_region` VALUES (3707, 3704, '金沙', '金沙镇', '中国,台湾省,金门县,金沙镇', 3, 'jinsha', '082', '890', 'J', '118.427993', '24.481109');
INSERT INTO `hup_region` VALUES (3708, 3704, '金宁', '金宁乡', '中国,台湾省,金门县,金宁乡', 3, 'jinning', '082', '892', 'J', '118.334506', '24.45672');
INSERT INTO `hup_region` VALUES (3709, 3704, '烈屿', '烈屿乡', '中国,台湾省,金门县,烈屿乡', 3, 'lieyu', '082', '894', 'L', '118.247255', '24.433102');
INSERT INTO `hup_region` VALUES (3710, 3704, '乌丘', '乌丘乡', '中国,台湾省,金门县,乌丘乡', 3, 'wuqiu', '082', '896', 'W', '118.319578', '24.435038');
INSERT INTO `hup_region` VALUES (3711, 3325, '连江', '连江县', '中国,台湾省,连江县', 2, 'lienchiang', '0836', '2', 'L', '119.539704', '26.197364');
INSERT INTO `hup_region` VALUES (3712, 3711, '南竿', '南竿乡', '中国,台湾省,连江县,南竿乡', 3, 'nangan', '0836', '209', 'N', '119.944267', '26.144035');
INSERT INTO `hup_region` VALUES (3713, 3711, '北竿', '北竿乡', '中国,台湾省,连江县,北竿乡', 3, 'beigan', '0836', '210', 'B', '120.000572', '26.221983');
INSERT INTO `hup_region` VALUES (3714, 3711, '莒光', '莒光乡', '中国,台湾省,连江县,莒光乡', 3, 'juguang', '0836', '211', NULL, '119.940405', '25.976256');
INSERT INTO `hup_region` VALUES (3715, 3711, '东引', '东引乡', '中国,台湾省,连江县,东引乡', 3, 'dongyin', '0836', '212', 'D', '120.493955', '26.366164');
INSERT INTO `hup_region` VALUES (3716, 0, '香港', '香港特别行政区', '中国,香港特别行政区', 1, 'hongkong', '', '', 'X', '114.173355', '22.320048');
INSERT INTO `hup_region` VALUES (3738, 0, '澳门', '澳门特别行政区', '中国,澳门特别行政区', 1, 'macau', '', '', 'A', '113.54909', '22.198951');
INSERT INTO `hup_region` VALUES (3739, 3738, '澳门半岛', '澳门半岛', '中国,澳门特别行政区,澳门半岛', 2, 'macaupeninsula', '00853', '999078', 'A', '113.549134', '22.198751');
INSERT INTO `hup_region` VALUES (3740, 3739, '花地玛堂区', '花地玛堂区', '中国,澳门特别行政区,澳门半岛,花地玛堂区', 3, 'nossasenhoradefatima', '00853', '999078', 'H', '113.552284', '22.208067');
INSERT INTO `hup_region` VALUES (3741, 3739, '圣安多尼堂区', '圣安多尼堂区', '中国,澳门特别行政区,澳门半岛,圣安多尼堂区', 3, 'santoantonio', '00853', '999078', 'S', '113.564301', '22.12381');
INSERT INTO `hup_region` VALUES (3742, 3739, '大堂', '大堂区', '中国,澳门特别行政区,澳门半岛,大堂区', 3, 'sé', '00853', '999078', 'D', '113.552971', '22.188359');
INSERT INTO `hup_region` VALUES (3743, 3739, '望德堂区', '望德堂区', '中国,澳门特别行政区,澳门半岛,望德堂区', 3, 'saolazaro', '00853', '999078', 'W', '113.550568', '22.194081');
INSERT INTO `hup_region` VALUES (3744, 3739, '风顺堂区', '风顺堂区', '中国,澳门特别行政区,澳门半岛,风顺堂区', 3, 'saolourenco', '00853', '999078', 'F', '113.541928', '22.187368');
INSERT INTO `hup_region` VALUES (3745, 3738, '氹仔岛', '氹仔岛', '中国,澳门特别行政区,氹仔岛', 2, 'taipa', '00853', '999078', NULL, '113.577669', '22.156838');
INSERT INTO `hup_region` VALUES (3746, 3745, '嘉模堂区', '嘉模堂区', '中国,澳门特别行政区,氹仔岛,嘉模堂区', 3, 'ourladyofcarmel\'sparish', '00853', '999078', 'J', '113.565303', '22.149029');
INSERT INTO `hup_region` VALUES (3747, 3738, '路环岛', '路环岛', '中国,澳门特别行政区,路环岛', 2, 'coloane', '00853', '999078', 'L', '113.564857', '22.116226');
INSERT INTO `hup_region` VALUES (3748, 3747, '圣方济各堂区', '圣方济各堂区', '中国,澳门特别行政区,路环岛,圣方济各堂区', 3, 'stfrancisxavier\'sparish', '00853', '999078', 'S', '113.559954', '22.123486');
INSERT INTO `hup_region` VALUES (3999, 3716, '香港', '香港特别行政区', '中国,香港特别行政区', 2, 'hongkong', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4000, 3999, '中西区', '中西区', '中国,香港特别行政区,中西区', 3, 'zhongxin', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4001, 3999, '东区', '东区', '中国,香港特别行政区,东区', 3, 'dong', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4002, 3999, '九龙城区', '九龙城区', '中国,香港特别行政区,九龙城区', 3, 'jiulong', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4003, 3999, '观塘区', '观塘区', '中国,香港特别行政区,观塘区', 3, 'guantang', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4004, 3999, '南区', '南区', '中国,香港特别行政区,南区', 3, 'nan', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4005, 3999, '深水埗区', '深水埗区', '中国,香港特别行政区,深水埗区', 3, 'shenshuibu', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4006, 3999, '湾仔区', '湾仔区', '中国,香港特别行政区,湾仔区', 3, 'wanzi', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4007, 3999, '黄大仙区', '黄大仙区', '中国,香港特别行政区,黄大仙区', 3, 'huangdaxian', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4008, 3999, '油尖旺区', '油尖旺区', '中国,香港特别行政区,油尖旺区', 3, 'youjianwang', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4009, 3999, '离岛区', '离岛区', '中国,香港特别行政区,离岛区', 3, 'lidao', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4010, 3999, '葵青区', '葵青区', '中国,香港特别行政区,葵青区', 3, 'kuiqing', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4011, 3999, '北区', '北区', '中国,香港特别行政区,北区', 3, 'bei', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4012, 3999, '西贡区', '西贡区', '中国,香港特别行政区,西贡区', 3, 'xigong', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4013, 3999, '沙田区', '沙田区', '中国,香港特别行政区,沙田区', 3, 'shatian', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4014, 3999, '屯门区', '屯门区', '中国,香港特别行政区,屯门区', 3, 'tunmen', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4015, 3999, '大埔区', '大埔区', '中国,香港特别行政区,大埔区', 3, 'dapu', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4016, 3999, '荃湾区', '荃湾区', '中国,香港特别行政区,荃湾区', 3, 'quanwan', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4017, 3999, '元朗区', '元朗区', '中国,香港特别行政区,元朗区', 3, 'yuanlang', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `hup_region` VALUES (4018, 2291, '儋州', '儋州市', '中国,海南省,儋州市', 2, 'danzhou', '0898', '571700', 'D', NULL, NULL);SET FOREIGN_KEY_CHECKS = 1;

mysql省市区表-1
https://blog.csdn.net/weixin_42998455/article/details/133635525

mysql省市区表-2
https://blog.csdn.net/weixin_42998455/article/details/133635990

mysql省市区表-3
https://blog.csdn.net/weixin_42998455/article/details/133636248

mysql省市区表-4
https://blog.csdn.net/weixin_42998455/article/details/133636301

mysql省市区表-5
https://blog.csdn.net/weixin_42998455/article/details/133636352

sql完整压缩包
完结。

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！