Upgrade to Pro — share decks privately, control downloads, hide ads and more …

COSCUP 17 Lightning Talk

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for Hsiao-Ting Yu Hsiao-Ting Yu
August 05, 2017
0
200

COSCUP 17 Lightning Talk

Avatar for Hsiao-Ting Yu

Hsiao-Ting Yu

August 05, 2017
Tweet

More Decks by Hsiao-Ting Yu

See All by Hsiao-Ting Yu
有人用了更頭大： OpenStreetMap 
的社群營運挑戰
Avatar for Hsiao-Ting Yu littlebtc
0
79
[COSCUP 2014] Take Back the Map to People: When OpenStreetMap Meets Taiwan Social Issues
Avatar for Hsiao-Ting Yu littlebtc
0
230
[SOTM.TW 2013] The mapping status of bus lines in Taiwan
Avatar for Hsiao-Ting Yu littlebtc
0
230
(Mobile) App and Open Source: Kamigami Client on Various Platforms
Avatar for Hsiao-Ting Yu littlebtc
0
500
Mobile Web Issues: Limitation and Experience
Avatar for Hsiao-Ting Yu littlebtc
1
290
From Rails to Node.js + Backbone: The Rewrite of TouchLimit
Avatar for Hsiao-Ting Yu littlebtc
2
210

Featured

See All Featured
Helping Users Find Their Own Way: Creating Modern Search Experiences
Avatar for Dan Newman danielanewman
31
3.1k
Being A Developer After 40
Avatar for Adrian Kosmaczewski akosma
91
590k
Chasing Engaging Ingredients in Design
Avatar for Sebastian Deterding codingconduct
0
110
AI in Enterprises - Java and Open Source to the Rescue
Avatar for ivargrimstad ivargrimstad
0
1.1k
コードの90%をAIが書く世界で何が待っているのか / What awaits us in a world where 90% of the code is written by AI
Avatar for r-kagaya rkaga
59
42k
Agile that works and the tools we love
Avatar for Rasmus Luckow-Nielsen rasmusluckow
331
21k
Have SEOs Ruined the Internet? - User Awareness of SEO in 2025
Avatar for Akash Hashmi akashhashmi
0
260
Joys of Absence: A Defence of Solitary Play
Avatar for Sebastian Deterding codingconduct
1
280
Pawsitive SEO: Lessons from My Dog (and Many Mistakes) on Thriving as a Consultant in the Age of AI
Avatar for David Carrasco davidcarrasco
0
60
Intergalactic Javascript Robots from Outer Space
Avatar for Vicent Martí tanoku
273
27k
The Organizational Zoo: Understanding Human Behavior Agility Through Metaphoric Constructive Conversations (based on the works of Arthur Shelley, Ph.D)
Avatar for Dr. Kim W Petersen kimpetersen
PRO
0
230
How People are Using Generative and Agentic AI to Supercharge Their Products, Projects, Services and Value Streams Today
Avatar for Helen Beal helenjbeal
1
100

Transcript

  1. 當資料來來了了 誰來來把它放上去 —以 OSM + 台中市⾨門牌資料為例例 Littlebtc ⼩小B Text: CC-BY-SA

    Map data: © OpenStreetMap Contributors © Taichung City Government

  2. Me • 第⼀一次 COSCUP: 2009 • 從⼩小是地圖迷 + 程式天才 •

    本業寫程式，突然愛上畫地圖 • 近年年專職是議程中睡著

  3. 提供 台中市政府

  4. None

  5. 有都市計畫圖 重劃區就IMBA啦！

  6. 1,100,788 個地址

  7. None

  8. 街道哪裡來來？

  9. 29,573 個街道叢集 熬夜*1

  10. None

  11. 嘗試各種 PostGIS ⿊黑魔法

  12. 熬夜*2

  13. 經過了了熬夜*3

  14. ⿊黑魔法的 Python CSV -> PostGIS • tl;dr: PostGIS + PgRouting

    +
 ⼀一整天嘗試當掉或卡死之後得到的魔法 • TWD97 轉 4326 • 街道作群組 unnest(ST_ClusterWithin(location, 0.001)) • pgr_PointsAsPolygon ⼤大數量量比較快 • ST_SimplifyPreserveTopology(ST_SmartConcaveHull())
 處理理其他的

  15. 後置作業 • 加上圖磚 • 放上 Google Cloud Engine • 後續改良

  16. None

  17. Finally • 圖磚跟 Task Manager 貼社團 • 祈禱有⼈人來來畫 3 months

    ago

  18. http://osmtm.exc.moe/ Facebook: OpenStreetMap台灣 有粉絲⾴頁、也有社團喔 來來幫忙畫 或著看看戲 https://github.com/OsmHackTW/taichung-street-tile/ ⾒見見證⿊黑魔法