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
180
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
68
[COSCUP 2014] Take Back the Map to People: When OpenStreetMap Meets Taiwan Social Issues
littlebtc
0
200
[SOTM.TW 2013] The mapping status of bus lines in Taiwan
littlebtc
0
210
(Mobile) App and Open Source: Kamigami Client on Various Platforms
littlebtc
0
390
Mobile Web Issues: Limitation and Experience
littlebtc
1
250
From Rails to Node.js + Backbone: The Rewrite of TouchLimit
littlebtc
2
190
Featured
See All Featured
Build The Right Thing And Hit Your Dates
maggiecrowley
33
2.5k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
112
50k
The Power of CSS Pseudo Elements
geoffreycrofte
74
5.4k
jQuery: Nuts, Bolts and Bling
dougneiner
62
7.6k
The Cult of Friendly URLs
andyhume
78
6.1k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
356
29k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
49
2.2k
A designer walks into a library…
pauljervisheath
205
24k
Art, The Web, and Tiny UX
lynnandtonic
298
20k
Side Projects
sachag
452
42k
Building Applications with DynamoDB
mza
92
6.1k
RailsConf 2023
tenderlove
29
960
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/ ⾒見見證⿊黑魔法