# AIoT班上課紀錄II
###
## 2024-07-02
## SQL資料庫

#### SELECT資料查詢

/* 查詢ubike全部欄位資料 */
SELECT * FROM ubike;

/* 查詢ubike部分欄位資料 */
SELECT sna, bemp, ar, tot, sbi FROM ubike;

/* 查詢ubike部分欄位資料，sna欄位為健行科技大學 */
SELECT sna, bemp, ar, tot, sbi FROM ubike WHERE sna = '健行科技大學';

/* 查詢ubike部分欄位資料，sna欄位有包含健行科技的都會撈出來 */
SELECT sna, bemp, ar, tot, sbi FROM ubike WHERE sna LIKE '%健行科技%';

/* 撈出站名和總停車格數量，且必須該站牌總停車格數量50格以上或是10格以下的站台 */
SELECT sna, tot FROM ubike WHERE tot >= 50 OR tot <= 10;

/* 撈出站名和總停車格數量，並且降冪排序 */
SELECT sna, tot FROM ubike ORDER BY tot DESC; /* ASC: 升冪 */

/* 撈出站名和總停車格數量，降冪排序後只取第一筆資料 */
SELECT sna, tot, sbi FROM ubike ORDER BY tot DESC, sbi DESC LIMIT 1;

/* 撈出站名和總停車格數量，tot降冪排序後如果資料一樣的，會再用sbi欄位降冪排序 */
SELECT sna, tot, sbi FROM ubike ORDER BY tot DESC, sbi DESC;

/* 取得總共幾筆資料 */
SELECT count(*) count FROM ubike;

/* 計算全桃園市全部站台的總共數量 */
SELECT sum(tot) count FROM ubike;

/* 將撈出的sarea資料重複的濾掉 */
SELECT DISTINCT sarea FROM ubike;

/* 將sarea欄位聚合後撈出來 */
SELECT sarea FROM ubike GROUP BY sarea;

/* 取得桃園區和中壢區總共有幾個站台 */
SELECT count(*) FROM ubike WHERE sarea = '桃園區' OR sarea = '中壢區';

/* 取得桃園區和中壢區總共有幾個站台 */
SELECT count(*) FROM ubike WHERE sarea IN ('桃園區', '中壢區');

SELECT tot FROM ubike u ORDER BY tot DESC LIMIT 1;

SELECT max(tot) FROM ubike;

SELECT sna, tot FROM ubike WHERE tot = (SELECT max(tot) FROM ubike);

#### INSERT ubike資料

INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.194666,'中央大學圖書館','National Central University Library',5,'中大路300號(中央大學校內圖書館前)',1,2001,'No.300, Zhongda Rd.',14,1,8,20240702104429,24.968128);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.212038,'中壢高中','Jhungli Senior High School',0,'中央西路二段215號對面人行道',1,2002,'No.215, Sec. 2, Zhongyang W. Rd. (opposite)',12,2,12,20240702104428,24.960815);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.224805,'中正公園(中美路)','Zhongzheng Park (Zhongmei Rd.)',-1,'中美路101-113號對面人行道',0,2003,'No.101 to No.113, Zhongmei Rd. (opposite)',34,3,0,20230919103006,24.959113);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.22644,'中壢火車站(前站)中和路','TRA Zhongli Station (Front)Zhonghe Rd.',14,'中和路109號空地',1,2004,'No. 109, Zhonghe Rd.',24,4,8,20240702104429,24.954042);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.240201,'中原大學','Chung Yuan Christian University',17,'中北路200號(中原大學校內懷恩樓後方空地)',1,2005,'No.200, Zhongbei Rd.',28,5,8,20240702104417,24.957943);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.224241,'銀河廣場','Galaxy Square',6,'九和一街48號對面銀河廣場人行道',1,2006,'No.48, Jiuhe 1st St. (opposite)',12,6,5,20240702104421,24.961716);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.224696,'中壢區公所','Civil Affairs Office of Zhongli District',5,'環北路380號旁人行道',1,2007,'No.380, Huanbei Rd.',10,7,3,20240702104443,24.965697);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.217385,'光明公園','Guangming Park',19,'民權路322號對面停車場',1,2008,'No.322, Minquan Rd. (opposite)',24,8,2,20240702104416,24.962812);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.215878,'翠堤橋','Cuiti Bridge',11,'義民路105號旁人行道',1,2009,'No.105, Yimin Rd.',12,9,1,20240702104419,24.953265);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.220349,'中壢國小','Chungli Elementary School',6,'康樂路61號旁公園',1,2010,'No.61, Kangle Rd. (opposite)',12,10,6,20240702104436,24.954097);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.235693,'莒光公園','Juguang Park',3,'寧夏二街43號對面莒光公園入口圓環',1,2011,'No.43,Ningxia 2nd St. (opposite)',6,11,3,20240702104433,24.951472);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.224325,'中壢火車站(後站)','TRA Zhongli Station (Rear)',5,'新興路68-94號對面人行道',1,2012,'No.68 to No.94, Xinxing Rd. (opposite)',10,12,1,20240702104419,24.952352);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.310863,'桃園市立圖書館桃園分館','Taoyuan City Library Taoyuan Branch',0,'民權路32號前方人行道',0,2013,'No.32, Minquan Rd.',66,13,0,20240412101931,24.993040);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.227300,'中正公園(元化路)','Zhongzheng Park(Yuanhua Rd.)',7,'元化路197巷對面中正公園旁人行道',1,2017,'Ln. 197, Yuanhua Rd. (opposite)',10,14,2,20240702104425,24.960415);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.230027,'中壢區聯合辦公大樓','Zhongli District Joint Office Building',9,'溪洲街298號前方人行道',1,2018,'No.298, Xizhou St.',10,15,0,20240702104444,24.962068);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.306636,'民族公園','Minzu Park',4,'汕頭街15號對面民族公園旁人行道',1,2019,'No.15, Shantou St.(opposite)',12,16,8,20240702104424,24.995946);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.312820,'朝陽森林公園','Chaoyang Park',18,'朝陽街104-108號對面機車停車場',1,2020,'No.104 to No.108, Chaoyang St.',28,17,8,20240702104427,24.999107);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.314998,'桃園延平公園','Taoyuan Yenping Park',18,'大豐路187號對面延平公園旁人行道',1,2021,'No.187, Dafeng Rd.(opposite)',18,18,0,20240702104418,24.980482);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.311513,'福豐公園','Fufeng Park',24,'建國路昆明路口(西北側)',1,2022,'Jianguo Rd./Kunming Rd.',26,19,2,20240702104434,24.985652);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.314279,'桃園火車站(後站)','TRA Taoyuan Station (Rear)',2,'延平路26號對面人行道',1,2023,'No.26, Yanping Rd.(opposite)',14,20,10,20240702104428,24.987795);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.317759,'桃園建國公園','Taoyuan Jianguo Park',8,'桃鶯路93號對面建國公園旁人行道',1,2024,'No.93, Taoying Rd. (opposite)',8,21,0,20240702104445,24.987418);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.303296,'桃園陽明高中','Taoyuan Municipal Yang Ming High School',11,'德壽街8號前方人行道',1,2025,'No.8, Deshou St.',20,22,9,20240702104428,24.980404);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.261596,'夢幻公園','Dream Park',0,'榮安十三街榮民路口(西南側)',1,2026,'Rongan 13th St./Rongmin Rd.',12,23,11,20240702104438,24.962541);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.259279,'內壢自強公園','Neili Ziqiang Park',7,'強國路46號旁自強公園側人行道',1,2027,'No.46, Qiangguo Rd.',12,24,5,20240702104434,24.967686);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.248114,'內壢復興公園','Neili Fuxing Park',1,'復華街191號對面復興公園旁人行道',1,2028,'No.191, Fuhua St. (opposite)',8,25,7,20240702104425,24.973630);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.263249,'元智大學','Yuan Ze University',15,'遠東路135號(面元智大學左側人行道)',1,2029,'No.135, Yuandong Rd.',22,26,3,20240702104445,24.970346);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.293908,'同德國中','Tongde Junior High School',4,'南平路479號對面同德國中旁人行道',1,2030,'No.479, Nanping Rd. (opposite)',10,27,6,20240702104428,25.016130);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.299970,'桃園展演中心(同德六街)','Taoyuan Arts Center(Tongde 6th St.)',4,'同德六街藝文二街口東南側廣場',1,2031,'Tongde 6th St./Yiwen 2nd St.',12,28,8,20240702104432,25.016551);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.313558,'東溪綠園','Dongxi Greens',8,'成功路二段1號旁小公園',1,2032,'No.1, Sec. 2, Chenggong Rd.',16,29,7,20240702104419,24.993122);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.218322,'桃園市立圖書館平鎮分館','Taoyuan Public Library Pingzhen Branch',3,'環南路三段88號右前方人行道',1,2033,'No.88, Sec. 3, Huannan Rd.',12,30,8,20240702104422,24.940031);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.216686,'新勢公園','Xinshi Park',28,'延平路一段181號對面新勢公園旁人行道',1,2034,'No.181, Sec. 1, Yanping Rd.(opposite)',28,31,0,20240702104430,24.950692);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.319691,'三民運動公園','Sanmin Sports Park',35,'三民路一段200號前方人行道',1,2035,'No.200, Sec. 1, Sanmin Rd.',40,32,4,20240702104449,25.000577);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.298235,'桃園展演中心(南平路)','Taoyuan Arts Center (Nanping Rd.)',9,'南平路336號對面人行道',1,2037,'No.336, Nanping Rd.(opposite)',10,33,1,20240702104325,25.018038);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.289327,'國強公園','Guochiang Park',12,'國強一街益壽一街口(東北側人行道)',1,2038,'Guociang 1st St./Yishou 1st St.',14,34,2,20240702104430,24.993077);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.303725,'新埔公園','Xinpu Park',4,'同安街203號對面人行道',1,2039,'No.203, Tong’an St.(opposite)',8,35,4,20240702104422,25.015195);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.231454,'信義國小','Hsin Yi Elementary School',6,'成都路36號對面人行道',1,2040,'No.36, Chengdu Rd.(opposite)',6,36,0,20240702104443,24.951017);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.321076,'桃園市立圖書館大林分館','Taoyuan Public Library Dalin Branch',3,'樹仁二街37號後方人行道',1,2041,'No.37, Shuren 2nd St.',12,37,8,20240702104429,24.977812);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.313022,'桃園火車站(前站)','TRA Taoyuan Station (Front)',3,'中正路1號面火車站右方人行道',1,2042,'No.1, Zhongzheng Rd.',14,38,8,20240702104436,24.989618);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.292954,'瑞慶公園','Ruiching Park',8,'中埔一街362號對面瑞慶公園旁人行道',1,2043,'No.362, Zhongpu 1st St.(opposite)',12,39,3,20240702104437,25.019129);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.299560,'中寧公園','Zhongning Park',2,'同德二街177號對面中寧公園旁人行道',1,2044,'No.177, Tongde 2nd St.(opposite)',6,40,4,20240702104420,25.009993);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.308126,'陽明運動公園','Yangming Sports Park',4,'介壽路199號前方人行道',1,2045,'No.199, Jieshou Rd.',8,41,4,20240702104420,24.982285);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.314760,'大業國小','Da Yie Elementary School',6,'民光東路280號對面人行道',1,2046,'No.280, Minguang E. Rd.(opposite)',12,42,6,20240702104439,25.006896);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.319869,'大有國中','Da You Junior High School',8,'大有路民光東路口西北側人行道',1,2047,'Dayou Rd./Minguang E. Rd.',12,43,4,20240702104438,25.008585);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.257255,'莊敬廣場','Zhuangjing Square',14,'莊敬路38-1號對面自行車停放區',1,2048,'No.38-1, Zhuangjing Rd.(opposite)',16,44,2,20240702104422,24.971851);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.250406,'吉林路吉利六街口','Jilin Rd. & Jili 6th St. Intersection',9,'吉林路吉利六街口東南側人行道',1,2049,'Jilin Rd./Jili 6th St.',10,45,1,20240702104441,24.982900);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.235924,'龍岡森林公園','Longgang Park',19,'龍岡路三段289號對面龍岡森林公園旁人行道',1,2050,'No.289, Sec. 3, Longgang Rd.(opposite)',20,46,1,20240702104443,24.933974);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.305469,'君臨公園','Junlin Park',19,'忠勇六街1號對面人行道',1,2051,'No.1, Zhongyong 6th St.(opposite)',22,47,1,20240702104443,24.964524);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.290229,'光明國小','Guang Ming Elementary School',39,'南昌路忠孝西路口東北側人行道',1,2053,'Nanchang Rd./Zhongxiao W. Rd.',42,48,1,20240702104438,25.041275);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.281064,'桃園龍岡公園','Taoyuan Longgang Park',4,'國豐一街101號對面龍岡公園旁人行道',1,2054,'No.101, Guofeng 1st St.(opposite)',8,49,2,20240702104432,24.99039);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.278943,'桃園龍鳳公園','Taoyuan Longfeng Park',17,'國豐五街51號對面龍鳳公園旁人行道',1,2055,'No.51, Guofeng 5rd St.(opposite)',20,50,2,20240702104420,24.989688);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.300537,'桃園市政府文化局','Departmaent of Cultural Affairs, Taoyuan',4,'縣府路21號面文化局左側路側',1,2056,'No.21, Xianfu Rd.',12,51,7,20240702104431,24.994184);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.317130,'成功春日路口','Chenggong & Chunri Rd. Intersection',15,'成功路二段春日路口東南側人行道',1,2057,'Chenggong Rd./Chunri Rd.',22,52,7,20240702104424,24.994177);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.256853,'忠孝廣場','Zongxiao Square',4,'忠孝路8-22號對面路側',1,2058,'No.8-22, Zhongxiao Rd.(opposite)',8,53,3,20240702104424,24.972516);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.227697,'忠福廣場','Zhongfu Square',9,'南園二路292號對面忠福廣場旁人行道',1,2059,'No.292, Nanyuan 2nd Rd.(opposite)',10,54,1,20240702104430,24.971805);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.229011,'健行科技大學','Chien Hsin University of Science and Technology',14,'健行路229號(商學大樓後人行道)',1,2060,'No.229, Jianxing Rd.',16,55,2,20240702104424,24.946778);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.234553,'啟英高中','Chi-Ying Senior High School',8,'西園路76號對面啟英高中旁人行道',1,2061,'No.76, Xiyuan Rd.(opposite)',12,56,4,20240702104432,24.975610);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.250102,'內壢文化公園','Neili Wenhua Park',7,'文化路長春二路西北側公園旁人行道',1,2062,'Wenhua Rd./Changchun 2nd Rd.',10,57,2,20240702104417,24.979567);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.229925,'萬能科技大學','Vanung University of Technology',9,'萬能路1號(萬芳樓後方人行道)',1,2063,'No.1, Changchun 2nd Rd.',20,58,9,20240702104437,24.992749);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.293209,'中德里休閒廣場','Zhongde Square',16,'國際一路國際二路口西南側停車場',1,2064,'Guoji 1st Rd./Guoji 2nd Rd.',18,59,1,20240702104438,24.962275);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.323924,'桃園巨蛋','Taoyuan Arena',5,'三民路100號對面人行道',1,2065,'No.100, Sanmin Rd.(opposite)',18,60,11,20240702104435,24.995393);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.337660,'龜山區公所','Civil Affairs Office of Guishan District',10,'中山街26號前方人行道',1,2066,'No.26, Zhongshan St.',10,61,0,20240702104428,24.992532);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.339485,'龜山國中','Guishan Junior High School',7,'自強西路66號前方人行道',1,2067,'No.66, Ziqiang W. Rd.',12,62,5,20240702104428,24.997536);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.303884,'西門綠園','Ximen Greens',9,'文康街61號對面人行道',1,2068,'No.61, Wenkang St.(opposite)',10,63,1,20240702104434,24.993968);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.268981,'衛福部桃園醫院','Taoyuan General Hospital, Ministry of Health and Welfare',2,'龍壽街60號對面人行道',1,2069,'No.60, Longshou St.(opposite)',10,64,8,20240702104430,24.979389);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.255168,'環中東永福路口','Huanzhong E. & Yongfu Rd. Intersection',0,'環中東路325號前人行道',0,2070,'No.325, Huanzhong E. Rd.',10,65,0,20240702104417,24.962030);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.297856,'南崁高中','Nankan Senior High School',32,'仁愛路二段1號(南崁高中旁人行道)',1,2071,'No.1, Sec. 2, Ren’ai Rd.',34,66,2,20240702104421,25.052456);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.293711,'蘆竹區婦幼館','Luzhu Maternity and Child Center',19,'五福路88號對面婦幼館人行道',1,2072,'No.88, Wufu Rd.(opposite)',28,67,7,20240702104420,25.050733);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.287677,'光明河濱公園','Guangming Riverside Park',15,'光明路二段100號對面路側',1,2073,'No.100, Sec. 2, Guangming Rd.(opposite)',20,68,5,20240702104420,25.046808);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.269685,'開南大學','Kainan University',34,'開南路1號(行政大樓南棟前停車場)',1,2074,'No.1, Kainan Rd.',46,69,7,20240702104417,25.011106);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.299397,'蘆竹吉林公園','Luzhu Jilin Park',23,'吉林路121-137號對面吉林公園旁人行道',1,2075,'No.121-137, Jilin Rd.(opposite)',24,70,1,20240702104419,25.049560);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.296538,'大和公園','Dahe Park',20,'銀和街29號對面公園',1,2076,'No.29, Yinhe St.(opposite)',26,71,3,20240702104444,24.955717);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Daxi Dist.','大溪區',121.287613,'月眉停車場','Yuemei Parking Lot',26,'月眉15鄰105號',1,2077,'No.105, Yuemei',34,72,5,20240702104426,24.889279);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Daxi Dist.','大溪區',121.285453,'大溪中正公園','Daxi Zhongzheng Park',26,'普濟路80號旁停車場',1,2078,'No.80, Puji Rd.',28,73,2,20240702104429,24.883151);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.294739,'忠孝兒童遊樂場','Zhongxiao Children''s Playground',9,'宏昌七街泰昌三街西南側廣場',1,2079,'Hongchang 7th St./Taichang 3rd St.',12,74,1,20240702104443,24.986849);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.301680,'桃園市政府','Taoyuan City Government',8,'縣府路3號對面廣場',1,2080,'No.3, Xianfu Rd.(opposite)',18,75,6,20240702104415,24.992799);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.204579,'五權公園','Wuquan Park',4,'正大街五族二街西北側人行道',1,2081,'Zhengda St./Wuzu 2nd St.',8,76,4,20240702104418,24.958867);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.226050,'中壢新興公園','Zhongli Xinxing Park',5,'林森路90號前方人行道',1,2082,'No.90, Linsen Rd.',8,77,2,20240702104436,24.945265);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.257972,'桃園市立圖書館內壢分館','Taoyuan Public Library Neili Branch',6,'光華三街10號前方人行道',1,2083,'No.10, Guanghua 3rd St.',14,78,8,20240702104415,24.977945);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.204192,'宋屋公園','Songwu Park',17,'廣泰路152號對面公園旁人行道',1,2084,'No.152, Guangtai Rd.(opposite)',20,79,1,20240702104428,24.945284);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.190958,'中央大學依仁堂','Office of Physical Education, NCU',7,'中大路300號(松苑餐廳前方廣場)',1,2085,'No.300, Zhongda Rd.',14,80,6,20240702104422,24.967119);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.298761,'思源公園','Siyuan Park',17,'思源街122號(對面公園綠帶)',1,2087,'No.122, Siyuan St.(opposite)',18,81,0,20240702091738,24.973517);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.297907,'廣豐公園','Guangfeng Park',26,'公園路廣豐二街東北側人行道',1,2088,'Gongyuan Rd./Guangfeng 2nd St.',28,82,1,20240702104421,24.966015);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.206413,'廣仁公園','Guangren Park',22,'廣南路168號對面公園旁人行道',1,2090,'No.168, Guangnan Rd.(opposite)',26,83,2,20240702104437,24.939478);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.342803,'璟都江山社區','Jingdu-Jiangshan Community',6,'光峰路131巷6號前方人行道',1,2095,'No.6, Ln. 131, Guangfeng Rd.',8,84,2,20240702104421,25.0023);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.285489,'捷運山鼻站(A10)','MRT Shanbi  Station (A10)',1,'南山路三段176號旁自行車停放區',1,2097,'No.176, Sec. 3, Nanshan Rd.',10,85,9,20240702104445,25.080942);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Dayuan Dist.','大園區',121.209741,'捷運大園站(A15)','MRT  Dayuan Station(A15)',7,'橫湳一路1號捷運站旁人行道',1,2098,'No.1, Hengnan 1st. Rd.',12,86,4,20240702104429,25.056627);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Dayuan Dist.','大園區',121.222169,'捷運領航站(A17)','MRT Linghang Station (A17)',3,'領航北路四段358號對面人行道',1,2099,'No.358, Sec. 4, Linghang N. Rd.(opposite)',10,87,7,20240702104442,25.023021);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.213932,'捷運高鐵桃園站(A18)','MRT HSR Taoyuan Station (A18)',9,'高鐵北路一段6號(對面捷運站出口外側人行道)',1,2100,'No.6, Sec. 1, Gaotie N. Rd.(opposite)',16,88,6,20240702104428,25.013775);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.202782,'捷運桃園體育園區站(A19)','MRT Taoyuan Sports Park Station (A19)',1,'高鐵南路二段369號對面人行道',1,2101,'No.369, Sec. 2, Gaotie S. Rd.(opposite)',4,89,2,20240702104433,25.001568);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.220967,'捷運環北站(A21)','MRT Huanbei Station (A21)',6,'中豐北路26號旁人行道',1,2102,'No.26, Zhongfeng N. Rd.',8,90,2,20240702104417,24.967563);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.205798,'青埔國中','Qing Pu Junior High School',3,'領航北路二段281號前方人行道',1,2103,'No.281, Sec. 2, Linghang N. Rd.',8,91,2,20240702104442,25.010832);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.201054,'領航公園','Linghang Park',19,'領航北路一段永裕路口北側公園旁人行道',1,2104,'Sec. 1, Linghang N. Rd./Yongyu Rd.',22,92,3,20240702104431,25.007413);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.260842,'仁祥公園','Renxiang Park',10,'華祥一街3巷2號對面人行道',1,2105,'No.2, Ln. 3, Huaxiang 1st St.(opposite)',18,93,7,20240702104440,24.948864);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.263280,'篤行公園','Duxing Park',2,'永福路47號對面人行道',1,2106,'No.47, Yongfu Rd.(opposite)',8,94,3,20240702104431,24.958288);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.299434,'桃園市政府警察局桃園分局','Taoyuan Police Department Taoyuan Branch',2,'永安路375號旁人行道',1,2107,'No.375, Yong’an Rd.',10,95,8,20240702104439,25.000418);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.301842,'慈文國中','Tzu Wen Junior High School',9,'中正路835號前方人行道',1,2108,'No.835, Zhongzheng Rd.',12,96,1,20240702104436,25.008916);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.305633,'同新公園','Tongxin Park',11,'同安街經國路251巷口(東南側人行道)',1,2109,'Tong’an St./Ln. 251, Jingguo Rd.',12,97,1,20240702104429,25.012389);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.302925,'桃園永康公園','Taoyuan Yongkang Park',1,'力行路中正五街口東南側人行道',1,2110,'Lixing Rd./Zhongzheng 5th St.',8,98,7,20240702104420,25.001890);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.292088,'桃園市立游泳池','Taoyuan City Swimming Pool',5,'吉昌街86號(對面人行道)',1,2111,'No.86, Jichang St.(opposite)',10,99,5,20240702104425,24.989458);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.313903,'寶山公園','Baoshan Park',5,'民有三街517號對面公園旁人行道',1,2112,'No.517, Minyou 3rd St.(opposite)',14,100,9,20240702104421,25.013132);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.282126,'國強一街上海路口','Guochiang 1st St. & Shanghai Rd. Intersection',28,'國強一街上海路口西北側高架橋下廣場',1,2113,'Guoqiang 1st St./Shanghai Rd.',30,101,2,20240702104443,24.992059);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.317024,'青溪公園','Qingxi Park',7,'自強路217號前方人行道',1,2114,'No.217, Ziqiang Rd.',10,102,3,20240702104427,25.000959);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.252751,'甲蟲公園','Jiachong Park',5,'元生二街元生三街口西北側公園旁人行道',1,2115,'Yuansheng 2nd St./Yuansheng 3rd St.',8,103,3,20240702104427,24.977542);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.226195,'中壢中央公園','Zhongli Central Park',7,'建國北路9號對面公園人行道',1,2116,'No.9, Jianguo N. Rd.(opposite)',12,104,5,20240702104416,24.956663);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.214981,'新榮公園','Xinrong Park',7,'振興西路新德街口西北側公園旁人行道',1,2117,'Zhenxing W. Rd./Xinde St.',8,105,1,20240702104420,24.945991);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.304068,'重慶公園','Chongqing Park',16,'重慶街183號對面公園旁人行道',1,2118,'No.183, Chongqing St.(opposite)',18,106,0,20240702104445,24.955984);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.340557,'龜山國小','Guishan Elementary School',8,'大同路23號對面人行道',1,2120,'No.23, Datong Rd.(opposite)',14,107,6,20240702104444,24.994765);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.342481,'大同公園','Datong Park',9,'德明路77巷65號對面公園旁人行道',1,2123,'No.65, Ln. 77, Deming Rd.(opposite)',12,108,1,20240702104431,24.989332);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.294341,'蘆竹區公所','Civil Affairs District of Luzhu District',12,'南上路3號對面路側',1,2125,'No.3, Nanshang Rd.(opposite)',24,109,12,20240702104427,25.047325);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.292555,'峻德宮','Junde Temple',20,'奉化路292號旁路側',1,2126,'No.292, Fenghua Rd.',20,110,0,20240702104425,25.036999);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.271035,'桃園龍山國小','Taoyuan Long Shan Elementary School',17,'龍祥街94號對面人行道',1,2127,'No.94, Longxiang St.(opposite)',26,111,8,20240702104420,24.981988);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.302536,'介壽路(國2橋下)','Jieshou Rd.(Under the National Freeway No.2 Viaduct)',23,'介壽路547號旁國道二號橋下空間',1,2128,'No.547, Jieshou Rd.',24,112,1,20240702104427,24.974220);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Dayuan Dist.','大園區',121.175354,'桃禧航空城酒店','Hotel Orchard Park',2,'大觀路777號(桃禧航空城酒店園航路側人行道)',1,2129,'No.777, Daguan Rd.',10,113,6,20240702104324,25.061756);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Dayuan Dist.','大園區',121.195804,'老街溪停車場','Laojie River Parking Lot',22,'大觀路31巷1號旁老街溪上方停車場',1,2130,'No.1, Ln. 31, Daguan Rd.',26,114,2,20240702104426,25.064974);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Dayuan Dist.','大園區',121.201825,'大中華幼兒園','Big China Kindergarten',15,'中正三街9號對面空地',1,2131,'No.9, Zhongzheng 3rd St.(opposite)',24,115,4,20240702104231,25.06179);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Dayuan Dist.','大園區',121.194852,'華興池','Huaxing Pond',0,'華興路205號對面路側',0,2132,'No.205, Huaxing Rd.(opposite)',36,116,0,20230828084025,25.059125);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.249757,'東安國中','Dong An Junior High School',18,'平東路168號(面東安國中右側人行道)',1,2133,'No.168, Pingdong Rd.',20,117,1,20240702104443,24.916497);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.294575,'五福停車場','Wufu Parking Lot',23,'五福一路120號對面人行道',1,2137,'No.120, Wufu 1st Rd.(opposite)',24,118,0,20240702104435,25.055851);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.259057,'大竹國小','Dazhu Elementary School',20,'南竹路五段271號對面人行道',1,2138,'No.271, Sec. 5, Nanzhu Rd.(opposite)',28,119,6,20240702104428,25.024481);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.260268,'中興環保公園','Zhongxing Eco-Park',16,'大興四街61巷及大興四街路口公園內',1,2139,'Ln. 61, Daxing 4th St./Daxing 4th St.',20,120,2,20240702104416,25.016221);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.297919,'桃園中正公園(同安街)','Taoyuan Zhongzheng Park (Tung''an St.)',13,'同安街601號旁公園人行道',1,2140,'No.601, Tong’an St.',14,121,0,20240702104440,25.023701);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.310324,'建新公園','Jianxin Park',9,'陽明十二街25號對面公園旁人行道',1,2141,'No.25, Yangming 12th St.(opposite)',10,122,0,20240702104443,24.979206);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.308633,'中正一正康一街口','Zhongzheng 1st St. & Zhengkang 1st St. Intersection',0,'正康一街1號對面機車停車場',0,2142,'No.1, Zhengkang 1st St.(opposite)',34,123,0,20230621124340,24.999637);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.221136,'平鎮和平公園','Pingzhen Heping Park',20,'莒光路39號對面路側',1,2143,'No.39, Juguang Rd.(opposite)',20,124,0,20240702104421,24.947529);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.214821,'莊敬里民集會所','Zhuangjing Civil Activity Center',20,'自強街莊福路口東北側人行道',1,2144,'Ziqiang St.,/Zhuangfu Rd.',20,125,0,20240702104419,24.904080);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.211817,'中豐坤慶路口','Zhongfeng & Kunqing Rd. Intersection',16,'坤慶路1號前方人行道',1,2145,'No.1, Kunqing Rd.',18,126,2,20240702104439,24.90262);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.210032,'龍潭大池(龍元路)','Longtan Pond (Longyuan Rd.)',20,'龍元路144號對面龍潭大池旁人行道',1,2147,'No.144, Longyuan Rd.(opposite)',26,127,4,20240702104434,24.863851);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.218519,'龍潭運動公園(北龍路)','Longtan Sports Park (Beilong Rd.)',0,'公園路北龍路口東南側公園旁人行道',0,2148,'Gongyuan Rd./Beilong Rd.',38,128,0,20240702104424,24.868242);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.256127,'黎明公園','Liming Park',1,'同慶路榮民南路口西南側公園前方路側',1,2149,'Tongqing Rd./Rongmin S. Rd.',6,129,3,20240702104425,24.939894);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.263548,'興仁公園','Xinren Park',4,'興仁路二段120號對面公園內人行道',1,2150,'No.120, Sec. 2, Xingren Rd.(opposite)',10,130,5,20240702104443,24.966256);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.253381,'自立新村(榮安一街)','Zili Community (Rong''an 1st St.)',6,'榮安一街自立三街2巷北側人行道',1,2151,'Rong’an 1st St./Ln. 2, Zili 3rd St.',10,131,1,20240702104434,24.965432);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.261293,'晉元路仁德一街口','Jinyuan Rd. & Rende 1st St. Intersection',4,'仁德一街28-4號對面路側',1,2152,'No.28-4, Rende 1st St.(opposite)',6,132,1,20240702104428,24.950926);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.244805,'龍和公園','Longhe Park',4,'龍和三街290號(活動中心旁公園人行道)',1,2153,'No.290, Longhe 3rd St.',8,133,4,20240702104436,24.934221);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.337264,'萬壽中興路口','Wanshou & Zhongxin Rd. Interstction',8,'萬壽路二段981號對面停車場',1,2154,'No.981, Sec. 2, Wanshou Rd.(opposite)',12,134,3,20240702104440,24.994938);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.304047,'大同西路簡易公園','Datong W. Rd. Simple Park',6,'大同西路7巷4號對面公園',1,2155,'No.4, Ln. 7, Datong W. Rd.(opposite)',8,135,2,20240702104436,24.988164);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.287879,'霖園兒童公園','Linyuan Children''s Park',11,'國鼎二街132號(對面公園東側人行道)',1,2156,'No.132, Guoding 2nd St.(opposite)',18,136,5,20240702104441,24.986079);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.30502,'家樂福經國店','Carrefour Jingguo Branch',8,'天祥三街10號對面人行道',1,2157,'No.10, Tianxiang 3rd St.(opposite)',12,137,1,20240702104426,25.016383);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.301174,'玉山公園','Yushan Park',4,'南豐二街120號斜前方公園側',1,2158,'No.120, Nanfeng 2nd St.(opposite)',14,138,8,20240702104422,24.982621);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.313437,'會稽國中','Kuai Ji Junior High School',6,'大興路222號(面會稽國中校門左側人行道)',1,2159,'No.222, Daxing Rd.(opposite)',8,139,1,20240702104420,25.016115);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.296402,'和盛公園','Hesheng Park',19,'大和路101號對面公園側人行道',1,2161,'No.101, Dahe Rd.(opposite)',24,140,1,20240702104442,24.954289);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.146247,'楊梅火車站(前站)','TRA Yangmei Station (Front)',19,'大成路256號(火車站前方人行道)',1,2162,'No.256, Dacheng Rd.',28,141,7,20240702104435,24.913845);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.154995,'楊明國中','Yang-Ming Junior High School',20,'新農街337號(面楊明國中左側人行道)',1,2163,'No.337, Xinnong St.',28,142,6,20240702104438,24.910546);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.147179,'楊梅國中','Yang Mei Junior High School',23,'校前路86號對面人行道',1,2164,'No.86, Xiaoqian Rd.(opposite)',26,143,0,20240702104424,24.904093);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.303596,'經國國中','Jingguo Junior High School',2,'經國路276號(面經國國中校門左側人行道)',1,2165,'No.276, Jingguo Rd.(opposite)',8,144,6,20240702104421,25.0217);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.225294,'獅子林社區活動中心','Shizilin Community Activity Center',21,'大智街88號對面',1,2166,'No.88, Dazhi St.(opposite)',22,145,0,20240702104442,24.928339);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.222832,'紫雲宮','Ziyun Temple',0,'自忠二街126號對面停車場',0,2167,'No.126, Zizhong 2nd St.(opposite)',24,146,0,20240509100024,24.944845);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.206352,'民俗文化公園','Folk Cultural Park',29,'上海路及上海路119巷口西南側廣場',1,2168,'Shanghai Rd./Ln. 119, Shanghai Rd.',38,147,6,20240702104436,24.911914);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.289893,'風禾公園','Fenghe Park',25,'文中二路慈文路口東北側人行道',1,2169,'Wenzhong 2nd Rd./Ciwen Rd.',30,148,1,20240702104438,25.000991);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.320733,'財政部北區國稅局桃園分局','National Taxation Bureau of the Nothern Area, Ministry of Finance (Taoyuan Branch)',17,'三元街150號',1,2170,'No.150, Sanyuan St.',26,149,3,20240702104444,25.003782);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.308517,'桃園觀光夜市旅客服務中心','Taoyuan Tourist Night Market Service Center',22,'正康三街8號旁停車場',1,2171,'No.8, Zhengkang 3rd St.',26,150,4,20240702104442,25.004089);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Dayuan Dist.','大園區',121.220506,'大園國際高中','Dayuan International Senior High School',7,'大成路二段37號對面人行道',1,2172,'No.37, Sec. 2, Dacheng Rd.(opposite)',14,151,7,20240702104436,25.020834);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.308382,'同福公園','Tongfu Park',19,'和義街50號對面人行道',1,2173,'No.50, Heyi St.(opposite)',22,152,0,20240702104426,24.959257);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.303459,'大勇國小','Dayong Elementary School',28,'忠勇街373號對面人行道',1,2174,'No.373, Zhongyong St.(opposite)',32,153,1,20240702104444,24.968624);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.250856,'常樂公園','Changle Park',10,'文化二路237-243號旁公園人行道',1,2176,'No.237-243, Wenhua 2nd Rd.',10,154,0,20240702104438,24.976881);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.248625,'金鋒太子','Jinfeng Prince',2,'金鋒四街50巷2號對面',1,2177,'No.2, Ln. 50, Jinfeng 4th St.(opposite)',6,155,4,20240702104418,24.945911);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.259724,'華愛兒童公園','Hua-Ai Children''s Park',3,'華愛街35號對面公園旁人行道',1,2178,'Hua-Ai Children''s Park',8,156,5,20240702104327,24.952303);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.291398,'南榮公園','Nanrong Park',16,'南平街洛陽街口南側公園旁人行道',1,2179,'Nanping St./Luoyang St.',22,157,6,20240702104417,25.045165);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.221761,'龍潭行政園區','Longtan Administrative Park',16,'中興路681號對面人行道',1,2180,'No.681, Zhongxing Rd.(opposite)',26,158,7,20240702104439,24.869962);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.175517,'過嶺國中','Guo Ling Junior High School',5,'松智路過嶺路一段路口人行道',1,2181,'Songzhi Rd./Sec. 1, Guoling Rd.',6,159,1,20240702104318,24.960203);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.177906,'南方莊園','Nanfang Park',3,'樹籽路8號對面停車場旁人行道',1,2182,'No.8, Shuzi Rd.(opposite)',6,160,3,20240702104435,24.967284);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.330472,'陸光河濱公園','Luguang Riverside Park',17,'同心二路19號對面公園內人行道',1,2184,'No.19, Tongxin 2nd Rd.(opposite)',20,161,3,20240702104429,24.99485);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.331988,'山福里集會所','Shanfu Civil Activity Center',6,'中興路152號旁停車場',1,2185,'No.152, Zhongxing Rd.',8,162,2,20240702104417,24.988965);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.31682,'大檜溪公園','Dakuaixi Park',0,'興一街65巷50號(地下停車場出入口旁公園)',1,2186,'No.50, Ln. 65, Xing 1st St.',6,163,6,20240702104437,25.013781);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Dayuan Dist.','大園區',121.171991,'大園國中','Dayuan Junior High School',11,'園科路400號前人行道',1,2201,'No.400, Yuanhang Rd.',26,164,15,20240702104423,25.053976);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Xinwu Dist.','新屋區',121.107716,'清華高中','Ching Hua High School',8,'中華路658號前方人行道',1,2202,'No.658, Zhonghua Rd.',18,165,10,20240702104431,24.981699);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guanyin Dist.','觀音區',121.133881,'觀音高中','Taoyuan Municipal Guanyin High School',18,'文中路46號對面人行道',1,2203,'46F., Wenzhong Rd.(opposite)',24,166,6,20240702104431,25.014978);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.29825,'溫州公園','Wenzhou Park',6,'大興西路二段139巷173號旁公園人行道',1,2204,'No.173, Ln. 139, Sec. 2, Daxing W. Rd.',8,167,2,20240702104432,25.008);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.22493,'忠愛公園','Zhong’ai Park',19,'金陵路二段454巷18號旁公園',1,2205,'No.18, Ln. 454, Sec. 2, Jinling Rd.',24,168,5,20240702104428,24.93306);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.25171,'南亞技術學院','Nanya Institute of Technology',11,'中山東路三段414號內機車停車場',1,2206,'No.414, Sec. 3, Zhongshan E. Rd.',16,169,3,20240702104425,24.93756);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.261741,'華勛公園','Huaxun Park',13,'華仁街68巷34號對面公園',1,2207,'No.34, Ln. 68, Huaren St.(opposite)',22,170,9,20240702104442,24.946622);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.148482,'中山親水公園','Zhongshan Waterfront Park',17,'新農街80號旁公園內',1,2208,'No.80, Xinnong St.',20,171,1,20240702104442,24.909657);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.34496,'楓樹公園','Fengshu park',21,'楓樹一街19號對面公園',1,2209,'No.19, Fengshu 1st St.(opposite)',22,172,0,20240702104428,25.00465);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.084646,'伯公岡公園','Bogonggang Park',18,'民生街101號對面公園',1,2210,'No.101, Minsheng St.(opposite)',24,173,5,20240702104422,24.938531);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.20492,'青塘園','Qingtang Garden',12,'洽溪路133號對面公園人行道',1,2212,'No.133, Qiaxi Rd. (oppsite)',18,174,6,20240702104441,25.00641);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.27619,'龍安公園','Longan Park',4,'國豐七街122號對面公園',1,2213,'No.122, Guofeng 7th St.(oppsite)',6,175,1,20240702104435,24.99153);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.19022,'平鎮魚形公園','Pingzhen Yusing Park',17,'清泉街49-53號旁公園內',1,2216,'No.49-53, Qingquan St.',20,176,1,20240702104423,24.95796);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Daxi Dist.','大溪區',121.28389,'大溪河濱公園','Daxi Riverside Park',26,'瑞興段2407地號內停車格',1,2217,'No.2407 of Ruixing Section',30,177,3,20240702104424,24.89212);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.32744,'大明公園','Daming Park',11,'興隆街2號對面公園',1,2218,'No.2, Xinglong St.(oppsite)',20,178,5,20240702104430,24.96875);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.23637,'國軍桃園總醫院','Taoyuan Armed Forces General Hospital',9,'中興路179號對面人行道',1,2219,'No.179, Zhongxing Rd. (opposite)',26,179,16,20240702104428,24.87498);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.27843,'元聖宮','Yuansheng Temple',20,'東泰街2號旁空地',1,2220,'No.2, Dongtai St.',22,180,2,20240702104425,24.96384);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.22939,'大江購物中心','Metrowalk',10,'中園路二段501號前方人行道',1,2221,'No.501, Sec. 2, Zhongyuan Rd.',12,181,2,20240702104435,25.00127);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.21856,'老街溪河川教育中心','LaoJier River Education Center',12,'中原路58號前方人行道',1,2222,'No.58, Gongxue Rd.',12,182,0,20240702104429,24.953739);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Dayuan Dist.','大園區',121.212793,'兒九公園','Erjiu Park',2,'致遠街致維街口公園內',1,2224,'Zhiyuan St./Jhihwei St.',8,183,3,20240702104440,25.005083);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.298213,'永定二保定三街89巷口','Yongding 2nd & Ln. 89, Baoding 3rd St. Intersection',20,'永定二街保定三街89巷口公園內',1,2225,'Yongding 2nd St./Ln. 89, Baoding 3rd St.',22,184,0,20240702104438,24.99746);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.300762,'八德霖園公園','Bade Linyuan Park',20,'介壽路一段16巷73號旁公園人行道',1,2226,'No.73, Ln. 16, Sec. 1, Jieshou Rd.(opposite)',20,185,0,20240702104436,24.97847);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.281626,'建德公園','Jiande Park',23,'長興路61號對面公園',1,2227,'No.61, Changxing Rd.(opposite)',28,186,1,20240702104436,24.931091);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.244046,'龍岡圓環','Longgang Roundabout',2,'龍東路龍岡路三段路口',1,2228,'Longdong Rd./Sec. 3, Longgang Rd.',6,187,4,20240702104435,24.926002);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.306346,'成功國小','Chenggong Elementary School',4,'中正三街與長春路口',1,2229,'Zhongzheng 3rd St./ Changchun Rd.',6,188,2,20240702104420,24.999511);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.25673,'新福大新一街口','Xinfu & Daxin 1st St. Intersection',17,'新福街125-127號對面',1,2230,'No.125-No.127, Xinfu St.(opposite)',20,189,3,20240702104436,25.02428);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.27288,'龍安國小','Long''an Elementary School',12,'文中路一段35號',1,2231,'No.35, Sec. 1, Wenzhong Rd.',22,190,10,20240702104442,24.99242);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.29726,'綠九公園','Lujiu Park',16,'六福路/六福路247巷路口旁公園',1,2232,'Liufu Rd./Ln. 247, Liufu Rd.',26,191,6,20240702104430,25.061109);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.179425,'內厝社區活動中心','Neicuo Activity Center',5,'中正路四段112號前方路側',1,2233,'No.112, Sec. 4, Zhongzheng Rd.',16,192,10,20240702104439,24.989317);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.251253,'普忠路770巷口','Ln. 770, Puzhong Rd.',1,'普忠路605號對面人行道',1,2235,'No.605, Puzhong Rd.(opposite)',10,193,9,20240702104442,24.954231);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.21368,'青埔國小','Qingpu Elementary School',6,'新生路四段127號對面人行道',1,2236,'No.127, Sec. 4, Sinsheng Rd.(opposite)',8,194,1,20240702104434,25.00662);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.347685,'南崁溪自行車道(長壽路口)','Nankan River Bikeway ( Changshou Rd. )',17,'半嶺段 44地號',1,2237,'No. 44 of Banling Section',18,195,1,20240702104433,25.001722);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.20433,'山仔頂公園','Shanzaiding Park',26,'自由街57號對面公園',1,2238,'No.57, Ziyou St.. (opposite)',26,196,0,20240702104437,24.892175);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.306156,'桃園區南平運動中心','Taoyuan District Naiping Sports Center',3,'南平路23號對面人行道',1,2239,'No.23, Nanping Rd.',12,197,8,20240702104423,25.021357);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.278891,'溪濱公園','Xibin Park',19,'廣興二路廣興五街口旁公園',1,2240,'Guangxing 5th St., Bade Dist., Taoyuan City',22,198,2,20240702104432,24.933108);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.28745,'豐德公園','Fengde Park',24,'豐田一路87號對面公園',1,2241,'No.87, Fengtian 1st Rd.(opposite)',28,199,3,20240702104435,24.926655);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.287328,'八德仁德公園','Bade Rende Park',12,'仁德路218號對面公園',1,2242,'No.218, Rende Rd.(opposite)',22,200,9,20240702104417,24.935127);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.287946,'中德里市民活動中心','Zhongde Civil Activity Center',12,'國際路一段與國際路一段678巷口',1,2243,'Sec. 1, Guoji Rd/Ln. 678, Sec. 1, Guoji Rd.',14,201,1,20240702104427,24.977868);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.28182,'茄明里集會所','Jiaming Activity Center',8,'中華路27號外側人行道',1,2244,'No.27, Zhonghua Rd.(opposite)',24,202,16,20240702104430,24.986389);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.29609,'向陽公園','Xiangyang Park',19,'正光路186巷50號對面人行道',1,2245,'No.50, Ln. 186, Zhengguang Rd.(opposite)',20,203,0,20240702104442,24.997013);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.279348,'國豐公園','Guofeng Park',4,'龍鳳三街65巷2號對面公園',1,2246,'No.2, Ln. 65, Longfeng 3rd St.',12,204,7,20240702104419,24.987028);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.219904,'公七公園','Gongqi Park',6,'青商路288-298斜對面公園內',1,2247,'No.288, Qingshang Rd.',8,205,2,20240702104430,25.008599);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.209494,'義興公園','Yixing Park',6,'義興街55號對面公園人行道',1,2248,'No.55, Yixing St.(opposite)',18,206,10,20240702104442,24.949106);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.261501,'上興公園','Shangxing Park',12,'上興路182號對面路側',1,2249,'No.182, Shangxing Rd.(opposite)',22,207,8,20240702104416,25.018738);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.179031,'瑞塘公有停車場','Rueytarng Parking Lot',18,'萬大路187號對面停車場',1,2250,'No.187, Wanda Rd.(opposite)',22,208,0,20240702104417,24.908548);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.249948,'至善綠園','Zhishan Greens',7,'龍昌路32號對面公園',1,2251,'No.32, Longchang Rd.(opposite)',8,209,1,20240702104426,24.940354);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Daxi Dist.','大溪區',121.276781,'仁和國小','Renhe Elementary School',11,'仁和二街50號旁人行道',1,2252,'No.50, Renhe 2nd St.(opposite)',18,210,7,20240702104425,24.897638);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.250653,'中鑄公園','Zhongzhu Park',7,'中華路一段619巷31號對面公園',1,2253,'No.31, Ln. 619, Sec. 1, Zhonghua Rd.',8,211,1,20240702104428,24.968527);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.2348423,'大潤發中壢店','RT-Mart Zhongli Store',11,'中北路二段468號南側人行道',1,2254,'No. 468, Section 2, Zhongbei Road.',12,212,1,20240702104425,24.95524533);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.082367,'富岡車站','TRA Fu Gung Station',18,'成功路58號斜對面廣場',1,2255,'No.58, Chenggong Rd.(opposite)',18,213,0,20240702104420,24.934444);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.306712,'北門國小','Bei Men Elementary School',5,'大連一街103號對面人行道',1,2256,'No.103, Aly. 825, Dalian 1st St.',6,214,1,20240702104424,25.007437);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Dayuan Dist.','大園區',121.256217,'菓林國小','Guo Lin Elementary School',2,'菓林里12鄰41號前方人行道',1,2257,'No 41, Neighborhood 12,Guolin Vil.',16,215,12,20240702104433,25.077668);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.293195,'大魯閣(中正路)','TAROKO SPORTS (Zhongzheng Rd.)',7,'中正北路2巷16號對面廣場',1,2258,'No.16, Ln. 2, Jhongjheng N. Rd.',16,216,3,20240702104445,25.030046);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.297788,'同安國小','Tong An Elementary School',6,'同德十一街33號對面人行道',1,2259,'No.33, Tongde 11th St.',8,217,1,20240702104426,25.021257);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.308003,'文昌國中','Wen Chang Junior High School',7,'民生路729號前方人行道',1,2260,'No.729, Minsheng Rd.',10,218,3,20240702104429,25.010094);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.280302,'蘆竹區聯合辦公大樓','Luzhu District Joint Office Building',5,'長安路二段與東溪路口',1,2261,'Sec. 2, Chang’an Rd./Dongxi Rd.',20,219,13,20240702104418,25.062955);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.287672,'桃園市立圖書館山腳分館','Taoyuan City Library Shanjiau Branch',13,'山外路117號旁人行道',1,2262,'No.117, Shanwai Rd.',22,220,8,20240702104451,25.08289);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.234624,'桃園市客家文化館','Taoyuan Hakka Culture Hall',10,'中正路三林段500號前方路側',1,2263,'No.500, Sec. Sanlin, Zhongzheng Rd.',20,221,2,20240702104434,24.845599);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.21176,'百年大鎮社區','Bainian Town',10,'中豐路279號前方人行道',1,2264,'No.279, Zhongfeng Rd.',18,222,2,20240702104443,24.877751);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.294279,'榮興橋','Rongxing Bridge',26,'南新段 948地號人行道',1,2265,'No.948, Neixin Section',30,223,4,20240702104419,25.040756);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Daxi Dist.','大溪區',121.284806,'十大觀光小城公園','Ten Sightseeing Town Park',23,'介壽路965號對面公園',1,2266,'No.965, Jieshou Rd.(opposite)',30,224,4,20240702104425,24.905108);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.289487,'八德興豐公園','Bade Xingfeng Park',27,'興豐路豐田路路口旁公園',1,2267,'Xingfeng Rd./Fengtian Rd.',28,225,1,20240702104425,24.930484);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.299289,'八德藝文廣場','Bade Arts Square',17,'瑞發街興豐路825巷口旁空地',1,2268,'Aly. 825, Xingfeng Rd., Bade Dist',18,226,1,20240702104437,24.933575);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.279858,'茄明公園','Jiaming Park',13,'明光街56號對面公園人行道',1,2269,'No.56, Mingguang St.(opposite)',22,227,9,20240702104437,24.98279);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.300971,'大忠停車場','Dazhong Parking Lot',27,'大忠街140號對面人行道',1,2270,'No.140, Dazhong St.(opposite)',30,228,3,20240702104425,24.958435);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.343598,'龜山中正公園','Guishan Zhongzheng Park',28,'自強北路19號對面人行道',1,2271,'No.19, Ziqiang N. Rd.(opposite)',14,229,0,20240508154114,24.999606);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.319564,'大仁里遊樂場','Daren Playground',25,'中華段 764地號',1,2272,'No.764 of Zhonghua Section',26,230,1,20240702104425,24.968349);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.249297,'萬坪公園','Wanping Park',0,'龍昌路龍川九街路口旁人行道',0,2273,'Longchang Rd./ Longchuan 9th St.',36,231,0,20230829073740,24.932823);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.236378,'龍興國中','Longxing Junior High School',7,'龍勇路100號前方人行道',1,2274,'No.100, Longyong Rd.',8,232,1,20240702104440,24.937841);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.20184,'竹風青田','TrueFull QingTian',5,'永園路一段130號前方人行道',1,2275,'No.130, Yongyuan Rd.',8,233,2,20240702104426,25.011504);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.25766,'龍安里集會所','Longan Activity Center',11,'龍江路99號前方廣場',1,2277,'No.99, Longjiang Rd.',18,234,4,20240702104427,24.93149);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.18062,'四維兒童公園','Siwei Children''s Park',18,'四維二路95號對面公園',1,2278,'No.95, Siwei 2nd Rd.',20,235,1,20240702104425,24.91279);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Xinwu Dist.','新屋區',121.105284,'新屋區公所','Civil Affairs Office of Xinwu District',0,'中山路267巷1號對面路側',0,2279,'No.1, Ln. 267, Zhongshan Rd.(opposite)',42,236,0,20240702104444,24.972532);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.286743,'國信公園','Guosin Park',9,'國信街1號對面公園',1,2280,'No.1, Guoxin St.(opposite)',18,237,7,20240702104421,24.994389);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.3008,'經國轉運站(經國路)','JingGuo Bus Station',9,'水汴頭段14地號園道內',1,2281,'No.14 of Shubiantou Section',10,238,1,20240702104436,25.02986);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.266529,'中壢仁德公園','Zhongli Rende Park',20,'崁頂路崁頂路1401巷口旁人行道',1,2282,'Ln. 1401, Kanding Rd./Kanding Rd.',22,239,2,20240702104439,24.953347);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Daxi Dist.','大溪區',121.2937846,'僑愛停車場','Qiao''ai Parking lot',28,'僑愛一街46巷11號東南側停車場',1,2283,'No. 11, Ln. 46, Qiaoaiyi St. (Southeast)',30,240,1,20240702104426,24.92191586);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.243768,'龍慈龍和三街口','Longci & Longhe 3rd st. Intersection',9,'龍慈路與龍和三街旁路側',1,2284,'Longcih Rd./Longhe 3rd St.',10,241,1,20240702104430,24.940105);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.256356,'功學社新村','Gongxueshexincun',6,'功學路156號前方空地',1,2285,'No.156, Gongxue Rd.',10,242,4,20240702104425,24.954249);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.224583,'六和兒童公園','Liuhe Children''s Park',6,'六和路55號對面公園',1,2286,'No.55, Liouhe Rd.(opposite)',6,243,0,20240702104435,24.963642);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.263396,'海湖農會','Haihu Farmers'' Association',4,'海湖東路77號旁空地',1,2287,'No.77, Haihu E. Rd.',14,244,8,20240702104415,25.101066);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.216174,'龍潭區衛生所','Public Health Center of Longtan Dist.',19,'中正路210號對面路側',1,2288,'No.210, Zhongzheng Rd.(opposite)',24,245,2,20240702104439,24.863704);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.323988,'台北榮民總醫院桃園分院','Taipei Veterans General Hospital Taoyuan Branch',29,'成功路三段三聖路口旁人行道',1,2289,'Sec. 3, Chenggong Rd./Sansheng Rd.',36,246,6,20240702104441,25.002531);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.257617,'大竹游泳池','Dazhu Swimming Pool',23,'大新一街115號旁空地',1,2290,'No.115, Daxin 1st St.',30,247,5,20240702104419,25.021193);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.089127,'富岡運動公園','Fugang Sports Park',14,'新富七街180號斜對面',1,2291,'No.180, Xinfu 7th St.(opposite)',22,248,5,20240702104431,24.93788);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.265778,'捷運坑口站(A11)','MRT Kengkou Station(A11)',36,'捷運坑口站(A11)出入口前',1,2292,'Kengkou Station Exit 1',38,249,1,20240702104442,25.086895);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.295414,'蘆竹親子公園','Luzhu Parent-child Park',17,'六福路163號對面廣場',1,2293,'No.163, Liufu Rd.',26,250,7,20240702104418,25.059);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.33042,'山頂里集會所','Shanding Activity Center',7,'明興街36號旁人行道及路側',1,2295,'No.36, Mingsing St.',8,251,0,20240702104436,24.986224);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.324152,'臻愛家社區','ZhenAiJia Community',6,'建國東路31號旁人行道',1,2296,'No.31, Jianguo E. Rd.',8,252,2,20240702104419,24.987167);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.298567,'八德區衛生所','Public Health Center of Bade District',14,'介壽路二段361巷28號前廣場',1,2297,'No.28, Ln. 361, Sec. 2, Jieshou Rd.',20,253,2,20240702104427,24.947541);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.305316,'水汴頭音樂廣場','Shuibiantou Music Square',13,'鹽庫西街70號對面空地',1,2299,'No.70, Yanku W. St.(opposite)',16,254,2,20240702104424,25.023323);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.295471,'桃智路廣豐三街口','Taozhi Rd. & Guangfeng 3rd St. Intersection',6,'桃智路31號前外側人行道及路側',1,2300,'No.31, Taozhi Rd.',8,255,2,20240702104441,24.964802);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.256339,'普忠榮民南路口','Puzhong & Rongmin S. Rd. Intersection',13,'普忠路1168號前人行道',1,2302,'Puzhong Rd./Rongmin S. Rd.',18,256,5,20240702104422,24.949502);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.253064,'龍岡停車場','Longgang Parking Lot',2,'龍東路202號機車停車場',1,2303,'No.202, Longdong Rd.',8,257,6,20240702104433,24.930088);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.218962,'平鎮市廿公園','Pingzhen No.20 Park',23,'德育路二段104號對向人行道上',1,2304,'No.104, Sec. 2, Deyu Rd.(opposite)',24,258,0,20240702104439,24.942799);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.306696,'復興三民路口','Fuxing Rd. & Sanmin Rd. Intersection',15,'復興路308號旁停車場',1,2305,'No.308, Fusing Rd.',16,259,1,20240702104426,24.989258);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.218056,'中正光明路口','Zhongzheng Rd. & Guangming Rd. Intersection',13,'中正路339號對側高架橋下',1,2306,'No.339, Jhongjheng Rd.(opposite)',18,260,3,20240702104439,24.860621);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.318555,'大安果樹公園','Da-an Guoshu Park',20,'建安街長安街口公園廣場',1,2307,'Jian’an St./ Chang’an St.',22,261,1,20240702104428,24.950006);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.274497,'中山路裕和街口','Zhongshan Rd. & Yuhe St. Intersection',5,'中山路1306號旁人行道',1,2308,'No.1306, Zhongshan Rd.',14,262,6,20240702104437,24.980741);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.235966,'莒光公園(環中東路)','Juguang Park (Huanzhong E. Rd.)',3,'環中東路二段288號前人行道',1,2309,'No.288, Sec. 2, Huanjhong E. Rd.',8,263,4,20240702104445,24.948936);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.243344,'環中東實踐路口','Huanzhong E. & Shijian Rd. Intersection',6,'環中東路776號前人行道',1,2310,'No.776, Huanjhong E. Rd.',10,264,4,20240702104419,24.953682);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.29587,'新南路一段榮興路口','Sec. 1, Sinnan Rd.& Rongsing Rd. Intersection',15,'新南路一段榮興路口旁人行道',1,2311,'Sec. 1, Xinnan Rd./Rongxing Rd.',24,265,8,20240702104419,25.041056);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.298571,'瑞泰公園','Ruitai Park',13,'介壽路2段583巷16弄12號對面空地',1,2312,'No.12, Aly. 16, Ln. 583, Sec. 2, Jieshou Rd.(opposite)',22,266,9,20240702104428,24.941473);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guanyin Dist.','觀音區',121.080987,'觀音中興停車場','Guanyin Zhongxing Parking Lot',13,'中興路與玉林路口',1,2313,'Zhongxing Rd./Yulin Rd.',20,267,3,20240702104431,25.038199);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guanyin Dist.','觀音區',121.083586,'觀音國小','Guan-Yin Elementary School',8,'文化路61號對面人行道',1,2314,'No.61, Wenhua Rd.(opposite)',22,268,12,20240702104418,25.03451);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.290432,'中路兒2公園','Zhonglu Second Children''s Park',3,'永安路765巷8號對面公園',1,2315,'No.8, Ln. 765, Yong’an Rd.(opposite)',6,269,3,20240702104427,25.007402);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.209701,'平鎮國民運動中心','Pingzhen Civil Sports Center',4,'興安路20號對面空地',1,2316,'No.20, Xing’an Rd.(opposite)',20,270,14,20240702104435,24.913957);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.21231,'新明國中','Hsin Ming Junior High School',3,'民族路109號對面人行道',1,2317,'No.109, Minzu Rd.(opposite)',10,271,5,20240702104432,24.956212);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.253549,'中華路一段文化二路口','Sec. 1, Zhonghua Rd. & Wenhua 2nd Rd. Intersection',7,'中華路一段480號前方人行道',1,2318,'No.480, Sec. 1, Zhonghua Rd.(opposite)',12,272,5,20240702104439,24.970929);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.311688,'春日路民富九街口','Chunri Rd. & Minfu 9th St. Intersection',4,'春日路618號前方人行道',1,2319,'No.168, Chunri Rd.',8,273,4,20240702104435,25.007974);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.290175,'光明國中','Guang Ming Junior High School',18,'洛陽街139號之1對面人行道',1,2320,'No.139-1, Luoyang St.(opposite)',20,274,1,20240702104430,25.044194);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.164511,'過嶺廣場','Guoling Square',4,'松勤路13號對面公園',1,2321,'No.13, Songqin Rd(opposite)',8,275,3,20240702104416,24.96035);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.301557,'藝文一街大興西路口','Yiwen 1st St. & Daxing W. Rd. Intersection',7,'藝文一街6號對面廣場',1,2322,'No.6, Yiwen 1st St.(opposite)',12,276,5,20240702104421,25.013286);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.294916,'中正莊敬路口','Jhongjheng Rd. & Zhuangjing Rd. Intersection',8,'中正路1379號前方人行道',1,2323,'No.1379, Jhongjheng Rd.',8,277,0,20240702104433,25.023593);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.231206,'桃園市立圖書館東勢分館','Taoyuan City Library Dongshi Branch',7,'金陵路五段55號前方空地',1,2324,'No.55, Sec. 5, Jinling Rd.',14,278,2,20240702104437,24.9105);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.343263,'光榮光峰路口','Guangrong Rd.& Guangfeng Rd.Intersection',7,'光峰路299號旁公園',1,2325,'No.299, Guangfeng Rd.',10,279,1,20240702104418,25.006866);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.306248,'南門公園','Nanmen Park',5,'文化街64號對面公園',1,2326,'No.64, Wunhua St.(opposite)',10,280,4,20240702104425,24.991347);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.310887,'八德埤塘自然生態公園','Bade Pond Ecological Park',14,'榮興段1483地號公園人行道',1,2328,'No.1483 of Rongxing Section',22,281,7,20240702104440,24.941091);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.171616,'頭重溪公園','Toujhongsi Park',13,'三元街99號對面公園綠地',1,2330,'No.99, Sanyuan St.(opposite)',22,282,1,20240702104429,24.911118);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guanyin Dist.','觀音區',121.138213,'觀音區棒壘球場','Baseball and Softball Field of Guanyin Dist.',16,'福興街147之1號對面停車場',1,2331,'No147-1, Fuxing Street, Guanyin District',22,283,4,20240702104429,25.044671);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.207897,'中壢公15公園','Zhongli Public 15th Park',14,'領航南路一段218號對面公園',1,2332,'No.218, Sec. 1, Linghang S. Rd.(opposite)',14,284,0,20240702104433,25.000532);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.306013,'介壽公園','Jieshou Park',5,'介壽段16地號公園',1,2333,'No.16 of Jieshou Section',8,285,3,20240702104433,24.979016);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.324855,'桃園高中','Taoyuan Senior High School',12,'成功路三段8號旁邊空地',1,2334,'No.8, Sec. 3, Chenggong Rd.',14,286,2,20240702104433,24.997204);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.228734,'新街國小','Shin Jie Elementary School',6,'環北路564號旁步道',1,2335,'No.564, Huanbei Rd.',10,287,4,20240702104434,24.964378);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.234777,'福州橋','Fuzhou Bridge',1,'福州二街513號對面步道',1,2336,'No.513, Fujhou 2nd St.(opposite)',8,288,6,20240702104439,24.968299);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.311016,'陽明運動公園(建新街)','Yangming Sports Park(Jianxin St.)',10,'建新街163號對面公園籃球場旁',1,2337,'No.163, Jiansin St.(opposite)',26,289,2,20240702104435,24.980992);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.334721,'貿商社區','Maoshang Community',16,'自強南路自強南路301巷口',1,2339,'Zihciang S. Rd./Ln.301 Zihciang S. Rd.',16,290,0,20240702104427,24.990411);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.219066,'平鎮棒球場','Baseball Field of Pingzhen Dist.',20,'德育路240號旁人行道',1,2340,'No.240, Deyu Rd.',20,291,0,20240702104415,24.946102);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Daxi Dist.','大溪區',121.26523,'大溪永昌宮','Daxi YongChang Temple',16,'仁和路二段190巷27號前方廣場',1,2341,'No.27, Ln. 190, Sec. 2, Renhe Rd.',22,292,6,20240702104420,24.904152);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.28779,'台茂購物中心','Tai Mall Shopping Center',0,'南崁路一段112號前方人行道',1,2342,'No.112, Sec. 1, Nankan Rd.',16,293,0,20240702104438,25.05246);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.215221,'高鐵桃園站(3號出口)','HSR Taoyuan Station (Exit.3)',7,'高鐵北路一段6號前人行道',1,2343,'HSR Taoyuan Station (Exit.3)',12,294,5,20240702104442,25.012423);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Daxi Dist.','大溪區',121.266547,'三元公園','Sanyuan Park',18,'員林路二段450號對面公園',1,2346,'No.450, Sec. 2, Yuanlin Rd.(opposite)',22,295,4,20240702104425,24.882799);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.302291,'同安親子公園','Tong An Parent-child Park',4,'同安街358號對面公園',1,2347,'No.358, Tong’an St.(opposite)',8,296,2,20240702104432,25.017355);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.219325,'老街溪環河步道(環北路)','Laojiexi Huanhe Trail (Huanbei Rd.)',4,'環北路92號旁公園',1,2348,'No.92, Huanbei Rd.',8,297,4,20240702104424,24.9661);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.284555,'八德區公所','Civil Affairs District of Bade District',0,'中山路40號對面人行道',0,2349,'No.40, Zhongshan Rd.(opposite)',34,298,0,20231201084737,24.929308);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.185342,'埔心停車場','Puxin Parking Lot',20,'金龍三路95號前停車場',1,2350,'No.95, Jinlong 3rd Rd.',22,299,1,20240702104419,24.912472);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.286262,'中信公園','Zhong Xin Park',7,'德華街92號對面路側',1,2352,'No.92, Dehua St.(opposite)',16,300,5,20240702104445,24.990791);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.31578,'桃園建國國小','Taoyuan Jian-Guo Elementary School',8,'昆明路120號對面人行道',1,2353,'No.120, Kunming Rd.(opposite)',10,301,0,20240702104444,24.983616);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.274198,'高城公園','Gaocheng Park',11,'高城六街48巷9號旁公園',1,2354,'No.9, Ln. 48, Gaocheng 6th St.',18,302,7,20240702104438,24.979318);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.32457,'桃園市立田徑場','Taoyuan Municipal Stadium',4,'萬壽路二段1379號對面人行道',1,2355,'No.1379, Sec. 2, Wanshou Rd.(opposite)',14,303,6,20240702104444,24.99277);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.25297,'忠孝黃昏市場','Zhongxiao Dusk Market',2,'吉利七街65號旁綠地',1,2356,'No.65, Jili 7th St.',6,304,4,20240702104440,24.982262);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.214063,'廣明停車場','Guangming Parking Lot',13,'廣明路78號旁停車場',1,2357,'No.78, Guangming Rd.',16,305,3,20240702104436,24.954579);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.220334,'高鐵北青昇二街口','Gaotie N. Rd. & Qingsheng 2nd St. Intersection',7,'高鐵北路二段96號旁公園',1,2358,'No.96, Sec. 2, Gaotie N. Rd.',8,306,1,20240702104439,25.018035);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.300758,'下埔子溪綠地(天祥七街)','Green space of Xiapuzi river(Tiansiang 7th St.)',4,'天祥七街72號旁公園',1,2360,'No.72, Tiansiang 7th St.',10,307,2,20240702104442,25.023509);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Dayuan Dist.','大園區',121.255208,'遠雄自貿港區加值園區','Farglory Free Trade Zone Value-Added Park',8,'航翔路5號前方廣場',1,2361,'No.5, Hangsiang Rd.',20,308,11,20240702104424,25.093612);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.291219,'仁愛兒童公園','Renai Children''s Park',20,'宏昌九街17號對面公園',1,2362,'No.17, Hongchang 9th St.(opposite)',26,309,5,20240702104440,24.985429);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.20138,'竹風青庭','TrueFull QingTing',4,'領航北路一段296號前方人行道',1,2363,'No.296, Sec. 1, Linghang N. Rd.',6,310,2,20240702104422,25.006039);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.20756,'青埔公10公園','Qingpu Public 10th  Park',18,'青溪段233地號上人行道',1,2365,'No.233 of Cingsi Section',22,311,1,20240702104425,25.014404);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.291143,'昭揚建築(水秀公園)','Sound Rise Construction (Shueisiou Park)',6,'力行路688巷11號旁公園',1,2366,'No.11, Ln. 688, Lising Rd.',8,312,1,20240702104443,24.99845);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.208652,'玖都機構','Jiudu Institution',13,'公園路一段文發路口(土地公廟前)',1,2368,'Sec. 1, Gongyuan Rd. & Wenfa Rd. Intersection',14,313,1,20240702104438,25.004995);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.258832,'天翔社區','Tian Xiang Station',3,'華美三路353號前人行道',1,2369,'No.353, Huamei 3rd Rd.',6,314,3,20240702104435,24.946126);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.24607,'中科院一號門','NCSIST Gate 1',42,'中科段 1124地號空地',1,2371,'No.1124 of Jhongke Section',50,315,8,20240702104436,24.847931);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Daxi Dist.','大溪區',121.256142,'中科院五號門','NCSIST Gate 5',43,'石園路615號前方空地',1,2372,'No.615, Shihyuan Rd.(opposite)',50,316,6,20240702104437,24.867174);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.23472,'中科院石園三村','NCSIST Shihyuan 3rd village',25,'武漢路100號對面停車格',1,2373,'No.100, Wuhan Rd.(opposite)',30,317,3,20240702104415,24.870971);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.241561,'中科院石園一村','NCSIST Shihyuan 1st village',43,'佳安段712地號',1,2374,'No.712 of Jia’an Section',50,318,4,20240702104423,24.836824);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.237482,'中科院石園二村','NCSIST Shihyuan 2nd village',25,'八德路1號旁停車場',1,2375,'No.1, Bade Rd.',30,319,4,20240702104437,24.831178);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.25862,'三坑自然生態公園','Sankern Natural and Ecological Park',0,'永福段1148地號',0,2376,'No.1148 of Yongfu Section',32,320,0,20230914085039,24.838888);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.186656,'治平中學','Chih Ping Senior High School',20,'福德街143號斜前方停車場',1,2377,'No.143, Fude St.',24,321,3,20240702104429,24.916161);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.293267,'桃園街堤岸','Embankment nearby Taoyuan St.',9,'桃園街9號斜前方堤岸',1,2378,'No.9, Taoyuan St.',24,322,15,20240702104426,25.042563);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.183889,'埔心火車站(前站)','TRA Puxin Station',18,'永美路210號旁廣場',1,2379,'No.210, Yongmei Rd.',18,323,0,20240702104442,24.919407);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.227558,'中壢區殯葬服務中心','Office of Funeral Services,Zhongli',13,'培英路289號前人行道',1,2380,'No.289, Peiying Rd.',16,324,3,20240702104440,24.976932);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.287254,'順興公園','ShunXing Park',7,'南順二街26號旁公園',1,2381,'No.26, Nanshun 2nd St.',16,325,9,20240702104428,25.041562);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.230631,'臺北商業大學桃園校區','Taoyuan Campus of NTUB',12,'福龍路一段100號前方綠地',1,2383,'No.100, Sec. 1, Fulong Rd.',22,326,9,20240702104417,24.902752);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.22901,'健行科技大學民設學院','College of Human Ecology and Design(UCH)',5,'衡陽街93號對面停車場',1,2385,'No.93, Hengyang St.(opposite)',12,327,6,20240702104428,24.949331);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.2191,'老街溪河岸廣場','Laojie Creek Riverside Square',3,'中美路二段192號旁廣場',1,2386,'No.192, Sec. 2, Jhongmei Rd.',8,328,4,20240702104444,24.960272);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.227002,'中壢藝術館','Zhongli Arts Hall',2,'中美路31號對面人行道',1,2387,'No.31, Zhongmei Rd. (opposite)',14,329,9,20240702104427,24.958227);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.29702,'桃園市立圖書館蘆竹分館','Luzhu Branch Taoyuan Public Library',19,'福祿五街4號對面人行道',1,2388,'No.4, Fulu 5th St. (opposite)',20,330,1,20240702104441,25.053476);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.290934,'南順七街32巷口','Ln. 32, Nanshun 7th St.',17,'南順七街35號旁人行道',1,2389,'No.35, Nanshun 7th St.',18,331,1,20240702104426,25.039407);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.31611,'復興路朝陽街口','Fuxing Rd. & Zhaoyang St. Intersection',6,'復興路51號旁停車場',1,2390,'No.51, Fusing Rd.',10,332,3,20240702104425,24.990843);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.274887,'龍園公園','Ryuen Park',3,'中山路1216巷公園旁',1,2391,'Ln. 1216, Zhongshan Rd.',8,333,5,20240702104431,24.986313);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.2940747,'八德國民運動中心','Bade Civil Sports Center',1,'廣福路218號前人行道',1,2392,'No. 218, Guangfu Rd.',18,334,13,20240702104430,24.95981416);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.2621253,'興仁市民活動中心','Xingren Civil Activity Center',14,'興仁路330之1號前廣場',1,2393,'No. 330-1, Xingren Rd.',22,335,5,20240702104425,25.01430727);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.2188854,'同心公園','Tongxin Park',8,'青埔六街/青埔三街口(東南側)',1,2394,'Qingbu 6th St./Qingbu 3rd St. intersection. (Southeast)',8,336,0,20240702104428,25.00485076);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.306878,'東埔公園','Dongbu Park',6,'正康二街/美光街口東北側',1,2395,'Zhengkang 2nd St./Meiguang St.',10,337,4,20240702104426,25.005447);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.254634,'雲南文化公園','Yunnan Culture Park',16,'龍平路251號西南側',1,2396,'No. 251, Longping Rd. (Southwest)',20,338,0,20240702104421,24.928798);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.30074,'中山長春路口','Zhongshan Rd. & Changchun Rd. Intersection',28,'中山路59號東側',1,2397,'Zhongshan E. Rd. (East)',28,339,0,20240702104433,25.052077);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.3201492,'青溪國中','Ching-Hsi Junior High School',9,'中山東路/中山東路126巷口(西南側)',1,2398,'Zhongshan E Rd./Ln. 126, Zhongshan E Rd. (Southwest)',10,340,1,20240702104426,24.99752272);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.252352,'海湖地景公園','Haihu landscape Park',15,'下海湖公車站東側空地',1,2399,'Xiahaihu bus station east side space',22,341,6,20240702104434,25.113297);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Yangmei Dist.','楊梅區',121.158658,'楊梅楊明公園','Yangmei Yangming Park',19,'中山北路一段390巷46號(南側廣場)',1,2400,'No. 46, Ln. 390, Sec. 1, Zhongshan N. Rd. (South)',20,342,0,20240702104448,24.910803);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.235105,'龍慈游泳路口','Longci Rd. & Youyong Rd. Intersection',21,'龍慈路/游泳路口東側',1,2401,'Longci Rd. & Youyong Rd. Intersection (East)',22,343,0,20240702104437,24.928243);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.2074,'新富橋','Xinfu Bridge',18,'新光路二段87巷口(新富橋西北側)',1,2402,'Ln. 87, Sec. 2, Xinguang Rd. intersection (Xinfu Bridge Northwest)',22,344,3,20240702104440,24.9319);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.3103,'大業路二段235巷口','Ln. 235, Sec. 2, Daye Rd. Intersection',16,'大業路二段252號旁',1,2403,'No. 252, Sec. 2, Daye Rd.',22,345,0,20240702104421,25.0211);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.3099,'桃園煉油廠南門綠地','CPC Nanmen Park',1,'中油煉油廠南門綠地南側(鹽務路)',1,2404,'CPC Nanmen Park (South) (Yanwu Rd.)',16,346,13,20240702104417,25.0263);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guishan Dist.','龜山區',121.3232871,'萬壽德育街口','Wanshou Rd. & Deyu St. Intersection',14,'萬壽路二段1427號東側停車場',1,2405,'No. 1427, Sec. 2, Wanshou Rd. (East)',24,347,9,20240702104441,24.992);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.3096,'勞工教育大樓','Labor Education Building',26,'民生路650號',1,2406,'No. 650, Minsheng Rd.',30,348,1,20240702104435,25.0028);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.2964609,'法治守法路口','Fazhi Rd. & Shoufa Rd. Intersection',3,'法治路4號對側',1,2408,'No. 4, Fazhi Rd. (opposite)',14,349,4,20240702104431,24.99274129);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.2946,'中路運動公園','Zhonglu Sports Park',11,'溫州一路59號對側',1,2409,'No. 59, Wenzhou 1st Rd. (opposite)',16,350,3,20240702104425,25.0043);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guanyin Dist.','觀音區',121.1231,'觀音樹林里籃球場','Guanyin Shulin Vil. Basketball Court',12,'民生路與民生路71巷口',1,2410,'Ln. 71, Minsheng Rd. & Minsheng Rd. intersection',18,351,5,20240702104441,25.0517);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.324241,'大發休閒公園','Dafa Park',18,'興豐路2182-1號',1,2412,'No. 2182-1, Xingfeng Rd.',22,352,3,20240702104439,24.952771);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Guanyin Dist.','觀音區',121.0839325,'觀音行政園區','Guanyin Executive Park',19,'觀新路52號旁',1,2413,'No. 52, Guanxin Rd.',22,353,2,20240702104443,25.02770049);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.2193014,'捷運老街溪站(A22)','MRT Laojie River Station (A22)',9,'中豐路與中央西路一段西側人行道',1,2414,'Zhongfeng Rd. & Sec.1, Zhongyang W. Rd. intersection (West)',14,354,4,20240702104434,24.95826348);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.273361,'永豐路519巷口','Ln 519, Yongfeng Rd. Intersection',22,'永豐路490號西北側',1,2415,'No. 490, Yongfeng Rd.(Northwest)',26,355,1,20240702104420,24.97420362);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Taoyuan Dist.','桃園區',121.2966636,'幸福路水岸二街口','Xingfu Rd.& Shui''an 2nd St. Intersection',7,'幸福路318號',1,2416,'No. 318, Xingfu Rd.',12,356,4,20240702104423,25.02798487);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.1904549,'安平鎮綠映公園','Anpingzhen Green Park',19,'平鎮區鎮興段1416、1419地號',1,2417,'No.1419, No.1416 of Zhenxing Section, Pingzhen Dist.',22,357,0,20240702104440,24.9059947);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Pingzhen Dist.','平鎮區',121.2529289,'平鎮第一市民活動中心','Pingzhen First Civil Activity Center',20,'貿五路26號對側',1,2418,'No. 26, Mao 5th Rd. (opposite)',22,358,2,20240702104444,24.92762715);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.3056981,'機捷路二段外社街口','Sec. 2, Jijie Rd. & Waishe St. Intersection',0,'機捷路二段與外社街口東北側人行道',0,2419,'Sec. 2, Jijie Rd. & Waishe St. Intersection (Northeast)',22,359,0,20240312092228,25.07951528);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.2164173,'良茂詠恆','LM Qingbu Station',16,'領航南路二段350~396號前',1,2420,'No. 350, Sec. 2, Linghang S. Rd.',16,360,0,20240702104433,25.00643489);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.212729,'置地廣場 桃園','Landmark Plaza Taoyuan',6,'春德路132號對側',1,2421,'No. 132, Chunde Rd. (opposite)',6,361,0,20240702104433,25.016959);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Bade Dist.','八德區',121.2809,'中大公園','Zhongda Park',6,'建德路與興豐路口',1,2422,'Jiande Rd. & Xingfeng Rd. Intersection',20,362,13,20240702104440,24.9288);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.22416,'領航南青溪路口','Linghang S Rd. & Qingxi Rd. Intersection',6,'領航南路四段與青溪路二段口(東北側)',1,2423,'Sec. 4, Linghang S Rd. & Sec. 2, Qingxi Rd. Intersection (Northeast)',10,363,3,20240702104416,25.017846);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.2234,'櫻花緻','SAKURA ARCH',11,'青溪路一段與青埔六街口東側人行道',1,2424,'Sec. 1, Qingxi Rd.&Qingpu 6th St. Intersection (East)',12,364,1,20240702104441,25.0051);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Longtan Dist.','龍潭區',121.2067164,'龍潭婦幼館','Women and Children Hall LongTan Dt.',19,'干城路19巷30號南側停車場',1,2427,'No. 30, Ln. 19, Gancheng Rd. (South)',22,365,3,20240702104444,24.86852588);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Luzhu Dist.','蘆竹區',121.2534236,'大華籃球場','Dahua Basketball Court',14,'大華街65號對側',1,2428,'No. 65, Ln. 1, Dahua St. (opposite)',20,366,5,20240702104417,25.03722802);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Zhongli Dist.','中壢區',121.2219515,'青昇公園','Qingsheng Park',10,'領航南路四段與青昇路口',1,2429,'Sec. 4, Linghang S. Rd.&Qingsheng Rd. Intersection',12,367,2,20240702104447,25.01471253);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Daxi Dist.','大溪區',121.2844996,'至善高中','Jhih Shan High School',10,'康莊路645號',1,2430,'No. 645, Kangzhuang Rd.',18,368,7,20240702104422,24.86728539);
INSERT INTO ubike(sareaen,sarea,lng,sna,snaen,bemp,ar,act,sno,aren,tot,_id,sbi,mday,lat) VALUES ('Xinwu Dist.','新屋區',121.1008929,'新屋高中','Xinwu Senior High School',29,'三民路與中興路口',1,2431,'Sanmin Rd. & Zhongxing Rd. Intersection',32,369,3,20240702104432,24.96949493);

#### 匯入CSV
CSV TO SQL線上服務: https://www.convertcsv.com/csv-to-sql.htm
> 步驟:
> 1. 將複製的csv內容貼上網頁 Step 1
> 2. 確認Step 2的First row is column names選項有打勾。
> 3. 將Step 3的Create Table/View取消勾選。
> 4. Step 4: 點擊CSV to INSERT按鈕來產生SQL語法。

#### Create ubike table

/* 建立ubike */
CREATE TABLE ubike (
  sareaen varchar(32) COMMENT '行政區英文名',
  sarea varchar(16) COMMENT '行政區中文名',
  lng decimal(10, 7) COMMENT '經度',
  sna varchar(16) COMMENT '中文站名',
  snaen varchar(128) COMMENT '英文站名',
  bemp int COMMENT '空位數量',
  ar varchar(128) COMMENT '中文地址',
  act TINYINT COMMENT '全站禁用狀態(0:禁用、1:啟用)',
  sno int COMMENT '站編號' PRIMARY KEY,
  aren varchar(256) COMMENT '英文地址',
  tot int COMMENT '場站總停車格',
  _id int COMMENT '資料編號',
  sbi int COMMENT '場站目前車輛數量',
  mday bigint COMMENT '微笑單車各場站來源資料更新時間',
  lat decimal(10, 7) COMMENT '緯度'
);

#### ubike URL

https://data.tycg.gov.tw/api/v1/rest/datastore/a1b4714b-3b75-4ff8-a8f2-cc377e4eaa0f?format=csv

#### SQL語法

/* 建立my_system資料庫 */
create database my_system;

/* 建立member資料表 */
CREATE TABLE `member` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `age` tinyint DEFAULT '0',
  `phone` varchar(16) ,
  `reg_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
);

/* 修改Table名稱 */
ALTER TABLE member RENAME TO user;

/* 新增欄位 */
ALTER table member add password varchar(32);  

/* 改變欄位順序 */
ALTER TABLE member CHANGE password password varchar(32) AFTER name;

/* 改變欄位名稱和屬性 */
ALTER TABLE member CHANGE password passwd varchar(64);

/* 改變欄位屬性 */
ALTER TABLE member MODIFY password varchar(32) NOT NULL;

/* 刪除欄位 */
ALTER TABLE member DROP password;

## 2024-07-01
#### 建立auto increment

create table member3
(id int primary key not null auto_increment, 
 name varchar(64) not null, 
 age tinyint, 
 phone varchar(16), 
 reg_date datetime
);

#### 建立Table

create table member
(id int, 
 name varchar(64), 
 age tinyint, 
 phone varchar(16), 
 reg_date datetime, 
 CONSTRAINT pk_member primary key (id)
);

#### 建立資料庫

create database aaron_test;

#### mySQL資料庫連線

import pymysql

try:
    conn = pymysql.connect(host='localhost', port=3306, user='root', password='xxxxxx')

    cursor = conn.cursor()

    cursor.execute('show databases')

    for i in cursor:
        print(i)

except Exception as e:
    print('資料庫連線失敗: ', e)