Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
COSCUP 17 Lightning Talk
Search
Hsiao-Ting Yu
August 05, 2017
0
190
COSCUP 17 Lightning Talk
Hsiao-Ting Yu
August 05, 2017
Tweet
Share
More Decks by Hsiao-Ting Yu
See All by Hsiao-Ting Yu
有人用了更頭大: OpenStreetMap 的社群營運挑戰
littlebtc
0
75
[COSCUP 2014] Take Back the Map to People: When OpenStreetMap Meets Taiwan Social Issues
littlebtc
0
230
[SOTM.TW 2013] The mapping status of bus lines in Taiwan
littlebtc
0
220
(Mobile) App and Open Source: Kamigami Client on Various Platforms
littlebtc
0
460
Mobile Web Issues: Limitation and Experience
littlebtc
1
280
From Rails to Node.js + Backbone: The Rewrite of TouchLimit
littlebtc
2
200
Featured
See All Featured
The World Runs on Bad Software
bkeepers
PRO
71
11k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
30
2.9k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
162
15k
Designing for humans not robots
tammielis
254
25k
The MySQL Ecosystem @ GitHub 2015
samlambert
251
13k
How to train your dragon (web standard)
notwaldorf
96
6.3k
Scaling GitHub
holman
463
140k
KATA
mclloyd
32
15k
Visualization
eitanlees
148
16k
The Art of Delivering Value - GDevCon NA Keynote
reverentgeek
15
1.7k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
addyosmani
7
890
Improving Core Web Vitals using Speculation Rules API
sergeychernyshev
19
1.2k
Transcript
當資料來來了了 誰來來把它放上去 —以 OSM + 台中市⾨門牌資料為例例 Littlebtc ⼩小B Text: CC-BY-SA
Map data: © OpenStreetMap Contributors © Taichung City Government
Me • 第⼀一次 COSCUP: 2009 • 從⼩小是地圖迷 + 程式天才 •
本業寫程式,突然愛上畫地圖 • 近年年專職是議程中睡著
提供 台中市政府
None
有都市計畫圖 重劃區就IMBA啦!
1,100,788 個地址
None
街道哪裡來來?
29,573 個街道叢集 熬夜*1
None
嘗試各種 PostGIS ⿊黑魔法
熬夜*2
經過了了熬夜*3
⿊黑魔法的 Python CSV -> PostGIS • tl;dr: PostGIS + PgRouting
+ ⼀一整天嘗試當掉或卡死之後得到的魔法 • TWD97 轉 4326 • 街道作群組 unnest(ST_ClusterWithin(location, 0.001)) • pgr_PointsAsPolygon ⼤大數量量比較快 • ST_SimplifyPreserveTopology(ST_SmartConcaveHull()) 處理理其他的
後置作業 • 加上圖磚 • 放上 Google Cloud Engine • 後續改良
None
Finally • 圖磚跟 Task Manager 貼社團 • 祈禱有⼈人來來畫 3 months
ago
http://osmtm.exc.moe/ Facebook: OpenStreetMap台灣 有粉絲⾴頁、也有社團喔 來來幫忙畫 或著看看戲 https://github.com/OsmHackTW/taichung-street-tile/ ⾒見見證⿊黑魔法