area_insert_taiwan.sql

INSERT INTO `area` (`id`, `pid`, `name`, `level`) VALUES (830000000000, 0, '台灣省', 1); INSERT INTO `area` (`id`, `pid`, `name`, `level`) VALUES (830100000000, 830000000000, '臺北市', 2), (830200000000, 830000000000, '基隆市', 2), (830300000000, 830000000000, '新北市', 2), (830400000000, 830000000000, '桃園市', 2), (830500000000, 830000000000, '新竹市', 2), (830600000000, 830000000000, '新竹縣', 2), (830700000000, 830000000000, '苗栗縣', 2), (830800000000, 830000000000, '臺中市', 2), (830900000000, 830000000000, '彰化縣', 2), (831000000000, 830000000000, '南投縣', 2), (831100000000, 830000000000, '雲林縣', 2), (831200000000, 830000000000, '嘉義市', 2), (831300000000, 830000000000, '嘉義縣', 2), (831400000000, 830000000000, '臺南市', 2), (831500000000, 830000000000, '高雄市', 2), (831600000000, 830000000000, '屏東縣', 2), (831700000000, 830000000000, '宜蘭縣', 2), (831800000000, 830000000000, '花蓮縣', 2), (831900000000, 830000000000, '臺東縣', 2), (832000000000, 830000000000, '澎湖縣', 2), (832100000000, 830000000000, '金門縣', 2), (832200000000, 830000000000, '連江縣', 2), (830101000000, 830100000000, '中正區', 3), (830102000000, 830100000000, '大同區', 3), (830103000000, 830100000000, '中山區', 3), (830104000000, 830100000000, '松山區', 3), (830105000000, 830100000000, '大安區', 3), (830106000000, 830100000000, '萬華區', 3), (830107000000, 830100000000, '信義區', 3), (830108000000, 830100000000, '士林區', 3), (830109000000, 830100000000, '北投區', 3), (830110000000, 830100000000, '內湖區', 3), (830111000000, 830100000000, '南港區', 3), (830112000000, 830100000000, '文山區', 3), (830201000000, 830200000000, '仁愛區', 3), (830202000000, 830200000000, '信義區', 3), (830203000000, 830200000000, '中正區', 3),